edb_info.go 61 KB

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