短信指定楼栋发送

linwe

2024-08-09 8b7258c9427882bb1798f1502eaa35184c6e374e

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

@@ -16,15 +16,16 @@
 */
package org.springblade.modules.house.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import org.apache.ibatis.annotations.MapKey;
import org.apache.ibatis.annotations.Param;
import org.springblade.modules.house.entity.HouseEntity;
import org.springblade.modules.house.excel.HouseExcel;
import org.springblade.modules.house.vo.HouseParam;
import org.springblade.modules.house.vo.HouseTree;
import org.springblade.modules.house.vo.HouseVO;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import org.springblade.modules.house.excel.HouseExcel;
import org.springblade.modules.label.vo.LabelVO;

import java.util.List;
import java.util.Map;
@@ -44,17 +45,23 @@
    * @param house
    * @return
    */
   List<HouseVO> selectHousePage(IPage page, HouseVO house);
   List<HouseVO> selectHousePage(IPage page,
                          @Param("house") HouseVO house,
                          @Param("regionChildCodesList") List<String> regionChildCodesList,
                          @Param("gridCodeList") List<String> gridCodeList,
                          @Param("isAdministrator") Integer isAdministrator);

   /**
    * 房屋自定义详情查询
    *
    * @param house
    * @return
    */
    HouseVO getHouseDetail(@Param("house") HouseVO house);
   HouseVO getHouseDetail(@Param("house") HouseVO house);

   /**
    * 导出房屋数据
    *
    * @param house
    * @return
    */
@@ -62,16 +69,104 @@

   /**
    * 查询房屋树
    *
    * @param houseParam
    * @param list
    * @return
    */
   @MapKey(value = "code")
    Map<String, HouseTree> getHouseTree(@Param("houseParam") HouseParam houseParam,
   Map<String, HouseTree> getHouseTree(@Param("houseParam") HouseParam houseParam,
                              @Param("list") List<String> list);

    Integer getHouseStatisticsOne(String code, Long userId);
    Integer getHouseStatisticsTwo(String code, Long userId);
    Integer getHouseStatisticsThree(String code, Long userId);
    Integer getHouseStatisticsFour(String code, Long userId);
   Integer getHouseStatisticsOne(List<String> communityCodeList, 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(List<String> communityCodeList, 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);

   List<String> getHouseUnit(String districtCode, String building);

   @MapKey("id")
   List<Map<String, Object>>  labelStatistics(@Param("house") HouseVO house,
                                    @Param("regionChildCodesList") List<String> regionChildCodesList,
                                    @Param("isAdministrator") Integer isAdministrator);

   @MapKey("id")
   List<Map<String, Object>>  labelCommunityStatistics(@Param("house") HouseVO house,
                                          @Param("regionChildCodesList") List<String> regionChildCodesList);

   List<LabelVO> getlabelCount(@Param("house") HouseVO house,
                        @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);
}