linwe
2023-12-23 55d677758efadb6d42e6d4e595cecc2c50c20d5a
src/main/java/org/springblade/modules/grid/mapper/GridMapper.java
@@ -16,12 +16,19 @@
 */
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 接口
@@ -40,5 +47,67 @@
    */
   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);
}