linpax / microphp-framework

     * @return array

     * @throws \Micro\Base\Exception

     */

    protected function rolePerms($role)

    {

        $query = new Query($this->db);

        $query->select = '*';

        $query->table = 'acl_role_perm';

        $query->addWhere('role='.$role);

        $query->single = false;

        return $query->run();

    }

    /**

     * Assign role permission

     * @return mixed

     * @throws \Micro\Base\Exception

     */

    public function assigned($userId)

    {

        $query = new Query($this->db);

        $query->select = '*';

        $query->table = 'acl_user';

        $query->addWhere('`user`='.$userId);

        $query->single = false;

        return $query->run();

    }

    /**

     * Get permissions in role

     * @return mixed

     * @throws \Micro\Base\Exception

     */

    public function assigned($userId)

    {

        $query = new Query($this->db);

        $query->distinct = true;

        $query->select = '`role` AS `name`';

        $query->table = '`rbac_user`';

        $query->addWhere('`user`='.$userId);

        $query->single = false;

        return $query->run(\PDO::FETCH_ASSOC);

    }

    /**

     * Recursive search in roles array

     * @return mixed

     * @throws \Micro\Base\Exception

     */

    public function rawRoles($pdo = \PDO::FETCH_ASSOC)

    {

        $query = new Query($this->db);

        $query->table = 'rbac_role';

        $query->order = '`type` ASC';

        $query->single = false;

        return $query->run($pdo);

    }

    /**

     * Recursive delete roles from array