Merge remote-tracking branch 'origin/master'
| | |
| | | if (list.size()>0) { |
| | | // 将场所数据保存到场所表中 |
| | | for (DoorplateAddressEntity addressEntity : list) { |
| | | // pio 名称不为空的进行插入操作 |
| | | if (!Strings.isBlank(addressEntity.getPoi())) { |
| | | PlaceEntity placeEntity = new PlaceEntity(); |
| | | placeEntity.setHouseCode(addressEntity.getAddressCode()); |
| | | placeEntity.setPlaceName(addressEntity.getPoi()); |
| | |
| | | // 加入集合 |
| | | placeList.add(placeEntity); |
| | | } |
| | | } |
| | | // 批量插入 |
| | | placeService.saveBatch(placeList); |
| | | } |
| | |
| | | |
| | | <!--查询小区网格绑定--> |
| | | <select id="getGridListByAoiCode" resultType="org.springblade.modules.grid.vo.GridVO"> |
| | | SELECT jg.id,jg.grid_name from jczz_grid jg |
| | | SELECT jg.grid_name from jczz_grid jg |
| | | left join jczz_grid_range jgr on jg.id = jgr.grid_id |
| | | where jg.is_deleted = 0 |
| | | and jgr.district_code = #{aoiCode} |
| | | GROUP BY jg.id,jg.grid_name |
| | | GROUP BY jg.grid_name |
| | | </select> |
| | | |
| | | </mapper> |