backend-api/app/extra/dao/system/SystemRoleDao.php

<?php

namespace app\extra\dao\system;

use app\extra\basic\Dao;
use app\model\system\SystemRole;

class SystemRoleDao extends Dao
{
    /**
     * 设置模型
     * @return string
     */
    protected function setModel(): string
    {
        return SystemRole::class;
    }

    public function getList(array $where,string $field = '*',int $page = 0, int $limit = 0,string $order='id desc')
    {
        return $this->getModel()->where($where)->field($field)->when($page&&$limit,function($query)use($page,$limit){
            $query->page($page,$limit);
        })->select();
    }

    /**
     * 获取权限id
     * @param array $rules
     * @return array
     */
    public function getRoleIds(array $rules)
    {
        $rules = $this->dao->getColumn([['id', 'IN', $rules], ['status', '=', '1']], 'rules', 'id');
        return array_unique(explode(',', implode(',', $rules)));
    }

}