[Noalyss-commit] [noalyss] 16/65: order by receipt number in dashboard

[Dany De Bontridder]

sparkyx pushed a commit to branch master
in repository noalyss.

commit 8d6b911c7ba6c39a93fab650c229d15db0b3bb52
Author: Dany De Bontridder <address@hidden>
Date:   Mon Aug 31 18:27:55 2015 +0200

    order by receipt number in dashboard
---
 include/class_acc_ledger.php |    2 +-
 1 files changed, 1 insertions(+), 1 deletions(-)

diff --git a/include/class_acc_ledger.php b/include/class_acc_ledger.php
index 268b057..795568f 100644
--- a/include/class_acc_ledger.php
+++ b/include/class_acc_ledger.php
@@ -2995,7 +2995,7 @@ class Acc_Ledger extends jrn_def_sql
                        from jrn
                        join jrn_def on (jrn_def_id=jr_def_id)
                         where $filter_ledger
-                       order by jr_date desc limit $p_limit";
+                       order by jr_date desc , 
substring(jr_pj_number,'[0-9]+$')::numeric desc limit $p_limit";
                $array = $this->db->get_array($sql);
                return $array;
        }