3 # Copyright 2015 Koha Team
5 # This file is part of Koha.
7 # Koha is free software; you can redistribute it and/or modify it
8 # under the terms of the GNU General Public License as published by
9 # the Free Software Foundation; either version 3 of the License, or
10 # (at your option) any later version.
12 # Koha is distributed in the hope that it will be useful, but
13 # WITHOUT ANY WARRANTY; without even the implied warranty of
14 # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
15 # GNU General Public License for more details.
17 # You should have received a copy of the GNU General Public License
18 # along with Koha; if not, see <http://www.gnu.org/licenses>.
22 use C4::Auth qw( get_template_and_user haspermission );
23 use C4::Biblio qw( GetMarcBiblio );
24 use C4::Circulation qw( barcodedecode );
29 GetNormalizedOCLCNumber
32 use C4::Items qw( GetItemsLocationInfo );
34 use C4::Output qw( pagination_bar output_html_with_http_headers );
35 use C4::XSLT qw( XSLTParse4Display );
38 use Koha::Biblioitems;
41 use Koha::CsvProfiles;
43 use Koha::Virtualshelves;
45 use constant ANYONE => 2;
46 use constant STAFF => 3;
50 my ( $template, $loggedinuser, $cookie ) = get_template_and_user(
51 { template_name => "virtualshelves/shelves.tt",
54 flagsrequired => { catalogue => 1 },
58 my $op = $query->param('op') || 'list';
59 my $referer = $query->param('referer') || $op;
60 my $public = $query->param('public') ? 1 : 0;
61 my ( $shelf, $shelfnumber, @messages, $allow_transfer );
63 if ( $op eq 'add_form' ) {
65 $shelf = { allow_change_from_owner => 1 };
66 } elsif ( $op eq 'edit_form' ) {
67 $shelfnumber = $query->param('shelfnumber');
68 $shelf = Koha::Virtualshelves->find($shelfnumber);
71 $public = $shelf->public;
72 my $patron = Koha::Patrons->find( $shelf->owner )->unblessed;
73 $template->param( owner => $patron, );
74 unless ( $shelf->can_be_managed( $loggedinuser ) ) {
75 push @messages, { type => 'alert', code => 'unauthorized_on_update' };
79 push @messages, { type => 'alert', code => 'does_not_exist' };
81 } elsif ( $op eq 'add' ) {
82 my $allow_changes_from = $query->param('allow_changes_from');
84 $shelf = Koha::Virtualshelf->new(
85 { shelfname => scalar $query->param('shelfname'),
86 sortfield => scalar $query->param('sortfield'),
88 allow_change_from_owner => $allow_changes_from > 0,
89 allow_change_from_others => $allow_changes_from == ANYONE,
90 allow_change_from_staff => $allow_changes_from == STAFF,
91 owner => scalar $query->param('owner'),
95 $shelfnumber = $shelf->shelfnumber;
98 push @messages, { type => 'alert', code => ref($@), msg => $@ };
99 } elsif ( not $shelf ) {
100 push @messages, { type => 'alert', code => 'error_on_insert' };
103 push @messages, { type => 'message', code => 'success_on_insert' };
106 } elsif ( $op eq 'edit' ) {
107 $shelfnumber = $query->param('shelfnumber');
108 $shelf = Koha::Virtualshelves->find($shelfnumber);
112 my $sortfield = $query->param('sortfield');
113 $sortfield = 'title' unless grep { $_ eq $sortfield } qw( title author copyrightdate itemcallnumber dateadded );
114 if ( $shelf->can_be_managed( $loggedinuser ) ) {
115 $shelf->shelfname( scalar $query->param('shelfname') );
116 $shelf->sortfield( $sortfield );
117 my $allow_changes_from = $query->param('allow_changes_from');
118 $shelf->allow_change_from_owner( $allow_changes_from > 0 );
119 $shelf->allow_change_from_others( $allow_changes_from == ANYONE );
120 $shelf->allow_change_from_staff( $allow_changes_from == STAFF );
121 $shelf->public( scalar $query->param('public') );
122 eval { $shelf->store };
125 push @messages, { type => 'alert', code => 'error_on_update' };
128 push @messages, { type => 'message', code => 'success_on_update' };
131 push @messages, { type => 'alert', code => 'unauthorized_on_update' };
134 push @messages, { type => 'alert', code => 'does_not_exist' };
136 } elsif ( $op eq 'delete' ) {
137 $shelfnumber = $query->param('shelfnumber');
138 $shelf = Koha::Virtualshelves->find($shelfnumber);
140 if ( $shelf->can_be_deleted( $loggedinuser ) ) {
141 eval { $shelf->delete; };
143 push @messages, { type => 'alert', code => ref($@), msg => $@ };
145 push @messages, { type => 'message', code => 'success_on_delete' };
148 push @messages, { type => 'alert', code => 'unauthorized_on_delete' };
151 push @messages, { type => 'alert', code => 'does_not_exist' };
154 } elsif ( $op eq 'add_biblio' ) {
155 $shelfnumber = $query->param('shelfnumber');
156 $shelf = Koha::Virtualshelves->find($shelfnumber);
158 if( my $barcodes = $query->param('barcodes') ) {
159 if ( $shelf->can_biblios_be_added( $loggedinuser ) ) {
160 my @barcodes = split /\n/, $barcodes; # Entries are effectively passed in as a <cr> separated list
161 foreach my $barcode (@barcodes){
162 $barcode = barcodedecode( $barcode ) if $barcode;
163 next if $barcode eq '';
164 my $item = Koha::Items->find({barcode => $barcode});
166 my $added = eval { $shelf->add_biblio( $item->biblionumber, $loggedinuser ); };
168 push @messages, { item_barcode => $barcode, type => 'alert', code => ref($@), msg => $@ };
170 push @messages, { item_barcode => $barcode, type => 'message', code => 'success_on_add_biblio' };
172 push @messages, { item_barcode => $barcode, type => 'message', code => 'error_on_add_biblio' };
175 push @messages, { item_barcode => $barcode, type => 'alert', code => 'item_does_not_exist' };
179 push @messages, { type => 'alert', code => 'unauthorized_on_add_biblio' };
182 if ( my $biblionumbers = $query->param('biblionumbers') ) {
183 if ( $shelf->can_biblios_be_added( $loggedinuser ) ) {
184 my @biblionumbers = split /\n/, $biblionumbers;
185 foreach my $biblionumber (@biblionumbers) {
186 $biblionumber =~ s/\r$//; # strip any naughty return chars
187 next if $biblionumber eq '';
188 my $biblio = Koha::Biblios->find($biblionumber);
189 if (defined $biblio) {
190 my $added = eval { $shelf->add_biblio( $biblionumber, $loggedinuser ); };
192 push @messages, { bibnum => $biblionumber, type => 'alert', code => ref($@), msg => $@ };
194 push @messages, { bibnum => $biblionumber, type => 'message', code => 'success_on_add_biblio' };
196 push @messages, { bibnum => $biblionumber, type => 'message', code => 'error_on_add_biblio' };
199 push @messages, { bibnum => $biblionumber, type => 'alert', code => 'item_does_not_exist' };
203 push @messages, { type => 'alert', code => 'unauthorized_on_add_biblio' };
207 push @messages, { type => 'alert', code => 'does_not_exist' };
210 } elsif ( $op eq 'remove_biblios' ) {
211 $shelfnumber = $query->param('shelfnumber');
212 $shelf = Koha::Virtualshelves->find($shelfnumber);
213 my @biblionumbers = $query->multi_param('biblionumber');
215 if ( $shelf->can_biblios_be_removed( $loggedinuser ) ) {
216 my $number_of_biblios_removed = eval {
217 $shelf->remove_biblios(
219 biblionumbers => \@biblionumbers,
220 borrowernumber => $loggedinuser,
225 push @messages, { type => 'alert', code => ref($@), msg => $@ };
226 } elsif ( $number_of_biblios_removed ) {
227 push @messages, { type => 'message', code => 'success_on_remove_biblios' };
229 push @messages, { type => 'alert', code => 'no_biblio_removed' };
232 push @messages, { type => 'alert', code => 'unauthorized_on_remove_biblios' };
235 push @messages, { type => 'alert', code => 'does_not_exist' };
238 } elsif ( $op eq 'transfer' ) {
239 $shelfnumber = $query->param('shelfnumber');
240 $shelf = Koha::Virtualshelves->find($shelfnumber) if $shelfnumber;
241 my $new_owner = $query->param('new_owner'); # is a borrowernumber
245 # First check: shelf found, permission, patron found?
247 push @messages, { type => 'alert', code => 'does_not_exist' };
248 } elsif( !haspermission(C4::Context->userenv->{id}, { lists => 'edit_public_lists' }) ) {
249 push @messages, { type => 'alert', code => 'unauthorized_transfer' };
250 } elsif( !Koha::Patrons->find($new_owner) ) {
251 push @messages, { type => 'alert', code => 'new_owner_not_found' };
252 $op = 'transfer'; # find again..
254 $shelf->owner($new_owner)->store;
259 if ( $op eq 'view' ) {
260 $shelfnumber ||= $query->param('shelfnumber');
261 $shelf = Koha::Virtualshelves->find($shelfnumber);
263 if ( $shelf->can_be_viewed( $loggedinuser ) ) {
264 my $sortfield = $query->param('sortfield') || $shelf->sortfield || 'title'; # Passed in sorting overrides default sorting
265 $sortfield = 'title' unless grep { $_ eq $sortfield } qw( title author copyrightdate itemcallnumber dateadded );
266 my $direction = $query->param('direction') || 'asc';
267 $direction = 'asc' if $direction ne 'asc' and $direction ne 'desc';
269 unless ( $query->param('print') ) {
270 $rows = C4::Context->preference('numSearchResults') || 20;
271 $page = ( $query->param('page') ? $query->param('page') : 1 );
274 my $order_by = $sortfield eq 'itemcallnumber' ? 'items.cn_sort' : $sortfield;
275 my $contents = $shelf->get_contents->search(
278 prefetch => [ { 'biblionumber' => { 'biblioitems' => 'items' } } ],
281 order_by => { "-$direction" => $order_by },
286 while ( my $content = $contents->next ) {
288 my $biblionumber = $content->biblionumber;
289 my $record = GetMarcBiblio({ biblionumber => $biblionumber });
291 $this_item->{XSLTBloc} = XSLTParse4Display(
293 biblionumber => $biblionumber,
295 xsl_syspref => 'XSLTListsDisplay',
300 my $marcflavour = C4::Context->preference("marcflavour");
301 my $itemtype = Koha::Biblioitems->search({ biblionumber => $content->biblionumber })->next->itemtype;
302 $itemtype = Koha::ItemTypes->find( $itemtype );
303 my $biblio = Koha::Biblios->find( $content->biblionumber );
304 $this_item->{title} = $biblio->title;
305 $this_item->{subtitle} = $biblio->subtitle;
306 $this_item->{medium} = $biblio->medium;
307 $this_item->{part_number} = $biblio->part_number;
308 $this_item->{part_name} = $biblio->part_name;
309 $this_item->{author} = $biblio->author;
310 $this_item->{dateadded} = $content->dateadded;
311 $this_item->{imageurl} = $itemtype ? C4::Koha::getitemtypeimagelocation( 'intranet', $itemtype->imageurl ) : q{};
312 $this_item->{description} = $itemtype ? $itemtype->description : q{}; #FIXME Should this be translated_description ?
313 $this_item->{notforloan} = $itemtype->notforloan if $itemtype;
314 $this_item->{'coins'} = $biblio->get_coins;
315 $this_item->{'normalized_upc'} = GetNormalizedUPC( $record, $marcflavour );
316 $this_item->{'normalized_ean'} = GetNormalizedEAN( $record, $marcflavour );
317 $this_item->{'normalized_oclc'} = GetNormalizedOCLCNumber( $record, $marcflavour );
318 $this_item->{'normalized_isbn'} = GetNormalizedISBN( undef, $record, $marcflavour );
320 unless ( defined $this_item->{size} ) {
322 #TT has problems with size
323 $this_item->{size} = q||;
326 # Getting items infos for location display
327 my @items_infos = &GetItemsLocationInfo( $biblionumber );
328 $this_item->{'ITEM_RESULTS'} = \@items_infos;
329 $this_item->{biblionumber} = $biblionumber;
330 push @items, $this_item;
333 my $some_private_shelves = Koha::Virtualshelves->get_some_shelves(
335 borrowernumber => $loggedinuser,
340 my $some_public_shelves = Koha::Virtualshelves->get_some_shelves(
342 borrowernumber => $loggedinuser,
349 add_to_some_private_shelves => $some_private_shelves,
350 add_to_some_public_shelves => $some_public_shelves,
351 can_manage_shelf => $shelf->can_be_managed($loggedinuser),
352 can_remove_shelf => $shelf->can_be_deleted($loggedinuser),
353 can_remove_biblios => $shelf->can_biblios_be_removed($loggedinuser),
354 can_add_biblios => $shelf->can_biblios_be_added($loggedinuser),
355 sortfield => $sortfield,
356 itemsloop => \@items,
357 sortfield => $sortfield,
358 direction => $direction,
361 my $pager = $contents->pager;
363 pagination_bar => pagination_bar(
364 q||, $pager->last_page - $pager->first_page + 1,
365 $page, "page", { op => 'view', shelfnumber => $shelf->shelfnumber, sortfield => $sortfield, direction => $direction, }
370 push @messages, { type => 'error', code => 'unauthorized_on_view' };
374 push @messages, { type => 'alert', code => 'does_not_exist' };
376 } elsif( $op eq 'list' ) {
377 $allow_transfer = haspermission( C4::Context->userenv->{id}, { lists => 'edit_public_lists' } ) ? 1 : 0;
384 messages => \@messages,
386 print => scalar $query->param('print') || 0,
387 csv_profiles => [ Koha::CsvProfiles->search({ type => 'marc', used_for => 'export_records' })->as_list ],
388 allow_transfer => $allow_transfer,
391 output_html_with_http_headers $query, $cookie, $template->output;