|
Line 0
Link Here
|
| 0 |
- |
1 |
#!/usr/bin/perl |
|
|
2 |
# |
| 3 |
# Copyright (C) 2012 ByWater Solutions |
| 4 |
# |
| 5 |
# This file is part of Koha. |
| 6 |
# |
| 7 |
# Koha is free software; you can redistribute it and/or modify it under the |
| 8 |
# terms of the GNU General Public License as published by the Free Software |
| 9 |
# Foundation; either version 2 of the License, or (at your option) any later |
| 10 |
# version. |
| 11 |
# |
| 12 |
# Koha is distributed in the hope that it will be useful, but WITHOUT ANY |
| 13 |
# WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR |
| 14 |
# A PARTICULAR PURPOSE. See the GNU General Public License for more details. |
| 15 |
# |
| 16 |
# You should have received a copy of the GNU General Public License along |
| 17 |
# with Koha; if not, write to the Free Software Foundation, Inc., |
| 18 |
# 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA. |
| 19 |
|
| 20 |
use strict; |
| 21 |
use warnings; |
| 22 |
|
| 23 |
BEGIN { |
| 24 |
# find Koha's Perl modules |
| 25 |
# test carefully before changing this |
| 26 |
use FindBin; |
| 27 |
eval { require "$FindBin::Bin/../kohalib.pl" }; |
| 28 |
} |
| 29 |
|
| 30 |
use C4::Context; |
| 31 |
use C4::Installer; |
| 32 |
use C4::Dates; |
| 33 |
|
| 34 |
use Getopt::Long; |
| 35 |
use Data::Dumper; |
| 36 |
|
| 37 |
sub print_usage { |
| 38 |
print <<_USAGE_ |
| 39 |
$0: Remove duplicate fines |
| 40 |
|
| 41 |
Due to bug 8253, upgrading from Koha 3.6 to 3.8 may introduce duplicate fines. |
| 42 |
This script will remove these duplicate fines. To use, repeatably run this |
| 43 |
script until there are no more duplicates in the database. |
| 44 |
|
| 45 |
Parameters: |
| 46 |
--confirm or -c Confirm you want to run the script. |
| 47 |
--help or -h Print out this help message. |
| 48 |
_USAGE_ |
| 49 |
} |
| 50 |
|
| 51 |
my $help; |
| 52 |
my $confirm; |
| 53 |
my $result = GetOptions( |
| 54 |
'confirm|c' => \$confirm, |
| 55 |
'help|h' => \$help, |
| 56 |
); |
| 57 |
if ( $help || !$confirm ) { |
| 58 |
print_usage(); |
| 59 |
exit 0; |
| 60 |
} |
| 61 |
|
| 62 |
|
| 63 |
my $dbh = C4::Context->dbh; |
| 64 |
|
| 65 |
my $query = " |
| 66 |
SELECT * FROM accountlines |
| 67 |
WHERE ( accounttype = 'FU' OR accounttype = 'F' ) |
| 68 |
AND description like '%23:59%' |
| 69 |
ORDER BY borrowernumber, itemnumber, accountno, description |
| 70 |
"; |
| 71 |
my $sth = $dbh->prepare($query); |
| 72 |
$sth->execute(); |
| 73 |
my $results = $sth->fetchall_arrayref( {} ); |
| 74 |
|
| 75 |
$query = |
| 76 |
"SELECT * FROM accountlines WHERE description LIKE ? AND description NOT LIKE ?"; |
| 77 |
$sth = $dbh->prepare($query); |
| 78 |
|
| 79 |
my @fines; |
| 80 |
foreach my $keeper (@$results) { |
| 81 |
|
| 82 |
warn "WORKING ON KEEPER: " . Data::Dumper::Dumper( $keeper ); |
| 83 |
my ($description_to_match) = split( / 23:59/, $keeper->{'description'} ); |
| 84 |
$description_to_match .= '%'; |
| 85 |
|
| 86 |
warn "DESCRIPTION TO MATCH: " . $description_to_match; |
| 87 |
|
| 88 |
$sth->execute( $description_to_match, $keeper->{'description'} ); |
| 89 |
|
| 90 |
my $has_changed = 0; |
| 91 |
|
| 92 |
while ( my $f = $sth->fetchrow_hashref() ) { |
| 93 |
|
| 94 |
warn "DELETING: " . Data::Dumper::Dumper( $f ); |
| 95 |
|
| 96 |
if ( $f->{'amountoutstanding'} < $keeper->{'amountoutstanding'} ) { |
| 97 |
$keeper->{'amountoutstanding'} = $f->{'amountoutstanding'}; |
| 98 |
$has_changed = 1; |
| 99 |
} |
| 100 |
|
| 101 |
my $sql = |
| 102 |
"DELETE FROM accountlines WHERE borrowernumber = ? AND accountno = ? AND itemnumber = ? AND date = ? AND description = ? LIMIT 1"; |
| 103 |
$dbh->do( $sql, undef, $f->{'borrowernumber'}, |
| 104 |
$f->{'accountno'}, $f->{'itemnumber'}, $f->{'date'}, |
| 105 |
$f->{'description'} ); |
| 106 |
} |
| 107 |
|
| 108 |
if ($has_changed) { |
| 109 |
my $sql = |
| 110 |
"UPDATE accountlines SET amountoutstanding = ? WHERE borrowernumber = ? AND accountno = ? AND itemnumber = ? AND date = ? AND description = ? LIMIT 1"; |
| 111 |
$dbh->do( |
| 112 |
$sql, undef, |
| 113 |
$keeper->{'amountoutstanding'}, $keeper->{'borrowernumber'}, |
| 114 |
$keeper->{'accountno'}, $keeper->{'itemnumber'}, |
| 115 |
$keeper->{'date'}, $keeper->{'description'} |
| 116 |
); |
| 117 |
} |
| 118 |
} |
| 119 |
|
| 120 |
exit; |
| 121 |
|