eta_api/models/ppt_v2.go

package models

import (
	"eta_gn/eta_api/global"
	"eta_gn/eta_api/models/ppt_english"
	"eta_gn/eta_api/utils"
	"time"

	"github.com/beego/beego/v2/client/orm"
	"github.com/rdlucklib/rdluck_tools/paging"
)

// PptV2 表
type PptV2 struct {
	PptId         int       `gorm:"column:ppt_id;primaryKey;autoIncrement:true" description:"ppt的Id"`
	TemplateType  int       `gorm:"column:template_type" description:"模版类型"`
	BackgroundImg string    `gorm:"column:background_img" description:"背景图片"`
	Title         string    `gorm:"column:title" description:"标题"`
	ReportType    string    `gorm:"column:report_type" description:"报告类型"`
	PptDate       string    `gorm:"column:ppt_date" description:"选择日期"`
	Content       string    `gorm:"column:content" description:"ppt内容"`
	PptUrl        string    `gorm:"column:ppt_url" description:"ppt下载地址"`
	PptxUrl       string    `gorm:"column:pptx_url" description:"pptx下载地址"`
	CreateTime    time.Time `gorm:"column:create_time" description:"创建时间"`
	ModifyTime    time.Time `gorm:"column:modify_time" description:"修改时间"`
	AdminId       int       `gorm:"column:admin_id" description:"系统用户id"`
	AdminRealName string    `gorm:"column:admin_real_name" description:"系统用户名称"`
	PptVersion    int8      `gorm:"column:ppt_version" description:"是否ppt的旧版本；1：旧的，2：新的"`
	ReportId      int       `gorm:"column:report_id" description:"关联的报告ID"`
	ReportCode    string    `gorm:"column:report_code" description:"关联的报告code"`
	IsShare       int8      `gorm:"column:is_share" description:"是否分享，0：不分享，1：分享"`
	PublishTime   time.Time `gorm:"column:publish_time" description:"发布时间"`
	CoverContent  string    `gorm:"column:cover_content" description:"PPT内容-JSON"`
	PptPage       int       `gorm:"column:ppt_page" description:"PPT页数"`
	TitleSetting  string    `gorm:"column:title_setting" description:"PPT标题设置"`
}

type PptV2Item struct {
	PptId         int       `gorm:"column:ppt_id;primaryKey" description:"ppt的Id"`
	TemplateType  int       `gorm:"column:template_type" description:"模版类型"`
	BackgroundImg string    `gorm:"column:background_img" description:"背景图片"`
	Title         string    `gorm:"column:title" description:"标题"`
	ReportType    string    `gorm:"column:report_type" description:"报告类型"`
	PptDate       string    `gorm:"column:ppt_date" description:"选择日期"`
	Content       string    `gorm:"column:content" description:"ppt内容"`
	PptUrl        string    `gorm:"column:ppt_url" description:"ppt下载地址"`
	PptxUrl       string    `gorm:"column:pptx_url" description:"pptx下载地址"`
	CreateTime    time.Time `gorm:"column:create_time" description:"创建时间"`
	ModifyTime    time.Time `gorm:"column:modify_time" description:"修改时间"`
	AdminId       int       `gorm:"column:admin_id" description:"系统用户id"`
	AdminRealName string    `gorm:"column:admin_real_name" description:"系统用户名称"`
	PptVersion    int8      `gorm:"column:ppt_version" description:"是否ppt的旧版本；1：旧的，2：新的"`
	IsAuth        bool      `gorm:"column:is_auth" description:"true:有操作权限，false:无操作权限"`
	ReportId      int       `gorm:"column:report_id" description:"报告ID"`
	ReportCode    string    `gorm:"column:report_code" description:"关联的报告code"`
	IsShare       int8      `gorm:"column:is_share" description:"是否分享，0：不分享，1：分享"`
	PublishTime   time.Time `gorm:"column:publish_time" description:"发布时间"`
	CoverContent  string    `gorm:"column:cover_content" description:"PPT内容-JSON"`
	PptPage       int       `gorm:"column:ppt_page" description:"PPT页数"`
	TitleSetting  string    `gorm:"column:title_setting" description:"PPT标题设置"`
}

func GetPptV2List(condition string, pars []interface{}, startSize, pageSize int) (items []*PptV2Item, err error) {
	//o := orm.NewOrmUsingDB("rddp")
	sql := `SELECT * FROM ppt_v2 WHERE 1=1 `
	if condition != "" {
		sql += condition
	}
	//
	sql += `ORDER BY modify_time DESC LIMIT ?,?`
	//sql += `ORDER BY create_time DESC LIMIT ?,?`
	//_, err = o.Raw(sql, pars, startSize, pageSize).QueryRows(&items)
	err = global.DmSQL["rddp"].Raw(sql, pars, startSize, pageSize).Find(&items).Error
	return
}

func GetPptV2ByCondition(condition string, pars []interface{}) (items []*PptV2, err error) {
	//o := orm.NewOrmUsingDB("rddp")
	sql := `SELECT * FROM ppt_v2 WHERE 1=1 `
	if condition != "" {
		sql += condition
	}
	//
	sql += `ORDER BY modify_time DESC`
	//sql += `ORDER BY create_time DESC LIMIT ?,?`
	//_, err = o.Raw(sql, pars).QueryRows(&items)
	err = global.DmSQL["rddp"].Raw(sql, pars).Find(&items).Error
	return
}

func GetPptV2ListCount(condition string, pars []interface{}) (count int, err error) {
	//o := orm.NewOrmUsingDB("rddp")
	sql := `SELECT COUNT(1) AS count FROM ppt_v2 WHERE 1=1 `
	if condition != "" {
		sql += condition
	}
	//err = o.Raw(sql, pars).QueryRow(&count)
	err = global.DmSQL["rddp"].Raw(sql, pars).Scan(&count).Error
	return
}

type PptV2ListResp struct {
	List   []*PptV2Item
	Paging *paging.PagingItem `description:"分页数据"`
}

// AddPptV2 新增PPT
func AddPptV2(item *PptV2) (lastId int64, err error) {
	//o := orm.NewOrmUsingDB("rddp")
	//lastId, err = o.Insert(item)
	err = global.DmSQL["rddp"].Create(item).Error
	lastId = int64(item.PptId)
	return
}

// DeletePptV2 删除ppt
func DeletePptV2(pptId int) (err error) {
	//o := orm.NewOrmUsingDB("rddp")
	sql := `DELETE FROM ppt_v2 WHERE ppt_id=? `
	//_, err = o.Raw(sql, pptId).Exec()
	err = global.DmSQL["rddp"].Exec(sql, pptId).Error
	return
}

type AddPptV2Req struct {
	PptId     int64 `description:"ppt_id"`
	FirstPage struct {
		Title        string `description:"标题"`
		ReportType   string `description:"类型"`
		PptDate      string `description:"日期"`
		ImgUrl       string `description:"图片"`
		BackIndex    int    `description:"背景图片下标"`
		TemplateType int    `description:"模版id"`
	} `description:"首页"`
	Content      string `description:"ppt的json数据"`
	GroupId      int64  `description:"目录id"`
	CoverContent string `description:"封面图内容-JSON数据"`
	TitleSetting string `description:"PPT标题设置"`
}

type AddPptResp struct {
	PptId int64 `description:"PptId"`
}

// Update 更新ppt基础信息
func (item *PptV2) Update(cols []string) (err error) {
	//o := orm.NewOrmUsingDB("rddp")
	//_, err = o.Update(item, cols...)
	err = global.DmSQL["rddp"].Select(cols).Updates(item).Error
	return
}

type DeletePptV2Req struct {
	PptId int `description:"PptId" `
}

// SavePptV2PathReq 保存ppt的下载地址请求
type SavePptV2PathReq struct {
	PptId   int    `description:"PptId" `
	PptxUrl string `description:"PptxUrl" `
}

func GetPptV2ById(pptId int) (item *PptV2, err error) {
	//o := orm.NewOrmUsingDB("rddp")
	sql := `SELECT * FROM ppt_v2 WHERE 1=1 AND ppt_id=? `
	//err = o.Raw(sql, pptId).QueryRow(&item)
	err = global.DmSQL["rddp"].Raw(sql, pptId).Find(&item).Error
	return
}

func GetPptV2ByIds(pptIds []int) (list []*PptV2, err error) {
	_, err = orm.NewOrmUsingDB("rddp").
		QueryTable("ppt_v2").
		Filter("ppt_id__in", pptIds).
		All(&list)
	err = global.DmSQL["rddp"].Table("ppt_v2").Where("ppt_id IN ?", pptIds).Find(&list).Error

	return
}

func GetPptV2ByTitle(title string) (item *PptV2, err error) {
	//o := orm.NewOrmUsingDB("rddp")
	sql := `SELECT * FROM ppt_v2 WHERE 1=1 AND title=? `
	//err = o.Raw(sql, title).QueryRow(&item)
	err = global.DmSQL["rddp"].Raw(sql, title).First(&item).Error
	return
}

// EditPptV2Path 编辑Ppt的下载地址
func EditPptV2Path(pptId int, pptxPath string) (err error) {
	sql := `UPDATE ppt_v2 SET pptx_url=?,modify_time=NOW(),publish_time=NOW() WHERE ppt_id=? `
	//o := orm.NewOrmUsingDB("rddp")
	//_, err = o.Raw(sql, pptxPath, pptId).Exec()
	err = global.DmSQL["rddp"].Exec(sql, pptxPath, pptId).Error
	return
}

// PptV2PublishRecord 发布记录表
type PptV2PublishRecord struct {
	Id         int `orm:"column(id);pk"`
	PptId      int
	PptUrl     string
	CreateTime time.Time
}

// AddPptV2PublishRecord 添加发布记录，主要是记录每次发布的时候，当前的ppt
func AddPptV2PublishRecord(item *PptV2PublishRecord) (lastId int64, err error) {
	//o := orm.NewOrmUsingDB("rddp")
	//lastId, err = o.Insert(item)
	err = global.DmSQL["rddp"].Create(item).Error
	lastId = int64(item.Id)
	return
}

// PptV2SaveLog ppt记录表
type PptV2SaveLog struct {
	Id            int       `gorm:"column:id;primaryKey;autoIncrement" description:"自增Id"`
	PptId         int       `gorm:"column:ppt_id" description:"ppt的Id"`
	TemplateType  int       `gorm:"column:template_type" description:"模版类型"`
	BackgroundImg string    `gorm:"column:background_img" description:"背景图片"`
	Title         string    `gorm:"column:title" description:"标题"`
	ReportType    string    `gorm:"column:report_type" description:"报告类型"`
	PptDate       string    `gorm:"column:ppt_date" description:"选择日期"`
	Content       string    `gorm:"column:content" description:"ppt内容"`
	AdminId       int       `gorm:"column:admin_id" description:"系统用户id"`
	AdminRealName string    `gorm:"column:admin_real_name" description:"系统用户名称"`
	CreateTime    time.Time `gorm:"column:create_time" description:"创建时间"`
	CoverContent  string    `gorm:"column:cover_content" description:"PPT内容-JSON"`
	TitleSetting  string    `gorm:"column:title_setting" description:"PPT标题设置"`
}

// AddPptV2SaveLog 新增PPT日志
func AddPptV2SaveLog(item *PptV2SaveLog) (lastId int64, err error) {
	//o := orm.NewOrmUsingDB("rddp")
	//lastId, err = o.Insert(item)
	err = global.DmSQL["rddp"].Create(item).Error
	lastId = int64(item.Id)
	return
}

type PptV2ConfigResp struct {
	PptNum   int `description:"ppt数量" json:"ppt_num"`
	ChartNum int `description:"图片数量" json:"chart_num"`
}

type PPT2ReportReq struct {
	PptId      int    `description:"PPT主键"`
	ClassifyId int    `description:"报告二级分类ID"`
	Title      string `description:"标题"`
}

// AddPptV2Multi 批量新增ppt
func AddPptV2Multi(list []*PptV2) (err error) {
	//o := orm.NewOrmUsingDB("rddp")
	//_, err = o.InsertMulti(1, list)
	err = global.DmSQL["rddp"].CreateInBatches(list, utils.MultiAddNum).Error
	return
}

// GetAllPptTitle 获取当前目录的所有名称
func GetAllPptTitle() (names []string, err error) {
	//	o := orm.NewOrmUsingDB("rddp")
	sql := "select title from ppt_v2"
	//_, err = o.Raw(sql).QueryRows(&names)
	err = global.DmSQL["rddp"].Raw(sql).Scan(&names).Error
	return
}

// PPT2ReportResp PPT转报告响应体
type PPT2ReportResp struct {
	ReportId   int    `description:"关联的报告ID" json:"report_id"`
	ReportCode string `description:"关联的报告编码" json:"report_code"`
}

// GetPptV2ByReportId 通过关联的报告ID获取PPT
func GetPptV2ByReportId(reportId int) (item *PptV2, err error) {
	//o := orm.NewOrmUsingDB("rddp")
	sql := `SELECT * FROM ppt_v2 WHERE 1=1 AND report_id=? LIMIT 1`
	//err = o.Raw(sql, reportId).QueryRow(&item)
	err = global.DmSQL["rddp"].Raw(sql, reportId).First(&item).Error
	return
}

// GetSharePptV2 获取公开分享的ppt
func GetSharePptV2(IsNewPpt int) (items []*PptV2, err error) {
	//o := orm.NewOrmUsingDB("rddp")
	sql := `SELECT * FROM ppt_v2 WHERE 1=1 AND is_share = 1 `

	if IsNewPpt > 0 {
		sql += ` AND ppt_version = 2 `
	}
	sql += `ORDER BY create_time DESC`
	//sql += `ORDER BY create_time DESC LIMIT ?,?`
	//_, err = o.Raw(sql).QueryRows(&items)
	err = global.DmSQL["rddp"].Raw(sql).Find(&items).Error
	return
}

// GetAllPptV2List 根据条件获取所有的Ppt
func GetAllPptV2List(condition string, pars []interface{}) (items []*PptV2Item, err error) {
	//o := orm.NewOrmUsingDB("rddp")
	sql := `SELECT * FROM ppt_v2 WHERE 1=1 `
	if condition != "" {
		sql += condition
	}
	//
	sql += `ORDER BY modify_time DESC `
	//_, err = o.Raw(sql, pars).QueryRows(&items)
	err = global.DmSQL["rddp"].Raw(sql, pars).Find(&items).Error
	return
}

type EnPPT2CnReq struct {
	PptId   int `description:"英文PPT主键"`
	GroupId int `description:"目录ID"`
}

type BatchEnPPT2CnReq struct {
	PptIds  string `description:"英文PPT主键s"`
	GroupId int    `description:"目录ID"`
}

func GetPptV2ByTitleAndId(title string, adminId int) (item *PptV2, err error) {
	//o := orm.NewOrmUsingDB("rddp")
	sql := `SELECT * FROM ppt_v2 WHERE 1=1 AND title=? AND admin_id=? `
	//err = o.Raw(sql, title, adminId).QueryRow(&item)
	err = global.DmSQL["rddp"].Raw(sql, title, adminId).First(&item).Error
	return
}

// PPTEditingReq 标记编辑中请求体
type PPTEditingReq struct {
	PptId  int `description:"PPT主键ID"`
	Status int `description:"标记状态: 1-编辑中; 2-编辑完成"`
}

// PPTDetailResp PPT详情响应体
type PPTDetailResp struct {
	*PptV2
	Editor ppt_english.PPTEditingCache `description:"编辑人信息"`
}