报事报修网格员查询不出来

linwei

2024-02-20 648234ac152ecb00bf44fc6e867eb23c0590a712

报事报修网格员查询不出来

 src/main/java/org/springblade/modules/task/mapper/TaskReportForRepairsMapper.xml

@@ -210,29 +210,14 @@
        <if test="isAdministrator==2">
            <choose>
                <when test="regionChildCodesList !=null and regionChildCodesList.size()>0">
                    and jg.community_code in
                    and jg.grid_code in
                    <foreach collection="regionChildCodesList" item="code" open="(" close=")" separator=",">
                        #{code}
                    </foreach>
                </when>
            </choose>
        </if>
        <if test="vo.roleName!=null and vo.roleName!=''">
            <if test="vo.roleName=='网格员'">
                <choose>
                    <when test="list != null and list.size()>0">
                        and (jda.address_code in
                        <foreach collection="list" item="houseCode" separator="," open="(" close=")">
                            #{houseCode}
                        </foreach>
                        or jtrfr.confirm_user_id = #{vo.confirmUserId})
                    </when>
                    <otherwise>
                        and (jtrfr.confirm_user_id = #{vo.confirmUserId})
                    </otherwise>
                </choose>
            </if>
        </if>


        <if test="aoiCodeList!=null and aoiCodeList.size()>0">
            and jda.aoi_code in