#!/usr/bin/perl
-#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 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 2 of the License, or (at your option) any later
-# version.
+# 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.
+# 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, write to the Free Software Foundation, Inc., 59 Temple Place,
-# Suite 330, Boston, MA 02111-1307 USA
+# You should have received a copy of the GNU General Public License
+# along with Koha; if not, see <http://www.gnu.org/licenses>.
=head1 NAME
orderreceive.pl
=head1 DESCRIPTION
+
This script shows all order already receive and all pendings orders.
It permit to write a new order as 'received'.
=over 4
-=item supplierid
+=item booksellerid
+
to know on what supplier this script has to display receive order.
-=item recieve
+=item invoiceid
-=item invoice
-the number of this invoice.
+the id of this invoice.
=item freight
=item biblio
+
The biblionumber of this order.
-=item daterecieved
+=item datereceived
=item catview
=cut
-use strict;
-use CGI;
+use Modern::Perl;
+
+use CGI qw ( -utf8 );
use C4::Context;
-use C4::Koha; # GetKohaAuthorisedValues GetItemTypes
use C4::Acquisition;
use C4::Auth;
use C4::Output;
-use C4::Dates qw/format_date/;
-use C4::Bookseller;
+use C4::Budgets qw/ GetBudget GetBudgetHierarchy CanUserUseBudget GetBudgetPeriods /;
use C4::Members;
-use C4::Branch; # GetBranches
+use C4::Items;
+use C4::Biblio;
+use C4::Suggestions;
+use C4::Koha;
+
+use Koha::Acquisition::Booksellers;
+use Koha::Acquisition::Currencies;
+use Koha::Acquisition::Orders;
+use Koha::DateUtils qw( dt_from_string );
+use Koha::ItemTypes;
+use Koha::Patrons;
my $input = new CGI;
-my $supplierid = $input->param('supplierid');
-my $dbh = C4::Context->dbh;
-
-my $search = $input->param('recieve');
-my $invoice = $input->param('invoice');
-my $freight = $input->param('freight');
-my $biblionumber = $input->param('biblionumber');
-my $daterecieved = $input->param('daterecieved') || format_date(join "-",Date::Calc::Today());
-my $catview = $input->param('catview');
-my $gst = $input->param('gst');
-my @results = SearchOrder( $search, $supplierid, $biblionumber, $catview );
-my $count = scalar @results;
+my $dbh = C4::Context->dbh;
+my $invoiceid = $input->param('invoiceid');
+my $invoice = GetInvoice($invoiceid);
+my $booksellerid = $invoice->{booksellerid};
+my $freight = $invoice->{shipmentcost};
+my $ordernumber = $input->param('ordernumber');
-my @booksellers = GetBookSeller( $results[0]->{'booksellerid'} );
+my $bookseller = Koha::Acquisition::Booksellers->find( $booksellerid );
+my $results;
+$results = SearchOrders({
+ ordernumber => $ordernumber
+}) if $ordernumber;
-my $date = $results[0]->{'entrydate'};
-
-my ( $template, $loggedinuser, $cookie ) = get_template_and_user(
+my ( $template, $loggedinuser, $cookie, $userflags ) = get_template_and_user(
{
- template_name => "acqui/orderreceive.tmpl",
+ template_name => "acqui/orderreceive.tt",
query => $input,
type => "intranet",
authnotrequired => 0,
- flagsrequired => { acquisition => 1 },
+ flagsrequired => {acquisition => 'order_receive'},
debug => 1,
}
);
-$template->param($count);
-
-if ( $count == 1 ) {
-
- my $itemtypes = GetItemTypes;
- my @itemtypesloop;
- foreach my $thisitemtype (sort keys %$itemtypes) {
- my %row = (
- value => $thisitemtype,
- description => $itemtypes->{$thisitemtype}->{'description'},
- );
- push @itemtypesloop, \%row;
+
+unless ( $results and @$results) {
+ output_html_with_http_headers $input, $cookie, $template->output;
+ exit;
+}
+
+# prepare the form for receiving
+my $order = $results->[0];
+my $order_object = Koha::Acquisition::Orders->find( $ordernumber );
+my $basket = $order_object->basket;
+my $active_currency = Koha::Acquisition::Currencies->get_active;
+
+# Check if ACQ framework exists
+my $acq_fw = GetMarcStructure( 1, 'ACQ', { unsafe => 1 } );
+unless($acq_fw) {
+ $template->param('NoACQframework' => 1);
+}
+
+my $AcqCreateItem = $basket->effective_create_items;
+if ($AcqCreateItem eq 'receiving') {
+ $template->param(
+ AcqCreateItemReceiving => 1,
+ UniqueItemFields => C4::Context->preference('UniqueItemFields'),
+ );
+} elsif ($AcqCreateItem eq 'ordering') {
+ my $fw = ($acq_fw) ? 'ACQ' : '';
+ my $items = $order_object->items;
+ my @items;
+ while ( my $i = $items->next ) {
+ my $item = $i->unblessed;
+ my $descriptions;
+ $descriptions = Koha::AuthorisedValues->get_description_by_koha_field({frameworkcode => $fw, kohafield => 'items.notforloan', authorised_value => $item->{notforloan} });
+ $item->{notforloan} = $descriptions->{lib} // '';
+
+ $descriptions = Koha::AuthorisedValues->get_description_by_koha_field({frameworkcode => $fw, kohafield => 'items.restricted', authorised_value => $item->{restricted} });
+ $item->{restricted} = $descriptions->{lib} // '';
+
+ $descriptions = Koha::AuthorisedValues->get_description_by_koha_field({frameworkcode => $fw, kohafield => 'items.location', authorised_value => $item->{location} });
+ $item->{location} = $descriptions->{lib} // '';
+
+ $descriptions = Koha::AuthorisedValues->get_description_by_koha_field({frameworkcode => $fw, kohafield => 'items.ccode', authorised_value => $item->{ccode} });
+ $item->{collection} = $descriptions->{lib} // '';
+
+ $descriptions = Koha::AuthorisedValues->get_description_by_koha_field({frameworkcode => $fw, kohafield => 'items.materials', authorised_value => $item->{materials} });
+ $item->{materials} = $descriptions->{lib} // '';
+
+ my $itemtype = Koha::ItemTypes->find($i->effective_itemtype);
+ if (defined $itemtype) {
+ # We should not do that here, but call ->itemtype->description when needed instead
+ $item->{itemtype} = $itemtype->description; # FIXME Should not it be translated_description?
+ }
+ push @items, $item;
}
-
- $template->param(itemtypeloop => \@itemtypesloop);
-
-
- my $locations = GetKohaAuthorisedValues( 'items.location' );
- if ($locations) {
- my @location_codes = keys %$locations;
- my $CGIlocation = CGI::scrolling_list(
- -name => 'location',
- -id => 'location',
- -values => \@location_codes,
- -default => $results[0]->{'itemtype'},
- -labels => $locations,
- -size => 1,
- -tabindex => '',
- -multiple => 0
- );
- $template->param( CGIlocation => $CGIlocation );
+ $template->param(items => \@items);
+}
+
+$order->{quantityreceived} = '' if $order->{quantityreceived} == 0;
+
+my $unitprice = $order->{unitprice};
+my ( $rrp, $ecost );
+if ( $bookseller->invoiceincgst ) {
+ $rrp = $order->{rrp_tax_included};
+ $ecost = $order->{ecost_tax_included};
+ unless ( $unitprice != 0 and defined $unitprice) {
+ $unitprice = $order->{ecost_tax_included};
}
- my $onlymine=C4::Context->preference('IndependantBranches') &&
- C4::Context->userenv &&
- C4::Context->userenv->{flags} !=1 &&
- C4::Context->userenv->{branch};
- my $branches = GetBranches($onlymine);
- my @branchloop;
- foreach my $thisbranch ( sort keys %$branches ) {
- my %row = (
- value => $thisbranch,
- branchname => $branches->{$thisbranch}->{'branchname'},
- );
- push @branchloop, \%row;
+} else {
+ $rrp = $order->{rrp_tax_excluded};
+ $ecost = $order->{ecost_tax_excluded};
+ unless ( $unitprice != 0 and defined $unitprice) {
+ $unitprice = $order->{ecost_tax_excluded};
}
+}
- my $auto_barcode = C4::Context->boolean_preference("autoBarcode") || 0;
-
- # See whether barcodes should be automatically allocated.
- # Defaults to 0, meaning "no".
- my $barcode;
- if ( $auto_barcode ) {
- my $sth = $dbh->prepare("Select max(barcode) from items");
- $sth->execute;
- my $data = $sth->fetchrow_hashref;
- $barcode = $results[0]->{'barcode'} + 1;
- $sth->finish;
- }
+my $tax_rate;
+if( defined $order->{tax_rate_on_receiving} ) {
+ $tax_rate = $order->{tax_rate_on_receiving} + 0.0;
+} else {
+ $tax_rate = $order->{tax_rate_on_ordering} + 0.0;
+}
- if ( $results[0]->{'quantityreceived'} == 0 ) {
- $results[0]->{'quantityreceived'} = '';
- }
- if ( $results[0]->{'unitprice'} == 0 ) {
- $results[0]->{'unitprice'} = '';
+my $suggestion = GetSuggestionInfoFromBiblionumber($order->{biblionumber});
+
+my $creator = Koha::Patrons->find( $order->{created_by} );
+
+my $budget = GetBudget( $order->{budget_id} );
+
+my $datereceived = $order->{datereceived} ? dt_from_string( $order->{datereceived} ) : dt_from_string;
+
+# get option values for gist syspref
+my @gst_values = map {
+ option => $_ + 0.0
+}, split( '\|', C4::Context->preference("gist") );
+
+my $order_internalnote = $order->{order_internalnote};
+my $order_vendornote = $order->{order_vendornote};
+if ( $order->{subscriptionid} ) {
+ # Order from a subscription, we will display an history of what has been received
+ my $orders = Koha::Acquisition::Orders->search(
+ {
+ subscriptionid => $order->{subscriptionid},
+ parent_ordernumber => $order->{ordernumber},
+ ordernumber => { '!=' => $order->{ordernumber} }
+ }
+ );
+ if ( $order->{parent_ordernumber} != $order->{ordernumber} ) {
+ my $parent_order = Koha::Acquisition::Orders->find($order->{parent_ordernumber});
+ $order_internalnote = $parent_order->{order_internalnote};
+ $order_vendornote = $parent_order->{order_vendornote};
}
- $results[0]->{'copyrightdate'} =
- format_date( $results[0]->{'copyrightdate'} );
$template->param(
- branchloop => \@branchloop,
- count => 1,
- biblionumber => $results[0]->{'biblionumber'},
- ordernumber => $results[0]->{'ordernumber'},
- biblioitemnumber => $results[0]->{'biblioitemnumber'},
- supplierid => $results[0]->{'booksellerid'},
- freight => $freight,
- gst => $gst,
- catview => ( $catview ne 'yes' ? 1 : 0 ),
- name => $booksellers[0]->{'name'},
- date => format_date($date),
- title => $results[0]->{'title'},
- author => $results[0]->{'author'},
- copyrightdate => format_date( $results[0]->{'copyrightdate'} ),
- itemtype => $results[0]->{'itemtype'},
- isbn => $results[0]->{'isbn'},
- seriestitle => $results[0]->{'seriestitle'},
- barcode => $barcode,
- bookfund => $results[0]->{'bookfundid'},
- quantity => $results[0]->{'quantity'},
- quantityreceivedplus1 => $results[0]->{'quantityreceived'} + 1,
- quantityreceived => $results[0]->{'quantityreceived'},
- rrp => $results[0]->{'rrp'},
- ecost => $results[0]->{'ecost'},
- unitprice => $results[0]->{'unitprice'},
- invoice => $invoice,
- daterecieved => $daterecieved,
+ orders => $orders,
);
}
-else {
- my @loop;
- for ( my $i = 0 ; $i < $count ; $i++ ) {
- my %line = %{ $results[$i] };
-
- $line{invoice} = $invoice;
- $line{daterecieved} = $daterecieved;
- $line{freight} = $freight;
- $line{gst} = $gst;
- $line{title} = $results[$i]->{'title'};
- $line{author} = $results[$i]->{'author'};
- $line{supplierid} = $supplierid;
- push @loop, \%line;
+
+$template->param(
+ AcqCreateItem => $AcqCreateItem,
+ count => 1,
+ biblionumber => $order->{'biblionumber'},
+ ordernumber => $order->{'ordernumber'},
+ subscriptionid => $order->{subscriptionid},
+ booksellerid => $order->{'booksellerid'},
+ freight => $freight,
+ name => $bookseller->name,
+ cur_active_sym => $active_currency->symbol,
+ cur_active => $active_currency->currency,
+ listincgst => $bookseller->listincgst,
+ invoiceincgst => $bookseller->invoiceincgst,
+ title => $order->{'title'},
+ author => $order->{'author'},
+ copyrightdate => $order->{'copyrightdate'},
+ isbn => $order->{'isbn'},
+ seriestitle => $order->{'seriestitle'},
+ bookfund => $budget->{budget_name},
+ quantity => $order->{'quantity'},
+ quantityreceivedplus1 => $order->{'quantityreceived'} + 1,
+ quantityreceived => $order->{'quantityreceived'},
+ rrp => $rrp,
+ replacementprice => $order->{'replacementprice'},
+ ecost => $ecost,
+ unitprice => $unitprice,
+ tax_rate => $tax_rate,
+ creator => $creator,
+ invoiceid => $invoice->{invoiceid},
+ invoice => $invoice->{invoicenumber},
+ datereceived => $datereceived,
+ order_internalnote => $order_internalnote,
+ order_vendornote => $order_vendornote,
+ suggestionid => $suggestion->{suggestionid},
+ surnamesuggestedby => $suggestion->{surnamesuggestedby},
+ firstnamesuggestedby => $suggestion->{firstnamesuggestedby},
+ gst_values => \@gst_values,
+);
+
+my $patron = Koha::Patrons->find( $loggedinuser )->unblessed;
+my @budget_loop;
+my $periods = GetBudgetPeriods( );
+foreach my $period (@$periods) {
+ if ($period->{'budget_period_id'} == $budget->{'budget_period_id'}) {
+ $template->{'VARS'}->{'budget_period_description'} = $period->{'budget_period_description'};
}
- $template->param(
- loop => \@loop,
- date => format_date($date),
- daterecieved => $daterecieved,
- name => $booksellers[0]->{'name'},
- supplierid => $supplierid,
- invoice => $invoice,
- daterecieved => $daterecieved,
- );
+ next if $period->{'budget_period_locked'} || !$period->{'budget_period_description'};
+ my $budget_hierarchy = GetBudgetHierarchy( $period->{'budget_period_id'} );
+ my @funds;
+ foreach my $r ( @{$budget_hierarchy} ) {
+ next unless ( CanUserUseBudget( $patron, $r, $userflags ) );
+ if ( !defined $r->{budget_amount} || $r->{budget_amount} == 0 ) {
+ next;
+ }
+ push @funds,
+ {
+ b_id => $r->{budget_id},
+ b_txt => $r->{budget_name},
+ b_sel => ( $r->{budget_id} == $order->{budget_id} ) ? 1 : 0,
+ };
+ }
+
+ @funds = sort { uc( $a->{b_txt} ) cmp uc( $b->{b_txt} ) } @funds;
+
+ push @budget_loop,
+ {
+ 'id' => $period->{'budget_period_id'},
+ 'description' => $period->{'budget_period_description'},
+ 'funds' => \@funds
+ };
+}
+
+$template->{'VARS'}->{'budget_loop'} = \@budget_loop;
+my $op = $input->param('op');
+if ($op and $op eq 'edit'){
+ $template->param(edit => 1);
}
output_html_with_http_headers $input, $cookie, $template->output;
projects / koha-equinox.git / blobdiff