xiangpei
2025-02-27 5b0fbf34e8e9a59be474e7994a508d6be321d59a
在库项目查询bug
1个文件已修改
9 ■■■■■ 已修改文件
business/src/main/resources/mapper/ProjectInfoMapper.xml 9 ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史
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>
            <!-- 业主数据权限 -->