[Phpcompta-dev] r515 - tag/rel660/tools/include

[phpcompta-dev]

Author: danydb
Date: 2013-06-09 19:39:21 +0200 (Sun, 09 Jun 2013)
New Revision: 515

Modified:
   tag/rel660/tools/include/operation.inc.php
   tag/rel660/tools/include/tool_function.php
Log:
bug #0000855: Ordre des pi?\195?\168ces justificatives

Modified: tag/rel660/tools/include/operation.inc.php
===================================================================
--- tag/rel660/tools/include/operation.inc.php  2013-05-28 19:25:01 UTC (rev 
514)
+++ tag/rel660/tools/include/operation.inc.php  2013-06-09 17:39:21 UTC (rev 
515)
@@ -55,7 +55,7 @@
     list($sql,$where)=$ledger->build_search_sql($array);
 
     // order
-    $sql.=' order by jr_date_order 
asc,substring(jr_pj_number,\'\\\d+$\')::numeric asc  ';
+    $sql.=' order by jr_date_order 
asc,substring(jr_pj_number,\'[0-9]+$\')::numeric asc  ';
 
     // Count nb of line
     $max_line=$cn->count_sql($sql);

Modified: tag/rel660/tools/include/tool_function.php
===================================================================
--- tag/rel660/tools/include/tool_function.php  2013-05-28 19:25:01 UTC (rev 
514)
+++ tag/rel660/tools/include/tool_function.php  2013-06-09 17:39:21 UTC (rev 
515)
@@ -377,7 +377,7 @@
        where
        jr_def_id=$1 and jr_date >= to_date($2,'DD.MM.YYYY')
        and jr_date <= to_date($3,'DD.MM.YYYY')
-        order by jr_date asc,substring(jr_pj_number,'\\\\d+$')::numeric asc
+        order by jr_date asc,substring(jr_pj_number,'[0-9]+$')::numeric asc
        ";
   
$ret=$cn->exec_sql($sql,array($_GET['ledger'],$_GET['dstart'],$_GET['dend']));
   $nb_row=Database::num_row($ret);



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