From c13abc8f78e365ae3ea46709bc138f2d8aaae177 Mon Sep 17 00:00:00 2001 From: Owen Leonard Date: Fri, 20 Feb 2009 10:59:28 -0600 Subject: [PATCH] Adding additional information and consolidating display of information in holds queue report Signed-off-by: Galen Charlton --- circ/view_holdsqueue.pl | 3 +- .../prog/en/modules/circ/view_holdsqueue.tmpl | 39 ++++++------------- 2 files changed, 14 insertions(+), 28 deletions(-) diff --git a/circ/view_holdsqueue.pl b/circ/view_holdsqueue.pl index 63f2e24116..920f852a05 100755 --- a/circ/view_holdsqueue.pl +++ b/circ/view_holdsqueue.pl @@ -95,9 +95,10 @@ sub GetHoldsQueueItems { my $dbh = C4::Context->dbh; my @bind_params = (); - my $query = q/SELECT tmp_holdsqueue.*, biblio.author, items.ccode, items.location, items.enumchron, items.cn_sort + my $query = q/SELECT tmp_holdsqueue.*, biblio.author, items.ccode, items.location, items.enumchron, items.cn_sort, biblioitems.publishercode,biblio.copyrightdate,biblioitems.publicationyear,biblioitems.pages,biblioitems.size,biblioitems.publicationyear,biblioitems.isbn FROM tmp_holdsqueue JOIN biblio USING (biblionumber) + LEFT JOIN biblioitems USING (biblionumber) LEFT JOIN items USING (itemnumber) /; if ($branchlimit) { diff --git a/koha-tmpl/intranet-tmpl/prog/en/modules/circ/view_holdsqueue.tmpl b/koha-tmpl/intranet-tmpl/prog/en/modules/circ/view_holdsqueue.tmpl index ff25fdf0be..ebd04a6b41 100644 --- a/koha-tmpl/intranet-tmpl/prog/en/modules/circ/view_holdsqueue.tmpl +++ b/koha-tmpl/intranet-tmpl/prog/en/modules/circ/view_holdsqueue.tmpl @@ -1,25 +1,7 @@ Koha › Circulation › Holds Queue - - + @@ -50,23 +32,26 @@ Title - Author Collection - Shelving Location Call Number Barcode - Enumeration + Patron Send To Date - "> - +

">

+

+ + , + , + : + ISBN:

+ - - + @@ -74,7 +59,7 @@ Any available copy - +

#reserves">, ()

-- 2.39.5