From 86530fe51ee65aea39e07e8fa131bf6e3310c4b0 Mon Sep 17 00:00:00 2001 From: lishihai <dslsh@dscom> Date: 星期五, 14 六月 2024 17:04:13 +0800 Subject: [PATCH] 属性值和对象-AttributeValue-wms_attribute_value-的ID查询和LIST分页查询 --- 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