From 91afffaa4f3eb9104d39044197e4140c2044a78c Mon Sep 17 00:00:00 2001 From: jiangshuai <291802688@qq.com> Date: 星期二, 21 十一月 2023 15:33:17 +0800 Subject: [PATCH] 合同管理列表修改筛选条件 --- model/contract.go | 15 ++++++++++++++- 1 files changed, 14 insertions(+), 1 deletions(-) diff --git a/model/contract.go b/model/contract.go index e437c6c..430e5c0 100644 --- a/model/contract.go +++ b/model/contract.go @@ -28,7 +28,7 @@ ContractSearch struct { Contract - + Keyword string Orm *gorm.DB SearchMap map[string]interface{} OrderBy string @@ -47,6 +47,11 @@ } } +func (slf *ContractSearch) SetKeyword(keyword string) *ContractSearch { + slf.Keyword = keyword + return slf +} + func (slf *ContractSearch) build() *gorm.DB { var db = slf.Orm.Model(&Contract{}) @@ -55,6 +60,10 @@ } if slf.Number != "" { db = db.Where("number = ?", slf.Number) + } + + if slf.Keyword != "" { + db = db.Joins("Client").Where("contract_name like ? or number like ? or Client.name like ?", fmt.Sprintf("%%%v%%", slf.Keyword), fmt.Sprintf("%%%v%%", slf.Keyword), fmt.Sprintf("%%%v%%", slf.Keyword)) } if len(slf.SearchMap) > 0 { @@ -76,6 +85,10 @@ if key == "created_at" { db = db.Where(key+"= ?", v) } + + if key == "contract_name" { + db = db.Where("contract_name=?", "%"+v+"%") + } case int: if key == "member_id" { db = db.Where(key+"= ?", v) -- Gitblit v1.8.0