['agree_type', 'worker_id', 'sign', 'audit_state', 'pdf_url', 'create_time'], ]; } public function queryWhere(){ $where = []; if(isset($this->params['range_update_time']) && !empty($this->params['range_update_time'])){ $time = [strtotime($this->params['range_update_time'][0]), strtotime($this->params['range_update_time'][1])]; $where[] = ['update_time', 'between', $time]; } return $where; } /** * @notes 获取列表 * @return array * @throws \think\db\exception\DataNotFoundException * @throws \think\db\exception\DbException * @throws \think\db\exception\ModelNotFoundException * @author likeadmin * @date 2024/07/17 15:20 */ public function lists(): array { return MasterWorkerAgree::with(['masterWorkerInfo'])->where($this->searchWhere)->where($this->queryWhere()) ->field(['id', 'agree_type', 'worker_id', 'sign', 'pdf_url', 'create_time', 'audit_state','update_time']) ->limit($this->limitOffset, $this->limitLength) ->order(['id' => 'desc']) ->select() ->toArray(); } /** * @notes 获取数量 * @return int * @author likeadmin * @date 2024/07/17 15:20 */ public function count(): int { return MasterWorkerAgree::where($this->searchWhere)->where($this->queryWhere())->count(); } }