chart.go 27 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713
  1. package models
  2. import (
  3. "errors"
  4. "eta/eta_chart_lib/models/mgo"
  5. "eta/eta_chart_lib/utils"
  6. "fmt"
  7. "strconv"
  8. "time"
  9. "github.com/beego/beego/v2/client/orm"
  10. "go.mongodb.org/mongo-driver/bson"
  11. "github.com/nosixtools/solarlunar"
  12. )
  13. type ChartInfo struct {
  14. ChartInfoId int `json:"-" orm:"column(chart_info_id);pk"`
  15. ChartName string `description:"来源名称"`
  16. ChartNameEn string `description:"英文图表名称"`
  17. ChartClassifyId int `json:"-" description:"图表分类id"`
  18. SysUserId int `json:"-"`
  19. SysUserRealName string `json:"-"`
  20. UniqueCode string `description:"图表唯一编码"`
  21. CreateTime time.Time `json:"-"`
  22. ModifyTime time.Time `json:"-"`
  23. DateType int `description:"日期类型:1:00年至今,2:10年至今,3:15年至今,4:年初至今,5:自定义时间"`
  24. StartDate string `description:"自定义开始日期"`
  25. EndDate string `description:"自定义结束日期"`
  26. IsSetName int `description:"设置名称"`
  27. EdbInfoIds string `description:"指标id"`
  28. ChartType int `description:"生成样式:1:曲线图,2:季节性图"`
  29. Calendar string `description:"公历/农历"`
  30. SeasonStartDate string `description:"季节性图开始日期"`
  31. SeasonEndDate string `description:"季节性图开始日期"`
  32. ChartImage string `description:"图表图片"`
  33. BarConfig string `description:"柱方图的配置,json数据" json:"-"`
  34. XMin string `description:"图表X轴最小值"`
  35. XMax string `description:"图表X轴最大值"`
  36. LeftMin string `description:"图表左侧最小值"`
  37. LeftMax string `description:"图表左侧最大值"`
  38. RightMin string `description:"图表右侧最小值"`
  39. RightMax string `description:"图表右侧最大值"`
  40. Right2Min string `description:"图表右侧2最小值"`
  41. Right2Max string `description:"图表右侧2最大值"`
  42. MinMaxSave int `description:"是否手动保存过上下限:0-否;1-是"`
  43. Source int `description:"1:ETA图库;2:商品价格曲线"`
  44. UnitEn string `description:"英文图表单位"`
  45. Unit string `description:"图表单位"`
  46. ExtraConfig string `description:"图表额外配置,json数据" json:"-"`
  47. ChartSource string `description:"图表来源str"`
  48. ChartSourceEn string `description:"图表来源(英文)"`
  49. SeasonExtraConfig string `description:"季节性图表中的配置,json数据"`
  50. StartYear int `description:"当选择的日期类型为最近N年类型时,即date_type=20, 用start_year表示N"`
  51. ChartThemeId int `description:"图表应用主题ID"`
  52. ChartThemeStyle string `description:"图表应用主题样式"`
  53. SourcesFrom string `description:"图表来源"`
  54. Instructions string `description:"图表说明"`
  55. MarkersLines string `description:"标识线"`
  56. MarkersAreas string `description:"标识区"`
  57. }
  58. func GetChartInfoByUniqueCode(uniqueCode string) (item *ChartInfo, err error) {
  59. o := orm.NewOrmUsingDB("data")
  60. sql := ` SELECT * FROM chart_info WHERE unique_code=? `
  61. err = o.Raw(sql, uniqueCode).QueryRow(&item)
  62. return
  63. }
  64. type ChartEdbInfoMapping struct {
  65. EdbInfoId int `description:"指标id"`
  66. SourceName string `description:"来源名称"`
  67. Source int `description:"来源id"`
  68. EdbCode string `description:"指标编码"`
  69. EdbName string `description:"指标名称"`
  70. EdbAliasName string `description:"指标名称(别名)"`
  71. EdbAliasNameEn string `description:"英文指标名称(别名)"`
  72. EdbNameEn string `description:"英文指标名称"`
  73. Frequency string `description:"频率"`
  74. FrequencyEn string `description:"英文频率"`
  75. Unit string `description:"单位"`
  76. UnitEn string `description:"英文单位"`
  77. StartDate string `description:"起始日期"`
  78. EndDate string `description:"终止日期"`
  79. ModifyTime string `description:"指标最后更新时间"`
  80. ChartEdbMappingId int `description:"图表指标id" json:"-"`
  81. ChartInfoId int `description:"图表id"`
  82. MaxData float64 `description:"上限"`
  83. MinData float64 `description:"下限"`
  84. IsOrder bool `description:"true:正序,false:逆序"`
  85. IsAxis int `description:"1:左轴,0:右轴"`
  86. EdbInfoType int `description:"1:标准指标,0:领先指标"`
  87. EdbType int `description:"指标类型:1:基础指标,2:计算指标"`
  88. LeadValue int `description:"领先值"`
  89. LeadUnit string `description:"领先单位"`
  90. LeadUnitEn string `description:"领先英文单位"`
  91. ChartStyle string `description:"图表类型"`
  92. ChartColor string `description:"颜色"`
  93. ChartWidth float64 `description:"线条大小"`
  94. DataList interface{}
  95. EdbInfoCategoryType int `description:"0:普通指标,1:预测指标"`
  96. PredictChartColor string `description:"预测数据的颜色"`
  97. ChartType int `description:"生成样式:1:曲线图,2:季节性图,3:面积图,4:柱状图,5:散点图,6:组合图"`
  98. LatestDate string `description:"数据最新日期"`
  99. LatestValue float64 `description:"数据最新值"`
  100. MoveLatestDate string `description:"移动后的数据最新日期"`
  101. UniqueCode string `description:"指标唯一编码"`
  102. MinValue float64 `json:"-" description:"最小值"`
  103. MaxValue float64 `json:"-" description:"最大值"`
  104. IsNullData bool `json:"-" description:"是否空数据"`
  105. MappingSource int `description:"1:ETA图库;2:商品价格曲线"`
  106. SubSource int `description:"子数据来源:0:经济数据库,1:日期序列"`
  107. SubSourceName string `description:"子数据来源名称"`
  108. IndicatorCode string `description:"指标代码"`
  109. StockCode string `description:"证券代码"`
  110. IsConvert int `description:"是否数据转换 0不转 1转"`
  111. ConvertType int `description:"数据转换类型 1乘 2除 3对数"`
  112. ConvertValue float64 `description:"数据转换值"`
  113. ConvertUnit string `description:"数据转换单位"`
  114. ConvertEnUnit string `description:"数据转换单位"`
  115. }
  116. func GetChartEdbMappingList(chartInfoId int) (list []*ChartEdbInfoMapping, err error) {
  117. o := orm.NewOrmUsingDB("data")
  118. aField := `a.chart_edb_mapping_id,a.chart_info_id,a.edb_info_id,a.create_time,a.modify_time,a.unique_code,a.max_data,a.min_data,a.is_order,a.is_axis,a.edb_info_type,a.lead_value,a.lead_unit,a.chart_style,a.chart_color,a.predict_chart_color,a.chart_width,a.source as mapping_source,a.edb_alias_name`
  119. sql := ` SELECT ` + aField + `,b.source_name,b.source,b.edb_code,b.edb_name,b.edb_name_en,b.frequency,b.unit,b.unit_en,b.start_date,b.end_date,b.modify_time,b.edb_type,b.latest_date,b.latest_value,b.unique_code,b.edb_info_type AS edb_info_category_type,b.sub_source,
  120. a.is_convert, a.convert_type, a.convert_value, a.convert_unit, a.convert_en_unit
  121. FROM chart_edb_mapping AS a
  122. INNER JOIN edb_info AS b ON a.edb_info_id=b.edb_info_id
  123. WHERE chart_info_id=?
  124. ORDER BY chart_edb_mapping_id ASC `
  125. _, err = o.Raw(sql, chartInfoId).QueryRows(&list)
  126. return
  127. }
  128. type EdbDataList struct {
  129. EdbDataId int `json:"-" description:" 指标数据ID"`
  130. EdbInfoId int `json:"-" description:"指标ID"`
  131. DataTime string `description:"数据日期"`
  132. DataTimestamp int64 `description:"数据日期"`
  133. Value float64 `description:"数据值"`
  134. }
  135. // GetEdbDataList 获取指标的数据(日期正序返回)
  136. func GetEdbDataList(source, subSource, edbInfoId int, startDate, endDate string) (list []*EdbDataList, err error) {
  137. // 自有数据需要额外处理(从mongo获取)
  138. if source == utils.DATA_SOURCE_BUSINESS {
  139. return getEdbDataListByMongo(source, subSource, edbInfoId, startDate, endDate)
  140. }
  141. return getEdbDataListByMysql(source, subSource, edbInfoId, startDate, endDate)
  142. }
  143. // getEdbDataListByMysql
  144. // @Description: 从mysql中获取指标的数据(日期正序返回)
  145. // @author: Roc
  146. // @datetime 2024-05-08 16:49:48
  147. // @param source int
  148. // @param subSource int
  149. // @param edbInfoId int
  150. // @param startDate string
  151. // @param endDate string
  152. // @return list []*EdbDataList
  153. // @return err error
  154. func getEdbDataListByMysql(source, subSource, edbInfoId int, startDate, endDate string) (list []*EdbDataList, err error) {
  155. tableName := GetEdbDataTableName(source, subSource)
  156. if tableName == "" {
  157. err = errors.New("无效的渠道:" + strconv.Itoa(source))
  158. list = make([]*EdbDataList, 0)
  159. return list, err
  160. }
  161. var pars []interface{}
  162. var condition string
  163. if startDate != "" {
  164. condition += ` AND data_time>=? `
  165. pars = append(pars, startDate)
  166. }
  167. if endDate != "" {
  168. condition += ` AND data_time<=? `
  169. pars = append(pars, endDate)
  170. }
  171. sql := `SELECT edb_data_id,edb_info_id,data_time,value,data_timestamp FROM %s WHERE edb_info_id=? `
  172. if condition != "" {
  173. sql += condition
  174. }
  175. sql += ` ORDER BY data_time ASC `
  176. sql = fmt.Sprintf(sql, tableName)
  177. o := orm.NewOrmUsingDB("data")
  178. _, err = o.Raw(sql, edbInfoId, pars).QueryRows(&list)
  179. return
  180. }
  181. // getEdbDataListByMongo
  182. // @Description: 从mongo中获取指标的数据(日期正序返回)
  183. // @author: Roc
  184. // @datetime 2024-05-08 16:49:59
  185. // @param source int
  186. // @param subSource int
  187. // @param edbInfoId int
  188. // @param startDate string
  189. // @param endDate string
  190. // @return list []*EdbDataList
  191. // @return err error
  192. func getEdbDataListByMongo(source, subSource, edbInfoId int, startDate, endDate string) (list []*EdbDataList, err error) {
  193. list = make([]*EdbDataList, 0)
  194. mogDataObj := mgo.EdbDataBusiness{}
  195. // 构建查询条件
  196. queryConditions := bson.M{
  197. "edb_info_id": edbInfoId,
  198. }
  199. // 日期
  200. dateCondition, err := mgo.BuildDateCondition(startDate, endDate)
  201. if err != nil {
  202. return
  203. }
  204. if len(dateCondition) > 0 {
  205. queryConditions["data_time"] = dateCondition
  206. }
  207. // 获取列表数据
  208. tmpDataList, tmpErr := mogDataObj.GetAllDataList(queryConditions, []string{"data_time"})
  209. if tmpErr != nil {
  210. err = tmpErr
  211. return
  212. }
  213. for k, v := range tmpDataList {
  214. list = append(list, &EdbDataList{
  215. EdbDataId: k + 1,
  216. EdbInfoId: v.EdbInfoId,
  217. DataTime: v.DataTime.Format(utils.FormatDate),
  218. DataTimestamp: v.DataTimestamp,
  219. Value: v.Value,
  220. })
  221. }
  222. return
  223. }
  224. type EdbDataItemList struct {
  225. EdbDataId int `json:"-" description:" 指标数据ID"`
  226. EdbInfoId int `json:"-" description:"指标ID"`
  227. DataTime string `description:"数据日期"`
  228. DataTimestamp int64 `description:"数据日期"`
  229. Value float64 `description:"数据值"`
  230. }
  231. type EdbDataItems struct {
  232. Items []*EdbDataList
  233. Year int
  234. BetweenDay int `json:"-" description:"公历与农历之间相差的天数"`
  235. CuttingDataTimestamp int64 `description:"切割的时间戳"`
  236. }
  237. type EdbDataResult struct {
  238. List []*EdbDataItems
  239. }
  240. type QuarterData struct {
  241. Year string
  242. DataList []*EdbDataList
  243. CuttingDataTimestamp int64 `description:"切割的时间戳"`
  244. ChartLegend string
  245. Years string
  246. }
  247. type QuarterXDateItem struct {
  248. StartDate time.Time
  249. EndDate time.Time
  250. ShowName string
  251. ChartLegend string
  252. CuttingDataTimestamp int64 `description:"切割的时间戳"`
  253. }
  254. type ChartInfoDetailResp struct {
  255. ChartInfo *ChartInfo
  256. EdbInfoList []*ChartEdbInfoMapping
  257. XEdbIdValue []int `description:"柱方图的x轴数据,指标id"`
  258. YDataList []YData `description:"柱方图的y轴数据"`
  259. XDataList []XData `description:"商品价格曲线的X轴数据"`
  260. CorrelationChartInfo *CorrelationInfo `description:"相关性图表信息"`
  261. DataResp interface{} `description:"图表数据,根据图的类型而定的,没有确定的数据格式"`
  262. WaterMark string `description:"水印"`
  263. IsCollect bool `description:"是否收藏"`
  264. }
  265. // XData 商品价格曲线的的x轴数据
  266. type XData struct {
  267. Name string `description:"别名"`
  268. NameEn string `description:"英文别名"`
  269. }
  270. // YData 柱方图的y轴数据
  271. type YData struct {
  272. Date string `description:"数据日期"`
  273. ConfigDate time.Time `description:"配置的日期" json:"-"`
  274. Color string `description:"数据颜色"`
  275. Name string `description:"别名"`
  276. NameEn string `description:"英文别名"`
  277. Value []float64 `description:"每个指标的值"`
  278. NoDataEdbList []int `description:"没有数据的指标列表"`
  279. XEdbInfoIdList []int `description:"对应X轴的指标id列表"`
  280. EdbValMap map[int]float64 `description:"指标与值的对应" json:"-"`
  281. M []int `description:"对应开始日期的间隔值" json:"-"`
  282. NameList []string `description:"每个值对应的名称"`
  283. EnNameList []string `description:"每个值对应的英文名称"`
  284. Unit string `description:"中文单位名称"`
  285. UnitEn string `description:"英文单位名称"`
  286. SeriesEdb struct {
  287. SeriesId int `description:"因子指标系列ID"`
  288. EdbInfoId int `description:"指标ID"`
  289. } `description:"对应的系列指标"`
  290. }
  291. // RollingCorrelationChartDataResp 滚动相关性图
  292. type RollingCorrelationChartDataResp struct {
  293. XDateTimeValue []string `description:"滚动相关性图的x轴数据,日期数据"`
  294. YDataList []YData `description:"滚动相关性图的y轴数据"`
  295. }
  296. // 指标季度数据计算(公历转农历)
  297. func AddCalculateQuarterV5(dataList []*EdbDataList) (result *EdbDataResult, err error) {
  298. var errMsg string
  299. defer func() {
  300. if errMsg != "" {
  301. fmt.Println("errMsg:", errMsg)
  302. }
  303. }()
  304. if len(dataList) <= 0 {
  305. result.List = make([]*EdbDataItems, 0)
  306. return
  307. }
  308. endDate := dataList[len(dataList)-1].DataTime
  309. endDateForm, err := time.Parse(utils.FormatDate, endDate)
  310. if err != nil {
  311. return result, err
  312. }
  313. thisMonth := int(endDateForm.Month())
  314. result = new(EdbDataResult)
  315. var yearArr []int
  316. yearMap := make(map[int]int)
  317. var cureentDate time.Time
  318. if thisMonth < 11 {
  319. for k, v := range dataList {
  320. dateTime, err := time.Parse(utils.FormatDate, v.DataTime)
  321. if err != nil {
  322. errMsg = "time.Parse Err:" + err.Error() + ";DataTime:" + v.DataTime
  323. return result, err
  324. }
  325. if k == len(dataList)-1 {
  326. cureentDate = dateTime
  327. }
  328. year := dateTime.Year()
  329. if _, ok := yearMap[year]; !ok {
  330. yearArr = append(yearArr, year)
  331. }
  332. yearMap[year] = year
  333. }
  334. } else {
  335. for k, v := range dataList {
  336. dateTime, err := time.Parse(utils.FormatDate, v.DataTime)
  337. if err != nil {
  338. errMsg = "time.Parse Err:" + err.Error() + ";DataTime:" + v.DataTime
  339. return result, err
  340. }
  341. if k == len(dataList)-1 {
  342. cureentDate = dateTime
  343. }
  344. year := dateTime.Year() + 1
  345. if _, ok := yearMap[year]; !ok {
  346. yearArr = append(yearArr, year)
  347. }
  348. yearMap[year] = year
  349. }
  350. }
  351. //排序
  352. fmt.Println("yearArr:", yearArr)
  353. thisYear := cureentDate.Year()
  354. //thisMonth := int(cureentDate.Month())
  355. fmt.Println("thisMonth:", thisMonth)
  356. for ky, vy := range yearArr {
  357. fmt.Println("line 432:", ky, vy, thisYear, thisMonth)
  358. if thisMonth < 11 {
  359. currentYearCjnl := strconv.Itoa(thisYear) + "-01-01" //当前年份春节农历
  360. currentYearCjgl := solarlunar.LunarToSolar(currentYearCjnl, false) //当前年份春节公历
  361. currentYearCjglDate, err := time.Parse(utils.FormatDate, currentYearCjgl)
  362. if err != nil {
  363. errMsg = "生成当前春节失败,Err:" + err.Error()
  364. return result, err
  365. }
  366. preYear := vy
  367. preYearCjnl := strconv.Itoa(preYear) + "-01-01" //之前年份春节农历
  368. preYearCjgl := solarlunar.LunarToSolar(preYearCjnl, false) //之前年份春节公历
  369. preYearCjglDate, err := time.Parse(utils.FormatDate, preYearCjgl)
  370. if err != nil {
  371. errMsg = "生成历史年份春节失败,Err:" + err.Error()
  372. return result, err
  373. }
  374. day := currentYearCjglDate.Sub(preYearCjglDate).Hours() / float64(24)
  375. items := new(EdbDataItems)
  376. items.BetweenDay = int(day) //公历日期换算成农历,需要减除的天数
  377. items.Year = preYear
  378. for _, v := range dataList {
  379. dateTime, err := time.Parse(utils.FormatDate, v.DataTime)
  380. if err != nil {
  381. errMsg = "time.Parse Err:" + err.Error() + ";DataTime:" + v.DataTime
  382. return result, err
  383. }
  384. newDate := dateTime.AddDate(0, 0, int(day))
  385. selectDateStr := strconv.Itoa(thisYear) + "-11" + "-30"
  386. selectDate, _ := time.Parse(utils.FormatDate, selectDateStr)
  387. if newDate.Before(selectDate) || newDate == selectDate {
  388. timestamp := newDate.UnixNano() / 1e6
  389. item := new(EdbDataList)
  390. item.DataTime = newDate.Format(utils.FormatDate)
  391. item.EdbInfoId = v.EdbInfoId
  392. item.Value = v.Value
  393. item.EdbDataId = v.EdbDataId
  394. item.DataTimestamp = timestamp
  395. items.Items = append(items.Items, item)
  396. }
  397. }
  398. result.List = append(result.List, items)
  399. } else {
  400. nextYear := thisYear + 1
  401. nextYearCjnl := strconv.Itoa(nextYear) + "-01-01" //当前年份春节农历
  402. nextYearCjgl := solarlunar.LunarToSolar(nextYearCjnl, false) //当前年份春节公历
  403. nextYearCjglDate, err := time.Parse(utils.FormatDate, nextYearCjgl)
  404. if err != nil {
  405. errMsg = "生成当前春节失败,Err:" + err.Error()
  406. return result, err
  407. }
  408. preYear := vy
  409. preYearCjnl := strconv.Itoa(preYear) + "-01-01" //之前年份春节农历
  410. preYearCjgl := solarlunar.LunarToSolar(preYearCjnl, false) //之前年份春节公历
  411. preYearCjglDate, err := time.Parse(utils.FormatDate, preYearCjgl)
  412. if err != nil {
  413. errMsg = "生成历史年份春节失败,Err:" + err.Error()
  414. return result, err
  415. }
  416. day := nextYearCjglDate.Sub(preYearCjglDate).Hours() / float64(24)
  417. fmt.Println("day:", day, nextYearCjglDate, preYearCjglDate)
  418. items := new(EdbDataItems)
  419. items.BetweenDay = int(day) //公历日期换算成农历,需要减除的天数
  420. items.Year = preYear - 1
  421. fmt.Println("preYear:", preYear, "ky:", ky, "yearArrLen:", len(yearArr))
  422. if ky+1 < len(yearArr) {
  423. for _, v := range dataList {
  424. dateTime, err := time.Parse(utils.FormatDate, v.DataTime)
  425. if err != nil {
  426. errMsg = "time.Parse Err:" + err.Error() + ";DataTime:" + v.DataTime
  427. return result, err
  428. }
  429. newDate := dateTime.AddDate(0, 0, int(day))
  430. selectDateStr := strconv.Itoa(nextYear) + "-05" + "-31"
  431. selectDate, _ := time.Parse(utils.FormatDate, selectDateStr)
  432. if newDate.Before(selectDate) || newDate == selectDate {
  433. timestamp := newDate.UnixNano() / 1e6
  434. item := new(EdbDataList)
  435. item.DataTime = newDate.Format(utils.FormatDate)
  436. item.EdbInfoId = v.EdbInfoId
  437. item.Value = v.Value
  438. item.EdbDataId = v.EdbDataId
  439. item.DataTimestamp = timestamp
  440. items.Items = append(items.Items, item)
  441. }
  442. }
  443. result.List = append(result.List, items)
  444. } else {
  445. for _, v := range dataList {
  446. dateTime, err := time.Parse(utils.FormatDate, v.DataTime)
  447. if err != nil {
  448. errMsg = "time.Parse Err:" + err.Error() + ";DataTime:" + v.DataTime
  449. return result, err
  450. }
  451. timestamp := dateTime.UnixNano() / 1e6
  452. item := new(EdbDataList)
  453. item.DataTime = dateTime.Format(utils.FormatDate)
  454. item.EdbInfoId = v.EdbInfoId
  455. item.Value = v.Value
  456. item.EdbDataId = v.EdbDataId
  457. item.DataTimestamp = timestamp
  458. items.Items = append(items.Items, item)
  459. }
  460. result.List = append(result.List, items)
  461. }
  462. }
  463. }
  464. return
  465. }
  466. // AddCalculateQuarterV6 指标季度数据计算(季节性图表)
  467. func AddCalculateQuarterV6(dataList []*EdbDataList) (result *EdbDataResult, err error) {
  468. var errMsg string
  469. defer func() {
  470. if errMsg != "" {
  471. fmt.Println("errMsg:", errMsg)
  472. }
  473. }()
  474. endDate := dataList[len(dataList)-1].DataTime
  475. endDateForm, err := time.Parse(utils.FormatDate, endDate)
  476. if err != nil {
  477. return result, err
  478. }
  479. thisMonth := int(endDateForm.Month())
  480. result = new(EdbDataResult)
  481. var yearArr []int
  482. yearMap := make(map[int]int)
  483. var cureentDate time.Time
  484. if thisMonth < 11 {
  485. for k, v := range dataList {
  486. dateTime, err := time.Parse(utils.FormatDate, v.DataTime)
  487. if err != nil {
  488. errMsg = "time.Parse Err:" + err.Error() + ";DataTime:" + v.DataTime
  489. return result, err
  490. }
  491. if k == len(dataList)-1 {
  492. cureentDate = dateTime
  493. }
  494. year := dateTime.Year()
  495. if _, ok := yearMap[year]; !ok {
  496. yearArr = append(yearArr, year)
  497. }
  498. yearMap[year] = year
  499. }
  500. } else {
  501. for k, v := range dataList {
  502. dateTime, err := time.Parse(utils.FormatDate, v.DataTime)
  503. if err != nil {
  504. errMsg = "time.Parse Err:" + err.Error() + ";DataTime:" + v.DataTime
  505. return result, err
  506. }
  507. if k == len(dataList)-1 {
  508. cureentDate = dateTime
  509. }
  510. year := dateTime.Year() + 1
  511. if _, ok := yearMap[year]; !ok {
  512. yearArr = append(yearArr, year)
  513. }
  514. yearMap[year] = year
  515. }
  516. }
  517. //排序
  518. fmt.Println("yearArr:", yearArr)
  519. thisYear := cureentDate.Year()
  520. //thisMonth := int(cureentDate.Month())
  521. fmt.Println("thisMonth:", thisMonth)
  522. for ky, vy := range yearArr {
  523. fmt.Printf("line 432:ky:%d, vy:%d, thisYear:%d, thisMonth:%d", ky, vy, thisYear, thisMonth)
  524. fmt.Println("")
  525. if thisMonth < 11 {
  526. currentYearCjnl := strconv.Itoa(thisYear) + "-01-01" //当前年份春节农历
  527. currentYearCjgl := solarlunar.LunarToSolar(currentYearCjnl, false) //当前年份春节公历
  528. currentYearCjglDate, err := time.Parse(utils.FormatDate, currentYearCjgl)
  529. if err != nil {
  530. errMsg = "生成当前春节失败,Err:" + err.Error()
  531. return result, err
  532. }
  533. preYear := vy
  534. preYearCjnl := strconv.Itoa(preYear) + "-01-01" //之前年份春节农历
  535. preYearCjgl := solarlunar.LunarToSolar(preYearCjnl, false) //之前年份春节公历
  536. preYearCjglDate, err := time.Parse(utils.FormatDate, preYearCjgl)
  537. if err != nil {
  538. errMsg = "生成历史年份春节失败,Err:" + err.Error()
  539. return result, err
  540. }
  541. day := currentYearCjglDate.Sub(preYearCjglDate).Hours() / float64(24)
  542. fmt.Println("day:", day, currentYearCjglDate, preYearCjglDate)
  543. items := new(EdbDataItems)
  544. items.BetweenDay = int(day) //公历日期换算成农历,需要减除的天数
  545. items.Year = preYear
  546. for _, v := range dataList {
  547. dateTime, err := time.Parse(utils.FormatDate, v.DataTime)
  548. if err != nil {
  549. errMsg = "time.Parse Err:" + err.Error() + ";DataTime:" + v.DataTime
  550. return result, err
  551. }
  552. newDate := dateTime.AddDate(0, 0, int(day))
  553. timestamp := newDate.UnixNano() / 1e6
  554. item := new(EdbDataList)
  555. item.DataTime = newDate.Format(utils.FormatDate)
  556. item.EdbInfoId = v.EdbInfoId
  557. item.Value = v.Value
  558. item.EdbDataId = v.EdbDataId
  559. item.DataTimestamp = timestamp
  560. items.Items = append(items.Items, item)
  561. }
  562. result.List = append(result.List, items)
  563. } else {
  564. nextYear := thisYear + 1
  565. nextYearCjnl := strconv.Itoa(nextYear) + "-01-01" //当前年份春节农历
  566. nextYearCjgl := solarlunar.LunarToSolar(nextYearCjnl, false) //当前年份春节公历
  567. nextYearCjglDate, err := time.Parse(utils.FormatDate, nextYearCjgl)
  568. if err != nil {
  569. errMsg = "生成当前春节失败,Err:" + err.Error()
  570. return result, err
  571. }
  572. preYear := vy
  573. preYearCjnl := strconv.Itoa(preYear) + "-01-01" //之前年份春节农历
  574. preYearCjgl := solarlunar.LunarToSolar(preYearCjnl, false) //之前年份春节公历
  575. preYearCjglDate, err := time.Parse(utils.FormatDate, preYearCjgl)
  576. if err != nil {
  577. errMsg = "生成历史年份春节失败,Err:" + err.Error()
  578. return result, err
  579. }
  580. day := nextYearCjglDate.Sub(preYearCjglDate).Hours() / float64(24)
  581. fmt.Println("day:", day, nextYearCjglDate, preYearCjglDate)
  582. items := new(EdbDataItems)
  583. items.BetweenDay = int(day) //公历日期换算成农历,需要减除的天数
  584. items.Year = preYear
  585. fmt.Println("preYear:", preYear, "ky:", ky, "yearArrLen:", len(yearArr))
  586. //if ky+1 < len(yearArr) {
  587. for _, v := range dataList {
  588. dateTime, err := time.Parse(utils.FormatDate, v.DataTime)
  589. if err != nil {
  590. errMsg = "time.Parse Err:" + err.Error() + ";DataTime:" + v.DataTime
  591. return result, err
  592. }
  593. newDate := dateTime.AddDate(0, 0, int(day))
  594. timestamp := newDate.UnixNano() / 1e6
  595. item := new(EdbDataList)
  596. item.DataTime = newDate.Format(utils.FormatDate)
  597. item.EdbInfoId = v.EdbInfoId
  598. item.Value = v.Value
  599. item.EdbDataId = v.EdbDataId
  600. item.DataTimestamp = timestamp
  601. items.Items = append(items.Items, item)
  602. }
  603. result.List = append(result.List, items)
  604. /*} else {
  605. for _, v := range dataList {
  606. dateTime, err := time.Parse(utils.FormatDate, v.DataTime)
  607. if err != nil {
  608. errMsg = "time.Parse Err:" + err.Error() + ";DataTime:" + v.DataTime
  609. return result, err
  610. }
  611. timestamp := dateTime.UnixNano() / 1e6
  612. item := new(EdbDataList)
  613. item.DataTime = dateTime.Format(utils.FormatDate)
  614. item.EdbInfoId = v.EdbInfoId
  615. item.Value = v.Value
  616. item.EdbDataId = v.EdbDataId
  617. item.DataTimestamp = timestamp
  618. items.Items = append(items.Items, item)
  619. }
  620. result.List = append(result.List, items)
  621. }*/
  622. }
  623. }
  624. return
  625. }
  626. type CorrelationInfo struct {
  627. LeadValue int `description:"领先值"`
  628. LeadUnit string `description:"领先单位"`
  629. StartDate string `description:"开始日期"`
  630. EndDate string `description:"结束日期"`
  631. EdbInfoIdFirst int `description:"A指标ID"`
  632. EdbInfoIdSecond int `description:"B指标ID"`
  633. PeriodData string `description:"X轴-期数数据"`
  634. CorrelationData string `description:"Y轴-相关性系数"`
  635. AnalysisMode int `description:"分析模式: 0-单因子; 1-多因子"`
  636. }
  637. type SeasonExtraItem struct {
  638. ChartLegend []SeasonChartLegend `description:"自定义的图例名称"`
  639. XStartDate string `description:"横坐标显示的起始日"`
  640. XEndDate string `description:"横坐标显示的截止日"`
  641. JumpYear int `description:"横坐标日期是否跨年,1跨年,0不跨年"`
  642. }
  643. type SeasonChartLegend struct {
  644. Name string
  645. Value string
  646. }
  647. type QuarterDataList []*QuarterData
  648. func (m QuarterDataList) Len() int {
  649. return len(m)
  650. }
  651. func (m QuarterDataList) Less(i, j int) bool {
  652. return m[i].Years < m[j].Years
  653. }
  654. func (m QuarterDataList) Swap(i, j int) {
  655. m[i], m[j] = m[j], m[i]
  656. }
  657. type ChartDwCollectReq struct {
  658. UniqueCode string
  659. Token string
  660. }