[Koha-patches] [PATCH](bug #2987) Added support to display call numbers in overdues list

[Zhendong Yu]

Bug #2987. Added call number display in overdues list.

---
 circ/overdue.pl                                    |    5 ++++-
 .../prog/en/modules/circ/overdue.tmpl              |    2 +-
 2 files changed, 5 insertions(+), 2 deletions(-)

diff --git a/circ/overdue.pl b/circ/overdue.pl
index 7152d44..6e5a476 100755
--- a/circ/overdue.pl
+++ b/circ/overdue.pl
@@ -118,6 +118,7 @@ $template->param(borcatloop=> \@borcatloop,
 my $duedate;
 my $borrowernumber;
 my $itemnum;
+my $callnumber;
 my $data1;
 my $data2;
 my $data3;
@@ -133,7 +134,7 @@ $bornamefilter =~s/\*/\%/g;
 $bornamefilter =~s/\?/\_/g;

 my $strsth="SELECT date_due,concat(surname,' ', firstname) as borrower,
-  borrowers.phone, borrowers.email,issues.itemnumber, items.barcode,
biblio.title, biblio.author,borrowers.borrowernumber,biblio.biblionumber,borrowers.branchcode
+  borrowers.phone, borrowers.email,issues.itemnumber, items.barcode,
items.itemcallnumber, biblio.title,
biblio.author,borrowers.borrowernumber,biblio.biblionumber,borrowers.branchcode
   FROM issues
 LEFT JOIN borrowers ON (issues.borrowernumber=borrowers.borrowernumber )
 LEFT JOIN items ON (issues.itemnumber=items.itemnumber)
@@ -180,6 +181,7 @@ while (my $data=$sth->fetchrow_hashref) {

   $title=$data->{'title'};
   $author=$data->{'author'};
+  $callnumber=$data->{'itemcallnumber'};
   push (@overduedata, {
                         duedate        => $duedate,
                         borrowernumber => $data->{borrowernumber},
@@ -189,6 +191,7 @@ while (my $data=$sth->fetchrow_hashref) {
                         phone          => $phone,
                         email          => $email,
                         biblionumber   => $data->{'biblionumber'},
+                        callnumber     => $callnumber,
                         title          => $title,
                         author         => $author,
                         branchcode     => $data->{'branchcode'} });
diff --git a/koha-tmpl/intranet-tmpl/prog/en/modules/circ/overdue.tmpl
b/koha-tmpl/intranet-tmpl/prog/en/modules/circ/overdue.tmpl
index 1d10537..053d363 100644
--- a/koha-tmpl/intranet-tmpl/prog/en/modules/circ/overdue.tmpl
+++ b/koha-tmpl/intranet-tmpl/prog/en/modules/circ/overdue.tmpl
@@ -40,7 +40,7 @@
 <!-- TMPL_ELSIF NAME="BiblioDefaultViewisbd" -->
 <a href="/cgi-bin/koha/catalogue/ISBDdetail.pl?biblionumber=<!--
TMPL_VAR NAME="biblionumber" ESCAPE="URL" -->"><!-- TMPL_VAR
NAME="title" escape="html" --></a>
 <!-- TMPL_ELSE -->
-<a href="/cgi-bin/koha/catalogue/detail.pl?biblionumber=<!-- TMPL_VAR
NAME="biblionumber" ESCAPE="URL" -->"><!-- TMPL_VAR NAME="title"
escape="html" -->  <!-- TMPL_VAR NAME="subtitle" --></a><!-- /TMPL_IF
--> <!-- TMPL_IF NAME="author" -->, by <!-- TMPL_VAR NAME="author"
--><!-- /TMPL_IF -->
+<a href="/cgi-bin/koha/catalogue/detail.pl?biblionumber=<!-- TMPL_VAR
NAME="biblionumber" ESCAPE="URL" -->"><!-- TMPL_VAR NAME="title"
escape="html" -->  <!-- TMPL_VAR NAME="subtitle" --></a><!-- /TMPL_IF
--> <!-- TMPL_IF NAME="author" -->, by <!-- TMPL_VAR NAME="author"
--><!-- /TMPL_IF --> <!-- TMPL_IF NAME="author" --> Call number: <!--
TMPL_VAR NAME="callnumber" --> <!-- /TMPL_IF -->
         </td>
     </tr>
 <!-- /TMPL_LOOP --></tbody>
--
1.5.6.5