[Phpcompta-dev] r5159 - phpcompta/tags/rel650/include

[phpcompta-dev]

Author: danydb
Date: 2012-12-06 21:43:22 +0100 (Thu, 06 Dec 2012)
New Revision: 5159

Modified:
   phpcompta/tags/rel650/include/class_acc_ledger.php
Log:
Bug : the history doesn't show the first_name for VEN

Modified: phpcompta/tags/rel650/include/class_acc_ledger.php
===================================================================
--- phpcompta/tags/rel650/include/class_acc_ledger.php  2012-12-06 20:42:51 UTC 
(rev 5158)
+++ phpcompta/tags/rel650/include/class_acc_ledger.php  2012-12-06 20:43:22 UTC 
(rev 5159)
@@ -2528,7 +2528,7 @@
                and f_id=(select qf_other from quant_fin where 
quant_fin.jr_id=x.jr_id))
            end as name,
           case
-            when jrn_def_type='VEB' then (select ad_value from fiche_detail 
where ad_id=32 and f_id=(select max(qs_client) from quant_sold join jrnx using 
(j_id) join jrn as e on (e.jr_grpt_id=j_grpt) where e.jr_id=x.jr_id))
+            when jrn_def_type='VEN' then (select ad_value from fiche_detail 
where ad_id=32 and f_id=(select max(qs_client) from quant_sold join jrnx using 
(j_id) join jrn as e on (e.jr_grpt_id=j_grpt) where e.jr_id=x.jr_id))
            when jrn_def_type = 'ACH' then (select ad_value from fiche_detail 
where ad_id=32 and f_id=(select max(qp_supplier) from quant_purchase join jrnx 
using (j_id) join jrn as e on (e.jr_grpt_id=j_grpt) where e.jr_id=x.jr_id))
            when jrn_def_type = 'FIN' then (select ad_value from fiche_detail 
where ad_id=32 and f_id=(select qf_other from quant_fin where 
quant_fin.jr_id=x.jr_id))
            end as first_name,



---
PhpCompta est un logiciel de comptabilité libre en ligne (full web)
Projet opensource http://www.phpcompta.eu