base_from_mysteel_chemical.go 23 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854
  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/services"
  7. "eta/eta_index_lib/utils"
  8. "fmt"
  9. "strconv"
  10. "time"
  11. )
  12. // MySteelChemicalController 钢联化工
  13. type MySteelChemicalController struct {
  14. BaseAuthController
  15. }
  16. // Add
  17. // @Title 新增钢联化工指标接口
  18. // @Description 新增钢联化工指标接口
  19. // @Success 200 {object} models.AddEdbInfoReq
  20. // @router /add [post]
  21. func (this *MySteelChemicalController) Add() {
  22. br := new(models.BaseResponse).Init()
  23. var cacheKey string
  24. defer func() {
  25. utils.Rc.Delete(cacheKey)
  26. this.Data["json"] = br
  27. this.ServeJSON()
  28. }()
  29. source := utils.DATA_SOURCE_MYSTEEL_CHEMICAL
  30. var req models.AddEdbInfoReq
  31. err := json.Unmarshal(this.Ctx.Input.RequestBody, &req)
  32. if err != nil {
  33. br.Msg = "参数解析异常!"
  34. br.ErrMsg = "参数解析失败,Err:" + err.Error()
  35. return
  36. }
  37. if req.EdbCode == "" {
  38. br.Msg = "请输入指标编码!"
  39. br.ErrMsg = "请输入指标编码,指标编码为空"
  40. return
  41. }
  42. cacheKey = utils.CACHE_EDB_DATA_ADD + strconv.Itoa(source) + "_" + req.EdbCode
  43. if !utils.Rc.IsExist(cacheKey) {
  44. utils.Rc.SetNX(cacheKey, 1, 1*time.Minute)
  45. err = models.AddEdbDataFromMysteelChemical(req.EdbCode)
  46. if err != nil {
  47. br.Msg = "获取指标信息失败!"
  48. br.ErrMsg = "获取指标信息失败 AddEdbDataFromMysteelChemical,Err:" + err.Error()
  49. return
  50. }
  51. br.Ret = 200
  52. br.Success = true
  53. br.Msg = "获取成功"
  54. } else {
  55. br.Ret = 501
  56. br.Success = true
  57. br.Msg = "系统处理中,请稍后重试"
  58. }
  59. }
  60. // Refresh
  61. // @Title 刷新钢联化工指标接口
  62. // @Description 刷新钢联化工指标接口
  63. // @Success 200 {object} models.RefreshEdbInfoReq
  64. // @router /refresh [post]
  65. func (this *MySteelChemicalController) Refresh() {
  66. br := new(models.BaseResponse).Init()
  67. var cacheKey string
  68. defer func() {
  69. utils.Rc.Delete(cacheKey)
  70. this.Data["json"] = br
  71. this.ServeJSON()
  72. }()
  73. source := utils.DATA_SOURCE_MYSTEEL_CHEMICAL
  74. var req models.RefreshEdbInfoReq
  75. err := json.Unmarshal(this.Ctx.Input.RequestBody, &req)
  76. if err != nil {
  77. br.Msg = "参数解析异常!"
  78. br.ErrMsg = "参数解析失败,Err:" + err.Error()
  79. return
  80. }
  81. if req.EdbCode == "" {
  82. br.Msg = "请输入指标编码!"
  83. br.ErrMsg = "请输入指标编码,指标编码为空"
  84. return
  85. }
  86. if req.EdbInfoId < 0 {
  87. br.Msg = "请输入指标ID!"
  88. br.ErrMsg = "请输入指标ID"
  89. return
  90. }
  91. cacheKey = utils.CACHE_EDB_DATA_REFRESH + strconv.Itoa(source) + "_" + req.EdbCode
  92. if utils.Rc.IsExist(cacheKey) {
  93. br.Ret = 501
  94. br.Success = true
  95. br.Msg = "系统处理中,请稍后重试"
  96. return
  97. }
  98. dataUpdateTime := time.Now().Format(utils.FormatDateTime)
  99. utils.Rc.SetNX(cacheKey, 1, 1*time.Minute)
  100. // 将数据刷新到BaseFromMysteelChemicalData
  101. err = services.RefreshDataFromMysteelChemical(req.EdbCode, utils.GetEdbRefreshStartDate(req.StartDate), utils.BASE_END_DATE)
  102. if err != nil {
  103. br.Msg = "获取指标信息失败!"
  104. br.ErrMsg = "获取指标信息失败 RefreshDataFromMysteelChemical,Err:" + err.Error()
  105. return
  106. }
  107. err = models.RefreshEdbDataFromMysteelChemical(req.EdbInfoId, req.EdbCode, req.StartDate)
  108. if err != nil && err.Error() != utils.ErrNoRow() {
  109. br.Msg = "刷新指标信息失败!"
  110. br.ErrMsg = "刷新指标信息失败 RefreshEdbDataFromMysteel,Err:" + err.Error()
  111. return
  112. }
  113. if req.EdbInfoId != 0 {
  114. // 获取指标详情
  115. edbInfo, err := models.GetEdbInfoByEdbCode(source, req.EdbCode)
  116. if err != nil {
  117. br.Msg = "指标不存在!"
  118. br.ErrMsg = "指标不存在"
  119. return
  120. }
  121. // 更新指标最大最小值
  122. erDataUpdateDate, err, errMsg := models.UnifiedModifyEdbInfoMaxAndMinInfoDataUpdate(edbInfo, dataUpdateTime)
  123. if err != nil {
  124. br.Msg = errMsg
  125. br.ErrMsg = err.Error()
  126. return
  127. }
  128. // 添加指标刷新成功日志
  129. if erDataUpdateDate != "" {
  130. _ = services.AddEdbInfoUpdateLog(edbInfo.EdbInfoId, 1, "", 1, "", 0, 0)
  131. } else {
  132. _ = services.AddEdbInfoUpdateLog(edbInfo.EdbInfoId, 1, "", 2, "未刷新到数据", 0, 0)
  133. }
  134. // 更新ES
  135. go logic.UpdateEs(edbInfo.EdbInfoId)
  136. }
  137. if utils.MysteelChemicalApiToken != "" {
  138. // 钢联走api接口,那就更新数据源明细表
  139. _ = services.SetMysteelChemicalEdbInfoUpdateStat(false)
  140. _ = services.SetEdbSourceStat(false)
  141. }
  142. br.Ret = 200
  143. br.Success = true
  144. br.Msg = "获取成功"
  145. }
  146. // @Title 查询刷新钢联指标的接口
  147. // @Description 查询刷新钢联指标的接口
  148. // @Success 200 {object} models.CheckDeleteClassifyResp
  149. // @router /query/refresh [post]
  150. func (this *MySteelChemicalController) QueryRefresh() {
  151. br := new(models.BaseResponse).Init()
  152. defer func() {
  153. this.Data["json"] = br
  154. this.ServeJSON()
  155. }()
  156. mysteelIndex := new(models.BaseFromMysteelChemicalIndex)
  157. list, err := mysteelIndex.GetIndexRefreshAllByMergeFile()
  158. if err != nil && err.Error() != utils.ErrNoRow() {
  159. br.Msg = "获取失败!"
  160. br.ErrMsg = "获取失败,Err:" + err.Error()
  161. return
  162. }
  163. if list == nil {
  164. list = make([]*models.BaseFromMysteelChemicalIndex, 0)
  165. }
  166. br.Ret = 200
  167. br.Data = list
  168. br.Success = true
  169. br.Msg = "获取成功"
  170. }
  171. // @Title 处理钢联指标的接口
  172. // @Description 处理钢联指标的接口
  173. // @Success 200 {object} models.HandleMysteelIndexResp
  174. // @router /handle/mysteel/index [post]
  175. func (this *MySteelChemicalController) HandleMysteelIndex() {
  176. br := new(models.BaseResponse).Init()
  177. defer func() {
  178. this.Data["json"] = br
  179. this.ServeJSON()
  180. }()
  181. body := this.Ctx.Input.RequestBody
  182. var req models.HandleMysteelIndexResp
  183. err := json.Unmarshal(body, &req)
  184. if err != nil {
  185. br.Msg = "参数解析异常!"
  186. br.ErrMsg = "参数解析失败,Err:" + err.Error()
  187. return
  188. }
  189. err = services.HandleMysteelIndex(&req)
  190. if err != nil {
  191. fmt.Println("HandleMysteelIndex Err:" + err.Error())
  192. br.Msg = "处理失败"
  193. br.ErrMsg = "处理失败,Err:" + err.Error()
  194. return
  195. }
  196. br.Ret = 200
  197. br.Success = true
  198. br.Msg = "处理成功"
  199. }
  200. // @Title 处理钢联指标的接口
  201. // @Description 处理钢联指标的接口
  202. // @Success 200 {object} models.HandleMysteelIndexResp
  203. // @router /handle/api/mysteel/index [post]
  204. func (this *MySteelChemicalController) HandleApiMysteelIndex() {
  205. br := new(models.BaseResponse).Init()
  206. defer func() {
  207. this.Data["json"] = br
  208. this.ServeJSON()
  209. }()
  210. body := this.Ctx.Input.RequestBody
  211. var req models.HandleMysteelIndexResp
  212. err := json.Unmarshal(body, &req)
  213. if err != nil {
  214. br.Msg = "参数解析异常!"
  215. br.ErrMsg = "参数解析失败,Err:" + err.Error()
  216. return
  217. }
  218. errMsg, err := services.HandleApiMysteelIndex(&req)
  219. if err != nil {
  220. fmt.Println("HandleMysteelIndex Err:" + err.Error())
  221. if errMsg == "" {
  222. br.Msg = "数据获取失败"
  223. } else {
  224. br.Msg = errMsg
  225. }
  226. br.ErrMsg = "处理失败,Err:" + err.Error()
  227. return
  228. }
  229. br.Ret = 200
  230. br.Success = true
  231. br.Msg = "处理成功"
  232. }
  233. // GetMaxFileIndex
  234. // @Title 获取最大的文件编号下标
  235. // @Description 获取最大的文件编号下标
  236. // @Success 200 {object} models.HandleMysteelIndexResp
  237. // @router /getMaxFileIndex [post]
  238. func (this *MySteelChemicalController) GetMaxFileIndex() {
  239. br := new(models.BaseResponse).Init()
  240. defer func() {
  241. this.Data["json"] = br
  242. this.ServeJSON()
  243. }()
  244. var req models.GetMaxFileIndexReq
  245. err := json.Unmarshal(this.Ctx.Input.RequestBody, &req)
  246. if err != nil {
  247. br.Msg = "参数解析异常!"
  248. br.ErrMsg = "参数解析失败,Err:" + err.Error()
  249. return
  250. }
  251. indexObj := new(models.BaseFromMysteelChemicalIndex)
  252. // 获取最大的文件编号下标
  253. item, err := indexObj.GetMaxFileIndex(req.Frequency)
  254. if err != nil {
  255. return
  256. }
  257. br.Data = item
  258. br.Ret = 200
  259. br.Success = true
  260. br.Msg = "处理成功"
  261. }
  262. // GetNoMergeIndexByFrequencyCount
  263. // @Title 获取未合并的指标总数量
  264. // @Description 获取未合并的指标总数量
  265. // @Success 200 {object} models.HandleMysteelIndexResp
  266. // @router /getNoMergeIndexByFrequencyCount [post]
  267. func (this *MySteelChemicalController) GetNoMergeIndexByFrequencyCount() {
  268. br := new(models.BaseResponse).Init()
  269. defer func() {
  270. this.Data["json"] = br
  271. this.ServeJSON()
  272. }()
  273. var req models.GetMaxFileIndexReq
  274. err := json.Unmarshal(this.Ctx.Input.RequestBody, &req)
  275. if err != nil {
  276. br.Msg = "参数解析异常!"
  277. br.ErrMsg = "参数解析失败,Err:" + err.Error()
  278. return
  279. }
  280. indexObj := new(models.BaseFromMysteelChemicalIndex)
  281. // 获取未合并的指标总数量
  282. indexTotal, err := indexObj.GetNoMergeIndexByFrequencyCount(req.Frequency)
  283. if err != nil {
  284. return
  285. }
  286. br.Data = indexTotal
  287. br.Ret = 200
  288. br.Success = true
  289. br.Msg = "处理成功"
  290. }
  291. // GetNoMergeIndexByFrequencyPage
  292. // @Title 获取未合并的指标列表
  293. // @Description 获取未合并的指标列表
  294. // @Success 200 {object} models.HandleMysteelIndexResp
  295. // @router /getNoMergeIndexByFrequencyPage [post]
  296. func (this *MySteelChemicalController) GetNoMergeIndexByFrequencyPage() {
  297. br := new(models.BaseResponse).Init()
  298. defer func() {
  299. this.Data["json"] = br
  300. this.ServeJSON()
  301. }()
  302. var req models.GetNoMergeIndexByFrequencyPageReq
  303. err := json.Unmarshal(this.Ctx.Input.RequestBody, &req)
  304. if err != nil {
  305. br.Msg = "参数解析异常!"
  306. br.ErrMsg = "参数解析失败,Err:" + err.Error()
  307. return
  308. }
  309. indexObj := new(models.BaseFromMysteelChemicalIndex)
  310. // 获取未合并的指标总数量
  311. indexTotal, err := indexObj.GetNoMergeIndexByFrequencyPage(req.Frequency, req.Limit)
  312. if err != nil {
  313. return
  314. }
  315. br.Data = indexTotal
  316. br.Ret = 200
  317. br.Success = true
  318. br.Msg = "处理成功"
  319. }
  320. // GetIndexCountByMergeFilePath
  321. // @Title 获取该文件下标已经存在多少的指标
  322. // @Description 获取该文件下标已经存在多少的指标
  323. // @Success 200 {object} models.HandleMysteelIndexResp
  324. // @router /getIndexCountByMergeFilePath [post]
  325. func (this *MySteelChemicalController) GetIndexCountByMergeFilePath() {
  326. br := new(models.BaseResponse).Init()
  327. defer func() {
  328. this.Data["json"] = br
  329. this.ServeJSON()
  330. }()
  331. var req models.GetIndexCountByMergeFilePathReq
  332. err := json.Unmarshal(this.Ctx.Input.RequestBody, &req)
  333. if err != nil {
  334. br.Msg = "参数解析异常!"
  335. br.ErrMsg = "参数解析失败,Err:" + err.Error()
  336. return
  337. }
  338. if req.MergeFilePath == "" {
  339. br.Msg = "参数有误"
  340. br.ErrMsg = "参数有误, 文件路径有误"
  341. return
  342. }
  343. indexObj := new(models.BaseFromMysteelChemicalIndex)
  344. indexTotal, err := indexObj.GetIndexCountByMergeFilePath(req.MergeFilePath)
  345. if err != nil {
  346. return
  347. }
  348. br.Data = indexTotal
  349. br.Ret = 200
  350. br.Success = true
  351. br.Msg = "获取成功"
  352. }
  353. // GetIndexCreate
  354. // @Title 获取两分钟前新增的指标
  355. // @Description 获取两分钟前新增的指标
  356. // @Success 200 {object} models.BaseFromMysteelChemicalIndex
  357. // @router /getIndexCreate [post]
  358. func (this *MySteelChemicalController) GetIndexCreate() {
  359. br := new(models.BaseResponse).Init()
  360. defer func() {
  361. this.Data["json"] = br
  362. this.ServeJSON()
  363. }()
  364. // 终端编码
  365. terminalCode := this.GetString("TerminalCode")
  366. indexObj := new(models.BaseFromMysteelChemicalIndex)
  367. items, err := indexObj.GetIndexCreate(terminalCode)
  368. if err != nil {
  369. br.Msg = "获取失败"
  370. br.ErrMsg = "获取指标失败, Err: " + err.Error()
  371. return
  372. }
  373. if items == nil {
  374. items = make([]*models.BaseFromMysteelChemicalIndex, 0)
  375. }
  376. br.Data = items
  377. br.Ret = 200
  378. br.Success = true
  379. br.Msg = "获取成功"
  380. }
  381. // GetIndexRefreshMethanolByMergeFile
  382. // @Title 获取需要刷新的甲醇文件
  383. // @Description 获取需要刷新的甲醇文件
  384. // @Success 200 {object} models.BaseFromMysteelChemicalIndex
  385. // @router /getIndexRefreshMethanolByMergeFile [post]
  386. func (this *MySteelChemicalController) GetIndexRefreshMethanolByMergeFile() {
  387. br := new(models.BaseResponse).Init()
  388. defer func() {
  389. this.Data["json"] = br
  390. this.ServeJSON()
  391. }()
  392. indexObj := new(models.BaseFromMysteelChemicalIndex)
  393. items, err := indexObj.GetIndexRefreshMethanolByMergeFile()
  394. if err != nil {
  395. br.Msg = "获取失败"
  396. br.ErrMsg = "获取指标失败, Err: " + err.Error()
  397. return
  398. }
  399. if items == nil {
  400. items = make([]*models.BaseFromMysteelChemicalIndex, 0)
  401. }
  402. br.Data = items
  403. br.Ret = 200
  404. br.Success = true
  405. br.Msg = "获取成功"
  406. }
  407. // GetIndexRefreshMethanolByTimely
  408. // @Title 获取需要及时刷新的文件
  409. // @Description 获取需要及时刷新的文件
  410. // @Success 200 {object} models.BaseFromMysteelChemicalIndex
  411. // @router /getIndexRefreshMethanolByTimely [post]
  412. func (this *MySteelChemicalController) GetIndexRefreshMethanolByTimely() {
  413. br := new(models.BaseResponse).Init()
  414. defer func() {
  415. this.Data["json"] = br
  416. this.ServeJSON()
  417. }()
  418. indexObj := new(models.BaseFromMysteelChemicalIndex)
  419. items, err := indexObj.GetIndexRefreshMethanolByTimely()
  420. if err != nil {
  421. br.Msg = "获取失败"
  422. br.ErrMsg = "获取指标失败, Err: " + err.Error()
  423. return
  424. }
  425. if items == nil {
  426. items = make([]*models.BaseFromMysteelChemicalIndex, 0)
  427. }
  428. br.Data = items
  429. br.Ret = 200
  430. br.Success = true
  431. br.Msg = "获取成功"
  432. }
  433. // GetIndexByFrequency
  434. // @Title 根据频率获取指标
  435. // @Description 根据频率获取指标
  436. // @Success 200 {object} models.BaseFromMysteelChemicalIndex
  437. // @router /getIndexByFrequency [post]
  438. func (this *MySteelChemicalController) GetIndexByFrequency() {
  439. br := new(models.BaseResponse).Init()
  440. defer func() {
  441. this.Data["json"] = br
  442. this.ServeJSON()
  443. }()
  444. var req models.GetIndexByFrequencyReq
  445. err := json.Unmarshal(this.Ctx.Input.RequestBody, &req)
  446. if err != nil {
  447. br.Msg = "参数解析异常!"
  448. br.ErrMsg = "参数解析失败,Err:" + err.Error()
  449. return
  450. }
  451. if req.Frequency == "" {
  452. br.Msg = "参数有误"
  453. br.ErrMsg = "参数有误"
  454. return
  455. }
  456. indexObj := new(models.BaseFromMysteelChemicalIndex)
  457. items, err := indexObj.GetIndexByFrequency(req.Frequency)
  458. if err != nil {
  459. br.Msg = "获取失败"
  460. br.ErrMsg = "获取指标失败, Err: " + err.Error()
  461. return
  462. }
  463. if items == nil {
  464. items = make([]*models.BaseFromMysteelChemicalIndex, 0)
  465. }
  466. br.Data = items
  467. br.Ret = 200
  468. br.Success = true
  469. br.Msg = "获取成功"
  470. }
  471. // GetIndexRefreshWeek
  472. // @Title 根据周获取指标
  473. // @Description 根据周获取指标
  474. // @Success 200 {object} models.BaseFromMysteelChemicalIndex
  475. // @router /getIndexRefreshWeek [post]
  476. func (this *MySteelChemicalController) GetIndexRefreshWeek() {
  477. br := new(models.BaseResponse).Init()
  478. defer func() {
  479. this.Data["json"] = br
  480. this.ServeJSON()
  481. }()
  482. var req models.GetIndexRefreshWeekReq
  483. err := json.Unmarshal(this.Ctx.Input.RequestBody, &req)
  484. if err != nil {
  485. br.Msg = "参数解析异常!"
  486. br.ErrMsg = "参数解析失败,Err:" + err.Error()
  487. return
  488. }
  489. if req.NowWeekZn == "" || req.StartTime == "" || req.EndTime == "" {
  490. br.Msg = "参数有误"
  491. br.ErrMsg = "参数有误"
  492. return
  493. }
  494. indexObj := new(models.BaseFromMysteelChemicalIndex)
  495. items, err := indexObj.GetIndexRefreshWeek(req.NowWeekZn, req.StartTime, req.EndTime)
  496. if err != nil {
  497. br.Msg = "获取失败"
  498. br.ErrMsg = "获取指标失败, Err: " + err.Error()
  499. return
  500. }
  501. if items == nil {
  502. items = make([]*models.BaseFromMysteelChemicalIndex, 0)
  503. }
  504. br.Data = items
  505. br.Ret = 200
  506. br.Success = true
  507. br.Msg = "获取成功"
  508. }
  509. // UpdateIndex
  510. // @Title 更新指标
  511. // @Description 更新指标
  512. // @Success 200 string "操作成功"
  513. // @router /updateIndex [post]
  514. //func (this *MySteelChemicalController) UpdateIndex() {
  515. // br := new(models.BaseResponse).Init()
  516. // defer func() {
  517. // this.Data["json"] = br
  518. // this.ServeJSON()
  519. // }()
  520. // var req models.UpdateIndexReq
  521. // err := json.Unmarshal(this.Ctx.Input.RequestBody, &req)
  522. // if err != nil {
  523. // br.Msg = "参数解析异常!"
  524. // br.ErrMsg = "参数解析失败,Err:" + err.Error()
  525. // return
  526. // }
  527. // if req.Item == nil {
  528. // br.Msg = "参数有误"
  529. // br.ErrMsg = "参数有误, 指标信息有误"
  530. // return
  531. // }
  532. // if len(req.UpdateCols) == 0 {
  533. // br.Msg = "参数有误"
  534. // br.ErrMsg = "参数有误, 无更新字段"
  535. // return
  536. // }
  537. //
  538. // // 更新指标
  539. // indexObj := new(models.BaseFromMysteelChemicalIndex)
  540. // err = indexObj.UpdateIndex(req.Item, req.UpdateCols)
  541. // if err != nil {
  542. // br.Msg = "操作失败"
  543. // br.ErrMsg = "批量更新指标失败, MultiUpdateIndexByIndexCode err: " + err.Error()
  544. // return
  545. // }
  546. //
  547. // br.Ret = 200
  548. // br.Success = true
  549. // br.Msg = "操作成功"
  550. //}
  551. // MultiUpdateIndex
  552. // @Title 批量更新指标
  553. // @Description 批量更新指标
  554. // @Success 200 string "操作成功"
  555. // @router /multiUpdateIndex [post]
  556. func (this *MySteelChemicalController) MultiUpdateIndex() {
  557. br := new(models.BaseResponse).Init()
  558. defer func() {
  559. this.Data["json"] = br
  560. this.ServeJSON()
  561. }()
  562. var req []models.UpdateIndexReq
  563. err := json.Unmarshal(this.Ctx.Input.RequestBody, &req)
  564. if err != nil {
  565. br.Msg = "参数解析异常!"
  566. br.ErrMsg = "参数解析失败,Err:" + err.Error()
  567. return
  568. }
  569. if len(req) == 0 {
  570. br.Msg = "参数有误"
  571. br.ErrMsg = "参数有误, 无指标需要更新"
  572. return
  573. }
  574. // 批量更新指标
  575. indexObj := new(models.BaseFromMysteelChemicalIndex)
  576. err = indexObj.MultiUpdateIndex(req)
  577. if err != nil {
  578. br.Msg = "操作失败"
  579. br.ErrMsg = "批量更新指标失败, MultiUpdateIndex err: " + err.Error()
  580. return
  581. }
  582. br.Ret = 200
  583. br.Success = true
  584. br.Msg = "操作成功"
  585. }
  586. // AddMysteelIndex
  587. // @Title 处理钢联指标的接口
  588. // @Description 处理钢联指标的接口
  589. // @Success 200 {object} models.AddMysteelIndexResp
  590. // @router /add/mysteel/index [post]
  591. func (this *MySteelChemicalController) AddMysteelIndex() {
  592. br := new(models.BaseResponse).Init()
  593. defer func() {
  594. this.Data["json"] = br
  595. this.ServeJSON()
  596. }()
  597. var req models.AddMysteelIndexResp
  598. err := json.Unmarshal(this.Ctx.Input.RequestBody, &req)
  599. if err != nil {
  600. br.Msg = "参数解析异常!"
  601. br.ErrMsg = "参数解析失败,Err:" + err.Error()
  602. return
  603. }
  604. mysteelIndexObj := new(models.BaseFromMysteelChemicalIndex)
  605. indexItem, err := mysteelIndexObj.GetIndexItem(req.EdbCode)
  606. var isAdd bool
  607. if err != nil {
  608. if err.Error() == utils.ErrNoRow() {
  609. isAdd = true
  610. } else {
  611. br.Msg = "判断指标是否存在失败"
  612. br.ErrMsg = "判断指标是否存在失败,Err:" + err.Error()
  613. return
  614. }
  615. }
  616. if indexItem == nil {
  617. isAdd = true
  618. }
  619. if isAdd {
  620. mysteelIndexObj.IndexCode = req.EdbCode
  621. mysteelIndexObj.TerminalCode = req.TerminalCode
  622. mysteelIndexObj.BaseFromMysteelChemicalClassifyId = req.BaseFromMysteelChemicalClassifyId
  623. mysteelIndexObj.SysUserId = req.SysUserId
  624. mysteelIndexObj.SysUserRealName = req.SysUserRealName
  625. mysteelIndexObj.CreateTime = time.Now()
  626. mysteelIndexObj.ModifyTime = time.Now()
  627. err = mysteelIndexObj.Add()
  628. if err != nil {
  629. br.Msg = "新增指标失败"
  630. br.ErrMsg = "新增指标失败,Err:" + err.Error()
  631. return
  632. }
  633. }
  634. br.Ret = 200
  635. br.Success = true
  636. br.Msg = "新增成功"
  637. }
  638. // GetIndexDetailByCode
  639. // @Title 获取指标详情
  640. // @Description 获取指标详情
  641. // @Success 200 {object} models.GetIndexDetailReq
  642. // @router /index_detail [post]
  643. func (this *MySteelChemicalController) GetIndexDetailByCode() {
  644. br := new(models.BaseResponse).Init()
  645. defer func() {
  646. this.Data["json"] = br
  647. this.ServeJSON()
  648. }()
  649. var req models.GetIndexDetailReq
  650. err := json.Unmarshal(this.Ctx.Input.RequestBody, &req)
  651. if err != nil {
  652. br.Msg = "参数解析异常!"
  653. br.ErrMsg = "参数解析失败,Err:" + err.Error()
  654. return
  655. }
  656. if req.IndexCode == "" {
  657. br.Msg = "参数有误"
  658. br.ErrMsg = "参数有误"
  659. return
  660. }
  661. indexObj := new(models.BaseFromMysteelChemicalIndex)
  662. item, err := indexObj.GetIndexItem(req.IndexCode)
  663. if err != nil {
  664. br.Msg = "获取失败"
  665. br.ErrMsg = "获取指标失败, Err: " + err.Error()
  666. return
  667. }
  668. br.Data = item
  669. br.Ret = 200
  670. br.Success = true
  671. br.Msg = "获取成功"
  672. }
  673. // GetIndexCountByFrequency
  674. // @Title 根据频度获取指标总数量
  675. // @Description 根据频度获取指标总数量
  676. // @Success 200 {object} models.HandleMysteelIndexResp
  677. // @router /getIndexCountByFrequency [post]
  678. func (this *MySteelChemicalController) GetIndexCountByFrequency() {
  679. br := new(models.BaseResponse).Init()
  680. defer func() {
  681. this.Data["json"] = br
  682. this.ServeJSON()
  683. }()
  684. var req models.GetMaxFileIndexReq
  685. err := json.Unmarshal(this.Ctx.Input.RequestBody, &req)
  686. if err != nil {
  687. br.Msg = "参数解析异常!"
  688. br.ErrMsg = "参数解析失败,Err:" + err.Error()
  689. return
  690. }
  691. var condition string
  692. var pars []interface{}
  693. if req.Frequency != "" {
  694. condition += ` AND frequency = ? `
  695. pars = append(pars, req.Frequency)
  696. }
  697. if req.EndDate != "" {
  698. condition += ` AND end_date < ? `
  699. pars = append(pars, req.EndDate)
  700. }
  701. // 终端编码
  702. condition += ` AND terminal_code = ? `
  703. pars = append(pars, req.TerminalCode)
  704. condition += ` AND is_stop = 0 `
  705. indexObj := new(models.BaseFromMysteelChemicalIndex)
  706. // 获取未合并的指标总数量
  707. indexTotal, err := indexObj.GetIndexCountByFrequency(condition, pars)
  708. if err != nil {
  709. return
  710. }
  711. br.Data = indexTotal
  712. br.Ret = 200
  713. br.Success = true
  714. br.Msg = "处理成功"
  715. }
  716. // GetIndexLimitByFrequency
  717. // @Title 获取未合并的指标列表
  718. // @Description 获取未合并的指标列表
  719. // @Success 200 {object} models.HandleMysteelIndexResp
  720. // @router /getIndexLimitByFrequency [post]
  721. func (this *MySteelChemicalController) GetIndexLimitByFrequency() {
  722. br := new(models.BaseResponse).Init()
  723. defer func() {
  724. this.Data["json"] = br
  725. this.ServeJSON()
  726. }()
  727. var req models.GetNoMergeIndexByFrequencyPageReq
  728. err := json.Unmarshal(this.Ctx.Input.RequestBody, &req)
  729. if err != nil {
  730. br.Msg = "参数解析异常!"
  731. br.ErrMsg = "参数解析失败,Err:" + err.Error()
  732. return
  733. }
  734. indexObj := new(models.BaseFromMysteelChemicalIndex)
  735. // 获取未合并的指标总数量
  736. indexTotal, err := indexObj.GetIndexLimitByFrequency(req.Frequency, req.Limit)
  737. if err != nil {
  738. return
  739. }
  740. br.Data = indexTotal
  741. br.Ret = 200
  742. br.Success = true
  743. br.Msg = "处理成功"
  744. }
  745. // GetIndexPageByFrequency
  746. // @Title 获取钢联指标分页数据
  747. // @Description 获取钢联指标分页数据
  748. // @Success 200 {object} models.HandleMysteelIndexResp
  749. // @router /getIndexPageByFrequency [post]
  750. func (this *MySteelChemicalController) GetIndexPageByFrequency() {
  751. br := new(models.BaseResponse).Init()
  752. defer func() {
  753. this.Data["json"] = br
  754. this.ServeJSON()
  755. }()
  756. var req models.GetIndexPageByFrequencyPageReq
  757. err := json.Unmarshal(this.Ctx.Input.RequestBody, &req)
  758. if err != nil {
  759. br.Msg = "参数解析异常!"
  760. br.ErrMsg = "参数解析失败,Err:" + err.Error()
  761. return
  762. }
  763. var condition string
  764. var pars []interface{}
  765. if req.Frequency != "" {
  766. condition += ` AND frequency = ? `
  767. pars = append(pars, req.Frequency)
  768. }
  769. if req.EndDate != "" {
  770. condition += ` AND end_date < ? `
  771. pars = append(pars, req.EndDate)
  772. }
  773. // 终端编码
  774. condition += ` AND terminal_code = ? `
  775. pars = append(pars, req.TerminalCode)
  776. condition += ` AND is_stop = 0 `
  777. indexObj := new(models.BaseFromMysteelChemicalIndex)
  778. // 获取未合并的指标总数量
  779. indexTotal, err := indexObj.GetIndexPageByFrequency(condition, pars, req.StartSize, req.PageSize)
  780. if err != nil {
  781. return
  782. }
  783. br.Data = indexTotal
  784. br.Ret = 200
  785. br.Success = true
  786. br.Msg = "处理成功"
  787. }