['user_id', 'order_number', 'order_status', 'transaction_id', 'pay_status', 'consultation_id', 'work_id'], '%like%' => ['mobile', 'remark'], ]; } public function queryWhere(): array { $where = []; if(isset($this->params['refund_pay_status']) && !empty($this->params['refund_pay_status'])){ $where[] = ['pay_status', 'in', [3,4,5,6]]; } /*if(isset($this->params['create_time_range']) && !empty($this->params['create_time_range'][0]) && !empty($this->params['create_time_range'][1])){ $time = [strtotime($this->params['create_time_range'][0]), strtotime($this->params['create_time_range'][1])+86400-1]; $where[] = ['create_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 2025/05/23 13:40 */ public function lists(): array { return DouyinOrder::with(['goods', 'serviceWork','douyinRefundOrder'])->where($this->searchWhere)->where($this->queryWhere()) ->field(['*']) ->append(['order_status_text','pay_status_text']) ->limit($this->limitOffset, $this->limitLength) ->order(['id' => 'desc']) ->select() ->toArray(); } /** * @notes 获取数量 * @return int * @author likeadmin * @date 2025/05/23 13:40 */ public function count(): int { return DouyinOrder::where($this->searchWhere)->where($this->queryWhere())->count(); } }