Attachment #143025 for bug #14783

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




            VALUES ('OPACAllowUserToChangeBranch','','Pending, In-Transit, Suspended','Allow users to change the library to pick up a hold for these statuses:','multiple');
        });

	my ($value) = $dbh->selectrow_array(q{
            SELECT CASE WHEN value=1 THEN 'intransit' ELSE '' END
            FROM systempreferences
            WHERE variable='OPACInTransitHoldPickupLocationChange'
        });

        $dbh->do(q{
            UPDATE systempreferences
            SET value=(?)
            WHERE variable='OPACAllowUserToChangeBranch'
        },undef,$value);

        say $out "Added new system preference 'OPACAllowUserToChangeBranch'";

- 

Return to bug 14783

Lines 12-22 return { Link Here

(-)a/installer/data/mysql/db_revs/220600064.pl (-3 / +8 lines)
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	-