where($query->getTable() . '.shop_supplier_id', -1); }else{ $query->where($query->getTable() . '.shop_supplier_id', 'in', $shop_supplier_ids); } } /** * 获取列表数据 */ public function getList($store_id = 0, $search = '', $params) { $model = $this; if ($store_id > 0) { $model = $model->where('clerk.store_id', '=', (int)$store_id); } if (!empty($search)) { $model = $model->where('clerk.real_name', 'like', '%' . $search . '%'); } if(isset($params['shop_supplier_ids'])&&$params['shop_supplier_ids']){ $model = $model->where('order.shop_supplier_id', 'in', $params['shop_supplier_ids']); } // 查询列表数据 $data = $model->with(['store', 'clerk', 'supplier']) ->alias('order') ->field(['order.*']) ->join('store_clerk clerk', 'clerk.clerk_id = order.clerk_id', 'INNER') ->order(['order.create_time' => 'desc']) ->paginate($params); if ($data->isEmpty()) { return $data; } // 整理订单信息 return OrderService::getOrderList($data); } }