Merge branch 'dev_lxw' of https://whyclj@gitlab.com/whyclxw1/gx_tieta.git i...

LiJun

2018-11-26 a6b4c1e19b3b3fdcf80d7f69f20fe406205fcf8f

Merge branch 'dev_lxw' of https://whyclj@gitlab.com/whyclxw1/gx_tieta.git into dev_lxw

 gx_tieta/WebRoot/control.jsp

@@ -264,6 +264,11 @@
                                    <span class="whyc-btn-icon fa fa-signal"></span>

                                    <span class="whyc-btn-txt">信号质量</span>

                                </a>

                                <br>

                                <a href="javascript:void(0);" id="threadInfo" class="whyc-btn whyc-btn-disabled" id="specialGraphExport">

                                    <span class="whyc-btn-icon fa fa-desktop"></span>

                                    <span class="whyc-btn-txt">设备进程</span>

                                </a>

                            </div>

                        </div>

                    </div>

@@ -4969,6 +4974,86 @@
                //console.info(rs);

                return rs;

            }

			
            // 设备进程显示

            var threadInfoSearch = {

                num: gprs.threadinfo,

                dev_id:910000001 
            };

			
            // 点击设备进程按钮

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

                console.log(threadInfoSearch);

                SendDeviceThreadInfo(threadInfoSearch,function(data){

                    searchDeviceThreadInfo({dev_id:910000001});

                });

            });

			
			
			
			
            //给GPRS发送指定的命令，获取AT返回值

            function SendDeviceThreadInfo(param,callback){

                $.ajax({ 	
                    type:"post", 								
                    url: "Bts_gprs_stateAction_action_update_bts_task_inf",						
                    async:true,				
                    dataType:'json',

                    data:'json='+JSON.stringify(param),		
                    success: function(data){ 
                        var model = eval('('+data.result+')');

                        console.info(model);

                        if(callback && typeof callback == 'function'){

                            callback(model);

                        }

                    },error:function(e){

                        var model = {

                            code:0,

                            data:e,

                            msg:'通信失败'

                        };

                        if(callback && typeof callback == 'function'){

                            callback(model);

                        }

                    } 				
                });

            }

			
            //查询设备的进程信息

            function searchDeviceThreadInfo(param,callback){

                $.ajax({ 	
                    type:"post", 								
                    url: "Bts_gprs_stateAction_action_serchByCondition",						
                    async:true,				
                    dataType:'json',

                    data:'json='+JSON.stringify(param),		
                    success: function(data){ 
                        var model = eval('('+data.result+')');

                        console.info(model);

                        var btsTaskInf = model.data[0].bts_task_inf;

                        layer.open({

                            title: '设备进程',

                            width: 380,

                            height: 450,

                            content: '<pre>'+btsTaskInf+'</pre>'

                        });

						
                        if(callback && typeof callback == 'function'){

                            callback(model);

                        }

                    },error:function(e){

                        var model = {

                            code:0,

                            data:e,

                            msg:'通信失败'

                        };

                        if(callback && typeof callback == 'function'){

                            callback(model);

                        }

                    } 				
                });

            }

			
        });

        

        // 机历卡模块


 gx_tieta/WebRoot/index.jsp

@@ -1582,28 +1582,42 @@
    

    // 普通机房描述

    function mapImgDescNormal(iconExplain) {

        // 机房落后

        // 落后机房

        var iconList = $('<div class="explain-list" style="padding: 4px 6px; border-bottom: 1px slid #ccc; display:block"></div>');

        var input = $('<input type="checkbox" data-img="item-behind" checked="checked">');

        var span = $('<span>电池落后机房</span>');

        var icon = $('<img src="'+mapImages.behind+'">');

        var span = $('<span>电池组落后机房</span>');

        var badge = $('<a href="javascript:;" class="layui-badge-rim mrr8 badge-behind">0</a>');

        iconList.append(input);

        iconList.append(span);

        iconList.append(icon);

        iconList.append(badge);

        iconExplain.append(iconList);

        

        // 机房告警

        // 告警机房

        var iconList = $('<div class="explain-list" style="padding: 4px 6px; border-bottom: 1px slid #ccc; display:block"></div>');

        var input = $('<input type="checkbox" data-img="item-warn" checked="checked">');

        var span = $('<span>电池告警机房</span>');

        var icon = $('<img src="'+mapImages.warn+'">');

        var span = $('<span>电池组告警机房</span>');

        var badge = $('<a href="javascript:;" class="layui-badge-rim mrr8 badge-warn">0</a>');

        iconList.append(input);

        iconList.append(span);

        iconList.append(icon);

        iconList.append(badge);

        iconList.append('<div class="clear"></div>');

        iconExplain.append(iconList);

        

		
        // 掉站机房

        var iconList = $('<div class="explain-list" style="padding: 4px 6px; border-bottom: 1px slid #ccc; display:block"></div>');

        var input = $('<input type="checkbox" data-img="item-down" checked="checked">');

        var icon = $('<img src="'+mapImages.timeout+'">');

        var span = $('<span>掉站机房</span>');

        var badge = $('<a href="javascript:;" class="layui-badge-rim mrr8 badge-down">0</a>');

        iconList.append(input);

        iconList.append(span);

        iconList.append(icon);

        iconList.append(badge);

        //iconExplain.append(iconList);

        

        // 机房延时

        var iconList = $('<div class="explain-list" style="padding: 4px 6px; border-bottom: 1px slid #ccc; display:block"></div>');

@@ -1613,16 +1627,18 @@
        iconList.append(input);

        iconList.append(span);

        iconList.append(icon);

        iconExplain.append(iconList);

        //iconExplain.append(iconList);

        

        // 停电机房

        var iconList = $('<div class="explain-list" style="padding: 4px 6px; border-bottom: 1px slid #ccc; display:block"></div>');

        var input = $('<input type="checkbox" data-img="item-poff" checked="checked">');

        var icon = $('<img src="'+mapImages.powercut+'">');

        var span = $('<span>停电机房</span>');

        var badge = $('<a href="javascript:;" class="layui-badge-rim mrr8 badge-powercut">0</a>');

        iconList.append(input);

        iconList.append(span);

        iconList.append(icon);

        iconList.append(badge);

        iconExplain.append(iconList);

        

        // 正常机房

@@ -1630,12 +1646,40 @@
        var input = $('<input type="checkbox" data-img="item-normal" checked="checked">');

        var icon = $('<img src="'+mapImages.normal+'">');

        var span = $('<span>正常机房</span>');

        var badge = $('<a href="javascript:;" class="layui-badge-rim mrr8 badge-normal">0</a>');

        iconList.append(input);

        iconList.append(span);

        iconList.append(icon);

        iconList.append(badge);

        iconExplain.append(iconList);

		
        // 续航不足3小时机房

        var iconList = $('<div class="explain-list" style="padding: 4px 6px; border-bottom: 1px slid #ccc; display:block"></div>');

        var input = $('<input type="checkbox" data-img="item-weak" checked="checked">');

        var icon = $('<img src="'+mapImages.normal+'">');

        var span = $('<span>续航不足3小时机房</span>');

        var badge = $('<a href="javascript:;" class="layui-badge-rim mrr8 badge-weak">0</a>');

        iconList.append(input);

        iconList.append(span);

        iconList.append(icon);

        iconList.append(badge);

        //iconExplain.append(iconList);

		
		
    }

    

    // 更新地图图标badge的值

    function updateMapIconBadge() {

        var mapImgDesc = $('#mapImgDesc');

        var behind = mapImgDesc.find('.badge-behind');        // 电池落后机房

        var warn = mapImgDesc.find('.badge-warn');            // 电池告警机房

        var down = mapImgDesc.find('.badge-down');            // 掉站机房

        var powercut = mapImgDesc.find('.badge-powercut');    // 停电机房

        var normal = mapImgDesc.find('.badge-normal');        // 正常机房

        var weak = mapImgDesc.find('.badge-weak');            // 续航不足3小时机房

    }

	
	
    // 61850描述

    function mapImgDesc61850(iconExplain) {

        // 核容/停电放电


 gx_tieta/WebRoot/mobil/batt-state-statistical.html

New file
@@ -0,0 +1,555 @@
<!DOCTYPE html>

<html lang="en">

<head>

    <meta charset="UTF-8">

    <title>机房历史事件查询</title>

    <meta name="viewport" content="width=device-width,initial-scale=1">

    <meta name="apple-mobile-web-app-capable" content="yes">

    <meta name="apple-mobile-web-app-status-bar-style" content="black">

    <link rel="stylesheet" href="mobilCss/jquery.mobile-1.4.5.min.css"/>

    <link href="mobilCss/mobiscroll.core-2.5.2.css" rel="stylesheet" type="text/css" />

    <link href="mobilCss/mobiscroll.animation-2.5.2.css" rel="stylesheet" type="text/css" />

    <link rel="stylesheet" type="text/css" href="css/tbl.css">

    <script type="text/javascript" src="mobilJs/jquery-1.8.2.js"></script>

    <script type="text/javascript" src="mobilJs/jquery.mobile-1.4.5.min.js"></script>

    <style type="text/css">

		
        /*规定面板的样式*/

        .ui-panel {

            width: 80%;

        }

        .ui-panel-dismiss{

            width: 20%;

        }

        .ui-panel-inner{

            padding:0 !important;

        }

        .ui-collapsible-heading-toggle{

            padding-left: 1em !important;

        }

        .panel-header{

            padding: 8px 0;

            font-size: 1.2em;

            text-indent: 1em;

            background-color: #DFDCDC;

        }

        /*规定开关的位置*/

        .ui-flipswitch {

            margin-left: 0.5em;

        }

		
        .ui-field-contain{

            padding: 0 0.6em ;

        }

        .ui-field-contain {

            border-bottom-color: #828282;

            border-bottom-color: rgba(0,0,0,.15);

            border-bottom-width: 1px;

            border-bottom-style: none;

        }

        .sicon{ 
            display:inline-block;width:4%;margin:1em 0;float:left; 
        }

        .checkdata{

             display:inline-block;width:48%;margin:0 0 0 0;float:left; 
         }

	     
         .next-page, .pre-page {

            position: fixed;

            width: 40px;

            height: 40px;

            top: 50%;

            margin-top: -15px;

        }

        .next-page  {

            right: 0;

        }

        .pre-page  {

            left: 0;

        }

	     
       
        table {

            margin-top:.5em;

            border-collapse:separate; 
            border-spacing:0 .5em;

        }

		
        tbody tr td{

            overflow: hidden;

            text-overflow:ellipsis;

            white-space: nowrap;

        }

    </style>

    <link rel="stylesheet" href="css/fgpanel.css">

</head>

<body>

    <div data-role="page">

        <div class="fg-panel">

            <form>

                <div class="fg-panel-header">筛选</div>

                <div class="fg-panel-content">

                    <fieldset data-role="controlgroup">

                         <p>省</p>

                        <select id="mainteArea" data-mini="true">

                          <option value="">全部</option>

                          <option value="">一枢纽</option>

                          <option value="">二枢纽</option>

                          <option value="">枢纽楼</option>

                        </select>

                        <p>市</p>

                        <select id="city" data-mini="true">

                            <option value="">全部</option>

                        </select>

                        <p>区/县</p>

                        <select id="country" data-mini="true">

                            <option value="">全部</option>

                        </select>

                         <p>机房站点</p>

                        <select id="homeName" data-mini="true">

                            <option value="">全部</option>

                        </select>

                        <p>统计方式</p>

                        <select id="" data-mini="true">

                            <option value="">按年统计</option>

                            <option value="">按月统计</option>

			            	
                        </select>

                         <p>时间</p>

                         <div class="checkdata">

                            <input id="startTestrecord"  type="text" name="appDate" class="appDatefir"  value="2000-01-01" />

                        </div>

                        <span class="sicon">&macr;</span>

                        <div class="checkdata">

                            <input id="endTestrecord" type="text" name="appDate" class="appDatesec"  value="2017-01-01" />

                        </div>

						
                    </fieldset>

                </div>

                <div class="fg-panel-btn">

                    <a href="javascript:panel.hide(true);" id="submit" data-role="button" class="ui-btn ui-mini ui-btn-b ui-shadow">确定</a>

                </div>

            </form>

        </div>

        <!-- 头部内容 -->

        <div data-role="header" data-position="fixed">

            <a href="count-report.html" target="_top" class="ui-btn ui-corner-all ui-shadow ui-icon-back ui-btn-icon-left" style="padding-top: 0.7em; padding-bottom: 0.7em;">返回</a>

            <h1>机房历史事件查询</h1>

            <a href="javascript:panel.show();" class="ui-btn ui-corner-all ui-shadow ui-icon-grid ui-btn-icon-left" style="padding-top: 0.7em; padding-bottom: 0.7em;" id="screen">筛选</a>

        </div>

        <!-- 主体内容 -->

        <div data-role="main">

            <div class="pre-page"><a href="#" class="ui-btn ui-corner-all ui-icon-carat-l ui-btn-icon-notext">图标</a></div>

            <div class="next-page"><a href="#" class="ui-btn ui-corner-all ui-icon-carat-r ui-btn-icon-notext">图标</a></div>	
            <!-- 表格容器 -->

            <div class="tbl-container"></div>

            <table data-role="table" class="ui-responsive ui-shadow" id="tab" >

					
            </table>

        </div>

    </div>

</body>



<script src="mobilJs/mobiscroll.core-2.5.2.js" type="text/javascript"></script>

<script src="mobilJs/mobiscroll.core-2.5.2-zh.js" type="text/javascript"></script>

<script src="mobilJs/mobiscroll.datetime-2.5.1.js" type="text/javascript"></script>

<script src="mobilJs/mobiscroll.datetime-2.5.1-zh.js" type="text/javascript"></script>

<script type="text/javascript" src="js/tbl.js"></script>

<script type="text/javascript" src="mobilJs/base.js"></script>

<script type="text/javascript" src="js/panel.js"></script>

<script type="text/javascript">	
    $(function () {

        setTimes($("#startTestrecord"),'2000-01-01');

        setTimes($("#endTestrecord"),new Date().format('yyyy-MM-dd'));

		
    });

</script> 
 <script type="text/javascript">  
    $('document').ready(function(){panel.show();});    
 
    var arr=new Array();        //当前表格td数据

    var Page = {

        pageSize:10,                 //每页的行数

        pageCurr:1,                  //当前页码数

        pageAll:0,

    };

	
    var arrTh = ['告警时间段', '机房名称', '停电次数', '发电次数','掉站次数','开门异常次数','续航次数','温度上限告警','温度下限告警','湿度上限告警','湿度下限告警','详情'];

    dataArr = [];

    var startTime = "1980-01-01";

    var endTime = new Date().format('yyyy-MM-dd');

    var tbl = $('.tbl-container');

    createTbl(tbl, arrTh, dataArr);

    $(document).ready(function(){

        setPage();

        $("#submit").click(function(){

            Page.pageCurr=1;

            searchBadBatt();

        });

     });

	
     //查询电池信息

     function searchBadBatt(){

         loadshow();

         var stationid = $("#station_name").find('option:selected').attr('stationid')?$("#station_name").find('option:selected').attr('stationid'):'';

        var temp = createSearchForm();

        console.info(stationid);

        /*var temp = {

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

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

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

            StationName: $("#station_name").val(),

            StationId: stationid

        };*/

        //console.info(temp);

         var json = JSON.stringify(temp);

         //console.info(json);

        arrTd = new Array();

        $.post("Batt_Maint_DealarmAction_serchByConditionNew","result="+json,function(data){

            data=eval("("+data.result+")");

            //console.info(data);

            if(data.code==1 && data.data.length>0){

                data=data.data;

                //console.info(data);					
                arr=new Array();

                index=0;

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

                    Page.pageAll=data[i].Size;

                    arr[index++]=data[i].BattGroupId;                //电池组id

                    arr[index++]=data[i].StationName;                //机房名称

                    arr[index++]=data[i].StationIp;                    //机房IP

                    arr[index++]=data[i].BattGroupName;    //电池组名称

                    arr[index++]=data[i].BattGroupNum;                //电池组序号

					
					
                }

               //console.info(Page);

               createTbl(tbl, arrTh, arr);

	          
            }else{

                $('#searchNull').popup('open');

                Page.pageAll = 0;

            }

            setPage();

            //console.info(Page);

            loadclose();     
        }).error(function(){

            loadclose();

            $('#searchErr').popup('open');

        });

	 
     }





	
    function createSearchForm(){

        var temp={

            page:{

                pageCurr:Page.pageCurr,

                pageSize:Page.pageSize,

            },

            binf:{

                StationName1:$('#mainteArea').val(),

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

                StationName5:$('#country').val(),

                StationName:$('#homeName').val(),

				
            },

			
            tdata:{	
				
                record_time:$('#startTestrecord').val(),           //电池测试记录时间段

                record_time1:$('#endTestrecord').val()  
				
            }

			
        };

        return temp;

    }

    // stringify(createSearchForm());

    //页面加载时查询省

    $.post("BattInfAction_serchByStation",null,function(data){

        data = data.result;

        data = eval("("+data+")");

        //console.info(data);

        //console.info(data.code);

        if(data.code==1&&data.data.length>0){

               var $Ostation_name1=$("#mainteArea");

            $Ostation_name1.text("");

            var arr = new Array();

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

            {

                   if(i == 0){

                       arr.push({

                           val:"",

                           txt:"全部(共"+data.sum+"个)",

                       });

                   }else{

                       arr.push({

                           val:data.data[i-1].StationName1,

                           txt:data.data[i-1].StationName1,

                       });

                   }

            }

            updataSel($Ostation_name1, arr);

        }

         findCity();

    });



  
//当省改变时更新市

    function findCity(){

        var data = {

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

        };

        //console.info(data);

        // 请求获取当前省下的市

        $.ajax({ 	
            type: "post", 				
            url: "BattInfAction!serchStationName2",				
            async:true,				
            dataType:'json',

            data:"json = "+JSON.stringify(data),	
            success: function(data){

            data = data.result;

            data = eval("("+data+")");

            //console.info(data);

            //console.info(data.code);	   
            if(data.code==1&&data.data.length>0){

                   var $Ostation_name1=$("#city");

                $Ostation_name1.text("");

                var arr = new Array();

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

                {

                       if(i == 0){

                           arr.push({

                               val:"",

                               txt:"全部(共"+data.data.length+"个)",

                           });

                       }else{

                           arr.push({

                               val:data.data[i-1].StationName2,

                               txt:data.data[i-1].StationName2,

                           });

                       }

                }

                updataSel($Ostation_name1, arr);

            }

             findCounty();

        }

        });

    }

	
//当市改变时更新区/县

    function findCounty(){

        var data = {

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

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

        };

        //console.info(data);

        $.ajax({ 	
            type: "post", 				
            url: "BattInfAction!serchStationName5",				
            async:true,				
            dataType:'json',

            data:"json = "+JSON.stringify(data),	
            success: function(data){

            data = data.result;

            data = eval("("+data+")");

            //console.info(data);

            //console.info(data.code);	   
            if(data.code==1&&data.data.length>0){

                   var $Ostation_name1=$("#country");

                $Ostation_name1.text("");

                var arr = new Array();

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

                {

                       if(i == 0){

                           arr.push({

                               val:"",

                               txt:"全部(共"+data.data.length+"个)",

                           });

                       }else{

                           arr.push({

                               val:data.data[i-1].StationName5,

                               txt:data.data[i-1].StationName5,

                           });

                       }

                }

                updataSel($Ostation_name1, arr);

            }

          findStationNamebyStationname1();   
        }

        });

    }

  
 //当区县更新时更新机房  
    function findStationNamebyStationname1(){

        var data = {

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

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

            StationName5:$("#country").val()

        };

        //console.info(data);

        $.ajax({ 	
            type: "post", 				
            url: "BattInfAction!serchStationName3",				
            async:true,				
            dataType:'json',

            data:"json = "+JSON.stringify(data),	
            success: function(data){

            data = data.result;

            data = eval("("+data+")");

            //console.info(data);

            //console.info(data.code);	   
            if(data.code==1&&data.data.length>0){

                   var $Ostation_name1=$("#homeName");

                $Ostation_name1.text("");

                var arr = new Array();

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

                {

                       if(i == 0){

                           arr.push({

                               val:"",

                               stationid:"",

                               txt:"全部(共"+data.data.length+"个)",

                           });

                       }else{

                           arr.push({

                               val:data.data[i-1].StationName3,

                               stationid:data.data[i-1].StationId,

                               txt:data.data[i-1].StationName3,

                           });

                       }

                }

                //console.info(111111111111111);

                updataSelStation($Ostation_name1, arr);

            }

	       
            findserchByBattGroupNamebystationname(); 
        }

        });

    }

 
 //根据机房获取电池组   
     function findserchByBattGroupNamebystationname(){

        var stationid = $("#station_name").find('option:selected').attr('stationid')?$("#station_name").find('option:selected').attr('stationid'):'';

	
        var data = {

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

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

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

            StationName: $("#homeName").val(),

            StationId: stationid

        };

		
        //console.info(data);

        $.ajax({ 	
            type: "post", 				
            url: "BattInfAction!serchBattByStation",				
            async:true,				
            dataType:'json',

            data:"json = "+JSON.stringify(data),	
            success: function(data){

            data = data.result;

            data = eval("("+data+")");

            //console.warn();

            //console.info(data);

            //console.info(data.code);	   
            if(data.code==1&&data.data.length>0){

                   var $Ostation_name1=$("#battgroup_name");

                $Ostation_name1.text("");

                var arr = new Array();

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

                {

                       if(i == 0){

                           arr.push({

                               val:0,

                               txt:"全部(共"+data.data.length+"个)",

                           });

                       }else{

                           arr.push({

                               val:data.data[i-1].BattGroupId,

                               txt:data.data[i-1].BattGroupName,

                           });

                       }

                }

                updataSel($Ostation_name1, arr);

            }

	         
        }

        });

    }

    
   //当省改变时更新市

   $('#mainteArea').change(function(){

           findCity();	
   });

   //当市改变时改变区/县

   $('#city').change(function(){

           findCounty();	
   });

   //当区/县改变时改变机房

   $('#country').change(function(){

           findStationNamebyStationname1(); 	
   });   	
    //当机房改变时，更新电池组	
    $('#homeName').change(function(){

        findserchByBattGroupNamebystationname();

    });

		
	
		
    $(function() {

        //点击上一页

        $('.pre-page').on('click', 'a', function() {

            if(Page.pageCurr>1){

                Page.pageCurr = Page.pageCurr - 1;

                searchBadBatt();

            }

        });

		
        //点击下一页

        $('.next-page').on('click', 'a', function() {

            var pageNum = Math.ceil(Page.pageAll/Page.pageSize);

            if(Page.pageCurr<pageNum){

                Page.pageCurr = Page.pageCurr + 1;

                searchBadBatt();

            }

        });

    });

	
	
    // 判断是否显示翻页按钮

    function setPageTurning(isShowPre, isShowNext) {

        if(isShowPre) {    // 判断是否显示向上翻页按钮

            $('.pre-page').show();

        }else {

            $('.pre-page').hide();

        }



        if(isShowNext) {    // 判断是否显示向下翻页按钮

            $('.next-page').show();

        }else {

            $('.next-page').hide();

        }

    }					
	
    //设置页面的跳转链接

    function setPage(){

        if(Page.pageCurr <= 1){

            $('.pre-page').hide();

        }else{

            $('.pre-page').show();

        }

        var pageNum = Math.ceil(Page.pageAll/Page.pageSize);

		
        if(Page.pageCurr < pageNum){

            $('.next-page').show();

        }else{

            $('.next-page').hide();

        }

		
    }

   </script>

</html> 

 gx_tieta/WebRoot/mobil/batt-traffic-statistics.html

New file
@@ -0,0 +1,555 @@
<!DOCTYPE html>

<html lang="en">

<head>

    <meta charset="UTF-8">

    <title>设备流量统计查询</title>

    <meta name="viewport" content="width=device-width,initial-scale=1">

    <meta name="apple-mobile-web-app-capable" content="yes">

    <meta name="apple-mobile-web-app-status-bar-style" content="black">

    <link rel="stylesheet" href="mobilCss/jquery.mobile-1.4.5.min.css"/>

    <link href="mobilCss/mobiscroll.core-2.5.2.css" rel="stylesheet" type="text/css" />

    <link href="mobilCss/mobiscroll.animation-2.5.2.css" rel="stylesheet" type="text/css" />

    <link rel="stylesheet" type="text/css" href="css/tbl.css">

    <script type="text/javascript" src="mobilJs/jquery-1.8.2.js"></script>

    <script type="text/javascript" src="mobilJs/jquery.mobile-1.4.5.min.js"></script>

    <style type="text/css">

		
        /*规定面板的样式*/

        .ui-panel {

            width: 80%;

        }

        .ui-panel-dismiss{

            width: 20%;

        }

        .ui-panel-inner{

            padding:0 !important;

        }

        .ui-collapsible-heading-toggle{

            padding-left: 1em !important;

        }

        .panel-header{

            padding: 8px 0;

            font-size: 1.2em;

            text-indent: 1em;

            background-color: #DFDCDC;

        }

        /*规定开关的位置*/

        .ui-flipswitch {

            margin-left: 0.5em;

        }

		
        .ui-field-contain{

            padding: 0 0.6em ;

        }

        .ui-field-contain {

            border-bottom-color: #828282;

            border-bottom-color: rgba(0,0,0,.15);

            border-bottom-width: 1px;

            border-bottom-style: none;

        }

        .sicon{ 
            display:inline-block;width:4%;margin:1em 0;float:left; 
        }

        .checkdata{

             display:inline-block;width:48%;margin:0 0 0 0;float:left; 
         }

	     
         .next-page, .pre-page {

            position: fixed;

            width: 40px;

            height: 40px;

            top: 50%;

            margin-top: -15px;

        }

        .next-page  {

            right: 0;

        }

        .pre-page  {

            left: 0;

        }

	     
       
        table {

            margin-top:.5em;

            border-collapse:separate; 
            border-spacing:0 .5em;

        }

		
        tbody tr td{

            overflow: hidden;

            text-overflow:ellipsis;

            white-space: nowrap;

        }

    </style>

    <link rel="stylesheet" href="css/fgpanel.css">

</head>

<body>

    <div data-role="page">

        <div class="fg-panel">

            <form>

                <div class="fg-panel-header">筛选</div>

                <div class="fg-panel-content">

                    <fieldset data-role="controlgroup">

                         <p>省</p>

                        <select id="mainteArea" data-mini="true">

                          <option value="">全部</option>

                          <option value="">一枢纽</option>

                          <option value="">二枢纽</option>

                          <option value="">枢纽楼</option>

                        </select>

                        <p>市</p>

                        <select id="city" data-mini="true">

                            <option value="">全部</option>

                        </select>

                        <p>区/县</p>

                        <select id="country" data-mini="true">

                            <option value="">全部</option>

                        </select>

                         <p>机房站点</p>

                        <select id="homeName" data-mini="true">

                            <option value="">全部</option>

                        </select>

                        <p>统计方式</p>

                        <select id="" data-mini="true">

                            <option value="">按年统计</option>

                            <option value="">按月统计</option>

                            <option value="">按日统计</option>

                        </select>

                         <p>时间段</p>

                         <div class="checkdata">

                            <input id="startTestrecord"  type="text" name="appDate" class="appDatefir"  value="2000-01-01" />

                        </div>

                        <span class="sicon">&macr;</span>

                        <div class="checkdata">

                            <input id="endTestrecord" type="text" name="appDate" class="appDatesec"  value="2017-01-01" />

                        </div>

						
                    </fieldset>

                </div>

                <div class="fg-panel-btn">

                    <a href="javascript:panel.hide(true);" id="submit" data-role="button" class="ui-btn ui-mini ui-btn-b ui-shadow">确定</a>

                </div>

            </form>

        </div>

        <!-- 头部内容 -->

        <div data-role="header" data-position="fixed">

            <a href="count-report.html" target="_top" class="ui-btn ui-corner-all ui-shadow ui-icon-back ui-btn-icon-left" style="padding-top: 0.7em; padding-bottom: 0.7em;">返回</a>

            <h1>设备流量统计查询</h1>

            <a href="javascript:panel.show();" class="ui-btn ui-corner-all ui-shadow ui-icon-grid ui-btn-icon-left" style="padding-top: 0.7em; padding-bottom: 0.7em;" id="screen">筛选</a>

        </div>

        <!-- 主体内容 -->

        <div data-role="main">

            <div class="pre-page"><a href="#" class="ui-btn ui-corner-all ui-icon-carat-l ui-btn-icon-notext">图标</a></div>

            <div class="next-page"><a href="#" class="ui-btn ui-corner-all ui-icon-carat-r ui-btn-icon-notext">图标</a></div>	
            <!-- 表格容器 -->

            <div class="tbl-container"></div>

            <table data-role="table" class="ui-responsive ui-shadow" id="tab" >

					
            </table>

        </div>

    </div>

</body>



<script src="mobilJs/mobiscroll.core-2.5.2.js" type="text/javascript"></script>

<script src="mobilJs/mobiscroll.core-2.5.2-zh.js" type="text/javascript"></script>

<script src="mobilJs/mobiscroll.datetime-2.5.1.js" type="text/javascript"></script>

<script src="mobilJs/mobiscroll.datetime-2.5.1-zh.js" type="text/javascript"></script>

<script type="text/javascript" src="js/tbl.js"></script>

<script type="text/javascript" src="mobilJs/base.js"></script>

<script type="text/javascript" src="js/panel.js"></script>

<script type="text/javascript">	
    $(function () {

        setTimes($("#startTestrecord"),'2000-01-01');

        setTimes($("#endTestrecord"),new Date().format('yyyy-MM-dd'));

		
    });

</script> 
 <script type="text/javascript">  
    $('document').ready(function(){panel.show();});    
 
    var arr=new Array();        //当前表格td数据

    var Page = {

        pageSize:10,                 //每页的行数

        pageCurr:1,                  //当前页码数

        pageAll:0,

    };

	
    var arrTh = ['统计时间段', '省', '市', '机房名称','流量'];

    dataArr = [];

    var startTime = "1980-01-01";

    var endTime = new Date().format('yyyy-MM-dd');

    var tbl = $('.tbl-container');

    createTbl(tbl, arrTh, dataArr);

    $(document).ready(function(){

        setPage();

        $("#submit").click(function(){

            Page.pageCurr=1;

            searchBadBatt();

        });

     });

	
     //查询电池信息

     function searchBadBatt(){

         loadshow();

         var stationid = $("#station_name").find('option:selected').attr('stationid')?$("#station_name").find('option:selected').attr('stationid'):'';

        var temp = createSearchForm();

        console.info(stationid);

        /*var temp = {

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

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

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

            StationName: $("#station_name").val(),

            StationId: stationid

        };*/

        //console.info(temp);

         var json = JSON.stringify(temp);

         //console.info(json);

        arrTd = new Array();

        $.post("Batt_Maint_DealarmAction_serchByConditionNew","result="+json,function(data){

            data=eval("("+data.result+")");

            //console.info(data);

            if(data.code==1 && data.data.length>0){

                data=data.data;

                //console.info(data);					
                arr=new Array();

                index=0;

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

                    Page.pageAll=data[i].Size;

                    arr[index++]=data[i].BattGroupId;                //电池组id

                    arr[index++]=data[i].StationName;                //机房名称

                    arr[index++]=data[i].StationIp;                    //机房IP

                    arr[index++]=data[i].BattGroupName;    //电池组名称

                    arr[index++]=data[i].BattGroupNum;                //电池组序号

					
					
                }

               //console.info(Page);

               createTbl(tbl, arrTh, arr);

	          
            }else{

                $('#searchNull').popup('open');

                Page.pageAll = 0;

            }

            setPage();

            //console.info(Page);

            loadclose();     
        }).error(function(){

            loadclose();

            $('#searchErr').popup('open');

        });

	 
     }





	
    function createSearchForm(){

        var temp={

            page:{

                pageCurr:Page.pageCurr,

                pageSize:Page.pageSize,

            },

            binf:{

                StationName1:$('#mainteArea').val(),

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

                StationName5:$('#country').val(),

                StationName:$('#homeName').val(),

				
            },

			
            tdata:{	
				
                record_time:$('#startTestrecord').val(),           //电池测试记录时间段

                record_time1:$('#endTestrecord').val()  
				
            }

			
        };

        return temp;

    }

    // stringify(createSearchForm());

    //页面加载时查询省

    $.post("BattInfAction_serchByStation",null,function(data){

        data = data.result;

        data = eval("("+data+")");

        //console.info(data);

        //console.info(data.code);

        if(data.code==1&&data.data.length>0){

               var $Ostation_name1=$("#mainteArea");

            $Ostation_name1.text("");

            var arr = new Array();

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

            {

                   if(i == 0){

                       arr.push({

                           val:"",

                           txt:"全部(共"+data.sum+"个)",

                       });

                   }else{

                       arr.push({

                           val:data.data[i-1].StationName1,

                           txt:data.data[i-1].StationName1,

                       });

                   }

            }

            updataSel($Ostation_name1, arr);

        }

         findCity();

    });



  
//当省改变时更新市

    function findCity(){

        var data = {

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

        };

        //console.info(data);

        // 请求获取当前省下的市

        $.ajax({ 	
            type: "post", 				
            url: "BattInfAction!serchStationName2",				
            async:true,				
            dataType:'json',

            data:"json = "+JSON.stringify(data),	
            success: function(data){

            data = data.result;

            data = eval("("+data+")");

            //console.info(data);

            //console.info(data.code);	   
            if(data.code==1&&data.data.length>0){

                   var $Ostation_name1=$("#city");

                $Ostation_name1.text("");

                var arr = new Array();

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

                {

                       if(i == 0){

                           arr.push({

                               val:"",

                               txt:"全部(共"+data.data.length+"个)",

                           });

                       }else{

                           arr.push({

                               val:data.data[i-1].StationName2,

                               txt:data.data[i-1].StationName2,

                           });

                       }

                }

                updataSel($Ostation_name1, arr);

            }

             findCounty();

        }

        });

    }

	
//当市改变时更新区/县

    function findCounty(){

        var data = {

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

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

        };

        //console.info(data);

        $.ajax({ 	
            type: "post", 				
            url: "BattInfAction!serchStationName5",				
            async:true,				
            dataType:'json',

            data:"json = "+JSON.stringify(data),	
            success: function(data){

            data = data.result;

            data = eval("("+data+")");

            //console.info(data);

            //console.info(data.code);	   
            if(data.code==1&&data.data.length>0){

                   var $Ostation_name1=$("#country");

                $Ostation_name1.text("");

                var arr = new Array();

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

                {

                       if(i == 0){

                           arr.push({

                               val:"",

                               txt:"全部(共"+data.data.length+"个)",

                           });

                       }else{

                           arr.push({

                               val:data.data[i-1].StationName5,

                               txt:data.data[i-1].StationName5,

                           });

                       }

                }

                updataSel($Ostation_name1, arr);

            }

          findStationNamebyStationname1();   
        }

        });

    }

  
 //当区县更新时更新机房  
    function findStationNamebyStationname1(){

        var data = {

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

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

            StationName5:$("#country").val()

        };

        //console.info(data);

        $.ajax({ 	
            type: "post", 				
            url: "BattInfAction!serchStationName3",				
            async:true,				
            dataType:'json',

            data:"json = "+JSON.stringify(data),	
            success: function(data){

            data = data.result;

            data = eval("("+data+")");

            //console.info(data);

            //console.info(data.code);	   
            if(data.code==1&&data.data.length>0){

                   var $Ostation_name1=$("#homeName");

                $Ostation_name1.text("");

                var arr = new Array();

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

                {

                       if(i == 0){

                           arr.push({

                               val:"",

                               stationid:"",

                               txt:"全部(共"+data.data.length+"个)",

                           });

                       }else{

                           arr.push({

                               val:data.data[i-1].StationName3,

                               stationid:data.data[i-1].StationId,

                               txt:data.data[i-1].StationName3,

                           });

                       }

                }

                //console.info(111111111111111);

                updataSelStation($Ostation_name1, arr);

            }

	       
            findserchByBattGroupNamebystationname(); 
        }

        });

    }

 
 //根据机房获取电池组   
     function findserchByBattGroupNamebystationname(){

        var stationid = $("#station_name").find('option:selected').attr('stationid')?$("#station_name").find('option:selected').attr('stationid'):'';

	
        var data = {

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

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

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

            StationName: $("#homeName").val(),

            StationId: stationid

        };

		
        //console.info(data);

        $.ajax({ 	
            type: "post", 				
            url: "BattInfAction!serchBattByStation",				
            async:true,				
            dataType:'json',

            data:"json = "+JSON.stringify(data),	
            success: function(data){

            data = data.result;

            data = eval("("+data+")");

            //console.warn();

            //console.info(data);

            //console.info(data.code);	   
            if(data.code==1&&data.data.length>0){

                   var $Ostation_name1=$("#battgroup_name");

                $Ostation_name1.text("");

                var arr = new Array();

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

                {

                       if(i == 0){

                           arr.push({

                               val:0,

                               txt:"全部(共"+data.data.length+"个)",

                           });

                       }else{

                           arr.push({

                               val:data.data[i-1].BattGroupId,

                               txt:data.data[i-1].BattGroupName,

                           });

                       }

                }

                updataSel($Ostation_name1, arr);

            }

	         
        }

        });

    }

    
   //当省改变时更新市

   $('#mainteArea').change(function(){

           findCity();	
   });

   //当市改变时改变区/县

   $('#city').change(function(){

           findCounty();	
   });

   //当区/县改变时改变机房

   $('#country').change(function(){

           findStationNamebyStationname1(); 	
   });   	
    //当机房改变时，更新电池组	
    $('#homeName').change(function(){

        findserchByBattGroupNamebystationname();

    });

		
	
		
    $(function() {

        //点击上一页

        $('.pre-page').on('click', 'a', function() {

            if(Page.pageCurr>1){

                Page.pageCurr = Page.pageCurr - 1;

                searchBadBatt();

            }

        });

		
        //点击下一页

        $('.next-page').on('click', 'a', function() {

            var pageNum = Math.ceil(Page.pageAll/Page.pageSize);

            if(Page.pageCurr<pageNum){

                Page.pageCurr = Page.pageCurr + 1;

                searchBadBatt();

            }

        });

    });

	
	
    // 判断是否显示翻页按钮

    function setPageTurning(isShowPre, isShowNext) {

        if(isShowPre) {    // 判断是否显示向上翻页按钮

            $('.pre-page').show();

        }else {

            $('.pre-page').hide();

        }



        if(isShowNext) {    // 判断是否显示向下翻页按钮

            $('.next-page').show();

        }else {

            $('.next-page').hide();

        }

    }					
	
    //设置页面的跳转链接

    function setPage(){

        if(Page.pageCurr <= 1){

            $('.pre-page').hide();

        }else{

            $('.pre-page').show();

        }

        var pageNum = Math.ceil(Page.pageAll/Page.pageSize);

		
        if(Page.pageCurr < pageNum){

            $('.next-page').show();

        }else{

            $('.next-page').hide();

        }

		
    }

   </script>

</html> 

 gx_tieta/WebRoot/mobil/count-report.html

@@ -46,6 +46,12 @@
                    <li>

                        <a href="batt-state-manage.html"  target="_top" data-transition="slidefade">机房实时状态查询</a>

                    </li>

                    <li>

                        <a href="batt-state-statistical.html"  target="_top" data-transition="slidefade">机房历史事件查询</a>

                    </li>

                    <li>

                        <a href="batt-traffic-statistics.html"  target="_top" data-transition="slidefade">设备流量统计查询</a>

                    </li>

                    <!-- <li>

                        <a href="powercut.html" data-ajax="false" data-transition="slidefade">机房停电查询</a>

                    </li>                


 gx_tieta/WebRoot/pages/js/common.js

@@ -464,6 +464,7 @@
    gl.namespace('CMD.gprs');

    gl.CMD.gprs.param = 145;

    gl.CMD.gprs.signal = "CSQ";

    gl.CMD.gprs.threadinfo = 0x17;

})(jQuery, window, document, GLOBAL);



// 地图信息


 gx_tieta/src/com/fgkj/actions/ram/Bts_station_stateAction.java

@@ -27,14 +27,20 @@
        return SUCCESS;

    }

    

  //机房断电统计(首页上的饼状图)

   //机房断电统计(首页上的饼状图)

    public String serchPowerOff(){

        User_inf uinf=(User_inf) ActionUtil.getUser();

        ServiceModel model = service.serchPowerOff(uinf);

        result = tojson(model);              

        return SUCCESS;

    }

    
  //地图右下角显示出已安装机房中(停电数/掉站数/机房告警数/落后单体机房数)

    public String serchStationState(){

        User_inf uinf=(User_inf) ActionUtil.getUser();

        ServiceModel model = service.serchStationState(uinf);

        result = tojson(model);          	
        return SUCCESS;

    }

    

    

    


 gx_tieta/src/com/fgkj/dao/impl/BadBatt_monImpl.java

@@ -377,8 +377,38 @@
        }

        return list;

    }





    
    //查询存在落后单体得机房个数

    public int searchBadBattInStation(Object obj) {

        User_inf uinf=(User_inf) obj;

        String sql=" select count(distinct db_battinf.tb_battinf.stationid) as nums from db_battinf.tb_battinf where  station_install=1 " +

                " and db_battinf.tb_battinf.battgroupid in (select distinct tb_badbatt_mon.BattGroupId from web_site.tb_badbatt_mon) " +

                " and db_battinf.tb_battinf.stationid in ( select distinct db_user.tb_user_battgroup_baojigroup_battgroup.stationid " +

                " from db_user.tb_user_battgroup_baojigroup_battgroup,db_user.tb_user_battgroup_baojigroup_usr " +

                " where db_user.tb_user_battgroup_baojigroup_battgroup.baoji_group_id=db_user.tb_user_battgroup_baojigroup_usr.baoji_group_id  " +

                " and db_user.tb_user_battgroup_baojigroup_usr.uId=? )  ";

        //System.out.println(sql);

        List list=DAOHelper.executeQuery(sql, DBUtil.getConn(), new Object[]{uinf.getUId()}, new CallBack() {

			
            public List getResults(ResultSet rs) {

                List list=new ArrayList();

                try {

                    while(rs.next()){

                        list.add(rs.getInt("nums"));

                    }

                } catch (SQLException e) {

                    // TODO Auto-generated catch block

                    e.printStackTrace();

                }

                return list;

            }

        });

        int nums=0;//最后的结果

        if(list!=null&&list.size()>0){

            nums=(Integer) list.get(list.size()-1);

        }

        return nums;

    }

    public static void main(String[] args) throws ParseException {

        SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");

        Date date1 = sdf.parse("2000-01-01");

@@ -410,10 +440,12 @@
        bmd.setBinf(binf);

        bmd.setPage(page);

        bmd.setUinf(uinf);

        List<Batt_Maint_Dealarm> list=bimpl.serchByInfo(bmd);

        /*List<Batt_Maint_Dealarm> list=bimpl.serchByInfo(bmd);

        for (Batt_Maint_Dealarm b : list) {

            System.out.println(b);

        }

        }*/

        int nums=bimpl.searchBadBattInStation(uinf);

        System.out.println(nums);

    }






 gx_tieta/src/com/fgkj/dao/impl/Battalarm_dataDAOImpl.java

@@ -1898,7 +1898,36 @@
        return list;

    }



	
    //查询存在电池告警的机房个数

    public int  searchAlarmInStation(Object obj){

        User_inf uinf=(User_inf) obj;

        String sql=" select count(distinct db_battinf.tb_battinf.stationid) as nums from db_battinf.tb_battinf where  station_install=1 " +

                " and db_battinf.tb_battinf.battgroupid in (select distinct db_alarm.tb_battalarm_data.battgroupid from db_alarm.tb_battalarm_data) " +

                " and db_battinf.tb_battinf.stationid in ( select distinct db_user.tb_user_battgroup_baojigroup_battgroup.stationid " +

                " from db_user.tb_user_battgroup_baojigroup_battgroup,db_user.tb_user_battgroup_baojigroup_usr " +

                " where db_user.tb_user_battgroup_baojigroup_battgroup.baoji_group_id=db_user.tb_user_battgroup_baojigroup_usr.baoji_group_id  " +

                " and db_user.tb_user_battgroup_baojigroup_usr.uId=? ) " ;

        List list=DAOHelper.executeQuery(sql, DBUtil.getConn(), new Object[]{uinf.getUId()}, new CallBack() {

			
            public List getResults(ResultSet rs) {

                List list=new ArrayList();

                try {

                    while(rs.next()){

                        list.add(rs.getInt("nums"));

                    }

                } catch (SQLException e) {

                    // TODO Auto-generated catch block

                    e.printStackTrace();

                }

                return list;

            }

        });

        int nums=0;//最后的结果

        if(list!=null&&list.size()>0){

            nums=(Integer) list.get(list.size()-1);

        }

        return nums;

    }

    

    public static void main(String[] args) throws ParseException {

        Battalarm_dataDAOImpl bimp = new Battalarm_dataDAOImpl();

@@ -1970,7 +1999,9 @@
        for (int num : list) {

            System.out.println(num);

        }*/

        List list=bimp.serchIn30(uinf);

        System.out.println(list.size());

        //List list=bimp.serchIn30(uinf);

        //System.out.println(list.size());

        int nums=bimp.searchAlarmInStation(uinf);

        System.out.println(nums);

    }

}


 gx_tieta/src/com/fgkj/dao/impl/ram/Bts_station_stateImpl.java

@@ -182,13 +182,9 @@
    public int serchByState(Object obj) {

        User_inf uinf=(User_inf) obj;

        String sql=" select count(*) as nums from db_ram_db.tb_bts_station_state where station_stat&2>1  " +

                   "  and tb_bts_station_state.station_id in (" +

                   "  select distinct db_battinf.tb_battinf.stationid  " +

                   "  from db_battinf.tb_battinf " +

                   "  left outer join db_user.tb_user_battgroup_baojigroup_battgroup on db_user.tb_user_battgroup_baojigroup_battgroup.stationid=db_battinf.tb_battinf.stationid " +

                   "  left outer join db_user.tb_user_battgroup_baojigroup_usr on db_user.tb_user_battgroup_baojigroup_usr.baoji_group_id=db_user.tb_user_battgroup_baojigroup_battgroup.baoji_group_id " +

                   "  left outer join db_user.tb_user_inf on tb_user_inf.uid=db_user.tb_user_battgroup_baojigroup_usr.uid " +

                   "  where db_user.tb_user_inf.uid=?  ) " ;

                   "  and tb_bts_station_state.station_id  in (" +

                " select distinct db_user.tb_user_battgroup_baojigroup_battgroup.StationId from db_user.tb_user_battgroup_baojigroup_battgroup,db_user.tb_user_battgroup_baojigroup_usr where db_user.tb_user_battgroup_baojigroup_battgroup.baoji_group_id=db_user.tb_user_battgroup_baojigroup_usr.baoji_group_id  and db_user.tb_user_battgroup_baojigroup_usr.uId=?" +

                " ) ";

        List list=DAOHelper.executeQuery(sql, DBUtil.getConn(), new Object[]{uinf.getUId()}, new CallBack() {

            

            public List getResults(ResultSet rs) {

@@ -215,12 +211,8 @@
        User_inf uinf=(User_inf) obj;

        String sql=" select count(*) as nums from db_ram_db.tb_bts_station_state where station_stat&32>1  " +

                   "  and tb_bts_station_state.station_id in (" +

                   "  select distinct db_battinf.tb_battinf.stationid  " +

                   "  from db_battinf.tb_battinf " +

                   "  left outer join db_user.tb_user_battgroup_baojigroup_battgroup on db_user.tb_user_battgroup_baojigroup_battgroup.stationid=db_battinf.tb_battinf.stationid " +

                   "  left outer join db_user.tb_user_battgroup_baojigroup_usr on db_user.tb_user_battgroup_baojigroup_usr.baoji_group_id=db_user.tb_user_battgroup_baojigroup_battgroup.baoji_group_id " +

                   "  left outer join db_user.tb_user_inf on tb_user_inf.uid=db_user.tb_user_battgroup_baojigroup_usr.uid " +

                   "  where db_user.tb_user_inf.uid=?  ) " ;

                " select distinct db_user.tb_user_battgroup_baojigroup_battgroup.StationId from db_user.tb_user_battgroup_baojigroup_battgroup,db_user.tb_user_battgroup_baojigroup_usr where db_user.tb_user_battgroup_baojigroup_battgroup.baoji_group_id=db_user.tb_user_battgroup_baojigroup_usr.baoji_group_id  and db_user.tb_user_battgroup_baojigroup_usr.uId=?" +

                " ) ";

        List list=DAOHelper.executeQuery(sql, DBUtil.getConn(), new Object[]{uinf.getUId()}, new CallBack() {

            

            public List getResults(ResultSet rs) {

@@ -242,7 +234,7 @@
        }

        return nums;

    }

    //查询当前机房停电数(根据station_id )

    //查询具体某机房停电数(根据station_id )

    public int serchByStationId(Object obj) {

        BattMap_information binformation=(BattMap_information) obj;

        String sql="select count(num) as nums  from db_ram_db.tb_bts_station_state " +

@@ -295,11 +287,11 @@
            //System.out.println(bs.getStation_stat_diaozhan()+"  "+bs.getStation_stat_dooropen()+"  "+bs.getStation_stat_fadian()+"   "+bs.getStation_stat_xuhang()+"  "+bs.getStation_stat_poff());

            System.out.println(bs);

        }

        /*int nums=bimpl.serchByState(uinf);*/

        int nums=bimpl.serchByState(uinf);

        /*BattMap_information bm=new BattMap_information();

        bm.setStationId("42000570");

        int nums=bimpl.serchByStationId(bm);*/

        int nums=bimpl.serchByState_diaozhan(uinf);

        //int nums=bimpl.serchByState_diaozhan(uinf);

        System.out.println(nums);

    }




 gx_tieta/src/com/fgkj/services/ram/Bts_station_stateService.java

@@ -4,9 +4,12 @@


import com.fgkj.dao.BaseDAO;

import com.fgkj.dao.BaseDAOFactory;

import com.fgkj.dao.impl.BadBatt_monImpl;

import com.fgkj.dao.impl.BattInfImpl;

import com.fgkj.dao.impl.BattPower_offImpl;

import com.fgkj.dao.impl.Battalarm_dataDAOImpl;

import com.fgkj.dao.impl.ram.Bts_station_stateImpl;

import com.fgkj.dto.Battalarm_data;

import com.fgkj.dto.ServiceModel;



public class Bts_station_stateService {

@@ -47,4 +50,19 @@
        model.setCode(dianzhanNum);

        return model;

    }

  //地图右下角显示出已安装机房中(停电数/掉站数/机房告警数/落后单体机房数)

    public ServiceModel serchStationState(Object obj){

        int powerNum=((Bts_station_stateImpl)dao).serchByState(obj);    //停电实时数

        int dianzhanNum=((Bts_station_stateImpl)dao).serchByState_diaozhan(obj);    //掉站实时数

        int badbattNum=(new BadBatt_monImpl()).searchBadBattInStation(obj);//存在落后单体的机房个数

        int alarmNum=(new Battalarm_dataDAOImpl()).searchAlarmInStation(obj);//存在电池告警的机房个数

        int devNum=(new BattInfImpl()).serchByDeviceId(obj);        //总设备数

        model.setSum(powerNum);//停电实时数

        model.setCode(dianzhanNum);//掉站实时数

        model.setNewsum(devNum);    //总设备数

        model.setMsgN(String.valueOf(badbattNum));//存在落后单体的机房个数

        model.setMsg(String.valueOf(alarmNum));//存在电池告警的机房个数

        return model;

    }

    
}