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 |
|