From 389dffb0b6218f05277b8755bb82b61b6a316528 Mon Sep 17 00:00:00 2001 From: zhangqian <zhangqian@123.com> Date: 星期四, 14 三月 2024 20:06:13 +0800 Subject: [PATCH] 按仓库返回销售明细单对应产品完成入库且可用数量 --- controllers/report_forms_controller.go | 4 ++-- 1 files changed, 2 insertions(+), 2 deletions(-) diff --git a/controllers/report_forms_controller.go b/controllers/report_forms_controller.go index a495b07..ced1c45 100644 --- a/controllers/report_forms_controller.go +++ b/controllers/report_forms_controller.go @@ -97,8 +97,8 @@ Where("wms_operation.base_operation_type in (?)", []constvar.BaseOperationType{constvar.BaseOperationTypeOutgoing, constvar.BaseOperationTypeInternal, constvar.BaseOperationTypeDisuse}). Where("wms_operation.status in (?)", []constvar.OperationStatus{constvar.OperationStatus_Ready, constvar.OperationStatus_Finish}) if len(locationIds) > 0 { - dbIn.Where("wms_operation.to_location_id in (?)", locationIds) - dbOut.Where("wms_operation.from_location_id in (?)", locationIds) + dbIn.Where("wms_operation_details.to_location_id in (?)", locationIds) + dbOut.Where("wms_operation_details.from_location_id in (?)", locationIds) } if len(productIds) > 0 { dbIn.Where("wms_operation_details.product_id in (?)", productIds) -- Gitblit v1.8.0