/*
|
* Copyright (c) 2018-2028, Chill Zhuang All rights reserved.
|
*
|
* Redistribution and use in source and binary forms, with or without
|
* modification, are permitted provided that the following conditions are met:
|
*
|
* Redistributions of source code must retain the above copyright notice,
|
* this list of conditions and the following disclaimer.
|
* Redistributions in binary form must reproduce the above copyright
|
* notice, this list of conditions and the following disclaimer in the
|
* documentation and/or other materials provided with the distribution.
|
* Neither the name of the dreamlu.net developer nor the names of its
|
* contributors may be used to endorse or promote products derived from
|
* this software without specific prior written permission.
|
* Author: Chill 庄骞 (smallchill@163.com)
|
*/
|
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 接口
|
*
|
* @author BladeX
|
* @since 2023-10-28
|
*/
|
public interface GridMapper extends BaseMapper<GridEntity> {
|
|
/**
|
* 自定义分页
|
*
|
* @param page
|
* @param grid
|
* @return
|
*/
|
List<GridVO> selectGridPage(IPage page,
|
@Param("grid") GridVO grid,
|
@Param("regionChildCodesList") List<String> regionChildCodesList,
|
@Param("isAdministrator") Integer isAdministrator);
|
|
/**
|
* 根据地址编号查询网格数据
|
* @param houseCode
|
* @return
|
*/
|
GridVO getPlaceGridDetailByHouseCode(@Param("houseCode") String houseCode);
|
|
/**
|
* 根据用户id(网格员)查询对应的房屋地址code
|
* @param userId
|
* @return
|
*/
|
List<String> getAddressCodeListByUserId(@Param("userId") Long userId,@Param("addressCode") String addressCode);
|
|
/**
|
* 空间分析 mysql 5.7 点落面
|
*/
|
List<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);
|
|
/**
|
* 查询对应网格人对应的网格
|
* @param userId
|
* @return
|
*/
|
GridEntity getGridByUserId(@Param("userId") Long userId);
|
|
/**
|
* 根据网格名称，社区名称查询对应的网格
|
* @param gridName
|
* @param communityName
|
* @return
|
*/
|
GridEntity getGridByNames(@Param("gridName") String gridName,
|
@Param("communityName") String communityName);
|
|
/**
|
* 查询用户对应的网格
|
* @param userId
|
* @return
|
*/
|
List<String> getGridListByUserId(@Param("userId") String userId);
|
|
/**
|
* 查询对应的房屋地址code(更加网格编号集合）
|
* @param gridCodeList
|
* @return
|
*/
|
List<String> getAddressCodeListByGridCodeList(@Param("communityCode")String communityCode,@Param("gridCodeList")List<String> gridCodeList);
|
|
/**
|
* 根据社区编号及网格编号集合查询对应的网格信息
|
* @param communityCode
|
* @param gridCodeList
|
* @return
|
*/
|
List<GridVO> getGridListByComAndList(@Param("communityCode")String communityCode,
|
@Param("gridCodeList") List<String> gridCodeList);
|
|
/**
|
* 根据社区名称和网格名称查询对应的网格信息
|
* @param communityName
|
* @param gridName
|
* @return
|
*/
|
GridEntity getGridInfoByParam(@Param("communityName")String communityName,@Param("gridName") String gridName);
|
}
|
