diff options
author | Udo Walter | 2017-03-28 15:11:57 +0200 |
---|---|---|
committer | Udo Walter | 2017-03-28 15:11:57 +0200 |
commit | cca740195f76ef89563ab5c00a76c492a462d752 (patch) | |
tree | 05329226d22262de98e8a6dd5bbabf41f11ff0f4 /modules-available/permissionmanager/inc/dbupdate.inc.php | |
parent | [permission-manager] role-list order consistency (diff) | |
download | slx-admin-cca740195f76ef89563ab5c00a76c492a462d752.tar.gz slx-admin-cca740195f76ef89563ab5c00a76c492a462d752.tar.xz slx-admin-cca740195f76ef89563ab5c00a76c492a462d752.zip |
[permission-manager] added role editor (new role and edit role)
Diffstat (limited to 'modules-available/permissionmanager/inc/dbupdate.inc.php')
-rw-r--r-- | modules-available/permissionmanager/inc/dbupdate.inc.php | 17 |
1 files changed, 17 insertions, 0 deletions
diff --git a/modules-available/permissionmanager/inc/dbupdate.inc.php b/modules-available/permissionmanager/inc/dbupdate.inc.php index 20ff746a..417fd812 100644 --- a/modules-available/permissionmanager/inc/dbupdate.inc.php +++ b/modules-available/permissionmanager/inc/dbupdate.inc.php @@ -34,4 +34,21 @@ class DbUpdate { Database::exec($query); } + public static function saveRole($roleName, $locType, $locations, $permissions, $role = NULL) { + if ($role) { + Database::exec("UPDATE role SET name = '$roleName', locType = '$locType' WHERE id = $role"); + Database::exec("DELETE FROM roleXlocation WHERE roleid = $role"); + Database::exec("DELETE FROM roleXpermission WHERE roleid = $role"); + } else { + Database::exec("INSERT INTO role (name, locType) VALUES ('$roleName', '$locType')"); + $role = Database::lastInsertId(); + } + foreach ($locations as $locID) { + Database::exec("INSERT INTO roleXlocation (roleid, locid) VALUES ($role, $locID)"); + } + foreach ($permissions as $permission) { + Database::exec("INSERT INTO roleXpermission (roleid, permissionid) VALUES ($role, '$permission')"); + } + } + } |