Author: danydb
Date: 2012-06-30 18:58:55 +0200 (Sat, 30 Jun 2012)
New Revision: 5060
Modified:
phpcompta/tags/rel650/include/class_follow_up.php
Log:
bug follow_up::get_late
Modified: phpcompta/tags/rel650/include/class_follow_up.php
===================================================================
--- phpcompta/tags/rel650/include/class_follow_up.php 2012-06-30 16:57:18 UTC
(rev 5059)
+++ phpcompta/tags/rel650/include/class_follow_up.php 2012-06-30 16:58:55 UTC
(rev 5060)
@@ -1022,7 +1022,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 ag_remind_date > now() ";
+ and
to_char(ag_remind_date,'DDMMYYYY')=to_char(now(),'DDMMYYYY') ";
$array = $this->db->get_array($sql);
return $array;
}
@@ -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 ag_remind_date > trunc (now()) ";
+ and ag_remind_date > 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
