diff options
Diffstat (limited to 'public/app/models')
| -rw-r--r-- | public/app/models/Access_model.php | 28 | ||||
| -rw-r--r-- | public/app/models/_info.md | 15 |
2 files changed, 16 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 ] diff --git a/public/app/models/_info.md b/public/app/models/_info.md index 0c19c02..401c13c 100644 --- a/public/app/models/_info.md +++ b/public/app/models/_info.md @@ -112,3 +112,18 @@ record_id media_id +USER menu +--- +profile -> name, hello, last-login, do ... +profile/information +profile/requests (all) +profile/request/id (one) + +Admin menu +--- +admin -> requests (all), MODAL: protocol +admin/request/id -> request (one) +admin/iinvite + + + |