From f6e9dccadb697459f63d7ebb8cfac91bf73c2e63 Mon Sep 17 00:00:00 2001 From: Katrin Fischer Date: Sat, 6 Apr 2019 12:11:38 +0000 Subject: [PATCH] Bug 12166: (follow-up) Remove 'Reserve Charge' from descriptions in accountlines With the prior 'Hold fee' will be displayed in OPAC and staff, so the 'Reserve Charge' would just be an untranslatable double up of information. To test: - Make sure you create some Reserve Charges prior to applying this patch set - Verify they show in staff and OPAC account - Apply patch - Run database update - Verfy the "Rental Charge - " is gone and old and new entries match now --- installer/data/mysql/atomicupdate/bug_12166_reserve_charge.pl | 6 ++++++ 1 file changed, 6 insertions(+) create mode 100644 installer/data/mysql/atomicupdate/bug_12166_reserve_charge.pl diff --git a/installer/data/mysql/atomicupdate/bug_12166_reserve_charge.pl b/installer/data/mysql/atomicupdate/bug_12166_reserve_charge.pl new file mode 100644 index 0000000000..508dcddead --- /dev/null +++ b/installer/data/mysql/atomicupdate/bug_12166_reserve_charge.pl @@ -0,0 +1,6 @@ +$DBversion = 'XXX'; # will be replaced by the RM +if( CheckVersion( $DBversion ) ) { + $dbh->do("UPDATE accountlines SET description = REPLACE(description, 'Reserve Charge - ', '') WHERE description LIKE 'Reserve Charge - %'"); + SetVersion( $DBversion ); + print "Upgrade to $DBversion done (Bug 12166 - Remove 'Reserve Charge' text from accountlines description)\n"; +} -- 2.11.0