From 98c8e73c57f8f76e5720a066f155ebfff2a7cc5f Mon Sep 17 00:00:00 2001
From: rain <167982779@qq.com>
Date: Thu, 18 Apr 2024 20:05:48 +0800
Subject: [PATCH] 修改DB成果展示入库失败,增加TbfjEntity表的字段,无对应字段默认0.

---
 src/main/java/com/dji/sample/media/service/impl/FileServiceImpl.java |    9 ++++++++-
 1 files changed, 8 insertions(+), 1 deletions(-)

diff --git a/src/main/java/com/dji/sample/media/service/impl/FileServiceImpl.java b/src/main/java/com/dji/sample/media/service/impl/FileServiceImpl.java
index 77272e0..c7a4fb8 100644
--- a/src/main/java/com/dji/sample/media/service/impl/FileServiceImpl.java
+++ b/src/main/java/com/dji/sample/media/service/impl/FileServiceImpl.java
@@ -103,13 +103,20 @@
 //                        .eq(MediaFileEntity::getWorkspaceId, workspaceId)
 //                        .orderByDesc(MediaFileEntity::getId));
         Page<MediaFileEntity> pageData = mapper.selectPage(new Page<MediaFileEntity>(page, pageSize), new LambdaQueryWrapper<MediaFileEntity>()
-                .eq(MediaFileEntity::getWorkspaceId,workspaceId));
+                .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);

--
Gitblit v1.9.3