PerfectApp\RBAC\PermissionsRepository::userRoleHasPermission()

Complexity

Conditions	2
Paths	2

Size

Total Lines	17
Code Lines	7

Duplication

Lines	0
Ratio	0 %

Code Coverage

Tests	10
CRAP Score	2

Importance

Changes

0

<?php
    public function userRoleHasPermission(int $userId, string $requiredPermission): bool
    {
        $sql = "SELECT COUNT(*) AS count
                FROM user_roles ur
                INNER JOIN role_permissions rp ON ur.role_id = rp.role_id
                INNER JOIN permissions p ON rp.permission_id = p.permission_id
                WHERE ur.user_id = :userId AND p.permission_name = :requiredPermission";

        $stmt = $this->pdo->prepare($sql);
        $stmt->execute([
            'userId' => $userId,
            'requiredPermission' => $requiredPermission
        ]);

        /** @var array<string, mixed>|false $result */
        $result = $stmt->fetch(PDO::FETCH_ASSOC);
        return $result !== false && $result['count'] > 0;
    }