resource_data.go 7.5 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123
  1. package models
  2. import (
  3. "github.com/beego/beego/v2/client/orm"
  4. "github.com/rdlucklib/rdluck_tools/paging"
  5. "time"
  6. )
  7. type CygxResourceData struct {
  8. Id int `orm:"column(id);pk"`
  9. SourceId int `description:"资源ID"`
  10. Source string `description:"资源类型 报告 :article 、图表 :newchart、微路演 :roadshow、活动 :activity、活动视频:activityvideo、活动音频:activityvoice、专项调研活动:activityspecial"`
  11. Title string `description:"标题"`
  12. Annotation string `description:"核心观点"`
  13. CreateTime time.Time `description:"创建时间"`
  14. PublishDate string `description:"发布时间"`
  15. Abstract string `description:"摘要"`
  16. }
  17. type CygxResourceDataResp struct {
  18. Id int `orm:"column(id);pk"`
  19. SourceId int `description:"资源ID"`
  20. Source string `description:"资源类型 报告 :article 、图表 :newchart、微路演 :roadshow、活动 :activity、活动视频:activityvideo、活动音频:activityvoice、专项调研活动:activityspecial"`
  21. Title string `description:"标题"`
  22. IsResearch bool `description:"是否属于研选"`
  23. BodyImg string `description:"文章封面图片"`
  24. Pv int `description:"PV"`
  25. Annotation string `description:"核心观点"`
  26. PublishDate string `description:"发布时间"`
  27. Abstract string `description:"摘要"`
  28. IsTop bool `description:"是否置顶"`
  29. IsCollection bool `description:"是否收藏 "`
  30. BackgroundImg string `description:"背景图"`
  31. City string `description:"城市"`
  32. IsSignup int `description:"是否已报名 1是 ,0 否"`
  33. IsAppointment int `description:"是否已预约纪要 1是 ,0 否"`
  34. IsCancelMeetingReminder int `description:"是否添加了消息消息提醒 1是 ,0 否"`
  35. ActiveState string `description:"活动进行状态 未开始:1、进行中2、已结束3"`
  36. ImgUrl string `description:"行业图片链接"`
  37. ImgUrlText string `description:"活动类型图片链接"`
  38. ActivityType int `description:"活动线上线下类型 1线上,0 线下,2线下"`
  39. IsShowOutboundCall bool `description:"是否展示预约外呼"`
  40. IsShowMeetingReminder bool `description:"是否展示会议提醒"`
  41. IsShowHelpSsk bool `description:"是否展示帮我带问"`
  42. IsShowSignup bool `description:"是否展示我要报名"`
  43. IsShowAppointment bool `description:"是否展示预约纪要"`
  44. IsLimitPeople int `description:"是否限制人数 1是,0否"`
  45. IsShowDetails bool `description:"是否展示查看详情按钮"`
  46. YidongActivityUrl string `description:"易董活动跳转地址"`
  47. TripStatus int `description:"行程进行状态 1:预报名,2:确定行程"`
  48. IsTrip int `description:"确定行程是否报名 1是 ,0 否"`
  49. ActivityTimeText string `description:"活动预期时间带文字"`
  50. TripImgLink string `description:"行程图片链接"`
  51. ChartPermissionId int `description:"权限id"`
  52. Expert string `description:"专家"`
  53. Speaker string `description:"主讲人"`
  54. DistinguishedGuest string `description:"嘉宾"`
  55. ActivityTime string `description:"活动预期时间"`
  56. ResourceUrl string `description:"链接"`
  57. AuthInfo *UserPermissionAuthInfo
  58. VoiceDetail *CygxActivityVoiceReq `description:"音频数据"`
  59. VideoDetail *CygxActivityVideoListResp `description:"视频数据"`
  60. AudioLink bool `description:"是否展示回放按钮"`
  61. FileType int `description:"类型: 1-音频; 2-视频"`
  62. SignupType int `description:"报名方式,1预约外呼,2自主拨入,3我要报名"`
  63. ActivityTypeId int `description:"活动类型id"`
  64. IsYidongConduct bool `description:"是否属于易董办会 1:是 、0:否"`
  65. IsCanOutboundCall int `description:"是否提供外呼 1:是 、0:否"`
  66. TencentConferenceNumber string `description:"腾讯会议号"`
  67. IsResearchSpecial bool `description:"是否属于特殊的研选"`
  68. IsExternalLabel bool `description:"是否为外部资源"`
  69. IsResearchPoints bool `description:"是否为研选扣点"`
  70. SiginupDeadline string `description:"报名截止时间"`
  71. }
  72. type HomeResourceDataListResp struct {
  73. Paging *paging.PagingItem
  74. List []*CygxResourceDataResp `description:"列表"`
  75. }
  76. // Source string `description:"资源类型 报告 :article 、图表 :newchart、微路演 :roadshow、活动 :activity、活动视频:activityvideo、活动音频:activityvoice、专项调研活动:activityspecial"`
  77. type HomeResourceDataListNewResp struct {
  78. Paging *paging.PagingItem
  79. List []*CygxResourceDataNewResp `description:"列表"`
  80. }
  81. type CygxResourceDataNewResp struct {
  82. Id int `orm:"column(id);pk"`
  83. SourceId int `description:"资源ID"`
  84. Source string `description:"资源类型 报告 :article 、图表 :newchart、微路演 :roadshow、活动 :activity、活动视频:activityvideo、活动音频:activityvoice、专项调研活动:activityspecial"`
  85. PublishDate string `description:"发布时间"`
  86. Article *ArticleListResp `description:"文章"`
  87. Newchart *HomeChartListResp `description:"图表"`
  88. Roadshow *MicroRoadShowPageList `description:"微路演"`
  89. Activity *ActivityListResp `description:"活动"`
  90. Activityvideo *MicroRoadShowPageList `description:"活动视频"`
  91. Activityvoice *MicroRoadShowPageList `description:"活动音频"`
  92. Activityspecial *CygxActivitySpecialDetail `description:"专项调研活动"`
  93. Researchsummary *CygxReportSelectionRep `description:"本周研究汇总"`
  94. Minutessummary *CygxReportSelectionRep `description:"上周纪要汇总"`
  95. Meetingreviewchapt *CygxMorningMeetingGatherDetailListResp `description:"晨会精华"`
  96. ProductInterior *CygxProductInteriorResp `description:"产品内测"`
  97. }
  98. // 列表
  99. func GetResourceDataList(condition string, pars []interface{}, startSize, pageSize int) (items []*CygxResourceDataNewResp, err error) {
  100. o := orm.NewOrm()
  101. sql := `SELECT * FROM cygx_resource_data WHERE 1= 1 `
  102. if condition != "" {
  103. sql += condition
  104. }
  105. sql += ` ORDER BY publish_date DESC , id DESC LIMIT ?,? `
  106. _, err = o.Raw(sql, pars, startSize, pageSize).QueryRows(&items)
  107. return
  108. }
  109. // 获取用户报名成功数量
  110. func GetResourceDataCount(condition string, pars []interface{}) (count int, err error) {
  111. sqlCount := `SELECT COUNT(1) AS count FROM cygx_resource_data WHERE 1= 1 ` + condition
  112. o := orm.NewOrm()
  113. err = o.Raw(sqlCount, pars).QueryRow(&count)
  114. return
  115. }