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