package org.sxkj.resource.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;

import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.sxkj.common.model.OdmUrlDto;
import org.sxkj.resource.entity.MediaFileEntity;
import org.sxkj.resource.model.EventHistoryDto;
import org.sxkj.resource.model.MediaFileQueryParam;
import org.sxkj.resource.model.MediaJobDTO;
import org.sxkj.resource.model.SearchMediaParam;
import org.sxkj.resource.vo.JobStatisticsTimeVoBo;
import org.sxkj.resource.vo.MediaFileCountVO;

import java.time.LocalDateTime;
import java.util.List;

/**
 * @author sean
 * @version 0.2
 * @date 2021/12/9
 */
@Mapper
public interface IFileMapper extends BaseMapper<MediaFileEntity> {
	Page<MediaFileEntity> getPage(@Param("page") Page<MediaFileEntity> mediaFileEntityPage, @Param("workspaceId") String workspaceId, @Param("query") MediaFileQueryParam mediaFileQueryParam);

	Page<MediaJobDTO> mediaPage(@Param("page") Page<MediaJobDTO> mediaFileEntityPage, @Param("workspaceId") String workspaceId, @Param("param") SearchMediaParam param);

	/**
	 * 查询odm
	 *
	 * @param workspaceId
	 * @param dkbhList
	 * @param
	 * @return
	 */
	List<OdmUrlDto> getOdm(@Param("workspaceId") String workspaceId,
						   List<String> dkbhList,
						   @Param("startTime") String startTime,
						   @Param("endTime") String endTime);

	Page<MediaJobDTO> mediaDetail(Page<MediaJobDTO> mediaJobDTOPage, @Param("jobId") String jobId, @Param("fileAddress") String fileAddress);

	/**
	 * 查询媒体文件信息
	 *
	 * @param objectKey
	 * @return
	 */
	MediaFileEntity getMediaFileByObjectKey(@Param("objectKey") String objectKey);

	/**
	 * 媒体文件信息更新
	 *
	 * @param objectKey
	 * @param objectName
	 * @return
	 */
	int updateMediaFileByObjectKey(@Param("objectKey") String objectKey, @Param("minObjectKey") String objectName);

	MediaFileEntity getMediaFieByTid(@Param("deviceId") String deviceId, @Param("timestamp") String timestamp);


	/**
	 * 批量删除媒体文件
	 *
	 * @param ids 要删除的文件的 objectKey 列表
	 * @return 删除的记录数量
	 */
	int batchDeleteByKeys(@Param("ids") List<Long> ids);

	/**
	 * 根据类型获取数据成果数量
	 * @param resultType 成果类型：0图片，1=视频，2=ai,3=三维，4=正射
	 * @return 成果数量
	 */
	MediaFileCountVO getMediaFileCountByResultType(@Param("resultType") Integer resultType,
												   @Param("areaCode") String areaCode,
												   @Param("deptIdList") List<Long> deptIdList,
												   @Param("permissionCondition") String permissionCondition);

	/**
	 * 获取三维成果面积
	 * @param resultType
	 * @param areaCode
	 * @param deptIdList
	 * @param permissionCondition
	 * @return
	 */
	MediaFileCountVO calculateTheThreeDimensionalArea(@Param("resultType") Integer resultType,
												   @Param("areaCode") String areaCode,
												   @Param("deptIdList") List<Long> deptIdList,
												   @Param("permissionCondition") String permissionCondition);

	/**
	 *
	 * @param resultType
	 * @param areaCode
	 * @return
	 */
	MediaFileCountVO getCountByResultType(@Param("resultType") Integer resultType, @Param("areaCode") String areaCode);


	public List<MediaFileEntity> findNearByMediaUrl(EventHistoryDto dto);

	public List<JobStatisticsTimeVoBo>timeEventNumStatistics(@Param("startDate") LocalDateTime startDate,@Param("endDate") LocalDateTime endDate, @Param("areaCode")String areaCode,

															 @Param("formatTime") String formatTime);

	public Long countEventNumStatistics(@Param("startDate") LocalDateTime startDate,@Param("endDate") LocalDateTime endDate, @Param("areaCode")String areaCode);
}