base_from_smm.go 6.7 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260
  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. // 有色
  13. type SmmController struct {
  14. BaseAuthController
  15. }
  16. // @Title 新增有色指标接口
  17. // @Description 新增有色指标接口
  18. // @Success 200 {object} models.AddEdbInfoReq
  19. // @router /add [post]
  20. func (this *SmmController) 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_YS
  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. smmBaseDataAll, err := services.GetEdbDataFromSmm(req.EdbCode)
  45. if err!= nil {
  46. br.Msg = "获取指标信息失败!"
  47. br.ErrMsg = "获取指标信息失败 GetEdbDataFromSmm,Err:" + err.Error()
  48. return
  49. }
  50. err = models.AddEdbDataFromSmm(req.EdbCode, smmBaseDataAll)
  51. if err != nil {
  52. br.Msg = "获取指标信息失败!"
  53. br.ErrMsg = "获取指标信息失败 AddEdbDataFromSmm,Err:" + err.Error()
  54. return
  55. }
  56. br.Ret = 200
  57. br.Success = true
  58. br.Msg = "获取成功"
  59. } else {
  60. br.Ret = 501
  61. br.Success = true
  62. br.Msg = "系统处理中,请稍后重试"
  63. }
  64. }
  65. // @Title 刷新有色指标接口
  66. // @Description 刷新有色指标接口
  67. // @Success 200 {object} models.RefreshEdbInfoReq
  68. // @router /refresh [post]
  69. func (this *SmmController) Refresh() {
  70. br := new(models.BaseResponse).Init()
  71. var cacheKey string
  72. defer func() {
  73. this.Data["json"] = br
  74. this.ServeJSON()
  75. }()
  76. source := utils.DATA_SOURCE_YS
  77. var req models.RefreshEdbInfoReq
  78. err := json.Unmarshal(this.Ctx.Input.RequestBody, &req)
  79. if err != nil {
  80. br.Msg = "参数解析异常!"
  81. br.ErrMsg = "参数解析失败,Err:" + err.Error()
  82. return
  83. }
  84. if req.EdbCode == "" {
  85. br.Msg = "请输入指标编码!"
  86. br.ErrMsg = "请输入指标编码,指标编码为空"
  87. return
  88. }
  89. if req.EdbInfoId < 0 {
  90. br.Msg = "请输入指标ID!"
  91. br.ErrMsg = "请输入指标ID"
  92. return
  93. }
  94. // 获取指标详情
  95. edbInfo, err := models.GetEdbInfoByEdbCode(source, req.EdbCode)
  96. if err != nil {
  97. br.Msg = "指标不存在!"
  98. br.ErrMsg = "指标不存在"
  99. return
  100. }
  101. cacheKey = utils.CACHE_EDB_DATA_REFRESH + strconv.Itoa(source) + "_" + req.EdbCode
  102. if utils.Rc.IsExist(cacheKey) {
  103. br.Ret = 501
  104. br.Success = true
  105. br.Msg = "系统处理中,请稍后重试"
  106. return
  107. }
  108. utils.Rc.SetNX(cacheKey, 1, 1*time.Minute)
  109. defer func() {
  110. utils.Rc.Delete(cacheKey)
  111. }()
  112. if req.EdbInfoId <= 0 {
  113. req.EdbInfoId = edbInfo.EdbInfoId
  114. }
  115. err = models.RefreshEdbDataFromSmm(req.EdbInfoId, req.EdbCode, req.StartDate)
  116. if err != nil && err.Error() != utils.ErrNoRow() {
  117. br.Msg = "刷新指标信息失败!"
  118. br.ErrMsg = "刷新指标信息失败 RefreshEdbDataFromSmm,Err:" + err.Error()
  119. return
  120. }
  121. // 更新指标最大最小值
  122. err, errMsg := models.UnifiedModifyEdbInfoMaxAndMinInfo(edbInfo)
  123. if err != nil {
  124. br.Msg = errMsg
  125. br.ErrMsg = err.Error()
  126. return
  127. }
  128. // 更新ES
  129. go logic.UpdateEs(edbInfo.EdbInfoId)
  130. br.Ret = 200
  131. br.Success = true
  132. br.Msg = "获取成功"
  133. }
  134. // HandleExcelData
  135. // @Title 处理有色指标的接口
  136. // @Description 处理有色指标的接口
  137. // @Success 200 string "操作成功"
  138. // @router /handle/excel_data [post]
  139. func (this *SmmController) HandleExcelData() {
  140. br := new(models.BaseResponse).Init()
  141. defer func() {
  142. this.Data["json"] = br
  143. this.ServeJSON()
  144. }()
  145. var req models.HandleSmmExcelDataReq
  146. err := json.Unmarshal(this.Ctx.Input.RequestBody, &req)
  147. if err != nil {
  148. br.Msg = "参数解析异常!"
  149. br.ErrMsg = "参数解析失败,Err:" + err.Error()
  150. return
  151. }
  152. // 处理excel表数据
  153. e, errMsg := services.SmmIndexHandle(req.BaseFilePath, req.RenameFilePath, req.IndexName, req.IndexCode, req.Unit, req.Frequency, req.Source, req.ExcelDataMap, req.TerminalCode)
  154. if e != nil {
  155. br.Msg = "处理失败"
  156. br.ErrMsg = fmt.Sprintf("处理有色excel表数据失败, Err: %s, ErrMsg: %s", e.Error(), errMsg)
  157. return
  158. }
  159. br.Ret = 200
  160. br.Success = true
  161. br.Msg = "处理成功"
  162. }
  163. // AddIndexToDataSource
  164. // @Title 添加指标到数据源-SMM
  165. // @Description 添加指标到数据源-SMM
  166. // @Success 200 {object} models.AddSmmIndexToDataSourceResp
  167. // @router /add/index/to_data_source [post]
  168. func (this *SmmController) AddIndexToDataSource() {
  169. br := new(models.BaseResponse).Init()
  170. defer func() {
  171. this.Data["json"] = br
  172. this.ServeJSON()
  173. }()
  174. var req models.AddSmmIndexToDataSourceResp
  175. err := json.Unmarshal(this.Ctx.Input.RequestBody, &req)
  176. if err != nil {
  177. br.Msg = "参数解析异常!"
  178. br.ErrMsg = "参数解析失败,Err:" + err.Error()
  179. return
  180. }
  181. smmIndexObj := new(models.BaseFromSmmIndex)
  182. indexItem, err := smmIndexObj.GetSmmIndexItem(req.EdbCode)
  183. var isAdd bool
  184. if err != nil {
  185. if err.Error() == utils.ErrNoRow() {
  186. isAdd = true
  187. } else {
  188. br.Msg = "判断指标是否存在失败"
  189. br.ErrMsg = "判断指标是否存在失败,Err:" + err.Error()
  190. return
  191. }
  192. }
  193. if indexItem == nil {
  194. isAdd = true
  195. }
  196. if isAdd {
  197. smmIndexObj.IndexCode = req.EdbCode
  198. smmIndexObj.ClassifyId = req.ClassifyId
  199. smmIndexObj.CreateTime = time.Now()
  200. smmIndexObj.ModifyTime = time.Now()
  201. err = smmIndexObj.Add()
  202. if err != nil {
  203. br.Msg = "新增指标失败"
  204. br.ErrMsg = "新增指标失败,Err:" + err.Error()
  205. return
  206. }
  207. }
  208. br.Ret = 200
  209. br.Success = true
  210. br.Msg = "新增成功"
  211. }
  212. // GetIndexDetailByCode
  213. // @Title 获取指标详情
  214. // @Description 获取指标详情
  215. // @Success 200 {object} models.GetIndexDetailReq
  216. // @router /index_detail/from_data_source [post]
  217. func (this *SmmController) GetIndexDetailFromDataSourceByCode() {
  218. br := new(models.BaseResponse).Init()
  219. defer func() {
  220. this.Data["json"] = br
  221. this.ServeJSON()
  222. }()
  223. var req models.GetIndexDetailReq
  224. err := json.Unmarshal(this.Ctx.Input.RequestBody, &req)
  225. if err != nil {
  226. br.Msg = "参数解析异常!"
  227. br.ErrMsg = "参数解析失败,Err:" + err.Error()
  228. return
  229. }
  230. if req.IndexCode == "" {
  231. br.Msg = "参数有误"
  232. br.ErrMsg = "参数有误"
  233. return
  234. }
  235. indexObj := new(models.BaseFromSmmIndex)
  236. item, err := indexObj.GetIndexItem(req.IndexCode)
  237. if err != nil {
  238. br.Msg = "获取失败"
  239. br.ErrMsg = "获取指标失败, Err: " + err.Error()
  240. return
  241. }
  242. br.Data = item
  243. br.Ret = 200
  244. br.Success = true
  245. br.Msg = "获取成功"
  246. }