[Koha-patches] [PATCH] Pendingreserves didn't restrict to items, if a particular item was requested

[Chris Cormack]

It now does, and it will print the copy number to help people get the
right item.
---
 circ/pendingreserves.pl                            |    4 ++++
 .../prog/en/modules/circ/pendingreserves.tmpl      |    8 ++++++--
 2 files changed, 10 insertions(+), 2 deletions(-)

diff --git a/circ/pendingreserves.pl b/circ/pendingreserves.pl
index cf71094..5ac0701 100755
--- a/circ/pendingreserves.pl
+++ b/circ/pendingreserves.pl
@@ -141,6 +141,8 @@ if ( $run_report ) {
                     ORDER BY items.itemnumber SEPARATOR '<br/>') l_location,
             GROUP_CONCAT(DISTINCT items.itemcallnumber 
                     ORDER BY items.itemnumber SEPARATOR '<br/>') l_itemcallnumber,
+            GROUP_CONCAT(DISTINCT items.copynumber
+                    ORDER BY items.itemnumber SEPARATOR '<br/>') l_copynumber,
             items.itemnumber,
             notes,
             notificationdate,
@@ -159,6 +161,7 @@ if ( $run_report ) {
     WHERE
     reserves.found IS NULL
     $sqldatewhere
+    AND (reserves.itemnumber IS NULL OR reserves.itemnumber = items.itemnumber)
     AND items.itemnumber NOT IN (SELECT itemnumber FROM branchtransfers where datearrived IS NULL)
     AND issues.itemnumber IS NULL
     AND reserves.priority <> 0 
@@ -200,6 +203,7 @@ if ( $run_report ) {
                 holdingbranch    => $data->{l_holdingbranch},
                 branch           => $data->{l_branch},
                 itemcallnumber   => $data->{l_itemcallnumber},
+		copyno           => $data->{l_copynumber},
                 notes            => $data->{notes},
                 notificationdate => $data->{notificationdate},
                 reminderdate     => $data->{reminderdate},
diff --git a/koha-tmpl/intranet-tmpl/prog/en/modules/circ/pendingreserves.tmpl b/koha-tmpl/intranet-tmpl/prog/en/modules/circ/pendingreserves.tmpl
index 7b5ea18..d322206 100644
--- a/koha-tmpl/intranet-tmpl/prog/en/modules/circ/pendingreserves.tmpl
+++ b/koha-tmpl/intranet-tmpl/prog/en/modules/circ/pendingreserves.tmpl
@@ -72,6 +72,9 @@ $.tablesorter.addParser({
 				<a href="/cgi-bin/koha/circ/pendingreserves.pl?order=call&amp;from=<!-- TMPL_VAR NAME="from" -->&amp;to=<!-- TMPL_VAR NAME="to" -->">Sort</a>
         </th>
         <th>
+            Available Copy No
+        </th>
+        <th>
             Available Itypes
 				<a href="/cgi-bin/koha/circ/pendingreserves.pl?order=itype&amp;from=<!-- TMPL_VAR NAME="from" -->&amp;to=<!-- TMPL_VAR NAME="to" -->">Sort</a>
         </th>
@@ -131,8 +134,9 @@ $.tablesorter.addParser({
             <!-- /TMPL_IF -->
             <td><p><!-- TMPL_VAR NAME="holdingbranch" --></p></td>
             <td><p><!-- TMPL_VAR NAME="itemcallnumber" --></p></td>
-				<td><p><!-- TMPL_VAR NAME="itype" --></p></td> 
-				<td><p><!-- TMPL_VAR NAME="location" --></p></td>
+	    <td><p><!-- TMPL_VAR NAME="copyno" --></p></td>
+	    <td><p><!-- TMPL_VAR NAME="itype" --></p></td> 
+	    <td><p><!-- TMPL_VAR NAME="location" --></p></td>
             <td width="15%">
                 <p><!-- TMPL_VAR NAME="reservedate" --></p>
                 <p>in <!-- TMPL_VAR NAME="branch" --></p>
-- 
1.6.3.3