文章通过范围查询

linwe

2023-12-01 5d5cd3ad979a0b85ab8c7034dcad1663fdcf71be

 src/main/java/org/springblade/modules/grid/mapper/GridMapper.java

@@ -16,12 +16,17 @@
 */
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.grid.entity.GridEntity;
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 +45,49 @@
    */
   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();
}