media_service.go 8.9 KB

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