Changes between Version 1 and Version 2 of AdvancedReports

Timestamp:

09/21/25 21:11:10 (3 months ago)

Author:

225144

Comment:

--

AdvancedReports

@@ -74 +74 @@
 }}} 
 
+== Проверка дали даден корисник поседува дадена пермисија за даден ресурс
+
+
+{{{
+SELECT COALESCE(
+                  EXISTS (SELECT 1
+                          FROM users_project_roles upr
+                                   JOIN project_role pr
+                               ON upr.role_id = pr.id
+                                   JOIN role_permissions rp
+                                    ON pr.id = rp.role_id
+                                   LEFT JOIN role_permissions_overrides rpo
+                                             ON pr.id = rpo.role_id
+                                                 AND rpo.permission_name = rp.permission_name
+                                                 AND rpo.project_resource_id = :resourceId
+   
+                          WHERE upr.user_id = :userId
+                            AND pr.project_id = :projectId
+                            AND rp.permission_name = :permissionName
+                            AND (
+                              (pr.override_type = 'INCLUDE' AND rpo.project_resource_id IS NOT NULL)
+                                  OR (pr.override_type = 'EXCLUDE' AND rpo.project_resource_id IS NULL)
+                              )), FALSE
+          ) AS has_access;
+}}}
+
+
+