[Phpcompta-dev] r5439 - phpcompta/trunk/include

[phpcompta-dev]

Author: danydb
Date: 2013-09-27 23:26:12 +0200 (Fri, 27 Sep 2013)
New Revision: 5439

Modified:
   phpcompta/trunk/include/class_follow_up.php
Log:
default order : last comment

Modified: phpcompta/trunk/include/class_follow_up.php
===================================================================
--- phpcompta/trunk/include/class_follow_up.php 2013-09-27 19:51:08 UTC (rev 
5438)
+++ phpcompta/trunk/include/class_follow_up.php 2013-09-27 21:26:12 UTC (rev 
5439)
@@ -698,7 +698,8 @@
                $sql = "
              select ag_id,to_char(ag_timestamp,'DD.MM.YYYY') as my_date,
                 to_char(ag_remind_date,'DD.MM.YYYY') as my_remind,
-                to_char(coalesce((select max(agc_date) from 
action_gestion_comment as agc where 
agc.ag_id=ag.ag_id),ag_timestamp),'DD.MM.YY') as last_comment,
+                to_char(coalesce((select max(agc_date) from 
action_gestion_comment as agc where 
agc.ag_id=ag.ag_id),ag_timestamp),'DD.MM.YY') as str_last_comment,
+                coalesce((select max(agc_date) from action_gestion_comment as 
agc where agc.ag_id=ag.ag_id),ag_timestamp) as last_comment,
                 f_id_dest,
                 s_value,
                 ag_title,dt_value,ag_ref, ag_priority,ag_state,
@@ -771,7 +772,7 @@
                         $checkbox->value=$row['ag_id'];
                         $r.='<td name="ag_id_td" 
style="display:none">'.$checkbox->input().'</td>';
                        $r.="<td>" . $href . smaller_date($row['my_date']) . 
'</a>' . "</td>";
-                       $r.="<td>" . $href . $row['last_comment'] . '</a>' . 
"</td>";
+                       $r.="<td>" . $href . $row['str_last_comment'] . '</a>' 
. "</td>";
                        $r.="<td>" . $href . smaller_date($row['my_remind']) . 
'</a>' . "</td>";
                        $r.="<td>" . $href . h($row['tags']). '</a>' . "</td>";
                        $r.="<td>" . $href . $row['ag_ref'] . '</a>' . "</td>";



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