From 89d47f57b83b436a3d1e1a16a84f87ffb267be52 Mon Sep 17 00:00:00 2001 From: Administrator <zhubaomin> Date: 星期四, 20 六月 2024 15:59:51 +0800 Subject: [PATCH] 2024-06-20 朱宝民 开关阀上报数据处理(基本功能) --- pipIrr-platform/pipIrr-global/src/main/java/com/dy/pipIrrGlobal/daoRm/RmOpenCloseLastMapper.java | 36 + pipIrr-platform/pipIrr-global/src/main/java/com/dy/pipIrrGlobal/daoRm/RmOpenCloseHistoryMapper.java | 27 + pipIrr-platform/pipIrr-global/src/main/resources/mapper/RmOpenCloseLastMapper.xml | 383 +++++++++++++++ pipIrr-platform/pipIrr-mw/pipIrr-mw-rtu/src/main/resources/RtuDataDealTree.xml | 1 pipIrr-platform/pipIrr-global/src/main/java/com/dy/pipIrrGlobal/pojoRm/RmOpenCloseHistory.java | 217 ++++++++ pipIrr-platform/pipIrr-mw/pipIrr-mw-rtu/src/main/java/com/dy/rtuMw/server/rtuData/p206V202404/TkDealCloseValveReportV202404.java | 104 ++++ pipIrr-platform/pipIrr-global/src/main/resources/mapper/RmOpenCloseHistoryMapper.xml | 375 +++++++++++++++ pipIrr-platform/pipIrr-mw/pipIrr-mw-rtu/src/main/java/com/dy/rtuMw/server/rtuData/p206V202404/TkDealOpenValveReportV202404.java | 54 +- pipIrr-platform/pipIrr-global/src/main/java/com/dy/pipIrrGlobal/pojoRm/RmOpenCloseLast.java | 217 ++++++++ pipIrr-platform/pipIrr-mw/pipIrr-mw-rtu/src/main/java/com/dy/rtuMw/server/rtuData/dbSv/DbSv.java | 43 + 10 files changed, 1,431 insertions(+), 26 deletions(-) diff --git a/pipIrr-platform/pipIrr-global/src/main/java/com/dy/pipIrrGlobal/daoRm/RmOpenCloseHistoryMapper.java b/pipIrr-platform/pipIrr-global/src/main/java/com/dy/pipIrrGlobal/daoRm/RmOpenCloseHistoryMapper.java new file mode 100644 index 0000000..39c2f2d --- /dev/null +++ b/pipIrr-platform/pipIrr-global/src/main/java/com/dy/pipIrrGlobal/daoRm/RmOpenCloseHistoryMapper.java @@ -0,0 +1,27 @@ +package com.dy.pipIrrGlobal.daoRm; + +import com.baomidou.mybatisplus.core.mapper.BaseMapper; +import com.dy.pipIrrGlobal.pojoRm.RmOpenCloseHistory; +import org.apache.ibatis.annotations.Mapper; + +/** + * @author ZhuBaoMin + * @date 2024-06-20 10:34 + * @LastEditTime 2024-06-20 10:34 + * @Description + */ + +@Mapper +public interface RmOpenCloseHistoryMapper extends BaseMapper<RmOpenCloseHistory> { + int deleteByPrimaryKey(Long id); + + int insert(RmOpenCloseHistory record); + + int insertSelective(RmOpenCloseHistory record); + + RmOpenCloseHistory selectByPrimaryKey(Long id); + + int updateByPrimaryKeySelective(RmOpenCloseHistory record); + + int updateByPrimaryKey(RmOpenCloseHistory record); +} \ No newline at end of file diff --git a/pipIrr-platform/pipIrr-global/src/main/java/com/dy/pipIrrGlobal/daoRm/RmOpenCloseLastMapper.java b/pipIrr-platform/pipIrr-global/src/main/java/com/dy/pipIrrGlobal/daoRm/RmOpenCloseLastMapper.java new file mode 100644 index 0000000..c94b41e --- /dev/null +++ b/pipIrr-platform/pipIrr-global/src/main/java/com/dy/pipIrrGlobal/daoRm/RmOpenCloseLastMapper.java @@ -0,0 +1,36 @@ +package com.dy.pipIrrGlobal.daoRm; + +import com.baomidou.mybatisplus.core.mapper.BaseMapper; +import com.dy.pipIrrGlobal.pojoRm.RmOpenCloseLast; +import org.apache.ibatis.annotations.Mapper; + +import java.util.List; + +/** + * @author ZhuBaoMin + * @date 2024-06-20 10:34 + * @LastEditTime 2024-06-20 10:34 + * @Description + */ + +@Mapper +public interface RmOpenCloseLastMapper extends BaseMapper<RmOpenCloseLast> { + int deleteByPrimaryKey(Long id); + + int insert(RmOpenCloseLast record); + + int insertSelective(RmOpenCloseLast record); + + RmOpenCloseLast selectByPrimaryKey(Long id); + + int updateByPrimaryKeySelective(RmOpenCloseLast record); + + int updateByPrimaryKey(RmOpenCloseLast record); + + /** + * 鏍规嵁闃�鎺у櫒鍦板潃鑾峰彇寮�鍏抽榾涓婃姤鏈�鏂版暟鎹� + * @param rtuAddr + * @return + */ + List<RmOpenCloseLast> getRmOpenCloseReportLast(String rtuAddr); +} \ No newline at end of file diff --git a/pipIrr-platform/pipIrr-global/src/main/java/com/dy/pipIrrGlobal/pojoRm/RmOpenCloseHistory.java b/pipIrr-platform/pipIrr-global/src/main/java/com/dy/pipIrrGlobal/pojoRm/RmOpenCloseHistory.java new file mode 100644 index 0000000..060b01f --- /dev/null +++ b/pipIrr-platform/pipIrr-global/src/main/java/com/dy/pipIrrGlobal/pojoRm/RmOpenCloseHistory.java @@ -0,0 +1,217 @@ +package com.dy.pipIrrGlobal.pojoRm; + +import com.alibaba.fastjson2.annotation.JSONField; +import com.alibaba.fastjson2.writer.ObjectWriterImplToString; +import com.baomidou.mybatisplus.annotation.IdType; +import com.baomidou.mybatisplus.annotation.TableId; +import com.baomidou.mybatisplus.annotation.TableName; +import com.dy.common.mw.protocol.p206V202404.DataV202404; +import com.dy.common.mw.protocol.p206V202404.upVos.DataCd84Vo; +import com.dy.common.mw.protocol.p206V202404.upVos.DataCd85Vo; +import com.dy.common.po.BaseEntity; +import com.dy.common.util.DateTime; +import com.fasterxml.jackson.annotation.JsonFormat; +import io.swagger.v3.oas.annotations.media.Schema; +import lombok.*; + +import java.util.Date; + +/** + * @author ZhuBaoMin + * @date 2024-06-20 10:34 + * @LastEditTime 2024-06-20 10:34 + * @Description + */ +/** + * 寮�鍏抽榾鎶ュ巻鍙叉暟鎹〃 + */ + +@TableName(value="rm_open_close_history", autoResultMap = true) +@Data +@Builder +@ToString +@NoArgsConstructor +@AllArgsConstructor +@Schema(name = "寮�鍏抽榾鎶ュ巻鍙叉暟鎹〃") +public class RmOpenCloseHistory implements BaseEntity { + public static final long serialVersionUID = 202406201040001L; + + /** + * 涓婚敭 + */ + @JSONField(serializeUsing= ObjectWriterImplToString.class) + @TableId(type = IdType.INPUT) + public Long id; + + /** + * 鎺у埗鍣ㄥ疄浣揑D锛堝閿級 + */ + @JSONField(serializeUsing= ObjectWriterImplToString.class) + public Long controllerId; + + /** + * 鍙栨按鍙e疄浣揑D锛堝閿級 + */ + @JSONField(serializeUsing= ObjectWriterImplToString.class) + public Long intakeId; + + /** + * 鎺у埗鍣ㄥ湴鍧� + */ + public String rtuAddr; + + /** + * 寮�闃�鏁版嵁鎺ユ敹鏃ユ湡鏃堕棿 + */ + @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss") + public Date opDt; + + /** + * 寮�闃�鎺у埗鍣ㄦ椂閽� + */ + @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss") + public Date opRtuDt; + + /** + * IC鍗″湴鍧�锛堣繙绋嬪叧闂椂涓�0锛� + */ + public String opIcCardAddr; + + /** + * IC鍗$紪鍙凤紙17浣嶆暟瀛楋級 + */ + public String opIcCardNo; + + /** + * 寮�闃�璁㈠崟鍙凤紙16浣嶆暟瀛楋級 + */ + public String opOrderNo; + + /** + * 寮�娉�/闃�鏃堕棿 + */ + @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss") + public Date openDt; + + /** + * 寮�闃�姘磋〃绱姘撮噺 + */ + public Double opWaterTotalAmount; + + /** + * 寮�闃�鐢佃〃绱鐢甸噺 + */ + public Double opEleTotalAmount; + + /** + * 寮�闃�鐢ㄦ埛鍓╀綑閲戦 + */ + public Double opMoneyRemainUser; + + /** + * 寮�闃�鐢ㄦ埛鍓╀綑姘撮噺 + */ + public Double opWaterRemainUser; + + /** + * 鍏虫车/闃�鏂瑰紡 + */ + public Byte opType; + + /** + * 鍏抽榾IC鍗″湴鍧�锛堣繙绋嬪叧闂椂涓�0锛� + */ + public String clIcCardAddr; + + /** + * 鍏抽榾IC鍗$紪鍙凤紙17浣嶆暟瀛楋級 + */ + public String clIcCardNo; + + /** + * 鍏抽榾璁㈠崟鍙凤紙16浣嶆暟瀛楋級 + */ + public String clOrderNo; + + /** + * 寮�濮嬫椂闂�(鍒嗘椂鏃ユ湀) + */ + @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss") + public Date startDt; + + /** + * 缁撴潫鏃堕棿(鍒嗘椂鏃ユ湀) + */ + @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss") + public Date endDt; + + /** + * 姘磋〃绱娴侀噺 + */ + public Double clWaterTotalAmount; + + /** + * 鐢佃〃绱鐢甸噺 + */ + public Double clEleTotalAmount; + + /** + * 鐢ㄦ埛鍓╀綑閲戦 + */ + public Double clMoneyRemainUser; + + /** + * 鐢ㄦ埛鍓╀綑姘撮噺 + */ + public Double clWaterRemainUser; + + /** + * 鏈浣跨敤鐢甸噺 + */ + public Double thisEle; + + /** + * 鏈浣跨敤姘撮噺 + */ + public Double thisWater; + + /** + * 鏈浣跨敤閲戦 + */ + public Double thisMoney; + + /** + * 鏈浣跨敤鏃堕棿闀� + */ + public Integer thisDuration; + + public void valueFrom84(DataV202404 dataV202404, DataCd84Vo cdData) throws Exception{ + this.opDt = DateTime.dateFrom_yyyy_MM_dd_HH_mm_ss(dataV202404.dt); + this.openDt = DateTime.dateFrom_yyyy_MM_dd_HH_mm_ss(cdData.opDt); + //this.opRtuDt = DateTime.dateFrom_yyyy_MM_dd_HH_mm_ss(cdData.opDt); + this.opIcCardAddr = cdData.icCardAddr; + this.opIcCardNo = cdData.icCardNo; + this.opOrderNo = cdData.orderNo; + this.opWaterTotalAmount = cdData.waterTotalAmount; + this.opEleTotalAmount = cdData.eleTotalAmount; + this.opMoneyRemainUser = cdData.moneyRemainUser; + this.opWaterRemainUser = cdData.waterRemainUser; + } + + public void valueFrom85(DataV202404 dataV202404, DataCd85Vo cdData) throws Exception{ + this.startDt = DateTime.dateFrom_yyyy_MM_dd_HH_mm_ss(cdData.startDt); + this.endDt = DateTime.dateFrom_yyyy_MM_dd_HH_mm_ss(cdData.endDt); + this.opType = cdData.opType; + this.clIcCardAddr = cdData.icCardAddr; + this.clIcCardNo = cdData.icCardNo; + this.clOrderNo = cdData.orderNo; + this.clWaterTotalAmount = cdData.waterTotalAmount; + this.clEleTotalAmount = cdData.eleTotalAmount; + this.clMoneyRemainUser = cdData.moneyRemain; + this.clWaterRemainUser = cdData.waterRemain; + this.thisEle = cdData.thisEle; + this.thisWater = cdData.thisWater; + this.thisMoney = cdData.thisMoney; + this.thisDuration = cdData.thisDuration; + } +} \ No newline at end of file diff --git a/pipIrr-platform/pipIrr-global/src/main/java/com/dy/pipIrrGlobal/pojoRm/RmOpenCloseLast.java b/pipIrr-platform/pipIrr-global/src/main/java/com/dy/pipIrrGlobal/pojoRm/RmOpenCloseLast.java new file mode 100644 index 0000000..5c8723d --- /dev/null +++ b/pipIrr-platform/pipIrr-global/src/main/java/com/dy/pipIrrGlobal/pojoRm/RmOpenCloseLast.java @@ -0,0 +1,217 @@ +package com.dy.pipIrrGlobal.pojoRm; + +import com.alibaba.fastjson2.annotation.JSONField; +import com.alibaba.fastjson2.writer.ObjectWriterImplToString; +import com.baomidou.mybatisplus.annotation.IdType; +import com.baomidou.mybatisplus.annotation.TableId; +import com.baomidou.mybatisplus.annotation.TableName; +import com.dy.common.mw.protocol.p206V202404.DataV202404; +import com.dy.common.mw.protocol.p206V202404.upVos.DataCd84Vo; +import com.dy.common.mw.protocol.p206V202404.upVos.DataCd85Vo; +import com.dy.common.po.BaseEntity; +import com.dy.common.util.DateTime; +import com.fasterxml.jackson.annotation.JsonFormat; +import io.swagger.v3.oas.annotations.media.Schema; +import lombok.*; + +import java.util.Date; + +/** + * @author ZhuBaoMin + * @date 2024-06-20 10:34 + * @LastEditTime 2024-06-20 10:34 + * @Description + */ +/** + * 寮�鍏抽榾鎶ユ渶鏂版暟鎹〃 + */ + +@TableName(value="rm_open_close_last", autoResultMap = true) +@Data +@Builder +@ToString +@NoArgsConstructor +@AllArgsConstructor +@Schema(name = "寮�鍏抽榾鎶ユ渶鏂版暟鎹〃") +public class RmOpenCloseLast implements BaseEntity { + public static final long serialVersionUID = 202406201041001L; + + /** + * 涓婚敭 + */ + @JSONField(serializeUsing= ObjectWriterImplToString.class) + @TableId(type = IdType.INPUT) + public Long id; + + /** + * 鎺у埗鍣ㄥ疄浣揑D锛堝閿級 + */ + @JSONField(serializeUsing= ObjectWriterImplToString.class) + public Long controllerId; + + /** + * 鍙栨按鍙e疄浣揑D锛堝閿級 + */ + @JSONField(serializeUsing= ObjectWriterImplToString.class) + public Long intakeId; + + /** + * 鎺у埗鍣ㄥ湴鍧� + */ + public String rtuAddr; + + /** + * 寮�闃�鏁版嵁鎺ユ敹鏃ユ湡鏃堕棿 + */ + @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss") + public Date opDt; + + /** + * 寮�闃�鎺у埗鍣ㄦ椂閽� + */ + @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss") + public Date opRtuDt; + + /** + * IC鍗″湴鍧�锛堣繙绋嬪叧闂椂涓�0锛� + */ + public String opIcCardAddr; + + /** + * IC鍗$紪鍙凤紙17浣嶆暟瀛楋級 + */ + public String opIcCardNo; + + /** + * 寮�闃�璁㈠崟鍙凤紙16浣嶆暟瀛楋級 + */ + public String opOrderNo; + + /** + * 寮�娉�/闃�鏃堕棿 + */ + @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss") + public Date openDt; + + /** + * 寮�闃�姘磋〃绱姘撮噺 + */ + public Double opWaterTotalAmount; + + /** + * 寮�闃�鐢佃〃绱鐢甸噺 + */ + public Double opEleTotalAmount; + + /** + * 寮�闃�鐢ㄦ埛鍓╀綑閲戦 + */ + public Double opMoneyRemainUser; + + /** + * 寮�闃�鐢ㄦ埛鍓╀綑姘撮噺 + */ + public Double opWaterRemainUser; + + /** + * 鍏虫车/闃�鏂瑰紡 + */ + public Byte opType; + + /** + * 鍏抽榾IC鍗″湴鍧�锛堣繙绋嬪叧闂椂涓�0锛� + */ + public String clIcCardAddr; + + /** + * 鍏抽榾IC鍗$紪鍙凤紙17浣嶆暟瀛楋級 + */ + public String clIcCardNo; + + /** + * 鍏抽榾璁㈠崟鍙凤紙16浣嶆暟瀛楋級 + */ + public String clOrderNo; + + /** + * 寮�濮嬫椂闂�(鍒嗘椂鏃ユ湀) + */ + @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss") + public Date startDt; + + /** + * 缁撴潫鏃堕棿(鍒嗘椂鏃ユ湀) + */ + @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss") + public Date endDt; + + /** + * 姘磋〃绱娴侀噺 + */ + public Double clWaterTotalAmount; + + /** + * 鐢佃〃绱鐢甸噺 + */ + public Double clEleTotalAmount; + + /** + * 鐢ㄦ埛鍓╀綑閲戦 + */ + public Double clMoneyRemainUser; + + /** + * 鐢ㄦ埛鍓╀綑姘撮噺 + */ + public Double clWaterRemainUser; + + /** + * 鏈浣跨敤鐢甸噺 + */ + public Double thisEle; + + /** + * 鏈浣跨敤姘撮噺 + */ + public Double thisWater; + + /** + * 鏈浣跨敤閲戦 + */ + public Double thisMoney; + + /** + * 鏈浣跨敤鏃堕棿闀� + */ + public Integer thisDuration; + + public void valueFrom84(DataV202404 dataV202404, DataCd84Vo cdData) throws Exception{ + this.opDt = DateTime.dateFrom_yyyy_MM_dd_HH_mm_ss(dataV202404.dt); + this.openDt = DateTime.dateFrom_yyyy_MM_dd_HH_mm_ss(cdData.opDt); + //this.opRtuDt = DateTime.dateFrom_yyyy_MM_dd_HH_mm_ss(cdData.opDt); + this.opIcCardAddr = cdData.icCardAddr; + this.opIcCardNo = cdData.icCardNo; + this.opOrderNo = cdData.orderNo; + this.opWaterTotalAmount = cdData.waterTotalAmount; + this.opEleTotalAmount = cdData.eleTotalAmount; + this.opMoneyRemainUser = cdData.moneyRemainUser; + this.opWaterRemainUser = cdData.waterRemainUser; + } + + public void valueFrom85(DataV202404 dataV202404, DataCd85Vo cdData) throws Exception{ + this.startDt = DateTime.dateFrom_yyyy_MM_dd_HH_mm_ss(cdData.startDt); + this.endDt = DateTime.dateFrom_yyyy_MM_dd_HH_mm_ss(cdData.endDt); + this.opType = cdData.opType; + this.clIcCardAddr = cdData.icCardAddr; + this.clIcCardNo = cdData.icCardNo; + this.clOrderNo = cdData.orderNo; + this.clWaterTotalAmount = cdData.waterTotalAmount; + this.clEleTotalAmount = cdData.eleTotalAmount; + this.clMoneyRemainUser = cdData.moneyRemain; + this.clWaterRemainUser = cdData.waterRemain; + this.thisEle = cdData.thisEle; + this.thisWater = cdData.thisWater; + this.thisMoney = cdData.thisMoney; + this.thisDuration = cdData.thisDuration; + } +} \ No newline at end of file diff --git a/pipIrr-platform/pipIrr-global/src/main/resources/mapper/RmOpenCloseHistoryMapper.xml b/pipIrr-platform/pipIrr-global/src/main/resources/mapper/RmOpenCloseHistoryMapper.xml new file mode 100644 index 0000000..9b3896d --- /dev/null +++ b/pipIrr-platform/pipIrr-global/src/main/resources/mapper/RmOpenCloseHistoryMapper.xml @@ -0,0 +1,375 @@ +<?xml version="1.0" encoding="UTF-8"?> +<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd"> +<mapper namespace="com.dy.pipIrrGlobal.daoRm.RmOpenCloseHistoryMapper"> + <resultMap id="BaseResultMap" type="com.dy.pipIrrGlobal.pojoRm.RmOpenCloseHistory"> + <!--@mbg.generated--> + <!--@Table rm_open_close_history--> + <id column="id" jdbcType="BIGINT" property="id" /> + <result column="controller_id" jdbcType="BIGINT" property="controllerId" /> + <result column="intake_id" jdbcType="BIGINT" property="intakeId" /> + <result column="rtu_addr" jdbcType="VARCHAR" property="rtuAddr" /> + <result column="op_dt" jdbcType="TIMESTAMP" property="opDt" /> + <result column="op_rtu_dt" jdbcType="TIMESTAMP" property="opRtuDt" /> + <result column="op_ic_card_addr" jdbcType="VARCHAR" property="opIcCardAddr" /> + <result column="op_ic_card_no" jdbcType="VARCHAR" property="opIcCardNo" /> + <result column="op_order_no" jdbcType="VARCHAR" property="opOrderNo" /> + <result column="open_dt" jdbcType="TIMESTAMP" property="openDt" /> + <result column="op_water_total_amount" jdbcType="FLOAT" property="opWaterTotalAmount" /> + <result column="op_ele_total_amount" jdbcType="FLOAT" property="opEleTotalAmount" /> + <result column="op_money_remain_user" jdbcType="FLOAT" property="opMoneyRemainUser" /> + <result column="op_water_remain_user" jdbcType="FLOAT" property="opWaterRemainUser" /> + <result column="op_type" jdbcType="TINYINT" property="opType" /> + <result column="cl_ic_card_addr" jdbcType="VARCHAR" property="clIcCardAddr" /> + <result column="cl_ic_card_no" jdbcType="VARCHAR" property="clIcCardNo" /> + <result column="cl_order_no" jdbcType="VARCHAR" property="clOrderNo" /> + <result column="start_dt" jdbcType="TIMESTAMP" property="startDt" /> + <result column="end_dt" jdbcType="TIMESTAMP" property="endDt" /> + <result column="cl_water_total_amount" jdbcType="FLOAT" property="clWaterTotalAmount" /> + <result column="cl_ele_total_amount" jdbcType="FLOAT" property="clEleTotalAmount" /> + <result column="cl_money_remain_user" jdbcType="FLOAT" property="clMoneyRemainUser" /> + <result column="cl_water_remain_user" jdbcType="FLOAT" property="clWaterRemainUser" /> + <result column="this_ele" jdbcType="FLOAT" property="thisEle" /> + <result column="this_water" jdbcType="FLOAT" property="thisWater" /> + <result column="this_money" jdbcType="FLOAT" property="thisMoney" /> + <result column="this_duration" jdbcType="INTEGER" property="thisDuration" /> + </resultMap> + <sql id="Base_Column_List"> + <!--@mbg.generated--> + id, controller_id, intake_id, rtu_addr, op_dt, op_rtu_dt, op_ic_card_addr, op_ic_card_no, + op_order_no, open_dt, op_water_total_amount, op_ele_total_amount, op_money_remain_user, + op_water_remain_user, op_type, cl_ic_card_addr, cl_ic_card_no, cl_order_no, start_dt, + end_dt, cl_water_total_amount, cl_ele_total_amount, cl_money_remain_user, cl_water_remain_user, + this_ele, this_water, this_money, this_duration + </sql> + <select id="selectByPrimaryKey" parameterType="java.lang.Long" resultMap="BaseResultMap"> + <!--@mbg.generated--> + select + <include refid="Base_Column_List" /> + from rm_open_close_history + where id = #{id,jdbcType=BIGINT} + </select> + <delete id="deleteByPrimaryKey" parameterType="java.lang.Long"> + <!--@mbg.generated--> + delete from rm_open_close_history + where id = #{id,jdbcType=BIGINT} + </delete> + <insert id="insert" parameterType="com.dy.pipIrrGlobal.pojoRm.RmOpenCloseHistory"> + <!--@mbg.generated--> + insert into rm_open_close_history (id, controller_id, intake_id, + rtu_addr, op_dt, op_rtu_dt, + op_ic_card_addr, op_ic_card_no, op_order_no, + open_dt, op_water_total_amount, op_ele_total_amount, + op_money_remain_user, op_water_remain_user, op_type, + cl_ic_card_addr, cl_ic_card_no, cl_order_no, + start_dt, end_dt, cl_water_total_amount, + cl_ele_total_amount, cl_money_remain_user, cl_water_remain_user, + this_ele, this_water, this_money, + this_duration) + values (#{id,jdbcType=BIGINT}, #{controllerId,jdbcType=BIGINT}, #{intakeId,jdbcType=BIGINT}, + #{rtuAddr,jdbcType=VARCHAR}, #{opDt,jdbcType=TIMESTAMP}, #{opRtuDt,jdbcType=TIMESTAMP}, + #{opIcCardAddr,jdbcType=VARCHAR}, #{opIcCardNo,jdbcType=VARCHAR}, #{opOrderNo,jdbcType=VARCHAR}, + #{openDt,jdbcType=TIMESTAMP}, #{opWaterTotalAmount,jdbcType=FLOAT}, #{opEleTotalAmount,jdbcType=FLOAT}, + #{opMoneyRemainUser,jdbcType=FLOAT}, #{opWaterRemainUser,jdbcType=FLOAT}, #{opType,jdbcType=TINYINT}, + #{clIcCardAddr,jdbcType=VARCHAR}, #{clIcCardNo,jdbcType=VARCHAR}, #{clOrderNo,jdbcType=VARCHAR}, + #{startDt,jdbcType=TIMESTAMP}, #{endDt,jdbcType=TIMESTAMP}, #{clWaterTotalAmount,jdbcType=FLOAT}, + #{clEleTotalAmount,jdbcType=FLOAT}, #{clMoneyRemainUser,jdbcType=FLOAT}, #{clWaterRemainUser,jdbcType=FLOAT}, + #{thisEle,jdbcType=FLOAT}, #{thisWater,jdbcType=FLOAT}, #{thisMoney,jdbcType=FLOAT}, + #{thisDuration,jdbcType=INTEGER}) + </insert> + <insert id="insertSelective" parameterType="com.dy.pipIrrGlobal.pojoRm.RmOpenCloseHistory"> + <!--@mbg.generated--> + insert into rm_open_close_history + <trim prefix="(" suffix=")" suffixOverrides=","> + <if test="id != null"> + id, + </if> + <if test="controllerId != null"> + controller_id, + </if> + <if test="intakeId != null"> + intake_id, + </if> + <if test="rtuAddr != null"> + rtu_addr, + </if> + <if test="opDt != null"> + op_dt, + </if> + <if test="opRtuDt != null"> + op_rtu_dt, + </if> + <if test="opIcCardAddr != null"> + op_ic_card_addr, + </if> + <if test="opIcCardNo != null"> + op_ic_card_no, + </if> + <if test="opOrderNo != null"> + op_order_no, + </if> + <if test="openDt != null"> + open_dt, + </if> + <if test="opWaterTotalAmount != null"> + op_water_total_amount, + </if> + <if test="opEleTotalAmount != null"> + op_ele_total_amount, + </if> + <if test="opMoneyRemainUser != null"> + op_money_remain_user, + </if> + <if test="opWaterRemainUser != null"> + op_water_remain_user, + </if> + <if test="opType != null"> + op_type, + </if> + <if test="clIcCardAddr != null"> + cl_ic_card_addr, + </if> + <if test="clIcCardNo != null"> + cl_ic_card_no, + </if> + <if test="clOrderNo != null"> + cl_order_no, + </if> + <if test="startDt != null"> + start_dt, + </if> + <if test="endDt != null"> + end_dt, + </if> + <if test="clWaterTotalAmount != null"> + cl_water_total_amount, + </if> + <if test="clEleTotalAmount != null"> + cl_ele_total_amount, + </if> + <if test="clMoneyRemainUser != null"> + cl_money_remain_user, + </if> + <if test="clWaterRemainUser != null"> + cl_water_remain_user, + </if> + <if test="thisEle != null"> + this_ele, + </if> + <if test="thisWater != null"> + this_water, + </if> + <if test="thisMoney != null"> + this_money, + </if> + <if test="thisDuration != null"> + this_duration, + </if> + </trim> + <trim prefix="values (" suffix=")" suffixOverrides=","> + <if test="id != null"> + #{id,jdbcType=BIGINT}, + </if> + <if test="controllerId != null"> + #{controllerId,jdbcType=BIGINT}, + </if> + <if test="intakeId != null"> + #{intakeId,jdbcType=BIGINT}, + </if> + <if test="rtuAddr != null"> + #{rtuAddr,jdbcType=VARCHAR}, + </if> + <if test="opDt != null"> + #{opDt,jdbcType=TIMESTAMP}, + </if> + <if test="opRtuDt != null"> + #{opRtuDt,jdbcType=TIMESTAMP}, + </if> + <if test="opIcCardAddr != null"> + #{opIcCardAddr,jdbcType=VARCHAR}, + </if> + <if test="opIcCardNo != null"> + #{opIcCardNo,jdbcType=VARCHAR}, + </if> + <if test="opOrderNo != null"> + #{opOrderNo,jdbcType=VARCHAR}, + </if> + <if test="openDt != null"> + #{openDt,jdbcType=TIMESTAMP}, + </if> + <if test="opWaterTotalAmount != null"> + #{opWaterTotalAmount,jdbcType=FLOAT}, + </if> + <if test="opEleTotalAmount != null"> + #{opEleTotalAmount,jdbcType=FLOAT}, + </if> + <if test="opMoneyRemainUser != null"> + #{opMoneyRemainUser,jdbcType=FLOAT}, + </if> + <if test="opWaterRemainUser != null"> + #{opWaterRemainUser,jdbcType=FLOAT}, + </if> + <if test="opType != null"> + #{opType,jdbcType=TINYINT}, + </if> + <if test="clIcCardAddr != null"> + #{clIcCardAddr,jdbcType=VARCHAR}, + </if> + <if test="clIcCardNo != null"> + #{clIcCardNo,jdbcType=VARCHAR}, + </if> + <if test="clOrderNo != null"> + #{clOrderNo,jdbcType=VARCHAR}, + </if> + <if test="startDt != null"> + #{startDt,jdbcType=TIMESTAMP}, + </if> + <if test="endDt != null"> + #{endDt,jdbcType=TIMESTAMP}, + </if> + <if test="clWaterTotalAmount != null"> + #{clWaterTotalAmount,jdbcType=FLOAT}, + </if> + <if test="clEleTotalAmount != null"> + #{clEleTotalAmount,jdbcType=FLOAT}, + </if> + <if test="clMoneyRemainUser != null"> + #{clMoneyRemainUser,jdbcType=FLOAT}, + </if> + <if test="clWaterRemainUser != null"> + #{clWaterRemainUser,jdbcType=FLOAT}, + </if> + <if test="thisEle != null"> + #{thisEle,jdbcType=FLOAT}, + </if> + <if test="thisWater != null"> + #{thisWater,jdbcType=FLOAT}, + </if> + <if test="thisMoney != null"> + #{thisMoney,jdbcType=FLOAT}, + </if> + <if test="thisDuration != null"> + #{thisDuration,jdbcType=INTEGER}, + </if> + </trim> + </insert> + <update id="updateByPrimaryKeySelective" parameterType="com.dy.pipIrrGlobal.pojoRm.RmOpenCloseHistory"> + <!--@mbg.generated--> + update rm_open_close_history + <set> + <if test="controllerId != null"> + controller_id = #{controllerId,jdbcType=BIGINT}, + </if> + <if test="intakeId != null"> + intake_id = #{intakeId,jdbcType=BIGINT}, + </if> + <if test="rtuAddr != null"> + rtu_addr = #{rtuAddr,jdbcType=VARCHAR}, + </if> + <if test="opDt != null"> + op_dt = #{opDt,jdbcType=TIMESTAMP}, + </if> + <if test="opRtuDt != null"> + op_rtu_dt = #{opRtuDt,jdbcType=TIMESTAMP}, + </if> + <if test="opIcCardAddr != null"> + op_ic_card_addr = #{opIcCardAddr,jdbcType=VARCHAR}, + </if> + <if test="opIcCardNo != null"> + op_ic_card_no = #{opIcCardNo,jdbcType=VARCHAR}, + </if> + <if test="opOrderNo != null"> + op_order_no = #{opOrderNo,jdbcType=VARCHAR}, + </if> + <if test="openDt != null"> + open_dt = #{openDt,jdbcType=TIMESTAMP}, + </if> + <if test="opWaterTotalAmount != null"> + op_water_total_amount = #{opWaterTotalAmount,jdbcType=FLOAT}, + </if> + <if test="opEleTotalAmount != null"> + op_ele_total_amount = #{opEleTotalAmount,jdbcType=FLOAT}, + </if> + <if test="opMoneyRemainUser != null"> + op_money_remain_user = #{opMoneyRemainUser,jdbcType=FLOAT}, + </if> + <if test="opWaterRemainUser != null"> + op_water_remain_user = #{opWaterRemainUser,jdbcType=FLOAT}, + </if> + <if test="opType != null"> + op_type = #{opType,jdbcType=TINYINT}, + </if> + <if test="clIcCardAddr != null"> + cl_ic_card_addr = #{clIcCardAddr,jdbcType=VARCHAR}, + </if> + <if test="clIcCardNo != null"> + cl_ic_card_no = #{clIcCardNo,jdbcType=VARCHAR}, + </if> + <if test="clOrderNo != null"> + cl_order_no = #{clOrderNo,jdbcType=VARCHAR}, + </if> + <if test="startDt != null"> + start_dt = #{startDt,jdbcType=TIMESTAMP}, + </if> + <if test="endDt != null"> + end_dt = #{endDt,jdbcType=TIMESTAMP}, + </if> + <if test="clWaterTotalAmount != null"> + cl_water_total_amount = #{clWaterTotalAmount,jdbcType=FLOAT}, + </if> + <if test="clEleTotalAmount != null"> + cl_ele_total_amount = #{clEleTotalAmount,jdbcType=FLOAT}, + </if> + <if test="clMoneyRemainUser != null"> + cl_money_remain_user = #{clMoneyRemainUser,jdbcType=FLOAT}, + </if> + <if test="clWaterRemainUser != null"> + cl_water_remain_user = #{clWaterRemainUser,jdbcType=FLOAT}, + </if> + <if test="thisEle != null"> + this_ele = #{thisEle,jdbcType=FLOAT}, + </if> + <if test="thisWater != null"> + this_water = #{thisWater,jdbcType=FLOAT}, + </if> + <if test="thisMoney != null"> + this_money = #{thisMoney,jdbcType=FLOAT}, + </if> + <if test="thisDuration != null"> + this_duration = #{thisDuration,jdbcType=INTEGER}, + </if> + </set> + where id = #{id,jdbcType=BIGINT} + </update> + <update id="updateByPrimaryKey" parameterType="com.dy.pipIrrGlobal.pojoRm.RmOpenCloseHistory"> + <!--@mbg.generated--> + update rm_open_close_history + set controller_id = #{controllerId,jdbcType=BIGINT}, + intake_id = #{intakeId,jdbcType=BIGINT}, + rtu_addr = #{rtuAddr,jdbcType=VARCHAR}, + op_dt = #{opDt,jdbcType=TIMESTAMP}, + op_rtu_dt = #{opRtuDt,jdbcType=TIMESTAMP}, + op_ic_card_addr = #{opIcCardAddr,jdbcType=VARCHAR}, + op_ic_card_no = #{opIcCardNo,jdbcType=VARCHAR}, + op_order_no = #{opOrderNo,jdbcType=VARCHAR}, + open_dt = #{openDt,jdbcType=TIMESTAMP}, + op_water_total_amount = #{opWaterTotalAmount,jdbcType=FLOAT}, + op_ele_total_amount = #{opEleTotalAmount,jdbcType=FLOAT}, + op_money_remain_user = #{opMoneyRemainUser,jdbcType=FLOAT}, + op_water_remain_user = #{opWaterRemainUser,jdbcType=FLOAT}, + op_type = #{opType,jdbcType=TINYINT}, + cl_ic_card_addr = #{clIcCardAddr,jdbcType=VARCHAR}, + cl_ic_card_no = #{clIcCardNo,jdbcType=VARCHAR}, + cl_order_no = #{clOrderNo,jdbcType=VARCHAR}, + start_dt = #{startDt,jdbcType=TIMESTAMP}, + end_dt = #{endDt,jdbcType=TIMESTAMP}, + cl_water_total_amount = #{clWaterTotalAmount,jdbcType=FLOAT}, + cl_ele_total_amount = #{clEleTotalAmount,jdbcType=FLOAT}, + cl_money_remain_user = #{clMoneyRemainUser,jdbcType=FLOAT}, + cl_water_remain_user = #{clWaterRemainUser,jdbcType=FLOAT}, + this_ele = #{thisEle,jdbcType=FLOAT}, + this_water = #{thisWater,jdbcType=FLOAT}, + this_money = #{thisMoney,jdbcType=FLOAT}, + this_duration = #{thisDuration,jdbcType=INTEGER} + where id = #{id,jdbcType=BIGINT} + </update> +</mapper> \ No newline at end of file diff --git a/pipIrr-platform/pipIrr-global/src/main/resources/mapper/RmOpenCloseLastMapper.xml b/pipIrr-platform/pipIrr-global/src/main/resources/mapper/RmOpenCloseLastMapper.xml new file mode 100644 index 0000000..da66783 --- /dev/null +++ b/pipIrr-platform/pipIrr-global/src/main/resources/mapper/RmOpenCloseLastMapper.xml @@ -0,0 +1,383 @@ +<?xml version="1.0" encoding="UTF-8"?> +<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd"> +<mapper namespace="com.dy.pipIrrGlobal.daoRm.RmOpenCloseLastMapper"> + <resultMap id="BaseResultMap" type="com.dy.pipIrrGlobal.pojoRm.RmOpenCloseLast"> + <!--@mbg.generated--> + <!--@Table rm_open_close_last--> + <id column="id" jdbcType="BIGINT" property="id" /> + <result column="controller_id" jdbcType="BIGINT" property="controllerId" /> + <result column="intake_id" jdbcType="BIGINT" property="intakeId" /> + <result column="rtu_addr" jdbcType="VARCHAR" property="rtuAddr" /> + <result column="op_dt" jdbcType="TIMESTAMP" property="opDt" /> + <result column="op_rtu_dt" jdbcType="TIMESTAMP" property="opRtuDt" /> + <result column="op_ic_card_addr" jdbcType="VARCHAR" property="opIcCardAddr" /> + <result column="op_ic_card_no" jdbcType="VARCHAR" property="opIcCardNo" /> + <result column="op_order_no" jdbcType="VARCHAR" property="opOrderNo" /> + <result column="open_dt" jdbcType="TIMESTAMP" property="openDt" /> + <result column="op_water_total_amount" jdbcType="FLOAT" property="opWaterTotalAmount" /> + <result column="op_ele_total_amount" jdbcType="FLOAT" property="opEleTotalAmount" /> + <result column="op_money_remain_user" jdbcType="FLOAT" property="opMoneyRemainUser" /> + <result column="op_water_remain_user" jdbcType="FLOAT" property="opWaterRemainUser" /> + <result column="op_type" jdbcType="TINYINT" property="opType" /> + <result column="cl_ic_card_addr" jdbcType="VARCHAR" property="clIcCardAddr" /> + <result column="cl_ic_card_no" jdbcType="VARCHAR" property="clIcCardNo" /> + <result column="cl_order_no" jdbcType="VARCHAR" property="clOrderNo" /> + <result column="start_dt" jdbcType="TIMESTAMP" property="startDt" /> + <result column="end_dt" jdbcType="TIMESTAMP" property="endDt" /> + <result column="cl_water_total_amount" jdbcType="FLOAT" property="clWaterTotalAmount" /> + <result column="cl_ele_total_amount" jdbcType="FLOAT" property="clEleTotalAmount" /> + <result column="cl_money_remain_user" jdbcType="FLOAT" property="clMoneyRemainUser" /> + <result column="cl_water_remain_user" jdbcType="FLOAT" property="clWaterRemainUser" /> + <result column="this_ele" jdbcType="FLOAT" property="thisEle" /> + <result column="this_water" jdbcType="FLOAT" property="thisWater" /> + <result column="this_money" jdbcType="FLOAT" property="thisMoney" /> + <result column="this_duration" jdbcType="INTEGER" property="thisDuration" /> + </resultMap> + <sql id="Base_Column_List"> + <!--@mbg.generated--> + id, controller_id, intake_id, rtu_addr, op_dt, op_rtu_dt, op_ic_card_addr, op_ic_card_no, + op_order_no, open_dt, op_water_total_amount, op_ele_total_amount, op_money_remain_user, + op_water_remain_user, op_type, cl_ic_card_addr, cl_ic_card_no, cl_order_no, start_dt, + end_dt, cl_water_total_amount, cl_ele_total_amount, cl_money_remain_user, cl_water_remain_user, + this_ele, this_water, this_money, this_duration + </sql> + <select id="selectByPrimaryKey" parameterType="java.lang.Long" resultMap="BaseResultMap"> + <!--@mbg.generated--> + select + <include refid="Base_Column_List" /> + from rm_open_close_last + where id = #{id,jdbcType=BIGINT} + </select> + <delete id="deleteByPrimaryKey" parameterType="java.lang.Long"> + <!--@mbg.generated--> + delete from rm_open_close_last + where id = #{id,jdbcType=BIGINT} + </delete> + <insert id="insert" parameterType="com.dy.pipIrrGlobal.pojoRm.RmOpenCloseLast"> + <!--@mbg.generated--> + insert into rm_open_close_last (id, controller_id, intake_id, + rtu_addr, op_dt, op_rtu_dt, + op_ic_card_addr, op_ic_card_no, op_order_no, + open_dt, op_water_total_amount, op_ele_total_amount, + op_money_remain_user, op_water_remain_user, op_type, + cl_ic_card_addr, cl_ic_card_no, cl_order_no, + start_dt, end_dt, cl_water_total_amount, + cl_ele_total_amount, cl_money_remain_user, cl_water_remain_user, + this_ele, this_water, this_money, + this_duration) + values (#{id,jdbcType=BIGINT}, #{controllerId,jdbcType=BIGINT}, #{intakeId,jdbcType=BIGINT}, + #{rtuAddr,jdbcType=VARCHAR}, #{opDt,jdbcType=TIMESTAMP}, #{opRtuDt,jdbcType=TIMESTAMP}, + #{opIcCardAddr,jdbcType=VARCHAR}, #{opIcCardNo,jdbcType=VARCHAR}, #{opOrderNo,jdbcType=VARCHAR}, + #{openDt,jdbcType=TIMESTAMP}, #{opWaterTotalAmount,jdbcType=FLOAT}, #{opEleTotalAmount,jdbcType=FLOAT}, + #{opMoneyRemainUser,jdbcType=FLOAT}, #{opWaterRemainUser,jdbcType=FLOAT}, #{opType,jdbcType=TINYINT}, + #{clIcCardAddr,jdbcType=VARCHAR}, #{clIcCardNo,jdbcType=VARCHAR}, #{clOrderNo,jdbcType=VARCHAR}, + #{startDt,jdbcType=TIMESTAMP}, #{endDt,jdbcType=TIMESTAMP}, #{clWaterTotalAmount,jdbcType=FLOAT}, + #{clEleTotalAmount,jdbcType=FLOAT}, #{clMoneyRemainUser,jdbcType=FLOAT}, #{clWaterRemainUser,jdbcType=FLOAT}, + #{thisEle,jdbcType=FLOAT}, #{thisWater,jdbcType=FLOAT}, #{thisMoney,jdbcType=FLOAT}, + #{thisDuration,jdbcType=INTEGER}) + </insert> + <insert id="insertSelective" parameterType="com.dy.pipIrrGlobal.pojoRm.RmOpenCloseLast"> + <!--@mbg.generated--> + insert into rm_open_close_last + <trim prefix="(" suffix=")" suffixOverrides=","> + <if test="id != null"> + id, + </if> + <if test="controllerId != null"> + controller_id, + </if> + <if test="intakeId != null"> + intake_id, + </if> + <if test="rtuAddr != null"> + rtu_addr, + </if> + <if test="opDt != null"> + op_dt, + </if> + <if test="opRtuDt != null"> + op_rtu_dt, + </if> + <if test="opIcCardAddr != null"> + op_ic_card_addr, + </if> + <if test="opIcCardNo != null"> + op_ic_card_no, + </if> + <if test="opOrderNo != null"> + op_order_no, + </if> + <if test="openDt != null"> + open_dt, + </if> + <if test="opWaterTotalAmount != null"> + op_water_total_amount, + </if> + <if test="opEleTotalAmount != null"> + op_ele_total_amount, + </if> + <if test="opMoneyRemainUser != null"> + op_money_remain_user, + </if> + <if test="opWaterRemainUser != null"> + op_water_remain_user, + </if> + <if test="opType != null"> + op_type, + </if> + <if test="clIcCardAddr != null"> + cl_ic_card_addr, + </if> + <if test="clIcCardNo != null"> + cl_ic_card_no, + </if> + <if test="clOrderNo != null"> + cl_order_no, + </if> + <if test="startDt != null"> + start_dt, + </if> + <if test="endDt != null"> + end_dt, + </if> + <if test="clWaterTotalAmount != null"> + cl_water_total_amount, + </if> + <if test="clEleTotalAmount != null"> + cl_ele_total_amount, + </if> + <if test="clMoneyRemainUser != null"> + cl_money_remain_user, + </if> + <if test="clWaterRemainUser != null"> + cl_water_remain_user, + </if> + <if test="thisEle != null"> + this_ele, + </if> + <if test="thisWater != null"> + this_water, + </if> + <if test="thisMoney != null"> + this_money, + </if> + <if test="thisDuration != null"> + this_duration, + </if> + </trim> + <trim prefix="values (" suffix=")" suffixOverrides=","> + <if test="id != null"> + #{id,jdbcType=BIGINT}, + </if> + <if test="controllerId != null"> + #{controllerId,jdbcType=BIGINT}, + </if> + <if test="intakeId != null"> + #{intakeId,jdbcType=BIGINT}, + </if> + <if test="rtuAddr != null"> + #{rtuAddr,jdbcType=VARCHAR}, + </if> + <if test="opDt != null"> + #{opDt,jdbcType=TIMESTAMP}, + </if> + <if test="opRtuDt != null"> + #{opRtuDt,jdbcType=TIMESTAMP}, + </if> + <if test="opIcCardAddr != null"> + #{opIcCardAddr,jdbcType=VARCHAR}, + </if> + <if test="opIcCardNo != null"> + #{opIcCardNo,jdbcType=VARCHAR}, + </if> + <if test="opOrderNo != null"> + #{opOrderNo,jdbcType=VARCHAR}, + </if> + <if test="openDt != null"> + #{openDt,jdbcType=TIMESTAMP}, + </if> + <if test="opWaterTotalAmount != null"> + #{opWaterTotalAmount,jdbcType=FLOAT}, + </if> + <if test="opEleTotalAmount != null"> + #{opEleTotalAmount,jdbcType=FLOAT}, + </if> + <if test="opMoneyRemainUser != null"> + #{opMoneyRemainUser,jdbcType=FLOAT}, + </if> + <if test="opWaterRemainUser != null"> + #{opWaterRemainUser,jdbcType=FLOAT}, + </if> + <if test="opType != null"> + #{opType,jdbcType=TINYINT}, + </if> + <if test="clIcCardAddr != null"> + #{clIcCardAddr,jdbcType=VARCHAR}, + </if> + <if test="clIcCardNo != null"> + #{clIcCardNo,jdbcType=VARCHAR}, + </if> + <if test="clOrderNo != null"> + #{clOrderNo,jdbcType=VARCHAR}, + </if> + <if test="startDt != null"> + #{startDt,jdbcType=TIMESTAMP}, + </if> + <if test="endDt != null"> + #{endDt,jdbcType=TIMESTAMP}, + </if> + <if test="clWaterTotalAmount != null"> + #{clWaterTotalAmount,jdbcType=FLOAT}, + </if> + <if test="clEleTotalAmount != null"> + #{clEleTotalAmount,jdbcType=FLOAT}, + </if> + <if test="clMoneyRemainUser != null"> + #{clMoneyRemainUser,jdbcType=FLOAT}, + </if> + <if test="clWaterRemainUser != null"> + #{clWaterRemainUser,jdbcType=FLOAT}, + </if> + <if test="thisEle != null"> + #{thisEle,jdbcType=FLOAT}, + </if> + <if test="thisWater != null"> + #{thisWater,jdbcType=FLOAT}, + </if> + <if test="thisMoney != null"> + #{thisMoney,jdbcType=FLOAT}, + </if> + <if test="thisDuration != null"> + #{thisDuration,jdbcType=INTEGER}, + </if> + </trim> + </insert> + <update id="updateByPrimaryKeySelective" parameterType="com.dy.pipIrrGlobal.pojoRm.RmOpenCloseLast"> + <!--@mbg.generated--> + update rm_open_close_last + <set> + <if test="controllerId != null"> + controller_id = #{controllerId,jdbcType=BIGINT}, + </if> + <if test="intakeId != null"> + intake_id = #{intakeId,jdbcType=BIGINT}, + </if> + <if test="rtuAddr != null"> + rtu_addr = #{rtuAddr,jdbcType=VARCHAR}, + </if> + <if test="opDt != null"> + op_dt = #{opDt,jdbcType=TIMESTAMP}, + </if> + <if test="opRtuDt != null"> + op_rtu_dt = #{opRtuDt,jdbcType=TIMESTAMP}, + </if> + <if test="opIcCardAddr != null"> + op_ic_card_addr = #{opIcCardAddr,jdbcType=VARCHAR}, + </if> + <if test="opIcCardNo != null"> + op_ic_card_no = #{opIcCardNo,jdbcType=VARCHAR}, + </if> + <if test="opOrderNo != null"> + op_order_no = #{opOrderNo,jdbcType=VARCHAR}, + </if> + <if test="openDt != null"> + open_dt = #{openDt,jdbcType=TIMESTAMP}, + </if> + <if test="opWaterTotalAmount != null"> + op_water_total_amount = #{opWaterTotalAmount,jdbcType=FLOAT}, + </if> + <if test="opEleTotalAmount != null"> + op_ele_total_amount = #{opEleTotalAmount,jdbcType=FLOAT}, + </if> + <if test="opMoneyRemainUser != null"> + op_money_remain_user = #{opMoneyRemainUser,jdbcType=FLOAT}, + </if> + <if test="opWaterRemainUser != null"> + op_water_remain_user = #{opWaterRemainUser,jdbcType=FLOAT}, + </if> + <if test="opType != null"> + op_type = #{opType,jdbcType=TINYINT}, + </if> + <if test="clIcCardAddr != null"> + cl_ic_card_addr = #{clIcCardAddr,jdbcType=VARCHAR}, + </if> + <if test="clIcCardNo != null"> + cl_ic_card_no = #{clIcCardNo,jdbcType=VARCHAR}, + </if> + <if test="clOrderNo != null"> + cl_order_no = #{clOrderNo,jdbcType=VARCHAR}, + </if> + <if test="startDt != null"> + start_dt = #{startDt,jdbcType=TIMESTAMP}, + </if> + <if test="endDt != null"> + end_dt = #{endDt,jdbcType=TIMESTAMP}, + </if> + <if test="clWaterTotalAmount != null"> + cl_water_total_amount = #{clWaterTotalAmount,jdbcType=FLOAT}, + </if> + <if test="clEleTotalAmount != null"> + cl_ele_total_amount = #{clEleTotalAmount,jdbcType=FLOAT}, + </if> + <if test="clMoneyRemainUser != null"> + cl_money_remain_user = #{clMoneyRemainUser,jdbcType=FLOAT}, + </if> + <if test="clWaterRemainUser != null"> + cl_water_remain_user = #{clWaterRemainUser,jdbcType=FLOAT}, + </if> + <if test="thisEle != null"> + this_ele = #{thisEle,jdbcType=FLOAT}, + </if> + <if test="thisWater != null"> + this_water = #{thisWater,jdbcType=FLOAT}, + </if> + <if test="thisMoney != null"> + this_money = #{thisMoney,jdbcType=FLOAT}, + </if> + <if test="thisDuration != null"> + this_duration = #{thisDuration,jdbcType=INTEGER}, + </if> + </set> + where id = #{id,jdbcType=BIGINT} + </update> + <update id="updateByPrimaryKey" parameterType="com.dy.pipIrrGlobal.pojoRm.RmOpenCloseLast"> + <!--@mbg.generated--> + update rm_open_close_last + set controller_id = #{controllerId,jdbcType=BIGINT}, + intake_id = #{intakeId,jdbcType=BIGINT}, + rtu_addr = #{rtuAddr,jdbcType=VARCHAR}, + op_dt = #{opDt,jdbcType=TIMESTAMP}, + op_rtu_dt = #{opRtuDt,jdbcType=TIMESTAMP}, + op_ic_card_addr = #{opIcCardAddr,jdbcType=VARCHAR}, + op_ic_card_no = #{opIcCardNo,jdbcType=VARCHAR}, + op_order_no = #{opOrderNo,jdbcType=VARCHAR}, + open_dt = #{openDt,jdbcType=TIMESTAMP}, + op_water_total_amount = #{opWaterTotalAmount,jdbcType=FLOAT}, + op_ele_total_amount = #{opEleTotalAmount,jdbcType=FLOAT}, + op_money_remain_user = #{opMoneyRemainUser,jdbcType=FLOAT}, + op_water_remain_user = #{opWaterRemainUser,jdbcType=FLOAT}, + op_type = #{opType,jdbcType=TINYINT}, + cl_ic_card_addr = #{clIcCardAddr,jdbcType=VARCHAR}, + cl_ic_card_no = #{clIcCardNo,jdbcType=VARCHAR}, + cl_order_no = #{clOrderNo,jdbcType=VARCHAR}, + start_dt = #{startDt,jdbcType=TIMESTAMP}, + end_dt = #{endDt,jdbcType=TIMESTAMP}, + cl_water_total_amount = #{clWaterTotalAmount,jdbcType=FLOAT}, + cl_ele_total_amount = #{clEleTotalAmount,jdbcType=FLOAT}, + cl_money_remain_user = #{clMoneyRemainUser,jdbcType=FLOAT}, + cl_water_remain_user = #{clWaterRemainUser,jdbcType=FLOAT}, + this_ele = #{thisEle,jdbcType=FLOAT}, + this_water = #{thisWater,jdbcType=FLOAT}, + this_money = #{thisMoney,jdbcType=FLOAT}, + this_duration = #{thisDuration,jdbcType=INTEGER} + where id = #{id,jdbcType=BIGINT} + </update> + + <!--鏍规嵁闃�鎺у櫒鍦板潃鑾峰彇寮�鍏抽榾涓婃姤鏈�鏂版暟鎹�--> + <select id="getRmOpenCloseReportLast" resultType="com.dy.pipIrrGlobal.pojoRm.RmOpenCloseLast"> + select + <include refid="Base_Column_List" /> + from rm_open_close_last + where rtu_addr = #{rtuAddr} + </select> +</mapper> \ No newline at end of file diff --git a/pipIrr-platform/pipIrr-mw/pipIrr-mw-rtu/src/main/java/com/dy/rtuMw/server/rtuData/dbSv/DbSv.java b/pipIrr-platform/pipIrr-mw/pipIrr-mw-rtu/src/main/java/com/dy/rtuMw/server/rtuData/dbSv/DbSv.java index 1309936..7492484 100644 --- a/pipIrr-platform/pipIrr-mw/pipIrr-mw-rtu/src/main/java/com/dy/rtuMw/server/rtuData/dbSv/DbSv.java +++ b/pipIrr-platform/pipIrr-mw/pipIrr-mw-rtu/src/main/java/com/dy/rtuMw/server/rtuData/dbSv/DbSv.java @@ -52,6 +52,11 @@ @Autowired private RmTimingReportLastMapper rmTimingReportLastDao; // 瀹氱偣涓婃姤鏈�鏂版暟鎹瓺AO + @Autowired + private RmOpenCloseHistoryMapper rmOpenCloseHistoryDao; + @Autowired + private RmOpenCloseLastMapper rmOpenCloseLastDao; + //@Autowired //@Lazy //private DbSv sv ; @@ -263,7 +268,45 @@ this.rmOpenCloseValveHistoryMapperDao.updateByPrimaryKeySelective(po) ; } + /** + * 淇濆瓨鎺у埗鍣ㄥ紑鍏抽榾涓婃姤鏁版嵁鏈�鏂拌褰�(202404) + * @param po + */ + @Transactional(rollbackFor = Exception.class) + public void saveRmOpenCloseLast(RmOpenCloseLast po){ + this.rmOpenCloseLastDao.insert(po) ; + } + /** + * 淇濆瓨鎺у埗鍣ㄥ紑鍏抽榾涓婃姤鏁版嵁鍘嗗彶璁板綍(202404) + * @param po + */ + @Transactional(rollbackFor = Exception.class) + public void saveRmOpenCloseHistory(RmOpenCloseHistory po){ + this.rmOpenCloseHistoryDao.insert(po) ; + } + + /** + * 寰楀埌鎺у埗鍣ㄥ紑鍏抽榾涓婃姤鏁版嵁鏈�鏂拌褰�(202404) + * @param rtuAddr + * @return + */ + public RmOpenCloseLast getRmOpenCloseLast(String rtuAddr){ + List<RmOpenCloseLast> list = rmOpenCloseLastDao.getRmOpenCloseReportLast(rtuAddr); + if(list != null && list.size() > 0){ + return list.get(0) ; + } + return null ; + } + + /** + * 淇濆瓨鎺у埗鍣ㄥ紑鍏抽榾涓婃姤鏁版嵁鏈�鏂拌褰�(202404) + * @param po + */ + @Transactional(rollbackFor = Exception.class) + public void updateRmOpenCloseLast(RmOpenCloseLast po){ + this.rmOpenCloseLastDao.updateByPrimaryKeySelective(po); + } ///////////////////////////////////////////////// // diff --git a/pipIrr-platform/pipIrr-mw/pipIrr-mw-rtu/src/main/java/com/dy/rtuMw/server/rtuData/p206V202404/TkDealCloseValveReportV202404.java b/pipIrr-platform/pipIrr-mw/pipIrr-mw-rtu/src/main/java/com/dy/rtuMw/server/rtuData/p206V202404/TkDealCloseValveReportV202404.java new file mode 100644 index 0000000..43f32fe --- /dev/null +++ b/pipIrr-platform/pipIrr-mw/pipIrr-mw-rtu/src/main/java/com/dy/rtuMw/server/rtuData/p206V202404/TkDealCloseValveReportV202404.java @@ -0,0 +1,104 @@ +package com.dy.rtuMw.server.rtuData.p206V202404; + +import com.dy.common.mw.protocol.Data; +import com.dy.common.mw.protocol.p206V202404.DataV202404; +import com.dy.common.mw.protocol.p206V202404.upVos.DataCd85Vo; +import com.dy.pipIrrGlobal.pojoPr.PrController; +import com.dy.pipIrrGlobal.pojoRm.RmOpenCloseHistory; +import com.dy.pipIrrGlobal.pojoRm.RmOpenCloseLast; +import com.dy.rtuMw.server.rtuData.TaskSurpport; +import com.dy.rtuMw.server.rtuData.dbSv.DbSv; +import org.apache.logging.log4j.LogManager; +import org.apache.logging.log4j.Logger; + +/** + * @author ZhuBaoMin + * @date 2024-06-20 13:48 + * @LastEditTime 2024-06-20 13:48 + * @Description + */ +public class TkDealCloseValveReportV202404 extends TaskSurpport { + private static final Logger log = LogManager.getLogger(TkDealTimingReportV202404.class.getName()); + + //绫籌D锛屼竴瀹氫笌Tree.xml閰嶇疆鏂囦欢涓厤缃竴鑷� + public static final String taskId = "TkDealCloseValveReportV202404"; + + /** + * 鎵ц鑺傜偣浠诲姟锛氬叧闃�涓婃姤 + * + * @param data 闇�瑕佸鐞嗙殑鏁版嵁 + */ + @Override + public void execute(Object data) { + Data d = (Data) data; + DataV202404 dV202404 = (DataV202404) d.getSubData(); + Object cdObj = dV202404.subData; + if (cdObj != null) { + try { + Object[] objs = this.getTaskResults(TkPreGenObjsV202404.taskId); + DbSv sv = (DbSv) objs[0]; + PrController controller = (PrController) objs[1]; + if (cdObj instanceof DataCd85Vo) { + DataCd85Vo cdData = (DataCd85Vo) (cdObj); + this.doDeal(sv, controller, d.getRtuAddr(), dV202404, (DataCd85Vo)cdObj); + } + } catch (Exception e) { + log.error("淇濆瓨鎺у埗鍣ㄥ紑闃�鎶ユ暟鎹椂鍙戠敓寮傚父", e); + } + } + } + /** + * 澶勭悊鍏抽榾鎶ユ暟鎹� + * @param sv 鏈嶅姟 + * @param controller 鎺у埗鍣ㄥ璞� + * @param rtuAddr 鎺у埗鍣ㄥ湴鍧� + * @param dataV202404 鍗忚鏁版嵁 + * @param cdData 鍔熻兘鏁版嵁 + */ + private void doDeal(DbSv sv, PrController controller, String rtuAddr, DataV202404 dataV202404, DataCd85Vo cdData) throws Exception { + this.saveOrUpdateLast(sv, controller, rtuAddr, dataV202404, cdData); + this.saveHistory(sv, controller, rtuAddr, dataV202404, cdData); + } + + /** + * 淇濆瓨鎴栨洿鏂版帶鍒跺櫒鍏抽榾鎶ユ渶鏂版暟鎹� + * @param sv 鏈嶅姟bean + * @param controller 鎺у埗鍣ㄥ璞� + * @param rtuAddr 鎺у埗鍣ㄥ湴鍧� + * @param dataV202404 鍗忚鏁版嵁 + * @param cdData 鍔熻兘鏁版嵁 + */ + private void saveOrUpdateLast(DbSv sv, PrController controller, String rtuAddr, DataV202404 dataV202404, DataCd85Vo cdData)throws Exception { + RmOpenCloseLast po = sv.getRmOpenCloseLast(rtuAddr); + if(po == null){ + po = new RmOpenCloseLast(); + po.controllerId = controller==null?null:controller.getId(); + po.intakeId = controller==null?null:controller.getIntakeId(); + po.rtuAddr = rtuAddr; + po.valueFrom85(dataV202404, cdData); + sv.saveRmOpenCloseLast(po); + }else{ + po.controllerId = controller==null?null:controller.getId(); + po.intakeId = controller==null?null:controller.getIntakeId(); + po.valueFrom85(dataV202404, cdData); + sv.updateRmOpenCloseLast(po); + } + } + + /** + * 淇濆瓨鎺у埗鍣ㄥ叧闃�鎶ュ巻鍙叉暟鎹� + * @param sv 鏈嶅姟bean + * @param controller 鎺у埗鍣ㄥ璞� + * @param rtuAddr 鎺у埗鍣ㄥ湴鍧� + * @param dataV202404 鍗忚鏁版嵁 + * @param cdData 鍔熻兘鏁版嵁 + */ + private void saveHistory(DbSv sv, PrController controller, String rtuAddr, DataV202404 dataV202404, DataCd85Vo cdData)throws Exception { + RmOpenCloseHistory po = new RmOpenCloseHistory(); + po.controllerId = controller==null?null:controller.getId(); + po.intakeId = controller==null?null:controller.getIntakeId(); + po.rtuAddr = rtuAddr; + po.valueFrom85(dataV202404, cdData); + sv.saveRmOpenCloseHistory(po); ; + } +} diff --git a/pipIrr-platform/pipIrr-mw/pipIrr-mw-rtu/src/main/java/com/dy/rtuMw/server/rtuData/p206V202404/TkDealOpenValveReportV202404.java b/pipIrr-platform/pipIrr-mw/pipIrr-mw-rtu/src/main/java/com/dy/rtuMw/server/rtuData/p206V202404/TkDealOpenValveReportV202404.java index 18fdf20..76f11b8 100644 --- a/pipIrr-platform/pipIrr-mw/pipIrr-mw-rtu/src/main/java/com/dy/rtuMw/server/rtuData/p206V202404/TkDealOpenValveReportV202404.java +++ b/pipIrr-platform/pipIrr-mw/pipIrr-mw-rtu/src/main/java/com/dy/rtuMw/server/rtuData/p206V202404/TkDealOpenValveReportV202404.java @@ -4,6 +4,8 @@ import com.dy.common.mw.protocol.p206V202404.DataV202404; import com.dy.common.mw.protocol.p206V202404.upVos.DataCd84Vo; import com.dy.pipIrrGlobal.pojoPr.PrController; +import com.dy.pipIrrGlobal.pojoRm.RmOpenCloseHistory; +import com.dy.pipIrrGlobal.pojoRm.RmOpenCloseLast; import com.dy.rtuMw.server.rtuData.TaskSurpport; import com.dy.rtuMw.server.rtuData.dbSv.DbSv; import org.apache.logging.log4j.LogManager; @@ -54,8 +56,8 @@ * @param cdData 鍔熻兘鏁版嵁 */ private void doDeal(DbSv sv, PrController controller, String rtuAddr, DataV202404 dataV202404, DataCd84Vo cdData) throws Exception { - //this.saveOrUpdateLast(sv, controller, rtuAddr, dataV202404, cdData); - //this.saveHistory(sv, controller, rtuAddr, dataV202404, cdData); + this.saveOrUpdateLast(sv, controller, rtuAddr, dataV202404, cdData); + this.saveHistory(sv, controller, rtuAddr, dataV202404, cdData); } /** @@ -66,22 +68,22 @@ * @param dataV202404 鍗忚鏁版嵁 * @param cdData 鍔熻兘鏁版嵁 */ - //private void saveOrUpdateLast(DbSv sv, PrController controller, String rtuAddr, DataV202404 dataV202404, DataCd84Vo cdData)throws Exception { - // RmTimingReportLast po = sv.getRmTimingReportLast(rtuAddr) ; - // if(po == null){ - // po = new RmTimingReportLast(); - // po.controllerId = controller==null?null:controller.getId(); - // po.intakeId = controller==null?null:controller.getIntakeId(); - // po.rtuAddr = rtuAddr; - // po.valueFrom(dataV202404, cdData); - // sv.saveRmTimingReportLast(po) ; - // }else{ - // po.controllerId = controller==null?null:controller.getId(); - // po.intakeId = controller==null?null:controller.getIntakeId(); - // po.valueFrom(dataV202404, cdData); - // sv.updateRmTimingReportLast(po); - // } - //} + private void saveOrUpdateLast(DbSv sv, PrController controller, String rtuAddr, DataV202404 dataV202404, DataCd84Vo cdData)throws Exception { + RmOpenCloseLast po = sv.getRmOpenCloseLast(rtuAddr); + if(po == null){ + po = new RmOpenCloseLast(); + po.controllerId = controller==null?null:controller.getId(); + po.intakeId = controller==null?null:controller.getIntakeId(); + po.rtuAddr = rtuAddr; + po.valueFrom84(dataV202404, cdData); + sv.saveRmOpenCloseLast(po); + }else{ + po.controllerId = controller==null?null:controller.getId(); + po.intakeId = controller==null?null:controller.getIntakeId(); + po.valueFrom84(dataV202404, cdData); + sv.updateRmOpenCloseLast(po); + } + } /** * 淇濆瓨鎺у埗鍣ㄥ伐浣滄姤鍘嗗彶鏁版嵁 @@ -91,12 +93,12 @@ * @param dataV202404 鍗忚鏁版嵁 * @param cdData 鍔熻兘鏁版嵁 */ - //private void saveHistory(DbSv sv, PrController controller, String rtuAddr, DataV202404 dataV202404, DataCd84Vo cdData)throws Exception { - // RmTimingReportHistory po = new RmTimingReportHistory(); - // po.controllerId = controller==null?null:controller.getId(); - // po.intakeId = controller==null?null:controller.getIntakeId(); - // po.rtuAddr = rtuAddr; - // po.valueFrom(dataV202404, cdData); - // sv.saveRmTimingReportHistory(po); ; - //} + private void saveHistory(DbSv sv, PrController controller, String rtuAddr, DataV202404 dataV202404, DataCd84Vo cdData)throws Exception { + RmOpenCloseHistory po = new RmOpenCloseHistory(); + po.controllerId = controller==null?null:controller.getId(); + po.intakeId = controller==null?null:controller.getIntakeId(); + po.rtuAddr = rtuAddr; + po.valueFrom84(dataV202404, cdData); + sv.saveRmOpenCloseHistory(po); ; + } } diff --git a/pipIrr-platform/pipIrr-mw/pipIrr-mw-rtu/src/main/resources/RtuDataDealTree.xml b/pipIrr-platform/pipIrr-mw/pipIrr-mw-rtu/src/main/resources/RtuDataDealTree.xml index 891127c..50a0e54 100644 --- a/pipIrr-platform/pipIrr-mw/pipIrr-mw-rtu/src/main/resources/RtuDataDealTree.xml +++ b/pipIrr-platform/pipIrr-mw/pipIrr-mw-rtu/src/main/resources/RtuDataDealTree.xml @@ -42,6 +42,7 @@ <task id="TkDealWorkingReportV202404" name="鎺у埗鍣ㄥ伐浣滄姤(鍔熻兘鐮�80)" enable="true" class="com.dy.rtuMw.server.rtuData.p206V202404.TkDealWorkingReportV202404" /> <task id="TkDealTimingReportV202404" name="鎺у埗鍣ㄥ畾鏃朵笂鎶�(鍔熻兘鐮�83)" enable="true" class="com.dy.rtuMw.server.rtuData.p206V202404.TkDealTimingReportV202404" /> <task id="TkDealOpenValveReportV202404" name="鎺у埗鍣ㄥ紑闃�涓婃姤(鍔熻兘鐮�84)" enable="true" class="com.dy.rtuMw.server.rtuData.p206V202404.TkDealOpenValveReportV202404" /> + <task id="TkDealCloseValveReportV202404" name="鎺у埗鍣ㄥ叧闃�涓婃姤(鍔熻兘鐮�85)" enable="true" class="com.dy.rtuMw.server.rtuData.p206V202404.TkDealCloseValveReportV202404" /> </task> <!-- 璇嗗埆鍛戒护鍝嶅簲鏁版嵁 --> <task id="TkFindComResponseV202404" name="璇嗗埆鍝嶅簲鍛戒护鏁版嵁" enable="true" class="com.dy.rtuMw.server.rtuData.p206V202404.TkFindComResponseV202404"> -- Gitblit v1.8.0