From 5b0fbf34e8e9a59be474e7994a508d6be321d59a Mon Sep 17 00:00:00 2001
From: xiangpei <xiangpei@timesnew.cn>
Date: 星期四, 27 二月 2025 17:44:05 +0800
Subject: [PATCH] 在库项目查询bug
---
business/src/main/resources/mapper/ProjectInfoMapper.xml | 9 +++++----
1 files changed, 5 insertions(+), 4 deletions(-)
diff --git a/business/src/main/resources/mapper/ProjectInfoMapper.xml b/business/src/main/resources/mapper/ProjectInfoMapper.xml
index 2b37ad7..4739f1e 100644
--- a/business/src/main/resources/mapper/ProjectInfoMapper.xml
+++ b/business/src/main/resources/mapper/ProjectInfoMapper.xml
@@ -164,12 +164,13 @@
<!-- <if test="query.reserveOrPrevious != null and query.reserveOrPrevious == 'previous'">-->
<!-- and TPP.process_ins_id is not null-->
<!-- </if>-->
- <if test="query.projectPhase == 3">
- and (TPI.project_status = 'working' or TPI.project_status = 'stop')
- </if>
+<!-- <if test="query.projectPhase == 3">-->
+<!-- and (TPI.project_status = 'working' or TPI.project_status = 'stop')-->
+<!-- </if>-->
+ /* 涓虹┖琛ㄧず鍦ㄥ簱椤圭洰 */
<if test="query.projectPhase == null">
<if test="query.role != null and query.role == 1">
- and TPI.used_status = 1 and FIND_IN_SET(#{query.competentDepartment}, TPI.competent_department) > 0
+ and TPI.competent_department = #{query.competentDepartment}
</if>
</if>
<!-- 涓氫富鏁版嵁鏉冮檺 -->
--
Gitblit v1.8.0