/*
 *      Copyright (c) 2018-2028, Chill Zhuang All rights reserved.
 *
 *  Redistribution and use in source and binary forms, with or without
 *  modification, are permitted provided that the following conditions are met:
 *
 *  Redistributions of source code must retain the above copyright notice,
 *  this list of conditions and the following disclaimer.
 *  Redistributions in binary form must reproduce the above copyright
 *  notice, this list of conditions and the following disclaimer in the
 *  documentation and/or other materials provided with the distribution.
 *  Neither the name of the dreamlu.net developer nor the names of its
 *  contributors may be used to endorse or promote products derived from
 *  this software without specific prior written permission.
 *  Author: Chill 庄骞 (smallchill@163.com)
 */
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 org.springblade.modules.label.vo.LabelVO;

import java.util.List;
import java.util.Map;

/**
 * 房屋 Mapper 接口
 *
 * @author BladeX
 * @since 2023-10-28
 */
public interface HouseMapper extends BaseMapper<HouseEntity> {

	/**
	 * 自定义分页
	 *
	 * @param page
	 * @param house
	 * @return
	 */
	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);

	/**
	 * 导出房屋数据
	 *
	 * @param house
	 * @return
	 */
	List<HouseExcel> export(@Param("house") HouseVO house);

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

	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);
}