webservice推送设备状态和设备利用率

Lius

2024-06-18 1279d6eee2934b2765ce4ea1bf3a4d45d931760d

 lxzn-module-mdc/src/main/java/org/jeecg/modules/mdc/mapper/EquipmentMapper.java

@@ -6,6 +6,10 @@
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import org.jeecg.modules.mdc.entity.Equipment;
import org.jeecg.modules.mdc.vo.WsEquipmentStatus;
import org.jeecg.modules.mdc.vo.WsEquipmentUtilizationRate;

import java.util.List;

/**
 * @Description: 采集设备表
@@ -30,4 +34,8 @@

    @Insert(" SELECT * INTO ${tableName} FROM ${lastTableName} WHERE CollectTime < '${date}' ")
    void insertNoTableData(@Param("tableName") String tableName, @Param("lastTableName") String lastTableName, @Param("date") String date);

    List<WsEquipmentStatus> selectEquipmentStatus();

    List<WsEquipmentUtilizationRate> selectEquipmentRate(@Param("date") String date);
}