[permission-manager] renamed some files, moved html generation to templates,

using bind variables in mysql code, changed order of modules in role editor

1 files changed, 97 insertions, 0 deletions

diff --git a/modules-available/permissionmanager/inc/getpermissiondata.inc.php b/modules-available/permissionmanager/inc/getpermissiondata.inc.php
new file mode 100644
index 00000000..be7ddb1c
--- /dev/null
+++ b/modules-available/permissionmanager/inc/getpermissiondata.inc.php
@@ -0,0 +1,97 @@
+<?php
+
+class GetPermissionData {
+
+	// get UserIDs, User Login Names, User Roles
+	public static function getUserData() {
+		$res = self::queryUserData();
+		$data = array();
+		while ($row = $res->fetch(PDO::FETCH_ASSOC)) {
+			$data[] = array(
+				'userid' => $row['userid'],
+				'name' => $row['login'],
+				'role' => explode(",",$row['role'])
+			);
+		}
+		return $data;
+	}
+
+	// get LocationIDs, Location Names, Roles of each Location
+	public static function getLocationData() {
+		$res = self::queryLocationData();
+		$data = array();
+		while ($row = $res->fetch(PDO::FETCH_ASSOC)) {
+			$data[] = array(
+				'locid' => $row['locid'],
+				'name' => $row['locname'],
+				'role' => explode(",",$row['role'])
+			);
+		}
+		return $data;
+	}
+
+	// get all roles from database (id and name)
+	public static function getRoles() {
+		$res = Database::simpleQuery("SELECT id, name FROM role ORDER BY name ASC");
+		$data = array();
+		while ($row = $res->fetch(PDO::FETCH_ASSOC)) {
+			$data[] = array(
+				'roleId' => $row['id'],
+				'roleName' => $row['name']
+			);
+		}
+		return $data;
+	}
+
+	public static function getLocations($selected) {
+		$res = Database::simplequery("SELECT locationid, locationname FROM location");
+		$data = array();
+		while ($row = $res->fetch(PDO::FETCH_ASSOC)) {
+			$data[] = array('locid' => $row['locationid'], 'locName' => $row['locationname'],
+				'selected' => in_array($row['locationid'], $selected) ? "selected" : "");
+		}
+		return $data;
+	}
+
+	public static function getRoleData($roleId) {
+		$query = "SELECT id, name FROM role WHERE id = :roleId";
+		$data = Database::queryFirst($query, array("roleId" => $roleId));
+		$query = "SELECT roleid, locid FROM role_x_location WHERE roleid = :roleId";
+		$res = Database::simpleQuery($query, array("roleId" => $roleId));
+		$data["locations"] = array();
+		while ($row = $res->fetch(PDO::FETCH_ASSOC)) {
+			$data["locations"][] = $row['locid'];
+		}
+		$query = "SELECT roleid, permissionid FROM role_x_permission WHERE roleid = :roleId";
+		$res = Database::simpleQuery($query, array("roleId" => $roleId));
+		$data["permissions"] = array();
+		while ($row = $res->fetch(PDO::FETCH_ASSOC)) {
+			$data["permissions"][] = $row['permissionid'];
+		}
+		return $data;
+	}
+
+	// UserID, User Login Name, Roles of each User
+	private static function queryUserData() {
+		$res = Database::simpleQuery("SELECT user.userid AS userid, user.login AS login, GROUP_CONCAT(role.name ORDER BY role.name ASC) AS role
+												FROM user
+													LEFT JOIN user_x_role ON user.userid = user_x_role.userid
+													LEFT JOIN role ON user_x_role.roleid = role.id
+												GROUP BY user.userid
+												");
+		return $res;
+	}
+
+	// LocationID, Location Name, Roles of each Location
+	private static function queryLocationData() {
+		$res = Database::simpleQuery("SELECT location.locationid AS locid, location.locationname AS locname, GROUP_CONCAT(role.name ORDER BY role.name ASC) AS role
+												FROM location
+													LEFT JOIN role_x_location ON location.locationid = role_x_location.locid
+													LEFT JOIN role ON role_x_location.roleid = role.id
+												GROUP BY location.locationid
+												ORDER BY location.locationname
+												");
+		return $res;
+	}
+
+}
\ No newline at end of file