123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301 |
- package models
- import (
- "eta_gn/eta_api/global"
- "eta_gn/eta_api/utils"
- "time"
- "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) {
- sql := `SELECT * FROM ppt_v2 WHERE 1=1 `
- if condition != "" {
- sql += condition
- }
- //
- sql += `ORDER BY modify_time DESC LIMIT ?,?`
- pars = append(pars, startSize)
- pars = append(pars, pageSize)
- err = global.DmSQL["rddp"].Raw(sql, pars...).Find(&items).Error
- return
- }
- func GetPptV2ByCondition(condition string, pars []interface{}) (items []*PptV2, err error) {
- sql := `SELECT * FROM ppt_v2 WHERE 1=1 `
- if condition != "" {
- sql += condition
- }
- //
- sql += `ORDER BY modify_time DESC`
- err = global.DmSQL["rddp"].Raw(sql, pars...).Find(&items).Error
- return
- }
- func GetPptV2ListCount(condition string, pars []interface{}) (count int, err error) {
- sql := `SELECT COUNT(1) AS count FROM ppt_v2 WHERE 1=1 `
- if condition != "" {
- sql += condition
- }
- 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) {
- err = global.DmSQL["rddp"].Create(item).Error
- lastId = int64(item.PptId)
- return
- }
- // DeletePptV2 删除ppt
- func DeletePptV2(pptId int) (err error) {
- sql := `DELETE FROM ppt_v2 WHERE ppt_id=? `
- 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) {
- 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) {
- sql := `SELECT * FROM ppt_v2 WHERE 1=1 AND ppt_id=? `
- err = global.DmSQL["rddp"].Raw(sql, pptId).Find(&item).Error
- return
- }
- func GetPptV2ByIds(pptIds []int) (list []*PptV2, err error) {
- err = global.DmSQL["rddp"].Table("ppt_v2").Where("ppt_id IN ?", pptIds).Find(&list).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=? `
- err = global.DmSQL["rddp"].Exec(sql, pptxPath, pptId).Error
- return
- }
- // PptV2PublishRecord 发布记录表
- type PptV2PublishRecord struct {
- Id int `gorm:"primaryKey" `
- PptId int
- PptUrl string
- CreateTime time.Time
- }
- // AddPptV2PublishRecord 添加发布记录,主要是记录每次发布的时候,当前的ppt
- func AddPptV2PublishRecord(item *PptV2PublishRecord) (lastId int64, err error) {
- 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) {
- 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) {
- err = global.DmSQL["rddp"].CreateInBatches(list, utils.MultiAddNum).Error
- return
- }
- // GetAllPptTitle 获取当前目录的所有名称
- func GetAllPptTitle() (names []string, err error) {
- sql := "select title from ppt_v2"
- 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) {
- sql := `SELECT * FROM ppt_v2 WHERE 1=1 AND report_id=? LIMIT 1`
- err = global.DmSQL["rddp"].Raw(sql, reportId).First(&item).Error
- return
- }
- // GetSharePptV2 获取公开分享的ppt
- func GetSharePptV2(IsNewPpt int) (items []*PptV2, err error) {
- 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`
- err = global.DmSQL["rddp"].Raw(sql).Find(&items).Error
- return
- }
- // GetAllPptV2List 根据条件获取所有的Ppt
- func GetAllPptV2List(condition string, pars []interface{}) (items []*PptV2Item, err error) {
- sql := `SELECT * FROM ppt_v2 WHERE 1=1 `
- if condition != "" {
- sql += condition
- }
- //
- sql += `ORDER BY modify_time DESC `
- 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) {
- sql := `SELECT * FROM ppt_v2 WHERE 1=1 AND title=? AND admin_id=? `
- 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 PPTEditingCache `description:"编辑人信息"`
- }
- // PPTEditingCache PPT编辑缓存信息
- type PPTEditingCache struct {
- IsEditing bool `description:"是否有人编辑"`
- AdminId int `description:"编辑者ID"`
- Editor string `description:"编辑者姓名"`
- Tips string `description:"提示信息"`
- }
|