| | |
| | | |
| | | <!--查询社区信息--> |
| | | <select id="getAllDoorplateAddress" resultType="org.springblade.modules.doorplateAddress.entity.DoorplateAddressEntity"> |
| | | select * from jczz_doorplate_address where nei_name = #{name} |
| | | select * from jczz_doorplate_address |
| | | where 1=1 |
| | | <if test="name!=null and name!=''"> |
| | | and nei_name = #{name} |
| | | </if> |
| | | </select> |
| | | |
| | | <!--获取房屋树--> |
| | |
| | | @Transactional(rollbackFor = Exception.class) |
| | | public Object spatialAnalysis() { |
| | | // 按社区 |
| | | String name = "万达社区居民委员会"; |
| | | String name = null; |
| | | // String name = "茶山路社区居民委员会"; |
| | | //查询社区信息 |
| | | List<DoorplateAddressEntity> doorplateAddressEntities = doorplateAddressService.getAllDoorplateAddress(name); |
| | |
| | | */ |
| | | @ApiModelProperty(value = "确认意见") |
| | | private String confirmNotion; |
| | | /** |
| | | * 经度 |
| | | */ |
| | | @ApiModelProperty(value = "经度") |
| | | private String lng; |
| | | /** |
| | | * 纬度 |
| | | */ |
| | | @ApiModelProperty(value = "纬度") |
| | | private String lat; |
| | | /** |
| | | * 事发地地址 |
| | | */ |
| | | @ApiModelProperty(value = "事发地地址") |
| | | private String address; |
| | | } |