[Koha-cvs] koha overdue.pl [rel_2_2]
Joshua Ferraro
jmf at kados.org
Wed Feb 8 00:19:09 CET 2006
CVSROOT: /sources/koha
Module name: koha
Branch: rel_2_2
Changes by: Joshua Ferraro <kados at savannah.gnu.org> 06/02/07 23:19:09
Modified files:
. : overdue.pl
Log message:
Fixing a bug in the query
CVSWeb URLs:
http://cvs.savannah.gnu.org/viewcvs/koha/koha/overdue.pl.diff?only_with_tag=rel_2_2&tr1=1.9.2.9&tr2=1.9.2.10&r1=text&r2=text
Patches:
Index: koha/overdue.pl
diff -u koha/overdue.pl:1.9.2.9 koha/overdue.pl:1.9.2.10
--- koha/overdue.pl:1.9.2.9 Mon Feb 6 14:02:33 2006
+++ koha/overdue.pl Tue Feb 7 23:19:09 2006
@@ -1,6 +1,6 @@
#!/usr/bin/perl
-# $Id: overdue.pl,v 1.9.2.9 2006/02/06 14:02:33 hdl Exp $
+# $Id: overdue.pl,v 1.9.2.10 2006/02/07 23:19:09 kados Exp $
# Copyright 2000-2002 Katipo Communications
#
@@ -123,7 +123,7 @@
my $strsth="select date_due,concat(firstname,' ',surname) as borrower, borrowers.phone, borrowers.emailaddress,issues.itemnumber, biblio.title, biblio.author from issues, borrowers,items,biblioitems, biblio where isnull(returndate) ";
$strsth.= " && date_due<'".$todaysdate."' " unless ($showall);
-$strsth.= " && issues.borrowernumber=borrowers.borrowernumber && issues.itemnumber=items.itemnumber && biblioitems.biblioitemnumber=items.itemnumber && biblio.biblionumber=items.biblionumber ";
+$strsth.= " && issues.borrowernumber=borrowers.borrowernumber && issues.itemnumber=items.itemnumber && biblioitems.biblioitemnumber=items.biblioitemnumber && biblio.biblionumber=items.biblionumber ";
$strsth.=" && (borrowers.firstname like '".$bornamefilter."%' or borrowers.surname like '".$bornamefilter."%' or borrowers.cardnumber like '".$bornamefilter."%')" if($bornamefilter) ;
$strsth.=" && borrowers.categorycode = '".$borcatfilter."' " if($borcatfilter) ;
$strsth.=" && biblioitems.itemtype = '".$itemtypefilter."' " if($itemtypefilter) ;
More information about the Koha-cvs
mailing list