media_service.go 7.7 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213
  1. package media
  2. import (
  3. "encoding/json"
  4. "eta/eta_mini_ht_api/common/component/config"
  5. "eta/eta_mini_ht_api/common/component/es"
  6. logger "eta/eta_mini_ht_api/common/component/log"
  7. "eta/eta_mini_ht_api/common/contants"
  8. "eta/eta_mini_ht_api/common/utils/page"
  9. reportService "eta/eta_mini_ht_api/domian/report"
  10. "eta/eta_mini_ht_api/models"
  11. mediaDao "eta/eta_mini_ht_api/models/media"
  12. "sort"
  13. "time"
  14. )
  15. var (
  16. htConfig = config.GetConfig(contants.HT).(*config.HTBizConfig)
  17. )
  18. const (
  19. DESC models.Order = "desc"
  20. ASC models.Order = "asc"
  21. ESColumn = "mediaName"
  22. ESRangeColumn = "mediaId"
  23. ConditionColumn = "mediaType"
  24. )
  25. var (
  26. sortField = []string{"_score:desc"}
  27. )
  28. func elastic() *es.ESClient {
  29. return es.GetInstance()
  30. }
  31. type MediaDTO struct {
  32. MediaId int `json:"mediaId"`
  33. AuthorId int `json:"authorId"`
  34. AuthorName string `json:"authorName,omitempty"`
  35. MediaType string `json:"mediaType"`
  36. Src string `json:"src"`
  37. MediaName string `json:"mediaName"`
  38. MediaTitle string `json:"mediaTitle,omitempty"`
  39. CoverSrc string `json:"coverSrc"`
  40. SourceType string `json:"sourceType"`
  41. MediaPlayMilliseconds int `json:"mediaPlayMilliseconds"`
  42. PublishedTime string `json:"publishedTime"`
  43. PermissionIDs string `json:"permissionIds"`
  44. PermissionNames []string `json:"permissionNames,omitempty"`
  45. Highlight []string `json:"highlight,omitempty"`
  46. }
  47. func SearchMediaList(mediaType string, key string, from int, size int, max int64) (reports []MediaDTO, err error) {
  48. //同步es
  49. sorts := append(sortField, "publishedTime:desc")
  50. request := matchRangeByCondition(key, from, size, max, sorts, ConditionColumn, mediaType)
  51. re, err := elastic().Search(request)
  52. if err != nil {
  53. logger.Error("es搜索失败:%v", err)
  54. }
  55. hits := elastic().GetSource(re.Hits)
  56. for _, hit := range hits {
  57. var content map[string][]string
  58. err = json.Unmarshal(hit.Highlight, &content)
  59. media := MediaDTO{}
  60. err = json.Unmarshal(hit.Source, &media)
  61. if err != nil {
  62. logger.Error("解析媒体数据失败:%v", err)
  63. continue
  64. }
  65. media.Highlight = content[ESColumn]
  66. media.PublishedTime = media.PublishedTime[:10]
  67. media.MediaTitle = media.Highlight[0]
  68. reports = append(reports, media)
  69. }
  70. return
  71. }
  72. func SearchMaxMediaId(mediaType string, key string) (total int64, latestId int64) {
  73. mediaSort := []string{"mediaId:desc"}
  74. request := matchAllByCondition(mediaSort, key, ConditionColumn, mediaType)
  75. //同步es
  76. //re, err := elastic().Search(request)
  77. re, err := elastic().Count(request)
  78. if err != nil {
  79. logger.Error("es搜索失败:%v", err)
  80. }
  81. count := re.Count
  82. total = int64(count)
  83. if total > 0 {
  84. request = matchByCondition(mediaSort, key, ConditionColumn, mediaType, 0, count)
  85. re, err = elastic().Search(request)
  86. if err != nil {
  87. logger.Error("es搜索异常:%v", err)
  88. }
  89. hits := elastic().GetSource(re.Hits)
  90. data := hits[0].Source
  91. media := MediaDTO{}
  92. err = json.Unmarshal(data, &media)
  93. if err != nil {
  94. logger.Error("获取当前最大媒体id失败:%v", err)
  95. return
  96. }
  97. total = int64(len(hits))
  98. latestId = int64(media.MediaId)
  99. return
  100. }
  101. return
  102. }
  103. func GetMediaPermissionMappingByPermissionIds(mediaType string, permissionIds []int) (total int64, latestId int64, ids []int) {
  104. ids, err := mediaDao.GetMediaPermissionMappingByPermissionId(mediaType, permissionIds)
  105. if err != nil {
  106. logger.Error("获取当前最大媒体id失败:%v", err)
  107. return 0, 0, ids
  108. }
  109. sort.Slice(ids, func(i, j int) bool {
  110. return ids[i] > ids[j]
  111. })
  112. return int64(len(ids)), int64(ids[0]), ids
  113. }
  114. func GetTotalPageCount(mediaType string) (count int64, latestId int64) {
  115. return mediaDao.GetCountByMediaType(mediaType)
  116. }
  117. func GetTotalPageCountByAnalystId(mediaType string, analystId int) (count int64, latestId int64) {
  118. return mediaDao.GetCountByMediaTypeByAnalystId(mediaType, analystId)
  119. }
  120. func GetMediaPageByIds(mediaType string, pageInfo page.PageInfo, mediaIds []int) (list []MediaDTO, err error) {
  121. offset := page.StartIndex(pageInfo.Current, pageInfo.PageSize)
  122. medias, err := mediaDao.GetMediaPageByIds(pageInfo.LatestId, pageInfo.PageSize, offset, mediaType, mediaIds)
  123. if err == nil && medias != nil {
  124. for _, media := range medias {
  125. dto := convertMediaDTO(media, false)
  126. list = append(list, dto)
  127. }
  128. }
  129. return
  130. }
  131. func GetMediaPageByAnalystId(mediaType string, pageInfo page.PageInfo, analystId int) (list []MediaDTO, err error) {
  132. offset := page.StartIndex(pageInfo.Current, pageInfo.PageSize)
  133. medias, err := mediaDao.GetMediaPageByAnalystId(pageInfo.LatestId, pageInfo.PageSize, offset, mediaType, analystId)
  134. if err == nil && medias != nil {
  135. for _, media := range medias {
  136. dto := convertMediaDTO(media, false)
  137. list = append(list, dto)
  138. }
  139. }
  140. return
  141. }
  142. func convertMediaDTO(media mediaDao.Media, fullTime bool) MediaDTO {
  143. if fullTime {
  144. return MediaDTO{
  145. MediaId: media.Id,
  146. AuthorId: media.AuthorID,
  147. AuthorName: media.AuthorName,
  148. MediaType: string(media.MediaType),
  149. Src: media.Src,
  150. MediaName: media.MediaName,
  151. SourceType: media.SourceType,
  152. CoverSrc: media.CoverSrc,
  153. MediaPlayMilliseconds: media.MediaPlayMilliseconds,
  154. PermissionIDs: media.PermissionIDs,
  155. PublishedTime: media.PublishedTime.Format(time.DateTime),
  156. }
  157. } else {
  158. return MediaDTO{
  159. MediaId: media.Id,
  160. AuthorId: media.AuthorID,
  161. AuthorName: media.AuthorName,
  162. MediaType: string(media.MediaType),
  163. Src: media.Src,
  164. MediaName: media.MediaName,
  165. SourceType: media.SourceType,
  166. CoverSrc: media.CoverSrc,
  167. MediaPlayMilliseconds: media.MediaPlayMilliseconds,
  168. PermissionIDs: media.PermissionIDs,
  169. PublishedTime: media.PublishedTime.Format(time.DateOnly),
  170. }
  171. }
  172. }
  173. func GetMediaById(mediaType string, mediaId int) (mediaDTO MediaDTO, err error) {
  174. media, err := mediaDao.GetMediaById(mediaType, mediaId)
  175. if err != nil {
  176. logger.Error("查询媒体信息失败:%v", err)
  177. return
  178. }
  179. mediaDTO = convertMediaDTO(media, true)
  180. return
  181. }
  182. func GetPermissionsByIds(ids []int) (permissionDTOs []reportService.PermissionDTO, err error) {
  183. return reportService.GetFirstPermissionsByIds(ids)
  184. }
  185. func matchAllByCondition(sorts []string, key string, column string, value string) (request *es.ESQueryRequest) {
  186. req := new(es.ESQueryRequest)
  187. //return req.CreateESQueryRequest(htConfig.GetMediaIndex(), ESColumn, key, 0, 1, sorts, es.MatchAllByCondition).ByCondition(column, value)
  188. return req.CreateESQueryRequest(htConfig.GetMediaIndex(), ESColumn, key, 0, 1, sorts, es.MatchAll)
  189. }
  190. func matchByCondition(sorts []string, key string, column string, value string, from int, to int) (request *es.ESQueryRequest) {
  191. req := new(es.ESQueryRequest)
  192. //return req.CreateESQueryRequest(htConfig.GetMediaIndex(), ESColumn, key, from, to, sorts, es.MatchAllByCondition).ByCondition(column, value)
  193. return req.CreateESQueryRequest(htConfig.GetMediaIndex(), ESColumn, key, from, to, sorts, es.MatchAll)
  194. }
  195. func matchRangeByCondition(key string, from int, to int, max int64, sorts []string, column string, value string) (request *es.ESQueryRequest) {
  196. req := new(es.ESQueryRequest)
  197. //return req.CreateESQueryRequest(htConfig.GetMediaIndex(), ESColumn, key, from, to, sorts, es.RangeByCondition).Range(0, max, ESRangeColumn).ByCondition(column, value)
  198. return req.CreateESQueryRequest(htConfig.GetMediaIndex(), ESColumn, key, from, to, sorts, es.Range).Range(0, max, ESRangeColumn)
  199. }
  200. func GetImageSrc(id int) (src string, err error) {
  201. return mediaDao.GetImageSrc(id)
  202. }