短信指定楼栋发送

linwe

2024-08-09 8b7258c9427882bb1798f1502eaa35184c6e374e

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

@@ -16,14 +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,26 +45,29 @@
    * @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
    * @param userId
    * @return
    */
    List<String> getAddressCodeListByUserId(@Param("userId") Long userId);
    List<String> getAddressCodeListByUserId(@Param("userId") Long userId,@Param("addressCode") String addressCode);

   /**
    * 空间分析 mysql 5.7  点落面
    */
   GridEntity spatialAnalysis(@Param("point")String point);
   List<GridEntity> spatialAnalysis(@Param("point")String point);

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