[permission-manager] first fill of location table

1 files changed, 26 insertions, 0 deletions

diff --git a/modules-available/permissionmanager/inc/getdata.inc.php b/modules-available/permissionmanager/inc/getdata.inc.php
index 7ca56754..caa50215 100644
--- a/modules-available/permissionmanager/inc/getdata.inc.php
+++ b/modules-available/permissionmanager/inc/getdata.inc.php
@@ -16,6 +16,20 @@ class GetData {
 		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");
@@ -68,4 +82,16 @@ class GetData {
 		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 roleXlocation ON location.locationid = roleXlocation.locid
+													LEFT JOIN role ON roleXlocation.roleid = role.id
+												GROUP BY location.locationid
+												ORDER BY location.locationname
+												");
+		return $res;
+	}
+
 }
\ No newline at end of file