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 +--------------------------- public/app/models/_info.md | 15 +++++++++++++++ 2 files changed, 16 insertions(+), 27 deletions(-) (limited to 'public/app/models') 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 + + + -- cgit v1.2.3