AKZG -- added inventory number generation for new homebranch

[koha.git] / acqui / finishreceive.pl

diff --git a/acqui/finishreceive.pl b/acqui/finishreceive.pl
index c72da15..e80e368 100755 (executable)
--- a/acqui/finishreceive.pl
+++ b/acqui/finishreceive.pl
@@ -59,9 +59,20 @@ 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, ',');
+    }
+}
+
 $unitprice = Koha::Number::Price->new( $unitprice )->unformat();
 $replacementprice = Koha::Number::Price->new( $replacementprice )->unformat();
-my $basket = Koha::Acquisition::Orders->find( $ordernumber )->basket;
+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 ) {
@@ -100,6 +111,10 @@ if ($quantityrec > $origquantityrec ) {
 
     # 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,
@@ -153,17 +168,81 @@ if ($quantityrec > $origquantityrec ) {
     }
 }
 
-ModItem(
-    {
-        booksellerid         => $booksellerid,
-        dateaccessioned      => $datereceived,
-        datelastseen         => $datereceived,
-        price                => $unitprice,
-        replacementprice     => $replacementprice,
-        replacementpricedate => $datereceived,
-    },
-    $biblionumber,
-    $_
-) foreach GetItemnumbersFromOrder($new_ordernumber);
+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,
+    );
+}
+
+
+# XXX KRT-4338 -- create barcode and stocknumber now!
+use Data::Dump qw(dump);
+
+my @received_items = $input->param('items_to_receive');
+foreach my $itemnumber ( @received_items ) {
+
+       my $dbh = C4::Context->dbh;
+
+       $dbh->begin_work;
+
+       my $sth = $dbh->prepare("select biblionumber,barcode,stocknumber,itype,homebranch from items where itemnumber = ?");
+       $sth->execute( $itemnumber );
+
+       if ( $sth->rows != 1 ) {
+               die "ERROR: itemnumber $itemnumber have ", $sth->rows, " rows";
+       }
+
+       my ( $biblionumber, $barcode, $stocknumber, $itype, $homebranch ) = $sth->fetchrow_array;
+       warn "YYY got ", dump( $biblionumber, $barcode, $stocknumber, $itype, $homebranch );
+
+       next if $itype =~ /(BAZA|PER|CLA|PRE|RZB)/;
+
+       if (! $barcode ) {
+               $sth = $dbh->prepare("select max(abs(barcode)) from items");
+               $sth->execute;
+               $barcode = $sth->fetchrow;
+               $barcode++;
+               warn "# itemnumber: $itemnumber new barcode: $barcode";
+       }
+
+       my $year = DateTime->now->year;
+
+       if (! $stocknumber && ( $homebranch eq 'FFZG' || $homebranch eq 'AKZG' ) ) {
+
+               my $inventarna_knjiga = lc($homebranch) . '_inventarna_knjiga';
+
+               $sth = $dbh->prepare("select max(num) from $inventarna_knjiga where year = ?");
+               $sth->execute($year);
+
+               $stocknumber = $sth->fetchrow; # return null without any data
+               $stocknumber += 1;
+
+               $sth = $dbh->prepare("insert into $inventarna_knjiga (year,num, biblionumber, itemnumber) values (?,?,?,?)");
+               $sth->execute( $year, $stocknumber, $biblionumber, $itemnumber );
+
+               $stocknumber = "$year-$stocknumber";
+
+               $stocknumber = 'AK-' . $stocknumber if $homebranch eq 'AKZG';
+       }
+
+       warn "## itemnumber: $itemnumber barcode: $barcode stocknumber: $stocknumber\n";
+
+       $sth = $dbh->prepare("update items set barcode=?, stocknumber=? where itemnumber = ?");
+       $sth->execute( $barcode, $stocknumber, $itemnumber );
+
+       $dbh->commit;
+
+}
 
 print $input->redirect("/cgi-bin/koha/acqui/parcel.pl?invoiceid=$invoiceid&sticky_filters=1");