chart_info_elastic.go 5.1 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172
  1. package data
  2. import (
  3. "eta_gn/eta_api/models/data_manage"
  4. "eta_gn/eta_api/services/elastic"
  5. "eta_gn/eta_api/utils"
  6. "fmt"
  7. "strconv"
  8. "strings"
  9. )
  10. // AddAllChartInfo
  11. // @Description: 更新es中的所有的图表数据
  12. // @author: Roc
  13. // @datetime 2024-11-20 13:11:35
  14. func AddAllChartInfo() {
  15. allList, err := data_manage.GetChartInfoAllList()
  16. if err != nil {
  17. fmt.Println("GetArticleAll Err:", err.Error())
  18. return
  19. }
  20. total := len(allList)
  21. for k, v := range allList {
  22. EsAddOrEditChartInfo(v.ChartInfoId)
  23. fmt.Println("剩余", total-k-1, "条图表数据,当前图表id:", v.ChartInfoId)
  24. }
  25. }
  26. // EsAddOrEditChartInfo 新增和修改ES中的图表数据
  27. func EsAddOrEditChartInfo(chartInfoId int) {
  28. var err error
  29. defer func() {
  30. if err != nil {
  31. fmt.Println("新增和修改ES中的图表数据失败:", err.Error())
  32. }
  33. }()
  34. itemInfo, err := data_manage.GetChartEsInfoById(chartInfoId)
  35. if err != nil {
  36. return
  37. }
  38. // 获取分享人
  39. obj := data_manage.ChartInfoShare{}
  40. list, _ := obj.GetListByChartInfoId(itemInfo.ChartInfoId)
  41. sharedList := make([]int, 0)
  42. for _, v := range list {
  43. sharedList = append(sharedList, v.SysUserId)
  44. }
  45. itemInfo.SharedUserIdList = sharedList
  46. //添加es
  47. err = elastic.EsAddOrEditChartInfoData(utils.CHART_INDEX_NAME, strconv.Itoa(itemInfo.ChartInfoId), itemInfo)
  48. return
  49. }
  50. // EsDeleteChartInfo 删除ES中的图表数据
  51. func EsDeleteChartInfo(chartInfoId int) {
  52. var err error
  53. defer func() {
  54. if err != nil {
  55. fmt.Println("删除ES中的图表数据失败:", err.Error())
  56. }
  57. }()
  58. //添加es
  59. err = elastic.EsDeleteDataV2(utils.CHART_INDEX_NAME, strconv.Itoa(chartInfoId))
  60. return
  61. }
  62. // EsSearchChartInfo 搜索图表信息
  63. func EsSearchChartInfo(keyword string, showSysId int, sourceList []int, noPermissionChartIdList []int, startSize, pageSize int) (list []*data_manage.ChartInfo, total int64, err error) {
  64. list, total, err = elastic.SearchChartInfoData(utils.CHART_INDEX_NAME, keyword, showSysId, sourceList, noPermissionChartIdList, startSize, pageSize)
  65. return
  66. }
  67. // EsAddOrEditMyChartInfoByChartInfoId 根据图表id 新增和修改ES中的图表数据
  68. func EsAddOrEditMyChartInfoByChartInfoId(chartInfoId int) {
  69. errMsg := make([]string, 0)
  70. defer func() {
  71. if len(errMsg) > 0 {
  72. fmt.Println("新增和修改ES中的图表数据失败:", strings.Join(errMsg, "\n"))
  73. }
  74. }()
  75. var condition string
  76. var pars []interface{}
  77. condition += " and a.chart_info_id = ? "
  78. pars = append(pars, chartInfoId)
  79. allList, err := data_manage.GetMyChartListGroupByCharyInfoIdAndAdminIdByCondition(condition, pars)
  80. if err != nil {
  81. errMsg = append(errMsg, fmt.Sprintf("EsAddOrEditMyChartInfoByChartInfoId Err:%s", err.Error()))
  82. return
  83. }
  84. for _, v := range allList {
  85. //添加es
  86. err = elastic.EsAddOrEditDataInterface(utils.MY_CHART_INDEX_NAME, strconv.Itoa(v.MyChartId), v)
  87. if err != nil {
  88. errMsg = append(errMsg, fmt.Sprintf("myChartId:%d,添加Es失败,err:%s", v.MyChartId, err.Error()))
  89. }
  90. }
  91. return
  92. }
  93. // EsAddOrEditMyChartInfoByMyChartId 根据我的图库id 新增和修改ES中的图表数据
  94. func EsAddOrEditMyChartInfoByMyChartId(myChartId int) {
  95. errMsg := make([]string, 0)
  96. defer func() {
  97. if len(errMsg) > 0 {
  98. fmt.Println("新增和修改ES中的图表数据失败:", strings.Join(errMsg, "\n"))
  99. }
  100. }()
  101. var condition string
  102. var pars []interface{}
  103. condition += " AND a.my_chart_id = ? "
  104. pars = append(pars, myChartId)
  105. allList, err := data_manage.GetMyChartListGroupByCharyInfoIdAndAdminIdByCondition(condition, pars)
  106. if err != nil {
  107. errMsg = append(errMsg, fmt.Sprintf("EsAddOrEditMyChartInfoByMyChartId Err:%s", err.Error()))
  108. return
  109. }
  110. for _, v := range allList {
  111. //添加es
  112. err = elastic.EsAddOrEditDataInterface(utils.MY_CHART_INDEX_NAME, strconv.Itoa(v.MyChartId), v)
  113. if err != nil {
  114. errMsg = append(errMsg, fmt.Sprintf("myChartId:%d,添加Es失败,err:%s", v.MyChartId, err.Error()))
  115. }
  116. }
  117. return
  118. }
  119. // EsDeleteMyChartInfoByMyChartId 根据我的图库id 删除ES中的图表数据
  120. func EsDeleteMyChartInfoByMyChartId(myChartId int) {
  121. var err error
  122. defer func() {
  123. if err != nil {
  124. fmt.Println("删除ES中的图表数据失败:", err.Error())
  125. }
  126. }()
  127. //添加es
  128. err = elastic.EsDeleteDataV2(utils.MY_CHART_INDEX_NAME, strconv.Itoa(myChartId))
  129. return
  130. }
  131. // EsSearchMyChartInfo 搜索图表信息
  132. func EsSearchMyChartInfo(keyword string, adminId int, noPermissionChartIdList []int, startSize, pageSize int) (list []*data_manage.MyChartList, total int64, err error) {
  133. list, total, err = elastic.SearchMyChartInfoData(utils.MY_CHART_INDEX_NAME, keyword, adminId, noPermissionChartIdList, startSize, pageSize)
  134. return
  135. }
  136. // EsDeleteMyChartInfoByMyChartIds 根据我的图表IDs删除ES中的我的图表
  137. func EsDeleteMyChartInfoByMyChartIds(ids []int) {
  138. if len(ids) == 0 {
  139. return
  140. }
  141. errMsg := make([]string, 0)
  142. defer func() {
  143. if len(errMsg) > 0 {
  144. fmt.Println("EsDeleteMyChartInfoByMyChartIds, 删除ES中的我的图表数据失败:", strings.Join(errMsg, "\n"))
  145. }
  146. }()
  147. for _, v := range ids {
  148. id := strconv.Itoa(v)
  149. if e := elastic.EsDeleteDataV2(utils.MY_CHART_INDEX_NAME, id); e != nil {
  150. errMsg = append(errMsg, fmt.Sprintf("myChartId:%d,删除Es失败,err:%s", v, e.Error()))
  151. }
  152. }
  153. return
  154. }