Bug 11642: Add confirmation and tooltips to batch deletion tool
[koha.git] / acqui / addorder.pl
blob2c269e01edb4b0b3c25f3af43ba698e166035049
1 #!/usr/bin/perl
3 #script to add an order into the system
4 #written 29/2/00 by chris@katipo.co.nz
6 # Copyright 2000-2002 Katipo Communications
8 # This file is part of Koha.
10 # Koha is free software; you can redistribute it and/or modify it
11 # under the terms of the GNU General Public License as published by
12 # the Free Software Foundation; either version 3 of the License, or
13 # (at your option) any later version.
15 # Koha is distributed in the hope that it will be useful, but
16 # WITHOUT ANY WARRANTY; without even the implied warranty of
17 # MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
18 # GNU General Public License for more details.
20 # You should have received a copy of the GNU General Public License
21 # along with Koha; if not, see <http://www.gnu.org/licenses>.
24 =head1 NAME
26 addorder.pl
28 =head1 DESCRIPTION
30 this script allows to add an order.
31 It is called by :
33 =over
35 =item neworderbiblio.pl to add an order from nothing.
37 =item neworderempty.pl to add an order from an existing biblio.
39 =item newordersuggestion.pl to add an order from an existing suggestion.
41 =back
43 =head1 CGI PARAMETERS
45 All of the cgi parameters below are related to the new order.
47 =over
49 =item C<ordernumber>
50 the number of this new order.
52 =item C<basketno>
53 the number of this new basket
55 =item C<booksellerid>
56 the bookseller the librarian has to pay.
58 =item C<existing>
60 =item C<title>
61 the title of the record ordered.
63 =item C<author>
64 the author of the record ordered.
66 =item C<copyrightdate>
67 the copyrightdate of the record ordered.
69 =item C<ISBN>
70 the ISBN of the record ordered.
72 =item C<format>
74 =item C<quantity>
75 the quantity to order.
77 =item C<list_price>
78 the price of this order.
80 =item C<uncertainprice>
81 uncertain price, can't close basket until prices of all orders are known.
83 =item C<branch>
84 the branch where this order will be received.
86 =item C<series>
88 =item C<notes>
89 Notes on this basket.
91 =item C<budget_id>
92 budget_id used to pay this order.
94 =item C<sort1> & C<sort2>
96 =item C<rrp>
98 =item C<ecost>
100 =item C<GST>
102 =item C<budget>
104 =item C<cost>
106 =item C<sub>
108 =item C<invoice>
109 the number of the invoice for this order.
111 =item C<publishercode>
113 =item C<suggestionid>
114 if it is an order from an existing suggestion : the id of this suggestion.
116 =item C<donation>
118 =back
120 =cut
122 use Modern::Perl;
123 use CGI qw ( -utf8 );
124 use C4::Auth; # get_template_and_user
125 use C4::Acquisition; # ModOrder
126 use C4::Suggestions; # ModStatus
127 use C4::Biblio; # AddBiblio TransformKohaToMarc
128 use C4::Budgets;
129 use C4::Items;
130 use C4::Output;
131 use Koha::Acquisition::Currencies;
132 use Koha::Acquisition::Orders;
133 use C4::Barcodes;
135 ### "-------------------- addorder.pl ----------"
137 # FIXME: This needs to do actual error checking and possibly return user to the same form,
138 # not just blindly call C4 functions and print a redirect.
140 my $input = new CGI;
141 my $use_ACQ_framework = $input->param('use_ACQ_framework');
143 # Check if order total amount exceed allowed budget
144 my $confirm_budget_exceeding = $input->param('confirm_budget_exceeding');
145 unless($confirm_budget_exceeding) {
146 my $budget_id = $input->param('budget_id');
147 my $total = $input->param('total');
148 my $budget = GetBudget($budget_id);
149 my $budget_spent = GetBudgetSpent($budget_id);
150 my $budget_ordered = GetBudgetOrdered($budget_id);
151 my $budget_used = $budget_spent + $budget_ordered;
152 my $budget_remaining = $budget->{budget_amount} - $budget_used;
153 my $budget_encumbrance = $budget->{budget_amount} * $budget->{budget_encumb} / 100;
154 my $budget_expenditure = $budget->{budget_expend};
156 if ( $total > $budget_remaining
157 || ( ($budget_encumbrance+0) && ($budget_used + $total) > $budget_encumbrance)
158 || ( ($budget_expenditure+0) && ($budget_used + $total) > $budget_expenditure) )
160 my ($template, $loggedinuser, $cookie) = get_template_and_user({
161 template_name => "acqui/addorder.tt",
162 query => $input,
163 type => "intranet",
164 authnotrequired => 0,
165 flagsrequired => {acquisition => 'order_manage'},
168 my $url = $input->referer();
169 unless ( defined $url ) {
170 my $basketno = $input->param('basketno');
171 $url = "/cgi-bin/koha/acqui/basket.pl?basketno=$basketno";
174 my $vars = $input->Vars;
175 my @vars_loop;
176 foreach (keys %$vars) {
177 push @vars_loop, {
178 name => $_,
179 values => [$input->param($_)],
183 if( ($budget_encumbrance+0) && ($budget_used + $total) > $budget_encumbrance
184 && $total <= $budget_remaining)
186 $template->param(
187 encumbrance_exceeded => 1,
188 encumbrance => sprintf("%.2f", $budget->{'budget_encumb'}),
191 if( ($budget_expenditure+0) && ($budget_used + $total) > $budget_expenditure
192 && $total <= $budget_remaining )
194 my $currency = Koha::Acquisition::Currencies->get_active;
195 $template->param(
196 expenditure_exceeded => 1,
197 expenditure => sprintf("%.2f", $budget_expenditure),
198 currency => ($currency) ? $currency->symbol : '',
201 if($total > $budget_remaining){
202 $template->param(budget_exceeded => 1);
205 $template->param(
206 not_enough_budget => 1,
207 referer => $url,
208 vars_loop => \@vars_loop,
210 output_html_with_http_headers $input, $cookie, $template->output;
211 exit;
215 # get_template_and_user used only to check auth & get user id
216 my ( $template, $loggedinuser, $cookie ) = get_template_and_user(
218 template_name => "acqui/booksellers.tt",
219 query => $input,
220 type => "intranet",
221 authnotrequired => 0,
222 flagsrequired => { acquisition => 'order_manage' },
223 debug => 1,
227 # get CGI parameters
228 my $orderinfo = $input->Vars;
229 $orderinfo->{'list_price'} ||= 0;
230 $orderinfo->{'uncertainprice'} ||= 0;
231 $orderinfo->{subscriptionid} ||= undef;
233 my $user = $input->remote_user;
234 my $basketno = $$orderinfo{basketno};
235 my $basket = Koha::Acquisition::Baskets->find($basketno);
237 # create, modify or delete biblio
238 # create if $quantity>0 and $existing='no'
239 # modify if $quantity>0 and $existing='yes'
240 if ( $basket->{is_standing} || $orderinfo->{quantity} ne '0' ) {
241 #TODO:check to see if biblio exists
242 unless ( $$orderinfo{biblionumber} ) {
244 my $record;
245 if ( $use_ACQ_framework ) {
246 my @tags = $input->multi_param('bib_tag');
247 my @subfields = $input->multi_param('bib_subfield');
248 my @field_values = $input->multi_param('bib_field_value');
249 my $xml = TransformHtmlToXml( \@tags, \@subfields, \@field_values );
250 $record=MARC::Record::new_from_xml($xml, 'UTF-8');
251 } else {
252 #if it doesn't create it
253 $record = TransformKohaToMarc(
255 "biblio.title" => "$$orderinfo{title}",
256 "biblio.author" => $$orderinfo{author} ? $$orderinfo{author} : "",
257 "biblio.seriestitle" => $$orderinfo{series} ? $$orderinfo{series} : "",
258 "biblioitems.isbn" => $$orderinfo{isbn} ? $$orderinfo{isbn} : "",
259 "biblioitems.ean" => $$orderinfo{ean} ? $$orderinfo{ean} : "",
260 "biblioitems.publishercode" => $$orderinfo{publishercode} ? $$orderinfo{publishercode} : "",
261 "biblioitems.publicationyear" => $$orderinfo{publicationyear} ? $$orderinfo{publicationyear}: "",
262 "biblio.copyrightdate" => $$orderinfo{publicationyear} ? $$orderinfo{publicationyear}: "",
263 "biblioitems.itemtype" => $$orderinfo{itemtype} ? $$orderinfo{itemtype} : "",
264 "biblioitems.editionstatement"=> $$orderinfo{editionstatement} ? $$orderinfo{editionstatement} : "",
268 C4::Acquisition::FillWithDefaultValues( $record );
270 # create the record in catalogue, with framework ''
271 my ($biblionumber,$bibitemnum) = AddBiblio($record,'');
272 # change suggestion status if applicable
273 if ($$orderinfo{suggestionid}) {
274 ModSuggestion( {suggestionid=>$$orderinfo{suggestionid}, STATUS=>'ORDERED', biblionumber=>$biblionumber} );
276 $orderinfo->{biblionumber}=$biblionumber;
279 $orderinfo->{unitprice} = $orderinfo->{ecost} if not defined $orderinfo->{unitprice} or $orderinfo->{unitprice} eq '';
281 $orderinfo = C4::Acquisition::populate_order_with_prices(
283 order => $orderinfo,
284 booksellerid => $orderinfo->{booksellerid},
285 ordering => 1,
289 # if we already have $ordernumber, then it's an ordermodif
290 my $order = Koha::Acquisition::Order->new($orderinfo);
291 if ( $orderinfo->{ordernumber} ) {
292 ModOrder($orderinfo);
294 else { # else, it's a new line
295 $order->store;
297 my $order_users_ids = $input->param('users_ids');
298 my @order_users = split( /:/, $order_users_ids );
299 ModOrderUsers( $order->ordernumber, @order_users );
301 # now, add items if applicable
302 if ($basket->effective_create_items eq 'ordering') {
304 my @tags = $input->multi_param('tag');
305 my @subfields = $input->multi_param('subfield');
306 my @field_values = $input->multi_param('field_value');
307 my @serials = $input->multi_param('serial');
308 my @itemid = $input->multi_param('itemid');
309 my @ind_tag = $input->multi_param('ind_tag');
310 my @indicator = $input->multi_param('indicator');
311 #Rebuilding ALL the data for items into a hash
312 # parting them on $itemid.
314 my %itemhash;
315 my $countdistinct;
316 my $range=scalar(@itemid);
317 for (my $i=0; $i<$range; $i++){
318 unless ($itemhash{$itemid[$i]}){
319 $countdistinct++;
321 push @{$itemhash{$itemid[$i]}->{'tags'}},$tags[$i];
322 push @{$itemhash{$itemid[$i]}->{'subfields'}},$subfields[$i];
323 push @{$itemhash{$itemid[$i]}->{'field_values'}},$field_values[$i];
324 push @{$itemhash{$itemid[$i]}->{'ind_tag'}},$ind_tag[$i];
325 push @{$itemhash{$itemid[$i]}->{'indicator'}},$indicator[$i];
327 foreach my $item (keys %itemhash){
328 my $xml = TransformHtmlToXml( $itemhash{$item}->{'tags'},
329 $itemhash{$item}->{'subfields'},
330 $itemhash{$item}->{'field_values'},
331 $itemhash{$item}->{'indicator'},
332 $itemhash{$item}->{'ind_tag'},
333 'ITEM');
334 my $record=MARC::Record::new_from_xml($xml, 'UTF-8');
335 my ($barcodefield,$barcodesubfield) = GetMarcFromKohaField('items.barcode');
336 next unless ( defined $barcodefield && defined $barcodesubfield );
337 my $barcode = $record->subfield($barcodefield,$barcodesubfield) || '';
338 my $aBpref = C4::Context->preference('autoBarcode');
339 if( $barcode eq '' && $aBpref ne 'OFF'){
340 my $barcodeobj;
341 if ( $aBpref eq 'hbyymmincr'){
342 my ($homebranchfield,$homebranchsubfield) = GetMarcFromKohaField('items.homebranch');
343 my $homebranch = $record->subfield($homebranchfield,$homebranchsubfield);
344 $barcodeobj = C4::Barcodes->new($aBpref, $homebranch);
345 } else {
346 $barcodeobj = C4::Barcodes->new($aBpref);
348 $barcode = $barcodeobj->value();
349 $record->field($barcodefield)->delete_subfield( code => $barcodesubfield);
350 $record->field($barcodefield)->add_subfields($barcodesubfield => $barcode);
352 my ($biblionumber,$bibitemnum,$itemnumber) = AddItemFromMarc($record,$$orderinfo{biblionumber});
353 $order->add_item($itemnumber);
359 my $booksellerid=$$orderinfo{booksellerid};
360 if (my $import_batch_id=$$orderinfo{import_batch_id}) {
361 print $input->redirect("/cgi-bin/koha/acqui/addorderiso2709.pl?import_batch_id=$import_batch_id&basketno=$basketno&booksellerid=$booksellerid");
362 } elsif ( defined $orderinfo->{invoiceid} ) {
363 print $input->redirect("/cgi-bin/koha/acqui/parcel.pl?invoiceid=" . $orderinfo->{invoiceid});
364 } else {
365 print $input->redirect("/cgi-bin/koha/acqui/basket.pl?basketno=$basketno");