1 package C4::Circulation::Issues;
5 #package to deal with Issues
6 #written 3/11/99 by chris@katipo.co.nz
8 # Copyright 2000-2002 Katipo Communications
10 # This file is part of Koha.
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
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.
21 # You should have received a copy of the GNU General Public License along with
22 # Koha; if not, write to the Free Software Foundation, Inc., 59 Temple Place,
23 # Suite 330, Boston, MA 02111-1307 USA
25 # FIXME - AFAICT the only function here that's still being used is
26 # &formatitem, and I'm not convinced that it's really being used.
34 use C4::Circulation::Main;
35 # FIXME - C4::Circulation::Main and C4::Circulation::Issues
36 # use each other, so functions get redefined.
37 use C4::Circulation::Borrower;
38 # FIXME - C4::Circulation::Issues and C4::Circulation::Borrower
39 # use each other, so functions get redefined.
45 use vars qw($VERSION @ISA @EXPORT);
47 # set the version for version checking
52 C4::Circulation::Issues - Miscellaneous functions related to Koha issues
56 use C4::Circulation::Issues;
60 This module provides a function for pretty-printing an item being
71 @EXPORT = qw(&Issue &formatitem);
73 # FIXME - This is only used in C4::Circmain and C4::Circulation, both
74 # of which look obsolete. Is this function obsolete as well?
75 # If not, this needs a POD.
78 my $dbh = C4::Context->dbh;
83 my ($items,$items2,$amountdue);
85 $env->{'sysarea'} = "Issues";
87 while ($done eq "Issues") {
88 my ($bornum,$issuesallowed,$borrower,$reason,$amountdue) = &findborrower($env,$dbh);
89 #C4::Circulation::Borrowers
90 $env->{'loanlength'}="";
93 } elsif ($env->{'IssuesAllowed'} eq '0') {
94 error_msg($env,"No Issues Allowed =$env->{'IssuesAllowed'}");
96 $env->{'bornum'} = $bornum;
97 $env->{'bcard'} = $borrower->{'cardnumber'};
98 #deal with alternative loans
101 C4::Circulation::Main::pastitems($env,$bornum,$dbh); #from Circulation.pm
104 while ($done eq 'No'){
105 ($done,$items2,$it2p,$amountdue,$itemsdet) =
106 &processitems($env,$bornum,$borrower,$items,
107 $items2,$it2p,$amountdue,$itemsdet);
112 Cdk::refreshCdkScreen();
116 # FIXME - Not exported, but called by "telnet/borrwraper.pl".
117 # Presumably this function is obsolete.
119 #process a users items
120 my ($env,$bornum,$borrower,$items,$items2,$it2p,$amountdue,$itemsdet,$odues)=@_;
121 my $dbh = C4::Context->dbh;
122 $env->{'newborrower'} = "";
123 my ($itemnum,$reason) =
124 issuewindow($env,'Issues',$dbh,$items,$items2,$borrower,fmtdec($env,$amountdue,"32"));
126 $reason = "Finished user";
128 my ($item,$charge,$datedue) = &issueitem($env,$dbh,$itemnum,$bornum,$items);
129 if ($datedue ne "") {
130 my $line = formatitem($env,$item,$datedue,$charge);
131 unshift @$items2,$line;
132 #$items2->[$it2p] = $line;
133 $item->{'date_due'} = $datedue;
134 $item->{'charge'} = $charge;
135 $itemsdet->[$it2p] = $item;
137 $amountdue += $charge;
140 #check to see if more books to process for this user
142 if ($env->{'newborrower'} ne "") {$reason = "Finished user";}
143 if ($reason eq 'Finished user'){
144 if (@$items2[0] ne "") {
145 remoteprint($env,$itemsdet,$borrower);
146 if ($amountdue > 0) {
147 &reconcileaccount($env,$dbh,$borrower->{'borrowernumber'},$amountdue);
151 } elsif ($reason eq "Print"){
152 remoteprint($env,$itemsdet,$borrower);
153 @done = ("No",$items2,$it2p);
155 if ($reason ne 'Finished issues'){
156 #return No to let them know that we wish to
157 # process more Items for borrower
158 @done = ("No",$items2,$it2p,$amountdue,$itemsdet);
163 #debug_msg($env, "return from issues $done[0]");
169 $line = &formatitem($env, $item, $datedue, $charge);
171 Pretty-prints a description of an item being issued, and returns the
172 pretty-printed string.
174 C<$env> is effectively ignored.
176 C<$item> is a reference-to-hash whose keys are fields from the items
177 table in the Koha database.
179 C<$datedue> is a string that will be prepended to the output.
181 C<$charge> is a number that will be appended to the output.
183 The return value C<$line> is a string of the form
185 I<$datedue $barcode $title: $author $type$dewey$subclass $charge>
187 where those values that are not passed in as arguments are obtained
193 my ($env,$item,$datedue,$charge) = @_;
194 my $line = $datedue." ".$item->{'barcode'}." ".$item->{'title'}.": ".$item->{'author'};
195 # FIXME - Use string interpolation or sprintf()
196 my $iclass = $item->{'itemtype'};
197 # FIXME - The Dewey code is a string, not a number.
198 if ($item->{'dewey'} > 0) {
199 my $dewey = $item->{'dewey'};
202 $iclass .= $dewey.$item->{'subclass'};
204 my $llen = 65 - length($iclass);
205 my $line = fmtstr($env,$line,"L".$llen);
206 # FIXME - Use sprintf() instead of &fmtstr.
207 my $line .= " $iclass ";
208 my $line .= fmtdec($env,$charge,"22");
212 # Only used internally
213 # FIXME - Only used by &processitems, which appears to be obsolete.
215 my ($env,$dbh,$itemnum,$bornum,$items)=@_;
216 $itemnum=uc $itemnum;
218 ## my ($itemnum,$reason)=&scanbook();
221 my $datedue = $env->{'loanlength'};
222 my $sth=$dbh->prepare("Select * from items,biblio,biblioitems where (barcode=?) and
223 (items.biblionumber=biblio.biblionumber) and
224 (items.biblioitemnumber=biblioitems.biblioitemnumber) ");
225 $sth->execute($itemnum);
226 if ($item=$sth->fetchrow_hashref) {
228 #check if item is restricted
229 if ($item->{'notforloan'} == 1) {
230 error_msg($env,"Item Not for Loan");
232 } elsif ($item->{'wthdrawn'} == 1) {
233 error_msg($env,"Item Withdrawn");
235 # } elsif ($item->{'itemlost'} == 1) {
236 # error_msg($env,"Item Lost");
238 } elsif ($item->{'restricted'} == 1 ){
239 error_msg($env,"Restricted Item");
240 #check borrowers status to take out restricted items
241 # if borrower allowed {
246 } elsif ($item->{'itemtype'} eq 'REF'){
247 error_msg($env,"Item Not for Loan");
250 #check if item is on issue already
251 if ($canissue == 1) {
252 my ($currbor,$issuestat,$newdate) =
253 &C4::Circulation::Main::previousissue($env,$item->{'itemnumber'},$dbh,$bornum);
254 if ($issuestat eq "N") {
256 } elsif ($issuestat eq "R") {
259 $charge = calc_charges($env,$dbh,$item->{'itemnumber'},$bornum);
261 createcharge($env,$dbh,$item->{'itemnumber'},$bornum,$charge);
263 &UpdateStats($env,$env->{'branchcode'},'renew',$charge,'',$item->{'itemnumber'},$item->{'itemtype'});
266 if ($canissue == 1) {
268 my ($resbor,$resrec) = &C4::Circulation::Main::checkreserve($env,$dbh,$item->{'itemnumber'});
269 #debug_msg($env,$resbor);
270 if ($resbor eq $bornum) {
271 my $rsth = $dbh->prepare("update reserves
273 where reservedate = ?
274 and borrowernumber = ?
275 and biblionumber = ?");
276 $rsth->execute($resrec->{'reservedate'},$resrec->{'borrowernumber'},$resrec->{'biblionumber'});
278 } elsif ($resbor ne "") {
279 my $btsh = $dbh->prepare("select * from borrowers where borrowernumber = ?");
280 $btsh->execute($resbor);
281 my $resborrower = $btsh->fetchrow_hashref;
282 my $msgtxt = chr(7)."Res for $resborrower->{'cardnumber'},";
283 $msgtxt .= " $resborrower->{'initials'} $resborrower->{'surname'}";
284 my $ans = msg_ny($env,$msgtxt,"Allow issue?");
287 printreserve($env,$resrec,$resborrower,$item);
290 my $ans = msg_ny($env,"Cancel reserve?");
292 my $rsth = $dbh->prepare("update reserves
294 where reservedate = ?
295 and borrowernumber = ?
296 and biblionumber = ?");
297 $rsth->execute($resrec->{'reservedate'},$resrec->{'borrowernumber'},$resrec->{'biblionumber'});
304 #if charge deal with it
306 if ($canissue == 1) {
307 $charge = calc_charges($env,$dbh,$item->{'itemnumber'},$bornum);
309 if ($canissue == 1) {
311 $datedue=&updateissues($env,$item->{'itemnumber'},$item->{'biblioitemnumber'},$dbh,$bornum);
312 #debug_msg("","date $datedue");
313 &UpdateStats($env,$env->{'branchcode'},'issue',$charge,'',$item->{'itemnumber'},$item->{'itemtype'});
315 createcharge($env,$dbh,$item->{'itemnumber'},$bornum,$charge);
317 } elsif ($canissue == 0) {
318 info_msg($env,"Can't issue $item->{'cardnumber'}");
321 my $valid = checkdigit($env,$itemnum, 1);
323 if (substr($itemnum,0,1) = "V") {
325 $env->{'newborrower'} = $itemnum;
327 error_msg($env,"$itemnum not found - rescan");
330 error_msg($env,"Invalid Number");
334 #debug_msg($env,"date $datedue");
335 return($item,$charge,$datedue);
338 # FIXME - A virtually identical function appears in
339 # C4::Circulation::Circ2. Pick one and stick with it.
341 my ($env,$dbh,$itemno,$bornum,$charge) = @_;
342 my $nextaccntno = getnextacctno($env,$bornum,$dbh);
343 my $sth = $dbh->prepare("insert into accountlines
344 (borrowernumber,itemnumber,accountno,date,amount,
345 description,accounttype,amountoutstanding)
346 values (?,?,?,now(),?,'Rental','Rent',?)");
347 $sth->execute($bornum,$itemno,$nextaccntno,$charge,$charge);
352 # Only used internally
355 my ($env,$itemno,$bitno,$dbh,$bornum)=@_;
357 my $sth=$dbh->prepare("Select * from biblioitems,itemtypes
358 where (biblioitems.biblioitemnumber=?)
359 and (biblioitems.itemtype = itemtypes.itemtype)");
360 $sth->execute($bitno);
361 if (my $data=$sth->fetchrow_hashref) {
362 $loanlength = $data->{'loanlength'}
366 if ($env->{'loanlength'} eq "") {
368 my $datedue = time + ($loanlength * 86400);
369 my @datearr = localtime($datedue);
370 $dateduef = (1900+$datearr[5])."-".($datearr[4]+1)."-".$datearr[3];
372 $dateduef = $env->{'loanlength'};
374 #FIXME: what is going on above? Replaces with MySQL function or strftime?
375 my $sth=$dbh->prepare("Insert into issues (borrowernumber,itemnumber, date_due,branchcode)
377 $sth->execute($bornum,$itemno,$dateduef,$env->{'branchcode'});
379 $sth=$dbh->prepare("Select * from items where itemnumber=?");
380 $sth->execute($itemno);
381 my $item=$sth->fetchrow_hashref;
384 $sth=$dbh->prepare("Update items set issues=? where itemnumber=?");
385 $sth->execute($item->{'issues'},$itemno);
387 #my ($sec,$min,$hour,$mday,$mon,$year,$wday,$yday,$isdst) = localtime($datedue);
388 my @datearr = split('-',$dateduef);
389 my $dateret = join('-',$datearr[2],$datearr[1],$datearr[0]);
390 # debug_msg($env,"query $query");
394 # FIXME - This is very similar to
395 # &C4::Circulation::Renewals2::calc_charges and
396 # &C4::Circulation::Circ2::calc_charges.
397 # Pick one and stick with it.
399 # Only used internally
401 # calculate charges due
402 my ($env, $dbh, $itemno, $bornum)=@_;
405 my $sth1= $dbh->prepare("select itemtypes.itemtype,rentalcharge from items,biblioitems,itemtypes
406 where (items.itemnumber =?)
407 and (biblioitems.biblioitemnumber = items.biblioitemnumber)
408 and (biblioitems.itemtype = itemtypes.itemtype)");
409 $sth1->execute($itemno);
410 if (my $data1=$sth1->fetchrow_hashref) {
411 $item_type = $data1->{'itemtype'};
412 $charge = $data1->{'rentalcharge'};
413 my $sth2=$dbh->prepare("select rentaldiscount from borrowers,categoryitem
414 where (borrowers.borrowernumber = ?)
415 and (borrowers.categorycode = categoryitem.categorycode)
416 and (categoryitem.itemtype = ?)");
417 $sth2->execute($bornum,$item_type);
418 if (my $data2=$sth2->fetchrow_hashref) {
419 my $discount = $data2->{'rentaldiscount'};
420 $charge = ($charge *(100 - $discount)) / 100;
435 Koha Developement team <info@koha.org>