From d2c1d8192b60d6981f0a743ef9cab8e37496e6a3 Mon Sep 17 00:00:00 2001
From: wangpengfei <274878379@qq.com>
Date: 星期三, 09 八月 2023 10:03:41 +0800
Subject: [PATCH] fix
---
model/client.go | 13 +++++++++++++
1 files changed, 13 insertions(+), 0 deletions(-)
diff --git a/model/client.go b/model/client.go
index 11ceaa1..25c3935 100644
--- a/model/client.go
+++ b/model/client.go
@@ -22,6 +22,7 @@
ClientLevel ClientLevel `json:"client_level" gorm:"foreignKey:ClientLevelId"`
Contacts []Contact `json:"contacts" gorm:"foreignKey:ClientId"`
MemberId int `json:"member_id" gorm:"column:member_id;type:int(11);comment:閿�鍞礋璐ｄ汉ID"`
+ Member User `json:"member" gorm:"foreignKey:MemberId"`
ServiceMemberId int `json:"service_member_id" gorm:"column:service_member_id;type:int(11);comment:鏈嶅姟璐熻矗浜篒D"`
DetailAddress string `json:"detail_address" gorm:"column:detail_address;type:varchar(255);comment:璇︾粏鍦板潃"`
Remark string `json:"remark" gorm:"column:remark;type:varchar(255);comment:澶囨敞"`
@@ -97,6 +98,18 @@
db = db.Where("member_id = ?", constvar.UserTypeSuper)
}
+ if key == "client_status" {
+ db = db.Joins("ClientStatus").Where("ClientStatus.name LIKE ?", "%"+v+"%")
+ }
+
+ if key == "client_level" {
+ db = db.Joins("ClientLevel").Where("ClientLevel.name LIKE ?", "%"+v+"%")
+ }
+
+ if key == "member_name" {
+ db = db.Joins("Member").Where("Member.username LIKE ?", "%"+v+"%")
+ }
+
case int:
if key == "id" || key == "client_type_id" || key == "client_status_id" || key == "member_id" {
db = db.Where(key+" = ?", v)
--
Gitblit v1.8.0