resource_data.go 14 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448
  1. package services
  2. import (
  3. "errors"
  4. "fmt"
  5. "hongze/hongze_cygx/models"
  6. "hongze/hongze_cygx/utils"
  7. "strconv"
  8. "strings"
  9. "time"
  10. )
  11. func GetResourceDataList(condition string, pars []interface{}, startSize, pageSize int, user *models.WxUserItem) (items []*models.CygxResourceDataResp, err error) {
  12. uid := user.UserId
  13. list, e := models.GetResourceDataList(condition, pars, startSize, pageSize)
  14. if e != nil {
  15. err = errors.New("GetResourceDataList, Err: " + e.Error())
  16. return
  17. }
  18. mapItems := make(map[string]*models.CygxResourceDataResp)
  19. for _, v := range list {
  20. //预处理文章
  21. item := new(models.CygxResourceDataResp)
  22. item.Id = v.Id
  23. item.SourceId = v.SourceId
  24. item.Source = v.Source
  25. item.PublishDate = utils.TimeRemoveHms2(v.PublishDate)
  26. mapItems[fmt.Sprint(v.Source, v.SourceId)] = item
  27. }
  28. var articleIds []int
  29. var newchartIds []int
  30. var roadshowIds []string
  31. var activityIds []int
  32. var activityvideoIds []string
  33. var activityvoiceIds []string
  34. var activityspecialIds []int
  35. var researchsummaryIds []int
  36. var minutessummaryIds []int
  37. var meetingreviewchaptIds []int
  38. //Source string `description:"资源类型 报告 :article 、图表 :newchart、微路演 :roadshow、活动 :activity、活动视频:activityvideo、活动音频:activityvoice、专项调研活动:activityspecial 、 本周研究汇总: researchsummary 、 上周纪要汇总 :minutessummary 、晨会精华 :meetingreviewchapt "`
  39. for _, v := range list {
  40. if v.Source == "article" {
  41. articleIds = append(articleIds, v.SourceId)
  42. } else if v.Source == "newchart" {
  43. newchartIds = append(newchartIds, v.SourceId)
  44. } else if v.Source == "roadshow" {
  45. roadshowIds = append(roadshowIds, strconv.Itoa(v.SourceId))
  46. } else if v.Source == "activity" {
  47. activityIds = append(activityIds, v.SourceId)
  48. } else if v.Source == "activityvideo" {
  49. activityvideoIds = append(activityvideoIds, strconv.Itoa(v.SourceId))
  50. } else if v.Source == "activityvoice" {
  51. activityvoiceIds = append(activityvoiceIds, strconv.Itoa(v.SourceId))
  52. } else if v.Source == "activityspecial" {
  53. activityspecialIds = append(activityspecialIds, v.SourceId)
  54. } else if v.Source == "researchsummary" {
  55. researchsummaryIds = append(researchsummaryIds, v.SourceId)
  56. } else if v.Source == "minutessummary" {
  57. minutessummaryIds = append(minutessummaryIds, v.SourceId)
  58. } else if v.Source == "meetingreviewchapt" {
  59. meetingreviewchaptIds = append(meetingreviewchaptIds, v.SourceId)
  60. }
  61. }
  62. //处理文章
  63. if len(articleIds) > 0 {
  64. pars = make([]interface{}, 0)
  65. condition = ` AND a.article_id IN (` + utils.GetOrmInReplace(len(articleIds)) + `)`
  66. pars = append(pars, articleIds)
  67. listArticle, e := models.GetHomeList(condition, pars, 0, len(articleIds))
  68. if e != nil {
  69. err = errors.New("GetResourceDataList, Err: " + e.Error())
  70. return
  71. }
  72. listArticle, e = HandleArticleCategoryImg(listArticle)
  73. if e != nil {
  74. err = errors.New("HandleArticleCategoryImg, Err: " + e.Error())
  75. return
  76. }
  77. for _, v := range listArticle {
  78. v.Body = ""
  79. v.BodyHtml = ""
  80. mapItems[fmt.Sprint("article", v.ArticleId)].Article = v
  81. }
  82. }
  83. //处理晨会精华
  84. if len(meetingreviewchaptIds) > 0 {
  85. pars = make([]interface{}, 0)
  86. condition = ` AND c.id IN (` + utils.GetOrmInReplace(len(meetingreviewchaptIds)) + `)`
  87. pars = append(pars, meetingreviewchaptIds)
  88. listrMeet, e := models.GetCygxMorningMeetingReviewChapterList(condition, pars)
  89. if e != nil {
  90. err = errors.New("GetResourceDataList, Err: " + e.Error())
  91. return
  92. }
  93. for _, v := range listrMeet {
  94. v.PublishTime = utils.TimeRemoveHms2(v.PublishTime)
  95. mapItems[fmt.Sprint("meetingreviewchapt", v.Id)].Meetingreviewchapt = v
  96. }
  97. }
  98. //处理上周纪要汇总
  99. if len(minutessummaryIds) > 0 {
  100. pars = make([]interface{}, 0)
  101. condition = ` AND article_id IN (` + utils.GetOrmInReplace(len(minutessummaryIds)) + `)`
  102. pars = append(pars, minutessummaryIds)
  103. listresearchsummary, e := models.GetReportSelectionListHome(condition, "cygx_minutes_summary", pars, 0, len(minutessummaryIds))
  104. if e != nil {
  105. err = errors.New("GetResourceDataList, Err: " + e.Error())
  106. return
  107. }
  108. for _, v := range listresearchsummary {
  109. v.PublishDate = utils.TimeRemoveHms2(v.PublishDate)
  110. mapItems[fmt.Sprint("minutessummary", v.ArticleId)].Minutessummary = v
  111. }
  112. }
  113. //处理本周纪要汇总
  114. if len(researchsummaryIds) > 0 {
  115. pars = make([]interface{}, 0)
  116. condition = ` AND article_id IN (` + utils.GetOrmInReplace(len(researchsummaryIds)) + `)`
  117. pars = append(pars, researchsummaryIds)
  118. listresearchsummary, e := models.GetReportSelectionListHome(condition, "cygx_research_summary", pars, 0, len(researchsummaryIds))
  119. if e != nil {
  120. err = errors.New("GetReportSelectionListHome, Err: " + e.Error())
  121. return
  122. }
  123. for _, v := range listresearchsummary {
  124. v.PublishDate = utils.TimeRemoveHms2(v.PublishDate)
  125. mapItems[fmt.Sprint("researchsummary", v.ArticleId)].Researchsummary = v
  126. }
  127. }
  128. detail, e := models.GetConfigByCode("city_img_url")
  129. if e != nil {
  130. err = errors.New("GetResourceDataList, Err: " + e.Error())
  131. return
  132. }
  133. detailChart, e := models.GetConfigByCode("chart_img_url")
  134. if e != nil {
  135. err = errors.New("GetResourceDataList, Err: " + e.Error())
  136. return
  137. }
  138. addressList := strings.Split(detail.ConfigValue, "{|}")
  139. mapAddress := make(map[string]string)
  140. chartList := strings.Split(detailChart.ConfigValue, "{|}")
  141. mapChart := make(map[string]string)
  142. var cityName string
  143. var chartName string
  144. var imgUrl string
  145. var imgUrlChart string
  146. for _, v := range addressList {
  147. vslice := strings.Split(v, "_")
  148. cityName = vslice[0]
  149. imgUrl = vslice[len(vslice)-1]
  150. mapAddress[cityName] = imgUrl
  151. }
  152. for _, v := range chartList {
  153. vslice := strings.Split(v, "_")
  154. chartName = vslice[0]
  155. imgUrlChart = vslice[len(vslice)-1]
  156. mapChart[chartName] = imgUrlChart
  157. }
  158. var imgUrlResp string
  159. //处理活动
  160. if len(activityIds) > 0 {
  161. for _, vss := range activityIds {
  162. imgUrlResp += strconv.Itoa(vss) + ","
  163. }
  164. pars = make([]interface{}, 0)
  165. condition = ` AND art.activity_id IN (` + utils.GetOrmInReplace(len(activityIds)) + `)`
  166. pars = append(pars, activityIds)
  167. activityList, e := models.GetActivityListNew(condition, pars, uid, 0, len(activityIds), 0, 0, "")
  168. if e != nil {
  169. err = errors.New("GetResourceDataList, Err: " + e.Error())
  170. return
  171. }
  172. //处理不同的报名方式按钮回显
  173. mapActivitySignup, e := GetActivitySignupResp(activityIds, user)
  174. if e != nil {
  175. e = errors.New("GetActivitySignupResp, Err: " + e.Error())
  176. return
  177. }
  178. var activityListRersp []*models.ActivityDetail
  179. for _, v := range activityList {
  180. v.SignupType = mapActivitySignup[v.ActivityId]
  181. activityListRersp = append(activityListRersp, ActivityButtonShow(v))
  182. }
  183. for _, v := range activityListRersp {
  184. if v == nil {
  185. continue
  186. }
  187. if v.ActivityType == 0 {
  188. if mapAddress[v.City] != "" {
  189. imgUrlResp = mapAddress[v.City]
  190. } else {
  191. imgUrlResp = mapAddress["其它"]
  192. }
  193. } else {
  194. if mapChart[v.ChartPermissionName] != "" {
  195. imgUrlResp = mapChart[v.ChartPermissionName]
  196. }
  197. }
  198. v.SourceType = 1
  199. mapItems[fmt.Sprint("activity", v.ActivityId)].Activity = v
  200. }
  201. }
  202. //处理图表
  203. if len(newchartIds) > 0 {
  204. pars = make([]interface{}, 0)
  205. condition = ` AND a.chart_id IN (` + utils.GetOrmInReplace(len(newchartIds)) + `)`
  206. pars = append(pars, newchartIds)
  207. chartDateList, e := models.GetChartListCollectionNew(condition, pars, uid, 0, len(newchartIds))
  208. if e != nil {
  209. err = errors.New("GetResourceDataList, Err: " + e.Error())
  210. return
  211. }
  212. for _, v := range chartDateList {
  213. mapItems[fmt.Sprint("newchart", v.ChartId)].Newchart = v
  214. }
  215. }
  216. //处理专项调研
  217. if len(activityspecialIds) > 0 {
  218. pars = make([]interface{}, 0)
  219. condition = ` AND art.activity_id IN (` + utils.GetOrmInReplace(len(activityspecialIds)) + `)`
  220. pars = append(pars, activityspecialIds)
  221. activitySpeciallist, e := models.GetCygxActivitySpecialDetailList(condition, pars, user.UserId, 0, len(activityspecialIds))
  222. if e != nil {
  223. err = errors.New("GetCygxActivitySpecialDetailList, Err: " + e.Error())
  224. return
  225. }
  226. UserMap, e := GetSpecialTripUserMap(activityIds, user.UserId)
  227. if e != nil {
  228. err = errors.New("GetSpecialTripUserMap, Err: " + e.Error())
  229. return
  230. }
  231. for _, v := range activitySpeciallist {
  232. if mapChart[v.ChartPermissionName] != "" {
  233. imgUrlResp = mapChart[v.ChartPermissionName]
  234. }
  235. if _, ok := UserMap[v.ActivityId]; ok {
  236. v.IsTrip = 1
  237. }
  238. if v.Days == 0 {
  239. v.TripStatus = 1
  240. v.TripImgLink = v.TripImgLink
  241. } else {
  242. v.TripStatus = 2
  243. v.TripImgLink = v.TripImgLinkFix
  244. v.ActivityTimeText = v.ActivityTimeTextByDay
  245. }
  246. resultTimeStart := utils.StrTimeToTime(v.ActivityTime) //时间字符串格式转时间格式
  247. resultTimeEnd := utils.StrTimeToTime(v.ActivityTimeEnd) //时间字符串格式转时间格式
  248. if resultTimeStart.After(time.Now()) {
  249. v.ActiveState = 1
  250. } else if time.Now().After(resultTimeEnd) {
  251. v.ActiveState = 3
  252. } else {
  253. v.ActiveState = 2
  254. }
  255. v.ImgUrl = imgUrlResp
  256. mapItems[fmt.Sprint("activityspecial", v.ActivityId)].Activityspecial = v
  257. }
  258. }
  259. if len(roadshowIds)+len(activityvideoIds)+len(activityvoiceIds) > 0 {
  260. audioIdstr := strings.Join(activityvoiceIds, ",")
  261. ideoIdsStr := strings.Join(roadshowIds, ",")
  262. activityVideoIdsStr := strings.Join(activityvideoIds, ",")
  263. list, _, e := GetMicroRoadShowMycollect(len(roadshowIds)+len(activityvideoIds)+len(activityvoiceIds), 0, audioIdstr, ideoIdsStr, activityVideoIdsStr)
  264. if e != nil {
  265. err = errors.New("GetMicroRoadShowMycollect, Err: " + e.Error())
  266. return
  267. }
  268. for _, item := range list {
  269. if item.Type == 1 {
  270. //音频
  271. count, e := models.GetVoiceCollectCount(user.UserId, item.Id)
  272. if e != nil {
  273. err = errors.New("GetVoiceCollectCount, Err: " + e.Error())
  274. return
  275. }
  276. if count > 0 {
  277. item.IsCollect = true
  278. }
  279. } else if item.Type == 2 {
  280. //活动视频
  281. count, e := models.GetActivityVideoCollectCount(user.UserId, item.Id)
  282. if e != nil {
  283. err = errors.New("GetActivityVideoCollectCount, Err: " + e.Error())
  284. return
  285. }
  286. if count > 0 {
  287. item.IsCollect = true
  288. }
  289. } else if item.Type == 3 {
  290. //微路演视频
  291. count, e := models.GetVideoCollectCount(user.UserId, item.Id)
  292. if e != nil {
  293. err = errors.New("GetVideoCollectCount, Err: " + e.Error())
  294. return
  295. }
  296. if count > 0 {
  297. item.IsCollect = true
  298. }
  299. }
  300. }
  301. // 用户权限
  302. authInfo, permissionArr, e := GetUserRaiPermissionInfo(user.UserId, user.CompanyId)
  303. if e != nil {
  304. err = errors.New("GetUserRaiPermissionInfo, Err: " + e.Error())
  305. return
  306. }
  307. // 获取默认图配置
  308. audioMap, videoMap, audioShareMap, videoShareMap, e := GetMicroRoadShowDefaultImgConfig()
  309. if e != nil {
  310. err = errors.New("GetMicroRoadShowDefaultImgConfig, Err: " + e.Error())
  311. return
  312. }
  313. //Source string `description:"资源类型 报告 :article 、图表 :newchart、微路演 :roadshow、活动 :activity、活动视频:activityvideo、活动音频:activityvoice、专项调研活动:activityspecial"`
  314. for i := range list {
  315. // 权限
  316. au := new(models.UserPermissionAuthInfo)
  317. au.SellerName = authInfo.SellerName
  318. au.SellerMobile = authInfo.SellerMobile
  319. au.HasPermission = authInfo.HasPermission
  320. au.OperationMode = authInfo.OperationMode
  321. if au.HasPermission == 1 {
  322. // 非宏观权限进一步判断是否有权限
  323. if list[i].ChartPermissionId != utils.HONG_GUAN_ID && !utils.InArrayByStr(permissionArr, list[i].ChartPermissionName) {
  324. au.HasPermission = 2
  325. }
  326. }
  327. // 无权限的弹框提示
  328. if au.HasPermission != 1 {
  329. if au.OperationMode == UserPermissionOperationModeCall {
  330. if list[i].Type == 1 {
  331. au.PopupMsg = UserPermissionPopupMsgCallActivity
  332. } else {
  333. au.PopupMsg = UserPermissionPopupMsgCallMicroVideo
  334. }
  335. } else {
  336. if list[i].Type == 1 {
  337. au.PopupMsg = UserPermissionPopupMsgApplyActivity
  338. } else {
  339. au.PopupMsg = UserPermissionPopupMsgApplyMicroVideo
  340. }
  341. }
  342. }
  343. list[i].AuthInfo = au
  344. list[i].PublishTime = utils.StrTimeToTime(list[i].PublishTime).Format(utils.FormatDate)
  345. // 默认图
  346. if list[i].BackgroundImg == "" {
  347. if list[i].Type == 1 {
  348. list[i].BackgroundImg = audioMap[list[i].ChartPermissionId]
  349. } else {
  350. list[i].BackgroundImg = videoMap[list[i].ChartPermissionId]
  351. }
  352. }
  353. // 分享图
  354. if list[i].ShareImg == "" {
  355. if list[i].Type == 1 {
  356. list[i].ShareImg = audioShareMap[list[i].ChartPermissionId]
  357. } else {
  358. list[i].ShareImg = videoShareMap[list[i].ChartPermissionId]
  359. }
  360. }
  361. }
  362. //Type int `description:"类型: 1-音频; 2-活动视频; 3-产业视频"`
  363. for _, item := range list {
  364. if item.Type == 1 {
  365. mapItems[fmt.Sprint("activityvoice", item.Id)].Activityvoice = item
  366. } else if item.Type == 2 {
  367. mapItems[fmt.Sprint("activityvideo", item.Id)].Activityvideo = item
  368. } else if item.Type == 3 {
  369. mapItems[fmt.Sprint("roadshow", item.Id)].Roadshow = item
  370. }
  371. }
  372. }
  373. for _, vList := range list {
  374. for _, v := range mapItems {
  375. if v.SourceId == vList.SourceId {
  376. items = append(items, v)
  377. }
  378. }
  379. }
  380. return
  381. }
  382. // 同步活动到最新数据表
  383. func UpdateResourceData(sourceId int, source, doType, publishDate string) (err error) {
  384. defer func() {
  385. if err != nil {
  386. go utils.SendAlarmMsg("同步到最新数据表失败,Err:"+err.Error()+"资源ID"+strconv.Itoa(sourceId)+"资源类型"+source+"操作方式"+doType, 3)
  387. }
  388. }()
  389. if doType == "add" {
  390. item := new(models.CygxResourceData)
  391. item.SourceId = sourceId
  392. item.Source = source
  393. item.PublishDate = publishDate
  394. item.CreateTime = time.Now()
  395. _, err = models.AddCygxResourceData(item)
  396. } else if doType == "delete" {
  397. err = models.DeleteResourceData(sourceId, source)
  398. } else if doType == "update" {
  399. err = models.UpdateResourceData(sourceId, source, publishDate)
  400. }
  401. return
  402. }
  403. // 批量删除最新图表数据
  404. func Deletenewchart(chartIdsDelete []int) (err error) {
  405. defer func() {
  406. if err != nil {
  407. fmt.Println(err)
  408. go utils.SendAlarmMsg("批量删除最新图表数据,Err:"+err.Error(), 3)
  409. }
  410. }()
  411. lenchartIdsDelete := len(chartIdsDelete)
  412. if lenchartIdsDelete == 0 {
  413. return
  414. }
  415. var condition string
  416. var pars []interface{}
  417. condition += ` AND source = 'newchart' AND source_id IN (` + utils.GetOrmInReplace(lenchartIdsDelete) + `) `
  418. pars = append(pars, chartIdsDelete)
  419. err = models.DeleteResourceDataList(condition, pars)
  420. return
  421. }