diff --git a/casic-sluicewell/src/main/java/com/casic/missiles/modular/system/dao/DataWaterMeterMapper.java b/casic-sluicewell/src/main/java/com/casic/missiles/modular/system/dao/DataWaterMeterMapper.java
index 6e1c63b..a277471 100644
--- a/casic-sluicewell/src/main/java/com/casic/missiles/modular/system/dao/DataWaterMeterMapper.java
+++ b/casic-sluicewell/src/main/java/com/casic/missiles/modular/system/dao/DataWaterMeterMapper.java
@@ -8,6 +8,7 @@
import org.apache.ibatis.annotations.Param;
import java.util.List;
+import java.util.Map;
/**
*
@@ -20,4 +21,10 @@
public interface DataWaterMeterMapper extends BaseMapper {
DataWaterMeter selectLatestRecordByDevcode(@Param("devcode") String devcode, @Param("uptime") String uptime);
+ Map selectLatestDayAccByDevice(@Param("devcode") String devcode, @Param("date") String date);
+ Map isExistDataWatermeterMonth(@Param("devcode") String devcode, @Param("month") String month);
+
+ void insertDataWatermeterDay(@Param("dataDay") Map dataDay);
+ void insertDataWatermeterMonth(@Param("dataMonth") Map dataMonth);
+ void updateDataWatermeterMonth(@Param("dataMonth") Map dataMonth, @Param("id") Long id);
}
diff --git a/casic-sluicewell/src/main/java/com/casic/missiles/modular/system/dao/DataWaterMeterMapper.java b/casic-sluicewell/src/main/java/com/casic/missiles/modular/system/dao/DataWaterMeterMapper.java
index 6e1c63b..a277471 100644
--- a/casic-sluicewell/src/main/java/com/casic/missiles/modular/system/dao/DataWaterMeterMapper.java
+++ b/casic-sluicewell/src/main/java/com/casic/missiles/modular/system/dao/DataWaterMeterMapper.java
@@ -8,6 +8,7 @@
import org.apache.ibatis.annotations.Param;
import java.util.List;
+import java.util.Map;
/**
*
@@ -20,4 +21,10 @@
public interface DataWaterMeterMapper extends BaseMapper {
DataWaterMeter selectLatestRecordByDevcode(@Param("devcode") String devcode, @Param("uptime") String uptime);
+ Map selectLatestDayAccByDevice(@Param("devcode") String devcode, @Param("date") String date);
+ Map isExistDataWatermeterMonth(@Param("devcode") String devcode, @Param("month") String month);
+
+ void insertDataWatermeterDay(@Param("dataDay") Map dataDay);
+ void insertDataWatermeterMonth(@Param("dataMonth") Map dataMonth);
+ void updateDataWatermeterMonth(@Param("dataMonth") Map dataMonth, @Param("id") Long id);
}
diff --git a/casic-sluicewell/src/main/java/com/casic/missiles/modular/system/dao/mapping/DataWaterMeterMapper.xml b/casic-sluicewell/src/main/java/com/casic/missiles/modular/system/dao/mapping/DataWaterMeterMapper.xml
index d07dbda..3f5865b 100644
--- a/casic-sluicewell/src/main/java/com/casic/missiles/modular/system/dao/mapping/DataWaterMeterMapper.xml
+++ b/casic-sluicewell/src/main/java/com/casic/missiles/modular/system/dao/mapping/DataWaterMeterMapper.xml
@@ -26,6 +26,34 @@
SELECT FROM data_watermeter
where devcode = #{devcode} and unix_timestamp(uptime) < unix_timestamp(#{uptime}) order by uptime desc limit 1
+
+
+
+
+ INSERT INTO data_watermeter_day (WELL_CODE, DEVCODE, FLOW_ACC_DATE, FLOW_ACC, DATE)
+ VALUES (#{dataDay.wellCode}, #{dataDay.devCode}, #{dataDay.flowAccDate}, #{dataDay.flowAcc}, #{dataDay.date})
+
+
+
+
+
+ INSERT INTO data_watermeter_month (WELL_CODE, DEVCODE, FLOW_ACC_MONTH, FIRST_ACC, LAST_ACC, MONTH)
+ VALUES (#{dataMonth.wellCode}, #{dataMonth.devCode}, #{dataMonth.flowAccMonth}, #{dataMonth.firstAcc}, #{dataMonth.lastAcc}, #{dataMonth.month})
+
+
+
+ UPDATE data_watermeter_month SET FLOW_ACC_MONTH = #{dataMonth.flowAccMonth}, LAST_ACC = #{dataMonth.lastAcc}
+ WHERE ID = #{id}
+
+
+
+
+
+ INSERT INTO data_watermeter_day (WELL_CODE, DEVCODE, FLOW_ACC_DATE, FLOW_ACC, DATE)
+ VALUES (#{dataDay.wellCode}, #{dataDay.devCode}, #{dataDay.flowAccDate}, #{dataDay.flowAcc}, #{dataDay.date})
+
+
+
+
+
+ INSERT INTO data_watermeter_month (WELL_CODE, DEVCODE, FLOW_ACC_MONTH, FIRST_ACC, LAST_ACC, MONTH)
+ VALUES (#{dataMonth.wellCode}, #{dataMonth.devCode}, #{dataMonth.flowAccMonth}, #{dataMonth.firstAcc}, #{dataMonth.lastAcc}, #{dataMonth.month})
+
+
+
+ UPDATE data_watermeter_month SET FLOW_ACC_MONTH = #{dataMonth.flowAccMonth}, LAST_ACC = #{dataMonth.lastAcc}
+ WHERE ID = #{id}
+
+
+
+
+
+ INSERT INTO data_watermeter_day (WELL_CODE, DEVCODE, FLOW_ACC_DATE, FLOW_ACC, DATE)
+ VALUES (#{dataDay.wellCode}, #{dataDay.devCode}, #{dataDay.flowAccDate}, #{dataDay.flowAcc}, #{dataDay.date})
+
+
+
+
+
+ INSERT INTO data_watermeter_month (WELL_CODE, DEVCODE, FLOW_ACC_MONTH, FIRST_ACC, LAST_ACC, MONTH)
+ VALUES (#{dataMonth.wellCode}, #{dataMonth.devCode}, #{dataMonth.flowAccMonth}, #{dataMonth.firstAcc}, #{dataMonth.lastAcc}, #{dataMonth.month})
+
+
+
+ UPDATE data_watermeter_month SET FLOW_ACC_MONTH = #{dataMonth.flowAccMonth}, LAST_ACC = #{dataMonth.lastAcc}
+ WHERE ID = #{id}
+