首页上添加续航不足图标功能

81041

2018-12-05 bbe25007af388943027ee6b630c28a2815edca73

首页上添加续航不足图标功能

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

@@ -11,6 +11,7 @@
import com.fgkj.dao.DAOHelper;

import com.fgkj.dao.LimitNumberFactory;

import com.fgkj.db.DBUtil;

import com.fgkj.dto.BattMap_information;

import com.fgkj.dto.Batt_endurance;

import com.fgkj.dto.Page;

import com.fgkj.dto.User_inf;

@@ -210,6 +211,33 @@
        }

        return nums;

    }

    //根据机房id查询该机房续航不足的数

    public int serchxuhangNotInThree_stationid(Object obj) {

        BattMap_information binformation=(BattMap_information) obj;

        String sql="select count(distinct tb_batt_endurance.deviceid) as nums from web_site.tb_batt_endurance " +

                " where endurance_actual_timelong<180  and tb_batt_endurance.stationid=? "  ;

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

			
            public List getResults(ResultSet rs) {

                List list=new ArrayList();

                try {

                    while(rs.next()){

                        int nums=rs.getInt("nums");

                        list.add(nums);

                    }

                } catch (SQLException e) {

                    // TODO Auto-generated catch block

                    e.printStackTrace();

                }

                return list;

            }

        });

        int nums=0;//续航不足3小时数

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

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

        }

        return nums;

    }

    public List serchByInfo(Object obj) {

        // TODO Auto-generated method stub

        return null;

@@ -240,7 +268,11 @@
            System.out.println(num);

        }*/

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

        int nums=bimpl.serchxuhangNotInThree(uinf);

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

        System.out.println(nums);*/

        BattMap_information binformation=new BattMap_information();

        binformation.setStationId("42000530");

        int nums=bimpl.serchxuhangNotInThree_stationid(binformation);

        System.out.println(nums);

    }

    


 gx_tieta/src/com/fgkj/services/BattMap_informationService.java

@@ -12,6 +12,7 @@
import com.fgkj.dao.impl.BattDischarge_planImpl;

import com.fgkj.dao.impl.BattInfImpl;

import com.fgkj.dao.impl.BattMap_informationImpl;

import com.fgkj.dao.impl.Batt_enduranceImpl;

import com.fgkj.dao.impl.Batt_rtstateDAOImpl;

import com.fgkj.dao.impl.Battalarm_dataDAOImpl;

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

@@ -110,6 +111,7 @@
        int numPlan=0;

        int numPoff=0;

        int dianzhanNum=0;

        int xuhangNum=0;

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

            for(int i=0;i<list.size();i++){                

                state="item-normal";

@@ -120,6 +122,7 @@
                    binf.setFBSDeviceId(binformation.getFBSDeviceId());

                    state=(new Fbs9100_stateImpl().seachDevNow(binf));

                }else{

                    xuhangNum=(new Batt_enduranceImpl()).serchxuhangNotInThree_stationid(binformation);//续航不足3小时数

                    numPoff=(new Bts_station_stateImpl()).serchByStationId(binformation);  //停电数  

                    dianzhanNum=(new Bts_station_stateImpl()).serchByStationId_diaozhan(binformation);    //掉站数

                    numBadBatt=(new BadBatt_monImpl()).serchByStationId(binformation);                //落后总数

@@ -132,16 +135,19 @@
                            state="item-poff";                             //停电

                            

                        }else{

                            if(numBadBatt>0){

                                state="item-behind";                                    //落后机房

                            if(xuhangNum>0){

                                state="item-xuhang";                       //续航不足

                            }else{

                                if(numAlarm > 0){

                                    state="item-warn";                                //告警机房	
                                if(numBadBatt>0){

                                    state="item-behind";                                    //落后机房

                                }else{

                                    if(numAlarm > 0){

                                        state="item-warn";                                //告警机房	
                                    }

                                }

                            }

                        }

                    }

					
                }

                if("0".equals(list.get(i).getInformation())){

                    state="item-install";                            //若机房未安装将指定的机房设置成灰色的

@@ -152,6 +158,7 @@
                model.setSum(numBadBatt);        //落后总数

                //model.setNewsum(numPlan);        //延时总数

                model.setMsgT(String.valueOf(dianzhanNum));   //掉站

                model.setMsgV(String.valueOf(xuhangNum));//续航不足

                model.setMsg(state);            //61850状态

                model.setMsgN(binformation.getFBSDeviceId().toString());

                listAll.add(model);

@@ -169,6 +176,7 @@
        int numPlan=0;

        int numPoff=0;

        int dianzhanNum=0;

        int xuhangNum=0;

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

            for(int i=0;i<list.size();i++){

                state="item-normal";

@@ -179,6 +187,7 @@
                    binf.setFBSDeviceId(binformation.getFBSDeviceId());

                    state=(new Fbs9100_stateImpl().seachDevNow(binf));

                }else{

                    xuhangNum=(new Batt_enduranceImpl()).serchxuhangNotInThree_stationid(binformation);//续航不足3小时数

                    numPoff=(new Bts_station_stateImpl()).serchByStationId(binformation);  //停电数  

                    dianzhanNum=(new Bts_station_stateImpl()).serchByStationId_diaozhan(binformation);    //掉站数

                    numBadBatt=(new BadBatt_monImpl()).serchByStationId(binformation);                //落后总数

@@ -191,11 +200,15 @@
                            state="item-poff";                             //停电

                            

                        }else{

                            if(numBadBatt>0){

                                state="item-behind";                                    //落后机房

                            if(xuhangNum>0){

                                state="item-xuhang";                       //续航不足

                            }else{

                                if(numAlarm > 0){

                                    state="item-warn";                                //告警机房	
                                if(numBadBatt>0){

                                    state="item-behind";                                    //落后机房

                                }else{

                                    if(numAlarm > 0){

                                        state="item-warn";                                //告警机房	
                                    }

                                }

                            }

                        }

@@ -207,6 +220,7 @@
                model.setSum(numBadBatt);        //落后总数

                //model.setNewsum(numPlan);        //延时总数

                model.setMsgT(String.valueOf(dianzhanNum));   //掉站

                model.setMsgV(String.valueOf(xuhangNum));//续航不足

                model.setMsg(state);            //61850状态

                model.setMsgN(binformation.getFBSDeviceId().toString());

                listAll.add(model);

@@ -227,12 +241,14 @@
                    int numPlan=(new BattDischarge_planImpl()).serchByStationId(binformation);

                    int numPoff=(new Bts_station_stateImpl()).serchByStationId(binformation);  //停电数  

                    int dianzhanNum=(new Bts_station_stateImpl()).serchByStationId_diaozhan(binformation);    //掉站数

                    int xuhangNum=(new Batt_enduranceImpl()).serchxuhangNotInThree_stationid(binformation);//续航不足3小时数

                    model.setData(list.get(i));

                    model.setCode(numAlarm);        //告警总数

                    model.setSum(numBadBatt);        //落后总数

                    model.setNewsum(numPlan);        //延时总数

                    model.setMsgO(String.valueOf(numPoff));         //停电数

                    model.setMsgT(String.valueOf(dianzhanNum));   //掉站

                    model.setMsgV(String.valueOf(xuhangNum));//续航不足

                    listAll.add(model);

                }

            }


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

@@ -7,6 +7,7 @@
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.Batt_enduranceImpl;

import com.fgkj.dao.impl.Battalarm_dataDAOImpl;

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

import com.fgkj.dto.Battalarm_data;

@@ -56,12 +57,14 @@
        int dianzhanNum=((Bts_station_stateImpl)dao).serchByState_diaozhan(obj);    //掉站实时数

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

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

        int xuhangnums=(new Batt_enduranceImpl()).serchxuhangNotInThree(obj); //存在续航不足3小时的机房个数

        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));//存在电池告警的机房个数

        model.setMsgT(String.valueOf(xuhangnums));//存在续航不足3小时的机房个数

        return model;

    }