eta_api/models/image_conf.go

package models

import (
	"eta_gn/eta_api/global"
	"time"
)

type ImageConf struct {
	ImageConfId int       `gorm:"primaryKey;column:image_conf_id;type:int(10) unsigned;not null"`
	CreateTime  time.Time `gorm:"column:create_time" description:"消息时间"`
	ModifyTime  time.Time `gorm:"column:modify_time" description:"更新时间"`
	ImageName   string    `gorm:"column:image_name;type:varchar(64);not null;default:''" description:"图片名称"`
	Url         string    `gorm:"column:url;type:varchar(512);not null;default:''" description:"图片地址"`
	ConfType    int       `gorm:"column:conf_type;type:tinyint(4) unsigned;not null;default:1" description:"配置类型 1-ppt素材"`
	ImageType   int       `gorm:"column:image_type;type:tinyint(4) unsigned;not null;default:1" description:"图片类型 1-封面图 2-背景图 3-封底图"`
}

// BatchAddImageMaterials 新增图片素材
func BatchAddImageMaterials(items []*ImageConf, batchSize int) (err error) {
	err = global.DmSQL["rddp"].CreateInBatches(items, batchSize).Error
	return
}

// GetImageConfByName 根据图片名称查询
func GetImageConfByName(imageName string) (item *ImageConf, err error) {
	item = &ImageConf{}
	err = global.DmSQL["rddp"].Where("image_name = ?", imageName).First(item).Error
	return
}

// GetImageConfByCondition 根据条件查询图片素材
func GetImageConfByCondition(condition string, pars []interface{}) (list []*ImageConf, err error) {
	err = global.DmSQL["rddp"].Where(condition, pars...).Find(&list).Error
	return
}