1) { $model = $model->where('first_user_id|second_user_id|third_user_id', '=', $user_id); } if ($is_settled > -1) { $model = $model->where('is_settled', '=', $is_settled); } // 获取分销商订单列表 $data = $model->with([ 'agent_first', 'agent_second', 'agent_third' ]) ->order(['create_time' => 'desc']) ->paginate(15); if ($data->isEmpty()) { return $data; } // 获取订单的主信息 $with = ['product' => ['image', 'refund'], 'address', 'user']; return OrderService::getOrderList($data, 'order_master', $with); } /** * 订单导出 */ public function exportList($user_id = null, $is_settled = -1) { $model = $this; // 检索查询条件 if ($user_id > 1) { $model = $model->where('first_user_id|second_user_id|third_user_id', '=', $user_id); } if ($is_settled > -1) { $model = $model->where('is_settled', '=', $is_settled); } // 获取分销商订单列表 $data = $model->with([ 'agent_first', 'agent_second', 'agent_third' ]) ->order(['create_time' => 'desc']) ->select(); if ($data->isEmpty()) { return $data; } // 获取订单的主信息 $with = ['product' => ['image', 'refund'], 'address', 'user']; $list = OrderService::getOrderList($data, 'order_master', $with); // 导出excel文件 (new Exportservice)->agentOrderList($list); } }