base_from_mysteel_chemical.go 15 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565
  1. package controllers
  2. import (
  3. "encoding/json"
  4. "hongze/hongze_edb_lib/logic"
  5. "hongze/hongze_edb_lib/models"
  6. "hongze/hongze_edb_lib/services"
  7. "hongze/hongze_edb_lib/utils"
  8. "strconv"
  9. "time"
  10. )
  11. // MySteelChemicalController 钢联化工
  12. type MySteelChemicalController struct {
  13. BaseAuthController
  14. }
  15. // Add
  16. // @Title 新增钢联化工指标接口
  17. // @Description 新增钢联化工指标接口
  18. // @Success 200 {object} models.AddEdbInfoReq
  19. // @router /add [post]
  20. func (this *MySteelChemicalController) Add() {
  21. br := new(models.BaseResponse).Init()
  22. var cacheKey string
  23. defer func() {
  24. utils.Rc.Delete(cacheKey)
  25. this.Data["json"] = br
  26. this.ServeJSON()
  27. }()
  28. source := utils.DATA_SOURCE_MYSTEEL_CHEMICAL
  29. var req models.AddEdbInfoReq
  30. err := json.Unmarshal(this.Ctx.Input.RequestBody, &req)
  31. if err != nil {
  32. br.Msg = "参数解析异常!"
  33. br.ErrMsg = "参数解析失败,Err:" + err.Error()
  34. return
  35. }
  36. if req.EdbCode == "" {
  37. br.Msg = "请输入指标编码!"
  38. br.ErrMsg = "请输入指标编码,指标编码为空"
  39. return
  40. }
  41. cacheKey = utils.CACHE_EDB_DATA_ADD + strconv.Itoa(source) + "_" + req.EdbCode
  42. if !utils.Rc.IsExist(cacheKey) {
  43. utils.Rc.SetNX(cacheKey, 1, 1*time.Minute)
  44. err = models.AddEdbDataFromMysteelChemical(req.EdbCode)
  45. if err != nil {
  46. br.Msg = "获取指标信息失败!"
  47. br.ErrMsg = "获取指标信息失败 AddEdbDataFromMysteelChemical,Err:" + err.Error()
  48. return
  49. }
  50. br.Ret = 200
  51. br.Success = true
  52. br.Msg = "获取成功"
  53. } else {
  54. br.Ret = 501
  55. br.Success = true
  56. br.Msg = "系统处理中,请稍后重试"
  57. }
  58. }
  59. // Refresh
  60. // @Title 刷新钢联化工指标接口
  61. // @Description 刷新钢联化工指标接口
  62. // @Success 200 {object} models.RefreshEdbInfoReq
  63. // @router /refresh [post]
  64. func (this *MySteelChemicalController) Refresh() {
  65. br := new(models.BaseResponse).Init()
  66. var cacheKey string
  67. defer func() {
  68. utils.Rc.Delete(cacheKey)
  69. this.Data["json"] = br
  70. this.ServeJSON()
  71. }()
  72. source := utils.DATA_SOURCE_MYSTEEL_CHEMICAL
  73. var req models.RefreshEdbInfoReq
  74. err := json.Unmarshal(this.Ctx.Input.RequestBody, &req)
  75. if err != nil {
  76. br.Msg = "参数解析异常!"
  77. br.ErrMsg = "参数解析失败,Err:" + err.Error()
  78. return
  79. }
  80. if req.EdbCode == "" {
  81. br.Msg = "请输入指标编码!"
  82. br.ErrMsg = "请输入指标编码,指标编码为空"
  83. return
  84. }
  85. if req.EdbInfoId <= 0 {
  86. br.Msg = "请输入指标ID!"
  87. br.ErrMsg = "请输入指标ID"
  88. return
  89. }
  90. // 获取指标详情
  91. edbInfo, err := models.GetEdbInfoByEdbCode(source, req.EdbCode)
  92. if err != nil {
  93. br.Msg = "指标不存在!"
  94. br.ErrMsg = "指标不存在"
  95. return
  96. }
  97. cacheKey = utils.CACHE_EDB_DATA_REFRESH + strconv.Itoa(source) + "_" + req.EdbCode
  98. if utils.Rc.IsExist(cacheKey) {
  99. br.Ret = 501
  100. br.Success = true
  101. br.Msg = "系统处理中,请稍后重试"
  102. return
  103. }
  104. utils.Rc.SetNX(cacheKey, 1, 1*time.Minute)
  105. err = models.RefreshEdbDataFromMysteelChemical(req.EdbInfoId, req.EdbCode, req.StartDate)
  106. if err != nil && err.Error() != utils.ErrNoRow() {
  107. br.Msg = "刷新指标信息失败!"
  108. br.ErrMsg = "刷新指标信息失败 RefreshEdbDataFromMysteel,Err:" + err.Error()
  109. return
  110. }
  111. // 更新指标最大最小值
  112. err, errMsg := models.UnifiedModifyEdbInfoMaxAndMinInfo(edbInfo)
  113. if err != nil {
  114. br.Msg = errMsg
  115. br.ErrMsg = err.Error()
  116. return
  117. }
  118. // 更新ES
  119. go logic.UpdateEs(edbInfo.EdbInfoId)
  120. br.Ret = 200
  121. br.Success = true
  122. br.Msg = "获取成功"
  123. }
  124. // @Title 查询刷新钢联指标的接口
  125. // @Description 查询刷新钢联指标的接口
  126. // @Success 200 {object} models.CheckDeleteClassifyResp
  127. // @router /query/refresh [post]
  128. func (this *MySteelChemicalController) QueryRefresh() {
  129. br := new(models.BaseResponse).Init()
  130. defer func() {
  131. this.Data["json"] = br
  132. this.ServeJSON()
  133. }()
  134. mysteelIndex := new(models.BaseFromMysteelChemicalIndex)
  135. list, err := mysteelIndex.GetIndexRefreshAllByMergeFile()
  136. if err != nil && err.Error() != utils.ErrNoRow() {
  137. br.Msg = "获取失败!"
  138. br.ErrMsg = "获取失败,Err:" + err.Error()
  139. return
  140. }
  141. if list == nil {
  142. list = make([]*models.BaseFromMysteelChemicalIndex, 0)
  143. }
  144. br.Ret = 200
  145. br.Data = list
  146. br.Success = true
  147. br.Msg = "获取成功"
  148. }
  149. // @Title 处理钢联指标的接口
  150. // @Description 处理钢联指标的接口
  151. // @Success 200 {object} models.HandleMysteelIndexResp
  152. // @router /handle/mysteel/index [post]
  153. func (this *MySteelChemicalController) HandleMysteelIndex() {
  154. br := new(models.BaseResponse).Init()
  155. defer func() {
  156. this.Data["json"] = br
  157. this.ServeJSON()
  158. }()
  159. var req models.HandleMysteelIndexResp
  160. err := json.Unmarshal(this.Ctx.Input.RequestBody, &req)
  161. if err != nil {
  162. br.Msg = "参数解析异常!"
  163. br.ErrMsg = "参数解析失败,Err:" + err.Error()
  164. return
  165. }
  166. services.HandleMysteelIndex(&req)
  167. br.Ret = 200
  168. br.Success = true
  169. br.Msg = "处理成功"
  170. }
  171. // GetMaxFileIndex
  172. // @Title 获取最大的文件编号下标
  173. // @Description 获取最大的文件编号下标
  174. // @Success 200 {object} models.HandleMysteelIndexResp
  175. // @router /getMaxFileIndex [post]
  176. func (this *MySteelChemicalController) GetMaxFileIndex() {
  177. br := new(models.BaseResponse).Init()
  178. defer func() {
  179. this.Data["json"] = br
  180. this.ServeJSON()
  181. }()
  182. var req models.GetMaxFileIndexReq
  183. err := json.Unmarshal(this.Ctx.Input.RequestBody, &req)
  184. if err != nil {
  185. br.Msg = "参数解析异常!"
  186. br.ErrMsg = "参数解析失败,Err:" + err.Error()
  187. return
  188. }
  189. indexObj := new(models.BaseFromMysteelChemicalIndex)
  190. // 获取最大的文件编号下标
  191. item, err := indexObj.GetMaxFileIndex(req.Frequency)
  192. if err != nil {
  193. return
  194. }
  195. br.Data = item
  196. br.Ret = 200
  197. br.Success = true
  198. br.Msg = "处理成功"
  199. }
  200. // GetNoMergeIndexByFrequencyCount
  201. // @Title 获取未合并的指标总数量
  202. // @Description 获取未合并的指标总数量
  203. // @Success 200 {object} models.HandleMysteelIndexResp
  204. // @router /getNoMergeIndexByFrequencyCount [post]
  205. func (this *MySteelChemicalController) GetNoMergeIndexByFrequencyCount() {
  206. br := new(models.BaseResponse).Init()
  207. defer func() {
  208. this.Data["json"] = br
  209. this.ServeJSON()
  210. }()
  211. var req models.GetMaxFileIndexReq
  212. err := json.Unmarshal(this.Ctx.Input.RequestBody, &req)
  213. if err != nil {
  214. br.Msg = "参数解析异常!"
  215. br.ErrMsg = "参数解析失败,Err:" + err.Error()
  216. return
  217. }
  218. indexObj := new(models.BaseFromMysteelChemicalIndex)
  219. // 获取未合并的指标总数量
  220. indexTotal, err := indexObj.GetNoMergeIndexByFrequencyCount(req.Frequency)
  221. if err != nil {
  222. return
  223. }
  224. br.Data = indexTotal
  225. br.Ret = 200
  226. br.Success = true
  227. br.Msg = "处理成功"
  228. }
  229. // GetNoMergeIndexByFrequencyPage
  230. // @Title 获取未合并的指标列表
  231. // @Description 获取未合并的指标列表
  232. // @Success 200 {object} models.HandleMysteelIndexResp
  233. // @router /getNoMergeIndexByFrequencyPage [post]
  234. func (this *MySteelChemicalController) GetNoMergeIndexByFrequencyPage() {
  235. br := new(models.BaseResponse).Init()
  236. defer func() {
  237. this.Data["json"] = br
  238. this.ServeJSON()
  239. }()
  240. var req models.GetNoMergeIndexByFrequencyPageReq
  241. err := json.Unmarshal(this.Ctx.Input.RequestBody, &req)
  242. if err != nil {
  243. br.Msg = "参数解析异常!"
  244. br.ErrMsg = "参数解析失败,Err:" + err.Error()
  245. return
  246. }
  247. indexObj := new(models.BaseFromMysteelChemicalIndex)
  248. // 获取未合并的指标总数量
  249. indexTotal, err := indexObj.GetNoMergeIndexByFrequencyPage(req.Frequency, req.Limit)
  250. if err != nil {
  251. return
  252. }
  253. br.Data = indexTotal
  254. br.Ret = 200
  255. br.Success = true
  256. br.Msg = "处理成功"
  257. }
  258. // GetIndexCountByMergeFilePath
  259. // @Title 获取该文件下标已经存在多少的指标
  260. // @Description 获取该文件下标已经存在多少的指标
  261. // @Success 200 {object} models.HandleMysteelIndexResp
  262. // @router /getIndexCountByMergeFilePath [post]
  263. func (this *MySteelChemicalController) GetIndexCountByMergeFilePath() {
  264. br := new(models.BaseResponse).Init()
  265. defer func() {
  266. this.Data["json"] = br
  267. this.ServeJSON()
  268. }()
  269. var req models.GetIndexCountByMergeFilePathReq
  270. err := json.Unmarshal(this.Ctx.Input.RequestBody, &req)
  271. if err != nil {
  272. br.Msg = "参数解析异常!"
  273. br.ErrMsg = "参数解析失败,Err:" + err.Error()
  274. return
  275. }
  276. if req.MergeFilePath == "" {
  277. br.Msg = "参数有误"
  278. br.ErrMsg = "参数有误, 文件路径有误"
  279. return
  280. }
  281. indexObj := new(models.BaseFromMysteelChemicalIndex)
  282. indexTotal, err := indexObj.GetIndexCountByMergeFilePath(req.MergeFilePath)
  283. if err != nil {
  284. return
  285. }
  286. br.Data = indexTotal
  287. br.Ret = 200
  288. br.Success = true
  289. br.Msg = "获取成功"
  290. }
  291. // GetIndexCreate
  292. // @Title 获取两分钟前新增的指标
  293. // @Description 获取两分钟前新增的指标
  294. // @Success 200 {object} models.BaseFromMysteelChemicalIndex
  295. // @router /getIndexCreate [post]
  296. func (this *MySteelChemicalController) GetIndexCreate() {
  297. br := new(models.BaseResponse).Init()
  298. defer func() {
  299. this.Data["json"] = br
  300. this.ServeJSON()
  301. }()
  302. indexObj := new(models.BaseFromMysteelChemicalIndex)
  303. items, err := indexObj.GetIndexCreate()
  304. if err != nil {
  305. br.Msg = "获取失败"
  306. br.ErrMsg = "获取指标失败, Err: " + err.Error()
  307. return
  308. }
  309. if items == nil {
  310. items = make([]*models.BaseFromMysteelChemicalIndex, 0)
  311. }
  312. br.Data = items
  313. br.Ret = 200
  314. br.Success = true
  315. br.Msg = "获取成功"
  316. }
  317. // GetIndexRefreshMethanolByMergeFile
  318. // @Title 获取需要刷新的甲醇文件
  319. // @Description 获取需要刷新的甲醇文件
  320. // @Success 200 {object} models.BaseFromMysteelChemicalIndex
  321. // @router /getIndexRefreshMethanolByMergeFile [post]
  322. func (this *MySteelChemicalController) GetIndexRefreshMethanolByMergeFile() {
  323. br := new(models.BaseResponse).Init()
  324. defer func() {
  325. this.Data["json"] = br
  326. this.ServeJSON()
  327. }()
  328. indexObj := new(models.BaseFromMysteelChemicalIndex)
  329. items, err := indexObj.GetIndexRefreshMethanolByMergeFile()
  330. if err != nil {
  331. br.Msg = "获取失败"
  332. br.ErrMsg = "获取指标失败, Err: " + err.Error()
  333. return
  334. }
  335. if items == nil {
  336. items = make([]*models.BaseFromMysteelChemicalIndex, 0)
  337. }
  338. br.Data = items
  339. br.Ret = 200
  340. br.Success = true
  341. br.Msg = "获取成功"
  342. }
  343. // GetIndexRefreshMethanolByTimely
  344. // @Title 获取需要及时刷新的文件
  345. // @Description 获取需要及时刷新的文件
  346. // @Success 200 {object} models.BaseFromMysteelChemicalIndex
  347. // @router /getIndexRefreshMethanolByTimely [post]
  348. func (this *MySteelChemicalController) GetIndexRefreshMethanolByTimely() {
  349. br := new(models.BaseResponse).Init()
  350. defer func() {
  351. this.Data["json"] = br
  352. this.ServeJSON()
  353. }()
  354. indexObj := new(models.BaseFromMysteelChemicalIndex)
  355. items, err := indexObj.GetIndexRefreshMethanolByTimely()
  356. if err != nil {
  357. br.Msg = "获取失败"
  358. br.ErrMsg = "获取指标失败, Err: " + err.Error()
  359. return
  360. }
  361. if items == nil {
  362. items = make([]*models.BaseFromMysteelChemicalIndex, 0)
  363. }
  364. br.Data = items
  365. br.Ret = 200
  366. br.Success = true
  367. br.Msg = "获取成功"
  368. }
  369. // GetIndexByFrequency
  370. // @Title 根据频率获取指标
  371. // @Description 根据频率获取指标
  372. // @Success 200 {object} models.BaseFromMysteelChemicalIndex
  373. // @router /getIndexByFrequency [post]
  374. func (this *MySteelChemicalController) GetIndexByFrequency() {
  375. br := new(models.BaseResponse).Init()
  376. defer func() {
  377. this.Data["json"] = br
  378. this.ServeJSON()
  379. }()
  380. var req models.GetIndexByFrequencyReq
  381. err := json.Unmarshal(this.Ctx.Input.RequestBody, &req)
  382. if err != nil {
  383. br.Msg = "参数解析异常!"
  384. br.ErrMsg = "参数解析失败,Err:" + err.Error()
  385. return
  386. }
  387. if req.Frequency == "" {
  388. br.Msg = "参数有误"
  389. br.ErrMsg = "参数有误"
  390. return
  391. }
  392. indexObj := new(models.BaseFromMysteelChemicalIndex)
  393. items, err := indexObj.GetIndexByFrequency(req.Frequency)
  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. // GetIndexRefreshWeek
  408. // @Title 根据周获取指标
  409. // @Description 根据周获取指标
  410. // @Success 200 {object} models.BaseFromMysteelChemicalIndex
  411. // @router /getIndexRefreshWeek [post]
  412. func (this *MySteelChemicalController) GetIndexRefreshWeek() {
  413. br := new(models.BaseResponse).Init()
  414. defer func() {
  415. this.Data["json"] = br
  416. this.ServeJSON()
  417. }()
  418. var req models.GetIndexRefreshWeekReq
  419. err := json.Unmarshal(this.Ctx.Input.RequestBody, &req)
  420. if err != nil {
  421. br.Msg = "参数解析异常!"
  422. br.ErrMsg = "参数解析失败,Err:" + err.Error()
  423. return
  424. }
  425. if req.NowWeekZn == "" || req.StartTime == "" || req.EndTime == "" {
  426. br.Msg = "参数有误"
  427. br.ErrMsg = "参数有误"
  428. return
  429. }
  430. indexObj := new(models.BaseFromMysteelChemicalIndex)
  431. items, err := indexObj.GetIndexRefreshWeek(req.NowWeekZn, req.StartTime, req.EndTime)
  432. if err != nil {
  433. br.Msg = "获取失败"
  434. br.ErrMsg = "获取指标失败, Err: " + err.Error()
  435. return
  436. }
  437. if items == nil {
  438. items = make([]*models.BaseFromMysteelChemicalIndex, 0)
  439. }
  440. br.Data = items
  441. br.Ret = 200
  442. br.Success = true
  443. br.Msg = "获取成功"
  444. }
  445. // UpdateIndex
  446. // @Title 更新指标
  447. // @Description 更新指标
  448. // @Success 200 string "操作成功"
  449. // @router /updateIndex [post]
  450. //func (this *MySteelChemicalController) UpdateIndex() {
  451. // br := new(models.BaseResponse).Init()
  452. // defer func() {
  453. // this.Data["json"] = br
  454. // this.ServeJSON()
  455. // }()
  456. // var req models.UpdateIndexReq
  457. // err := json.Unmarshal(this.Ctx.Input.RequestBody, &req)
  458. // if err != nil {
  459. // br.Msg = "参数解析异常!"
  460. // br.ErrMsg = "参数解析失败,Err:" + err.Error()
  461. // return
  462. // }
  463. // if req.Item == nil {
  464. // br.Msg = "参数有误"
  465. // br.ErrMsg = "参数有误, 指标信息有误"
  466. // return
  467. // }
  468. // if len(req.UpdateCols) == 0 {
  469. // br.Msg = "参数有误"
  470. // br.ErrMsg = "参数有误, 无更新字段"
  471. // return
  472. // }
  473. //
  474. // // 更新指标
  475. // indexObj := new(models.BaseFromMysteelChemicalIndex)
  476. // err = indexObj.UpdateIndex(req.Item, req.UpdateCols)
  477. // if err != nil {
  478. // br.Msg = "操作失败"
  479. // br.ErrMsg = "批量更新指标失败, MultiUpdateIndexByIndexCode err: " + err.Error()
  480. // return
  481. // }
  482. //
  483. // br.Ret = 200
  484. // br.Success = true
  485. // br.Msg = "操作成功"
  486. //}
  487. // MultiUpdateIndex
  488. // @Title 批量更新指标
  489. // @Description 批量更新指标
  490. // @Success 200 string "操作成功"
  491. // @router /multiUpdateIndex [post]
  492. func (this *MySteelChemicalController) MultiUpdateIndex() {
  493. br := new(models.BaseResponse).Init()
  494. defer func() {
  495. this.Data["json"] = br
  496. this.ServeJSON()
  497. }()
  498. var req []models.UpdateIndexReq
  499. err := json.Unmarshal(this.Ctx.Input.RequestBody, &req)
  500. if err != nil {
  501. br.Msg = "参数解析异常!"
  502. br.ErrMsg = "参数解析失败,Err:" + err.Error()
  503. return
  504. }
  505. if len(req) == 0 {
  506. br.Msg = "参数有误"
  507. br.ErrMsg = "参数有误, 无指标需要更新"
  508. return
  509. }
  510. // 批量更新指标
  511. indexObj := new(models.BaseFromMysteelChemicalIndex)
  512. err = indexObj.MultiUpdateIndex(req)
  513. if err != nil {
  514. br.Msg = "操作失败"
  515. br.ErrMsg = "批量更新指标失败, MultiUpdateIndex err: " + err.Error()
  516. return
  517. }
  518. br.Ret = 200
  519. br.Success = true
  520. br.Msg = "操作成功"
  521. }