business/src/main/resources/mapper/ProjectInfoMapper.xml

@@ -163,10 +163,6 @@
            <if test="query.projectCategory == 3">
                and (TPI.project_status = 'working' or TPI.project_status = 'stop')
            </if>
            <!-- 业主数据权限 -->
            <if test="query.role == 0">
                and TPI.project_owner_unit = #{query.projectOwnerUnit}
            </if>
            <if test="query.projectCategory == 6">
<!--                <if test="query.role == 0">-->
<!--                    and TPI.used_status != 2-->
@@ -175,7 +171,10 @@
                    and TPI.used_status = 1 and  FIND_IN_SET(#{query.competentDepartment}, TPI.competent_department) > 0
                </if>
            </if>
            <!--${query.params.dataScope}-->
            <!-- 业主数据权限 -->
            <if test="query.role == 0">
                ${query.params.dataScope}
            </if>
        </where>
        order by TPI.gmt_create
    </select>