bluzphp / skeleton

application/models/Privileges/Table.php

<?php

/**
 * @copyright Bluz PHP Team
 * @link      https://github.com/bluzphp/skeleton
 */

declare(strict_types=1);

namespace Application\Privileges;

use Application\Roles;
use Bluz\Proxy\Cache;

The type Bluz\Proxy\Cache was not found. Maybe you did not declare it correctly or list all dependencies?

use Bluz\Proxy\Db;

The type Bluz\Proxy\Db was not found. Maybe you did not declare it correctly or list all dependencies?

/**
 * Table of Privileges
 *
 * @package  Application\Privileges
 *
 * @method   static Row|null findRow($primaryKey)
 * @see      \Bluz\Db\Table::findRow()
 * @method   static Row|null findRowWhere($whereList)
 * @see      \Bluz\Db\Table::findRowWhere()
 */
class Table extends \Bluz\Db\Table

The type Bluz\Db\Table was not found. Maybe you did not declare it correctly or list all dependencies?

{
    /**
     * Table
     *
     * @var string
     */
    protected $name = 'acl_privileges';

    /**
     * Primary key(s)
     *
     * @var array
     */
    protected $primary = ['roleId', 'module', 'privilege'];

    /**
     * Get all privileges
     *
     * @return Row[]
     */
    public function getPrivileges(): array
    {
        return self::fetch(
            'SELECT DISTINCT p.roleId, p.module, p.privilege
            FROM acl_privileges AS p
            ORDER BY module, privilege'
        );
    }

    /**
     * Get user privileges
     *
     * @param integer $userId
     *
     * @return array
     */
    public function getUserPrivileges($userId): array
    {
        $roles = Roles\Table::getInstance()->getUserRolesIdentity($userId);

        $stack = [[]];
        foreach ($roles as $roleId) {
            $stack[] = $this->getRolePrivileges($roleId);
        }
        $stack = array_merge(...$stack);

        // magic array_unique for multi array
        return array_unique($stack);

        // follow code is faster, but required record for every user in memcache
        // in other words, need more memory for decrease CPU load
        // for update
        /*
        $cacheKey = '|privileges|'.$userId;
        if (!$data = Cache::get($cacheKey)) {
            $data = Db::getDefaultAdapter()->fetchColumn(
                "SELECT DISTINCT r.id, CONCAT(p.module, ':', p.privilege)
                FROM acl_privileges AS p, acl_roles AS r, acl_users_roles AS u2r
                WHERE p.roleId = r.id AND r.id = u2r.roleId AND u2r.userId = ?
                ORDER BY module, privilege",
                [(int) $userId]
            );

            Cache::set($cacheKey, $data, Cache::TTL_NO_EXPIRY);
        }
        return $data;
        */
    }

    /**
     * Get user privileges
     *
     * @param integer $roleId
     *
     * @return array
     */
    public function getRolePrivileges($roleId): array
    {
        $cacheKey = 'roles.privileges.' . $roleId;

        if (!$data = Cache::get($cacheKey)) {
            $data = Db::fetchColumn(
                "SELECT DISTINCT CONCAT(p.module, ':', p.privilege)
                FROM acl_privileges AS p, acl_roles AS r
                WHERE p.roleId = r.id AND r.id = ?
                ORDER BY CONCAT(p.module, ':', p.privilege)",
                [(int)$roleId]
            );

            Cache::set($cacheKey, $data, Cache::TTL_NO_EXPIRY, ['system', 'roles', 'privileges']);
        }
        return $data;
    }
}