| 12345678910111213141516171819202122232425262728293031323334353637383940 |
- package dao
- import (
- "time"
- )
- type Library struct {
- ID int `gorm:"primary_key" json:"id"` //编号
- MaterialAddress string `gorm:"type:varchar(10000)" json:"materialAddress"` //素材地址
- LibName string `gorm:"type:varchar(64)" json:"libName"` //素材名称
- LibExplain string `gorm:"type:varchar(255)" json:"libExplain"` //素材说明
- LibType int `gorm:"type:int" json:"libType"` //素材类型：1-视频,2-图片,3-文字,4-音频
- Resolution string `gorm:"type:varchar(64)" json:"resolution"` //分辨率
- FileSize int64 `gorm:"type:bigint" json:"fileSize"` //文件大小
- LibDuration int `gorm:"type:int;default 0" json:"libDuration"` //获取视频时长
- FileId string `gorm:"type:varchar(255)" json:"fileId"` //文件ID，系统类型为广播系统时使用
- TalkSpeed int `gorm:"type:int;default 0" json:"talkSpeed"` //语速(用于文字广播)：0-正常,1-快一些,2-很快
- TenantId int `gorm:"type:int" json:"tenantId"` //租户ID
- CreateTime time.Time `gorm:"type:datetime" json:"createTime"` //新增时间
- CreateUser int64 `gorm:"type:bigint" json:"createUser"` //新增记录操作用户ID
- UpdateTime time.Time `gorm:"type:datetime" json:"updateTime"` //修改时间
- UpdateUser int64 `gorm:"type:bigint" json:"updateUser"` //修改用户
- IsDeleted int `gorm:"type:int;default 0" json:"isDeleted"` //是否删除 0=未删除,1=删除
- Status int `gorm:"type:int;default 2" json:"status"` //状态 1=正常,2=异常
- }
- func (Library) TableName() string {
- return "media_library"
- }
- func (c Library) GetLibraries(offset, limit int) ([]Library, error) {
- var libraries []Library
- db := Db.Debug().Model(&c)
- if c.LibName != "" {
- db = db.Where("lib_name like ?", "%"+c.LibName+"%")
- }
- err := db.Where("is_deleted = 0 and tenant_id = ?", c.TenantId).Offset(offset).Limit(limit).Find(&libraries).Error
- return libraries, err
- }
|
