acqui/parcel.pl

   1 #!/usr/bin/perl
   2
   3
   4 #script to recieve orders
   5 #written by chris@katipo.co.nz 24/2/2000
   6
   7
   8 # Copyright 2000-2002 Katipo Communications
   9 #
  10 # This file is part of Koha.
  11 #
  12 # Koha is free software; you can redistribute it and/or modify it under the
  13 # terms of the GNU General Public License as published by the Free Software
  14 # Foundation; either version 2 of the License, or (at your option) any later
  15 # version.
  16 #
  17 # Koha is distributed in the hope that it will be useful, but WITHOUT ANY
  18 # WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR
  19 # A PARTICULAR PURPOSE.  See the GNU General Public License for more details.
  20 #
  21 # You should have received a copy of the GNU General Public License along with
  22 # Koha; if not, write to the Free Software Foundation, Inc., 59 Temple Place,
  23 # Suite 330, Boston, MA  02111-1307 USA
  24
  25
  26 =head1 NAME
  27
  28 parcel.pl
  29
  30 =head1 DESCRIPTION
  31 This script shows all orders receipt or pending for a given supplier.
  32 It allows to write an order as 'received' when he arrives.
  33
  34 =head1 CGI PARAMETERS
  35
  36 =over 4
  37
  38 =item supplierid
  39 To know the supplier this script has to show orders.
  40
  41 =item code
  42 is the bookseller invoice number.
  43
  44 =item freight
  45
  46
  47 =item gst
  48
  49
  50 =item datereceived
  51 To filter the results list on this given date.
  52
  53 =back
  54
  55 =cut
  56
  57 use C4::Auth;
  58 use C4::Acquisition;
  59 use C4::Bookseller;
  60 use C4::Biblio;
  61 use CGI;
  62 use C4::Output;
  63 use C4::Date;
  64
  65 use strict;
  66
  67 my $input=new CGI;
  68 my $supplierid=$input->param('supplierid');
  69 my @booksellers=GetBookSeller($supplierid);
  70 my $count = scalar @booksellers;
  71
  72 my $invoice=$input->param('invoice') || '';
  73 my $freight=$input->param('freight');
  74 my $gst=$input->param('gst');
  75 my $datereceived=format_date_in_iso($input->param('datereceived')) || format_date(join "-",Date::Calc::Today());
  76 my $code=$input->param('code');
  77
  78 my ($template, $loggedinuser, $cookie)
  79     = get_template_and_user({template_name => "acqui/parcel.tmpl",
  80                  query => $input,
  81                  type => "intranet",
  82                  authnotrequired => 0,
  83                  flagsrequired => {acquisition => 1},
  84                  debug => 1,
  85 });
  86 my @parcelitems=GetParcel($supplierid,$invoice,$datereceived);
  87 my $countlines = scalar @parcelitems;
  88
  89 my $totalprice=0;
  90 my $totalfreight=0;
  91 my $totalquantity=0;
  92 my $total;
  93 my $tototal;
  94 my $toggle;
  95 my @loop_received = ();
  96 for (my $i=0;$i<$countlines;$i++){
  97     $total=($parcelitems[$i]->{'unitprice'} + $parcelitems[$i]->{'freight'}) * $parcelitems[$i]->{'quantityreceived'};   #weird, are the freight fees counted by book? (pierre)
  98     $parcelitems[$i]->{'unitprice'}+=0;
  99     my %line;
 100     if ($toggle==0){
 101         $line{color}='#EEEEEE';
 102         $toggle=1;
 103     } else {
 104             $line{color}='white';
 105             $toggle=0;
 106     }
 107     %line = %{$parcelitems[$i]};
 108     $line{invoice} = $invoice;
 109     $line{gst} = $gst;
 110     $line{total} = $total;
 111     $line{supplierid} = $supplierid;
 112     push @loop_received, \%line;
 113     $totalprice+=$parcelitems[$i]->{'unitprice'};
 114     $totalfreight+=$parcelitems[$i]->{'freight'};
 115     $totalquantity+=$parcelitems[$i]->{'quantityreceived'};
 116     $tototal+=$total;
 117 }
 118 my $pendingorders = GetPendingOrders($supplierid);
 119 my $countpendings = scalar @$pendingorders;
 120
 121 # pending orders totals
 122 my ($totalPunitprice,$totalPquantity,$totalPecost);
 123
 124 my @loop_orders = ();
 125 for (my $i=0;$i<$countpendings;$i++){
 126     my %line;
 127     if ($toggle==0){
 128         $line{color}='#EEEEEE';
 129         $toggle=1;
 130     } else {
 131             $line{color}='white';
 132             $toggle=0;
 133     }
 134     %line = %{$pendingorders->[$i]};
 135     $totalPunitprice += $line{unitprice};
 136     $totalPquantity +=$line{quantity};
 137     $totalPecost += $line{ecost};
 138     $line{ecost} = sprintf("%.2f",$line{ecost});
 139     $line{unitprice} = sprintf("%.2f",$line{unitprice});
 140     $line{invoice} = $invoice;
 141     $line{gst} = $gst;
 142     $line{total} = $total;
 143     $line{supplierid} = $supplierid;
 144     push @loop_orders, \%line;
 145 }
 146
 147 $totalfreight=$freight;
 148 $tototal=$tototal+$freight;
 149
 150 $template->param(invoice => $invoice,
 151                 datereceived => $datereceived,
 152                 formatteddatereceived => format_date($datereceived),
 153                 name => $booksellers[0]->{'name'},
 154                 supplierid => $supplierid,
 155                 gst => $gst,
 156                 freight => $freight,
 157                 invoice => $invoice,
 158                 countreceived => $countlines,
 159                 loop_received => \@loop_received,
 160                 countpending => $countpendings,
 161                 loop_orders => \@loop_orders,
 162                 totalprice => $totalprice,
 163                 totalfreight => $totalfreight,
 164                 totalquantity => $totalquantity,
 165                 tototal => $tototal,
 166                 gst => $gst,
 167                 grandtot => $tototal+$gst,
 168                 totalPunitprice => sprintf("%.2f",$totalPunitprice),
 169                 totalPquantity => $totalPquantity,
 170                 totalPecost => sprintf("%.2f",$totalPecost),
 171                 );
 172 output_html_with_http_headers $input, $cookie, $template->output;