From 622dda86c31506ecd40a87603c6edc08dbd08e0a Mon Sep 17 00:00:00 2001 From: Francesca Moore Date: Wed, 15 Jan 2014 12:03:51 +1300 Subject: [PATCH] 11231 notes should be reservenotes notes have been removed as they were not displaying in the first place. 1.apply patch 2.verify that both reports work --- circ/pendingreserves.pl | 2 -- circ/reserveratios.pl | 3 +-- 2 files changed, 1 insertion(+), 4 deletions(-) diff --git a/circ/pendingreserves.pl b/circ/pendingreserves.pl index 0110deb..c34c52c 100755 --- a/circ/pendingreserves.pl +++ b/circ/pendingreserves.pl @@ -124,7 +124,6 @@ if ( $run_report ) { GROUP_CONCAT(DISTINCT items.copynumber ORDER BY items.itemnumber SEPARATOR '
') l_copynumber, items.itemnumber, - notes, notificationdate, reminderdate, max(priority) as priority, @@ -183,7 +182,6 @@ if ( $run_report ) { itemcallnumber => $data->{l_itemcallnumber}, enumchron => $data->{l_enumchron}, copyno => $data->{l_copynumber}, - notes => $data->{notes}, notificationdate=> $data->{notificationdate}, reminderdate => $data->{reminderdate}, count => $data->{icount}, diff --git a/circ/reserveratios.pl b/circ/reserveratios.pl index 55eb018..d915d01 100755 --- a/circ/reserveratios.pl +++ b/circ/reserveratios.pl @@ -99,7 +99,7 @@ my $strsth = ORDER BY items.itemnumber SEPARATOR '
') as l_location, GROUP_CONCAT(DISTINCT items.itype ORDER BY items.itemnumber SEPARATOR '
') as l_itype, - notes, + reserves.found, biblio.title, biblio.author, @@ -141,7 +141,6 @@ while ( my $data = $sth->fetchrow_hashref ) { title => $data->{title}, subtitle => $data->{subtitle}, author => $data->{author}, - notes => $data->{notes}, itemnum => $data->{itemnumber}, biblionumber => $data->{biblionumber}, holdingbranch => $data->{holdingbranch}, -- 1.7.9.5