From 8b68c65e33201a9e9d352c9bb67df4ba64675f4e Mon Sep 17 00:00:00 2001 From: Julian Maurice Date: Fri, 28 Mar 2014 11:19:34 +0100 Subject: [PATCH 3/4] Bug 7292: Add new permission to users that have 'order_receive' permission Signed-off-by: Paola Rossi --- installer/data/mysql/updatedatabase.pl | 15 ++++++++++++--- 1 file changed, 12 insertions(+), 3 deletions(-) diff --git a/installer/data/mysql/updatedatabase.pl b/installer/data/mysql/updatedatabase.pl index 646909e..48e7066 100755 --- a/installer/data/mysql/updatedatabase.pl +++ b/installer/data/mysql/updatedatabase.pl @@ -8553,12 +8553,21 @@ if (CheckVersion($DBversion)) { $DBversion = "XXX"; if ( C4::Context->preference("Version") < TransformToNum($DBversion) ) { - $dbh->do(" + $dbh->do(q{ INSERT IGNORE INTO permissions (module_bit, code, description) VALUES (11, 'order_claim_for_all', 'Claim for all orders') - "); + }); + + # Add this new permission to all users that have 'order_receive' permission + $dbh->do(q{ + INSERT INTO user_permissions (borrowernumber, module_bit, code) + SELECT borrowernumber, 11, 'order_claim_for_all' + FROM user_permissions + WHERE code = 'order_receive' + GROUP BY borrowernumber + }); - print "Upgrade to $DBversion done (Add permission order_claim_for_all)\n"; + print "Upgrade to $DBversion done (Bug 7292: Add permission order_claim_for_all)\n"; SetVersion($DBversion); } -- 1.7.10.4