/*
|
* 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.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") AttachVO 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);
|
}
|
