Author: danydb
Date: 2012-06-30 18:40:12 +0200 (Sat, 30 Jun 2012)
New Revision: 5057
Modified:
phpcompta/trunk/include/class_follow_up.php
Log:
bug follow_up::get_late
Modified: phpcompta/trunk/include/class_follow_up.php
===================================================================
--- phpcompta/trunk/include/class_follow_up.php 2012-06-30 12:39:28 UTC (rev
5056)
+++ phpcompta/trunk/include/class_follow_up.php 2012-06-30 16:40:12 UTC (rev
5057)
@@ -1035,7 +1035,7 @@
$sql = "select coalesce(vw_name,'Interne') as
vw_name,ag_id,ag_title,ag_ref, dt_value,to_char(ag_timestamp,'DD.MM.YYYY') as
ag_timestamp_fmt,ag_timestamp " .
" from action_gestion join document_type " .
" on (ag_type=dt_id) left join vw_fiche_attr on
(f_id=f_id_dest) where ag_state not in (1,4)
- and
to_char(ag_remind_date,'DDMMYYYY')<=to_char(now(),'DDMMYYYY') ";
+ and ag_remind_date > trunc (now()) ";
$array = $this->db->get_array($sql);
return $array;
}
---
PhpCompta est un logiciel de comptabilité libre en ligne (full web)
Projet opensource http://www.phpcompta.eu
_______________________________________________
Phpcompta est un logiciel libre de comptabilité en ligne
(http://www.phpcompta.eu)
Phpcompta-dev mailing list
[email protected]
https://lists.nongnu.org/mailman/listinfo/phpcompta-dev
