base_from_business.go 2.8 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106
  1. package data
  2. import (
  3. "eta/eta_api/models/data_manage"
  4. "eta/eta_api/models/mgo"
  5. "eta/eta_api/utils"
  6. "fmt"
  7. "go.mongodb.org/mongo-driver/bson"
  8. )
  9. type BusinessIndexSource2EdbReq struct {
  10. EdbCode string
  11. EdbName string
  12. Frequency string
  13. Unit string
  14. ClassifyId int
  15. AdminId int
  16. AdminRealName string
  17. }
  18. // BusinessIndexSource2Edb 新增彭博数据源到指标库
  19. func BusinessIndexSource2Edb(req BusinessIndexSource2EdbReq, lang string) (edb *data_manage.EdbInfo, err error, errMsg string, skip bool) {
  20. if req.EdbCode == "" {
  21. err = fmt.Errorf("指标ID为空")
  22. return
  23. }
  24. defer func() {
  25. if err != nil {
  26. tips := fmt.Sprintf("BusinessIndexSource2Edb新增失败, Err: %s", err.Error())
  27. fmt.Println(tips)
  28. utils.FileLog.Info(tips)
  29. }
  30. }()
  31. source := utils.DATA_SOURCE_BUSINESS
  32. // 是否新增过指标
  33. exist, e := data_manage.GetEdbInfoByEdbCode(source, req.EdbCode)
  34. if e != nil && e.Error() != utils.ErrNoRow() {
  35. err = fmt.Errorf("获取指标是否存在失败, err: %s", e.Error())
  36. return
  37. }
  38. if exist != nil {
  39. skip = true
  40. return
  41. }
  42. // 开始结束时间
  43. var startDate, endDate string
  44. // 新增指标库
  45. edbInfo, e, msg, _ := EdbInfoAdd(source, utils.DATA_SUB_SOURCE_EDB, req.ClassifyId, req.EdbCode, req.EdbName, req.Frequency, req.Unit, startDate, endDate, req.AdminId, req.AdminRealName, lang)
  46. if e != nil {
  47. errMsg = msg
  48. err = fmt.Errorf("EdbInfo: 新增指标失败, err: %s", e.Error())
  49. return
  50. }
  51. edb = edbInfo
  52. return
  53. }
  54. // GetPageBaseBusinessIndexData
  55. // @Description: 获取自有数据的分页数据
  56. // @author: Roc
  57. // @datetime 2024-05-07 11:02:51
  58. // @param indexCode int
  59. // @param startSize int
  60. // @param pageSize int
  61. // @return dataCount int
  62. // @return dataList []*data_manage.BaseFromBusinessIndexDataItem
  63. // @return err error
  64. func GetPageBaseBusinessIndexData(indexCode string, startSize, pageSize int) (dataCount int, dataList []*data_manage.BaseFromBusinessIndexDataItem, err error) {
  65. dataList = make([]*data_manage.BaseFromBusinessIndexDataItem, 0)
  66. mogDataObj := mgo.BaseFromBusinessData{}
  67. // 构建查询条件
  68. queryConditions := bson.M{
  69. "index_code": indexCode,
  70. }
  71. // 获取数据总量
  72. tmpCount, tmpErr := mogDataObj.GetCountDataList(queryConditions)
  73. if tmpErr != nil && tmpErr.Error() != utils.ErrNoRow() {
  74. err = tmpErr
  75. return
  76. }
  77. dataCount = int(tmpCount)
  78. // 获取列表数据
  79. tmpDataList, tmpErr := mogDataObj.GetPageDataList(queryConditions, int64(startSize), int64(pageSize), []string{"-data_time"})
  80. if tmpErr != nil {
  81. err = tmpErr
  82. return
  83. }
  84. for _, v := range tmpDataList {
  85. dataList = append(dataList, &data_manage.BaseFromBusinessIndexDataItem{
  86. ID: v.ID.String(),
  87. IndexCode: v.IndexCode,
  88. DataTime: v.DataTime.Format(utils.FormatDate),
  89. Value: v.Value,
  90. })
  91. }
  92. return
  93. }