yangys
2024-09-04 910131c0e5271f018c516480cfd926f8660d2dbb
collect/src/main/java/com/qianwen/mdc/collect/mapper/iotdb/DeviceStateMapper.java
@@ -4,6 +4,7 @@
import com.baomidou.mybatisplus.annotation.InterceptorIgnore;
import com.baomidou.mybatisplus.core.conditions.Wrapper;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.qianwen.mdc.collect.dto.StateAggregateTimeDTO;
import com.qianwen.mdc.collect.entity.iotdb.DeviceState;
import java.util.List;
@@ -12,7 +13,7 @@
@DS("iotdb")
@InterceptorIgnore(tenantLine = "true")
public interface DeviceStateMapper extends BaseMapper<DeviceState> {
    void createSuperTable();
    //void createSuperTable();
    //void createTable(Long workstationId);
@@ -26,7 +27,34 @@
    DeviceState getLastIsSyncNoFixPointState(@Param("workstationId") Long workstationId);
    DeviceState getLastWorkstationState(@Param("ew") Wrapper query);
    //DeviceState getLastWorkstationState(@Param("ew") Wrapper query);
    /**
     * 获取最新的已同步的非反馈点状态
     * @param workstationId
     * @return
     */
    DeviceState lastSyncedNoFeedbackPointState(Long workstationId);
    //DeviceState getFirstWorkstationState(@Param("ew") Wrapper query);
    /**
     * 获取第一个的未同步的非反馈点状态
     * @param workstationId
     * @return
     */
   DeviceState firstNotSyncedNofeedbackPointState(Long workstationId);
    DeviceState getFirstWorkstationState(@Param("ew") Wrapper query);
   /**
    * 获取时间区间内的状态数据
    * @param workstationId
    * @param timeRange
    * @return
    */
   List<DeviceState> statesInTimeRange(@Param("workstationId")Long workstationId,@Param("timeRange") StateAggregateTimeDTO timeRange);
   /**
    * 查询某天固定点数量
    * @param factoryDate
    * @return
    */
   long fixPointCountByDate(int factoryDate);
}