3.15.00.041 was wrong, the name of the letter should not always been the
name of the first HOLD notice.
PREDUE_PHONE should be updated with the first name of the PREDUE notice,
same for OVERDUE_PHONE and OVERDUE
Signed-off-by: Chris Cormack <chrisc@catalyst.net.z>
Signed-off-by: Marcel de Rooy <m.de.rooy@rijksmuseum.nl>
Signed-off-by: Brendan Gallagher <brendan@bywatersolutions.com>
(cherry picked from commit
6d52cd63f351cd56f36492b80c10c0d8568ef03d)
Signed-off-by: Julian Maurice <julian.maurice@biblibre.com>
(cherry picked from commit
6ca552c2e86a4459ba8a68903b7ac60c614731af)
Signed-off-by: Chris Cormack <chrisc@catalyst.net.nz>
$DBversion = "3.15.00.041";
if ( CheckVersion($DBversion) ) {
- my $name = $dbh->selectcol_arrayref(q|
+ my ( $name ) = $dbh->selectrow_array(q|
SELECT name FROM letter WHERE code="HOLD"
|);
- $name = $name->[0];
$dbh->do(q|
UPDATE letter
SET code="HOLD",
WHERE code="HOLD_PHONE"
|, {}, $name);
+ ( $name ) = $dbh->selectrow_array(q|
+ SELECT name FROM letter WHERE code="PREDUE"
+ |);
$dbh->do(q|
UPDATE letter
SET code="PREDUE",
WHERE code="PREDUE_PHONE"
|, {}, $name);
+ ( $name ) = $dbh->selectrow_array(q|
+ SELECT name FROM letter WHERE code="OVERDUE"
+ |);
$dbh->do(q|
UPDATE letter
SET code="OVERDUE",