4 # This file is part of Koha.
6 # Koha is free software; you can redistribute it and/or modify it
7 # under the terms of the GNU General Public License as published by
8 # the Free Software Foundation; either version 3 of the License, or
9 # (at your option) any later version.
11 # Koha is distributed in the hope that it will be useful, but
12 # WITHOUT ANY WARRANTY; without even the implied warranty of
13 # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
14 # GNU General Public License for more details.
16 # You should have received a copy of the GNU General Public License
17 # along with Koha; if not, see <http://www.gnu.org/licenses>.
26 This script check what subscription will expire before C<$datenumber $datelimit>
33 To filter subscription on title
36 To filter subscription on issn
39 The date to filter on.
49 use C4::Serials; # GetExpirationDate
53 use C4::Dates qw/format_date format_date_in_iso/;
54 use Date::Calc qw/Today Date_to_Days/;
58 my ( $template, $loggedinuser, $cookie, $flags ) = get_template_and_user (
60 template_name => "serials/checkexpiration.tt",
64 flagsrequired => { serials => 'check_expiration' },
69 my $title = $query->param('title');
70 my $issn = $query->param('issn');
71 my $branch = $query->param('branch');
72 my $date = format_date_in_iso($query->param('date'));
75 my @subscriptions = SearchSubscriptions({ title => $title, issn => $issn, orderby => 'title' });
76 my @subscriptions_loop;
78 foreach my $subscription ( @subscriptions ) {
79 my $subscriptionid = $subscription->{'subscriptionid'};
80 my $expirationdate = GetExpirationDate($subscriptionid);
81 $subscription->{expirationdate} = $expirationdate;
82 next if $expirationdate !~ /\d{4}-\d{2}-\d{2}/; # next if not in ISO format.
83 next if $subscription->{closed};
84 if ( ( ref $flags->{serials} and $flags->{serials}->{superserials} )
85 or ( !ref $flags->{serials} and $flags->{serials} == 1 ) )
87 $subscription->{cannotedit} = 0;
89 next if $subscription->{cannotedit};
90 if ( Date_to_Days(split "-",$expirationdate) < Date_to_Days(split "-",$date) &&
91 Date_to_Days(split "-",$expirationdate) > Date_to_Days(&Today) &&
92 ( !$branch || ($subscription->{'branchcode'} eq $branch) ) ) {
93 $subscription->{expirationdate}=format_date($subscription->{expirationdate});
94 push @subscriptions_loop,$subscription;
101 numsubscription => scalar @subscriptions_loop,
102 date => format_date($date),
103 subscriptions_loop => \@subscriptions_loop,
104 "BiblioDefaultView".C4::Context->preference("BiblioDefaultView") => 1,
110 if ( C4::Context->IsSuperLibrarian()
111 or ( ref $flags->{serials} and $flags->{serials}->{superserials} )
112 or ( !ref $flags->{serials} and $flags->{serials} == 1 ) )
114 $branches_loop = C4::Branch::GetBranchesLoop( $branch );
118 (uc(C4::Context->preference("marcflavour"))) => 1,
119 branches_loop => $branches_loop,
122 output_html_with_http_headers $query, $cookie, $template->output;