#
# 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.,
-# 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 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
=over
-=item neworderbiblio.pl to add an order from nothing.
-
-=item neworderempty.pl to add an order from an existing biblio.
+=item neworderempty.pl to add an order from an existing record or from nothing.
=item newordersuggestion.pl to add an order from an existing suggestion.
=item C<quantity>
the quantity to order.
-=item C<list_price>
+=item C<listprice>
the price of this order.
=item C<uncertainprice>
=cut
-use strict;
-use warnings;
-use CGI;
-use C4::Auth; # get_template_and_user
-use C4::Acquisition; # NewOrder DelOrder ModOrder
-use C4::Suggestions; # ModStatus
-use C4::Biblio; # AddBiblio TransformKohaToMarc
-use C4::Items;
-use C4::Output;
+use Modern::Perl;
+use CGI qw ( -utf8 );
+use JSON qw ( to_json encode_json );
+use C4::Auth qw( get_template_and_user );
+use C4::Acquisition qw( FillWithDefaultValues ModOrderUsers );
+use C4::Suggestions qw( ModSuggestion );
+use C4::Biblio qw(
+ AddBiblio
+ GetMarcFromKohaField
+ TransformHtmlToXml
+ TransformKohaToMarc
+);
+use C4::Budgets qw( GetBudget GetBudgetSpent GetBudgetOrdered );
+use C4::Items qw( AddItemFromMarc );
+use C4::Output qw( output_html_with_http_headers );
+use C4::Log qw( logaction );
+use Koha::Acquisition::Currencies qw( get_active );
+use Koha::Acquisition::Orders;
+use Koha::Acquisition::Baskets;
+use C4::Barcodes;
+use Koha::DateUtils qw( dt_from_string );
### "-------------------- addorder.pl ----------"
# FIXME: This needs to do actual error checking and possibly return user to the same form,
# not just blindly call C4 functions and print a redirect.
-my $input = new CGI;
-### $input
+my $input = CGI->new;
+my $use_ACQ_framework = $input->param('use_ACQ_framework');
+
+# Check if order total amount exceed allowed budget
+my $confirm_budget_exceeding = $input->param('confirm_budget_exceeding');
+unless($confirm_budget_exceeding) {
+ my $budget_id = $input->param('budget_id');
+ my $total = $input->param('total');
+ my $budget = GetBudget($budget_id);
+ my $budget_spent = GetBudgetSpent($budget_id);
+ my $budget_ordered = GetBudgetOrdered($budget_id);
+
+ my $ordernumber = $input->param('ordernumber');
+ if ( $ordernumber ) {
+ # modifying an existing order so remove order price from $budget_ordered
+ my $order = Koha::Acquisition::Orders->find($ordernumber);
+ $budget_ordered = $budget_ordered - ( $order->ecost_tax_included * $order->quantity );
+ }
+
+ my $budget_used = $budget_spent + $budget_ordered;
+ my $budget_remaining = $budget->{budget_amount} - $budget_used;
+ my $budget_encumbrance = $budget->{budget_amount} * $budget->{budget_encumb} / 100;
+ my $budget_expenditure = $budget->{budget_expend};
+
+ if ( $total > $budget_remaining
+ || ( ($budget_encumbrance+0) && ($budget_used + $total) > $budget_encumbrance)
+ || ( ($budget_expenditure+0) && ($budget_used + $total) > $budget_expenditure) )
+ {
+ my ($template, $loggedinuser, $cookie) = get_template_and_user({
+ template_name => "acqui/addorder.tt",
+ query => $input,
+ type => "intranet",
+ flagsrequired => {acquisition => 'order_manage'},
+ });
+
+ my $url = $input->referer();
+ unless ( defined $url ) {
+ my $basketno = $input->param('basketno');
+ $url = "/cgi-bin/koha/acqui/basket.pl?basketno=$basketno";
+ }
+
+ my $vars = $input->Vars;
+ my @vars_loop;
+ foreach (keys %$vars) {
+ push @vars_loop, {
+ name => $_,
+ values => [ $input->multi_param($_) ],
+ };
+ }
+
+ if( ($budget_encumbrance+0) && ($budget_used + $total) > $budget_encumbrance
+ && $total <= $budget_remaining)
+ {
+ $template->param(
+ encumbrance_exceeded => 1,
+ encumbrance => sprintf("%.2f", $budget->{'budget_encumb'}),
+ );
+ }
+ if( ($budget_expenditure+0) && ($budget_used + $total) > $budget_expenditure
+ && $total <= $budget_remaining )
+ {
+ my $currency = Koha::Acquisition::Currencies->get_active;
+ $template->param(
+ expenditure_exceeded => 1,
+ expenditure => sprintf("%.2f", $budget_expenditure),
+ currency => ($currency) ? $currency->symbol : '',
+ );
+ }
+ if($total > $budget_remaining){
+ $template->param(budget_exceeded => 1);
+ }
+
+ $template->param(
+ not_enough_budget => 1,
+ referer => $url,
+ vars_loop => \@vars_loop,
+ );
+ output_html_with_http_headers $input, $cookie, $template->output;
+ exit;
+ }
+}
# get_template_and_user used only to check auth & get user id
my ( $template, $loggedinuser, $cookie ) = get_template_and_user(
{
- template_name => "acqui/booksellers.tmpl",
+ template_name => "acqui/booksellers.tt",
query => $input,
type => "intranet",
- authnotrequired => 0,
flagsrequired => { acquisition => 'order_manage' },
- debug => 1,
}
);
# get CGI parameters
-my $orderinfo = $input->Vars;
-$orderinfo->{'list_price'} ||= 0;
-$orderinfo->{'uncertainprice'} ||= 0;
-
-my $user = $input->remote_user;
+my $orderinfo = {
+ ordernumber => scalar $input->param('ordernumber'),
+ basketno => scalar $input->param('basketno'),
+ biblionumber => scalar $input->param('biblionumber'),
+ invoiceid => scalar $input->param('invoiceid'),
+ quantity => scalar $input->param('quantity'),
+ budget_id => scalar $input->param('budget_id'),
+ currency => scalar $input->param('currency'),
+ listprice => scalar $input->param('listprice'),
+ uncertainprice => scalar $input->param('uncertainprice'),
+ tax_rate_on_ordering => scalar $input->param('tax_rate'),
+ discount => scalar $input->param('discount'),
+ rrp => scalar $input->param('rrp'),
+ replacementprice => scalar $input->param('replacementprice'),
+ ecost => scalar $input->param('ecost'),
+ unitprice => scalar $input->param('unitprice'),
+ order_internalnote => scalar $input->param('order_internalnote'),
+ order_vendornote => scalar $input->param('order_vendornote'),
+ sort1 => scalar $input->param('sort1'),
+ sort2 => scalar $input->param('sort2'),
+ subscriptionid => scalar $input->param('subscriptionid'),
+ estimated_delivery_date => scalar $input->param('estimated_delivery_date'),
+};
+
+$orderinfo->{uncertainprice} ||= 0;
+$orderinfo->{subscriptionid} ||= undef;
+
+my $user = $input->remote_user;
+my $basketno = $$orderinfo{basketno};
+my $basket = Koha::Acquisition::Baskets->find($basketno);
+
+# Order related fields we're going to log
+my @log_order_fields = (
+ 'quantity',
+ 'listprice',
+ 'unitprice',
+ 'unitprice_tax_excluded',
+ 'unitprice_tax_included',
+ 'rrp',
+ 'replacementprice',
+ 'rrp_tax_excluded',
+ 'rrp_tax_included',
+ 'ecost',
+ 'ecost_tax_excluded',
+ 'ecost_tax_included',
+ 'tax_rate_on_ordering'
+);
# create, modify or delete biblio
-# create if $quantity>=0 and $existing='no'
-# modify if $quantity>=0 and $existing='yes'
-# delete if $quantity has been set to 0 by the librarian
-# delete biblio if delbiblio has been set to 1 by the librarian
-my $bibitemnum;
-if ( $orderinfo->{quantity} ne '0' ) {
+# create if $quantity>0 and $existing='no'
+# modify if $quantity>0 and $existing='yes'
+if ( $basket->{is_standing} || $orderinfo->{quantity} ne '0' ) {
#TODO:check to see if biblio exists
unless ( $$orderinfo{biblionumber} ) {
- #if it doesnt create it
- my $record = TransformKohaToMarc(
- {
- "biblio.title" => "$$orderinfo{title}",
- "biblio.author" => $$orderinfo{author} ? $$orderinfo{author} : "",
- "biblio.seriestitle" => $$orderinfo{series} ? $$orderinfo{series} : "",
- "biblioitems.isbn" => $$orderinfo{isbn} ? $$orderinfo{isbn} : "",
- "biblioitems.ean" => $$orderinfo{ean} ? $$orderinfo{ean} : "",
- "biblioitems.publishercode" => $$orderinfo{publishercode} ? $$orderinfo{publishercode} : "",
- "biblioitems.publicationyear" => $$orderinfo{publicationyear} ? $$orderinfo{publicationyear}: "",
- "biblio.copyrightdate" => $$orderinfo{publicationyear} ? $$orderinfo{publicationyear}: "",
- "biblioitems.itemtype" => $$orderinfo{itemtype} ? $$orderinfo{itemtype} : "",
- "biblioitems.editionstatement"=> $$orderinfo{editionstatement} ? $$orderinfo{editionstatement} : "",
- "aqorders.branchcode" => $$orderinfo{branchcode} ? $$orderinfo{branchcode} : "",
- "aqorders.quantity" => $$orderinfo{quantity} ? $$orderinfo{quantity} : "",
- "aqorders.listprice" => $$orderinfo{listprice} ? $$orderinfo{listprice} : "",
- "aqorders.uncertainprice" => $$orderinfo{uncertainprice} ? $$orderinfo{uncertainprice} : "",
- "aqorders.rrp" => $$orderinfo{rrp} ? $$orderinfo{rrp} : "",
- "aqorders.ecost" => $$orderinfo{ecost} ? $$orderinfo{ecost} : "",
- "aqorders.discount" => $$orderinfo{discount} ? $$orderinfo{discount} : "",
- });
+
+ my $record;
+ if ( $use_ACQ_framework ) {
+ my @tags = $input->multi_param('bib_tag');
+ my @subfields = $input->multi_param('bib_subfield');
+ my @field_values = $input->multi_param('bib_field_value');
+ my $xml = TransformHtmlToXml( \@tags, \@subfields, \@field_values );
+ $record=MARC::Record::new_from_xml($xml, 'UTF-8');
+ } else {
+ #if it doesn't create it
+ $record = TransformKohaToMarc(
+ {
+ "biblio.title" => $input->param('title') || '',
+ "biblio.author" => $input->param('author') || '',
+ "biblio.seriestitle" => $input->param('series') || '',
+ "biblioitems.isbn" => $input->param('isbn') || '',
+ "biblioitems.ean" => $input->param('ean') || '',
+ "biblioitems.publishercode" => $input->param('publishercode') || '',
+ "biblioitems.publicationyear" => $input->param('publicationyear') || '',
+ "biblio.copyrightdate" => $input->param('publicationyear') || '',
+ "biblioitems.itemtype" => $input->param('itemtype') || '',
+ "biblioitems.editionstatement"=> $input->param('editionstatement') || '',
+ }
+ );
+ }
+ C4::Acquisition::FillWithDefaultValues( $record );
# create the record in catalogue, with framework ''
my ($biblionumber,$bibitemnum) = AddBiblio($record,'');
- # change suggestion status if applicable
- if ($$orderinfo{suggestionid}) {
- ModSuggestion( {suggestionid=>$$orderinfo{suggestionid}, STATUS=>'ORDERED', biblionumber=>$biblionumber} );
- }
- $orderinfo->{biblioitemnumber}=$bibitemnum;
- $orderinfo->{biblionumber}=$biblionumber;
+
+ $orderinfo->{biblionumber}=$biblionumber;
+ }
+
+ # change suggestion status if applicable
+ if ( my $suggestionid = $input->param('suggestionid') ) {
+ ModSuggestion(
+ {
+ suggestionid => $suggestionid,
+ biblionumber => $orderinfo->{biblionumber},
+ STATUS => 'ORDERED',
+ }
+ );
}
$orderinfo->{unitprice} = $orderinfo->{ecost} if not defined $orderinfo->{unitprice} or $orderinfo->{unitprice} eq '';
- # if we already have $ordernumber, then it's an ordermodif
- if ($$orderinfo{ordernumber}) {
- ModOrder( $orderinfo);
+ my $order;
+ my $log_action_name;
+
+ if ( $orderinfo->{ordernumber} ) {
+ $order = Koha::Acquisition::Orders->find($orderinfo->{ordernumber});
+ $order->set($orderinfo);
+ $log_action_name = 'MODIFY_ORDER';
+ } else {
+ $order = Koha::Acquisition::Order->new($orderinfo);
+ $log_action_name = 'CREATE_ORDER';
}
- else { # else, it's a new line
- @$orderinfo{qw(basketno ordernumber )} = NewOrder($orderinfo);
+ $order->populate_with_prices_for_ordering();
+ $order->store;
+
+ # Log the order creation
+ if (C4::Context->preference("AcquisitionLog")) {
+ my $infos = {};
+ foreach my $field(@log_order_fields) {
+ $infos->{$field} = $order->$field;
+ }
+ logaction(
+ 'ACQUISITIONS',
+ $log_action_name,
+ $order->ordernumber,
+ encode_json($infos)
+ );
}
+ my $order_users_ids = $input->param('users_ids');
+ my @order_users = split( /:/, $order_users_ids );
+ ModOrderUsers( $order->ordernumber, @order_users );
# now, add items if applicable
- if (C4::Context->preference('AcqCreateItem') eq 'ordering') {
-
- my @tags = $input->param('tag');
- my @subfields = $input->param('subfield');
- my @field_values = $input->param('field_value');
- my @serials = $input->param('serial');
- my @itemid = $input->param('itemid');
- my @ind_tag = $input->param('ind_tag');
- my @indicator = $input->param('indicator');
+ if ($basket->effective_create_items eq 'ordering') {
+
+ 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');
#Rebuilding ALL the data for items into a hash
# parting them on $itemid.
unless ($itemhash{$itemid[$i]}){
$countdistinct++;
}
- push @{$itemhash{$itemid[$i]}->{'tags'}},$tags[$i];
- push @{$itemhash{$itemid[$i]}->{'subfields'}},$subfields[$i];
+ 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];
}
foreach my $item (keys %itemhash){
-
my $xml = TransformHtmlToXml( $itemhash{$item}->{'tags'},
$itemhash{$item}->{'subfields'},
$itemhash{$item}->{'field_values'},
- $itemhash{$item}->{'ind_tag'},
- $itemhash{$item}->{'indicator'},
+ undef,
+ undef,
'ITEM');
my $record=MARC::Record::new_from_xml($xml, 'UTF-8');
+ my ($barcodefield,$barcodesubfield) = GetMarcFromKohaField('items.barcode');
+ next unless ( defined $barcodefield && defined $barcodesubfield );
+ my $barcode = $record->subfield($barcodefield,$barcodesubfield) || '';
+ my $aBpref = C4::Context->preference('autoBarcode');
+ if( $barcode eq '' && $aBpref ne 'OFF'){
+ my $barcodeobj;
+ if ( $aBpref eq 'hbyymmincr'){
+ my ($homebranchfield,$homebranchsubfield) = GetMarcFromKohaField('items.homebranch');
+ my $homebranch = $record->subfield($homebranchfield,$homebranchsubfield);
+ $barcodeobj = C4::Barcodes->new($aBpref, $homebranch);
+ } else {
+ $barcodeobj = C4::Barcodes->new($aBpref);
+ }
+ $barcode = $barcodeobj->value();
+ $record->field($barcodefield)->delete_subfield( code => $barcodesubfield);
+ $record->field($barcodefield)->add_subfields($barcodesubfield => $barcode);
+ }
my ($biblionumber,$bibitemnum,$itemnumber) = AddItemFromMarc($record,$$orderinfo{biblionumber});
- NewOrderItem($itemnumber, $$orderinfo{ordernumber});
-
+ $order->add_item($itemnumber);
}
}
}
-else { # qty=0, delete the line
- my $biblionumber = $input->param('biblionumber');
- DelOrder( $biblionumber, $$orderinfo{ordernumber} );
- if ($orderinfo->{delbiblio} == 1){
- DelBiblio($biblionumber);
- }
+if (C4::Context->preference("AcquisitionLog") && $basketno) {
+ my $modified = Koha::Acquisition::Baskets->find( $basketno );
+ logaction(
+ 'ACQUISITIONS',
+ 'MODIFY_BASKET',
+ $basketno,
+ to_json($modified->unblessed)
+ );
}
-my $basketno=$$orderinfo{basketno};
+
my $booksellerid=$$orderinfo{booksellerid};
-if (my $import_batch_id=$$orderinfo{import_batch_id}) {
+if (my $import_batch_id = $input->param('import_batch_id')) {
print $input->redirect("/cgi-bin/koha/acqui/addorderiso2709.pl?import_batch_id=$import_batch_id&basketno=$basketno&booksellerid=$booksellerid");
+} elsif ( defined $orderinfo->{invoiceid} ) {
+ print $input->redirect("/cgi-bin/koha/acqui/parcel.pl?invoiceid=" . $orderinfo->{invoiceid});
} else {
print $input->redirect("/cgi-bin/koha/acqui/basket.pl?basketno=$basketno");
}