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.MdcEquipmentStatisticalDto;
|
import org.jeecg.modules.mdc.entity.MdcEquipmentStatisticalShiftInfo;
|
|
import java.math.BigDecimal;
|
import java.util.List;
|
|
/**
|
* @author: LiuS
|
* @create: 2023-07-24 11:23
|
*/
|
public interface MdcEquipmentStatisticalShiftInfoMapper extends BaseMapper<MdcEquipmentStatisticalShiftInfo> {
|
|
/**
|
* 获取设备最新日期的运行数据
|
*
|
* @param equipmentid
|
* @return
|
*/
|
MdcEquipmentStatisticalShiftInfo getMaxStaticsData(@Param("equipmentId") String equipmentid);
|
|
BigDecimal findSpindleRunDuration(@Param("equipmentId") String equipmentId, @Param("validDate") String validDate);
|
|
MdcEquipmentStatisticalDto findByEquipmentAndMonth(@Param("equipmentId") String equipmentId, @Param("date") String date);
|
|
List<MdcEquipmentStatisticalDto> findShiftByEquipmentAndMonth(@Param("equipmentId") String equipmentId, @Param("date") String date);
|
}
|
