linpax / microphp-framework

     * @return mixed

     * @throws \Micro\Base\Exception

     */

    public function assigned($userId)

    {

        $query = new Query($this->container->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

     * @inheritdoc

     * @throws \Micro\Base\Exception

     */

    protected function getElement($name)

    {

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

        $query->table = $this->table;

        $query->addWhere('`name`=:name');

        $query->params = ['name' => $name];

        $query->limit = 1;

        $query->single = true;

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

    }

    /**

     * @inheritdoc