3 # Copyright 2000-2002 Katipo Communications
4 # Parts Copyright 2010 Biblibre
6 # This file is part of Koha.
8 # Koha is free software; you can redistribute it and/or modify it
9 # under the terms of the GNU General Public License as published by
10 # the Free Software Foundation; either version 3 of the License, or
11 # (at your option) any later version.
13 # Koha is distributed in the hope that it will be useful, but
14 # WITHOUT ANY WARRANTY; without even the implied warranty of
15 # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
16 # GNU General Public License for more details.
18 # You should have received a copy of the GNU General Public License
19 # along with Koha; if not, see <http://www.gnu.org/licenses>.
31 * modsubscriptionhistory :to modify the subscription history
32 * serialchangestatus :to modify the status of this subscription
67 use Encode qw( decode is_utf8 );
75 use C4::Search qw/enabled_staff_search_views/;
78 use List::MoreUtils qw/uniq/;
80 my $query = CGI->new();
81 my $dbh = C4::Context->dbh;
82 my @serialids = $query->multi_param('serialid');
83 my @serialseqs = $query->multi_param('serialseq');
84 my @planneddates = $query->multi_param('planneddate');
85 my @publisheddates = $query->multi_param('publisheddate');
86 my @publisheddatetexts = $query->multi_param('publisheddatetext');
87 my @status = $query->multi_param('status');
88 my @notes = $query->multi_param('notes');
89 my @subscriptionids = $query->multi_param('subscriptionid');
90 my $op = $query->param('op');
91 if ( scalar(@subscriptionids) == 1 && index( $subscriptionids[0], q|,| ) > 0 ) {
92 @subscriptionids = split( /,/, $subscriptionids[0] );
96 my $dbh = C4::Context->dbh;
98 # If user comes from subscription details
100 my $serstatus = $query->param('serstatus');
101 my @statuses = split ',', $serstatus;
103 foreach my $subscriptionid (@subscriptionids) {
104 my @tmpser = GetSerials2( $subscriptionid, \@statuses );
105 push @serialids, map { $_->{serialid} } @tmpser;
110 unless ( @serialids ) {
112 'serials-collection.pl?subscriptionid=' . join ',', uniq @subscriptionids;
115 print $query->redirect($string);
118 my ( $template, $loggedinuser, $cookie ) = get_template_and_user(
120 template_name => 'serials/serials-edit.tt',
123 authnotrequired => 0,
124 flagsrequired => { serials => 'receive_serials' },
130 my %processedserialid;
132 my $today = output_pref( { dt => dt_from_string, dateonly => 1 } );
134 foreach my $serialid (@serialids) {
136 #filtering serialid for duplication
137 #NEW serial should appear only once and are created afterwards
139 && $serialid =~ /^[0-9]+$/
140 && !$processedserialid{$serialid} )
142 my $serinfo = GetSerialInformation($serialid); #TODO duplicates work done by GetSerials2 above
144 for my $d ( qw( publisheddate planneddate )){
145 if ( $serinfo->{$d} =~m/^00/ ) {
146 $serinfo->{$d} = q{};
149 $serinfo->{$d} = output_pref( { dt => dt_from_string( $serinfo->{$d} ), dateonly => 1 } );
152 $serinfo->{arriveddate} = $today;
154 $serinfo->{'editdisable'} = (
156 HasSubscriptionExpired( $serinfo->{subscriptionid} )
157 && $serinfo->{'status1'}
159 || $serinfo->{'cannotedit'}
161 $serinfo->{editdisable} = 0 if C4::Auth::haspermission( C4::Context->userenv->{id}, { serials => 'receive_serials' } );
162 $serinfo->{editdisable} ||= ($serinfo->{status8} and $serinfo->{closed});
163 push @serialdatalist, $serinfo;
164 $processedserialid{$serialid} = 1;
167 my $biblio = GetBiblioData( $serialdatalist[0]->{'biblionumber'} );
170 my @subscriptionloop;
172 # check, for each subscription edited, that we have an empty item line if applicable for the subscription
173 my %processedsubscriptionid;
174 foreach my $subscriptionid (@subscriptionids) {
176 #Do not process subscriptionid twice if it was already processed.
177 if ( $subscriptionid && !$processedsubscriptionid{$subscriptionid} )
180 if ( $serialdatalist[0]->{'serialsadditems'} ) {
182 #Create New empty item
184 PrepareItemrecordDisplay( $serialdatalist[0]->{'biblionumber'},
185 '', GetSubscription($subscriptionid) );
186 $cell->{serialsadditems} = 1;
188 $cell->{'subscriptionid'} = $subscriptionid;
189 $cell->{biblionumber} = $serialdatalist[0]->{'biblionumber'};
190 $cell->{'itemid'} = 'NNEW';
191 $cell->{'serialid'} = 'NEW';
192 $cell->{'issuesatonce'} = 1;
193 $cell->{arriveddate} = $today;
195 push @newserialloop, $cell;
196 push @subscriptionloop,
198 'subscriptionid' => $subscriptionid,
199 'abouttoexpire' => abouttoexpire($subscriptionid),
200 'subscriptionexpired' => HasSubscriptionExpired($subscriptionid),
202 $processedsubscriptionid{$subscriptionid} = 1;
205 $template->param( newserialloop => \@newserialloop );
206 $template->param( subscriptions => \@subscriptionloop );
208 if ( $op and $op eq 'serialchangestatus' ) {
210 # Convert serialseqs to UTF-8 to prevent encoding problems
211 foreach my $seq (@serialseqs) {
212 $seq = Encode::decode('UTF-8', $seq) unless Encode::is_utf8($seq);
216 for ( my $i = 0 ; $i <= $#serialids ; $i++ ) {
217 my ($plan_date, $pub_date);
219 if (defined $planneddates[$i] && $planneddates[$i] ne 'XXX') {
220 $plan_date = eval { output_pref( { dt => dt_from_string( $planneddates[$i] ), dateonly => 1, dateformat => 'iso' } ); };
222 if (defined $publisheddates[$i] && $publisheddates[$i] ne 'XXX') {
223 $pub_date = eval { output_pref( { dt => dt_from_string( $publisheddates[$i] ), dateonly => 1, dateformat => 'iso' } ); };
226 if ( $serialids[$i] && $serialids[$i] eq 'NEW' ) {
227 if ( $serialseqs[$i] ) {
229 #IF newserial was provided a name Then we have to create a newSerial
230 ### FIXME if NewIssue is modified to use subscription biblionumber, then biblionumber would not be useful.
231 $newserial = NewIssue(
234 $serialdatalist[0]->{'biblionumber'},
238 $publisheddatetexts[$i],
243 elsif ( $serialids[$i] ) {
249 $publisheddatetexts[$i],
254 my $makePreviousSerialAvailable = C4::Context->preference('makePreviousSerialAvailable');
255 if ($makePreviousSerialAvailable && $serialids[$i] ne "NEW") {
256 # We already have created the new expected serial at this point, so we get the second previous serial
257 my $previous = GetPreviousSerialid($subscriptionids[$i]);
260 # Getting the itemnumber matching the serialid
261 my $query = "SELECT itemnumber FROM serialitems WHERE serialid=?";
262 my $sth = $dbh->prepare($query);
263 $sth->execute($previous);
264 my @row = $sth->fetchrow_array;
266 my $itemnumber = $row[0];
268 # Getting the itemtype to set from the database
269 my $subscriptioninfos = GetSubscription($subscriptionids[$i]);
271 # Changing the status to "available" and the itemtype according to the previousitemtype db field
272 ModItem({notforloan => 0, itype => $subscriptioninfos->{'previousitemtype'} }, undef, $itemnumber);
278 my @moditems = $query->multi_param('moditem');
279 if ( scalar(@moditems) ) {
280 my @tags = $query->multi_param('tag');
281 my @subfields = $query->multi_param('subfield');
282 my @field_values = $query->multi_param('field_value');
283 my @serials = $query->multi_param('serial');
284 my @bibnums = $query->multi_param('bibnum');
285 my @itemid = $query->multi_param('itemid');
286 my @ind_tag = $query->multi_param('ind_tag');
287 my @indicator = $query->multi_param('indicator');
289 #Rebuilding ALL the data for items into a hash
290 # parting them on $itemid.
293 my $range = scalar(@itemid);
294 for ( my $i = 0 ; $i < $range ; $i++ ) {
295 unless ( $itemhash{ $itemid[$i] } ) {
296 if ( $serials[$countdistinct]
297 && $serials[$countdistinct] ne "NEW" )
299 $itemhash{ $itemid[$i] }->{'serial'} =
300 $serials[$countdistinct];
303 $itemhash{ $itemid[$i] }->{'serial'} = $newserial;
305 $itemhash{ $itemid[$i] }->{'bibnum'} = $bibnums[$countdistinct];
308 push @{ $itemhash{ $itemid[$i] }->{'tags'} }, $tags[$i];
309 push @{ $itemhash{ $itemid[$i] }->{'subfields'} }, $subfields[$i];
310 push @{ $itemhash{ $itemid[$i] }->{'field_values'} },
312 push @{ $itemhash{ $itemid[$i] }->{'ind_tag'} }, $ind_tag[$i];
313 push @{ $itemhash{ $itemid[$i] }->{'indicator'} }, $indicator[$i];
315 foreach my $item ( keys %itemhash ) {
317 # Verify Itemization is "Valid", i.e. serial status is Arrived or Missing
319 for ( my $i = 0 ; $i < scalar(@serialids) ; $i++ ) {
321 $itemhash{$item}->{serial} eq $serialids[$i]
322 || ( $itemhash{$item}->{serial} == $newserial
323 && $serialids[$i] eq 'NEW' )
328 if ( $index >= 0 && $status[$index] == 2 ) {
329 my $xml = TransformHtmlToXml(
330 $itemhash{$item}->{'tags'},
331 $itemhash{$item}->{'subfields'},
332 $itemhash{$item}->{'field_values'},
333 $itemhash{$item}->{'indicator'},
334 $itemhash{$item}->{'ind_tag'}
338 my $bib_record = MARC::Record::new_from_xml( $xml, 'UTF-8' );
339 if ( $item =~ /^N/ ) {
343 # if autoBarcode is set to 'incremental', calculate barcode...
344 my ( $barcodetagfield, $barcodetagsubfield ) =
345 GetMarcFromKohaField(
348 $serialdatalist[0]->{'biblionumber'}
351 if ( C4::Context->preference('autoBarcode') eq
356 $bib_record->field($barcodetagfield)
357 && $bib_record->field($barcodetagfield)->subfield($barcodetagsubfield)
361 my $sth_barcode = $dbh->prepare(
362 'select max(abs(barcode)) from items');
363 $sth_barcode->execute;
364 my ($newbarcode) = $sth_barcode->fetchrow;
366 # OK, we have the new barcode, add the entry in MARC record # FIXME -> should be using barcode plugin here.
367 $bib_record->field($barcodetagfield)
368 ->update( $barcodetagsubfield => ++$newbarcode );
372 # check for item barcode # being unique
375 $bib_record->subfield(
376 $barcodetagfield, $barcodetagsubfield
380 $exists = GetItemnumberFromBarcode(
381 $bib_record->subfield(
382 $barcodetagfield, $barcodetagsubfield
387 # push @errors,"barcode_not_unique" if($exists);
388 # if barcode exists, don't create, but report The problem.
390 push @errors, 'barcode_not_unique';
391 push @errseq, { serialseq => $serialseqs[$index] };
394 my ( $biblionumber, $bibitemnum, $itemnumber ) =
395 AddItemFromMarc( $bib_record,
396 $itemhash{$item}->{bibnum} );
397 AddItem2Serial( $itemhash{$item}->{serial},
404 my ( $oldbiblionumber, $oldbibnum, $itemnumber ) =
405 ModItemFromMarc( $bib_record,
406 $itemhash{$item}->{'bibnum'}, $item );
414 $template->param( Errors => 1 );
416 $template->param( barcode_not_unique => 1, errseq => \@errseq );
420 my $redirect = 'serials-collection.pl?';
421 $redirect .= join( '&', map { 'subscriptionid=' . $_ } @subscriptionids );
422 print $query->redirect($redirect);
425 my $location = $serialdatalist[0]->{'location'};
426 my $default_bib_view = get_default_view();
429 serialsadditems => $serialdatalist[0]->{'serialsadditems'},
430 callnumber => $serialdatalist[0]->{'callnumber'},
431 internalnotes => $serialdatalist[0]->{'internalnotes'},
432 bibliotitle => $biblio->{'title'},
433 biblionumber => $serialdatalist[0]->{'biblionumber'},
434 serialslist => \@serialdatalist,
435 default_bib_view => $default_bib_view,
436 location => $location,
437 (uc(C4::Context->preference("marcflavour"))) => 1
440 output_html_with_http_headers $query, $cookie, $template->output;
442 sub get_default_view {
443 my $defaultview = C4::Context->preference('IntranetBiblioDefaultView');
444 my %views = C4::Search::enabled_staff_search_views();
445 if ( $defaultview eq 'isbd' && $views{can_view_ISBD} ) {
448 elsif ( $defaultview eq 'marc' && $views{can_view_MARC} ) {
451 elsif ( $defaultview eq 'labeled_marc' && $views{can_view_labeledMARC} ) {
452 return 'labeledMARCdetail';