2 # WARNING: This file contains mixed-sized tabs! (some 4-character, some 8)
3 # WARNING: Currently, 4-character tabs seem to be dominant
4 # WARNING: But there are still lots of 8-character tabs
6 #written 11/3/2002 by Finlay
7 #script to execute returns of books
9 # Copyright 2000-2002 Katipo Communications
11 # This file is part of Koha.
13 # Koha is free software; you can redistribute it and/or modify it under the
14 # terms of the GNU General Public License as published by the Free Software
15 # Foundation; either version 2 of the License, or (at your option) any later
18 # Koha is distributed in the hope that it will be useful, but WITHOUT ANY
19 # WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR
20 # A PARTICULAR PURPOSE. See the GNU General Public License for more details.
22 # You should have received a copy of the GNU General Public License along with
23 # Koha; if not, write to the Free Software Foundation, Inc., 59 Temple Place,
24 # Suite 330, Boston, MA 02111-1307 USA
28 use C4::Circulation::Circ2;
34 use C4::Interface::CGI::Output;
41 my ( $template, $borrowernumber, $cookie ) = get_template_and_user(
43 template_name => "circ/returns.tmpl",
47 flagsrequired => { circulate => 1 },
54 my $headerbackgroundcolor = '#99cc33';
55 my $linecolor1 = '#ffffcc';
56 my $linecolor2 = 'white';
57 my $todaysdate =get_today();
58 my $branches = GetBranches();
59 my $printers = getprinters( \%env );
61 # my $branch = getbranch( $query, $branches );
62 my $printer = getprinter( $query, $printers );
65 # Some code to handle the error if there is no branch or printer setting.....
67 my $branch=C4::Context->preference("defaultBranch");
68 $env{'branchcode'} = $branch;
69 $env{'printer'} = $printer;
70 $env{'queue'} = $printer;
72 # Set up the item stack ....
77 foreach ( $query->param ) {
78 (next) unless (/ri-(\d*)/);
81 (next) if ( $counter > 20 );
82 my $barcode = $query->param("ri-$counter");
83 my $duedate = $query->param("dd-$counter");
84 my $borrowernumber = $query->param("bn-$counter");
88 $barcode = cuecatbarcodedecode($barcode);
90 ######################
91 #Are these lines still useful ?
92 $returneditems{$counter} = $barcode;
93 $riduedate{$counter} = $duedate;
94 $riborrowernumber{$counter} = $borrowernumber;
96 #######################
97 $input{counter} = $counter;
98 $input{barcode} = $barcode;
99 $input{duedate} = $duedate;
100 $input{bornum} = $borrowernumber;
101 push ( @inputloop, \%input );
106 # Deal with the requests....
107 if ( $query->param('resbarcode') ) {
108 $item = $query->param('itemnumber');
109 my $borrnum = $query->param('borrowernumber');
110 my $resbarcode = $query->param('resbarcode');
113 my $iteminfo = getiteminformation( \%env, $item );
114 my $tobranchcd = ReserveWaiting( $item, $borrnum );
115 my $branchname = $branches->{$tobranchcd}->{'branchname'};
116 my ($borr) = getpatroninformation( \%env, $borrnum, 0 );
117 my $borcnum = $borr->{'cardnumber'};
119 $borr->{'surname'} . " " . $borr->{'title'} . " " . $borr->{'firstname'};
120 my $slip = $query->param('resslip');
121 printslip( \%env, $slip ); #removed by paul
123 if ( $tobranchcd ne $branch ) {
125 itemtitle => $iteminfo->{'title'},
126 iteminfo => $iteminfo->{'author'},
127 branchname => $branchname,
140 my $barcode = $query->param('barcode');
142 # actually return book and prepare item table.....
146 $barcode = cuecatbarcodedecode($barcode);
147 ( $returned, $messages, $iteminformation, $borrower ) =
148 returnbook( $barcode, $branch );
150 $returneditems{0} = $barcode;
151 $riborrowernumber{0} = $borrower->{'borrowernumber'};
152 $riduedate{0} = $iteminformation->{'date_due'};
156 $input{barcode} = $barcode;
157 $input{duedate} = $riduedate{0};
158 $input{bornum} = $riborrowernumber{0};
159 push ( @inputloop, \%input );
161 elsif ( !$messages->{'BadBarcode'} ) {
162 if ( $messages->{'NotIssued'} ) {
163 my $dbh = C4::Context->dbh;
164 my $sth=$dbh->prepare("select duetime from reserveissue where itemnumber=? and isnull(rettime)");
165 $sth->execute($iteminformation->{'itemnumber'});
166 my ($date_due) = $sth->fetchrow;
170 # $messages->{'ReserveIssued'} =$barcode;
171 print $query->redirect("/cgi-bin/koha/circ/resreturns.pl?barcode=$barcode");
177 $input{barcode} = $barcode;
180 $returneditems{0} = $barcode;
182 if ( $messages->{'wthdrawn'} ) {
183 $input{withdrawn} = 1;
184 $input{bornum} = "Item Cancelled";
185 $riborrowernumber{0} = 'Item Cancelled';
188 $input{bornum} = " ";
189 $riborrowernumber{0} = ' ';
191 push ( @inputloop, \%input );
194 returned => $returned,
195 itemtitle => $iteminformation->{'title'},
197 # itembc => $iteminformation->{'barcode'},
198 # itemdatedue => $iteminformation->{'datedue'},
199 itemauthor => $iteminformation->{'author'}
202 $template->param( inputloop => \@inputloop );
208 if ( $messages->{'ResFound'} ) {
209 my $res = $messages->{'ResFound'};
210 my $branchname = $branches->{ $res->{'branchcode'} }->{'branchname'};
211 my ($borr) = getpatroninformation( \%env, $res->{'borrowernumber'}, 0 );
213 $borr->{'surname'} . " " . $borr->{'title'} . " " . $borr->{'firstname'};
214 my ($iteminfo) = getiteminformation( \%env, 0, $barcode );
216 if ( $res->{'ResFound'} eq "Waiting" ) {
220 borfirstname => $borr->{'firstname'},
221 borsurname => $borr->{'surname'},
222 bortitle => $borr->{'title'},
223 borphone => $borr->{'phone'},
224 borstraddress => $borr->{'streetaddress'},
225 borcity => $borr->{'city'},
226 borzip => $borr->{'zipcode'},
227 bornum => $res->{'borrowernumber'},
228 borcnum => $borr->{'cardnumber'},
229 branchname => $branches->{ $res->{'branchcode'} }->{'branchname'},
231 itemnumber => $res->{'itemnumber'},
232 itemtitle => $iteminfo->{'title'},
233 itemauthor => $iteminfo->{'author'},
234 itembarcode => $iteminfo->{'barcode'},
235 itemtype => $iteminfo->{'itemtype'},
236 itembiblionumber => $iteminfo->{'biblionumber'}
240 if ( $res->{'ResFound'} eq "Reserved" ) {
244 branchname => $branches->{ $res->{'branchcode'} }->{'branchname'},
246 today =>format_date( $todaysdate),
247 itemnumber => $res->{'itemnumber'},
248 itemtitle => $iteminfo->{'title'},
249 itemauthor => $iteminfo->{'author'},
250 itembarcode => $iteminfo->{'barcode'},
251 itemtype => $iteminfo->{'itemtype'},
252 itembiblionumber => $iteminfo->{'biblionumber'},
253 borsurname => $borr->{'surname'},
254 bortitle => $borr->{'title'},
255 borfirstname => $borr->{'firstname'},
256 bornum => $res->{'borrowernumber'},
257 borcnum => $borr->{'cardnumber'},
258 borphone => $borr->{'phone'},
259 borstraddress => $borr->{'streetaddress'},
260 borsub => $borr->{'suburb'},
261 borcity => $borr->{'city'},
262 borzip => $borr->{'zipcode'},
263 boremail => $borr->{'emailadress'},
271 foreach my $code ( keys %$messages ) {
275 my $exit_required_p = 0;
276 if ( $code eq 'BadBarcode' ) {
277 $err{badbarcode} = 1;
278 $err{msg} = $messages->{'BadBarcode'};
280 elsif ( $code eq 'NotIssued' ) {
282 $err{msg} = $branches->{ $messages->{'IsPermanent'} }->{'branchname'};
284 elsif ( $code eq 'WasLost' ) {
287 elsif ( $code eq 'ResFound' ) {
288 ; # FIXME... anything to do here?
290 elsif ( $code eq 'WasReturned' ) {
291 ; # FIXME... anything to do here?
293 elsif ( $code eq 'WasTransfered' ) {
294 ; # FIXME... anything to do here?
296 elsif ( $code eq 'ReserveIssued' ) {
297 $err{reserveissued} = 1;
299 elsif ( $code eq 'wthdrawn' ) {
301 $exit_required_p = 1;
303 elsif ( ( $code eq 'IsPermanent' ) && ( not $messages->{'ResFound'} ) ) {
304 if ( $messages->{'IsPermanent'} ne $branch ) {
305 $err{ispermanent} = 1;
307 $branches->{ $messages->{'IsPermanent'} }->{'branchname'};
311 die "Unknown error code $code"; # XXX
314 push ( @errmsgloop, \%err );
316 last if $exit_required_p;
318 $template->param( errmsgloop => \@errmsgloop );
322 my $flags = $borrower->{'flags'};
326 foreach my $flag ( sort keys %$flags ) {
328 ( $color eq $linecolor1 )
329 ? ( $color = $linecolor2 )
330 : ( $color = $linecolor1 );
331 unless ($flagset) { $flagset = 1; }
332 $flaginfo{color} = $color;
333 $flaginfo{redfont} = ( $flags->{$flag}->{'noissues'} );
334 $flaginfo{flag} = $flag;
335 if ( $flag eq 'CHARGES' ) {
336 $flaginfo{msg} = $flag;
337 $flaginfo{charges} = 1;
338 $flaginfo{bornum} = $borrower->{borrowernumber};
340 elsif ( $flag eq 'WAITING' ) {
341 $flaginfo{msg} = $flag;
342 $flaginfo{waiting} = 1;
344 my $items = $flags->{$flag}->{'itemlist'};
345 foreach my $item (@$items) {
346 my ($iteminformation) =
347 getiteminformation( \%env, $item->{'itemnumber'}, 0 );
349 $waitingitem{biblionum} = $iteminformation->{'biblionumber'};
350 $waitingitem{barcode} = $iteminformation->{'barcode'};
351 $waitingitem{title} = $iteminformation->{'title'};
352 $waitingitem{brname} =
353 $branches->{ $iteminformation->{'holdingbranch'} }->{
355 push ( @waitingitemloop, \%waitingitem );
357 $flaginfo{itemloop} = \@waitingitemloop;
359 elsif ( $flag eq 'ODUES' ) {
360 my $items = $flags->{$flag}->{'itemlist'};
362 foreach my $item ( sort { $a->{'date_due'} cmp $b->{'date_due'} }
365 my ($iteminformation) =
366 getiteminformation( \%env, $item->{'itemnumber'}, 0 );
368 $overdueitem{duedate} = $item->{'date_due'};
369 $overdueitem{biblionum} = $iteminformation->{'biblionumber'};
370 $overdueitem{barcode} = $iteminformation->{'barcode'};
371 $overdueitem{title} = $iteminformation->{'title'};
372 $overdueitem{brname} =
373 $branches->{ $iteminformation->{'holdingbranch'} }->{
375 push ( @itemloop, \%overdueitem );
377 $flaginfo{itemloop} = \@itemloop;
378 $flaginfo{overdue} = 1;
381 $flaginfo{other} = 1;
382 $flaginfo{msg} = $flags->{$flag}->{'message'};
384 push ( @flagloop, \%flaginfo );
388 flagloop => \@flagloop,
389 ribornum => $borrower->{'borrowernumber'},
390 riborcnum => $borrower->{'cardnumber'},
391 riborsurname => $borrower->{'surname'},
392 ribortitle => $borrower->{'title'},
393 riborfirstname => $borrower->{'firstname'}
399 #set up so only the last 8 returned items display (make for faster loading pages)
402 foreach ( sort { $a <=> $b } keys %returneditems ) {
405 ( $color eq $linecolor1 )
406 ? ( $color = $linecolor2 )
407 : ( $color = $linecolor1 );
409 my $barcode = $returneditems{$_};
410 my $duedate = $riduedate{$_};
416 $ri{duedate}=format_date($duedate);
418 getpatroninformation( \%env, $riborrowernumber{$_}, 0 );
419 $ri{bornum} = $borrower->{'borrowernumber'};
420 $ri{borcnum} = $borrower->{'cardnumber'};
421 $ri{borfirstname} = $borrower->{'firstname'};
422 $ri{borsurname} = $borrower->{'surname'};
423 $ri{bortitle} = $borrower->{'title'};
426 $ri{bornum} = $riborrowernumber{$_};
429 my ($iteminformation) = getiteminformation( \%env, 0, $barcode );
431 $ri{itembiblionumber} = $iteminformation->{'biblionumber'};
432 $ri{itemtitle} = $iteminformation->{'title'};
433 $ri{itemauthor} = $iteminformation->{'author'};
434 $ri{itemtype} = $iteminformation->{'itemtype'};
435 $ri{barcode} = $barcode;
441 push ( @riloop, \%ri );
443 $template->param( riloop => \@riloop );
446 genbrname => $branches->{$branch}->{'branchname'},
447 genprname => $printers->{$printer}->{'printername'},
450 errmsgloop => \@errmsgloop
453 # actually print the page!
454 output_html_with_http_headers $query, $cookie, $template->output;
456 sub cuecatbarcodedecode {
459 my @fields = split ( /\./, $barcode );
460 my @results = map( decode($_), @fields[ 1 .. $#fields ] );
461 if ( $#results == 2 ) {