-
#!/usr/bin/perl
-# $Id$
-
-#script to recieve orders
+#script to receive orders
#written by chris@katipo.co.nz 24/2/2000
-
# Copyright 2000-2002 Katipo Communications
#
# This file is part of Koha.
# Koha; if not, write to the Free Software Foundation, Inc., 59 Temple Place,
# Suite 330, Boston, MA 02111-1307 USA
+=head1 NAME
+
+parcel.pl
+
+=head1 DESCRIPTION
+This script shows all orders receipt or pending for a given supplier.
+It allows to write an order as 'received' when he arrives.
+
+=head1 CGI PARAMETERS
+
+=over 4
+
+=item supplierid
+To know the supplier this script has to show orders.
+
+=item code
+is the bookseller invoice number.
+
+=item freight
+
+
+=item gst
+
+
+=item datereceived
+To filter the results list on this given date.
+
+=back
+
+=cut
+
use C4::Auth;
use C4::Acquisition;
+use C4::Bookseller;
use C4::Biblio;
-use C4::Output;
use CGI;
-use C4::Interface::CGI::Output;
-use C4::Database;
-use HTML::Template;
+use C4::Output;
+use C4::Dates qw/format_date format_date_in_iso/;
+
use strict;
-my $input=new CGI;
-my $supplierid=$input->param('supplierid');
-my ($count,@booksellers)=bookseller($supplierid);
-my $invoice=$input->param('code') || '';
-my $freight=$input->param('freight');
-my $gst=$input->param('gst');
-my $date=$input->param('datereceived');
-my $code=$input->param('code');
-
-my ($template, $loggedinuser, $cookie)
- = get_template_and_user({template_name => "acqui/parcel.tmpl",
- query => $input,
- type => "intranet",
- authnotrequired => 0,
- flagsrequired => {acquisition => 1},
- debug => 1,
-});
-
-my ($countlines,@parcelitems)=getparcelinformation($supplierid,$invoice,$date);
-my $totalprice=0;
-my $totalfreight=0;
-my $totalquantity=0;
+my $input = new CGI;
+my $supplierid = $input->param('supplierid');
+my $bookseller = GetBookSellerFromId($supplierid);
+
+my $invoice = $input->param('invoice') || '';
+my $freight = $input->param('freight');
+my $gst = $input->param('gst');
+my $datereceived =
+ ($input->param('op') eq 'new')
+ ? C4::Dates->new($input->param('datereceived'))
+ : C4::Dates->new($input->param('datereceived'), 'iso');
+$datereceived = C4::Dates->new() unless $datereceived;
+my $code = $input->param('code');
+my @rcv_err = $input->param('error');
+my @rcv_err_barcode = $input->param('error_bc');
+
+my ($template, $loggedinuser, $cookie) = get_template_and_user(
+ { template_name => "acqui/parcel.tmpl",
+ query => $input,
+ type => "intranet",
+ authnotrequired => 0,
+ flagsrequired => { acquisition => 1 },
+ debug => 1,
+ }
+);
+
+if($input->param('op') eq "delete" ){
+ if($input->param('biblionumber') and $input->param('ordernumber')){
+ DelOrder($input->param('biblionumber'), $input->param('ordernumber'));
+ print $input->redirect("/cgi-bin/koha/acqui/parcel.pl?supplierid=$supplierid&datereceived=" . $datereceived->output('iso'));
+ exit;
+ }
+}
+
+
+# If receiving error, report the error (coming from finishreceive.pl).
+if (scalar(@rcv_err)) {
+ my $cnt = 0;
+ my $error_loop;
+ for my $err (@rcv_err) {
+ push @$error_loop, { "error_$err" => 1, barcode => $rcv_err_barcode[$cnt] };
+ $cnt++;
+ }
+ $template->param(
+ receive_error => 1,
+ error_loop => $error_loop,
+ );
+}
+
+my $cfstr = "%.2f"; # currency format string -- could get this from currency table.
+my @parcelitems = GetParcel($supplierid, $invoice, $datereceived->output('iso'));
+my $countlines = scalar @parcelitems;
+my $totalprice = 0;
+my $totalfreight = 0;
+my $totalquantity = 0;
my $total;
my $tototal;
-my $toggle;
my @loop_received = ();
-for (my $i=0;$i<$countlines;$i++){
- $total=($parcelitems[$i]->{'unitprice'} + $parcelitems[$i]->{'freight'}) * $parcelitems[$i]->{'quantityreceived'}; #weird, are the freight fees counted by book? (pierre)
- $parcelitems[$i]->{'unitprice'}+=0;
+
+for (my $i = 0 ; $i < $countlines ; $i++) {
+
+ #$total=($parcelitems[$i]->{'unitprice'} + $parcelitems[$i]->{'freight'}) * $parcelitems[$i]->{'quantityreceived'}; #weird, are the freight fees counted by book? (pierre)
+ $total = ($parcelitems[$i]->{'unitprice'}) * $parcelitems[$i]->{'quantityreceived'}; #weird, are the freight fees counted by book? (pierre)
+ $parcelitems[$i]->{'unitprice'} += 0;
my %line;
- if ($toggle==0){
- $line{color}='#EEEEEE';
- $toggle=1;
-} else {
- $line{color}='white';
- $toggle=0;
-}
- $line{basketno} = $parcelitems[$i]->{'basketno'};
- $line{isbn} = $parcelitems[$i]->{'isbn'};
- $line{ordernumber} = $parcelitems[$i]->{'ordernumber'};
- $line{biblionumber} = $parcelitems[$i]->{'biblionumber'};
+ %line = %{ $parcelitems[$i] };
$line{invoice} = $invoice;
- $line{gst} = $gst;
- $line{title} = $parcelitems[$i]->{'title'};
- $line{author} = $parcelitems[$i]->{'author'};
- $line{unitprice} = $parcelitems[$i]->{'unitprice'};
- $line{ecost} = $parcelitems[$i]->{'ecost'};
- $line{quantityrecieved} = $parcelitems[$i]->{'quantityreceived'};
- $line{quantity} = $parcelitems[$i]->{'quantity'};
- $line{total} = $total;
+ $line{gst} = $gst;
+ $line{total} = sprintf($cfstr, $total);
$line{supplierid} = $supplierid;
push @loop_received, \%line;
- $totalprice+=$parcelitems[$i]->{'unitprice'};
- $totalfreight+=$parcelitems[$i]->{'freight'};
- $totalquantity+=$parcelitems[$i]->{'quantityreceived'};
- $tototal+=$total;
+ $totalprice += $parcelitems[$i]->{'unitprice'};
+ $line{unitprice} = sprintf($cfstr, $parcelitems[$i]->{'unitprice'});
+
+ #double FIXME - totalfreight is redefined later.
+
+# FIXME - each order in a parcel holds the freight for the whole parcel. This means if you receive a parcel with items from multiple budgets, you'll see the freight charge in each budget..
+ if ($i > 0 && $totalfreight != $parcelitems[$i]->{'freight'}) {
+ warn "FREIGHT CHARGE MISMATCH!!";
+ }
+ $totalfreight = $parcelitems[$i]->{'freight'};
+ $totalquantity += $parcelitems[$i]->{'quantityreceived'};
+ $tototal += $total;
}
-my ($countpendings,@pendingorders)=getallorders($supplierid);
+
+my $pendingorders = GetPendingOrders($supplierid, "", 1);
+my $countpendings = scalar @$pendingorders;
+
+# pending orders totals
+my ($totalPunitprice, $totalPquantity, $totalPecost, $totalPqtyrcvd);
+my $ordergrandtotal;
my @loop_orders = ();
-for (my $i=0;$i<$countpendings;$i++){
+for (my $i = 0 ; $i < $countpendings ; $i++) {
my %line;
- if ($toggle==0){
- $line{color}='#EEEEEE';
- $toggle=1;
-} else {
- $line{color}='white';
- $toggle=0;
-}
- $line{basketno} = $pendingorders[$i]->{'basketno'};
- $line{isbn} = $pendingorders[$i]->{'isbn'};
- $line{ordernumber} = $pendingorders[$i]->{'ordernumber'};
- $line{biblionumber} = $pendingorders[$i]->{'biblionumber'};
- $line{invoice} = $invoice;
- $line{gst} = $gst;
- $line{title} = $pendingorders[$i]->{'title'};
- $line{author} = $pendingorders[$i]->{'author'};
- $line{unitprice} = $pendingorders[$i]->{'unitprice'};
- $line{ecost} = $pendingorders[$i]->{'ecost'};
- $line{quantityrecieved} = $pendingorders[$i]->{'quantityreceived'};
- $line{quantity} = $pendingorders[$i]->{'quantity'};
- $line{total} = $total;
+ %line = %{ $pendingorders->[$i] };
+ $line{quantity} += 0;
+ $line{quantityreceived} += 0;
+ $line{unitprice} += 0;
+ $totalPunitprice += $line{unitprice};
+ $totalPquantity += $line{quantity};
+ $totalPqtyrcvd += $line{quantityreceived};
+ $totalPecost += $line{ecost};
+ $line{ecost} = sprintf("%.2f", $line{ecost});
+ $line{ordertotal} = sprintf("%.2f", $line{ecost} * $line{quantity});
+ $line{unitprice} = sprintf("%.2f", $line{unitprice});
+ $line{invoice} = $invoice;
+ $line{gst} = $gst;
+ $line{total} = $total;
$line{supplierid} = $supplierid;
+ $ordergrandtotal += $line{ecost} * $line{quantity};
push @loop_orders, \%line;
}
+$freight = $totalfreight unless $freight;
+
+#$totalfreight=$freight;
+$tototal = $tototal + $freight;
-$totalfreight=$freight;
-$tototal=$tototal+$freight;
-
-$template->param(invoice => $invoice,
- date => $date,
- name => $booksellers[0]->{'name'},
- supplierid => $supplierid,
- gst => $gst,
- freight => $freight,
- invoice => $invoice,
- countreceived => $countlines,
- loop_received => \@loop_received,
- countpending => $countpendings,
- loop_orders => \@loop_orders,
- totalprice => $totalprice,
- totalfreight => $totalfreight,
- totalquantity => $totalquantity,
- tototal => $tototal,
- gst => $gst,
- grandtot => $tototal+$gst,
- intranetcolorstylesheet => C4::Context->preference("intranetcolorstylesheet"),
- intranetstylesheet => C4::Context->preference("intranetstylesheet"),
- IntranetNav => C4::Context->preference("IntranetNav"),
- );
+$template->param(
+ invoice => $invoice,
+ datereceived => $datereceived->output('iso'),
+ invoicedatereceived => $datereceived->output('iso'),
+ formatteddatereceived => $datereceived->output(),
+ name => $bookseller->{'name'},
+ supplierid => $supplierid,
+ gst => $gst,
+ freight => $freight,
+ invoice => $invoice,
+ countreceived => $countlines,
+ loop_received => \@loop_received,
+ countpending => $countpendings,
+ loop_orders => \@loop_orders,
+ totalprice => sprintf($cfstr, $totalprice),
+ totalfreight => $totalfreight,
+ totalquantity => $totalquantity,
+ tototal => sprintf($cfstr, $tototal),
+ ordergrandtotal => sprintf($cfstr, $ordergrandtotal),
+ gst => $gst,
+ grandtot => sprintf($cfstr, $tototal + $gst),
+ totalPunitprice => sprintf("%.2f", $totalPunitprice),
+ totalPquantity => $totalPquantity,
+ totalPqtyrcvd => $totalPqtyrcvd,
+ totalPecost => sprintf("%.2f", $totalPecost),
+);
output_html_with_http_headers $input, $cookie, $template->output;
projects / koha.git / blobdiff