hongze_clpt/models/report_selection.go

package models

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

type CygxReportSelectionRep struct {
	ArticleId         int    `orm:"column(article_id);pk"description:"报告id"`
	Title             string `description:"标题"`
	Department        string `description:"作者"`
	PublishDate       string `description:"发布时间"`
	CreateTime        string `description:"创建时间"`
	Abstract          string `description:"摘要/更新说明"`
	UpdateDescription string `description:"更新说明"`
	IsRed             bool   `description:"是否标记红点"`
	ReadNum           int    `description:"阅读次数"`
}

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

type DetailCygxReportSelectionRep struct {
	ArticleId          int    `description:"报告Id"`
	Title              string `description:"标题"`
	Department         string `description:"作者"`
	PublishDate        string `description:"发布时间"`
	CreateTime         string `description:"创建时间"`
	LastUpdatedTime    string `description:"最后一次更新时间"`
	Periods            int    `description:"期数"`
	VideoUrl           string `description:"链接"`
	VideoPlaySeconds   string `description:"时长"`
	VideoName          string `description:"音频名称"`
	ProductDescription string `description:"产品说明"`
	UpdateDescription  string `description:"更新说明"`
	FocusOn            string `description:"近期重点关注方向"`
	MarketStrategy     string `description:"市场策略核心逻辑汇总"`
	ReportLink         string `description:"报告链接"`
	CeLueArticleId     int    `description:"策略报告详情"`
	VisibleRange       int    `description:"设置可见范围1全部，0内部"`
}

type ReportSelectionLetailResp struct {
	Detail                *DetailCygxReportSelectionRep
	HasPermission         int `description:"1:有该行业权限,正常展示，2：无该行业权限，不存在权益客户下，3:无该品类权限,已提交过申请，4：无该行业权限,未提交过申请，5：潜在客户，未提交过申请，6：潜在客户,已提交过申请"`
	List                  []*ReportSelectionChartPermission
	ListPermissionSubject []*ReportSelectionChartLogPermission `description:"行业列表"`
	IsShow                bool                                 `description:"是否展示"`
}

type ReportSelectionChartPermission struct {
	PermissionName    string `description:"权限名称"`
	ChartPermissionId int    `description:"权限名称"`
	IcoLink           string `orm:"column(image_url)"description:"图标链接"`
	List              []*CygxReportSelectionLogDetail
	BodyChartSummary  string `description:"行业核心逻辑汇总"`
}

type ReportSelectionChartLogPermission struct {
	PermissionName string                                `description:"权限名称"`
	ListSubject    []*ReportSelectionChartLogSubjectName `description:"标的列表"`
}

type ReportSelectionChartLogSubjectName struct {
	SubjectName         string `description:"标的名称"`
	IndustrialSubjectId int    `description:"标的ID"`
	IsNew               bool   `description:"是否展示新标签"`
}

type CygxReportSelectionLogDetail struct {
	IndustrialManagementId string   `description:"产业Id"`
	IndustrialSubjectId    int      `description:"标的ID"`
	SubjectName            string   `description:"标的名称"`
	IsNew                  bool     `description:"是否展示新标签"`
	Body                   string   `description:"内容"`
	CompanyLabel           []string `description:"公司标签"`
	Label                  string   `description:"公司标签"`
	OverviewArticleId      int      `description:"综述报告Id"`
	List                   []*IndustriaReportSelection
}
type IndustriaReportSelection struct {
	IndustrialManagementId int    `description:"产业Id"`
	IndustryName           string `description:"产业名称"`
}

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

// 获取数量
func GetCygxReportSelectionPublic(condition, tbdb string, pars []interface{}) (count int, err error) {
	sqlCount := ` SELECT COUNT(1) AS count  FROM ` + tbdb + ` as art WHERE 1= 1 AND art.publish_status = 1   `
	if condition != "" {
		sqlCount += condition
	}
	o := orm.NewOrm()
	err = o.Raw(sqlCount, pars).QueryRow(&count)
	return
}

// 通过ID获取详情
func GetCygxReportSelectionInfoById(articleId int) (item *DetailCygxReportSelectionRep, err error) {
	o := orm.NewOrm()
	sql := `SELECT * FROM cygx_report_selection  WHERE article_id=? AND publish_status = 1 `
	err = o.Raw(sql, articleId).QueryRow(&item)
	return
}

// 通过期数获取详情
func GetCygxReportSelectionInfoByperiods(periods int) (item *DetailCygxReportSelectionRep, err error) {
	o := orm.NewOrm()
	sql := `SELECT * FROM cygx_report_selection  WHERE periods=?  `
	err = o.Raw(sql, periods).QueryRow(&item)
	return
}

// 列表
func GetReportSelectionListPublic(condition, readSql, tbdb string, pars []interface{}, startSize, pageSize int) (items []*CygxReportSelectionRep, err error) {
	o := orm.NewOrm()
	sql := `SELECT * ,` + readSql + ` FROM  ` + tbdb + ` as art WHERE 1= 1 AND art.publish_status = 1  `
	if condition != "" {
		sql += condition
	}
	sql += ` ORDER BY  art.publish_date  DESC  LIMIT ?,?`
	_, err = o.Raw(sql, pars, startSize, pageSize).QueryRows(&items)
	return
}

// 列表
func GetReportSelectionListHome(condition, tbdb string, pars []interface{}, startSize, pageSize int) (items []*CygxReportSelectionRep, err error) {
	o := orm.NewOrm()
	sql := `SELECT *  FROM  ` + tbdb + ` as art WHERE 1= 1 AND art.publish_status = 1  `
	if condition != "" {
		sql += condition
	}
	sql += ` ORDER BY  art.publish_date  DESC  LIMIT ?,?`
	_, err = o.Raw(sql, pars, startSize, pageSize).QueryRows(&items)
	return
}

type CygxReportSelectionLog 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    int       `description:"标的ID"`
	IndustrialManagementId string    `description:"产业资源包Id  多个用 , 隔开"`
	SubjectName            string    `description:"标的名称"`
	IcoLink                string    `orm:"column(image_url)"description:"图标链接"`
	CompanyLabel           []string  `description:"公司标签"`
	Label                  string    `description:"公司标签"`
	OverviewArticleId      int       `description:"综述报告Id"`
}

// 列表
func GetReportSelectionlogListAll(articleId int) (items []*CygxReportSelectionLog, err error) {
	o := orm.NewOrm()
	sql := `SELECT c.permission_name ,c.image_url,s.subject_name , l.*  ,l.company_label as label
			FROM
			cygx_report_selection_log AS l
			INNER JOIN chart_permission AS c ON c.chart_permission_id = l.chart_permission_id 
			INNER JOIN cygx_industrial_subject AS s ON s.industrial_subject_id = l.industrial_subject_id 
			WHERE l.article_id = ? `
	_, err = o.Raw(sql, articleId).QueryRows(&items)
	return
}

// 列表
func GetReportSelectionlogSonListAll(articleId, chartPermissionId int) (items []*CygxReportSelectionLogDetail, err error) {
	o := orm.NewOrm()
	sql := `SELECT c.permission_name , l.* ,l.company_label as label
			FROM
			cygx_report_selection_log AS l
			INNER JOIN chart_permission AS c ON c.chart_permission_id = l.chart_permission_id 
			LEFT JOIN cygx_industrial_subject AS s ON s.industrial_subject_id = l.industrial_subject_id 
			WHERE l.article_id = ? AND l.chart_permission_id =?`
	_, err = o.Raw(sql, articleId, chartPermissionId).QueryRows(&items)
	return
}

func GetIndustrialByIds(industrialManagementIds string) (items []*IndustriaReportSelection, err error) {
	o := orm.NewOrm()
	sql := `SELECT * FROM cygx_industrial_management  WHERE industrial_management_id IN (` + industrialManagementIds + `)`
	_, err = o.Raw(sql).QueryRows(&items)
	return
}