CaseVideoServiceImpl.java 11 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237
  1. package com.fdkankan.fusion.service.impl;
  2. import cn.hutool.core.io.FileUtil;
  3. import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
  4. import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
  5. import com.baomidou.mybatisplus.core.conditions.update.LambdaUpdateWrapper;
  6. import com.fdkankan.fusion.common.ResultCode;
  7. import com.fdkankan.fusion.common.FilePath;
  8. import com.fdkankan.fusion.common.util.RedisKeyUtil;
  9. import com.fdkankan.fusion.common.util.LocalToOssUtil;
  10. import com.fdkankan.fusion.common.util.VideoUtil;
  11. import com.fdkankan.fusion.entity.CaseEntity;
  12. import com.fdkankan.fusion.entity.CaseVideoFolder;
  13. import com.fdkankan.fusion.exception.BusinessException;
  14. import com.fdkankan.fusion.entity.CaseVideo;
  15. import com.fdkankan.fusion.mapper.ICaseVideoMapper;
  16. import com.fdkankan.fusion.service.ICaseService;
  17. import com.fdkankan.fusion.service.ICaseVideoFolderService;
  18. import com.fdkankan.fusion.service.ICaseVideoService;
  19. import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
  20. import com.fdkankan.redis.util.RedisUtil;
  21. import lombok.extern.slf4j.Slf4j;
  22. import org.apache.commons.lang3.StringUtils;
  23. import org.springframework.beans.factory.annotation.Autowired;
  24. import org.springframework.beans.factory.annotation.Value;
  25. import org.springframework.scheduling.annotation.Async;
  26. import org.springframework.stereotype.Service;
  27. import org.springframework.web.multipart.MultipartFile;
  28. import java.io.File;
  29. import java.io.IOException;
  30. import java.util.ArrayList;
  31. import java.util.LinkedHashSet;
  32. import java.util.List;
  33. import java.util.concurrent.ThreadPoolExecutor;
  34. /**
  35. * <p>
  36. * 服务实现类
  37. * </p>
  38. *
  39. * @author
  40. * @since 2022-07-29
  41. */
  42. @Slf4j
  43. @Service
  44. public class CaseVideoServiceImpl extends ServiceImpl<ICaseVideoMapper, CaseVideo> implements ICaseVideoService {
  45. @Autowired
  46. LocalToOssUtil localToOssUtil;
  47. @Autowired
  48. ICaseVideoFolderService videoFolderService;
  49. @Autowired
  50. ICaseService caseService;
  51. @Autowired
  52. UploadService uploadService;
  53. @Value("${upload.query-path}")
  54. private String queryPath;
  55. @Value("${spring.profiles.active}")
  56. private String environment;
  57. @Autowired
  58. RedisUtil redisUtil;
  59. @Override
  60. public List<CaseVideo> getAllList(Integer folderId) {
  61. QueryWrapper<CaseVideo> wrapper = new QueryWrapper<>();
  62. wrapper.lambda().eq(CaseVideo::getFolderId,folderId);
  63. wrapper.lambda().orderByAsc(CaseVideo::getSort);
  64. wrapper.lambda().orderByAsc(CaseVideo::getCreateTime);
  65. return this.list(wrapper);
  66. }
  67. @Override
  68. public CaseVideoFolder uploadAddVideo(MultipartFile[] files, Integer folderId,Integer caseId) throws IOException {
  69. if(files.length <=0 || caseId == null){
  70. throw new BusinessException(ResultCode.MISSING_REQUIRED_PARAMETERS);
  71. }
  72. CaseEntity caseEntity = caseService.getById(caseId);
  73. if(caseEntity == null){
  74. throw new BusinessException(ResultCode.CASE_NOT_EXIST);
  75. }
  76. CaseVideoFolder videoFolder = videoFolderService.getByIdIfNotNew(folderId,caseId);
  77. if(videoFolder == null){
  78. throw new BusinessException(ResultCode.FOLDER_NOT_EXIST);
  79. }
  80. redisUtil.set(RedisKeyUtil.mergerVideoKey + videoFolder.getVideoFolderId(), "0");
  81. //替换文件夹中文件
  82. List<CaseVideo> videoList = new ArrayList<>();
  83. Integer sort = 1;
  84. LinkedHashSet<String> filePathSet = new LinkedHashSet<>();
  85. for (MultipartFile file : files) {
  86. String localPath = uploadService.uploadFile(file, videoFolder.getVideoFolderId());
  87. if(StringUtils.isEmpty(localPath)){
  88. throw new BusinessException(ResultCode.UPLOAD_ERROR);
  89. }
  90. filePathSet.add(localPath);
  91. CaseVideo caseVideo = new CaseVideo();
  92. caseVideo.setFolderId(videoFolder.getVideoFolderId());
  93. caseVideo.setVideoPath(localPath);
  94. caseVideo.setVideoName(file.getName());
  95. caseVideo.setSort(sort);
  96. videoList.add(caseVideo);
  97. sort++;
  98. }
  99. if (videoList.size() <= 0) {
  100. return videoFolder;
  101. }
  102. this.saveBatch(videoList);
  103. runThread(filePathSet,videoFolder,this);
  104. return videoFolder;
  105. }
  106. public void runThread(LinkedHashSet<String> filePathSet,CaseVideoFolder videoFolder,ICaseVideoService caseVideoService){
  107. new Thread(new Runnable() {
  108. @Override
  109. public void run() {
  110. LinkedHashSet<String> filePathSetAll = new LinkedHashSet<>();
  111. LinkedHashSet<String> ossDelList = new LinkedHashSet<>();
  112. String mergeLocalPath = null;
  113. String mergeLocalPathImg = null;
  114. try {
  115. String mergeVideoUrl = null;
  116. if (StringUtils.isNotBlank(videoFolder.getVideoMergeUrl())) {
  117. mergeVideoUrl = videoFolder.getVideoMergeUrl().replace(queryPath, "/home/");
  118. localToOssUtil.downFormAli(videoFolder.getVideoMergeUrl().replace(queryPath, ""), mergeVideoUrl);
  119. ossDelList.add(videoFolder.getVideoMergeUrl());
  120. }
  121. caseVideoService.deleteByFolderId(videoFolder.getVideoFolderId());
  122. redisUtil.set(RedisKeyUtil.mergerVideoKey + videoFolder.getVideoFolderId(), "10");
  123. redisUtil.set(RedisKeyUtil.mergerVideoKey + videoFolder.getVideoFolderId(), "20");
  124. if (StringUtils.isNotBlank(mergeVideoUrl)) {
  125. filePathSetAll.add(mergeVideoUrl);
  126. }
  127. filePathSetAll.addAll(filePathSet);
  128. Boolean newCover = true;
  129. if(StringUtils.isNotBlank(videoFolder.getVideoFolderCover()) && localToOssUtil.existKey(videoFolder.getVideoFolderCover().replace(queryPath,""))){
  130. newCover = false;
  131. }
  132. String mergeLocalName = VideoUtil.mergeVideo(filePathSetAll, String.format(FilePath.VIDEO_LOCAL_PATH,environment),newCover);
  133. redisUtil.set(RedisKeyUtil.mergerVideoKey + videoFolder.getVideoFolderId(), "30");
  134. if (mergeLocalName == null) {
  135. updateCaseVideoStatus(videoFolder.getVideoFolderId(), -1);
  136. redisUtil.set(RedisKeyUtil.mergerVideoKey + videoFolder.getVideoFolderId(), "-1");
  137. return;
  138. }
  139. mergeLocalPath = String.format(FilePath.VIDEO_LOCAL_PATH,environment) + "/" + mergeLocalName;
  140. String ossKey = String.format(FilePath.VIDEO_OSS_PATH,environment, videoFolder.getVideoFolderId()) + "/" + mergeLocalName;
  141. localToOssUtil.uploadOss(mergeLocalPath, ossKey);
  142. if (!localToOssUtil.existKey(ossKey)) {
  143. updateCaseVideoStatus(videoFolder.getVideoFolderId(), -1);
  144. redisUtil.set(RedisKeyUtil.mergerVideoKey + videoFolder.getVideoFolderId(), "-1");
  145. return;
  146. }
  147. if(newCover){
  148. mergeLocalPathImg = String.format(FilePath.VIDEO_LOCAL_PATH,environment) + "/" + mergeLocalName.replace(".mp4", ".jpg");
  149. String ossKeyImg = String.format(FilePath.VIDEO_OSS_PATH, environment,videoFolder.getVideoFolderId()) + "/" + mergeLocalName.replace(".mp4", ".jpg");
  150. localToOssUtil.uploadOss(mergeLocalPathImg, ossKeyImg);
  151. if (!localToOssUtil.existKey(ossKeyImg)) {
  152. updateCaseVideoStatus(videoFolder.getVideoFolderId(), -1);
  153. redisUtil.set(RedisKeyUtil.mergerVideoKey + videoFolder.getVideoFolderId(), "-1");
  154. return;
  155. }
  156. videoFolder.setVideoFolderCover(queryPath + ossKeyImg);
  157. }
  158. redisUtil.set(RedisKeyUtil.mergerVideoKey + videoFolder.getVideoFolderId(), "70");
  159. videoFolder.setVideoMergeUrl(queryPath + ossKey);
  160. videoFolderService.updateById(videoFolder);
  161. updateCaseVideoStatus(videoFolder.getVideoFolderId(), 1);
  162. //删除oss原资源
  163. for (String path : ossDelList) {
  164. uploadService.deleteOssUrl(path);
  165. }
  166. redisUtil.set(RedisKeyUtil.mergerVideoKey + videoFolder.getVideoFolderId(), "100");
  167. }catch (Exception e){
  168. updateCaseVideoStatus(videoFolder.getVideoFolderId(), -1);
  169. redisUtil.set(RedisKeyUtil.mergerVideoKey + videoFolder.getVideoFolderId(), "-1");
  170. log.info("合并视频出错:",e);
  171. }finally {
  172. for (String path : filePathSetAll) {
  173. FileUtil.del(path);
  174. }
  175. FileUtil.del(mergeLocalPath);
  176. FileUtil.del(mergeLocalPathImg);
  177. }
  178. }
  179. }).start();
  180. }
  181. private void updateCaseVideoStatus(Integer folderId, Integer status) {
  182. LambdaUpdateWrapper<CaseVideo> wrapper = new LambdaUpdateWrapper<>();
  183. wrapper.in(CaseVideo::getFolderId,folderId)
  184. .set(CaseVideo::getUploadStatus,status);
  185. this.update(wrapper);
  186. LambdaUpdateWrapper<CaseVideoFolder> wrapperFolder = new LambdaUpdateWrapper<>();
  187. wrapperFolder.eq(CaseVideoFolder::getVideoFolderId,folderId)
  188. .set(CaseVideoFolder::getUploadStatus,status);
  189. videoFolderService.update(wrapperFolder);
  190. }
  191. @Override
  192. public String uploadAddVideoProgress(Integer folderId) {
  193. String redisKey = RedisKeyUtil.mergerVideoKey+folderId;
  194. if(redisUtil.hasKey(redisKey)){
  195. return redisUtil.get(redisKey);
  196. }
  197. return "0";
  198. }
  199. @Override
  200. public void deleteByFolderId(Integer videoFolderId) {
  201. LambdaQueryWrapper<CaseVideo> wrapper = new LambdaQueryWrapper<>();
  202. wrapper.eq(CaseVideo::getFolderId,videoFolderId);
  203. List<CaseVideo> list = this.list(wrapper);
  204. if(list.size() <=0){
  205. return;
  206. }
  207. for (CaseVideo caseVideo : list) {
  208. this.delete(caseVideo.getVideoId());
  209. }
  210. }
  211. @Override
  212. public void delete(Integer videoId) {
  213. CaseVideo caseVideo = this.getById(videoId);
  214. this.removeById(videoId);
  215. uploadService.deleteOssUrl(caseVideo.getVideoPath());
  216. uploadService.deleteOssUrl(caseVideo.getVideoCover());
  217. }
  218. }