Potievdev\SlimRbac\Models\Repository\RolePermissionRepository

Complexity

Total Complexity

2

Size/Duplication

Total Lines	39
Duplicated Lines	0 %

Importance

Changes

0

2 Methods

Rating	Name	Duplication	Size	Complexity
A	isPermissionAssigned()	0	17	1
A	getRoleIdsByPermission()	0	8	1

<?php

namespace Potievdev\SlimRbac\Models\Repository;

use Doctrine\ORM\EntityRepository;
use Potievdev\SlimRbac\Models\Entity\Permission;

/**
 * RolePermissionRepository
 *
 * This class was generated by the Doctrine ORM. Add your own custom
 * repository methods below.
 */
class RolePermissionRepository extends EntityRepository
{
    /**
     * @param Permission $permission
     * @return array
     */
    public function getRoleIdsByPermission(Permission $permission)
    {
        $qb = $this->createQueryBuilder('rolePermission');

        $qb->select('rolePermission.roleId')
            ->where($qb->expr()->eq('rolePermission.permissionId', $permission->getId()));

        return $qb->getQuery()->getArrayResult();
    }

    /**
     * Search RolePermission record. If found return true else false
     * @param integer $permissionId
     * @param integer[] $roleIds
     * @return bool
     */
    public function isPermissionAssigned(int $permissionId, array $roleIds): bool
    {
        $qb = $this->createQueryBuilder('rolePermission');

        $result = $qb
            ->select('rolePermission.id')
            ->where(
                $qb->expr()->andX(
                    $qb->expr()->eq('rolePermission.permissionId', $permissionId),
                    $qb->expr()->in('rolePermission.roleId', $roleIds)
                )
            )
            ->setMaxResults(1)
            ->getQuery()
            ->getArrayResult();

        return count($result) > 0;
    }
}