From 11a27e2913693a46a16dd8a709d99b59bc8262f8 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 Signed-off-by: Owen Leonard Signed-off-by: Martin Renvoize --- .../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.20.1