Bug 22656: Fix charts in reports
[koha.git] / acqui / basket.pl
blobe9bf7cd440a7f9ae35eb38b605d054a6d16001ba
1 #!/usr/bin/perl
3 #script to show display basket of orders
5 # Copyright 2000 - 2004 Katipo
6 # Copyright 2008 - 2009 BibLibre SARL
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>.
23 use Modern::Perl;
24 use C4::Auth;
25 use C4::Koha;
26 use C4::Output;
27 use CGI qw ( -utf8 );
28 use C4::Acquisition;
29 use C4::Budgets;
30 use C4::Contract;
31 use C4::Debug;
32 use C4::Biblio;
33 use C4::Items;
34 use C4::Suggestions;
35 use Koha::Biblios;
36 use Koha::Acquisition::Baskets;
37 use Koha::Acquisition::Booksellers;
38 use Koha::Acquisition::Orders;
39 use Koha::Libraries;
40 use C4::Letters qw/SendAlerts/;
41 use Date::Calc qw/Add_Delta_Days/;
42 use Koha::Database;
43 use Koha::EDI qw( create_edi_order get_edifact_ean );
44 use Koha::CsvProfiles;
45 use Koha::Patrons;
47 use Koha::AdditionalFields;
49 =head1 NAME
51 basket.pl
53 =head1 DESCRIPTION
55 This script display all informations about basket for the supplier given
56 on input arg. Moreover, it allows us to add a new order for this supplier from
57 an existing record, a suggestion or a new record.
59 =head1 CGI PARAMETERS
61 =over 4
63 =item $basketno
65 The basket number.
67 =item booksellerid
69 the supplier this script have to display the basket.
71 =item order
73 =back
75 =cut
77 our $query = new CGI;
78 our $basketno = $query->param('basketno');
79 our $ean = $query->param('ean');
80 our $booksellerid = $query->param('booksellerid');
81 my $duplinbatch = $query->param('duplinbatch');
83 our ( $template, $loggedinuser, $cookie, $userflags ) = get_template_and_user(
85 template_name => "acqui/basket.tt",
86 query => $query,
87 type => "intranet",
88 authnotrequired => 0,
89 flagsrequired => { acquisition => 'order_manage' },
90 debug => 1,
94 our $basket = GetBasket($basketno);
95 $booksellerid = $basket->{booksellerid} unless $booksellerid;
96 my $bookseller = Koha::Acquisition::Booksellers->find( $booksellerid );
97 my $schema = Koha::Database->new()->schema();
98 my $rs = $schema->resultset('VendorEdiAccount')->search(
99 { vendor_id => $booksellerid, } );
100 $template->param( ediaccount => ($rs->count > 0));
102 unless (CanUserManageBasket($loggedinuser, $basket, $userflags)) {
103 $template->param(
104 cannot_manage_basket => 1,
105 basketno => $basketno,
106 basketname => $basket->{basketname},
107 booksellerid => $booksellerid,
108 booksellername => $bookseller->name,
110 output_html_with_http_headers $query, $cookie, $template->output;
111 exit;
114 # FIXME : what about the "discount" percentage?
115 # FIXME : the query->param('booksellerid') below is probably useless. The bookseller is always known from the basket
116 # if no booksellerid in parameter, get it from basket
117 # warn "=>".$basket->{booksellerid};
118 my $op = $query->param('op') // 'list';
120 our $confirm_pref= C4::Context->preference("BasketConfirmations") || '1';
121 $template->param( skip_confirm_reopen => 1) if $confirm_pref eq '2';
123 my @messages;
125 if ( $op eq 'delete_confirm' ) {
126 my $basketno = $query->param('basketno');
127 my $delbiblio = $query->param('delbiblio');
128 my @orders = GetOrders($basketno);
129 #Delete all orders included in that basket, and all items received.
130 foreach my $myorder (@orders){
131 DelOrder($myorder->{biblionumber},$myorder->{ordernumber});
133 # if $delbiblio = 1, delete the records if possible
134 if ((defined $delbiblio)and ($delbiblio ==1)){
135 my @cannotdelbiblios ;
136 foreach my $myorder (@orders){
137 my $biblionumber = $myorder->{'biblionumber'};
138 my $biblio = Koha::Biblios->find( $biblionumber );
139 my $countbiblio = CountBiblioInOrders($biblionumber);
140 my $ordernumber = $myorder->{'ordernumber'};
141 my $cnt_subscriptions = $biblio->subscriptions->count;
142 my $itemcount = $biblio->items->count;
143 my $error;
144 if ($countbiblio == 0 && $itemcount == 0 && not $cnt_subscriptions ) {
145 $error = DelBiblio($myorder->{biblionumber}) }
146 else {
147 push @cannotdelbiblios, {biblionumber=> ($myorder->{biblionumber}),
148 title=> $myorder->{'title'},
149 author=> $myorder->{'author'},
150 countbiblio=> $countbiblio,
151 itemcount=>$itemcount,
152 subscriptions => $cnt_subscriptions};
154 if ($error) {
155 push @cannotdelbiblios, {biblionumber=> ($myorder->{biblionumber}),
156 title=> $myorder->{'title'},
157 author=> $myorder->{'author'},
158 othererror=> $error};
161 $template->param( cannotdelbiblios => \@cannotdelbiblios );
163 # delete the basket
164 DelBasket($basketno,);
165 $template->param(
166 delete_confirmed => 1,
167 booksellername => $bookseller->name,
168 booksellerid => $booksellerid,
170 } elsif ( !$bookseller ) {
171 $template->param( NO_BOOKSELLER => 1 );
172 } elsif ($op eq 'export') {
173 print $query->header(
174 -type => 'text/csv',
175 -attachment => 'basket' . $basket->{'basketno'} . '.csv',
177 my $csv_profile_id = $query->param('csv_profile');
178 print GetBasketAsCSV( scalar $query->param('basketno'), $query, $csv_profile_id ); # if no csv_profile_id passed, using default rows
179 exit;
180 } elsif ($op eq 'email') {
181 my $err = eval {
182 SendAlerts( 'orderacquisition', $query->param('basketno'), 'ACQORDER' );
184 if ( $@ ) {
185 push @messages, { type => 'error', code => $@ };
186 } elsif ( ref $err and exists $err->{error} ) {
187 push @messages, { type => 'error', code => $err->{error} };
188 } else {
189 push @messages, { type => 'message', code => 'email_sent' };
192 $op = 'list';
193 } elsif ($op eq 'close') {
194 my $confirm = $query->param('confirm') || $confirm_pref eq '2';
195 if ($confirm) {
196 my $basketno = $query->param('basketno');
197 my $booksellerid = $query->param('booksellerid');
198 $basketno =~ /^\d+$/ and CloseBasket($basketno);
199 # if requested, create basket group, close it and attach the basket
200 if ($query->param('createbasketgroup')) {
201 my $branchcode;
202 if(C4::Context->userenv and C4::Context->userenv->{'branch'}
203 and C4::Context->userenv->{'branch'} ne "NO_LIBRARY_SET") {
204 $branchcode = C4::Context->userenv->{'branch'};
206 my $basketgroupid = NewBasketgroup( { name => $basket->{basketname},
207 booksellerid => $booksellerid,
208 deliveryplace => $branchcode,
209 billingplace => $branchcode,
210 closed => 1,
212 ModBasket( { basketno => $basketno,
213 basketgroupid => $basketgroupid } );
214 print $query->redirect('/cgi-bin/koha/acqui/basketgroup.pl?booksellerid='.$booksellerid.'&closed=1');
215 } else {
216 print $query->redirect('/cgi-bin/koha/acqui/booksellers.pl?booksellerid=' . $booksellerid);
218 exit;
219 } else {
220 $template->param(
221 confirm_close => "1",
222 booksellerid => $booksellerid,
223 booksellername => $bookseller->name,
224 basketno => $basket->{'basketno'},
225 basketname => $basket->{'basketname'},
226 basketgroupname => $basket->{'basketname'},
229 } elsif ($op eq 'reopen') {
230 ReopenBasket(scalar $query->param('basketno'));
231 print $query->redirect('/cgi-bin/koha/acqui/basket.pl?basketno='.$basket->{'basketno'})
233 elsif ( $op eq 'ediorder' ) {
234 edi_close_and_order()
235 } elsif ( $op eq 'mod_users' ) {
236 my $basketusers_ids = $query->param('users_ids');
237 my @basketusers = split( /:/, $basketusers_ids );
238 ModBasketUsers($basketno, @basketusers);
239 print $query->redirect("/cgi-bin/koha/acqui/basket.pl?basketno=$basketno");
240 exit;
241 } elsif ( $op eq 'mod_branch' ) {
242 my $branch = $query->param('branch');
243 $branch = undef if(defined $branch and $branch eq '');
244 ModBasket({
245 basketno => $basket->{basketno},
246 branch => $branch
248 print $query->redirect("/cgi-bin/koha/acqui/basket.pl?basketno=$basketno");
249 exit;
252 if ( $op eq 'list' ) {
253 my @branches_loop;
254 # get librarian branch...
255 if ( C4::Context->preference("IndependentBranches") ) {
256 my $userenv = C4::Context->userenv;
257 unless ( C4::Context->IsSuperLibrarian() ) {
258 my $validtest = ( $basket->{creationdate} eq '' )
259 || ( $userenv->{branch} eq $basket->{branch} )
260 || ( $userenv->{branch} eq '' )
261 || ( $basket->{branch} eq '' );
262 unless ($validtest) {
263 print $query->redirect("../mainpage.pl");
264 exit 0;
268 if (!defined $basket->{branch} or $basket->{branch} eq $userenv->{branch}) {
269 push @branches_loop, {
270 branchcode => $userenv->{branch},
271 branchname => $userenv->{branchname},
272 selected => 1,
275 } else {
276 # get branches
277 my $branches = Koha::Libraries->search( {}, { order_by => ['branchname'] } )->unblessed;
278 foreach my $branch (@$branches) {
279 my $selected = 0;
280 if (defined $basket->{branch}) {
281 $selected = 1 if $branch->{branchcode} eq $basket->{branch};
282 } else {
283 $selected = 1 if $branch->{branchcode} eq C4::Context->userenv->{branch};
285 push @branches_loop, {
286 branchcode => $branch->{branchcode},
287 branchname => $branch->{branchname},
288 selected => $selected
293 #if the basket is closed,and the user has the permission to edit basketgroups, display a list of basketgroups
294 my ($basketgroup, $basketgroups);
295 my $patron = Koha::Patrons->find($loggedinuser);
296 if ($basket->{closedate} && haspermission($patron->userid, { acquisition => 'group_manage'} )) {
297 $basketgroups = GetBasketgroups($basket->{booksellerid});
298 for my $bg ( @{$basketgroups} ) {
299 if ($basket->{basketgroupid} && $basket->{basketgroupid} == $bg->{id}){
300 $bg->{default} = 1;
301 $basketgroup = $bg;
306 # if the basket is closed, calculate estimated delivery date
307 my $estimateddeliverydate;
308 if( $basket->{closedate} ) {
309 my ($year, $month, $day) = ($basket->{closedate} =~ /(\d+)-(\d+)-(\d+)/);
310 ($year, $month, $day) = Add_Delta_Days($year, $month, $day, $bookseller->deliverytime);
311 $estimateddeliverydate = sprintf( "%04d-%02d-%02d", $year, $month, $day );
314 # if new basket, pre-fill infos
315 $basket->{creationdate} = "" unless ( $basket->{creationdate} );
316 $basket->{authorisedby} = $loggedinuser unless ( $basket->{authorisedby} );
317 $debug
318 and warn sprintf
319 "loggedinuser: $loggedinuser; creationdate: %s; authorisedby: %s",
320 $basket->{creationdate}, $basket->{authorisedby};
322 my @basketusers_ids = GetBasketUsers($basketno);
323 my @basketusers;
324 foreach my $basketuser_id (@basketusers_ids) {
325 # FIXME Could be improved with a search -in
326 my $basket_patron = Koha::Patrons->find( $basketuser_id );
327 push @basketusers, $basket_patron if $basket_patron;
330 my $active_currency = Koha::Acquisition::Currencies->get_active;
332 my @orders = GetOrders( $basketno );
333 my @books_loop;
335 my @book_foot_loop;
336 my %foot;
337 my $total_quantity = 0;
338 my $total_tax_excluded = 0;
339 my $total_tax_included = 0;
340 my $total_tax_value = 0;
341 for my $order (@orders) {
342 my $line = get_order_infos( $order, $bookseller);
343 if ( $line->{uncertainprice} ) {
344 $template->param( uncertainprices => 1 );
347 $line->{tax_rate} = $line->{tax_rate_on_ordering} // 0;
348 $line->{tax_value} = $line->{tax_value_on_ordering} // 0;
350 push @books_loop, $line;
352 $foot{$$line{tax_rate}}{tax_rate} = $$line{tax_rate};
353 $foot{$$line{tax_rate}}{tax_value} += get_rounded_price($$line{tax_value});
354 $total_tax_value += $$line{tax_value};
355 $foot{$$line{tax_rate}}{quantity} += get_rounded_price($$line{quantity});
356 $total_quantity += $$line{quantity};
357 $foot{$$line{tax_rate}}{total_tax_excluded} += $$line{total_tax_excluded};
358 $total_tax_excluded += $$line{total_tax_excluded};
359 $foot{$$line{tax_rate}}{total_tax_included} += $$line{total_tax_included};
360 $total_tax_included += $$line{total_tax_included};
363 push @book_foot_loop, map {$_} values %foot;
365 # Get cancelled orders
366 my @cancelledorders = GetOrders($basketno, { cancelled => 1 });
367 my @cancelledorders_loop;
368 for my $order (@cancelledorders) {
369 my $line = get_order_infos( $order, $bookseller);
370 push @cancelledorders_loop, $line;
373 my $contract = GetContract({
374 contractnumber => $basket->{contractnumber}
377 if ($basket->{basketgroupid}){
378 $basketgroup = GetBasketgroup($basket->{basketgroupid});
380 my $budgets = GetBudgetHierarchy;
381 my $has_budgets = 0;
382 foreach my $r (@{$budgets}) {
383 if (!defined $r->{budget_amount} || $r->{budget_amount} == 0) {
384 next;
386 next unless (CanUserUseBudget($loggedinuser, $r, $userflags));
388 $has_budgets = 1;
389 last;
392 $template->param(
393 basketno => $basketno,
394 basket => $basket,
395 basketname => $basket->{'basketname'},
396 basketbranchcode => $basket->{branch},
397 basketnote => $basket->{note},
398 basketbooksellernote => $basket->{booksellernote},
399 basketcontractno => $basket->{contractnumber},
400 basketcontractname => $contract->{contractname},
401 branches_loop => \@branches_loop,
402 creationdate => $basket->{creationdate},
403 authorisedby => $basket->{authorisedby},
404 authorisedbyname => $basket->{authorisedbyname},
405 users_ids => join(':', @basketusers_ids),
406 users => \@basketusers,
407 closedate => $basket->{closedate},
408 estimateddeliverydate=> $estimateddeliverydate,
409 is_standing => $basket->{is_standing},
410 deliveryplace => $basket->{deliveryplace},
411 billingplace => $basket->{billingplace},
412 active => $bookseller->active,
413 booksellerid => $bookseller->id,
414 booksellername => $bookseller->name,
415 books_loop => \@books_loop,
416 book_foot_loop => \@book_foot_loop,
417 cancelledorders_loop => \@cancelledorders_loop,
418 total_quantity => $total_quantity,
419 total_tax_excluded => $total_tax_excluded,
420 total_tax_included => $total_tax_included,
421 total_tax_value => $total_tax_value,
422 currency => $active_currency->currency,
423 listincgst => $bookseller->listincgst,
424 basketgroups => $basketgroups,
425 basketgroup => $basketgroup,
426 grouped => $basket->{basketgroupid},
427 # The double negatives and booleans here mean:
428 # "A basket cannot be closed if there are no orders in it or it's a standing order basket."
430 # (The template has another implicit restriction that the order cannot be closed if there
431 # are any orders with uncertain prices.)
432 unclosable => @orders ? $basket->{is_standing} : 1,
433 has_budgets => $has_budgets,
434 duplinbatch => $duplinbatch,
435 csv_profiles => [ Koha::CsvProfiles->search({ type => 'sql', used_for => 'export_basket' }) ],
436 available_additional_fields => [ Koha::AdditionalFields->search( { tablename => 'aqbasket' } ) ],
437 additional_field_values => { map {
438 $_->field->name => $_->value
439 } Koha::Acquisition::Baskets->find($basketno)->additional_field_values->as_list },
443 $template->param( messages => \@messages );
444 output_html_with_http_headers $query, $cookie, $template->output;
446 sub get_order_infos {
447 my $order = shift;
448 my $bookseller = shift;
449 my $qty = $order->{'quantity'} || 0;
450 if ( !defined $order->{quantityreceived} ) {
451 $order->{quantityreceived} = 0;
453 my $budget = GetBudget($order->{budget_id});
454 my $basket = GetBasket($order->{basketno});
456 my %line = %{ $order };
457 # Don't show unreceived standing orders as received
458 $line{order_received} = ( $qty == $order->{'quantityreceived'} && ( $basket->{is_standing} ? $qty : 1 ) );
459 $line{basketno} = $basketno;
460 $line{budget_name} = $budget->{budget_name};
462 $line{total_tax_included} = get_rounded_price($line{ecost_tax_included}) * $line{quantity};
463 $line{total_tax_excluded} = get_rounded_price($line{ecost_tax_excluded}) * $line{quantity};
464 $line{tax_value} = $line{tax_value_on_ordering};
465 $line{tax_rate} = $line{tax_rate_on_ordering};
467 if ( $line{uncertainprice} ) {
468 $line{rrp_tax_excluded} .= ' (Uncertain)';
470 if ( $line{'title'} ) {
471 my $volume = $order->{'volume'};
472 my $seriestitle = $order->{'seriestitle'};
473 $line{'title'} .= " / $seriestitle" if $seriestitle;
474 $line{'title'} .= " / $volume" if $volume;
477 my $biblionumber = $order->{'biblionumber'};
478 if ( $biblionumber ) { # The biblio still exists
479 my $biblio = Koha::Biblios->find( $biblionumber );
480 my $countbiblio = CountBiblioInOrders($biblionumber);
481 my $ordernumber = $order->{'ordernumber'};
482 my $cnt_subscriptions = $biblio->subscriptions->count;
483 my $itemcount = $biblio->items->count;
484 my $holds_count = $biblio->holds->count;
485 my $order = Koha::Acquisition::Orders->find($ordernumber); # FIXME We should certainly do that at the beginning of this sub
486 my $items = $order->items;
487 my $itemholds = $biblio->holds->search({ itemnumber => { -in => [ $items->get_column('itemnumber') ] } })->count;
489 # if the biblio is not in other orders and if there is no items elsewhere and no subscriptions and no holds we can then show the link "Delete order and Biblio" see bug 5680
490 $line{can_del_bib} = 1 if $countbiblio <= 1 && $itemcount == $items->count && !($cnt_subscriptions) && !($holds_count);
491 $line{items} = $itemcount - $items->count;
492 $line{left_item} = 1 if $line{items} >= 1;
493 $line{left_biblio} = 1 if $countbiblio > 1;
494 $line{biblios} = $countbiblio - 1;
495 $line{left_subscription} = 1 if $cnt_subscriptions;
496 $line{subscriptions} = $cnt_subscriptions;
497 ($holds_count >= 1) ? $line{left_holds} = 1 : $line{left_holds} = 0;
498 $line{left_holds_on_order} = 1 if $line{left_holds}==1 && ($line{items} == 0 || $itemholds );
499 $line{holds} = $holds_count;
500 $line{holds_on_order} = $itemholds?$itemholds:$holds_count if $line{left_holds_on_order};
504 my $suggestion = GetSuggestionInfoFromBiblionumber($line{biblionumber});
505 $line{suggestionid} = $$suggestion{suggestionid};
506 $line{surnamesuggestedby} = $$suggestion{surnamesuggestedby};
507 $line{firstnamesuggestedby} = $$suggestion{firstnamesuggestedby};
509 foreach my $key (qw(transferred_from transferred_to)) {
510 if ($line{$key}) {
511 my $order = GetOrder($line{$key});
512 my $basket = GetBasket($order->{basketno});
513 my $bookseller = Koha::Acquisition::Booksellers->find( $basket->{booksellerid} );
514 $line{$key} = {
515 order => $order,
516 basket => $basket,
517 bookseller => $bookseller,
518 timestamp => $line{$key . '_timestamp'},
523 return \%line;
526 sub edi_close_and_order {
527 my $confirm = $query->param('confirm') || $confirm_pref eq '2';
528 if ($confirm) {
529 my $edi_params = {
530 basketno => $basketno,
531 ean => $ean,
533 if ( $basket->{branch} ) {
534 $edi_params->{branchcode} = $basket->{branch};
536 if ( create_edi_order($edi_params) ) {
537 #$template->param( edifile => 1 );
539 CloseBasket($basketno);
541 # if requested, create basket group, close it and attach the basket
542 if ( $query->param('createbasketgroup') ) {
543 my $branchcode;
544 if ( C4::Context->userenv
545 and C4::Context->userenv->{'branch'}
546 and C4::Context->userenv->{'branch'} ne "NO_LIBRARY_SET" )
548 $branchcode = C4::Context->userenv->{'branch'};
550 my $basketgroupid = NewBasketgroup(
552 name => $basket->{basketname},
553 booksellerid => $booksellerid,
554 deliveryplace => $branchcode,
555 billingplace => $branchcode,
556 closed => 1,
559 ModBasket(
561 basketno => $basketno,
562 basketgroupid => $basketgroupid
565 print $query->redirect(
566 "/cgi-bin/koha/acqui/basketgroup.pl?booksellerid=$booksellerid&closed=1"
569 else {
570 print $query->redirect(
571 "/cgi-bin/koha/acqui/booksellers.pl?booksellerid=$booksellerid"
574 exit;
576 else {
577 $template->param(
578 edi_confirm => 1,
579 booksellerid => $booksellerid,
580 basketno => $basket->{basketno},
581 basketname => $basket->{basketname},
582 basketgroupname => $basket->{basketname},
584 if ($ean) {
585 $template->param( ean => $ean );
589 return;