['work_sn', 'service_work_id', 'master_worker_id', 'issue_approval', 'complaint_status', 'responsible', 'complaint_details', 'finished_time', 'approval_admin_id', 'approval_time', 'create_time', 'update_time'], ]; } public function querySearch(): array { $where['issue_approval'] = ['<>',0]; $where['master_worker_id'] = ['=',$this->userId]; return $where; } /** * @notes 获取列表 * @return array * @throws \think\db\exception\DataNotFoundException * @throws \think\db\exception\DbException * @throws \think\db\exception\ModelNotFoundException * @author whitef * @date 2024/07/10 15:06 */ public function lists(): array { return IssueWork::where($this->searchWhere) ->where($this->querySearch()) ->field(['id', 'work_sn', 'service_work_id', 'issue_approval', 'complaint_status', 'responsible', 'complaint_details', 'complaint_images', 'finished_time', 'create_time', 'update_time']) ->limit($this->limitOffset, $this->limitLength) ->order(['id' => 'desc']) ->select() ->toArray(); } /** * @notes 获取数量 * @return int * @author whitef * @date 2024/07/10 15:06 */ public function count(): int { return IssueWork::where($this->searchWhere)->where($this->querySearch())->count(); } }