chart_theme.go 22 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707
  1. package data
  2. import (
  3. "encoding/json"
  4. "errors"
  5. "eta/eta_api/models/data_manage"
  6. "eta/eta_api/models/data_manage/chart_theme"
  7. "eta/eta_api/models/data_manage/chart_theme/request"
  8. "eta/eta_api/utils"
  9. "fmt"
  10. "github.com/shopspring/decimal"
  11. "math"
  12. "time"
  13. )
  14. // GetThemePreviewChartEdbData 获取图表的指标数据
  15. func GetThemePreviewChartEdbData(chartType int, calendar, startDate, endDate string, mappingList []*data_manage.ChartEdbInfoMapping, extraConfigStr string, seasonExtraConfig string) (edbList []*data_manage.ChartEdbInfoMapping, xEdbIdValue []int, yDataList []data_manage.YData, dataResp interface{}, err error, errMsg string) {
  16. edbList = make([]*data_manage.ChartEdbInfoMapping, 0)
  17. xEdbIdValue = make([]int, 0)
  18. yDataList = make([]data_manage.YData, 0)
  19. var extraConfig interface{}
  20. switch chartType {
  21. case 7: // 柱形图
  22. var barConfig data_manage.BarChartInfoReq
  23. if extraConfigStr == `` {
  24. errMsg = "柱方图未配置"
  25. err = errors.New(errMsg)
  26. return
  27. }
  28. err = json.Unmarshal([]byte(extraConfigStr), &barConfig)
  29. if err != nil {
  30. errMsg = "柱方图配置异常"
  31. err = errors.New(errMsg)
  32. return
  33. }
  34. extraConfig = barConfig
  35. case 10: // 截面散点图
  36. var tmpExtraConfig data_manage.SectionScatterReq
  37. if extraConfigStr == `` {
  38. errMsg = "截面散点图未配置"
  39. err = errors.New(errMsg)
  40. return
  41. }
  42. err = json.Unmarshal([]byte(extraConfigStr), &tmpExtraConfig)
  43. if err != nil {
  44. errMsg = "截面散点配置异常"
  45. err = errors.New(errMsg)
  46. return
  47. }
  48. extraConfig = tmpExtraConfig
  49. case utils.CHART_TYPE_RADAR:
  50. var barConfig data_manage.RadarChartInfoReq
  51. if extraConfigStr == `` {
  52. errMsg = "雷达图未配置"
  53. err = errors.New(errMsg)
  54. return
  55. }
  56. err = json.Unmarshal([]byte(extraConfigStr), &barConfig)
  57. if err != nil {
  58. errMsg = "雷达图配置异常"
  59. err = errors.New(errMsg)
  60. return
  61. }
  62. extraConfig = barConfig
  63. default:
  64. xEdbIdValue = make([]int, 0)
  65. yDataList = make([]data_manage.YData, 0)
  66. }
  67. // 指标对应的所有数据
  68. edbDataListMap, edbList, err := getThemePreviewEdbDataMapList(chartType, calendar, startDate, endDate, mappingList, seasonExtraConfig)
  69. if err != nil {
  70. return
  71. }
  72. // 特殊图形数据处理
  73. switch chartType {
  74. case 7: // 柱形图
  75. barChartConf := extraConfig.(data_manage.BarChartInfoReq)
  76. xEdbIdValue, yDataList, err = BarChartData(mappingList, edbDataListMap, barChartConf.DateList, barChartConf.Sort)
  77. for k := range yDataList {
  78. yDataList[k].Unit = barChartConf.Unit
  79. yDataList[k].UnitEn = barChartConf.UnitEn
  80. }
  81. for _, v := range edbList {
  82. // 指标别名
  83. if barChartConf.EdbInfoIdList != nil && len(barChartConf.EdbInfoIdList) > 0 {
  84. for _, reqEdb := range barChartConf.EdbInfoIdList {
  85. if v.EdbInfoId == reqEdb.EdbInfoId {
  86. v.EdbAliasName = reqEdb.Name
  87. }
  88. }
  89. }
  90. }
  91. case 10: // 截面散点图
  92. sectionScatterConf := extraConfig.(data_manage.SectionScatterReq)
  93. xEdbIdValue, dataResp, err = getThemePreviewSectionScatterChartData(mappingList, edbDataListMap, sectionScatterConf)
  94. var tmpExtraConfig data_manage.SectionScatterReq
  95. if extraConfigStr == `` {
  96. errMsg = "截面散点图未配置"
  97. err = errors.New(errMsg)
  98. return
  99. }
  100. err = json.Unmarshal([]byte(extraConfigStr), &tmpExtraConfig)
  101. if err != nil {
  102. errMsg = "截面散点配置异常"
  103. err = errors.New(errMsg)
  104. return
  105. }
  106. // 这个数据没有必要返回给前端
  107. for _, v := range edbList {
  108. v.DataList = nil
  109. }
  110. case utils.CHART_TYPE_RADAR: //雷达图
  111. radarConf := extraConfig.(data_manage.RadarChartInfoReq)
  112. xEdbIdValue, dataResp, err = RadarChartData(mappingList, edbDataListMap, radarConf)
  113. case utils.CHART_TYPE_SECTION_COMBINE: // 截面组合图
  114. var sectionConf data_manage.ChartSectionAllExtraConf
  115. if extraConfigStr == `` {
  116. errMsg = "截面散点图未配置"
  117. err = errors.New(errMsg)
  118. return
  119. }
  120. err = json.Unmarshal([]byte(extraConfigStr), &sectionConf)
  121. if err != nil {
  122. errMsg = "截面散点配置异常"
  123. err = errors.New(errMsg + err.Error())
  124. return
  125. }
  126. // edbIdList 指标展示顺序;x轴的指标顺序
  127. xEdbIdValue = make([]int, 0)
  128. for _, v := range mappingList {
  129. xEdbIdValue = append(xEdbIdValue, v.EdbInfoId)
  130. }
  131. for k, _ := range sectionConf.SeriesList {
  132. if k == 0 {
  133. sectionConf.SeriesList[k].DataList = []float64{1455, 1076, 2532, 3729}
  134. sectionConf.SeriesList[k].MaxData = 3729
  135. sectionConf.SeriesList[k].MinData = 1076
  136. }
  137. if k == 1 {
  138. sectionConf.SeriesList[k].DataList = []float64{13, 12, 12, 14}
  139. sectionConf.SeriesList[k].MaxData = 14
  140. sectionConf.SeriesList[k].MinData = 12
  141. }
  142. }
  143. dataResp = &data_manage.ChartSectionCombineDataResp{
  144. DateConfList: sectionConf.DateConfList,
  145. IsHeap: sectionConf.IsHeap,
  146. XDataList: sectionConf.XDataList,
  147. UnitList: sectionConf.UnitList,
  148. BaseChartSeriesName: sectionConf.BaseChartSeriesName,
  149. SortType: sectionConf.SortType,
  150. SeriesList: sectionConf.SeriesList,
  151. LeftMin: "0",
  152. LeftMax: "4000",
  153. RightMin: "10",
  154. RightMax: "15",
  155. }
  156. // 这个数据没有必要返回给前端
  157. for _, v := range edbList {
  158. v.DataList = nil
  159. }
  160. }
  161. return
  162. }
  163. func getThemePreviewEdbDataMapList(chartType int, calendar, startDate, endDate string, mappingList []*data_manage.ChartEdbInfoMapping, seasonExtraConfig string) (edbDataListMap map[int][]*data_manage.EdbDataList, edbList []*data_manage.ChartEdbInfoMapping, err error) {
  164. // 指标对应的所有数据
  165. edbDataListMap = make(map[int][]*data_manage.EdbDataList)
  166. for _, v := range mappingList {
  167. //fmt.Println("v:", v.EdbInfoId)
  168. item := new(data_manage.ChartEdbInfoMapping)
  169. item.EdbInfoId = v.EdbInfoId
  170. item.SourceName = v.SourceName
  171. item.Source = v.Source
  172. item.EdbCode = v.EdbCode
  173. item.EdbName = v.EdbName
  174. item.EdbNameEn = v.EdbNameEn
  175. item.Frequency = v.Frequency
  176. item.EdbType = v.EdbType
  177. item.FrequencyEn = GetFrequencyEn(v.Frequency)
  178. if v.Unit != `无` {
  179. item.Unit = v.Unit
  180. }
  181. item.UnitEn = v.UnitEn
  182. item.StartDate = v.StartDate
  183. item.EndDate = v.EndDate
  184. item.ModifyTime = v.ModifyTime
  185. item.EdbInfoCategoryType = v.EdbInfoCategoryType
  186. item.PredictChartColor = v.PredictChartColor
  187. item.ClassifyId = v.ClassifyId
  188. item.IsAxis = 1
  189. item.EdbInfoType = 1
  190. item.LeadValue = v.LeadValue
  191. item.LeadUnit = v.LeadUnit
  192. item.LeadUnitEn = GetLeadUnitEn(v.LeadUnit)
  193. item.ChartEdbMappingId = v.ChartEdbMappingId
  194. item.ChartInfoId = v.ChartInfoId
  195. item.ChartStyle = v.ChartStyle
  196. item.ChartColor = v.ChartColor
  197. item.ChartWidth = 0
  198. item.IsOrder = false
  199. item.MaxData = v.MaxValue
  200. item.MinData = v.MinValue
  201. item.LatestValue = v.LatestValue
  202. item.LatestDate = v.LatestDate
  203. item.UniqueCode = v.UniqueCode
  204. item.MoveLatestDate = v.LatestDate
  205. var startDateReal string
  206. var diffSeconds int64
  207. if chartType == 2 { //季节性图
  208. startDateReal = startDate
  209. } else {
  210. if v.EdbInfoType == 0 && v.LeadUnit != "" && v.LeadValue > 0 { //领先指标
  211. var startTimeRealTemp time.Time
  212. startDateParse, _ := time.Parse(utils.FormatDate, startDate)
  213. switch v.LeadUnit {
  214. case "天":
  215. startTimeRealTemp = startDateParse.AddDate(0, 0, -v.LeadValue)
  216. case "月":
  217. startTimeRealTemp = startDateParse.AddDate(0, -v.LeadValue, 0)
  218. case "季":
  219. startTimeRealTemp = startDateParse.AddDate(0, -3*v.LeadValue, 0)
  220. case "周":
  221. startTimeRealTemp = startDateParse.AddDate(0, 0, -7*v.LeadValue)
  222. case "年":
  223. startTimeRealTemp = startDateParse.AddDate(-v.LeadValue, 0, 0)
  224. }
  225. if startTimeRealTemp.Before(startDateParse) {
  226. startDateReal = startTimeRealTemp.Format(utils.FormatDate)
  227. diffSeconds = (int64(startTimeRealTemp.UnixNano()) - int64(startDateParse.UnixNano())) / 1e6
  228. } else {
  229. startDateReal = startDate
  230. diffSeconds = 0
  231. }
  232. // 预测指标的开始日期也要偏移
  233. {
  234. day, tmpErr := utils.GetDaysBetween2Date(utils.FormatDate, startDate, startDateReal)
  235. if tmpErr != nil {
  236. err = tmpErr
  237. return
  238. }
  239. moveLatestDateTime, tmpErr := time.ParseInLocation(utils.FormatDate, item.MoveLatestDate, time.Local)
  240. if tmpErr != nil {
  241. err = tmpErr
  242. return
  243. }
  244. item.MoveLatestDate = moveLatestDateTime.AddDate(0, 0, day).Format(utils.FormatDate)
  245. }
  246. } else {
  247. startDateReal = startDate
  248. }
  249. }
  250. dataList := make([]*data_manage.EdbDataList, 0)
  251. dataList, err = chart_theme.GetChartThemeDefaultDataItemList(v.EdbInfoId, startDateReal)
  252. if err != nil {
  253. return
  254. }
  255. edbDataListMap[v.EdbInfoId] = dataList
  256. if diffSeconds != 0 && v.EdbInfoType == 0 {
  257. dataListLen := len(dataList)
  258. for i := 0; i < dataListLen; i++ {
  259. dataList[i].DataTimestamp = dataList[i].DataTimestamp - diffSeconds
  260. }
  261. }
  262. if chartType == 2 {
  263. latestDate, tmpErr := time.Parse(utils.FormatDate, v.LatestDate)
  264. if tmpErr != nil {
  265. //item.DataList = dataList
  266. item.IsNullData = true
  267. edbList = append(edbList, item)
  268. continue
  269. }
  270. quarterDataList, tErr := GetSeasonEdbInfoDataListByXDate(dataList, latestDate, seasonExtraConfig)
  271. if tErr != nil {
  272. err = errors.New("获取季节性图表数据失败,Err:" + tErr.Error())
  273. return
  274. }
  275. item.DataList = quarterDataList
  276. } else if chartType == 7 || chartType == utils.CHART_TYPE_RADAR { //柱方图
  277. //item.DataList = dataList
  278. } else {
  279. item.DataList = dataList
  280. }
  281. edbList = append(edbList, item)
  282. }
  283. return
  284. }
  285. func getThemePreviewSectionScatterChartData(mappingList []*data_manage.ChartEdbInfoMapping, edbDataListMap map[int][]*data_manage.EdbDataList, extraConfig data_manage.SectionScatterReq) (edbIdList []int, chartDataResp data_manage.SectionScatterInfoResp, err error) {
  286. // 指标数据数组(10086:{"2022-12-02":100.01,"2022-12-01":102.3})
  287. edbDataMap := make(map[int]map[string]float64)
  288. for edbInfoId, edbDataList := range edbDataListMap {
  289. edbDateData := make(map[string]float64)
  290. for _, edbData := range edbDataList {
  291. edbDateData[edbData.DataTime] = edbData.Value
  292. }
  293. edbDataMap[edbInfoId] = edbDateData
  294. }
  295. // edbIdList 指标展示顺序;x轴的指标顺序
  296. edbIdList = make([]int, 0)
  297. edbMappingMap := make(map[int]*data_manage.ChartEdbInfoMapping)
  298. for _, v := range mappingList {
  299. edbIdList = append(edbIdList, v.EdbInfoId)
  300. edbMappingMap[v.EdbInfoId] = v
  301. }
  302. //SectionScatterSeriesInfoResp
  303. dataListResp := make([]data_manage.SectionScatterSeriesItemResp, 0) //y轴的数据列表
  304. for _, seriesItem := range extraConfig.SeriesList {
  305. var maxDate time.Time
  306. // 系列中的指标数据
  307. tmpSeriesEdbInfoList := make([]data_manage.SectionScatterEdbItemResp, 0)
  308. var minXVal, maxXVal, minYVal, maxYVal float64
  309. for _, edbConf := range seriesItem.EdbInfoList {
  310. tmpItem := data_manage.SectionScatterEdbItemResp{
  311. IsShow: edbConf.IsShow,
  312. Name: edbConf.Name,
  313. NameEn: edbConf.NameEn,
  314. } //单个坐标点的数据
  315. //X轴的数据
  316. {
  317. edbInfoId := edbConf.XEdbInfoId //X轴的指标
  318. edbMappingInfo, ok := edbMappingMap[edbInfoId]
  319. if !ok {
  320. continue
  321. }
  322. findDate := edbConf.XDate //需要的日期值
  323. dataList := edbDataListMap[edbInfoId] //指标的所有数据值
  324. if len(dataList) <= 0 {
  325. // 没有数据的指标id
  326. //findDataList = append(findDataList, 0)
  327. continue
  328. }
  329. tmpItem.XEdbInfoId = edbInfoId
  330. tmpItem.XName = edbMappingInfo.EdbName
  331. tmpItem.XNameEn = edbMappingInfo.EdbNameEn
  332. switch edbConf.XDateType {
  333. case 1: //最新值
  334. findDate = dataList[len(dataList)-1].DataTime
  335. case 2: //近期几天
  336. findDateTime, tmpErr := time.ParseInLocation(utils.FormatDate, dataList[len(dataList)-1].DataTime, time.Local)
  337. if tmpErr != nil {
  338. err = tmpErr
  339. return
  340. }
  341. findDateTime = findDateTime.AddDate(0, 0, -edbConf.XDateValue)
  342. lenData := len(dataList) - 1
  343. for i := lenData; i >= 0; i-- {
  344. currDateTime, tmpErr := time.ParseInLocation(utils.FormatDate, dataList[i].DataTime, time.Local)
  345. if tmpErr != nil {
  346. err = tmpErr
  347. return
  348. }
  349. if currDateTime.Equal(findDateTime) || currDateTime.Before(findDateTime) {
  350. findDate = dataList[i].DataTime
  351. break
  352. }
  353. }
  354. case 3: // 固定日期
  355. //最早的日期
  356. minDateTime, tmpErr := time.ParseInLocation(utils.FormatDate, dataList[0].DataTime, time.Local)
  357. if tmpErr != nil {
  358. err = tmpErr
  359. return
  360. }
  361. //寻找固定日期的数据
  362. findDateTime, tmpErr := time.ParseInLocation(utils.FormatDate, edbConf.XDate, time.Local)
  363. if tmpErr != nil {
  364. err = tmpErr
  365. return
  366. }
  367. for tmpDateTime := findDateTime; tmpDateTime.After(minDateTime) || tmpDateTime.Equal(minDateTime); tmpDateTime = tmpDateTime.AddDate(0, 0, -1) {
  368. tmpDate := tmpDateTime.Format(utils.FormatDate)
  369. if _, ok := edbDataMap[edbInfoId][tmpDate]; ok { //如果能找到数据,那么就返回
  370. findDate = tmpDate
  371. break
  372. }
  373. }
  374. default:
  375. err = errors.New(fmt.Sprint("日期类型异常,Type:", edbConf.XDate))
  376. return
  377. }
  378. findDateTime, _ := time.ParseInLocation(utils.FormatDate, findDate, time.Local)
  379. if maxDate.IsZero() {
  380. maxDate = findDateTime
  381. } else {
  382. if findDateTime.After(maxDate) {
  383. maxDate = findDateTime
  384. }
  385. }
  386. if tmpValue, ok := edbDataMap[edbInfoId][findDate]; ok {
  387. tmpItem.XDate = findDate
  388. tmpItem.XValue = tmpValue
  389. } else {
  390. continue
  391. }
  392. }
  393. //Y轴的数据
  394. {
  395. edbInfoId := edbConf.YEdbInfoId //Y轴的指标
  396. edbMappingInfo, ok := edbMappingMap[edbInfoId]
  397. if !ok {
  398. continue
  399. }
  400. findDate := edbConf.YDate //需要的日期值
  401. dataList := edbDataListMap[edbInfoId] //指标的所有数据值
  402. if len(dataList) <= 0 {
  403. // 没有数据的指标id
  404. //findDataList = append(findDataList, 0)
  405. continue
  406. }
  407. tmpItem.YEdbInfoId = edbInfoId
  408. tmpItem.YName = edbMappingInfo.EdbName
  409. tmpItem.YNameEn = edbMappingInfo.EdbNameEn
  410. switch edbConf.YDateType {
  411. case 1: //最新值
  412. findDate = dataList[len(dataList)-1].DataTime
  413. case 2: //近期几天
  414. findDateTime, tmpErr := time.ParseInLocation(utils.FormatDate, dataList[len(dataList)-1].DataTime, time.Local)
  415. if tmpErr != nil {
  416. err = tmpErr
  417. return
  418. }
  419. findDateTime = findDateTime.AddDate(0, 0, -edbConf.YDateValue)
  420. lenData := len(dataList) - 1
  421. for i := lenData; i >= 0; i-- {
  422. currDateTime, tmpErr := time.ParseInLocation(utils.FormatDate, dataList[i].DataTime, time.Local)
  423. if tmpErr != nil {
  424. err = tmpErr
  425. return
  426. }
  427. if currDateTime.Equal(findDateTime) || currDateTime.Before(findDateTime) {
  428. findDate = dataList[i].DataTime
  429. break
  430. }
  431. }
  432. case 3: // 固定日期
  433. //最早的日期
  434. minDateTime, tmpErr := time.ParseInLocation(utils.FormatDate, dataList[0].DataTime, time.Local)
  435. if tmpErr != nil {
  436. err = tmpErr
  437. return
  438. }
  439. //寻找固定日期的数据
  440. findDateTime, tmpErr := time.ParseInLocation(utils.FormatDate, edbConf.YDate, time.Local)
  441. if tmpErr != nil {
  442. err = tmpErr
  443. return
  444. }
  445. for tmpDateTime := findDateTime; tmpDateTime.After(minDateTime) || tmpDateTime.Equal(minDateTime); tmpDateTime = tmpDateTime.AddDate(0, 0, -1) {
  446. tmpDate := tmpDateTime.Format(utils.FormatDate)
  447. if _, ok := edbDataMap[edbInfoId][tmpDate]; ok { //如果能找到数据,那么就返回
  448. findDate = tmpDate
  449. break
  450. }
  451. }
  452. default:
  453. err = errors.New(fmt.Sprint("日期类型异常,Type:", edbConf.YDate))
  454. return
  455. }
  456. findDateTime, _ := time.ParseInLocation(utils.FormatDate, findDate, time.Local)
  457. if maxDate.IsZero() {
  458. maxDate = findDateTime
  459. } else {
  460. if findDateTime.After(maxDate) {
  461. maxDate = findDateTime
  462. }
  463. }
  464. if tmpValue, ok := edbDataMap[edbInfoId][findDate]; ok {
  465. tmpItem.YDate = findDate
  466. tmpItem.YValue = tmpValue
  467. } else {
  468. continue
  469. }
  470. }
  471. // 获取当前系列的X轴的最大最小值
  472. {
  473. if tmpItem.XValue < minXVal {
  474. minXVal = tmpItem.XValue
  475. }
  476. if tmpItem.XValue > maxXVal {
  477. maxXVal = tmpItem.XValue
  478. }
  479. if tmpItem.YValue < minYVal {
  480. minYVal = tmpItem.YValue
  481. }
  482. if tmpItem.YValue > maxYVal {
  483. maxYVal = tmpItem.YValue
  484. }
  485. }
  486. tmpSeriesEdbInfoList = append(tmpSeriesEdbInfoList, tmpItem)
  487. }
  488. trendLimitData := make([]data_manage.CoordinatePoint, 0) //趋势线的前后坐标点
  489. var trendLine, rSquare string
  490. // 生成线性方程式
  491. var a, b float64
  492. {
  493. coordinateData := make([]utils.Coordinate, 0)
  494. for _, tmpSeriesEdbInfo := range tmpSeriesEdbInfoList {
  495. tmpCoordinate1 := utils.Coordinate{
  496. X: tmpSeriesEdbInfo.XValue,
  497. Y: tmpSeriesEdbInfo.YValue,
  498. }
  499. coordinateData = append(coordinateData, tmpCoordinate1)
  500. }
  501. // 只有存在两个坐标点的时候,才能去计算线性方程和R平方
  502. if len(coordinateData) >= 2 {
  503. a, b = utils.GetLinearResult(coordinateData)
  504. if !math.IsNaN(a) && !math.IsNaN(b) {
  505. if b > 0 {
  506. trendLine = fmt.Sprintf("y=%sx+%s", utils.SubFloatToString(a, 4), utils.SubFloatToString(b, 4))
  507. } else {
  508. trendLine = fmt.Sprintf("y=%sx%s", utils.SubFloatToString(a, 4), utils.SubFloatToString(b, 4))
  509. }
  510. minYVal, _ = decimal.NewFromFloat(a).Mul(decimal.NewFromFloat(minXVal)).Add(decimal.NewFromFloat(b)).Round(4).Float64()
  511. maxYVal, _ = decimal.NewFromFloat(a).Mul(decimal.NewFromFloat(maxXVal)).Add(decimal.NewFromFloat(b)).Round(4).Float64()
  512. }
  513. // 计算R平方
  514. rSquare = fmt.Sprint(utils.CalculationDecisive(coordinateData))
  515. }
  516. trendLimitData = append(trendLimitData, data_manage.CoordinatePoint{
  517. X: minXVal,
  518. Y: minYVal,
  519. }, data_manage.CoordinatePoint{
  520. X: maxXVal,
  521. Y: maxYVal,
  522. })
  523. }
  524. dataListResp = append(dataListResp, data_manage.SectionScatterSeriesItemResp{
  525. Name: seriesItem.Name,
  526. NameEn: seriesItem.NameEn,
  527. IsNameDefault: seriesItem.IsNameDefault,
  528. Color: seriesItem.Color,
  529. EdbInfoList: tmpSeriesEdbInfoList,
  530. ShowTrendLine: seriesItem.ShowTrendLine,
  531. ShowFitEquation: seriesItem.ShowFitEquation,
  532. ShowRSquare: seriesItem.ShowRSquare,
  533. TrendLine: trendLine,
  534. RSquare: rSquare,
  535. TrendLimitData: trendLimitData,
  536. })
  537. }
  538. // 截面散点图点击详情时自动更新系列名
  539. if len(extraConfig.SeriesList) > 0 {
  540. // 默认名字的时候才自动更新
  541. if extraConfig.SeriesList[0].IsNameDefault {
  542. firstXEdbInfoId := extraConfig.SeriesList[0].EdbInfoList[0].XEdbInfoId
  543. if v, ok := edbMappingMap[firstXEdbInfoId]; ok {
  544. extraConfig.SeriesList[0].Name = v.LatestDate
  545. extraConfig.SeriesList[0].NameEn = v.LatestDate
  546. dataListResp[0].Name = v.LatestDate
  547. dataListResp[0].NameEn = v.LatestDate
  548. }
  549. }
  550. }
  551. chartDataResp = data_manage.SectionScatterInfoResp{
  552. XName: extraConfig.XName,
  553. XNameEn: extraConfig.XNameEn,
  554. XUnitName: extraConfig.XUnitName,
  555. XUnitNameEn: extraConfig.XUnitNameEn,
  556. YName: extraConfig.YName,
  557. YNameEn: extraConfig.YNameEn,
  558. YUnitName: extraConfig.YUnitName,
  559. YUnitNameEn: extraConfig.YUnitNameEn,
  560. XMinValue: extraConfig.XMinValue,
  561. XMaxValue: extraConfig.XMaxValue,
  562. YMinValue: extraConfig.YMinValue,
  563. YMaxValue: extraConfig.YMaxValue,
  564. DataList: dataListResp,
  565. }
  566. return
  567. }
  568. // GetChartThemeConfig
  569. // @Description: 根据主题id获取主题信息,如果获取不到的话,那么就获取默认的主题
  570. // @author: Roc
  571. // @datetime 2023-12-19 14:31:17
  572. // @param chartThemeId int
  573. // @param chartType int
  574. // @param source int
  575. // @return chartTheme *chart_theme.ChartTheme
  576. // @return err error
  577. func GetChartThemeConfig(chartThemeId, source, chartType int) (chartTheme *chart_theme.ChartTheme, err error) {
  578. chartTheme, err = chart_theme.GetChartThemeId(chartThemeId)
  579. if err != nil && err.Error() != utils.ErrNoRow() {
  580. return
  581. }
  582. err = nil
  583. // 如果找到了,那么就返回
  584. if chartTheme != nil {
  585. // 兼容历史数据,加入新字段LineOptionList
  586. newConfig, e := ConvertOldChartOptions(chartTheme.Config)
  587. if e == nil {
  588. chartTheme.Config = newConfig
  589. }
  590. return
  591. }
  592. // 没有找到的话,那么就找默认的主题
  593. // 查找主题类型id
  594. chartThemeType, err := chart_theme.GetChartThemeTypeByChartTypeAndSource(chartType, source)
  595. if err != nil {
  596. return
  597. }
  598. // 寻找默认的主题id
  599. chartTheme, err = chart_theme.GetChartThemeId(chartThemeType.DefaultChartThemeId)
  600. if err != nil && err.Error() != utils.ErrNoRow() {
  601. return
  602. }
  603. err = nil
  604. // 如果找到了,那么就返回
  605. if chartTheme != nil {
  606. // 兼容历史数据,加入新字段LineOptionList
  607. newConfig, e := ConvertOldChartOptions(chartTheme.Config)
  608. if e == nil {
  609. chartTheme.Config = newConfig
  610. }
  611. return
  612. }
  613. // 如果还是没找到,那就系统的主题id
  614. chartTheme, err = chart_theme.GetSystemChartTheme(chartThemeType.ChartThemeTypeId)
  615. // 兼容历史数据,加入新字段LineOptionList
  616. newConfig, e := ConvertOldChartOptions(chartTheme.Config)
  617. if e == nil {
  618. chartTheme.Config = newConfig
  619. }
  620. return
  621. }
  622. // 兼容历史数据,加入新字段LineOptionList
  623. func ConvertOldChartOptions(config string) (newConfig string, err error) {
  624. var oldTheme request.OldChartOptions
  625. var newTheme request.NewChartOptions
  626. err = json.Unmarshal([]byte(config), &oldTheme)
  627. if err != nil {
  628. return
  629. }
  630. if oldTheme.LineOptionList != nil && len(oldTheme.LineOptionList) > 0 {
  631. newConfig = config
  632. return
  633. }
  634. newTheme.OldChartOptions = oldTheme
  635. for i := 0; i < 10; i++ {
  636. newLineOption := request.NewLineOptions{
  637. LineOptions: oldTheme.LineOptions,
  638. Color: oldTheme.ColorsOptions[i],
  639. DataMark: "none",
  640. MarkType: "square",
  641. MarkSize: 5,
  642. MarkColor: oldTheme.ColorsOptions[i],
  643. }
  644. newTheme.LineOptionList = append(newTheme.LineOptionList, newLineOption)
  645. }
  646. newThemeStr, _ := json.Marshal(newTheme)
  647. newConfig = string(newThemeStr)
  648. return
  649. }