From e0662557646e59f6d8b467cf3e55573ab4997fad 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.perl | 6 ++++++ 1 file changed, 6 insertions(+) create mode 100644 installer/data/mysql/atomicupdate/bug_12166_reserve_charge.perl diff --git a/installer/data/mysql/atomicupdate/bug_12166_reserve_charge.perl b/installer/data/mysql/atomicupdate/bug_12166_reserve_charge.perl new file mode 100644 index 0000000000..508dcddead --- /dev/null +++ b/installer/data/mysql/atomicupdate/bug_12166_reserve_charge.perl @@ -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