lc_veterans/app/multimedia/dao/libraryDao.go

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
}