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

import com.baomidou.dynamic.datasource.annotation.DS;
import com.baomidou.mybatisplus.annotation.InterceptorIgnore;

import java.util.List;
import org.apache.ibatis.annotations.Param;

import com.qianwen.smartman.common.constant.FmsConstant;
import com.qianwen.smartman.modules.mdc.dto.ProcessParameterVO;
import com.qianwen.smartman.modules.mdc.dto.TimeDTO;
import com.qianwen.smartman.modules.mdc.entity.LastProcessParam;
import com.qianwen.smartman.modules.mdc.entity.WorkstationCollectData;

@DS("iotdb")
@InterceptorIgnore(tenantLine = FmsConstant.AUTOMATIC)
public interface SuperProcessParameterMapper {
	//这个在ProcessParameterService中实现了，mybatisplus对此有bug
    //List<WorkstationCollectData> queryLastParameter(@Param("workstationId") String workstationId);
	/**
	 * 查询工位最新参数，yys增加，可能需要使用queryLastParameter了（如果没问题）
	 * @param workstationId
	 * @return
	 */
	//LastProcessParam getLastParameters(@Param("workstationId") String workstationId);
	
    List<ProcessParameterVO> queryProcessParameter(@Param("workstationId") String workstationId, @Param("collectItems") List<String> collectItems, @Param("startTime") Long startTime, @Param("endTime") Long endTime);

    
    List<ProcessParameterVO> pageProcessParameter(@Param("size") Integer size, @Param("current") Integer current, @Param("startTime") Long startTime, @Param("endTime") Long endTime, @Param("item") String item, @Param("workstationId") String workstationId);

    Long countProcessParameter(@Param("item") String item, @Param("startTime") Long startTime, @Param("endTime") Long endTime, @Param("workstationId") String workstationId);

    ProcessParameterVO getOneDate(@Param("workstationId") String workstationId, @Param("item") String item, @Param("time") String time, @Param("flag") Boolean flag);

    List<ProcessParameterVO> processParameterListByShift(@Param("times") List<TimeDTO> times, @Param("collectItems") List<String> collectItems, @Param("workstationId") String workstationId);

    /**
     * 
     * @param workstationId
     * @param item
     * @param startTime
     * @param endTime
     * @return
     */
    List<ProcessParameterVO> oldOneCollectList(@Param("workstationId") Long workstationId, @Param("item") String item, @Param("startTime") Long startTime, @Param("endTime") Long endTime);

    /**
     * ???
     * @param workstationId
     * @param item
     * @param startTime
     * @return
     */
    //ProcessParameterVO oldFirstStatue(@Param("workstationId") String workstationId, @Param("item") String item, @Param("startTime") Long startTime);
    //LastProcessParam lastParameterLessThanTime(@Param("workstationId") Long workstationId, @Param("item") String item, @Param("startTime") Long startTime);
    
    /**
     * 
     * @param workstationId
     * @param item
     * @param startTime
     * @return
     */
    //ProcessParameterVO oldLastStatue(@Param("workstationId") String workstationId, @Param("item") String item, @Param("endTime") Long endTime);
    //LastProcessParam lastParameterGreaterThanTime(@Param("workstationId") Long workstationId, @Param("item") String item, @Param("endTime") Long endTime);
    
    /**
     * 获取一个采集参数不等于某值的最后一条
     * @param workstationId 工位id
     * @param item 参数名称
     * @param value 值
     * @return
     */
    ProcessParameterVO lastParameterNotEqValue(@Param("workstationId") Long workstationId,@Param("item")String item,@Param("value")String value);
    
    ProcessParameterVO firstParameterEqValueGtTime(@Param("workstationId") Long workstationId,@Param("item")String item,@Param("value")String value,@Param("time")long time);
    /**
     * 获取一个采集参数等于某值的最早一条
     * @param workstationId
     * @param item
     * @param value
     * @return
     */
    ProcessParameterVO firstParameterEqValue(@Param("workstationId") Long workstationId,@Param("item")String item,@Param("value")String value);
    
}