3 # This script loops through each overdue item, determines the fine,
4 # and updates the total amount of fines due by each user. It relies on
5 # the existence of /tmp/fines, which is created by ???
6 # Doesnt really rely on it, it relys on being able to write to /tmp/
7 # It creates the fines file
9 # This script is meant to be run nightly out of cron.
11 # Copyright 2000-2002 Katipo Communications
13 # This file is part of Koha.
15 # Koha is free software; you can redistribute it and/or modify it under the
16 # terms of the GNU General Public License as published by the Free Software
17 # Foundation; either version 2 of the License, or (at your option) any later
20 # Koha is distributed in the hope that it will be useful, but WITHOUT ANY
21 # WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR
22 # A PARTICULAR PURPOSE. See the GNU General Public License for more details.
24 # You should have received a copy of the GNU General Public License along with
25 # Koha; if not, write to the Free Software Foundation, Inc., 59 Temple Place,
26 # Suite 330, Boston, MA 02111-1307 USA
33 use Date::Manip qw/Date_DaysSince1BC/;
37 open (FILE,'>/tmp/fines') || die;
39 # it looks like $count is just a counter, would it be
40 # better to rely on the length of the array @$data and turn the
41 # for loop below into a foreach loop?
44 my $data=Getoverdues();
45 # warn "Overdues : = ".scalar(@$data)." => ".Data::Dumper::Dumper($data);
46 my $overdueItemsCounted=0 if $DEBUG;
47 # FIXME - There's got to be a better way to figure out what day
49 my ($sec,$min,$hour,$mday,$mon,$year,$wday,$yday,$isdst) =localtime(time);
52 my $date=Date_DaysSince1BC($mon,$mday,$year);
53 # print "DATE : ".$date if $DEBUG;
60 my $reference = $year."".$mon;
63 for (my $i=0;$i<scalar(@$data);$i++){
64 my @dates=split('-',$data->[$i]->{'date_due'});
65 my $date2=Date_DaysSince1BC($dates[1],$dates[2],$dates[0]);
66 my $datedue=$data->[$i]->{'date_due'};
67 my $due="$dates[2]/$dates[1]/$dates[0]";
68 my $borrower=BorType($data->[$i]->{'borrowernumber'});
72 $overdueItemsCounted++ if $DEBUG;
73 my $difference=$date-$date2;
74 my ($amount,$type,$printout,$daycounttotal,$daycount)=
75 CalcFine($data->[$i]->{'itemnumber'},
76 $borrower->{'categorycode'},
80 my ($delays1,$delays2,$delays3)=GetOverdueDelays($borrower->{'categorycode'});
81 my $issuingrules=GetIssuingRules($data->[$i]->{'itemnumber'},$borrower->{'categorycode'});
83 # warn "$delays1 and $delays2 and $delays3";
84 if($delays1 and $delays2 and $delays3) {
86 my $debarredstatus=CheckBorrowerDebarred($borrower->{'borrowernumber'});
88 if (($issuingrules->{'fine'} > 0) || ($issuingrules->{'fine'} ne '' )){
90 #DELAYS 1##########################################
91 # warn "$amount > 0 && $daycount >= $delays1 && $daycount < $delays2";
92 if ($amount > 0 && $daycount >= $delays1 && $daycount < $delays2){
93 # FIXME : already in GetIssuingRules ?
94 my $debarred1=GetOverduerules($borrower->{'categorycode'},1);
95 (UpdateBorrowerDebarred($borrower->{'borrowernumber'}))if(($debarred1 eq '1' ) and ($debarredstatus eq '0'));
97 UpdateFine($data->[$i]->{'itemnumber'},$data->[$i]->{'borrowernumber'},$amount,$type,$due);
98 # is there an open "dossier" for this date & borrower
99 my $getnotifyid=CheckExistantNotifyid($borrower->{'borrowernumber'},$datedue);
101 my $update=CheckAccountLineLevelInfo($borrower->{'borrowernumber'},$data->[$i]->{'itemnumber'},1,$datedue);
103 if ($getnotifyid eq '0'){
104 $starter=GetNextIdNotify($reference,$borrower->{'borrowernumber'});
108 $starter=$getnotifyid;
112 UpdateAccountLines($starter,1,$borrower->{'borrowernumber'},$data->[$i]->{'itemnumber'});
114 ###############################################
116 if ($daycount>=$delays2) {
118 $amount=$issuingrules->{'fine'} * ($delays2);
119 UpdateFine($data->[$i]->{'itemnumber'},$data->[$i]->{'borrowernumber'},$amount,$type,$due);
123 #DELAYS 2#################################
125 if ($daycount >= $delays2 && $daycount < $delays3){
126 my $debarred2=GetOverduerules($borrower->{'categorycode'},2);
127 (UpdateBorrowerDebarred($borrower->{'borrowernumber'}))if(($debarred2 eq '1' ) and ($debarredstatus eq '0'));
128 my $update=CheckAccountLineLevelInfo($borrower->{'borrowernumber'},$data->[$i]->{'itemnumber'},2,$datedue);
130 UpdateAccountLines(undef,2,$borrower->{'borrowernumber'},$data->[$i]->{'itemnumber'});
133 ###############################################
135 #DELAYS 3###################################
136 if ($daycount >= $delays3 ){
137 my $debarred3=GetOverduerules($borrower->{'categorycode'},3);
138 (UpdateBorrowerDebarred($borrower->{'borrowernumber'}))if(($debarred3 eq '1' ) and ($debarredstatus eq '0'));
139 my $update=CheckAccountLineLevelInfo($borrower->{'borrowernumber'},$data->[$i]->{'itemnumber'},3,$datedue);
141 UpdateAccountLines(undef,3,$borrower->{'borrowernumber'},$data->[$i]->{'itemnumber'});
143 my $items=GetItems($data->[$i]->{'itemnumber'});
144 my $todaydate=$year."-".$mon."-".$mday;
145 # add item price, the item is considered as lost.
146 my $description="Item Price";
147 my $typeaccount="IP";
149 my $notifyid=GetNotifyId($borrower->{'borrowernumber'},$data->[$i]->{'itemnumber'});
150 my $timestamp=$todaydate." ".$hour."\:".$min."\:".$sec;
151 my $create=CheckAccountLineItemInfo($borrower->{'borrowernumber'},$data->[$i]->{'itemnumber'},$typeaccount,$notifyid);
154 CreateItemAccountLine($borrower->{'borrowernumber'},$data->[$i]->{'itemnumber'},$todaydate,$items->{'price'},$description,$typeaccount,
155 $items->{'price'},$timestamp,$notifyid,$level);
158 ###############################################
164 if ($borrower->{'category_type'} eq 'C'){
165 my $query=qq| SELECT *
167 WHERE borrowernumber=?|;
168 my $dbh = C4::Context->dbh;
169 my $sth=$dbh->prepare($query);
170 $sth->execute($borrower->{'guarantorid'});
171 my $tdata=$sth->fetchrow_hashref;
173 $borrower->{'phone'}=$tdata->{'phone'};
175 print "$printout\t$borrower->{'cardnumber'}\t$borrower->{'category_type'}\t$borrower->{'firstname'}\t$borrower->{'surname'}\t$data->[$i]->{'date_due'}\t$type\t$difference\t$borrower->{'email'}\t$borrower->{'phone'}\t$borrower->{'address'}\t$borrower->{'city'}\t$amount\n";
179 my $numOverdueItems=scalar(@$data);
183 Number of Overdue Items counted $overdueItemsCounted
184 Number of Overdue Items reported $numOverdueItems