chart.go 22 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809
  1. package cross_variety
  2. import (
  3. "encoding/json"
  4. "errors"
  5. "eta/eta_mobile/models/data_manage"
  6. cross_varietyModel "eta/eta_mobile/models/data_manage/cross_variety"
  7. "eta/eta_mobile/models/data_manage/cross_variety/request"
  8. "eta/eta_mobile/models/system"
  9. "eta/eta_mobile/services/data"
  10. "eta/eta_mobile/utils"
  11. "fmt"
  12. "github.com/shopspring/decimal"
  13. "strconv"
  14. "strings"
  15. "time"
  16. )
  17. // ChartInfoResp 截面散点图数据
  18. type ChartInfoResp struct {
  19. XName string `description:"x轴名称"`
  20. XNameEn string `description:"x轴名称(英文)"`
  21. XUnitName string `description:"x轴单位名称"`
  22. XUnitNameEn string `description:"x轴单位名称(英文)"`
  23. YName string `description:"y轴名称"`
  24. YNameEn string `description:"y轴名称(英文)"`
  25. YUnitName string `description:"y轴单位名称"`
  26. YUnitNameEn string `description:"y轴单位名称(英文)"`
  27. XMinValue string `description:"X轴的最小值"`
  28. XMaxValue string `description:"X轴的最大值"`
  29. YMinValue string `description:"Y轴的最小值"`
  30. YMaxValue string `description:"Y轴的最大值"`
  31. DataList []SectionScatterSeriesItemResp `description:"数据列"`
  32. }
  33. // SectionScatterSeriesItemResp 系列的返回
  34. type SectionScatterSeriesItemResp struct {
  35. Name string `description:"系列名"`
  36. NameEn string `description:"系列名(英文)"`
  37. Color string `description:"颜色"`
  38. CoordinatePointData []CoordinatePoint `description:"趋势线的前后坐标点"`
  39. }
  40. // SectionScatterEdbItemResp 截面散点的返回参数
  41. type SectionScatterEdbItemResp struct {
  42. XEdbInfoId int `description:"X轴指标id"`
  43. XDate string `description:"X轴指标实际日期"`
  44. XName string `description:"X轴指标名称"`
  45. XNameEn string `description:"X轴指标英文名称"`
  46. XValue float64 `description:"X轴实际值"`
  47. YEdbInfoId int `description:"Y轴指标id"`
  48. YDate string `description:"Y轴指标实际日期"`
  49. YName string `description:"Y轴指标名称"`
  50. YNameEn string `description:"Y轴指标英文名称"`
  51. YValue float64 `description:"Y轴实际值"`
  52. IsShow bool `description:"是否展示"`
  53. Name string `description:"标签名称"`
  54. NameEn string `description:"英文标签名称"`
  55. }
  56. // CoordinatePoint 坐标点
  57. type CoordinatePoint struct {
  58. X float64
  59. Y float64
  60. XEdbInfoId int
  61. YEdbInfoId int
  62. XDate string
  63. YDate string
  64. }
  65. // GetChartData
  66. // @Description: 获取跨品种分析图表数据
  67. // @author: Roc
  68. // @datetime 2023-11-24 09:42:59
  69. // @param chartInfoId int
  70. // @param config request.ChartConfigReq
  71. // @return edbList []*data_manage.ChartEdbInfoMapping
  72. // @return dataResp ChartInfoResp
  73. // @return err error
  74. // @return errMsg string
  75. // @return isSendEmail bool
  76. func GetChartData(chartInfoId int, config request.ChartConfigReq) (edbList []*data_manage.ChartEdbInfoMapping, dataResp ChartInfoResp, err error, errMsg string, isSendEmail bool) {
  77. moveUnitDays, ok := utils.FrequencyDaysMap[config.CalculateUnit]
  78. if !ok {
  79. errMsg = "错误的分析周期"
  80. err = errors.New(errMsg)
  81. isSendEmail = false
  82. return
  83. }
  84. isSendEmail = true
  85. // 品种map
  86. varietyMap := make(map[int]*cross_varietyModel.ChartVariety)
  87. {
  88. varietyList, tmpErr := cross_varietyModel.GetVarietyListByIdList(config.VarietyList)
  89. if tmpErr != nil {
  90. err = tmpErr
  91. return
  92. }
  93. for _, v := range varietyList {
  94. varietyMap[v.ChartVarietyId] = v
  95. }
  96. }
  97. // 标签m
  98. var xTagInfo, yTagInfo *cross_varietyModel.ChartTag
  99. {
  100. tagList, tmpErr := cross_varietyModel.GetTagListByIdList([]int{config.TagX, config.TagY})
  101. if tmpErr != nil {
  102. err = tmpErr
  103. return
  104. }
  105. for _, v := range tagList {
  106. if v.ChartTagId == config.TagX {
  107. xTagInfo = v
  108. } else if v.ChartTagId == config.TagY {
  109. yTagInfo = v
  110. }
  111. }
  112. }
  113. if xTagInfo == nil {
  114. errMsg = "找不到对应的X轴标签"
  115. err = errors.New(errMsg)
  116. return
  117. }
  118. if yTagInfo == nil {
  119. errMsg = "找不到对应的Y轴标签"
  120. err = errors.New(errMsg)
  121. return
  122. }
  123. xVarietyEdbMap, yVarietyEdbMap, edbInfoIdList, err := GetXYEdbIdList(config.TagX, config.TagY, config.VarietyList)
  124. if err != nil {
  125. return
  126. }
  127. if len(edbInfoIdList) <= 0 {
  128. errMsg = "品种未配置指标"
  129. err = errors.New(errMsg)
  130. isSendEmail = false
  131. return
  132. }
  133. mappingList, err := data_manage.GetChartEdbMappingListByEdbInfoIdList(edbInfoIdList)
  134. if err != nil {
  135. errMsg = "获取指标信息失败"
  136. err = errors.New("获取指标信息失败,ERR:" + err.Error())
  137. return
  138. }
  139. // 指标对应的所有数据
  140. chartType := 1 //1:普通图,2:季节性图
  141. calendar := "公历"
  142. edbDataListMap, edbList, err := data.GetEdbDataMapList(chartInfoId, chartType, calendar, "", "", mappingList, "")
  143. if err != nil {
  144. return
  145. }
  146. currDay := time.Now()
  147. currDay = time.Date(currDay.Year(), currDay.Month(), currDay.Day(), 0, 0, 0, 0, time.Local)
  148. dataMap := make(map[string]float64)
  149. dateMap := make(map[string]string)
  150. for dateIndex, dateConfig := range config.DateConfigList {
  151. for _, edbInfoMapping := range mappingList {
  152. // 数据会是正序的
  153. dataList, ok := edbDataListMap[edbInfoMapping.EdbInfoId]
  154. if !ok {
  155. continue
  156. }
  157. lenData := len(dataList)
  158. if lenData <= 0 {
  159. continue
  160. }
  161. // 数据开始日期
  162. endDateStr := ``
  163. var endDate time.Time
  164. // 数据的开始索引
  165. k := lenData - 1
  166. var currVal float64
  167. switch dateConfig.DateType {
  168. case 1: // 1:最新日期;
  169. endDateStr = dataList[k].DataTime
  170. tmpDate, tmpErr := time.ParseInLocation(utils.FormatDate, endDateStr, time.Local)
  171. if tmpErr != nil {
  172. err = tmpErr
  173. return
  174. }
  175. endDate = tmpDate
  176. currVal = dataList[k].Value
  177. case 2: // 2:N天前
  178. tmpEndDate := currDay.AddDate(0, 0, -dateConfig.Num)
  179. tmpEndDateStr := tmpEndDate.Format(utils.FormatDate)
  180. for i := k; i >= 0; i-- {
  181. tmpDateStr := dataList[i].DataTime
  182. // 如果正好是这一天,那么就直接break了
  183. if tmpEndDateStr == tmpDateStr {
  184. k = i
  185. endDateStr = tmpDateStr
  186. currVal = dataList[i].Value
  187. break
  188. }
  189. tmpDate, tmpErr := time.ParseInLocation(utils.FormatDate, tmpDateStr, time.Local)
  190. if tmpErr != nil {
  191. err = tmpErr
  192. return
  193. }
  194. // 如果这期的日期晚于选择的日期,那么继续遍历
  195. if tmpDate.After(tmpEndDate) {
  196. continue
  197. }
  198. k = i
  199. endDateStr = tmpDateStr
  200. endDate = tmpDate
  201. currVal = dataList[i].Value
  202. break
  203. }
  204. }
  205. // 没有找到日期,那么就不处理
  206. if endDateStr == `` || endDate.IsZero() {
  207. continue
  208. }
  209. // 最早的日期
  210. earliestDate := endDate.AddDate(0, 0, -config.CalculateValue*moveUnitDays)
  211. earliestDateStr := earliestDate.Format(utils.FormatDate)
  212. var minVal, maxVal float64
  213. var isNotFirst bool // 是否是第一条数据
  214. for i := k; i >= 0; i-- {
  215. tmpData := dataList[i]
  216. if !isNotFirst {
  217. maxVal = tmpData.Value
  218. minVal = tmpData.Value
  219. isNotFirst = true
  220. continue
  221. }
  222. tmpDateStr := dataList[i].DataTime
  223. // 如果正好是这一天,那么就直接break了
  224. if earliestDateStr == tmpDateStr {
  225. break
  226. }
  227. tmpDate, tmpErr := time.ParseInLocation(utils.FormatDate, tmpDateStr, time.Local)
  228. if tmpErr != nil {
  229. err = tmpErr
  230. return
  231. }
  232. // 如果这期的日期早于选择的日期,那么继续停止遍历
  233. if tmpDate.Before(earliestDate) {
  234. continue
  235. }
  236. if tmpData.Value > maxVal {
  237. maxVal = tmpData.Value
  238. }
  239. if tmpData.Value < minVal {
  240. minVal = tmpData.Value
  241. }
  242. }
  243. // 最大值等于最小值,说明计算结果无效
  244. if maxVal == minVal {
  245. continue
  246. }
  247. //百分位=(现值-Min)/(Max-Min)
  248. tmpV := (currVal - minVal) / (maxVal - minVal) * 100
  249. tmpV, _ = decimal.NewFromFloat(tmpV).Round(4).Float64()
  250. // key的生成(日期配置下标+指标id)
  251. key := fmt.Sprint(dateIndex, "_", edbInfoMapping.EdbInfoId)
  252. dataMap[key] = tmpV
  253. dateMap[key] = endDateStr
  254. }
  255. }
  256. // 返回数据处理
  257. dataList := make([]SectionScatterSeriesItemResp, 0)
  258. var xMinVal, xMaxVal, yMinVal, yMaxVal float64
  259. var isNotFirst bool
  260. for _, varietyId := range config.VarietyList {
  261. xEdbInfoId, ok1 := xVarietyEdbMap[varietyId]
  262. if !ok1 {
  263. continue
  264. }
  265. yEdbInfoId, ok2 := yVarietyEdbMap[varietyId]
  266. if !ok2 {
  267. continue
  268. }
  269. variety, ok := varietyMap[varietyId]
  270. if !ok {
  271. continue
  272. }
  273. coordinatePointList := make([]CoordinatePoint, 0)
  274. for dateIndex, _ := range config.DateConfigList {
  275. key1 := fmt.Sprint(dateIndex, "_", xEdbInfoId)
  276. xVal, ok1 := dataMap[key1]
  277. if !ok1 {
  278. continue
  279. }
  280. key2 := fmt.Sprint(dateIndex, "_", yEdbInfoId)
  281. yVal, ok2 := dataMap[key2]
  282. if !ok2 {
  283. continue
  284. }
  285. if !isNotFirst {
  286. xMinVal = xVal
  287. xMaxVal = xVal
  288. yMinVal = yVal
  289. yMaxVal = yVal
  290. isNotFirst = true
  291. } else {
  292. if xVal < xMinVal {
  293. xMinVal = xVal
  294. }
  295. if xVal > xMaxVal {
  296. xMaxVal = xVal
  297. }
  298. if yVal < yMinVal {
  299. yMinVal = yVal
  300. }
  301. if yVal > yMaxVal {
  302. yMaxVal = yVal
  303. }
  304. }
  305. coordinatePointList = append(coordinatePointList, CoordinatePoint{
  306. X: xVal,
  307. Y: yVal,
  308. XEdbInfoId: xEdbInfoId,
  309. YEdbInfoId: yEdbInfoId,
  310. XDate: dateMap[key1],
  311. YDate: dateMap[key2],
  312. })
  313. }
  314. dataList = append(dataList, SectionScatterSeriesItemResp{
  315. Name: variety.ChartVarietyName,
  316. NameEn: variety.ChartVarietyNameEn,
  317. Color: "",
  318. CoordinatePointData: coordinatePointList,
  319. })
  320. }
  321. dataResp = ChartInfoResp{
  322. XName: xTagInfo.ChartTagName + "百分位",
  323. XNameEn: xTagInfo.ChartTagNameEn,
  324. XUnitName: "%",
  325. XUnitNameEn: "%",
  326. YName: yTagInfo.ChartTagName + "百分位",
  327. YNameEn: yTagInfo.ChartTagNameEn,
  328. YUnitName: "%",
  329. YUnitNameEn: "%",
  330. XMinValue: fmt.Sprint(xMinVal),
  331. XMaxValue: fmt.Sprint(xMaxVal),
  332. YMinValue: fmt.Sprint(yMinVal),
  333. YMaxValue: fmt.Sprint(yMaxVal),
  334. DataList: dataList,
  335. }
  336. // 去除返回指标中的数据信息,避免没必要的数据传输
  337. for k, _ := range edbList {
  338. edbList[k].DataList = nil
  339. }
  340. return
  341. }
  342. // CheckIsEnChart
  343. // @Description: 检测是否展示英文名称
  344. // @author: Roc
  345. // @datetime 2023-11-28 20:54:41
  346. // @param chartNameEn string
  347. // @param dataResp ChartInfoResp
  348. // @return bool
  349. func CheckIsEnChart(chartNameEn string, dataResp ChartInfoResp) bool {
  350. if chartNameEn == "" {
  351. return false
  352. }
  353. if dataResp.XNameEn == `` {
  354. return false
  355. }
  356. if dataResp.YNameEn == `` {
  357. return false
  358. }
  359. for _, v := range dataResp.DataList {
  360. if v.NameEn == `` {
  361. return false
  362. }
  363. }
  364. return true
  365. }
  366. // GetXYEdbIdList
  367. // @Description: 根据标签id和品种获取指标列表信息
  368. // @author: Roc
  369. // @datetime 2023-11-27 14:31:23
  370. // @param tagX int
  371. // @param tagY int
  372. // @param varietyList []int
  373. // @return xVarietyEdbMap map[int]int
  374. // @return yVarietyEdbMap map[int]int
  375. // @return edbInfoIdList []int
  376. // @return errMsg string
  377. // @return err error
  378. func GetXYEdbIdList(tagX, tagY int, varietyList []int) (xVarietyEdbMap, yVarietyEdbMap map[int]int, edbInfoIdList []int, err error) {
  379. edbInfoIdList = make([]int, 0)
  380. xVarietyEdbMap = make(map[int]int)
  381. yVarietyEdbMap = make(map[int]int)
  382. xList, err := cross_varietyModel.GetChartTagVarietyListByTagAndVariety(tagX, varietyList)
  383. if err != nil {
  384. err = errors.New("获取X轴的品种指标配置信息失败,Err:" + err.Error())
  385. return
  386. }
  387. yList, err := cross_varietyModel.GetChartTagVarietyListByTagAndVariety(tagY, varietyList)
  388. if err != nil {
  389. err = errors.New("获取Y轴的品种指标配置信息失败,Err:" + err.Error())
  390. return
  391. }
  392. baseVarietyIdMap := make(map[int]int)
  393. for _, v := range xList {
  394. baseVarietyIdMap[v.ChartVarietyId] = v.ChartVarietyId
  395. }
  396. // 两个标签里面的品种并集
  397. needVarietyIdMap := make(map[int]int)
  398. for _, v := range yList {
  399. if val, ok := baseVarietyIdMap[v.ChartVarietyId]; ok {
  400. // 如果在 map2 中存在相同的键,则将键和值添加到结果中
  401. needVarietyIdMap[v.ChartVarietyId] = val
  402. }
  403. }
  404. for _, v := range xList {
  405. if _, ok := needVarietyIdMap[v.ChartVarietyId]; ok {
  406. xVarietyEdbMap[v.ChartVarietyId] = v.EdbInfoId
  407. edbInfoIdList = append(edbInfoIdList, v.EdbInfoId)
  408. }
  409. }
  410. for _, v := range yList {
  411. if _, ok := needVarietyIdMap[v.ChartVarietyId]; ok {
  412. yVarietyEdbMap[v.ChartVarietyId] = v.EdbInfoId
  413. edbInfoIdList = append(edbInfoIdList, v.EdbInfoId)
  414. }
  415. }
  416. return
  417. }
  418. // AddChartInfo
  419. // @Description: AddChartInfo
  420. // @author: Roc
  421. // @datetime 2023-11-24 15:58:14
  422. // @param req request.AddChartReq
  423. // @param sysUser *system.Admin
  424. // @return chartInfo *data_manage.ChartInfo
  425. // @return err error
  426. // @return errMsg string
  427. // @return isSendEmail bool
  428. func AddChartInfo(req request.AddChartReq, sysUser *system.Admin) (chartInfo *data_manage.ChartInfo, err error, errMsg string, isSendEmail bool) {
  429. isSendEmail = true
  430. source := utils.CHART_SOURCE_CROSS_HEDGING
  431. req.ChartName = strings.Trim(req.ChartName, " ")
  432. if req.ChartName == "" {
  433. errMsg = "请填写图表名称!"
  434. err = errors.New(errMsg)
  435. isSendEmail = false
  436. return
  437. }
  438. if req.TagX <= 0 {
  439. errMsg = "请选择X轴坐标的标签!"
  440. err = errors.New(errMsg)
  441. isSendEmail = false
  442. return
  443. }
  444. if req.TagY <= 0 {
  445. errMsg = "请选择Y轴坐标的标签!"
  446. err = errors.New(errMsg)
  447. isSendEmail = false
  448. return
  449. }
  450. if req.CalculateValue <= 0 {
  451. errMsg = "请设置时间长度!"
  452. err = errors.New(errMsg)
  453. isSendEmail = false
  454. return
  455. }
  456. if req.CalculateUnit == `` {
  457. errMsg = "请设置时间频度!"
  458. err = errors.New(errMsg)
  459. isSendEmail = false
  460. return
  461. }
  462. // 品种配置
  463. if len(req.VarietyList) < 0 {
  464. errMsg = "请选择品种!"
  465. err = errors.New(errMsg)
  466. isSendEmail = false
  467. return
  468. }
  469. // 日期配置
  470. dateConfigList := len(req.DateConfigList)
  471. if dateConfigList < 0 {
  472. errMsg = "请选择日期!"
  473. err = errors.New(errMsg)
  474. isSendEmail = false
  475. return
  476. }
  477. if dateConfigList > 5 {
  478. errMsg = "日期数量已达上限!"
  479. err = errors.New(errMsg)
  480. isSendEmail = false
  481. return
  482. }
  483. // 基础配置转string
  484. extraConfigByte, err := json.Marshal(req)
  485. if err != nil {
  486. return
  487. }
  488. chartClassify, err := data_manage.GetCrossVarietyChartClassifyBySysUserId(sysUser.AdminId)
  489. if err != nil {
  490. if err.Error() != utils.ErrNoRow() {
  491. errMsg = "获取分类信息失败"
  492. err = errors.New("获取分类信息失败,Err:" + err.Error())
  493. return
  494. }
  495. timestamp := strconv.FormatInt(time.Now().UnixNano(), 10)
  496. chartClassify = &data_manage.ChartClassify{
  497. ChartClassifyId: 0,
  498. ChartClassifyName: sysUser.RealName,
  499. ParentId: 0,
  500. HasData: 0,
  501. CreateTime: time.Now(),
  502. ModifyTime: time.Now(),
  503. SysUserId: sysUser.AdminId,
  504. SysUserRealName: sysUser.RealName,
  505. Level: 1,
  506. UniqueCode: utils.MD5(utils.DATA_PREFIX + "_" + timestamp),
  507. Sort: 0,
  508. Source: source,
  509. }
  510. }
  511. var chartInfoId int
  512. // 判断图表是否存在
  513. //var condition string
  514. //var pars []interface{}
  515. //condition += " AND chart_name=? AND source = ? "
  516. //pars = append(pars, req.ChartName, source)
  517. //count, err := data_manage.GetChartInfoCountByCondition(condition, pars)
  518. //if err != nil {
  519. // errMsg = "判断图表名称是否存在失败"
  520. // err = errors.New("判断图表名称是否存在失败,Err:" + err.Error())
  521. // return
  522. //}
  523. //if count > 0 {
  524. // errMsg = "图表已存在,请重新填写"
  525. // err = errors.New(errMsg)
  526. // isSendEmail = false
  527. // return
  528. //}
  529. chartInfo = new(data_manage.ChartInfo)
  530. chartInfo.ChartName = req.ChartName
  531. //chartInfo.EdbInfoIds = edbInfoIdStr
  532. //chartInfo.ChartClassifyId = req.ChartClassifyId
  533. chartInfo.SysUserId = sysUser.AdminId
  534. chartInfo.SysUserRealName = sysUser.RealName
  535. chartInfo.CreateTime = time.Now()
  536. chartInfo.ModifyTime = time.Now()
  537. chartInfo.IsSetName = 0
  538. timestamp := strconv.FormatInt(time.Now().UnixNano(), 10)
  539. chartInfo.UniqueCode = utils.MD5(utils.CHART_PREFIX + "_" + timestamp)
  540. chartInfo.ChartType = 9 // 相关性图
  541. chartInfo.Calendar = "公历"
  542. chartInfo.DateType = 6
  543. //chartInfo.StartDate = req.StartDate
  544. //chartInfo.EndDate = req.EndDate
  545. //chartInfo.SeasonStartDate = req.StartDate
  546. //chartInfo.SeasonEndDate = req.EndDate
  547. chartInfo.LeftMin = req.LeftMin
  548. chartInfo.LeftMax = req.LeftMax
  549. //chartInfo.RightMin = req.RightMin
  550. //chartInfo.RightMax = req.RightMax
  551. //chartInfo.Disabled = disableVal
  552. chartInfo.Source = source
  553. chartInfo.ExtraConfig = string(extraConfigByte)
  554. // 图表品种
  555. chartVarietyMappingList := make([]*cross_varietyModel.ChartVarietyMapping, 0)
  556. for _, varietyId := range req.VarietyList {
  557. chartVarietyMappingList = append(chartVarietyMappingList, &cross_varietyModel.ChartVarietyMapping{
  558. Id: 0,
  559. ChartInfoId: 0,
  560. ChartVarietyId: varietyId,
  561. ModifyTime: time.Now(),
  562. CreateTime: time.Now(),
  563. })
  564. }
  565. // 图表配置
  566. chartInfoCrossVariety := &cross_varietyModel.ChartInfoCrossVariety{
  567. Id: 0,
  568. ChartInfoId: 0,
  569. ChartXTagId: req.TagX,
  570. ChartYTagId: req.TagY,
  571. CalculateValue: req.CalculateValue,
  572. CalculateUnit: req.CalculateUnit,
  573. ModifyTime: time.Now(),
  574. CreateTime: time.Now(),
  575. }
  576. // 新增图表和指标mapping
  577. chartInfoId, e := cross_varietyModel.CreateChart(chartInfo, chartClassify, chartVarietyMappingList, chartInfoCrossVariety)
  578. if e != nil {
  579. errMsg = "操作失败"
  580. err = errors.New("新增相关性图表失败, Err: " + e.Error())
  581. return
  582. }
  583. //添加es数据
  584. go data.EsAddOrEditChartInfo(chartInfoId)
  585. return
  586. }
  587. // EditChartInfo
  588. // @Description: 编辑图表
  589. // @author: Roc
  590. // @datetime 2023-11-24 15:58:31
  591. // @param req request.EditChartReq
  592. // @param sysUser *system.Admin
  593. // @return chartItem *data_manage.ChartInfo
  594. // @return err error
  595. // @return errMsg string
  596. // @return isSendEmail bool
  597. func EditChartInfo(req request.EditChartReq, sysUser *system.Admin) (chartItem *data_manage.ChartInfo, err error, errMsg string, isSendEmail bool) {
  598. isSendEmail = true
  599. chartItem, err = data_manage.GetChartInfoById(req.ChartInfoId)
  600. if err != nil {
  601. if err.Error() == utils.ErrNoRow() {
  602. errMsg = "图表已被删除,请刷新页面"
  603. err = errors.New(errMsg)
  604. isSendEmail = false
  605. return
  606. }
  607. errMsg = "获取图表信息失败"
  608. err = errors.New("获取图表信息失败,Err:" + err.Error())
  609. return
  610. }
  611. if chartItem.Source != utils.CHART_SOURCE_CROSS_HEDGING {
  612. errMsg = "该图不是跨品种分析图表!"
  613. err = errors.New(errMsg)
  614. isSendEmail = false
  615. return
  616. }
  617. req.ChartName = strings.Trim(req.ChartName, " ")
  618. if req.ChartName == "" {
  619. errMsg = "请填写图表名称!"
  620. err = errors.New(errMsg)
  621. isSendEmail = false
  622. return
  623. }
  624. if req.TagX <= 0 {
  625. errMsg = "请选择X轴坐标的标签!"
  626. err = errors.New(errMsg)
  627. isSendEmail = false
  628. return
  629. }
  630. if req.TagY <= 0 {
  631. errMsg = "请选择Y轴坐标的标签!"
  632. err = errors.New(errMsg)
  633. isSendEmail = false
  634. return
  635. }
  636. if req.CalculateValue <= 0 {
  637. errMsg = "请设置时间长度!"
  638. err = errors.New(errMsg)
  639. isSendEmail = false
  640. return
  641. }
  642. if req.CalculateUnit == `` {
  643. errMsg = "请设置时间频度!"
  644. err = errors.New(errMsg)
  645. isSendEmail = false
  646. return
  647. }
  648. // 品种配置
  649. if len(req.VarietyList) < 0 {
  650. errMsg = "请选择品种!"
  651. err = errors.New(errMsg)
  652. isSendEmail = false
  653. return
  654. }
  655. // 日期配置
  656. dateConfigList := len(req.DateConfigList)
  657. if dateConfigList < 0 {
  658. errMsg = "请选择日期!"
  659. err = errors.New(errMsg)
  660. isSendEmail = false
  661. return
  662. }
  663. if dateConfigList > 5 {
  664. errMsg = "日期数量已达上限!"
  665. err = errors.New(errMsg)
  666. isSendEmail = false
  667. return
  668. }
  669. // 基础配置转string
  670. extraConfigByte, err := json.Marshal(req)
  671. if err != nil {
  672. return
  673. }
  674. // 图表操作权限
  675. ok := data.CheckOpChartPermission(sysUser, chartItem.SysUserId)
  676. if !ok {
  677. errMsg = "没有该图表的操作权限"
  678. err = errors.New(errMsg)
  679. isSendEmail = false
  680. return
  681. }
  682. //判断图表是否存在
  683. //var condition string
  684. //var pars []interface{}
  685. //condition += " AND chart_info_id <> ? "
  686. //pars = append(pars, req.ChartInfoId)
  687. //condition += " AND chart_name=? AND source = ? "
  688. //pars = append(pars, req.ChartName, chartItem.Source)
  689. //count, err := data_manage.GetChartInfoCountByCondition(condition, pars)
  690. //if err != nil {
  691. // errMsg = "判断图表名称是否存在失败"
  692. // err = errors.New("判断图表名称是否存在失败,Err:" + err.Error())
  693. // return
  694. //}
  695. //if count > 0 {
  696. // errMsg = "图表已存在,请重新填写"
  697. // err = errors.New(errMsg)
  698. // isSendEmail = false
  699. // return
  700. //}
  701. chartItem.ChartName = req.ChartName
  702. chartItem.ExtraConfig = string(extraConfigByte)
  703. chartItem.ModifyTime = time.Now()
  704. chartUpdateCols := []string{"ChartName", "ExtraConfig", "ModifyTime"}
  705. // 跨品种分析配置
  706. chartInfoCrossVariety, err := cross_varietyModel.GetChartInfoCrossVarietyByChartInfoId(chartItem.ChartInfoId)
  707. if err != nil {
  708. return
  709. }
  710. chartInfoCrossVariety.ChartXTagId = req.TagX
  711. chartInfoCrossVariety.ChartYTagId = req.TagY
  712. chartInfoCrossVariety.CalculateValue = req.CalculateValue
  713. chartInfoCrossVariety.CalculateUnit = req.CalculateUnit
  714. chartInfoCrossVariety.ModifyTime = time.Now()
  715. chartInfoCrossVarietyUpdateCols := []string{"ChartXTagId", "ChartYTagId", "CalculateValue", "CalculateUnit", "ModifyTime"}
  716. // 图表品种
  717. chartVarietyMappingList := make([]*cross_varietyModel.ChartVarietyMapping, 0)
  718. for _, varietyId := range req.VarietyList {
  719. chartVarietyMappingList = append(chartVarietyMappingList, &cross_varietyModel.ChartVarietyMapping{
  720. Id: 0,
  721. ChartInfoId: 0,
  722. ChartVarietyId: varietyId,
  723. ModifyTime: time.Now(),
  724. CreateTime: time.Now(),
  725. })
  726. }
  727. err = cross_varietyModel.EditChart(chartItem, chartVarietyMappingList, chartInfoCrossVariety,
  728. chartUpdateCols, chartInfoCrossVarietyUpdateCols)
  729. if err != nil {
  730. errMsg = "保存失败"
  731. err = errors.New("保存失败,Err:" + err.Error())
  732. return
  733. }
  734. resp := new(data_manage.AddChartInfoResp)
  735. resp.ChartInfoId = chartItem.ChartInfoId
  736. resp.UniqueCode = chartItem.UniqueCode
  737. //resp.ChartType = req.ChartType
  738. //添加es数据
  739. go data.EsAddOrEditChartInfo(chartItem.ChartInfoId)
  740. //修改my eta es数据
  741. go data.EsAddOrEditMyChartInfoByChartInfoId(chartItem.ChartInfoId)
  742. return
  743. }