[Koha-patches] [PATCH] fix for bug 1204: random sort order for opac-user.pl

Jesse Weaver jesse.weaver at liblime.com
Thu Aug 21 18:52:10 CEST 2008


This makes GetPendingIssues sort the issues by due date in descending order.
---
 C4/Members.pm |    2 +-
 1 files changed, 1 insertions(+), 1 deletions(-)

diff --git a/C4/Members.pm b/C4/Members.pm
index 7df9424..48e69d3 100644
--- a/C4/Members.pm
+++ b/C4/Members.pm
@@ -1004,7 +1004,7 @@ sub GetPendingIssues {
       LEFT JOIN biblioitems ON items.biblioitemnumber=biblioitems.biblioitemnumber
     WHERE
       borrowernumber=? 
-    ORDER BY issues.issuedate"
+    ORDER BY issues.date_due DESC"
     );
     $sth->execute($borrowernumber);
     my $data = $sth->fetchall_arrayref({});
-- 
1.5.5.GIT



More information about the Koha-patches mailing list