修改基站信息

D:/workspace/chenjingjing/git/gx_tieta/gx_tieta/.gitignore

2019-01-17 ee2c6ed5cd4aaf0a2e66c96f7262a9d156a90024

 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">

@@ -39,70 +39,17 @@
        <jsp:include page="nav.jsp" flush="true"/>

       <!-- 主体内容 -->

        <div class="layui-page-container">

           <!-- 条件筛选 -->

            <div class="layui-page-filter">

                <div class="page-filter-header layui-page-filter-fweight">设备连接信息</div>

                <div class="page-filter-content">

                    <table>

                        <tr class="layui-page-filter-tbl-header layui-page-filter-fweight">

                            <td>省</td>                  <!-- 省 -->

                            <td>市</td>                  <!-- 市 -->

                             <td>区/县</td>                  <!-- 市 -->

                            <td><s:text name="Computer_name"/></td>                     <!-- 机房名称 -->

                        </tr>

                        <tr>

                            <td>

                               <div class="layui-form" lay-filter="provinceFilter">

                                  <div class="layui-form-item">

                                     <div class="layui-input-block">

                                        <select name="province" id="province" lay-filter="province">

                                    <option value="">请选择省</option>

                                 </select>

                                     </div>

                                  </div>

                               </div>

                            </td>

                            <td>

                               <div class="layui-form" lay-filter="cityFilter">

                                  <div class="layui-form-item">

                                     <div class="layui-input-block">

                                        <select name="city" id="city" lay-filter="city">

                                    <option value="">请选择市/区</option>

                                 </select>

                                     </div>

                                  </div>

                               </div>

                            </td>

                            
                             <td>

                               <div class="layui-form" lay-filter="countyFilter">

                                  <div class="layui-form-item">

                                     <div class="layui-input-block">

                                        <select name="county" id="county" lay-filter="county">

                                    <option value="">请选择区/县</option>

                                 </select>

                                     </div>

                                  </div>

                               </div>

                            </td>

                            
                            <td>

                               <div class="layui-form" lay-filter="homeFilter">

                                  <div class="layui-form-item">

                                     <div class="layui-input-block">

                                        <select name="home" id="home" lay-filter="home">

                                    <option value="">请选择机房</option>

                                 </select>

                                     </div>

                                  </div>

                               </div>

                            </td>

                        </tr>

                    </table>

                </div>

            </div>

            <!-- 页面主题内容 -->

            <div class="layui-page-content" style="position: relative;">

               <div class="tbl-filter" lay-filter="tblFilter" style="position: absolute;z-index: 891;top: 8px; left: 15px">

               <div class="layui-form layui-form-pane"  lay-filter="tblFilter">

                  设备ID：

                  <div class="layui-inline">

                      <input class="layui-input" name="id" id="devId" autocomplete="off">

                    </div>

                  <button class="layui-btn layui-btn-sm layui-btn-normal" id="searchById"><i class="fa fa-search"></i>搜索</button>

               </div>

            </div>

               <!-- 表格内容 -->

            <table id="pageTbl" lay-filter="pageTbl"></table>

            </div>

@@ -141,6 +88,7 @@
       <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;      // 获取表格模块

@@ -148,252 +96,34 @@
              var layer = layui.layer;      // 获取弹出框模块

              var element = layui.element;   // 获取元素操作模块

              

              var isNewLoad = true;

            var pre_province = getQueryString('province');

            // 查询省下拉框

            searchProvince();

            // 查询省

            var filterLoad = layer.load();

            function searchProvince() {

               // 请求后台查询

               $.ajax({

                  type:'post',

                  async:true,

                  url: 'User_battgroup_baojigroup_battgroupAction!serchStationName1InGroup',

                  data: null,

                  dataType: 'json',

                  success:function(result) {

                     var rs = JSON.parse(result.result);

                     var list = [];            // option结果集

                     var ele = $('#province');   // 目标select

                     if(rs.code == 1) {

                        var data = rs.data;

                        list.push(getLayuiSelect('请选择省/直辖市', '', {}, undefined));

                        // 遍历查询结果

                        for(var i=0; i<data.length; i++) {

                           var _data = data[i];

                           var _tmp = getLayuiSelect(_data, _data, {}, {});

                           if(pre_province == _data && isNewLoad){

                              _tmp = getLayuiSelect(_data, _data, {}, {},true);

                           }

                           list.push(_tmp);

                        }

                     }else {

                        list.push(getLayuiSelect('暂无省/直辖市', '', {}, undefined));

                     }

							
                     // 根据对象数组生成下拉列表

                     createLayuiSelect(ele, list);

                     form.render('select', 'provinceFilter');

							
                     // 查询市

                     searchCity();

                  }

               });

            }

				
            // 切换省-市

            form.on('select(province)', function(data) {

               // 查询市

               searchCity(true);

            });

				
            // 查询市

            function searchCity(isLoad) {

               // 构造查询条件

               var tmp = {

                  StationName1: $("#province").val()

               };

               var pre_city = getQueryString('city');

					
               // 是否添加等待

               if(isLoad) {

                  filterLoad = layer.load();

               }

               // 根据构造条件查询内容

               $.ajax({

                  type: 'post',

                  async: true,

                  url: 'BattInfAction!serchStationName2',

                  dataType: 'json',

                  data: "json = "+JSON.stringify(tmp),

                  success: function(result) {

                     var rs = JSON.parse(result.result);

                     var list = [];            // option结果集

                     var ele = $('#city');   // 目标select

                     if(rs.code == 1) {

                        var data = rs.data;

                        list.push(getLayuiSelect('请选择市/区', '', {}, undefined));

                        // 遍历查询结果

                        for(var i=0; i<data.length; i++) {

                           var _data = data[i];

                           var _tmp = getLayuiSelect(_data.StationName2, _data.StationName2, {}, _data);

                           if(pre_city == _data.StationName2 && isNewLoad){

                              _tmp = getLayuiSelect(_data.StationName2, _data.StationName2, {}, _data,true);

                           }

                           list.push(_tmp);

                        }

                     }else {

                        list.push(getLayuiSelect('暂无市/区', '', {}, undefined));

                     }

							
                     // 根据对象数组生成下拉列表

                     createLayuiSelect(ele, list);

                     form.render('select', 'cityFilter');

							
                     // 查询区县

                     searchCounty();

                  }

               });

            }

				
            // 切换市-区县

            form.on('select(city)', function(data) {

               // 查询区县

               searchCounty(true);

            });

				
				
            // 查询区/县

            function searchCounty(isLoad) {

               // 构造查询条件

               var tmp = {

                  StationName1: $("#province").val(),

                  StationName2: $("#city").val()

               };

               // 是否添加等待

               if(isLoad) {

                  filterLoad = layer.load();

               }

               var pre_county = getQueryString('county');

               // 根据构造条件查询内容

               $.ajax({

                  type: 'post',

                  async: true,

                  url: 'BattInfAction!serchStationName5',

                  dataType: 'json',

                  data: "json = "+JSON.stringify(tmp),

                  success: function(result) {

                     var rs = JSON.parse(result.result);

                     //console.info(rs);

                     var list = [];            // option结果集

                     var ele = $('#county');   // 目标select

                     if(rs.code == 1) {

                        var data = rs.data;

                        list.push(getLayuiSelect('请选择区/县', '', {}, undefined));

                        // 遍历查询结果

                        for(var i=0; i<data.length; i++) {

                           var _data = data[i];

                           var _tmp = getLayuiSelect(_data.StationName5, _data.StationName5, {}, _data);

                           if(pre_county ==  _data.StationName5 && isNewLoad){

                              _tmp = getLayuiSelect(_data.StationName5, _data.StationName5, {}, _data,true);

                           }

                           //console.info(_tmp);

                           list.push(_tmp);

                        }

                     }else {

                        list.push(getLayuiSelect('暂无区/县', '', {}, undefined));

                     }

							
                     // 根据对象数组生成下拉列表

                     createLayuiSelect(ele, list);

                     form.render('select', 'countyFilter');

							
                     // 查询机房

                     searchHome();

                  }

               });

            }

				
            // 切换市-区县

            form.on('select(county)', function(data) {

               // 查询区县

               searchHome(true);

            });

				
            // 查询机房

            function searchHome(isLoad) {

               // 构造查询条件

               var tmp = {

                  StationName1:$("#province").val(),

                  StationName2:$("#city").val(),

                  StationName5:$("#county").val(),

               };

               var pre_home = getQueryString('home');

               var auto_seach = false;

               // 是否添加等待

               if(isLoad) {

                  filterLoad = layer.load();

               }

               // 根据构造条件查询内容

               $.ajax({

                  type: 'post',

                  async: true,

                  url: 'BattInfAction!serchStationName3',

                  dataType: 'json',

                  data: "json = "+JSON.stringify(tmp),

                  success: function(result) {

                     var rs = JSON.parse(result.result);

                     var list = [];            // option结果集

                     var ele = $('#home');   // 目标select

                     if(rs.code == 1) {

                        var data = rs.data;

                        list.push(getLayuiSelect('请选择机房', '', {StationId: '', dev_id: ''}, undefined));

                        // 遍历查询结果

                        for(var i=0; i<data.length; i++) {

                           var _data = data[i];

                           var _attr = {

                              StationId: _data.StationId,

                              dev_id: _data.FBSDeviceId

                           };

                           var _tmp = getLayuiSelect(_data.StationName, _data.StationName3, _attr, _data);

                           if(pre_home == _data.StationName && isNewLoad){

                              _tmp = getLayuiSelect(_data.StationName, _data.StationName3, _attr, _data,true);

                              auto_seach = true;

                           }

                           list.push(_tmp);

                        }

                     }else {

                        list.push(getLayuiSelect('暂无机房', '', {}, undefined));

                     }

                     // 根据对象数组生成下拉列表

                     createLayuiSelect(ele, list);

                     form.render('select', 'homeFilter');

                     isNewLoad = false;

                     layer.close(filterLoad);

                  }

               });

            }

        		
              // 表格模块

            var tOptions = {

               elem: '#pageTbl'

               ,toolbar: false

               ,toolbar: true

               ,defaultToolbar: []

               ,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:[

                  {'break_type': 1}

               ]

               ,data:[]

               ,limit: 1000

                ,page: false

                ,height: 'full-290'

                ,height: 'full-190'

            };

            

            // 生成表格数据

            table.render(tOptions);

            

            var Page = new TblPage();

            Page.set(1, 100, 10);

            Page.set(1, 0, 10);

            //console.log(Page);

             

            // 查询后台数据

@@ -401,31 +131,102 @@
            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 = {};

                           // console.log(_data);

                           _tmp.Staionanme = _data.stationName?_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="找不到对应设备ID";break;

                  case 2:str_type="通信异常断开";break;

                  default:str_type="未知类型";

               }

               return str_type;

            }

				
            

            // 构造查询条件

            function createSearchParam() {

               var sid = $('#home').attr('stationid')?$('#home').attr('stationid'): 0;

               var temp = {

                  StationId: sid

                  FBSDeviceId: 0

                  ,page: Page.getPage()

               };

					
               // console.log(temp);

               return temp;

					
					
            }

				
            // 点击上方的设备id搜索

            $('#searchById').click(function() {

               var dev_id = $('#devId').val();

					
               // 判断数据合法新

               if(!isNumber(dev_id)) {

                  layer.msg('存在违法字符串');

               }else{

                  dev_id = dev_id.length==0?0:dev_id;

                  Page.setCurr(1);

                  // 构造查询条件

                  var temp = {

                     FBSDeviceId: dev_id

                     ,page: Page.getPage()

                  };

                  search(temp, true);

               }	
            });

				
				
            //点击查询按钮

            $('#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 +258,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);

                  }

@@ -469,7 +270,7 @@
               var value=$('#number').val();

               //当输入的数大于0时

               if(value>0){

                  if(value != Page.pageSize){

                  if(value != Page.size){

                     Page.setSize(parseInt(value));

                     Page.setCurr(1);

                  }

@@ -499,6 +300,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>