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);
}