From 2f3d5101decabbbf9c0608c3a1ab929b58788bc4 Mon Sep 17 00:00:00 2001 From: Adrien Saurat Date: Fri, 13 Jan 2012 16:45:38 +0100 Subject: [PATCH] Bug 7434: display of serialseq in overdue report If the number of a serial is stored in serial.serialseq, it will be now displayer after the author name in the overdues report. --- circ/overdue.pl | 6 +++++- .../intranet-tmpl/prog/en/modules/circ/overdue.tt | 2 +- 2 files changed, 6 insertions(+), 2 deletions(-) diff --git a/circ/overdue.pl b/circ/overdue.pl index e59961a..a894454 100755 --- a/circ/overdue.pl +++ b/circ/overdue.pl @@ -256,12 +256,15 @@ if ($noreport) { biblio.biblionumber, borrowers.branchcode, items.itemcallnumber, - items.replacementprice + items.replacementprice, + serial.serialseq FROM issues LEFT JOIN borrowers ON (issues.borrowernumber=borrowers.borrowernumber ) LEFT JOIN items ON (issues.itemnumber=items.itemnumber) LEFT JOIN biblioitems ON (biblioitems.biblioitemnumber=items.biblioitemnumber) LEFT JOIN biblio ON (biblio.biblionumber=items.biblionumber ) + LEFT JOIN serialitems ON (serialitems.itemnumber = items.itemnumber) + LEFT JOIN serial ON (serial.serialid = serialitems.serialid) WHERE 1=1 "; # placeholder, since it is possible that none of the additional # conditions will be selected by user $strsth.=" AND date_due < '" . $todaysdate . "' " unless ($showall); @@ -334,6 +337,7 @@ if ($noreport) { branchcode => $data->{branchcode}, itemcallnumber => $data->{itemcallnumber}, replacementprice => $data->{replacementprice}, + serialseq => $data->{serialseq}, patron_attr_value_loop => \@patron_attr_value_loop, }; } diff --git a/koha-tmpl/intranet-tmpl/prog/en/modules/circ/overdue.tt b/koha-tmpl/intranet-tmpl/prog/en/modules/circ/overdue.tt index e196399..78d73b6 100644 --- a/koha-tmpl/intranet-tmpl/prog/en/modules/circ/overdue.tt +++ b/koha-tmpl/intranet-tmpl/prog/en/modules/circ/overdue.tt @@ -120,7 +120,7 @@ [% IF ( overdueloo.email ) %][email][% END %] [% IF ( overdueloo.phone ) %]([% overdueloo.phone %])[% ELSIF ( overdueloo.mobile ) %]([% overdueloo.mobile %])[% ELSIF ( overdueloo.phonepro ) %]([% overdueloo.phonepro %])[% END %] [% overdueloo.branchcode %] - [% INCLUDE 'biblio-default-view.inc' biblionumber = overdueloo.biblionumber %][% overdueloo.title |html %] [% overdueloo.subtitle %] [% IF ( overdueloo.author ) %], by [% overdueloo.author %][% END %] + [% INCLUDE 'biblio-default-view.inc' biblionumber = overdueloo.biblionumber %][% overdueloo.title |html %] [% overdueloo.subtitle %] [% IF ( overdueloo.author ) %], by [% overdueloo.author %][% END %][% IF ( overdueloo.serialseq ) %], [% overdueloo.serialseq %][% END %] [% overdueloo.barcode %] [% overdueloo.itemcallnumber %] -- 1.7.4.1