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