chart_info.go 23 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704
  1. package chart
  2. import (
  3. "context"
  4. "encoding/json"
  5. "fmt"
  6. "github.com/gin-gonic/gin"
  7. "hongze/hongze_yb/controller/response"
  8. "hongze/hongze_yb/global"
  9. "hongze/hongze_yb/models/request"
  10. responseModel "hongze/hongze_yb/models/response"
  11. "hongze/hongze_yb/models/response/chart_info"
  12. chartEdbMappingModel "hongze/hongze_yb/models/tables/chart_edb_mapping"
  13. chartInfoModel "hongze/hongze_yb/models/tables/chart_info"
  14. "hongze/hongze_yb/models/tables/chart_info_log"
  15. edbInfoModel "hongze/hongze_yb/models/tables/edb_info"
  16. "hongze/hongze_yb/models/tables/yb_my_chart"
  17. "hongze/hongze_yb/services"
  18. "hongze/hongze_yb/services/alarm_msg"
  19. "hongze/hongze_yb/services/chart"
  20. "hongze/hongze_yb/services/chart/cross_variety"
  21. "hongze/hongze_yb/services/user"
  22. "hongze/hongze_yb/utils"
  23. "sort"
  24. "strconv"
  25. "strings"
  26. "time"
  27. )
  28. // GetChartInfoDetail 获取图表详情
  29. // @Tags 图库模块
  30. // @Summary 获取图表详情
  31. // @Description 获取图表详情
  32. // @Security ApiKeyAuth
  33. // @Param Authorization header string true "Bearer 31a165baebe6dec616b1f8f3207b4273"
  34. // @Accept json
  35. // @Product json
  36. // @Param DateType query string false "时间段:1-00年至今; 2-10年至今; 3-15年至今; 4-21年至今; 5-指定区间; 6-指定年月至今; 7-18年至今; 8-19年至今; 9-20年至今"
  37. // @Param ClassifyId query string false "图表分类ID"
  38. // @Success 200 {object} chart_info.ChartInfoDetailResp
  39. // @failure 400 {string} string "图表详情获取失败"
  40. // @Router /my_chart/getChartInfoDetail [get]
  41. func GetChartInfoDetail(c *gin.Context) {
  42. // 图表ID
  43. reqChartInfoId := c.DefaultQuery("ChartInfoId", "")
  44. if reqChartInfoId == "" {
  45. response.Fail("参数有误:图表ID", c)
  46. return
  47. }
  48. chartInfoId, _ := strconv.Atoi(reqChartInfoId)
  49. reqStartDate := c.DefaultQuery("StartDate", "")
  50. reqEndDate := c.DefaultQuery("EndDate", "")
  51. // 图表样式类型
  52. reqChartType := c.DefaultQuery("ChartType", "")
  53. chartType, _ := strconv.Atoi(reqChartType)
  54. /*// 季节性图表时间
  55. reqSeasonStartDate := c.DefaultQuery("SeasonStartDate", "")
  56. reqSeasonEndDate := c.DefaultQuery("SeasonEndDate", "")*/
  57. // 指标ID
  58. edbInfoId := c.DefaultQuery("EdbInfoId", "")
  59. // 公历/农历
  60. reqCalendar := c.DefaultQuery("Calendar", "")
  61. // 获取图表信息
  62. var err error
  63. chartInfo := new(chartInfoModel.ChartInfoView)
  64. chartInfo, err = chartInfoModel.GetChartInfoViewById(chartInfoId)
  65. if err != nil {
  66. if err == utils.ErrNoRow {
  67. response.Custom(4003, "图表不存在,请刷新页面", c)
  68. return
  69. }
  70. response.FailMsg("获取失败", "获取图表信息失败, Err:"+err.Error(), c)
  71. return
  72. }
  73. var (
  74. edbList []*chartEdbMappingModel.ChartEdbInfoMappingList
  75. xEdbIdValue []int
  76. yDataList []chart_info.YData
  77. sourceArr []string
  78. dataResp interface{}
  79. )
  80. // todo 特殊处理平衡表
  81. if chartInfo.Source == utils.CHART_SOURCE_BALANCE_EXCEL {
  82. //调用接口
  83. chartData, e := services.GetBalanceChartDetail(chartInfo.UniqueCode)
  84. if e != nil {
  85. response.FailMsg("获取失败", "获取图表信息失败, Err:"+e.Error(), c)
  86. return
  87. }
  88. chartDataResp := new(chart_info.ChartInfoDetailResp)
  89. // 兼容返回值类型
  90. chartDataString, _ := json.Marshal(chartData)
  91. err = json.Unmarshal(chartDataString, chartDataResp)
  92. if err != nil {
  93. response.FailMsg("获取失败", "获取图表信息失败, Err:"+err.Error(), c)
  94. return
  95. }
  96. chartInfo = chartDataResp.ChartInfo
  97. chartInfo.ChartInfoId = chartInfoId
  98. yDataList = chartDataResp.YDataList
  99. edbList = chartDataResp.EdbInfoList
  100. xEdbIdValue = chartDataResp.XEdbIdValue
  101. sourceArr = append(sourceArr, "平衡表")
  102. dataResp = chartDataResp.DataResp
  103. } else if chartInfo.Source == utils.CHART_SOURCE_RANGE_ANALYSIS {
  104. //调用接口
  105. chartData, e := services.GetRangeChartChartDetail(chartInfo.UniqueCode)
  106. if e != nil {
  107. response.FailMsg("获取失败", "获取图表信息失败, Err:"+e.Error(), c)
  108. return
  109. }
  110. chartDataResp := new(chart_info.ChartInfoDetailResp)
  111. // 兼容返回值类型
  112. chartDataString, _ := json.Marshal(chartData)
  113. err = json.Unmarshal(chartDataString, chartDataResp)
  114. if err != nil {
  115. response.FailMsg("获取失败", "获取图表信息失败, Err:"+err.Error(), c)
  116. return
  117. }
  118. chartInfo = chartDataResp.ChartInfo
  119. chartInfo.ChartInfoId = chartInfoId
  120. yDataList = chartDataResp.YDataList
  121. edbList = chartDataResp.EdbInfoList
  122. xEdbIdValue = chartDataResp.XEdbIdValue
  123. dataResp = chartDataResp.DataResp
  124. // 图表的指标来源
  125. sourceNameList, sourceNameEnList := chart.GetEdbSourceByEdbInfoIdList(edbList)
  126. chartInfo.ChartSource = strings.Join(sourceNameList, ",")
  127. chartInfo.ChartSourceEn = strings.Join(sourceNameEnList, ",")
  128. } else {
  129. // 获取主题样式
  130. chartTheme, err := chart.GetChartThemeConfig(chartInfo.ChartThemeId, chartInfo.Source, chartInfo.ChartType)
  131. if err != nil {
  132. response.FailMsg("获取失败", "获取主题信息失败, Err:"+err.Error(), c)
  133. return
  134. }
  135. chartInfo.ChartThemeStyle = chartTheme.Config
  136. chartInfo.ChartThemeId = chartTheme.ChartThemeID
  137. chartType = chartInfo.ChartType
  138. startDate := chartInfo.StartDate
  139. endDate := chartInfo.EndDate
  140. startYear := chartInfo.StartYear
  141. calendar := chartInfo.Calendar
  142. if reqCalendar != "" {
  143. calendar = reqCalendar
  144. }
  145. // 时段筛选
  146. reqDateType := c.DefaultQuery("DateType", "")
  147. dateType := chartInfo.DateType
  148. if reqDateType != "" {
  149. dateType, _ = strconv.Atoi(reqDateType)
  150. }
  151. if dateType <= 0 {
  152. dateType = 3 // 默认同后台15年至今
  153. }
  154. if reqStartDate != "" {
  155. startDate = reqStartDate
  156. }
  157. if reqEndDate != "" {
  158. endDate = reqEndDate
  159. }
  160. // 获取图表指标映射
  161. mappingList := make([]*chartEdbMappingModel.ChartEdbInfoMapping, 0)
  162. if chartInfoId > 0 {
  163. mappingList, err = chartEdbMappingModel.GetMappingListByChartInfoId(chartInfoId)
  164. if err != nil {
  165. response.FailMsg("获取失败", "获取图表指标信息失败4001, Err:"+err.Error(), c)
  166. return
  167. }
  168. } else {
  169. if edbInfoId != "" {
  170. mappingList, err = chartEdbMappingModel.GetMappingListByEdbInfoId(edbInfoId)
  171. if err != nil {
  172. response.FailMsg("获取失败", "获取图表指标信息失败4002, Err:"+err.Error(), c)
  173. return
  174. }
  175. }
  176. }
  177. var dateMax time.Time
  178. for _, v := range mappingList {
  179. // 得到指标更新的最新的年份
  180. if dateType == utils.DateTypeNYears && !v.LatestDate.IsZero() {
  181. if v.LatestDate.After(dateMax) {
  182. dateMax = v.LatestDate
  183. }
  184. }
  185. }
  186. if chartType == utils.CHART_TYPE_SEASON && dateType == utils.DateTypeNYears {
  187. // 季节性图表,要特殊处理起始日期, 最近N年
  188. dateMax = time.Date(dateMax.Year()+1, 1, 1, 0, 0, 0, 0, time.Local)
  189. }
  190. // 开始/结束日期
  191. startDate, endDate = utils.GetDateByDateTypeV2(dateType, startDate, endDate, startYear, dateMax)
  192. // 图表额外数据参数
  193. extraConfigStr := chartInfo.ExtraConfig
  194. // 柱方图的一些配置
  195. var barConfig request.BarChartInfoReq
  196. if chartInfo != nil && chartInfo.ChartType == 7 {
  197. if chartInfo.BarConfig == `` {
  198. response.FailMsg("柱方图未配置", "柱方图未配置", c)
  199. return
  200. }
  201. err = json.Unmarshal([]byte(chartInfo.BarConfig), &barConfig)
  202. if err != nil {
  203. response.FailMsg("柱方图配置异常", "柱方图配置异常", c)
  204. return
  205. }
  206. extraConfigStr = chartInfo.BarConfig
  207. }
  208. var errMsg string
  209. // 获取图表中的指标数据
  210. edbList, xEdbIdValue, yDataList, sourceArr, dataResp, err, errMsg = chart.GetChartEdbData(chartInfoId, chartType, calendar, startDate, endDate, mappingList, extraConfigStr, chartInfo.SeasonExtraConfig)
  211. if err != nil {
  212. msg := `获取失败`
  213. if errMsg != `` {
  214. msg = errMsg
  215. }
  216. response.FailMsg(msg, "获取图表,指标信息失败, Err:"+err.Error(), c)
  217. return
  218. }
  219. for _, v := range edbList {
  220. // 指标别名
  221. if barConfig.EdbInfoIdList != nil && len(barConfig.EdbInfoIdList) > 0 {
  222. for _, reqEdb := range barConfig.EdbInfoIdList {
  223. if v.EdbInfoId == reqEdb.EdbInfoId {
  224. v.EdbAliasName = reqEdb.Name
  225. }
  226. }
  227. }
  228. }
  229. // 图表的指标来源
  230. sourceNameList, sourceNameEnList := chart.GetEdbSourceByEdbInfoIdList(edbList)
  231. chartInfo.ChartSource = strings.Join(sourceNameList, ",")
  232. chartInfo.ChartSourceEn = strings.Join(sourceNameEnList, ",")
  233. }
  234. sourceArr = append(sourceArr, "弘则研究")
  235. chartInfo.ChartSource = strings.Join(sourceArr, ",")
  236. // 访问记录-仅普通用户记录
  237. userInfo := user.GetInfoByClaims(c)
  238. ok, _, _ := user.GetAdminByUserInfo(userInfo)
  239. if !ok {
  240. reqMyChartClassifyId := c.DefaultQuery("MyChartClassifyId", "")
  241. myChartClassifyId, _ := strconv.Atoi(reqMyChartClassifyId)
  242. go chart.SaveChartVisitLog(userInfo, chartInfo, myChartClassifyId)
  243. }
  244. // 用户是否有收藏该图表
  245. ob := new(yb_my_chart.YbMyChart)
  246. cond := `user_id = ? AND chart_info_id = ?`
  247. pars := make([]interface{}, 0)
  248. pars = append(pars, userInfo.UserID, chartInfo.ChartInfoId)
  249. exists, e := ob.FetchByCondition(cond, pars)
  250. if e != nil && e != utils.ErrNoRow {
  251. response.FailMsg("操作失败", "获取用户图表失败, Err: "+e.Error(), c)
  252. return
  253. }
  254. myChartInfo := new(responseModel.MyChartItem)
  255. if exists != nil && exists.MyChartID > 0 {
  256. myChartInfo.MyChartID = exists.MyChartID
  257. myChartInfo.MyChartClassifyID = exists.MyChartClassifyID
  258. myChartInfo.ChartInfoID = exists.ChartInfoID
  259. myChartInfo.ChartName = exists.ChartName
  260. myChartInfo.UniqueCode = exists.UniqueCode
  261. myChartInfo.ChartImage = exists.ChartImage
  262. myChartInfo.UserID = exists.UserID
  263. myChartInfo.ReportID = exists.ReportID
  264. myChartInfo.ReportChapterID = exists.ReportChapterID
  265. myChartInfo.CreateTime = utils.TimeTransferString(utils.FormatDateTime, exists.CreateTime)
  266. }
  267. resp := new(chart_info.ChartInfoDetailResp)
  268. resp.ChartInfo = chartInfo
  269. resp.EdbInfoList = edbList
  270. resp.XEdbIdValue = xEdbIdValue
  271. resp.YDataList = yDataList
  272. resp.MyChartInfo = myChartInfo
  273. resp.DataResp = dataResp
  274. response.OkData("获取成功", resp, c)
  275. }
  276. func getChartInfoDetail(chartInfo *chartInfoModel.ChartInfoView, myChartClassifyId int, userInfo user.UserInfo) (resp *chart_info.ChartInfoDetailResp, isOk bool, msg, errMsg string) {
  277. // 获取图表信息
  278. var err error
  279. chartType := chartInfo.ChartType
  280. calendar := chartInfo.Calendar
  281. startDate := chartInfo.StartDate
  282. endDate := chartInfo.EndDate
  283. startYear := chartInfo.StartYear
  284. // 时段筛选
  285. dateType := chartInfo.DateType
  286. if dateType <= 0 {
  287. dateType = 3 // 默认同后台15年至今
  288. }
  289. // 获取图表指标映射
  290. mappingList := make([]*chartEdbMappingModel.ChartEdbInfoMapping, 0)
  291. mappingList, err = chartEdbMappingModel.GetMappingListByChartInfoId(chartInfo.ChartInfoId)
  292. if err != nil {
  293. msg = `获取失败`
  294. errMsg = "获取图表指标信息失败4001, Err:" + err.Error()
  295. return
  296. }
  297. var dateMax time.Time
  298. if dateType == utils.DateTypeNYears {
  299. for _, v := range mappingList {
  300. if !v.LatestDate.IsZero() && v.LatestDate.After(dateMax) {
  301. dateMax = v.LatestDate
  302. }
  303. }
  304. }
  305. startDate, endDate = utils.GetDateByDateTypeV2(dateType, startDate, endDate, startYear, dateMax)
  306. //fmt.Println("start_date:", startDate)
  307. //fmt.Println("end_date:", endDate)
  308. // 图表额外数据参数
  309. extraConfigStr := chartInfo.ExtraConfig
  310. // 柱方图的一些配置
  311. var barConfig request.BarChartInfoReq
  312. if chartInfo != nil && chartInfo.ChartType == 7 {
  313. if chartInfo.BarConfig == `` {
  314. msg = "柱方图未配置"
  315. errMsg = "柱方图未配置"
  316. return
  317. }
  318. err := json.Unmarshal([]byte(chartInfo.BarConfig), &barConfig)
  319. if err != nil {
  320. msg = "柱方图配置异常"
  321. errMsg = "柱方图配置异常"
  322. return
  323. }
  324. extraConfigStr = chartInfo.BarConfig
  325. }
  326. // 获取图表中的指标数据
  327. edbList, xEdbIdValue, yDataList, sourceArr, dataResp, err, tmpErrMsg := chart.GetChartEdbData(chartInfo.ChartInfoId, chartType, calendar, startDate, endDate, mappingList, extraConfigStr, chartInfo.SeasonExtraConfig)
  328. if err != nil {
  329. msg = `获取失败`
  330. if tmpErrMsg != `` {
  331. msg = tmpErrMsg
  332. }
  333. errMsg = "获取图表,指标信息失败, Err:" + err.Error()
  334. return
  335. }
  336. for _, v := range edbList {
  337. // 指标别名
  338. if barConfig.EdbInfoIdList != nil && len(barConfig.EdbInfoIdList) > 0 {
  339. for _, reqEdb := range barConfig.EdbInfoIdList {
  340. if v.EdbInfoId == reqEdb.EdbInfoId {
  341. v.EdbAliasName = reqEdb.Name
  342. }
  343. }
  344. }
  345. }
  346. sourceArr = append(sourceArr, "弘则研究")
  347. chartInfo.ChartSource = strings.Join(sourceArr, ",")
  348. // 访问记录-仅普通用户记录
  349. ok, _, _ := user.GetAdminByUserInfo(userInfo)
  350. if !ok {
  351. go chart.SaveChartVisitLog(userInfo, chartInfo, myChartClassifyId)
  352. }
  353. // 用户是否有收藏该图表
  354. ob := new(yb_my_chart.YbMyChart)
  355. cond := `user_id = ? AND chart_info_id = ?`
  356. pars := make([]interface{}, 0)
  357. pars = append(pars, userInfo.UserID, chartInfo.ChartInfoId)
  358. exists, e := ob.FetchByCondition(cond, pars)
  359. if e != nil && e != utils.ErrNoRow {
  360. msg = `操作失败`
  361. errMsg = "获取用户图表失败, Err: " + e.Error()
  362. return
  363. }
  364. myChartInfo := new(responseModel.MyChartItem)
  365. if exists != nil && exists.MyChartID > 0 {
  366. myChartInfo.MyChartID = exists.MyChartID
  367. myChartInfo.MyChartClassifyID = exists.MyChartClassifyID
  368. myChartInfo.ChartInfoID = exists.ChartInfoID
  369. myChartInfo.ChartName = exists.ChartName
  370. myChartInfo.UniqueCode = exists.UniqueCode
  371. myChartInfo.ChartImage = exists.ChartImage
  372. myChartInfo.UserID = exists.UserID
  373. myChartInfo.ReportID = exists.ReportID
  374. myChartInfo.ReportChapterID = exists.ReportChapterID
  375. myChartInfo.CreateTime = utils.TimeTransferString(utils.FormatDateTime, exists.CreateTime)
  376. }
  377. resp = new(chart_info.ChartInfoDetailResp)
  378. resp.ChartInfo = chartInfo
  379. resp.EdbInfoList = edbList
  380. resp.XEdbIdValue = xEdbIdValue
  381. resp.YDataList = yDataList
  382. resp.MyChartInfo = myChartInfo
  383. resp.DataResp = dataResp
  384. isOk = true
  385. return
  386. }
  387. // RefreshChartInfo 刷新图表信息
  388. // @Tags 图库模块
  389. // @Summary 刷新图表信息
  390. // @Description 刷新图表信息
  391. // @Security ApiKeyAuth
  392. // @Param Authorization header string true "Bearer 31a165baebe6dec616b1f8f3207b4273"
  393. // @Accept json
  394. // @Product json
  395. // @Param data body chartInfoModel.SaveChartInfoReq true "请求参数"
  396. // @Success 200 {string} string "操作成功"
  397. // @failure 400 {string} string "操作失败"
  398. // @Router /my_chart/refreshChartInfo [post]
  399. func RefreshChartInfo(c *gin.Context) {
  400. // 参数校验
  401. var req chartInfoModel.RefreshChartInfoReq
  402. if c.ShouldBind(&req) != nil {
  403. response.Fail("参数异常", c)
  404. return
  405. }
  406. chartInfoId := req.ChartInfoId
  407. if chartInfoId == 0 {
  408. response.Fail("参数有误", c)
  409. return
  410. }
  411. userInfo := user.GetInfoByClaims(c)
  412. ok, _, err := user.GetAdminByUserInfo(userInfo)
  413. if err != nil {
  414. response.FailMsg("刷新失败", "RefreshChartInfo-获取系统用户信息失败"+err.Error(), c)
  415. return
  416. }
  417. if !ok {
  418. // 普通用户刷新频率限制-每个用户/图/天/2次
  419. cacheKey := utils.HZ_CHART_LIB_DETAIL + "YB_REFRESH_LIMIT_" + strconv.Itoa(chartInfoId) + "_" + strconv.Itoa(int(userInfo.UserID))
  420. fmt.Println("refreshCacheKey:", cacheKey)
  421. countUserRefresh, _ := global.Redis.Get(context.TODO(), cacheKey).Int()
  422. if countUserRefresh >= 2 {
  423. response.Ok("目前已是最新数据", c)
  424. return
  425. }
  426. countUserRefresh += 1
  427. now := time.Now()
  428. today := time.Date(now.Year(), now.Month(), now.Day(), 23, 59, 59, 0, time.Local)
  429. sub := today.Sub(now)
  430. _ = global.Redis.SetEX(context.TODO(), cacheKey, countUserRefresh, sub)
  431. }
  432. // 图表信息校验
  433. chartInfo, err := chartInfoModel.GetChartInfoById(chartInfoId)
  434. if err != nil {
  435. if err == utils.ErrNoRow {
  436. response.Fail("图表已被删除,无需刷新", c)
  437. return
  438. }
  439. response.FailMsg("刷新失败", "刷新失败, Err:"+err.Error(), c)
  440. return
  441. }
  442. if chartInfo.Source == utils.CHART_SOURCE_CROSS_HEDGING {
  443. var config request.ChartConfigReq
  444. err = json.Unmarshal([]byte(chartInfo.ExtraConfig), &config)
  445. if err != nil {
  446. response.FailMsg("解析跨品种分析配置失败", "解析跨品种分析配置失败, Err:"+err.Error(), c)
  447. return
  448. }
  449. // 获取关联的指标信息
  450. _, _, edbInfoIdList, err := cross_variety.GetXYEdbIdList(config.TagX, config.TagY, config.VarietyList)
  451. if err != nil {
  452. response.FailMsg("获取指标信息失败", "刷新失败,获取指标信息失败, Err:"+err.Error(), c)
  453. return
  454. }
  455. // 刷新图表
  456. //_ = correlation.ChartInfoRefresh(chartInfo.ChartInfoId)
  457. err, errMsg := chart.EdbInfoRefreshAllFromBase(edbInfoIdList, false)
  458. if err != nil {
  459. errContent := fmt.Sprint("刷新图表关联指标信息失败 errMsg:", errMsg, "err: "+err.Error())
  460. if global.CONFIG.Serve.RunMode == "release" {
  461. go alarm_msg.SendAlarmMsg("刷新图表报错"+time.Now().Format("2006-01-02 15:04:05")+";Err:"+errContent, 3)
  462. //go services.SendEmail("弘则研报小程序-release-刷新图表报错", errContent, utils.EmailSendToUsers)
  463. } else {
  464. global.LOG.Info(errContent)
  465. }
  466. response.FailMsg("刷新失败", "刷新失败,获取指标信息失败, Err:"+err.Error(), c)
  467. return
  468. }
  469. } else {
  470. // 刷新图表
  471. if err = chart.ChartInfoRefreshV2(chartInfo.ChartInfoId); err != nil {
  472. errContent := fmt.Sprint("ErrMsg: 刷新图表关联指标信息失败, " + err.Error())
  473. if global.CONFIG.Serve.RunMode == "release" {
  474. go alarm_msg.SendAlarmMsg("刷新图表报错"+time.Now().Format("2006-01-02 15:04:05")+";Err:"+errContent, 3)
  475. //go services.SendEmail("弘则研报小程序-release-刷新图表报错", errContent, utils.EmailSendToUsers)
  476. } else {
  477. global.LOG.Info(errContent)
  478. }
  479. }
  480. }
  481. //清除图表缓存
  482. {
  483. key := utils.HZ_CHART_LIB_DETAIL + chartInfo.UniqueCode
  484. _ = global.Redis.Del(context.TODO(), key)
  485. }
  486. response.OkData("刷新成功", "", c)
  487. }
  488. // EditChartInfo 编辑图表信息
  489. // @Tags 图库模块
  490. // @Summary 编辑图表信息
  491. // @Description 编辑图表信息
  492. // @Security ApiKeyAuth
  493. // @Param Authorization header string true "Bearer 31a165baebe6dec616b1f8f3207b4273"
  494. // @Accept json
  495. // @Product json
  496. // @Param data body chartInfoModel.SaveChartInfoReq true "请求参数"
  497. // @Success 200 {string} string "操作成功"
  498. // @failure 400 {string} string "操作失败"
  499. // @Router /my_chart/editChartInfo [post]
  500. func EditChartInfo(c *gin.Context) {
  501. // 参数校验
  502. var req chartInfoModel.SaveChartInfoReq
  503. if c.ShouldBind(&req) != nil {
  504. response.Fail("参数异常", c)
  505. return
  506. }
  507. if req.ChartInfoId <= 0 {
  508. response.Fail("参数异常", c)
  509. return
  510. }
  511. // 操作权限校验
  512. userInfo := user.GetInfoByClaims(c)
  513. ok, adminInfo, err := user.GetAdminByUserInfo(userInfo)
  514. if err != nil {
  515. response.Fail("操作人信息有误", c)
  516. return
  517. }
  518. if !ok {
  519. response.Fail("非内部人员无权进行操作", c)
  520. return
  521. }
  522. // 图表信息校验
  523. chartItem, err := chartInfoModel.GetChartInfoById(req.ChartInfoId)
  524. if err != nil {
  525. if err == utils.ErrNoRow {
  526. response.Fail("图表已被删除,请刷新页面!", c)
  527. return
  528. }
  529. response.FailMsg("操作失败", "获取图表信息失败, Err:"+err.Error(), c)
  530. return
  531. }
  532. // 图表关联指标id
  533. chartEdbInfoList := make([]*chartInfoModel.ChartSaveItem, 0)
  534. // 关联指标
  535. var edbInfoIdArr []int
  536. // 非散点截面图的直接通过前端获取,散点截面图需要额外从配置中获取
  537. if chartItem.ChartType != 10 {
  538. //edbList := make([]*data_manage.EdbInfo, 0)
  539. for _, v := range req.ChartEdbInfoList {
  540. edbInfoId := v.EdbInfoId
  541. edbInfo, err := edbInfoModel.GetEdbInfoById(edbInfoId)
  542. if err != nil {
  543. if err == utils.ErrNoRow {
  544. response.FailMsg("操作失败", "图表不存在,ChartInfoId:"+strconv.Itoa(v.EdbInfoId), c)
  545. return
  546. }
  547. response.FailMsg("操作失败", "获取图表的指标信息失败,Err:"+err.Error(), c)
  548. return
  549. }
  550. if edbInfo == nil {
  551. response.FailMsg("操作失败", "指标不存在,ChartInfoId:"+strconv.Itoa(v.EdbInfoId), c)
  552. return
  553. }
  554. if edbInfo.EdbInfoId <= 0 {
  555. response.FailMsg("指标已被删除,请重新选择!", "指标不存在,ChartInfoId:"+strconv.Itoa(v.EdbInfoId), c)
  556. return
  557. }
  558. edbInfoIdArr = append(edbInfoIdArr, edbInfoId)
  559. edbInfo.EdbNameSource = edbInfo.EdbName
  560. //edbList = append(edbList, edbInfo)
  561. }
  562. chartEdbInfoList = req.ChartEdbInfoList
  563. } else {
  564. if req.ExtraConfig == `` {
  565. response.FailMsg("请选择指标!", "请选择指标!, Err:"+err.Error(), c)
  566. return
  567. }
  568. // 校验配置的指标列表
  569. tmpEdbInfoIdArr, err, errMsg := chart.CheckChartExtraConfig(chartItem.ChartType, req.ExtraConfig)
  570. if err != nil {
  571. response.FailMsg(errMsg, "修改失败!, Err:"+err.Error(), c)
  572. return
  573. }
  574. edbInfoIdArr = tmpEdbInfoIdArr
  575. lenEdbInfoIdArr := len(edbInfoIdArr)
  576. if lenEdbInfoIdArr > 0 {
  577. tmpEdbList, err := edbInfoModel.GetEdbInfoByIdList(edbInfoIdArr)
  578. if err != nil {
  579. response.FailMsg("指标异常!", "指标异常!, Err:"+err.Error(), c)
  580. return
  581. }
  582. if len(tmpEdbList) != lenEdbInfoIdArr {
  583. response.FailMsg("指标异常!", fmt.Sprint("查找出来的指标数量与选择的指标数量不符!查找出来的指标数量:", len(tmpEdbList), ";用户选择的指标数量:", lenEdbInfoIdArr), c)
  584. return
  585. }
  586. for _, v := range tmpEdbList {
  587. chartEdbInfoList = append(chartEdbInfoList, &chartInfoModel.ChartSaveItem{
  588. EdbInfoId: v.EdbInfoId,
  589. MaxData: 0,
  590. MinData: 0,
  591. IsOrder: false,
  592. IsAxis: 1,
  593. EdbInfoType: 1,
  594. LeadValue: 0,
  595. LeadUnit: "",
  596. ChartStyle: "",
  597. ChartColor: "",
  598. //PredictChartColor: "",
  599. ChartWidth: 0,
  600. Source: utils.CHART_SOURCE_DEFAULT,
  601. })
  602. }
  603. }
  604. }
  605. if len(edbInfoIdArr) <= 0 {
  606. response.Fail("请选择指标!", c)
  607. return
  608. }
  609. if chartItem.ChartType == 2 && len(req.ChartEdbInfoList) > 1 {
  610. response.Fail("您选择的图表样式为季节性图表,只支持单指标画图!", c)
  611. return
  612. }
  613. if req.Calendar == "" {
  614. req.Calendar = "公历"
  615. }
  616. sort.Ints(edbInfoIdArr)
  617. var edbInfoIdArrStr []string
  618. for _, v := range edbInfoIdArr {
  619. edbInfoIdArrStr = append(edbInfoIdArrStr, strconv.Itoa(v))
  620. }
  621. edbInfoIdStr := strings.Join(edbInfoIdArrStr, ",")
  622. err = chart.ModifyChartInfoAndMapping(edbInfoIdStr, &req, chartItem.ChartType, chartEdbInfoList)
  623. if err != nil {
  624. response.Fail("图表保存失败, Err:"+err.Error(), c)
  625. return
  626. }
  627. // 清除图表缓存
  628. cacheKey := utils.HZ_CHART_LIB_DETAIL + chartItem.UniqueCode
  629. _ = global.Redis.Del(context.TODO(), cacheKey)
  630. // 新增操作日志
  631. {
  632. chartLog := new(chart_info_log.ChartInfoLog)
  633. chartLog.ChartName = chartItem.ChartName
  634. chartLog.ChartInfoId = req.ChartInfoId
  635. chartLog.ChartClassifyId = chartItem.ChartClassifyId
  636. chartLog.SysUserId = int(adminInfo.AdminID)
  637. chartLog.SysUserRealName = adminInfo.RealName
  638. chartLog.UniqueCode = chartItem.UniqueCode
  639. chartLog.CreateTime = time.Now()
  640. bodyBytes, _ := json.Marshal(req)
  641. chartLog.Content = string(bodyBytes)
  642. chartLog.Status = "修改配置项"
  643. chartLog.Method = c.Request.URL.String()
  644. go chartLog.Create()
  645. }
  646. response.OkData("操作成功", "", c)
  647. }