hongze_clpt/models/resource_data.go

package models

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

type CygxResourceData struct {
	Id              int       `orm:"column(id);pk"`
	SourceId        int       `description:"资源ID"`
	Source          string    `description:"资源类型 报告 ：article 、图表 ：newchart、微路演 ：roadshow、活动 ：activity、活动视频：activityvideo、活动音频：activityvoice、专项调研活动：activityspecial"`
	Title           string    `description:"标题"`
	Annotation      string    `description:"核心观点"`
	CreateTime      time.Time `description:"创建时间"`
	PublishDate     string    `description:"发布时间"`
	Abstract        string    `description:"摘要"`
	SearchTag       string    `description:"搜索标签"`
	SearchTitle     string    `description:"搜索匹配用的标题"`
	SearchContent   string    `description:"搜索匹配用的内容"`
	SearchOrderTime string    `description:"搜索排序时间"`
}

type CygxResourceDataResp struct {
	Id                      int    `orm:"column(id);pk"`
	SourceId                int    `description:"资源ID"`
	Source                  string `description:"资源类型 报告 ：article 、图表 ：newchart、微路演 ：roadshow、活动 ：activity、活动视频：activityvideo、活动音频：activityvoice、专项调研活动：activityspecial"`
	Title                   string `description:"标题"`
	IsResearch              bool   `description:"是否属于研选"`
	BodyImg                 string `description:"文章封面图片"`
	Pv                      int    `description:"PV"`
	Annotation              string `description:"核心观点"`
	PublishDate             string `description:"发布时间"`
	Abstract                string `description:"摘要"`
	IsTop                   bool   `description:"是否置顶"`
	IsCollection            bool   `description:"是否收藏 "`
	BackgroundImg           string `description:"背景图"`
	City                    string `description:"城市"`
	IsSignup                int    `description:"是否已报名 1是 ，0 否"`
	IsAppointment           int    `description:"是否已预约纪要 1是 ，0 否"`
	IsCancelMeetingReminder int    `description:"是否添加了消息消息提醒   1是 ，0 否"`
	ActiveState             string `description:"活动进行状态 未开始：1、进行中2、已结束3"`
	ImgUrl                  string `description:"行业图片链接"`
	ImgUrlText              string `description:"活动类型图片链接"`
	ActivityType            int    `description:"活动线上线下类型 1线上，0 线下，2线下"`
	IsShowOutboundCall      bool   `description:"是否展示预约外呼"`
	IsShowMeetingReminder   bool   `description:"是否展示会议提醒"`
	IsShowHelpSsk           bool   `description:"是否展示帮我带问"`
	IsShowSignup            bool   `description:"是否展示我要报名"`
	IsShowAppointment       bool   `description:"是否展示预约纪要"`
	IsLimitPeople           int    `description:"是否限制人数 1是，0否"`
	IsShowDetails           bool   `description:"是否展示查看详情按钮"`
	YidongActivityUrl       string `description:"易董活动跳转地址"`
	IsYidongActivity        bool   `description:"是否属于易董同步过来的活动"`
	TripStatus              int    `description:"行程进行状态 1：预报名，2：确定行程"`
	IsTrip                  int    `description:"确定行程是否报名 1是 ，0 否"`
	ActivityTimeText        string `description:"活动预期时间带文字"`
	TripImgLink             string `description:"行程图片链接"`
	ChartPermissionId       int    `description:"权限id"`
	Expert                  string `description:"专家"`
	Speaker                 string `description:"主讲人"`
	DistinguishedGuest      string `description:"嘉宾"`
	ActivityTime            string `description:"活动预期时间"`
	ResourceUrl             string `description:"链接"`
	AuthInfo                *UserPermissionAuthInfo
	VoiceDetail             *CygxActivityVoiceReq      `description:"音频数据"`
	VideoDetail             *CygxActivityVideoListResp `description:"视频数据"`
	AudioLink               bool                       `description:"是否展示回放按钮"`
	FileType                int                        `description:"类型: 1-音频; 2-视频"`
	SignupType              int                        `description:"报名方式，1预约外呼，2自主拨入，3我要报名"`
	ActivityTypeId          int                        `description:"活动类型id"`
	IsYidongConduct         bool                       `description:"是否属于易董办会 1：是 、0：否"`
	IsCanOutboundCall       int                        `description:"是否提供外呼 1：是 、0：否"`
	TencentConferenceNumber string                     `description:"腾讯会议号"`
	IsResearchSpecial       bool                       `description:"是否属于特殊的研选"`
	IsExternalLabel         bool                       `description:"是否为外部资源"`
	IsResearchPoints        bool                       `description:"是否为研选扣点"`
	SiginupDeadline         string                     `description:"报名截止时间"`
}

type HomeResourceDataListResp struct {
	Paging *paging.PagingItem
	List   []*CygxResourceDataResp `description:"列表"`
}

// Source      string    `description:"资源类型 报告 ：article 、图表 ：newchart、微路演 ：roadshow、活动 ：activity、活动视频：activityvideo、活动音频：activityvoice、专项调研活动：activityspecial"`
type HomeResourceDataListNewResp struct {
	Paging *paging.PagingItem
	List   []*CygxResourceDataNewResp `description:"列表"`
}

type CygxResourceDataNewResp struct {
	Id                 int                                     `orm:"column(id);pk"`
	BodyHighlight      []string                                `description:"搜索高亮展示结果"`
	TitleHighlight     string                                  `description:"搜索高亮展示结果"`
	SourceId           int                                     `description:"资源ID"`
	Source             string                                  `description:"资源类型 报告 ：article 、图表 ：newchart、微路演 ：roadshow、活动 ：activity、活动视频：activityvideo、活动音频：activityvoice、专项调研活动：activityspecial"`
	PublishDate        string                                  `description:"发布时间"`
	Article            *ArticleListResp                        `description:"文章"`
	Newchart           *HomeChartListResp                      `description:"图表"`
	Roadshow           *MicroRoadShowPageList                  `description:"微路演"`
	Activity           *ActivityListResp                       `description:"活动"`
	Activityvideo      *MicroRoadShowPageList                  `description:"活动视频"`
	Activityvoice      *MicroRoadShowPageList                  `description:"活动音频"`
	Activityspecial    *CygxActivitySpecialDetail              `description:"专项调研活动"`
	Researchsummary    *CygxReportSelectionRep                 `description:"本周研究汇总"`
	Minutessummary     *CygxReportSelectionRep                 `description:"上周纪要汇总"`
	Meetingreviewchapt *CygxMorningMeetingGatherDetailListResp `description:"晨会精华"`
	ProductInterior    *CygxProductInteriorResp                `description:"产品内测"`
	IndustrialResource *IndustrialManagement                   `description:"产业资源包"`
	ReportSelection    *CygxReportSelectionRep                 `description:"重点公司（原报告精选）"`
	YanxuanSpecial     *CygxYanxuanSpecialItem                 `description:"研选专栏"`
	AskserieVideo      *MicroRoadShowPageList                  `description:"活动音频"`
}

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

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

// 获取用户报名成功数量
func GetResourceDataCount(condition string, pars []interface{}) (count int, err error) {
	sqlCount := `SELECT COUNT(1) AS count FROM cygx_resource_data    WHERE 1= 1 ` + condition
	o := orm.NewOrm()
	err = o.Raw(sqlCount, pars).QueryRow(&count)
	return
}

// 删除数据
func DeleteResourceData(sourceId int, source string) (err error) {
	o := orm.NewOrm()
	sql := ` DELETE FROM cygx_resource_data WHERE source_id = ? AND source =?  `
	_, err = o.Raw(sql, sourceId, source).Exec()
	return
}

// 获取数量
func GetCygxResourceDataBySourceAndIdCount(sourceId int, source string) (count int, err error) {
	o := orm.NewOrm()
	sqlCount := ` SELECT COUNT(1) AS count  FROM cygx_resource_data  WHERE  source_id = ? AND source =?  `
	err = o.Raw(sqlCount, sourceId, source).QueryRow(&count)
	return
}

// 添加
func AddCygxResourceData(item *CygxResourceData) (lastId int64, err error) {
	o := orm.NewOrm()
	lastId, err = o.Insert(item)
	return
}

// 修改
func UpdateResourceDataByItem(item *CygxResourceData) (err error) {
	o := orm.NewOrm()
	updateParams := make(map[string]interface{})
	updateParams["PublishDate"] = item.PublishDate
	updateParams["SearchTag"] = item.SearchTag
	ptrStructOrTableName := "cygx_resource_data"
	whereParam := map[string]interface{}{"source_id": item.SourceId, "source": item.Source}
	qs := o.QueryTable(ptrStructOrTableName)
	for expr, exprV := range whereParam {
		qs = qs.Filter(expr, exprV)
	}
	_, err = qs.Update(updateParams)
	if err != nil {
		return
	}
	return
}