serials/serials-edit.pl

   1 #!/usr/bin/perl
   2
   3 # Copyright 2000-2002 Katipo Communications
   4 # Parts Copyright 2010 Biblibre
   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 =head1 NAME
  22
  23 serials-edit.pl
  24
  25 =head1 Parameters
  26
  27 =over 4
  28
  29 =item op
  30 op can be :
  31     * modsubscriptionhistory :to modify the subscription history
  32     * serialchangestatus     :to modify the status of this subscription
  33
  34 =item subscriptionid
  35
  36 =item user
  37
  38 =item histstartdate
  39
  40 =item enddate
  41
  42 =item recievedlist
  43
  44 =item missinglist
  45
  46 =item opacnote
  47
  48 =item librariannote
  49
  50 =item serialid
  51
  52 =item serialseq
  53
  54 =item planneddate
  55
  56 =item notes
  57
  58 =item status
  59
  60 =back
  61
  62 =cut
  63
  64 use strict;
  65 use warnings;
  66 use CGI;
  67 use C4::Auth;
  68 use C4::Dates qw/format_date format_date_in_iso/;
  69 use C4::Biblio;
  70 use C4::Items;
  71 use C4::Koha;
  72 use C4::Output;
  73 use C4::Context;
  74 use C4::Serials;
  75 use List::MoreUtils qw/uniq/;
  76
  77 my $query           = CGI->new();
  78 my $dbh             = C4::Context->dbh;
  79 my @serialids       = $query->param('serialid');
  80 my @serialseqs      = $query->param('serialseq');
  81 my @planneddates    = $query->param('planneddate');
  82 my @publisheddates  = $query->param('publisheddate');
  83 my @status          = $query->param('status');
  84 my @notes           = $query->param('notes');
  85 my @subscriptionids = $query->param('subscriptionid');
  86 my $op              = $query->param('op');
  87 if ( scalar(@subscriptionids) == 1 && index( $subscriptionids[0], q|,| ) > 0 ) {
  88     @subscriptionids = split( /,/, $subscriptionids[0] );
  89 }
  90 my @errors;
  91 my @errseq;
  92
  93 # If user comes from subscription details
  94 unless (@serialids) {
  95     foreach my $subscriptionid (@subscriptionids) {
  96         my $serstatus = $query->param('serstatus');
  97         if ($serstatus) {
  98             my @tmpser = GetSerials2( $subscriptionid, $serstatus );
  99             foreach (@tmpser) {
 100                 push @serialids, $_->{'serialid'};
 101             }
 102         }
 103     }
 104 }
 105
 106 unless ( scalar(@serialids) ) {
 107     my $string = "serials-collection.pl?subscriptionid=" . join( ",", uniq @subscriptionids );
 108     $string =~ s/,$//;
 109
 110     print $query->redirect($string);
 111 }
 112
 113 my ( $template, $loggedinuser, $cookie ) = get_template_and_user(
 114     {
 115         template_name   => "serials/serials-edit.tmpl",
 116         query           => $query,
 117         type            => "intranet",
 118         authnotrequired => 0,
 119         flagsrequired   => {serials => 'receive_serials'},
 120         debug           => 1,
 121     }
 122 );
 123
 124 my @serialdatalist;
 125 my %processedserialid;
 126
 127 my $today = C4::Dates->new();
 128 foreach my $tmpserialid (@serialids) {
 129
 130     #filtering serialid for duplication
 131     #NEW serial should appear only once and are created afterwards
 132     if (   defined($tmpserialid)
 133         && $tmpserialid =~ /^[0-9]+$/
 134         && !$processedserialid{$tmpserialid} )
 135     {
 136         my $data = GetSerialInformation($tmpserialid);
 137         for my $datefield ( qw( publisheddate planneddate) ) {
 138             if ($data->{$datefield} && $data->{$datefield}!~m/^00/) {
 139                 $data->{$datefield} = format_date( $data->{$datefield} );
 140             }
 141             else {
 142                 $data->{$datefield} = q{};
 143             }
 144         }
 145         $data->{arriveddate}=$today->output('syspref');
 146         $data->{'editdisable'} = (
 147             (
 148                 HasSubscriptionExpired( $data->{subscriptionid} ) == 1
 149                   && $data->{'status1'}
 150             )
 151               || $data->{'cannotedit'}
 152         );
 153         push @serialdatalist, $data;
 154         $processedserialid{$tmpserialid} = 1;
 155     }
 156 }
 157 my $bibdata = GetBiblioData( $serialdatalist[0]->{'biblionumber'} );
 158
 159 my @newserialloop;
 160 my @subscriptionloop;
 161
 162 # check, for each subscription edited, that we have an empty item line if applicable for the subscription
 163 my %processedsubscriptionid;
 164 foreach my $subscriptionid (@subscriptionids) {
 165
 166     #Do not process subscriptionid twice if it was already processed.
 167     if ( defined($subscriptionid)
 168         && !$processedsubscriptionid{$subscriptionid} )
 169     {
 170         my $cell;
 171         if ( $serialdatalist[0]->{'serialsadditems'} ) {
 172
 173             #Create New empty item
 174             $cell =
 175               PrepareItemrecordDisplay( $serialdatalist[0]->{'biblionumber'},
 176                 '', GetSubscription($subscriptionid) );
 177             $cell->{serialsadditems} = 1;
 178         }
 179         $cell->{'subscriptionid'} = $subscriptionid;
 180         $cell->{'itemid'}         = "NNEW";
 181         $cell->{'serialid'}       = "NEW";
 182         $cell->{'issuesatonce'}   = 1;
 183         $cell->{arriveddate}=$today->output('syspref');
 184
 185         push @newserialloop, $cell;
 186         push @subscriptionloop,
 187           {
 188             'subscriptionid'      => $subscriptionid,
 189             'abouttoexpire'       => abouttoexpire($subscriptionid),
 190             'subscriptionexpired' => HasSubscriptionExpired($subscriptionid),
 191           };
 192         $processedsubscriptionid{$subscriptionid} = 1;
 193     }
 194 }
 195 $template->param( newserialloop => \@newserialloop );
 196 $template->param( subscriptions => \@subscriptionloop );
 197
 198 if ( $op and $op eq 'serialchangestatus' ) {
 199
 200     my $newserial;
 201     for ( my $i = 0 ; $i <= $#serialids ; $i++ ) {
 202
 203         if ( $serialids[$i] && $serialids[$i] eq "NEW" ) {
 204             if ( $serialseqs[$i] ) {
 205
 206             #IF newserial was provided a name Then we have to create a newSerial
 207                 ### FIXME if NewIssue is modified to use subscription biblionumber, then biblionumber would not be useful.
 208                 $newserial = NewIssue(
 209                     $serialseqs[$i],
 210                     $subscriptionids[0],
 211                     $serialdatalist[0]->{'biblionumber'},
 212                     $status[$i],
 213                     format_date_in_iso( $planneddates[$i] ),
 214                     format_date_in_iso( $publisheddates[$i] ),
 215                     $notes[$i]
 216                 );
 217             }
 218         }
 219         elsif ( $serialids[$i] ) {
 220             ModSerialStatus(
 221                 $serialids[$i],
 222                 $serialseqs[$i],
 223                 format_date_in_iso( $planneddates[$i] ),
 224                 format_date_in_iso( $publisheddates[$i] ),
 225                 $status[$i],
 226                 $notes[$i]
 227             );
 228         }
 229     }
 230     my @moditems = $query->param('moditem');
 231     if ( scalar(@moditems) ) {
 232         my @tags         = $query->param('tag');
 233         my @subfields    = $query->param('subfield');
 234         my @field_values = $query->param('field_value');
 235         my @serials      = $query->param('serial');
 236         my @bibnums      = $query->param('bibnum');
 237         my @itemid       = $query->param('itemid');
 238         my @ind_tag      = $query->param('ind_tag');
 239         my @indicator    = $query->param('indicator');
 240
 241         #Rebuilding ALL the data for items into a hash
 242         # parting them on $itemid.
 243         my %itemhash;
 244         my $countdistinct;
 245         my $range = scalar(@itemid);
 246         for ( my $i = 0 ; $i < $range ; $i++ ) {
 247             unless ( $itemhash{ $itemid[$i] } ) {
 248                 if (   $serials[$countdistinct]
 249                     && $serials[$countdistinct] ne "NEW" )
 250                 {
 251                     $itemhash{ $itemid[$i] }->{'serial'} =
 252                       $serials[$countdistinct];
 253                 }
 254                 else {
 255                     $itemhash{ $itemid[$i] }->{'serial'} = $newserial;
 256                 }
 257                 $itemhash{ $itemid[$i] }->{'bibnum'} = $bibnums[$countdistinct];
 258                 $countdistinct++;
 259             }
 260             push @{ $itemhash{ $itemid[$i] }->{'tags'} },      $tags[$i];
 261             push @{ $itemhash{ $itemid[$i] }->{'subfields'} }, $subfields[$i];
 262             push @{ $itemhash{ $itemid[$i] }->{'field_values'} },
 263               $field_values[$i];
 264             push @{ $itemhash{ $itemid[$i] }->{'ind_tag'} },   $ind_tag[$i];
 265             push @{ $itemhash{ $itemid[$i] }->{'indicator'} }, $indicator[$i];
 266         }
 267         foreach my $item ( keys %itemhash ) {
 268
 269        # Verify Itemization is "Valid", i.e. serial status is Arrived or Missing
 270             my $index = -1;
 271             for ( my $i = 0 ; $i < scalar(@serialids) ; $i++ ) {
 272                   if (
 273                     $itemhash{$item}->{serial} eq $serialids[$i]
 274                     || (   $itemhash{$item}->{serial} == $newserial
 275                         && $serialids[$i] eq 'NEW' )
 276                 ) {
 277                     $index = $i
 278                   }
 279             }
 280             if ( $index >= 0 && $status[$index] == 2 ) {
 281                 my $xml = TransformHtmlToXml(
 282                     $itemhash{$item}->{'tags'},
 283                     $itemhash{$item}->{'subfields'},
 284                     $itemhash{$item}->{'field_values'},
 285                     $itemhash{$item}->{'indicator'},
 286                     $itemhash{$item}->{'ind_tag'}
 287                 );
 288
 289                 #           warn $xml;
 290                 my $bib_record = MARC::Record::new_from_xml( $xml, 'UTF-8' );
 291                 if ( $item =~ /^N/ ) {
 292
 293                     #New Item
 294
 295                   # if autoBarcode is set to 'incremental', calculate barcode...
 296                     my ( $barcodetagfield, $barcodetagsubfield ) =
 297                       GetMarcFromKohaField(
 298                         'items.barcode',
 299                         GetFrameworkCode(
 300                             $serialdatalist[0]->{'biblionumber'}
 301                         )
 302                       );
 303                     if ( C4::Context->preference("autoBarcode") eq
 304                         'incremental' )
 305                     {
 306                         if ( !$bib_record->field($barcodetagfield)
 307                             ->subfield($barcodetagsubfield) )
 308                         {
 309                             my $sth_barcode = $dbh->prepare(
 310                                 "select max(abs(barcode)) from items");
 311                             $sth_barcode->execute;
 312                             my ($newbarcode) = $sth_barcode->fetchrow;
 313
 314 # OK, we have the new barcode, add the entry in MARC record # FIXME -> should be  using barcode plugin here.
 315                             $bib_record->field($barcodetagfield)
 316                               ->update( $barcodetagsubfield => ++$newbarcode );
 317                         }
 318                     }
 319
 320                     # check for item barcode # being unique
 321                     my $exists;
 322                     if (
 323                         $bib_record->subfield(
 324                             $barcodetagfield, $barcodetagsubfield
 325                         )
 326                       )
 327                     {
 328                         $exists = GetItemnumberFromBarcode(
 329                             $bib_record->subfield(
 330                                 $barcodetagfield, $barcodetagsubfield
 331                             )
 332                         );
 333                     }
 334
 335                     #           push @errors,"barcode_not_unique" if($exists);
 336                     # if barcode exists, don't create, but report The problem.
 337                     if ($exists) {
 338                         push @errors, 'barcode_not_unique';
 339                         push @errseq, { serialseq => $serialseqs[$index] };
 340                     }
 341                     else {
 342                         my ( $biblionumber, $bibitemnum, $itemnumber ) =
 343                           AddItemFromMarc( $bib_record,
 344                             $itemhash{$item}->{bibnum} );
 345                         AddItem2Serial( $itemhash{$item}->{serial},
 346                             $itemnumber );
 347                     }
 348                 }
 349                 else {
 350
 351                     #modify item
 352                     my ( $oldbiblionumber, $oldbibnum, $itemnumber ) =
 353                       ModItemFromMarc( $bib_record,
 354                         $itemhash{$item}->{'bibnum'}, $item );
 355                 }
 356             }
 357         }
 358     }
 359
 360
 361     if ( @errors ) {
 362         $template->param( Errors => 1 );
 363         if ( @errseq ) {
 364             $template->param( barcode_not_unique => 1, errseq => \@errseq );
 365         }
 366     }
 367     else {
 368         my $redirect = "serials-collection.pl?";
 369         $redirect .= join( '&', map { "subscriptionid=" . $_ } sort @subscriptionids );# ID The sort necessary
 370         print $query->redirect($redirect);
 371     }
 372 }
 373 my $location = GetAuthorisedValues('LOC', $serialdatalist[0]->{'location'});
 374 my $locationlib;
 375 foreach (@$location) {
 376     $locationlib = $_->{'lib'} if $_->{'selected'};
 377 }
 378 my $default_bib_view = get_default_view();
 379
 380 $template->param(
 381     serialsadditems => $serialdatalist[0]->{'serialsadditems'},
 382     callnumber       => $serialdatalist[0]->{'callnumber'},
 383     bibliotitle     => $bibdata->{'title'},
 384     biblionumber    => $serialdatalist[0]->{'biblionumber'},
 385     serialslist     => \@serialdatalist,
 386     default_bib_view => $default_bib_view,
 387     location         => $locationlib,
 388 );
 389 output_html_with_http_headers $query, $cookie, $template->output;
 390
 391 sub get_default_view {
 392     my $defaultview = C4::Context->preference('IntranetBiblioDefaultView');
 393     my $views = { C4::Search::enabled_staff_search_views };
 394     if ($defaultview eq 'isbd' && $views->{can_view_ISBD}) {
 395         return 'ISBDdetail';
 396     } elsif  ($defaultview eq 'marc' && $views->{can_view_MARC}) {
 397         return 'MARCdetail';
 398     } elsif  ($defaultview eq 'labeled_marc' && $views->{can_view_labeledMARC}) {
 399         return 'labeledMARCdetail';
 400     } else {
 401         return 'detail';
 402     }
 403 }