[Koha-cvs] koha/circ reserve.pl [rel_2_2]

[Chris Cormack]

CVSROOT:        /sources/koha
Module name:    koha
Branch:         rel_2_2
Changes by:     Chris Cormack <address@hidden>  06/05/11 11:31:23

Modified files:
        circ           : reserve.pl 

Log message:
        Fix for reordering by borrower name not working
        bug 1063

CVSWeb URLs:
http://cvs.savannah.gnu.org/viewcvs/koha/koha/circ/reserve.pl.diff?only_with_tag=rel_2_2&tr1=1.1.2.6&tr2=1.1.2.7&r1=text&r2=text

Patches:
Index: koha/circ/reserve.pl
diff -u koha/circ/reserve.pl:1.1.2.6 koha/circ/reserve.pl:1.1.2.7
--- koha/circ/reserve.pl:1.1.2.6        Sun Feb  5 21:59:21 2006
+++ koha/circ/reserve.pl        Thu May 11 11:31:23 2006
@@ -1,6 +1,6 @@
 #!/usr/bin/perl
 
-# $Id: reserve.pl,v 1.1.2.6 2006/02/05 21:59:21 kados Exp $
+# $Id: reserve.pl,v 1.1.2.7 2006/05/11 11:31:23 rangi Exp $
 
 # Copyright 2000-2002 Katipo Communications
 #
@@ -71,7 +71,7 @@
 
 my $dbh = C4::Context->dbh;
 my $strsth="select reservedate,reserves.borrowernumber as bornum, 
concat(firstname,' ',surname) as borrower, borrowers.phone, 
borrowers.emailaddress,reserves.biblionumber, reserves.branchcode as branch, 
items.holdingbranch, items.itemcallnumber, items.itemnumber, notes, 
notificationdate, reminderdate, priority, reserves.found, biblio.title, 
biblio.author from reserves left join items on 
items.itemnumber=reserves.itemnumber, borrowers,biblio where 
isnull(cancellationdate) && reserves.borrowernumber=borrowers.borrowernumber && 
reserves.biblionumber=biblio.biblionumber order by reservedate, borrower ";
-$strsth="select reservedate,reserves.borrowernumber as 
bornum,concat(firstname,' ',surname) as borrower, borrowers.phone, 
borrowers.emailaddress,reserves.biblionumber, reserves.branchcode as branch, 
items.holdingbranch, items.itemcallnumber, items.itemnumber, notes, 
notificationdate, reminderdate, priority, reserves.found, biblio.title, 
biblio.author from reserves left join items on  
items.itemnumber=reserves.itemnumber , borrowers,biblio where 
isnull(cancellationdate) && reserves.borrowernumber=borrowers.borrowernumber && 
reserves.biblionumber=biblio.biblionumberorder by borrower,reservedate " if 
($order eq "borrower");
+$strsth="select reservedate,reserves.borrowernumber as 
bornum,concat(firstname,' ',surname) as borrower, borrowers.phone, 
borrowers.emailaddress,reserves.biblionumber, reserves.branchcode as branch, 
items.holdingbranch, items.itemcallnumber, items.itemnumber, notes, 
notificationdate, reminderdate, priority, reserves.found, biblio.title, 
biblio.author from reserves left join items on  
items.itemnumber=reserves.itemnumber , borrowers,biblio where 
isnull(cancellationdate) && reserves.borrowernumber=borrowers.borrowernumber && 
reserves.biblionumber=biblio.biblionumber order by borrower,reservedate " if 
($order eq "borrower");
 $strsth="select reservedate,reserves.borrowernumber as 
bornum,concat(firstname,' ',surname) as borrower, borrowers.phone, 
borrowers.emailaddress,reserves.biblionumber, reserves.branchcode as branch, 
items.holdingbranch, items.itemcallnumber, items.itemnumber, notes, 
notificationdate, reminderdate, priority, reserves.found, biblio.title, 
biblio.author from reserves left join items on 
items.itemnumber=reserves.itemnumber, borrowers,biblio where 
isnull(cancellationdate) && reserves.borrowernumber=borrowers.borrowernumber && 
reserves.biblionumber=biblio.biblionumber order by biblio.title, 
priority,reservedate " if ($order eq "biblio");
 my $sth=$dbh->prepare($strsth);
 warn "".$strsth;