Bug 5466 On new orders get currency from vendor
[wip/koha-chris_n.git] / acqui / addorderiso2709.pl
1 #!/usr/bin/perl
2
3 #A script that lets the user populate a basket from an iso2709 file
4 #the script first displays a list of import batches, then when a batch is selected displays all the biblios in it.
5 #The user can then pick which biblios he wants to order
6 #written by john.soros@biblibre.com 01/12/2008
7
8 # Copyright 2008 - 2009 BibLibre SARL
9 #
10 # This file is part of Koha.
11 #
12 # Koha is free software; you can redistribute it and/or modify it under the
13 # terms of the GNU General Public License as published by the Free Software
14 # Foundation; either version 2 of the License, or (at your option) any later
15 # version.
16 #
17 # Koha is distributed in the hope that it will be useful, but WITHOUT ANY
18 # WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR
19 # A PARTICULAR PURPOSE.  See the GNU General Public License for more details.
20 #
21 # You should have received a copy of the GNU General Public License along
22 # with Koha; if not, write to the Free Software Foundation, Inc.,
23 # 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA.
24
25 use strict;
26 use warnings;
27 use CGI;
28 use C4::Context;
29 use C4::Auth;
30 use C4::Input;
31 use C4::Output;
32 use C4::ImportBatch qw/GetImportBatchRangeDesc GetNumberOfNonZ3950ImportBatches GetImportRecordMatches GetImportBibliosRange GetImportBatchOverlayAction GetImportBatchNoMatchAction GetImportBatchItemAction GetImportRecordMarc GetImportBatch/;
33 use C4::Matcher;
34 use C4::Search qw/FindDuplicate BiblioAddAuthorities/;
35 use C4::Acquisition qw/NewOrder/;
36 use C4::Biblio;
37 use C4::Items;
38 use C4::Koha qw/GetItemTypes/;
39 use C4::Budgets qw/GetBudgets/;
40 use C4::Acquisition qw/NewOrderItem GetBasket/;
41 use C4::Bookseller qw/GetBookSellerFromId/;
42
43 my $input = new CGI;
44 my ($template, $loggedinuser, $cookie) = get_template_and_user({
45                                         template_name => "acqui/addorderiso2709.tmpl",
46                                         query => $input,
47                                         type => "intranet",
48                                         authnotrequired => 0,
49                                         flagsrequired   => { acquisition => 'order_manage' },
50                                         debug => 1,
51                                         });
52 my $cgiparams = $input->Vars;
53 my $op = $cgiparams->{'op'};
54 my $booksellerid  = $input->param('booksellerid');
55 my $bookseller = GetBookSellerFromId($booksellerid);
56
57 $template->param(scriptname => "/cgi-bin/koha/acqui/addorderiso2709.pl",
58                 booksellerid => $booksellerid,
59                 booksellername => $bookseller->{name},
60                 );
61 my $ordernumber;
62
63 if ($cgiparams->{'import_batch_id'} && $op eq ""){
64     $op = "batch_details";
65 }
66
67 #Needed parameters:
68 if (! $cgiparams->{'basketno'}){
69     die "Basketnumber required to order from iso2709 file import";
70 }
71
72 if ($op eq ""){
73     $template->param("basketno" => $cgiparams->{'basketno'});
74 #display batches
75     import_batches_list($template);
76 } elsif ($op eq "batch_details"){
77 #display lines inside the selected batch
78     $template->param("batch_details" => 1,
79                      "basketno"      => $cgiparams->{'basketno'});
80     import_biblios_list($template, $cgiparams->{'import_batch_id'});
81     
82 } elsif ($op eq 'import_records'){
83 #import selected lines
84     $template->param('basketno' => $cgiparams->{'basketno'});
85 # Budget_id is mandatory for adding an order, we just add a default, the user needs to modify this aftewards
86     my $budgets = GetBudgets();
87     if (scalar @$budgets == 0){
88         die "No budgets defined, can't continue";
89     }
90     my $budget_id = @$budgets[0]->{'budget_id'};
91 #get all records from a batch, and check their import status to see if they are checked.
92 #(default values: quantity 1, uncertainprice yes, first budget)
93
94     # retrieve the file you want to import
95     my $import_batch_id = $cgiparams->{'import_batch_id'};
96     my $biblios = GetImportBibliosRange($import_batch_id);
97     for my $biblio (@$biblios){
98         if($cgiparams->{'order-'.$biblio->{'import_record_id'}}){
99             my ($marcblob, $encoding) = GetImportRecordMarc($biblio->{'import_record_id'});
100             my $marcrecord = MARC::Record->new_from_usmarc($marcblob) || die "couldn't translate marc information";
101             my ($duplicatetitle, $biblionumber);
102             if(!(($biblionumber,$duplicatetitle) = FindDuplicate($marcrecord))){
103 #FIXME: missing: marc21 support (should be same with different field)
104                 if ( C4::Context->preference("marcflavour") eq 'UNIMARC' ) {
105                     my $itemtypeid = "itemtype-" . $biblio->{'import_record_id'};
106                     $marcrecord->field(200)->update("b" => $cgiparams->{$itemtypeid});
107                 }
108                 # add the biblio
109                 my $bibitemnum;
110                 # remove ISBN -
111                 my ($isbnfield,$isbnsubfield) = GetMarcFromKohaField('biblioitems.isbn','');
112                 if ( $marcrecord->field($isbnfield) ) {
113                     foreach my $field ( $marcrecord->field($isbnfield) ) {
114                         foreach my $subfield ( $field->subfield($isbnsubfield) ) {
115                             my $newisbn = $field->subfield($isbnsubfield);
116                             $newisbn =~ s/-//g;
117                             $field->update( $isbnsubfield => $newisbn );
118                         }
119                     }
120                 }
121
122                 ( $biblionumber, $bibitemnum ) = AddBiblio( $marcrecord, $cgiparams->{'frameworkcode'} || '' );
123             } else {
124                 warn("Duplicate item found: ", $biblionumber, "; Duplicate: ", $duplicatetitle);
125             }
126             if (C4::Context->preference("BiblioAddsAuthorities")){
127                 my ($countlinked,$countcreated)=BiblioAddAuthorities($marcrecord, $cgiparams->{'frameworkcode'});
128             }
129             my $patron = C4::Members->GetMember(borrowernumber => $loggedinuser);
130             my $branch = C4::Branch->GetBranchDetail($patron->{branchcode});
131             my ($invoice);
132             my %orderinfo = ("biblionumber", $biblionumber,
133                             "basketno", $cgiparams->{'basketno'},
134                             "quantity", $cgiparams->{'quantityrec-' . $biblio->{'import_record_id'}},
135                             "branchcode", $branch,
136                             "booksellerinvoicenumber", $invoice,
137                             "budget_id", $budget_id,
138                             "uncertainprice", 1,
139                             );
140             # get the price if there is one.
141             # filter by storing only the 1st number
142             # we suppose the currency is correct, as we have no possibilities to get it.
143             if ($marcrecord->subfield("345","d")) {
144               $orderinfo{'listprice'} = $marcrecord->subfield("345","d");
145               if ($orderinfo{'listprice'} =~ /^([\d\.,]*)/) {
146                   $orderinfo{'listprice'} = $1;
147                   $orderinfo{'listprice'} =~ s/,/\./;
148                   my $basket = GetBasket($orderinfo{basketno});
149                   my $bookseller = GetBookSellerFromId($basket->{booksellerid});
150                   # '//' is like '||' but tests for defined, rather than true
151                   my $gst = $bookseller->{gstrate} // C4::Context->preference("gist") // 0;
152                   $orderinfo{'unitprice'} = $orderinfo{listprice} - ($orderinfo{listprice} * ($bookseller->{discount} / 100));
153                   $orderinfo{'ecost'} = $orderinfo{unitprice};
154               } else {
155                   $orderinfo{'listprice'} = 0;
156               }
157               $orderinfo{'rrp'} = $orderinfo{'listprice'};
158             }
159             elsif ($marcrecord->subfield("010","d")) {
160               $orderinfo{'listprice'} = $marcrecord->subfield("010","d");
161               if ($orderinfo{'listprice'} =~ /^([\d\.,]*)/) {
162                   $orderinfo{'listprice'} = $1;
163                   $orderinfo{'listprice'} =~ s/,/\./;
164                   my $basket = GetBasket($orderinfo{basketno});
165                   my $bookseller = GetBookSellerFromId($basket->{booksellerid});
166                   my $gst = $bookseller->{gstrate} // C4::Context->preference("gist") // 0;
167                   $orderinfo{'unitprice'} = $orderinfo{listprice} - ($orderinfo{listprice} * ($bookseller->{discount} / 100));
168                   $orderinfo{'ecost'} = $orderinfo{unitprice};
169               } else {
170                   $orderinfo{'listprice'} = 0;
171               }
172               $orderinfo{'rrp'} = $orderinfo{'listprice'};
173             }
174             # remove uncertainprice flag if we have found a price in the MARC record
175             $orderinfo{uncertainprice} = 0 if $orderinfo{listprice};
176             my $basketno;
177             ( $basketno, $ordernumber ) = NewOrder(\%orderinfo);
178
179             # now, add items if applicable
180             # parse all items sent by the form, and create an item just for the import_record_id we are dealing with
181             # this is not optimised, but it's working !
182             if (C4::Context->preference('AcqCreateItem') eq 'ordering') {
183                 my @tags         = $input->param('tag');
184                 my @subfields    = $input->param('subfield');
185                 my @field_values = $input->param('field_value');
186                 my @serials      = $input->param('serial');
187                 my @itemids       = $input->param('itemid'); # hint : in iso2709, the itemid contains the import_record_id, not an item id. It is used to get the right item, as we have X biblios.
188                 my @ind_tag      = $input->param('ind_tag');
189                 my @indicator    = $input->param('indicator');
190                 #Rebuilding ALL the data for items into a hash
191                 # parting them on $itemid.
192                 my %itemhash;
193                 my $range=scalar(@itemids);
194                 
195                 my $i = 0;
196                 my @items;
197                 for my $itemid (@itemids){
198                     my $realitemid;     #javascript generated random itemids, in the form itemid-randomnumber, $realitemid is the itemid, while $itemid is the itemide parsed from the html
199                     if ($itemid =~ m/(\d+)-.*/){
200                         my @splits = split(/-/, $itemid);
201                         $realitemid = $splits[0];
202                     }
203                     if ( ( $realitemid && $cgiparams->{'order-'. $realitemid} && $realitemid eq $biblio->{import_record_id}) || ($itemid && $cgiparams->{'order-'. $itemid} && $itemid eq $biblio->{import_record_id}) ){
204                         my ($item, $found);
205                         for my $tmpitem (@items){
206                             if ($tmpitem->{itemid} eq $itemid){
207                                 $item = $tmpitem;
208                                 $found = 1;
209                             }
210                         }
211                         push @{$item->{tags}}, $tags[$i];
212                         push @{$item->{subfields}}, $subfields[$i];
213                         push @{$item->{field_values}}, $field_values[$i];
214                         push @{$item->{ind_tag}}, $ind_tag[$i];
215                         push @{$item->{indicator}}, $indicator[$i];
216                         $item->{itemid} = $itemid;
217                         if (! $found){
218                              push @items, $item;
219                         }
220                     }
221                     ++$i
222                 }
223                 foreach my $item (@items){
224                         my $xml = TransformHtmlToXml( $item->{'tags'},
225                                                 $item->{'subfields'},
226                                                 $item->{'field_values'},
227                                                 $item->{'ind_tag'},
228                                                 $item->{'indicator'});
229                         my $record=MARC::Record::new_from_xml($xml, 'UTF-8');
230                         my ($biblionumber,$bibitemnum,$itemnumber) = AddItemFromMarc($record,$biblionumber);
231                         NewOrderItem( $itemnumber, $ordernumber);
232                 }
233             }
234         }
235     }
236     # go to basket page
237     print $input->redirect("/cgi-bin/koha/acqui/basket.pl?basketno=".$cgiparams->{'basketno'});
238     exit;
239 }
240 output_html_with_http_headers $input, $cookie, $template->output;
241
242
243 sub import_batches_list {
244     my ($template) = @_;
245     my $batches = GetImportBatchRangeDesc();
246
247     my @list = ();
248     foreach my $batch (@$batches) {
249         if ($batch->{'import_status'} eq "staged") {
250         push @list, {
251                 import_batch_id => $batch->{'import_batch_id'},
252                 num_biblios => $batch->{'num_biblios'},
253                 num_items => $batch->{'num_items'},
254                 upload_timestamp => $batch->{'upload_timestamp'},
255                 import_status => $batch->{'import_status'},
256                 file_name => $batch->{'file_name'},
257                 comments => $batch->{'comments'},
258             };
259         }
260     }
261     $template->param(batch_list => \@list); 
262     my $num_batches = GetNumberOfNonZ3950ImportBatches();
263     $template->param(num_results => $num_batches);
264 }
265
266 sub import_biblios_list {
267     my ($template, $import_batch_id) = @_;
268     my $batch = GetImportBatch($import_batch_id,'staged');
269     my $biblios = GetImportBibliosRange($import_batch_id,'','','staged');
270     my @list = ();
271 # # Itemtype is mandatory for adding a biblioitem, we just add a default, the user needs to modify this aftewards
272 #     my $itemtypehash = GetItemTypes();
273 #     my @itemtypes;
274 #     for my $key (sort { $itemtypehash->{$a}->{description} cmp $itemtypehash->{$b}->{description} } keys %$itemtypehash) {
275 #         push(@itemtypes, $itemtypehash->{$key});
276 #     }
277     foreach my $biblio (@$biblios) {
278         my $citation = $biblio->{'title'};
279         $citation .= " $biblio->{'author'}" if $biblio->{'author'};
280         $citation .= " (" if $biblio->{'issn'} or $biblio->{'isbn'};
281         $citation .= $biblio->{'isbn'} if $biblio->{'isbn'};
282         $citation .= ", " if $biblio->{'issn'} and $biblio->{'isbn'};
283         $citation .= $biblio->{'issn'} if $biblio->{'issn'};
284         $citation .= ")" if $biblio->{'issn'} or $biblio->{'isbn'};
285         my $match = GetImportRecordMatches($biblio->{'import_record_id'}, 1);
286         my %cellrecord = (
287             import_record_id => $biblio->{'import_record_id'},
288             citation => $citation,
289             import  => 1,
290             status => $biblio->{'status'},
291             record_sequence => $biblio->{'record_sequence'},
292             overlay_status => $biblio->{'overlay_status'},
293             match_biblionumber => $#$match > -1 ? $match->[0]->{'biblionumber'} : 0,
294             match_citation => $#$match > -1 ? $match->[0]->{'title'} . ' ' . $match->[0]->{'author'} : '',
295             match_score => $#$match > -1 ? $match->[0]->{'score'} : 0,
296 #             itemtypes => \@itemtypes,
297         );
298 #         if (C4::Context->preference('AcqCreateItem') eq 'ordering' && !$ordernumber) {
299 #             # prepare empty item form
300 #             my $cell = PrepareItemrecordDisplay();
301 #             my @itemloop;
302 #             push @itemloop,$cell;
303 #             $cellrecord{'items'} = \@itemloop;
304 #         }
305         push @list, \%cellrecord;
306
307
308     }
309     my $num_biblios = $batch->{'num_biblios'};
310     my $overlay_action = GetImportBatchOverlayAction($import_batch_id);
311     my $nomatch_action = GetImportBatchNoMatchAction($import_batch_id);
312     my $item_action = GetImportBatchItemAction($import_batch_id);
313     $template->param(biblio_list => \@list,
314                         num_results => $num_biblios,
315                         import_batch_id => $import_batch_id,
316                         "overlay_action_${overlay_action}" => 1,
317                         overlay_action => $overlay_action,
318                         "nomatch_action_${nomatch_action}" => 1,
319                         nomatch_action => $nomatch_action,
320                         "item_action_${item_action}" => 1,
321                         item_action => $item_action
322                     );
323     batch_info($template, $batch);
324 }
325
326 sub batch_info {
327     my ($template, $batch) = @_;
328     $template->param(batch_info => 1,
329                                       file_name => $batch->{'file_name'},
330                                           comments => $batch->{'comments'},
331                                           import_status => $batch->{'import_status'},
332                                           upload_timestamp => $batch->{'upload_timestamp'},
333                                           num_biblios => $batch->{'num_biblios'},
334                                           num_items => $batch->{'num_biblios'});
335     if ($batch->{'num_biblios'} > 0) {
336         if ($batch->{'import_status'} eq 'staged' or $batch->{'import_status'} eq 'reverted') {
337             $template->param(can_commit => 1);
338         }
339         if ($batch->{'import_status'} eq 'imported') {
340             $template->param(can_revert => 1);
341         }
342     }
343     if (defined $batch->{'matcher_id'}) {
344         my $matcher = C4::Matcher->fetch($batch->{'matcher_id'});
345         if (defined $matcher) {
346             $template->param('current_matcher_id' => $batch->{'matcher_id'},
347                                               'current_matcher_code' => $matcher->code(),
348                                               'current_matcher_description' => $matcher->description());
349         }
350     }
351     add_matcher_list($batch->{'matcher_id'});
352 }
353
354 sub add_matcher_list {
355     my $current_matcher_id = shift;
356     my @matchers = C4::Matcher::GetMatcherList();
357     if (defined $current_matcher_id) {
358         for (my $i = 0; $i <= $#matchers; $i++) {
359             if ($matchers[$i]->{'matcher_id'} == $current_matcher_id) {
360                 $matchers[$i]->{'selected'} = 1;
361             }
362         }
363     }
364     $template->param(available_matchers => \@matchers);
365 }