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