From 1123e3f0584fb402300499aee42d45e2150138cc Mon Sep 17 00:00:00 2001 From: liujiandao <274878379@qq.com> Date: 星期一, 01 四月 2024 16:01:04 +0800 Subject: [PATCH] aps查询工单入库信息 --- models/operation.go | 37 ++++++++++++++++++++++++++++--------- 1 files changed, 28 insertions(+), 9 deletions(-) diff --git a/models/operation.go b/models/operation.go index 1296457..bd56ea2 100644 --- a/models/operation.go +++ b/models/operation.go @@ -53,15 +53,16 @@ OperationSearch struct { Operation - Order string - PageNum int - PageSize int - Keyword string - Orm *gorm.DB - Preload bool - Disuse bool - Ids []int - Numbers []string + Order string + PageNum int + PageSize int + Keyword string + Orm *gorm.DB + Preload bool + Disuse bool + Ids []int + SourceNumbers []string + SalesDetailsNumbers []string } ) @@ -118,6 +119,11 @@ return slf } +func (slf *OperationSearch) SetSourceNumbers(numbers []string) *OperationSearch { + slf.SourceNumbers = numbers + return slf +} + func (slf *OperationSearch) SetDisuse(disuse bool) *OperationSearch { slf.Disuse = disuse return slf @@ -143,6 +149,11 @@ return slf } +func (slf *OperationSearch) SetSalesDetailsNumbers(salesDetailsNumbers []string) *OperationSearch { + slf.SalesDetailsNumbers = salesDetailsNumbers + return slf +} + func (slf *OperationSearch) SetOperationSource(operationSource constvar.OperationSource) *OperationSearch { slf.OperationSource = operationSource return slf @@ -164,6 +175,10 @@ if slf.SourceNumber != "" { db = db.Where("source_number = ?", slf.SourceNumber) + } + + if len(slf.SourceNumbers) > 0 { + db = db.Where("source_number in (?)", slf.SourceNumbers) } if slf.Number != "" { @@ -198,6 +213,10 @@ db = db.Where("sales_details_number = ?", slf.SalesDetailsNumber) } + if len(slf.SalesDetailsNumbers) > 0 { + db = db.Where("sales_details_number in (?)", slf.SalesDetailsNumbers) + } + if slf.OperationSource != 0 { db = db.Where("operation_source = ?", slf.OperationSource) } -- Gitblit v1.8.0