X-Git-Url: http://git.rot13.org/?a=blobdiff_plain;f=acqui%2Flateorders-export.pl;h=585cac83c2e01ff16b0011ed17af985d3233d4e1;hb=43adbda007545b610b3a350f359ff019737fa51b;hp=f328eacadbb88b2d86473ac3d125433a4b19b845;hpb=fd2c751a86fad7a388c57fcd51746dbc4592c807;p=koha.git diff --git a/acqui/lateorders-export.pl b/acqui/lateorders-export.pl index f328eacadb..585cac83c2 100755 --- a/acqui/lateorders-export.pl +++ b/acqui/lateorders-export.pl @@ -2,63 +2,64 @@ # This file is part of Koha. # -# Koha is free software; you can redistribute it and/or modify it under the -# terms of the GNU General Public License as published by the Free Software -# Foundation; either version 2 of the License, or (at your option) any later -# version. +# Koha is free software; you can redistribute it and/or modify it +# under the terms of the GNU General Public License as published by +# the Free Software Foundation; either version 3 of the License, or +# (at your option) any later version. # -# Koha is distributed in the hope that it will be useful, but WITHOUT ANY -# WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR -# A PARTICULAR PURPOSE. See the GNU General Public License for more details. +# Koha is distributed in the hope that it will be useful, but +# WITHOUT ANY WARRANTY; without even the implied warranty of +# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the +# GNU General Public License for more details. # -# You should have received a copy of the GNU General Public License along -# with Koha; if not, write to the Free Software Foundation, Inc., -# 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA. +# You should have received a copy of the GNU General Public License +# along with Koha; if not, see . use Modern::Perl; use CGI; + use C4::Auth; -use C4::Serials; use C4::Acquisition; use C4::Output; use C4::Context; -use Text::CSV::Encoded; -use open qw/ :std :utf8 /; - -my $csv = Text::CSV::Encoded->new ({ - encoding => undef, - quote_char => '"', - escape_char => '"', - sep_char => ',', - binary => 1, - }); - -my $query = new CGI; -my @ordernumbers = $query->param('ordernumber'); - -print $query->header( - -type => 'text/csv', - -attachment => "lateorders.csv", -); - -print "LATE ORDERS\n\n"; -print "ORDER DATE,ESTIMATED DELIVERY DATE,VENDOR,INFORMATION,TOTAL COST,BASKET,CLAIMS COUNT,CLAIMED DATE\n"; +my $input = new CGI; +my ($template, $loggedinuser, $cookie) = get_template_and_user({ + template_name => "acqui/csv/lateorders.tt", + query => $input, + type => "intranet", + authnotrequired => 0, + flagsrequired => {acquisition => 'order_receive'}, +}); +my @ordernumbers = $input->param('ordernumber'); +my @orders; for my $ordernumber ( @ordernumbers ) { my $order = GetOrder $ordernumber; - $csv->combine( - "(" . $order->{supplierid} . ") " . $order->{orderdate} . " (" . $order->{latesince} . " days)", - $order->{estimateddeliverydate}, - $order->{supplier}, - $order->{title} . ( $order->{author} ? " Author: $order->{author}" : "" ) . ( $order->{publisher} ? " Published by: $order->{publisher}" : "" ), - $order->{unitpricesupplier} . "x" . $order->{quantity_to_receive} . " = " . $order->{subtotal} . " (" . $order->{budget} . ")", - $order->{basketname} . " (" . $order->{basketno} . ")", - $order->{claims_count}, - $order->{claimed_date} - ); - my $string = $csv->string; - print $string, "\n"; + push @orders, { + orderdate => $order->{orderdate}, + latesince => $order->{latesince}, + estimateddeliverydate => $order->{estimateddeliverydate}, + supplier => $order->{supplier}, + supplierid => $order->{supplierid}, + title => $order->{title}, + author => $order->{author}, + publisher => $order->{publisher}, + unitpricesupplier => $order->{unitpricesupplier}, + quantity_to_receive => $order->{quantity_to_receive}, + subtotal => $order->{subtotal}, + budget => $order->{budget}, + basketname => $order->{basketname}, + basketno => $order->{basketno}, + claims_count => $order->{claims_count}, + claimed_date => $order->{claimed_date}, + } + ; } -print ",,Total Number Late, " . scalar @ordernumbers . "\n"; +print $input->header( + -type => 'text/csv', + -attachment => 'lateorders.csv', +); +$template->param( orders => \@orders ); +print $template->output;