industrial_management.go 14 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459
  1. package services
  2. import (
  3. "context"
  4. "errors"
  5. "fmt"
  6. "hongze/hongze_cygx/models"
  7. "hongze/hongze_cygx/utils"
  8. "strings"
  9. "time"
  10. )
  11. //修改标签状态
  12. func UpdateIndustrialManagementLabel(cont context.Context) (err error) {
  13. defer func() {
  14. if err != nil {
  15. fmt.Println("修改失败,Err:", err.Error())
  16. }
  17. }()
  18. fmt.Println("修改状态0000")
  19. go models.UpdateIndustrialIsNewLabel()
  20. list, err := models.GetIndustrialMorethan10()
  21. if err != nil {
  22. return err
  23. }
  24. if len(list) == 0 {
  25. return
  26. }
  27. var idStr string
  28. for _, v := range list {
  29. idStr += v.IndustrialManagementId + ","
  30. }
  31. idStr = strings.TrimRight(idStr, ",")
  32. go models.UpdateIndustrialIsDeepLabel(idStr)
  33. //fmt.Println(idStr)
  34. //go models.UpdateActivitySattusToComplete()
  35. fmt.Println("修改状态完成")
  36. return
  37. }
  38. //修改活动状态
  39. func UpdateIndustrialManagementSubjectNnames() (err error) {
  40. defer func() {
  41. if err != nil {
  42. fmt.Println("修改失败,Err:", err.Error())
  43. }
  44. }()
  45. fmt.Println("修改产业关联标的")
  46. list, err := models.GetIndustrialManagementIds()
  47. if err != nil {
  48. return err
  49. }
  50. for _, v := range list {
  51. //fmt.Println(v.IndustrialManagementId)
  52. var nameSub string
  53. listSub, errdSub := models.GetcygxIndustrialSubject(v.IndustrialManagementId)
  54. if errdSub != nil {
  55. return errdSub
  56. }
  57. for _, v2 := range listSub {
  58. fmt.Println(v2.SubjectName)
  59. nameSub += v2.SubjectName + ","
  60. }
  61. nameSub += v.IndustryName
  62. go models.UpdateIndustrialManagementSubjectNames(nameSub, v.IndustrialManagementId)
  63. }
  64. if len(list) == 0 {
  65. return
  66. }
  67. fmt.Println("修改状态完成")
  68. return
  69. }
  70. func ChageIndustrialArticleNum(cont context.Context) (err error) {
  71. allList, err := models.IndustrialManagementAll()
  72. if err != nil {
  73. fmt.Println("GetArticleAll Err:", err.Error())
  74. return
  75. }
  76. for _, v := range allList {
  77. total, errTop := models.GetIndustrialManagementArtCount(v.IndustrialManagementId)
  78. if errTop != nil {
  79. fmt.Println("Top Err:", errTop.Error())
  80. return
  81. }
  82. if total > 0 {
  83. err = models.UpdateIndustrialManagementArtReadNum(total, v.IndustrialManagementId)
  84. if err != nil {
  85. fmt.Println("Update Err:", err.Error())
  86. return
  87. }
  88. }
  89. }
  90. return
  91. }
  92. func ReportBillboardUpdate(cont context.Context) (err error) {
  93. //修改产业关注数量
  94. go IndustryFllowCountUpdate()
  95. //修改文章收藏数量
  96. go ArticleCollectCountUpdate()
  97. return
  98. }
  99. //修改产业关注数量
  100. func IndustryFllowCountUpdate() (err error) {
  101. defer func() {
  102. if err != nil {
  103. go utils.SendAlarmMsg("修改产业关注数量信息失败"+err.Error(), 2)
  104. go utils.SendEmail(utils.APPNAME+"【"+utils.RunMode+"】"+"失败提醒", "GetCeLueArticlePv ErrMsg:"+err.Error(), utils.EmailSendToUsers)
  105. }
  106. }()
  107. fllowList, err := models.GetUserFllowIndustrialCountList()
  108. if err != nil {
  109. return
  110. }
  111. for _, v := range fllowList {
  112. err = models.UpdateIndustrialManagementFllowNum(v.Num, v.IndustrialManagementId)
  113. if err != nil {
  114. return
  115. }
  116. }
  117. return err
  118. }
  119. //修改文章收藏数量
  120. func ArticleCollectCountUpdate() (err error) {
  121. defer func() {
  122. if err != nil {
  123. go utils.SendAlarmMsg("修改文章收藏数量信息失败"+err.Error(), 2)
  124. go utils.SendEmail(utils.APPNAME+"【"+utils.RunMode+"】"+"失败提醒", "修改文章收藏数量信息失败 ErrMsg:"+err.Error(), utils.EmailSendToUsers)
  125. }
  126. }()
  127. collectList, err := models.GetUserArticleCollectList()
  128. if err != nil {
  129. return
  130. }
  131. for _, v := range collectList {
  132. err = models.UpdateArticleCollectCountNum(v.Num, v.ArticleId)
  133. if err != nil {
  134. return
  135. }
  136. }
  137. return err
  138. }
  139. //根据行业处理所选的全部赛道字段
  140. func DoXzsChooseSend(chartPermissionName string) string {
  141. var allIn string
  142. if chartPermissionName == utils.YI_YAO_NAME {
  143. allIn = "all_in_yi_yao"
  144. } else if chartPermissionName == utils.XIAO_FEI_NAME {
  145. allIn = "all_in_xiao_fei"
  146. } else if chartPermissionName == utils.KE_JI_NAME {
  147. allIn = "all_in_ke_ji"
  148. } else if chartPermissionName == utils.ZHI_ZAO_NAME {
  149. allIn = "all_in_zhi_zao"
  150. } else if chartPermissionName == utils.CHART_PERMISSION_NAME_MF_YANXUAN {
  151. allIn = "all_in_yan_xuan"
  152. }
  153. return allIn
  154. }
  155. //行业关注或者取消关注的时候,对于用户全部赛道的影响
  156. func IndustryFllowWithTrack(industrialManagementId, count, uid int) (err error) {
  157. defer func() {
  158. if err != nil {
  159. fmt.Println(err)
  160. go utils.SendAlarmMsg("修改行业关注或者取消关注的时候,对于用户全部赛道的影响信息失败"+err.Error(), 2)
  161. go utils.SendEmail(utils.APPNAME+"【"+utils.RunMode+"】"+"失败提醒", "修改行业关注或者取消关注的时候,对于用户全部赛道的影响信息失败 ErrMsg:"+err.Error(), utils.EmailSendToUsers)
  162. }
  163. }()
  164. detail, err := models.GetIndustrialManagementDetail(industrialManagementId)
  165. if err != nil {
  166. return err
  167. }
  168. categoryinfo, err := models.GetChartPermissionById(detail.ChartPermissionId)
  169. if err != nil {
  170. return err
  171. }
  172. var allIn string
  173. allIn = DoXzsChooseSend(categoryinfo.PermissionName)
  174. if allIn != "" {
  175. //如果取消关注就把该赛道设置为非全部赛道
  176. if count == 1 {
  177. err = models.UpdateCygxXzsChooseSendIsAllIn(allIn, 0, uid)
  178. if err != nil {
  179. return err
  180. }
  181. } else {
  182. //医药、消费、科技、智造、研选下的产业赛道
  183. mapIndustrial := make(map[int][]*models.IndustrialManagementRep)
  184. industrialList, err := models.GetindustrialManagement()
  185. if err != nil {
  186. return err
  187. }
  188. for _, v := range industrialList {
  189. mapIndustrial[v.ChartPermissionId] = append(mapIndustrial[v.ChartPermissionId], v)
  190. }
  191. fllowNum, err := models.GetCountCygxIndustryFllowByUidAndChartPermissionId(uid, detail.ChartPermissionId)
  192. if err != nil {
  193. return err
  194. }
  195. if fllowNum == len(mapIndustrial[detail.ChartPermissionId]) {
  196. err = models.UpdateCygxXzsChooseSendIsAllIn(allIn, 1, uid)
  197. if err != nil {
  198. return err
  199. }
  200. }
  201. }
  202. }
  203. return err
  204. }
  205. // GetIndustryNewLabelMap 获取产业【新】标签Map
  206. func GetIndustryNewLabelMap(industryIds []int) (labelMap map[int]bool, err error) {
  207. labelMap = make(map[int]bool, 0)
  208. industryIdLen := len(industryIds)
  209. if industryIdLen == 0 {
  210. return
  211. }
  212. // 获取产业关联的报告最早发布时间及最近的发布时间
  213. var timeCond string
  214. var timePars []interface{}
  215. timeCond += ` AND b.publish_status = 1`
  216. if industryIdLen > 0 {
  217. timeCond += ` AND a.industrial_management_id IN (` + utils.GetOrmInReplace(industryIdLen) + `)`
  218. timePars = append(timePars, industryIds)
  219. }
  220. //只要弘则报告,不要研选报告
  221. timeCond += ` AND b.article_id < ? `
  222. timePars = append(timePars, utils.SummaryArticleId)
  223. industryTimeList, e := models.GetIndustryArticleMinMaxPublishTime(timeCond, timePars)
  224. if e != nil {
  225. err = errors.New("获取产业文章最大最小发布时间失败, Err: " + e.Error())
  226. return
  227. }
  228. // 判断产业是否为新
  229. nowTime := time.Now().Local()
  230. threeMonthBefore := nowTime.AddDate(0, -3, 0)
  231. nullTime, _ := time.ParseInLocation(utils.FormatDateTime, "0001-01-01 00:00:00", time.Local)
  232. industryMap := make(map[int]*models.IndustryArticleMinMaxPublishTime, 0)
  233. for i := range industryTimeList {
  234. industryMap[industryTimeList[i].IndustrialManagementId] = industryTimeList[i]
  235. }
  236. for i := range industryIds {
  237. iid := industryIds[i]
  238. item := industryMap[iid]
  239. if item != nil {
  240. // 最早发布时间为空 / 最早发布时间在三个月前之后
  241. if item.MinPublishTime.Equal(nullTime) || (item.MinPublishTime.After(threeMonthBefore)) {
  242. labelMap[iid] = true
  243. }
  244. } else {
  245. // 产业无报告, 则为新产业
  246. labelMap[iid] = true
  247. }
  248. }
  249. return
  250. }
  251. //func init() {
  252. // GetIndustrialManagementArticleNewPublishData()
  253. //}
  254. //批量修改获取产业关联文章的最新发布时间
  255. func GetIndustrialManagementArticleNewPublishData() (err error) {
  256. defer func() {
  257. if err != nil {
  258. go utils.SendAlarmMsg("批量修改获取产业关联文章的最新发布时间"+"GetIndustrialManagementArticleNewPublishData ErrMsg:"+err.Error(), 2)
  259. }
  260. }()
  261. articleNewPublishDataList, e := models.GetIndustrialManagementArticleNewPublishData()
  262. if e != nil {
  263. err = errors.New("获取客户剩余报名次数失败 GetIndustrialManagementArticleNewPublishData, Err: " + e.Error())
  264. return
  265. }
  266. mapUPdateTime := make(map[int]string)
  267. var industrialManagementIds []int
  268. for _, v := range articleNewPublishDataList {
  269. if v.IndustrialManagementId > 0 {
  270. industrialManagementIds = append(industrialManagementIds, v.IndustrialManagementId)
  271. }
  272. mapUPdateTime[v.IndustrialManagementId] = v.UpdateTime
  273. }
  274. //时间线的更新时间
  275. listtimelinePublishdate, err := models.GetTimeLineReportIndustrialPublishdateList(industrialManagementIds)
  276. if err != nil && err.Error() != utils.ErrNoRow() {
  277. return
  278. }
  279. for _, v := range listtimelinePublishdate {
  280. if mapUPdateTime[v.IndustrialManagementId] != "" {
  281. if utils.StrTimeToTime(v.PublishDate).After(utils.StrTimeToTime(mapUPdateTime[v.IndustrialManagementId])) {
  282. mapUPdateTime[v.IndustrialManagementId] = v.PublishDate
  283. }
  284. }
  285. }
  286. err = models.UpdateIndustrialManagementArticleNewPublishData(mapUPdateTime)
  287. return
  288. }
  289. //HandleIndustryList预处理产业列表字段
  290. func HandleIndustryList(list []*models.IndustrialManagement, user *models.WxUserItem) (items []*models.IndustrialManagement, err error) {
  291. userId := user.UserId
  292. fllowList, err := models.GetUserFllowIndustrialList(userId)
  293. if err != nil {
  294. return
  295. }
  296. fllowMap := make(map[int]int)
  297. if len(fllowList) > 0 {
  298. for _, v := range fllowList {
  299. fllowMap[v.IndustrialManagementId] = v.IndustrialManagementId
  300. }
  301. }
  302. mapindustrialId, e := GetMicroRoadshowVideoMap()
  303. if e != nil {
  304. err = e
  305. return
  306. }
  307. //合并产业关联的标的
  308. listSubjcet, err := models.GetThemeHeatSubjectList("")
  309. if err != nil {
  310. return
  311. }
  312. industrialIdArr := make([]int, 0)
  313. for k, v := range list {
  314. list[k].Source = 1
  315. if fllowMap[v.IndustrialManagementId] > 0 {
  316. list[k].IsFollow = 1
  317. }
  318. industrialIdArr = append(industrialIdArr, v.IndustrialManagementId)
  319. if _, ok := mapindustrialId[v.IndustrialManagementId]; !ok {
  320. continue
  321. }
  322. videoSimple, au, e := GetindustryVideo(user, v.IndustrialManagementId)
  323. if e != nil {
  324. err = errors.New("获取产业关联的视频失败,GetindustryVideo " + e.Error())
  325. return
  326. }
  327. if videoSimple != nil && videoSimple.Id > 0 {
  328. v.IndustryVideo = videoSimple
  329. }
  330. v.AuthInfo = au
  331. }
  332. if len(industrialIdArr) > 0 {
  333. //合并产业关联的标的
  334. listSubjcet, err = models.GetIndustrialSubjectAllByIndustrialId(industrialIdArr)
  335. if err != nil {
  336. return
  337. }
  338. mapIndustrial := make(map[string]int)
  339. for _, v := range listSubjcet {
  340. for k2, v2 := range list {
  341. if v2.IndustrialManagementId == v.IndustrialManagementId && mapIndustrial[fmt.Sprint(v2.IndustrialManagementId, "Hz", v.SubjectName)] == 0 {
  342. list[k2].IndustrialSubjectList = append(list[k2].IndustrialSubjectList, v)
  343. mapIndustrial[fmt.Sprint(v2.IndustrialManagementId, "Hz", v.SubjectName)] = v2.IndustrialManagementId
  344. }
  345. }
  346. }
  347. }
  348. mapUPdateTime := make(map[int]string)
  349. articleIdArr := make([]int, 0)
  350. //获取这些产业下最新更新的文章
  351. listUpdateTime, err := models.GetNewArticleDetailByIndustrialIds(industrialIdArr)
  352. if err != nil && err.Error() != utils.ErrNoRow() {
  353. return
  354. }
  355. for _, v := range listUpdateTime {
  356. mapUPdateTime[v.IndustrialManagementId] = v.PublishDate
  357. articleIdArr = append(articleIdArr, v.ArticleId)
  358. }
  359. //时间线的更新时间
  360. // maptimelineUPdateTime := make(map[int]string)
  361. listtimelinePublishdate, err := models.GetTimeLineReportIndustrialPublishdateList(industrialIdArr)
  362. if err != nil && err.Error() != utils.ErrNoRow() {
  363. return
  364. }
  365. for _, v := range listtimelinePublishdate {
  366. if mapUPdateTime[v.IndustrialManagementId] != "" {
  367. if utils.StrTimeToTime(v.PublishDate).After(utils.StrTimeToTime(mapUPdateTime[v.IndustrialManagementId])) {
  368. mapUPdateTime[v.IndustrialManagementId] = v.PublishDate
  369. }
  370. }
  371. }
  372. //mapHistroyArticleId := make(map[int]int)
  373. //if userId > 0 {
  374. // listArticleHistory, e := models.GetUserToArticleHistory(userId, articleIdArr)
  375. // if e != nil && e.Error() != utils.ErrNoRow() {
  376. // err = errors.New("获取产业关联的视频失败,GetindustryVideo " + e.Error())
  377. // return
  378. // }
  379. // for _, v := range listArticleHistory {
  380. // mapHistroyArticleId[v.ArticleId] = v.ArticleId
  381. // }
  382. //}
  383. articleList, err := models.GetReportIndustrialReadNumList(userId, industrialIdArr)
  384. mapHistroyindustrialId := make(map[int]int)
  385. for _, v := range articleList {
  386. mapHistroyindustrialId[v.IndustrialManagementId] = v.ReadNum
  387. }
  388. nowTime := time.Now().Local()
  389. threeMonBefore := nowTime.AddDate(0, -3, 0)
  390. for k, v := range list {
  391. list[k].UpdateTime = utils.TimeRemoveHms(mapUPdateTime[v.IndustrialManagementId])
  392. if userId > 0 {
  393. //如果文章没有阅读,而且,文章的发布时间晚于项目的上线时间,而且文章的发布时间晚于用户的注册时间,就进行标红处理
  394. //9.2修改为只要有未读的就标红
  395. if mapHistroyindustrialId[v.IndustrialManagementId] == 0 && user.CreatedTime.Before(utils.StrTimeToTime(mapUPdateTime[v.IndustrialManagementId])) && utils.StrTimeToTime(utils.OnlineTime).Before(utils.StrTimeToTime(mapUPdateTime[v.IndustrialManagementId])) {
  396. list[k].IsRed = true
  397. }
  398. } else {
  399. if utils.StrTimeToTime(utils.OnlineTime).Before(utils.StrTimeToTime(mapUPdateTime[v.IndustrialManagementId])) {
  400. list[k].IsRed = true
  401. }
  402. list[k].IsFollow = 0
  403. }
  404. list[k].UpdateTime = utils.TimeRemoveHms(mapUPdateTime[v.IndustrialManagementId])
  405. if userId > 0 {
  406. //如果文章没有阅读,而且,文章的发布时间晚于项目的上线时间,而且文章的发布时间晚于用户的注册时间,就进行标红处理
  407. if mapHistroyindustrialId[v.IndustrialManagementId] == 0 && user.CreatedTime.Before(utils.StrTimeToTime(mapUPdateTime[v.IndustrialManagementId])) && utils.StrTimeToTime(utils.OnlineTime).Before(utils.StrTimeToTime(mapUPdateTime[v.IndustrialManagementId])) {
  408. list[k].IsRed = true
  409. }
  410. } else {
  411. if utils.StrTimeToTime(utils.OnlineTime).Before(utils.StrTimeToTime(mapUPdateTime[v.IndustrialManagementId])) {
  412. list[k].IsRed = true
  413. }
  414. list[k].IsFollow = 0
  415. }
  416. // 关联报告发布时间均在3个月内则标记New
  417. if v.MinReportTime != "" {
  418. t, e := time.Parse(utils.FormatDateTime, v.MinReportTime)
  419. if e != nil {
  420. err = errors.New("报告最早发布时间有误,GetindustryVideo " + e.Error())
  421. return
  422. }
  423. if t.After(threeMonBefore) {
  424. list[k].IsNew = true
  425. }
  426. }
  427. }
  428. items = list
  429. return
  430. }