修复离线时间展示

yangys

2025-11-24 11d4be720620abf502d35000e2ed40d30c4023bf

 collect/src/main/java/com/qianwen/mdc/collect/mapper/iotdb/DeviceStateMapper.java

@@ -13,7 +13,7 @@
@DS("iotdb")
@InterceptorIgnore(tenantLine = "true")
public interface DeviceStateMapper extends BaseMapper<DeviceState> {
    void createSuperTable();
    //void createSuperTable();

    //void createTable(Long workstationId);

@@ -51,5 +51,69 @@
    */
   List<DeviceState> statesInTimeRange(@Param("workstationId")Long workstationId,@Param("timeRange") StateAggregateTimeDTO timeRange);

   /**
    * 查询某天固定点数量
    * @param factoryDate
    * @return
    */
   Long fixPointCountByDate(int factoryDate);

   /**
    * 根据工位id,获取 小于时间戳 的非反馈点数据
    * @param workstationId 工位id
    * @param time 时间戳
    * @return
    */
   DeviceState lastNoFeedbackStateLessThanTime(@Param("workstationId")Long workstationId, @Param("time")Long time);
   
   /**
    * 根据工位id,获取 小于等于时间戳 的非反馈点数据
    * @param workstationId
    * @param time
    * @return
    */
   DeviceState lastNoFeedbackStateLeTime(@Param("workstationId")Long workstationId, @Param("time")Long time);
   /**
    * 根据工位id和时间戳精确获取一条状态数据
    * @param workstationId
    * @param time
    * @return
    */
   DeviceState getByWorkstationIdAndTime(@Param("workstationId")Long workstationId, @Param("time")Long time);

   /**
    * 根据工位id和时间戳精确获取一条状态数据
    * @param workstationId
    * @param time
    * @return
    */
   DeviceState getLastByWorkstationIdAndLeTimeAndShiftIndexNotNull(@Param("workstationId")Long workstationId, @Param("time")Long time);
	
   /**
    * 根据时间和工位id，获取一个固定点
    * @param workstationId
    * @param time
    * @return
    */
   DeviceState getFixPointByWorkstationIdAndTime(@Param("workstationId")Long workstationId, @Param("time")Long time);
	
   /**
    * 获取指定工位时间区间内的非反馈点状态数据列表
    * @param workstationId
    * @param startTime
    * @param endTime
    * @return
    */
   List<DeviceState> workstationNoFeedbackPointStatesInTimeRange(@Param("workstationId")Long workstationId, @Param("startTime")Long startTime, @Param("endTime")Long endTime);
	
   /**
    * 获取指定工位时间区间内的 固定点 状态数据列表
    * @param workstationId
    * @param startTime
    * @param endTime
    * @return
    */
   List<DeviceState> workstationFixPointStatesInTimeRange(@Param("workstationId")Long workstationId, @Param("startTime")Long startTime, @Param("endTime")Long endTime);

    DeviceState lastNoFixedState(@Param("workstationId")long workstationId);
}