hongze_cygx/models/researchSummary.go

package models

import (
	"rdluck_tools/orm"
	"time"
)

type CygxResearchSummary struct {
	ArticleId          int       `orm:"column(article_id);pk"description:"报告id"`
	AddType            string    `description:"更新方式 1重新编辑  ，2 继承往期"`
	Title              string    `description:"标题"`
	Department         string    `description:"作者"`
	PublishStatus      int       `description:"发布状态，1已发布，0未发布"`
	PublishDate        time.Time `description:"发布时间"`
	CreateTime         time.Time `description:"创建时间"`
	LastUpdatedTime    time.Time `description:"最后一次更新时间"`
	Periods            string    `description:"期数"`
	HavePublish        int       `description:"是否发布过，1是，0否"`
	InheritPeriods     string    `description:"继承期数"`
	ProductDescription string    `description:"产品说明"`
	UpdateDescription  string    `description:"更新说明"`
	FocusOn            string    `description:"近期重点关注方向"`
}

type AddCygxResearchSummary struct {
	ArticleId          int    `description:"报告Id ，传0时新增，大于0时修改"`
	AddType            string `description:"更新方式 1重新编辑  ，2 继承往期"`
	InheritPeriods     string `description:"继承期数"`
	Title              string `description:"标题"`
	Department         string `description:"作者"`
	PublishDate        string `description:"发布时间"`
	ProductDescription string `description:"产品说明"`
	UpdateDescription  string `description:"更新说明"`
	FocusOn            string `description:"近期重点关注方向"`
	DoType             int    `description:"操作方式，1发布，0保存"`
}

type DetailCygxResearchSummaryRep struct {
	ArticleId        int     `description:"报告Id"`
	Title            string  `description:"标题"`
	Department       string  `description:"作者"`
	PublishDate      string  `description:"发布时间"`
	VideoUrl         string  `description:"链接"`
	VideoPlaySeconds float64 `description:"时长"`
	Abstract         string  `description:"摘要"`
}

type ResearchSummaryLetailResp struct {
	Detail *DetailCygxResearchSummaryRep
	List   []*ResearchSummaryChartPermission
}

type ResearchSummaryChartPermission struct {
	ListName string `description:"列表名称"`
	Type     string `description:"类型'SDBG深度报告片篇,’CYDYJY：产业调研纪要’,’SJDP事件点评,’BZCHJH：本周晨会精华’"`
	List     []*CygxResearchSummaryLogSecond
}

type CygxResearchSummaryLogSecond struct {
	PermissionName    string `description:"行业名称"`
	ChartPermissionId int    `description:"行业ID"`
	IcoLink           string `orm:"column(image_url)"description:"图标链接"`
	List              []*CygxResearchSummaryLogThird
}

type CygxResearchSummaryLogThird struct {
	Body       string `description:"内容"`
	ReportLink string `description:"报告链接"`
}
type IndustriaResearchSummary struct {
	IndustrialManagementId int    `description:"产业Id"`
	IndustryName           string `description:"产业名称"`
}

type ResearchSummaryId struct {
	ArticleId int `description:"报告I"`
}

//通过纪要ID获取详情
func GetCygxResearchSummaryInfoById(articleId int) (item *DetailCygxResearchSummaryRep, err error) {
	o := orm.NewOrm()
	sql := `SELECT * FROM cygx_research_summary  WHERE article_id=?`
	err = o.Raw(sql, articleId).QueryRow(&item)
	return
}

type CygxResearchSummaryLog struct {
	ArticleSunId           int       `description:"子级报告id"`
	ArticleId              int       `description:"父级报告Id"`
	ChartPermissionId      int       `description:"行业ID"`
	PermissionName         string    `description:"行业ID"`
	CreateTime             time.Time `description:"创建时间"`
	Body                   string    `description:"内容"`
	IndustrialSubjectId    string    `description:"标的ID"`
	IndustrialManagementId string    `description:"产业资源包Id  多个用 , 隔开"`
	SubjectName            string    `description:"标的名称"`
	Type                   string    `description:"类型'SDBG深度报告片篇,’CYDYJY：产业调研纪要’,’SJDP事件点评,’BZCHJH：本周晨会精华’"`
}

//列表
func GetResearchSummarylogListFirst(articleId int) (items []*ResearchSummaryChartPermission, err error) {
	o := orm.NewOrm()
	sql := `SELECT l.* 
			FROM cygx_research_summary_log AS l 
			WHERE l.article_id = ? 
			GROUP BY l.type 
			ORDER BY l.sort ASC`
	_, err = o.Raw(sql, articleId).QueryRows(&items)
	return
}

//列表
func GetResearchSummarylogSonListSecond(articleId int, artType string) (items []*CygxResearchSummaryLogSecond, err error) {
	o := orm.NewOrm()
	sql := `SELECT c.permission_name ,c.chart_permission_id ,c.image_url, l.* 
			FROM
			cygx_research_summary_log AS l
			LEFT JOIN chart_permission AS c ON c.chart_permission_id = l.chart_permission_id 
			WHERE l.article_id = ? AND l.type =?
			GROUP BY l.chart_permission_id
			ORDER  BY l.chart_permission_sort ASC`
	_, err = o.Raw(sql, articleId, artType).QueryRows(&items)
	return
}

//列表
func GetResearchSummarylogSonListThird(articleId, chartPermissionId int, artType string) (items []*CygxResearchSummaryLogThird, err error) {
	o := orm.NewOrm()
	sql := `SELECT  l.* 
			FROM cygx_research_summary_log AS l
			WHERE l.article_id = ? AND l.type =? AND  l.chart_permission_id = ? 
			ORDER  BY l.chart_permission_sort ASC `
	_, err = o.Raw(sql, articleId, artType, chartPermissionId).QueryRows(&items)
	return
}