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:"摘要"`
}

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:"标题"`
	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:"是否展示预约纪要"`
	IsShowDetails           bool   `description:"是否展示查看详情按钮"`
	YidongActivityUrl       string `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:"主讲人"`
	ActivityTime            string `description:"活动预期时间"`
	ResourceUrl             string `description:"链接"`
	AuthInfo                *UserPermissionAuthInfo
	VoiceDetail             *CygxActivityVoiceReq      `description:"音频数据"`
	VideoDetail             *CygxActivityVideoListResp `description:"视频数据"`
	AudioLink               bool                       `description:"是否展示回放按钮"`
	FileType                int                        `description:"类型: 1-音频; 2-视频"`
}

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

//列表
func GetResourceDataList(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 publish_date  DESC ,  id  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
}