Minor indexing bug : Title series indexed as Title
[koha.git] / acqui / neworderempty.pl
1 #!/usr/bin/perl
2
3 #script to show display basket of orders
4 #written by chris@katipo.co.nz 24/2/2000
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 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
13 # version.
14 #
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.
18 #
19 # You should have received a copy of the GNU General Public License along with
20 # Koha; if not, write to the Free Software Foundation, Inc., 59 Temple Place,
21 # Suite 330, Boston, MA  02111-1307 USA
22
23
24 =head1 NAME
25
26 neworderempty.pl
27
28 =head1 DESCRIPTION
29 this script allows to create a new record to order it. This record shouldn't exist
30 on database.
31
32 =head1 CGI PARAMETERS
33
34 =over 4
35
36 =item booksellerid
37 the bookseller the librarian has to buy a new book.
38
39 =item title
40 the title of this new record.
41
42 =item author
43 the author of this new record.
44
45 =item copyright
46 the copyright of this new record.
47
48 =item ordnum
49 the number of this order.
50
51 =item biblio
52
53 =item basketno
54 the basket number for this new order.
55
56 =item suggestionid
57 if this order comes from a suggestion.
58
59 =item close
60
61 =back
62
63 =cut
64
65 use strict;
66 use CGI;
67 use C4::Context;
68 use C4::Input;
69
70 use C4::Auth;
71 use C4::Bookfund;
72 use C4::Bookseller;             # GetBookSellerFromId
73 use C4::Acquisition;
74 use C4::Suggestions;    # GetSuggestion
75 use C4::Biblio;                 # GetBiblioData
76 use C4::Output;
77 use C4::Input;
78 use C4::Koha;
79 use C4::Branch;                 # GetBranches
80 use C4::Members;
81
82 my $input        = new CGI;
83 my $booksellerid = $input->param('booksellerid');       # FIXME: else ERROR!
84 my $title        = $input->param('title');
85 my $author       = $input->param('author');
86 my $copyright    = $input->param('copyright');
87 my $bookseller   = GetBookSellerFromId($booksellerid);  # FIXME: else ERROR!
88 my $ordnum       = $input->param('ordnum');
89 my $biblionumber = $input->param('biblionumber');
90 my $basketno     = $input->param('basketno');
91 my $purchaseorder= $input->param('purchaseordernumber');
92 my $suggestionid = $input->param('suggestionid');
93 # my $donation     = $input->param('donation');
94 my $close        = $input->param('close');
95 my $data;
96 my $new;
97 my $dbh = C4::Context->dbh;
98
99 if ( $ordnum eq '' ) {    # create order
100     $new = 'yes';
101
102     #   $ordnum=newordernum;
103     if ( $biblionumber && !$suggestionid ) {
104         $data = GetBiblioData($biblionumber);
105     }
106
107 # get suggestion fields if applicable. If it's a subscription renewal, then the biblio already exists
108 # otherwise, retrieve suggestion information.
109     if ($suggestionid) {
110                 $data = ($biblionumber) ? GetBiblioData($biblionumber) : GetSuggestion($suggestionid);
111     }
112 }
113 else {    #modify order
114     $data   = GetOrder($ordnum);
115     $biblionumber = $data->{'biblionumber'};
116     #get basketno and supplierno. too!
117     my $data2 = GetBasket( $data->{'basketno'} );
118     $basketno     = $data2->{'basketno'};
119     $booksellerid = $data2->{'booksellerid'};
120 }
121
122 my ( $template, $loggedinuser, $cookie ) = get_template_and_user(
123     {
124         template_name   => "acqui/neworderempty.tmpl",
125         query           => $input,
126         type            => "intranet",
127         authnotrequired => 0,
128         flagsrequired   => { acquisition => 1 },
129         debug           => 1,
130     }
131 );
132
133 # get currencies (for change rates calcs if needed)
134 my @rates = GetCurrencies();
135 my $count = scalar @rates;
136
137 my @loop_currency = ();
138 for ( my $i = 0 ; $i < $count ; $i++ ) {
139     my %line;
140     $line{currency} = $rates[$i]->{'currency'};
141     $line{rate}     = $rates[$i]->{'rate'};
142     push @loop_currency, \%line;
143 }
144
145 # build itemtype list
146 my $itemtypes = GetItemTypes;
147
148 my @itemtypesloop;
149 foreach my $thisitemtype (sort keys %$itemtypes) {
150     push @itemtypesloop, { itemtype => $itemtypes->{$thisitemtype}->{'itemtype'} , desc =>  $itemtypes->{$thisitemtype}->{'description'} } ;
151 }
152
153 # build branches list
154 my $onlymine=C4::Context->preference('IndependantBranches') && 
155              C4::Context->userenv && 
156              C4::Context->userenv->{flags}!=1 && 
157              C4::Context->userenv->{branch};
158 my $branches = GetBranches($onlymine);
159 my @branchloop;
160 foreach my $thisbranch ( sort keys %$branches ) {
161      my %row = (
162         value      => $thisbranch,
163         branchname => $branches->{$thisbranch}->{'branchname'},
164     );
165     push @branchloop, \%row;
166 }
167 $template->param( branchloop => \@branchloop , itypeloop => \@itemtypesloop );
168
169 # build bookfund list
170 my $borrower= GetMember($loggedinuser);
171 my ( $flags, $homebranch )= ($borrower->{'flags'},$borrower->{'branchcode'});
172
173 my @select_bookfund;
174 my %select_bookfunds;
175
176 my @bookfund = GetBookFunds($homebranch);
177 my $count2 = scalar @bookfund;
178
179 for ( my $i = 0 ; $i < $count2 ; $i++ ) {
180     push @select_bookfund, $bookfund[$i]->{'bookfundid'};
181     $select_bookfunds{ $bookfund[$i]->{'bookfundid'} } =
182       $bookfund[$i]->{'bookfundname'};
183 }
184 my $CGIbookfund = CGI::scrolling_list(
185     -name     => 'bookfund',
186         -id       => 'bookfund',
187     -values   => \@select_bookfund,
188     -default  => $data->{'bookfundid'},
189     -labels   => \%select_bookfunds,
190         #-size     => 1,
191         -tabindex =>'',
192     -multiple => 0
193 );
194
195 my $bookfundname;
196 my $bookfundid;
197 if ($close) {
198     $bookfundid   = $data->{'bookfundid'};
199     $bookfundname = $select_bookfunds{$bookfundid};
200 }
201
202 #Build sort lists
203 my $CGIsort1 = buildCGIsort( "Asort1", "sort1", $data->{'sort1'} );
204 if ($CGIsort1) {
205     $template->param( CGIsort1 => $CGIsort1 );
206 } else {
207     $template->param( sort1 => $data->{'sort1'} );
208 }
209
210 my $CGIsort2 = buildCGIsort( "Asort2", "sort2", $data->{'sort2'} );
211 if ($CGIsort2) {
212     $template->param( CGIsort2 => $CGIsort2 );
213 } else {
214     $template->param( sort2 => $data->{'sort2'} );
215 }
216
217 #do a biblioitems lookup on bib
218 my @bibitems = GetBiblioItemByBiblioNumber($biblionumber);
219 my $bibitemscount = scalar @bibitems;
220
221 if ( $bibitemscount > 0 ) {
222     # warn "NEWBIBLIO: bibitems for $biblio exists\n";
223     my @bibitemloop;
224     for ( my $i = 0 ; $i < $bibitemscount ; $i++ ) {
225         my %line;
226         $line{biblioitemnumber} = $bibitems[$i]->{'biblioitemnumber'};
227         $line{isbn}             = $bibitems[$i]->{'isbn'};
228         $line{itemtype}         = $bibitems[$i]->{'itemtype'};
229         $line{volumeddesc}      = $bibitems[$i]->{'volumeddesc'};
230         push( @bibitemloop, \%line );
231
232         $template->param( bibitemloop => \@bibitemloop );
233     }
234     $template->param( bibitemexists => "1" );
235 }
236
237 # fill template
238 $template->param(
239     close        => $close,
240     bookfundid   => $bookfundid,
241     bookfundname => $bookfundname
242   )
243   if ($close);
244
245 $template->param(
246     existing         => $biblionumber,
247     ordnum           => $ordnum,
248     basketno         => $basketno,
249     booksellerid     => $booksellerid,
250     suggestionid     => $suggestionid,
251     biblionumber     => $biblionumber,
252     authorisedbyname => $borrower->{'firstname'} . " " . $borrower->{'surname'},
253         biblioitemnumber => $data->{'biblioitemnumber'},
254     itemtype         => $data->{'itemtype'},
255     itemtype_desc    => $itemtypes->{$data->{'itemtype'}}->{description},
256     discount         => $bookseller->{'discount'},
257     listincgst       => $bookseller->{'listincgst'},
258     listprice        => $bookseller->{'listprice'},
259     gstreg           => $bookseller->{'gstreg'},
260     invoiceinc       => $bookseller->{'invoiceincgst'},
261     invoicedisc      => $bookseller->{'invoicedisc'},
262     nocalc           => $bookseller->{'nocalc'},
263     name             => $bookseller->{'name'},
264     currency         => $bookseller->{'listprice'},
265     gstrate          => C4::Context->preference("gist"),
266     loop_currencies  => \@loop_currency,
267     orderexists      => ( $new eq 'yes' ) ? 0 : 1,
268     title            => $data->{'title'},
269     author           => $data->{'author'},
270     copyrightdate    => $data->{'copyrightdate'},
271     CGIbookfund      => $CGIbookfund,
272     isbn             => $data->{'isbn'},
273     seriestitle      => $data->{'seriestitle'},
274     quantity         => $data->{'quantity'},
275     listprice        => $data->{'listprice'},
276     rrp              => $data->{'rrp'},
277     total            => $data->{ecost}*$data->{quantity},
278     invoice          => $data->{'booksellerinvoicenumber'},
279     ecost            => $data->{'ecost'},
280     purchaseordernumber => $data->{'purchaseordernumber'},
281     notes            => $data->{'notes'},
282     publishercode    => $data->{'publishercode'},
283 #     donation         => $donation
284 );
285
286 output_html_with_http_headers $input, $cookie, $template->output;