[Phpcompta-dev] r4142 - phpcompta/trunk/include

[phpcompta-dev]

Author: danydb
Date: 2011-05-28 04:38:03 +0200 (Sat, 28 May 2011)
New Revision: 4142

Modified:
   phpcompta/trunk/include/class_acc_account_ledger.php
Log:
Compta 8.2

Modified: phpcompta/trunk/include/class_acc_account_ledger.php
===================================================================
--- phpcompta/trunk/include/class_acc_account_ledger.php        2011-05-27 
20:09:58 UTC (rev 4141)
+++ phpcompta/trunk/include/class_acc_account_ledger.php        2011-05-28 
02:38:03 UTC (rev 4142)
@@ -127,8 +127,8 @@
        if ( $solded == 1)
          {
            $filter=str_replace('jrn_def_id','jr_def_id',$filter_sql);
-           $bal_sql="with signed_amount as 
-                                               (select case when j_debit='t' 
then j_montant else 0 end as amount_deb,
+           $bal_sql="                                          select 
sum(amount_deb) as s_deb,sum(amount_cred) as s_cred, j_poste from 
+                       (select case when j_debit='t' then j_montant else 0 end 
as amount_deb,
                                                                case when 
j_debit='f' then j_montant else 0 end as amount_cred,
                                                                j_poste 
                                                                from jrnx join 
jrn on (j_grpt = jr_grpt_id)
@@ -136,8 +136,7 @@
                                                                j_poste=$1 and
                                                                $filter and
                                                                ( 
to_date($2,'DD.MM.YYYY') <= j_date and 
-                                  to_date($3,'DD.MM.YYYY') >= j_date  ))
-                                               select sum(amount_deb) as 
s_deb,sum(amount_cred) as s_cred, j_poste from signed_amount
+                                  to_date($3,'DD.MM.YYYY') >= j_date  )) as m
                                                group by j_poste
                                                ";
            $r=$this->db->get_array($bal_sql,array($this->id,$p_from,$p_to));