[Phpcompta-dev] r5493 - in phpcompta/trunk/include: . template

[phpcompta-dev]

Author: danydb
Date: 2013-10-14 20:36:57 +0200 (Mon, 14 Oct 2013)
New Revision: 5493

Modified:
   phpcompta/trunk/include/class_todo_list.php
   phpcompta/trunk/include/template/dashboard.php
Log:
task #0000899: Dans la todo list : tri

Modified: phpcompta/trunk/include/class_todo_list.php
===================================================================
--- phpcompta/trunk/include/class_todo_list.php 2013-10-12 20:23:33 UTC (rev 
5492)
+++ phpcompta/trunk/include/class_todo_list.php 2013-10-14 18:36:57 UTC (rev 
5493)
@@ -184,7 +184,7 @@
      */
     public function load_all()
     {
-        $sql="select tl_id, tl_title,tl_desc,to_char( tl_date,'DD.MM.YYYY') as 
str_tl_date
+        $sql="select tl_id, tl_title,tl_desc,to_char( tl_date,'DD.MM.YYYY') as 
str_tl_date,tl_date
              from todo_list where use_login=$1".
              " order by tl_date::date asc";
         $res=$this->cn->exec_sql(

Modified: phpcompta/trunk/include/template/dashboard.php
===================================================================
--- phpcompta/trunk/include/template/dashboard.php      2013-10-12 20:23:33 UTC 
(rev 5492)
+++ phpcompta/trunk/include/template/dashboard.php      2013-10-14 18:36:57 UTC 
(rev 5493)
@@ -121,7 +121,8 @@
 <?php
 echo HtmlInput::button('add',_('Ajout'),'onClick="add_todo()"');
 if ( ! empty ($array) )  {
-  echo '<table id="table_todo" width="100%">';
+  echo '<table id="table_todo" class="sortable" width="100%">';
+  echo '<tr><th class=" sorttable_sorted_reverse">Date <span 
id="sorttable_sortrevind">&nbsp;&blacktriangle;</span></th><th>Titre</th><th></th>';
   $nb=0;
   $today=date('d.m.Y');
 
@@ -130,7 +131,7 @@
     if ( strcmp($today,$row['str_tl_date'])==0) { $odd.=' 
style="background-color:#FFEA00"';}
     $nb++;
     echo '<tr id="tr'.$row['tl_id'].'" '.$odd.'>'.
-      '<td>'.
+      '<td sorttable_customkey="'.$row['tl_date'].'>">'.
       $row['str_tl_date'].
       '</td>'.
       '<td>'.



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