From f204bf028848914a219223ecd6c7d1201992a0bb Mon Sep 17 00:00:00 2001
From: didiyu <1293722656@qq.com>
Date: 星期三, 24 十月 2018 08:51:17 +0800
Subject: [PATCH] jia
---
gx_tieta/WebRoot/batt-state-statistical.jsp | 68 +++++++++++++++++++++++++++++++--
1 files changed, 63 insertions(+), 5 deletions(-)
diff --git a/gx_tieta/WebRoot/batt-state-statistical.jsp b/gx_tieta/WebRoot/batt-state-statistical.jsp
index d8b76f7..67b81f2 100644
--- a/gx_tieta/WebRoot/batt-state-statistical.jsp
+++ b/gx_tieta/WebRoot/batt-state-statistical.jsp
@@ -78,13 +78,13 @@
</table>
<table class="condi-opt">
<tr>
- <input type="hidden" id="ALM_TYPE_BTS9100S_POFF_ComError" name="" value="" class="" /> <!-- 鍋滅數 -->
- <input type="hidden" id="ALM_TYPE_BTS9100S_FADIAN_ComError" name="" value="" class="" /> <!-- 鍙戠數 -->
- <input type="hidden" id="ALM_TYPE_BTS9100S_DIAOZHAN_ComError" name="" value="" class=""> <!-- 鎺夌珯 -->
- <input type="hidden" id="ALM_TYPE_BTS9100S_DOOROPEN_ComError" name="" value="" class="" > <!-- 寮�闂紝寮�鍏崇數婧愬紓甯� -->
+ <td><input type="checkbox" id="ALM_TYPE_BTS9100S_POFF_ComError" name="" value="" class="" />鍋滅數</td> <!-- 鍋滅數 -->
+ <td><input type="checkbox" id="ALM_TYPE_BTS9100S_FADIAN_ComError" name="" value="" class="" />鍙戠數</td> <!-- 鍙戠數 -->
+ <td><input type="checkbox" id="ALM_TYPE_BTS9100S_DIAOZHAN_ComError" name="" value="" class="">鎺夌珯</td> <!-- 鎺夌珯 -->
+ <td><input type="checkbox" id="ALM_TYPE_BTS9100S_DOOROPEN_ComError" name="" value="" class="" >寮�闂ㄥ紓甯�</td> <!-- 寮�闂紝寮�鍏崇數婧愬紓甯� -->
<input type="hidden" id="ALM_TYPE_BTS9100S_TEMPUP_ComError" name="" value="" class="">
<input type="hidden" id="ALM_TYPE_BTS9100S_TEMPLOW_ComError" name="" value="" class=""> <!-- 娓╁害寮傚父 -->
- <input type="hidden" id="ALM_TYPE_BTS9100S_DAMPUP_ComError" name="" value="" class="">
+ <input type="hidden" id="ALM_TYPE_BTS9100S_DAMPUP_ComError" name="" value="" class="">
<input type="hidden" id="ALM_TYPE_BTS9100S_DAMPLOW_ComError" name="" value="" class=""> <!-- 婀垮害寮傚父 -->
</tr>
</table>
@@ -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