From d033483d3ed9e05f1109a3713ec6a3df883a1dae Mon Sep 17 00:00:00 2001
From: Udo Walter
Date: Fri, 7 Apr 2017 15:49:54 +0200
Subject: [permission-manager] renamed some files, moved html generation to
 templates, using bind variables in mysql code, changed order of modules in
 role editor

---
 .../inc/permissiondbupdate.inc.php                 | 57 ++++++++++++++++++++++
 1 file changed, 57 insertions(+)
 create mode 100644 modules-available/permissionmanager/inc/permissiondbupdate.inc.php

(limited to 'modules-available/permissionmanager/inc/permissiondbupdate.inc.php')

diff --git a/modules-available/permissionmanager/inc/permissiondbupdate.inc.php b/modules-available/permissionmanager/inc/permissiondbupdate.inc.php
new file mode 100644
index 00000000..87c989fa
--- /dev/null
+++ b/modules-available/permissionmanager/inc/permissiondbupdate.inc.php
@@ -0,0 +1,57 @@
+<?php
+
+class PermissionDbUpdate {
+
+	// insert new user_x_role to database. "ignore" to ignore duplicate entry try
+	public static function addRoleToUser($users, $roles) {
+		foreach($users AS $user) {
+			foreach ($roles AS $role) {
+				$query = "INSERT IGNORE INTO user_x_role (userid, roleid) VALUES (:user, :role)";
+				Database::exec($query, array("user" => $user, "role" => $role));
+			}
+		}
+	}
+
+	// remove user_x_role entry from database
+	public static function removeRoleFromUser($users, $roles) {
+		foreach($users AS $user) {
+			foreach ($roles AS $role) {
+				$query = "DELETE FROM user_x_role WHERE userid = :user AND roleid = :role";
+				Database::exec($query, array("user" => $user, "role" => $role));
+			}
+		}
+	}
+
+	// delete role, delete user_x_role relationships, delete role_x_location relationships, delete role_x_permission relationships
+	public static function deleteRole($id) {
+		$query = "DELETE FROM role WHERE id = :id";
+		Database::exec($query, array("id" => $id));
+		$query = "DELETE FROM user_x_role WHERE roleid = :id";
+		Database::exec($query, array("id" => $id));
+		$query = "DELETE FROM role_x_location WHERE roleid = :id";
+		Database::exec($query, array("id" => $id));
+		$query = "DELETE FROM role_x_permission WHERE roleid = :id";
+		Database::exec($query, array("id" => $id));
+	}
+
+	public static function saveRole($roleName, $locations, $permissions, $role = NULL) {
+		if ($role) {
+			Database::exec("UPDATE role SET name = :roleName WHERE id = :role",
+									array("roleName" => $roleName, "role" => $role));
+			Database::exec("DELETE FROM role_x_location WHERE roleid = :role", array("role" => $role));
+			Database::exec("DELETE FROM role_x_permission WHERE roleid = :role", array("role" => $role));
+		} else {
+			Database::exec("INSERT INTO role (name) VALUES (:roleName)", array("roleName" => $roleName));
+			$role = Database::lastInsertId();
+		}
+		foreach ($locations as $locID) {
+			Database::exec("INSERT INTO role_x_location (roleid, locid) VALUES (:role, :locid)",
+									array("role" => $role, "locid" => $locID));
+		}
+		foreach ($permissions as $permission) {
+			Database::exec("INSERT INTO role_x_permission (roleid, permissionid) VALUES (:role, :permission)",
+											array("role" => $role, "permission" => $permission));
+		}
+	}
+
+}
-- 
cgit v1.2.3-55-g7522