Bug 13669: followup to add DBIx::RunSQL dependency
[koha.git] / acqui / lateorders.pl
blob872d0af18b1b7b5c55788d549111a005226fd98d
1 #!/usr/bin/perl
4 # Copyright 2005 Biblibre
5 # This file is part of Koha.
7 # Koha is free software; you can redistribute it and/or modify it
8 # under the terms of the GNU General Public License as published by
9 # the Free Software Foundation; either version 3 of the License, or
10 # (at your option) any later version.
12 # Koha is distributed in the hope that it will be useful, but
13 # WITHOUT ANY WARRANTY; without even the implied warranty of
14 # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
15 # GNU General Public License for more details.
17 # You should have received a copy of the GNU General Public License
18 # along with Koha; if not, see <http://www.gnu.org/licenses>.
20 =head1 NAME
22 lateorders.pl
24 =head1 DESCRIPTION
26 this script shows late orders for a specific supplier, branch and delay
27 given on input arg.
29 =head1 CGI PARAMETERS
31 =over 4
33 =item booksellerid
34 To know on which supplier this script have to display late order.
36 =item delay
37 To know the time boundary. Default value is 30 days.
39 =item branch
40 To know on which branch this script have to display late order.
42 =back
44 =cut
46 use Modern::Perl;
47 use CGI qw ( -utf8 );
48 use C4::Bookseller qw( GetBooksellersWithLateOrders );
49 use C4::Auth;
50 use C4::Koha;
51 use C4::Output;
52 use C4::Context;
53 use C4::Acquisition;
54 use C4::Letters;
55 use C4::Branch; # GetBranches
56 use Koha::DateUtils;
58 my $input = new CGI;
59 my ($template, $loggedinuser, $cookie) = get_template_and_user(
61 template_name => "acqui/lateorders.tt",
62 query => $input,
63 type => "intranet",
64 authnotrequired => 0,
65 flagsrequired => { acquisition => 'order_receive' },
66 debug => 1,
70 my $booksellerid = $input->param('booksellerid') || undef; # we don't want "" or 0
71 my $delay = $input->param('delay') // 0;
73 # Get the "date from" param if !defined is today
74 my $estimateddeliverydatefrom = $input->param('estimateddeliverydatefrom');
75 my $estimateddeliverydateto = $input->param('estimateddeliverydateto');
77 my $estimateddeliverydatefrom_dt =
78 $estimateddeliverydatefrom
79 ? dt_from_string($estimateddeliverydatefrom)
80 : undef;
82 # Get the "date to" param. If it is not defined and $delay is not defined too, it is the today's date.
83 my $estimateddeliverydateto_dt = $estimateddeliverydateto
84 ? dt_from_string($estimateddeliverydateto)
85 : ( not defined $delay and not defined $estimateddeliverydatefrom)
86 ? dt_from_string()
87 : undef;
89 # Format the output of "date from" and "date to"
90 if ($estimateddeliverydatefrom_dt) {
91 $estimateddeliverydatefrom = output_pref({dt => $estimateddeliverydatefrom_dt, dateonly => 1});
93 if ($estimateddeliverydateto_dt) {
94 $estimateddeliverydateto = output_pref({dt => $estimateddeliverydateto_dt, dateonly => 1});
97 my $branch = $input->param('branch');
98 my $op = $input->param('op');
100 my @errors = ();
101 if ( $delay and not $delay =~ /^\d{1,3}$/ ) {
102 push @errors, {delay_digits => 1, bad_delay => $delay};
105 if ($op and $op eq "send_alert"){
106 my @ordernums = $input->multi_param("ordernumber");# FIXME: Fallback values?
107 my $err;
108 eval {
109 $err = SendAlerts( 'claimacquisition', \@ordernums, $input->param("letter_code") ); # FIXME: Fallback value?
110 if ( not ref $err or not exists $err->{error} ) {
111 AddClaim ( $_ ) for @ordernums;
115 if ( $@ ) {
116 $template->param(error_claim => $@);
117 } elsif ( ref $err and exists $err->{error} and $err->{error} eq "no_email" ) {
118 $template->{VARS}->{'error_claim'} = "no_email";
119 } elsif ( ref $err and exists $err->{error} and $err->{error} eq "no_order_seleted"){
120 $template->{VARS}->{'error_claim'} = "no_order_seleted";
121 } else {
122 $template->{VARS}->{'info_claim'} = 1;
126 my @parameters = ( $delay );
127 push @parameters, $estimateddeliverydatefrom_dt
128 ? $estimateddeliverydatefrom_dt->ymd()
129 : undef;
131 push @parameters, $estimateddeliverydateto_dt
132 ? $estimateddeliverydateto_dt->ymd()
133 : undef;
135 my %supplierlist = GetBooksellersWithLateOrders(@parameters);
137 my (@sloopy); # supplier loop
138 foreach (keys %supplierlist){
139 push @sloopy, (($booksellerid and $booksellerid eq $_ ) ?
140 {id=>$_, name=>$supplierlist{$_}, selected=>1} :
141 {id=>$_, name=>$supplierlist{$_}} ) ;
143 $template->param(SUPPLIER_LOOP => \@sloopy);
145 $template->param(Supplier=>$supplierlist{$booksellerid}) if ($booksellerid);
146 $template->param(booksellerid=>$booksellerid) if ($booksellerid);
148 @parameters =
149 ( $delay, $booksellerid, $branch );
150 if ($estimateddeliverydatefrom_dt) {
151 push @parameters, $estimateddeliverydatefrom_dt->ymd();
153 else {
154 push @parameters, undef;
156 if ($estimateddeliverydateto_dt) {
157 push @parameters, $estimateddeliverydateto_dt->ymd();
159 my @lateorders = GetLateOrders( @parameters );
161 my $total;
162 foreach (@lateorders){
163 $total += $_->{subtotal};
166 my $letters = GetLetters({ module => "claimacquisition" });
168 $template->param(ERROR_LOOP => \@errors) if (@errors);
169 $template->param(
170 lateorders => \@lateorders,
171 delay => $delay,
172 letters => $letters,
173 estimateddeliverydatefrom => $estimateddeliverydatefrom,
174 estimateddeliverydateto => $estimateddeliverydateto,
175 total => $total,
176 intranetcolorstylesheet => C4::Context->preference("intranetcolorstylesheet"),
178 output_html_with_http_headers $input, $cookie, $template->output;