resource_data.go 15 KB

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