@@ -, +, @@
---
C4/VirtualShelves.pm | 3 ++-
C4/VirtualShelves/Page.pm | 3 +++
.../prog/en/modules/virtualshelves/shelves.tt | 10 ++++++++--
.../opac-tmpl/prog/en/modules/opac-shelves.tt | 2 ++
4 files changed, 15 insertions(+), 3 deletions(-)
--- a/C4/VirtualShelves.pm
+++ a/C4/VirtualShelves.pm
@@ -264,11 +264,12 @@ sub GetShelfContents {
($sortfield) = $sth2->fetchrow_array;
}
my $query =
- " SELECT vc.biblionumber, vc.shelfnumber, vc.dateadded, itemtypes.*,
+ " SELECT DISTINCT vc.biblionumber, vc.shelfnumber, vc.dateadded, itemtypes.*,
biblio.*, biblioitems.itemtype, biblioitems.publicationyear as year, biblioitems.publishercode, biblioitems.place, biblioitems.size, biblioitems.pages
FROM virtualshelfcontents vc
JOIN biblio ON vc.biblionumber = biblio.biblionumber
LEFT JOIN biblioitems ON biblio.biblionumber = biblioitems.biblionumber
+ LEFT JOIN items ON items.biblionumber=vc.biblionumber
LEFT JOIN itemtypes ON biblioitems.itemtype = itemtypes.itemtype
WHERE vc.shelfnumber=? ";
my @params = ($shelfnumber);
--- a/C4/VirtualShelves/Page.pm
+++ a/C4/VirtualShelves/Page.pm
@@ -304,6 +304,7 @@ sub shelfpage {
viewshelf => $shelfnumber,
authorsort => $authorsort,
yearsort => $yearsort,
+ itemcallnumbersort => $sortfield eq 'itemcallnumber',
manageshelf => $manageshelf,
allowremovingitems => ShelfPossibleAction( $loggedinuser, $shelfnumber, 'delete'),
allowaddingitem => ShelfPossibleAction( $loggedinuser, $shelfnumber, 'add'),
@@ -418,6 +419,8 @@ sub shelfpage {
$shelflist->{$element}->{"authorsort"} = 'author';
} elsif ( $sortfield eq 'year' ) {
$shelflist->{$element}->{"yearsort"} = 'year';
+ } elsif ( $sortfield eq 'itemcallnumber' ) {
+ $shelflist->{$element}->{"itemcallnumbersort"} = 'itemcallnumber';
}
}
$shelflist->{$element}->{"viewcategory$category"} = 1;
--- a/koha-tmpl/intranet-tmpl/prog/en/modules/virtualshelves/shelves.tt
+++ a/koha-tmpl/intranet-tmpl/prog/en/modules/virtualshelves/shelves.tt
@@ -210,6 +210,7 @@ function placeHold () {
Title |
Author |
Date added |
+ Call number |
|
[% FOREACH itemsloo IN itemsloop %]
@@ -238,6 +239,9 @@ function placeHold () {
[% itemsloo.author %] |
[% itemsloo.dateadded %] |
+ [% FOREACH result IN itemsloo.ITEM_RESULTS %][% result.itemcallnumber %][% UNLESS loop.last %], [% END %][% END %]
+ |
+
[% UNLESS ( itemsloo.notforloan ) %]
Holds
[% END %]
@@ -299,6 +303,7 @@ function placeHold () {
[% IF ( sort_title ) %][% ELSE %][% END %]
[% IF ( sort_author ) %][% ELSE %][% END %]
[% IF ( sort_copyrightdate ) %][% ELSE %][% END %]
+ [% IF ( sort_itemcallnumber ) %][% ELSE %][% END %]
|