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 | 28 ++++++++++++++++++++++++----
1 files changed, 24 insertions(+), 4 deletions(-)
diff --git a/models/attribute_value.go b/models/attribute_value.go
index 3b8ad53..960685d 100644
--- a/models/attribute_value.go
+++ b/models/attribute_value.go
@@ -10,9 +10,9 @@
// AttributeValue 灞炴�у�煎拰瀵硅薄
AttributeValue struct {
gorm.Model
- EntityID string `gorm:"primaryKey"`
- AttributeID uint `gorm:"primaryKey"`
- Value string `json:"value"`
+ EntityID string `gorm:"uniqueIndex:entity_id_attr_id;type:varchar(100);not null;default:''" json:"entityID"`
+ AttributeID uint `gorm:"uniqueIndex:entity_id_attr_id;type:int;not null;default:0" json:"attributeID"`
+ Value string `gorm:"type:varchar(255);not null;default:''" json:"value"`
}
AttributeValueSearch struct {
@@ -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