eta_api/models/en_video_cover.go

package models

import (
	"eta_gn/eta_api/global"
	"github.com/rdlucklib/rdluck_tools/paging"
	"time"
)

// EnglishVideoCover 英文研报视频封面库
type EnglishVideoCover struct {
	Id         int       `gorm:"column:id;primaryKey;autoIncrement" description:"封面ID"`
	CoverName  string    `gorm:"column:cover_name" description:"封面名称"`
	CoverUrl   string    `gorm:"column:cover_url" description:"封面图地址"`
	IsDeleted  int       `gorm:"column:is_deleted" description:"是否已删除 0-否 1-是"`
	CreateTime time.Time `gorm:"column:create_time;autoCreateTime" description:"创建时间"`
	ModifyTime time.Time `gorm:"column:modify_time;autoUpdateTime" description:"修改时间"`
	DeleteTime time.Time `gorm:"column:delete_time" description:"删除时间"`
}

func (item *EnglishVideoCover) TableName() string {
	return "english_video_cover"
}

func (item *EnglishVideoCover) Add() (err error) {
	//o := orm.NewOrmUsingDB("rddp")
	//_, err = o.Insert(item)
	err = global.DmSQL["rddp"].Create(item).Error
	return
}

func (item *EnglishVideoCover) Update(cols []string) (err error) {
	//o := orm.NewOrmUsingDB("rddp")
	//_, err = o.Update(item, cols...)
	err = global.DmSQL["rddp"].Select(cols).Updates(item).Error
	return
}

// GetEnglishVideoCoverById 主键获取封面
func GetEnglishVideoCoverById(coverId int) (item *EnglishVideoCover, err error) {
	//o := orm.NewOrmUsingDB("rddp")
	sql := `SELECT * FROM english_video_cover WHERE id = ? AND is_deleted = 0 LIMIT 1`
	//err = o.Raw(sql, coverId).QueryRow(&item)
	err = global.DmSQL["rddp"].Raw(sql, coverId).First(&item).Error
	return
}

// GetEnglishVideoCoverPageList 获取封面库分页列表
func GetEnglishVideoCoverPageList(condition string, pars []interface{}, orderRule string, startSize, pageSize int) (total int, list []*EnglishVideoCover, err error) {
	//	o := orm.NewOrmUsingDB("rddp")
	sql := `SELECT * FROM english_video_cover WHERE is_deleted = 0 `
	sql += condition
	if orderRule == "" {
		orderRule = ` ORDER BY modify_time DESC`
	}
	sql += orderRule
	totalSQL := `SELECT COUNT(1) total FROM (` + sql + `) z`
	//if err = o.Raw(totalSQL, pars).QueryRow(&total); err != nil {
	if err = global.DmSQL["rddp"].Raw(totalSQL, pars).Scan(&total).Error; err != nil {
		return
	}
	sql += ` LIMIT ?,?`
	//_, err = o.Raw(sql, pars, startSize, pageSize).QueryRows(&list)
	err = global.DmSQL["rddp"].Raw(sql, pars, startSize, pageSize).Find(&list).Error
	return
}

// DeleteEnglishVideoCover 删除封面
func DeleteEnglishVideoCover(coverId int) (err error) {
	//o := orm.NewOrmUsingDB("rddp")
	sql := `UPDATE english_video_cover SET is_deleted = 1, delete_time = NOW() WHERE id = ? LIMIT 1`
	//_, err = o.Raw(sql, coverId).Exec()
	err = global.DmSQL["rddp"].Exec(sql, coverId).Error
	return
}

type EnglishVideoCoverListResp struct {
	Paging *paging.PagingItem
	List   []*EnglishVideoCoverItem `description:"列表数据"`
}

type EnglishVideoCoverItem struct {
	Id         int    `description:"封面ID"`
	CoverName  string `description:"封面名称"`
	CoverUrl   string `description:"封面图地址"`
	CreateTime string `description:"提问时间"`
	ModifyTime string `description:"修改时间"`
}

type EnglishVideoCoverSaveReq struct {
	Id        int    `description:"封面ID"`
	CoverName string `description:"封面名称"`
	CoverUrl  string `description:"封面图地址"`
}

type EnglishVideoCoverOptionReq struct {
	Id int `description:"封面图ID"`
}