From 86530fe51ee65aea39e07e8fa131bf6e3310c4b0 Mon Sep 17 00:00:00 2001 From: lishihai <dslsh@dscom> Date: 星期五, 14 六月 2024 17:04:13 +0800 Subject: [PATCH] 属性值和对象-AttributeValue-wms_attribute_value-的ID查询和LIST分页查询 --- controllers/operation.go | 6 ++++++ 1 files changed, 6 insertions(+), 0 deletions(-) diff --git a/controllers/operation.go b/controllers/operation.go index a163cc6..8193fa9 100644 --- a/controllers/operation.go +++ b/controllers/operation.go @@ -1289,6 +1289,12 @@ if params.Condition != "" { db = db.Where("wms_operation.number like ? or wms_operation.source_number like ? or from_location.`name` like ? or to_location.`name` like ? or material.`name` like ? ", "%"+params.Condition+"%", "%"+params.Condition+"%", "%"+params.Condition+"%", "%"+params.Condition+"%", "%"+params.Condition+"%") } + if params.WarehouseId != 0 { + db = db.Where("warehouse_id = ?", params.WarehouseId) + } + if params.LocationId != 0 { + db = db.Where("location_id = ?", params.LocationId) + } var ( records = make([]*response.InventoryHistory, 0) total int64 -- Gitblit v1.8.0