场所详细查询返回绑定多个房屋的二维码编号和标准地址

zhongrj

2024-03-11 96bc2773501df383ffe5f0bf77073e7d109e43fa

场所详细查询返回绑定多个房屋的二维码编号和标准地址

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

@@ -575,6 +575,12 @@
        <if test="doorplateAddress.poi!=null and doorplateAddress.poi!=''">
            and jda.poi like concat('%',#{doorplateAddress.poi},'%')
        </if>
        <if test="doorplateAddress.addressCode!=null and doorplateAddress.addressCode!=''">
            and jda.address_code in
            <foreach collection="addressCode.split(',')" item="addressCode" open="(" close=")" separator=",">
                #{addressCode}
            </foreach>
        </if>
        <if test="isAdministrator==2">
            <choose>
                <when test="doorplateAddress.roleName != null and doorplateAddress.roleName != ''">

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

@@ -25,6 +25,7 @@
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import java.util.List;
import java.util.Map;

/**
 * 场所表 Mapper 接口
@@ -180,4 +181,11 @@
     * @return
     */
    List<PlaceEntity> selectPlaceNotDoorBindList();

    /**
     * 查询绑定的房屋
     * @param houseCodeBinds
     * @return
     */
    List<Map<String,Object>> getHouseBindMap(@Param("houseCodeBinds") String houseCodeBinds);
}

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

@@ -766,4 +766,13 @@
         and source = 1 and house_code_binds is null
    </select>

    <!--查询绑定的房屋-->
    <select id="getHouseBindMap" resultType="java.util.Map">
        select address_code as addressCode,address_name addressName from jczz_doorplate_address
        where address_code in
        <foreach collection="houseCodeBinds.split(',')" item="houseCode" separator="," open="(" close=")">
            #{houseCode}
        </foreach>
    </select>

</mapper>

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

@@ -852,6 +852,8 @@
                QueryWrapper<PlaceExtEntity> queryWrapper = new QueryWrapper<>();
                queryWrapper.eq("is_deleted", 0).eq("place_id", placeVO.getId());
                placeVO.setPlaceExtEntity(placeExtService.getOne(queryWrapper));
                // 查询绑定的房屋
                placeVO.setHouseBindList(baseMapper.getHouseBindMap(placeVO.getHouseCodeBinds()));
            }
        } else {
            // 查询地址编码信息（社区派出所相关信息）

 src/main/java/org/springblade/modules/place/vo/PlaceVO.java

@@ -28,7 +28,9 @@
import org.springblade.modules.place.entity.PlacePoiLabel;

import java.util.ArrayList;
import java.util.HashMap;
import java.util.List;
import java.util.Map;

/**
 * 场所表 视图实体类
@@ -156,4 +158,9 @@
     */
    private String roleName;

    /**
     * 房屋绑定
     */
    private List<Map<String,Object>> houseBindList = new ArrayList<>();

}