3 # Copyright 2008 SARL Biblibre
5 # This file is part of Koha.
7 # Koha is free software; you can redistribute it and/or modify it under the
8 # terms of the GNU General Public License as published by the Free Software
9 # Foundation; either version 2 of the License, or (at your option) any later
12 # Koha is distributed in the hope that it will be useful, but WITHOUT ANY
13 # WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR
14 # A PARTICULAR PURPOSE. See the GNU General Public License for more details.
16 # You should have received a copy of the GNU General Public License along
17 # with Koha; if not, write to the Free Software Foundation, Inc.,
18 # 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA.
25 # find Koha's Perl modules
26 # test carefully before changing this
28 eval { require "$FindBin::Bin/../kohalib.pl" };
32 use C4
::Dates qw
/format_date format_date_in_iso/;
36 use Date
::Calc qw
/Date_to_Days check_date/;
42 serialsUpdate.pl - change status of serial issues that are late
46 serialsUpdate.pl [ -h | -m ][ -v ] -c ][ --note "you are late" ][ --no-note ]
49 --h --help -? Brief help message
50 --man Full documentation
51 --verbose -v Verbose mode
52 -c Confirm: without this option, the script will report on affected serial
53 issues without modifying database
54 --note Note set on affected serial issues, by default "Automatically set to late"
55 --no-note Do not set a note on affected serial issues
59 my $dbh = C4
::Context
->dbh;
71 'v|verbose' => \
$verbose,
74 'no-note' => \
$nonote,
77 pod2usage
(1) if $help;
78 pod2usage
( -verbose
=> 2 ) if $man;
80 $verbose and !$confirm and print "### Database will not be modified ###\n";
82 if ( $note && $nonote ) {
85 if ( !$note && !$nonote ) {
86 $note = 'Automatically set to late';
88 $verbose and print $note ?
"Note : $note\n" : "No note\n";
90 # select all serials with not "irregular" periodicity that are late
91 my $sth = $dbh->prepare(
98 subscription.subscriptionid
100 LEFT JOIN subscription
101 ON (subscription.subscriptionid=serial.subscriptionid)
102 WHERE serial.status = 1
103 AND periodicity <> 32
104 AND DATE_ADD(planneddate, INTERVAL CAST(graceperiod AS SIGNED) DAY) < NOW()
105 AND subscription.closed = 0
110 while ( my $issue = $sth->fetchrow_hashref ) {
112 my $subscription = &GetSubscription
( $issue->{subscriptionid
} );
113 my $planneddate = $issue->{planneddate
};
115 if ( $subscription && $planneddate && $planneddate ne "0000-00-00" ) {
116 my $nextpublisheddate = GetNextDate
( $planneddate, $subscription );
117 my $today = format_date_in_iso
( C4
::Dates
->new()->output() );
119 if ( $nextpublisheddate && $today ) {
120 my ( $year, $month, $day ) = split( /-/, $nextpublisheddate );
121 my ( $tyear, $tmonth, $tday ) = split( /-/, $today );
122 if ( check_date
( $year, $month, $day )
123 && check_date
( $tyear, $tmonth, $tday )
124 && Date_to_Days
( $year, $month, $day ) <
125 Date_to_Days
( $tyear, $tmonth, $tday ) )
128 and ModSerialStatus
( $issue->{serialid
}, $issue->{serialseq
},
129 $issue->{planneddate
}, $issue->{publisheddate
},
132 and print "Serial issue with id=" . $issue->{serialid
} . " updated\n";
137 and print "Error with serial("
139 . ") has no existent subscription("
140 . $issue->{subscriptionid
}
141 . ") attached or planneddate is wrong\n";