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.
47 use C4::Auth qw( get_template_and_user );
48 use C4::Serials qw( SearchSubscriptions GetExpirationDate );
49 use C4::Output qw( output_html_with_http_headers );
51 use Koha::DateUtils qw( dt_from_string );
57 my ( $template, $loggedinuser, $cookie, $flags ) = get_template_and_user (
59 template_name => "serials/checkexpiration.tt",
62 flagsrequired => { serials => 'check_expiration' },
66 my $title = $query->param('title');
67 my $issn = $query->param('issn');
68 my $branch = $query->param('branch');
69 my $date = $query->param('date');
70 $date = eval { dt_from_string( scalar $query->param('date') ) } if $date;
71 my $showhistoricexpired = $query->param('showhistoricexpired');
74 my @subscriptions = SearchSubscriptions({ title => $title, issn => $issn, orderby => 'title' });
75 my @subscriptions_loop;
77 foreach my $subscription ( @subscriptions ) {
78 my $subscriptionid = $subscription->{'subscriptionid'};
79 my $expirationdate = GetExpirationDate($subscriptionid);
81 $subscription->{expirationdate} = $expirationdate;
83 next if $expirationdate !~ /\d{4}-\d{2}-\d{2}/; # next if not in ISO format.
85 next if $subscription->{closed};
86 if ( !C4::Context->preference("IndependentBranches")
87 or C4::Context->IsSuperLibrarian()
88 or ( ref $flags->{serials} and $flags->{serials}->{superserials} )
89 or ( !ref $flags->{serials} and $flags->{serials} == 1 ) )
91 $subscription->{cannotedit} = 0;
93 next if $subscription->{cannotedit};
95 my $expirationdate_dt = dt_from_string( $expirationdate, 'iso' );
96 my $today_dt = dt_from_string();
97 if ( DateTime->compare( $date, $expirationdate_dt ) == 1
98 && ( $showhistoricexpired || DateTime->compare( $expirationdate_dt, $today_dt ) == 1 )
99 && ( !$branch || ( $subscription->{'branchcode'} eq $branch ) ) ) {
100 push @subscriptions_loop, $subscription;
107 showhistoricexpired => $showhistoricexpired,
108 numsubscription => scalar @subscriptions_loop,
110 subscriptions_loop => \@subscriptions_loop,
115 my $can_change_library;;
116 if ( !C4::Context->preference("IndependentBranches")
117 or C4::Context->IsSuperLibrarian()
118 or ( ref $flags->{serials} and $flags->{serials}->{superserials} )
119 or ( !ref $flags->{serials} and $flags->{serials} == 1 ) )
121 $can_change_library = 1;
125 (uc(C4::Context->preference("marcflavour"))) => 1,
126 can_change_library => $can_change_library,
130 output_html_with_http_headers $query, $cookie, $template->output;