From 270056c608c6ffc171e21f36740fd75c54246ba0 Mon Sep 17 00:00:00 2001 From: whyclxw <810412026@qq.com> Date: 星期四, 19 六月 2025 17:19:09 +0800 Subject: [PATCH] 电池告警参数全部导出加设备名 --- src/main/resources/mapper/BattAlmparamMapper.xml | 2 +- src/main/java/com/whyc/pojo/db_param/BattAlmparam.java | 3 +++ 2 files changed, 4 insertions(+), 1 deletions(-) diff --git a/src/main/java/com/whyc/pojo/db_param/BattAlmparam.java b/src/main/java/com/whyc/pojo/db_param/BattAlmparam.java index e710ec9..b2b10e4 100644 --- a/src/main/java/com/whyc/pojo/db_param/BattAlmparam.java +++ b/src/main/java/com/whyc/pojo/db_param/BattAlmparam.java @@ -99,4 +99,7 @@ @TableField(exist = false) private String battgroupName; + @TableField(exist = false) + private String devName; + } diff --git a/src/main/resources/mapper/BattAlmparamMapper.xml b/src/main/resources/mapper/BattAlmparamMapper.xml index 32b4ca9..b4d5e4d 100644 --- a/src/main/resources/mapper/BattAlmparamMapper.xml +++ b/src/main/resources/mapper/BattAlmparamMapper.xml @@ -35,7 +35,7 @@ </where> </select> <select id="getBattAlmParamToExport" resultType="com.whyc.pojo.db_param.BattAlmparam"> - select distinct tb_batt_almparam.*,tb_batt_inf.battgroup_name + select distinct tb_batt_almparam.*,tb_batt_inf.battgroup_name,tb_batt_inf.dev_name ,tb_station_inf.station_type,tb_station_inf.station_name,tb_station_inf.provice,tb_station_inf.city,tb_station_inf.country,tb_station_inf.full_name from db_station.tb_batt_inf,db_station.tb_station_inf,db_param.tb_batt_almparam <where> -- Gitblit v1.9.1