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.MdcEquipmentStatisticalInfo;
|
|
import java.util.List;
|
|
/**
|
* @Description: 设备单日运行数据表
|
* @Author: jeecg-boot
|
* @Date: 2023-04-14
|
* @Version: V1.0
|
*/
|
public interface MdcEquipmentStatisticalInfoMapper extends BaseMapper<MdcEquipmentStatisticalInfo> {
|
|
/**
|
* 获取设备最新日期的运行数据
|
*/
|
MdcEquipmentStatisticalInfo getMaxStaticsData(@Param("equipmentId") String equipmentId);
|
|
/**
|
* 查询设备运行时间
|
*
|
* @param equipmentId
|
* @param validDate
|
* @return
|
*/
|
Integer selectProcessLong(@Param("equipmentId") String equipmentId, @Param("validDate") String validDate);
|
|
MdcEquipmentStatisticalDto findByEquipmentAndMonth(@Param("equipmentId") String equipmentId, @Param("date") String date);
|
|
List<MdcEquipmentStatisticalInfo> findByEquipmentAndDate(@Param("equipmentList") List<String> equipmentList, @Param("start") String start, @Param("end") String end);
|
|
List<MdcEquipmentStatisticalInfo> findByEquIdAndDate(@Param("equipmentId") String equipmentId, @Param("start") String start, @Param("end") String end);
|
|
MdcEquipmentStatisticalInfo findByEquIdAndMonth(@Param("equipmentId") String equipmentId, @Param("month") String month);
|
|
List<MdcEquipmentStatisticalInfo> findMdcEquipmentStatisticalInfo(@Param("equipmentId") String equipmentId, @Param("start") String start, @Param("end") String end);
|
}
|
