package com.ard.work.inspect.mapper;
|
|
import java.util.List;
|
import java.util.Map;
|
|
import com.ard.work.inspect.domain.ArdVideoInspectRecord;
|
import org.apache.ibatis.annotations.MapKey;
|
import org.apache.ibatis.annotations.Param;
|
|
/**
|
* 视频巡检记录Mapper接口
|
*
|
* @author ruoyi
|
* @date 2024-09-12
|
*/
|
public interface ArdVideoInspectRecordMapper
|
{
|
/**
|
* 查询视频巡检记录
|
*
|
* @param id 视频巡检记录主键
|
* @return 视频巡检记录
|
*/
|
public ArdVideoInspectRecord selectArdVideoInspectRecordById(String id);
|
|
/**
|
* 查询视频巡检记录列表
|
*
|
* @param ardVideoInspectRecord 视频巡检记录
|
* @return 视频巡检记录集合
|
*/
|
public List<ArdVideoInspectRecord> selectArdVideoInspectRecordList(ArdVideoInspectRecord ardVideoInspectRecord);
|
|
/**
|
* 新增视频巡检记录
|
*
|
* @param ardVideoInspectRecord 视频巡检记录
|
* @return 结果
|
*/
|
public int insertArdVideoInspectRecord(ArdVideoInspectRecord ardVideoInspectRecord);
|
|
/**
|
* 修改视频巡检记录
|
*
|
* @param ardVideoInspectRecord 视频巡检记录
|
* @return 结果
|
*/
|
public int updateArdVideoInspectRecord(ArdVideoInspectRecord ardVideoInspectRecord);
|
|
/**
|
* 删除视频巡检记录
|
*
|
* @param id 视频巡检记录主键
|
* @return 结果
|
*/
|
public int deleteArdVideoInspectRecordById(String id);
|
|
/**
|
* 批量删除视频巡检记录
|
*
|
* @param ids 需要删除的数据主键集合
|
* @return 结果
|
*/
|
public int deleteArdVideoInspectRecordByIds(String[] ids);
|
|
/**
|
* 按照月份统计巡检记录数量
|
* @param startMonth 开始月份
|
* @return List<Map<String, Object>>
|
*/
|
@MapKey("start_date")
|
List<Map<String, Object>> selectArdVideoInspectRecordCountByStartMonth(@Param("startMonth") String startMonth,@Param("wellName") String wellName,@Param("taskName") String taskName);
|
}
|
