From 7d64716cb0d406f21cde03976fd273bd07fdc06f Mon Sep 17 00:00:00 2001
From: whycxzp <perryhsu@163.com>
Date: 星期二, 28 九月 2021 11:44:28 +0800
Subject: [PATCH] 更新用户-角色-菜单-权限
---
src/main/java/com/whyc/service/MotorStateService.java | 27 +++++++++++++++++++++++++++
1 files changed, 27 insertions(+), 0 deletions(-)
diff --git a/src/main/java/com/whyc/service/MotorStateService.java b/src/main/java/com/whyc/service/MotorStateService.java
index 91893d8..cdc815c 100644
--- a/src/main/java/com/whyc/service/MotorStateService.java
+++ b/src/main/java/com/whyc/service/MotorStateService.java
@@ -13,6 +13,10 @@
import org.springframework.stereotype.Service;
import javax.annotation.Resource;
+import java.text.DateFormat;
+import java.text.ParseException;
+import java.text.SimpleDateFormat;
+import java.util.Date;
import java.util.List;
@Service
@@ -64,7 +68,30 @@
}
+ public MotorState getByDeviceId(int deviceId){
+ QueryWrapper<MotorState> wrapper = Wrappers.query();
+ wrapper.eq("device_id",deviceId);
+ MotorState motorState = motorStateMapper.selectOne(wrapper);
+ return motorState;
+ }
+
public boolean delete(int deviceId){
return motorStateMapper.deleteById(deviceId)>0;
}
+
+ /**
+ * 閫氳繃璁惧id锛屽紑濮嬬粨鏉熸椂闂磋幏鍙栬澶囧巻鍙叉暟鎹�
+ * @param deviceId
+ * @param startTime
+ * @param endTime
+ * @return
+ */
+ public List<MotorState> getHistoryData(String deviceId,String startTime,String endTime){
+ //鑾峰彇鏃堕棿鎷兼帴鏁版嵁琛ㄥ悕
+ String dateStr = startTime.substring(0,10).replace('-','_');
+ String tableName="tb_motor_state_realdata_"+deviceId+"_"+dateStr;
+ List<MotorState> data = motorStateMapper.getDataByTime(tableName,startTime,endTime);
+ return data;
+ }
+
}
--
Gitblit v1.9.1