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

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import org.apache.ibatis.annotations.Param;
import org.sxkj.resource.dto.WaylineJobInfoQueryParam;
import org.sxkj.resource.entity.Attach;
import org.sxkj.resource.param.AttachPageParam;
import org.sxkj.resource.vo.*;

import java.util.Date;
import java.util.List;

/**
 * 附件表 Mapper 接口
 *
 * @author Chill
 */
public interface AttachMapper extends BaseMapper<Attach> {

	/**
	 * 自定义分页
	 *
	 * @param page
	 * @param attach
	 * @return
	 */
	List<AttachVO> selectAttachPage(IPage page, @Param("attach") AttachPageParam attach);

	/**
	 * 自定义分页
	 *
	 * @param page
	 * @param attach
	 * @return
	 */
	List<AttachVO> findAiAttachImages(IPage page,
									  @Param("attach") AttachVO attach,
									  List<Long> deptIdList,
									  String permissionCondition);


	/**
	 * 事件状态
	 *
	 * @param page
	 * @param attach
	 * @return
	 */
	List<AttachVO> selectEventAttachPage(IPage page, @Param("attach") AttachVO attach);

	/**
	 * 获取ai生成前后的图片md5
	 *
	 * @param aiRecordIds 记录ids
	 * @return
	 */
	public List<EventImgMd5VO> findAllMd5ByAi(List<Long> aiRecordIds);

	/**
	 * 查询md5值
	 *
	 * @param aiRecordIds
	 * @return
	 */
	public List<String> findAiMd5s(List<Long> aiRecordIds);

	/**
	 * ai 图片
	 *
	 * @param page   分页
	 * @param attach 参数
	 * @return
	 */
	List<AttachVO> findAttachImages(IPage page,
									@Param("attach") AttachVO attach,
									List<Long> deptIdList,
									String permissionCondition,
									@Param("userId") Long userId);

	List<DeptAndSizeVo> getDeptAllSize(String startTime, String endTime);

	/**
	 * 判断附件是否已存在
	 *
	 * @param attach
	 * @return
	 */
	Integer getAttachNumberByParam(@Param("attach") Attach attach);

	/**
	 * 查询正射的图片信息
	 *
	 * @return
	 */
	List<Attach> getHisOrtPicList();

	/**
	 * 查询媒体属性根据图片，名称
	 *
	 * @param names
	 * @return
	 */
	public List<Attach> findMetaDataByName(@Param("names") List<String> names);

	/**
	 * 首页地图数据汇聚
	 *
	 * @param param
	 * @return
	 */
	public List<AttachStatisticsBo> mapAreaCodeAttachStatistics(AttachQueryParam param);

	/**
	 * 正射数据
	 *
	 * @param param
	 * @return
	 */
	public List<AttachStatisticsBo> mapAreaCodeZhenSheStatistics(AttachQueryParam param);

	/**
	 * 地图上点经纬度
	 *
	 * @param param 参数
	 * @return
	 */
	public List<AttachMapVo> mapAttachList(AttachQueryParam param);

	/**
	 * 查询同一个经纬度数据
	 *
	 * @param lat 1
	 * @param lng 1
	 * @return 经纬度数据
	 */
	public List<AnalysisAttachVo> findPointAttach(@Param("lat") Double lat, @Param("lng") Double lng,
												  @Param("beforeDate") Date beforeDate,
												  @Param("afterDate") Date afterDate, @Param("id") Long id);


	/**
	 * @param param
	 * @return
	 */
	List<AttachVO> getAttachList(AttachmentDownloadParam param);

	/**
	 * 获取附件信息
	 *
	 * @param id
	 * @return
	 */
	AttachInfoVO getAttachInfo(Long id);

	/**
	 * @param jobId
	 * @return
	 */
	List<AttachInfoVO> getAttachInfoByJobId(String jobId);

	/**
	 * @param attachStatisticsVo
	 * @return
	 */
	List<AttachTypeStatisticsVO> attachTypeStatistics(@Param("param") AttachStatisticsVo attachStatisticsVo,
													  List<Long> deptIdList,
													  String permissionCondition);

	/**
	 * 三维面积计算
	 * @param attachStatisticsVo
	 * @param deptIdList
	 * @param permissionCondition
	 * @return
	 */
	AttachTypeStatisticsVO calculateTheThreeDimensionalArea(@Param("param") AttachStatisticsVo attachStatisticsVo,
													  List<Long> deptIdList,
													  String permissionCondition);

	void deletedEventData(String md5);

	/**
	 * @param param
	 * @return
	 */
	List<AttachTypeStatisticsVO> getManageAttachTypeStatistics(WaylineJobInfoQueryParam param,
															   List<Long> deptIdList,
															   @Param("permissionCondition") String permissionCondition);

	/**
	 * @param deviceSn
	 * @param timestamp
	 * @param operator
	 * @param workspaceId
	 * @return
	 */
	Boolean deleteAttach(String deviceSn, long timestamp, Long operator, String workspaceId);

	/**
	 * 根据图斑ID查询附件列表
	 *
	 * @param lotInfoId 图斑ID
	 * @return 附件列表
	 */
	List<Attach> getlotInfoList(@Param("lotInfoId") Long lotInfoId);

	/**
	 *
	 * @param attachStatisticsVo
	 * @param deptIdList
	 * @param permissionCondition
	 * @return
	 */
	List<AttachTypeStatisticsVO> calculateTheThreeDimensionalAreaGroupBy(@Param("param") AttachStatisticsVo attachStatisticsVo, List<Long> deptIdList, String permissionCondition);

	/**
	 *
	 * @param jobId
	 * @return
	 */
    List<AttachChaneVO > selectAttachByJobIds(@Param("jobId") String jobId);
}