package com.yeshi.buwan.service.manager.search;
|
|
import com.yeshi.buwan.domain.ResourceVideo;
|
import com.yeshi.buwan.domain.solr.SolrAlbumVideo;
|
import com.yeshi.buwan.domain.VideoInfo;
|
import com.yeshi.buwan.domain.VideoResource;
|
import com.yeshi.buwan.domain.video.AlbumVideoMap;
|
import com.yeshi.buwan.dto.search.SolrResultDTO;
|
import com.yeshi.buwan.dto.search.SolrVideoSearchFilter;
|
import com.yeshi.buwan.service.imp.ResourceVideoService;
|
import com.yeshi.buwan.service.imp.VideoInfoService;
|
import com.yeshi.buwan.service.imp.VideoResourceService;
|
import com.yeshi.buwan.service.inter.juhe.AlbumVideoMapService;
|
import com.yeshi.buwan.service.inter.video.VideoInfoExtraService;
|
import com.yeshi.buwan.util.StringUtil;
|
import com.yeshi.buwan.util.factory.SolrVideoFactory;
|
import org.apache.solr.client.solrj.response.UpdateResponse;
|
import org.slf4j.Logger;
|
import org.slf4j.LoggerFactory;
|
import org.springframework.dao.InvalidDataAccessApiUsageException;
|
import org.springframework.data.domain.Sort;
|
import org.springframework.data.solr.core.SolrTemplate;
|
import org.springframework.data.solr.core.query.Criteria;
|
import org.springframework.data.solr.core.query.Query;
|
import org.springframework.data.solr.core.query.SimpleFilterQuery;
|
import org.springframework.data.solr.core.query.SimpleQuery;
|
import org.springframework.data.solr.core.query.result.ScoredPage;
|
import org.springframework.stereotype.Component;
|
|
import javax.annotation.Resource;
|
import java.io.Serializable;
|
import java.util.*;
|
|
/**
|
* 搜索引擎-专辑数据管理
|
*/
|
@Component
|
public class SolrAlbumVideoDataManager {
|
|
private final String CORE_NAME = "buwan_album";
|
|
private final Logger logger = LoggerFactory.getLogger(SolrAlbumVideoDataManager.class);
|
|
@Resource
|
private SolrTemplate solrTemplate;
|
|
@Resource
|
private AlbumVideoMapService albumVideoMapService;
|
|
@Resource
|
private VideoInfoService videoInfoService;
|
|
@Resource
|
private ResourceVideoService resourceVideoService;
|
|
|
@Resource
|
private VideoInfoExtraService videoInfoExtraService;
|
|
@Resource
|
private VideoResourceService videoResourceService;
|
|
|
public void saveOrUpdate(VideoInfo videoInfo) {
|
List<VideoResource> resourceList = videoResourceService.getResourceList();
|
List<Long> rids = new ArrayList<>();
|
for (VideoResource vr : resourceList) {
|
rids.add(Long.parseLong(vr.getId()));
|
}
|
|
List<VideoInfo> videoList = new ArrayList<>();
|
videoList.add(videoInfo);
|
videoInfoExtraService.batchExtra(videoList, rids);
|
|
|
UpdateResponse updateResponse = solrTemplate.saveBean(CORE_NAME, SolrVideoFactory.createAlbum(videoInfo, videoInfo.getResourceList()));
|
if (updateResponse.getStatus() == 0) {
|
solrTemplate.commit(CORE_NAME);
|
} else {
|
solrTemplate.rollback(CORE_NAME);
|
}
|
}
|
|
public void saveOrUpdate(List<VideoInfo> videoInfoList) {
|
List<VideoResource> resourceList = videoResourceService.getResourceList();
|
List<Long> rids = new ArrayList<>();
|
for (VideoResource vr : resourceList) {
|
rids.add(Long.parseLong(vr.getId()));
|
}
|
videoInfoExtraService.batchExtra(videoInfoList, rids);
|
|
|
List<SolrAlbumVideo> solrVideoList = new ArrayList<>();
|
for (VideoInfo vi : videoInfoList) {
|
solrVideoList.add(SolrVideoFactory.createAlbum(vi, vi.getResourceList()));
|
}
|
UpdateResponse updateResponse = solrTemplate.saveBeans(CORE_NAME, solrVideoList);
|
if (updateResponse.getStatus() == 0) {
|
solrTemplate.commit(CORE_NAME);
|
} else {
|
solrTemplate.rollback(CORE_NAME);
|
}
|
}
|
|
/**
|
* 删除所有
|
*/
|
// public void clear() {
|
// Query query = new SimpleQuery("name:*");
|
// UpdateResponse updateResponse = solrTemplate.delete(query);
|
// if (updateResponse.getStatus() == 0) {
|
// solrTemplate.commit();
|
// } else {
|
// solrTemplate.rollback();
|
// }
|
// }
|
public void deleteById(String id) {
|
UpdateResponse updateResponse = solrTemplate.deleteById(CORE_NAME, id);
|
if (updateResponse.getStatus() == 0) {
|
solrTemplate.commit(CORE_NAME);
|
} else {
|
solrTemplate.rollback(CORE_NAME);
|
}
|
}
|
|
public SolrAlbumVideo findOne(Serializable id) {
|
SolrAlbumVideo solrVideo = solrTemplate.getById(CORE_NAME, id, SolrAlbumVideo.class);
|
return solrVideo;
|
}
|
|
public SolrResultDTO find(SolrVideoSearchFilter filter, int page, int pageSize) {
|
if (filter.getKey() == null) {
|
filter.setKey("");
|
}
|
logger.info(filter.getKey() + "#" + page);
|
Query query = null;
|
if (!StringUtil.isNullOrEmpty(filter.getKey())) {
|
//solr精准检索需要带引号
|
if (filter.isFuzzy()) {
|
query = new SimpleQuery(new Criteria("name").expression(filter.getKey()));
|
} else {
|
try {
|
query = new SimpleQuery(new Criteria("nameStr").startsWith(filter.getKey()).or("mainactor").expression("\"" + filter.getKey() + "\""));
|
} catch (InvalidDataAccessApiUsageException e) {
|
query = new SimpleQuery(new Criteria("nameStr").expression("\"" + filter.getKey() + "\"").or("mainactor").expression("\"" + filter.getKey() + "\""));
|
}
|
}
|
} else if (!StringUtil.isNullOrEmpty(filter.getActor())) {
|
query = new SimpleQuery(new Criteria("mainactor").expression("\"" + filter.getActor() + "\""));
|
} else if (!StringUtil.isNullOrEmpty(filter.getDirector())) {
|
query = new SimpleQuery(new Criteria("director").expression("\"" + filter.getDirector() + "\""));
|
} else {
|
query = new SimpleQuery("*:*");
|
}
|
|
|
if (filter.getVideoType() != null) {
|
query.addFilterQuery(new SimpleFilterQuery(Criteria.where("root_video_type").is(filter.getVideoType())));
|
}
|
|
if (filter.getResourceIds() != null && filter.getResourceIds().size() > 0) {
|
Criteria ors = null;
|
for (String rid : filter.getResourceIds()) {
|
if (ors == null)
|
ors = Criteria.where("resourceIds").contains(rid);
|
else
|
ors = ors.or("resourceIds").contains(rid);
|
}
|
query.addFilterQuery(new SimpleFilterQuery(ors));
|
}
|
if (filter.getFreeType() != null) {
|
query.addFilterQuery(new SimpleFilterQuery(Criteria.where("free_type").is(filter.getFreeType())));
|
}
|
|
if (filter.getArea() != null) {
|
query.addFilterQuery(new SimpleFilterQuery(Criteria.where("area").contains(filter.getArea())));
|
}
|
|
|
/** 设置分页开始记录数(第一页) 默认0 */
|
query.setOffset((page - 1) * pageSize);
|
/** 设置每页显示记录数，默认10 */
|
query.setRows(pageSize);
|
if (!StringUtil.isNullOrEmpty(filter.getSortKey())) {
|
query.addSort(new Sort(Sort.Direction.DESC, filter.getSortKey()));
|
}
|
|
|
ScoredPage<SolrAlbumVideo> result = solrTemplate.queryForPage(CORE_NAME, query, SolrAlbumVideo.class);
|
System.out.println("总记录数：" + result.getTotalElements());
|
List<SolrAlbumVideo> list = result.getContent();
|
return new SolrResultDTO(list, (int) result.getTotalElements());
|
}
|
|
public List<String> getSuggestKeyList(String key) {
|
Query query = new SimpleQuery(new Criteria("nameStr").expression(key + "*"));
|
/** 设置分页开始记录数(第一页) 默认0 */
|
query.setOffset(0);
|
/** 设置每页显示记录数，默认10 */
|
query.setRows(10);
|
|
|
ScoredPage<SolrAlbumVideo> result = solrTemplate.queryForPage(CORE_NAME, query, SolrAlbumVideo.class);
|
System.out.println("总记录数：" + result.getTotalElements());
|
List<SolrAlbumVideo> list = result.getContent();
|
List<String> keyList = new ArrayList<>();
|
for (SolrAlbumVideo sv : list)
|
if (!keyList.contains(sv.getName()))
|
keyList.add(sv.getName());
|
return keyList;
|
}
|
|
|
/**
|
* 同步所有专辑
|
*/
|
public void syncAllAlbum() {
|
long count = albumVideoMapService.countAll();
|
int pageSize = 100;
|
int pageCount = (int) (count % pageSize == 0 ? count / pageSize : count / pageSize + 1);
|
for (int i = 0; i < pageCount; i++) {
|
try {
|
List<String> videoIds = new ArrayList<>();
|
List<AlbumVideoMap> albumVideoMapList = albumVideoMapService.listAll(i + 1, pageSize);
|
for (AlbumVideoMap map : albumVideoMapList) {
|
videoIds.add(map.getVideoId());
|
}
|
List<VideoInfo> videoList = videoInfoService.listByVideoIds(videoIds);
|
|
//获取资源ID
|
List<ResourceVideo> rvList = resourceVideoService.getResourceList(videoList);
|
Map<String, List<VideoResource>> map = new HashMap<>();
|
for (ResourceVideo rv : rvList) {
|
if (rv.getVideo() != null && rv.getResource() != null) {
|
if (map.get(rv.getVideo().getId()) == null)
|
map.put(rv.getVideo().getId(), new ArrayList<>());
|
map.get(rv.getVideo().getId()).add(rv.getResource());
|
}
|
}
|
for (VideoInfo vi : videoList) {
|
if (map.get(vi.getId()) != null) {
|
vi.setResourceList(map.get(vi.getId()));
|
}
|
}
|
saveOrUpdate(videoList);
|
} catch (Exception e) {
|
logger.error("专辑搜索引擎数据同步失败", e);
|
}
|
}
|
}
|
|
public void syncAlbum(String videoId) {
|
AlbumVideoMap map = albumVideoMapService.selectByVideoId(videoId);
|
if (map == null)
|
return;
|
|
VideoInfo video = videoInfoService.getVideoInfo(videoId);
|
if (video != null) {
|
List<ResourceVideo> rvList = resourceVideoService.getResourceList(video.getId());
|
List<VideoResource> vrList = new ArrayList<>();
|
for (ResourceVideo rv : rvList)
|
vrList.add(rv.getResource());
|
video.setResourceList(vrList);
|
saveOrUpdate(video);
|
}
|
}
|
|
}
|
