/*
 *      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.place.mapper;

import org.apache.ibatis.annotations.Param;
import org.springblade.common.node.TreeStringNode;
import org.springblade.modules.place.entity.PlaceEntity;
import org.springblade.modules.place.excel.ExportPlaceExcel;
import org.springblade.modules.place.excel.NinePlaceExcel;
import org.springblade.modules.place.excel.PlaceAndRelExcel;
import org.springblade.modules.place.vo.PlaceVO;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import java.util.List;
import java.util.Map;

/**
 * 场所表 Mapper 接口
 *
 * @author BladeX
 * @since 2023-10-28
 */
public interface PlaceMapper extends BaseMapper<PlaceEntity> {


	/**
	 * 自定义分页
	 *
	 * @param page
	 * @param place
	 * @param regionChildCodesList
	 * @param isAdministrator
	 * @return
	 */
	List<PlaceVO> selectPlacePage(IPage page,
								  @Param("place") PlaceVO place,
								  @Param("gridCodeList") List<String> gridCodeList,
								  @Param("regionChildCodesList") List<String> regionChildCodesList,
								  @Param("isAdministrator") Integer isAdministrator);

	/**
	 * 九小场所档案
	 *
	 * @param page
	 * @param place
	 * @param gridCodeList
	 * @param regionChildCodesList
	 * @param isAdministrator
	 * @param isAdministrator
	 * @return
	 */
	List<PlaceVO> selectNinePlacePage(IPage page,
									  @Param("place") PlaceVO place,
									  @Param("gridCodeList") List<String> gridCodeList,
									  @Param("regionChildCodesList") List<String> regionChildCodesList,
									  @Param("isAdministrator") Integer isAdministrator,
									  @Param("nineTypeList") List<String> nineTypeList);


	/**
	 * 查询场所集合信息
	 *
	 * @param userId
	 * @return
	 */
	List<TreeStringNode> selectPlaceNodeList(@Param("userId") String userId);

	/**
	 * 插入用户标签
	 *
	 * @param userId
	 * @param labelId
	 */
	int saveUserLabel(@Param("userId") Long userId, @Param("labelId") int labelId);

	/**
	 * 查询所有的场所（手机号不为空）
	 *
	 * @return
	 */
	List<PlaceVO> getPlaceNotNullPhone();

	/**
	 * 查询所有的场所
	 *
	 * @return
	 */
	List<PlaceVO> getAllHistoryPlace();

	/**
	 * 更新场所信息
	 *
	 * @param place
	 */
	int updatePlaceEntity(@Param("place") PlaceVO place);

	/**
	 * 查询场所详情数据
	 *
	 * @param place
	 * @return
	 */
	PlaceVO getDetail(@Param("place") PlaceEntity place);

	/**
	 * 判断商超是否导入
	 *
	 * @param placeExcel
	 * @return
	 */
	PlaceEntity getPlaceAndRelInfo(@Param("place") PlaceAndRelExcel placeExcel);

	/**
	 * 查询出有用户id 的场所
	 *
	 * @return
	 */
	List<PlaceEntity> getHasUserIdPlaceList();

	/**
	 * 查询所有的场所数据（除去详情表已有的）
	 *
	 * @return
	 */
	List<PlaceEntity> getPlaceListByNoExt();

	/**
	 * 商超数据处理
	 *
	 * @return
	 */
	List<PlaceEntity> placeAndRelHandle();

	/**
	 * 根据编号集合查询对应的场所（按颜色区分近多少天没有发过任务的场所）4部分数据（三种颜色对应的+从来没有发过的）
	 *
	 * @param stringList
	 * @param tableName
	 * @return
	 */
	List<PlaceVO> getPlaceListByParam(@Param("list") List<String> stringList,
									  @Param("tableName") String tableName);

	List<NinePlaceExcel> export(@Param("place") PlaceVO place,
								@Param("houseCodeList") List<String> houseCodeList,
								@Param("regionChildCodesList") List<String> regionChildCodesList,
								@Param("isAdministrator") Integer isAdministrator,
								@Param("nineTypeList") List<String> nineTypeList);

	/**
	 * 查询 警务网格为空的数据
	 *
	 * @return
	 */
	List<PlaceEntity> getPlaceNotJwGridCode();

	/**
	 * 比对两点间的距离是否在1km 范围内(和地址总表位置对比)
	 *
	 * @param placeVO
	 * @return
	 */
	Integer comparisonPosition(@Param("place") PlaceVO placeVO);

	/**
	 * 比对两点间的距离是否在1km 范围内 (和采集的位置对比)
	 *
	 * @param placeVO
	 * @return
	 */
	Boolean comparisonPositionNotHouseCode(@Param("place") PlaceVO placeVO);

	/**
	 * 查询 综治网格为空的数据
	 *
	 * @return
	 */
	List<PlaceEntity> getPlaceNotGridCode();

	/**
	 * 查询对应未的场所 house_code_binds 为空，source = 1 的
	 *
	 * @return
	 */
	List<PlaceEntity> selectPlaceNotDoorBindList();

	/**
	 * 查询绑定的房屋
	 *
	 * @param houseCodeBinds
	 * @return
	 */
	List<Map<String, Object>> getHouseBindMap(@Param("houseCodeBinds") String houseCodeBinds);

	/**
	 * 企业商超列表查询
	 */
	List<PlaceVO> selectMallPage(IPage page,
								 @Param("place") PlaceVO place,
								 @Param("gridCodeList") List<String> gridCodeList,
								 @Param("regionChildCodesList") List<String> regionChildCodesList,
								 @Param("isAdministrator") Integer isAdministrator);

	/**
	 * 查询所有场所数据
	 * @return
	 */
    List<PlaceVO> getAllList(@Param("i") int i,@Param("size") int size);

	/**
	 * 查询所有场所数据总数
	 * @return
	 */
	int getAllListTotal();

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

	/**
	 * 导出场所信息
	 * @param place
	 * @return
	 */
    List<ExportPlaceExcel> exportPlaceList(@Param("place") PlaceVO place,
										   @Param("gridCodeList") List<String> gridCodeList,
										   @Param("regionChildCodesList") List<String> regionChildCodesList,
										   @Param("isAdministrator") Integer isAdministrator);

	/**
	 * 查询附近场所
	 * @param lat
	 * @param lng
	 * @return
	 */
	List<PlaceVO> getNearbyPlaceList(String lat, String lng);
}