Add a UNIMARC to Dublin Core XSL
[koha.git] / acqui / parcel.pl
index 0a1feec..e6fa893 100755 (executable)
@@ -60,32 +60,49 @@ use C4::Bookseller;
 use C4::Biblio;
 use CGI;
 use C4::Output;
-use C4::Date;
+use C4::Dates qw/format_date format_date_in_iso/;
 
 use strict;
 
 my $input=new CGI;
 my $supplierid=$input->param('supplierid');
-my @booksellers=GetBookSeller($supplierid);
-my $count = scalar @booksellers;
+my $bookseller=GetBookSellerFromId($supplierid);
 
 my $invoice=$input->param('invoice') || '';
 my $freight=$input->param('freight');
 my $gst=$input->param('gst');
-my $datereceived=format_date_in_iso($input->param('datereceived')) || format_date(join "-",Date::Calc::Today());
+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",
+                                type => "intranet",
                  authnotrequired => 0,
                  flagsrequired => {acquisition => 1},
                  debug => 1,
 });
-my @parcelitems=GetParcel($supplierid,$invoice,$datereceived);
-my $countlines = scalar @parcelitems;
 
+# If receiving error, report the error (coming from finishrecieve.pl(sic)).
+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;
@@ -94,8 +111,9 @@ 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;
+    #$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';
@@ -107,20 +125,28 @@ for (my $i=0;$i<$countlines;$i++){
     %line = %{$parcelitems[$i]};
     $line{invoice} = $invoice;
     $line{gst} = $gst;
-    $line{total} = $total;
+    $line{total} = sprintf($cfstr,$total);
     $line{supplierid} = $supplierid;
     push @loop_received, \%line;
     $totalprice+=$parcelitems[$i]->{'unitprice'};
-    $totalfreight+=$parcelitems[$i]->{'freight'};
+       $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 $pendingorders = GetPendingOrders($supplierid);
 my $countpendings = scalar @$pendingorders;
 
 # pending orders totals
-my ($totalPunitprice,$totalPquantity,$totalPecost);
-
+my ($totalPunitprice,$totalPquantity,$totalPecost, $totalPqtyrcvd);
+my $ordergrandtotal;
 my @loop_orders = ();
 for (my $i=0;$i<$countpendings;$i++){
     my %line;
@@ -132,25 +158,32 @@ for (my $i=0;$i<$countpendings;$i++){
             $toggle=0;
     }
     %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;
 }
-
-$totalfreight=$freight;
+$freight = $totalfreight unless $freight;
+#$totalfreight=$freight;
 $tototal=$tototal+$freight;
 
 $template->param(invoice => $invoice,
-                datereceived => $datereceived,
-                formatteddatereceived => format_date($datereceived),
-                name => $booksellers[0]->{'name'},
+                datereceived => $datereceived->output('iso'),
+                invoicedatereceived => $datereceived->output('iso'), 
+                formatteddatereceived => $datereceived->output(),
+                name => $bookseller->{'name'},
                 supplierid => $supplierid,
                 gst => $gst,
                 freight => $freight,
@@ -159,14 +192,16 @@ $template->param(invoice => $invoice,
                 loop_received => \@loop_received,
                 countpending => $countpendings,
                 loop_orders => \@loop_orders,
-                totalprice => $totalprice,
+                totalprice => sprintf($cfstr,$totalprice),
                 totalfreight => $totalfreight,
                 totalquantity => $totalquantity,
-                tototal => $tototal,
+                tototal => sprintf($cfstr,$tototal),
+                ordergrandtotal => sprintf($cfstr,$ordergrandtotal),
                 gst => $gst,
-                grandtot => $tototal+$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;