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));
_______________________________________________
Phpcompta-dev mailing list
[email protected]
https://lists.nongnu.org/mailman/listinfo/phpcompta-dev
