base_from_predict_calculate.go 43 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979980981982983984985986987988989990991992993994995996997998999100010011002100310041005100610071008100910101011101210131014101510161017101810191020102110221023102410251026102710281029103010311032103310341035103610371038103910401041104210431044104510461047104810491050105110521053105410551056105710581059106010611062106310641065106610671068106910701071107210731074107510761077107810791080108110821083108410851086108710881089109010911092109310941095109610971098109911001101110211031104110511061107110811091110111111121113111411151116111711181119112011211122112311241125112611271128112911301131113211331134113511361137113811391140114111421143114411451146114711481149115011511152115311541155115611571158115911601161116211631164116511661167116811691170117111721173117411751176117711781179118011811182118311841185118611871188118911901191119211931194119511961197119811991200120112021203120412051206120712081209121012111212121312141215121612171218121912201221122212231224122512261227122812291230123112321233123412351236123712381239124012411242124312441245124612471248124912501251125212531254125512561257125812591260126112621263126412651266126712681269127012711272127312741275127612771278127912801281128212831284128512861287128812891290129112921293129412951296129712981299130013011302130313041305130613071308130913101311131213131314131513161317131813191320
  1. package controllers
  2. import (
  3. "encoding/json"
  4. "eta/eta_index_lib/logic"
  5. "eta/eta_index_lib/models"
  6. "eta/eta_index_lib/utils"
  7. "fmt"
  8. "strconv"
  9. "strings"
  10. "time"
  11. )
  12. // PredictCalculateController 预测计算指标
  13. type PredictCalculateController struct {
  14. BaseAuthController
  15. }
  16. // Save
  17. // @Title 新增/编辑预测指标运算接口
  18. // @Description 新增预测指标运算接口
  19. // @Success 200 {object} models.EdbInfoCalculateSaveReq
  20. // @router /save [post]
  21. func (this *PredictCalculateController) Save() {
  22. br := new(models.BaseResponse).Init()
  23. defer func() {
  24. this.Data["json"] = br
  25. this.ServeJSON()
  26. }()
  27. var req models.EdbInfoCalculateSaveReq
  28. err := json.Unmarshal(this.Ctx.Input.RequestBody, &req)
  29. if err != nil {
  30. br.Msg = "参数解析异常!"
  31. br.ErrMsg = "参数解析失败,Err:" + err.Error()
  32. return
  33. }
  34. if req.EdbInfoId <= 0 {
  35. addPredictCalculate(br, req, this.Lang)
  36. } else {
  37. editPredictCalculate(br, req, this.Lang)
  38. }
  39. }
  40. // AddPredictCalculate 添加预测指标运算
  41. func addPredictCalculate(br *models.BaseResponse, req models.EdbInfoCalculateSaveReq, lang string) {
  42. req.EdbName = strings.Trim(req.EdbName, " ")
  43. if req.EdbName == "" {
  44. br.Msg = "指标名称不能为空"
  45. return
  46. }
  47. if req.Frequency == "" {
  48. br.Msg = "频率不能为空"
  49. return
  50. }
  51. if req.Unit == "" {
  52. br.Msg = "单位不能为空"
  53. return
  54. }
  55. if req.ClassifyId <= 0 {
  56. br.Msg = "请选择分类"
  57. return
  58. }
  59. if len(req.EdbInfoIdArr) <= 0 {
  60. br.Msg = "请选择指标"
  61. return
  62. }
  63. if req.CalculateFormula == "" {
  64. br.Msg = "请填写指标"
  65. return
  66. }
  67. //加入缓存机制,避免创建同一个名称的指标 start
  68. redisKey := fmt.Sprint("predict_edb_info:calculate:batch:save:", utils.DATA_SOURCE_PREDICT_CALCULATE, ":", req.EdbName)
  69. isExist := utils.Rc.IsExist(redisKey)
  70. if isExist {
  71. br.Msg = "指标正在处理,请勿重复提交"
  72. return
  73. } else {
  74. //设置3分钟缓存
  75. utils.Rc.SetNX(redisKey, 1, time.Second*300)
  76. defer func() {
  77. _ = utils.Rc.Delete(redisKey)
  78. }()
  79. }
  80. calculateFormula := req.CalculateFormula
  81. calculateFormula = strings.Replace(calculateFormula, "(", "(", -1)
  82. calculateFormula = strings.Replace(calculateFormula, ")", ")", -1)
  83. calculateFormula = strings.Replace(calculateFormula, ",", ",", -1)
  84. calculateFormula = strings.Replace(calculateFormula, "。", ".", -1)
  85. if strings.Contains(req.CalculateFormula, "%") {
  86. calculateFormula = strings.Replace(calculateFormula, "%", "*0.01", -1)
  87. }
  88. req.CalculateFormula = calculateFormula
  89. //检验公式
  90. var formulaStr string
  91. var edbInfoIdBytes []string
  92. for _, v := range req.EdbInfoIdArr {
  93. formulaStr += v.FromTag + ","
  94. edbInfoIdBytes = append(edbInfoIdBytes, v.FromTag)
  95. }
  96. formulaSlice, err := utils.CheckFormulaJson(req.CalculateFormula)
  97. if err != nil {
  98. br.Msg = "公式格式错误,请重新填写"
  99. return
  100. }
  101. for _, formula := range formulaSlice {
  102. formulaMap, e := utils.CheckFormula(formula)
  103. if e != nil {
  104. br.Msg = "公式错误,请重新填写"
  105. return
  106. }
  107. for _, v := range formulaMap {
  108. if !strings.Contains(formulaStr, v) {
  109. br.Msg = "公式错误,请重新填写"
  110. return
  111. }
  112. }
  113. }
  114. // 根据指标名称和指标ID校验库中是否还存在其他同名指标
  115. existEdbName, err := logic.CheckExistByEdbNameAndEdbInfoId(1, 0, req.EdbName, lang)
  116. if err != nil {
  117. br.Msg = "判断指标名称是否存在失败"
  118. br.ErrMsg = "判断指标名称是否存在失败,Err:" + err.Error()
  119. return
  120. }
  121. if existEdbName {
  122. br.Msg = "指标名称已存在,请重新填写"
  123. br.ErrMsg = "指标名称已存在,请重新填写"
  124. return
  125. }
  126. // 关联指标信息
  127. edbInfoList := make([]*models.EdbInfo, 0)
  128. calculateMappingList := make([]*models.EdbInfoCalculateMapping, 0)
  129. for k, v := range req.EdbInfoIdArr {
  130. fromEdbInfo, err := models.GetEdbInfoById(v.EdbInfoId)
  131. if err != nil {
  132. if err.Error() == utils.ErrNoRow() {
  133. br.Msg = "生成计算指标失败"
  134. br.Msg = "指标 " + strconv.Itoa(v.EdbInfoId) + " 不存在"
  135. return
  136. }
  137. br.Msg = "生成计算指标失败"
  138. br.Msg = "获取指标失败:Err:" + err.Error()
  139. return
  140. }
  141. edbInfoList = append(edbInfoList, fromEdbInfo)
  142. //关联关系表
  143. {
  144. calculateMappingItem := &models.EdbInfoCalculateMapping{
  145. CreateTime: time.Now(),
  146. ModifyTime: time.Now(),
  147. Sort: k + 1,
  148. //EdbCode: edbCode,
  149. //EdbInfoId: int(edbInfoId),
  150. FromEdbInfoId: fromEdbInfo.EdbInfoId,
  151. FromEdbCode: fromEdbInfo.EdbCode,
  152. FromEdbName: fromEdbInfo.EdbName,
  153. FromSource: fromEdbInfo.Source,
  154. FromSourceName: fromEdbInfo.SourceName,
  155. FromTag: v.FromTag,
  156. Source: utils.DATA_SOURCE_PREDICT_CALCULATE,
  157. SourceName: "预测指标运算",
  158. }
  159. calculateMappingList = append(calculateMappingList, calculateMappingItem)
  160. }
  161. }
  162. for _, v := range formulaSlice {
  163. formulaMap, e := utils.CheckFormula(v)
  164. if e != nil {
  165. br.Msg = "公式错误,请重新填写"
  166. return
  167. }
  168. //预先计算,判断公式是否正常
  169. ok, _ := models.CheckFormula2(edbInfoList, formulaMap, v, edbInfoIdBytes)
  170. if !ok {
  171. br.Msg = "生成计算指标失败,请使用正确的计算公式"
  172. return
  173. }
  174. }
  175. // 指标入库
  176. randStr := utils.GetRandDigit(4)
  177. edbCode := `C2` + time.Now().Format("060102") + randStr
  178. timestamp := strconv.FormatInt(time.Now().UnixNano(), 10)
  179. uniqueCode := utils.MD5(utils.DATA_PREFIX + "_" + timestamp)
  180. edbInfo := &models.EdbInfo{
  181. EdbInfoType: 1,
  182. Source: utils.DATA_SOURCE_PREDICT_CALCULATE,
  183. SourceName: "预测指标运算",
  184. EdbCode: edbCode,
  185. EdbName: req.EdbName,
  186. EdbNameSource: req.EdbName,
  187. Frequency: req.Frequency,
  188. Unit: req.Unit,
  189. ClassifyId: req.ClassifyId,
  190. SysUserId: req.AdminId,
  191. SysUserRealName: req.AdminName,
  192. CreateTime: time.Now(),
  193. ModifyTime: time.Now(),
  194. UniqueCode: uniqueCode,
  195. CalculateFormula: req.CalculateFormula,
  196. EdbType: 2,
  197. EmptyType: req.EmptyType,
  198. MaxEmptyType: req.MaxEmptyType,
  199. EdbNameEn: req.EdbName,
  200. UnitEn: req.Unit,
  201. }
  202. edbInfoId, err := models.AddEdbInfo(edbInfo)
  203. if err != nil {
  204. br.Msg = "生成计算指标失败"
  205. br.Msg = "生成计算指标失败,AddEdbInfo Err:" + err.Error()
  206. return
  207. }
  208. edbInfo.EdbInfoId = int(edbInfoId)
  209. //处理同名指标
  210. {
  211. edbNameList, err := models.GetEdbInfoByName(req.EdbName)
  212. if err != nil {
  213. br.Msg = "保存失败"
  214. br.ErrMsg = "获取指标信息失败,Err:" + err.Error()
  215. return
  216. }
  217. if len(edbNameList) >= 2 {
  218. for _, v := range edbNameList {
  219. edbName := v.EdbName + "(" + v.SourceName + ")"
  220. err = models.ModifyEdbInfoNameSource(edbName, v.EdbInfoId)
  221. if err != nil {
  222. br.Msg = "保存失败"
  223. br.ErrMsg = "修改指标名称失败,Err:" + err.Error()
  224. return
  225. }
  226. }
  227. }
  228. }
  229. //关联关系表入库
  230. {
  231. if len(calculateMappingList) > 0 {
  232. for k, v := range calculateMappingList {
  233. v.EdbCode = edbInfo.EdbCode
  234. v.EdbInfoId = edbInfo.EdbInfoId
  235. calculateMappingList[k] = v
  236. }
  237. go models.AddEdbInfoCalculateMappingMulti(calculateMappingList)
  238. }
  239. }
  240. // 开始添加预测指标
  241. latestDateStr, latestValue, err := models.AddPredictCalculateData(edbInfoList, edbInfo, edbCode, req.CalculateFormula, edbInfoIdBytes)
  242. if err != nil {
  243. br.Msg = "生成计算指标失败"
  244. br.Msg = "生成计算指标失败,Calculate Err:" + err.Error()
  245. return
  246. }
  247. // 更新指标最大最小值
  248. err, errMsg := models.UnifiedModifyPredictEdbInfoMaxAndMinInfo(edbInfo, latestDateStr, latestValue)
  249. if err != nil {
  250. br.Msg = errMsg
  251. br.ErrMsg = err.Error()
  252. return
  253. }
  254. resp := models.AddEdbInfoResp{
  255. EdbInfoId: int(edbInfoId),
  256. UniqueCode: uniqueCode,
  257. }
  258. br.Ret = 200
  259. br.Success = true
  260. br.Msg = "保存成功"
  261. br.Data = resp
  262. br.IsAddLog = true
  263. }
  264. // editPredictCalculate 编辑预测指标运算
  265. func editPredictCalculate(br *models.BaseResponse, req models.EdbInfoCalculateSaveReq, lang string) {
  266. req.EdbName = strings.Trim(req.EdbName, " ")
  267. if req.EdbName == "" {
  268. br.Msg = "指标名称不能为空"
  269. return
  270. }
  271. if req.Frequency == "" {
  272. br.Msg = "频率不能为空"
  273. return
  274. }
  275. if req.Unit == "" {
  276. br.Msg = "单位不能为空"
  277. return
  278. }
  279. if req.ClassifyId <= 0 {
  280. br.Msg = "请选择分类"
  281. return
  282. }
  283. if len(req.EdbInfoIdArr) <= 0 {
  284. br.Msg = "请选择指标"
  285. return
  286. }
  287. if req.CalculateFormula == "" {
  288. br.Msg = "请填写指标"
  289. return
  290. }
  291. //加入缓存机制,避免创建同一个名称的指标 start
  292. redisKey := fmt.Sprint("predict_edb_info:calculate:batch:save:", utils.DATA_SOURCE_PREDICT_CALCULATE, ":", req.EdbName)
  293. isExist := utils.Rc.IsExist(redisKey)
  294. if isExist {
  295. br.Msg = "指标正在处理,请勿重复提交"
  296. // return
  297. } else {
  298. //设置3分钟缓存
  299. utils.Rc.SetNX(redisKey, 1, time.Second*300)
  300. defer func() {
  301. _ = utils.Rc.Delete(redisKey)
  302. }()
  303. }
  304. calculateFormula := req.CalculateFormula
  305. calculateFormula = strings.Replace(calculateFormula, "(", "(", -1)
  306. calculateFormula = strings.Replace(calculateFormula, ")", ")", -1)
  307. calculateFormula = strings.Replace(calculateFormula, ",", ",", -1)
  308. calculateFormula = strings.Replace(calculateFormula, "。", ".", -1)
  309. if strings.Contains(req.CalculateFormula, "%") {
  310. calculateFormula = strings.Replace(calculateFormula, "%", "*0.01", -1)
  311. }
  312. req.CalculateFormula = calculateFormula
  313. //检验公式
  314. var formulaStr string
  315. var edbInfoIdBytes []string
  316. for _, v := range req.EdbInfoIdArr {
  317. formulaStr += v.FromTag + ","
  318. edbInfoIdBytes = append(edbInfoIdBytes, v.FromTag)
  319. }
  320. formulaSlice, err := utils.CheckFormulaJson(req.CalculateFormula)
  321. if err != nil {
  322. br.Msg = "公式格式错误,请重新填写"
  323. return
  324. }
  325. for _, formula := range formulaSlice {
  326. formulaMap, e := utils.CheckFormula(formula)
  327. if e != nil {
  328. br.Msg = "公式错误,请重新填写"
  329. return
  330. }
  331. for _, v := range formulaMap {
  332. if !strings.Contains(formulaStr, v) {
  333. br.Msg = "公式错误,请重新填写"
  334. return
  335. }
  336. }
  337. }
  338. // 获取计算指标信息
  339. edbInfo, err := models.GetEdbInfoById(req.EdbInfoId)
  340. if err != nil {
  341. br.Msg = "获取指标信息失败"
  342. br.ErrMsg = "获取指标信息失败,Err:" + err.Error()
  343. return
  344. }
  345. // 根据指标名称和指标ID校验库中是否还存在其他同名指标
  346. existEdbName, err := logic.CheckExistByEdbNameAndEdbInfoId(edbInfo.EdbInfoType, edbInfo.EdbInfoId, req.EdbName, lang)
  347. if err != nil {
  348. br.Msg = "判断指标名称是否存在失败"
  349. br.ErrMsg = "判断指标名称是否存在失败,Err:" + err.Error()
  350. return
  351. }
  352. if existEdbName {
  353. br.Msg = "指标名称已存在,请重新填写"
  354. br.ErrMsg = "指标名称已存在,请重新填写"
  355. return
  356. }
  357. // 关联指标信息
  358. edbInfoList := make([]*models.EdbInfo, 0)
  359. calculateMappingList := make([]*models.EdbInfoCalculateMapping, 0)
  360. for k, v := range req.EdbInfoIdArr {
  361. fromEdbInfo, err := models.GetEdbInfoById(v.EdbInfoId)
  362. if err != nil {
  363. if err.Error() == utils.ErrNoRow() {
  364. br.Msg = "生成计算指标失败"
  365. br.Msg = "指标 " + strconv.Itoa(v.EdbInfoId) + " 不存在"
  366. return
  367. }
  368. br.Msg = "生成计算指标失败"
  369. br.Msg = "获取指标失败:Err:" + err.Error()
  370. return
  371. }
  372. edbInfoList = append(edbInfoList, fromEdbInfo)
  373. //关联关系表
  374. {
  375. calculateMappingItem := &models.EdbInfoCalculateMapping{
  376. CreateTime: time.Now(),
  377. ModifyTime: time.Now(),
  378. Sort: k + 1,
  379. EdbCode: edbInfo.EdbCode,
  380. EdbInfoId: edbInfo.EdbInfoId,
  381. FromEdbInfoId: fromEdbInfo.EdbInfoId,
  382. FromEdbCode: fromEdbInfo.EdbCode,
  383. FromEdbName: fromEdbInfo.EdbName,
  384. FromSource: fromEdbInfo.Source,
  385. FromSourceName: fromEdbInfo.SourceName,
  386. FromTag: v.FromTag,
  387. Source: utils.DATA_SOURCE_PREDICT_CALCULATE,
  388. SourceName: "预测指标运算",
  389. }
  390. calculateMappingList = append(calculateMappingList, calculateMappingItem)
  391. }
  392. }
  393. for _, v := range formulaSlice {
  394. formulaMap, e := utils.CheckFormula(v)
  395. if e != nil {
  396. br.Msg = "公式错误,请重新填写"
  397. return
  398. }
  399. //预先计算,判断公式是否正常
  400. ok, _ := models.CheckFormula2(edbInfoList, formulaMap, v, edbInfoIdBytes)
  401. if !ok {
  402. br.Msg = "生成计算指标失败,请使用正确的计算公式"
  403. return
  404. }
  405. }
  406. //处理同名指标
  407. {
  408. edbNameList, err := models.GetEdbInfoByName(req.EdbName)
  409. if err != nil {
  410. br.Msg = "保存失败"
  411. br.ErrMsg = "获取指标信息失败,Err:" + err.Error()
  412. return
  413. }
  414. if len(edbNameList) >= 2 {
  415. for _, v := range edbNameList {
  416. edbName := v.EdbName + "(" + v.SourceName + ")"
  417. err = models.ModifyEdbInfoNameSource(edbName, v.EdbInfoId)
  418. if err != nil {
  419. br.Msg = "保存失败"
  420. br.ErrMsg = "修改指标名称失败,Err:" + err.Error()
  421. return
  422. }
  423. }
  424. }
  425. }
  426. switch lang {
  427. case utils.EnLangVersion:
  428. edbInfo.EdbNameEn = req.EdbName
  429. edbInfo.UnitEn = req.Unit
  430. default:
  431. edbInfo.EdbName = req.EdbName
  432. edbInfo.Unit = req.Unit
  433. }
  434. edbInfo.Frequency = req.Frequency
  435. edbInfo.ClassifyId = req.ClassifyId
  436. edbInfo.CalculateFormula = req.CalculateFormula
  437. edbInfo.EmptyType = req.EmptyType
  438. edbInfo.MaxEmptyType = req.MaxEmptyType
  439. err = models.EditPredictCalculate(edbInfo, calculateMappingList)
  440. if err != nil {
  441. br.Msg = "修改计算指标失败"
  442. br.Msg = "修改计算指标失败,Calculate Err:" + err.Error()
  443. return
  444. }
  445. // 开始添加预测指标
  446. latestDateStr, latestValue, err := models.AddPredictCalculateData(edbInfoList, edbInfo, edbInfo.EdbCode, req.CalculateFormula, edbInfoIdBytes)
  447. if err != nil {
  448. br.Msg = "生成计算指标失败"
  449. br.Msg = "生成计算指标失败,Calculate Err:" + err.Error()
  450. return
  451. }
  452. // 更新指标最大最小值
  453. err, errMsg := models.UnifiedModifyPredictEdbInfoMaxAndMinInfo(edbInfo, latestDateStr, latestValue)
  454. if err != nil {
  455. br.Msg = errMsg
  456. br.ErrMsg = err.Error()
  457. return
  458. }
  459. resp := models.AddEdbInfoResp{
  460. EdbInfoId: edbInfo.EdbInfoId,
  461. UniqueCode: edbInfo.UniqueCode,
  462. }
  463. br.Ret = 200
  464. br.Success = true
  465. br.Msg = "保存成功"
  466. br.Data = resp
  467. br.IsAddLog = true
  468. }
  469. // CalculateBatchSave
  470. // @Title 累计值转月-同比值-同差等计算新增
  471. // @Description 累计值转月-同比值-同差等计算新增接口
  472. // @Param request body models.EdbInfoCalculateBatchSaveReq true "type json string"
  473. // @Success Ret=200 返回指标id
  474. // @router /batch/save [post]
  475. func (this *PredictCalculateController) CalculateBatchSave() {
  476. br := new(models.BaseResponse).Init()
  477. defer func() {
  478. this.Data["json"] = br
  479. this.ServeJSON()
  480. }()
  481. var req models.EdbInfoCalculateBatchSaveReq
  482. err := json.Unmarshal(this.Ctx.Input.RequestBody, &req)
  483. if err != nil {
  484. br.Msg = "参数解析异常!"
  485. br.ErrMsg = "参数解析失败,Err:" + err.Error()
  486. return
  487. }
  488. req.EdbName = strings.Trim(req.EdbName, " ")
  489. if req.EdbName == "" {
  490. br.Msg = "指标名称不能为空"
  491. return
  492. }
  493. if req.Frequency == "" {
  494. br.Msg = "频率不能为空"
  495. return
  496. }
  497. if req.Unit == "" {
  498. br.Msg = "单位不能为空"
  499. return
  500. }
  501. if req.ClassifyId <= 0 {
  502. br.Msg = "请选择分类"
  503. return
  504. }
  505. // 基础指标id
  506. fromEdbInfoId := req.FromEdbInfoId
  507. notNeedFromEdbSourceList := []int{utils.DATA_SOURCE_PREDICT_CALCULATE_KSZS, utils.DATA_SOURCE_PREDICT_CALCULATE_NHCC} // 不需要传入来源指标id的 指标类型
  508. if fromEdbInfoId <= 0 && !utils.InArrayByInt(notNeedFromEdbSourceList, req.Source) {
  509. br.Msg = "请选择指标"
  510. return
  511. }
  512. //加入缓存机制,避免创建同一个名称的指标 start
  513. redisKey := fmt.Sprint("edb_lib:predict_calculate:batch:save:", req.Source, ":", req.EdbName)
  514. isExist := utils.Rc.IsExist(redisKey)
  515. if isExist {
  516. br.Msg = "指标正在处理,请勿重复提交"
  517. return
  518. } else {
  519. //设置3分钟缓存
  520. utils.Rc.SetNX(redisKey, 1, time.Second*300)
  521. defer func() {
  522. _ = utils.Rc.Delete(redisKey)
  523. }()
  524. }
  525. //加入缓存机制,避免创建同一个名称的指标 end
  526. // 根据指标名称和指标ID校验库中是否还存在其他同名指标
  527. existEdbName, err := logic.CheckExistByEdbNameAndEdbInfoId(1, req.EdbInfoId, req.EdbName, this.Lang)
  528. if err != nil {
  529. br.Msg = "判断指标名称是否存在失败"
  530. br.ErrMsg = "判断指标名称是否存在失败,Err:" + err.Error()
  531. return
  532. }
  533. if existEdbName {
  534. br.Msg = "指标名称已存在,请重新填写"
  535. br.ErrMsg = "指标名称已存在,请重新填写"
  536. return
  537. }
  538. //生成指标编码
  539. randStr := utils.GetRandDigit(4)
  540. edbCode := `C` + time.Now().Format("060102") + randStr
  541. timestamp := strconv.FormatInt(time.Now().UnixNano(), 10)
  542. uniqueCode := utils.MD5(utils.DATA_PREFIX + "_" + timestamp)
  543. adminId := req.AdminId
  544. adminName := req.AdminName
  545. var sourName string
  546. var errMsg string
  547. var edbInfo *models.EdbInfo
  548. var latestDateStr string // 最近实际数据的日期
  549. var latestValue float64 // 最近实际数据的值
  550. var formulaInt int
  551. var nhccDate models.NhccDate // 拟合残差的日期
  552. switch req.Source {
  553. case utils.DATA_SOURCE_PREDICT_CALCULATE_NSZYDPJJS, utils.DATA_SOURCE_PREDICT_CALCULATE_HBZ, utils.DATA_SOURCE_PREDICT_CALCULATE_HCZ, utils.DATA_SOURCE_PREDICT_CALCULATE_TIME_SHIFT, utils.DATA_SOURCE_PREDICT_CALCULATE_CJJX:
  554. if req.Formula == "" {
  555. br.Msg = "请填写N值"
  556. return
  557. }
  558. formulaInt, _ = strconv.Atoi(req.Formula)
  559. if formulaInt <= 0 {
  560. br.Msg = "N值输入错误,请重新输入"
  561. return
  562. }
  563. /*case utils.DATA_SOURCE_PREDICT_CALCULATE_ZJPJ:
  564. //直接拼接指标
  565. //校验时间格式
  566. _, err = time.ParseInLocation(utils.FormatDate, req.Formula, time.Local)
  567. if err != nil {
  568. br.Msg = "拼接日期有误,请重新输入"
  569. return
  570. }*/
  571. case utils.DATA_SOURCE_PREDICT_CALCULATE_NHCC: //拟合残差指标
  572. //指标校验
  573. if len(req.EdbInfoIdArr) != 2 {
  574. br.Msg = "选择的指标异常,请重新选择"
  575. return
  576. }
  577. fromEdbInfoId = req.EdbInfoIdArr[0].EdbInfoId
  578. //校验时间格式
  579. //数据格式:2022-11-01,2022-11-10
  580. timeList := strings.Split(req.Formula, ",")
  581. if len(timeList) != 2 {
  582. br.Msg = "选择时间有误,请重新输入"
  583. return
  584. }
  585. startDate, err := time.ParseInLocation(utils.FormatDate, timeList[0], time.Local)
  586. if err != nil {
  587. br.Msg = "开始日期有误,请重新输入"
  588. return
  589. }
  590. endDate, err := time.ParseInLocation(utils.FormatDate, timeList[1], time.Local)
  591. if err != nil {
  592. br.Msg = "结束日期有误,请重新输入"
  593. return
  594. }
  595. if utils.GetTimeSubDay(startDate, endDate) < 2 {
  596. br.Msg = "日期间隔不得少于两天"
  597. return
  598. }
  599. nhccDate.StartDate = startDate
  600. nhccDate.EndDate = endDate
  601. case utils.DATA_SOURCE_CALCULATE_ZSXY: // 指数修匀
  602. if req.Formula == "" {
  603. br.Msg = "请填写alpha值"
  604. return
  605. }
  606. a, e := strconv.ParseFloat(req.Formula, 64)
  607. if e != nil {
  608. br.Msg = "alpha值输入错误, 请重新输入"
  609. return
  610. }
  611. if a <= 0 || a >= 1 {
  612. br.Msg = "alpha值输入错误, 请重新输入"
  613. return
  614. }
  615. }
  616. if err != nil {
  617. br.Msg = "获取指标信息失败"
  618. br.ErrMsg = "获取指标信息失败:Err:" + err.Error()
  619. return
  620. }
  621. // 来源预测指标信息
  622. var fromEdbInfo *models.EdbInfo
  623. if fromEdbInfoId > 0 {
  624. fromEdbInfo, err = models.GetEdbInfoById(fromEdbInfoId)
  625. if err != nil {
  626. br.Msg = "获取指标信息失败"
  627. br.ErrMsg = "获取指标信息失败:Err:" + err.Error()
  628. return
  629. }
  630. if fromEdbInfo.EdbInfoType != 1 {
  631. br.Msg = "来源指标不是预测指标"
  632. br.ErrMsg = "来源指标不是预测指标"
  633. return
  634. }
  635. }
  636. var baseEdbInfoModel models.BasePredictEdbInfoInterface
  637. saveParams := models.BatchSaveCalculateBatchParams{
  638. Req: req,
  639. FromEdbInfo: fromEdbInfo,
  640. EdbCode: edbCode,
  641. UniqueCode: uniqueCode,
  642. SysUserId: req.AdminId,
  643. SysUserRealName: req.AdminName,
  644. Lang: this.Lang,
  645. }
  646. if req.Source == utils.DATA_SOURCE_PREDICT_CALCULATE_TBZ {
  647. if req.EdbInfoId <= 0 {
  648. if req.Frequency != fromEdbInfo.Frequency {
  649. br.Msg = "当前频度和原指标频度不一致"
  650. return
  651. }
  652. if req.Unit != "无" {
  653. br.Msg = "单位只允许为无,禁止选择其他单位"
  654. return
  655. }
  656. }
  657. }
  658. if req.Source == utils.DATA_SOURCE_PREDICT_CALCULATE_TCZ {
  659. if req.EdbInfoId <= 0 {
  660. if req.Frequency != fromEdbInfo.Frequency {
  661. br.Msg = "当前频度和原指标频度不一致"
  662. return
  663. }
  664. if req.Unit != fromEdbInfo.Unit {
  665. br.Msg = "当前单位和原指标单位不一致"
  666. return
  667. }
  668. }
  669. sourName = "预测同差"
  670. edbInfo, latestDateStr, latestValue, err, errMsg = models.SavePredictCalculateTcz(req.EdbInfoId, req.ClassifyId, req.EdbName, req.Frequency, req.Unit, req.Formula, fromEdbInfo, edbCode, uniqueCode, adminId, adminName, this.Lang)
  671. } else if req.Source == utils.DATA_SOURCE_PREDICT_CALCULATE_NSZYDPJJS {
  672. sourName = "预测N数值移动平均计算"
  673. edbInfo, latestDateStr, latestValue, err, errMsg = models.SavePredictCalculateNszydpjjs(req.EdbInfoId, req.ClassifyId, req.EdbName, req.Frequency, req.Unit, req.Formula, fromEdbInfo, edbCode, uniqueCode, adminId, adminName, this.Lang)
  674. } else if req.Source == utils.DATA_SOURCE_PREDICT_CALCULATE_BP {
  675. sourName = "预测变频"
  676. edbInfo, latestDateStr, latestValue, err = models.SavePredictCalculateBp(&req, fromEdbInfo, edbCode, uniqueCode, adminId, adminName, this.Lang)
  677. } else if req.Source == utils.DATA_SOURCE_PREDICT_CALCULATE_HBZ {
  678. checkDataList, tmpErr := models.GetPredictEdbDataListAllByStartDate(fromEdbInfo, 0, "")
  679. if tmpErr != nil && tmpErr.Error() != utils.ErrNoRow() {
  680. br.Msg = "判断环比值是否可计算失败"
  681. br.ErrMsg = "判断环比值是否可计算失败,Err:" + tmpErr.Error()
  682. return
  683. }
  684. for _, v := range checkDataList {
  685. if v.Value <= 0 {
  686. br.Msg = "原始数据中存在0或负数,该指标不能进行环比运算"
  687. br.ErrMsg = "原始数据中出现0和负值时,提示该指标不能进行环比运算"
  688. return
  689. }
  690. }
  691. sourName = "预测环比值"
  692. edbInfo, latestDateStr, latestValue, err = models.SavePredictCalculateHbz(&req, fromEdbInfo, edbCode, uniqueCode, adminId, adminName, formulaInt, this.Lang)
  693. } else if req.Source == utils.DATA_SOURCE_PREDICT_CALCULATE_HCZ {
  694. sourName = "预测环差值"
  695. edbInfo, latestDateStr, latestValue, err = models.SavePredictCalculateHcz(&req, fromEdbInfo, edbCode, uniqueCode, adminId, adminName, formulaInt, this.Lang)
  696. } else if req.Source == utils.DATA_SOURCE_PREDICT_CALCULATE_LJZZY {
  697. sourName = "预测累计值转月值"
  698. if fromEdbInfo.Frequency != "月度" {
  699. br.Msg = "请选择月度指标"
  700. return
  701. }
  702. edbInfo, latestDateStr, latestValue, err = models.SavePredictCalculateLjzzy(&req, fromEdbInfo, edbCode, uniqueCode, adminId, adminName, this.Lang)
  703. } else if req.Source == utils.DATA_SOURCE_PREDICT_CALCULATE_TIME_SHIFT {
  704. sourName = "预测时间移位"
  705. edbInfo, latestDateStr, latestValue, err = models.SavePredictCalculateTimeShift(&req, fromEdbInfo, edbCode, uniqueCode, adminId, adminName, this.Lang)
  706. } else if req.Source == utils.DATA_SOURCE_PREDICT_CALCULATE_CJJX {
  707. sourName = "预测超季节性"
  708. edbInfo, latestDateStr, latestValue, err = models.SavePredictCalculateCjjx(&req, fromEdbInfo, edbCode, uniqueCode, adminId, adminName, formulaInt, this.Lang)
  709. } else if req.Source == utils.DATA_SOURCE_PREDICT_CALCULATE_NHCC {
  710. sourName = "预测拟合残差"
  711. secondEdbInfoReq := req.EdbInfoIdArr[1]
  712. secondEdbInfo, tmpErr := models.GetEdbInfoById(secondEdbInfoReq.EdbInfoId)
  713. if tmpErr != nil {
  714. br.Msg = "获取因变量的指标信息失败"
  715. br.ErrMsg = "获取因变量的指标信息失败:Err:" + tmpErr.Error()
  716. return
  717. }
  718. if fromEdbInfo.EdbInfoId == secondEdbInfo.EdbInfoId {
  719. br.Msg = "两个指标不允许为同一个"
  720. br.ErrMsg = "两个指标不允许为同一个"
  721. return
  722. }
  723. edbInfo, latestDateStr, latestValue, err = models.SavePredictCalculateNhcc(&req, fromEdbInfo, secondEdbInfo, edbCode, uniqueCode, nhccDate, adminId, adminName, this.Lang)
  724. } else if req.Source == utils.DATA_SOURCE_PREDICT_CALCULATE_JP {
  725. sourName = utils.DATA_SOURCE_NAME_PREDICT_CALCULATE_JP
  726. edbInfo, latestDateStr, latestValue, err, errMsg = models.SavePredictCalculateJp(req.EdbInfoId, req.ClassifyId, req.EdbName, req.Frequency, req.Unit, req.Formula, fromEdbInfo, edbCode, uniqueCode, adminId, adminName, this.Lang)
  727. } else if req.Source == utils.DATA_SOURCE_PREDICT_CALCULATE_NH {
  728. sourName = utils.DATA_SOURCE_NAME_PREDICT_CALCULATE_NH
  729. edbInfo, latestDateStr, latestValue, err, errMsg = models.SavePredictCalculateNh(req.EdbInfoId, req.ClassifyId, req.EdbName, req.Frequency, req.Unit, req.Formula, fromEdbInfo, edbCode, uniqueCode, adminId, adminName, this.Lang)
  730. } else if req.Source == utils.DATA_SOURCE_PREDICT_CALCULATE_KSZS {
  731. sourName = utils.DATA_SOURCE_NAME_PREDICT_CALCULATE_KSZS
  732. edbInfo, latestDateStr, latestValue, err, errMsg = models.SavePredictCalculateKszs(req.EdbInfoId, req.ClassifyId, req.EdbName, req.Frequency, req.Unit, req.Formula, req.EdbInfoIdArr, edbCode, uniqueCode, adminId, adminName, this.Lang)
  733. } else {
  734. // 获取通用的数据源处理服务
  735. baseEdbInfoModel = models.GetBasePredictEdbInfoModel(req.Source)
  736. // 没有找到的话,那么就直接返回报错吧
  737. if baseEdbInfoModel == nil {
  738. br.Msg = "无效计算方式"
  739. br.ErrMsg = "无效计算方式,source:" + strconv.Itoa(req.Source)
  740. return
  741. }
  742. sourName = baseEdbInfoModel.GetSourceName()
  743. if req.EdbInfoId <= 0 {
  744. edbInfo, latestDateStr, latestValue, err, errMsg = baseEdbInfoModel.Add(saveParams)
  745. } else {
  746. edbInfo, err = models.GetEdbInfoById(req.EdbInfoId)
  747. if err != nil {
  748. if err.Error() == utils.ErrNoRow() {
  749. br.Msg = "指标已被删除,请刷新页面"
  750. br.ErrMsg = "指标已被删除,请刷新页面:Err:" + err.Error()
  751. return
  752. }
  753. br.Msg = "获取指标信息失败"
  754. br.ErrMsg = "获取指标信息失败:Err:" + err.Error()
  755. return
  756. }
  757. saveParams.EdbInfo = edbInfo
  758. latestDateStr, latestValue, err, errMsg = baseEdbInfoModel.Edit(saveParams)
  759. }
  760. }
  761. if err != nil {
  762. br.Msg = "生成" + sourName + "失败"
  763. if errMsg != `` {
  764. br.Msg = errMsg
  765. }
  766. br.Msg = "生成" + sourName + "失败 Err:" + err.Error()
  767. return
  768. }
  769. if edbInfo == nil {
  770. br.Msg = "生成" + sourName + "失败"
  771. br.ErrMsg = "生成" + sourName + "失败,edbInfo is nil"
  772. return
  773. }
  774. //处理同名指标
  775. {
  776. edbNameList, err := models.GetEdbInfoByName(req.EdbName)
  777. if err != nil {
  778. br.Msg = "保存失败"
  779. br.ErrMsg = "获取指标信息失败,Err:" + err.Error()
  780. return
  781. }
  782. if len(edbNameList) >= 2 {
  783. for _, v := range edbNameList {
  784. edbName := v.EdbName + "(" + v.SourceName + ")"
  785. err = models.ModifyEdbInfoNameSource(edbName, v.EdbInfoId)
  786. if err != nil {
  787. br.Msg = "保存失败"
  788. br.ErrMsg = "修改指标名称失败,Err:" + err.Error()
  789. return
  790. }
  791. }
  792. }
  793. }
  794. // 更新指标最大最小值
  795. err, errMsg = models.UnifiedModifyPredictEdbInfoMaxAndMinInfo(edbInfo, latestDateStr, latestValue)
  796. if err != nil {
  797. br.Msg = errMsg
  798. br.ErrMsg = err.Error()
  799. return
  800. }
  801. resp := models.AddEdbInfoResp{
  802. EdbInfoId: edbInfo.EdbInfoId,
  803. UniqueCode: uniqueCode,
  804. }
  805. br.Ret = 200
  806. br.Success = true
  807. br.Msg = "保存成功"
  808. br.Data = resp
  809. br.IsAddLog = true
  810. }
  811. // Refresh
  812. // @Title 刷新计算指标接口
  813. // @Description 刷新计算指标接口
  814. // @Success 200 {object} models.RefreshEdbInfoReq
  815. // @router /refresh [post]
  816. func (this *PredictCalculateController) Refresh() {
  817. br := new(models.BaseResponse).Init()
  818. var cacheKey string
  819. defer func() {
  820. this.Data["json"] = br
  821. this.ServeJSON()
  822. }()
  823. var req models.RefreshEdbInfoReq
  824. err := json.Unmarshal(this.Ctx.Input.RequestBody, &req)
  825. if err != nil {
  826. br.Msg = "参数解析异常!"
  827. br.ErrMsg = "参数解析失败,Err:" + err.Error()
  828. return
  829. }
  830. if req.EdbCode == "" {
  831. br.Msg = "请输入指标编码!"
  832. br.ErrMsg = "请输入指标编码,指标编码为空"
  833. return
  834. }
  835. if req.EdbInfoId <= 0 {
  836. br.Msg = "请输入指标ID!"
  837. br.ErrMsg = "请输入指标ID"
  838. return
  839. }
  840. edbInfo, err := models.GetEdbInfoById(req.EdbInfoId)
  841. if err != nil {
  842. br.Msg = "指标不存在!"
  843. br.ErrMsg = "指标不存在"
  844. return
  845. }
  846. cacheKey = utils.CACHE_EDB_DATA_REFRESH + strconv.Itoa(edbInfo.Source) + "_" + req.EdbCode
  847. if utils.Rc.IsExist(cacheKey) {
  848. br.Ret = 501
  849. br.Success = true
  850. br.Msg = "系统处理中,请稍后重试"
  851. br.IsSendEmail = false
  852. return
  853. }
  854. utils.Rc.SetNX(cacheKey, 1, 1*time.Minute)
  855. defer func() {
  856. _ = utils.Rc.Delete(cacheKey)
  857. }()
  858. startDate := req.StartDate
  859. var errMsg string
  860. endDate := time.Now().Format(utils.FormatDate)
  861. edbInfoId := edbInfo.EdbInfoId
  862. source := edbInfo.Source
  863. var latestDateStr string // 最近实际数据的日期
  864. var latestValue float64 // 最近实际数据的值
  865. var baseEdbInfoModel models.BasePredictEdbInfoInterface
  866. refreshParams := models.RefreshParams{
  867. EdbInfo: edbInfo,
  868. }
  869. switch source {
  870. case utils.DATA_SOURCE_PREDICT_CALCULATE_TBZ: //刷新同比值
  871. calculateTbz, err := models.GetEdbInfoCalculateMappingDetail(edbInfoId)
  872. if err != nil {
  873. errMsg = "GetEdbInfoCalculateTbzDetail Err:" + err.Error()
  874. break
  875. }
  876. fromEdbInfo, err := models.GetEdbInfoById(calculateTbz.FromEdbInfoId)
  877. if err != nil {
  878. errMsg = "GetEdbInfoById Err:" + err.Error()
  879. break
  880. }
  881. refreshParams.FromEdbInfo = fromEdbInfo
  882. refreshParams.StartDate = edbInfo.StartDate
  883. }
  884. switch source {
  885. case utils.DATA_SOURCE_PREDICT_CALCULATE:
  886. //startDate = edbInfo.StartDate
  887. //sTime, err := time.ParseInLocation(utils.FormatDate, edbInfo.EndDate, time.Local)
  888. //if err != nil {
  889. // return
  890. //}
  891. //startDate = sTime.Format(utils.FormatDate)
  892. startDate = ""
  893. var edbInfoIdBytes []string
  894. calculateMap, err := models.GetEdbInfoCalculateDetailList(edbInfo.EdbInfoId)
  895. if err != nil {
  896. errMsg = "GetEdbInfoCalculateDetail Err:" + err.Error()
  897. break
  898. }
  899. var formulaStr string
  900. edbInfoList := make([]*models.EdbInfo, 0)
  901. for _, v := range calculateMap {
  902. formulaStr += v.FromTag + ","
  903. edbInfoIdBytes = append(edbInfoIdBytes, v.FromTag)
  904. edbInfo, _ := models.GetEdbInfoById(v.FromEdbInfoId)
  905. edbInfoList = append(edbInfoList, edbInfo)
  906. }
  907. latestDateStr, latestValue, err = models.RefreshAllPredictCalculate(edbInfoList, edbInfo.EdbInfoId, source, edbInfo.SubSource, edbInfo.EdbCode, edbInfo.CalculateFormula, startDate, edbInfoIdBytes, edbInfo.EmptyType, edbInfo.MaxEmptyType)
  908. if err != nil && err.Error() != utils.ErrNoRow() {
  909. errMsg = "RefreshCalculate Err:" + err.Error()
  910. break
  911. }
  912. case utils.DATA_SOURCE_PREDICT_CALCULATE_TCZ: //同差值
  913. calculateTcz, err := models.GetEdbInfoCalculateMappingDetail(edbInfoId)
  914. if err != nil {
  915. errMsg = "GetEdbInfoCalculateTczDetail Err:" + err.Error()
  916. break
  917. }
  918. fromEdbInfo, err := models.GetEdbInfoById(calculateTcz.FromEdbInfoId)
  919. if err != nil {
  920. errMsg = "GetEdbInfoById Err:" + err.Error()
  921. break
  922. }
  923. startDate = edbInfo.StartDate
  924. latestDateStr, latestValue, err = models.RefreshAllPredictCalculateTcz(edbInfoId, source, edbInfo.SubSource, fromEdbInfo, calculateTcz.EdbCode, startDate)
  925. if err != nil && err.Error() != utils.ErrNoRow() {
  926. errMsg = "RefreshCalculateTcz Err:" + err.Error()
  927. break
  928. }
  929. case utils.DATA_SOURCE_PREDICT_CALCULATE_NSZYDPJJS: //N数值移动平均计算
  930. calculateInfo, err := models.GetEdbInfoCalculateMappingDetail(edbInfoId)
  931. if err != nil {
  932. errMsg = "GetEdbInfoCalculateTczDetail Err:" + err.Error()
  933. break
  934. }
  935. fromEdbInfo, err := models.GetEdbInfoById(calculateInfo.FromEdbInfoId)
  936. if err != nil {
  937. errMsg = "GetEdbInfoById Err:" + err.Error()
  938. break
  939. }
  940. var formulaInt int
  941. formulaInt, _ = strconv.Atoi(calculateInfo.CalculateFormula)
  942. if formulaInt <= 0 {
  943. errMsg = "N值输入错误,请重新输入"
  944. break
  945. }
  946. startDate = edbInfo.StartDate
  947. latestDateStr, latestValue, err = models.RefreshAllPredictCalculateNszydpjjs(edbInfoId, source, edbInfo.SubSource, formulaInt, fromEdbInfo, calculateInfo.EdbCode, startDate)
  948. if err != nil && err.Error() != utils.ErrNoRow() {
  949. errMsg = "RefreshAllPredictCalculateNszydpjjs Err:" + err.Error()
  950. break
  951. }
  952. case utils.DATA_SOURCE_PREDICT_CALCULATE_BP: //刷新变频
  953. calculateTbz, err := models.GetEdbInfoCalculateMappingDetail(edbInfoId)
  954. if err != nil {
  955. errMsg = "GetEdbInfoCalculateTbzDetail Err:" + err.Error()
  956. break
  957. }
  958. fromEdbInfo, err := models.GetEdbInfoById(calculateTbz.FromEdbInfoId)
  959. if err != nil {
  960. errMsg = "GetEdbInfoById Err:" + err.Error()
  961. break
  962. }
  963. endDate = time.Now().Format(utils.FormatDate)
  964. latestDateStr, latestValue, err = models.RefreshAllPredictCalculateBp(edbInfoId, source, edbInfo.SubSource, fromEdbInfo, calculateTbz.EdbCode, startDate, endDate)
  965. if err != nil && err.Error() != utils.ErrNoRow() {
  966. errMsg = "RefreshAllPredictCalculateBp Err:" + err.Error()
  967. break
  968. }
  969. case utils.DATA_SOURCE_PREDICT_CALCULATE_HBZ: //刷新环比值
  970. calculateTbz, err := models.GetEdbInfoCalculateMappingDetail(edbInfoId)
  971. if err != nil {
  972. errMsg = "GetEdbInfoCalculateHbzDetail Err:" + err.Error()
  973. break
  974. }
  975. fromEdbInfo, err := models.GetEdbInfoById(calculateTbz.FromEdbInfoId)
  976. if err != nil {
  977. errMsg = "GetEdbInfoById Err:" + err.Error()
  978. break
  979. }
  980. startDate = `` //只要填写日期,就会出现问题,还是把日期给去掉吧
  981. endDate = time.Now().Format(utils.FormatDate)
  982. formulaInt, _ := strconv.Atoi(edbInfo.CalculateFormula)
  983. latestDateStr, latestValue, err = models.RefreshAllPredictCalculateHbz(edbInfoId, source, edbInfo.SubSource, fromEdbInfo, calculateTbz.EdbCode, startDate, endDate, formulaInt)
  984. if err != nil && err.Error() != utils.ErrNoRow() {
  985. errMsg = "RefreshAllPredictCalculateHbz Err:" + err.Error()
  986. break
  987. }
  988. case utils.DATA_SOURCE_PREDICT_CALCULATE_HCZ: //刷新环差值
  989. calculateTbz, err := models.GetEdbInfoCalculateMappingDetail(edbInfoId)
  990. if err != nil {
  991. errMsg = "GetEdbInfoCalculateHczDetail Err:" + err.Error()
  992. break
  993. }
  994. fromEdbInfo, err := models.GetEdbInfoById(calculateTbz.FromEdbInfoId)
  995. if err != nil {
  996. errMsg = "GetEdbInfoById Err:" + err.Error()
  997. break
  998. }
  999. startDate = `` //只要填写日期,就会出现问题,还是把日期给去掉吧
  1000. endDate = time.Now().Format(utils.FormatDate)
  1001. formulaInt, _ := strconv.Atoi(edbInfo.CalculateFormula)
  1002. latestDateStr, latestValue, err = models.RefreshAllPredictCalculateHcz(edbInfoId, source, edbInfo.SubSource, fromEdbInfo, calculateTbz.EdbCode, startDate, endDate, formulaInt)
  1003. if err != nil && err.Error() != utils.ErrNoRow() {
  1004. errMsg = "RefreshAllPredictCalculateHcz Err:" + err.Error()
  1005. break
  1006. }
  1007. case utils.DATA_SOURCE_PREDICT_CALCULATE_LJZZY: //刷新累计值转月值
  1008. calculateLjzzy, err := models.GetEdbInfoCalculateMappingDetail(edbInfoId)
  1009. if err != nil {
  1010. errMsg = "GetEdbInfoCalculateLjzzyDetail Err:" + err.Error()
  1011. break
  1012. }
  1013. fromEdbInfo, err := models.GetEdbInfoById(calculateLjzzy.FromEdbInfoId)
  1014. if err != nil {
  1015. errMsg = "GetEdbInfoById Err:" + err.Error()
  1016. break
  1017. }
  1018. endDate = `` //只要填写日期,就会出现问题,还是把日期给去掉吧
  1019. startDate = `` //只要填写日期,就会出现问题,还是把日期给去掉吧
  1020. latestDateStr, latestValue, err = models.RefreshAllPredictCalculateLjzzy(edbInfoId, source, edbInfo.SubSource, fromEdbInfo, calculateLjzzy.EdbCode, startDate, endDate)
  1021. if err != nil && err.Error() != utils.ErrNoRow() {
  1022. errMsg = "RefreshAllPredictCalculateLjzzy Err:" + err.Error()
  1023. break
  1024. }
  1025. case utils.DATA_SOURCE_PREDICT_CALCULATE_TIME_SHIFT:
  1026. calculate, err := models.GetEdbInfoCalculateMappingDetail(edbInfoId)
  1027. if err != nil {
  1028. errMsg = "GetEdbInfoCalculateTbzDetail Err:" + err.Error()
  1029. break
  1030. }
  1031. fromEdbInfo, err := models.GetEdbInfoById(calculate.FromEdbInfoId)
  1032. if err != nil {
  1033. errMsg = "GetEdbInfoById Err:" + err.Error()
  1034. break
  1035. }
  1036. //startDate = edbInfo.StartDate
  1037. startDate = `` //只要填写日期,就会出现问题,还是把日期给去掉吧
  1038. endDate = time.Now().Format(utils.FormatDate)
  1039. formulaInt, _ := strconv.Atoi(calculate.CalculateFormula)
  1040. latestDateStr, latestValue, err = models.RefreshAllPredictCalculateTimeShift(edbInfoId, source, edbInfo.SubSource, formulaInt, calculate.MoveType, fromEdbInfo, calculate.EdbCode, startDate, endDate, calculate.MoveFrequency)
  1041. if err != nil && err.Error() != utils.ErrNoRow() {
  1042. errMsg = "RefreshAllCalculateTimeShift Err:" + err.Error()
  1043. }
  1044. case utils.DATA_SOURCE_PREDICT_CALCULATE_LJZTBPJ: //刷新累计值同比拼接
  1045. latestDateStr, latestValue, err = models.RefreshAllPredictCalculateLjztbpj(edbInfo)
  1046. if err != nil && err.Error() != utils.ErrNoRow() {
  1047. errMsg = "RefreshAllPredictCalculateLjztbpj Err:" + err.Error()
  1048. break
  1049. }
  1050. case utils.DATA_SOURCE_PREDICT_CALCULATE_ZJPJ: //刷新直接拼接
  1051. latestDateStr, latestValue, err = models.RefreshAllPredictCalculateZjpj(edbInfo)
  1052. if err != nil && err.Error() != utils.ErrNoRow() {
  1053. errMsg = "RefreshAllPredictCalculateZjpj Err:" + err.Error()
  1054. break
  1055. }
  1056. case utils.DATA_SOURCE_PREDICT_CALCULATE_CJJX: //超季节性
  1057. calculateCjjx, err := models.GetEdbInfoCalculateMappingDetail(edbInfoId)
  1058. if err != nil {
  1059. errMsg = "GetEdbInfoCalculateNszydpjjsDetail Err:" + err.Error()
  1060. break
  1061. }
  1062. fromEdbInfo, err := models.GetEdbInfoById(calculateCjjx.FromEdbInfoId)
  1063. if err != nil {
  1064. errMsg = "GetEdbInfoById Err:" + err.Error()
  1065. break
  1066. }
  1067. formulaInt, _ := strconv.Atoi(edbInfo.CalculateFormula)
  1068. startDate = `` //只要填写日期,就会出现问题,还是把日期给去掉吧
  1069. latestDateStr, latestValue, err = models.RefreshAllPredictCalculateCjjx(edbInfoId, edbInfo.Source, edbInfo.SubSource, fromEdbInfo, calculateCjjx.EdbCode, startDate, "", edbInfo.Calendar, formulaInt)
  1070. if err != nil && err.Error() != utils.ErrNoRow() {
  1071. errMsg = "RefreshAllPredictCalculateCjjx Err:" + err.Error()
  1072. break
  1073. }
  1074. case utils.DATA_SOURCE_PREDICT_CALCULATE_NHCC: //nhcc
  1075. latestDateStr, latestValue, err = models.RefreshAllPredictCalculateNhcc(edbInfo)
  1076. if err != nil && err.Error() != utils.ErrNoRow() {
  1077. errMsg = "RefreshAllPredictCalculateNhcc Err:" + err.Error()
  1078. break
  1079. }
  1080. case utils.DATA_SOURCE_PREDICT_CALCULATE_JP: //降频
  1081. calculateInfo, err := models.GetEdbInfoCalculateMappingDetail(edbInfoId)
  1082. if err != nil {
  1083. errMsg = "GetEdbInfoCalculateTczDetail Err:" + err.Error()
  1084. break
  1085. }
  1086. fromEdbInfo, err := models.GetEdbInfoById(calculateInfo.FromEdbInfoId)
  1087. if err != nil {
  1088. errMsg = "GetEdbInfoById Err:" + err.Error()
  1089. break
  1090. }
  1091. latestDateStr, latestValue, err = models.RefreshAllPredictCalculateJp(edbInfoId, source, edbInfo.SubSource, fromEdbInfo, calculateInfo.EdbCode, edbInfo.Frequency, edbInfo.CalculateFormula)
  1092. if err != nil && err.Error() != utils.ErrNoRow() {
  1093. errMsg = "RefreshAllPredictCalculateJp Err:" + err.Error()
  1094. break
  1095. }
  1096. case utils.DATA_SOURCE_PREDICT_CALCULATE_NH: //年化
  1097. calculateInfo, err := models.GetEdbInfoCalculateMappingDetail(edbInfoId)
  1098. if err != nil {
  1099. errMsg = "GetEdbInfoCalculateTczDetail Err:" + err.Error()
  1100. break
  1101. }
  1102. fromEdbInfo, err := models.GetEdbInfoById(calculateInfo.FromEdbInfoId)
  1103. if err != nil {
  1104. errMsg = "GetEdbInfoById Err:" + err.Error()
  1105. break
  1106. }
  1107. latestDateStr, latestValue, err = models.RefreshAllPredictCalculateNh(edbInfoId, source, edbInfo.SubSource, fromEdbInfo, calculateInfo.EdbCode, edbInfo.Frequency, edbInfo.CalculateFormula)
  1108. if err != nil && err.Error() != utils.ErrNoRow() {
  1109. errMsg = "RefreshAllPredictCalculateNh Err:" + err.Error()
  1110. break
  1111. }
  1112. case utils.DATA_SOURCE_PREDICT_CALCULATE_KSZS: //扩散指数
  1113. latestDateStr, latestValue, err = models.RefreshAllPredictCalculateKszs(edbInfo)
  1114. if err != nil && err.Error() != utils.ErrNoRow() {
  1115. errMsg = "RefreshAllPredictCalculateKszs Err:" + err.Error()
  1116. break
  1117. }
  1118. default:
  1119. // 获取通用的数据源处理服务
  1120. baseEdbInfoModel = models.GetBasePredictEdbInfoModel(source)
  1121. // 没有找到的话,那么就直接返回报错吧
  1122. if baseEdbInfoModel == nil {
  1123. br.Msg = "来源异常,请联系相关开发!"
  1124. br.ErrMsg = "来源异常,请联系相关开发"
  1125. return
  1126. }
  1127. latestDateStr, latestValue, err, errMsg = baseEdbInfoModel.Refresh(refreshParams)
  1128. }
  1129. if errMsg != `` {
  1130. br.Msg = "刷新指标失败!"
  1131. br.ErrMsg = "刷新指标失败,err:" + errMsg
  1132. return
  1133. }
  1134. // 更新指标最大最小值
  1135. err, errMsg = models.UnifiedModifyPredictEdbInfoMaxAndMinInfo(edbInfo, latestDateStr, latestValue)
  1136. if err != nil {
  1137. br.Msg = errMsg
  1138. br.ErrMsg = err.Error()
  1139. return
  1140. }
  1141. // 更新ES
  1142. go logic.UpdateEs(edbInfo.EdbInfoId)
  1143. br.Ret = 200
  1144. br.Success = true
  1145. br.Msg = "获取成功"
  1146. }
  1147. // CalculateComputeCorrelation
  1148. // @Title 拟合残差计算相关性接口
  1149. // @Description 拟合残差计算相关性接口
  1150. // @Param request body models.EdbInfoCalculateBatchSaveReq true "type json string"
  1151. // @Success Ret=200 返回指标id
  1152. // @router /compute_correlation [post]
  1153. func (this *PredictCalculateController) CalculateComputeCorrelation() {
  1154. br := new(models.BaseResponse).Init()
  1155. defer func() {
  1156. this.Data["json"] = br
  1157. this.ServeJSON()
  1158. }()
  1159. var req models.EdbInfoCalculateBatchSaveReq
  1160. err := json.Unmarshal(this.Ctx.Input.RequestBody, &req)
  1161. if err != nil {
  1162. br.Msg = "参数解析异常!"
  1163. br.ErrMsg = "参数解析失败,Err:" + err.Error()
  1164. return
  1165. }
  1166. if len(req.EdbInfoIdArr) != 2 {
  1167. br.Msg = "选择的指标异常,请重新选择"
  1168. return
  1169. }
  1170. //校验时间格式
  1171. //数据格式:2022-11-01,2022-11-10
  1172. timeList := strings.Split(req.Formula, ",")
  1173. if len(timeList) != 2 {
  1174. br.Msg = "选择时间有误,请重新输入"
  1175. return
  1176. }
  1177. startDate, err := time.ParseInLocation(utils.FormatDate, timeList[0], time.Local)
  1178. if err != nil {
  1179. br.Msg = "开始日期有误,请重新输入"
  1180. return
  1181. }
  1182. endDate, err := time.ParseInLocation(utils.FormatDate, timeList[1], time.Local)
  1183. if err != nil {
  1184. br.Msg = "结束日期有误,请重新输入"
  1185. return
  1186. }
  1187. if utils.GetTimeSubDay(startDate, endDate) < 2 {
  1188. br.Msg = "日期间隔不得少于两天"
  1189. return
  1190. }
  1191. var nhccDate models.NhccDate // 拟合残差的日期
  1192. nhccDate.StartDate = startDate
  1193. nhccDate.EndDate = endDate
  1194. // 来源预测指标信息
  1195. fromEdbInfoId := req.EdbInfoIdArr[0].EdbInfoId
  1196. if fromEdbInfoId <= 0 {
  1197. br.Msg = "请选择指标"
  1198. return
  1199. }
  1200. // 来源指标(自变量指标)
  1201. fromEdbInfo, err := models.GetEdbInfoById(fromEdbInfoId)
  1202. if err != nil {
  1203. br.Msg = "获取指标信息失败"
  1204. br.ErrMsg = "获取指标信息失败:Err:" + err.Error()
  1205. return
  1206. }
  1207. if fromEdbInfo.EdbInfoType != 1 {
  1208. br.Msg = "来源指标不是预测指标"
  1209. br.ErrMsg = "来源指标不是预测指标"
  1210. return
  1211. }
  1212. // 因变量指标
  1213. secondEdbInfoReq := req.EdbInfoIdArr[1]
  1214. secondEdbInfo, tmpErr := models.GetEdbInfoById(secondEdbInfoReq.EdbInfoId)
  1215. if tmpErr != nil {
  1216. br.Msg = "获取因变量的指标信息失败"
  1217. br.ErrMsg = "获取因变量的指标信息失败:Err:" + tmpErr.Error()
  1218. return
  1219. }
  1220. if fromEdbInfo.EdbInfoId == secondEdbInfo.EdbInfoId {
  1221. br.Msg = "两个指标不允许为同一个"
  1222. br.ErrMsg = "两个指标不允许为同一个"
  1223. return
  1224. }
  1225. rVal, err := models.CalculatePredictComputeCorrelation(&req, fromEdbInfo, secondEdbInfo, nhccDate)
  1226. if err != nil {
  1227. br.Msg = "计算失败"
  1228. br.ErrMsg = "计算失败,ERR:" + err.Error()
  1229. return
  1230. }
  1231. br.Ret = 200
  1232. br.Success = true
  1233. br.Msg = "计算成功"
  1234. br.Data = rVal
  1235. br.IsAddLog = true
  1236. }