diff options
| author | George Halkiadakis <gchalkiadakis@sklavenitis.co.gr> | 2023-05-01 04:33:06 +0300 |
|---|---|---|
| committer | George Halkiadakis <gchalkiadakis@sklavenitis.co.gr> | 2023-05-01 04:33:06 +0300 |
| commit | 2b4ed611e7e001ad8ea93ef3e8cdce35bc56dc07 (patch) | |
| tree | 0da2582de2cef450f6366a9cff28e47353eddb2e /public/app/models/Access_model.php | |
| parent | 77b3a3ebf23598b82d035ead6df43b2c2ca885f4 (diff) | |
| download | gyraf1gov-2b4ed611e7e001ad8ea93ef3e8cdce35bc56dc07.tar.gz gyraf1gov-2b4ed611e7e001ad8ea93ef3e8cdce35bc56dc07.tar.bz2 gyraf1gov-2b4ed611e7e001ad8ea93ef3e8cdce35bc56dc07.zip | |
form designer; setup main forms of the application
Diffstat (limited to 'public/app/models/Access_model.php')
| -rw-r--r-- | public/app/models/Access_model.php | 28 |
1 files changed, 1 insertions, 27 deletions
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 ] |