base_from_calculate.go 66 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869870871872873874875876877878879880881882883884885886887888889890891892893894895896897898899900901902903904905906907908909910911912913914915916917918919920921922923924925926927928929930931932933934935936937938939940941942943944945946947948949950951952953954955956957958959960961962963964965966967968969970971972973974975976977978979980981982983984985986987988989990991992993994995996997998999100010011002100310041005100610071008100910101011101210131014101510161017101810191020102110221023102410251026102710281029103010311032103310341035103610371038103910401041104210431044104510461047104810491050105110521053105410551056105710581059106010611062106310641065106610671068106910701071107210731074107510761077107810791080108110821083108410851086108710881089109010911092109310941095109610971098109911001101110211031104110511061107110811091110111111121113111411151116111711181119112011211122112311241125112611271128112911301131113211331134113511361137113811391140114111421143114411451146114711481149115011511152115311541155115611571158115911601161116211631164116511661167116811691170117111721173117411751176117711781179118011811182118311841185118611871188118911901191119211931194119511961197119811991200120112021203120412051206120712081209121012111212121312141215121612171218121912201221122212231224122512261227122812291230123112321233123412351236123712381239124012411242124312441245124612471248124912501251125212531254125512561257125812591260126112621263126412651266126712681269127012711272127312741275127612771278127912801281128212831284128512861287128812891290129112921293129412951296129712981299130013011302130313041305130613071308130913101311131213131314131513161317131813191320132113221323132413251326132713281329133013311332133313341335133613371338133913401341134213431344134513461347134813491350135113521353135413551356135713581359136013611362136313641365136613671368136913701371137213731374137513761377137813791380138113821383138413851386138713881389139013911392139313941395139613971398139914001401140214031404140514061407140814091410141114121413141414151416141714181419142014211422142314241425142614271428142914301431143214331434143514361437143814391440144114421443144414451446144714481449145014511452145314541455145614571458145914601461146214631464146514661467146814691470147114721473147414751476147714781479148014811482148314841485148614871488148914901491149214931494149514961497149814991500150115021503150415051506150715081509151015111512151315141515151615171518151915201521152215231524152515261527152815291530153115321533153415351536153715381539154015411542154315441545154615471548154915501551155215531554155515561557155815591560156115621563156415651566156715681569157015711572157315741575157615771578157915801581158215831584158515861587158815891590159115921593159415951596159715981599160016011602160316041605160616071608160916101611161216131614161516161617161816191620162116221623162416251626162716281629163016311632163316341635163616371638163916401641164216431644164516461647164816491650165116521653165416551656165716581659166016611662166316641665166616671668166916701671167216731674167516761677167816791680168116821683168416851686168716881689169016911692169316941695169616971698169917001701170217031704170517061707170817091710171117121713171417151716171717181719172017211722172317241725172617271728172917301731173217331734173517361737173817391740174117421743174417451746174717481749175017511752175317541755175617571758175917601761176217631764176517661767176817691770177117721773177417751776177717781779178017811782178317841785178617871788178917901791179217931794179517961797179817991800180118021803180418051806180718081809181018111812181318141815181618171818181918201821182218231824182518261827182818291830183118321833183418351836183718381839184018411842184318441845184618471848184918501851185218531854185518561857185818591860186118621863186418651866186718681869187018711872187318741875187618771878187918801881188218831884188518861887188818891890189118921893189418951896189718981899190019011902190319041905190619071908190919101911191219131914191519161917191819191920192119221923192419251926192719281929193019311932193319341935193619371938193919401941194219431944194519461947194819491950195119521953195419551956195719581959196019611962196319641965196619671968196919701971197219731974197519761977197819791980198119821983198419851986198719881989199019911992199319941995199619971998199920002001200220032004200520062007200820092010201120122013201420152016201720182019202020212022202320242025202620272028202920302031203220332034203520362037203820392040204120422043204420452046204720482049205020512052205320542055205620572058205920602061206220632064206520662067206820692070207120722073207420752076207720782079208020812082208320842085208620872088208920902091209220932094209520962097209820992100210121022103210421052106210721082109211021112112211321142115211621172118211921202121212221232124212521262127212821292130213121322133213421352136213721382139214021412142214321442145214621472148214921502151215221532154215521562157215821592160216121622163216421652166216721682169217021712172217321742175217621772178217921802181218221832184218521862187218821892190219121922193219421952196219721982199220022012202220322042205220622072208220922102211221222132214221522162217221822192220222122222223222422252226222722282229223022312232223322342235223622372238223922402241224222432244224522462247224822492250225122522253225422552256225722582259
  1. package controllers
  2. import (
  3. "encoding/json"
  4. "errors"
  5. "eta_gn/eta_index_lib/logic"
  6. "eta_gn/eta_index_lib/models"
  7. "eta_gn/eta_index_lib/services"
  8. "eta_gn/eta_index_lib/utils"
  9. "fmt"
  10. "strconv"
  11. "strings"
  12. "sync"
  13. "time"
  14. )
  15. type CalculateController struct {
  16. BaseAuthController
  17. }
  18. // @router /add [post]
  19. func (this *CalculateController) Add() {
  20. br := new(models.BaseResponse).Init()
  21. defer func() {
  22. this.Data["json"] = br
  23. this.ServeJSON()
  24. }()
  25. var req models.EdbInfoCalculateSaveReq
  26. err := json.Unmarshal(this.Ctx.Input.RequestBody, &req)
  27. if err != nil {
  28. br.Msg = "参数解析异常!"
  29. br.ErrMsg = "参数解析失败,Err:" + err.Error()
  30. return
  31. }
  32. req.EdbName = strings.Trim(req.EdbName, " ")
  33. if req.EdbName == "" {
  34. br.Msg = "指标名称不能为空"
  35. return
  36. }
  37. if req.Frequency == "" {
  38. br.Msg = "频率不能为空"
  39. return
  40. }
  41. if req.Unit == "" {
  42. br.Msg = "单位不能为空"
  43. return
  44. }
  45. if req.ClassifyId <= 0 {
  46. br.Msg = "请选择分类"
  47. return
  48. }
  49. if len(req.EdbInfoIdArr) <= 0 {
  50. br.Msg = "请选择指标"
  51. return
  52. }
  53. if req.CalculateFormula == "" {
  54. br.Msg = "请填写指标"
  55. return
  56. }
  57. redisKey := fmt.Sprint("edb_lib:edb_info:calculate:add:", utils.DATA_SOURCE_CALCULATE, ":", req.EdbName)
  58. isExist := utils.Rc.IsExist(redisKey)
  59. if isExist {
  60. br.Msg = "指标正在处理,请勿重复提交"
  61. return
  62. } else {
  63. utils.Rc.SetNX(redisKey, 1, time.Second*300)
  64. defer func() {
  65. _ = utils.Rc.Delete(redisKey)
  66. }()
  67. }
  68. edbInfo, uniqueCode, err, errMsg := services.EdbCalculateAdd(req, this.Lang)
  69. if err != nil {
  70. br.Msg = err.Error()
  71. br.ErrMsg = errMsg
  72. return
  73. }
  74. {
  75. edbNameList, e := models.GetEdbInfoByName(req.EdbName)
  76. if e != nil {
  77. err = fmt.Errorf("保存失败")
  78. errMsg = "获取指标信息失败,Err:" + e.Error()
  79. return
  80. }
  81. if len(edbNameList) >= 2 {
  82. for _, v := range edbNameList {
  83. edbName := v.EdbName + "(" + v.SourceName + ")"
  84. err = models.ModifyEdbInfoNameSource(edbName, v.EdbInfoId)
  85. if err != nil {
  86. errMsg = "修改指标名称失败,Err:" + err.Error()
  87. err = fmt.Errorf("保存失败")
  88. return
  89. }
  90. }
  91. }
  92. }
  93. err, errMsg = models.UnifiedModifyEdbInfoMaxAndMinInfo(edbInfo)
  94. if err != nil {
  95. return
  96. }
  97. go services.DisableEdbInfoNoUpdate(edbInfo)
  98. resp := models.AddEdbInfoResp{
  99. EdbInfoId: edbInfo.EdbInfoId,
  100. UniqueCode: uniqueCode,
  101. }
  102. br.Ret = 200
  103. br.Success = true
  104. br.Msg = "保存成功"
  105. br.Data = resp
  106. br.IsAddLog = true
  107. }
  108. // @router /edit [post]
  109. func (this *CalculateController) Edit() {
  110. br := new(models.BaseResponse).Init()
  111. defer func() {
  112. this.Data["json"] = br
  113. this.ServeJSON()
  114. }()
  115. var req models.EdbInfoCalculateSaveReq
  116. err := json.Unmarshal(this.Ctx.Input.RequestBody, &req)
  117. if err != nil {
  118. br.Msg = "参数解析异常!"
  119. br.ErrMsg = "参数解析失败,Err:" + err.Error()
  120. return
  121. }
  122. if req.EdbInfoId <= 0 {
  123. br.Msg = "参数错误"
  124. br.ErrMsg = "指标ID:" + strconv.Itoa(req.EdbInfoId)
  125. return
  126. }
  127. req.EdbName = strings.Trim(req.EdbName, " ")
  128. if req.EdbName == "" {
  129. br.Msg = "指标名称不能为空"
  130. return
  131. }
  132. if req.Frequency == "" {
  133. br.Msg = "频率不能为空"
  134. return
  135. }
  136. if req.Unit == "" {
  137. br.Msg = "单位不能为空"
  138. return
  139. }
  140. if req.ClassifyId <= 0 {
  141. br.Msg = "请选择分类"
  142. return
  143. }
  144. if len(req.EdbInfoIdArr) <= 0 {
  145. br.Msg = "请选择指标"
  146. return
  147. }
  148. if req.CalculateFormula == "" {
  149. br.Msg = "请填写指标公式"
  150. return
  151. }
  152. calculateFormula := req.CalculateFormula
  153. calculateFormula = strings.Replace(calculateFormula, "(", "(", -1)
  154. calculateFormula = strings.Replace(calculateFormula, ")", ")", -1)
  155. calculateFormula = strings.Replace(calculateFormula, ",", ",", -1)
  156. calculateFormula = strings.Replace(calculateFormula, "。", ".", -1)
  157. calculateFormula = strings.Replace(calculateFormula, "%", "*0.01", -1)
  158. req.CalculateFormula = calculateFormula
  159. edbInfoMap := make(map[int]string)
  160. {
  161. upperCalculateFormulaStr := strings.ToUpper(req.CalculateFormula)
  162. newEdbInfoIdArr := make([]models.EdbInfoFromTag, 0)
  163. for _, tmpEdbInfo := range req.EdbInfoIdArr {
  164. _, ok := edbInfoMap[tmpEdbInfo.EdbInfoId]
  165. if ok {
  166. br.Msg = "选择指标失败,请勿选择重复指标!"
  167. return
  168. }
  169. edbInfoMap[tmpEdbInfo.EdbInfoId] = tmpEdbInfo.FromTag
  170. upperFromTag := strings.ToUpper(tmpEdbInfo.FromTag)
  171. if strings.Contains(upperCalculateFormulaStr, upperFromTag) {
  172. newEdbInfoIdArr = append(newEdbInfoIdArr, tmpEdbInfo)
  173. }
  174. }
  175. req.EdbInfoIdArr = newEdbInfoIdArr
  176. }
  177. existEdbName, err := logic.CheckExistByEdbNameAndEdbInfoId(utils.EDB_INFO_TYPE, req.EdbInfoId, req.EdbName, this.Lang)
  178. if err != nil {
  179. br.Msg = "判断指标名称是否存在失败"
  180. br.ErrMsg = "判断指标名称是否存在失败,Err:" + err.Error()
  181. return
  182. }
  183. if existEdbName {
  184. br.Msg = "指标名称已存在,请重新填写"
  185. br.ErrMsg = "指标名称已存在,请重新填写"
  186. br.IsSendEmail = false
  187. return
  188. }
  189. edbInfoDetail, err := models.GetEdbInfoById(req.EdbInfoId)
  190. if err != nil {
  191. br.Msg = "修改失败"
  192. br.Msg = "获取指标信息失败,GetEdbInfoById Err:" + err.Error()
  193. return
  194. }
  195. if edbInfoDetail == nil {
  196. br.Msg = "修改失败"
  197. br.Msg = "指标信息不存在,EdbInfoId:" + strconv.Itoa(req.EdbInfoId)
  198. return
  199. }
  200. oldEdbName := edbInfoDetail.EdbName
  201. oldFrequency := edbInfoDetail.Frequency
  202. oldUnit := edbInfoDetail.Unit
  203. var needCalculate bool
  204. if edbInfoDetail.CalculateFormula != req.CalculateFormula || edbInfoDetail.EmptyType != req.EmptyType || edbInfoDetail.MaxEmptyType != req.MaxEmptyType || edbInfoDetail.Extra != req.Extra {
  205. needCalculate = true
  206. }
  207. var formulaStr string
  208. var edbInfoIdBytes []string
  209. var edbInfoIdArr []string
  210. for _, v := range req.EdbInfoIdArr {
  211. formulaStr += v.FromTag + ","
  212. edbInfoIdBytes = append(edbInfoIdBytes, v.FromTag)
  213. edbInfoIdArr = append(edbInfoIdArr, strconv.Itoa(v.EdbInfoId))
  214. if v.EdbInfoId == req.EdbInfoId {
  215. br.Msg = "计算指标中包含此指标,不能修改"
  216. return
  217. }
  218. }
  219. if needCalculate == false {
  220. edbInfoIdStr := strings.Join(edbInfoIdArr, ",")
  221. fromEdbInfoId, err := models.GetCalculateEdbInfo(req.EdbInfoId)
  222. if err != nil {
  223. br.Msg = "修改失败"
  224. br.Msg = "获取数据失败,GetCalculateEdbInfo:" + err.Error()
  225. return
  226. }
  227. if edbInfoIdStr != fromEdbInfoId {
  228. needCalculate = true
  229. }
  230. }
  231. formulaSlice, err := utils.CheckFormulaJson(req.CalculateFormula)
  232. if err != nil {
  233. br.Msg = "公式格式错误,请重新填写"
  234. return
  235. }
  236. for _, formula := range formulaSlice {
  237. formulaMap, e := utils.CheckFormula(formula)
  238. if e != nil {
  239. br.Msg = "公式错误,请重新填写"
  240. return
  241. }
  242. for _, v := range formulaMap {
  243. if !strings.Contains(formulaStr, v) {
  244. br.Msg = "公式错误,请重新填写"
  245. return
  246. }
  247. }
  248. }
  249. switch this.Lang {
  250. case utils.EnLangVersion:
  251. req.EdbNameEn = req.EdbName
  252. req.UnitEn = req.Unit
  253. req.EdbName = edbInfoDetail.EdbName
  254. req.Unit = edbInfoDetail.Unit
  255. default:
  256. req.EdbNameEn = edbInfoDetail.EdbNameEn
  257. req.UnitEn = edbInfoDetail.UnitEn
  258. }
  259. err, errMsg := models.EditCalculateInfo(edbInfoDetail, req, formulaSlice, edbInfoIdBytes, needCalculate)
  260. if err != nil {
  261. br.Msg = "生成计算指标失败"
  262. if errMsg != `` {
  263. br.Msg = errMsg
  264. }
  265. br.Msg = "生成计算指标失败,AddEdbInfo Err:" + err.Error()
  266. return
  267. }
  268. err, errMsg = models.UnifiedModifyEdbInfoMaxAndMinInfo(edbInfoDetail)
  269. if err != nil {
  270. br.Msg = errMsg
  271. br.ErrMsg = err.Error()
  272. return
  273. }
  274. oldEdbInfo := new(models.EdbInfo)
  275. oldEdbInfo.EdbInfoId = edbInfoDetail.EdbInfoId
  276. oldEdbInfo.EdbName = oldEdbName
  277. oldEdbInfo.Frequency = oldFrequency
  278. oldEdbInfo.Unit = oldUnit
  279. newEdbInfoEditRecord := new(models.EdbInfoEditRecord)
  280. newEdbInfoEditRecord.EdbName = req.EdbName
  281. newEdbInfoEditRecord.Frequency = req.Frequency
  282. newEdbInfoEditRecord.Unit = req.Unit
  283. newEdbInfoEditRecord.OperateUserId = req.AdminId
  284. newEdbInfoEditRecord.OperateUserRealName = req.AdminName
  285. err = services.AddEditEdbInfoRcord(oldEdbInfo, newEdbInfoEditRecord)
  286. if err != nil {
  287. br.Msg = "记录基础信息变更日志失败"
  288. br.ErrMsg = err.Error()
  289. return
  290. }
  291. resp := models.AddEdbInfoResp{
  292. EdbInfoId: edbInfoDetail.EdbInfoId,
  293. UniqueCode: edbInfoDetail.UniqueCode,
  294. }
  295. go services.ResetEdbRelation(edbInfoDetail.EdbInfoId)
  296. br.Ret = 200
  297. br.Success = true
  298. br.Msg = "保存成功"
  299. br.Data = resp
  300. br.IsAddLog = true
  301. }
  302. // @router /batch/save [post]
  303. func (this *CalculateController) BatchSave() {
  304. br := new(models.BaseResponse).Init()
  305. defer func() {
  306. if br.ErrMsg == "" {
  307. br.IsSendEmail = false
  308. }
  309. this.Data["json"] = br
  310. this.ServeJSON()
  311. }()
  312. var req models.EdbInfoCalculateBatchSaveReq
  313. err := json.Unmarshal(this.Ctx.Input.RequestBody, &req)
  314. if err != nil {
  315. br.Msg = "参数解析异常!"
  316. br.ErrMsg = "参数解析失败,Err:" + err.Error()
  317. return
  318. }
  319. req.EdbName = strings.Trim(req.EdbName, " ")
  320. if req.EdbName == "" {
  321. br.Msg = "指标名称不能为空"
  322. return
  323. }
  324. if req.Frequency == "" {
  325. br.Msg = "频率不能为空"
  326. return
  327. }
  328. if req.Unit == "" {
  329. br.Msg = "单位不能为空"
  330. return
  331. }
  332. if req.ClassifyId <= 0 {
  333. br.Msg = "请选择分类"
  334. return
  335. }
  336. fromEdbInfoId := req.FromEdbInfoId
  337. var formulaInt int
  338. var nhccDate models.NhccDate // 拟合残差的日期
  339. switch req.Source {
  340. case utils.DATA_SOURCE_CALCULATE_NSZYDPJJS, utils.DATA_SOURCE_CALCULATE_HBZ, utils.DATA_SOURCE_CALCULATE_HCZ, utils.DATA_SOURCE_CALCULATE_TIME_SHIFT, utils.DATA_SOURCE_CALCULATE_CJJX:
  341. if req.Formula == "" {
  342. br.Msg = "请填写N值"
  343. return
  344. }
  345. formulaInt, _ = strconv.Atoi(req.Formula)
  346. if formulaInt <= 0 {
  347. br.Msg = "N值输入错误,请重新输入"
  348. return
  349. }
  350. case utils.DATA_SOURCE_CALCULATE_ZJPJ:
  351. _, err = time.ParseInLocation(utils.FormatDate, req.Formula, time.Local)
  352. if err != nil {
  353. br.Msg = "拼接日期有误,请重新输入"
  354. return
  355. }
  356. case utils.DATA_SOURCE_CALCULATE_NHCC: //拟合残差指标
  357. if len(req.EdbInfoIdArr) != 2 {
  358. br.Msg = "选择的指标异常,请重新选择"
  359. return
  360. }
  361. fromEdbInfoId = req.EdbInfoIdArr[0].EdbInfoId
  362. timeList := strings.Split(req.Formula, ",")
  363. if len(timeList) != 2 {
  364. br.Msg = "选择时间有误,请重新输入"
  365. return
  366. }
  367. startDate, err := time.ParseInLocation(utils.FormatDate, timeList[0], time.Local)
  368. if err != nil {
  369. br.Msg = "开始日期有误,请重新输入"
  370. return
  371. }
  372. endDate, err := time.ParseInLocation(utils.FormatDate, timeList[1], time.Local)
  373. if err != nil {
  374. br.Msg = "结束日期有误,请重新输入"
  375. return
  376. }
  377. if utils.GetTimeSubDay(startDate, endDate) < 2 {
  378. br.Msg = "日期间隔不得少于两天"
  379. return
  380. }
  381. nhccDate.StartDate = startDate
  382. nhccDate.EndDate = endDate
  383. case utils.DATA_SOURCE_CALCULATE_JP:
  384. if req.Formula != "期末值" && req.Formula != "平均值" {
  385. br.Msg = "数据取值类型错误:" + req.Formula
  386. return
  387. }
  388. case utils.DATA_SOURCE_CALCULATE_ZSXY: // 指数修匀
  389. if req.Formula == "" {
  390. br.Msg = "请填写alpha值"
  391. return
  392. }
  393. a, e := strconv.ParseFloat(req.Formula, 64)
  394. if e != nil {
  395. br.Msg = "alpha值输入错误, 请重新输入"
  396. return
  397. }
  398. if a <= 0 || a >= 1 {
  399. br.Msg = "alpha值输入错误, 请重新输入"
  400. return
  401. }
  402. }
  403. notNeedFromEdbSourceList := []int{utils.DATA_SOURCE_CALCULATE_KSZS, utils.DATA_SOURCE_CALCULATE_CORRELATION, utils.DATA_SOURCE_CALCULATE_ZDYFX} // 不需要传入来源指标id的 指标类型
  404. if fromEdbInfoId <= 0 && !utils.InArrayByInt(notNeedFromEdbSourceList, req.Source) {
  405. br.Msg = "请选择指标"
  406. return
  407. }
  408. redisKey := fmt.Sprint("edb_lib:edb_info:calculate:batch:save:", req.Source, ":", req.EdbName)
  409. isExist := utils.Rc.IsExist(redisKey)
  410. if isExist {
  411. br.Msg = "指标正在处理,请勿重复提交"
  412. return
  413. } else {
  414. utils.Rc.SetNX(redisKey, 1, time.Second*300)
  415. defer func() {
  416. _ = utils.Rc.Delete(redisKey)
  417. }()
  418. }
  419. existEdbName, err := logic.CheckExistByEdbNameAndEdbInfoId(utils.EDB_INFO_TYPE, req.EdbInfoId, req.EdbName, this.Lang)
  420. if err != nil {
  421. br.Msg = "判断指标名称是否存在失败"
  422. br.ErrMsg = "判断指标名称是否存在失败,Err:" + err.Error()
  423. return
  424. }
  425. if existEdbName {
  426. br.Msg = "指标名称已存在,请重新填写"
  427. br.ErrMsg = "指标名称已存在,请重新填写"
  428. br.IsSendEmail = false
  429. return
  430. }
  431. var fromEdbInfo *models.EdbInfo
  432. if fromEdbInfoId > 0 {
  433. fromEdbInfo, err = models.GetEdbInfoById(fromEdbInfoId)
  434. if err != nil {
  435. br.Msg = "获取指标信息失败"
  436. br.ErrMsg = "获取指标信息失败:Err:" + err.Error()
  437. return
  438. }
  439. }
  440. edbCode, err := utils.GenerateEdbCode(1, "")
  441. if err != nil {
  442. br.Msg = "指标生成失败"
  443. br.ErrMsg = "指标编码生成失败,Err:" + err.Error()
  444. return
  445. }
  446. timestamp := strconv.FormatInt(time.Now().UnixNano(), 10)
  447. uniqueCode := utils.MD5(utils.DATA_PREFIX + "_" + timestamp)
  448. sysUserId := req.AdminId
  449. sysUserName := req.AdminName
  450. var sourName string
  451. var edbInfoId int
  452. var edbInfo *models.EdbInfo
  453. var errMsg string
  454. var baseEdbInfoModel models.BaseEdbInfoInterface
  455. addParam := models.AddCalculateBatchParams{
  456. Req: &req,
  457. FromEdbInfo: fromEdbInfo,
  458. EdbCode: edbCode,
  459. UniqueCode: uniqueCode,
  460. SysUserId: sysUserId,
  461. SysUserRealName: sysUserName,
  462. }
  463. switch req.Source {
  464. case utils.DATA_SOURCE_CALCULATE_LJZZY:
  465. sourName = "累计值转月值"
  466. if fromEdbInfo.Frequency != "月度" {
  467. br.Msg = "请选择月度指标"
  468. return
  469. }
  470. edbInfo, err = models.AddCalculateLjzzy(&req, fromEdbInfo, edbCode, uniqueCode, sysUserId, sysUserName)
  471. case utils.DATA_SOURCE_CALCULATE_TBZ:
  472. if req.Frequency != fromEdbInfo.Frequency {
  473. br.Msg = "当前频度和原指标频度不一致"
  474. return
  475. }
  476. if req.Unit != "无" {
  477. br.Msg = "单位只允许为无,禁止选择其他单位"
  478. return
  479. }
  480. sourName = "同比值"
  481. edbInfo, err = models.AddCalculateTbz(&req, fromEdbInfo, edbCode, uniqueCode, sysUserId, sysUserName)
  482. case utils.DATA_SOURCE_CALCULATE_TCZ:
  483. if req.Frequency != fromEdbInfo.Frequency {
  484. br.Msg = "当前频度和原指标频度不一致"
  485. return
  486. }
  487. if req.Unit != fromEdbInfo.Unit {
  488. br.Msg = "当前单位和原指标单位不一致"
  489. return
  490. }
  491. sourName = "同差值"
  492. edbInfo, err = models.AddCalculateTcz(&req, fromEdbInfo, edbCode, uniqueCode, sysUserId, sysUserName)
  493. case utils.DATA_SOURCE_CALCULATE_NSZYDPJJS:
  494. sourName = "N数值移动平均计算"
  495. edbInfo, err = models.AddCalculateNszydpjjs(&req, fromEdbInfo, edbCode, uniqueCode, sysUserId, sysUserName, formulaInt)
  496. case utils.DATA_SOURCE_CALCULATE_HBZ:
  497. checkCount, tmpErr := models.GetLteZeroEdbDataCount(fromEdbInfo.Source, fromEdbInfo.SubSource, fromEdbInfoId)
  498. if tmpErr != nil && tmpErr.Error() != utils.ErrNoRow() {
  499. br.Msg = "判断环比值是否可计算失败"
  500. br.ErrMsg = "判断环比值是否可计算失败,Err:" + tmpErr.Error()
  501. return
  502. }
  503. if checkCount > 0 {
  504. br.Msg = "原始数据中存在0或负数,该指标不能进行环比运算"
  505. br.ErrMsg = "原始数据中出现0和负值时,提示该指标不能进行环比运算"
  506. return
  507. }
  508. sourName = "环比值"
  509. edbInfo, err = models.AddCalculateHbz(&req, fromEdbInfo, edbCode, uniqueCode, sysUserId, sysUserName, formulaInt)
  510. case utils.DATA_SOURCE_CALCULATE_HCZ:
  511. sourName = "环差值"
  512. edbInfo, err = models.AddCalculateHcz(&req, fromEdbInfo, edbCode, uniqueCode, sysUserId, sysUserName, formulaInt)
  513. case utils.DATA_SOURCE_CALCULATE_BP:
  514. sourName = utils.DATA_SOURCE_NAME_CALCULATE_BP
  515. edbInfo, err = models.AddCalculateBp(&req, fromEdbInfo, edbCode, uniqueCode, sysUserId, sysUserName)
  516. case utils.DATA_SOURCE_CALCULATE_TIME_SHIFT:
  517. sourName = "时间移位"
  518. edbInfo, err = models.AddCalculateTimeShift(&req, fromEdbInfo, edbCode, uniqueCode, sysUserId, sysUserName)
  519. case utils.DATA_SOURCE_CALCULATE_ZJPJ:
  520. sourName = "直接拼接"
  521. if len(req.EdbInfoIdArr) != 1 {
  522. br.Msg = "请传入拼接日期之后的指标"
  523. br.ErrMsg = "请传入拼接日期之后的指标"
  524. return
  525. }
  526. secondEdbInfoReq := req.EdbInfoIdArr[0]
  527. secondEdbInfo, tmpErr := models.GetEdbInfoById(secondEdbInfoReq.EdbInfoId)
  528. if tmpErr != nil {
  529. br.Msg = "获取拼接日期之后的指标信息失败"
  530. br.ErrMsg = "获取拼接日期之后的指标信息失败:Err:" + tmpErr.Error()
  531. return
  532. }
  533. if fromEdbInfo.EdbInfoId == secondEdbInfo.EdbInfoId {
  534. br.Msg = "两个指标不允许为同一个"
  535. br.ErrMsg = "两个指标不允许为同一个"
  536. return
  537. }
  538. edbInfo, err = models.AddCalculateZjpj(&req, fromEdbInfo, secondEdbInfo, edbCode, uniqueCode, sysUserId, sysUserName)
  539. case utils.DATA_SOURCE_CALCULATE_LJZTBPJ:
  540. sourName = "累计值同比拼接"
  541. if fromEdbInfo.Frequency != "月度" {
  542. br.Msg = "待拼接指标只能筛选月度指标"
  543. br.ErrMsg = "待拼接指标只能筛选月度指标"
  544. return
  545. }
  546. if len(req.EdbInfoIdArr) != 1 {
  547. br.Msg = "请传入同比值指标"
  548. br.ErrMsg = "请传入同比值指标"
  549. return
  550. }
  551. secondEdbInfoReq := req.EdbInfoIdArr[0]
  552. tbzEdbInfo, tmpErr := models.GetEdbInfoById(secondEdbInfoReq.EdbInfoId)
  553. if tmpErr != nil {
  554. br.Msg = "获取同比值指标信息失败"
  555. br.ErrMsg = "获取同比值指标信息失败:Err:" + tmpErr.Error()
  556. return
  557. }
  558. if tbzEdbInfo.Source != utils.DATA_SOURCE_CALCULATE_TBZ {
  559. br.Msg = "指标必须是传入同比值指标类型"
  560. br.ErrMsg = "指标必须是传入同比值指标类型"
  561. return
  562. }
  563. if tbzEdbInfo.Frequency != "月度" {
  564. br.Msg = "同比值指标只能筛选月度指标"
  565. br.ErrMsg = "同比值指标只能筛选月度指标"
  566. return
  567. }
  568. if fromEdbInfo.EdbInfoId == tbzEdbInfo.EdbInfoId {
  569. br.Msg = "两个指标不允许为同一个"
  570. br.ErrMsg = "两个指标不允许为同一个"
  571. return
  572. }
  573. edbInfo, err = models.AddCalculateLjztbpj(&req, fromEdbInfo, tbzEdbInfo, edbCode, uniqueCode, sysUserId, sysUserName)
  574. case utils.DATA_SOURCE_CALCULATE_CJJX:
  575. sourName = "超季节性"
  576. edbInfo, err = models.AddCalculateCjjx(&req, fromEdbInfo, edbCode, uniqueCode, sysUserId, sysUserName, formulaInt)
  577. case utils.DATA_SOURCE_CALCULATE_NHCC:
  578. sourName = "拟合残差"
  579. secondEdbInfoReq := req.EdbInfoIdArr[1]
  580. secondEdbInfo, tmpErr := models.GetEdbInfoById(secondEdbInfoReq.EdbInfoId)
  581. if tmpErr != nil {
  582. br.Msg = "获取因变量的指标信息失败"
  583. br.ErrMsg = "获取因变量的指标信息失败:Err:" + tmpErr.Error()
  584. return
  585. }
  586. if fromEdbInfo.EdbInfoId == secondEdbInfo.EdbInfoId {
  587. br.Msg = "两个指标不允许为同一个"
  588. br.ErrMsg = "两个指标不允许为同一个"
  589. return
  590. }
  591. edbInfo, err, errMsg = models.AddCalculateNhcc(&req, fromEdbInfo, secondEdbInfo, edbCode, uniqueCode, nhccDate, sysUserId, sysUserName)
  592. case utils.DATA_SOURCE_CALCULATE_JP:
  593. if !models.CheckFrequency(fromEdbInfo.Frequency, req.Frequency) {
  594. br.Msg = "频度异常,不允许低频降频到高频"
  595. return
  596. }
  597. sourName = utils.DATA_SOURCE_NAME_CALCULATE_JP
  598. edbInfo, err = models.AddCalculateJp(&req, fromEdbInfo, edbCode, uniqueCode, sysUserId, sysUserName)
  599. case utils.DATA_SOURCE_CALCULATE_NH:
  600. sourName = utils.DATA_SOURCE_NAME_CALCULATE_NH
  601. edbInfo, err = models.AddCalculateNh(&req, fromEdbInfo, edbCode, uniqueCode, sysUserId, sysUserName)
  602. case utils.DATA_SOURCE_CALCULATE_KSZS:
  603. if len(req.EdbInfoIdArr) < 2 {
  604. br.Msg = "指标数量不能小于2个,请重新选择"
  605. br.ErrMsg = "指标数量不能小于2个,请重新选择"
  606. br.IsSendEmail = false
  607. return
  608. }
  609. sourName = utils.DATA_SOURCE_NAME_CALCULATE_KSZS
  610. edbInfo, err = models.AddCalculateKszs(&req, edbCode, uniqueCode, sysUserId, sysUserName)
  611. case utils.DATA_SOURCE_CALCULATE_CORRELATION:
  612. if len(req.EdbInfoIdArr) < 2 {
  613. br.Msg = "指标数量不能小于2个,请重新选择"
  614. br.ErrMsg = "指标数量不能小于2个,请重新选择"
  615. br.IsSendEmail = false
  616. return
  617. }
  618. sourName = utils.DATA_SOURCE_NAME_CALCULATE_CORRELATION
  619. edbInfo, err, errMsg = models.AddCalculateCorrelation(&req, edbCode, uniqueCode, sysUserId, sysUserName)
  620. case utils.DATA_SOURCE_CALCULATE_RJZ:
  621. if req.Frequency == "日度" {
  622. br.Msg = "日度指标无需进行日均值计算"
  623. return
  624. }
  625. if req.Frequency != fromEdbInfo.Frequency {
  626. br.Msg = "当前频度和原指标频度不一致"
  627. return
  628. }
  629. if req.Unit != fromEdbInfo.Unit {
  630. br.Msg = "单位只允许为和原指标频度保持一致,禁止选择其他单位"
  631. return
  632. }
  633. sourName = "日均值"
  634. edbInfo, err = models.AddCalculateRjz(&req, fromEdbInfo, edbCode, uniqueCode, sysUserId, sysUserName)
  635. default:
  636. baseEdbInfoModel = models.GetBaseEdbInfoModel(req.Source)
  637. if baseEdbInfoModel == nil {
  638. br.Msg = "无效计算方式"
  639. br.ErrMsg = "无效计算方式,source:" + strconv.Itoa(req.Source)
  640. return
  641. }
  642. sourName = baseEdbInfoModel.GetSourceName()
  643. edbInfo, err, errMsg = baseEdbInfoModel.Add(addParam)
  644. }
  645. if err != nil {
  646. br.Msg = "生成" + sourName + "失败"
  647. if errMsg != `` {
  648. br.Msg = errMsg
  649. }
  650. br.ErrMsg = "生成" + sourName + "失败 Err:" + err.Error()
  651. return
  652. }
  653. if edbInfo == nil {
  654. br.Msg = "生成" + sourName + "失败"
  655. br.ErrMsg = "生成" + sourName + "失败,指标ID错误:" + strconv.Itoa(edbInfoId)
  656. return
  657. }
  658. edbInfoId = edbInfo.EdbInfoId
  659. go logic.UpdateEs(edbInfoId)
  660. {
  661. edbNameList, err := models.GetEdbInfoByName(req.EdbName)
  662. if err != nil {
  663. br.Msg = "保存失败"
  664. br.ErrMsg = "获取指标信息失败,Err:" + err.Error()
  665. return
  666. }
  667. if len(edbNameList) >= 2 {
  668. for _, v := range edbNameList {
  669. edbName := v.EdbName + "(" + v.SourceName + ")"
  670. err = models.ModifyEdbInfoNameSource(edbName, v.EdbInfoId)
  671. if err != nil {
  672. br.Msg = "保存失败"
  673. br.ErrMsg = "修改指标名称失败,Err:" + err.Error()
  674. return
  675. }
  676. }
  677. }
  678. }
  679. err, errMsg = models.UnifiedModifyEdbInfoMaxAndMinInfo(edbInfo)
  680. if err != nil {
  681. br.Msg = errMsg
  682. br.ErrMsg = err.Error()
  683. return
  684. }
  685. newEdbInfo := new(models.EdbInfoEditRecord)
  686. newEdbInfo.EdbName = req.EdbName
  687. newEdbInfo.Frequency = req.Frequency
  688. newEdbInfo.Unit = req.Unit
  689. newEdbInfo.OperateUserId = req.AdminId
  690. newEdbInfo.OperateUserRealName = req.AdminName
  691. err = services.AddEditEdbInfoRcord(edbInfo, newEdbInfo)
  692. if err != nil {
  693. br.Msg = "保存失败"
  694. br.ErrMsg = "保存失败,Err:" + err.Error()
  695. return
  696. }
  697. go services.DisableEdbInfoNoUpdate(edbInfo)
  698. resp := models.AddEdbInfoResp{
  699. EdbInfoId: edbInfo.EdbInfoId,
  700. UniqueCode: edbInfo.UniqueCode,
  701. }
  702. br.Ret = 200
  703. br.Success = true
  704. br.Msg = "保存成功"
  705. br.Data = resp
  706. br.IsAddLog = true
  707. }
  708. // @router /batch/edit [post]
  709. func (this *CalculateController) BatchEdit() {
  710. br := new(models.BaseResponse).Init()
  711. defer func() {
  712. this.Data["json"] = br
  713. this.ServeJSON()
  714. }()
  715. var req models.EdbInfoCalculateBatchEditReq
  716. err := json.Unmarshal(this.Ctx.Input.RequestBody, &req)
  717. if err != nil {
  718. br.Msg = "参数解析异常!"
  719. br.ErrMsg = "参数解析失败,Err:" + err.Error()
  720. return
  721. }
  722. if req.EdbName == "" {
  723. br.Msg = "指标名称不能为空"
  724. return
  725. }
  726. if req.Frequency == "" {
  727. br.Msg = "频率不能为空"
  728. return
  729. }
  730. if req.Unit == "" {
  731. br.Msg = "单位不能为空"
  732. return
  733. }
  734. if req.ClassifyId <= 0 {
  735. br.Msg = "请选择分类"
  736. return
  737. }
  738. if req.EdbInfoId <= 0 {
  739. br.Msg = "请选择指标"
  740. return
  741. }
  742. existEdbName, err := logic.CheckExistByEdbNameAndEdbInfoId(utils.EDB_INFO_TYPE, req.EdbInfoId, req.EdbName, this.Lang)
  743. if err != nil {
  744. br.Msg = "判断指标名称是否存在失败"
  745. br.ErrMsg = "判断指标名称是否存在失败,Err:" + err.Error()
  746. return
  747. }
  748. if existEdbName {
  749. br.Msg = "指标名称已存在,请重新填写"
  750. br.ErrMsg = "指标名称已存在,请重新填写"
  751. br.IsSendEmail = false
  752. return
  753. }
  754. edbInfo, err := models.GetEdbInfoById(req.EdbInfoId)
  755. if err != nil {
  756. if err.Error() == utils.ErrNoRow() {
  757. br.Msg = "指标已被删除,请刷新页面"
  758. br.ErrMsg = "指标已被删除,请刷新页面:Err:" + err.Error()
  759. return
  760. }
  761. br.Msg = "获取指标信息失败"
  762. br.ErrMsg = "获取指标信息失败:Err:" + err.Error()
  763. return
  764. }
  765. oldEdbName := edbInfo.EdbName
  766. oldFrequency := edbInfo.Frequency
  767. oldUnit := edbInfo.Unit
  768. fromEdbInfoId := req.FromEdbInfoId
  769. if req.Source <= 0 {
  770. req.Source = edbInfo.Source
  771. }
  772. var formulaInt int
  773. var nhccDate models.NhccDate // 拟合残差的日期
  774. switch req.Source {
  775. case utils.DATA_SOURCE_CALCULATE_NSZYDPJJS, utils.DATA_SOURCE_CALCULATE_HBZ, utils.DATA_SOURCE_CALCULATE_HCZ, utils.DATA_SOURCE_CALCULATE_TIME_SHIFT, utils.DATA_SOURCE_CALCULATE_CJJX:
  776. if req.Formula == "" {
  777. br.Msg = "请填写N值"
  778. return
  779. }
  780. formulaInt, _ = strconv.Atoi(req.Formula)
  781. if formulaInt <= 0 {
  782. br.Msg = "N值输入错误,请重新输入"
  783. return
  784. }
  785. case utils.DATA_SOURCE_CALCULATE_ZJPJ:
  786. _, err = time.ParseInLocation(utils.FormatDate, req.Formula, time.Local)
  787. if err != nil {
  788. br.Msg = "拼接日期有误,请重新输入"
  789. return
  790. }
  791. case utils.DATA_SOURCE_CALCULATE_NHCC: //拟合残差指标
  792. if len(req.EdbInfoIdArr) != 2 {
  793. br.Msg = "选择的指标异常,请重新选择"
  794. return
  795. }
  796. fromEdbInfoId = req.EdbInfoIdArr[0].EdbInfoId
  797. timeList := strings.Split(req.Formula, ",")
  798. if len(timeList) != 2 {
  799. br.Msg = "选择时间有误,请重新输入"
  800. return
  801. }
  802. startDate, err := time.ParseInLocation(utils.FormatDate, timeList[0], time.Local)
  803. if err != nil {
  804. br.Msg = "开始日期有误,请重新输入"
  805. return
  806. }
  807. endDate, err := time.ParseInLocation(utils.FormatDate, timeList[1], time.Local)
  808. if err != nil {
  809. br.Msg = "结束日期有误,请重新输入"
  810. return
  811. }
  812. if utils.GetTimeSubDay(startDate, endDate) < 2 {
  813. br.Msg = "日期间隔不得少于两天"
  814. return
  815. }
  816. nhccDate.StartDate = startDate
  817. nhccDate.EndDate = endDate
  818. case utils.DATA_SOURCE_CALCULATE_JP:
  819. if req.Formula != "期末值" && req.Formula != "平均值" {
  820. br.Msg = "数据取值类型错误:" + req.Formula
  821. return
  822. }
  823. case utils.DATA_SOURCE_CALCULATE_ZSXY: // 指数修匀
  824. if req.Formula == "" {
  825. br.Msg = "请填写alpha值"
  826. return
  827. }
  828. a, e := strconv.ParseFloat(req.Formula, 64)
  829. if e != nil {
  830. br.Msg = "alpha值输入错误, 请重新输入"
  831. return
  832. }
  833. if a <= 0 || a >= 1 {
  834. br.Msg = "alpha值输入错误, 请重新输入"
  835. return
  836. }
  837. }
  838. var fromEdbInfo *models.EdbInfo
  839. if fromEdbInfoId > 0 {
  840. fromEdbInfo, err = models.GetEdbInfoById(fromEdbInfoId)
  841. if err != nil {
  842. if err.Error() == utils.ErrNoRow() {
  843. br.Msg = "指标已被删除,请刷新页面"
  844. br.ErrMsg = "指标已被删除,请刷新页面:Err:" + err.Error()
  845. return
  846. }
  847. br.Msg = "获取指标信息失败"
  848. br.ErrMsg = "获取指标信息失败:Err:" + err.Error()
  849. return
  850. }
  851. }
  852. switch this.Lang {
  853. case utils.EnLangVersion:
  854. req.EdbNameEn = req.EdbName
  855. req.UnitEn = req.Unit
  856. req.EdbName = edbInfo.EdbName
  857. req.Unit = edbInfo.Unit
  858. default:
  859. req.EdbNameEn = edbInfo.EdbNameEn
  860. req.UnitEn = edbInfo.UnitEn
  861. }
  862. var sourName, errMsg string
  863. var edbInfoId int
  864. var baseEdbInfoModel models.BaseEdbInfoInterface
  865. editParams := models.EditCalculateBatchParams{
  866. Req: &req,
  867. EdbInfo: edbInfo,
  868. FromEdbInfo: fromEdbInfo,
  869. }
  870. switch req.Source {
  871. case utils.DATA_SOURCE_CALCULATE_LJZZY:
  872. sourName = "累计值转月值"
  873. if fromEdbInfo.Frequency != "月度" {
  874. br.Msg = "请选择月度指标"
  875. return
  876. }
  877. err = models.EditCalculateLjzzy(edbInfo, &req, fromEdbInfo)
  878. case utils.DATA_SOURCE_CALCULATE_TBZ:
  879. sourName = "同比值"
  880. err = models.EditCalculateTbz(edbInfo, &req, fromEdbInfo)
  881. case utils.DATA_SOURCE_CALCULATE_TCZ:
  882. fmt.Println("start edit", time.Now())
  883. sourName = "同差值"
  884. err = models.EditCalculateTcz(edbInfo, &req, fromEdbInfo)
  885. fmt.Println("end edit", time.Now())
  886. case utils.DATA_SOURCE_CALCULATE_NSZYDPJJS:
  887. sourName = "N数值移动平均计算"
  888. err = models.EditCalculateNszydpjjs(edbInfo, &req, fromEdbInfo, formulaInt, edbInfo.CalculateFormula)
  889. case utils.DATA_SOURCE_CALCULATE_HBZ:
  890. checkCount, tmpErr := models.GetLteZeroEdbDataCount(fromEdbInfo.Source, fromEdbInfo.SubSource, req.FromEdbInfoId)
  891. if tmpErr != nil && tmpErr.Error() != utils.ErrNoRow() {
  892. br.Msg = "判断环比值是否可计算失败"
  893. br.ErrMsg = "判断环比值是否可计算失败,Err:" + tmpErr.Error()
  894. return
  895. }
  896. if checkCount > 0 {
  897. br.Msg = "原始数据中存在0或负数,该指标不能进行环比运算"
  898. br.ErrMsg = "原始数据中出现0和负值时,提示该指标不能进行环比运算"
  899. return
  900. }
  901. sourName = "环比值"
  902. err = models.EditCalculateHbz(edbInfo, &req, fromEdbInfo, formulaInt, edbInfo.CalculateFormula)
  903. case utils.DATA_SOURCE_CALCULATE_HCZ:
  904. sourName = "环差值"
  905. err = models.EditCalculateHcz(edbInfo, &req, fromEdbInfo, formulaInt, edbInfo.CalculateFormula)
  906. case utils.DATA_SOURCE_CALCULATE_BP:
  907. sourName = utils.DATA_SOURCE_NAME_CALCULATE_BP
  908. err = models.EditCalculateBp(edbInfo, &req, fromEdbInfo)
  909. case utils.DATA_SOURCE_CALCULATE_TIME_SHIFT:
  910. sourName = "时间移位"
  911. err = models.EditCalculateTimeShift(edbInfo, &req, fromEdbInfo)
  912. case utils.DATA_SOURCE_CALCULATE_ZJPJ:
  913. sourName = "直接拼接"
  914. if len(req.EdbInfoIdArr) != 1 {
  915. br.Msg = "请传入拼接日期之后的指标"
  916. br.ErrMsg = "请传入拼接日期之后的指标"
  917. return
  918. }
  919. secondEdbInfoReq := req.EdbInfoIdArr[0]
  920. secondEdbInfo, tmpErr := models.GetEdbInfoById(secondEdbInfoReq.EdbInfoId)
  921. if tmpErr != nil {
  922. br.Msg = "获取拼接日期之后的指标信息失败"
  923. br.ErrMsg = "获取拼接日期之后的指标信息失败:Err:" + tmpErr.Error()
  924. return
  925. }
  926. if fromEdbInfo.EdbInfoId == secondEdbInfo.EdbInfoId {
  927. br.Msg = "两个指标不允许为同一个"
  928. br.ErrMsg = "两个指标不允许为同一个"
  929. return
  930. }
  931. err = models.EditCalculateZjpj(&req, edbInfo, fromEdbInfo, secondEdbInfo)
  932. case utils.DATA_SOURCE_CALCULATE_LJZTBPJ: //累计值同比拼接
  933. sourName = "累计值同比拼接"
  934. if fromEdbInfo.Frequency != "月度" {
  935. br.Msg = "待拼接指标只能筛选月度指标"
  936. br.ErrMsg = "待拼接指标只能筛选月度指标"
  937. return
  938. }
  939. if len(req.EdbInfoIdArr) != 1 {
  940. br.Msg = "请传入同比值指标"
  941. br.ErrMsg = "请传入同比值指标"
  942. return
  943. }
  944. secondEdbInfoReq := req.EdbInfoIdArr[0]
  945. tbzEdbInfo, tmpErr := models.GetEdbInfoById(secondEdbInfoReq.EdbInfoId)
  946. if tmpErr != nil {
  947. br.Msg = "获取同比值指标信息失败"
  948. br.ErrMsg = "获取同比值指标信息失败:Err:" + tmpErr.Error()
  949. return
  950. }
  951. if tbzEdbInfo.Source != utils.DATA_SOURCE_CALCULATE_TBZ {
  952. br.Msg = "指标必须是传入同比值指标类型"
  953. br.ErrMsg = "指标必须是传入同比值指标类型"
  954. return
  955. }
  956. if tbzEdbInfo.Frequency != "月度" {
  957. br.Msg = "同比值指标只能筛选月度指标"
  958. br.ErrMsg = "同比值指标只能筛选月度指标"
  959. return
  960. }
  961. if fromEdbInfo.EdbInfoId == tbzEdbInfo.EdbInfoId {
  962. br.Msg = "两个指标不允许为同一个"
  963. br.ErrMsg = "两个指标不允许为同一个"
  964. return
  965. }
  966. err = models.EditCalculateLjztbpj(&req, edbInfo, fromEdbInfo, tbzEdbInfo)
  967. case utils.DATA_SOURCE_CALCULATE_CJJX:
  968. sourName = "超季节性"
  969. err = models.EditCalculateCjjx(&req, edbInfo, fromEdbInfo, formulaInt)
  970. case utils.DATA_SOURCE_CALCULATE_NHCC:
  971. sourName = "拟合残差"
  972. secondEdbInfoReq := req.EdbInfoIdArr[1]
  973. secondEdbInfo, tmpErr := models.GetEdbInfoById(secondEdbInfoReq.EdbInfoId)
  974. if tmpErr != nil {
  975. br.Msg = "获取因变量的指标信息失败"
  976. br.ErrMsg = "获取因变量的指标信息失败:Err:" + tmpErr.Error()
  977. return
  978. }
  979. if fromEdbInfo.EdbInfoId == secondEdbInfo.EdbInfoId {
  980. br.Msg = "两个指标不允许为同一个"
  981. br.ErrMsg = "两个指标不允许为同一个"
  982. return
  983. }
  984. err, errMsg = models.EditCalculateNhcc(&req, edbInfo, fromEdbInfo, secondEdbInfo, nhccDate)
  985. case utils.DATA_SOURCE_CALCULATE_JP:
  986. if !models.CheckFrequency(fromEdbInfo.Frequency, req.Frequency) {
  987. br.Msg = "频度异常,不允许低频降频到高频"
  988. return
  989. }
  990. sourName = utils.DATA_SOURCE_NAME_CALCULATE_JP
  991. err = models.EditCalculateJp(edbInfo, &req, fromEdbInfo)
  992. case utils.DATA_SOURCE_CALCULATE_NH:
  993. sourName = utils.DATA_SOURCE_NAME_CALCULATE_NH
  994. err = models.EditCalculateNh(edbInfo, &req, fromEdbInfo)
  995. case utils.DATA_SOURCE_CALCULATE_KSZS:
  996. if len(req.EdbInfoIdArr) < 2 {
  997. br.Msg = "指标数量不能小于2个,请重新选择"
  998. br.ErrMsg = "指标数量不能小于2个,请重新选择"
  999. br.IsSendEmail = false
  1000. return
  1001. }
  1002. sourName = utils.DATA_SOURCE_NAME_CALCULATE_KSZS
  1003. err = models.EditCalculateKszs(edbInfo, &req)
  1004. case utils.DATA_SOURCE_CALCULATE_CORRELATION:
  1005. if len(req.EdbInfoIdArr) < 2 {
  1006. br.Msg = "指标数量不能小于2个,请重新选择"
  1007. br.ErrMsg = "指标数量不能小于2个,请重新选择"
  1008. br.IsSendEmail = false
  1009. return
  1010. }
  1011. sourName = utils.DATA_SOURCE_NAME_CALCULATE_CORRELATION
  1012. err, errMsg = models.EditCalculateCorrelation(edbInfo, &req)
  1013. case utils.DATA_SOURCE_CALCULATE_RJZ:
  1014. if req.Frequency == "日度" {
  1015. br.Msg = "日度指标无需进行日均值计算"
  1016. return
  1017. }
  1018. if req.Frequency != fromEdbInfo.Frequency {
  1019. br.Msg = "当前频度和原指标频度不一致"
  1020. return
  1021. }
  1022. if req.Unit != fromEdbInfo.Unit {
  1023. br.Msg = "单位只允许为和原指标频度保持一致,禁止选择其他单位"
  1024. return
  1025. }
  1026. sourName = "日均值"
  1027. err = models.EditCalculateRjz(edbInfo, &req, fromEdbInfo)
  1028. default:
  1029. baseEdbInfoModel = models.GetBaseEdbInfoModel(req.Source)
  1030. if baseEdbInfoModel == nil {
  1031. br.Msg = "无效计算方式"
  1032. br.ErrMsg = "无效计算方式,source:" + strconv.Itoa(req.Source)
  1033. return
  1034. }
  1035. sourName = baseEdbInfoModel.GetSourceName()
  1036. err, errMsg = baseEdbInfoModel.Edit(editParams)
  1037. }
  1038. if err != nil {
  1039. br.Msg = "生成" + sourName + "失败"
  1040. if errMsg != `` {
  1041. br.Msg = errMsg
  1042. }
  1043. br.Msg = "生成" + sourName + "失败 Err:" + err.Error()
  1044. return
  1045. }
  1046. if edbInfo == nil {
  1047. br.Msg = "生成" + sourName + "失败"
  1048. br.ErrMsg = "生成" + sourName + "失败,指标ID错误:" + strconv.Itoa(edbInfoId)
  1049. return
  1050. }
  1051. edbInfoId = edbInfo.EdbInfoId
  1052. {
  1053. edbNameList, err := models.GetEdbInfoByName(req.EdbName)
  1054. if err != nil {
  1055. br.Msg = "保存失败"
  1056. br.ErrMsg = "获取指标信息失败,Err:" + err.Error()
  1057. return
  1058. }
  1059. if len(edbNameList) >= 2 {
  1060. for _, v := range edbNameList {
  1061. edbName := v.EdbName + "(" + v.SourceName + ")"
  1062. err = models.ModifyEdbInfoNameSource(edbName, v.EdbInfoId)
  1063. if err != nil {
  1064. br.Msg = "保存失败"
  1065. br.ErrMsg = "修改指标名称失败,Err:" + err.Error()
  1066. return
  1067. }
  1068. }
  1069. }
  1070. }
  1071. err, errMsg = models.UnifiedModifyEdbInfoMaxAndMinInfo(edbInfo)
  1072. if err != nil {
  1073. br.Msg = errMsg
  1074. br.ErrMsg = err.Error()
  1075. return
  1076. }
  1077. oldEdbInfo := new(models.EdbInfo)
  1078. oldEdbInfo.EdbInfoId = edbInfo.EdbInfoId
  1079. oldEdbInfo.EdbName = oldEdbName
  1080. oldEdbInfo.Frequency = oldFrequency
  1081. oldEdbInfo.Unit = oldUnit
  1082. newEdbInfoRecord := new(models.EdbInfoEditRecord)
  1083. newEdbInfoRecord.EdbName = req.EdbName
  1084. newEdbInfoRecord.Frequency = req.Frequency
  1085. newEdbInfoRecord.Unit = req.Unit
  1086. newEdbInfoRecord.OperateUserId = req.AdminId
  1087. newEdbInfoRecord.OperateUserRealName = req.AdminName
  1088. err = services.AddEditEdbInfoRcord(oldEdbInfo, newEdbInfoRecord)
  1089. if err != nil {
  1090. br.Msg = "保存失败"
  1091. br.ErrMsg = "记录指标操作记录失败,Err:" + err.Error()
  1092. }
  1093. go services.ResetEdbRelation(edbInfoId)
  1094. go logic.UpdateEs(edbInfo.EdbInfoId)
  1095. resp := models.AddEdbInfoResp{
  1096. EdbInfoId: edbInfo.EdbInfoId,
  1097. UniqueCode: edbInfo.UniqueCode,
  1098. }
  1099. br.Ret = 200
  1100. br.Success = true
  1101. br.Msg = "保存成功"
  1102. br.Data = resp
  1103. br.IsAddLog = true
  1104. }
  1105. // @router /refresh [post]
  1106. func (this *CalculateController) Refresh() {
  1107. br := new(models.BaseResponse).Init()
  1108. var cacheKey string
  1109. defer func() {
  1110. this.Data["json"] = br
  1111. this.ServeJSON()
  1112. }()
  1113. var req models.RefreshEdbInfoReq
  1114. err := json.Unmarshal(this.Ctx.Input.RequestBody, &req)
  1115. if err != nil {
  1116. br.Msg = "参数解析异常!"
  1117. br.ErrMsg = "参数解析失败,Err:" + err.Error()
  1118. return
  1119. }
  1120. if req.EdbCode == "" {
  1121. br.Msg = "请输入指标编码!"
  1122. br.ErrMsg = "请输入指标编码,指标编码为空"
  1123. return
  1124. }
  1125. if req.EdbInfoId <= 0 {
  1126. br.Msg = "请输入指标ID!"
  1127. br.ErrMsg = "请输入指标ID"
  1128. return
  1129. }
  1130. edbInfo, err := models.GetEdbInfoById(req.EdbInfoId)
  1131. if err != nil {
  1132. br.Msg = "指标不存在!"
  1133. br.ErrMsg = "指标不存在"
  1134. return
  1135. }
  1136. cacheKey = utils.CACHE_EDB_DATA_REFRESH + strconv.Itoa(edbInfo.Source) + "_" + req.EdbCode
  1137. if utils.Rc.IsExist(cacheKey) {
  1138. br.Ret = 501
  1139. br.Success = true
  1140. br.Msg = "系统处理中,请稍后重试"
  1141. return
  1142. }
  1143. utils.Rc.SetNX(cacheKey, 1, 1*time.Minute)
  1144. defer func() {
  1145. _ = utils.Rc.Delete(cacheKey)
  1146. }()
  1147. startDate := req.StartDate
  1148. var errMsg string
  1149. endDate := time.Now().Format(utils.FormatDate)
  1150. edbInfoId := edbInfo.EdbInfoId
  1151. source := edbInfo.Source
  1152. subSource := edbInfo.SubSource
  1153. var baseEdbInfoModel models.BaseEdbInfoInterface
  1154. refreshParams := models.RefreshParams{
  1155. EdbInfo: edbInfo,
  1156. StartDate: "", // 更新所有
  1157. EndDate: "", // 更新所有数据
  1158. }
  1159. switch source {
  1160. case utils.DATA_SOURCE_CALCULATE:
  1161. startDate = ""
  1162. var edbInfoIdBytes []string
  1163. calculateMap, err := models.GetEdbInfoCalculateDetailList(edbInfo.EdbInfoId)
  1164. if err != nil {
  1165. errMsg = "GetEdbInfoCalculateDetail Err:" + err.Error()
  1166. break
  1167. }
  1168. var formulaStr string
  1169. edbInfoList := make([]*models.EdbInfo, 0)
  1170. edbInfoTag := make(map[string]int)
  1171. for _, v := range calculateMap {
  1172. edbInfoTag[v.FromTag] = v.FromEdbInfoId
  1173. formulaStr += v.FromTag + ","
  1174. edbInfoIdBytes = append(edbInfoIdBytes, v.FromTag)
  1175. edbInfo, _ := models.GetEdbInfoById(v.FromEdbInfoId)
  1176. edbInfoList = append(edbInfoList, edbInfo)
  1177. }
  1178. err = models.RefreshAllCalculate(edbInfoList, edbInfoTag, edbInfo.EdbInfoId, source, subSource, edbInfo.EdbCode, edbInfo.CalculateFormula, startDate, endDate, edbInfoIdBytes, edbInfo.EmptyType, edbInfo.MaxEmptyType, edbInfo.Extra)
  1179. if err != nil && err.Error() != utils.ErrNoRow() {
  1180. errMsg = "RefreshCalculate Err:" + err.Error()
  1181. break
  1182. }
  1183. case utils.DATA_SOURCE_CALCULATE_LJZZY: //刷新累计值转月值
  1184. calculateLjzzy, err := models.GetEdbInfoCalculateMappingDetail(edbInfoId)
  1185. if err != nil {
  1186. errMsg = "GetEdbInfoCalculateLjzzyDetail Err:" + err.Error()
  1187. break
  1188. }
  1189. fromEdbInfo, err := models.GetEdbInfoById(calculateLjzzy.FromEdbInfoId)
  1190. if err != nil {
  1191. errMsg = "GetEdbInfoById Err:" + err.Error()
  1192. break
  1193. }
  1194. endDate = `` //只要填写日期,就会出现问题,还是把日期给去掉吧
  1195. startDate = `` //只要填写日期,就会出现问题,还是把日期给去掉吧
  1196. err = models.RefreshAllCalculateLjzzy(edbInfoId, source, subSource, fromEdbInfo, calculateLjzzy.EdbCode, startDate, endDate)
  1197. if err != nil && err.Error() != utils.ErrNoRow() {
  1198. errMsg = "RefreshAllCalculateLjzzy Err:" + err.Error()
  1199. break
  1200. }
  1201. case utils.DATA_SOURCE_CALCULATE_TBZ: //刷新同比值
  1202. calculateTbz, err := models.GetEdbInfoCalculateMappingDetail(edbInfoId)
  1203. if err != nil {
  1204. errMsg = "GetEdbInfoCalculateTbzDetail Err:" + err.Error()
  1205. break
  1206. }
  1207. fromEdbInfo, err := models.GetEdbInfoById(calculateTbz.FromEdbInfoId)
  1208. if err != nil {
  1209. errMsg = "GetEdbInfoById Err:" + err.Error()
  1210. break
  1211. }
  1212. endDate = time.Now().Format(utils.FormatDate)
  1213. err = models.RefreshAllCalculateTbz(edbInfoId, source, subSource, fromEdbInfo, calculateTbz.EdbCode, startDate, endDate)
  1214. if err != nil && err.Error() != utils.ErrNoRow() {
  1215. errMsg = "RefreshAllCalculateTbz Err:" + err.Error()
  1216. break
  1217. }
  1218. case utils.DATA_SOURCE_CALCULATE_TCZ: //同差值
  1219. calculateTcz, err := models.GetEdbInfoCalculateMappingDetail(edbInfoId)
  1220. if err != nil {
  1221. errMsg = "GetEdbInfoCalculateTczDetail Err:" + err.Error()
  1222. break
  1223. }
  1224. fromEdbInfo, err := models.GetEdbInfoById(calculateTcz.FromEdbInfoId)
  1225. if err != nil {
  1226. errMsg = "GetEdbInfoById Err:" + err.Error()
  1227. break
  1228. }
  1229. endDate = time.Now().Format(utils.FormatDate)
  1230. err = models.RefreshAllCalculateTcz(edbInfoId, source, subSource, fromEdbInfo, calculateTcz.EdbCode, startDate, endDate)
  1231. if err != nil && err.Error() != utils.ErrNoRow() {
  1232. errMsg = "RefreshCalculateTcz Err:" + err.Error()
  1233. break
  1234. }
  1235. case utils.DATA_SOURCE_CALCULATE_NSZYDPJJS: //N数值移动平均计算
  1236. calculateNszydpjjs, err := models.GetEdbInfoCalculateMappingDetail(edbInfoId)
  1237. if err != nil {
  1238. errMsg = "GetEdbInfoCalculateNszydpjjsDetail Err:" + err.Error()
  1239. break
  1240. }
  1241. fromEdbInfo, err := models.GetEdbInfoById(calculateNszydpjjs.FromEdbInfoId)
  1242. if err != nil {
  1243. errMsg = "GetEdbInfoById Err:" + err.Error()
  1244. break
  1245. }
  1246. formulaInt, _ := strconv.Atoi(edbInfo.CalculateFormula)
  1247. startDate = `` //只要填写日期,就会出现问题,还是把日期给去掉吧
  1248. err = models.RefreshAllCalculateNszydpjjs(edbInfoId, edbInfo.Source, edbInfo.SubSource, formulaInt, fromEdbInfo, calculateNszydpjjs.EdbCode, startDate)
  1249. if err != nil && err.Error() != utils.ErrNoRow() {
  1250. errMsg = "RefreshCalculateNszydpjjs Err:" + err.Error()
  1251. break
  1252. }
  1253. case utils.DATA_SOURCE_CALCULATE_HBZ: //刷新环比值
  1254. calculateTbz, err := models.GetEdbInfoCalculateMappingDetail(edbInfoId)
  1255. if err != nil {
  1256. errMsg = "GetEdbInfoCalculateHbzDetail Err:" + err.Error()
  1257. break
  1258. }
  1259. fromEdbInfo, err := models.GetEdbInfoById(calculateTbz.FromEdbInfoId)
  1260. if err != nil {
  1261. errMsg = "GetEdbInfoById Err:" + err.Error()
  1262. break
  1263. }
  1264. startDate = `` //只要填写日期,就会出现问题,还是把日期给去掉吧
  1265. endDate = time.Now().Format(utils.FormatDate)
  1266. formulaInt, _ := strconv.Atoi(edbInfo.CalculateFormula)
  1267. err = models.RefreshAllCalculateHbz(edbInfoId, source, subSource, fromEdbInfo, calculateTbz.EdbCode, startDate, endDate, formulaInt)
  1268. if err != nil && err.Error() != utils.ErrNoRow() {
  1269. errMsg = "RefreshAllCalculateHbz Err:" + err.Error()
  1270. break
  1271. }
  1272. case utils.DATA_SOURCE_CALCULATE_HCZ: //刷新环差值
  1273. calculateTbz, err := models.GetEdbInfoCalculateMappingDetail(edbInfoId)
  1274. if err != nil {
  1275. errMsg = "GetEdbInfoCalculateHczDetail Err:" + err.Error()
  1276. break
  1277. }
  1278. fromEdbInfo, err := models.GetEdbInfoById(calculateTbz.FromEdbInfoId)
  1279. if err != nil {
  1280. errMsg = "GetEdbInfoById Err:" + err.Error()
  1281. break
  1282. }
  1283. startDate = `` //只要填写日期,就会出现问题,还是把日期给去掉吧
  1284. endDate = time.Now().Format(utils.FormatDate)
  1285. formulaInt, _ := strconv.Atoi(edbInfo.CalculateFormula)
  1286. err = models.RefreshAllCalculateHcz(edbInfoId, source, subSource, fromEdbInfo, calculateTbz.EdbCode, startDate, endDate, formulaInt)
  1287. if err != nil && err.Error() != utils.ErrNoRow() {
  1288. errMsg = "RefreshAllCalculateHcz Err:" + err.Error()
  1289. break
  1290. }
  1291. case utils.DATA_SOURCE_CALCULATE_BP: //刷新升频
  1292. calculateTbz, err := models.GetEdbInfoCalculateMappingDetail(edbInfoId)
  1293. if err != nil {
  1294. errMsg = "GetEdbInfoCalculateTbzDetail Err:" + err.Error()
  1295. break
  1296. }
  1297. fromEdbInfo, err := models.GetEdbInfoById(calculateTbz.FromEdbInfoId)
  1298. if err != nil {
  1299. errMsg = "GetEdbInfoById Err:" + err.Error()
  1300. break
  1301. }
  1302. endDate = time.Now().Format(utils.FormatDate)
  1303. err = models.RefreshAllCalculateBp(edbInfoId, source, subSource, fromEdbInfo, calculateTbz.EdbCode, startDate, endDate, edbInfo.EmptyType)
  1304. if err != nil && err.Error() != utils.ErrNoRow() {
  1305. errMsg = "RefreshAllCalculateBp Err:" + err.Error()
  1306. break
  1307. }
  1308. case utils.DATA_SOURCE_CALCULATE_TIME_SHIFT:
  1309. calculate, err := models.GetEdbInfoCalculateMappingDetail(edbInfoId)
  1310. if err != nil {
  1311. errMsg = "GetEdbInfoCalculateTbzDetail Err:" + err.Error()
  1312. break
  1313. }
  1314. fromEdbInfo, err := models.GetEdbInfoById(calculate.FromEdbInfoId)
  1315. if err != nil {
  1316. errMsg = "GetEdbInfoById Err:" + err.Error()
  1317. break
  1318. }
  1319. startDate = `` //只要填写日期,就会出现问题,还是把日期给去掉吧
  1320. endDate = time.Now().Format(utils.FormatDate)
  1321. formulaInt, _ := strconv.Atoi(calculate.CalculateFormula)
  1322. err = models.RefreshAllCalculateTimeShift(edbInfoId, source, subSource, formulaInt, calculate.MoveType, fromEdbInfo, calculate.EdbCode, startDate, endDate, calculate.MoveFrequency)
  1323. if err != nil && err.Error() != utils.ErrNoRow() {
  1324. errMsg = "RefreshAllCalculateTimeShift Err:" + err.Error()
  1325. }
  1326. case utils.DATA_SOURCE_CALCULATE_ZJPJ: //刷新直接拼接
  1327. err = models.RefreshAllCalculateZjpj(edbInfo)
  1328. if err != nil && err.Error() != utils.ErrNoRow() {
  1329. errMsg = "RefreshAllCalculateZjpj Err:" + err.Error()
  1330. break
  1331. }
  1332. case utils.DATA_SOURCE_CALCULATE_LJZTBPJ: //刷新累计值同比拼接
  1333. err = models.RefreshAllCalculateLjztbpj(edbInfo)
  1334. if err != nil && err.Error() != utils.ErrNoRow() {
  1335. errMsg = "RefreshAllCalculateLjztbpj Err:" + err.Error()
  1336. break
  1337. }
  1338. case utils.DATA_SOURCE_PYTHON: //python代码运算
  1339. edbPythonCode, err := models.GetEdbPythonCodeById(edbInfo.EdbInfoId)
  1340. if err != nil {
  1341. errMsg = "获取python代码失败 Err:" + err.Error()
  1342. break
  1343. }
  1344. edbData, err, errMsg := services.ExecPythonCode(edbInfo.EdbCode, edbPythonCode.PythonCode)
  1345. if err != nil {
  1346. br.Msg = "获取数据失败"
  1347. br.ErrMsg = "python代码获取数据失败,err:" + err.Error()
  1348. if errMsg != "" {
  1349. br.Msg = errMsg
  1350. }
  1351. return
  1352. }
  1353. err = models.RefreshAllPythonEdb(edbInfo, edbData)
  1354. if err != nil && err.Error() != utils.ErrNoRow() {
  1355. errMsg = "RefreshAllPythonEdb Err:" + err.Error()
  1356. break
  1357. }
  1358. case utils.DATA_SOURCE_CALCULATE_CJJX: //超季节性
  1359. calculateCjjx, err := models.GetEdbInfoCalculateMappingDetail(edbInfoId)
  1360. if err != nil {
  1361. errMsg = "GetEdbInfoCalculateNszydpjjsDetail Err:" + err.Error()
  1362. break
  1363. }
  1364. fromEdbInfo, err := models.GetEdbInfoById(calculateCjjx.FromEdbInfoId)
  1365. if err != nil {
  1366. errMsg = "GetEdbInfoById Err:" + err.Error()
  1367. break
  1368. }
  1369. formulaInt, _ := strconv.Atoi(edbInfo.CalculateFormula)
  1370. startDate = `` //只要填写日期,就会出现问题,还是把日期给去掉吧
  1371. err = models.RefreshAllCalculateCjjx(edbInfoId, edbInfo.Source, edbInfo.SubSource, fromEdbInfo, calculateCjjx.EdbCode, startDate, "", edbInfo.Calendar, formulaInt)
  1372. if err != nil && err.Error() != utils.ErrNoRow() {
  1373. errMsg = "RefreshAllCalculateCjjx Err:" + err.Error()
  1374. break
  1375. }
  1376. case utils.DATA_SOURCE_CALCULATE_NHCC: //nhcc
  1377. err = models.RefreshAllCalculateNhcc(edbInfo)
  1378. if err != nil && err.Error() != utils.ErrNoRow() {
  1379. errMsg = "RefreshAllCalculateNhcc Err:" + err.Error()
  1380. break
  1381. }
  1382. case utils.DATA_SOURCE_CALCULATE_ADJUST:
  1383. calculateMapping, err := models.GetEdbInfoCalculateMappingDetail(edbInfo.EdbInfoId)
  1384. if err != nil {
  1385. br.Msg = "获取来源指标异常!"
  1386. br.ErrMsg = "获取来源指标异常,Err:" + err.Error()
  1387. return
  1388. }
  1389. fromEdbInfo, err := models.GetEdbInfoById(calculateMapping.FromEdbInfoId)
  1390. if err != nil {
  1391. br.Msg = "来源指标不存在!"
  1392. br.ErrMsg = "来源指标不存在"
  1393. return
  1394. }
  1395. err = models.RefreshAllAdjustEdb(edbInfo, fromEdbInfo)
  1396. if err != nil && err.Error() != utils.ErrNoRow() {
  1397. errMsg = "RefreshAllAdjustEdb Err:" + err.Error()
  1398. break
  1399. }
  1400. case utils.DATA_SOURCE_CALCULATE_JP: //刷新降频
  1401. calculateMapping, err := models.GetEdbInfoCalculateMappingDetail(edbInfoId)
  1402. if err != nil {
  1403. errMsg = "GetEdbInfoCalculateTbzDetail Err:" + err.Error()
  1404. break
  1405. }
  1406. fromEdbInfo, err := models.GetEdbInfoById(calculateMapping.FromEdbInfoId)
  1407. if err != nil {
  1408. errMsg = "GetEdbInfoById Err:" + err.Error()
  1409. break
  1410. }
  1411. endDate = time.Now().Format(utils.FormatDate)
  1412. err = models.RefreshAllCalculateJp(edbInfoId, source, subSource, fromEdbInfo, edbInfo.EdbCode, edbInfo.Frequency, edbInfo.CalculateFormula)
  1413. if err != nil && err.Error() != utils.ErrNoRow() {
  1414. errMsg = "RefreshAllCalculateJp Err:" + err.Error()
  1415. break
  1416. }
  1417. case utils.DATA_SOURCE_CALCULATE_NH: //刷新年化
  1418. calculateMapping, err := models.GetEdbInfoCalculateMappingDetail(edbInfoId)
  1419. if err != nil {
  1420. errMsg = "GetEdbInfoCalculateTbzDetail Err:" + err.Error()
  1421. break
  1422. }
  1423. fromEdbInfo, err := models.GetEdbInfoById(calculateMapping.FromEdbInfoId)
  1424. if err != nil {
  1425. errMsg = "GetEdbInfoById Err:" + err.Error()
  1426. break
  1427. }
  1428. endDate = time.Now().Format(utils.FormatDate)
  1429. err = models.RefreshAllCalculateNh(edbInfoId, source, subSource, fromEdbInfo, edbInfo.EdbCode)
  1430. if err != nil && err.Error() != utils.ErrNoRow() {
  1431. errMsg = "RefreshAllCalculateNh Err:" + err.Error()
  1432. break
  1433. }
  1434. case utils.DATA_SOURCE_CALCULATE_KSZS: //刷新扩散指数
  1435. endDate = time.Now().Format(utils.FormatDate)
  1436. err = models.RefreshAllCalculateKszs(edbInfo)
  1437. if err != nil && err.Error() != utils.ErrNoRow() {
  1438. errMsg = "RefreshAllCalculateKszs Err:" + err.Error()
  1439. break
  1440. }
  1441. case utils.DATA_SOURCE_STOCK_PLANT: //存量装置
  1442. endDate = time.Now().Format(utils.FormatDate)
  1443. req.StartDate = `` // 开始日期也给过滤吧,万一研究员补充了之前的数据呢,还是过滤掉吧
  1444. err = models.RefreshEdbDataFromStockPlant(req.EdbInfoId, req.EdbCode, req.StartDate)
  1445. if err != nil && err.Error() != utils.ErrNoRow() {
  1446. errMsg = "RefreshEdbDataFromStockPlant Err:" + err.Error()
  1447. break
  1448. }
  1449. case utils.DATA_SOURCE_CALCULATE_CORRELATION:
  1450. err, errMsg = models.RefreshAllCalculateCorrelation(edbInfo)
  1451. case utils.DATA_SOURCE_CALCULATE_RJZ: //刷新日均值
  1452. calculateRjz, err := models.GetEdbInfoCalculateMappingDetail(edbInfoId)
  1453. if err != nil {
  1454. errMsg = "GetEdbInfoCalculateMappingDetail Err:" + err.Error()
  1455. break
  1456. }
  1457. fromEdbInfo, err := models.GetEdbInfoById(calculateRjz.FromEdbInfoId)
  1458. if err != nil {
  1459. errMsg = "GetEdbInfoById Err:" + err.Error()
  1460. break
  1461. }
  1462. endDate = time.Now().Format(utils.FormatDate)
  1463. err = models.RefreshAllCalculateRjz(edbInfoId, source, fromEdbInfo, calculateRjz.EdbCode, startDate, endDate)
  1464. if err != nil && err.Error() != utils.ErrNoRow() {
  1465. errMsg = "RefreshAllCalculateRjz Err:" + err.Error()
  1466. break
  1467. }
  1468. default:
  1469. baseEdbInfoModel = models.GetBaseEdbInfoModel(source)
  1470. if baseEdbInfoModel == nil {
  1471. br.Msg = "来源异常,请联系相关开发!"
  1472. br.ErrMsg = "来源异常,请联系相关开发"
  1473. return
  1474. }
  1475. err, errMsg = baseEdbInfoModel.Refresh(refreshParams)
  1476. }
  1477. if errMsg != `` {
  1478. br.Msg = "刷新指标失败!"
  1479. br.ErrMsg = "刷新指标失败,err:" + errMsg
  1480. return
  1481. }
  1482. err, errMsg = models.UnifiedModifyEdbInfoMaxAndMinInfo(edbInfo)
  1483. if err != nil {
  1484. br.Msg = errMsg
  1485. br.ErrMsg = err.Error()
  1486. return
  1487. }
  1488. go logic.UpdateEs(edbInfoId)
  1489. br.Ret = 200
  1490. br.Success = true
  1491. br.Msg = "获取成功"
  1492. }
  1493. // @router /adjust/save [post]
  1494. func (this *CalculateController) SaveAdjust() {
  1495. br := new(models.BaseResponse).Init()
  1496. defer func() {
  1497. this.Data["json"] = br
  1498. this.ServeJSON()
  1499. }()
  1500. var req models.SaveAdjustEdbReq
  1501. err := json.Unmarshal(this.Ctx.Input.RequestBody, &req)
  1502. if err != nil {
  1503. br.Msg = "参数解析异常!"
  1504. br.ErrMsg = "参数解析失败,Err:" + err.Error()
  1505. return
  1506. }
  1507. req.EdbName = strings.Trim(req.EdbName, " ")
  1508. if req.EdbName == "" {
  1509. br.Msg = "指标名称不能为空"
  1510. return
  1511. }
  1512. if req.Frequency == "" {
  1513. br.Msg = "频率不能为空"
  1514. return
  1515. }
  1516. if req.Unit == "" {
  1517. br.Msg = "单位不能为空"
  1518. return
  1519. }
  1520. if req.ClassifyId <= 0 {
  1521. br.Msg = "请选择分类"
  1522. return
  1523. }
  1524. if len(req.DataList) == 0 {
  1525. br.Msg = "请填写数据"
  1526. return
  1527. }
  1528. redisKey := fmt.Sprint("edb_info:adjust:add:", utils.DATA_SOURCE_CALCULATE_ADJUST, ":", req.EdbName)
  1529. isExist := utils.Rc.IsExist(redisKey)
  1530. if isExist {
  1531. br.Msg = "指标正在处理,请勿重复提交"
  1532. return
  1533. } else {
  1534. utils.Rc.SetNX(redisKey, 1, time.Second*300)
  1535. defer func() {
  1536. _ = utils.Rc.Delete(redisKey)
  1537. }()
  1538. }
  1539. var condition string
  1540. var pars []interface{}
  1541. condition += " AND edb_name=? "
  1542. pars = append(pars, req.EdbName)
  1543. if req.EdbInfoId > 0 {
  1544. condition += " AND edb_info_id != ? "
  1545. pars = append(pars, req.EdbInfoId)
  1546. }
  1547. count, err := models.GetEdbInfoCountByCondition(condition, pars)
  1548. if err != nil {
  1549. br.Msg = "判断指标名称是否存在失败"
  1550. br.ErrMsg = "判断指标名称是否存在失败,Err:" + err.Error()
  1551. return
  1552. }
  1553. if count > 0 {
  1554. br.Msg = "指标名称已存在,请重新填写"
  1555. br.ErrMsg = "指标名称已存在,请重新填写"
  1556. return
  1557. }
  1558. edbInfo, err, errMsg := models.SaveAdjustEdb(req)
  1559. if err != nil {
  1560. br.Msg = errMsg
  1561. br.Msg = "添加指标失败,Err:" + err.Error()
  1562. return
  1563. }
  1564. {
  1565. edbNameList, err := models.GetEdbInfoByName(req.EdbName)
  1566. if err != nil {
  1567. br.Msg = "保存失败"
  1568. br.ErrMsg = "获取指标信息失败,Err:" + err.Error()
  1569. return
  1570. }
  1571. if len(edbNameList) >= 2 {
  1572. for _, v := range edbNameList {
  1573. edbName := v.EdbName + "(" + v.SourceName + ")"
  1574. err = models.ModifyEdbInfoNameSource(edbName, v.EdbInfoId)
  1575. if err != nil {
  1576. br.Msg = "保存失败"
  1577. br.ErrMsg = "修改指标名称失败,Err:" + err.Error()
  1578. return
  1579. }
  1580. }
  1581. }
  1582. }
  1583. err, errMsg = models.UnifiedModifyEdbInfoMaxAndMinInfo(edbInfo)
  1584. if err != nil {
  1585. br.Msg = errMsg
  1586. br.ErrMsg = err.Error()
  1587. return
  1588. }
  1589. resp := models.AddEdbInfoResp{
  1590. EdbInfoId: edbInfo.EdbInfoId,
  1591. UniqueCode: edbInfo.UniqueCode,
  1592. }
  1593. go services.DisableEdbInfoNoUpdate(edbInfo)
  1594. go services.ResetEdbRelation(edbInfo.EdbInfoId)
  1595. br.Ret = 200
  1596. br.Success = true
  1597. br.Msg = "保存成功"
  1598. br.Data = resp
  1599. br.IsAddLog = true
  1600. }
  1601. // @router /compute_correlation [post]
  1602. func (this *CalculateController) CalculateComputeCorrelation() {
  1603. br := new(models.BaseResponse).Init()
  1604. defer func() {
  1605. this.Data["json"] = br
  1606. this.ServeJSON()
  1607. }()
  1608. var req models.EdbInfoCalculateBatchSaveReq
  1609. err := json.Unmarshal(this.Ctx.Input.RequestBody, &req)
  1610. if err != nil {
  1611. br.Msg = "参数解析异常!"
  1612. br.ErrMsg = "参数解析失败,Err:" + err.Error()
  1613. return
  1614. }
  1615. if len(req.EdbInfoIdArr) != 2 {
  1616. br.Msg = "选择的指标异常,请重新选择"
  1617. return
  1618. }
  1619. timeList := strings.Split(req.Formula, ",")
  1620. if len(timeList) != 2 {
  1621. br.Msg = "选择时间有误,请重新输入"
  1622. return
  1623. }
  1624. startDate, err := time.ParseInLocation(utils.FormatDate, timeList[0], time.Local)
  1625. if err != nil {
  1626. br.Msg = "开始日期有误,请重新输入"
  1627. return
  1628. }
  1629. endDate, err := time.ParseInLocation(utils.FormatDate, timeList[1], time.Local)
  1630. if err != nil {
  1631. br.Msg = "结束日期有误,请重新输入"
  1632. return
  1633. }
  1634. if utils.GetTimeSubDay(startDate, endDate) < 2 {
  1635. br.Msg = "日期间隔不得少于两天"
  1636. return
  1637. }
  1638. var nhccDate models.NhccDate // 拟合残差的日期
  1639. nhccDate.StartDate = startDate
  1640. nhccDate.EndDate = endDate
  1641. fromEdbInfoId := req.EdbInfoIdArr[0].EdbInfoId
  1642. if fromEdbInfoId <= 0 {
  1643. br.Msg = "请选择指标"
  1644. return
  1645. }
  1646. fromEdbInfo, err := models.GetEdbInfoById(fromEdbInfoId)
  1647. if err != nil {
  1648. br.Msg = "获取指标信息失败"
  1649. br.ErrMsg = "获取指标信息失败:Err:" + err.Error()
  1650. return
  1651. }
  1652. secondEdbInfoReq := req.EdbInfoIdArr[1]
  1653. secondEdbInfo, tmpErr := models.GetEdbInfoById(secondEdbInfoReq.EdbInfoId)
  1654. if tmpErr != nil {
  1655. br.Msg = "获取因变量的指标信息失败"
  1656. br.ErrMsg = "获取因变量的指标信息失败:Err:" + tmpErr.Error()
  1657. return
  1658. }
  1659. if fromEdbInfo.EdbInfoId == secondEdbInfo.EdbInfoId {
  1660. br.Msg = "两个指标不允许为同一个"
  1661. br.ErrMsg = "两个指标不允许为同一个"
  1662. return
  1663. }
  1664. aVal, bVal, rVal, err, errMsg := models.CalculateComputeCorrelation(&req, fromEdbInfo, secondEdbInfo, nhccDate)
  1665. if err != nil {
  1666. br.Msg = "计算失败"
  1667. if errMsg != `` {
  1668. br.Msg = errMsg
  1669. }
  1670. br.ErrMsg = "计算失败,ERR:" + err.Error()
  1671. return
  1672. }
  1673. connStr := ``
  1674. if bVal >= 0 {
  1675. connStr = `+`
  1676. }
  1677. valStr := fmt.Sprintf("y = %sx %s %s R²=%f", utils.SubFloatToString(aVal, 4), connStr, utils.SubFloatToString(bVal, 4), rVal)
  1678. br.Ret = 200
  1679. br.Success = true
  1680. br.Msg = "计算成功"
  1681. br.Data = valStr
  1682. br.IsAddLog = true
  1683. }
  1684. // @router /custom_analysis/reset [post]
  1685. func (this *CalculateController) ResetCustomAnalysisData() {
  1686. br := new(models.BaseResponse).Init()
  1687. defer func() {
  1688. this.Data["json"] = br
  1689. this.ServeJSON()
  1690. }()
  1691. var req models.ResetCustomAnalysisData
  1692. err := json.Unmarshal(this.Ctx.Input.RequestBody, &req)
  1693. if err != nil {
  1694. br.Msg = "参数解析异常!"
  1695. br.ErrMsg = "参数解析失败,Err:" + err.Error()
  1696. br.IsSendEmail = false
  1697. return
  1698. }
  1699. if req.EdbInfoId <= 0 {
  1700. br.Msg = "请选择指标"
  1701. br.ErrMsg = br.Msg
  1702. br.IsSendEmail = false
  1703. return
  1704. }
  1705. if len(req.DateList) <= 0 {
  1706. br.Msg = "请传入日期序列"
  1707. br.ErrMsg = br.Msg
  1708. br.IsSendEmail = false
  1709. return
  1710. }
  1711. if len(req.DataList) <= 0 {
  1712. br.Msg = "请传入数据序列"
  1713. br.ErrMsg = br.Msg
  1714. br.IsSendEmail = false
  1715. return
  1716. }
  1717. edbInfo, err := models.GetEdbInfoById(req.EdbInfoId)
  1718. if err != nil {
  1719. if err.Error() == utils.ErrNoRow() {
  1720. br.Msg = "指标已被删除,请刷新页面"
  1721. br.ErrMsg = "指标已被删除,请刷新页面:Err:" + err.Error()
  1722. return
  1723. }
  1724. br.Msg = "获取指标信息失败"
  1725. br.ErrMsg = "获取指标信息失败:Err:" + err.Error()
  1726. return
  1727. }
  1728. baseEdbInfoModel := models.CustomAnalysis{}
  1729. err, errMsg := baseEdbInfoModel.ResetData(edbInfo, req.DateList, req.DataList)
  1730. if err != nil {
  1731. br.Msg = "更新数据失败"
  1732. if errMsg != `` {
  1733. br.Msg = errMsg
  1734. }
  1735. br.ErrMsg = "更新数据失败 Err:" + err.Error()
  1736. return
  1737. }
  1738. if edbInfo == nil {
  1739. br.Msg = "更新数据失败"
  1740. br.ErrMsg = "更新数据失败,指标ID错误:"
  1741. return
  1742. }
  1743. err, errMsg = models.UnifiedModifyEdbInfoMaxAndMinInfo(edbInfo)
  1744. if err != nil {
  1745. br.Msg = errMsg
  1746. br.ErrMsg = err.Error()
  1747. return
  1748. }
  1749. resp := models.AddEdbInfoResp{
  1750. EdbInfoId: edbInfo.EdbInfoId,
  1751. UniqueCode: edbInfo.UniqueCode,
  1752. }
  1753. br.Ret = 200
  1754. br.Success = true
  1755. br.Msg = "处理成功"
  1756. br.Data = resp
  1757. br.IsAddLog = true
  1758. }
  1759. // @router /base [post]
  1760. func (this *CalculateController) Calculate() {
  1761. br := new(models.BaseResponse).Init()
  1762. defer func() {
  1763. this.Data["json"] = br
  1764. this.ServeJSON()
  1765. }()
  1766. var req models.BaseCalculateBySearchData
  1767. err := json.Unmarshal(this.Ctx.Input.RequestBody, &req)
  1768. if err != nil {
  1769. br.Msg = "参数解析异常!"
  1770. br.ErrMsg = "参数解析失败,Err:" + err.Error()
  1771. return
  1772. }
  1773. dateDataMap := make(map[time.Time]float64)
  1774. var errMsg string
  1775. dataList, err := models.EdbInfoSearchDataToData(req.DataList)
  1776. if err != nil {
  1777. br.Msg = "计算失败,数据异常!"
  1778. br.ErrMsg = "计算失败,数据异常,Err:" + err.Error()
  1779. return
  1780. }
  1781. baseCalculate := models.BaseCalculate{
  1782. DataList: dataList,
  1783. Frequency: req.Frequency,
  1784. Formula: req.Formula,
  1785. Calendar: req.Calendar,
  1786. MoveType: req.MoveType,
  1787. MoveFrequency: req.MoveFrequency,
  1788. FromFrequency: req.FromFrequency,
  1789. Source: req.Source,
  1790. }
  1791. switch baseCalculate.Source {
  1792. case 1:
  1793. dateDataMap, err, errMsg = baseCalculate.Ljzzy()
  1794. case 2:
  1795. dateDataMap, err, errMsg = baseCalculate.Ljzzj()
  1796. case 3:
  1797. dateDataMap, err, errMsg = baseCalculate.Tbz()
  1798. case 4:
  1799. dateDataMap, err, errMsg = baseCalculate.Tcz()
  1800. case 5:
  1801. dateDataMap, err, errMsg = baseCalculate.Nszydpjjs()
  1802. case 6:
  1803. dateDataMap, err, errMsg = baseCalculate.Hbz()
  1804. case 7:
  1805. dateDataMap, err, errMsg = baseCalculate.Hcz()
  1806. case 8:
  1807. dateDataMap, err, errMsg = baseCalculate.UpFrequency()
  1808. case 9:
  1809. dateDataMap, err, errMsg = baseCalculate.DownFrequency()
  1810. case 10:
  1811. dateDataMap, err, errMsg = baseCalculate.TimeShift()
  1812. case 11:
  1813. dateDataMap, err, errMsg = baseCalculate.Cjjx()
  1814. case 12:
  1815. dateDataMap, err, errMsg = baseCalculate.Annualized()
  1816. case 13:
  1817. dateDataMap, err, errMsg = baseCalculate.Ljz()
  1818. case 14:
  1819. dateDataMap, err, errMsg = baseCalculate.LjzNczj()
  1820. case 15:
  1821. dateDataMap, err, errMsg = baseCalculate.ExponentialSmoothing()
  1822. case 16:
  1823. dateDataMap, err, errMsg = baseCalculate.Rjz()
  1824. default:
  1825. errMsg = "错误的计算类型"
  1826. err = errors.New(errMsg + ":" + strconv.Itoa(baseCalculate.Source))
  1827. }
  1828. if err != nil {
  1829. br.Msg = "计算失败"
  1830. if errMsg != `` {
  1831. br.Msg = errMsg
  1832. }
  1833. br.ErrMsg = err.Error()
  1834. return
  1835. }
  1836. dateStrDataMap, dateList := models.GetDateDataAndDateList(dateDataMap)
  1837. br.Ret = 200
  1838. br.Success = true
  1839. br.Msg = "计算成功"
  1840. br.Data = models.BaseCalculateResp{
  1841. DataMap: dateStrDataMap,
  1842. DateList: dateList,
  1843. }
  1844. br.IsAddLog = true
  1845. }
  1846. // @router /batch/save/multi [post]
  1847. func (this *CalculateController) BatchSaveMulti() {
  1848. br := new(models.BaseResponse).Init()
  1849. defer func() {
  1850. if br.ErrMsg == "" {
  1851. br.IsSendEmail = false
  1852. }
  1853. this.Data["json"] = br
  1854. this.ServeJSON()
  1855. }()
  1856. var req models.CalculateBatchSaveReq
  1857. err := json.Unmarshal(this.Ctx.Input.RequestBody, &req)
  1858. if err != nil {
  1859. br.Msg = "参数解析异常!"
  1860. br.ErrMsg = "参数解析失败,Err:" + err.Error()
  1861. return
  1862. }
  1863. resp := models.BatchEdbInfoCalculateBatchSaveResp{
  1864. Fail: make([]models.BatchEdbInfoCalculateBatchSaveFailResp, 0),
  1865. Success: make([]models.BatchEdbInfoCalculateBatchSaveSuccessResp, 0),
  1866. }
  1867. redisKeyList := make([]string, 0) //需要清理的缓存key列表
  1868. defer func() {
  1869. for _, redisKey := range redisKeyList {
  1870. utils.Rc.Delete(redisKey)
  1871. }
  1872. }()
  1873. var wg sync.WaitGroup
  1874. for _, item := range req.EdbList {
  1875. calculateId := item.CalculateId
  1876. redisKey := fmt.Sprint("edb_info:calculate:batch:save:", req.AdminId, ":", req.Source, ":", calculateId)
  1877. isExist := utils.Rc.IsExist(redisKey)
  1878. if isExist {
  1879. resp.Fail = append(resp.Fail, models.BatchEdbInfoCalculateBatchSaveFailResp{
  1880. CalculateId: calculateId,
  1881. Msg: "指标正在处理,请勿重复提交",
  1882. })
  1883. continue
  1884. } else {
  1885. utils.Rc.SetNX(redisKey, 1, time.Second*300)
  1886. redisKeyList = append(redisKeyList, redisKey)
  1887. }
  1888. wg.Add(1)
  1889. reqItem := models.EdbInfoCalculateBatchSaveReq{
  1890. AdminId: req.AdminId,
  1891. AdminName: req.AdminName,
  1892. EdbInfoId: item.EdbInfoId,
  1893. EdbName: item.EdbName,
  1894. Frequency: item.Frequency,
  1895. Unit: item.Unit,
  1896. ClassifyId: item.ClassifyId,
  1897. Formula: req.Formula, //N数值移动平均计算、环比值、环差值
  1898. FromEdbInfoId: item.FromEdbInfoId,
  1899. CalculateFormula: req.CalculateFormula,
  1900. Source: req.Source,
  1901. MoveType: req.MoveType,
  1902. MoveFrequency: req.MoveFrequency,
  1903. EdbInfoIdArr: req.EdbInfoIdArr,
  1904. Calendar: req.Calendar,
  1905. EmptyType: req.EmptyType,
  1906. MaxEmptyType: req.MaxEmptyType,
  1907. Extra: req.Extra,
  1908. }
  1909. var edbInfo *models.EdbInfo
  1910. uniqueCode := ""
  1911. errMsg := ""
  1912. go func() {
  1913. defer func() {
  1914. if err != nil {
  1915. utils.FileLog.Info(fmt.Sprintf("批量指标计算,保存失败 Err:%v, ErrMsg:%s", err, errMsg))
  1916. resp.Fail = append(resp.Fail, models.BatchEdbInfoCalculateBatchSaveFailResp{
  1917. CalculateId: calculateId,
  1918. Msg: err.Error(),
  1919. ErrMsg: errMsg,
  1920. })
  1921. } else {
  1922. resp.Success = append(resp.Success, models.BatchEdbInfoCalculateBatchSaveSuccessResp{
  1923. ClassifyId: reqItem.ClassifyId,
  1924. CalculateId: calculateId,
  1925. EdbInfoId: edbInfo.EdbInfoId,
  1926. UniqueCode: uniqueCode,
  1927. })
  1928. }
  1929. wg.Done()
  1930. }()
  1931. edbInfo, uniqueCode, err, errMsg = services.EdbCalculateBatchSave(reqItem, this.Lang)
  1932. return
  1933. }()
  1934. }
  1935. wg.Wait()
  1936. if resp.Success != nil && len(resp.Success) > 0 {
  1937. for _, item := range resp.Success {
  1938. go logic.UpdateEs(item.EdbInfoId)
  1939. }
  1940. }
  1941. br.Ret = 200
  1942. br.Success = true
  1943. br.Msg = "保存成功"
  1944. br.Data = resp
  1945. br.IsAddLog = true
  1946. }
  1947. // @router /batch/edit/multi [post]
  1948. func (this *CalculateController) BatchEditMulti() {
  1949. br := new(models.BaseResponse).Init()
  1950. defer func() {
  1951. if br.ErrMsg == "" {
  1952. br.IsSendEmail = false
  1953. }
  1954. this.Data["json"] = br
  1955. this.ServeJSON()
  1956. }()
  1957. var req models.CalculateBatchSaveReq
  1958. err := json.Unmarshal(this.Ctx.Input.RequestBody, &req)
  1959. if err != nil {
  1960. br.Msg = "参数解析异常!"
  1961. br.ErrMsg = "参数解析失败,Err:" + err.Error()
  1962. return
  1963. }
  1964. resp := models.BatchEdbInfoCalculateBatchSaveResp{
  1965. Fail: make([]models.BatchEdbInfoCalculateBatchSaveFailResp, 0),
  1966. Success: make([]models.BatchEdbInfoCalculateBatchSaveSuccessResp, 0),
  1967. }
  1968. redisKeyList := make([]string, 0) //需要清理的缓存key列表
  1969. defer func() {
  1970. for _, redisKey := range redisKeyList {
  1971. utils.Rc.Delete(redisKey)
  1972. }
  1973. }()
  1974. var wg sync.WaitGroup
  1975. for _, item := range req.EdbList {
  1976. calculateId := item.CalculateId
  1977. if item.EdbInfoId <= 0 {
  1978. resp.Fail = append(resp.Fail, models.BatchEdbInfoCalculateBatchSaveFailResp{
  1979. CalculateId: calculateId,
  1980. Msg: "请选择要编辑的指标",
  1981. })
  1982. continue
  1983. }
  1984. redisKey := fmt.Sprint("edb_info:calculate:batch:edit:", req.AdminId, ":", req.Source, ":", item.EdbInfoId)
  1985. isExist := utils.Rc.IsExist(redisKey)
  1986. if isExist {
  1987. resp.Fail = append(resp.Fail, models.BatchEdbInfoCalculateBatchSaveFailResp{
  1988. CalculateId: calculateId,
  1989. Msg: "指标正在处理,请勿重复提交",
  1990. })
  1991. continue
  1992. } else {
  1993. utils.Rc.SetNX(redisKey, 1, time.Second*300)
  1994. redisKeyList = append(redisKeyList, redisKey)
  1995. }
  1996. wg.Add(1)
  1997. reqItem := models.EdbInfoCalculateBatchEditReq{
  1998. EdbInfoId: item.EdbInfoId,
  1999. EdbName: item.EdbName,
  2000. Frequency: item.Frequency,
  2001. Unit: item.Unit,
  2002. ClassifyId: item.ClassifyId,
  2003. AdminId: req.AdminId,
  2004. AdminName: req.AdminName,
  2005. Formula: req.Formula, //N数值移动平均计算、环比值、环差值
  2006. FromEdbInfoId: item.FromEdbInfoId,
  2007. CalculateFormula: req.CalculateFormula,
  2008. Source: req.Source,
  2009. MoveType: req.MoveType,
  2010. MoveFrequency: req.MoveFrequency,
  2011. EdbInfoIdArr: req.EdbInfoIdArr,
  2012. Calendar: req.Calendar,
  2013. EmptyType: req.EmptyType,
  2014. MaxEmptyType: req.MaxEmptyType,
  2015. Extra: req.Extra,
  2016. }
  2017. var errMsg string
  2018. var edbInfo *models.EdbInfo
  2019. uniqueCode := ""
  2020. go func() {
  2021. defer func() {
  2022. if err != nil {
  2023. utils.FileLog.Info(fmt.Sprintf("批量指标计算,保存失败 Err:%v, ErrMsg:%s", err, errMsg))
  2024. resp.Fail = append(resp.Fail, models.BatchEdbInfoCalculateBatchSaveFailResp{
  2025. CalculateId: calculateId,
  2026. Msg: err.Error(),
  2027. ErrMsg: errMsg,
  2028. })
  2029. } else {
  2030. resp.Success = append(resp.Success, models.BatchEdbInfoCalculateBatchSaveSuccessResp{
  2031. ClassifyId: reqItem.ClassifyId,
  2032. CalculateId: calculateId,
  2033. EdbInfoId: edbInfo.EdbInfoId,
  2034. UniqueCode: uniqueCode,
  2035. })
  2036. }
  2037. wg.Done()
  2038. }()
  2039. edbInfo, uniqueCode, err, errMsg = services.EdbCalculateBatchEdit(reqItem)
  2040. return
  2041. }()
  2042. }
  2043. wg.Wait()
  2044. if err != nil {
  2045. br.Msg = "批量指标计算,保存失败"
  2046. br.ErrMsg = "批量指标计算,保存失败,Err:" + err.Error()
  2047. return
  2048. }
  2049. if resp.Success != nil && len(resp.Success) > 0 {
  2050. for _, item := range resp.Success {
  2051. go logic.UpdateEs(item.EdbInfoId)
  2052. }
  2053. }
  2054. br.Ret = 200
  2055. br.Success = true
  2056. br.Msg = "保存成功"
  2057. br.Data = resp
  2058. br.IsAddLog = true
  2059. }
  2060. // @router /base/step_calculate [post]
  2061. func (this *CalculateController) StepCalculate() {
  2062. br := new(models.BaseResponse).Init()
  2063. defer func() {
  2064. if br.ErrMsg == "" {
  2065. br.IsSendEmail = false
  2066. }
  2067. this.Data["json"] = br
  2068. this.ServeJSON()
  2069. }()
  2070. var req models.StepCalculateBySearchData
  2071. if e := json.Unmarshal(this.Ctx.Input.RequestBody, &req); e != nil {
  2072. br.Msg = "参数解析异常"
  2073. br.ErrMsg = fmt.Sprintf("参数解析失败, Err: %v", e)
  2074. return
  2075. }
  2076. resultData, dates, errMsg, e := services.StepCalculate(req.DataList, req.Calculates)
  2077. if e != nil {
  2078. br.Msg = "计算失败"
  2079. if errMsg != "" {
  2080. br.Msg = errMsg
  2081. }
  2082. br.ErrMsg = fmt.Sprintf("分步骤计算失败, Err: %v", e)
  2083. return
  2084. }
  2085. br.Ret = 200
  2086. br.Success = true
  2087. br.Msg = "计算成功"
  2088. br.Data = models.BaseCalculateResp{
  2089. DataMap: resultData,
  2090. DateList: dates,
  2091. }
  2092. br.IsAddLog = true
  2093. }