- my $subscription = GetSubscription($subscriptionid);
-
- my $sth = $dbh->prepare("SELECT publisheddate, serialid, serialseq, planneddate
- FROM serial WHERE status = 1 AND subscriptionid = ?");
- $sth->execute($subscriptionid);
-
- # modify actual expected issue, to generate the next
- if ( my $issue = $sth->fetchrow_hashref ) {
- ModSerialStatus( $issue->{serialid}, $issue->{serialseq},
- $issue->{planneddate}, $issue->{publisheddate},
- 3, "" );
- }else{
- my $expected = GetNextExpected($subscriptionid);
- my (
- $newserialseq, $newlastvalue1, $newlastvalue2, $newlastvalue3,
- $newinnerloop1, $newinnerloop2, $newinnerloop3
- ) = GetNextSeq($subscription);
-
- ## We generate the next publication date
- my $nextpublisheddate = GetNextDate( $expected->{planneddate}->output('iso'), $subscription );
- ## Creating the new issue
- NewIssue( $newserialseq, $subscriptionid, $subscription->{'biblionumber'},
- 1, $nextpublisheddate, $nextpublisheddate );
-
- ## Updating the subscription seq status
- my $squery = "UPDATE subscription SET lastvalue1=?, lastvalue2=?, lastvalue3=?, innerloop1=?, innerloop2=?, innerloop3=?
- WHERE subscriptionid = ?";
- $sth = $dbh->prepare($squery);
- $sth->execute(
- $newlastvalue1, $newlastvalue2, $newlastvalue3, $newinnerloop1,
- $newinnerloop2, $newinnerloop3, $subscriptionid
- );
-
- }
-
+ my $sth = $dbh->prepare("
+ SELECT publisheddate, publisheddatetext, serialid, serialseq,
+ planneddate, notes, routingnotes
+ FROM serial
+ WHERE status = 1 AND subscriptionid = ?
+ ");
+ my $status = defined( $nbissues ) ? 2 : 3;
+ $nbissues ||= 1;
+ for ( my $i = 0; $i < $nbissues; $i++ ){
+ $sth->execute($subscriptionid);
+ # modify actual expected issue, to generate the next
+ if ( my $issue = $sth->fetchrow_hashref ) {
+ my $planneddate = $date_received_today ? dt_from_string : $issue->{planneddate};
+ ModSerialStatus( $issue->{serialid}, $issue->{serialseq},
+ $planneddate, $issue->{publisheddate},
+ $issue->{publisheddatetext}, $status, "" );
+ } else {
+ require C4::Serials::Numberpattern;
+ my $subscription = GetSubscription($subscriptionid);
+ my $pattern = C4::Serials::Numberpattern::GetSubscriptionNumberpattern($subscription->{numberpattern});
+ my $frequency = C4::Serials::Frequency::GetSubscriptionFrequency($subscription->{periodicity});
+ my $expected = GetNextExpected($subscriptionid);
+ my (
+ $newserialseq, $newlastvalue1, $newlastvalue2, $newlastvalue3,
+ $newinnerloop1, $newinnerloop2, $newinnerloop3
+ ) = GetNextSeq($subscription, $pattern, $frequency, $expected->{publisheddate});
+
+ ## We generate the next publication date
+ my $nextpublisheddate = GetNextDate($subscription, $expected->{publisheddate}, $frequency, 1);
+ my $planneddate = $date_received_today ? dt_from_string : $nextpublisheddate;
+ ## Creating the new issue
+ NewIssue( $newserialseq, $subscriptionid, $subscription->{'biblionumber'},
+ 1, $planneddate, $nextpublisheddate, undef,
+ $issue->{notes}, $issue->{routingnotes} );
+
+ ## Updating the subscription seq status
+ my $squery = "UPDATE subscription SET lastvalue1=?, lastvalue2=?, lastvalue3=?, innerloop1=?, innerloop2=?, innerloop3=?
+ WHERE subscriptionid = ?";
+ my $seqsth = $dbh->prepare($squery);
+ $seqsth->execute(
+ $newlastvalue1, $newlastvalue2, $newlastvalue3, $newinnerloop1,
+ $newinnerloop2, $newinnerloop3, $subscriptionid
+ );
+
+ }
+ last if $nbissues == 1;
+ last if HasSubscriptionExpired($subscriptionid) > 0;
+ }