activity.go 34 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642
  1. package models
  2. import (
  3. "github.com/beego/beego/v2/client/orm"
  4. "github.com/rdlucklib/rdluck_tools/paging"
  5. "strings"
  6. "time"
  7. )
  8. // 活动详情
  9. type CygxActivity struct {
  10. ActivityId int `orm:"column(activity_id);pk";description:"活动ID 等于0新增活动,大于0修改活动"`
  11. ActivityTypeId int `description:"活动类型id"`
  12. ActivityTypeName string `description:"活动类型名称"`
  13. ChartPermissionId int `description:"行业id"`
  14. ChartPermissionName string `description:"行业名称"`
  15. ChartPermissionNames string `description:"行业名称辅助字段,区分研选子分类"`
  16. Body string `description:"内容"`
  17. CreateTime time.Time `description:"创建时间"`
  18. PublishDate time.Time `description:"发布时间"`
  19. IsLimitPeople int `description:"是否限制人数 1是,0否"`
  20. LimitPeopleNum int `description:"限制的人数数量"`
  21. CustomerTypeIds string `description:"活动可见的客户类型,多个ID用 , 隔开"`
  22. PublishStatus int `description:"发布状态 1已发布,0未发布"`
  23. LastUpdatedTime time.Time `description:"更新时间"`
  24. ActivityTime string `description:"活动时间"`
  25. ActivityTimeText string `description:"活动时间带文字"`
  26. DistinguishedGuest string `description:"嘉宾"`
  27. Host string `description:"主持人"`
  28. MainlandTell string `description:"大陆拨入号"`
  29. HongKongTell string `description:"香港拨入号"`
  30. TaiwanTell string `description:"台湾拨入号"`
  31. AmericaTell string `description:"美国拨入号"`
  32. ParticipationCode string `description:"参会密码"`
  33. Theme string `description:"主题"`
  34. Expert string `description:"专家"`
  35. ActivityName string `description:"活动名称"`
  36. ActivityNameTask string `description:"活动名称定时任务同步的时候使用"`
  37. OnlineParticipation string `description:"网络参会"`
  38. ReportLink string `description:"报告链接"`
  39. City string `description:"城市"`
  40. Address string `description:"活动地址"`
  41. Highlights string `description:"活动亮点"`
  42. Remarks string `description:"备注"`
  43. Speaker string `description:"主讲人"`
  44. ArticleId int `description:"关联报告id"`
  45. Label string `description:"标签"`
  46. LinkParticipants string `description:"链接参会"`
  47. AppAttendance string `description:"App参会"`
  48. ConferencePassword string `description:"会议密码"`
  49. TemporaryLabel string `description:"临时标签"`
  50. IsMakerShow int `description:"是否仅决策人可见 0,否 、1,是"`
  51. VisibleRange int `description:"可见范围 1,仅本组可见 、2,全部客户可见"`
  52. Scale string `description:"管理规模,空不填,1::50亿以下,2:50~100亿,3:100亿以上。多个用, 隔开"`
  53. IsShowSubjectName int `description:"小程序内是否展示标的名称 1是 ,0 否 默认0 "`
  54. IsHideAppointment int `description:"是否隐藏预约纪要按钮 1是 ,0 否 默认0 "`
  55. AdminId int `description:"销售/管理员ID"`
  56. AdminName string `description:"销售/管理员姓名"`
  57. IsCanAppointmentMinutes int `description:"是否可预约纪要 1是 ,0 否 默认0 "`
  58. YidongActivityId string `description:"易董活动ID"`
  59. IsExternalLabel int `description:"是否为外部资源 1是,0否"`
  60. IsResearchPoints int `description:"是否为研选扣点"`
  61. }
  62. // 活动详情
  63. type ActivityDetail struct {
  64. ActivityId int `orm:"column(activity_id);pk";description:"活动ID "`
  65. ActivityTypeId int `description:"活动类型id"`
  66. ActivityTypeName string `description:"活动类型名称"`
  67. ChartPermissionId int `description:"行业id"`
  68. ChartPermissionName string `description:"行业名称"`
  69. ChartPermissionNames string `description:"行业名称辅助字段,区分研选子分类"`
  70. Body string `description:"内容"`
  71. CreateTime string `description:"创建时间"`
  72. IsLimitPeople int `description:"是否限制人数 1是,0否"`
  73. LimitPeopleNum int `description:"限制的人数数量"`
  74. LastUpdatedTime string `description:"更新时间"`
  75. ActivityTime string `description:"活动时间"`
  76. ActivityTimeText string `description:"活动时间带文字"`
  77. DistinguishedGuest string `description:"嘉宾"`
  78. Host string `description:"主持人"`
  79. Speaker string `description:"主讲人"`
  80. MainlandTell string `description:"大陆拨入号"`
  81. HongKongTell string `description:"香港拨入号"`
  82. TaiwanTell string `description:"台湾拨入号"`
  83. AmericaTell string `description:"美国拨入号"`
  84. ParticipationCode string `description:"参会密码"`
  85. Theme string `description:"主题"`
  86. Expert string `description:"专家"`
  87. ActivityName string `description:"活动名称"`
  88. OnlineParticipation string `description:"网络参会"`
  89. ReportLink string `description:"报告链接"`
  90. City string `description:"城市"`
  91. Address string `description:"活动地址"`
  92. Highlights string `description:"活动亮点"`
  93. Remarks string `description:"备注"`
  94. ShowType string `description:"人数限制类型,1不展示限制,2可选限制,3强制限制"`
  95. IsSignup int `description:"是否已报名 1是 ,0 否"`
  96. IsAppointment int `description:"是否已预约纪要 1是 ,0 否"`
  97. SignupNum int `description:"已报名人数"`
  98. SignupType int `description:"报名方式,1预约外呼,2自主拨入,3我要报名"`
  99. ActiveState string `description:"活动进行状态 未开始:1、进行中2、已结束3"`
  100. IsCancelMeetingReminder int `description:"是否取消会议提醒 1展示取消会议提醒 ,0展示会议提醒"`
  101. ArticleId int `description:"报告id(报告链接跳转使用)"`
  102. CustomerTypeIds string `description:"活动可见的客户类型,多个ID用 , 隔开"`
  103. IsShowSustainable bool `description:"是否展示限免标签"`
  104. Description string `description:"研选内容说明"`
  105. IsResearch bool `description:"是否属于研选"`
  106. LinkParticipants string `description:"链接参会"`
  107. AppAttendance string `description:"App参会"`
  108. ConferencePassword string `description:"会议密码"`
  109. Scale string `description:"管理规模,空不填,1::50亿以下,2:50~100亿,3:100亿以上。多个用, 隔开"`
  110. IsShowAppointment bool `description:"是否展示预约纪要"`
  111. IsHideAppointment int `description:"是否隐藏预约纪要按钮 1是,0 否"`
  112. IsCClassMeeting bool `description:"是否是c类电话会"`
  113. ArticleList []*ActivityArticleResp // 下面是列表添加的部分结构体
  114. IsBrackets int `description:"是否有方括号 1是 ,0 否"`
  115. Label string `description:"主题标签"`
  116. ImgUrl string `description:"图片链接"`
  117. ImgUrlText string `description:"图片链接文字"`
  118. ActivityType int `description:"活动线上线下类型 1线上,0 线下"`
  119. JmcjRoadshowTitle string `description:"进门财经手动匹配的活动名称"`
  120. Listndustrial []*IndustrialManagementRep `description:"活动关联的产业信息"`
  121. IsShowOutboundCall bool `description:"是否展示预约外呼"`
  122. IsShowMeetingReminder bool `description:"是否展示会议提醒"`
  123. IsShowHelpSsk bool `description:"是否展示帮我带问"`
  124. IsShowSignup bool `description:"是否展示我要报名"`
  125. IsShowDetails bool `description:"是否展示查看详情按钮"`
  126. TemporaryLabel string `description:"临时标签"`
  127. IsCanAppointmentMinutes int `description:"是否可预约纪要 1是 ,0 否 默认0 "`
  128. YidongActivityId string `description:"易董活动ID"`
  129. IsYidongActivity bool `description:"是否属于易董同步过来的活动"`
  130. YidongActivityUrl string `description:"易董活动跳转地址"`
  131. AudioLink bool `description:"是否展示回放按钮"`
  132. VoiceList *CygxActivityVoiceReq `description:"音频数据"`
  133. AdminId int `description:"管理员、销售ID "`
  134. IsMakerShow int `description:"是否仅决策人可见 0,否 、1,是"`
  135. VisibleRange int `description:"可见范围 1,仅本组可见 、2,全部客户可见"`
  136. VideoDetail *CygxActivityVideoListResp `description:"视频数据"`
  137. FileType int `description:"类型: 1-音频; 2-视频"`
  138. SourceType int `description:"活动来源。 1:活动 、2:专项产业调研"`
  139. TripImgLink string `description:"专项产业调研行程链接"`
  140. ActivityTimeEnd string `description:"专项产业调研活动预期结束时间"`
  141. AuthInfo *UserPermissionAuthInfo `description:"用户查看视频的权限"`
  142. Days int `description:"调研天数"`
  143. Title string `description:"标题"`
  144. IsYidongConduct bool `description:"是否属于易董办会 1:是 、0:否"`
  145. IsCanOutboundCall int `description:"是否提供外呼 1:是 、0:否"`
  146. TencentConferenceNumber string `description:"腾讯会议号"`
  147. IsResearchSpecial bool `description:"是否属于特殊的研选"`
  148. IsNeedEmail int `description:"是否需要提供邮箱 1是,0否"`
  149. SiginupDeadline string `description:"报名截止时间"`
  150. IsExternalLabel bool `description:"是否为外部资源"`
  151. IsResearchPoints bool `description:"是否为研选扣点"`
  152. CancelDeadline string `description:"取消报名截止时间"`
  153. ChartPermissionNameDeputy string `description:"副行业名称"`
  154. TopTime int `description:"置顶时间"`
  155. }
  156. // 活动详情
  157. type ActivityListResp struct {
  158. ActivityId int `description:"活动ID "`
  159. ActivityTypeId int `description:"活动类型id"`
  160. ActivityTypeName string `description:"活动类型名称"`
  161. ChartPermissionId int `description:"行业id"`
  162. ChartPermissionName string `description:"行业名称"`
  163. IsLimitPeople int `description:"是否限制人数 1是,0否"`
  164. LimitPeopleNum int `description:"限制的人数数量"`
  165. LastUpdatedTime string `description:"更新时间"`
  166. ActivityTime string `description:"活动时间"`
  167. ActivityTimeText string `description:"活动时间带文字"`
  168. DistinguishedGuest string `description:"嘉宾"`
  169. Host string `description:"主持人"`
  170. Speaker string `description:"主讲人"`
  171. MainlandTell string `description:"大陆拨入号"`
  172. HongKongTell string `description:"香港拨入号"`
  173. TaiwanTell string `description:"台湾拨入号"`
  174. AmericaTell string `description:"美国拨入号"`
  175. ParticipationCode string `description:"参会密码"`
  176. Theme string `description:"主题"`
  177. Expert string `description:"专家"`
  178. ActivityName string `description:"活动名称"`
  179. OnlineParticipation string `description:"网络参会"`
  180. ReportLink string `description:"报告链接"`
  181. LinkParticipants string `description:"链接参会"`
  182. AppAttendance string `description:"App参会"`
  183. ConferencePassword string `description:"会议密码"`
  184. City string `description:"城市"`
  185. Address string `description:"活动地址"`
  186. Highlights string `description:"活动亮点"`
  187. Remarks string `description:"备注"`
  188. IsSignup int `description:"是否已报名 1是 ,0 否"`
  189. SignupNum int `description:"已报名人数"`
  190. IsAppointment int `description:"是否已预约纪要 1是 ,0 否"`
  191. IsCancelMeetingReminder int `description:"是否添加了消息消息提醒 1是 ,0 否"`
  192. ActiveState string `description:"活动进行状态 未开始:1、进行中2、已结束3"`
  193. IsShowSustainable bool `description:"是否展示限免标签"`
  194. Description string `description:"研选内容说明"`
  195. IsResearch bool `description:"是否属于研选"`
  196. IsHideAppointment int `description:"是否隐藏预约纪要按钮 1是,0 否"`
  197. IsCClassMeeting bool `description:"是否是c类电话会"`
  198. Label string `description:"主题标签"`
  199. ImgUrl string `description:"行业图片链接"`
  200. ImgUrlText string `description:"活动类型图片链接"`
  201. ActivityType int `description:"活动线上线下类型 1线上,0 线下"`
  202. IsShowOutboundCall bool `description:"是否展示预约外呼"`
  203. IsShowMeetingReminder bool `description:"是否展示会议提醒"`
  204. IsShowHelpSsk bool `description:"是否展示帮我带问"`
  205. IsShowSignup bool `description:"是否展示我要报名"`
  206. IsShowAppointment bool `description:"是否展示预约纪要"`
  207. IsShowDetails bool `description:"是否展示查看详情按钮"`
  208. AudioLink bool `description:"是否展示回放按钮"`
  209. VoiceDetail *CygxActivityVoiceReq `description:"音频数据"`
  210. VideoDetail *CygxActivityVideoListResp `description:"视频数据"`
  211. FileType int `description:"类型: 1-音频; 2-视频"`
  212. SourceType int `description:"活动来源。 1:活动 、2:专项产业调研"`
  213. YidongActivityUrl string `description:"易董活动跳转地址"`
  214. ArticleList []*ActivityArticleResp
  215. Listndustrial []*IndustrialManagementRep `description:"活动关联的产业信息"`
  216. AuthInfo *UserPermissionAuthInfo `description:"用户查看视频的权限"`
  217. Explain string `description:"活动右上角提示"`
  218. TripImgLink string `description:"专项产业调研行程链接"`
  219. IsTrip int `description:"是否报名 1是 ,0 否"`
  220. TripStatus int `description:"行程进行状态 1:预报名,2:确定行程"`
  221. Days int `description:"调研天数"`
  222. SignupType int `description:"报名方式,1预约外呼,2自主拨入,3我要报名"`
  223. IsYidongConduct bool `description:"是否属于易董办会 1:是 、0:否"`
  224. IsCanOutboundCall int `description:"是否提供外呼 1:是 、0:否"`
  225. TencentConferenceNumber string `description:"腾讯会议号"`
  226. IsResearchSpecial bool `description:"是否属于特殊的研选"`
  227. IsExternalLabel bool `description:"是否为外部资源"`
  228. IsResearchPoints bool `description:"是否为研选扣点"`
  229. SiginupDeadline string `description:"报名截止时间"`
  230. CancelDeadline string `description:"取消报名截止时间"`
  231. IsYidongActivity bool `description:"是否属于易董同步过来的活动"`
  232. TopTime int `description:"置顶时间"`
  233. }
  234. type ActivityCheck struct {
  235. CheckPermission bool `description:"权限是否通过校验"`
  236. HasPermission int `description:"操作方式,1:有该行业权限,正常展示,2:无该行业权限,3:潜在客户,未提交过申请,4:潜在客户,已提交过申请"`
  237. PopupMsg string `description:"权限弹窗信息"`
  238. CancelPopupMsg string `description:"取消报名时间弹窗信息"`
  239. SellerMobile string `description:"销售电话"`
  240. SellerName string `description:"销售姓名"`
  241. Mobile string `description:"手机号"`
  242. IsResearch bool `description:"是否属于研选"`
  243. IsResearchSpecial bool `description:"是否属于特殊的研选"`
  244. CheckTime bool `description:"时间是否通过校验"`
  245. CheckEmail bool `description:"邮箱是否通过校验"`
  246. CheckPoints bool `description:"扣点是否通过校验"`
  247. CompanyPoints string `description:"公司剩余点数"`
  248. ActivityPoints string `description:"本场活动要扣除的点数"`
  249. }
  250. type ActivityArticleResp struct {
  251. ReportLink string `description:"报告链接"`
  252. Title string `description:"报告标题"`
  253. ArticleId int `description:"报告id(报告链接跳转使用)"`
  254. }
  255. type CygxActivityResp struct {
  256. HasPermission int `description:"1:有该行业权限,正常展示,2:无该行业权限,不存在权益客户下(ficc),3:无该品类权限,已提交过申请,4:无该品类权限,未提交过申请,5:潜在客户,未提交过申请,6:潜在客户,已提交过申请"`
  257. PopupMsg string `description:"权限弹窗信息"`
  258. SellerMobile string `description:"销售电话"`
  259. SellerName string `description:"销售姓名"`
  260. IsResearch bool `description:"是否属于研选"`
  261. IsResearchSpecial bool `description:"是否属于特殊的研选"`
  262. Detail *ActivityListResp
  263. }
  264. type CygxYidongActivityUrlResp struct {
  265. HasPermission int `description:"1:有该行业权限,正常展示,2:无该行业权限,不存在权益客户下(ficc),3:无该品类权限,已提交过申请,4:无该品类权限,未提交过申请,5:潜在客户,未提交过申请,6:潜在客户,已提交过申请"`
  266. PopupMsg string `description:"权限弹窗信息"`
  267. SellerMobile string `description:"销售电话"`
  268. SellerName string `description:"销售姓名"`
  269. IsResearch bool `description:"是否属于研选"`
  270. IsResearchSpecial bool `description:"是否属于特殊的研选"`
  271. YidongActivityUrl string `description:"易董活动跳转地址"`
  272. }
  273. // 列表
  274. func GetCygxActivityList(condition string, pars []interface{}, sortTime string, startSize, pageSize int) (items []*CygxActivity, err error) {
  275. o := orm.NewOrm()
  276. sql := `SELECT activity_id,chart_permission_id, city, label,temporary_label,is_show_subject_name, MAX( art.activity_time ) AS timesort, MIn( art.activity_time ) AS mintimesort , yidong_activity_id , activity_type_id,is_external_label,is_research_points
  277. FROM cygx_activity as art WHERE 1= 1 `
  278. if condition != "" {
  279. sql += condition
  280. }
  281. sql += ` GROUP BY art.activity_id ORDER BY ` + sortTime + ` ,art.activity_id DESC LIMIT ?,? `
  282. _, err = o.Raw(sql, pars, startSize, pageSize).QueryRows(&items)
  283. return
  284. }
  285. // 通过纪要ID获取活动详情
  286. func GetAddActivityInfoById(ActivityId int) (item *ActivityDetail, err error) {
  287. o := orm.NewOrm()
  288. sql := `SELECT * FROM cygx_activity WHERE activity_id=? AND publish_status = 1 `
  289. err = o.Raw(sql, ActivityId).QueryRow(&item)
  290. return
  291. }
  292. // 获取数量
  293. func GetActivityCount(condition string, playBack int, pars []interface{}, filter int) (count int, err error) {
  294. var sqlJiontable string
  295. if playBack == 1 {
  296. //sqlJiontable = ` INNER JOIN cygx_activity_voice AS ac ON ac.activity_id = art.activity_id `
  297. }
  298. if filter == 1 {
  299. sqlJiontable = ` INNER JOIN cygx_activity_video AS av ON av.activity_id = art.activity_id `
  300. } else if filter == 2 {
  301. sqlJiontable = ` INNER JOIN cygx_activity_voice AS ac ON ac.activity_id = art.activity_id `
  302. }
  303. sqlCount := ` SELECT COUNT(1) AS count FROM cygx_activity as art ` + sqlJiontable + ` WHERE 1= 1 `
  304. if condition != "" {
  305. sqlCount += condition
  306. }
  307. o := orm.NewOrm()
  308. err = o.Raw(sqlCount, pars).QueryRow(&count)
  309. return
  310. }
  311. func GetActivityListNew(condition string, pars []interface{}, uid, startSize, pageSize, playBack, filter int, typeName string) (items []*ActivityDetail, err error) {
  312. var sqlJiontable string
  313. if playBack == 1 {
  314. //sqlJiontable = ` INNER JOIN cygx_activity_voice AS ac ON ac.activity_id = art.activity_id `
  315. }
  316. if filter == 1 {
  317. sqlJiontable = ` INNER JOIN cygx_activity_video AS av ON av.activity_id = art.activity_id `
  318. } else if filter == 2 {
  319. sqlJiontable = ` INNER JOIN cygx_activity_voice AS ac ON ac.activity_id = art.activity_id `
  320. }
  321. o := orm.NewOrm()
  322. sql := `SELECT art.* ,t.activity_type,t.img_url_text,1 AS source_type,
  323. ( SELECT COUNT( 1 ) FROM cygx_activity_signup AS s WHERE s.activity_id = art.activity_id AND s.user_id = ? AND s.is_cancel = 0 AND s.do_fail_type = 0) AS is_signup,
  324. ( SELECT COUNT( DISTINCT user_id ) FROM cygx_activity_signup AS s WHERE s.activity_id = art.activity_id AND s.is_cancel = 0 AND s.do_fail_type = 0) AS signup_num,
  325. ( SELECT COUNT( 1 ) FROM cygx_activity_meeting_reminder AS m WHERE m.activity_id = art.activity_id AND m.user_id = ? AND m.is_cancel = 0 ) AS is_cancel_meeting_reminder,
  326. ( SELECT COUNT( 1 ) FROM cygx_activity_appointment AS ap WHERE ap.activity_id = art.activity_id AND ap.user_id = ? ) AS is_appointment
  327. FROM cygx_activity as art
  328. INNER JOIN cygx_activity_type as t ON t.activity_type_id = art.activity_type_id ` + sqlJiontable + ` WHERE 1= 1 `
  329. if condition != "" {
  330. sql += condition
  331. }
  332. sql += ` LIMIT ?,?`
  333. if typeName != "" {
  334. typeSlice := strings.Split(typeName, ",")
  335. tempCondition := ""
  336. for _, s := range typeSlice {
  337. if s == "1" {
  338. tempCondition += "'专家电话会',"
  339. } else if s == "2" {
  340. tempCondition += "'分析师电话会',"
  341. } else if s == "1,2" {
  342. tempCondition += "'专家电话会','分析师电话会',"
  343. }
  344. }
  345. tempCondition = strings.TrimRight(tempCondition, ",")
  346. sql = `SELECT * FROM(` + sql + `) AS t WHERE t.activity_type_name IN (` + tempCondition + `)`
  347. }
  348. _, err = o.Raw(sql, uid, uid, uid, pars, startSize, pageSize).QueryRows(&items)
  349. return
  350. }
  351. // 列表
  352. func GetActivityListHomeNew(condition string, startSize, pageSize int) (items []*ActivityDetail, err error) {
  353. o := orm.NewOrm()
  354. sql := `SELECT activity_id
  355. FROM cygx_activity as art
  356. INNER JOIN cygx_activity_type as t ON t.activity_type_id = art.activity_type_id WHERE 1= 1 `
  357. if condition != "" {
  358. sql += condition
  359. }
  360. sql += ` LIMIT ?,?`
  361. _, err = o.Raw(sql, startSize, pageSize).QueryRows(&items)
  362. return
  363. }
  364. type GetCygxActivityListRep struct {
  365. Paging *paging.PagingItem `description:"分页数据"`
  366. List []*ActivityListResp
  367. Label string `description:"主题"`
  368. ImgUrl string `description:"图片路径"`
  369. IsResearch bool `description:"是否属于研选"`
  370. IsJump bool `description:"是否跳转"`
  371. IndustrialManagementId int `description:"产业ID"`
  372. IndustryNewLabel bool `description:"产业是否新标签"`
  373. ChartPermissionId int `description:"权限id"`
  374. IsShowResearchPoints bool `description:"是否展示研选扣点搜索"`
  375. }
  376. type GetCygxActivityListSearchResp struct {
  377. Paging *paging.PagingItem `description:"分页数据"`
  378. List []*ActivityDetail
  379. Label string `description:"主题"`
  380. ImgUrl string `description:"图片路径"`
  381. IsResearch bool `description:"是否属于研选"`
  382. IsJump bool `description:"是否跳转"`
  383. IndustrialManagementId int `description:"产业ID"`
  384. IndustryNewLabel bool `description:"产业是否新标签"`
  385. ChartPermissionId int `description:"权限id"`
  386. }
  387. // 通过纪要ID获取活动详情
  388. func GetAddActivityInfoByIdShow(uid, ActivityId int) (item *ActivityDetail, err error) {
  389. o := orm.NewOrm()
  390. sql := `SELECT *,( SELECT COUNT( 1 ) FROM cygx_activity_signup AS s WHERE s.activity_id = a.activity_id AND s.user_id = ? AND s.is_cancel = 0 AND s.do_fail_type = 0) AS is_signup,
  391. ( SELECT COUNT( DISTINCT user_id ) FROM cygx_activity_signup AS s WHERE s.activity_id = a.activity_id AND s.is_cancel = 0 AND s.do_fail_type = 0) AS signup_num,
  392. ( SELECT COUNT( 1 ) FROM cygx_activity_meeting_reminder AS m WHERE m.activity_id = a.activity_id AND m.user_id = ? AND m.is_cancel = 0 ) AS is_cancel_meeting_reminder,
  393. ( SELECT COUNT( 1 ) FROM cygx_activity_appointment AS ap WHERE ap.activity_id = a.activity_id AND ap.user_id = ? ) AS is_appointment
  394. FROM cygx_activity AS a WHERE activity_id=? AND publish_status = 1 `
  395. err = o.Raw(sql, uid, uid, uid, ActivityId).QueryRow(&item)
  396. return
  397. }
  398. // GetActivitySpecialSearcheList 活动与专项调研的搜索
  399. func GetActivitySpecialSearcheList(condition string, pars []interface{}, conditionSpecil string, parsSpecil []interface{}, startSize, pageSize int) (items []*ActivityDetail, total int, err error) {
  400. o := orm.NewOrm()
  401. sql := `SELECT
  402. art.activity_id,
  403. art.activity_time_text,
  404. art.activity_name,
  405. art.chart_permission_id,
  406. art.active_state,
  407. t.activity_type,
  408. art.chart_permission_name,
  409. art.distinguished_guest,
  410. art.expert,
  411. art.speaker,
  412. "" AS trip_img_link,
  413. "" AS activity_time_end,
  414. art.yidong_activity_id,
  415. art.is_can_appointment_minutes,
  416. art.activity_type_id,
  417. art.limit_people_num,
  418. art.is_limit_people,
  419. 1 AS source_type,
  420. t.img_url_text,
  421. art.is_yidong_conduct,
  422. art.is_can_outbound_call,
  423. art.city,
  424. art.is_research_points,
  425. art.siginup_deadline,
  426. art.cancel_deadline,
  427. art.activity_time
  428. FROM
  429. cygx_activity AS art
  430. INNER JOIN cygx_activity_type AS t ON t.activity_type_id = art.activity_type_id
  431. WHERE
  432. 1 = 1 `
  433. if condition != `` {
  434. sql += condition
  435. }
  436. sql += ` UNION ALL
  437. SELECT
  438. art.activity_id,
  439. art.activity_time_text_by_day AS activity_time_text,
  440. art.research_theme AS activity_name,
  441. art.chart_permission_id,
  442. "",
  443. art.special_type AS activity_type,
  444. art.chart_permission_name,
  445. "",
  446. "",
  447. "",
  448. art.trip_img_link_fix AS trip_img_link,
  449. art.activity_time_end,
  450. "",
  451. "",
  452. "",
  453. "",
  454. "",
  455. 2 AS source_type,
  456. "",
  457. "",
  458. "",
  459. "",
  460. "",
  461. "",
  462. "",
  463. art.activity_time
  464. FROM
  465. cygx_activity_special AS art
  466. WHERE
  467. 1 = 1 `
  468. if conditionSpecil != "" {
  469. sql += conditionSpecil
  470. }
  471. totalSql := `SELECT COUNT(1) total FROM (` + sql + `) z `
  472. err = o.Raw(totalSql, pars, parsSpecil).QueryRow(&total)
  473. if err != nil {
  474. return
  475. }
  476. sql += ` ORDER BY activity_time DESC LIMIT ?,?`
  477. _, err = o.Raw(sql, pars, parsSpecil, startSize, pageSize).QueryRows(&items)
  478. return
  479. }
  480. // 获取我的日程数量
  481. func GetScheduleCount(condition string, uid int) (count int, err error) {
  482. o := orm.NewOrm()
  483. sqlCount := `SELECT COUNT( 1 ) AS count
  484. FROM cygx_my_schedule AS m
  485. INNER JOIN cygx_activity AS art ON art.activity_id = m.activity_id
  486. WHERE
  487. user_id = ?`
  488. if condition != "" {
  489. sqlCount += condition
  490. }
  491. err = o.Raw(sqlCount, uid).QueryRow(&count)
  492. return
  493. }
  494. // 获取我的日程数量
  495. func GetSpecialScheduleCount(uid int) (count int, err error) {
  496. o := orm.NewOrm()
  497. sqlCount := `
  498. SELECT COUNT( 1 ) AS count FROM
  499. cygx_activity_special AS art
  500. INNER JOIN cygx_activity_special_trip AS my ON my.activity_id = art.activity_id
  501. WHERE
  502. 1 = 1 AND my.user_id = ? AND my.is_cancel = 0`
  503. err = o.Raw(sqlCount, uid).QueryRow(&count)
  504. return
  505. }
  506. // 我的日程列表
  507. func GetScheduleList(condition string, pars []interface{}, uid, startSize, pageSize int) (items []*ActivityDetail, err error) {
  508. o := orm.NewOrm()
  509. sql := `SELECT art.*,t.activity_type,t.img_url_text,
  510. ( SELECT COUNT( 1 ) FROM cygx_activity_signup AS s WHERE s.activity_id = art.activity_id AND s.user_id = ? AND s.is_cancel = 0 AND s.do_fail_type = 0) AS is_signup,
  511. ( SELECT COUNT( DISTINCT user_id ) FROM cygx_activity_signup AS s WHERE s.activity_id = art.activity_id AND s.is_cancel = 0 AND s.do_fail_type = 0) AS signup_num ,
  512. ( SELECT COUNT( 1 ) FROM cygx_activity_appointment AS ap WHERE ap.activity_id = art.activity_id AND ap.user_id = ? ) AS is_appointment,
  513. ( SELECT COUNT( 1 ) FROM cygx_activity_meeting_reminder AS m WHERE m.activity_id = art.activity_id AND m.is_cancel = 0 AND m.user_id = ? ) AS is_cancel_meeting_reminder,
  514. 1 AS source_type
  515. FROM cygx_activity AS art
  516. INNER JOIN cygx_my_schedule as my ON my.activity_id = art.activity_id
  517. INNER JOIN cygx_activity_type as t ON t.activity_type_id = art.activity_type_id
  518. WHERE 1=1 AND my.user_id = ? `
  519. if condition != "" {
  520. sql += condition
  521. }
  522. sql += ` ORDER BY art.active_state ASC,art.activity_time ASC LIMIT ?,?`
  523. _, err = o.Raw(sql, pars, uid, uid, uid, uid, startSize, pageSize).QueryRows(&items)
  524. return
  525. }
  526. // 我的日程列表 活动以及专项调研一起
  527. func GetScheduleAndSpecilList(condition string, pars []interface{}, conditionSpecil string, parsSpecil []interface{}, startSize, pageSize int) (items []*ActivityDetail, err error) {
  528. o := orm.NewOrm()
  529. sql := `SELECT
  530. art.activity_id,
  531. art.activity_time_text,
  532. art.activity_name,
  533. art.chart_permission_id,
  534. art.active_state,
  535. t.activity_type,
  536. art.chart_permission_name,
  537. art.distinguished_guest,
  538. art.expert,
  539. art.speaker,
  540. "" AS trip_img_link,
  541. "" AS activity_time_end,
  542. art.yidong_activity_id,
  543. art.is_can_appointment_minutes,
  544. art.activity_type_id,
  545. art.limit_people_num,
  546. art.is_limit_people,
  547. 1 AS source_type,
  548. art.activity_time,
  549. 0 AS days,
  550. art.city AS city,
  551. art.is_external_label,
  552. art.is_yidong_conduct,
  553. art.is_can_outbound_call,
  554. art.is_research_points,
  555. art.cancel_deadline,
  556. art.host
  557. FROM
  558. cygx_activity AS art
  559. INNER JOIN cygx_my_schedule AS my ON my.activity_id = art.activity_id
  560. INNER JOIN cygx_activity_type AS t ON t.activity_type_id = art.activity_type_id
  561. WHERE
  562. 1 = 1 `
  563. if condition != `` {
  564. sql += condition
  565. }
  566. sql += ` UNION ALL
  567. SELECT
  568. art.activity_id,
  569. art.activity_time_text_by_day AS activity_time_text,
  570. art.research_theme AS activity_name,
  571. art.chart_permission_id,
  572. "",
  573. art.special_type AS activity_type,
  574. art.chart_permission_name,
  575. "",
  576. "",
  577. "",
  578. art.trip_img_link_fix AS trip_img_link,
  579. art.activity_time_end,
  580. "",
  581. "",
  582. "",
  583. "",
  584. "",
  585. 2 AS source_type,
  586. art.activity_time,
  587. art.days,
  588. art.city,
  589. "",
  590. "",
  591. "",
  592. "",
  593. "",
  594. art.host
  595. FROM
  596. cygx_activity_special AS art
  597. INNER JOIN cygx_activity_special_trip AS my ON my.activity_id = art.activity_id
  598. WHERE
  599. 1 = 1`
  600. if conditionSpecil != "" {
  601. sql += conditionSpecil
  602. }
  603. sql += ` ORDER BY activity_time DESC LIMIT ?,?`
  604. _, err = o.Raw(sql, pars, parsSpecil, startSize, pageSize).QueryRows(&items)
  605. return
  606. }
  607. // 列表
  608. func GetActivityListByCondition(condition string, pars []interface{}) (items []*CygxActivity, err error) {
  609. o := orm.NewOrm()
  610. sql := `SELECT * FROM cygx_activity WHERE 1 =1 `
  611. if condition != "" {
  612. sql += condition
  613. }
  614. _, err = o.Raw(sql, pars).QueryRows(&items)
  615. return
  616. }