From 9daa04779f76b91a4d806bef88c19d13637d1c58 Mon Sep 17 00:00:00 2001
From: xiangpei <xiangpei@timesnew.cn>
Date: 星期二, 21 一月 2025 15:02:50 +0800
Subject: [PATCH] 项目被删除、所有关联数据不查询
---
business/src/main/java/com/ycl/service/impl/ProjectProcessServiceImpl.java | 5 +++++
business/src/main/resources/mapper/ProjectPlanExamineRecordMapper.xml | 2 +-
2 files changed, 6 insertions(+), 1 deletions(-)
diff --git a/business/src/main/java/com/ycl/service/impl/ProjectProcessServiceImpl.java b/business/src/main/java/com/ycl/service/impl/ProjectProcessServiceImpl.java
index d7beadb..f00ba94 100644
--- a/business/src/main/java/com/ycl/service/impl/ProjectProcessServiceImpl.java
+++ b/business/src/main/java/com/ycl/service/impl/ProjectProcessServiceImpl.java
@@ -305,6 +305,8 @@
if (Objects.nonNull(project)) {
taskVO.setProjectId(project.getId());
taskVO.setProjectName(project.getProjectName());
+ } else {
+ continue;
}
// 娴佺▼鍙戣捣浜轰俊鎭�
@@ -364,6 +366,9 @@
taskVO.setHandlerUnitName(handlerUnitNames);
vos.add(taskVO);
}
+ if (vos.size() < pageSize) {
+ result.total(vos.size());
+ }
result.put("taskList", vos);
}
diff --git a/business/src/main/resources/mapper/ProjectPlanExamineRecordMapper.xml b/business/src/main/resources/mapper/ProjectPlanExamineRecordMapper.xml
index 414d5e7..0490ee3 100644
--- a/business/src/main/resources/mapper/ProjectPlanExamineRecordMapper.xml
+++ b/business/src/main/resources/mapper/ProjectPlanExamineRecordMapper.xml
@@ -189,7 +189,7 @@
from t_project_plan_examine_record ppe
LEFT JOIN t_project_plan_info ppi on ppe.project_plan_info_id = ppi.id
LEFT JOIN t_project_plan_record ppr on ppe.project_plan_record_id = ppr.id
- LEFT JOIN t_project_info pi on ppr.project_info_id = pi.id
+ INNER JOIN t_project_info pi on ppr.project_info_id = pi.id AND pi.deleted = 0
WHERE ppe.department_user_id = #{userId} or manager_user_id = #{userId}
</select>
--
Gitblit v1.8.0