[Phpcompta-dev] r5061 - phpcompta/tags/rel650/include

[phpcompta-dev]

Author: danydb
Date: 2012-06-30 19:03:29 +0200 (Sat, 30 Jun 2012)
New Revision: 5061

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:58:55 UTC 
(rev 5060)
+++ phpcompta/tags/rel650/include/class_follow_up.php   2012-06-30 17:03:29 UTC 
(rev 5061)
@@ -1019,7 +1019,7 @@
          */
        function get_today()
        {
-               $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 " .
+               $sql = "select 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 
to_char(ag_remind_date,'DDMMYYYY')=to_char(now(),'DDMMYYYY') ";
@@ -1032,7 +1032,7 @@
          */
        function get_late()
        {
-               $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 " .
+               $sql = "select 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() ";



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