View | Details | Raw Unified | Return to bug 14783
Collapse All | Expand All

(-)a/installer/data/mysql/db_revs/220600064.pl (-3 / +8 lines)
Lines 12-22 return { Link Here
12
            VALUES ('OPACAllowUserToChangeBranch','','Pending, In-Transit, Suspended','Allow users to change the library to pick up a hold for these statuses:','multiple');
12
            VALUES ('OPACAllowUserToChangeBranch','','Pending, In-Transit, Suspended','Allow users to change the library to pick up a hold for these statuses:','multiple');
13
        });
13
        });
14
14
15
	my ($value) = $dbh->selectrow_array(q{
16
            SELECT CASE WHEN value=1 THEN 'intransit' ELSE '' END
17
            FROM systempreferences
18
            WHERE variable='OPACInTransitHoldPickupLocationChange'
19
        });
20
15
        $dbh->do(q{
21
        $dbh->do(q{
16
            UPDATE systempreferences
22
            UPDATE systempreferences
17
            SET value=(SELECT CASE WHEN value=1 THEN 'intransit' ELSE '' END FROM systempreferences WHERE variable='OPACInTransitHoldPickupLocationChange')
23
            SET value=(?)
18
            WHERE variable='OPACAllowUserToChangeBranch'
24
            WHERE variable='OPACAllowUserToChangeBranch'
19
        });
25
        },undef,$value);
20
26
21
        say $out "Added new system preference 'OPACAllowUserToChangeBranch'";
27
        say $out "Added new system preference 'OPACAllowUserToChangeBranch'";
22
28
23
- 

Return to bug 14783