主管部门sqlbug

fuliqi

2025-02-11 f7a2b2f9f3ae8e13ed9e7d7265bb234b30d142ca

主管部门sqlbug

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