From 504f3e9bc274bcd6c7221e738802e0e5d4aef36f Mon Sep 17 00:00:00 2001 From: lishihai <dslsh@dscom> Date: 星期四, 20 六月 2024 17:07:02 +0800 Subject: [PATCH] 查询属性值和对象 通过主键ID查询 --- models/attribute_value.go | 22 +++++++++++++++++++++- 1 files changed, 21 insertions(+), 1 deletions(-) diff --git a/models/attribute_value.go b/models/attribute_value.go index f6bca8b..960685d 100644 --- a/models/attribute_value.go +++ b/models/attribute_value.go @@ -51,13 +51,33 @@ slf.ID = id return slf } - +func (slf *AttributeValueSearch) SetEntityID(entityId string) *AttributeValueSearch { + slf.EntityID = entityId + return slf +} +func (slf *AttributeValueSearch) SetAttributeID(attributeId uint) *AttributeValueSearch { + slf.AttributeID = attributeId + return slf +} +func (slf *AttributeValueSearch) SetValue(value string) *AttributeValueSearch { + slf.Value = value + return slf +} func (slf *AttributeValueSearch) build() *gorm.DB { var db = slf.Orm.Table(slf.TableName()) if slf.ID != 0 { db = db.Where("id = ?", slf.ID) } + if slf.EntityID != "" { + db = db.Where("entity_id = ?", slf.EntityID) + } + if slf.AttributeID != 0 { + db = db.Where("attribute_id = ?", slf.AttributeID) + } + if slf.Value != "" { + db = db.Where("value like ?", "%"+slf.Value+"%") + } if slf.Order != "" { db = db.Order(slf.Order) -- Gitblit v1.8.0