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} +