package com.dji.sample.media.service.impl;
|
|
import com.alibaba.fastjson.JSONObject;
|
import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
|
import com.baomidou.mybatisplus.core.conditions.update.LambdaUpdateWrapper;
|
import com.baomidou.mybatisplus.core.toolkit.Wrappers;
|
import com.baomidou.mybatisplus.extension.conditions.update.LambdaUpdateChainWrapper;
|
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;
|
import com.dji.sample.common.model.Pagination;
|
import com.dji.sample.common.model.PaginationData;
|
import com.dji.sample.component.oss.model.OssConfiguration;
|
import com.dji.sample.component.oss.service.impl.OssServiceContext;
|
import com.dji.sample.manage.model.dto.DeviceDictionaryDTO;
|
import com.dji.sample.manage.model.enums.DeviceDomainEnum;
|
import com.dji.sample.manage.service.IDeviceDictionaryService;
|
import com.dji.sample.media.dao.IFileMapper;
|
import com.dji.sample.media.model.FileUploadDTO;
|
import com.dji.sample.media.model.MediaFileDTO;
|
import com.dji.sample.media.model.MediaFileEntity;
|
import com.dji.sample.media.model.MediaFileQueryParam;
|
import com.dji.sample.media.service.IFileService;
|
import com.dji.sample.patches.model.entity.LotInfo;
|
import com.dji.sample.wayline.model.entity.WaylineJobEntity;
|
import org.springframework.beans.factory.annotation.Autowired;
|
import org.springframework.stereotype.Service;
|
import org.springframework.transaction.annotation.Transactional;
|
|
import java.net.URL;
|
import java.time.Instant;
|
import java.time.LocalDateTime;
|
import java.time.ZoneId;
|
import java.util.Arrays;
|
import java.util.List;
|
import java.util.Optional;
|
import java.util.UUID;
|
import java.util.stream.Collectors;
|
|
/**
|
* @author sean
|
* @version 0.2
|
* @date 2021/12/9
|
*/
|
@Service
|
@Transactional
|
public class FileServiceImpl implements IFileService {
|
|
@Autowired
|
private IFileMapper mapper;
|
|
@Autowired
|
private IDeviceDictionaryService deviceDictionaryService;
|
|
@Autowired
|
private OssServiceContext ossService;
|
|
private Optional<MediaFileEntity> getMediaByFingerprint(String workspaceId, String fingerprint) {
|
MediaFileEntity fileEntity = mapper.selectOne(new LambdaQueryWrapper<MediaFileEntity>()
|
.eq(MediaFileEntity::getWorkspaceId, workspaceId)
|
.eq(MediaFileEntity::getFingerprint, fingerprint));
|
return Optional.ofNullable(fileEntity);
|
}
|
|
private Optional<MediaFileEntity> getMediaByFileId(String workspaceId, String fileId) {
|
MediaFileEntity fileEntity = mapper.selectOne(new LambdaQueryWrapper<MediaFileEntity>()
|
.eq(MediaFileEntity::getWorkspaceId, workspaceId)
|
.eq(MediaFileEntity::getFileId, fileId));
|
return Optional.ofNullable(fileEntity);
|
}
|
|
@Override
|
public Boolean checkExist(String workspaceId, String fingerprint) {
|
return this.getMediaByFingerprint(workspaceId, fingerprint).isPresent();
|
}
|
|
@Override
|
public Integer saveFile(String workspaceId, FileUploadDTO file) {
|
MediaFileEntity fileEntity = this.fileUploadConvertToEntity(file);
|
fileEntity.setWorkspaceId(workspaceId);
|
fileEntity.setFileId(UUID.randomUUID().toString());
|
return mapper.insert(fileEntity);
|
}
|
|
@Override
|
public List<MediaFileDTO> getAllFilesByWorkspaceId(String workspaceId) {
|
return mapper.selectList(new LambdaQueryWrapper<MediaFileEntity>()
|
.eq(MediaFileEntity::getWorkspaceId, workspaceId))
|
.stream()
|
.map(this::entityConvertToDto)
|
.collect(Collectors.toList());
|
}
|
|
@Override
|
public List<MediaFileEntity> listMediaFileEntity(String workspaceId, String jobId) {
|
return mapper.selectList(new LambdaQueryWrapper<MediaFileEntity>()
|
.eq(MediaFileEntity::getWorkspaceId, workspaceId).eq(MediaFileEntity::getJobId,jobId));
|
}
|
|
@Override
|
public PaginationData<MediaFileEntity> getMediaFilesPaginationByWorkspaceId(String workspaceId, long page, long pageSize, MediaFileQueryParam mediaFileQueryParam) {
|
// Page<MediaFileEntity> pageData = mapper.selectPage(
|
// new Page<MediaFileEntity>(page, pageSize),
|
// new LambdaQueryWrapper<MediaFileEntity>()
|
// .eq(MediaFileEntity::getWorkspaceId, workspaceId)
|
// .orderByDesc(MediaFileEntity::getId));
|
Page<MediaFileEntity> pageData = mapper.selectPage(new Page<MediaFileEntity>(page, pageSize), new LambdaQueryWrapper<MediaFileEntity>()
|
.eq(MediaFileEntity::getWorkspaceId,workspaceId)
|
.orderByDesc(MediaFileEntity::getCreateTime));
|
|
List<MediaFileEntity> records = pageData.getRecords()
|
.stream()
|
.collect(Collectors.toList());
|
return new PaginationData<MediaFileEntity>(records, new Pagination(pageData));
|
}
|
|
public int deleteMedia(String workspaceId, String fileId) {
|
int count=mapper.delete(new LambdaUpdateWrapper<MediaFileEntity>().eq(MediaFileEntity::getFileId, fileId)
|
.eq(MediaFileEntity::getWorkspaceId, workspaceId));
|
return count;
|
}
|
@Override
|
public URL getObjectUrl(String workspaceId, String fileId) {
|
Optional<MediaFileEntity> mediaFileOpt = getMediaByFileId(workspaceId, fileId);
|
if (mediaFileOpt.isEmpty()) {
|
throw new IllegalArgumentException("{} 不存在");
|
}
|
|
return ossService.getObjectUrl(OssConfiguration.bucket, mediaFileOpt.get().getObjectKey());
|
}
|
|
@Override
|
public List<MediaFileDTO> getFilesByWorkspaceAndJobId(String workspaceId, String jobId) {
|
return mapper.selectList(new LambdaQueryWrapper<MediaFileEntity>()
|
.eq(MediaFileEntity::getWorkspaceId, workspaceId)
|
.eq(MediaFileEntity::getJobId, jobId))
|
.stream()
|
.map(this::entityConvertToDto).collect(Collectors.toList());
|
}
|
|
@Override
|
public Boolean updateMediaFile(String workspaceId, MediaFileEntity mediaFileEntity) {
|
|
/*MediaFileEntity params = new MediaFileEntity();
|
params.setFileId(mediaFileEntity.getFileId());
|
params.setWorkspaceId(mediaFileEntity.getWorkspaceId());*/
|
boolean update1 = new LambdaUpdateChainWrapper<>(mapper).eq(MediaFileEntity::getFileId, mediaFileEntity.getFileId())
|
.set(MediaFileEntity::getFileName, mediaFileEntity.getFileName())
|
.set(MediaFileEntity::getCollectStatus,mediaFileEntity.getCollectStatus())
|
.set(MediaFileEntity::getUserId,mediaFileEntity.getUserId())
|
.update();
|
// int update = mapper.update(mediaFileEntity, Wrappers.update(params));
|
return update1;
|
}
|
|
/**
|
* Convert the received file object into a database entity object.
|
* @param file
|
* @return
|
*/
|
private MediaFileEntity fileUploadConvertToEntity(FileUploadDTO file) {
|
MediaFileEntity.MediaFileEntityBuilder builder = MediaFileEntity.builder();
|
|
if (file != null) {
|
builder.fileName(file.getName())
|
.filePath(file.getPath())
|
.isadd(0)
|
.fingerprint(file.getFingerprint())
|
.objectKey(file.getObjectKey())
|
.subFileType(file.getSubFileType())
|
.isOriginal(file.getExt().getIsOriginal())
|
.jobId(file.getExt().getFlightId())
|
.drone(file.getExt().getSn()).metadata(file.getMetadata())
|
.tinnyFingerprint(file.getExt().getTinnyFingerprint());
|
|
// domain-type-subType
|
int[] payloadModel = Arrays.stream(file.getExt().getPayloadModelKey().split("-"))
|
.map(Integer::valueOf)
|
.mapToInt(Integer::intValue)
|
.toArray();
|
Optional<DeviceDictionaryDTO> payloadDict = deviceDictionaryService
|
.getOneDictionaryInfoByTypeSubType(DeviceDomainEnum.PAYLOAD.getVal(), payloadModel[1], payloadModel[2]);
|
payloadDict.ifPresent(payload -> builder.payload(payload.getDeviceName()));
|
}
|
return builder.build();
|
}
|
|
/**
|
* Convert database entity objects into file data transfer object.
|
* @param entity
|
* @return
|
*/
|
private MediaFileDTO entityConvertToDto(MediaFileEntity entity) {
|
MediaFileDTO.MediaFileDTOBuilder builder = MediaFileDTO.builder();
|
|
if (entity != null) {
|
builder.fileName(entity.getFileName())
|
.fileId(entity.getFileId())
|
.filePath(entity.getFilePath())
|
.isOriginal(entity.getIsOriginal())
|
.fingerprint(entity.getFingerprint())
|
.objectKey(entity.getObjectKey())
|
.tinnyFingerprint(entity.getTinnyFingerprint())
|
.payload(entity.getPayload())
|
.metadata(entity.getMetadata())
|
.createTime(LocalDateTime.ofInstant(
|
Instant.ofEpochMilli(entity.getCreateTime()), ZoneId.systemDefault()))
|
.drone(entity.getDrone())
|
.jobId(entity.getJobId());
|
|
}
|
|
return builder.build();
|
}
|
|
}
|
