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
25 # with Koha; if not, write to the Free Software Foundation, Inc.,
26 # 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA.
29 # FIXME: use FinesMode as described or change syspref description
31 #use warnings; FIXME - Bug 2505
34 # find Koha's Perl modules
35 # test carefully before changing this
37 eval { require "$FindBin::Bin/kohalib.pl" };
40 use Date::Calc qw/Date_to_Days/;
45 use C4::Calendar qw(); # don't need any exports from Calendar
47 use C4::Debug; # supplying $debug and $cgi_debug
54 GetOptions( 'h|help' => \$help,
55 'v|verbose' => \$verbose,
56 'o|out:s' => \$output_dir,
58 my $usage = << 'ENDUSAGE';
60 This script calculates and charges overdue fines
61 to patron accounts. If the Koha System Preference
62 'finesMode' is set to 'production', the fines are charged
63 to the patron accounts. If set to 'test', the fines are
64 calculated but not applied.
66 This script has the following parameters :
67 -h --help: this message
68 -o --out: ouput directory for logs (defaults to env or /tmp if !exist)
75 use vars qw(@borrower_fields @item_fields @other_fields);
76 use vars qw($fldir $libname $control $mode $delim $dbname $today $today_iso $today_days);
77 use vars qw($filename);
80 @borrower_fields = qw(cardnumber categorycode surname firstname email phone address citystate);
81 @item_fields = qw(itemnumber barcode date_due);
82 @other_fields = qw(type days_overdue fine);
83 $libname = C4::Context->preference('LibraryName');
84 $control = C4::Context->preference('CircControl');
85 $mode = C4::Context->preference('finesMode');
86 $dbname = C4::Context->config('database');
87 $delim = "\t"; # ? C4::Context->preference('delimiter') || "\t";
92 $debug and print "Each line will contain the following fields:\n",
93 "From borrowers : ", join(', ', @borrower_fields), "\n",
94 "From items : ", join(', ', @item_fields), "\n",
95 "Per overdue: ", join(', ', @other_fields), "\n",
96 "Delimiter: '$delim'\n";
99 my $data = Getoverdues();
100 my $overdueItemsCounted = 0;
102 $today = C4::Dates->new();
103 $today_iso = $today->output('iso');
104 $today_days = Date_to_Days(split(/-/,$today_iso));
106 $fldir = $output_dir if( -d $output_dir );
108 $fldir = $ENV{TMPDIR} || "/tmp";
111 warn "Could not write to $fldir ... does not exist!";
115 $filename = $fldir . '/'. $filename . '_' . $today_iso . ".log";
116 print "writing to $filename\n" if $verbose;
117 open (FILE, ">$filename") or die "Cannot write file $filename: $!";
118 print FILE join $delim, (@borrower_fields, @item_fields, @other_fields);
121 for (my $i=0; $i<scalar(@$data); $i++) {
122 my $datedue = C4::Dates->new($data->[$i]->{'date_due'},'iso');
123 my $datedue_days = Date_to_Days(split(/-/,$datedue->output('iso')));
124 my $due_str = $datedue->output();
125 unless (defined $data->[$i]->{'borrowernumber'}) {
126 print STDERR "ERROR in Getoverdues line $i: issues.borrowernumber IS NULL. Repair 'issues' table now! Skipping record.\n";
127 next; # Note: this doesn't solve everything. After NULL borrowernumber, multiple issues w/ real borrowernumbers can pile up.
129 my $borrower = BorType($data->[$i]->{'borrowernumber'});
130 my $branchcode = ($control eq 'ItemHomeLibrary') ? $data->[$i]->{homebranch} :
131 ($control eq 'PatronLibrary' ) ? $borrower->{branchcode} :
132 $data->[$i]->{branchcode} ;
133 # In final case, CircControl must be PickupLibrary. (branchcode comes from issues table here).
135 unless (defined ($calendars{$branchcode})) {
136 $calendars{$branchcode} = C4::Calendar->new(branchcode => $branchcode);
138 $calendar = $calendars{$branchcode};
139 my $isHoliday = $calendar->isHoliday(split '/', $today->output('metric'));
141 ($datedue_days <= $today_days) or next; # or it's not overdue, right?
143 $overdueItemsCounted++;
144 my ($amount,$type,$daycounttotal,$daycount)=
145 CalcFine($data->[$i], $borrower->{'categorycode'}, $branchcode,undef,undef, $datedue, $today);
146 # FIXME: $type NEVER gets populated by anything.
147 (defined $type) or $type = '';
148 # Don't update the fine if today is a holiday.
149 # This ensures that dropbox mode will remove the correct amount of fine.
150 if ($mode eq 'production' and ! $isHoliday) {
151 UpdateFine($data->[$i]->{'itemnumber'},$data->[$i]->{'borrowernumber'},$amount,$type,$due_str) if( $amount > 0 ) ;
154 push @cells, map {$borrower->{$_}} @borrower_fields;
155 push @cells, map {$data->[$i]->{$_}} @item_fields;
156 push @cells, $type, $daycounttotal, $amount;
157 print FILE join($delim, @cells), "\n";
160 my $numOverdueItems = scalar(@$data);
163 Fines assessment -- $today_iso -- Saved to $filename
164 Number of Overdue Items:
165 counted $overdueItemsCounted
166 reported $numOverdueItems