['master_worker_id', 'submit_admin_id', 'examine_admin_id', 'voucher_status', 'notice_rule'], ]; } public function queryWhere(){ $where = []; if (isset($this->params['mobile_account']) && !empty($this->params['mobile_account'])) { $mw_ids = MasterWorker::where('mobile|account','like', '%' . $this->params['mobile_account'] . '%')->column('id'); $where[] = [ 'master_worker_id','in',$mw_ids?:[0]]; } return $where; } /** * @notes 获取列表 * @return array * @throws \think\db\exception\DataNotFoundException * @throws \think\db\exception\DbException * @throws \think\db\exception\ModelNotFoundException * @author likeadmin * @date 2024/12/06 10:42 */ public function lists(): array { return MasterWorkerCommissionConfig::with(['masterWorker','examineAdmin'])->where($this->searchWhere)->where($this->queryWhere()) ->field(['id', 'master_worker_id', 'submit_admin_id', 'examine_admin_id', 'voucher_status', 'notice_rule','block_data']) ->limit($this->limitOffset, $this->limitLength) ->order(['id' => 'desc']) ->select() ->toArray(); } /** * @notes 获取数量 * @return int * @author likeadmin * @date 2024/12/06 10:42 */ public function count(): int { return MasterWorkerCommissionConfig::where($this->searchWhere)->count(); } }