Bug 18736: Use rounding syspref to determine correct prices in calculations
[koha.git] / acqui / finishreceive.pl
index 0fd4d13..90faed3 100755 (executable)
 #script to add a new item and to mark orders as received
 #written 1/3/00 by chris@katipo.co.nz
 
+# Copyright 2000-2002 Katipo Communications
+#
+# 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 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.
+#
+# You should have received a copy of the GNU General Public License
+# along with Koha; if not, see <http://www.gnu.org/licenses>.
+
+use Modern::Perl;
+use CGI qw ( -utf8 );
+use C4::Auth;
 use C4::Output;
-use C4::Acquisitions;
-use CGI;
+use C4::Context;
+use C4::Acquisition;
+use C4::Biblio;
+use C4::Items;
 use C4::Search;
 
+use Koha::Number::Price;
+use Koha::Acquisition::Booksellers;
+use Koha::Acquisition::Orders;
+
+use List::MoreUtils qw/any/;
+
 my $input=new CGI;
-#print $input->header;
-
-my $user=$input->remote_user;
-#print $input->dump;
-my $biblionumber = $input->param('biblio');
-my $ordnum=$input->param('ordnum');
-my $quantrec=$input->param('quantityrec');
-my $quantity=$input->param('quantity');
-my $notes=$input->param('notes');
-my $cost=$input->param('cost');
-my $invoiceno=$input->param('invoice');
-my $bibitemno=$input->param('biblioitemnum');
-my $data=bibitemdata($bibitemno);
-my $publisher=$data->{'publishercode'};
-my $pubdate=$data->{'publicationdate'};
-my $class=$data->{'classification'};
-my $dewey=$data->{'dewey'};
-my $subclass=$data->{'subclass'};
-
-my $size=$data->{'size'};
-my $illus=$data->{'illus'};
-my $pages=$data->{'pages'};
-my $replacement=$input->param('rrp');
-my $branch=$input->param('branch');
-my $bookfund=$input->param('bookfund');
-my $itemtype=$input->param('format');
-my $isbn=$input->param('ISBN');
-my $bookseller = $input->param('bookseller');
-my $id         = $bookseller;
-my $biblio = {
-    biblionumber  => $biblionumber,
-    title         => $input->param('title')?$input->param('title'):"",
-    author        => $input->param('author')?$input->param('author'):"",
-    copyrightdate => $input->param('copyright')?$input->param('copyright'):"",
-    series        => $input->param('Series')?$input->param('Series'):""
-}; # my $biblio
-
-if ($quantrec != 0){
-  $cost=$cost / $quantrec;
-}
+my $flagsrequired = {acquisition => 'order_receive'};
 
-my $gst=$input->param('gst');
-my $freight=$input->param('freight');
-my $volinf=$input->param('volinf');
-my $loan=0;
-if ($itemtype =~ /REF/){
-  $loan=1;
-}
+checkauth($input, 0, $flagsrequired, 'intranet');
 
-if ($itemtype =~ /PER/){
-#  print "$bibitemno";
-  $class="Periodical";
-  $bibitemno = &newbiblioitem({
-      biblionumber   => $biblionumber,
-      itemtype       => $itemtype?$itemtype:"",
-      isbn           => $isbn?$isbn:"",
-      volumeddesc    => $volinf?$volinf:"",
-      classification => $class?$class:"" });
-#  print "here $bibitemno";
+my $user             = $input->remote_user;
+my $biblionumber     = $input->param('biblionumber');
+my $ordernumber      = $input->param('ordernumber');
+my $origquantityrec  = $input->param('origquantityrec');
+my $quantityrec      = $input->param('quantityrec');
+my $quantity         = $input->param('quantity');
+my $unitprice        = $input->param('unitprice');
+my $replacementprice = $input->param('replacementprice');
+my $datereceived     = $input->param('datereceived'),
+my $invoiceid        = $input->param('invoiceid');
+my $invoice          = GetInvoice($invoiceid);
+my $invoiceno        = $invoice->{invoicenumber};
+my $booksellerid     = $input->param('booksellerid');
+my $cnt              = 0;
+my $bookfund         = $input->param("bookfund");
+my $order            = GetOrder($ordernumber);
+my $new_ordernumber  = $ordernumber;
+
+#bug18723 regression fix
+if (C4::Context->preference("CurrencyFormat") eq 'FR') {
+    if (rindex($unitprice, '.') ge 0) {
+        substr($unitprice, rindex($unitprice, '.'), 1, ',');
+    }
+    if (rindex($replacementprice,'.') ge 0) {
+        substr($replacementprice, rindex($replacementprice, '.'), 1, ',');
+    }
 }
-if ($quantity != 0){
-  receiveorder($biblionumber,$ordnum,$quantrec,$user,$cost,$invoiceno,$bibitemno,$freight,$bookfund);
-  modbiblio($biblio);
-  &modbibitem({
-      biblioitemnumber => $bibitemno,
-      itemtype         => $itemtype?$itemtype:"",
-      isbn             => $isbn?$isbn:"",
-      publisher        => $publisher?$publisher:"",
-      publicationyear  => $pubdate?$pubdate:"",
-      class            => $class?$class:"",
-      dewey            => $dewey?$dewey:"",
-      subclass         => $subclass?$subclass:"",
-      illus            => $illus?$illus:"",
-      pages            => $pages?$pages:"",
-      volumeddesc      => $volinf?$volinf:"",
-      notes            => $notes?$notes:"",
-      size             => $size?$size:"" });
-
-  my $barcode=$input->param('barcode');
-  my @barcodes;
-  if ($barcode =~ /\,/){
-    @barcodes=split(/\,/,$barcode);
-  }elsif ($barcode =~ /\|/){
-    @barcodes=split(/\|/,$barcode);
-  } else {
-    $barcodes[0]=$barcode;
-  #  print $input->header;
-  #  print @barcodes;
-  #  print $barcode;
-  }
-  my ($error) = newitems({ biblioitemnumber => $bibitemno,
-                          biblionumber     => $biblionumber,
-                          replacementprice => $replacement,
-                          price            => $cost,
-                          booksellerid     => $bookseller,
-                          homebranch       => $branch,
-                          loan             => $loan },
-                        @barcodes);
-  if ($error eq ''){
-    if ($itemtype ne 'PER'){
-      print $input->redirect("/cgi-bin/koha/acqui/receive.pl?invoice=$invoiceno&id=$id&freight=$freight&gst=$gst");
-    } else {
-      print $input->redirect("/acquisitions/");
+
+$unitprice = Koha::Number::Price->new( $unitprice )->unformat();
+$replacementprice = Koha::Number::Price->new( $replacementprice )->unformat();
+my $order_obj = Koha::Acquisition::Orders->find( $ordernumber );
+my $basket = $order_obj->basket;
+
+#need old receivedate if we update the order, parcel.pl only shows the right parcel this way FIXME
+if ($quantityrec > $origquantityrec ) {
+    my @received_items = ();
+    if ($basket->effective_create_items eq 'ordering') {
+        @received_items = $input->param('items_to_receive');
+        my @affects = split q{\|}, C4::Context->preference("AcqItemSetSubfieldsWhenReceived");
+        if ( @affects ) {
+            my $frameworkcode = GetFrameworkCode($biblionumber);
+            my ( $itemfield ) = GetMarcFromKohaField( 'items.itemnumber', $frameworkcode );
+            for my $in ( @received_items ) {
+                my $item = C4::Items::GetMarcItem( $biblionumber, $in );
+                for my $affect ( @affects ) {
+                    my ( $sf, $v ) = split q{=}, $affect, 2;
+                    foreach ( $item->field($itemfield) ) {
+                        $_->update( $sf => $v );
+                    }
+                }
+                C4::Items::ModItemFromMarc( $item, $biblionumber, $in );
+            }
+        }
+    }
+
+    $order->{order_internalnote} = $input->param("order_internalnote");
+    $order->{tax_rate_on_receiving} = $input->param("tax_rate");
+    $order->{replacementprice} = $replacementprice;
+    $order->{unitprice} = $unitprice;
+
+    $order = C4::Acquisition::populate_order_with_prices(
+        {
+            order => $order,
+            booksellerid => $booksellerid,
+            receiving => 1
+        }
+    );
+
+    # save the quantity received.
+    if ( $quantityrec > 0 ) {
+        if ( $order_obj->subscriptionid ) {
+            # Quantity can only be modified if linked to a subscription
+            $order->{quantity} = $quantity; # quantityrec will be deduced from this value in ModReceiveOrder
+        }
+        ( $datereceived, $new_ordernumber ) = ModReceiveOrder(
+            {
+                biblionumber     => $biblionumber,
+                order            => $order,
+                quantityreceived => $quantityrec,
+                user             => $user,
+                invoice          => $invoice,
+                budget_id        => $bookfund,
+                received_items   => \@received_items,
+            }
+        );
+    }
+
+    # now, add items if applicable
+    if ($basket->effective_create_items eq 'receiving') {
+
+        my @tags         = $input->multi_param('tag');
+        my @subfields    = $input->multi_param('subfield');
+        my @field_values = $input->multi_param('field_value');
+        my @serials      = $input->multi_param('serial');
+        my @itemid       = $input->multi_param('itemid');
+        my @ind_tag      = $input->multi_param('ind_tag');
+        my @indicator    = $input->multi_param('indicator');
+        #Rebuilding ALL the data for items into a hash
+        # parting them on $itemid.
+        my %itemhash;
+        my $countdistinct;
+        my $range=scalar(@itemid);
+        for (my $i=0; $i<$range; $i++){
+            unless ($itemhash{$itemid[$i]}){
+            $countdistinct++;
+            }
+            push @{$itemhash{$itemid[$i]}->{'tags'}},$tags[$i];
+            push @{$itemhash{$itemid[$i]}->{'subfields'}},$subfields[$i];
+            push @{$itemhash{$itemid[$i]}->{'field_values'}},$field_values[$i];
+            push @{$itemhash{$itemid[$i]}->{'ind_tag'}},$ind_tag[$i];
+            push @{$itemhash{$itemid[$i]}->{'indicator'}},$indicator[$i];
+        }
+        my $new_order = Koha::Acquisition::Orders->find( $new_ordernumber );
+        foreach my $item (keys %itemhash){
+            my $xml = TransformHtmlToXml( $itemhash{$item}->{'tags'},
+                                          $itemhash{$item}->{'subfields'},
+                                          $itemhash{$item}->{'field_values'},
+                                          $itemhash{$item}->{'indicator'},
+                                          $itemhash{$item}->{'ind_tag'},
+                                          'ITEM' );
+            my $record=MARC::Record::new_from_xml($xml, 'UTF-8');
+            my (undef,$bibitemnum,$itemnumber) = AddItemFromMarc($record,$biblionumber);
+            $new_order->add_item( $itemnumber );
+        }
     }
-  } else {
-    print $input->header;
-    print $error;
-  }
-} else {
-  print $input->header;
-  delorder($biblionumber,$ordnum);
-       print $input->redirect("/acquisitions/");
 }
+
+my $new_order_object = Koha::Acquisition::Orders->find( $new_ordernumber ); # FIXME we should not need to refetch it
+my $items = $new_order_object->items;
+while ( my $item = $items->next )  {
+    ModItem(
+        {
+            booksellerid         => $booksellerid,
+            dateaccessioned      => $datereceived,
+            datelastseen         => $datereceived,
+            price                => $unitprice,
+            replacementprice     => $replacementprice,
+            replacementpricedate => $datereceived,
+        },
+        $biblionumber,
+        $item->itemnumber,
+    );
+}
+
+print $input->redirect("/cgi-bin/koha/acqui/parcel.pl?invoiceid=$invoiceid&sticky_filters=1");