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