['worker_id', 'real_name', 'id_card', 'mobile', 'address', 'audit_state', '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/10/07 18:58 */ public function lists(): array { return MasterWorkerInfo::where($this->searchWhere)->where($this->queryWhere()) ->field(['id', 'worker_id', 'real_name', 'id_card', 'id_card_front_img', 'id_card_opposite_img', 'mobile', 'address', 'audit_state', 'create_time','update_time']) ->limit($this->limitOffset, $this->limitLength) ->order(['id' => 'desc']) ->select() ->toArray(); } /** * @notes 获取数量 * @return int * @author likeadmin * @date 2024/10/07 18:58 */ public function count(): int { return MasterWorkerInfo::where($this->searchWhere)->where($this->queryWhere())->count(); } }