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:"提示信息"` }