[Koha-patches] [PATCH] Adding copynumber to holds queue report also

[Chris Cormack]

---
 circ/view_holdsqueue.pl                            |    2 +-
 .../prog/en/modules/circ/view_holdsqueue.tmpl      |    2 ++
 2 files changed, 3 insertions(+), 1 deletions(-)

diff --git a/circ/view_holdsqueue.pl b/circ/view_holdsqueue.pl
index 668bdd1..c9d1b27 100755
--- a/circ/view_holdsqueue.pl
+++ b/circ/view_holdsqueue.pl
@@ -81,7 +81,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
+	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
                   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.tmpl b/koha-tmpl/intranet-tmpl/prog/en/modules/circ/view_holdsqueue.tmpl
index 52ddd85..99c376f 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
@@ -37,6 +37,7 @@
         <th>Title</th>
         <th>Collection</th>
         <th>Call Number</th>
+	<th>Copy Number</th>
         <th>Barcode</th>
 		<th>Patron</th>
         <th>Send To</th>
@@ -55,6 +56,7 @@
 			</td>
             <td><!-- TMPL_VAR NAME="ccode" --></td>
             <td><!-- TMPL_VAR NAME="location" --> <!-- TMPL_VAR NAME="itemcallnumber"--> <!-- TMPL_VAR NAME="enumchron" --></td>
+	    <td><!-- TMPL_VAR NAME="copynumber" --></td>
             <td>
                 <!-- TMPL_IF NAME="item_level_request" -->
                     <!-- TMPL_VAR NAME="barcode" -->
-- 
1.6.3.3