bluzphp / skeleton

     * @param integer $roleId

     * @return array

     */

    public function getRolePrivileges($roleId)

    {

        $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)",

                array((int) $roleId)

            );

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

        }

        return $data;

    }

}

     * @param integer $userId

     * @return array of identity

     */

    public function getUserRolesIdentity($userId)

    {

        $cacheKey = 'users.roles.'.$userId;

        if (!$data = Cache::get($cacheKey)) {

            $data = Db::fetchColumn(

                "SELECT r.id

                FROM acl_roles AS r, acl_users_roles AS u2r

                WHERE r.id = u2r.roleId AND u2r.userId = ?

                ORDER BY r.id ASC",

                array($userId)

            );

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

        }

        return $data;

    }

}