[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Phpcompta-dev] r4773 - phpcompta/tags/rel600/include
From: |
phpcompta-dev |
Subject: |
[Phpcompta-dev] r4773 - phpcompta/tags/rel600/include |
Date: |
Fri, 17 Feb 2012 01:26:17 +0100 (CET) |
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
[Prev in Thread] |
Current Thread |
[Next in Thread] |
- [Phpcompta-dev] r4773 - phpcompta/tags/rel600/include,
phpcompta-dev <=