From 783195e48c07acdbe34e5ee6be57e5f33a44b38f Mon Sep 17 00:00:00 2001 From: cjj <Administrator@192.168.10.30> Date: 星期三, 24 十月 2018 11:51:22 +0800 Subject: [PATCH] bug --- gx_tieta/WebRoot/batt-state-statistical.jsp | 75 ++++++++++++++++++++++++++++++++++--- 1 files changed, 69 insertions(+), 6 deletions(-) diff --git a/gx_tieta/WebRoot/batt-state-statistical.jsp b/gx_tieta/WebRoot/batt-state-statistical.jsp index d8b76f7..d399e94 100644 --- a/gx_tieta/WebRoot/batt-state-statistical.jsp +++ b/gx_tieta/WebRoot/batt-state-statistical.jsp @@ -78,13 +78,16 @@ </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="" > <!-- 寮�闂紝寮�鍏崇數婧愬紓甯� --> + <input type="hidden" id="ALM_TYPE_BTS9100S_POFF_ComError" name="" value=2 class="" /> <!-- 鍋滅數 --> + <input type="hidden" id="ALM_TYPE_BTS9100S_XUHANG_ComError" name="" value=4 class=""> <!-- 鎺夌珯 --> + <input type="hidden" id="ALM_TYPE_BTS9100S_FADIAN_ComError" name="" value=8 class="" /> <!-- 鍙戠數 --> + <input type="hidden" id="ALM_TYPE_BTS9100S_DOOROPEN_ComError" name="" value=16 class="" > + <input type="hidden" id="ALM_TYPE_BTS9100S_DIAOZHAN_ComError" name="" value=32 class=""> <!-- 鎺夌珯 --> + <!-- 寮�闂紝寮�鍏崇數婧愬紓甯� --> + <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 +162,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'} @@ -229,6 +233,7 @@ record_datetime:timearr[0], record_datetime_end:timearr[1], station_event_type:0, //1:鍩虹珯鍋滅數 2:鍩虹珯缁埅 3:鍩虹珯鍙戠數 4:鍩虹珯寮�闂� 5:鍩虹珯鎺夌珯 6:鍩虹珯娓╁害涓婇檺 7:鍩虹珯娓╁害涓嬮檺 8:鍩虹珯婀垮害涓婇檺 9:鍩虹珯婀垮害涓嬮檺 + page:{ pageSize:10, //姣忛〉鐨勮鏁� pageCurr:1 //褰撳墠椤电爜鏁� @@ -251,7 +256,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); @@ -269,17 +277,72 @@ StationId: stationid?stationid:0, BattInUseDate:$('#startalm').val()+" 00:00:00", BattInUseDate1:$('#endTalm').val()+" 23:59:59", - BattGroupNum:$('#statistics').val() + BattGroupNum:$('#statistics').val(), }; //console.info(temp); return temp; } + //鐐瑰嚮鏌ヨ鎸夐挳 $('#paging .search').click(function(){ 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