task.go 11 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313
  1. package services
  2. import (
  3. "fmt"
  4. "github.com/PuerkitoBio/goquery"
  5. "github.com/beego/beego/v2/task"
  6. "hongze/hongze_cygx/models"
  7. "hongze/hongze_cygx/utils"
  8. "html"
  9. "strconv"
  10. "strings"
  11. "time"
  12. )
  13. func Task() {
  14. fmt.Println("start")
  15. if utils.RunMode == "release" && utils.IsTask {
  16. //syncTacticsListAddreport := task.NewTask("syncTacticsListAddreport", "0 */5 * * * *", SyncTacticsListAddreport) //同步文章
  17. //task.AddTask("syncTacticsListAddreport", syncTacticsListAddreport)
  18. getSummarytoEs := task.NewTask("getSummarytoEs", "0 */30 * * * *", GetSummarytoEs) //同步纪要库内容到Es
  19. task.AddTask("getSummarytoEs", getSummarytoEs)
  20. getArticleListByApi := task.NewTask("getArticleListByApi", "0 */5 * * * *", GetArticleListByApi) //通过三方接口获取策略平台上的文章
  21. task.AddTask("getArticleListByApi", getArticleListByApi)
  22. //会议提醒模板消息推送
  23. sendActivityBeginMsg := task.NewTask("sendActivityBeginMsg", "0 */10 8-22 * * *", SendActivityBeginMsg) //会议前60分钟的提醒
  24. task.AddTask("sendActivityBeginMsg", sendActivityBeginMsg)
  25. sendActivityBeginMsgMeeting := task.NewTask("sendActivityBeginMsgMeeting", "0 */5 8-22 * * *", SendActivityBeginMsgMeeting) //会议前15分钟的提醒
  26. task.AddTask("sendActivityBeginMsgMeeting", sendActivityBeginMsgMeeting)
  27. //预约外呼名单,会前1小时自动发送邮件给专家组
  28. sendEmailFileToExpert := task.NewTask("sendEmailFileToExpert", "0 */5 8-22 * * *", SendEmailFileToExpert) //预约外呼名单,会前1小时自动发送邮件给专家组
  29. task.AddTask("sendEmailFileToExpert", sendEmailFileToExpert)
  30. sendEmailUserWhiteListChange := task.NewTask("sendEmailUserWhiteListChange", "0 00 17 * * *", SendEmailUserWhiteListChange) //新增 和冻结的客户白名单
  31. task.AddTask("白名单发送", sendEmailUserWhiteListChange)
  32. dotongbuShangHai := task.NewTask("dotongbuShangHai", "0 30 3 * * *", DotongbuShangHai) //把信息同步到上海策略品台
  33. task.AddTask("同步用户到上海", dotongbuShangHai)
  34. dotongbuShangHaiSendEmail := task.NewTask("dotongbuShangHaiSendEmail", "0 00 4 * * *", DotongbuShangHaiSendEmail) //发送上海策略品台同步结果名单的邮件附件
  35. task.AddTask("发送上海策略品台同步结果名单的邮件附件", dotongbuShangHaiSendEmail)
  36. getChartListByApi := task.NewTask("getChartListByApi", "0 */30 * * * *", GetChartListByApi) //同步图表
  37. task.AddTask("getChartListByApi", getChartListByApi)
  38. }
  39. if utils.IsTask {
  40. //修改任务状
  41. updateActivitySattus := task.NewTask("syncTacticsListAddreport", "0 */1 8-22 * * *", UpdateActivitySattus)
  42. task.AddTask("updateActivitySattus", updateActivitySattus)
  43. //更新深 和新的标签
  44. updateIndustrialManagementLabel := task.NewTask("updateIndustrialManagementLabel", "0 */30 * * * *", UpdateIndustrialManagementLabel)
  45. task.AddTask("updateIndustrialManagementLabel", updateIndustrialManagementLabel)
  46. //更改对应产业的文章阅读数量
  47. chageIndustrialArticleNum := task.NewTask("chageIndustrialArticleNum", "0 01 00 * * *", ChageIndustrialArticleNum) //更改对应产业的文章阅读数量
  48. task.AddTask("chageIndustrialArticleNum", chageIndustrialArticleNum)
  49. activityAttendanceDetail := task.NewTask("activityAttendanceDetail", "0 00 3 * * *", ActivityAttendanceDetail) //同步进门财经的路演信息
  50. task.AddTask("sendEmailUserWhiteListChange", activityAttendanceDetail)
  51. sendEmailFileForAskMsgResearch := task.NewTask("sendEmailFileForAskMsgResearch", "0 */5 8-22 * * *", SendEmailFileForAskMsgResearch) //研选系列专家电话会,会前1小时将问题列表发送给邮箱
  52. task.AddTask("sendEmailFileForAskMsgResearch", sendEmailFileForAskMsgResearch)
  53. sendEmailFileForAskMsg := task.NewTask("sendEmailFileForAskMsg", "0 */5 8-22 * * *", SendEmailFileForAskMsg) //非研选系列专家电话会,根据主持人姓名,会前15分钟将问题列表发送给至该主持人对应邮箱
  54. task.AddTask("sendEmailFileForAskMsg", sendEmailFileForAskMsg)
  55. }
  56. //ActivityAttendanceDetail()
  57. //SynchronizationArthistory()//同步原有的阅读记录
  58. //GetAddpArticle() //同步日度点评数据
  59. //SendEmailAllUserWithRAI() //发送当前所有权益用户到沈大爷的邮箱
  60. //SendEmailAllUserWithCompany() //发送这些公司下的用户到沈大爷的邮箱
  61. task.StartTask()
  62. //StatisticalReport()//导出报表
  63. fmt.Println("end")
  64. }
  65. ////白名单发送
  66. //sendEmailUserWhiteList := task.NewTask("sendEmailUserWhiteList", "0 27 17 * * *", SendEmailUserWhiteList) //白名单发送
  67. //task.AddTask("sendEmailUserWhiteList", sendEmailUserWhiteList)
  68. //editOutboundMobile := task.NewTask("editOutboundMobile", "0 */1 8-22 * * *", EditOutboundMobile) //同步外呼号码与手机号
  69. //task.AddTask("sendEmailFileToExpert", editOutboundMobile)
  70. //editUserOutboundMobile := task.NewTask("editUserOutboundMobile", "0 27 14 * * * ", EditUserOutboundMobile) //同步外呼号码与手机号
  71. //task.AddTask("editUserOutboundMobile", editUserOutboundMobile)
  72. func CreateIndex() {
  73. indexName := utils.IndexName
  74. mappingJson := `{
  75. "mappings": {
  76. "dynamic": true,
  77. "properties": {
  78. "ArticleId": {
  79. "type": "integer"
  80. },
  81. "CategoryId": {
  82. "type": "text"
  83. },
  84. "BodyText": {
  85. "type": "text",
  86. "term_vector": "with_positions_offsets",
  87. "analyzer": "ik_smart"
  88. },
  89. "PublishDate": {
  90. "type": "keyword"
  91. },
  92. "SubCategoryName": {
  93. "type": "text",
  94. "term_vector": "with_positions_offsets",
  95. "analyzer": "ik_smart"
  96. },
  97. "Title": {
  98. "type": "text",
  99. "term_vector": "with_positions_offsets",
  100. "analyzer": "ik_smart"
  101. },
  102. "TitleEn": {
  103. "type": "text",
  104. "term_vector": "with_positions_offsets"
  105. },
  106. "UpdateFrequency": {
  107. "type": "text",
  108. "term_vector": "with_positions_offsets"
  109. },
  110. "ExpertBackground": {
  111. "type": "text",
  112. "term_vector": "with_positions_offsets"
  113. }
  114. }
  115. }
  116. }`
  117. EsCreateIndex(indexName, mappingJson)
  118. AddAllArticle()
  119. }
  120. func AddAllArticle() {
  121. endDate := time.Now().AddDate(0, 0, -30).Format(utils.FormatDate)
  122. //allList, err := models.GetArticleAll()
  123. allList, err := models.GetArticleAllDate(endDate)
  124. if err != nil {
  125. fmt.Println("GetArticleAll Err:", err.Error())
  126. return
  127. }
  128. indexName := utils.IndexName
  129. for _, v := range allList {
  130. content := html.UnescapeString(v.Body)
  131. doc, err := goquery.NewDocumentFromReader(strings.NewReader(content))
  132. if err != nil {
  133. fmt.Println("create doc err:", err.Error())
  134. return
  135. }
  136. bodyText := doc.Text()
  137. item := new(ElasticTestArticleDetail)
  138. item.ArticleId = v.ArticleId
  139. item.Title = v.Title
  140. item.PublishDate = v.PublishDate
  141. item.BodyText = bodyText
  142. item.ExpertBackground = v.ExpertBackground
  143. item.CategoryId = strconv.Itoa(v.CategoryId)
  144. EsAddOrEditData(indexName, strconv.Itoa(v.ArticleId), item)
  145. fmt.Println(v.ArticleId)
  146. }
  147. }
  148. func AddAllArticleV4() {
  149. allList, err := models.GetArticleAll2()
  150. if err != nil {
  151. fmt.Println("GetArticleAll Err:", err.Error())
  152. return
  153. }
  154. indexName := "cygx_article_v4"
  155. for _, v := range allList {
  156. content := html.UnescapeString(v.Body)
  157. doc, err := goquery.NewDocumentFromReader(strings.NewReader(content))
  158. if err != nil {
  159. fmt.Println("create doc err:", err.Error())
  160. return
  161. }
  162. bodyText := doc.Text()
  163. item := new(ElasticTestArticleDetailV4)
  164. item.ArticleId = v.ArticleId
  165. item.Title = v.Title
  166. item.PublishDate = v.PublishDate
  167. item.BodyText = bodyText
  168. item.IsSummary = v.IsSummary
  169. item.IsReport = v.IsReport
  170. //if v.IsReport == 1 {
  171. // item.IsReport = true
  172. //}
  173. //if v.IsSummary == 1 {
  174. // item.IsSummary = true
  175. //}
  176. EsAddOrEditDataV4(indexName, strconv.Itoa(v.ArticleId), item)
  177. fmt.Println(v.ArticleId)
  178. }
  179. }
  180. // "term_vector": "with_positions_offsets"
  181. type ElasticArticleDetail struct {
  182. ArticleId int `description:"报告id"`
  183. Title string `description:"标题"`
  184. TitleEn string `description:"英文标题 "`
  185. UpdateFrequency string `description:"更新周期"`
  186. CreateDate string `description:"创建时间"`
  187. PublishDate string `description:"发布时间"`
  188. Abstract string `description:"摘要"`
  189. CategoryName string `description:"一级分类"`
  190. SubCategoryName string `description:"二级分类"`
  191. InterviewDate string `description:"访谈时间"`
  192. ExpertBackground string `description:"专家背景"`
  193. ExpertNumber string `description:"专家编号"`
  194. Department string `description:"作者"`
  195. ArticleIdMd5 string `description:"纪要id"`
  196. BodyText string `description:"内容"`
  197. }
  198. type ElasticTestArticleDetail struct {
  199. ArticleId int `description:"报告id"`
  200. Title string `description:"标题"`
  201. BodyText string `description:"内容"`
  202. PublishDate string `description:"发布时间"`
  203. ExpertBackground string `description:"专家背景"`
  204. CategoryId string `description:"文章分类"`
  205. }
  206. type ElasticTestArticleDetailV4 struct {
  207. ArticleId int `description:"报告id"`
  208. Title string `description:"标题"`
  209. BodyText string `description:"内容"`
  210. PublishDate string `description:"发布时间"`
  211. IsSummary int `description:"是否属于纪要库"`
  212. IsReport int `description:"是否属于报告"`
  213. }
  214. func GetAddpArticle() {
  215. list, err := models.GetReportList()
  216. for _, v := range list {
  217. var articleId int
  218. maxArticleIdArticleInfo, errMax := models.GetMaxArticleIdInfo()
  219. if errMax != nil {
  220. fmt.Println(errMax)
  221. return
  222. }
  223. articleId = maxArticleIdArticleInfo.ArticleId + 1
  224. item := new(models.CygxArticle)
  225. item.Title = v.Title
  226. item.ArticleId = articleId
  227. item.SellerAndMobile = v.Author
  228. item.PublishDate = v.PublishTime
  229. item.Abstract = v.Abstract
  230. item.Body = html.UnescapeString(v.Content)
  231. item.BodyText, _ = GetReportContentTextSub(v.Content)
  232. item.IsReport = 1
  233. item.Source = 1
  234. item.ArticleIdMd5 = utils.MD5(strconv.Itoa(articleId))
  235. item.Department = "弘则产品组"
  236. item.ArticleType = "lyjh"
  237. item.IsClass = 1
  238. item.CreateDate = v.CreateTime
  239. item.UpdateFrequency = "unknow"
  240. item.CategoryId = 100 // 100是路演精华对应ID
  241. item.SubCategoryName = "路演精华"
  242. item.HavePublish = 1
  243. item.PublishStatus = 1
  244. item.Periods = strconv.Itoa(v.Stage)
  245. item.VideoUrl = v.VideoUrl
  246. item.VideoName = v.VideoName
  247. item.VideoPlaySeconds = v.VideoPlaySeconds
  248. newId, _ := models.AddCygxArticles(item)
  249. fmt.Println(articleId)
  250. fmt.Println(newId)
  251. fmt.Println(item.ArticleIdMd5)
  252. }
  253. fmt.Println(err)
  254. fmt.Println(list)
  255. }
  256. func SynchronizationArthistory() {
  257. go SynchronizationArtclehistory()
  258. }
  259. //func init() {
  260. //
  261. // var newActivityName string
  262. // list, err := models.GetActivityList()
  263. // if err != nil {
  264. // fmt.Println(err)
  265. // }
  266. // for _, v := range list {
  267. //
  268. // fmt.Println("原来的", v.ActivityName)
  269. // newActivityName = v.ActivityName
  270. // newActivityName = strings.Replace(newActivityName, "【", "", -1)
  271. // newActivityName = strings.Replace(newActivityName, "】", "", -1)
  272. // newActivityName = strings.Replace(newActivityName, "-", "", -1)
  273. // newActivityName = strings.Replace(newActivityName, "—", "", -1)
  274. // newActivityName = strings.Replace(newActivityName, " ", "", -1)
  275. // newActivityName = strings.Replace(newActivityName, ":", "", -1)
  276. // fmt.Println("处理的", newActivityName)
  277. // err = models.UpdateCygxActivityName(v.ActivityId, newActivityName)
  278. // if err != nil {
  279. // fmt.Println(err)
  280. // }
  281. // }
  282. //}