bug 修复

linwei

2024-02-18 c1cb1198cd331fa949fc10fb7bd5c7093f47e61b

bug 修复

 src/main/java/org/springblade/modules/house/mapper/UserHouseLabelMapper.xml

@@ -193,7 +193,7 @@
            `blade_region` br
        WHERE
            br.region_level = 4
            AND br.city_code = 361100000000
            AND br.city_code = 361100
    </select>



 src/main/java/org/springblade/modules/place/mapper/PlaceMapper.xml

@@ -480,7 +480,7 @@
        jpe.confirm_flag confirmFlag,
        bus.`name` AS policeName,
        bus.phone AS policePhone,
        jp.location addressName,
        jp.location as addressName,
        jpag.pcs_name deptName
        from jczz_place jp
        left join jczz_grid jg on jg.grid_code = jp.grid_code and jg.is_deleted = 0
@@ -519,18 +519,20 @@
        <if test="place.policeName!=null and place.policeName!=''">
            and bus.name like concat('%',#{place.policeName},'%')
        </if>

        <if test="nineTypeList!=null and nineTypeList.size()>0">
            and jp.nine_type in
            <foreach collection="nineTypeList" separator="," open="(" close=")" item="nineType">
                #{nineType}
            </foreach>
        </if>

        <if test="place.isFront!=null and place.isFront!=''">
            and jp.is_front = #{place.isFront}
        </if>

        <if test="place.frontType!=null and place.frontType!=''">
            and jp.front_type = #{place.frontType}
        </if>

        <if test="place.neiName!=null and place.neiName!=''">
            and br.name like concat('%',#{place.neiName},'%')
        </if>

 src/main/java/org/springblade/modules/place/service/impl/PlaceServiceImpl.java

@@ -1236,7 +1236,6 @@

    @Override
    public List<NinePlaceExcel> export(PlaceVO place) {
        place.setIsNine(1);
        String roleName = SpringUtils.getRequestParam("roleName");
        String communityCode = SpringUtils.getRequestParam("communityCode");
        if (!Strings.isBlank(communityCode)){