edb_info.go 64 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979980981982983984985986987988989990991992993994995996997998999100010011002100310041005100610071008100910101011101210131014101510161017101810191020102110221023102410251026102710281029103010311032103310341035103610371038103910401041104210431044104510461047104810491050105110521053105410551056105710581059106010611062106310641065106610671068106910701071107210731074107510761077107810791080108110821083108410851086108710881089109010911092109310941095109610971098109911001101110211031104110511061107110811091110111111121113111411151116111711181119112011211122112311241125112611271128112911301131113211331134113511361137113811391140114111421143114411451146114711481149115011511152115311541155115611571158115911601161116211631164116511661167116811691170117111721173117411751176117711781179118011811182118311841185118611871188118911901191119211931194119511961197119811991200120112021203120412051206120712081209121012111212121312141215121612171218121912201221122212231224122512261227122812291230123112321233123412351236123712381239124012411242124312441245124612471248124912501251125212531254125512561257125812591260126112621263126412651266126712681269127012711272127312741275127612771278127912801281128212831284128512861287128812891290129112921293129412951296129712981299130013011302130313041305130613071308130913101311131213131314131513161317131813191320132113221323132413251326132713281329133013311332133313341335133613371338133913401341134213431344134513461347134813491350135113521353135413551356135713581359136013611362136313641365136613671368136913701371137213731374137513761377137813791380138113821383138413851386138713881389139013911392139313941395139613971398139914001401140214031404140514061407140814091410141114121413141414151416141714181419142014211422142314241425142614271428142914301431143214331434143514361437143814391440144114421443144414451446144714481449145014511452145314541455145614571458145914601461146214631464146514661467146814691470147114721473147414751476147714781479148014811482148314841485148614871488148914901491149214931494149514961497149814991500150115021503150415051506150715081509151015111512151315141515151615171518151915201521152215231524152515261527152815291530153115321533153415351536153715381539154015411542154315441545154615471548154915501551155215531554155515561557155815591560156115621563156415651566156715681569157015711572157315741575157615771578157915801581158215831584158515861587158815891590159115921593159415951596159715981599160016011602160316041605160616071608160916101611161216131614161516161617161816191620162116221623162416251626162716281629163016311632163316341635163616371638163916401641164216431644164516461647164816491650165116521653165416551656165716581659166016611662166316641665166616671668166916701671167216731674167516761677167816791680168116821683
  1. package data
  2. import (
  3. "context"
  4. "errors"
  5. "fmt"
  6. "github.com/rdlucklib/rdluck_tools/http"
  7. "hongze/hongze_task/models/data_manage"
  8. "hongze/hongze_task/services/alarm_msg"
  9. "hongze/hongze_task/utils"
  10. "sync"
  11. )
  12. //刷新同花顺数据
  13. func RefreshDataFromThs(wg *sync.WaitGroup) (err error) {
  14. defer func() {
  15. if err != nil {
  16. fmt.Println("RefreshDataFromThs Err:" + err.Error())
  17. //go utils.SendEmail(utils.APPNAME+"【"+utils.RunMode+"】"+"失败提醒", "RefreshDataFromThs ErrMsg:"+err.Error(), utils.EmailSendToUsers)
  18. go alarm_msg.SendAlarmMsg("RefreshDataFromThs ErrMsg:"+err.Error(), 3)
  19. }
  20. wg.Done()
  21. }()
  22. var condition string
  23. var pars []interface{}
  24. condition += " AND source=? "
  25. pars = append(pars, utils.DATA_SOURCE_THS)
  26. items, err := data_manage.GetEdbInfoByCondition(condition, pars, 0)
  27. if err != nil {
  28. err = errors.New("GetEdbInfoByCondition:" + err.Error())
  29. return
  30. }
  31. //var endDate string
  32. //endDate = time.Now().AddDate(utils.DATA_END_DATE_LIMIT, 0, 0).Format(utils.FormatDate)
  33. for _, v := range items {
  34. startDate := ""
  35. if v.Frequency == "日度" {
  36. startDate = v.EndDate.AddDate(0, 0, -utils.DATA_REFRESH).Format(utils.FormatDate)
  37. } else if v.Frequency == "周度" {
  38. startDate = v.EndDate.AddDate(0, 0, -(utils.DATA_REFRESH * 7)).Format(utils.FormatDate)
  39. } else if v.Frequency == "月度" {
  40. startDate = v.EndDate.AddDate(0, -utils.DATA_REFRESH, 0).Format(utils.FormatDate)
  41. } else if v.Frequency == "季度" {
  42. startDate = v.EndDate.AddDate(0, -utils.DATA_REFRESH*3, 0).Format(utils.FormatDate)
  43. } else if v.Frequency == "年度" {
  44. startDate = v.EndDate.AddDate(-utils.DATA_REFRESH, 0, 0).Format(utils.FormatDate)
  45. } else {
  46. startDate = v.EndDate.AddDate(0, 0, -utils.DATA_REFRESH).Format(utils.FormatDate)
  47. }
  48. //err = SyncEdbDataByThs(int64(v.EdbInfoId), v.EdbCode, startDate, endDate)
  49. //if err != nil {
  50. // err = errors.New("SyncEdbDataByThs Err:" + err.Error())
  51. // return err
  52. //}
  53. resp, err := RefreshEdbData(v.EdbInfoId, v.Source, v.EdbCode, startDate)
  54. if err != nil {
  55. return errors.New("RefreshEdbData Err:" + err.Error())
  56. }
  57. if resp.Ret != 200 {
  58. return errors.New("RefreshEdbData Err:" + resp.Msg + ";ErrMsg:" + resp.ErrMsg)
  59. }
  60. //item, err := data_manage.GetEdbInfoMaxAndMinInfo(v.Source, v.EdbCode)
  61. //if err != nil {
  62. // err = errors.New("GetEdbInfoMaxAndMinInfo Err:" + err.Error())
  63. // return err
  64. //}
  65. //if item != nil {
  66. // err = data_manage.ModifyEdbInfoMaxAndMinInfo(v.EdbInfoId, item)
  67. // if err != nil {
  68. // err = errors.New("ModifyEdbInfoMaxAndMinInfo Err:" + err.Error())
  69. // return err
  70. // }
  71. //}
  72. }
  73. return err
  74. }
  75. //刷新万得数据
  76. func RefreshDataFromWind(wg *sync.WaitGroup) (err error) {
  77. defer func() {
  78. if err != nil {
  79. fmt.Println("RefreshDataFromWind Err:" + err.Error())
  80. //go utils.SendEmail(utils.APPNAME+"【"+utils.RunMode+"】"+"失败提醒", "RefreshDataFromWind ErrMsg:"+err.Error(), utils.EmailSendToUsers)
  81. go alarm_msg.SendAlarmMsg("RefreshDataFromWind ErrMsg:"+err.Error(), 3)
  82. }
  83. wg.Done()
  84. }()
  85. var condition string
  86. var pars []interface{}
  87. condition += ` AND source=? AND no_update = 0 `
  88. pars = append(pars, utils.DATA_SOURCE_WIND)
  89. items, err := data_manage.GetEdbInfoByCondition(condition, pars, 0)
  90. if err != nil {
  91. return err
  92. }
  93. //var endDate string
  94. //endDate = time.Now().Format(utils.FormatDate)
  95. for _, v := range items {
  96. startDate := ""
  97. if v.Frequency == "日度" {
  98. startDate = v.EndDate.AddDate(0, 0, -utils.DATA_REFRESH).Format(utils.FormatDate)
  99. } else if v.Frequency == "周度" {
  100. startDate = v.EndDate.AddDate(0, 0, -(utils.DATA_REFRESH * 7)).Format(utils.FormatDate)
  101. } else if v.Frequency == "月度" {
  102. startDate = v.EndDate.AddDate(0, -utils.DATA_REFRESH, 0).Format(utils.FormatDate)
  103. } else if v.Frequency == "季度" {
  104. startDate = v.EndDate.AddDate(0, -utils.DATA_REFRESH*3, 0).Format(utils.FormatDate)
  105. } else if v.Frequency == "年度" {
  106. startDate = v.EndDate.AddDate(-utils.DATA_REFRESH, 0, 0).Format(utils.FormatDate)
  107. } else {
  108. startDate = v.EndDate.AddDate(0, 0, -utils.DATA_REFRESH).Format(utils.FormatDate)
  109. }
  110. //err = SyncEdbDataByWind(int64(v.EdbInfoId), v.EdbCode, startDate, endDate)
  111. //if err != nil {
  112. // return err
  113. //}
  114. //edbInfoId, source int, edbCode, startDate string) (resp *models.BaseResponse, err error) {
  115. resp, err := RefreshEdbData(v.EdbInfoId, v.Source, v.EdbCode, startDate)
  116. if err != nil {
  117. return errors.New("RefreshEdbData Err:" + err.Error())
  118. }
  119. if resp.Ret != 200 {
  120. return errors.New("RefreshEdbData Err:" + resp.Msg + ";ErrMsg:" + resp.ErrMsg)
  121. }
  122. //item, err := data_manage.GetEdbInfoMaxAndMinInfo(v.Source, v.EdbCode)
  123. //if err != nil {
  124. // return err
  125. //}
  126. //if item != nil {
  127. // err = data_manage.ModifyEdbInfoMaxAndMinInfo(v.EdbInfoId, item)
  128. // if err != nil {
  129. // return err
  130. // }
  131. //}
  132. }
  133. return err
  134. }
  135. //刷新彭博数据
  136. func RefreshDataFromPb(wg *sync.WaitGroup) (err error) {
  137. defer func() {
  138. if err != nil {
  139. fmt.Println("RefreshDataFromPb Err:" + err.Error())
  140. //go utils.SendEmail(utils.APPNAME+"【"+utils.RunMode+"】"+"失败提醒", "RefreshDataFromPb ErrMsg:"+err.Error(), utils.EmailSendToUsers)
  141. go alarm_msg.SendAlarmMsg("RefreshDataFromPb ErrMsg:"+err.Error(), 3)
  142. }
  143. wg.Done()
  144. }()
  145. var condition string
  146. var pars []interface{}
  147. condition += " AND source=? "
  148. pars = append(pars, utils.DATA_SOURCE_PB)
  149. items, err := data_manage.GetEdbInfoByCondition(condition, pars, 0)
  150. if err != nil {
  151. return errors.New("GetEdbInfoByCondition:" + err.Error())
  152. }
  153. //var endDate string
  154. //endDate = time.Now().AddDate(utils.DATA_END_DATE_LIMIT, 0, 0).Format(utils.FormatDateUnSpace)
  155. for _, v := range items {
  156. startDate := ""
  157. if v.Frequency == "日度" {
  158. startDate = v.EndDate.AddDate(0, 0, -utils.DATA_REFRESH).Format(utils.FormatDate)
  159. } else if v.Frequency == "周度" {
  160. startDate = v.EndDate.AddDate(0, 0, -(utils.DATA_REFRESH * 7)).Format(utils.FormatDate)
  161. } else if v.Frequency == "月度" {
  162. startDate = v.EndDate.AddDate(0, -utils.DATA_REFRESH, 0).Format(utils.FormatDate)
  163. } else if v.Frequency == "季度" {
  164. startDate = v.EndDate.AddDate(0, -utils.DATA_REFRESH*3, 0).Format(utils.FormatDate)
  165. } else if v.Frequency == "年度" {
  166. startDate = v.EndDate.AddDate(-utils.DATA_REFRESH, 0, 0).Format(utils.FormatDate)
  167. } else {
  168. startDate = v.EndDate.AddDate(0, 0, -utils.DATA_REFRESH).Format(utils.FormatDate)
  169. }
  170. //err = SyncEdbDataByPb(int64(v.EdbInfoId), v.EdbCode, startDate, endDate)
  171. //if err != nil {
  172. // return errors.New("SyncEdbDataByPb:" + err.Error())
  173. //}
  174. resp, err := RefreshEdbData(v.EdbInfoId, v.Source, v.EdbCode, startDate)
  175. if err != nil {
  176. return errors.New("RefreshEdbData Err:" + err.Error())
  177. }
  178. if resp.Ret != 200 {
  179. return errors.New("RefreshEdbData Err:" + resp.Msg + ";ErrMsg:" + resp.ErrMsg)
  180. }
  181. //item, err := data_manage.GetEdbInfoMaxAndMinInfo(v.Source, v.EdbCode)
  182. //if err != nil {
  183. // return err
  184. //}
  185. //if item != nil {
  186. // err = data_manage.ModifyEdbInfoMaxAndMinInfo(v.EdbInfoId, item)
  187. // if err != nil {
  188. // return err
  189. // }
  190. //}
  191. //minDate, maxDate, err := data.GetEdbDataPbMaxOrMinDate(v.EdbInfoId)
  192. //if err != nil {
  193. // return errors.New("GetEdbDataThsMaxOrMinDate:" + err.Error())
  194. //}
  195. //fmt.Println("minDate:" + minDate + ";maxDate:" + maxDate)
  196. //err = data.ModifyEdbDataInfoDate(v.EdbInfoId, maxDate)
  197. //if err != nil {
  198. // return errors.New("ModifyEdbDataInfoDate:" + err.Error())
  199. //}
  200. }
  201. return err
  202. }
  203. // RefreshDataFromPbFinance 刷新彭博财务指标数据
  204. func RefreshDataFromPbFinance(wg *sync.WaitGroup) (err error) {
  205. defer func() {
  206. if err != nil {
  207. fmt.Println("RefreshDataFromPb Err:" + err.Error())
  208. //go utils.SendEmail(utils.APPNAME+"【"+utils.RunMode+"】"+"失败提醒", "RefreshDataFromPb ErrMsg:"+err.Error(), utils.EmailSendToUsers)
  209. go alarm_msg.SendAlarmMsg("RefreshDataFromPb ErrMsg:"+err.Error(), 3)
  210. }
  211. wg.Done()
  212. }()
  213. var condition string
  214. var pars []interface{}
  215. condition += " AND source=? "
  216. pars = append(pars, utils.DATA_SOURCE_PB_FINANCE)
  217. items, err := data_manage.GetEdbInfoByCondition(condition, pars, 0)
  218. if err != nil {
  219. return errors.New("GetEdbInfoByCondition:" + err.Error())
  220. }
  221. //var endDate string
  222. //endDate = time.Now().AddDate(utils.DATA_END_DATE_LIMIT, 0, 0).Format(utils.FormatDateUnSpace)
  223. for _, v := range items {
  224. startDate := ""
  225. if v.Frequency == "日度" {
  226. startDate = v.EndDate.AddDate(0, 0, -utils.DATA_REFRESH).Format(utils.FormatDate)
  227. } else if v.Frequency == "周度" {
  228. startDate = v.EndDate.AddDate(0, 0, -(utils.DATA_REFRESH * 7)).Format(utils.FormatDate)
  229. } else if v.Frequency == "月度" {
  230. startDate = v.EndDate.AddDate(0, -utils.DATA_REFRESH, 0).Format(utils.FormatDate)
  231. } else if v.Frequency == "季度" {
  232. startDate = v.EndDate.AddDate(0, -utils.DATA_REFRESH*3, 0).Format(utils.FormatDate)
  233. } else if v.Frequency == "年度" {
  234. startDate = v.EndDate.AddDate(-utils.DATA_REFRESH, 0, 0).Format(utils.FormatDate)
  235. } else {
  236. startDate = v.EndDate.AddDate(0, 0, -utils.DATA_REFRESH).Format(utils.FormatDate)
  237. }
  238. //err = SyncEdbDataByPb(int64(v.EdbInfoId), v.EdbCode, startDate, endDate)
  239. //if err != nil {
  240. // return errors.New("SyncEdbDataByPb:" + err.Error())
  241. //}
  242. resp, err := RefreshEdbData(v.EdbInfoId, v.Source, v.EdbCode, startDate)
  243. if err != nil {
  244. return errors.New("RefreshEdbData Err:" + err.Error())
  245. }
  246. if resp.Ret != 200 {
  247. return errors.New("RefreshEdbData Err:" + resp.Msg + ";ErrMsg:" + resp.ErrMsg)
  248. }
  249. //item, err := data_manage.GetEdbInfoMaxAndMinInfo(v.Source, v.EdbCode)
  250. //if err != nil {
  251. // return err
  252. //}
  253. //if item != nil {
  254. // err = data_manage.ModifyEdbInfoMaxAndMinInfo(v.EdbInfoId, item)
  255. // if err != nil {
  256. // return err
  257. // }
  258. //}
  259. //minDate, maxDate, err := data.GetEdbDataPbMaxOrMinDate(v.EdbInfoId)
  260. //if err != nil {
  261. // return errors.New("GetEdbDataThsMaxOrMinDate:" + err.Error())
  262. //}
  263. //fmt.Println("minDate:" + minDate + ";maxDate:" + maxDate)
  264. //err = data.ModifyEdbDataInfoDate(v.EdbInfoId, maxDate)
  265. //if err != nil {
  266. // return errors.New("ModifyEdbDataInfoDate:" + err.Error())
  267. //}
  268. }
  269. return err
  270. }
  271. func CheckPbDataInterface(cont context.Context) (err error) {
  272. go func() {
  273. checkUrl := utils.Hz_Data_PB_Url + `hz_server`
  274. body, err := http.Get(checkUrl)
  275. if err != nil {
  276. //go utils.SendEmail(utils.APPNAME+"【"+utils.RunMode+"】"+"检测数据接口:失败提醒", "CheckPbDataInterface ErrMsg:"+err.Error(), utils.EmailSendToUsers)
  277. msg := "检测彭博数据服务器失败:CheckPbDataInterface ErrMsg:" + err.Error()
  278. go alarm_msg.SendAlarmMsg(msg, 3)
  279. } else {
  280. result := string(body)
  281. if result != "1" {
  282. //go utils.SendEmail(utils.APPNAME+"【"+utils.RunMode+"】"+"检测数据接口:失败提醒", "CheckPbDataInterface ErrMsg:"+string(body), utils.EmailSendToUsers)
  283. msg := "检测彭博数据服务器失败:CheckPbDataInterface ErrMsg:" + string(body)
  284. go alarm_msg.SendAlarmMsg(msg, 3)
  285. }
  286. }
  287. }()
  288. return
  289. }
  290. // CheckLtDataInterface 检测路透数据服务器
  291. func CheckLtDataInterface(cont context.Context) (err error) {
  292. go func() {
  293. checkUrl := utils.Hz_Data_LT_Url + `hz_server`
  294. body, err := http.Get(checkUrl)
  295. if err != nil {
  296. //go utils.SendEmail(utils.APPNAME+"【"+utils.RunMode+"】"+"检测数据接口:失败提醒", "检测路透数据服务器失败:CheckLtDataInterface ErrMsg:"+err.Error(), utils.EmailSendToUsers)
  297. msg := "检测路透数据服务器失败:CheckLtDataInterface ErrMsg:" + err.Error()
  298. go alarm_msg.SendAlarmMsg(msg, 3)
  299. } else {
  300. result := string(body)
  301. if result != `"ek true"` {
  302. //go utils.SendEmail(utils.APPNAME+"【"+utils.RunMode+"】"+"检测数据接口:失败提醒", "检测路透数据服务器失败:CheckLtDataInterface ErrMsg:"+string(body), utils.EmailSendToUsers)
  303. msg := "检测路透数据服务器失败:CheckLtDataInterface ErrMsg:" + string(body)
  304. go alarm_msg.SendAlarmMsg(msg, 3)
  305. }
  306. }
  307. }()
  308. return
  309. }
  310. // CheckThsDataInterface 检测同花顺数据服务器
  311. func CheckThsDataInterface(cont context.Context) (err error) {
  312. go func() {
  313. checkUrl := utils.Hz_Server_Data_Url + `hz_server`
  314. body, err := http.Get(checkUrl)
  315. if err != nil {
  316. //go utils.SendEmail(utils.APPNAME+"【"+utils.RunMode+"】"+"检测数据接口:失败提醒", "CheckPbDataInterface ErrMsg:"+err.Error(), utils.EmailSendToUsers)
  317. msg := "检测同花顺数据服务器失败:CheckThsDataInterface ErrMsg:" + err.Error()
  318. go alarm_msg.SendAlarmMsg(msg, 3)
  319. } else {
  320. result := string(body)
  321. if result != "1" {
  322. //go utils.SendEmail(utils.APPNAME+"【"+utils.RunMode+"】"+"检测数据接口:失败提醒", "CheckPbDataInterface ErrMsg:"+string(body), utils.EmailSendToUsers)
  323. msg := "检测同花顺数据服务器失败:CheckThsDataInterface ErrMsg:" + string(body)
  324. go alarm_msg.SendAlarmMsg(msg, 3)
  325. }
  326. }
  327. }()
  328. return
  329. }
  330. ////刷新所有计算指标
  331. //func RefreshDataFromCalculateAll() (err error) {
  332. // defer func() {
  333. // if err != nil {
  334. // utils.FileLog.Info("RefreshDataFromCalculateAll Err:" + err.Error())
  335. // go utils.SendEmail(utils.APPNAME+"【"+utils.RunMode+"】"+"失败提醒", "RefreshDataFromCalculateAll ErrMsg:"+err.Error(), utils.EmailSendToUsers)
  336. // }
  337. // }()
  338. // var condition string
  339. // var pars []interface{}
  340. // condition += " AND edb_type=? "
  341. // pars = append(pars, 2)
  342. //
  343. // //condition += " AND is_update=1 "
  344. //
  345. // items, err := data_manage.GetEdbInfoByCondition(condition, pars, 0)
  346. // if err != nil {
  347. // return err
  348. // }
  349. // for _, v := range items {
  350. // edbInfoId := v.EdbInfoId
  351. // edbCode := v.EdbCode
  352. // source := v.Source
  353. // fmt.Println(v.EdbInfoId, v.EdbCode, v.EdbName, v.SourceName, source)
  354. // if source == utils.DATA_SOURCE_CALCULATE {
  355. // startDate := ""
  356. // if v.Frequency == "日度" {
  357. // startDate = v.EndDate.AddDate(0, 0, -utils.DATA_REFRESH).Format(utils.FormatDate)
  358. // } else if v.Frequency == "周度" {
  359. // startDate = v.EndDate.AddDate(0, 0, -(utils.DATA_REFRESH * 7)).Format(utils.FormatDate)
  360. // } else if v.Frequency == "月度" {
  361. // startDate = v.EndDate.AddDate(0, -utils.DATA_REFRESH, 0).Format(utils.FormatDate)
  362. // } else if v.Frequency == "季度" {
  363. // startDate = v.EndDate.AddDate(0, -utils.DATA_REFRESH*3, 0).Format(utils.FormatDate)
  364. // } else if v.Frequency == "年度" {
  365. // startDate = v.EndDate.AddDate(-utils.DATA_REFRESH, 0, 0).Format(utils.FormatDate)
  366. // } else {
  367. // startDate = v.EndDate.AddDate(0, 0, -utils.DATA_REFRESH).Format(utils.FormatDate)
  368. // }
  369. // endDate := time.Now().Format(utils.FormatDate)
  370. // var edbInfoIdBytes []string
  371. // calculateMap, err := data_manage.GetEdbInfoCalculateDetail(int(v.EdbInfoId))
  372. // if err != nil {
  373. // return errors.New("GetEdbInfoCalculateDetail Err:" + err.Error())
  374. // }
  375. // var formulaStr string
  376. // edbInfoList := make([]*data_manage.EdbInfo, 0)
  377. // for _, v := range calculateMap {
  378. // formulaStr += v.FromTag + ","
  379. // edbInfoIdBytes = append(edbInfoIdBytes, v.FromTag)
  380. // edbInfo, _ := data_manage.GetEdbInfoById(v.FromEdbInfoId)
  381. // edbInfoList = append(edbInfoList, edbInfo)
  382. // }
  383. // //endDate = ""
  384. // err = RefreshCalculate(edbInfoList, edbInfoId, edbCode, v.CalculateFormula, startDate, endDate, edbInfoIdBytes)
  385. // if err != nil {
  386. // return errors.New("RefreshCalculate Err:" + err.Error())
  387. // }
  388. // } else if source == utils.DATA_SOURCE_CALCULATE_LJZZY {
  389. // calculateLjzzy, err := data_manage.GetEdbInfoCalculateLjzzyDetail(edbInfoId)
  390. // if err != nil {
  391. // if err.Error() == utils.ErrNoRow() {
  392. // continue
  393. // }
  394. // return errors.New("GetEdbInfoCalculateLjzzyDetail Err:" + err.Error())
  395. // }
  396. // fromEdbInfo, err := data_manage.GetEdbInfoById(calculateLjzzy.FromEdbInfoId)
  397. // if err != nil {
  398. // if err.Error() == utils.ErrNoRow() {
  399. // continue
  400. // }
  401. // return errors.New("GetEdbInfoById Err:" + err.Error())
  402. // }
  403. // year := time.Now().Year() - 1
  404. // startDate := strconv.Itoa(year) + "-01" + "-01"
  405. // endDate := "" //time.Now().Format(utils.FormatDate)
  406. // err = data_manage.RefreshCalculateLjzzy(edbInfoId, fromEdbInfo, edbCode, startDate, endDate)
  407. // if err != nil {
  408. // return errors.New("RefreshCalculateLjzzy Err:" + err.Error())
  409. // }
  410. // } else if source == utils.DATA_SOURCE_CALCULATE_TBZ {
  411. // calculateTbz, err := data_manage.GetEdbInfoCalculateTbzDetail(edbInfoId)
  412. // if err != nil {
  413. // return errors.New("GetEdbInfoCalculateTbzDetail Err:" + err.Error())
  414. // }
  415. // fromEdbInfo, err := data_manage.GetEdbInfoById(calculateTbz.FromEdbInfoId)
  416. // if err != nil {
  417. // if err.Error() == utils.ErrNoRow() {
  418. // continue
  419. // }
  420. // return errors.New("GetEdbInfoById Err:" + err.Error())
  421. // }
  422. // startDate := time.Now().AddDate(-2, -2, 0).Format(utils.FormatDate)
  423. // endDate := "" //time.Now().Format(utils.FormatDate)
  424. // err = data_manage.RefreshCalculateTbz(edbInfoId, fromEdbInfo, calculateTbz.EdbCode, startDate, endDate)
  425. // if err != nil {
  426. // return errors.New("RefreshCalculateTbz Err:" + err.Error())
  427. // }
  428. // } else if source == utils.DATA_SOURCE_CALCULATE_TCZ {
  429. // calculateTcz, err := data_manage.GetEdbInfoCalculateTczDetail(edbInfoId)
  430. // if err != nil {
  431. // return errors.New("GetEdbInfoCalculateTczDetail Err:" + err.Error())
  432. // }
  433. // fromEdbInfo, err := data_manage.GetEdbInfoById(calculateTcz.FromEdbInfoId)
  434. // if err != nil {
  435. // if err.Error() == utils.ErrNoRow() {
  436. // continue
  437. // }
  438. // return errors.New("GetEdbInfoById Err:" + err.Error())
  439. // }
  440. // startDate := time.Now().AddDate(-2, -2, 0).Format(utils.FormatDate)
  441. // endDate := "" //time.Now().Format(utils.FormatDate)
  442. // err = data_manage.RefreshCalculateTcz(edbInfoId, fromEdbInfo, calculateTcz.EdbCode, startDate, endDate)
  443. // if err != nil {
  444. // return errors.New("RefreshCalculateTcz Err:" + err.Error())
  445. // }
  446. // } else if source == utils.DATA_SOURCE_CALCULATE_NSZYDPJJS {
  447. // calculateNszydpjjs, err := data_manage.GetEdbInfoCalculateNszydpjjsDetail(edbInfoId)
  448. // if err != nil {
  449. // return errors.New("GetEdbInfoCalculateNszydpjjsDetail Err:" + err.Error())
  450. // }
  451. // fromEdbInfo, err := data_manage.GetEdbInfoById(calculateNszydpjjs.FromEdbInfoId)
  452. // if err != nil {
  453. // if err.Error() == utils.ErrNoRow() {
  454. // continue
  455. // }
  456. // return errors.New("GetEdbInfoById Err:" + err.Error())
  457. // }
  458. // formulaInt, _ := strconv.Atoi(v.CalculateFormula)
  459. // err = data_manage.RefreshCalculateNszydpjjs(edbInfoId, v.Source, formulaInt, fromEdbInfo, calculateNszydpjjs.EdbCode)
  460. // if err != nil {
  461. // return errors.New("RefreshCalculateNszydpjjs Err:" + err.Error())
  462. // }
  463. // } else if source == utils.DATA_SOURCE_CALCULATE_HBZ {
  464. // calculateHbz, err := data_manage.GetEdbInfoCalculateHbzDetail(edbInfoId)
  465. // if err != nil {
  466. // return errors.New("GetEdbInfoCalculateHbzDetail Err:" + err.Error())
  467. // }
  468. // fromEdbInfo, err := data_manage.GetEdbInfoById(calculateHbz.FromEdbInfoId)
  469. // if err != nil {
  470. // if err.Error() == utils.ErrNoRow() {
  471. // continue
  472. // }
  473. // return errors.New("GetEdbInfoById Err:" + err.Error())
  474. // }
  475. // startDate := time.Now().AddDate(-2, -2, 0).Format(utils.FormatDate)
  476. // endDate := "" //time.Now().Format(utils.FormatDate)
  477. // formulaInt, _ := strconv.Atoi(v.CalculateFormula)
  478. // err = data_manage.RefreshCalculateHbz(edbInfoId, source, fromEdbInfo, calculateHbz.EdbCode, startDate, endDate, formulaInt)
  479. // if err != nil {
  480. // return errors.New("RefreshCalculateTbz Err:" + err.Error())
  481. // }
  482. // } else if source == utils.DATA_SOURCE_CALCULATE_HCZ {
  483. // calculateHcz, err := data_manage.GetEdbInfoCalculateHczDetail(edbInfoId)
  484. // if err != nil {
  485. // return errors.New("GetEdbInfoCalculateHczDetail Err:" + err.Error())
  486. // }
  487. // fromEdbInfo, err := data_manage.GetEdbInfoById(calculateHcz.FromEdbInfoId)
  488. // if err != nil {
  489. // if err.Error() == utils.ErrNoRow() {
  490. // continue
  491. // }
  492. // return errors.New("GetEdbInfoById Err:" + err.Error())
  493. // }
  494. // startDate := time.Now().AddDate(-2, -2, 0).Format(utils.FormatDate)
  495. // endDate := "" //time.Now().Format(utils.FormatDate)
  496. // err = data_manage.RefreshCalculateHcz(edbInfoId, source, fromEdbInfo, calculateHcz.EdbCode, startDate, endDate)
  497. // if err != nil {
  498. // return errors.New("RefreshCalculateTbz Err:" + err.Error())
  499. // }
  500. // } else if source == utils.DATA_SOURCE_CALCULATE_BP {
  501. // calculateBp, err := data_manage.GetEdbInfoCalculateBpDetail(edbInfoId)
  502. // if err != nil && err.Error() != utils.ErrNoRow() {
  503. // return errors.New("GetEdbInfoCalculateBpDetail Err:" + err.Error())
  504. // }
  505. // if calculateBp != nil {
  506. // fromEdbInfo, err := data_manage.GetEdbInfoById(calculateBp.FromEdbInfoId)
  507. // if err != nil {
  508. // if err.Error() == utils.ErrNoRow() {
  509. // continue
  510. // }
  511. // return errors.New("GetEdbInfoById Err:" + err.Error())
  512. // }
  513. // startDate := time.Now().AddDate(-2, -2, 0).Format(utils.FormatDate)
  514. // endDate := "" //time.Now().Format(utils.FormatDate)
  515. // err = data_manage.RefreshCalculateBp(edbInfoId, fromEdbInfo, calculateBp.EdbCode, startDate, endDate)
  516. // if err != nil {
  517. // return errors.New("RefreshCalculateTbz Err:" + err.Error())
  518. // }
  519. // }
  520. // } else if source == utils.DATA_SOURCE_CALCULATE_TIME_SHIFT {
  521. // calculate, err := data_manage.GetEdbInfoCalculateMappingDetail(edbInfoId)
  522. // if err != nil {
  523. // return fmt.Errorf("GetEdbInfoCalculateTbzDetail Err:" + err.Error())
  524. // }
  525. // fromEdbInfo, err := data_manage.GetEdbInfoById(calculate.FromEdbInfoId)
  526. // if err != nil {
  527. // if err.Error() == utils.ErrNoRow() {
  528. // continue
  529. // }
  530. // return fmt.Errorf("GetEdbInfoById Err:" + err.Error())
  531. // }
  532. // //startDate := v.StartDate.Format(utils.FormatDate)
  533. // //endDate := time.Now().Format(utils.FormatDate)
  534. // formulaInt, _ := strconv.Atoi(calculate.CalculateFormula)
  535. // err = data_manage.RefreshAllCalculateTimeShift(edbInfoId, source, formulaInt, calculate.MoveType, fromEdbInfo, calculate.EdbCode, calculate.MoveFrequency)
  536. // if err != nil {
  537. // return fmt.Errorf("RefreshAllCalculateTimeShift Err:" + err.Error())
  538. // }
  539. //
  540. // } else if source == utils.DATA_SOURCE_CALCULATE_ZJPJ { //刷新直接拼接
  541. // tmpEdbInfo, err := data_manage.GetEdbInfoById(v.EdbInfoId)
  542. // if err != nil {
  543. // if err.Error() == utils.ErrNoRow() {
  544. // continue
  545. // }
  546. // return fmt.Errorf("GetEdbInfoById Err:" + err.Error())
  547. // }
  548. // err = data_manage.RefreshAllCalculateZjpj(tmpEdbInfo)
  549. // if err != nil {
  550. // return fmt.Errorf("RefreshAllCalculateZjpj Err:" + err.Error())
  551. // }
  552. // } else if source == utils.DATA_SOURCE_CALCULATE_LJZTBPJ { //刷新累计值同比拼接
  553. // tmpEdbInfo, err := data_manage.GetEdbInfoById(v.EdbInfoId)
  554. // if err != nil {
  555. // if err.Error() == utils.ErrNoRow() {
  556. // continue
  557. // }
  558. // return fmt.Errorf("GetEdbInfoById Err:" + err.Error())
  559. // }
  560. // err = data_manage.RefreshAllCalculateLjztbpj(tmpEdbInfo)
  561. // if err != nil {
  562. // return fmt.Errorf("RefreshAllCalculateLjztbpj Err:" + err.Error())
  563. // }
  564. // } else {
  565. // msg := "刷新失败,无效的指标渠道:source:" + strconv.Itoa(source) + " EdbCode:" + v.EdbCode
  566. // err = errors.New(msg)
  567. // return err
  568. // }
  569. //
  570. // maxAndMinItem, err := data_manage.GetEdbInfoMaxAndMinInfo(source, edbCode)
  571. // if err != nil {
  572. // fmt.Println("GetEdbInfoMaxAndMinInfo Err:" + err.Error() + ";source:" + strconv.Itoa(source) + ";edbCode:" + edbCode)
  573. // err = errors.New("GetEdbInfoMaxAndMinInfo Err:" + err.Error() + ";source:" + strconv.Itoa(source) + ";edbCode:" + edbCode)
  574. // return err
  575. // }
  576. // if maxAndMinItem != nil {
  577. // err = data_manage.ModifyEdbInfoMaxAndMinInfo(edbInfoId, maxAndMinItem)
  578. // if err != nil {
  579. // return err
  580. // }
  581. // }
  582. // }
  583. // return err
  584. //}
  585. //刷新所有计算指标
  586. func RefreshDataFromCalculateAll() (err error) {
  587. defer func() {
  588. if err != nil {
  589. utils.FileLog.Info("RefreshDataFromCalculateAll Err:" + err.Error())
  590. //go utils.SendEmail(utils.APPNAME+"【"+utils.RunMode+"】"+"失败提醒", "RefreshDataFromCalculateAll ErrMsg:"+err.Error(), utils.EmailSendToUsers)
  591. go alarm_msg.SendAlarmMsg("RefreshDataFromCalculateAll ErrMsg:"+err.Error(), 3)
  592. }
  593. }()
  594. var condition string
  595. var pars []interface{}
  596. // 查询 普通指标的计算指标
  597. condition += " AND edb_type=? AND edb_info_type=? "
  598. pars = append(pars, 2, 0)
  599. //condition += " AND modify_time<? "
  600. //pars = append(pars, "2022-03-02 17:03:52")
  601. //condition += " AND is_update=1 "
  602. items, err := data_manage.GetEdbInfoByCondition(condition, pars, 0)
  603. if err != nil {
  604. return err
  605. }
  606. for _, v := range items {
  607. //edbInfoId := v.EdbInfoId
  608. //edbCode := v.EdbCode
  609. source := v.Source
  610. startDate := v.StartDate.Format(utils.FormatDate)
  611. if startDate == "0001-01-01" {
  612. continue
  613. }
  614. fmt.Println(v.EdbInfoId, v.EdbCode, v.EdbName, v.SourceName, source)
  615. //if source == utils.DATA_SOURCE_CALCULATE {
  616. // startDate := ""
  617. // if v.Frequency == "日度" {
  618. // startDate = v.EndDate.AddDate(0, 0, -utils.DATA_REFRESH).Format(utils.FormatDate)
  619. // } else if v.Frequency == "周度" {
  620. // startDate = v.EndDate.AddDate(0, 0, -(utils.DATA_REFRESH * 7)).Format(utils.FormatDate)
  621. // } else if v.Frequency == "月度" {
  622. // startDate = v.EndDate.AddDate(0, -utils.DATA_REFRESH, 0).Format(utils.FormatDate)
  623. // } else if v.Frequency == "季度" {
  624. // startDate = v.EndDate.AddDate(0, -utils.DATA_REFRESH*3, 0).Format(utils.FormatDate)
  625. // } else if v.Frequency == "年度" {
  626. // startDate = v.EndDate.AddDate(-utils.DATA_REFRESH, 0, 0).Format(utils.FormatDate)
  627. // } else {
  628. // startDate = v.EndDate.AddDate(0, 0, -utils.DATA_REFRESH).Format(utils.FormatDate)
  629. // }
  630. // endDate := time.Now().Format(utils.FormatDate)
  631. // var edbInfoIdBytes []string
  632. // calculateMap, err := data_manage.GetEdbInfoCalculateDetail(int(v.EdbInfoId))
  633. // if err != nil {
  634. // return errors.New("GetEdbInfoCalculateDetail Err:" + err.Error())
  635. // }
  636. // var formulaStr string
  637. // edbInfoList := make([]*data_manage.EdbInfo, 0)
  638. // for _, v := range calculateMap {
  639. // formulaStr += v.FromTag + ","
  640. // edbInfoIdBytes = append(edbInfoIdBytes, v.FromTag)
  641. // edbInfo, _ := data_manage.GetEdbInfoById(v.FromEdbInfoId)
  642. // edbInfoList = append(edbInfoList, edbInfo)
  643. // }
  644. // //endDate = ""
  645. // err = RefreshCalculate(edbInfoList, edbInfoId, edbCode, v.CalculateFormula, startDate, endDate, edbInfoIdBytes)
  646. // if err != nil {
  647. // return errors.New("RefreshCalculate Err:" + err.Error())
  648. // }
  649. //} else if source == utils.DATA_SOURCE_CALCULATE_LJZZY {
  650. // calculateLjzzy, err := data_manage.GetEdbInfoCalculateLjzzyDetail(edbInfoId)
  651. // if err != nil {
  652. // if err.Error() == utils.ErrNoRow() {
  653. // continue
  654. // }
  655. // return errors.New("GetEdbInfoCalculateLjzzyDetail Err:" + err.Error())
  656. // }
  657. // fromEdbInfo, err := data_manage.GetEdbInfoById(calculateLjzzy.FromEdbInfoId)
  658. // if err != nil {
  659. // if err.Error() == utils.ErrNoRow() {
  660. // continue
  661. // }
  662. // return errors.New("GetEdbInfoById Err:" + err.Error())
  663. // }
  664. // year := time.Now().Year() - 1
  665. // startDate := strconv.Itoa(year) + "-01" + "-01"
  666. // endDate := "" //time.Now().Format(utils.FormatDate)
  667. // err = data_manage.RefreshCalculateLjzzy(edbInfoId, fromEdbInfo, edbCode, startDate, endDate)
  668. // if err != nil {
  669. // return errors.New("RefreshCalculateLjzzy Err:" + err.Error())
  670. // }
  671. //} else if source == utils.DATA_SOURCE_CALCULATE_TBZ {
  672. // calculateTbz, err := data_manage.GetEdbInfoCalculateTbzDetail(edbInfoId)
  673. // if err != nil {
  674. // return errors.New("GetEdbInfoCalculateTbzDetail Err:" + err.Error())
  675. // }
  676. // fromEdbInfo, err := data_manage.GetEdbInfoById(calculateTbz.FromEdbInfoId)
  677. // if err != nil {
  678. // if err.Error() == utils.ErrNoRow() {
  679. // continue
  680. // }
  681. // return errors.New("GetEdbInfoById Err:" + err.Error())
  682. // }
  683. // startDate := time.Now().AddDate(-2, -2, 0).Format(utils.FormatDate)
  684. // endDate := "" //time.Now().Format(utils.FormatDate)
  685. // err = data_manage.RefreshCalculateTbz(edbInfoId, fromEdbInfo, calculateTbz.EdbCode, startDate, endDate)
  686. // if err != nil {
  687. // return errors.New("RefreshCalculateTbz Err:" + err.Error())
  688. // }
  689. //} else if source == utils.DATA_SOURCE_CALCULATE_TCZ {
  690. // calculateTcz, err := data_manage.GetEdbInfoCalculateTczDetail(edbInfoId)
  691. // if err != nil {
  692. // return errors.New("GetEdbInfoCalculateTczDetail Err:" + err.Error())
  693. // }
  694. // fromEdbInfo, err := data_manage.GetEdbInfoById(calculateTcz.FromEdbInfoId)
  695. // if err != nil {
  696. // if err.Error() == utils.ErrNoRow() {
  697. // continue
  698. // }
  699. // return errors.New("GetEdbInfoById Err:" + err.Error())
  700. // }
  701. // startDate := time.Now().AddDate(-2, -2, 0).Format(utils.FormatDate)
  702. // endDate := "" //time.Now().Format(utils.FormatDate)
  703. // err = data_manage.RefreshCalculateTcz(edbInfoId, fromEdbInfo, calculateTcz.EdbCode, startDate, endDate)
  704. // if err != nil {
  705. // return errors.New("RefreshCalculateTcz Err:" + err.Error())
  706. // }
  707. //} else if source == utils.DATA_SOURCE_CALCULATE_NSZYDPJJS {
  708. // calculateNszydpjjs, err := data_manage.GetEdbInfoCalculateNszydpjjsDetail(edbInfoId)
  709. // if err != nil {
  710. // return errors.New("GetEdbInfoCalculateNszydpjjsDetail Err:" + err.Error())
  711. // }
  712. // fromEdbInfo, err := data_manage.GetEdbInfoById(calculateNszydpjjs.FromEdbInfoId)
  713. // if err != nil {
  714. // if err.Error() == utils.ErrNoRow() {
  715. // continue
  716. // }
  717. // return errors.New("GetEdbInfoById Err:" + err.Error())
  718. // }
  719. // formulaInt, _ := strconv.Atoi(v.CalculateFormula)
  720. // err = data_manage.RefreshCalculateNszydpjjs(edbInfoId, v.Source, formulaInt, fromEdbInfo, calculateNszydpjjs.EdbCode)
  721. // if err != nil {
  722. // return errors.New("RefreshCalculateNszydpjjs Err:" + err.Error())
  723. // }
  724. //} else if source == utils.DATA_SOURCE_CALCULATE_HBZ {
  725. // calculateHbz, err := data_manage.GetEdbInfoCalculateHbzDetail(edbInfoId)
  726. // if err != nil {
  727. // return errors.New("GetEdbInfoCalculateHbzDetail Err:" + err.Error())
  728. // }
  729. // fromEdbInfo, err := data_manage.GetEdbInfoById(calculateHbz.FromEdbInfoId)
  730. // if err != nil {
  731. // if err.Error() == utils.ErrNoRow() {
  732. // continue
  733. // }
  734. // return errors.New("GetEdbInfoById Err:" + err.Error())
  735. // }
  736. // startDate := time.Now().AddDate(-2, -2, 0).Format(utils.FormatDate)
  737. // endDate := "" //time.Now().Format(utils.FormatDate)
  738. // formulaInt, _ := strconv.Atoi(v.CalculateFormula)
  739. // err = data_manage.RefreshCalculateHbz(edbInfoId, source, fromEdbInfo, calculateHbz.EdbCode, startDate, endDate, formulaInt)
  740. // if err != nil {
  741. // return errors.New("RefreshCalculateTbz Err:" + err.Error())
  742. // }
  743. //} else if source == utils.DATA_SOURCE_CALCULATE_HCZ {
  744. // calculateHcz, err := data_manage.GetEdbInfoCalculateHczDetail(edbInfoId)
  745. // if err != nil {
  746. // return errors.New("GetEdbInfoCalculateHczDetail Err:" + err.Error())
  747. // }
  748. // fromEdbInfo, err := data_manage.GetEdbInfoById(calculateHcz.FromEdbInfoId)
  749. // if err != nil {
  750. // if err.Error() == utils.ErrNoRow() {
  751. // continue
  752. // }
  753. // return errors.New("GetEdbInfoById Err:" + err.Error())
  754. // }
  755. // startDate := time.Now().AddDate(-2, -2, 0).Format(utils.FormatDate)
  756. // endDate := "" //time.Now().Format(utils.FormatDate)
  757. // err = data_manage.RefreshCalculateHcz(edbInfoId, source, fromEdbInfo, calculateHcz.EdbCode, startDate, endDate)
  758. // if err != nil {
  759. // return errors.New("RefreshCalculateTbz Err:" + err.Error())
  760. // }
  761. //} else if source == utils.DATA_SOURCE_CALCULATE_BP {
  762. // calculateBp, err := data_manage.GetEdbInfoCalculateBpDetail(edbInfoId)
  763. // if err != nil && err.Error() != utils.ErrNoRow() {
  764. // return errors.New("GetEdbInfoCalculateBpDetail Err:" + err.Error())
  765. // }
  766. // if calculateBp != nil {
  767. // fromEdbInfo, err := data_manage.GetEdbInfoById(calculateBp.FromEdbInfoId)
  768. // if err != nil {
  769. // if err.Error() == utils.ErrNoRow() {
  770. // continue
  771. // }
  772. // return errors.New("GetEdbInfoById Err:" + err.Error())
  773. // }
  774. // startDate := time.Now().AddDate(-2, -2, 0).Format(utils.FormatDate)
  775. // endDate := "" //time.Now().Format(utils.FormatDate)
  776. // err = data_manage.RefreshCalculateBp(edbInfoId, fromEdbInfo, calculateBp.EdbCode, startDate, endDate)
  777. // if err != nil {
  778. // return errors.New("RefreshCalculateTbz Err:" + err.Error())
  779. // }
  780. // }
  781. //} else if source == utils.DATA_SOURCE_CALCULATE_TIME_SHIFT {
  782. // calculate, err := data_manage.GetEdbInfoCalculateMappingDetail(edbInfoId)
  783. // if err != nil {
  784. // return fmt.Errorf("GetEdbInfoCalculateTbzDetail Err:" + err.Error())
  785. // }
  786. // fromEdbInfo, err := data_manage.GetEdbInfoById(calculate.FromEdbInfoId)
  787. // if err != nil {
  788. // if err.Error() == utils.ErrNoRow() {
  789. // continue
  790. // }
  791. // return fmt.Errorf("GetEdbInfoById Err:" + err.Error())
  792. // }
  793. // //startDate := v.StartDate.Format(utils.FormatDate)
  794. // //endDate := time.Now().Format(utils.FormatDate)
  795. // formulaInt, _ := strconv.Atoi(calculate.CalculateFormula)
  796. // err = data_manage.RefreshAllCalculateTimeShift(edbInfoId, source, formulaInt, calculate.MoveType, fromEdbInfo, calculate.EdbCode, calculate.MoveFrequency)
  797. // if err != nil {
  798. // return fmt.Errorf("RefreshAllCalculateTimeShift Err:" + err.Error())
  799. // }
  800. //
  801. //} else if source == utils.DATA_SOURCE_CALCULATE_ZJPJ { //刷新直接拼接
  802. // tmpEdbInfo, err := data_manage.GetEdbInfoById(v.EdbInfoId)
  803. // if err != nil {
  804. // if err.Error() == utils.ErrNoRow() {
  805. // continue
  806. // }
  807. // return fmt.Errorf("GetEdbInfoById Err:" + err.Error())
  808. // }
  809. // err = data_manage.RefreshAllCalculateZjpj(tmpEdbInfo)
  810. // if err != nil {
  811. // return fmt.Errorf("RefreshAllCalculateZjpj Err:" + err.Error())
  812. // }
  813. //} else if source == utils.DATA_SOURCE_CALCULATE_LJZTBPJ { //刷新累计值同比拼接
  814. // tmpEdbInfo, err := data_manage.GetEdbInfoById(v.EdbInfoId)
  815. // if err != nil {
  816. // if err.Error() == utils.ErrNoRow() {
  817. // continue
  818. // }
  819. // return fmt.Errorf("GetEdbInfoById Err:" + err.Error())
  820. // }
  821. // err = data_manage.RefreshAllCalculateLjztbpj(tmpEdbInfo)
  822. // if err != nil {
  823. // return fmt.Errorf("RefreshAllCalculateLjztbpj Err:" + err.Error())
  824. // }
  825. //} else {
  826. // msg := "刷新失败,无效的指标渠道:source:" + strconv.Itoa(source) + " EdbCode:" + v.EdbCode
  827. // err = errors.New(msg)
  828. // return err
  829. //}
  830. fmt.Println("RefreshEdbCalculateData", v.EdbInfoId, v.EdbCode, startDate)
  831. result, err := RefreshEdbCalculateData(v.EdbInfoId, v.EdbCode, startDate)
  832. if err != nil {
  833. err = errors.New("RefreshEdbCalculateData Err:" + err.Error())
  834. return err
  835. }
  836. if result.Ret != 200 {
  837. err = errors.New("RefreshEdbCalculateData err;msg:" + result.Msg + ";errMsg:" + result.ErrMsg)
  838. return err
  839. }
  840. //maxAndMinItem, err := data_manage.GetEdbInfoMaxAndMinInfo(source, edbCode)
  841. //if err != nil {
  842. // fmt.Println("GetEdbInfoMaxAndMinInfo Err:" + err.Error() + ";source:" + strconv.Itoa(source) + ";edbCode:" + edbCode)
  843. // err = errors.New("GetEdbInfoMaxAndMinInfo Err:" + err.Error() + ";source:" + strconv.Itoa(source) + ";edbCode:" + edbCode)
  844. // return err
  845. //}
  846. //if maxAndMinItem != nil {
  847. // err = data_manage.ModifyEdbInfoMaxAndMinInfo(edbInfoId, maxAndMinItem)
  848. // if err != nil {
  849. // return err
  850. // }
  851. //}
  852. }
  853. return err
  854. }
  855. //刷新手工指标数据
  856. func RefreshDataFromManual(wg *sync.WaitGroup) (err error) {
  857. defer func() {
  858. if err != nil {
  859. fmt.Println("RefreshDataFromManual Err:" + err.Error())
  860. //go utils.SendEmail(utils.APPNAME+"【"+utils.RunMode+"】"+"失败提醒", "RefreshDataFromManual ErrMsg:"+err.Error(), utils.EmailSendToUsers)
  861. go alarm_msg.SendAlarmMsg("RefreshDataFromManual ErrMsg:"+err.Error(), 3)
  862. }
  863. wg.Done()
  864. }()
  865. var condition string
  866. var pars []interface{}
  867. condition += " AND source=? "
  868. pars = append(pars, utils.DATA_SOURCE_MANUAL)
  869. items, err := data_manage.GetEdbInfoByCondition(condition, pars, 0)
  870. if err != nil {
  871. return errors.New("GetEdbInfoByCondition:" + err.Error())
  872. }
  873. for _, v := range items {
  874. //err = data_manage.RefreshManual(v)
  875. //if err != nil {
  876. // return errors.New("RefreshManual:edbCode:" + v.EdbCode + ":" + err.Error())
  877. //}
  878. startDate := v.StartDate.Format(utils.FormatDate)
  879. resp, err := RefreshEdbData(v.EdbInfoId, v.Source, v.EdbCode, startDate)
  880. if err != nil {
  881. return errors.New("RefreshEdbData Err:" + err.Error())
  882. }
  883. if resp.Ret != 200 {
  884. return errors.New("RefreshEdbData Err:" + resp.Msg + ";ErrMsg:" + resp.ErrMsg)
  885. }
  886. //item, err := data_manage.GetEdbInfoMaxAndMinInfo(v.Source, v.EdbCode)
  887. //if err != nil {
  888. // if err.Error() != utils.ErrNoRow() {
  889. // return err
  890. // } else {
  891. // err = nil
  892. // }
  893. //} else {
  894. // if item != nil {
  895. // err = data_manage.ModifyEdbInfoMaxAndMinInfo(v.EdbInfoId, item)
  896. // if err != nil {
  897. // return err
  898. // }
  899. // }
  900. //}
  901. }
  902. return err
  903. }
  904. //刷新隆众数据
  905. func RefreshDataFromLz(wg *sync.WaitGroup) (err error) {
  906. defer func() {
  907. if err != nil {
  908. fmt.Println("RefreshDataFromLz Err:" + err.Error())
  909. //go utils.SendEmail(utils.APPNAME+"【"+utils.RunMode+"】"+"失败提醒", "RefreshDataFromLz ErrMsg:"+err.Error(), utils.EmailSendToUsers)
  910. go alarm_msg.SendAlarmMsg("RefreshDataFromLz ErrMsg:"+err.Error(), 3)
  911. }
  912. wg.Done()
  913. }()
  914. var condition string
  915. var pars []interface{}
  916. condition += " AND source=? "
  917. pars = append(pars, utils.DATA_SOURCE_LZ)
  918. items, err := data_manage.GetEdbInfoByCondition(condition, pars, 0)
  919. if err != nil {
  920. return errors.New("GetEdbInfoByCondition:" + err.Error())
  921. }
  922. //var endDate string
  923. //endDate = time.Now().AddDate(utils.DATA_END_DATE_LIMIT, 0, 0).Format(utils.FormatDateUnSpace)
  924. for _, v := range items {
  925. startDate := ""
  926. if v.Frequency == "日度" {
  927. startDate = v.EndDate.AddDate(0, 0, -utils.DATA_REFRESH).Format(utils.FormatDate)
  928. } else if v.Frequency == "周度" {
  929. startDate = v.EndDate.AddDate(0, 0, -(utils.DATA_REFRESH * 7)).Format(utils.FormatDate)
  930. } else if v.Frequency == "月度" {
  931. startDate = v.EndDate.AddDate(0, -utils.DATA_REFRESH, 0).Format(utils.FormatDate)
  932. } else if v.Frequency == "季度" {
  933. startDate = v.EndDate.AddDate(0, -utils.DATA_REFRESH*3, 0).Format(utils.FormatDate)
  934. } else if v.Frequency == "年度" {
  935. startDate = v.EndDate.AddDate(-utils.DATA_REFRESH, 0, 0).Format(utils.FormatDate)
  936. } else {
  937. startDate = v.EndDate.AddDate(0, 0, -utils.DATA_REFRESH).Format(utils.FormatDate)
  938. }
  939. //fmt.Println(startDate, endDate)
  940. //err = data_manage.RefreshEdbDataByLz(v.EdbInfoId, v.EdbCode, startDate, endDate)
  941. //if err != nil {
  942. // return errors.New("RefreshEdbDataByLz:" + err.Error())
  943. //}
  944. resp, err := RefreshEdbData(v.EdbInfoId, v.Source, v.EdbCode, startDate)
  945. if err != nil {
  946. return errors.New("RefreshEdbData Err:" + err.Error())
  947. }
  948. if resp.Ret != 200 {
  949. return errors.New("RefreshEdbData Err:" + resp.Msg + ";ErrMsg:" + resp.ErrMsg)
  950. }
  951. //item, err := data_manage.GetEdbInfoMaxAndMinInfo(v.Source, v.EdbCode)
  952. //if err != nil {
  953. // return err
  954. //}
  955. //if item != nil {
  956. // err = data_manage.ModifyEdbInfoMaxAndMinInfo(v.EdbInfoId, item)
  957. // if err != nil {
  958. // return err
  959. // }
  960. //}
  961. }
  962. return err
  963. }
  964. //刷新有色数据
  965. func RefreshDataFromYs(wg *sync.WaitGroup) (err error) {
  966. defer func() {
  967. if err != nil {
  968. fmt.Println("RefreshDataFromYs Err:" + err.Error())
  969. //go utils.SendEmail(utils.APPNAME+"【"+utils.RunMode+"】"+"失败提醒", "RefreshDataFromYs ErrMsg:"+err.Error(), utils.EmailSendToUsers)
  970. go alarm_msg.SendAlarmMsg("RefreshDataFromYs ErrMsg:"+err.Error(), 3)
  971. }
  972. wg.Done()
  973. }()
  974. var condition string
  975. var pars []interface{}
  976. condition += " AND source=? "
  977. pars = append(pars, utils.DATA_SOURCE_YS)
  978. items, err := data_manage.GetEdbInfoByCondition(condition, pars, 0)
  979. if err != nil {
  980. return errors.New("GetEdbInfoByCondition:" + err.Error())
  981. }
  982. //var endDate string
  983. //endDate = time.Now().AddDate(utils.DATA_END_DATE_LIMIT, 0, 0).Format(utils.FormatDateUnSpace)
  984. for _, v := range items {
  985. startDate := ""
  986. if v.Frequency == "日度" {
  987. startDate = v.EndDate.AddDate(0, 0, -utils.DATA_REFRESH).Format(utils.FormatDate)
  988. } else if v.Frequency == "周度" {
  989. startDate = v.EndDate.AddDate(0, 0, -(utils.DATA_REFRESH * 7)).Format(utils.FormatDate)
  990. } else if v.Frequency == "月度" {
  991. startDate = v.EndDate.AddDate(0, -utils.DATA_REFRESH, 0).Format(utils.FormatDate)
  992. } else if v.Frequency == "季度" {
  993. startDate = v.EndDate.AddDate(0, -utils.DATA_REFRESH*3, 0).Format(utils.FormatDate)
  994. } else if v.Frequency == "年度" {
  995. startDate = v.EndDate.AddDate(-utils.DATA_REFRESH, 0, 0).Format(utils.FormatDate)
  996. } else {
  997. startDate = v.EndDate.AddDate(0, 0, -utils.DATA_REFRESH).Format(utils.FormatDate)
  998. }
  999. //fmt.Println(startDate, endDate)
  1000. //err = data_manage.RefreshEdbDataByYs(v.EdbInfoId, v.EdbCode, startDate, endDate)
  1001. //if err != nil {
  1002. // return errors.New("RefreshEdbDataByYs:" + err.Error())
  1003. //}
  1004. resp, err := RefreshEdbData(v.EdbInfoId, v.Source, v.EdbCode, startDate)
  1005. if err != nil {
  1006. return errors.New("RefreshEdbData Err:" + err.Error())
  1007. }
  1008. if resp.Ret != 200 {
  1009. return errors.New("RefreshEdbData Err:" + resp.Msg + ";ErrMsg:" + resp.ErrMsg)
  1010. }
  1011. //item, err := data_manage.GetEdbInfoMaxAndMinInfo(v.Source, v.EdbCode)
  1012. //if err != nil {
  1013. // return err
  1014. //}
  1015. //if item != nil {
  1016. // err = data_manage.ModifyEdbInfoMaxAndMinInfo(v.EdbInfoId, item)
  1017. // if err != nil {
  1018. // return err
  1019. // }
  1020. //}
  1021. }
  1022. return err
  1023. }
  1024. //刷新钢联数据
  1025. func RefreshDataFromGl(wg *sync.WaitGroup) (err error) {
  1026. defer func() {
  1027. if err != nil {
  1028. fmt.Println("RefreshDataFromGl Err:" + err.Error())
  1029. //go utils.SendEmail(utils.APPNAME+"【"+utils.RunMode+"】"+"失败提醒", "RefreshDataFromGl ErrMsg:"+err.Error(), utils.EmailSendToUsers)
  1030. go alarm_msg.SendAlarmMsg("RefreshDataFromGl ErrMsg:"+err.Error(), 3)
  1031. }
  1032. wg.Done()
  1033. }()
  1034. var condition string
  1035. var pars []interface{}
  1036. condition += " AND source=? "
  1037. pars = append(pars, utils.DATA_SOURCE_GL)
  1038. items, err := data_manage.GetEdbInfoByCondition(condition, pars, 0)
  1039. if err != nil {
  1040. return errors.New("GetEdbInfoByCondition:" + err.Error())
  1041. }
  1042. //var endDate string
  1043. //endDate = time.Now().AddDate(utils.DATA_END_DATE_LIMIT, 0, 0).Format(utils.FormatDateUnSpace)
  1044. for _, v := range items {
  1045. startDate := ""
  1046. if v.Frequency == "日度" {
  1047. startDate = v.EndDate.AddDate(0, 0, -utils.DATA_REFRESH).Format(utils.FormatDate)
  1048. } else if v.Frequency == "周度" {
  1049. startDate = v.EndDate.AddDate(0, 0, -(utils.DATA_REFRESH * 7)).Format(utils.FormatDate)
  1050. } else if v.Frequency == "月度" {
  1051. startDate = v.EndDate.AddDate(0, -utils.DATA_REFRESH, 0).Format(utils.FormatDate)
  1052. } else if v.Frequency == "季度" {
  1053. startDate = v.EndDate.AddDate(0, -utils.DATA_REFRESH*3, 0).Format(utils.FormatDate)
  1054. } else if v.Frequency == "年度" {
  1055. startDate = v.EndDate.AddDate(-utils.DATA_REFRESH, 0, 0).Format(utils.FormatDate)
  1056. } else {
  1057. startDate = v.EndDate.AddDate(0, 0, -utils.DATA_REFRESH).Format(utils.FormatDate)
  1058. }
  1059. //fmt.Println(startDate, endDate)
  1060. //err = data_manage.RefreshEdbDataByGl(v.EdbInfoId, v.EdbCode, startDate, endDate)
  1061. //if err != nil {
  1062. // return errors.New("RefreshEdbDataByGl:" + err.Error())
  1063. //}
  1064. resp, err := RefreshEdbData(v.EdbInfoId, v.Source, v.EdbCode, startDate)
  1065. if err != nil {
  1066. return errors.New("RefreshEdbData Err:" + err.Error())
  1067. }
  1068. if resp.Ret != 200 {
  1069. return errors.New("RefreshEdbData Err:" + resp.Msg + ";ErrMsg:" + resp.ErrMsg)
  1070. }
  1071. //item, err := data_manage.GetEdbInfoMaxAndMinInfo(v.Source, v.EdbCode)
  1072. //if err != nil {
  1073. // return err
  1074. //}
  1075. //if item != nil {
  1076. // err = data_manage.ModifyEdbInfoMaxAndMinInfo(v.EdbInfoId, item)
  1077. // if err != nil {
  1078. // return err
  1079. // }
  1080. //}
  1081. }
  1082. return err
  1083. }
  1084. // RefreshDataFromSh 刷新上期所数据
  1085. func RefreshDataFromSh(wg *sync.WaitGroup) (err error) {
  1086. defer func() {
  1087. if err != nil {
  1088. fmt.Println("RefreshDataFromSh Err:" + err.Error())
  1089. //go utils.SendEmail(utils.APPNAME+"【"+utils.RunMode+"】"+"失败提醒", "RefreshDataFromSh ErrMsg:"+err.Error(), utils.EmailSendToUsers)
  1090. go alarm_msg.SendAlarmMsg("RefreshDataFromSh ErrMsg:"+err.Error(), 3)
  1091. }
  1092. wg.Done()
  1093. }()
  1094. var condition string
  1095. var pars []interface{}
  1096. condition += " AND source=? "
  1097. pars = append(pars, utils.DATA_SOURCE_SH)
  1098. items, err := data_manage.GetEdbInfoByCondition(condition, pars, 0)
  1099. if err != nil {
  1100. return errors.New("GetEdbInfoByCondition:" + err.Error())
  1101. }
  1102. //var endDate string
  1103. //endDate = time.Now().AddDate(utils.DATA_END_DATE_LIMIT, 0, 0).Format(utils.FormatDateUnSpace)
  1104. for _, v := range items {
  1105. startDate := ""
  1106. if v.Frequency == "日度" {
  1107. startDate = v.EndDate.AddDate(0, 0, -utils.DATA_REFRESH).Format(utils.FormatDate)
  1108. } else if v.Frequency == "周度" {
  1109. startDate = v.EndDate.AddDate(0, 0, -(utils.DATA_REFRESH * 7)).Format(utils.FormatDate)
  1110. } else if v.Frequency == "月度" {
  1111. startDate = v.EndDate.AddDate(0, -utils.DATA_REFRESH, 0).Format(utils.FormatDate)
  1112. } else if v.Frequency == "季度" {
  1113. startDate = v.EndDate.AddDate(0, -utils.DATA_REFRESH*3, 0).Format(utils.FormatDate)
  1114. } else if v.Frequency == "年度" {
  1115. startDate = v.EndDate.AddDate(-utils.DATA_REFRESH, 0, 0).Format(utils.FormatDate)
  1116. } else {
  1117. startDate = v.EndDate.AddDate(0, 0, -utils.DATA_REFRESH).Format(utils.FormatDate)
  1118. }
  1119. //fmt.Println(startDate, endDate)
  1120. //err = data_manage.RefreshEdbDataBySh(v.EdbInfoId, v.EdbCode, startDate, endDate)
  1121. //if err != nil {
  1122. // return errors.New("RefreshEdbDataBySh:" + err.Error())
  1123. //}
  1124. resp, err := RefreshEdbData(v.EdbInfoId, v.Source, v.EdbCode, startDate)
  1125. if err != nil {
  1126. return errors.New("RefreshEdbData Err:" + err.Error())
  1127. }
  1128. if resp.Ret != 200 {
  1129. return errors.New("RefreshEdbData Err:" + resp.Msg + ";ErrMsg:" + resp.ErrMsg)
  1130. }
  1131. //item, err := data_manage.GetEdbInfoMaxAndMinInfo(v.Source, v.EdbCode)
  1132. //if err != nil {
  1133. // return err
  1134. //}
  1135. //if item != nil {
  1136. // err = data_manage.ModifyEdbInfoMaxAndMinInfo(v.EdbInfoId, item)
  1137. // if err != nil {
  1138. // return err
  1139. // }
  1140. //}
  1141. }
  1142. return err
  1143. }
  1144. // RefreshDataFromDl 刷新大商所数据
  1145. func RefreshDataFromDl(wg *sync.WaitGroup) (err error) {
  1146. defer func() {
  1147. if err != nil {
  1148. fmt.Println("RefreshDataFromDl Err:" + err.Error())
  1149. //go utils.SendEmail(utils.APPNAME+"【"+utils.RunMode+"】"+"失败提醒", "RefreshDataFromDl ErrMsg:"+err.Error(), utils.EmailSendToUsers)
  1150. go alarm_msg.SendAlarmMsg("RefreshDataFromDl ErrMsg:"+err.Error(), 3)
  1151. }
  1152. wg.Done()
  1153. }()
  1154. var condition string
  1155. var pars []interface{}
  1156. condition += " AND source=? "
  1157. pars = append(pars, utils.DATA_SOURCE_DL)
  1158. items, err := data_manage.GetEdbInfoByCondition(condition, pars, 0)
  1159. if err != nil {
  1160. return errors.New("GetEdbInfoByCondition:" + err.Error())
  1161. }
  1162. //var endDate string
  1163. //endDate = time.Now().AddDate(utils.DATA_END_DATE_LIMIT, 0, 0).Format(utils.FormatDateUnSpace)
  1164. for _, v := range items {
  1165. startDate := ""
  1166. if v.Frequency == "日度" {
  1167. startDate = v.EndDate.AddDate(0, 0, -utils.DATA_REFRESH).Format(utils.FormatDate)
  1168. } else if v.Frequency == "周度" {
  1169. startDate = v.EndDate.AddDate(0, 0, -(utils.DATA_REFRESH * 7)).Format(utils.FormatDate)
  1170. } else if v.Frequency == "月度" {
  1171. startDate = v.EndDate.AddDate(0, -utils.DATA_REFRESH, 0).Format(utils.FormatDate)
  1172. } else if v.Frequency == "季度" {
  1173. startDate = v.EndDate.AddDate(0, -utils.DATA_REFRESH*3, 0).Format(utils.FormatDate)
  1174. } else if v.Frequency == "年度" {
  1175. startDate = v.EndDate.AddDate(-utils.DATA_REFRESH, 0, 0).Format(utils.FormatDate)
  1176. } else {
  1177. startDate = v.EndDate.AddDate(0, 0, -utils.DATA_REFRESH).Format(utils.FormatDate)
  1178. }
  1179. //fmt.Println(startDate, endDate)
  1180. //err = data_manage.RefreshEdbDataByDl(v.EdbInfoId, v.EdbCode, startDate, endDate)
  1181. //if err != nil {
  1182. // return errors.New("RefreshEdbDataByDl:" + err.Error())
  1183. //}
  1184. resp, err := RefreshEdbData(v.EdbInfoId, v.Source, v.EdbCode, startDate)
  1185. if err != nil {
  1186. return errors.New("RefreshEdbData Err:" + err.Error())
  1187. }
  1188. if resp.Ret != 200 {
  1189. return errors.New("RefreshEdbData Err:" + resp.Msg + ";ErrMsg:" + resp.ErrMsg)
  1190. }
  1191. //item, err := data_manage.GetEdbInfoMaxAndMinInfo(v.Source, v.EdbCode)
  1192. //if err != nil {
  1193. // return err
  1194. //}
  1195. //if item != nil {
  1196. // err = data_manage.ModifyEdbInfoMaxAndMinInfo(v.EdbInfoId, item)
  1197. // if err != nil {
  1198. // return err
  1199. // }
  1200. //}
  1201. }
  1202. return err
  1203. }
  1204. // RefreshDataFromShfe 刷新上期能源数据
  1205. func RefreshDataFromShfe(wg *sync.WaitGroup) (err error) {
  1206. defer func() {
  1207. if err != nil {
  1208. fmt.Println("RefreshDataFromShfe Err:" + err.Error())
  1209. //go utils.SendEmail(utils.APPNAME+"【"+utils.RunMode+"】"+"失败提醒", "RefreshDataFromShfe ErrMsg:"+err.Error(), utils.EmailSendToUsers)
  1210. go alarm_msg.SendAlarmMsg("RefreshDataFromShfe ErrMsg:"+err.Error(), 3)
  1211. }
  1212. wg.Done()
  1213. }()
  1214. var condition string
  1215. var pars []interface{}
  1216. condition += " AND source=? "
  1217. pars = append(pars, utils.DATA_SOURCE_SHFE)
  1218. items, err := data_manage.GetEdbInfoByCondition(condition, pars, 0)
  1219. if err != nil {
  1220. return errors.New("GetEdbInfoByCondition:" + err.Error())
  1221. }
  1222. //var endDate string
  1223. //endDate = time.Now().AddDate(utils.DATA_END_DATE_LIMIT, 0, 0).Format(utils.FormatDateUnSpace)
  1224. for _, v := range items {
  1225. startDate := ""
  1226. if v.Frequency == "日度" {
  1227. startDate = v.EndDate.AddDate(0, 0, -utils.DATA_REFRESH).Format(utils.FormatDate)
  1228. } else if v.Frequency == "周度" {
  1229. startDate = v.EndDate.AddDate(0, 0, -(utils.DATA_REFRESH * 7)).Format(utils.FormatDate)
  1230. } else if v.Frequency == "月度" {
  1231. startDate = v.EndDate.AddDate(0, -utils.DATA_REFRESH, 0).Format(utils.FormatDate)
  1232. } else if v.Frequency == "季度" {
  1233. startDate = v.EndDate.AddDate(0, -utils.DATA_REFRESH*3, 0).Format(utils.FormatDate)
  1234. } else if v.Frequency == "年度" {
  1235. startDate = v.EndDate.AddDate(-utils.DATA_REFRESH, 0, 0).Format(utils.FormatDate)
  1236. } else {
  1237. startDate = v.EndDate.AddDate(0, 0, -utils.DATA_REFRESH).Format(utils.FormatDate)
  1238. }
  1239. //fmt.Println(startDate, endDate)
  1240. //err = data_manage.RefreshEdbDataByShfe(v.EdbInfoId, v.EdbCode, startDate, endDate)
  1241. //if err != nil {
  1242. // return errors.New("RefreshEdbDataByShfe:" + err.Error())
  1243. //}
  1244. resp, err := RefreshEdbData(v.EdbInfoId, v.Source, v.EdbCode, startDate)
  1245. if err != nil {
  1246. return errors.New("RefreshEdbData Err:" + err.Error())
  1247. }
  1248. if resp.Ret != 200 {
  1249. return errors.New("RefreshEdbData Err:" + resp.Msg + ";ErrMsg:" + resp.ErrMsg)
  1250. }
  1251. //item, err := data_manage.GetEdbInfoMaxAndMinInfo(v.Source, v.EdbCode)
  1252. //if err != nil {
  1253. // return err
  1254. //}
  1255. //if item != nil {
  1256. // err = data_manage.ModifyEdbInfoMaxAndMinInfo(v.EdbInfoId, item)
  1257. // if err != nil {
  1258. // return err
  1259. // }
  1260. //}
  1261. }
  1262. return err
  1263. }
  1264. // RefreshDataFromCffex 刷新中金所数据
  1265. func RefreshDataFromCffex(wg *sync.WaitGroup) (err error) {
  1266. defer func() {
  1267. if err != nil {
  1268. fmt.Println("RefreshDataFromCffex Err:" + err.Error())
  1269. //go utils.SendEmail(utils.APPNAME+"【"+utils.RunMode+"】"+"失败提醒", "RefreshDataFromCffex ErrMsg:"+err.Error(), utils.EmailSendToUsers)
  1270. go alarm_msg.SendAlarmMsg("RefreshDataFromCffex ErrMsg:"+err.Error(), 3)
  1271. }
  1272. wg.Done()
  1273. }()
  1274. var condition string
  1275. var pars []interface{}
  1276. condition += " AND source=? "
  1277. pars = append(pars, utils.DATA_SOURCE_CFFEX)
  1278. items, err := data_manage.GetEdbInfoByCondition(condition, pars, 0)
  1279. if err != nil {
  1280. return errors.New("GetEdbInfoByCondition:" + err.Error())
  1281. }
  1282. //var endDate string
  1283. //endDate = time.Now().AddDate(utils.DATA_END_DATE_LIMIT, 0, 0).Format(utils.FormatDateUnSpace)
  1284. for _, v := range items {
  1285. startDate := ""
  1286. if v.Frequency == "日度" {
  1287. startDate = v.EndDate.AddDate(0, 0, -utils.DATA_REFRESH).Format(utils.FormatDate)
  1288. } else if v.Frequency == "周度" {
  1289. startDate = v.EndDate.AddDate(0, 0, -(utils.DATA_REFRESH * 7)).Format(utils.FormatDate)
  1290. } else if v.Frequency == "月度" {
  1291. startDate = v.EndDate.AddDate(0, -utils.DATA_REFRESH, 0).Format(utils.FormatDate)
  1292. } else if v.Frequency == "季度" {
  1293. startDate = v.EndDate.AddDate(0, -utils.DATA_REFRESH*3, 0).Format(utils.FormatDate)
  1294. } else if v.Frequency == "年度" {
  1295. startDate = v.EndDate.AddDate(-utils.DATA_REFRESH, 0, 0).Format(utils.FormatDate)
  1296. } else {
  1297. startDate = v.EndDate.AddDate(0, 0, -utils.DATA_REFRESH).Format(utils.FormatDate)
  1298. }
  1299. //fmt.Println(startDate, endDate)
  1300. //err = data_manage.RefreshEdbDataByCffex(v.EdbInfoId, v.EdbCode, startDate, endDate)
  1301. //if err != nil {
  1302. // return errors.New("RefreshEdbDataByCffex:" + err.Error())
  1303. //}
  1304. resp, err := RefreshEdbData(v.EdbInfoId, v.Source, v.EdbCode, startDate)
  1305. if err != nil {
  1306. return errors.New("RefreshEdbData Err:" + err.Error())
  1307. }
  1308. if resp.Ret != 200 {
  1309. return errors.New("RefreshEdbData Err:" + resp.Msg + ";ErrMsg:" + resp.ErrMsg)
  1310. }
  1311. //item, err := data_manage.GetEdbInfoMaxAndMinInfo(v.Source, v.EdbCode)
  1312. //if err != nil {
  1313. // return err
  1314. //}
  1315. //if item != nil {
  1316. // err = data_manage.ModifyEdbInfoMaxAndMinInfo(v.EdbInfoId, item)
  1317. // if err != nil {
  1318. // return err
  1319. // }
  1320. //}
  1321. }
  1322. return err
  1323. }
  1324. // RefreshDataFromZz 刷新郑商所数据
  1325. func RefreshDataFromZz(wg *sync.WaitGroup) (err error) {
  1326. defer func() {
  1327. if err != nil {
  1328. fmt.Println("RefreshDataFromZz Err:" + err.Error())
  1329. //go utils.SendEmail(utils.APPNAME+"【"+utils.RunMode+"】"+"失败提醒", "RefreshDataFromZz ErrMsg:"+err.Error(), utils.EmailSendToUsers)
  1330. go alarm_msg.SendAlarmMsg("RefreshDataFromZz ErrMsg:"+err.Error(), 3)
  1331. }
  1332. wg.Done()
  1333. }()
  1334. var condition string
  1335. var pars []interface{}
  1336. condition += " AND source=? "
  1337. pars = append(pars, utils.DATA_SOURCE_ZZ)
  1338. items, err := data_manage.GetEdbInfoByCondition(condition, pars, 0)
  1339. if err != nil {
  1340. return errors.New("GetEdbInfoByCondition:" + err.Error())
  1341. }
  1342. //var endDate string
  1343. //endDate = time.Now().AddDate(utils.DATA_END_DATE_LIMIT, 0, 0).Format(utils.FormatDateUnSpace)
  1344. for _, v := range items {
  1345. startDate := ""
  1346. if v.Frequency == "日度" {
  1347. startDate = v.EndDate.AddDate(0, 0, -utils.DATA_REFRESH).Format(utils.FormatDate)
  1348. } else if v.Frequency == "周度" {
  1349. startDate = v.EndDate.AddDate(0, 0, -(utils.DATA_REFRESH * 7)).Format(utils.FormatDate)
  1350. } else if v.Frequency == "月度" {
  1351. startDate = v.EndDate.AddDate(0, -utils.DATA_REFRESH, 0).Format(utils.FormatDate)
  1352. } else if v.Frequency == "季度" {
  1353. startDate = v.EndDate.AddDate(0, -utils.DATA_REFRESH*3, 0).Format(utils.FormatDate)
  1354. } else if v.Frequency == "年度" {
  1355. startDate = v.EndDate.AddDate(-utils.DATA_REFRESH, 0, 0).Format(utils.FormatDate)
  1356. } else {
  1357. startDate = v.EndDate.AddDate(0, 0, -utils.DATA_REFRESH).Format(utils.FormatDate)
  1358. }
  1359. //fmt.Println(startDate, endDate)
  1360. //err = data_manage.RefreshEdbDataByZz(v.EdbInfoId, v.EdbCode, startDate, endDate)
  1361. //if err != nil {
  1362. // return errors.New("RefreshEdbDataByZz:" + err.Error())
  1363. //}
  1364. resp, err := RefreshEdbData(v.EdbInfoId, v.Source, v.EdbCode, startDate)
  1365. if err != nil {
  1366. return errors.New("RefreshEdbData Err:" + err.Error())
  1367. }
  1368. if resp.Ret != 200 {
  1369. return errors.New("RefreshEdbData Err:" + resp.Msg + ";ErrMsg:" + resp.ErrMsg)
  1370. }
  1371. //item, err := data_manage.GetEdbInfoMaxAndMinInfo(v.Source, v.EdbCode)
  1372. //if err != nil {
  1373. // return err
  1374. //}
  1375. //if item != nil {
  1376. // err = data_manage.ModifyEdbInfoMaxAndMinInfo(v.EdbInfoId, item)
  1377. // if err != nil {
  1378. // return err
  1379. // }
  1380. //}
  1381. }
  1382. return err
  1383. }
  1384. // RefreshDataFromLt 刷新路透数据
  1385. func RefreshDataFromLt(wg *sync.WaitGroup) (err error) {
  1386. defer func() {
  1387. if err != nil {
  1388. fmt.Println("RefreshDataFromLt Err:" + err.Error())
  1389. //go utils.SendEmail(utils.APPNAME+"【"+utils.RunMode+"】"+"失败提醒", "RefreshDataFromLt ErrMsg:"+err.Error(), utils.EmailSendToUsers)
  1390. go alarm_msg.SendAlarmMsg("RefreshDataFromLt ErrMsg:"+err.Error(), 3)
  1391. }
  1392. wg.Done()
  1393. }()
  1394. var condition string
  1395. var pars []interface{}
  1396. condition += " AND source=? "
  1397. pars = append(pars, utils.DATA_SOURCE_LT)
  1398. items, err := data_manage.GetEdbInfoByCondition(condition, pars, 0)
  1399. if err != nil {
  1400. return errors.New("GetEdbInfoByCondition:" + err.Error())
  1401. }
  1402. //endDate := time.Now().Format(utils.FormatDate)
  1403. for _, v := range items {
  1404. startDate := v.StartDate.Format(utils.FormatDate)
  1405. //err = data_manage.RefreshAllEdbDataByLt(v.EdbInfoId, utils.DATA_SOURCE_LT, v.EdbCode, startDate, endDate)
  1406. //if err != nil {
  1407. // return errors.New("RefreshEdbDataByLt:" + err.Error())
  1408. //}
  1409. resp, err := RefreshEdbData(v.EdbInfoId, v.Source, v.EdbCode, startDate)
  1410. if err != nil {
  1411. return errors.New("RefreshEdbData Err:" + err.Error())
  1412. }
  1413. if resp.Ret != 200 {
  1414. return errors.New("RefreshEdbData Err:" + resp.Msg + ";ErrMsg:" + resp.ErrMsg)
  1415. }
  1416. //更新指标的最新数据
  1417. //item, err := data_manage.GetEdbInfoMaxAndMinInfo(v.Source, v.EdbCode)
  1418. //if err != nil {
  1419. // return err
  1420. //}
  1421. //if item != nil {
  1422. // err = data_manage.ModifyEdbInfoMaxAndMinInfo(v.EdbInfoId, item)
  1423. // if err != nil {
  1424. // return err
  1425. // }
  1426. //}
  1427. }
  1428. return err
  1429. }
  1430. func ResetEdbInfoIsUpdate(cont context.Context) (err error) {
  1431. go data_manage.ResetEdbInfoIsUpdate()
  1432. return nil
  1433. }
  1434. // CheckWindDataInterface 检测wind数据服务器
  1435. func CheckWindDataInterface(cont context.Context) (err error) {
  1436. for _, hzDataWindUrl := range utils.Hz_Data_WIND_Url_List {
  1437. go func(urlStr string) {
  1438. checkUrl := urlStr + `hz_server`
  1439. body, err := http.Get(checkUrl)
  1440. if err != nil {
  1441. msg := fmt.Sprintf("检测:%s ;失败:CheckWindDataInterface ErrMsg:%s", checkUrl, err.Error())
  1442. //go utils.SendEmail(utils.APPNAME+"【"+utils.RunMode+"】"+"检测数据接口:失败提醒", "检测路透数据服务器失败:CheckLtDataInterface ErrMsg:"+err.Error(), utils.EmailSendToUsers)
  1443. go alarm_msg.SendAlarmMsg(msg, 3)
  1444. } else {
  1445. result := string(body)
  1446. if result != `1` {
  1447. //go utils.SendEmail(utils.APPNAME+"【"+utils.RunMode+"】"+"检测数据接口:失败提醒", "检测路透数据服务器失败:CheckLtDataInterface ErrMsg:"+string(body), utils.EmailSendToUsers)
  1448. //msg := "检测Wind数据服务器2失败:CheckWindDataInterface ErrMsg:" + string(body)
  1449. msg := fmt.Sprintf("检测%s ;失败:CheckWindDataInterface ErrMsg:%s", checkUrl, string(body))
  1450. go alarm_msg.SendAlarmMsg(msg, 3)
  1451. }
  1452. }
  1453. }(hzDataWindUrl)
  1454. }
  1455. return
  1456. }
  1457. // RefreshDataFromCoal 刷新煤炭网数据
  1458. func RefreshDataFromCoal(wg *sync.WaitGroup) (err error) {
  1459. defer func() {
  1460. if err != nil {
  1461. fmt.Println("RefreshDataFromCoal Err:" + err.Error())
  1462. //go utils.SendEmail(utils.APPNAME+"【"+utils.RunMode+"】"+"失败提醒", "RefreshDataFromCoal ErrMsg:"+err.Error(), utils.EmailSendToUsers)
  1463. go alarm_msg.SendAlarmMsg("RefreshDataFromCoal ErrMsg:"+err.Error(), 3)
  1464. }
  1465. wg.Done()
  1466. }()
  1467. var condition string
  1468. var pars []interface{}
  1469. condition += " AND source=? "
  1470. pars = append(pars, utils.DATA_SOURCE_COAL)
  1471. items, err := data_manage.GetEdbInfoByCondition(condition, pars, 0)
  1472. if err != nil {
  1473. return errors.New("GetEdbInfoByCondition:" + err.Error())
  1474. }
  1475. //var endDate string
  1476. //endDate = time.Now().AddDate(utils.DATA_END_DATE_LIMIT, 0, 0).Format(utils.FormatDateUnSpace)
  1477. for _, v := range items {
  1478. startDate := ""
  1479. if v.Frequency == "日度" {
  1480. startDate = v.EndDate.AddDate(0, 0, -utils.DATA_REFRESH).Format(utils.FormatDate)
  1481. } else if v.Frequency == "周度" {
  1482. startDate = v.EndDate.AddDate(0, 0, -(utils.DATA_REFRESH * 7)).Format(utils.FormatDate)
  1483. } else if v.Frequency == "月度" {
  1484. startDate = v.EndDate.AddDate(0, -utils.DATA_REFRESH, 0).Format(utils.FormatDate)
  1485. } else if v.Frequency == "季度" {
  1486. startDate = v.EndDate.AddDate(0, -utils.DATA_REFRESH*3, 0).Format(utils.FormatDate)
  1487. } else if v.Frequency == "年度" {
  1488. startDate = v.EndDate.AddDate(-utils.DATA_REFRESH, 0, 0).Format(utils.FormatDate)
  1489. } else {
  1490. startDate = v.EndDate.AddDate(0, 0, -utils.DATA_REFRESH).Format(utils.FormatDate)
  1491. }
  1492. //fmt.Println(startDate, endDate)
  1493. //err = data_manage.RefreshEdbDataByZz(v.EdbInfoId, v.EdbCode, startDate, endDate)
  1494. //if err != nil {
  1495. // return errors.New("RefreshEdbDataByZz:" + err.Error())
  1496. //}
  1497. resp, err := RefreshEdbData(v.EdbInfoId, v.Source, v.EdbCode, startDate)
  1498. if err != nil {
  1499. return errors.New("RefreshEdbData Err:" + err.Error())
  1500. }
  1501. if resp.Ret != 200 {
  1502. return errors.New("RefreshEdbData Err:" + resp.Msg + ";ErrMsg:" + resp.ErrMsg)
  1503. }
  1504. //item, err := data_manage.GetEdbInfoMaxAndMinInfo(v.Source, v.EdbCode)
  1505. //if err != nil {
  1506. // return err
  1507. //}
  1508. //if item != nil {
  1509. // err = data_manage.ModifyEdbInfoMaxAndMinInfo(v.EdbInfoId, item)
  1510. // if err != nil {
  1511. // return err
  1512. // }
  1513. //}
  1514. }
  1515. return err
  1516. }
  1517. // RefreshDataFromEic 刷欧洲天然气数据
  1518. func RefreshDataFromEic(wg *sync.WaitGroup) (err error) {
  1519. defer func() {
  1520. if err != nil {
  1521. fmt.Println("RefreshDataFromEic Err:" + err.Error())
  1522. //go utils.SendEmail(utils.APPNAME+"【"+utils.RunMode+"】"+"失败提醒", "RefreshDataFromCoal ErrMsg:"+err.Error(), utils.EmailSendToUsers)
  1523. go alarm_msg.SendAlarmMsg("RefreshDataFromEic ErrMsg:"+err.Error(), 3)
  1524. }
  1525. wg.Done()
  1526. }()
  1527. var condition string
  1528. var pars []interface{}
  1529. condition += " AND source=? "
  1530. pars = append(pars, utils.DATA_SOURCE_GIE)
  1531. items, err := data_manage.GetEdbInfoByCondition(condition, pars, 0)
  1532. if err != nil {
  1533. return errors.New("GetEdbInfoByCondition:" + err.Error())
  1534. }
  1535. //var endDate string
  1536. //endDate = time.Now().AddDate(utils.DATA_END_DATE_LIMIT, 0, 0).Format(utils.FormatDateUnSpace)
  1537. for _, v := range items {
  1538. startDate := ""
  1539. if v.Frequency == "日度" {
  1540. startDate = v.EndDate.AddDate(0, 0, -utils.DATA_REFRESH).Format(utils.FormatDate)
  1541. } else if v.Frequency == "周度" {
  1542. startDate = v.EndDate.AddDate(0, 0, -(utils.DATA_REFRESH * 7)).Format(utils.FormatDate)
  1543. } else if v.Frequency == "月度" {
  1544. startDate = v.EndDate.AddDate(0, -utils.DATA_REFRESH, 0).Format(utils.FormatDate)
  1545. } else if v.Frequency == "季度" {
  1546. startDate = v.EndDate.AddDate(0, -utils.DATA_REFRESH*3, 0).Format(utils.FormatDate)
  1547. } else if v.Frequency == "年度" {
  1548. startDate = v.EndDate.AddDate(-utils.DATA_REFRESH, 0, 0).Format(utils.FormatDate)
  1549. } else {
  1550. startDate = v.EndDate.AddDate(0, 0, -utils.DATA_REFRESH).Format(utils.FormatDate)
  1551. }
  1552. //fmt.Println(startDate, endDate)
  1553. //err = data_manage.RefreshEdbDataByZz(v.EdbInfoId, v.EdbCode, startDate, endDate)
  1554. //if err != nil {
  1555. // return errors.New("RefreshEdbDataByZz:" + err.Error())
  1556. //}
  1557. resp, err := RefreshEdbData(v.EdbInfoId, v.Source, v.EdbCode, startDate)
  1558. if err != nil {
  1559. return errors.New("RefreshEdbData Err:" + err.Error())
  1560. }
  1561. if resp.Ret != 200 {
  1562. return errors.New("RefreshEdbData Err:" + resp.Msg + ";ErrMsg:" + resp.ErrMsg)
  1563. }
  1564. //item, err := data_manage.GetEdbInfoMaxAndMinInfo(v.Source, v.EdbCode)
  1565. //if err != nil {
  1566. // return err
  1567. //}
  1568. //if item != nil {
  1569. // err = data_manage.ModifyEdbInfoMaxAndMinInfo(v.EdbInfoId, item)
  1570. // if err != nil {
  1571. // return err
  1572. // }
  1573. //}
  1574. }
  1575. return err
  1576. }
  1577. // RefreshDataFromEic 刷新谷歌出行数据
  1578. func RefreshDataFromGoogleTravel(wg *sync.WaitGroup) (err error) {
  1579. defer func() {
  1580. if err != nil {
  1581. fmt.Println("RefreshDataFromGoogleTravel Err:" + err.Error())
  1582. go alarm_msg.SendAlarmMsg("RefreshDataFromGoogleTravel ErrMsg:"+err.Error(), 3)
  1583. }
  1584. wg.Done()
  1585. }()
  1586. var condition string
  1587. var pars []interface{}
  1588. condition += " AND source=? "
  1589. pars = append(pars, utils.DATA_SOURCE_GOOGLE_TRAVEL)
  1590. items, err := data_manage.GetEdbInfoByCondition(condition, pars, 0)
  1591. if err != nil {
  1592. return errors.New("GetEdbInfoByCondition:" + err.Error())
  1593. }
  1594. for _, v := range items {
  1595. startDate := ""
  1596. if v.Frequency == "日度" {
  1597. startDate = v.EndDate.AddDate(0, 0, -utils.DATA_REFRESH).Format(utils.FormatDate)
  1598. } else if v.Frequency == "周度" {
  1599. startDate = v.EndDate.AddDate(0, 0, -(utils.DATA_REFRESH * 7)).Format(utils.FormatDate)
  1600. } else if v.Frequency == "月度" {
  1601. startDate = v.EndDate.AddDate(0, -utils.DATA_REFRESH, 0).Format(utils.FormatDate)
  1602. } else if v.Frequency == "季度" {
  1603. startDate = v.EndDate.AddDate(0, -utils.DATA_REFRESH*3, 0).Format(utils.FormatDate)
  1604. } else if v.Frequency == "年度" {
  1605. startDate = v.EndDate.AddDate(-utils.DATA_REFRESH, 0, 0).Format(utils.FormatDate)
  1606. } else {
  1607. startDate = v.EndDate.AddDate(0, 0, -utils.DATA_REFRESH).Format(utils.FormatDate)
  1608. }
  1609. resp, err := RefreshEdbData(v.EdbInfoId, v.Source, v.EdbCode, startDate)
  1610. if err != nil {
  1611. return errors.New("RefreshEdbData Err:" + err.Error())
  1612. }
  1613. if resp.Ret != 200 {
  1614. return errors.New("RefreshEdbData Err:" + resp.Msg + ";ErrMsg:" + resp.ErrMsg)
  1615. }
  1616. //item, err := data_manage.GetEdbInfoMaxAndMinInfo(v.Source, v.EdbCode)
  1617. //if err != nil {
  1618. // return err
  1619. //}
  1620. //if item != nil {
  1621. // err = data_manage.ModifyEdbInfoMaxAndMinInfo(v.EdbInfoId, item)
  1622. // if err != nil {
  1623. // return err
  1624. // }
  1625. //}
  1626. }
  1627. return err
  1628. }