use C4::Acquisition; # NewOrder DelOrder ModOrder
use C4::Suggestions; # ModStatus
use C4::Biblio; # AddBiblio TransformKohaToMarc
+use C4::Budgets;
use C4::Items;
use C4::Output;
# not just blindly call C4 functions and print a redirect.
my $input = new CGI;
-### $input
+
+# 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 $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.tmpl",
+ query => $input,
+ type => "intranet",
+ authnotrequired => 0,
+ 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->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 = GetCurrency;
+ $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(
my $orderinfo = $input->Vars;
$orderinfo->{'list_price'} ||= 0;
$orderinfo->{'uncertainprice'} ||= 0;
-#my $ordernumber = $input->param('ordernumber');
-#my $basketno = $input->param('basketno');
-#my $booksellerid = $input->param('booksellerid');
-#my $existing = $input->param('existing'); # existing biblio, (not basket or order)
-#my $title = $input->param('title');
-#my $author = $input->param('author');
-#my $publicationyear= $input->param('publicationyear');
-#my $isbn = $input->param('ISBN');
-#my $itemtype = $input->param('format');
-#my $quantity = $input->param('quantity'); # FIXME: else ERROR!
-#my $branch = $input->param('branch');
-#my $series = $input->param('series');
-#my $notes = $input->param('notes');
-#my $budget_id = $input->param('budget_id');
-#my $sort1 = $input->param('sort1');
-#my $sort2 = $input->param('sort2');
-#my $rrp = $input->param('rrp');
-#my $ecost = $input->param('ecost');
-#my $gst = $input->param('GST');
-#my $budget = $input->param('budget');
-#my $cost = $input->param('cost');
-#my $sub = $input->param('sub');
-#my $purchaseorder = $input->param('purchaseordernumber');
-#my $invoice = $input->param('invoice');
-#my $publishercode = $input->param('publishercode');
-#my $suggestionid = $input->param('suggestionid');
-#my $biblionumber = $input->param('biblionumber');
-#my $uncertainprice = $input->param('uncertainprice');
-#my $import_batch_id= $input->param('import_batch_id');
-#
-#my $createbibitem = $input->param('createbibitem');
-#
-my $user = $input->remote_user;
+$orderinfo->{subscriptionid} ||= undef;
+
+my $user = $input->remote_user;
+
# 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
-my $bibitemnum;
+# delete biblio if delbiblio has been set to 1 by the librarian
if ( $orderinfo->{quantity} ne '0' ) {
#TODO:check to see if biblio exists
unless ( $$orderinfo{biblionumber} ) {
"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} : "",
});
# 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} );
+ ModSuggestion( {suggestionid=>$$orderinfo{suggestionid}, STATUS=>'ORDERED', biblionumber=>$biblionumber} );
}
- $orderinfo->{biblioitemnumber}=$bibitemnum;
- $orderinfo->{biblionumber}=$biblionumber;
+ $orderinfo->{biblionumber}=$biblionumber;
}
+ $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);
else { # qty=0, delete the line
my $biblionumber = $input->param('biblionumber');
DelOrder( $biblionumber, $$orderinfo{ordernumber} );
+ if ($orderinfo->{delbiblio} == 1){
+ DelBiblio($biblionumber);
+ }
}
my $basketno=$$orderinfo{basketno};
my $booksellerid=$$orderinfo{booksellerid};
if (my $import_batch_id=$$orderinfo{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");
}