package org.jeecg.modules.mdc.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Param;
import org.jeecg.modules.mdc.dto.EquipmentMachiningHistoryDto;
import org.jeecg.modules.mdc.entity.EquipmentMachiningHistory;

import java.util.Date;

/**
 * @Description: 设备转速负载历史表
 * @Author: lius
 * @Date: 2024-07-24
 * @Version: V1.0
 */
public interface EquipmentMachiningHistoryMapper extends BaseMapper<EquipmentMachiningHistory> {

    /**
     * 获取某个时间附近的主轴转速和主轴负载
     *
     * @param equipmentId
     * @param startDate
     * @param endDate
     * @param nearTime
     * @return
     */
    EquipmentMachiningHistoryDto getNearTimeSpindleLoad(@Param("equipmentId") String equipmentId, @Param("startDate") Date startDate, @Param("endDate") Date endDate, @Param("nearTime") Date nearTime);

    /**
     * 获取数据的最小时间
     *
     * @param equipmentId
     * @return
     */
    Date getMinDate(@Param("equipmentId") String equipmentId);

    /**
     * 获取设备某段时间内的最大主轴负载数据
     *
     * @param equipmentId
     * @param startDate
     * @param endDate
     * @return
     */
    EquipmentMachiningHistoryDto getMaxSpindleLoad(@Param("equipmentId") String equipmentId, @Param("startDate") Date startDate, @Param("endDate") Date endDate);
}