主管部门sqlbug

fuliqi

2025-02-11 be8f5982d0a2ccfc2880a3356e9cfe816affe9ef

主管部门sqlbug

 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}-->