package org.jeecg.modules.mdc.mapper;
|
|
import com.baomidou.mybatisplus.annotation.InterceptorIgnore;
|
import org.apache.ibatis.annotations.Mapper;
|
import org.apache.ibatis.annotations.Param;
|
import org.apache.ibatis.annotations.Select;
|
import org.jeecg.modules.mdc.dto.MdcEquipmentDto;
|
import org.springframework.stereotype.Repository;
|
|
import java.util.Date;
|
import java.util.List;
|
import java.util.Map;
|
|
/**
|
* @author: LiuS
|
* @create: 2023-04-07 14:12
|
*/
|
@Mapper
|
@Repository
|
public interface EquipmentWorklineMapper {
|
|
@InterceptorIgnore(tenantLine = "1")
|
List<MdcEquipmentDto> getMacingDataList(@Param("tableName") String tableName);
|
|
@InterceptorIgnore(tenantLine = "1")
|
@Select("select Sequencenumber,CollectTime from ${tableName} " +
|
" where CollectTime > #{startTime} and CollectTime <= #{endTime} and Sequencenumber is not null" +
|
" order by CollectTime desc ")
|
List<Map<String, Object>> getEquipmentSequenceNumber(@Param("tableName") String tableName, @Param("startTime") Date startTime, @Param("endTime") Date endTime);
|
|
|
@InterceptorIgnore(tenantLine = "1")
|
@Select("select CollectTime ${columns} from [${tableName}] where CollectTime > #{startTime} and CollectTime <= #{endTime} order by CollectTime asc")
|
List<Map<String, Object>> getWorkLineList(Map<String, Object> param);
|
}
|
