hongze_yb_en_api/models/english_video/english_video.go

package english_video

import (
	"hongze/hongze_yb_en_api/global"
	"hongze/hongze_yb_en_api/models/base"
	"time"
)

type EnglishVideo struct {
	Id                 uint      `gorm:"primaryKey;column:id" json:"id"`
	ClassifyIdFirst    int       `gorm:"column:classify_id_first" json:"classify_id_first"`       //一级分类id
	ClassifyNameFirst  string    `gorm:"column:classify_name_first" json:"classify_name_first"`   //一级分类名称
	ClassifyIdSecond   int       `gorm:"column:classify_id_second" json:"classify_id_second"`     //二级分类id
	ClassifyNameSecond string    `gorm:"column:classify_name_second" json:"classify_name_second"` //二级分类名称
	Title              string    `gorm:"column:title" json:"title"`                               //标题
	Abstract           string    `gorm:"column:abstract" json:"abstract"`                         //摘要
	Author             string    `gorm:"column:author" json:"author"`                             //作者
	State              int8      `gorm:"column:state" json:"state"`                               //1:未发布，2:已发布
	PublishTime        time.Time `gorm:"column:publish_time" json:"publish_time"`                 //发布时间
	Overview           string    `gorm:"column:overview" json:"overview"`                         //概述
	VideoUrl           string    `gorm:"column:video_url" json:"video_url"`                       //视频文件URL
	VideoCoverUrl      string    `gorm:"column:video_cover_url" json:"video_cover_url"`           //视频文件封面地址
	VideoSeconds       string    `gorm:"column:video_seconds" json:"video_seconds"`               //视频时长
	VideoCode          string    `gorm:"column:video_code" json:"video_code"`                     //唯一编码
	Pv                 int       `gorm:"column:pv" json:"pv"`
	ShareUrl           string    `gorm:"column:share_url" json:"share_url"`     //分享url
	PvEmail            uint      `gorm:"column:pv_email" json:"pv_email"`       //分享邮箱的PV
	EmailState         uint8     `gorm:"column:email_state" json:"email_state"` //是否已群发邮件：0-否; 1-是
	base.TimeBase
}


// TableName get sql table name.获取数据库表名
func (r *EnglishVideo) TableName() string {
	return "english_video"
}

type VideoListReq struct {
	ClassifyIdFirst  int `json:"classify_id_first" form:"classify_id_first"`
	ClassifyIdSecond int `json:"classify_id_second" form:"classify_id_second"`
	base.PageReq
}

type VideoListItem struct {
	Id                 uint   `json:"id"`
	ClassifyIdFirst    int    `json:"classify_id_first"`    //一级分类id
	ClassifyNameFirst  string `json:"classify_name_first"`  //一级分类名称
	ClassifyIdSecond   int    `json:"classify_id_second"`   //二级分类id
	ClassifyNameSecond string `json:"classify_name_second"` //二级分类名称
	Title              string `json:"title"`                //标题
	Abstract           string `json:"abstract"`             //摘要
	Author             string `json:"author"`               //作者
	PublishTime        string `json:"publish_time"`         //发布时间
	VideoUrl           string `json:"video_url"`            //视频文件URL
	VideoCoverUrl      string `json:"video_cover_url"`      //视频文件封面地址
	VideoSeconds       string `json:"video_seconds"`        //视频时长
	VideoCode          string `json:"video_code"`           //唯一编码
	ShareUrl           string `json:"share_url"`            //分享url
	CreateTime         string `json:"create_time"`          //创建时间
	ModifyTime         string `json:"modify_time"`          //最后更新时间
}

type VideoSearchReq struct {
	KeyWord  string `json:"key_word" form:"key_word"`
	base.PageReq
}

type VideoDetailReq struct {
	VideoCode  string `json:"video_code" form:"video_code" binding:"required"` //唯一编码
	ShareEmail int    `json:"share_email" form:"share_email"`                  //推送的邮箱ID
}

type VideoDetail struct {
	Id                 uint   `json:"id"`
	ClassifyIdFirst    int    `json:"classify_id_first"`    //一级分类id
	ClassifyNameFirst  string `json:"classify_name_first"`  //一级分类名称
	ClassifyIdSecond   int    `json:"classify_id_second"`   //二级分类id
	ClassifyNameSecond string `json:"classify_name_second"` //二级分类名称
	Title              string `json:"title"`                //标题
	Abstract           string `json:"abstract"`             //摘要
	Author             string `json:"author"`               //作者
	PublishTime        string `json:"publish_time"`         //发布时间
	VideoUrl           string `json:"video_url"`            //视频文件URL
	VideoCoverUrl      string `json:"video_cover_url"`      //视频文件封面地址
	VideoSeconds       string `json:"video_seconds"`        //视频时长
	VideoCode          string `json:"video_code"`           //唯一编码
	CreateTime         string `json:"create_time"`          //创建时间
	ModifyTime         string `json:"modify_time"`          //最后更新时间
	Overview           string `json:"overview"`             //概述
}

type VideoDetailResp struct {
	Video *VideoDetail `json:"Video"`
}

type SearchEnglishVideoItem struct {
	Id                 uint    `json:"id"`
	ClassifyIdFirst    int    `json:"classify_id_first"`    //一级分类id
	ClassifyNameFirst  string `json:"classify_name_first"`  //一级分类名称
	ClassifyIdSecond   int    `json:"classify_id_second"`   //二级分类id
	ClassifyNameSecond string `json:"classify_name_second"` //二级分类名称
	Title              string `json:"title"`                //标题
	Author             string `json:"author"`               //作者
	PublishTime        string `json:"publish_time"`         //发布时间
	VideoCode         string `json:"video_code"`          //唯一编码
	CreateTime         string `json:"create_time"`          //创建时间
	ContentSub         string `json:"content_sub"`          //内容前两个章节"`
}

func (r *EnglishVideo) SelectPage(page base.IPage, condition string, pars []interface{}) (count int64, results []*EnglishVideo, err error) {
	results = make([]*EnglishVideo, 0)
	query := global.DEFAULT_MYSQL.Model(r).
		Select("*").
		Where(condition, pars...)
	query.Count(&count)
	if len(page.GetOrderItemsString()) > 0 {
		query = query.Order(page.GetOrderItemsString())
	}
	err = query.Limit(int(page.GetPageSize())).Offset(int(page.Offset())).Find(&results).Error
	return
}

func (r *EnglishVideo) GetEnglishVideoByCode(videoCode string) (item *EnglishVideo, err error) {
	err = global.MYSQL["rddp"].Model(r).Where("video_code= ?", videoCode).First(&item).Error
	return
}

// 修改
func (r *EnglishVideo) Update(updateCols []string) (err error) {
	err = global.DEFAULT_MYSQL.Model(r).Select(updateCols).Updates(r).Error
	return
}

func (r *EnglishVideo) UpdatePvEmailByVideoCode(videoCode string) (err error) {
	sql := `UPDATE english_video SET pv_email = pv_email+1 WHERE video_code = ?  `
	err = global.DEFAULT_MYSQL.Exec(sql, videoCode).Error
	return
}

func (r *EnglishVideo) UpdatePvByVideoCode(videoCode string) (err error) {
	sql := `UPDATE english_video SET pv = pv+1 WHERE video_code = ?  `
	err = global.DEFAULT_MYSQL.Exec(sql, videoCode).Error
	return
}

// GetVideosByIds 通过IDs获取集合
func (r *EnglishVideo) GetVideosByIds(ids []uint) (list []*EnglishVideo, err error) {
	err = global.DEFAULT_MYSQL.Model(r).Where("id IN (?)", ids).Scan(&list).Error
	return
}