task.go 12 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372
  1. package services
  2. import (
  3. "context"
  4. "eta/eta_task/services/data"
  5. "eta/eta_task/services/data/future_good"
  6. "eta/eta_task/services/data_stat"
  7. "eta/eta_task/utils"
  8. "fmt"
  9. "sync"
  10. "time"
  11. "github.com/beego/beego/v2/task"
  12. )
  13. func Task() {
  14. fmt.Println("开始数据同步")
  15. SyncHzDataIndex(nil)
  16. //SyncRankingFromDalian(nil)
  17. fmt.Println("结束数据同步")
  18. return
  19. fmt.Println("task start")
  20. //如果是生产环境,才需要走这些任务
  21. if utils.RunMode == "release" {
  22. releaseTask()
  23. }
  24. // 定时发布智能研报
  25. publishSmartReport := task.NewTask("publishSmartReport", "0 */1 * * * *", PublishSmartReport)
  26. task.AddTask("定时发布智能研报", publishSmartReport)
  27. // 定时发布研报
  28. publishReport := task.NewTask("publishReport", "0 */1 * * * *", PublishReport)
  29. task.AddTask("定时发布研报", publishReport)
  30. // 定时汇总数据源终端指标更新情况
  31. setEdbSourceStatTask := task.NewTask("setEdbSourceStatTask", "0 20 19,23 * * *", data_stat.SetEdbSourceStatTask)
  32. task.AddTask("数据源统计表", setEdbSourceStatTask)
  33. XyTask()
  34. // 测试-刷新多空分析/相关性表格
  35. if utils.RunMode == "debug" {
  36. refreshTradeAnalysisTables := task.NewTask("refreshTradeAnalysisTables", "0 0 20 * * *", data.RefreshTradeAnalysisTables)
  37. task.AddTask("refreshTradeAnalysisTables", refreshTradeAnalysisTables)
  38. }
  39. // 测试-同步数据源ES
  40. if utils.RunMode == "debug" {
  41. syncDataSourceEs := task.NewTask("syncDataSourceEs", "0 30 4 * * *", data.SyncDataSourceEs)
  42. task.AddTask("syncDataSourceEs", syncDataSourceEs)
  43. }
  44. task.StartTask()
  45. fmt.Println("task end")
  46. }
  47. // 生产环境需要走的任务
  48. func releaseTask() {
  49. //同步指标
  50. if utils.BusinessCode != utils.BusinessCodeRelease {
  51. syncHzDataIndex := task.NewTask("syncHzDataIndex", "0 10,20,40,50 16,18 * * *", SyncHzDataIndex)
  52. task.AddTask("syncHzDataIndex", syncHzDataIndex)
  53. syncRankingFromDalian := task.NewTask("syncRankingFromDalian", "0 30,40,50 16,18 * * *", SyncRankingFromDalian)
  54. task.AddTask("syncRankingFromDalian", syncRankingFromDalian)
  55. }
  56. if utils.BusinessCode == utils.BusinessCodeRelease {
  57. // 定时刷新公众号文章
  58. refreshWechatPlatform := task.NewTask("refreshWechatPlatform", "0 0 14 * * *", RefreshWechatPlatform)
  59. task.AddTask("定时刷新公众号文章", refreshWechatPlatform)
  60. }
  61. // 定时统计交易所的持仓分析数据
  62. initPositionTask := task.NewTask("initPositionTask", "0 20,40 16-19 * * *", data.InitPositionTask)
  63. task.AddTask("initPositionTask", initPositionTask)
  64. //刷新指标数据
  65. refreshData := task.NewTask("refreshData", "0 30 0,19 * * *", RefreshData)
  66. task.AddTask("refreshData", refreshData)
  67. // 根据配置刷新指标数据
  68. configRefreshData := task.NewTask("syncBaseDataExt", "0 */30 * * * * ", ConfigRefreshData)
  69. task.AddTask("configRefreshData", configRefreshData)
  70. // 定时刷新计算指标-默认每天的7:05,8:05分刷新计算指标
  71. refreshCalculateEdbTaskTime := utils.RefreshCalculateEdbTaskTime
  72. if refreshCalculateEdbTaskTime == "" {
  73. refreshCalculateEdbTaskTime = "0 5 7,8 * * *"
  74. }
  75. refreshAllCalculateEdbData := task.NewTask("refreshAllCalculateEdbData", refreshCalculateEdbTaskTime, RefreshAllCalculateEdbData)
  76. task.AddTask("refreshAllCalculateEdbData", refreshAllCalculateEdbData)
  77. // 定时禁用钢联化工和wind指标的刷新状态
  78. disableEdbRefresh := task.NewTask("disableEdbRefresh", "0 0 10 * * *", DisableEdbRefresh)
  79. task.AddTask("disableEdbRefresh", disableEdbRefresh)
  80. //同步弘则数据库中来自,钢联,隆众,有色,人工等基础数据--每隔五分钟,同步一次最新数据
  81. syncBaseData := task.NewTask("syncBaseData", "0 */5 * * * * ", SyncBaseData)
  82. task.AddTask("syncBaseData", syncBaseData)
  83. syncBaseDataExt := task.NewTask("syncBaseDataExt", "0 */30 * * * * ", SyncBaseDataExt)
  84. task.AddTask("syncBaseDataExt", syncBaseDataExt)
  85. //初始化指标更新状态
  86. resetEdbInfoIsUpdate := task.NewTask("resetEdbInfoIsUpdate", "0 0 0 * * *", data.ResetEdbInfoIsUpdate)
  87. task.AddTask("resetEdbInfoIsUpdate", resetEdbInfoIsUpdate)
  88. // 刷新商品数据
  89. refreshFutureGoodData := task.NewTask("refreshFutureGoodData", "0 30 0,19 * * *", RefreshFutureGoodData)
  90. task.AddTask("refreshFutureGoodData", refreshFutureGoodData)
  91. //刷新交易所指标数据
  92. refreshTradeData := task.NewTask("refreshData", "0 1 4 * * *", RefreshTradeData)
  93. task.AddTask("refreshTradeData", refreshTradeData)
  94. //刷新欧洲天然气指标数据
  95. refreshEicData := task.NewTask("refreshData", "0 1 3,7 * * *", RefreshEicData)
  96. task.AddTask("refreshEicData", refreshEicData)
  97. //检测数据服务器
  98. checkDataServer := task.NewTask("checkDataServer", "0 */2 * * * * ", checkDataServer)
  99. task.AddTask("checkDataServer", checkDataServer)
  100. //删除日志 report_save_log,ppt_v2_save_log,保留一个月的
  101. deleteLog := task.NewTask("syncSubStatus", "0 0 2 2 * *", DeleteLog)
  102. task.AddTask("deleteLog", deleteLog)
  103. // 定时发布英文研报
  104. publishEnglishReport := task.NewTask("publishEnglishReport", "0 */1 * * * *", PublishEnglishReport)
  105. task.AddTask("定时发布英文研报", publishEnglishReport)
  106. // 每天清理两周前的报告保存日志
  107. clearReportSaveLog := task.NewTask("clearReportSaveLog", "0 15 23 * * *", ClearReportSaveLog)
  108. task.AddTask("定时清理报告保存日志", clearReportSaveLog)
  109. // 每天清理三个月前的用户操作日志
  110. clearAdminOperateLog := task.NewTask("clearAdminOperateLog", "0 20 23 * * *", ClearAdminOperateLog)
  111. task.AddTask("定时清理用户操作日志", clearAdminOperateLog)
  112. // 嘉悦物产
  113. if utils.BusinessCode == utils.BusinessCodeJiaYue {
  114. // 每10分钟定时同步增量指标
  115. syncJiaYueNewIndex := task.NewTask("syncJiaYueNewIndex", "0 */10 * * * *", data.SyncJiaYueNewIndex)
  116. task.AddTask("定时同步嘉悦物产增量指标", syncJiaYueNewIndex)
  117. // 每30分钟同步一次数据宝指标数据
  118. syncJiaYueDataBaby := task.NewTask("syncJiaYueDataBaby", "0 */30 * * * * ", data.RefreshJiaYueDataFromBridge)
  119. task.AddTask("syncJiaYueDataBaby", syncJiaYueDataBaby)
  120. }
  121. if utils.BusinessCode == utils.BusinessCodeZhongJi {
  122. // 每天同步一次指标列表
  123. syncZhongJiIndexList := task.NewTask("syncZhongJiIndexList", "0 0 17 * * *", data.SyncZhongJiIndexList)
  124. task.AddTask("定时同步中基宁波SMM指标列表", syncZhongJiIndexList)
  125. }
  126. // 中石油新加坡
  127. if utils.IsPCSG == "1" {
  128. refreshPCSGBloomberg := task.NewTask("refreshPCSGBloombergDaily", "0 */30 * * * *", data.RefreshPCSGBloomberg)
  129. task.AddTask("中石油新加坡-每日Bloomberg指标刷新", refreshPCSGBloomberg)
  130. }
  131. // 刷新同花顺高频
  132. refreshThsHfBase := task.NewTask("refreshThsHfBase", "0 0 0,6,9,12,15,18,21 * * *", data.RefreshBaseFromThsHfIndex)
  133. task.AddTask("refreshThsHfBase", refreshThsHfBase)
  134. // (基于交易所数据)多空分析/相关性表格刷新
  135. refreshTradeAnalysisTables := task.NewTask("refreshTradeAnalysisTables", "0 0 20 * * *", data.RefreshTradeAnalysisTables)
  136. task.AddTask("refreshTradeAnalysisTables", refreshTradeAnalysisTables)
  137. // 每日同步数据源ES(business_conf可开关)
  138. syncDataSourceEs := task.NewTask("syncDataSourceEs", "0 30 4 * * *", data.SyncDataSourceEs)
  139. task.AddTask("syncDataSourceEs", syncDataSourceEs)
  140. }
  141. func RefreshData(cont context.Context) (err error) {
  142. wg := sync.WaitGroup{}
  143. wg.Add(12)
  144. //hour := time.Now().Hour()
  145. //if hour != 0 {
  146. //}
  147. //彭博
  148. //go data.RefreshDataFromPb(&wg)
  149. //彭博财务
  150. //go data.RefreshDataFromPbFinance(&wg)
  151. //手工数据
  152. go data.RefreshDataFromManual(&wg)
  153. //隆众数据
  154. //go data.RefreshDataFromLz(&wg)
  155. //有色
  156. go data.RefreshDataFromYs(&wg)
  157. //钢联
  158. go data.RefreshDataFromGl(&wg)
  159. //路透
  160. go data.RefreshDataFromLt(&wg)
  161. //煤炭
  162. go data.RefreshDataFromCoal(&wg)
  163. //谷歌出行数据
  164. go data.RefreshDataFromGoogleTravel(&wg)
  165. //钢联化工
  166. go data.RefreshDataFromMysteelChemical(&wg)
  167. //eia steo报告指标
  168. go data.RefreshDataFromEiaSteo(&wg)
  169. //UN报告指标
  170. go data.RefreshDataFromComTrade(&wg)
  171. //卓创报告指标
  172. go data.RefreshDataFromSci(&wg)
  173. //国家统计局指标
  174. go data.RefreshDataFromNationalStatistics(&wg)
  175. //富宝指标刷新
  176. go data.RefreshDataFromFubao(&wg)
  177. // Bloomberg
  178. go func() {
  179. wg.Add(1)
  180. _ = data.RefreshDataFromBloomberg(&wg)
  181. }()
  182. // CCF化纤信息
  183. go func() {
  184. wg.Add(1)
  185. _ = data.RefreshDataFromCCF(&wg)
  186. }()
  187. // 持仓分析
  188. go func() {
  189. wg.Add(1)
  190. _ = data.RefreshDataFromTradeAnalysis(&wg)
  191. }()
  192. wg.Wait()
  193. ////计算指标
  194. data.RefreshDataFromCalculateAll()
  195. // 刷新所有的基础预测指标
  196. data.RefreshBasePredictDataAll()
  197. // 预测计算指标
  198. data.RefreshPredictDataFromCalculateAll()
  199. // 指标系列计算数据
  200. _ = data.RefreshFactorEdbCalculateData()
  201. // 指标系列图表计算数据
  202. _ = data.RefreshFactorEdbChartCalculateData()
  203. // 刷新商品利润曲线图表数据
  204. _ = data.RefreshFutureGoodProfitChart()
  205. // 刷新计算指标-依赖指标id大于当前计算指标id的计算指标
  206. data.RefreshDataFromCalculateAfter()
  207. time.Sleep(5 * time.Second)
  208. //data.RefreshNotice()
  209. fmt.Println("Refresh End")
  210. return
  211. }
  212. // 刷新所有计算指标数据
  213. func RefreshAllCalculateEdbData(cont context.Context) (err error) {
  214. ////计算指标
  215. err = data.RefreshDataFromCalculateAll()
  216. return
  217. }
  218. // SyncBaseData 刷新基础数据
  219. func SyncBaseData(cont context.Context) (err error) {
  220. now := time.Now()
  221. if now.Hour() == 0 || now.Hour() == 19 {
  222. return nil
  223. }
  224. //同步钢联基础数据
  225. if utils.BusinessCode == utils.BusinessCodeRelease {
  226. go data.SyncGlDataBase()
  227. }
  228. return
  229. }
  230. // SyncBaseDataExt 刷新基础数据
  231. func SyncBaseDataExt(cont context.Context) (err error) {
  232. now := time.Now()
  233. if now.Hour() == 0 || now.Hour() == 19 {
  234. return nil
  235. }
  236. //同步手工数据
  237. go data.SyncManualDataBase()
  238. //刷新图表中,指标的最新日期
  239. go data.SetChartEdbEndDate()
  240. return
  241. }
  242. // RefreshFutureGoodData 刷新商品数据
  243. func RefreshFutureGoodData(cont context.Context) (err error) {
  244. future_good.RefreshFutureGoodDataFromThs()
  245. fmt.Println("Refresh End")
  246. return
  247. }
  248. // RefreshTradeData 刷新交易所数据
  249. func RefreshTradeData(cont context.Context) (err error) {
  250. wg := sync.WaitGroup{}
  251. wg.Add(6)
  252. //郑商所
  253. go data.RefreshBaseDataFromSource(&wg, utils.DATA_SOURCE_ZZ)
  254. //上期所
  255. go data.RefreshBaseDataFromSource(&wg, utils.DATA_SOURCE_SH)
  256. //上期能源
  257. go data.RefreshBaseDataFromSource(&wg, utils.DATA_SOURCE_SHFE)
  258. //中金所
  259. go data.RefreshBaseDataFromSource(&wg, utils.DATA_SOURCE_CFFEX)
  260. //大商所
  261. go data.RefreshBaseDataFromSource(&wg, utils.DATA_SOURCE_DL)
  262. //广期所数据
  263. go data.RefreshBaseDataFromSource(&wg, utils.DATA_SOURCE_GFEX)
  264. wg.Wait()
  265. //计算指标
  266. data.RefreshDataFromCalculateAll()
  267. // 刷新所有的基础预测指标
  268. data.RefreshBasePredictDataAll()
  269. // 计算预测指标
  270. data.RefreshPredictDataFromCalculateAll()
  271. return
  272. }
  273. // RefreshEicData 刷新欧洲天然气数据
  274. func RefreshEicData(cont context.Context) (err error) {
  275. wg := sync.WaitGroup{}
  276. wg.Add(1)
  277. //欧洲天然气
  278. go data.RefreshDataFromEic(&wg)
  279. wg.Wait()
  280. ////计算指标
  281. //data.RefreshDataFromCalculateAll()
  282. //
  283. //// 刷新所有的基础预测指标
  284. //data.RefreshBasePredictDataAll()
  285. //
  286. //// 计算预测指标
  287. //data.RefreshPredictDataFromCalculateAll()
  288. return
  289. }
  290. // 检测数据服务
  291. func checkDataServer(cont context.Context) (err error) {
  292. //检测wind新服务器
  293. go data.CheckWindDataInterface(cont)
  294. //检测同花顺数据服务器
  295. //go data.CheckThsDataInterface(cont)
  296. //检测路透数据服务器
  297. go data.CheckLtDataInterface(cont)
  298. //检测彭博
  299. go data.CheckPbDataInterface(cont)
  300. return
  301. }
  302. func TaskInit() {
  303. fmt.Println("TaskInit start")
  304. //data.InitGuangzhouPositionTask()
  305. fmt.Println("TaskInit end")
  306. return
  307. }