task.go 28 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884
  1. package services
  2. import (
  3. "context"
  4. "errors"
  5. "fmt"
  6. "github.com/beego/beego/v2/task"
  7. "hongze/hongze_task/models"
  8. "hongze/hongze_task/services/alarm_msg"
  9. "hongze/hongze_task/services/company"
  10. "hongze/hongze_task/services/company_contract"
  11. "hongze/hongze_task/services/data"
  12. "hongze/hongze_task/services/data/future_good"
  13. "hongze/hongze_task/services/maycur"
  14. "hongze/hongze_task/services/roadshow"
  15. "hongze/hongze_task/utils"
  16. "runtime"
  17. "strconv"
  18. "strings"
  19. "sync"
  20. "time"
  21. )
  22. func InitTask() {
  23. defer func() {
  24. if err := recover(); err != nil {
  25. fmt.Println("进来了定时任务的异常处理")
  26. stack := fmt.Sprintf("Handler crashed with error: %v", err) + "\n</br>"
  27. for i := 1; ; i++ {
  28. _, file, line, ok := runtime.Caller(i)
  29. if !ok {
  30. break
  31. }
  32. stack += fmt.Sprintln(fmt.Sprintf("%s:%d</br>", file, line))
  33. }
  34. //fmt.Println(stack)
  35. go alarm_msg.SendAlarmMsg(utils.APPNAME+"崩了"+time.Now().Format("2006-01-02 15:04:05")+"\n"+stack, 3)
  36. }
  37. }()
  38. // 实际开始定时任务
  39. Task()
  40. }
  41. func Task() {
  42. fmt.Println("task start")
  43. //如果是生产环境,才需要走这些任务
  44. if utils.RunMode == "release" {
  45. releaseTask()
  46. }
  47. //每日定时合同处理
  48. handleCompanyContract := task.NewTask("handleCompanyContract", "0 1 2 * * *", company_contract.HandleCompanyContract)
  49. task.AddTask("每日定时合同处理", handleCompanyContract)
  50. //正式->试用
  51. companyTryOut := task.NewTask("companyTryOut", "0 5 2 * * *", CompanyTryOut)
  52. task.AddTask("正式->试用", companyTryOut)
  53. //试用->冻结
  54. companyFreeze := task.NewTask("companyFreeze", "0 10 2 * * *", CompanyFreeze)
  55. task.AddTask("试用->冻结", companyFreeze)
  56. //冻结->流失
  57. companyLoss := task.NewTask("companyLoss", "0 20 2 * * *", CompanyLoss)
  58. task.AddTask("冻结->流失", companyLoss)
  59. //用户产品权限正式-->试用
  60. companyReportPermissionTryOut := task.NewTask("companyReportPermissionTryOut", "0 30 2 * * *", CompanyReportPermissionTryOut)
  61. task.AddTask("用户产品权限正式-->试用", companyReportPermissionTryOut)
  62. //用户产品权限试用-->关闭
  63. companyReportPermissionClose := task.NewTask("companyReportPermissionClose", "0 35 2 * * *", CompanyReportPermissionClose)
  64. task.AddTask("用户产品权限试用-->关闭", companyReportPermissionClose)
  65. //用户产品权限试用-->关闭
  66. staticCompanyTryDay := task.NewTask("StaticCompanyTryDay", "0 40 2 * * *", StaticCompanyTryDay)
  67. task.AddTask("定时任务每天更新客户试用总天数", staticCompanyTryDay)
  68. // 存量客户数据统计
  69. stackCompanyStatistic := task.NewTask("stackCompanyStatistic", "0 40 2 * * *", StackCompanyStatistic)
  70. task.AddTask("存量客户数据统计", stackCompanyStatistic)
  71. // 定时往同花顺推送报告
  72. sendWaitReport := task.NewTask("sendWaitReport", "0 */1 * * * * ", SendWaitReport)
  73. task.AddTask("定时往同花顺推送报告", sendWaitReport)
  74. // 研报电话会提醒
  75. ybTelRemind := task.NewTask("YbTelRemind", "0 */1 * * * * ", YbTelRemind)
  76. task.AddTask("研报电话会提醒", ybTelRemind)
  77. // 研报沙龙提醒
  78. ybSalonRemind := task.NewTask("ybSalonRemind", "0 */1 * * * * ", YbSalonRemind)
  79. task.AddTask("研报沙龙提醒", ybSalonRemind)
  80. // 定时新增手工指标数据提醒
  81. addEdbTask := task.NewTask("sendWaitReport", "1 0 2 * * * ", AddEdbTask)
  82. task.AddTask("定时新增手工指标数据提醒", addEdbTask)
  83. //每次服务启动都需要执行一次的
  84. _ = AddEdbTask(nil)
  85. //每日用户阅读数据统计
  86. statisticsUserView := task.NewTask("statisticsUserView", "0 5 2 * * *", StatisticsUserView)
  87. task.AddTask("每日用户阅读数据统计", statisticsUserView)
  88. //路演-活动状态修改
  89. modifyRsCalendarStatus := task.NewTask("modifyRsCalendarStatus", "0 */1 * * * * ", roadshow.ModifyRsCalendarResearcherStatus)
  90. task.AddTask("modifyRsCalendarStatus", modifyRsCalendarStatus)
  91. addReportRecord := task.NewTask("addReportRecord", "0 0 */1 * * *", roadshow.AddReportRecord)
  92. task.AddTask("addReportRecord", addReportRecord)
  93. //ficc存量客户数据统计
  94. addCompanyReportRecord := task.NewTask("addCompanyReportRecord", "0 0 */1 * * *", company.AddCompanyReportRecord)
  95. task.AddTask("addCompanyReportRecord", addCompanyReportRecord)
  96. //rai存量客户数据统计
  97. addRaiCompanyReportRecord := task.NewTask("addRaiCompanyReportRecord", "0 0 */1 * * *", company.AddRaiCompanyReportRecord)
  98. task.AddTask("addRaiCompanyReportRecord", addRaiCompanyReportRecord)
  99. //CRM 6.3 客户列表路演次数统计
  100. roadShowTotal := task.NewTask("roadShowTotal", "0 */30 * * * *", roadshow.RoadShow)
  101. task.AddTask("roadShowTotal", roadShowTotal)
  102. //每半个小时用户阅读数据统计
  103. statisticsUserView1Hour := task.NewTask("statisticsUserView1Hour", "0 */30 * * * *", StatisticsUserView1Hour)
  104. task.AddTask("每半个小时用户阅读数据统计", statisticsUserView1Hour)
  105. //路演公开会议合并
  106. setPublicMeetingUnionCode := task.NewTask("setPublicMeetingUnionCode", "0 */10 * * * *", roadshow.SetPublicMeetingUnionCode)
  107. task.AddTask("setPublicMeetingUnionCode", setPublicMeetingUnionCode)
  108. //同步进门会议参会人员数据
  109. syncComeinMeeting := task.NewTask("SyncComeinMeeting", "0 1 */1 * * * ", SyncComeinMeeting)
  110. task.AddTask("SyncComeinMeeting", syncComeinMeeting)
  111. //同步user_record中的关注状态
  112. syncSubStatus := task.NewTask("syncSubStatus", "0 0 2 * * *", SyncSubStatus)
  113. task.AddTask("syncSubStatus", syncSubStatus)
  114. //删除日志 report_save_log,ppt_v2_save_log,保留一个月的
  115. deleteLog := task.NewTask("syncSubStatus", "0 0 2 2 * *", DeleteLog)
  116. task.AddTask("deleteLog", deleteLog)
  117. // 定时发布研报语音播报
  118. publishVoiceBroadcast := task.NewTask("publishVoiceBroadcast", "0 */1 * * * *", PublishVoiceBroadcast)
  119. task.AddTask("定时发布研报语音播报", publishVoiceBroadcast)
  120. // 定时发布研报
  121. publishReport := task.NewTask("publishReport", "0 */1 * * * *", PublishReport)
  122. task.AddTask("定时发布研报", publishReport)
  123. // 定时发布英文研报
  124. publishEnglishReport := task.NewTask("publishEnglishReport", "0 */1 * * * *", PublishEnglishReport)
  125. task.AddTask("定时发布英文研报", publishEnglishReport)
  126. // 定时生成本周研究汇总
  127. cygxResearchSummary := task.NewTask("cygxResearchSummary", "0 0 15 * * 5", CygxResearchSummary)
  128. task.AddTask("定时生成本周研究汇总", cygxResearchSummary)
  129. // 定时生成上周纪要汇总
  130. cygxLastWeekSummary := task.NewTask("CygxLastWeekSummary", "0 0 10 * * 2", CygxLastWeekSummary)
  131. task.AddTask("定时生成上周纪要汇总", cygxLastWeekSummary)
  132. //ETA试用客户 启用->禁用
  133. eTATrialDisabled := task.NewTask("eTATrialDisabled", "0 15 2 * * *", ETATrialDisabled)
  134. task.AddTask("ETA试用客户 启用->禁用", eTATrialDisabled)
  135. //英文研报客户 临时->终止
  136. englishReportEmailTermination := task.NewTask("englishReportEmailTermination", "0 30 2 * * *", EnglishReportEmailTermination)
  137. task.AddTask("英文研报客户 临时->终止", englishReportEmailTermination)
  138. // ETA商家签约状态更新
  139. etaBusinessUpdateStatus := task.NewTask("etaBusinessUpdateStatus", "0 5 5 * * *", EtaBusinessUpdateStatus)
  140. task.AddTask("etaBusinessUpdateStatus", etaBusinessUpdateStatus)
  141. task.StartTask()
  142. fmt.Println("task end")
  143. }
  144. //func Task() {
  145. // fmt.Println("start task")
  146. //
  147. // cont := new(context.Context)
  148. // _ = maycur.DailyUpdateCompanyProfile(*cont)
  149. //
  150. // fmt.Println("end task")
  151. //}
  152. // 生产环境需要走的任务
  153. func releaseTask() {
  154. ////隆众调研指标获取
  155. //getLzSurveyProduct := task.NewTask("getLzSurveyProduct", "0 5 08-19/1 * * * ", GetLzSurveyProduct)
  156. //task.AddTask("getLzSurveyProduct", getLzSurveyProduct)
  157. ////隆众调研指标数据获取
  158. //getLzSurveyProductData := task.NewTask("getLzSurveyProductData", "0 10 08-20/1 * * * ", GetLzSurveyProductData)
  159. //task.AddTask("getLzSurveyProductData", getLzSurveyProductData)
  160. //发送邮件
  161. sendEmail := task.NewTask("sendEmail", "0 0 12 * * 0 ", SendEmail)
  162. task.AddTask("sendEmail", sendEmail)
  163. // 正式/试用 用户到期提醒
  164. companyRemind := task.NewTask("companyRemind", "0 30 08 * * *", CompanyRemind)
  165. task.AddTask("companyRemind", companyRemind)
  166. //潜在客户
  167. freeViewerDetail := task.NewTask("freeViewerDetail", "0 0 9 * * 1 ", FreeViewerDetail)
  168. task.AddTask("潜在客户", freeViewerDetail)
  169. //上周增量客户列表
  170. incrementCompany := task.NewTask("incrementCompany", "0 0 9 * * 1 ", IncrementCompany)
  171. task.AddTask("上周增量客户列表", incrementCompany)
  172. // 刷新指标数据
  173. refreshData := task.NewTask("refreshData", "0 1 0,19 * * *", RefreshData)
  174. task.AddTask("refreshData", refreshData)
  175. // 刷新商品数据
  176. refreshFutureGoodData := task.NewTask("refreshFutureGoodData", "0 30 0,19 * * *", RefreshFutureGoodData)
  177. task.AddTask("refreshFutureGoodData", refreshFutureGoodData)
  178. //刷新交易所指标数据
  179. refreshTradeData := task.NewTask("refreshData", "0 1 4 * * *", RefreshTradeData)
  180. task.AddTask("refreshTradeData", refreshTradeData)
  181. //刷新欧洲天然气指标数据
  182. refreshEicData := task.NewTask("refreshData", "0 1 3,7 * * *", RefreshEicData)
  183. task.AddTask("refreshEicData", refreshEicData)
  184. //刷新指标基础数据
  185. //refreshBaseData := task.NewTask("refreshBaseData", "0 */30 * * * * ", RefreshBaseData)
  186. //task.AddTask("refreshBaseData", refreshBaseData)
  187. //同步弘则数据库中来自,钢联,隆众,有色,人工等基础数据--每隔五分钟,同步一次最新数据
  188. syncBaseData := task.NewTask("syncBaseData", "0 */5 * * * * ", SyncBaseData)
  189. task.AddTask("syncBaseData", syncBaseData)
  190. syncBaseDataExt := task.NewTask("syncBaseDataExt", "0 */30 * * * * ", SyncBaseDataExt)
  191. task.AddTask("syncBaseDataExt", syncBaseDataExt)
  192. // 定时往同花顺同步微信群的截止日期(凌晨4点)
  193. syncThsWxGroupEveryDay := task.NewTask("syncThsWxGroupEveryDay", "0 1 4 * * * ", SyncWxGroupEveryDay)
  194. task.AddTask("定时往同花顺同步微信群的截止日期", syncThsWxGroupEveryDay)
  195. //检测数据服务器
  196. checkDataServer := task.NewTask("checkDataServer", "0 */2 * * * * ", checkDataServer)
  197. task.AddTask("checkDataServer", checkDataServer)
  198. //初始化指标更新状态
  199. resetEdbInfoIsUpdate := task.NewTask("resetEdbInfoIsUpdate", "0 0 0 * * *", data.ResetEdbInfoIsUpdate)
  200. task.AddTask("resetEdbInfoIsUpdate", resetEdbInfoIsUpdate)
  201. // 定时检测同花顺客群推送消息状态
  202. //checkThsReportList := task.NewTask("checkThsReportList", "0 */2 * * * * ", CheckThsReportList)
  203. //task.AddTask("checkThsReportList", checkThsReportList)
  204. // 定时统计交易所的持仓分析数据
  205. initPositionTask := task.NewTask("initPositionTask", "0 15,45 16-23 * * *", data.InitPositionTask)
  206. task.AddTask("initPositionTask", initPositionTask)
  207. // 每日4:01更新每刻报销-客户档案
  208. syncMaycurCompanyProfile := task.NewTask("syncMaycurCompanyProfile", "0 1 4 * * * ", maycur.DailyUpdateCompanyProfile)
  209. task.AddTask("每日更新每刻报销-客户档案", syncMaycurCompanyProfile)
  210. // ETA商家到期提醒
  211. etaBusinessRemind := task.NewTask("etaBusinessRemind", "0 20 8 * * *", EtaBusinessExpiredRemind)
  212. task.AddTask("etaBusinessRemind", etaBusinessRemind)
  213. }
  214. //func TaskTest() {
  215. // fmt.Println("The task is start")
  216. //
  217. // //e, msg := data.InitTradePosition("shanghai", "2023-05-05", "2023-05-05")
  218. // //if e != nil {
  219. // // fmt.Println(e.Error())
  220. // // fmt.Println(msg)
  221. // //}
  222. //
  223. // //var ctx context.Context
  224. // //_ = EtaBusinessExpiredRemind(ctx)
  225. // //_ = EtaBusinessUpdateStatus(ctx)
  226. //
  227. // //task.StartTask()
  228. // fmt.Println("The task is end")
  229. //}
  230. func SendEmail(cont context.Context) (err error) {
  231. //报告历史访问次数
  232. go ReportViewTimes()
  233. //报告访问详情
  234. go ReportViewDetail()
  235. //用户权限统计
  236. go HongzeUsers()
  237. return
  238. }
  239. func OneMinute(cont context.Context) (err error) {
  240. //日度
  241. //FrequencyByDay()
  242. //周度
  243. FrequencyByWeek()
  244. //月度
  245. FrequencyByMonth()
  246. return
  247. }
  248. func RefreshData(cont context.Context) (err error) {
  249. wg := sync.WaitGroup{}
  250. wg.Add(16)
  251. //hour := time.Now().Hour()
  252. //if hour != 0 {
  253. //}
  254. go data.RefreshDataFromWind(&wg)
  255. //同花顺
  256. go data.RefreshDataFromThs(&wg)
  257. //彭博
  258. go data.RefreshDataFromPb(&wg)
  259. //彭博财务
  260. go data.RefreshDataFromPbFinance(&wg)
  261. //手工数据
  262. go data.RefreshDataFromManual(&wg)
  263. //隆众数据
  264. go data.RefreshDataFromLz(&wg)
  265. //有色
  266. go data.RefreshDataFromYs(&wg)
  267. //钢联
  268. go data.RefreshDataFromGl(&wg)
  269. //路透
  270. go data.RefreshDataFromLt(&wg)
  271. //煤炭
  272. go data.RefreshDataFromCoal(&wg)
  273. //谷歌出行数据
  274. go data.RefreshDataFromGoogleTravel(&wg)
  275. //钢联化工
  276. go data.RefreshDataFromMysteelChemical(&wg)
  277. //eia steo报告指标
  278. go data.RefreshDataFromEiaSteo(&wg)
  279. //UN报告指标
  280. go data.RefreshDataFromComTrade(&wg)
  281. //卓创报告指标
  282. go data.RefreshDataFromSci(&wg)
  283. //国家统计局指标
  284. go data.RefreshDataFromNationalStatistics(&wg)
  285. wg.Wait()
  286. ////计算指标
  287. data.RefreshDataFromCalculateAll()
  288. // 预测计算指标
  289. data.RefreshPredictDataFromCalculateAll()
  290. time.Sleep(5 * time.Second)
  291. data.RefreshNotice()
  292. fmt.Println("Refresh End")
  293. return
  294. }
  295. // RefreshFutureGoodData 刷新商品数据
  296. func RefreshFutureGoodData(cont context.Context) (err error) {
  297. future_good.RefreshFutureGoodDataFromThs()
  298. fmt.Println("Refresh End")
  299. return
  300. }
  301. // RefreshTradeData 刷新交易所数据
  302. func RefreshTradeData(cont context.Context) (err error) {
  303. wg := sync.WaitGroup{}
  304. wg.Add(5)
  305. //郑商所
  306. go data.RefreshDataFromZz(&wg)
  307. //上期所
  308. go data.RefreshDataFromSh(&wg)
  309. //上期能源
  310. go data.RefreshDataFromShfe(&wg)
  311. //中金所
  312. go data.RefreshDataFromCffex(&wg)
  313. //大商所
  314. go data.RefreshDataFromDl(&wg)
  315. wg.Wait()
  316. //计算指标
  317. data.RefreshDataFromCalculateAll()
  318. // 计算预测指标
  319. data.RefreshPredictDataFromCalculateAll()
  320. return
  321. }
  322. // RefreshEicData 刷新欧洲天然气数据
  323. func RefreshEicData(cont context.Context) (err error) {
  324. wg := sync.WaitGroup{}
  325. wg.Add(1)
  326. //欧洲天然气
  327. go data.RefreshDataFromEic(&wg)
  328. wg.Wait()
  329. //计算指标
  330. data.RefreshDataFromCalculateAll()
  331. // 计算预测指标
  332. data.RefreshPredictDataFromCalculateAll()
  333. return
  334. }
  335. // 刷新基础数据
  336. func RefreshBaseData(cont context.Context) (err error) {
  337. now := time.Now()
  338. if now.Hour() == 0 || now.Hour() == 19 {
  339. return nil
  340. }
  341. //同步有色基础指标数据
  342. go data.SyncSmmIndexDataBase()
  343. return
  344. }
  345. // 刷新基础数据
  346. func SyncBaseData(cont context.Context) (err error) {
  347. now := time.Now()
  348. if now.Hour() == 0 || now.Hour() == 19 {
  349. return nil
  350. }
  351. //同步钢联基础数据
  352. go data.SyncGlDataBase()
  353. return
  354. }
  355. // 刷新基础数据
  356. func SyncBaseDataExt(cont context.Context) (err error) {
  357. now := time.Now()
  358. if now.Hour() == 0 || now.Hour() == 19 {
  359. return nil
  360. }
  361. //同步隆众基础数据
  362. go data.SyncLzDataBase()
  363. //同步手工数据
  364. go data.SyncManualDataBase()
  365. //同步有色基础数据
  366. go data.SyncSmmDataBase()
  367. //刷新图表中,指标的最新日期
  368. go data.SetChartEdbEndDate()
  369. return
  370. }
  371. // EdbTaskNameMap 手工指标定时任务名称map集合
  372. var EdbTaskNameMap map[string]map[string]bool
  373. // EdbTaskNameChannel 手工指标定时任务名称channel
  374. var EdbTaskNameChannel chan string
  375. // EdbTaskStopChannel 手工指标定时任务停止channel
  376. var EdbTaskStopChannel chan string
  377. // EdbTaskRunNum 手工指标定时任务开始次数
  378. var EdbTaskRunNum int
  379. // AddEdbTask 新增手工指标数据录入提醒
  380. func AddEdbTask(cont context.Context) (err error) {
  381. //失败列表
  382. failList := make([]string, 0)
  383. defer func() {
  384. if len(failList) > 0 {
  385. fmt.Println("提醒失败:")
  386. for _, v := range failList {
  387. fmt.Println(v)
  388. }
  389. }
  390. }()
  391. list, err := models.GetEdbInfoByFrequencyNotDay()
  392. if err != nil {
  393. fmt.Println("查询获取频度非日度 且 提醒时间不为空 的指标数据失败,Err:", err.Error())
  394. }
  395. //如果还没有初始化map,那么先初始
  396. if EdbTaskNameMap == nil {
  397. EdbTaskNameMap = make(map[string]map[string]bool)
  398. }
  399. tmpEdbTaskNameMap := make(map[string]bool)
  400. // 今天的日期字符串(格式:2021-10-25)
  401. todayStr := time.Now().Format(utils.FormatDate)
  402. //当前周的周一与周日
  403. nowWeekFirstDay := utils.GetNowWeekMonday()
  404. nowWeekLastDay := utils.GetNowWeekLastDay()
  405. //当前月的一号与最后一天
  406. nowMonthFirstDay := utils.GetNowMonthFirstDay()
  407. nowMonthLastDay := utils.GetNowMonthLastDay()
  408. //当前季度的第一天与最后一天
  409. nowQuarterFirstDay := utils.GetNowQuarterFirstDay()
  410. nowQuarterLastDay := utils.GetNowQuarterLastDay()
  411. //当前半年的第一天与最后一天
  412. nowHalfYearFirstDay := utils.GetNowHalfYearFirstDay()
  413. nowHalfYearLastDay := utils.GetNowHalfYearLastDay()
  414. // 当前年的第一天与最后一天
  415. nowYearFirstDay := utils.GetNowYearFirstDay()
  416. nowYearLastDay := utils.GetNowYearLastDay()
  417. debugNoticeUserId := 0 //测试环境,需要发送消息的用户
  418. //测试环境也不发了
  419. //if utils.RunMode == "debug" {
  420. // tmpWxUser, tmpErr := models.GetWxUserByMobile("17634786714")
  421. // if tmpErr == nil && tmpWxUser != nil {
  422. // //debugNoticeUserId = 44078 //测试环境的话,发送邮箱给颜鹏
  423. // debugNoticeUserId = int(tmpWxUser.UserId) //测试环境的话,发送邮箱给嘉豪
  424. // }
  425. //}
  426. //task.globalTaskManager.adminTaskList
  427. for _, edb := range list {
  428. if edb.UserId <= 0 {
  429. continue //没有配置user_id的话,那么不需要提醒
  430. }
  431. tmpEdb := edb //指标信息
  432. isNotice := false //是否需要提醒
  433. noticeTime := "12:00:00" //提醒时间
  434. var dataDtTime time.Time
  435. edbData, tmpErr := models.GetLastEdbdataInfo(tmpEdb.TradeCode)
  436. if tmpErr != nil {
  437. if tmpErr.Error() != utils.ErrNoRow() {
  438. failList = append(failList, fmt.Sprint(tmpEdb.TradeCode, "失败,Err:", tmpErr.Error()))
  439. continue
  440. }
  441. }
  442. //如果确实是有数据的
  443. if edbData != nil {
  444. tmpDataDtTime, _ := time.ParseInLocation(utils.FormatDate, edbData.Dt, time.Now().Location())
  445. dataDtTime = tmpDataDtTime
  446. }
  447. switch tmpEdb.Frequency {
  448. case "周度":
  449. modifyDate := nowWeekLastDay //下次更新日期
  450. if tmpEdb.NoticeTime != "" {
  451. addDay := 7
  452. noticeArr := strings.Split(tmpEdb.NoticeTime, " ")
  453. if len(noticeArr) >= 2 {
  454. noticeTime = noticeArr[1]
  455. }
  456. noticeWeek := noticeArr[0]
  457. switch noticeWeek {
  458. case "周一":
  459. addDay = 1
  460. case "周二":
  461. addDay = 2
  462. case "周三":
  463. addDay = 3
  464. case "周四":
  465. addDay = 4
  466. case "周五":
  467. addDay = 5
  468. case "周六":
  469. addDay = 6
  470. case "周日":
  471. addDay = 7
  472. }
  473. modifyDate = modifyDate.AddDate(0, 0, addDay-7)
  474. }
  475. //如果正好是提醒日,同时本周没有过记录,那么需要提醒
  476. if todayStr == modifyDate.Format(utils.FormatDate) && !nowWeekFirstDay.Before(dataDtTime) {
  477. isNotice = true
  478. }
  479. case "月度":
  480. addDay := 0
  481. modifyDate := nowMonthLastDay //下次更新日期
  482. if tmpEdb.NoticeTime != "" {
  483. strArr := strings.Split(tmpEdb.NoticeTime, "日")
  484. if len(strArr) >= 2 {
  485. noticeTime = strArr[1]
  486. }
  487. tmpAddDay, tmpErr := strconv.Atoi(strArr[0])
  488. if tmpErr != nil {
  489. continue
  490. }
  491. addDay = tmpAddDay - 1
  492. modifyDate = nowMonthFirstDay.AddDate(0, 0, addDay)
  493. }
  494. //如果正好是提醒日,同时本月没有过记录,那么需要提醒
  495. if todayStr == modifyDate.Format(utils.FormatDate) && !nowMonthFirstDay.Before(dataDtTime) {
  496. isNotice = true
  497. }
  498. case "季度":
  499. //提醒时间
  500. if tmpEdb.NoticeTime != "" {
  501. noticeArr := strings.Split(tmpEdb.NoticeTime, " ")
  502. if len(noticeArr) >= 2 {
  503. noticeTime = noticeArr[1]
  504. }
  505. }
  506. //每季度更新数据时间
  507. //如果正好是提醒日(每季度最后一天),同时本季度没有过记录,那么需要提醒
  508. if todayStr == nowQuarterLastDay.Format(utils.FormatDate) && !nowQuarterFirstDay.Before(dataDtTime) {
  509. isNotice = true
  510. }
  511. case "半年度":
  512. //提醒时间
  513. if tmpEdb.NoticeTime != "" {
  514. noticeArr := strings.Split(tmpEdb.NoticeTime, " ")
  515. if len(noticeArr) >= 2 {
  516. noticeTime = noticeArr[1]
  517. }
  518. }
  519. //每半年度更新数据时间
  520. //如果正好是提醒日(每半年度最后一天),同时本半年度没有过记录,那么需要提醒
  521. if todayStr == nowHalfYearLastDay.Format(utils.FormatDate) && !nowHalfYearFirstDay.Before(dataDtTime) {
  522. isNotice = true
  523. }
  524. case "年度":
  525. //提醒时间
  526. if tmpEdb.NoticeTime != "" {
  527. noticeArr := strings.Split(tmpEdb.NoticeTime, " ")
  528. if len(noticeArr) >= 2 {
  529. noticeTime = noticeArr[1]
  530. }
  531. }
  532. //每年度更新数据时间
  533. //如果正好是提醒日(每年度最后一天),同时半年度没有过记录,那么需要提醒
  534. if todayStr == nowYearLastDay.Format(utils.FormatDate) && !nowYearFirstDay.Before(dataDtTime) {
  535. isNotice = true
  536. }
  537. }
  538. if isNotice {
  539. taskName := "edb_task_" + todayStr + ":" + fmt.Sprint(tmpEdb.TradeCode)
  540. //fmt.Println(taskName, ";", tmpEdb.SecName)
  541. //定时任务
  542. tmpTaskFunc := func(ctx context.Context) (funcErr error) {
  543. //方法执行结束后,移除定时任务
  544. defer func() {
  545. EdbTaskNameChannel <- taskName
  546. }()
  547. // 匿名方法内判断是否发送提醒,因为可能时间到的时候,发现
  548. funcIsNotice := false
  549. // 再次获取指标数据详情
  550. edbData, tmpErr := models.GetLastEdbdataInfo(tmpEdb.TradeCode)
  551. if tmpErr != nil {
  552. if tmpErr.Error() != utils.ErrNoRow() {
  553. funcErr = tmpErr
  554. return
  555. }
  556. }
  557. if utils.RunMode == "debug" && debugNoticeUserId > 0 {
  558. tmpEdb.UserId = debugNoticeUserId //测试环境的话,发送邮箱给嘉豪
  559. }
  560. //数据过期时间
  561. var funcDataDtTime time.Time
  562. //如果确实是有数据的
  563. if edbData != nil {
  564. tmpDataDtTime, _ := time.ParseInLocation(utils.FormatDate, edbData.Dt, time.Now().Location())
  565. funcDataDtTime = tmpDataDtTime
  566. }
  567. //提示频度文案
  568. notifyFrequency := "每日"
  569. switch tmpEdb.Frequency {
  570. case "周度":
  571. notifyFrequency = "每周"
  572. modifyDate := nowWeekLastDay //下次更新日期
  573. if tmpEdb.NoticeTime != "" {
  574. addDay := 7
  575. noticeArr := strings.Split(tmpEdb.NoticeTime, " ")
  576. if len(noticeArr) >= 2 {
  577. noticeTime = noticeArr[1]
  578. }
  579. noticeWeek := noticeArr[0]
  580. switch noticeWeek {
  581. case "周一":
  582. addDay = 1
  583. case "周二":
  584. addDay = 2
  585. case "周三":
  586. addDay = 3
  587. case "周四":
  588. addDay = 4
  589. case "周五":
  590. addDay = 5
  591. case "周六":
  592. addDay = 6
  593. case "周日":
  594. addDay = 7
  595. }
  596. modifyDate = modifyDate.AddDate(0, 0, addDay-7)
  597. }
  598. //如果正好是提醒日,同时本周没有过记录,那么需要提醒
  599. if todayStr == modifyDate.Format(utils.FormatDate) && !nowWeekFirstDay.Before(funcDataDtTime) {
  600. funcIsNotice = true
  601. }
  602. case "月度":
  603. notifyFrequency = "每月"
  604. addDay := 0
  605. modifyDate := nowMonthLastDay //下次更新日期
  606. if tmpEdb.NoticeTime != "" {
  607. strArr := strings.Split(tmpEdb.NoticeTime, "日")
  608. if len(strArr) >= 2 {
  609. noticeTime = strArr[1]
  610. }
  611. tmpAddDay, tmpErr := strconv.Atoi(strArr[0])
  612. if tmpErr != nil {
  613. funcErr = tmpErr
  614. }
  615. addDay = tmpAddDay - 1
  616. modifyDate = nowMonthFirstDay.AddDate(0, 0, addDay)
  617. }
  618. //如果正好是提醒日,同时本月没有过记录,那么需要提醒
  619. if todayStr == modifyDate.Format(utils.FormatDate) && !nowMonthFirstDay.Before(funcDataDtTime) {
  620. funcIsNotice = true
  621. }
  622. case "季度":
  623. notifyFrequency = "每季度"
  624. //提醒时间
  625. if tmpEdb.NoticeTime != "" {
  626. noticeArr := strings.Split(tmpEdb.NoticeTime, " ")
  627. if len(noticeArr) >= 2 {
  628. noticeTime = noticeArr[1]
  629. }
  630. }
  631. //每季度更新数据时间
  632. //如果正好是提醒日(每季度最后一天),同时本季度没有过记录,那么需要提醒
  633. if todayStr == nowQuarterLastDay.Format(utils.FormatDate) && !nowQuarterFirstDay.Before(funcDataDtTime) {
  634. funcIsNotice = true
  635. }
  636. case "半年度":
  637. notifyFrequency = "每半年度"
  638. //提醒时间
  639. if tmpEdb.NoticeTime != "" {
  640. noticeArr := strings.Split(tmpEdb.NoticeTime, " ")
  641. if len(noticeArr) >= 2 {
  642. noticeTime = noticeArr[1]
  643. }
  644. }
  645. //每半年度更新数据时间
  646. //如果正好是提醒日(每半年度最后一天),同时本半年度没有过记录,那么需要提醒
  647. if todayStr == nowHalfYearLastDay.Format(utils.FormatDate) && !nowHalfYearFirstDay.Before(funcDataDtTime) {
  648. funcIsNotice = true
  649. }
  650. case "年度":
  651. notifyFrequency = "每年"
  652. //提醒时间
  653. if tmpEdb.NoticeTime != "" {
  654. noticeArr := strings.Split(tmpEdb.NoticeTime, " ")
  655. if len(noticeArr) >= 2 {
  656. noticeTime = noticeArr[1]
  657. }
  658. }
  659. //每年度更新数据时间
  660. //如果正好是提醒日(每年度最后一天),同时半年度没有过记录,那么需要提醒
  661. if todayStr == nowYearLastDay.Format(utils.FormatDate) && !nowYearFirstDay.Before(funcDataDtTime) {
  662. funcIsNotice = true
  663. }
  664. }
  665. //fmt.Println(tmpEdb.TradeCode, " funcIsNotice:", funcIsNotice)
  666. //如果还是要提醒
  667. if funcIsNotice {
  668. //用户微信openid列表数据
  669. openIdList := make([]*models.OpenIdList, 0)
  670. //获取用户信息
  671. admin, err := models.GetAdminByAdminId(tmpEdb.UserId)
  672. if err != nil {
  673. if err.Error() == utils.ErrNoRow() {
  674. funcErr = errors.New("openId 列表为空" + strconv.Itoa(tmpEdb.UserId))
  675. return
  676. } else {
  677. return err
  678. }
  679. }
  680. if admin == nil {
  681. funcErr = errors.New("openId 列表为空" + strconv.Itoa(tmpEdb.UserId))
  682. return
  683. }
  684. //发送消息
  685. if admin.OpenId == "" {
  686. funcErr = errors.New("openId 列表为空" + strconv.Itoa(tmpEdb.UserId))
  687. return
  688. }
  689. openIdTemp := new(models.OpenIdList)
  690. openIdTemp.OpenId = admin.OpenId
  691. openIdList = append(openIdList, openIdTemp)
  692. first := "数据录入提醒"
  693. keyword1 := tmpEdb.SecName + "该更新了"
  694. keyword2 := notifyFrequency + " " + tmpEdb.NoticeTime
  695. remark := tmpEdb.SecName + "该更新了"
  696. err = SendWxMsgWithFrequency(first, keyword1, keyword2, remark, openIdList)
  697. if err != nil {
  698. return err
  699. }
  700. //发送成功,记录发送日志
  701. {
  702. sendRecord := new(models.EdbinfoSendMsgRecord)
  703. sendRecord.UserId = tmpEdb.UserId
  704. sendRecord.TradeCode = tmpEdb.TradeCode
  705. sendRecord.CreateTime = time.Now()
  706. err = models.AddEdbinfoSendMsgRecord(sendRecord)
  707. if err != nil {
  708. return err
  709. }
  710. }
  711. }
  712. return
  713. }
  714. //添加定时任务(没有设置通知时间就不进行定时任务通知了)
  715. spec := ``
  716. if noticeTime != "" {
  717. noticeArr := strings.Split(noticeTime, ":")
  718. if len(noticeArr) == 3 {
  719. //spec = ` */20 * * * * * `
  720. spec = fmt.Sprintf(` %s %s %s * * * `, noticeArr[2], noticeArr[1], noticeArr[0])
  721. //定时任务开始的时间
  722. tmpTask := task.NewTask(taskName, spec, tmpTaskFunc)
  723. task.AddTask(taskName, tmpTask)
  724. tmpEdbTaskNameMap[taskName] = true
  725. }
  726. }
  727. }
  728. }
  729. //将当天的手工指标加入到手工指标池去
  730. EdbTaskNameMap[todayStr] = tmpEdbTaskNameMap
  731. //开启协程,用来清除定时任务
  732. go deleteTask()
  733. //如果当前定时任务执行次数大于0次,那么需要往手工指标定时任务停止channel写入数据,用来关闭昨天没有执行的的定时任务
  734. if EdbTaskRunNum > 0 {
  735. //清除昨天的数据
  736. EdbTaskStopChannel <- time.Now().AddDate(0, 0, -1).Format(utils.FormatDate)
  737. }
  738. //手工指标定时任务开始次数累加
  739. EdbTaskRunNum++
  740. return
  741. //fmt.Println(task.NewMapSorter())
  742. }
  743. // deleteTask 清除已通知的任务
  744. func deleteTask() {
  745. for {
  746. select {
  747. case taskName := <-EdbTaskNameChannel:
  748. task.DeleteTask(taskName)
  749. delete(EdbTaskNameMap, taskName)
  750. case dayStr := <-EdbTaskStopChannel: //收到停止信号,先清除掉那一天的定时任务,
  751. for taskName := range EdbTaskNameMap[dayStr] {
  752. task.DeleteTask(taskName)
  753. delete(EdbTaskNameMap, taskName)
  754. }
  755. break
  756. }
  757. }
  758. }
  759. // 检测数据服务
  760. func checkDataServer(cont context.Context) (err error) {
  761. //检测wind新服务器
  762. go data.CheckWindDataInterface(cont)
  763. //检测同花顺数据服务器
  764. //go data.CheckThsDataInterface(cont)
  765. //检测路透数据服务器
  766. go data.CheckLtDataInterface(cont)
  767. //检测彭博
  768. go data.CheckPbDataInterface(cont)
  769. return
  770. }