Bugzilla – Attachment 44955 Details for
Bug 15076
Remove file misc/maintenance/fix_accountlines_date.pl
Home
|
New
|
Browse
|
Search
|
[?]
|
Reports
|
Help
|
New Account
|
Log In
[x]
|
Forgot Password
Login:
[x]
[patch]
Bug 15076: Remove file misc/maintenance/fix_accountlines_date.pl
Bug-15076-Remove-file-miscmaintenancefixaccountlin.patch (text/plain), 5.97 KB, created by
Marc Véron
on 2015-11-18 13:12:49 UTC
(
hide
)
Description:
Bug 15076: Remove file misc/maintenance/fix_accountlines_date.pl
Filename:
MIME Type:
Creator:
Marc Véron
Created:
2015-11-18 13:12:49 UTC
Size:
5.97 KB
patch
obsolete
>From 3ecbcdf5d3d25f9112e4fb0ea7b59116e2df6699 Mon Sep 17 00:00:00 2001 >From: =?UTF-8?q?Marc=20V=C3=A9ron?= <veron@veron.ch> >Date: Wed, 18 Nov 2015 14:02:23 +0100 >Subject: [PATCH] Bug 15076: Remove file > misc/maintenance/fix_accountlines_date.pl > >This patch removes the file misc/maintenance/fix_accountlines_date.pl > >To test: >- Verify that the file is removed. >--- > misc/maintenance/fix_accountlines_date.pl | 171 ----------------------------- > 1 file changed, 171 deletions(-) > delete mode 100755 misc/maintenance/fix_accountlines_date.pl > >diff --git a/misc/maintenance/fix_accountlines_date.pl b/misc/maintenance/fix_accountlines_date.pl >deleted file mode 100755 >index 470b84b..0000000 >--- a/misc/maintenance/fix_accountlines_date.pl >+++ /dev/null >@@ -1,171 +0,0 @@ >-#!/usr/bin/perl >-# >-# Copyright (C) 2008 LibLime >-# >-# This file is part of Koha. >-# >-# Koha is free software; you can redistribute it and/or modify it >-# under the terms of the GNU General Public License as published by >-# the Free Software Foundation; either version 3 of the License, or >-# (at your option) any later version. >-# >-# Koha is distributed in the hope that it will be useful, but >-# WITHOUT ANY WARRANTY; without even the implied warranty of >-# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the >-# GNU General Public License for more details. >-# >-# You should have received a copy of the GNU General Public License >-# along with Koha; if not, see <http://www.gnu.org/licenses>. >- >-use strict; >-use warnings; >-BEGIN { >- # find Koha's Perl modules >- # test carefully before changing this >- use FindBin; >- eval { require "$FindBin::Bin/../kohalib.pl" }; >-} >- >-use C4::Context; >-use Getopt::Long; >-use Pod::Usage; >-use Koha::DateUtils; >- >-=head1 NAME >- >-fix_accountlines_date.pl - Fix date code in the description of fines >- >-=head1 SYNOPSIS >- >-fix_accountlines_date.pl -m date_format [ -n fines_to_process ] [ -d ] [ --help or -h ] >- >- Options: >- --help or -h Brief usage message >- --man Full documentation >- -n fines_to_process How many fines to process; if left off will >- process all >- -m date_format What format the dates are currently in; 'us' >- or 'metric' (REQUIRED) >- -d Run in debugging mode >- >-=head1 DESCRIPTION >- >-This script fixes the date code in the description of fines. Previously, the >-format of this was determined by which script you were using to update fines (see the -m option) >- >-=over 8 >- >-=item B<--help> >- >-Prints a brief usage message and exits. >- >-=item B<--man> >- >-Prints a full manual page and exits. >- >-=item B<-n> >- >-Process only a certain amount of fines. If this option is left off, this script >-will process everything. >- >-=item B<-m> >- >-This required option tells the script what format your dates are currently in. >-If you were previously using the fines2.pl or fines-sanop.pl script to update >-your fines, they will be in 'metric' format. If you were using the fines-ll.pl >-script, they will be in 'us' format. After this script is finished, they will >-be in whatever format your 'dateformat' system preference specifies. >- >-=item B<-d> >- >-Run in debugging mode; this prints out a lot of information and should be used >-only if there is a problem and with the '-n' option. >- >-=back >- >-=cut >- >-my $mode = ''; >-my $want_help = 0; >-my $limit = -1; >-my $done = 0; >-my $DEBUG = 0; >- >-# Regexes for the two date formats >-our $US_DATE = '((0\d|1[0-2])\/([0-2]\d|3[01])\/(\d{4}))'; >-our $METRIC_DATE = '(([0-2]\d|3[01])\/(0\d|1[0-2])\/(\d{4}))'; >- >-sub print_usage { >- print <<_USAGE_ >-$0: Fix the date code in the description of fines >- >-Due to the multiple scripts used to update fines in earlier versions of Koha, >-this script should be used to change the format of the date codes in the >-accountlines table before you start using Koha 3.0. >- >-Parameters: >- --mode or -m This should be 'us' or 'metric', and tells the script >- what format your old dates are in. >- --debug or -d Run this script in debug mode. >- --limit or -n How many accountlines rows to fix; useful for testing. >- --help or -h Print out this help message. >-_USAGE_ >-} >- >-my $result = GetOptions( >- 'm=s' => \$mode, >- 'd' => \$DEBUG, >- 'n=i' => \$limit, >- 'help|h' => \$want_help, >-); >- >-if (not $result or $want_help or ($mode ne 'us' and $mode ne 'metric')) { >- print_usage(); >- exit 0; >-} >- >-our $dbh = C4::Context->dbh; >-$dbh->{AutoCommit} = 0; >-my $sth = $dbh->prepare(" >-SELECT borrowernumber, itemnumber, accountno, description >- FROM accountlines >- WHERE accounttype in ('FU', 'F', 'O', 'M') >-;"); >-$sth->execute(); >- >-my $update_sth = $dbh->prepare(' >-UPDATE accountlines >- SET description = ? >- WHERE borrowernumber = ? AND itemnumber = ? AND accountno = ? >-;'); >- >- >-while (my $accountline = $sth->fetchrow_hashref) { >- my $description = $accountline->{'description'}; >- my $updated = 0; >- >- if ($mode eq 'us') { >- if ($description =~ /$US_DATE/) { # mm/dd/yyyy >- my $date = output_pref( { dt => dt_from_string( $1, 'us' ), dateonly => 1} ); >- print "Converting $1 (us) to " . $date . "\n" if $DEBUG;i >- $description =~ s/$US_DATE/$date/; >- $updated = 1; >- } >- } elsif ($mode eq 'metric') { >- if ($description =~ /$METRIC_DATE/) { # dd/mm/yyyy >- my $date = output_pref( { dt => dt_from_string( $1, 'metric' ), dateonly => 1} ); >- print "Converting $1 (metric) to " . $date . "\n" if $DEBUG; >- $description =~ s/$METRIC_DATE/$date/; >- $updated = 2; >- } >- } >- >- print "Changing description from '" . $accountline->{'description'} . "' to '" . $description . "'\n" if $DEBUG; >- $update_sth->execute($description, $accountline->{'borrowernumber'}, $accountline->{'itemnumber'}, $accountline->{'accountno'}); >- >- $done++; >- >- last if ($done == $limit); # $done can't be -1, so this works >-} >- >-$dbh->commit(); >-- >1.7.10.4
You cannot view the attachment while viewing its details because your browser does not support IFRAMEs.
View the attachment on a separate page
.
View Attachment As Diff
View Attachment As Raw
Actions:
View
|
Diff
|
Splinter Review
Attachments on
bug 15076
: 44955