From acf7627f5c57d62fd7d93dd9794911c6e7b4e42f Mon Sep 17 00:00:00 2001
From: 81041 <81041@192.168.10.28>
Date: 星期五, 19 十月 2018 14:15:51 +0800
Subject: [PATCH] Merge branch 'dev_lxw' of https://whyclxw1@gitlab.com/whyclxw1/gx_tieta.git into dev_lxw
---
gx_tieta/WebRoot/batt-state-statistical.jsp | 58 ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
1 files changed, 58 insertions(+), 0 deletions(-)
diff --git a/gx_tieta/WebRoot/batt-state-statistical.jsp b/gx_tieta/WebRoot/batt-state-statistical.jsp
index d8b76f7..bbde297 100644
--- a/gx_tieta/WebRoot/batt-state-statistical.jsp
+++ b/gx_tieta/WebRoot/batt-state-statistical.jsp
@@ -159,6 +159,7 @@
,{field:'station_event_type_fadian', title:'鍙戠數娆℃暟', align:'center'}
,{field:'station_event_type_diaozhan', title:'鎺夌珯娆℃暟', align:'center'}
,{field:'station_event_type_dooropen', title:'寮�闂ㄥ紓甯告鏁�', align:'center'}
+ ,{field:'station_event_type_xuhang', title:'缁埅娆℃暟', align:'center'}
,{field:'station_event_type_tempup', title:'娓╁害涓婇檺鍛婅', align:'center'}
,{field:'station_event_type_templow', title:'娓╁害涓嬮檺鍛婅', align:'center'}
,{field:'station_event_type_dampup', title:'婀垮害涓婇檺鍛婅', align:'center'}
@@ -251,7 +252,10 @@
success:function(data){
var data=JSON.parse(data.result);
if(data.code==1&&data!=null){
+ //console.log(data.data);
tOptions.data = data.data;
+ }else {
+ tOptions.data = [];
}
table.render(tOptions);
@@ -280,6 +284,60 @@
serachBattStatistical();
});
+ // 鐐瑰嚮瀵煎嚭鎸夐挳
+ $('#export_table').click(function() {
+ var thead = [
+ '鍛婅鏃堕棿娈�', '鏈烘埧鍚嶇О', '鍋滅數娆℃暟', '鍙戠數娆℃暟', '鎺夌珯娆℃暟', '寮�闂ㄥ紓甯告鏁�',
+ '缁埅娆℃暟', '娓╁害涓婇檺鍛婅', '娓╁害涓嬮檺鍛婅','婀垮害涓婇檺鍛婅', '婀垮害涓嬮檺鍛婅'
+ ];
+ var tbody = getExportData(tOptions.data);
+ if(tbody.length == 0) {
+ layer.msg('娌℃湁鏁版嵁瀵煎嚭锛侊紒锛�');
+ return;
+ }
+ // 寮瑰嚭瀵煎嚭妗�
+ layer.open(
+ {
+ title: '瀵煎嚭琛ㄦ牸'
+ ,icon: '6'
+ ,btn:['瀵煎嚭xls', '瀵煎嚭csv', '鍙栨秷']
+ ,content: '閫夋嫨瀵煎嚭鏍煎紡'
+ ,yes: function(index) {
+ table.exportFile(thead, tbody, 'xls');
+ layer.close(index);
+ }
+ ,btn2: function(index) {
+ table.exportFile(thead, tbody, 'cvs');
+ layer.close(index);
+ }
+ }
+ );
+ });
+
+ // 鑾峰彇瀵煎嚭琛ㄦ牸鍐呭鏁扮粍
+ function getExportData(data) {
+ var rs = [];
+ // 寰幆閬嶅巻鑾峰彇鏁版嵁
+ for(var i=0;i<data.length;i++) {
+ var _data = data[i];
+ var tmp = [];
+ tmp.push(_data.note); // 鍛婅鏃堕棿娈�
+ tmp.push(_data.stationName); // 鏈烘埧鍚嶇О
+ tmp.push(_data.station_event_type_poff); // 鍋滅數娆℃暟
+ tmp.push(_data.station_event_type_fadian); // 鍙戠數娆℃暟
+ tmp.push(_data.station_event_type_diaozhan); // 鎺夌珯娆℃暟
+ tmp.push(_data.station_event_type_dooropen); // 寮�闂ㄦ鏁�
+ tmp.push(_data.station_event_type_xuhang); // 缁埅娆℃暟
+ tmp.push(_data.station_event_type_tempup); // 娓╁害涓婇檺
+ tmp.push(_data.station_event_type_templow); // 娓╁害涓嬮檺
+ tmp.push(_data.station_event_type_dampup); // 婀垮害涓婇檺
+ tmp.push(_data.station_event_type_damplow); // 婀垮害涓嬮檺
+
+ rs.push(tmp);
+ }
+
+ return rs;
+ }
});
--
Gitblit v1.9.1