基站统计

81041

2018-10-15 12808f035eec4cb7ea0dad67833dc9f11a281a4c

基站统计

 gx_tieta/src/com/fgkj/actions/Batt_devalarm_data_historyAction.java

@@ -2,6 +2,7 @@


import java.util.List;



import com.fgkj.dto.BattInf;

import com.fgkj.dto.Batt_Maint_Dealarm;

import com.fgkj.dto.Batt_devalarm_data_history;

import com.fgkj.dto.ServiceModel;

@@ -30,6 +31,14 @@
        result = tojson(model);

        return SUCCESS;    

    }

    //统计机房状态历史(机房状态)

    public String serchStateBydev_id(){

        BattInf binf=getGson("yyyy-MM-dd HH:mm:ss").fromJson(json, BattInf.class);

        ServiceModel model=service.serchStateBydev_id(binf);

        result=tojson(model);

        return SUCCESS;	
    }

	
    public String getResult() {

        return result;

    }


 gx_tieta/src/com/fgkj/dao/AlarmDaoFactory.java

@@ -17,6 +17,15 @@
    public static final int Alarm_CapAlarm =119010;      //--容量告警告警

    public static final int Alarm_CapChange =119011;      //--容量更换告警

    

    public static final int ALM_TYPE_BTS9100S_POFF_ComError_ID =119024;        //基站停电告警

    public static final int ALM_TYPE_BTS9100S_FADIAN_ComError_ID =119025;      //基站发电告警

    public static final int ALM_TYPE_BTS9100S_DIAOZHAN_ComError_ID  =119026;   //基站掉站告警

    public static final int ALM_TYPE_BTS9100S_DOOROPEN_ComError_ID  =119027;   //基站开门告警

    public final static int ALM_TYPE_BTS9100S_TEMPUP_ComError_ID    = 119028;        //基站温度上限告警

    public final static int ALM_TYPE_BTS9100S_TEMPLOW_ComError_ID   = 119029;        //基站温度下限告警

    public final static int ALM_TYPE_BTS9100S_DAMPUP_ComError_ID    = 119030;        //基站湿度上限告警

    public final static int ALM_TYPE_BTS9100S_DAMPLOW_ComError_ID   = 119031;        //基站湿度下限告警

	
    public final static int ALM_SIGNAL_ID_Null = 0;

    public final static int ALM_SIGNAL_ID_OnlineVolHigh = 1;

    public final static int ALM_SIGNAL_ID_OnlineVolLow = 2;


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

@@ -10,6 +10,7 @@
import java.util.List;



import com.fgkj.actions.ActionUtil;

import com.fgkj.dao.AlarmDaoFactory;

import com.fgkj.dao.BaseDAO;

import com.fgkj.dao.CallBack;

import com.fgkj.dao.DAOHelper;

@@ -133,12 +134,232 @@
        }

        return list;

    }



    //统计机房状态历史(机房状态)

    public List serchStateBydev_id(Object obj){

        final BattInf binf=(BattInf) obj;

        String sql="SELECT dev_id,alm_type,alm_start_time,alm_end_time,alm_cleared_type,usr_Id,tb_battinf.StationName,tb_battinf.StationName1,tb_battinf.StationName2,tb_battinf.StationName3 " +

                   " from db_alarm.tb_devalarm_data_history,db_battinf.tb_battinf " +

                   " where tb_devalarm_data_history.dev_id=tb_battinf.FBSDeviceId " +

                   " and alm_type in("+AlarmDaoFactory.ALM_TYPE_BTS9100S_POFF_ComError_ID+","+AlarmDaoFactory.ALM_TYPE_BTS9100S_FADIAN_ComError_ID+","+AlarmDaoFactory.ALM_TYPE_BTS9100S_DIAOZHAN_ComError_ID+","+AlarmDaoFactory.ALM_TYPE_BTS9100S_DOOROPEN_ComError_ID+

                   " ,"+AlarmDaoFactory.ALM_TYPE_BTS9100S_TEMPUP_ComError_ID+","+AlarmDaoFactory.ALM_TYPE_BTS9100S_TEMPLOW_ComError_ID+","+AlarmDaoFactory.ALM_TYPE_BTS9100S_DAMPUP_ComError_ID+","+AlarmDaoFactory.ALM_TYPE_BTS9100S_DAMPLOW_ComError_ID+")  " +

                   " and  alm_start_time>=?  and  alm_start_time<=?   " +

                   " and stationname1 like ? and stationname2 like  ? and stationname3 like ? and stationid like ? " ;

        //异常类型筛选

        String alm_typeSqlT=" and alm_type!=? ";

        String alm_typeSqlF=" and alm_type=? ";

        if(binf.getNum()==0){

            sql+=alm_typeSqlT;

        }else{

            sql+=alm_typeSqlF;

        }

        //排序

        String orderSql=" order by dev_id,alm_start_time,alm_type asc ";

        sql+=orderSql;

        //System.out.println(sql);

        //binf.getBattInUseDate(),binf.getBattInUseDate1(),"%"+binf.getStationName1()+"%","%"+binf.getStationName2()+"%","%"+binf.getStationName3()+"%","%"+binf.getStationId()+"%",

        List list=DAOHelper.executeQuery(sql, DBUtil.getConn(), new Object[]{binf.getBattInUseDate(),binf.getBattInUseDate1(),"%"+binf.getStationName1()+"%","%"+binf.getStationName2()+"%","%"+binf.getStationName3()+"%","%"+binf.getStationId()+"%",binf.getNum()}, new CallBack() {

			
            public List getResults(ResultSet rs) {

                List list=new ArrayList();

                int ALM_TYPE_BTS9100S_POFF_ComError_ID=0;//停电数

                int ALM_TYPE_BTS9100S_FADIAN_ComError_ID=0;//发电数

                int ALM_TYPE_BTS9100S_DIAOZHAN_ComError_ID=0;//掉站数

                int ALM_TYPE_BTS9100S_DOOROPEN_ComError_ID=0;//关门数

                int ALM_TYPE_BTS9100S_TEMPUP_ComError_ID    =0;        //基站温度上限告警

                int ALM_TYPE_BTS9100S_TEMPLOW_ComError_ID   = 0;        //基站温度下限告警

                int ALM_TYPE_BTS9100S_DAMPUP_ComError_ID    = 0;        //基站湿度上限告警

                int ALM_TYPE_BTS9100S_DAMPLOW_ComError_ID   = 0;        //基站湿度下限告警

                int dev_id=0;

                // 时间段

                String perid_Time = "";

                //机房名称

                String stationName="";

                try {

                    while(rs.next()){

                        int dev_ids=rs.getInt("dev_id");

                        int alm_types=rs.getInt("alm_type");

                        String stationNames=rs.getString("stationName");

                        // 年份，季度，月份

                        Date dev_recordtime = rs.getTimestamp("alm_start_time");

                        // 获取具体年份，月份和该月的总天数

                        int year = dev_recordtime.getYear() + 1900;

                        int month = dev_recordtime.getMonth() + 1;

                        String perid_Times="";

                        if(binf.getBattGroupNum()==1){//月统计

                            perid_Times = ActionUtil.getFirstDayOfMonth(year, month - 1);

                            perid_Times += " ";

                            perid_Times += ActionUtil.getLastDayOfMonth(year, month - 1);

                        }else if (binf.getBattGroupNum()==3) {// 按年份

                            perid_Times = ActionUtil.getFirstDayOfMonth(year, 0);

                            perid_Times += " ";

                            perid_Times += ActionUtil.getLastDayOfMonth(year, 11);

                        }

                        if(perid_Times.equals(perid_Time)){

                            if(dev_ids==dev_id){

                                if(alm_types==AlarmDaoFactory.ALM_TYPE_BTS9100S_POFF_ComError_ID){

                                    ALM_TYPE_BTS9100S_POFF_ComError_ID+=1;

                                }else if(alm_types==AlarmDaoFactory.ALM_TYPE_BTS9100S_FADIAN_ComError_ID){

                                    ALM_TYPE_BTS9100S_FADIAN_ComError_ID+=1;

                                }else if(alm_types==AlarmDaoFactory.ALM_TYPE_BTS9100S_DIAOZHAN_ComError_ID){

                                    ALM_TYPE_BTS9100S_DIAOZHAN_ComError_ID+=1;

                                }else if(alm_types==AlarmDaoFactory.ALM_TYPE_BTS9100S_DOOROPEN_ComError_ID){

                                    ALM_TYPE_BTS9100S_DOOROPEN_ComError_ID+=1;

                                }else if(alm_types==AlarmDaoFactory.ALM_TYPE_BTS9100S_TEMPUP_ComError_ID){

                                    ALM_TYPE_BTS9100S_TEMPUP_ComError_ID+=1;

                                }else if(alm_types==AlarmDaoFactory.ALM_TYPE_BTS9100S_TEMPLOW_ComError_ID){

                                    ALM_TYPE_BTS9100S_TEMPLOW_ComError_ID+=1;

                                }else if(alm_types==AlarmDaoFactory.ALM_TYPE_BTS9100S_DAMPUP_ComError_ID){

                                    ALM_TYPE_BTS9100S_DAMPUP_ComError_ID+=1;

                                }else if(alm_types==AlarmDaoFactory.ALM_TYPE_BTS9100S_DAMPLOW_ComError_ID){

                                    ALM_TYPE_BTS9100S_DAMPLOW_ComError_ID+=1;

                                }

                            }else{

                                Batt_devalarm_data_history dalarm=new Batt_devalarm_data_history();

                                dalarm.setStationName(stationName);

                                dalarm.setDev_id(dev_id);

                                dalarm.setNum(ALM_TYPE_BTS9100S_POFF_ComError_ID);

                                dalarm.setRecord_id(ALM_TYPE_BTS9100S_FADIAN_ComError_ID);

                                dalarm.setAlm_type(ALM_TYPE_BTS9100S_DIAOZHAN_ComError_ID);

                                dalarm.setAlm_level(ALM_TYPE_BTS9100S_DOOROPEN_ComError_ID);

								
                                dalarm.setAlm_is_confirmed(ALM_TYPE_BTS9100S_TEMPUP_ComError_ID);

                                dalarm.setAlm_cleared_type(ALM_TYPE_BTS9100S_TEMPLOW_ComError_ID);

                                dalarm.setUsr_id(ALM_TYPE_BTS9100S_DAMPUP_ComError_ID);

                                dalarm.setNote(String.valueOf(ALM_TYPE_BTS9100S_DAMPLOW_ComError_ID));

								
                                dalarm.setDev_ip(perid_Time);

                                //System.out.println(1+"    "+dalarm.getDev_ip()+" "+dalarm.getDev_id()+" "+dalarm.getNum()+" "+dalarm.getRecord_id()+" "+dalarm.getAlm_type()+" "+dalarm.getAlm_level()+" "+dalarm.getStationName());

                                list.add(dalarm);

                                stationName=stationNames;

                                dev_id=dev_ids;

                                ALM_TYPE_BTS9100S_POFF_ComError_ID=0;

                                ALM_TYPE_BTS9100S_FADIAN_ComError_ID=0;

                                ALM_TYPE_BTS9100S_DIAOZHAN_ComError_ID=0;

                                ALM_TYPE_BTS9100S_DOOROPEN_ComError_ID=0;

                                ALM_TYPE_BTS9100S_TEMPUP_ComError_ID    =0;        //基站温度上限告警

                                ALM_TYPE_BTS9100S_TEMPLOW_ComError_ID   = 0;        //基站温度下限告警

                                ALM_TYPE_BTS9100S_DAMPUP_ComError_ID    = 0;        //基站湿度上限告警

                                ALM_TYPE_BTS9100S_DAMPLOW_ComError_ID   = 0;        //基站湿度下限告警

                                if(alm_types==AlarmDaoFactory.ALM_TYPE_BTS9100S_POFF_ComError_ID){

                                    ALM_TYPE_BTS9100S_POFF_ComError_ID+=1;

                                }else if(alm_types==AlarmDaoFactory.ALM_TYPE_BTS9100S_FADIAN_ComError_ID){

                                    ALM_TYPE_BTS9100S_FADIAN_ComError_ID+=1;

                                }else if(alm_types==AlarmDaoFactory.ALM_TYPE_BTS9100S_DIAOZHAN_ComError_ID){

                                    ALM_TYPE_BTS9100S_DIAOZHAN_ComError_ID+=1;

                                }else if(alm_types==AlarmDaoFactory.ALM_TYPE_BTS9100S_DOOROPEN_ComError_ID){

                                    ALM_TYPE_BTS9100S_DOOROPEN_ComError_ID+=1;

                                }else if(alm_types==AlarmDaoFactory.ALM_TYPE_BTS9100S_TEMPUP_ComError_ID){

                                    ALM_TYPE_BTS9100S_TEMPUP_ComError_ID+=1;

                                }else if(alm_types==AlarmDaoFactory.ALM_TYPE_BTS9100S_TEMPLOW_ComError_ID){

                                    ALM_TYPE_BTS9100S_TEMPLOW_ComError_ID+=1;

                                }else if(alm_types==AlarmDaoFactory.ALM_TYPE_BTS9100S_DAMPUP_ComError_ID){

                                    ALM_TYPE_BTS9100S_DAMPUP_ComError_ID+=1;

                                }else if(alm_types==AlarmDaoFactory.ALM_TYPE_BTS9100S_DAMPLOW_ComError_ID){

                                    ALM_TYPE_BTS9100S_DAMPLOW_ComError_ID+=1;

                                }

                            }

                        }else{  
                               if(perid_Time.equals("")){

                                   if(alm_types==AlarmDaoFactory.ALM_TYPE_BTS9100S_POFF_ComError_ID){

                                          ALM_TYPE_BTS9100S_POFF_ComError_ID+=1;

                                       }else if(alm_types==AlarmDaoFactory.ALM_TYPE_BTS9100S_FADIAN_ComError_ID){

                                          ALM_TYPE_BTS9100S_FADIAN_ComError_ID+=1;

                                       }else if(alm_types==AlarmDaoFactory.ALM_TYPE_BTS9100S_DIAOZHAN_ComError_ID){

                                          ALM_TYPE_BTS9100S_DIAOZHAN_ComError_ID+=1;

                                       }else if(alm_types==AlarmDaoFactory.ALM_TYPE_BTS9100S_DOOROPEN_ComError_ID){

                                          ALM_TYPE_BTS9100S_DOOROPEN_ComError_ID+=1;

                                       }else if(alm_types==AlarmDaoFactory.ALM_TYPE_BTS9100S_TEMPUP_ComError_ID){

                                        ALM_TYPE_BTS9100S_TEMPUP_ComError_ID+=1;

                                    }else if(alm_types==AlarmDaoFactory.ALM_TYPE_BTS9100S_TEMPLOW_ComError_ID){

                                        ALM_TYPE_BTS9100S_TEMPLOW_ComError_ID+=1;

                                    }else if(alm_types==AlarmDaoFactory.ALM_TYPE_BTS9100S_DAMPUP_ComError_ID){

                                        ALM_TYPE_BTS9100S_DAMPUP_ComError_ID+=1;

                                    }else if(alm_types==AlarmDaoFactory.ALM_TYPE_BTS9100S_DAMPLOW_ComError_ID){

                                        ALM_TYPE_BTS9100S_DAMPLOW_ComError_ID+=1;

                                    }

                                   perid_Time=perid_Times;

                                   dev_id=dev_ids;

                                   stationName=stationNames;

                                   continue;

                                }

                                Batt_devalarm_data_history dalarm=new Batt_devalarm_data_history();

                                dalarm.setStationName(stationName);

                                dalarm.setDev_id(dev_id);

                                dalarm.setNum(ALM_TYPE_BTS9100S_POFF_ComError_ID);

                                dalarm.setRecord_id(ALM_TYPE_BTS9100S_FADIAN_ComError_ID);

                                dalarm.setAlm_type(ALM_TYPE_BTS9100S_DIAOZHAN_ComError_ID);

                                dalarm.setAlm_level(ALM_TYPE_BTS9100S_DOOROPEN_ComError_ID);

                                dalarm.setAlm_is_confirmed(ALM_TYPE_BTS9100S_TEMPUP_ComError_ID);

                                dalarm.setAlm_cleared_type(ALM_TYPE_BTS9100S_TEMPLOW_ComError_ID);

                                dalarm.setUsr_id(ALM_TYPE_BTS9100S_DAMPUP_ComError_ID);

                                dalarm.setNote(String.valueOf(ALM_TYPE_BTS9100S_DAMPLOW_ComError_ID));

                                dalarm.setDev_ip(perid_Time);

                                //System.out.println(2+" "+dalarm.getDev_ip()+" "+dalarm.getDev_id()+" "+dalarm.getNum()+" "+dalarm.getRecord_id()+" "+dalarm.getAlm_type()+" "+dalarm.getAlm_level()+" "+dalarm.getStationName());

                                list.add(dalarm);

                                ALM_TYPE_BTS9100S_POFF_ComError_ID=0;

                                ALM_TYPE_BTS9100S_FADIAN_ComError_ID=0;

                                ALM_TYPE_BTS9100S_DIAOZHAN_ComError_ID=0;

                                ALM_TYPE_BTS9100S_DOOROPEN_ComError_ID=0;

                                ALM_TYPE_BTS9100S_TEMPUP_ComError_ID    =0;        //基站温度上限告警

                                ALM_TYPE_BTS9100S_TEMPLOW_ComError_ID   = 0;        //基站温度下限告警

                                ALM_TYPE_BTS9100S_DAMPUP_ComError_ID    = 0;        //基站湿度上限告警

                                ALM_TYPE_BTS9100S_DAMPLOW_ComError_ID   = 0;        //基站湿度下限告警

                                if(alm_types==AlarmDaoFactory.ALM_TYPE_BTS9100S_POFF_ComError_ID){

                                    ALM_TYPE_BTS9100S_POFF_ComError_ID+=1;

                                }else if(alm_types==AlarmDaoFactory.ALM_TYPE_BTS9100S_FADIAN_ComError_ID){

                                    ALM_TYPE_BTS9100S_FADIAN_ComError_ID+=1;

                                }else if(alm_types==AlarmDaoFactory.ALM_TYPE_BTS9100S_DIAOZHAN_ComError_ID){

                                    ALM_TYPE_BTS9100S_DIAOZHAN_ComError_ID+=1;

                                }else if(alm_types==AlarmDaoFactory.ALM_TYPE_BTS9100S_DOOROPEN_ComError_ID){

                                    ALM_TYPE_BTS9100S_DOOROPEN_ComError_ID+=1;

                                }else if(alm_types==AlarmDaoFactory.ALM_TYPE_BTS9100S_TEMPUP_ComError_ID){

                                    ALM_TYPE_BTS9100S_TEMPUP_ComError_ID+=1;

                                }else if(alm_types==AlarmDaoFactory.ALM_TYPE_BTS9100S_TEMPLOW_ComError_ID){

                                    ALM_TYPE_BTS9100S_TEMPLOW_ComError_ID+=1;

                                }else if(alm_types==AlarmDaoFactory.ALM_TYPE_BTS9100S_DAMPUP_ComError_ID){

                                    ALM_TYPE_BTS9100S_DAMPUP_ComError_ID+=1;

                                }else if(alm_types==AlarmDaoFactory.ALM_TYPE_BTS9100S_DAMPLOW_ComError_ID){

                                    ALM_TYPE_BTS9100S_DAMPLOW_ComError_ID+=1;

                                }

                                dev_id=dev_ids;

                                stationName=stationNames;

                                perid_Time=perid_Times;

							
                        }

                       if(rs.isLast()){

                            Batt_devalarm_data_history dalarm=new Batt_devalarm_data_history();

                            dalarm.setStationName(stationNames);

                            dalarm.setDev_id(dev_ids);

                            dalarm.setNum(ALM_TYPE_BTS9100S_POFF_ComError_ID);

                            dalarm.setRecord_id(ALM_TYPE_BTS9100S_FADIAN_ComError_ID);

                            dalarm.setAlm_type(ALM_TYPE_BTS9100S_DIAOZHAN_ComError_ID);

                            dalarm.setAlm_level(ALM_TYPE_BTS9100S_DOOROPEN_ComError_ID);

                            dalarm.setAlm_is_confirmed(ALM_TYPE_BTS9100S_TEMPUP_ComError_ID);

                            dalarm.setAlm_cleared_type(ALM_TYPE_BTS9100S_TEMPLOW_ComError_ID);

                            dalarm.setUsr_id(ALM_TYPE_BTS9100S_DAMPUP_ComError_ID);

                            dalarm.setNote(String.valueOf(ALM_TYPE_BTS9100S_DAMPLOW_ComError_ID));

							
                            dalarm.setDev_ip(perid_Times);

                            //System.out.println(dalarm.getDev_ip()+" "+dalarm.getDev_id()+" "+dalarm.getNum()+" "+dalarm.getRecord_id()+" "+dalarm.getAlm_type()+" "+dalarm.getAlm_level()+" "+dalarm.getStationName());

                            list.add(dalarm);

                        }

                       // System.out.println(ALM_TYPE_BTS9100S_POFF_ComError_ID+" "+ALM_TYPE_BTS9100S_FADIAN_ComError_ID+" "+ALM_TYPE_BTS9100S_DIAOZHAN_ComError_ID+" "+ALM_TYPE_BTS9100S_DOOROPEN_ComError_ID);

                    }

                } catch (SQLException e) {

                    // TODO Auto-generated catch block

                    e.printStackTrace();

                }

                return list;

            }

        });

        return list;

    }

	
    public List serchByInfo(Object obj) {

        // TODO Auto-generated method stub

        return null;

    }

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

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

        Batt_devalarm_data_historyImpl bimpl=new Batt_devalarm_data_historyImpl();

        Page p = new Page();

        p.setPageCurr(1);

@@ -153,17 +374,21 @@
         * 单体内阻：maint_close 

         * 连接条阻抗：master_id

         * */

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

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

        Date date2 = sdf.parse("2020-01-01");

        SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss");

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

        Date date2 = sdf.parse("2020-01-01 00:00:00");

        

        

        BattInf binf = new BattInf();

		
        binf.setNum(0);

        binf.setStationName("");

        binf.setStationName1("");

        binf.setBattProductDate(ActionUtil.getSimpDate(date1));

        binf.setBattProductDate1(ActionUtil.getSimpDate(date2));

        binf.setStationName2("");

        binf.setStationName3("");

        binf.setStationId("");

        binf.setBattGroupNum(1);

        binf.setBattInUseDate(ActionUtil.getSimpDate(date1));

        binf.setBattInUseDate1(ActionUtil.getSimpDate(date2));

        

        User_inf uinf=new User_inf();

        uinf.setUId(1002);

@@ -171,9 +396,11 @@
        bmd.setPage(p);

        bmd.setBinf(binf);

        bmd.setUinf(uinf);

        List<Batt_devalarm_data_history> list=bimpl.serchByCondition(bmd);

        //List<Batt_devalarm_data_history> list=bimpl.serchByCondition(bmd);

        List<Batt_devalarm_data_history> list=bimpl.serchStateBydev_id(binf);

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

        for (Batt_devalarm_data_history b : list) {

            System.out.println(b);

            System.out.println(b.getDev_ip()+" "+b.getDev_id()+" "+b.getNum()+" "+b.getRecord_id()+" "+b.getAlm_type()+" "+b.getAlm_level()+" "+b.getAlm_is_confirmed()+" "+b.getAlm_cleared_type()+" "+b.getUsr_id()+" "+b.getNote()+" "+b.getStationName());

        }

}

}


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

@@ -62,4 +62,17 @@
        

        return model;

    }

    //统计机房状态历史(机房状态)

    public ServiceModel serchStateBydev_id(Object obj){

        List list=((Batt_devalarm_data_historyImpl)dao).serchStateBydev_id(obj);

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

            model.setCode(1);

            model.setData(list);

            model.setMsg("查询成功!");

        }else{

            model.setCode(0);

            model.setMsg("查询失败!");

        }

        return model;

    }

}