From ab5a672547f8eab121d0fe5c7142d2c4792dbd9d Mon Sep 17 00:00:00 2001 From: tipaul Date: Wed, 14 Dec 2005 15:35:40 +0000 Subject: [PATCH] removing warn + fixing a small bug, in branch selection (branchcode to be used, not issuingbranch) --- overdue.pl | 5 ++--- 1 file changed, 2 insertions(+), 3 deletions(-) diff --git a/overdue.pl b/overdue.pl index 1a3df7feb6..d16c7b5bf5 100755 --- a/overdue.pl +++ b/overdue.pl @@ -37,7 +37,6 @@ my $itemtypefilter=$input->param('itemtype'); my $borflagsfilter=$input->param('borflags'); my $branchfilter=$input->param('branch'); my $showall=$input->param('showall'); -warn "shoall :".$showall; my $theme = $input->param('theme'); # only used if allowthemeoverride is set my ($template, $loggedinuser, $cookie) @@ -138,7 +137,7 @@ $strsth.=" && (borrowers.firstname like '".$bornamefilter."%' or borrowers.surna $strsth.=" && borrowers.categorycode = '".$borcatfilter."' " if($borcatfilter) ; $strsth.=" && biblioitems.itemtype = '".$itemtypefilter."' " if($itemtypefilter) ; $strsth.=" && borrowers.flags = '".$borflagsfilter."' " if ($borflagsfilter ne " ") ; -$strsth.=" && issues.issuingbranch = '".$branchfilter."' " if($branchfilter) ; +$strsth.=" && issues.branchcode = '".$branchfilter."' " if($branchfilter) ; # my $bornamefilter=$input->param('borname'); # my $borcatfilter=$input->param('borcat'); # my $itemtypefilter=$input->param('itemtype'); @@ -151,7 +150,7 @@ if ($order eq "borrower"){ $strsth.=" order by date_due,borrower "; } my $sth=$dbh->prepare($strsth); -warn "".$strsth; +# warn "".$strsth; $sth->execute(); my @overduedata; -- 2.39.5