[Phpcompta-dev] r4773 - phpcompta/tags/rel600/include

[phpcompta-dev]

Author: danydb
Date: 2012-02-17 01:26:16 +0100 (Fri, 17 Feb 2012)
New Revision: 4773

Modified:
   phpcompta/tags/rel600/include/class_anc_grandlivre.php
Log:
ANC : great ledger oa_date problem (order by clause)

Modified: phpcompta/tags/rel600/include/class_anc_grandlivre.php
===================================================================
--- phpcompta/tags/rel600/include/class_anc_grandlivre.php      2012-02-17 
00:16:34 UTC (rev 4772)
+++ phpcompta/tags/rel600/include/class_anc_grandlivre.php      2012-02-17 
00:26:16 UTC (rev 4773)
@@ -79,7 +79,7 @@
        left join jrnx using (j_id)
        left join jrn on  (j_grpt=jr_grpt_id)
              where $pa_id_cond oa_amount <> 0.0  $cond_poste  $filter_date
-       order by po_name,to_date(oa_date,'DD.MM.YYYY') ,qcode,j_poste");
+       order by po_name,oa_date::date,qcode,j_poste");
 
         return $array;
     }
@@ -108,7 +108,7 @@
        left join jrnx using (j_id)
        left join jrn on  (j_grpt=jr_grpt_id)
              where $pa_id_cond oa_amount <> 0.0  $cond_poste $filter_date
-       order by po_name,to_date(oa_date,'DD.MM.YYYY') ,qcode,j_poste");
+       order by po_name,oa_date::date,qcode,j_poste");
 
 
         return $array;



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