acqui/addorder.pl

   1 #!/usr/bin/perl
   2
   3 #script to add an order into the system
   4 #written 29/2/00 by chris@katipo.co.nz
   5
   6 # Copyright 2000-2002 Katipo Communications
   7 #
   8 # This file is part of Koha.
   9 #
  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.
  14 #
  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.
  19 #
  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>.
  22
  23
  24 =head1 NAME
  25
  26 addorder.pl
  27
  28 =head1 DESCRIPTION
  29
  30 this script allows to add an order.
  31 It is called by :
  32
  33 =over
  34
  35 =item neworderbiblio.pl to add an order from nothing.
  36
  37 =item neworderempty.pl to add an order from an existing biblio.
  38
  39 =item newordersuggestion.pl to add an order from an existing suggestion.
  40
  41 =back
  42
  43 =head1 CGI PARAMETERS
  44
  45 All of the cgi parameters below are related to the new order.
  46
  47 =over
  48
  49 =item C<ordernumber>
  50 the number of this new order.
  51
  52 =item C<basketno>
  53 the number of this new basket
  54
  55 =item C<booksellerid>
  56 the bookseller the librarian has to pay.
  57
  58 =item C<existing>
  59
  60 =item C<title>
  61 the title of the record ordered.
  62
  63 =item C<author>
  64 the author of the record ordered.
  65
  66 =item C<copyrightdate>
  67 the copyrightdate of the record ordered.
  68
  69 =item C<ISBN>
  70 the ISBN of the record ordered.
  71
  72 =item C<format>
  73
  74 =item C<quantity>
  75 the quantity to order.
  76
  77 =item C<list_price>
  78 the price of this order.
  79
  80 =item C<uncertainprice>
  81 uncertain price, can't close basket until prices of all orders are known.
  82
  83 =item C<branch>
  84 the branch where this order will be received.
  85
  86 =item C<series>
  87
  88 =item C<notes>
  89 Notes on this basket.
  90
  91 =item C<budget_id>
  92 budget_id used to pay this order.
  93
  94 =item C<sort1> & C<sort2>
  95
  96 =item C<rrp>
  97
  98 =item C<ecost>
  99
 100 =item C<GST>
 101
 102 =item C<budget>
 103
 104 =item C<cost>
 105
 106 =item C<sub>
 107
 108 =item C<invoice>
 109 the number of the invoice for this order.
 110
 111 =item C<publishercode>
 112
 113 =item C<suggestionid>
 114 if it is an order from an existing suggestion : the id of this suggestion.
 115
 116 =item C<donation>
 117
 118 =back
 119
 120 =cut
 121
 122 use strict;
 123 use warnings;
 124 use CGI qw ( -utf8 );
 125 use C4::Auth;           # get_template_and_user
 126 use C4::Acquisition;    # ModOrder
 127 use C4::Suggestions;    # ModStatus
 128 use C4::Biblio;         # AddBiblio TransformKohaToMarc
 129 use C4::Budgets;
 130 use C4::Items;
 131 use C4::Output;
 132 use Koha::Acquisition::Currencies;
 133 use C4::Barcodes;
 134
 135 ### "-------------------- addorder.pl ----------"
 136
 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.
 139
 140 my $input = new CGI;
 141
 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};
 154
 155     if ( $total > $budget_remaining
 156       || ( ($budget_encumbrance+0) && ($budget_used + $total) > $budget_encumbrance)
 157       || ( ($budget_expenditure+0) && ($budget_used + $total) > $budget_expenditure) )
 158     {
 159         my ($template, $loggedinuser, $cookie) = get_template_and_user({
 160             template_name   => "acqui/addorder.tt",
 161             query           => $input,
 162             type            => "intranet",
 163             authnotrequired => 0,
 164             flagsrequired   => {acquisition => 'order_manage'},
 165         });
 166
 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";
 171         }
 172
 173         my $vars = $input->Vars;
 174         my @vars_loop;
 175         foreach (keys %$vars) {
 176             push @vars_loop, {
 177                 name => $_,
 178                 values => [$input->param($_)],
 179             };
 180         }
 181
 182         if( ($budget_encumbrance+0) && ($budget_used + $total) > $budget_encumbrance
 183           && $total <= $budget_remaining)
 184         {
 185             $template->param(
 186                 encumbrance_exceeded => 1,
 187                 encumbrance => sprintf("%.2f", $budget->{'budget_encumb'}),
 188             );
 189         }
 190         if( ($budget_expenditure+0) && ($budget_used + $total) > $budget_expenditure
 191           && $total <= $budget_remaining )
 192         {
 193             my $currency = Koha::Acquisition::Currencies->get_active;
 194             $template->param(
 195                 expenditure_exceeded => 1,
 196                 expenditure => sprintf("%.2f", $budget_expenditure),
 197                 currency => ($currency) ? $currency->symbol : '',
 198             );
 199         }
 200         if($total > $budget_remaining){
 201             $template->param(budget_exceeded => 1);
 202         }
 203
 204         $template->param(
 205             not_enough_budget => 1,
 206             referer => $url,
 207             vars_loop => \@vars_loop,
 208         );
 209         output_html_with_http_headers $input, $cookie, $template->output;
 210         exit;
 211     }
 212 }
 213
 214 # get_template_and_user used only to check auth & get user id
 215 my ( $template, $loggedinuser, $cookie ) = get_template_and_user(
 216     {
 217         template_name   => "acqui/booksellers.tt",
 218         query           => $input,
 219         type            => "intranet",
 220         authnotrequired => 0,
 221         flagsrequired   => { acquisition => 'order_manage' },
 222         debug           => 1,
 223     }
 224 );
 225
 226 # get CGI parameters
 227 my $orderinfo                                   = $input->Vars;
 228 $orderinfo->{'list_price'}    ||=  0;
 229 $orderinfo->{'uncertainprice'} ||= 0;
 230 $orderinfo->{subscriptionid} ||= undef;
 231
 232 my $basketno=$$orderinfo{basketno};
 233 my $basket = GetBasket($basketno);
 234
 235 my $user = $input->remote_user;
 236
 237 # create, modify or delete biblio
 238 # create if $quantity>0 and $existing='no'
 239 # modify if $quantity>0 and $existing='yes'
 240 if ( $basket->{is_standing} || $orderinfo->{quantity} ne '0' ) {
 241     #TODO:check to see if biblio exists
 242     unless ( $$orderinfo{biblionumber} ) {
 243         #if it doesn't create it
 244         my $record = TransformKohaToMarc(
 245             {
 246                 "biblio.title"                => "$$orderinfo{title}",
 247                 "biblio.author"               => $$orderinfo{author}          ? $$orderinfo{author}        : "",
 248                 "biblio.seriestitle"          => $$orderinfo{series}          ? $$orderinfo{series}        : "",
 249                 "biblioitems.isbn"            => $$orderinfo{isbn}            ? $$orderinfo{isbn}          : "",
 250                 "biblioitems.ean"             => $$orderinfo{ean}             ? $$orderinfo{ean}           : "",
 251                 "biblioitems.publishercode"   => $$orderinfo{publishercode}   ? $$orderinfo{publishercode} : "",
 252                 "biblioitems.publicationyear" => $$orderinfo{publicationyear} ? $$orderinfo{publicationyear}: "",
 253                 "biblio.copyrightdate"        => $$orderinfo{publicationyear} ? $$orderinfo{publicationyear}: "",
 254                 "biblioitems.itemtype"        => $$orderinfo{itemtype} ? $$orderinfo{itemtype} : "",
 255                 "biblioitems.editionstatement"=> $$orderinfo{editionstatement} ? $$orderinfo{editionstatement} : "",
 256             });
 257
 258         C4::Acquisition::FillWithDefaultValues( $record );
 259
 260         # create the record in catalogue, with framework ''
 261         my ($biblionumber,$bibitemnum) = AddBiblio($record,'');
 262         # change suggestion status if applicable
 263         if ($$orderinfo{suggestionid}) {
 264             ModSuggestion( {suggestionid=>$$orderinfo{suggestionid}, STATUS=>'ORDERED', biblionumber=>$biblionumber} );
 265         }
 266         $orderinfo->{biblionumber}=$biblionumber;
 267     }
 268
 269     $orderinfo->{unitprice} = $orderinfo->{ecost} if not defined $orderinfo->{unitprice} or $orderinfo->{unitprice} eq '';
 270
 271     $orderinfo = C4::Acquisition::populate_order_with_prices(
 272         {
 273             order        => $orderinfo,
 274             booksellerid => $orderinfo->{booksellerid},
 275             ordering     => 1,
 276         }
 277     );
 278
 279     # if we already have $ordernumber, then it's an ordermodif
 280     my $order = Koha::Acquisition::Order->new($orderinfo);
 281     if ( $orderinfo->{ordernumber} ) {
 282         ModOrder($orderinfo);
 283         my $order_users_ids = $input->param('users_ids');
 284         my @order_users = split( /:/, $order_users_ids );
 285
 286         ModOrderUsers( $orderinfo->{ordernumber}, @order_users );
 287     }
 288     else { # else, it's a new line
 289         $order->insert;
 290     }
 291
 292     # now, add items if applicable
 293     if (C4::Context->preference('AcqCreateItem') eq 'ordering') {
 294
 295         my @tags         = $input->multi_param('tag');
 296         my @subfields    = $input->multi_param('subfield');
 297         my @field_values = $input->multi_param('field_value');
 298         my @serials      = $input->multi_param('serial');
 299         my @itemid       = $input->multi_param('itemid');
 300         my @ind_tag      = $input->multi_param('ind_tag');
 301         my @indicator    = $input->multi_param('indicator');
 302         #Rebuilding ALL the data for items into a hash
 303         # parting them on $itemid.
 304
 305         my %itemhash;
 306         my $countdistinct;
 307         my $range=scalar(@itemid);
 308         for (my $i=0; $i<$range; $i++){
 309             unless ($itemhash{$itemid[$i]}){
 310             $countdistinct++;
 311             }
 312             push @{$itemhash{$itemid[$i]}->{'tags'}},$tags[$i];
 313             push @{$itemhash{$itemid[$i]}->{'subfields'}},$subfields[$i];
 314             push @{$itemhash{$itemid[$i]}->{'field_values'}},$field_values[$i];
 315             push @{$itemhash{$itemid[$i]}->{'ind_tag'}},$ind_tag[$i];
 316             push @{$itemhash{$itemid[$i]}->{'indicator'}},$indicator[$i];
 317         }
 318         foreach my $item (keys %itemhash){
 319             my $xml = TransformHtmlToXml( $itemhash{$item}->{'tags'},
 320                                     $itemhash{$item}->{'subfields'},
 321                                     $itemhash{$item}->{'field_values'},
 322                                     $itemhash{$item}->{'indicator'},
 323                                     $itemhash{$item}->{'ind_tag'},
 324                                     'ITEM');
 325             my $record=MARC::Record::new_from_xml($xml, 'UTF-8');
 326             my ($barcodefield,$barcodesubfield) = GetMarcFromKohaField('items.barcode');
 327             next unless ( defined $barcodefield && defined $barcodesubfield );
 328             my $barcode = $record->subfield($barcodefield,$barcodesubfield) || '';
 329             my $aBpref = C4::Context->preference('autoBarcode');
 330             if( $barcode eq '' && $aBpref ne 'OFF'){
 331                 my $barcodeobj;
 332                 if ( $aBpref eq 'hbyymmincr'){
 333                     my ($homebranchfield,$homebranchsubfield) = GetMarcFromKohaField('items.homebranch');
 334                     my $homebranch = $record->subfield($homebranchfield,$homebranchsubfield);
 335                     $barcodeobj = C4::Barcodes->new($aBpref, $homebranch);
 336                 } else {
 337                     $barcodeobj = C4::Barcodes->new($aBpref);
 338                 }
 339                 $barcode = $barcodeobj->value();
 340                 $record->field($barcodefield)->delete_subfield( code => $barcodesubfield);
 341                 $record->field($barcodefield)->add_subfields($barcodesubfield => $barcode);
 342             }
 343             my ($biblionumber,$bibitemnum,$itemnumber) = AddItemFromMarc($record,$$orderinfo{biblionumber});
 344             $order->add_item($itemnumber);
 345         }
 346     }
 347
 348 }
 349
 350 my $booksellerid=$$orderinfo{booksellerid};
 351 if (my $import_batch_id=$$orderinfo{import_batch_id}) {
 352     print $input->redirect("/cgi-bin/koha/acqui/addorderiso2709.pl?import_batch_id=$import_batch_id&basketno=$basketno&booksellerid=$booksellerid");
 353 } elsif ( defined $orderinfo->{invoiceid} ) {
 354     print $input->redirect("/cgi-bin/koha/acqui/parcel.pl?invoiceid=" . $orderinfo->{invoiceid});
 355 } else {
 356     print $input->redirect("/cgi-bin/koha/acqui/basket.pl?basketno=$basketno");
 357 }