From d4bf53dd19a45ef09a367babcf7a2ac04ae1d08f Mon Sep 17 00:00:00 2001 From: liujiandao <274878379@qq.com> Date: 星期二, 17 十月 2023 14:31:31 +0800 Subject: [PATCH] bug修改 --- model/serviceOrder.go | 37 ++++++++++++++++++++++++++++--------- 1 files changed, 28 insertions(+), 9 deletions(-) diff --git a/model/serviceOrder.go b/model/serviceOrder.go index 95cfbb0..f593b5c 100644 --- a/model/serviceOrder.go +++ b/model/serviceOrder.go @@ -61,13 +61,15 @@ // ServiceOrderSearch 鏈嶅姟鍗曟悳绱㈡潯浠� ServiceOrderSearch struct { ServiceOrder - Orm *gorm.DB - QueryClass constvar.ServiceOrderQueryClass - KeywordType constvar.ServiceOrderKeywordType - Keyword string - PageNum int - PageSize int - Preload bool + Orm *gorm.DB + QueryClass constvar.ServiceOrderQueryClass + KeywordType constvar.ServiceOrderKeywordType + Keyword string + PageNum int + PageSize int + Preload bool + ServiceManIds []int + Order string } ) @@ -87,10 +89,13 @@ db = db.Where("id = ?", slf.Id) } if slf.ServiceContractId != 0 { - db = db.Where("service_contract_id = ?", slf.ServiceContractId) + db = db.Where("contract_id = ?", slf.ServiceContractId) } if slf.SalesDetailsId != 0 { - db = db.Where("sales_details_id = ?", slf.SalesDetailsId) + db = db.Where("order_id = ?", slf.SalesDetailsId) + } + if slf.Order != "" { + db = db.Order(slf.Order) } if slf.Preload { db = db. @@ -124,6 +129,10 @@ db = db.Joins("ServiceType", clause.LeftJoin).Where("ServiceType.name like ?", fmt.Sprintf("%%%s%%", slf.Keyword)) case constvar.ServiceOrderKeywordFaultType: db = db.Joins("FaultType", clause.LeftJoin).Where("FaultType.name like ?", fmt.Sprintf("%%%s%%", slf.Keyword)) + } + + if len(slf.ServiceManIds) > 0 { + db = db.Where("service_man_id in ?", slf.ServiceManIds) } return db @@ -192,11 +201,21 @@ return slf } +func (slf *ServiceOrderSearch) SetMemberIds(memberIds []int) *ServiceOrderSearch { + slf.ServiceManIds = memberIds + return slf +} + func (slf *ServiceOrderSearch) SetPreload(preload bool) *ServiceOrderSearch { slf.Preload = preload return slf } +func (slf *ServiceOrderSearch) SetOrder(order string) *ServiceOrderSearch { + slf.Order = order + return slf +} + func (slf *ServiceOrderSearch) First() (*ServiceOrder, error) { var db = slf.build() var record = new(ServiceOrder) -- Gitblit v1.8.0