[Phpcompta-dev] r5098 - in phpcompta/tags/rel650/include: . template

[phpcompta-dev]

Author: danydb
Date: 2012-09-04 19:55:56 +0200 (Tue, 04 Sep 2012)
New Revision: 5098

Modified:
   phpcompta/tags/rel650/include/class_follow_up.php
   phpcompta/tags/rel650/include/template/dashboard.php
Log:
ajout ag_ref dans action aujourd'hui et action en retard

Modified: phpcompta/tags/rel650/include/class_follow_up.php
===================================================================
--- phpcompta/tags/rel650/include/class_follow_up.php   2012-08-24 20:27:20 UTC 
(rev 5097)
+++ phpcompta/tags/rel650/include/class_follow_up.php   2012-09-04 17:55:56 UTC 
(rev 5098)
@@ -1035,7 +1035,7 @@
          */
        function get_today()
        {
-               $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 " .
+               $sql = "select ag_ref,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') ";
@@ -1048,7 +1048,7 @@
          */
        function get_late()
        {
-               $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 " .
+               $sql = "select ag_ref,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() ";

Modified: phpcompta/tags/rel650/include/template/dashboard.php
===================================================================
--- phpcompta/tags/rel650/include/template/dashboard.php        2012-08-24 
20:27:20 UTC (rev 5097)
+++ phpcompta/tags/rel650/include/template/dashboard.php        2012-09-04 
17:55:56 UTC (rev 5098)
@@ -68,6 +68,9 @@
        for($i=0;$i<count($last_operation);$i++):
        ?>
        <li>
+               <span>
+                       <?=h($last_operation[$i]['ag_ref'])?>
+               </span>
        <span>
        <?=smaller_date($last_operation[$i]['ag_timestamp_fmt'])?>
        </span>
@@ -75,7 +78,7 @@
                        <?=h($last_operation[$i]['vw_name'])?>
                </span>
        <span>
-       <?=h(mb_substr($last_operation[$i]['ag_title'],0,60,'UTF-8'))?>
+       <?=h(mb_substr($last_operation[$i]['ag_title'],0,50,'UTF-8'))?>
        </span>
        <span style="font-style: italic">
        <?=$last_operation[$i]['dt_value']?>
@@ -95,6 +98,9 @@
        for($i=0;$i<count($late_operation);$i++):
        ?>
        <li>
+               <span>
+                       <?=h($late_operation[$i]['ag_ref'])?>
+               </span>
        <span>
        <?=smaller_date($late_operation[$i]['ag_timestamp_fmt'])?>
        </span>
@@ -102,7 +108,7 @@
                        <?=h($late_operation[$i]['vw_name'])?>
                </span>
        <span>
-       <?=h(mb_substr($late_operation[$i]['ag_title'],0,60,'UTF-8'))?>
+       <?=h(mb_substr($late_operation[$i]['ag_title'],0,50,'UTF-8'))?>
        </span>
        <span style="font-style: italic">
        <?=$late_operation[$i]['dt_value']?>



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