From a32b414192ab336404c0b9e1422bb7e83e25e66d Mon Sep 17 00:00:00 2001 From: Owen Leonard Date: Thu, 8 Aug 2013 16:06:14 -0400 Subject: [PATCH] Bug 5825 - Add Item Type column to Holds Queue report The hold queue report shows collection code but not item type. This patch adds it. Also added is use of the KohaAuthorisedValues template plugin to display the collection code description instead of code. To test, apply the patch and view the holds queue. There should be a new item type column showing an item type description for each row. The collection column should now show the collection description instead of code. Signed-off-by: Melia Meggs Signed-off-by: Jonathan Druart --- C4/HoldsQueue.pm | 2 +- .../intranet-tmpl/prog/en/modules/circ/view_holdsqueue.tt | 8 ++++++-- 2 files changed, 7 insertions(+), 3 deletions(-) diff --git a/C4/HoldsQueue.pm b/C4/HoldsQueue.pm index 2052f09..1242fc5 100755 --- a/C4/HoldsQueue.pm +++ b/C4/HoldsQueue.pm @@ -119,7 +119,7 @@ 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, biblioitems.publishercode,biblio.copyrightdate,biblioitems.publicationyear,biblioitems.pages,biblioitems.size,biblioitems.publicationyear,biblioitems.isbn,items.copynumber + my $query = q/SELECT tmp_holdsqueue.*, biblio.author, items.ccode, items.itype, items.location, items.enumchron, items.cn_sort, biblioitems.publishercode,biblio.copyrightdate,biblioitems.publicationyear,biblioitems.pages,biblioitems.size,biblioitems.publicationyear,biblioitems.isbn,items.copynumber FROM tmp_holdsqueue JOIN biblio USING (biblionumber) LEFT JOIN biblioitems USING (biblionumber) diff --git a/koha-tmpl/intranet-tmpl/prog/en/modules/circ/view_holdsqueue.tt b/koha-tmpl/intranet-tmpl/prog/en/modules/circ/view_holdsqueue.tt index 4c5f8d1..3482de6 100644 --- a/koha-tmpl/intranet-tmpl/prog/en/modules/circ/view_holdsqueue.tt +++ b/koha-tmpl/intranet-tmpl/prog/en/modules/circ/view_holdsqueue.tt @@ -1,3 +1,5 @@ +[% USE ItemTypes %] +[% USE KohaAuthorisedValues %] [% INCLUDE 'doc-head-open.inc' %] Koha › Circulation › Holds queue [% INCLUDE 'doc-head-close.inc' %] @@ -13,7 +15,7 @@