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.
142 # Check if order total amount exceed allowed budget
143 my $confirm_budget_exceeding = $input->param('confirm_budget_exceeding');
144 unless($confirm_budget_exceeding) {
145 my $budget_id = $input->param('budget_id');
146 my $total = $input->param('total');
147 my $budget = GetBudget
($budget_id);
148 my $budget_spent = GetBudgetSpent
($budget_id);
149 my $budget_ordered = GetBudgetOrdered
($budget_id);
150 my $budget_used = $budget_spent + $budget_ordered;
151 my $budget_remaining = $budget->{budget_amount
} - $budget_used;
152 my $budget_encumbrance = $budget->{budget_amount
} * $budget->{budget_encumb
} / 100;
153 my $budget_expenditure = $budget->{budget_expend
};
155 if ( $total > $budget_remaining
156 || ( ($budget_encumbrance+0) && ($budget_used + $total) > $budget_encumbrance)
157 || ( ($budget_expenditure+0) && ($budget_used + $total) > $budget_expenditure) )
159 my ($template, $loggedinuser, $cookie) = get_template_and_user
({
160 template_name
=> "acqui/addorder.tt",
163 authnotrequired
=> 0,
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 authnotrequired
=> 0,
221 flagsrequired
=> { acquisition
=> 'order_manage' },
227 my $orderinfo = $input->Vars;
228 $orderinfo->{'list_price'} ||= 0;
229 $orderinfo->{'uncertainprice'} ||= 0;
230 $orderinfo->{subscriptionid
} ||= undef;
232 my $user = $input->remote_user;
233 my $basketno = $$orderinfo{basketno
};
234 my $basket = Koha
::Acquisition
::Baskets
->find($basketno);
236 # create, modify or delete biblio
237 # create if $quantity>0 and $existing='no'
238 # modify if $quantity>0 and $existing='yes'
239 if ( $basket->{is_standing
} || $orderinfo->{quantity
} ne '0' ) {
240 #TODO:check to see if biblio exists
241 unless ( $$orderinfo{biblionumber
} ) {
242 #if it doesn't create it
243 my $record = TransformKohaToMarc
(
245 "biblio.title" => "$$orderinfo{title}",
246 "biblio.author" => $$orderinfo{author
} ?
$$orderinfo{author
} : "",
247 "biblio.seriestitle" => $$orderinfo{series
} ?
$$orderinfo{series
} : "",
248 "biblioitems.isbn" => $$orderinfo{isbn
} ?
$$orderinfo{isbn
} : "",
249 "biblioitems.ean" => $$orderinfo{ean
} ?
$$orderinfo{ean
} : "",
250 "biblioitems.publishercode" => $$orderinfo{publishercode
} ?
$$orderinfo{publishercode
} : "",
251 "biblioitems.publicationyear" => $$orderinfo{publicationyear
} ?
$$orderinfo{publicationyear
}: "",
252 "biblio.copyrightdate" => $$orderinfo{publicationyear
} ?
$$orderinfo{publicationyear
}: "",
253 "biblioitems.itemtype" => $$orderinfo{itemtype
} ?
$$orderinfo{itemtype
} : "",
254 "biblioitems.editionstatement"=> $$orderinfo{editionstatement
} ?
$$orderinfo{editionstatement
} : "",
257 C4
::Acquisition
::FillWithDefaultValues
( $record );
259 # create the record in catalogue, with framework ''
260 my ($biblionumber,$bibitemnum) = AddBiblio
($record,'');
261 # change suggestion status if applicable
262 if ($$orderinfo{suggestionid
}) {
263 ModSuggestion
( {suggestionid
=>$$orderinfo{suggestionid
}, STATUS
=>'ORDERED', biblionumber
=>$biblionumber} );
265 $orderinfo->{biblionumber
}=$biblionumber;
268 $orderinfo->{unitprice
} = $orderinfo->{ecost
} if not defined $orderinfo->{unitprice
} or $orderinfo->{unitprice
} eq '';
270 $orderinfo = C4
::Acquisition
::populate_order_with_prices
(
273 booksellerid
=> $orderinfo->{booksellerid
},
278 # if we already have $ordernumber, then it's an ordermodif
279 my $order = Koha
::Acquisition
::Order
->new($orderinfo);
280 if ( $orderinfo->{ordernumber
} ) {
281 ModOrder
($orderinfo);
282 my $order_users_ids = $input->param('users_ids');
283 my @order_users = split( /:/, $order_users_ids );
285 ModOrderUsers
( $orderinfo->{ordernumber
}, @order_users );
287 else { # else, it's a new line
291 # now, add items if applicable
292 if ($basket->effective_create_items eq 'ordering') {
294 my @tags = $input->multi_param('tag');
295 my @subfields = $input->multi_param('subfield');
296 my @field_values = $input->multi_param('field_value');
297 my @serials = $input->multi_param('serial');
298 my @itemid = $input->multi_param('itemid');
299 my @ind_tag = $input->multi_param('ind_tag');
300 my @indicator = $input->multi_param('indicator');
301 #Rebuilding ALL the data for items into a hash
302 # parting them on $itemid.
306 my $range=scalar(@itemid);
307 for (my $i=0; $i<$range; $i++){
308 unless ($itemhash{$itemid[$i]}){
311 push @
{$itemhash{$itemid[$i]}->{'tags'}},$tags[$i];
312 push @
{$itemhash{$itemid[$i]}->{'subfields'}},$subfields[$i];
313 push @
{$itemhash{$itemid[$i]}->{'field_values'}},$field_values[$i];
314 push @
{$itemhash{$itemid[$i]}->{'ind_tag'}},$ind_tag[$i];
315 push @
{$itemhash{$itemid[$i]}->{'indicator'}},$indicator[$i];
317 foreach my $item (keys %itemhash){
318 my $xml = TransformHtmlToXml
( $itemhash{$item}->{'tags'},
319 $itemhash{$item}->{'subfields'},
320 $itemhash{$item}->{'field_values'},
321 $itemhash{$item}->{'indicator'},
322 $itemhash{$item}->{'ind_tag'},
324 my $record=MARC
::Record
::new_from_xml
($xml, 'UTF-8');
325 my ($barcodefield,$barcodesubfield) = GetMarcFromKohaField
('items.barcode');
326 next unless ( defined $barcodefield && defined $barcodesubfield );
327 my $barcode = $record->subfield($barcodefield,$barcodesubfield) || '';
328 my $aBpref = C4
::Context
->preference('autoBarcode');
329 if( $barcode eq '' && $aBpref ne 'OFF'){
331 if ( $aBpref eq 'hbyymmincr'){
332 my ($homebranchfield,$homebranchsubfield) = GetMarcFromKohaField
('items.homebranch');
333 my $homebranch = $record->subfield($homebranchfield,$homebranchsubfield);
334 $barcodeobj = C4
::Barcodes
->new($aBpref, $homebranch);
336 $barcodeobj = C4
::Barcodes
->new($aBpref);
338 $barcode = $barcodeobj->value();
339 $record->field($barcodefield)->delete_subfield( code
=> $barcodesubfield);
340 $record->field($barcodefield)->add_subfields($barcodesubfield => $barcode);
342 my ($biblionumber,$bibitemnum,$itemnumber) = AddItemFromMarc
($record,$$orderinfo{biblionumber
});
343 $order->add_item($itemnumber);
349 my $booksellerid=$$orderinfo{booksellerid
};
350 if (my $import_batch_id=$$orderinfo{import_batch_id
}) {
351 print $input->redirect("/cgi-bin/koha/acqui/addorderiso2709.pl?import_batch_id=$import_batch_id&basketno=$basketno&booksellerid=$booksellerid");
352 } elsif ( defined $orderinfo->{invoiceid
} ) {
353 print $input->redirect("/cgi-bin/koha/acqui/parcel.pl?invoiceid=" . $orderinfo->{invoiceid
});
355 print $input->redirect("/cgi-bin/koha/acqui/basket.pl?basketno=$basketno");