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 ) %][<a href="mailto:[% overdueloo.email
%]?subject=Overdue: [% overdueloo.title |html %]">email</a>][% END %]
[% IF ( overdueloo.phone ) %]([% overdueloo.phone %])[% ELSIF (
overdueloo.mobile ) %]([% overdueloo.mobile %])[% ELSIF ( overdueloo.phonepro )
%]([% overdueloo.phonepro %])[% END %]</td>
<td>[% overdueloo.branchcode %]</td>
- <td>[% INCLUDE 'biblio-default-view.inc' biblionumber =
overdueloo.biblionumber %][% overdueloo.title |html %] [% overdueloo.subtitle
%]</a> [% IF ( overdueloo.author ) %], by [% overdueloo.author %][% END %]
+ <td>[% INCLUDE 'biblio-default-view.inc' biblionumber =
overdueloo.biblionumber %][% overdueloo.title |html %] [% overdueloo.subtitle
%]</a> [% IF ( overdueloo.author ) %], by [% overdueloo.author %][% END %][% IF
( overdueloo.serialseq ) %], [% overdueloo.serialseq %][% END %]
</td>
<td><a
href="/cgi-bin/koha/catalogue/moredetail.pl?biblionumber=[%
overdueloo.biblionumber %]&itemnumber=[% overdueloo.itemnum %]#item[%
overdueloo.itemnum %]">[% overdueloo.barcode %]</a></td>
<td>[% overdueloo.itemcallnumber %]</td>
--
1.7.4.1
_______________________________________________
Koha-patches mailing list
[email protected]
http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-patches
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/
