package com.qianwen.smartman.modules.mdc.mapper;

import com.baomidou.dynamic.datasource.annotation.DS;
import com.baomidou.mybatisplus.annotation.InterceptorIgnore;
import com.qianwen.smartman.common.constant.FmsConstant;
import com.qianwen.smartman.modules.mdc.vo.StateVO;
import com.qianwen.smartman.modules.mdc.vo.StatusRecordVO;
import org.apache.ibatis.annotations.Param;

@DS("iotdb")
@InterceptorIgnore(tenantLine = FmsConstant.AUTOMATIC)
public interface StateMapper {
    /**
     * 最后一个不是指定值的数据
     * @param workstationId 工位id
     * @param value 指定值
     * @param beforeTime 在指定时间之前
     * @return 状态记录
     */
    StateVO lastStateNotEqValueLtTime(@Param("workstationId")long workstationId, @Param("value")Integer value,@Param("beforeTime")long beforeTime);

    /**
     * 查询大于指定时间第一个状态值
     * @param workstationId 工位id
     * @param value 指定值
     * @param time 时间戳(大于该时间的数据)
     * @return 状态数据对象
     */
    StateVO firstStateEqValueGtTime(@Param("workstationId")long workstationId, @Param("value")Integer value, @Param("time")Long time);

    StateVO firstStateEqValue(@Param("workstationId")long workstationId, @Param("value")Integer value);
}