[Noalyss-commit] [noalyss] 299/323: Bug : action_late show also action for today

[Dany De Bontridder]

sparkyx pushed a commit to branch master
in repository noalyss.

commit 5ed35c23a71224c3a71a5bc0f1e8d8be951dcdf4
Author: Dany De Bontridder <address@hidden>
Date:   Mon Mar 5 22:39:46 2018 +0100

    Bug : action_late show also action for today
---
 include/class/follow_up.class.php | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/include/class/follow_up.class.php 
b/include/class/follow_up.class.php
index 91a368b..b68ae5f 100644
--- a/include/class/follow_up.class.php
+++ b/include/class/follow_up.class.php
@@ -1117,7 +1117,7 @@ class Follow_Up
         $sql="select ag_ref,ag_hour,coalesce(vw_name,'Interne') as 
vw_name,ag_id,ag_title,ag_ref, dt_value,to_char(ag_remind_date,'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 
".self::sql_security_filter($this->db,'R');
+                               and to_char(ag_remind_date,'YYMMDD') < 
to_char(now(),'YYMMDD') and ".self::sql_security_filter($this->db,'R');
         $array=$this->db->get_array($sql);
         return $array;
     }