From 830e57cd708a6514af4a313cbd60e969ee463a59 Mon Sep 17 00:00:00 2001 From: Owen Leonard Date: Thu, 8 Aug 2013 16:06:14 -0400 Subject: [PATCH] [Signed off] 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 --- C4/HoldsQueue.pm | 2 +- .../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 @@