From f01980c0d93183ca28b687455983708596a1ad3e Mon Sep 17 00:00:00 2001
From: gongchunyi <deslre0381@gmail.com>
Date: 星期二, 03 二月 2026 15:49:04 +0800
Subject: [PATCH] fix: 会议室被占用不能被删除

---
 src/main/java/com/ruoyi/collaborativeApproval/service/impl/MeetingServiceImpl.java |   32 +++++++++++++++++++++++++-------
 1 files changed, 25 insertions(+), 7 deletions(-)

diff --git a/src/main/java/com/ruoyi/collaborativeApproval/service/impl/MeetingServiceImpl.java b/src/main/java/com/ruoyi/collaborativeApproval/service/impl/MeetingServiceImpl.java
index bef5926..e5c05ed 100644
--- a/src/main/java/com/ruoyi/collaborativeApproval/service/impl/MeetingServiceImpl.java
+++ b/src/main/java/com/ruoyi/collaborativeApproval/service/impl/MeetingServiceImpl.java
@@ -25,16 +25,19 @@
 import com.ruoyi.collaborativeApproval.vo.SearchMeetingDraftVo;
 import com.ruoyi.collaborativeApproval.vo.SearchMeetingRoomVo;
 import com.ruoyi.collaborativeApproval.vo.SearchMeetingUseVo;
+import com.ruoyi.common.exception.ServiceException;
 import com.ruoyi.common.utils.SecurityUtils;
 import com.ruoyi.framework.web.domain.R;
 import com.ruoyi.project.system.domain.SysUser;
 import com.ruoyi.project.system.mapper.SysUserMapper;
 import com.ruoyi.project.system.service.ISysNoticeService;
-import com.ruoyi.staff.mapper.StaffJoinLeaveRecordMapper;
-import com.ruoyi.staff.pojo.StaffJoinLeaveRecord;
+import com.ruoyi.staff.mapper.StaffOnJobMapper;
+import com.ruoyi.staff.pojo.StaffOnJob;
 import lombok.RequiredArgsConstructor;
 import org.springframework.stereotype.Service;
+import org.springframework.transaction.annotation.Transactional;
 
+import java.time.LocalDateTime;
 import java.time.format.DateTimeFormatter;
 import java.util.*;
 import java.util.stream.Collectors;
@@ -48,11 +51,12 @@
     private final MeetDraftMapper meetDraftMapper;
 
     private final MeetApplicationMapper meetApplicationMapper;
-    private final StaffJoinLeaveRecordMapper staffJoinLeaveRecordMapper;
+    private final StaffOnJobMapper staffOnJobMapper;
 
     private final MeetingMinutesMapper meetingMinutesMapper;
     private final SysUserMapper userMapper;
     private final ISysNoticeService sysNoticeService;
+
 
     @Override
     public IPage<MeetingRoom> getMeetingRoomList(SearchMeetingRoomVo vo) {
@@ -82,7 +86,22 @@
     }
 
     @Override
+    @Transactional(rollbackFor = Exception.class)
     public void deleteMeetingRoom(Long id) {
+        if (id == null){
+            throw new ServiceException("鍒犻櫎浼氳瀹ゅけ璐�,浼氳瀹D涓嶈兘涓虹┖");
+        }
+
+        LocalDateTime now = LocalDateTime.now();
+        List<MeetApplication> meetApplicationList = meetApplicationMapper.selectList(Wrappers.<MeetApplication>lambdaQuery()
+                .eq(MeetApplication::getRoomId, id)
+                .gt(MeetApplication::getEndTime, now)
+                .in(MeetApplication::getStatus, Arrays.asList(0, 1)));
+
+        if (!meetApplicationList.isEmpty()){
+            throw new ServiceException("鍒犻櫎浼氳瀹ゅけ璐�,璇ヤ細璁灏氭湁鏈紑濮嬫垨杩涜涓殑鏈夋晥浼氳棰勭害");
+        }
+
         meetingRoomMapper.deleteById(id);
     }
 
@@ -165,7 +184,7 @@
                     .filter(s -> !s.isEmpty())
                     .map(Long::valueOf)
                     .map(staffId -> {
-                        StaffJoinLeaveRecord record = staffJoinLeaveRecordMapper.selectById(staffId);
+                        StaffOnJob record = staffOnJobMapper.selectById(staffId);
                         if (record == null) {
                             return null;
                         }
@@ -181,11 +200,10 @@
             if (!userIds.isEmpty()) {
                 sysNoticeService.simpleNoticeByUser(
                         "浼氳閫氱煡",
-                        "浼氳涓婚锛�" + application.getTitle() + "\n" +
-                                "浼氳鏃堕棿锛�" + application.getStartTime() + "-" + application.getEndTime() + "\n" +
+                        "浼氳涓婚锛�" + application.getTitle() + "\t" +
+                                "浼氳鏃堕棿锛�" + application.getStartTime() + "-" + application.getEndTime() + "\t" +
                                 "鍙戣捣浜猴細" + application.getApplicant(),
                         userIds,
-                        application.getTenantId(),
                         ""
                 );
             }

--
Gitblit v1.9.3