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>.
30 this script allows to add an order.
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.
45 All of the cgi parameters below are related to the new order.
50 the number of this new order.
53 the number of this new basket
56 the bookseller the librarian has to pay.
61 the title of the record ordered.
64 the author of the record ordered.
66 =item C<copyrightdate>
67 the copyrightdate of the record ordered.
70 the ISBN of the record ordered.
75 the quantity to order.
78 the price of this order.
80 =item C<uncertainprice>
81 uncertain price, can't close basket until prices of all orders are known.
84 the branch where this order will be received.
92 budget_id used to pay this order.
94 =item C<sort1> & C<sort2>
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.
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
131 use Koha::Acquisition::Currencies;
132 use Koha::Acquisition::Orders;
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.
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",
164 flagsrequired => {acquisition => 'order_manage'},
167 my $url = $input->referer();
168 unless ( defined $url ) {
169 my $basketno = $input->param('basketno');
170 $url = "/cgi-bin/koha/acqui/basket.pl?basketno=$basketno";
173 my $vars = $input->Vars;
175 foreach (keys %$vars) {
178 values => [$input->param($_)],
182 if( ($budget_encumbrance+0) && ($budget_used + $total) > $budget_encumbrance
183 && $total <= $budget_remaining)
186 encumbrance_exceeded => 1,
187 encumbrance => sprintf("%.2f", $budget->{'budget_encumb'}),
190 if( ($budget_expenditure+0) && ($budget_used + $total) > $budget_expenditure
191 && $total <= $budget_remaining )
193 my $currency = Koha::Acquisition::Currencies->get_active;
195 expenditure_exceeded => 1,
196 expenditure => sprintf("%.2f", $budget_expenditure),
197 currency => ($currency) ? $currency->symbol : '',
200 if($total > $budget_remaining){
201 $template->param(budget_exceeded => 1);
205 not_enough_budget => 1,
207 vars_loop => \@vars_loop,
209 output_html_with_http_headers $input, $cookie, $template->output;
214 # get_template_and_user used only to check auth & get user id
215 my ( $template, $loggedinuser, $cookie ) = get_template_and_user(
217 template_name => "acqui/booksellers.tt",
220 flagsrequired => { acquisition => 'order_manage' },
226 my $orderinfo = $input->Vars;
227 $orderinfo->{'list_price'} ||= 0;
228 $orderinfo->{'uncertainprice'} ||= 0;
229 $orderinfo->{subscriptionid} ||= undef;
231 my $user = $input->remote_user;
232 my $basketno = $$orderinfo{basketno};
233 my $basket = Koha::Acquisition::Baskets->find($basketno);
235 # create, modify or delete biblio
236 # create if $quantity>0 and $existing='no'
237 # modify if $quantity>0 and $existing='yes'
238 if ( $basket->{is_standing} || $orderinfo->{quantity} ne '0' ) {
239 #TODO:check to see if biblio exists
240 unless ( $$orderinfo{biblionumber} ) {
243 if ( $use_ACQ_framework ) {
244 my @tags = $input->multi_param('bib_tag');
245 my @subfields = $input->multi_param('bib_subfield');
246 my @field_values = $input->multi_param('bib_field_value');
247 my $xml = TransformHtmlToXml( \@tags, \@subfields, \@field_values );
248 $record=MARC::Record::new_from_xml($xml, 'UTF-8');
250 #if it doesn't create it
251 $record = TransformKohaToMarc(
253 "biblio.title" => "$$orderinfo{title}",
254 "biblio.author" => $$orderinfo{author} ? $$orderinfo{author} : "",
255 "biblio.seriestitle" => $$orderinfo{series} ? $$orderinfo{series} : "",
256 "biblioitems.isbn" => $$orderinfo{isbn} ? $$orderinfo{isbn} : "",
257 "biblioitems.ean" => $$orderinfo{ean} ? $$orderinfo{ean} : "",
258 "biblioitems.publishercode" => $$orderinfo{publishercode} ? $$orderinfo{publishercode} : "",
259 "biblioitems.publicationyear" => $$orderinfo{publicationyear} ? $$orderinfo{publicationyear}: "",
260 "biblio.copyrightdate" => $$orderinfo{publicationyear} ? $$orderinfo{publicationyear}: "",
261 "biblioitems.itemtype" => $$orderinfo{itemtype} ? $$orderinfo{itemtype} : "",
262 "biblioitems.editionstatement"=> $$orderinfo{editionstatement} ? $$orderinfo{editionstatement} : "",
266 C4::Acquisition::FillWithDefaultValues( $record );
268 # create the record in catalogue, with framework ''
269 my ($biblionumber,$bibitemnum) = AddBiblio($record,'');
270 # change suggestion status if applicable
271 if ($$orderinfo{suggestionid}) {
272 ModSuggestion( {suggestionid=>$$orderinfo{suggestionid}, STATUS=>'ORDERED', biblionumber=>$biblionumber} );
274 $orderinfo->{biblionumber}=$biblionumber;
277 $orderinfo->{unitprice} = $orderinfo->{ecost} if not defined $orderinfo->{unitprice} or $orderinfo->{unitprice} eq '';
279 $orderinfo = C4::Acquisition::populate_order_with_prices(
282 booksellerid => $orderinfo->{booksellerid},
287 # if we already have $ordernumber, then it's an ordermodif
288 my $order = Koha::Acquisition::Order->new($orderinfo);
289 if ( $orderinfo->{ordernumber} ) {
290 ModOrder($orderinfo);
292 else { # else, it's a new line
295 my $order_users_ids = $input->param('users_ids');
296 my @order_users = split( /:/, $order_users_ids );
297 ModOrderUsers( $order->ordernumber, @order_users );
299 # now, add items if applicable
300 if ($basket->effective_create_items eq 'ordering') {
302 my @tags = $input->multi_param('tag');
303 my @subfields = $input->multi_param('subfield');
304 my @field_values = $input->multi_param('field_value');
305 my @serials = $input->multi_param('serial');
306 my @itemid = $input->multi_param('itemid');
307 my @ind_tag = $input->multi_param('ind_tag');
308 my @indicator = $input->multi_param('indicator');
309 #Rebuilding ALL the data for items into a hash
310 # parting them on $itemid.
314 my $range=scalar(@itemid);
315 for (my $i=0; $i<$range; $i++){
316 unless ($itemhash{$itemid[$i]}){
319 push @{$itemhash{$itemid[$i]}->{'tags'}},$tags[$i];
320 push @{$itemhash{$itemid[$i]}->{'subfields'}},$subfields[$i];
321 push @{$itemhash{$itemid[$i]}->{'field_values'}},$field_values[$i];
322 push @{$itemhash{$itemid[$i]}->{'ind_tag'}},$ind_tag[$i];
323 push @{$itemhash{$itemid[$i]}->{'indicator'}},$indicator[$i];
325 foreach my $item (keys %itemhash){
326 my $xml = TransformHtmlToXml( $itemhash{$item}->{'tags'},
327 $itemhash{$item}->{'subfields'},
328 $itemhash{$item}->{'field_values'},
329 $itemhash{$item}->{'indicator'},
330 $itemhash{$item}->{'ind_tag'},
332 my $record=MARC::Record::new_from_xml($xml, 'UTF-8');
333 my ($barcodefield,$barcodesubfield) = GetMarcFromKohaField('items.barcode');
334 next unless ( defined $barcodefield && defined $barcodesubfield );
335 my $barcode = $record->subfield($barcodefield,$barcodesubfield) || '';
336 my $aBpref = C4::Context->preference('autoBarcode');
337 if( $barcode eq '' && $aBpref ne 'OFF'){
339 if ( $aBpref eq 'hbyymmincr'){
340 my ($homebranchfield,$homebranchsubfield) = GetMarcFromKohaField('items.homebranch');
341 my $homebranch = $record->subfield($homebranchfield,$homebranchsubfield);
342 $barcodeobj = C4::Barcodes->new($aBpref, $homebranch);
344 $barcodeobj = C4::Barcodes->new($aBpref);
346 $barcode = $barcodeobj->value();
347 $record->field($barcodefield)->delete_subfield( code => $barcodesubfield);
348 $record->field($barcodefield)->add_subfields($barcodesubfield => $barcode);
350 my ($biblionumber,$bibitemnum,$itemnumber) = AddItemFromMarc($record,$$orderinfo{biblionumber});
351 $order->add_item($itemnumber);
357 my $booksellerid=$$orderinfo{booksellerid};
358 if (my $import_batch_id=$$orderinfo{import_batch_id}) {
359 print $input->redirect("/cgi-bin/koha/acqui/addorderiso2709.pl?import_batch_id=$import_batch_id&basketno=$basketno&booksellerid=$booksellerid");
360 } elsif ( defined $orderinfo->{invoiceid} ) {
361 print $input->redirect("/cgi-bin/koha/acqui/parcel.pl?invoiceid=" . $orderinfo->{invoiceid});
363 print $input->redirect("/cgi-bin/koha/acqui/basket.pl?basketno=$basketno");