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 under the
11 # terms of the GNU General Public License as published by the Free Software
12 # Foundation; either version 2 of the License, or (at your option) any later
15 # Koha is distributed in the hope that it will be useful, but WITHOUT ANY
16 # WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR
17 # A PARTICULAR PURPOSE. See the GNU General Public License for more details.
19 # You should have received a copy of the GNU General Public License along
20 # with Koha; if not, write to the Free Software Foundation, Inc.,
21 # 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA.
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.
125 use C4
::Auth
; # get_template_and_user
126 use C4
::Acquisition
; # NewOrder DelOrder ModOrder
127 use C4
::Suggestions
; # ModStatus
128 use C4
::Biblio
; # AddBiblio TransformKohaToMarc
133 ### "-------------------- addorder.pl ----------"
135 # FIXME: This needs to do actual error checking and possibly return user to the same form,
136 # not just blindly call C4 functions and print a redirect.
140 # Check if order total amount exceed allowed budget
141 my $confirm_budget_exceeding = $input->param('confirm_budget_exceeding');
142 unless($confirm_budget_exceeding) {
143 my $budget_id = $input->param('budget_id');
144 my $total = $input->param('total');
145 my $budget = GetBudget
($budget_id);
146 my $budget_spent = GetBudgetSpent
($budget_id);
147 my $budget_ordered = GetBudgetOrdered
($budget_id);
148 my $budget_used = $budget_spent + $budget_ordered;
149 my $budget_remaining = $budget->{budget_amount
} - $budget_used;
150 my $budget_encumbrance = $budget->{budget_amount
} * $budget->{budget_encumb
} / 100;
151 my $budget_expenditure = $budget->{budget_expend
};
153 if ( $total > $budget_remaining
154 || ( ($budget_encumbrance+0) && ($budget_used + $total) > $budget_encumbrance)
155 || ( ($budget_expenditure+0) && ($budget_used + $total) > $budget_expenditure) )
157 my ($template, $loggedinuser, $cookie) = get_template_and_user
({
158 template_name
=> "acqui/addorder.tt",
161 authnotrequired
=> 0,
162 flagsrequired
=> {acquisition
=> 'order_manage'},
165 my $url = $input->referer();
166 unless ( defined $url ) {
167 my $basketno = $input->param('basketno');
168 $url = "/cgi-bin/koha/acqui/basket.pl?basketno=$basketno";
171 my $vars = $input->Vars;
173 foreach (keys %$vars) {
176 values => [$input->param($_)],
180 if( ($budget_encumbrance+0) && ($budget_used + $total) > $budget_encumbrance
181 && $total <= $budget_remaining)
184 encumbrance_exceeded
=> 1,
185 encumbrance
=> sprintf("%.2f", $budget->{'budget_encumb'}),
188 if( ($budget_expenditure+0) && ($budget_used + $total) > $budget_expenditure
189 && $total <= $budget_remaining )
191 my $currency = GetCurrency
;
193 expenditure_exceeded
=> 1,
194 expenditure
=> sprintf("%.2f", $budget_expenditure),
195 currency
=> ($currency) ?
$currency->{'symbol'} : '',
198 if($total > $budget_remaining){
199 $template->param(budget_exceeded
=> 1);
203 not_enough_budget
=> 1,
205 vars_loop
=> \
@vars_loop,
207 output_html_with_http_headers
$input, $cookie, $template->output;
212 # get_template_and_user used only to check auth & get user id
213 my ( $template, $loggedinuser, $cookie ) = get_template_and_user
(
215 template_name
=> "acqui/booksellers.tt",
218 authnotrequired
=> 0,
219 flagsrequired
=> { acquisition
=> 'order_manage' },
225 my $orderinfo = $input->Vars;
226 $orderinfo->{'list_price'} ||= 0;
227 $orderinfo->{'uncertainprice'} ||= 0;
228 $orderinfo->{subscriptionid
} ||= undef;
230 my $user = $input->remote_user;
232 # create, modify or delete biblio
233 # create if $quantity>=0 and $existing='no'
234 # modify if $quantity>=0 and $existing='yes'
235 # delete if $quantity has been set to 0 by the librarian
236 # delete biblio if delbiblio has been set to 1 by the librarian
237 if ( $orderinfo->{quantity
} ne '0' ) {
238 #TODO:check to see if biblio exists
239 unless ( $$orderinfo{biblionumber
} ) {
240 #if it doesnt create it
241 my $record = TransformKohaToMarc
(
243 "biblio.title" => "$$orderinfo{title}",
244 "biblio.author" => $$orderinfo{author
} ?
$$orderinfo{author
} : "",
245 "biblio.seriestitle" => $$orderinfo{series
} ?
$$orderinfo{series
} : "",
246 "biblioitems.isbn" => $$orderinfo{isbn
} ?
$$orderinfo{isbn
} : "",
247 "biblioitems.ean" => $$orderinfo{ean
} ?
$$orderinfo{ean
} : "",
248 "biblioitems.publishercode" => $$orderinfo{publishercode
} ?
$$orderinfo{publishercode
} : "",
249 "biblioitems.publicationyear" => $$orderinfo{publicationyear
} ?
$$orderinfo{publicationyear
}: "",
250 "biblio.copyrightdate" => $$orderinfo{publicationyear
} ?
$$orderinfo{publicationyear
}: "",
251 "biblioitems.itemtype" => $$orderinfo{itemtype
} ?
$$orderinfo{itemtype
} : "",
252 "biblioitems.editionstatement"=> $$orderinfo{editionstatement
} ?
$$orderinfo{editionstatement
} : "",
253 "aqorders.branchcode" => $$orderinfo{branchcode
} ?
$$orderinfo{branchcode
} : "",
254 "aqorders.quantity" => $$orderinfo{quantity
} ?
$$orderinfo{quantity
} : "",
255 "aqorders.listprice" => $$orderinfo{listprice
} ?
$$orderinfo{listprice
} : "",
256 "aqorders.uncertainprice" => $$orderinfo{uncertainprice
} ?
$$orderinfo{uncertainprice
} : "",
257 "aqorders.rrp" => $$orderinfo{rrp
} ?
$$orderinfo{rrp
} : "",
258 "aqorders.ecost" => $$orderinfo{ecost
} ?
$$orderinfo{ecost
} : "",
259 "aqorders.discount" => $$orderinfo{discount
} ?
$$orderinfo{discount
} : "",
262 # create the record in catalogue, with framework ''
263 my ($biblionumber,$bibitemnum) = AddBiblio
($record,'');
264 # change suggestion status if applicable
265 if ($$orderinfo{suggestionid
}) {
266 ModSuggestion
( {suggestionid
=>$$orderinfo{suggestionid
}, STATUS
=>'ORDERED', biblionumber
=>$biblionumber} );
268 $orderinfo->{biblionumber
}=$biblionumber;
271 $orderinfo->{unitprice
} = $orderinfo->{ecost
} if not defined $orderinfo->{unitprice
} or $orderinfo->{unitprice
} eq '';
273 # if we already have $ordernumber, then it's an ordermodif
274 if ($$orderinfo{ordernumber
}) {
275 ModOrder
( $orderinfo);
277 else { # else, it's a new line
278 $orderinfo->{ordernumber
} = NewOrder
($orderinfo);
281 # now, add items if applicable
282 if (C4
::Context
->preference('AcqCreateItem') eq 'ordering') {
284 my @tags = $input->param('tag');
285 my @subfields = $input->param('subfield');
286 my @field_values = $input->param('field_value');
287 my @serials = $input->param('serial');
288 my @itemid = $input->param('itemid');
289 my @ind_tag = $input->param('ind_tag');
290 my @indicator = $input->param('indicator');
291 #Rebuilding ALL the data for items into a hash
292 # parting them on $itemid.
296 my $range=scalar(@itemid);
297 for (my $i=0; $i<$range; $i++){
298 unless ($itemhash{$itemid[$i]}){
301 push @
{$itemhash{$itemid[$i]}->{'tags'}},$tags[$i];
302 push @
{$itemhash{$itemid[$i]}->{'subfields'}},$subfields[$i];
303 push @
{$itemhash{$itemid[$i]}->{'field_values'}},$field_values[$i];
304 push @
{$itemhash{$itemid[$i]}->{'ind_tag'}},$ind_tag[$i];
305 push @
{$itemhash{$itemid[$i]}->{'indicator'}},$indicator[$i];
307 foreach my $item (keys %itemhash){
309 my $xml = TransformHtmlToXml
( $itemhash{$item}->{'tags'},
310 $itemhash{$item}->{'subfields'},
311 $itemhash{$item}->{'field_values'},
312 $itemhash{$item}->{'ind_tag'},
313 $itemhash{$item}->{'indicator'},
315 my $record=MARC
::Record
::new_from_xml
($xml, 'UTF-8');
316 my ($biblionumber,$bibitemnum,$itemnumber) = AddItemFromMarc
($record,$$orderinfo{biblionumber
});
317 NewOrderItem
($itemnumber, $$orderinfo{ordernumber
});
324 else { # qty=0, delete the line
325 my $biblionumber = $input->param('biblionumber');
326 DelOrder
( $biblionumber, $$orderinfo{ordernumber
} );
327 if ($orderinfo->{delbiblio
} == 1){
328 DelBiblio
($biblionumber);
331 my $basketno=$$orderinfo{basketno
};
332 my $booksellerid=$$orderinfo{booksellerid
};
333 if (my $import_batch_id=$$orderinfo{import_batch_id
}) {
334 print $input->redirect("/cgi-bin/koha/acqui/addorderiso2709.pl?import_batch_id=$import_batch_id&basketno=$basketno&booksellerid=$booksellerid");
335 } elsif ( defined $orderinfo->{invoiceid
} ) {
336 print $input->redirect("/cgi-bin/koha/acqui/parcel.pl?invoiceid=" . $orderinfo->{invoiceid
});
338 print $input->redirect("/cgi-bin/koha/acqui/basket.pl?basketno=$basketno");