代码优化

lin

2024-03-29 4c3ebf5a834652d50b862cd4a95f92a50421bc16

代码优化

 src/main/java/org/springblade/modules/doorplateAddress/mapper/DoorplateAddressMapper.xml

@@ -129,18 +129,18 @@
                <when test="houseParam.roleName=='民警' and houseParam.userId!='1726859808689696770'">
                    <choose>
                        <when test="communityList != null and communityList.size()>0">
                            and br.code in
                            and jpag.jw_grid_code in
                            <foreach collection="communityList" item="code" separator ="," open="("  close=")">
                                #{code}
                            </foreach>
                        </when>
                        <otherwise>
                            and br.code in ('')
                            and jpag.jw_grid_code in ('')
                        </otherwise>
                    </choose>
                </when>
                <otherwise>
                    and br.code in ('')
                    and jpag.jw_grid_code in ('')
                </otherwise>
            </choose>
        </if>