通过E呼即办数据统计

linwe

2024-05-29 c10d6358b9f014375a13821465bc978d0c0da22e

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

@@ -55,19 +55,19 @@
    * @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);

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