From 3eb929dbba8a3ab9c7c52300779bfa8e3c59bc55 Mon Sep 17 00:00:00 2001
From: hdw <496960745@qq.com>
Date: 星期四, 06 十二月 2018 15:28:05 +0800
Subject: [PATCH] 修订导出数据函数
---
gx_tieta/WebRoot/bts-comm-task.jsp | 130 ++++++++++++++++++++++++++++++++++++------
1 files changed, 110 insertions(+), 20 deletions(-)
diff --git a/gx_tieta/WebRoot/bts-comm-task.jsp b/gx_tieta/WebRoot/bts-comm-task.jsp
index 94769cb..33dc6cb 100644
--- a/gx_tieta/WebRoot/bts-comm-task.jsp
+++ b/gx_tieta/WebRoot/bts-comm-task.jsp
@@ -15,7 +15,7 @@
<meta http-equiv="expires" content="0">
<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
<meta http-equiv="description" content="This is my page">
- <title>璁惧杩炴帴淇℃伅</title>
+ <title><s:text name="Dev_connect_info_query"/></title> <!-- 璁惧杩炴帴淇℃伅鏌ヨ -->
<link rel="stylesheet" type="text/css" href="pages/css/base.css">
<link rel="stylesheet" type="text/css" href="jqueryui/jquery-ui.css">
<link rel="stylesheet" type="text/css" href="src/css/layui.css">
@@ -41,7 +41,7 @@
<div class="layui-page-container">
<!-- 鏉′欢绛涢�� -->
<div class="layui-page-filter">
- <div class="page-filter-header layui-page-filter-fweight">鏈烘埧绔欑偣鍗囩骇鍔熻兘</div>
+ <div class="page-filter-header layui-page-filter-fweight"><s:text name="Dev_connect_info_query"/></div> <!-- 璁惧杩炴帴淇℃伅鏌ヨ -->
<div class="page-filter-content">
<table>
<tr class="layui-page-filter-tbl-header layui-page-filter-fweight">
@@ -141,13 +141,14 @@
<script type="text/javascript" src="jqueryui/jquery-ui.min.js"></script>
<script type="text/javascript" src="src/layui.js"></script>
<script type="text/javascript" src="pages/js/mylayui.js"></script>
+ <script type="text/javascript" src="pages/js/common.js"></script>
<script type="text/javascript">
layui.use(['form', 'table', 'layer', 'element'], function() {
var table = layui.table; // 鑾峰彇琛ㄦ牸妯″潡
var form = layui.form; // 鑾峰彇琛ㄥ崟妯″潡
var layer = layui.layer; // 鑾峰彇寮瑰嚭妗嗘ā鍧�
var element = layui.element; // 鑾峰彇鍏冪礌鎿嶄綔妯″潡
-
+
var isNewLoad = true;
var pre_province = getQueryString('province');
// 鏌ヨ鐪佷笅鎷夋
@@ -371,14 +372,14 @@
,toolbar: false
,cellMinWidth: 80
,cols: [[
- {fileld: 'Staionanme', title: '鏈烘埧鍚嶇О', align: 'center', width: 380}
+ {field: 'Staionanme', title: '鏈烘埧鍚嶇О', align: 'center', width: 450}
,{field:'dev_id', title:'璁惧id', align:'center', width: 150}
,{field:'battgroup_id1', title:'鐢垫睜缁�1', align:'center', width: 150}
,{field:'battgroup_id2', title:'鐢垫睜缁�2', align:'center', width: 150}
,{field:'battgroup_id3', title:'鐢垫睜缁�3', align:'center', width: 150}
,{field:'battgroup_id4', title:'鐢垫睜缁�4', align:'center', width: 150}
,{field:'connet_time', title:'璁惧杩炴帴鏃堕棿', align:'center'}
- ,{field: 'dev_comm_runtime', title: '璁惧杩愯鏃堕暱', align: 'center'}
+ ,{field:'dev_comm_runtime', title: '璁惧杩愯鏃堕棿', align: 'center'}
,{field:'break_type_txt', title:'杩炴帴鐘舵��', align:'center', templet: '#breakTypeTpl', width: 150}
]]
,data:[
@@ -393,7 +394,7 @@
table.render(tOptions);
var Page = new TblPage();
- Page.set(1, 100, 10);
+ Page.set(1, 0, 10);
//console.log(Page);
// 鏌ヨ鍚庡彴鏁版嵁
@@ -401,31 +402,84 @@
function search(temp, newLoad) {
var load;
if(newLoad) {
- load = layer.load(1)
+ load = layer.load(1);
}
- console.log(temp);
- setTimeout(function() {
- setPageVal(Page);
- layer.close(load);
- }, 1000);
+ //console.log(temp);
+ $.ajax({
+ type:'post',
+ async:true,
+ url: 'App_bts_comm_taskAction!serchByCondition',
+ data: "json="+JSON.stringify(temp),
+ dataType: 'json',
+ success:function(result) {
+ var model = JSON.parse(result.result);
+ //console.info(model);
+ var arr_td = new Array();
+ if(model.code == 1){
+ for(var i=0;i<model.data.length;i++){
+ var _data = model.data[i];
+ var _tmp = {};
+ _tmp.Staionanme = _data.stationName;
+ _tmp.dev_id = _data.dev_id;
+ _tmp.battgroup_id1 = _data.battgroup_id1;
+ _tmp.battgroup_id2 = _data.battgroup_id2;
+ _tmp.battgroup_id3 = _data.battgroup_id3;
+ _tmp.battgroup_id4 = _data.battgroup_id4;
+ _tmp.connet_time = _data.connet_time;
+ _tmp.dev_comm_runtime = _data.dev_comm_runtime;
+ _tmp.break_type = _data.break_type;
+ _tmp.break_type_txt = createDeviceType(_data.break_type);
+ arr_td.push(_tmp);
+ Page.setAll(_data.num);
+ }
+ }
+ //console.info(tOptions);
+ tOptions.data = arr_td;
+ // 鐢熸垚琛ㄦ牸鏁版嵁
+ table.render(tOptions);
+ setPageVal(Page);
+ layer.close(load);
+ },error:function(e){
+ layer.close(load);
+ }
+ });
+
}
+
+ //鑾峰彇璁惧杩炴帴鐨勭姸鎬�
+ function createDeviceType(dev_type){
+ var str_type = "鏈煡绫诲瀷";
+ //console.info(typeof dev_type);
+ switch(dev_type){
+ case 0:str_type="鎴愬姛杩炴帴";break;
+ case 1:str_type="鎵句笉鍒板搴旇澶嘔D";break;
+ case 2:str_type="閫氫俊寮傚父鏂紑";break;
+ default:str_type="鏈煡绫诲瀷";
+ }
+ return str_type;
+ }
+
// 鏋勯�犳煡璇㈡潯浠�
function createSearchParam() {
- var sid = $('#home').attr('stationid')?$('#home').attr('stationid'): 0;
+ var sid = $('#home').find('option:selected').attr('stationid')?$('#home').find('option:selected').attr('stationid'): 0;
var temp = {
- StationId: sid
- ,page: Page.getPage()
+ StationId: sid,
+ StationName1:$('#province').attr('value'),
+ StationName2:$('#city').attr('value'),
+ StationName5:$('#county').attr('value'),
+ page: Page.getPage(),
};
-
return temp;
-
-
}
+
+ //鐐瑰嚮鏌ヨ鎸夐挳
+ $('#paging .search').click(function(){
+ search(createSearchParam(), false);
+ });
//棣栭〉
$('#page_home').click(function(){
- alert(123);
if(Page != undefined){
if(Page.curr != 1){
Page.setCurr(1);
@@ -457,7 +511,7 @@
//灏鹃〉
$('#page_last').click(function(){
if(Page != undefined){
- if(Page.pageCurr < Page.num){
+ if(Page.curr < Page.num){
Page.setCurr(Page.num);
search(createSearchParam(), true);
}
@@ -499,6 +553,42 @@
$('#total').text(page.all);
}
+ //鐐瑰嚮瀵煎嚭鎶ヨ〃
+ $('#export_table').click(function(){
+ var tblData = GLOBAL.Table.cTblData(tOptions);
+ GLOBAL.Table.expExcel.xls(tblData);
+ });
+
+ //鏋勯�犲鍑鸿〃鏍煎璞�
+ function createTableData(tOptions){
+ var thead_arr = new Array(); //琛ㄥご鏁版嵁鏁扮粍
+ var thody_arr = new Array(); //琛ㄦ牸鏁版嵁鏁扮粍
+ var proname_arr = new Array(); //灞炴�у悕鏁扮粍
+ //console.info(tOptions);
+ if(tOptions != undefined){
+ //鏋勯�犺〃澶存暟缁�
+ for(var i = 0;i< tOptions.cols.length;i++){
+ var _th = tOptions.cols[i];
+ for(var k=0;k<_th.length;k++){
+ if(_th[k].field != undefined){
+ proname_arr.push(_th[k].field);
+ thead_arr.push(_th[k].title);
+ }
+ }
+ }
+ //鏋勯�犺〃鏍煎唴閮ㄦ暟鎹暟缁�
+ for(var j = 0;j < tOptions.data.length;j++){
+ var _data = tOptions.data[j];
+ for(var k=0;k<proname_arr.length;k++){
+ thody_arr.push(_data[proname_arr[k]]);
+ }
+ }
+ }
+ return {
+ thead: [thead_arr],
+ tbody:[thody_arr]
+ }
+ }
});
</script>
</body>
--
Gitblit v1.9.1