package org.jeecg.modules.mdc.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Param;
import org.jeecg.modules.mdc.entity.MdcEquipmentStatisticalShiftInfo;
import org.jeecg.modules.mdc.subcontrol.vo.LastWeekDataVo;

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

    List<LastWeekDataVo> findDataForBigScreen(@Param("equipmentIdList") List<String> equipmentIdList,
                                              @Param("monday") String monday, @Param("saturday") String saturday);

}