From f7a2b2f9f3ae8e13ed9e7d7265bb234b30d142ca Mon Sep 17 00:00:00 2001
From: fuliqi <fuliqi@qq.com>
Date: 星期二, 11 二月 2025 17:46:52 +0800
Subject: [PATCH] 主管部门sqlbug
---
business/src/main/resources/mapper/ProjectInfoMapper.xml | 3 ++-
1 files changed, 2 insertions(+), 1 deletions(-)
diff --git a/business/src/main/resources/mapper/ProjectInfoMapper.xml b/business/src/main/resources/mapper/ProjectInfoMapper.xml
index 365761b..3b9cdd2 100644
--- a/business/src/main/resources/mapper/ProjectInfoMapper.xml
+++ b/business/src/main/resources/mapper/ProjectInfoMapper.xml
@@ -167,7 +167,8 @@
<!-- and TPI.used_status != 2-->
<!-- </if>-->
<if test="query.role == 1">
- and TPI.used_status = 1 and TPI.competent_department like concat('%',#{query.competentDepartment},'%')
+ and TPI.used_status = 1 and FIND_IN_SET(#{query.competentDepartment}, TPI.competent_department) > 0;
+
</if>
</if>
<!--${query.params.dataScope}-->
--
Gitblit v1.8.0