消防检查优化

linwei

2024-02-03 b7df6735bcb2d447cae7fcfba2d12accf3dd2fcc

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

@@ -19,7 +19,9 @@
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;
@@ -43,14 +45,17 @@
    * @param grid
    * @return
    */
   List<GridVO> selectGridPage(IPage page,@Param("grid") GridVO grid);
   List<GridVO> selectGridPage(IPage page,
                        @Param("grid") GridVO grid,
                        @Param("regionChildCodesList") List<String> regionChildCodesList,
                        @Param("isAdministrator") Integer isAdministrator);

   /**
    * 根据地址编号查询网格数据
    * @param houseCode
    * @return
    */
    GridVO getGridDetailByHouseCode(@Param("houseCode") String houseCode);
    GridVO getPlaceGridDetailByHouseCode(@Param("houseCode") String houseCode);

   /**
    * 根据用户id(网格员)查询对应的房屋地址code
@@ -62,7 +67,7 @@
   /**
    * 空间分析 mysql 5.7  点落面
    */
   GridEntity spatialAnalysis(@Param("point")String point);
   List<GridEntity> spatialAnalysis(@Param("point")String point);

   /**
    * 根据参数查询网格数据
@@ -90,4 +95,38 @@
    */
   @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);
}