From 2b4ed611e7e001ad8ea93ef3e8cdce35bc56dc07 Mon Sep 17 00:00:00 2001 From: George Halkiadakis Date: Mon, 1 May 2023 04:33:06 +0300 Subject: form designer; setup main forms of the application --- public/app/models/Access_model.php | 28 +--------------------------- 1 file changed, 1 insertion(+), 27 deletions(-) (limited to 'public/app/models/Access_model.php') diff --git a/public/app/models/Access_model.php b/public/app/models/Access_model.php index d5ae19e..8d446dc 100644 --- a/public/app/models/Access_model.php +++ b/public/app/models/Access_model.php @@ -56,33 +56,7 @@ class Access_model FROM user_role WHERE user_role.user_id = :id ) - ) AS Roles_json, - ( -- construct array of (root-)privileges granted to user - SELECT CONCAT( - '[', - GROUP_CONCAT(privilege.id), - ']' - ) - FROM privilege - WHERE privilege.id IN ( - SELECT user_privilege.privilege_id - FROM user_privilege - WHERE user_privilege.user_id = :id - ) - ) AS RootPrivileges_json, - ( -- construct array of (root-)privileges granted to user - SELECT CONCAT( - '[', - GROUP_CONCAT(privilege.includes), - ']' - ) - FROM privilege - WHERE privilege.id IN ( - SELECT user_privilege.privilege_id - FROM user_privilege - WHERE user_privilege.user_id = :id - ) - ) AS SubPrivileges_json + ) AS Roles_json FROM user WHERE id = :id", [ ':id' => $id ] -- cgit v1.2.3