3 #script to show display basket of orders
4 #written by chris@katipo.co.nz 24/2/2000
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 create a new record to order it. This record shouldn't exist
38 the bookseller the librarian has to buy a new book.
41 the title of this new record.
44 the author of this new record.
46 =item publication year
47 the publication year of this new record.
50 the number of this order.
55 the basket number for this new order.
58 if this order comes from a suggestion.
61 the item's id in the breeding reservoir
76 use C4
::Suggestions
; # GetSuggestion
77 use C4
::Biblio
; # GetBiblioData GetMarcPrice
78 use C4
::Items
; #PrepareItemRecord
82 use C4
::Search qw
/FindDuplicate/;
84 #needed for z3950 import:
85 use C4
::ImportBatch qw
/GetImportRecordMarc SetImportRecordStatus/;
87 use Koha
::Acquisition
::Booksellers
;
88 use Koha
::Acquisition
::Currencies
;
89 use Koha
::BiblioFrameworks
;
90 use Koha
::DateUtils
qw( dt_from_string );
91 use Koha
::MarcSubfieldStructures
;
94 use Koha
::RecordProcessor
;
95 use Koha
::Subscriptions
;
98 my $booksellerid = $input->param('booksellerid'); # FIXME: else ERROR!
99 my $budget_id = $input->param('budget_id') || 0;
100 my $title = $input->param('title');
101 my $author = $input->param('author');
102 my $publicationyear = $input->param('publicationyear');
103 my $ordernumber = $input->param('ordernumber') || '';
104 our $biblionumber = $input->param('biblionumber');
105 our $basketno = $input->param('basketno');
106 my $suggestionid = $input->param('suggestionid');
107 my $uncertainprice = $input->param('uncertainprice');
108 my $import_batch_id = $input->param('import_batch_id'); # if this is filled, we come from a staged file, and we will return here after saving the order !
109 my $from_subscriptionid = $input->param('from_subscriptionid');
113 our ( $template, $loggedinuser, $cookie, $userflags ) = get_template_and_user
(
115 template_name
=> "acqui/neworderempty.tt",
118 flagsrequired
=> { acquisition
=> 'order_manage' },
123 our $marcflavour = C4
::Context
->preference('marcflavour');
126 my $order = GetOrder
($ordernumber);
127 $basketno = $order->{'basketno'};
130 our $basket = GetBasket
($basketno);
131 my $basketobj = Koha
::Acquisition
::Baskets
->find( $basketno );
132 $booksellerid = $basket->{booksellerid
} unless $booksellerid;
133 my $bookseller = Koha
::Acquisition
::Booksellers
->find( $booksellerid );
135 output_and_exit
( $input, $cookie, $template, 'unknown_basket') unless $basketobj;
136 output_and_exit
( $input, $cookie, $template, 'unknown_vendor') unless $bookseller;
138 my $contract = GetContract
({
139 contractnumber
=> $basket->{contractnumber
}
142 #simple parameters reading (all in one :-)
143 our $params = $input->Vars;
144 my $listprice=0; # the price, that can be in MARC record if we have one
145 if ( $ordernumber eq '' and defined $params->{'breedingid'}){
146 #we want to import from the breeding reservoir (from a z3950 search)
147 my ($marcrecord, $encoding) = MARCfindbreeding
($params->{'breedingid'});
148 die("Could not find the selected record in the reservoir, bailing") unless $marcrecord;
150 # Remove all the items (952) from the imported record
151 foreach my $item ($marcrecord->field('952')) {
152 $marcrecord->delete_field($item);
157 ($biblionumber,$duplicatetitle) = FindDuplicate
($marcrecord);
158 if($biblionumber && !$input->param('use_external_source')) {
159 #if duplicate record found and user did not decide yet, first warn user
160 #and let them choose between using a new record or an existing record
161 Load_Duplicate
($duplicatetitle);
164 #from this point: add a new record
165 C4
::Acquisition
::FillWithDefaultValues
($marcrecord, {only_mandatory
=> 1});
167 $params->{'frameworkcode'} or $params->{'frameworkcode'} = "";
168 ( $biblionumber, $bibitemnum ) = AddBiblio
( $marcrecord, $params->{'frameworkcode'} );
169 # get the price if there is one.
170 $listprice = GetMarcPrice
($marcrecord, $marcflavour);
171 SetImportRecordStatus
($params->{'breedingid'}, 'imported');
176 my ( @order_user_ids, @order_users, @catalog_details );
177 our $tagslib = GetMarcStructure
(1, 'ACQ', { unsafe
=> 1 } );
178 my ( $itemnumber_tag, $itemnumber_subtag ) = GetMarcFromKohaField
( 'items.itemnumber' );
179 if ( not $ordernumber ) { # create order
182 if ( $biblionumber ) {
183 $data = GetBiblioData
($biblionumber);
185 # get suggestion fields if applicable. If it's a subscription renewal, then the biblio already exists
186 # otherwise, retrieve suggestion information.
187 elsif ($suggestionid) {
188 $data = GetSuggestion
($suggestionid);
189 $budget_id ||= $data->{'budgetid'} // 0;
192 if ( not $biblionumber and Koha
::BiblioFrameworks
->find('ACQ') ) {
193 #my $acq_mss = Koha::MarcSubfieldStructures->search({ frameworkcode => 'ACQ', tagfield => { '!=' => $itemnumber_tag } });
194 foreach my $tag ( sort keys %{$tagslib} ) {
196 next if $tag eq $itemnumber_tag; # skip items fields
197 foreach my $subfield ( sort keys %{ $tagslib->{$tag} } ) {
198 my $mss = $tagslib->{$tag}{$subfield};
199 next if IsMarcStructureInternal
($mss);
200 next if $mss->{tab
} == -1;
201 my $value = $mss->{defaultvalue
};
203 if ($suggestionid and $mss->{kohafield
}) {
204 # Reading suggestion info if ordering from a suggestion
205 if ( $mss->{kohafield
} eq 'biblio.title' ) {
206 $value = $data->{title
};
208 elsif ( $mss->{kohafield
} eq 'biblio.author' ) {
209 $value = $data->{author
};
211 elsif ( $mss->{kohafield
} eq 'biblioitems.publishercode' ) {
212 $value = $data->{publishercode
};
214 elsif ( $mss->{kohafield
} eq 'biblioitems.editionstatement' ) {
215 $value = $data->{editionstatement
};
217 elsif ( $mss->{kohafield
} eq 'biblioitems.publicationyear' ) {
218 $value = $data->{publicationyear
};
220 elsif ( $mss->{kohafield
} eq 'biblioitems.isbn' ) {
221 $value = $data->{isbn
};
223 elsif ( $mss->{kohafield
} eq 'biblio.seriestitle' ) {
224 $value = $data->{seriestitle
};
230 # get today date & replace <<YYYY>>, <<YY>>, <<MM>>, <<DD>> if provided in the default value
231 my $today_dt = dt_from_string
;
232 my $year = $today_dt->strftime('%Y');
233 my $shortyear = $today_dt->strftime('%y');
234 my $month = $today_dt->strftime('%m');
235 my $day = $today_dt->strftime('%d');
236 $value =~ s/<<YYYY>>/$year/g;
237 $value =~ s/<<YY>>/$shortyear/g;
238 $value =~ s/<<MM>>/$month/g;
239 $value =~ s/<<DD>>/$day/g;
241 # And <<USER>> with surname (?)
243 ( C4
::Context
->userenv
244 ? C4
::Context
->userenv->{'surname'}
245 : "superlibrarian" );
246 $value =~ s/<<USER>>/$username/g;
248 push @catalog_details, {
250 subfield
=> $subfield,
251 %$mss, # Do we need plugins support (?)
259 $data = GetOrder
($ordernumber);
260 $budget_id = $data->{'budget_id'};
263 subscriptionid
=> $data->{subscriptionid
},
266 $basket = GetBasket
( $data->{'basketno'} );
267 $basketno = $basket->{'basketno'};
269 @order_user_ids = GetOrderUsers
($ordernumber);
270 foreach my $order_user_id (@order_user_ids) {
271 # FIXME Could be improved with search -in
272 my $order_patron = Koha
::Patrons
->find( $order_user_id );
273 push @order_users, $order_patron if $order_patron;
276 $biblionumber = $data->{biblionumber
};
279 # - no ordernumber but a biblionumber: from a subscription, from an existing record
280 # - no ordernumber, no biblionumber: from a suggestion, from a new order
281 if ( not $ordernumber or $biblionumber ) {
282 if ( C4
::Context
->preference('UseACQFrameworkForBiblioRecords') ) {
283 my $record = $biblionumber ? GetMarcBiblio
({ biblionumber
=> $biblionumber }) : undef;
284 foreach my $tag ( sort keys %{$tagslib} ) {
286 next if $tag eq $itemnumber_tag; # skip items fields
287 my @fields = $biblionumber ?
$record->field($tag) : ();
288 foreach my $subfield ( sort keys %{ $tagslib->{$tag} } ) {
289 my $mss = $tagslib->{$tag}{$subfield};
290 next if IsMarcStructureInternal
($mss);
291 next if $mss->{tab
} == -1;
292 # We only need to display the values
293 my $value = join '; ', map { $tag < 10 ?
$_->data : $_->subfield( $subfield ) } @fields;
295 push @catalog_details, {
297 subfield
=> $subfield,
307 $template->param( catalog_details
=> \
@catalog_details, );
310 $suggestion = GetSuggestionInfo
($suggestionid) if $suggestionid;
312 my @currencies = Koha
::Acquisition
::Currencies
->search;
313 my $active_currency = Koha
::Acquisition
::Currencies
->get_active;
315 # build bookfund list
316 my $patron = Koha
::Patrons
->find( $loggedinuser )->unblessed;
318 my $budget = GetBudget
($budget_id);
320 my $budget_loop = [];
321 my $budgets = GetBudgetHierarchy
;
322 foreach my $r (@
{$budgets}) {
323 next unless (CanUserUseBudget
($patron, $r, $userflags));
324 push @
{$budget_loop}, {
325 b_id
=> $r->{budget_id
},
326 b_txt
=> $r->{budget_name
},
327 b_sort1_authcat
=> $r->{'sort1_authcat'},
328 b_sort2_authcat
=> $r->{'sort2_authcat'},
329 b_active
=> $r->{budget_period_active
},
330 b_sel
=> ( $r->{budget_id
} == $budget_id ) ?
1 : 0,
331 b_level
=> $r->{budget_level
},
336 $template->param( sort1
=> $data->{'sort1'} );
337 $template->param( sort2
=> $data->{'sort2'} );
339 if ($basketobj->effective_create_items eq 'ordering' && !$ordernumber) {
340 # Check if ACQ framework exists
341 my $marc = GetMarcStructure
(1, 'ACQ', { unsafe
=> 1 } );
343 $template->param('NoACQframework' => 1);
346 AcqCreateItemOrdering
=> 1,
347 UniqueItemFields
=> C4
::Context
->preference('UniqueItemFields'),
351 # Get the item types list, but only if item_level_itype is YES. Otherwise, it will be in the item, no need to display it in the biblio
353 @itemtypes = Koha
::ItemTypes
->search unless C4
::Context
->preference('item-level_itypes');
355 if ( defined $from_subscriptionid ) {
356 # Get the last received order for this subscription
357 my $lastOrderReceived = Koha
::Acquisition
::Orders
->search(
359 subscriptionid
=> $from_subscriptionid,
360 datereceived
=> { '!=' => undef }
364 [ { -desc
=> 'datereceived' }, { -desc
=> 'ordernumber' } ]
367 if ( $lastOrderReceived->count ) {
368 $lastOrderReceived = $lastOrderReceived->next->unblessed; # FIXME We should send the object to the template
369 $budget_id = $lastOrderReceived->{budgetid
};
370 $data->{listprice
} = $lastOrderReceived->{listprice
};
371 $data->{uncertainprice
} = $lastOrderReceived->{uncertainprice
};
372 $data->{tax_rate
} = $lastOrderReceived->{tax_rate_on_ordering
};
373 $data->{discount
} = $lastOrderReceived->{discount
};
374 $data->{rrp
} = $lastOrderReceived->{rrp
};
375 $data->{replacementprice
} = $lastOrderReceived->{replacementprice
};
376 $data->{ecost
} = $lastOrderReceived->{ecost
};
377 $data->{quantity
} = $lastOrderReceived->{quantity
};
378 $data->{unitprice
} = $lastOrderReceived->{unitprice
};
379 $data->{order_internalnote
} = $lastOrderReceived->{order_internalnote
};
380 $data->{order_vendornote
} = $lastOrderReceived->{order_vendornote
};
381 $data->{sort1
} = $lastOrderReceived->{sort1
};
382 $data->{sort2
} = $lastOrderReceived->{sort2
};
384 $basket = GetBasket
( $input->param('basketno') );
387 my $subscription = Koha
::Subscriptions
->find($from_subscriptionid);
389 subscriptionid
=> $from_subscriptionid,
390 subscription
=> $subscription,
394 # Find the items.barcode subfield for barcode validations
395 my (undef, $barcode_subfield) = GetMarcFromKohaField
( 'items.barcode' );
398 # get option values for gist syspref
399 my @gst_values = map {
401 }, split( '\|', C4
::Context
->preference("gist") );
403 my $quantity = $input->param('rr_quantity_to_order') ?
404 $input->param('rr_quantity_to_order') :
410 existing
=> $biblionumber,
411 ordernumber
=> $ordernumber,
412 # basket informations
413 basketno
=> $basketno,
415 basketname
=> $basket->{'basketname'},
416 basketnote
=> $basket->{'note'},
417 booksellerid
=> $basket->{'booksellerid'},
418 basketbooksellernote
=> $basket->{booksellernote
},
419 basketcontractno
=> $basket->{contractnumber
},
420 basketcontractname
=> $contract->{contractname
},
421 creationdate
=> $basket->{creationdate
},
422 authorisedby
=> $basket->{'authorisedby'},
423 authorisedbyname
=> $basket->{'authorisedbyname'},
424 closedate
=> $basket->{'closedate'},
426 suggestionid
=> $suggestion->{suggestionid
},
427 surnamesuggestedby
=> $suggestion->{surnamesuggestedby
},
428 firstnamesuggestedby
=> $suggestion->{firstnamesuggestedby
},
429 biblionumber
=> $biblionumber,
430 uncertainprice
=> $data->{'uncertainprice'},
431 discount_2dp
=> sprintf( "%.2f", $bookseller->discount ) , # for display
432 discount
=> $bookseller->discount,
433 orderdiscount_2dp
=> sprintf( "%.2f", $data->{'discount'} || 0 ),
434 orderdiscount
=> $data->{'discount'},
435 order_internalnote
=> $data->{'order_internalnote'},
436 order_vendornote
=> $data->{'order_vendornote'},
437 listincgst
=> $bookseller->listincgst,
438 invoiceincgst
=> $bookseller->invoiceincgst,
439 name
=> $bookseller->name,
440 cur_active_sym
=> $active_currency->symbol,
441 cur_active
=> $active_currency->currency,
442 currencies
=> \
@currencies,
443 currency
=> $data->{currency
},
444 vendor_currency
=> $bookseller->listprice,
445 orderexists
=> ( $new eq 'yes' ) ?
0 : 1,
446 title
=> $data->{'title'},
447 author
=> $data->{'author'},
448 publicationyear
=> $data->{'publicationyear'} ?
$data->{'publicationyear'} : $data->{'copyrightdate'},
449 editionstatement
=> $data->{'editionstatement'},
450 budget_loop
=> $budget_loop,
451 isbn
=> $data->{'isbn'},
452 ean
=> $data->{'ean'},
453 seriestitle
=> $data->{'seriestitle'},
454 itemtypeloop
=> \
@itemtypes,
455 quantity
=> $quantity,
456 quantityrec
=> $quantity,
457 rrp
=> $data->{'rrp'},
458 replacementprice
=> $data->{'replacementprice'},
459 gst_values
=> \
@gst_values,
460 tax_rate
=> $data->{tax_rate_on_ordering
} ?
$data->{tax_rate_on_ordering
}+0.0 : $bookseller->tax_rate ?
$bookseller->tax_rate+0.0 : 0,
461 listprice
=> sprintf( "%.2f", $data->{listprice
} || $data->{price
} || $listprice),
462 total
=> sprintf( "%.2f", ($data->{ecost
} || 0) * ($data->{'quantity'} || 0) ),
463 ecost
=> sprintf( "%.2f", $data->{ecost
} || 0),
464 unitprice
=> sprintf( "%.2f", $data->{unitprice
} || 0),
465 publishercode
=> $data->{'publishercode'},
466 barcode_subfield
=> $barcode_subfield,
467 import_batch_id
=> $import_batch_id,
468 acqcreate
=> $basketobj->effective_create_items eq "ordering" ?
1 : "",
469 users_ids
=> join(':', @order_user_ids),
470 users
=> \
@order_users,
471 (uc(C4
::Context
->preference("marcflavour"))) => 1
474 output_html_with_http_headers
$input, $cookie, $template->output;
477 =head2 MARCfindbreeding
479 $record = MARCfindbreeding($breedingid);
481 Look up the import record repository for the record with
482 record with id $breedingid. If found, returns the decoded
483 MARC::Record; otherwise, -1 is returned (FIXME).
484 Returns as second parameter the character encoding.
488 sub MARCfindbreeding
{
490 my ($marc, $encoding) = GetImportRecordMarc
($id);
491 # remove the - in isbn, koha store isbn without any -
493 my $record = MARC
::Record
->new_from_usmarc($marc);
494 my ($isbnfield,$isbnsubfield) = GetMarcFromKohaField
( 'biblioitems.isbn' );
495 if ( $record->field($isbnfield) ) {
496 foreach my $field ( $record->field($isbnfield) ) {
497 foreach my $subfield ( $field->subfield($isbnsubfield) ) {
498 my $newisbn = $field->subfield($isbnsubfield);
500 $field->update( $isbnsubfield => $newisbn );
504 # fix the unimarc 100 coded field (with unicode information)
505 if ($marcflavour eq 'UNIMARC' && $record->subfield(100,'a')) {
506 my $f100a=$record->subfield(100,'a');
507 my $f100 = $record->field(100);
508 my $f100temp = $f100->as_string;
509 $record->delete_field($f100);
510 if ( length($f100temp) > 28 ) {
511 substr( $f100temp, 26, 2, "50" );
512 $f100->update( 'a' => $f100temp );
513 my $f100 = MARC
::Field
->new( '100', '', '', 'a' => $f100temp );
514 $record->insert_fields_ordered($f100);
518 if ( !defined(ref($record)) ) {
522 # normalize author : probably UNIMARC specific...
523 if ( C4
::Context
->preference("z3950NormalizeAuthor")
524 and C4
::Context
->preference("z3950AuthorAuthFields") )
526 my ( $tag, $subfield ) = GetMarcFromKohaField
( "biblio.author" );
529 C4
::Context
->preference("z3950AuthorAuthFields");
530 my @auth_fields = split /,/, $auth_fields;
533 if ( $record->field($tag) ) {
534 foreach my $tmpfield ( $record->field($tag)->subfields ) {
536 my $subfieldcode = shift @
$tmpfield;
537 my $subfieldvalue = shift @
$tmpfield;
539 $field->add_subfields(
540 "$subfieldcode" => $subfieldvalue )
541 if ( $subfieldcode ne $subfield );
545 MARC
::Field
->new( $tag, "", "",
546 $subfieldcode => $subfieldvalue )
547 if ( $subfieldcode ne $subfield );
551 $record->delete_field( $record->field($tag) );
552 foreach my $fieldtag (@auth_fields) {
553 next unless ( $record->field($fieldtag) );
554 my $lastname = $record->field($fieldtag)->subfield('a');
555 my $firstname = $record->field($fieldtag)->subfield('b');
556 my $title = $record->field($fieldtag)->subfield('c');
557 my $number = $record->field($fieldtag)->subfield('d');
559 $field->add_subfields(
560 "$subfield" => ucfirst($title) . " "
561 . ucfirst($firstname) . " "
565 $field->add_subfields(
566 "$subfield" => ucfirst($firstname) . ", "
567 . ucfirst($lastname) );
570 $record->insert_fields_ordered($field);
572 return $record, $encoding;
579 my ($duplicatetitle)= @_;
580 ($template, $loggedinuser, $cookie) = get_template_and_user
(
582 template_name
=> "acqui/neworderempty_duplicate.tt",
585 flagsrequired
=> { acquisition
=> 'order_manage' },
591 biblionumber
=> $biblionumber,
592 basketno
=> $basketno,
593 booksellerid
=> $basket->{'booksellerid'},
594 breedingid
=> $params->{'breedingid'},
595 duplicatetitle
=> $duplicatetitle,
596 (uc(C4
::Context
->preference("marcflavour"))) => 1
599 output_html_with_http_headers
$input, $cookie, $template->output;