| | |
| | | */ |
| | | package org.springblade.modules.grid.mapper; |
| | | |
| | | import org.apache.ibatis.annotations.MapKey; |
| | | import org.apache.ibatis.annotations.Param; |
| | | import org.springblade.common.node.TreeStringNode; |
| | | import org.springblade.modules.doorplateAddress.entity.DoorplateAddressEntity; |
| | | import org.springblade.modules.grid.entity.GridEntity; |
| | | import org.springblade.modules.grid.entity.GridmanEntity; |
| | | import org.springblade.modules.grid.vo.GridVO; |
| | | import com.baomidou.mybatisplus.core.mapper.BaseMapper; |
| | | import com.baomidou.mybatisplus.core.metadata.IPage; |
| | | import org.springblade.modules.place.vo.PlaceVO; |
| | | |
| | | import java.util.List; |
| | | import java.util.Map; |
| | | |
| | | /** |
| | | * 网格表 Mapper 接口 |
| | |
| | | */ |
| | | List<GridVO> selectGridPage(IPage page,@Param("grid") GridVO grid); |
| | | |
| | | /** |
| | | * 根据地址编号查询网格数据 |
| | | * @param houseCode |
| | | * @return |
| | | */ |
| | | GridVO getGridDetailByHouseCode(@Param("houseCode") String houseCode); |
| | | |
| | | /** |
| | | * 根据用户id(网格员)查询对应的房屋地址code |
| | | * @param userId |
| | | * @return |
| | | */ |
| | | List<String> getAddressCodeListByUserId(@Param("userId") Long userId); |
| | | |
| | | /** |
| | | * 空间分析 mysql 5.7 点落面 |
| | | */ |
| | | GridEntity spatialAnalysis(@Param("point")String point); |
| | | |
| | | /** |
| | | * 根据参数查询网格数据 |
| | | * @param place |
| | | * @return |
| | | */ |
| | | GridVO getGridDetailByParam(@Param("place") PlaceVO place); |
| | | |
| | | /** |
| | | * 网格表 自定义详情 |
| | | * @param grid |
| | | * @return |
| | | */ |
| | | GridVO getGridDetail(@Param("grid") GridVO grid); |
| | | |
| | | /** |
| | | * 查询所有 |
| | | * @return |
| | | */ |
| | | List<GridEntity> selectGridAll(); |
| | | |
| | | /** |
| | | * 网格树 |
| | | * @return |
| | | */ |
| | | @MapKey(value = "id") |
| | | Map<String, TreeStringNode> getGridTree(); |
| | | |
| | | List<GridmanEntity> gridInfo(String houseCode); |
| | | |
| | | List<DoorplateAddressEntity> gridAoiName(Integer id); |
| | | |
| | | /** |
| | | * 网格集合查询 |
| | | * @param grid |
| | | * @return |
| | | */ |
| | | List<GridEntity> getGridList(@Param("grid") GridVO grid); |
| | | |
| | | /** |
| | | * 查询小区网格绑定 |
| | | * @param aoiCode 小区aoiCode |
| | | * @return |
| | | */ |
| | | List<GridVO> getGridListByAoiCode(@Param("aoiCode") String aoiCode); |
| | | } |