短信指定楼栋发送

linwe

2024-08-09 8b7258c9427882bb1798f1502eaa35184c6e374e

 src/main/java/org/springblade/modules/house/mapper/HouseMapper.java

@@ -48,6 +48,7 @@
   List<HouseVO> selectHousePage(IPage page,
                          @Param("house") HouseVO house,
                          @Param("regionChildCodesList") List<String> regionChildCodesList,
                          @Param("gridCodeList") List<String> gridCodeList,
                          @Param("isAdministrator") Integer isAdministrator);

   /**
@@ -77,13 +78,20 @@
   Map<String, HouseTree> getHouseTree(@Param("houseParam") HouseParam houseParam,
                              @Param("list") List<String> list);

   Integer getHouseStatisticsOne(String code, Long userId, String aoiCode, String buildingCode, String unitCode, String roleType);
   Integer getHouseStatisticsOne(List<String> communityCodeList, Long userId, String aoiCode, String buildingCode, String unitCode, String roleType);

   Integer getHouseStatisticsTwo(String code, Long userId, String aoiCode, String buildingCode, String unitCode, String roleType);
   Integer getHouseStatisticsTwo(@Param("communityCodeList") List<String> communityCodeList,
                          @Param("aoiCode") String aoiCode,
                          @Param("buildingCode") String buildingCode,
                          @Param("unitCode") String unitCode,
                          @Param("house") HouseVO house,
                          @Param("isAdministrator") Integer isAdministrator,
                          @Param("regionChildCodesList")List<String> regionChildCodesList,
                          @Param("gridCodeList")List<String> gridCodeList);

   Integer getHouseStatisticsThree(String code, Long userId, String aoiCode, String buildingCode, String unitCode, String roleType);
   Integer getHouseStatisticsThree(List<String> communityCodeList, Long userId, String aoiCode, String buildingCode, String unitCode, String roleType);

   Integer getHouseStatisticsFour(String code, Long userId, String aoiCode, String buildingCode, String unitCode, String roleType);
   Integer getHouseStatisticsFour(List<String> communityCodeList, Long userId, String aoiCode, String buildingCode, String unitCode, String roleType);

   List<String> getHouseBuilding(String districtCode);

@@ -102,4 +110,63 @@
                        @Param("regionChildCodesList") List<String> regionChildCodesList,
                        @Param("isAdministrator") Integer isAdministrator,
                        @Param("streetCode") String streetCode);

   /**
    * 查询未绑定网格或警格的数据
    * @param type 1:网格  2：警格
    * @return
    */
   List<HouseEntity> getNotBindGridOrJwGridList(@Param("type") Integer type);

   /**
    * 按房屋标签统计
    * @param house
    * @param regionChildCodesList
    * @return
    */
   List<Map<String, Object>> getHouseLabelStatistic(@Param("house") HouseVO house,
                                        @Param("communityCodeList")List<String> regionChildCodesList);

   /**
    * 查询对应的社区编号
    * @param id
    * @return
    */
    String getCommunityCode(@Param("id") Long id);

   /**
    * 查询所有房屋总数
    * @return
    */
   int getAllListTotal();

   /**
    * 查询所有的房屋
    * @param i
    * @param size
    * @return
    */
   List<HouseVO> getAllList(@Param("i") int i,@Param("size") int size);

   /**
    * 查询无房屋状态的房屋数量
    * @param house
    * @return
    */
    int getNotBindLabelHouseNum(HouseVO house);

   /**
    * 查询无房屋状态的房屋列表集合
    * @param i
    * @param size
    * @return
    */
   List<HouseVO> getNotBindLabelHouseList(@Param("i") int i,@Param("size")  int size);

   /**
    *
    * @param aoiCodeList
    * @return
    */
   Map<String, Object> getHoseTotalAndAreaTotalByDistrictCode(List<String> aoiCodeList);
}