C4/VirtualShelves/Page.pm

   1 package C4::VirtualShelves::Page;
   2
   3 #
   4 # Copyright 2000-2002 Katipo Communications
   5 #
   6 # This file is part of Koha.
   7 #
   8 # Koha is free software; you can redistribute it and/or modify it under the
   9 # terms of the GNU General Public License as published by the Free Software
  10 # Foundation; either version 2 of the License, or (at your option) any later
  11 # version.
  12 #
  13 # Koha is distributed in the hope that it will be useful, but WITHOUT ANY
  14 # WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR
  15 # A PARTICULAR PURPOSE.  See the GNU General Public License for more details.
  16 #
  17 # You should have received a copy of the GNU General Public License along
  18 # with Koha; if not, write to the Free Software Foundation, Inc.,
  19 # 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA.
  20
  21 # perldoc at the end of the file, per convention.
  22
  23 use strict;
  24 use warnings;
  25
  26 use CGI;
  27 use Exporter;
  28 use Data::Dumper;
  29
  30 use C4::VirtualShelves qw/:DEFAULT ShelvesMax/;
  31 use C4::Biblio;
  32 use C4::Items;
  33 use C4::Koha;
  34 use C4::Auth qw/get_session/;
  35 use C4::Members;
  36 use C4::Output;
  37 use C4::Dates qw/format_date/;
  38 use C4::Tags qw(get_tags);
  39 use C4::Csv;
  40 use C4::XSLT;
  41
  42 use constant VIRTUALSHELVES_COUNT => 20;
  43
  44 use vars qw($debug @EXPORT @ISA $VERSION);
  45
  46 BEGIN {
  47     $VERSION = 3.07.00.049;
  48     @ISA     = qw(Exporter);
  49     @EXPORT  = qw(&shelfpage);
  50     $debug   = $ENV{DEBUG} || 0;
  51 }
  52
  53 our %pages = (
  54     intranet => { redirect => '/cgi-bin/koha/virtualshelves/shelves.pl', },
  55     opac     => { redirect => '/cgi-bin/koha/opac-shelves.pl', },
  56 );
  57
  58 sub shelfpage {
  59     my ( $type, $query, $template, $loggedinuser, $cookie ) = @_;
  60     ( $pages{$type} ) or $type = 'opac';
  61     $query            or die "No query";
  62     $template         or die "No template";
  63     $template->param(
  64     loggedinuser => $loggedinuser,
  65     OpacAllowPublicListCreation => C4::Context->preference('OpacAllowPublicListCreation'),
  66     );
  67     my $edit;
  68     my $shelves;
  69     my @paramsloop;
  70     my $totitems;
  71     my $shelfoff    = ( $query->param('shelfoff') ? $query->param('shelfoff') : 1 );
  72     $template->{VARS}->{'shelfoff'} = $shelfoff;
  73     my $itemoff     = ( $query->param('itemoff')  ? $query->param('itemoff')  : 1 );
  74     my $displaymode = ( $query->param('display')  ? $query->param('display')  : 'publicshelves' );
  75     my ( $shelflimit, $shelfoffset, $shelveslimit, $shelvesoffset );
  76     my $marcflavour = C4::Context->preference("marcflavour");
  77
  78     # get biblionumbers stored in the cart
  79     my @cart_list;
  80     my $cart_cookie = ( $type eq 'opac' ? "bib_list" : "intranet_bib_list" );
  81     if($query->cookie($cart_cookie)){
  82         my $cart_list = $query->cookie($cart_cookie);
  83         @cart_list = split(/\//, $cart_list);
  84     }
  85
  86     $shelflimit = ( $type eq 'opac' ? C4::Context->preference('OPACnumSearchResults') : C4::Context->preference('numSearchResults') );
  87     $shelflimit = $shelflimit || ShelvesMax('MGRPAGE');
  88     $shelfoffset   = ( $itemoff - 1 ) * $shelflimit;     # Sets the offset to begin retrieving items at
  89     $shelveslimit  = $shelflimit;                        # Limits number of shelves returned for a given query (row_count)
  90     $shelvesoffset = ( $shelfoff - 1 ) * $shelflimit;    # Sets the offset to begin retrieving shelves at (offset)
  91                                                 # getting the Shelves list
  92     my $category = ( ( $displaymode eq 'privateshelves' ) ? 1 : 2 );
  93     my ( $shelflist, $totshelves ) = GetShelves( $category, $shelveslimit, $shelvesoffset, $loggedinuser );
  94
  95     #Get a list of private shelves for possible deletion. Only do this when we've defaulted to public shelves
  96     my ( $privshelflist, $privtotshelves );
  97     if ( $category == 2 ) {
  98         ( $privshelflist, $privtotshelves ) = GetShelves( 1, $shelveslimit, $shelvesoffset, $loggedinuser );
  99     }
 100     my $op = $query->param('op');
 101
 102     # the format of this is unindented for ease of diff comparison to the old script
 103     # Note: do not mistake the assignment statements below for comparisons!
 104     if ( $query->param('modifyshelfcontents') ) {
 105         my ( $shelfnumber, $barcode, $item, $biblio );
 106         if ( $shelfnumber = $query->param('viewshelf') ) {
 107             #add to shelf
 108             if($barcode = $query->param('addbarcode') ) {
 109                 if(ShelfPossibleAction( $loggedinuser, $shelfnumber, 'add')) {
 110                     $item = GetItem( 0, $barcode);
 111                     if (defined $item && $item->{'itemnumber'}) {
 112                         $biblio = GetBiblioFromItemNumber( $item->{'itemnumber'} );
 113                         AddToShelf( $biblio->{'biblionumber'}, $shelfnumber, $loggedinuser)
 114                           or push @paramsloop, { duplicatebiblio => $barcode };
 115                     }
 116                     else {
 117                         push @paramsloop, { failgetitem => $barcode };
 118                     }
 119                 }
 120                 else {
 121                     push @paramsloop, { nopermission => $shelfnumber };
 122                 }
 123             }
 124             elsif(grep { /REM-(\d+)/ } $query->param) {
 125             #remove item(s) from shelf
 126                 if(ShelfPossibleAction($loggedinuser, $shelfnumber, 'delete')) {
 127                 #This is just a general okay; DelFromShelf checks further
 128                     my @bib;
 129                     foreach($query->param) {
 130                         /REM-(\d+)/ or next;
 131                         push @bib, $1; #$1 is biblionumber
 132                     }
 133                     my $t= DelFromShelf(\@bib, $shelfnumber, $loggedinuser);
 134                     if($t==0) {
 135                         push @paramsloop, {nothingdeleted => $shelfnumber};
 136                     }
 137                     elsif($t<@bib) {
 138                         push @paramsloop, {somedeleted => $shelfnumber};
 139                     }
 140                 }
 141                 else {
 142                     push @paramsloop, { nopermission => $shelfnumber };
 143                 }
 144             }
 145         }
 146         else {
 147             push @paramsloop, { noshelfnumber => 1 };
 148         }
 149     }
 150
 151     my $showadd = 1;
 152
 153     # set the default tab, etc. (for OPAC)
 154     my $shelf_type = ( $query->param('display') ? $query->param('display') : 'publicshelves' );
 155     if ( defined $shelf_type ) {
 156         if ( $shelf_type eq 'privateshelves' ) {
 157             $template->param( showprivateshelves => 1 );
 158         } elsif ( $shelf_type eq 'publicshelves' ) {
 159             $template->param( showpublicshelves => 1 );
 160             $showadd = 0;
 161         } else {
 162             $debug and warn "Invalid 'display' param ($shelf_type)";
 163         }
 164     } elsif ( $loggedinuser == -1 ) {
 165         $template->param( showpublicshelves => 1 );
 166     } else {
 167         $template->param( showprivateshelves => 1 );
 168     }
 169
 170     my ( $okmanage, $okview );
 171     my $shelfnumber = $query->param('shelfnumber') || $query->param('viewshelf');
 172     if ($shelfnumber) {
 173         $okmanage = ShelfPossibleAction( $loggedinuser, $shelfnumber, 'manage' );
 174         $okview   = ShelfPossibleAction( $loggedinuser, $shelfnumber, 'view' );
 175     }
 176
 177     my $delflag = 0;
 178
 179   SWITCH: {
 180         if ($op) {
 181         #Saving modified shelf
 182             if ( $op eq 'modifsave' ) {
 183                 unless ($okmanage) {
 184                         push @paramsloop, { nopermission => $shelfnumber };
 185                         last SWITCH;
 186                 }
 187                 my $shelf = {
 188                     shelfname          => $query->param('shelfname'),
 189                     sortfield          => $query->param('sortfield'),
 190                     allow_add          => $query->param('allow_add'),
 191                     allow_delete_own   => $query->param('allow_delete_own'),
 192                     allow_delete_other => $query->param('allow_delete_other'),
 193                 };
 194                 if($query->param('category')) { #optional
 195                     $shelf->{category}= $query->param('category');
 196                 }
 197                 unless(ModShelf($shelfnumber, $shelf )) {
 198                   push @paramsloop, {modifyfailure => $shelf->{shelfname}};
 199                   last SWITCH;
 200                 }
 201
 202                 if($displaymode eq "viewshelf"){
 203                     print $query->redirect( $pages{$type}->{redirect} . "?viewshelf=$shelfnumber" );
 204                 } elsif($displaymode eq "publicshelves"){
 205                     print $query->redirect( $pages{$type}->{redirect} );
 206                 } else {
 207                     print $query->redirect( $pages{$type}->{redirect} . "?display=privateshelves" );
 208                 }
 209                 exit;
 210             }
 211         #Editing a shelf
 212         elsif ( $op eq 'modif' ) {
 213                 my ( $shelfnumber2, $shelfname, $owner, $category, $sortfield, $allow_add, $allow_delete_own, $allow_delete_other) = GetShelf($shelfnumber);
 214                 my $member = GetMember( 'borrowernumber' => $owner );
 215                 my $ownername = defined($member) ? $member->{firstname} . " " . $member->{surname} : '';
 216                 $edit = 1;
 217                 $template->param(
 218                     edit                => 1,
 219                     display             => $displaymode,
 220                     shelfnumber         => $shelfnumber2,
 221                     shelfname           => $shelfname,
 222                     owner               => $owner,
 223                     ownername           => $ownername,
 224                     "category$category" => 1,
 225                     category            => $category,
 226                     sortfield           => $sortfield,
 227                     allow_add           => $allow_add,
 228                     allow_delete_own    => $allow_delete_own,
 229                     allow_delete_other  => $allow_delete_other,
 230                 );
 231             }
 232             last SWITCH;
 233         }
 234
 235         #View a shelf
 236         if ( $shelfnumber = $query->param('viewshelf') ) {
 237             # explicitly fetch this shelf
 238             my ($shelfnumber2,$shelfname,$owner,$category,$sorton) = GetShelf($shelfnumber);
 239
 240             $template->param( 'AllowOnShelfHolds' => C4::Context->preference('AllowOnShelfHolds') );
 241             if (C4::Context->preference('TagsEnabled')) {
 242                 $template->param(TagsEnabled => 1);
 243                     foreach (qw(TagsShowOnList TagsInputOnList)) {
 244                     C4::Context->preference($_) and $template->param($_ => 1);
 245                 }
 246             }
 247             #check that the user can view the shelf
 248             if ( ShelfPossibleAction( $loggedinuser, $shelfnumber, 'view' ) ) {
 249                 my $items;
 250                 my $tag_quantity;
 251                 my $sortfield = ( $sorton ? $sorton : 'title' );
 252                 $sortfield = $query->param('sort') || $sortfield; ## Passed in sorting overrides default sorting
 253                 my $direction = $query->param('direction') || 'asc';
 254                 $template->param(
 255                     sort      => $sortfield,
 256                     direction => $direction,
 257                 );
 258                 ( $items, $totitems ) = GetShelfContents( $shelfnumber, $shelflimit, $shelfoffset, $sortfield, $direction );
 259                 for my $this_item (@$items) {
 260                     my $biblionumber = $this_item->{'biblionumber'};
 261                     my $record = GetMarcBiblio($biblionumber);
 262                     $this_item->{XSLTBloc} =
 263                         XSLTParse4Display($biblionumber, $record, "OPACXSLTResultsDisplay")
 264                             if C4::Context->preference("OPACXSLTResultsDisplay") && $type eq 'opac';
 265
 266                     # the virtualshelfcontents table does not store these columns nor are they retrieved from the items
 267                     # and itemtypes tables, so I'm commenting them out for now to quiet the log -crn
 268                     #$this_item->{imageurl} = $imgdir."/".$itemtypes->{ $this_item->{itemtype}  }->{'imageurl'};
 269                     #$this_item->{'description'} = $itemtypes->{ $this_item->{itemtype} }->{'description'};
 270                     $this_item->{'dateadded'} = format_date( $this_item->{'dateadded'} );
 271                     $this_item->{'imageurl'}  = getitemtypeinfo( $this_item->{'itemtype'}, $type )->{'imageurl'};
 272                     $this_item->{'coins'}     = GetCOinSBiblio( $record );
 273                     $this_item->{'subtitle'} = GetRecordValue('subtitle', $record, GetFrameworkCode($this_item->{'biblionumber'}));
 274                     $this_item->{'normalized_upc'}  = GetNormalizedUPC(       $record,$marcflavour);
 275                     $this_item->{'normalized_ean'}  = GetNormalizedEAN(       $record,$marcflavour);
 276                     $this_item->{'normalized_oclc'} = GetNormalizedOCLCNumber($record,$marcflavour);
 277                     $this_item->{'normalized_isbn'} = GetNormalizedISBN(undef,$record,$marcflavour);
 278                     if(!defined($this_item->{'size'})) { $this_item->{'size'} = "" }; #TT has problems with size
 279                     # Getting items infos for location display
 280                     my @items_infos = &GetItemsLocationInfo( $this_item->{'biblionumber'});
 281                     $this_item->{'itemsissued'} = CountItemsIssued( $this_item->{'biblionumber'} );
 282                     $this_item->{'ITEM_RESULTS'} = \@items_infos;
 283                     if ( grep {$_ eq $biblionumber} @cart_list) {
 284                         $this_item->{'incart'} = 1;
 285                     }
 286
 287                     if (C4::Context->preference('TagsEnabled') and $tag_quantity = C4::Context->preference('TagsShowOnList')) {
 288                         $this_item->{'TagLoop'} = get_tags({
 289                             biblionumber=>$this_item->{'biblionumber'}, approved=>1, 'sort'=>'-weight',
 290                             limit=>$tag_quantity
 291                             });
 292                     }
 293
 294                 }
 295                 push @paramsloop, { display => 'privateshelves' } if $category == 1;
 296                 $showadd = 1;
 297                 my $i = 0;
 298                 my $manageshelf = ShelfPossibleAction( $loggedinuser, $shelfnumber, 'manage' );
 299                 $template->param(
 300                     shelfname           => $shelfname,
 301                     shelfnumber         => $shelfnumber,
 302                     viewshelf           => $shelfnumber,
 303                     sortfield           => $sortfield,
 304                     manageshelf         => $manageshelf,
 305                     allowremovingitems  => ShelfPossibleAction( $loggedinuser, $shelfnumber, 'delete'),
 306                     allowaddingitem     => ShelfPossibleAction( $loggedinuser, $shelfnumber, 'add'),
 307                     "category$category" => 1,
 308                     category            => $category,
 309                     itemsloop           => $items,
 310                     showprivateshelves  => $category==1,
 311                 );
 312             } else {
 313                 push @paramsloop, { nopermission => $shelfnumber };
 314             }
 315             last SWITCH;
 316         }
 317
 318         if ( $query->param('shelves') ) {
 319             my $stay = 1;
 320
 321         #Add a shelf
 322             if ( my $newshelf = $query->param('addshelf') ) {
 323
 324                 # note: a user can always add a new shelf
 325                 my $shelfnumber = AddShelf( {
 326                     shelfname => $newshelf,
 327                     sortfield => $query->param('sortfield'),
 328                     category => $query->param('category'),
 329                     allow_add => $query->param('allow_add'),
 330                     allow_delete_own => $query->param('allow_delete_own'),
 331                     allow_delete_other => $query->param('allow_delete_other'),
 332                     },
 333                     $query->param('owner') );
 334                 $stay = 1;
 335                 if ( $shelfnumber == -1 ) {    #shelf already exists.
 336                     $showadd = 1;
 337                     push @paramsloop, { already => $newshelf };
 338                     $template->param( shelfnumber => $shelfnumber );
 339                 } else {
 340                     print $query->redirect( $pages{$type}->{redirect} . "?viewshelf=$shelfnumber" );
 341                     exit;
 342                 }
 343             }
 344
 345         #Deleting a shelf (asking for confirmation if it has entries)
 346             foreach ( $query->param() ) {
 347                 /DEL-(\d+)/ or next;
 348                 $delflag = 1;
 349                 my $number = $1;
 350                 unless ( defined $shelflist->{$number} || defined $privshelflist->{$number} ) {
 351                     push( @paramsloop, { unrecognized => $number } );
 352                     last;
 353                 }
 354                 unless ( ShelfPossibleAction( $loggedinuser, $number, 'manage' ) ) {
 355                     push( @paramsloop, { nopermission => $shelfnumber } );
 356                     last;
 357                 }
 358                 my $contents;
 359                 ( $contents, $totshelves ) = GetShelfContents( $number, $shelveslimit, $shelvesoffset );
 360                 if ( my $count = scalar @$contents ) {
 361                     unless ( scalar grep { /^CONFIRM-$number$/ } $query->param() ) {
 362                         if ( defined $shelflist->{$number} ) {
 363                             push( @paramsloop, { need_confirm => $shelflist->{$number}->{shelfname}, count => $count, single => ($count eq 1 ? 1:0) } );
 364                             $shelflist->{$number}->{confirm} = $number;
 365                         } else {
 366                             push( @paramsloop, { need_confirm => $privshelflist->{$number}->{shelfname}, count => $count } );
 367                             $privshelflist->{$number}->{confirm} = $number;
 368                         }
 369                         $stay = 0;
 370                         next;
 371                     }
 372                 }
 373                 my $name;
 374                 if ( defined $shelflist->{$number} ) {
 375                     $name = $shelflist->{$number}->{'shelfname'};
 376                     delete $shelflist->{$number};
 377                 } else {
 378                     $name = $privshelflist->{$number}->{'shelfname'};
 379                     delete $privshelflist->{$number};
 380                 }
 381                 unless ( DelShelf($number) ) {
 382                     push( @paramsloop, { delete_fail => $name } );
 383                     last;
 384                 }
 385                 push( @paramsloop, { delete_ok => $name } );
 386
 387                 $stay = 0;
 388             }
 389             $showadd = 1;
 390             if ($stay){
 391                 $template->param( shelves => 1 );
 392                 $shelves = 1;
 393             }
 394             last SWITCH;
 395         }
 396     } # end of SWITCH block
 397
 398     (@paramsloop) and $template->param( paramsloop => \@paramsloop );
 399     $showadd      and $template->param( showadd    => 1 );
 400     my @shelvesloop;
 401     my @shelveslooppriv;
 402     my $numberCanManage = 0;
 403
 404     # rebuild shelflist in case a shelf has been added
 405     ( $shelflist, $totshelves ) = GetShelves( $category, $shelveslimit, $shelvesoffset, $loggedinuser ) unless $delflag;
 406     foreach my $element ( sort { lc( $shelflist->{$a}->{'shelfname'} ) cmp lc( $shelflist->{$b}->{'shelfname'} ) } keys %$shelflist ) {
 407         my %line;
 408         $shelflist->{$element}->{shelf} = $element;
 409         my $category  = $shelflist->{$element}->{'category'};
 410         my $owner     = $shelflist->{$element}->{'owner'}||0;
 411         my $canmanage = ShelfPossibleAction( $loggedinuser, $element, 'manage' );
 412         $shelflist->{$element}->{"viewcategory$category"} = 1;
 413         $shelflist->{$element}->{manageshelf} = $canmanage;
 414         if($canmanage || ($loggedinuser && $owner==$loggedinuser)) {
 415             $shelflist->{$element}->{'mine'} = 1;
 416         }
 417         my $member = GetMember( 'borrowernumber' => $owner );
 418         $shelflist->{$element}->{ownername} = defined($member) ? $member->{firstname} . " " . $member->{surname} : '';
 419         $numberCanManage++ if $canmanage;    # possibly outmoded
 420         if ( $shelflist->{$element}->{'category'} eq '1' ) {
 421             push( @shelveslooppriv, $shelflist->{$element} );
 422         } else {
 423             push( @shelvesloop, $shelflist->{$element} );
 424         }
 425     }
 426
 427     my $url = $type eq 'opac' ? "/cgi-bin/koha/opac-shelves.pl" : "/cgi-bin/koha/virtualshelves/shelves.pl";
 428     my %qhash = ();
 429     foreach (qw(display viewshelf sortfield sort direction)) {
 430         $qhash{$_} = $query->param($_) if $query->param($_);
 431     }
 432     ( scalar keys %qhash ) and $url .= '?' . join '&', map { "$_=$qhash{$_}" } keys %qhash;
 433     if ( $shelfnumber && $totitems ) {
 434         $template->param(  pagination_bar => pagination_bar( $url, ( int( $totitems / $shelflimit ) ) + ( ( $totitems % $shelflimit ) > 0 ? 1 : 0 ), $itemoff, "itemoff" )  );
 435     } elsif ( $totshelves ) {
 436         $template->param(
 437              pagination_bar => pagination_bar( $url, ( int( $totshelves / $shelveslimit ) ) + ( ( $totshelves % $shelveslimit ) > 0 ? 1 : 0 ), $shelfoff, "shelfoff" )  );
 438     }
 439     $template->param(
 440         shelveslooppriv                                                    => \@shelveslooppriv,
 441         shelvesloop                                                        => \@shelvesloop,
 442         shelvesloopall                                                     => [ ( @shelvesloop, @shelveslooppriv ) ],
 443         numberCanManage                                                    => $numberCanManage,
 444         "BiblioDefaultView" . C4::Context->preference("BiblioDefaultView") => 1,
 445         csv_profiles                                                       => GetCsvProfilesLoop()
 446     );
 447     if (   $shelfnumber
 448         or $shelves
 449         or $edit ) {
 450         $template->param( vseflag => 1 );
 451     }
 452     if ($shelves or    # note: this part looks duplicative, but is intentional
 453         $edit
 454       ) {
 455         $template->param( seflag => 1 );
 456         #This hack is just another argument for refactoring this script one day
 457         #At this point you are adding or editing a list; if you add, then you add a private list (by default) with permissions as below; if you edit, do not pass these permissions, they must come from the database
 458         $template->param( allow_add => 0, allow_delete_own => 1, allow_delete_other => 0) unless $shelfnumber;
 459     }
 460
 461 #Next call updates the shelves for the Lists button.
 462 #May not always be needed (when nothing changed), but doesn't take much.
 463     my ($total, $pubshelves, $barshelves) = C4::VirtualShelves::GetSomeShelfNames($loggedinuser, 'MASTHEAD');
 464     $template->param(
 465             barshelves     => $total->{bartotal},
 466             barshelvesloop => $barshelves,
 467             pubshelves     => $total->{pubtotal},
 468             pubshelvesloop => $pubshelves,
 469     );
 470
 471     output_html_with_http_headers $query, $cookie, $template->output;
 472 }
 473
 474 1;
 475 __END__
 476
 477 =head1 NAME
 478
 479 VirtualShelves/Page.pm
 480
 481 =head1 DESCRIPTION
 482
 483 Module used for both OPAC and intranet pages.
 484
 485 =head1 CGI PARAMETERS
 486
 487 =over 4
 488
 489 =item C<modifyshelfcontents>
 490
 491 If this script has to modify the shelf content.
 492
 493 =item C<shelfnumber>
 494
 495 To know on which shelf to work.
 496
 497 =item C<addbarcode>
 498
 499 =item C<op>
 500
 501  Op can be:
 502     * modif: show the template allowing modification of the shelves;
 503     * modifsave: save changes from modif mode.
 504
 505 =item C<viewshelf>
 506
 507 Load template with 'viewshelves param' displaying the shelf's information.
 508
 509 =item C<shelves>
 510
 511 If the param shelves == 1, then add or delete a shelf.
 512
 513 =item C<addshelf>
 514
 515 If the param shelves == 1, then addshelf is the name of the shelf to add.
 516
 517 =back
 518
 519 =cut