From c5a0eb549cba2cd358a2d0496c44f3a289f15d9c Mon Sep 17 00:00:00 2001 From: wangpengfei <274878379@qq.com> Date: 星期一, 28 八月 2023 14:22:06 +0800 Subject: [PATCH] fix --- model/client.go | 25 ++++++++++++++++--------- 1 files changed, 16 insertions(+), 9 deletions(-) diff --git a/model/client.go b/model/client.go index 3ecdfb6..fcd3023 100644 --- a/model/client.go +++ b/model/client.go @@ -13,13 +13,13 @@ Name string `json:"name" gorm:"column:name;uniqueIndex:name_isDeleted_idx;type:varchar(255);comment:瀹㈡埛鍚嶇О"` IsDeleted bool `json:"-" gorm:"column:is_deleted;uniqueIndex:name_isDeleted_idx;type:tinyint(1);comment:鏄惁鍒犻櫎"` Number string `json:"number" gorm:"column:number;type:varchar(255);comment:瀹㈡埛缂栧彿"` - ClientStatusId int `json:"client_status_id" gorm:"column:client_status_id;type:int(11);comment:瀹㈡埛鐘舵�両D"` + ClientStatusId int `json:"client_status_id" gorm:"column:client_status_id;type:int(11);default:1;comment:瀹㈡埛鐘舵�両D"` ClientStatus ClientStatus `json:"client_status" gorm:"foreignKey:ClientStatusId"` - ClientTypeId int `json:"client_type_id" gorm:"column:client_type_id;type:int(11);comment:瀹㈡埛绫诲瀷ID"` + ClientTypeId int `json:"client_type_id" gorm:"column:client_type_id;type:int(11);default:1;comment:瀹㈡埛绫诲瀷ID"` ClientType ClientType `json:"client_type" gorm:"foreignKey:ClientTypeId"` - ClientOriginId int `json:"client_origin_id" gorm:"column:client_origin_id;type:int(11);comment:瀹㈡埛鏉ユ簮ID"` + ClientOriginId int `json:"client_origin_id" gorm:"column:client_origin_id;type:int(11);default:1;comment:瀹㈡埛鏉ユ簮ID"` ClientOrigin ClientOrigin `json:"client_origin" gorm:"foreignKey:ClientOriginId"` - ClientLevelId int `json:"client_level_id" gorm:"column:client_level_id;type:int(11);comment:瀹㈡埛绛夌骇ID"` + ClientLevelId int `json:"client_level_id" gorm:"column:client_level_id;type:int(11);default:1;comment:瀹㈡埛绛夌骇ID"` 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:閿�鍞礋璐d汉ID"` @@ -74,7 +74,7 @@ for key, value := range slf.SearchMap { switch v := value.(type) { case string: - if key == "name" || key == "number" || key == "detail_address" || key == "remark" { + if key == "name" || key == "number" || key == "detail_address" || key == "remark" || key == "business_scope" || key == "registration_time" || key == "representative" { db = db.Where(key+" LIKE ?", "%"+v+"%") } @@ -112,14 +112,21 @@ db = db.Joins("Member").Where("Member.username LIKE ?", "%"+v+"%") } - if key == "legal_representative" || key == "registration_time" || key == "business_scope" { - db = db.Joins("Business").Where("Business."+key+" LIKE ?", "%"+v+"%") - } - case int: + case int64: + case float64: if key == "id" || key == "client_type_id" || key == "client_status_id" || key == "member_id" { db = db.Where(key+" = ?", v) } + + if key == "not_admin" { + if v == float64(constvar.NotAdminYes) { + db = db.Where("member_id != ?", constvar.UserTypeSuper) + } else { + db = db.Where("member_id = ?", constvar.UserTypeSuper) + } + } + } } } -- Gitblit v1.8.0