From c9b52c35041b3838e4fef7a2052b7d798ec00883 Mon Sep 17 00:00:00 2001
From: zhangqian <zhangqian@123.com>
Date: 星期五, 14 六月 2024 10:43:19 +0800
Subject: [PATCH] 操作明细查询支持位置和仓库过滤
---
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