public void setFile(String fileName, int flag) {
   if (flag == 1) {
     fullPath = ResourceCenter.getInstance().getSysPath() + "panel/model/" + fileName;
   } else {
     fullPath = ResourceCenter.getInstance().getSysPath() + "panel/xml/" + fileName;
   }
 }
  @SuppressWarnings("static-access")
  public String downloadReport() {
    String type = getParaValue("type");
    CompReportHelper helper = new CompReportHelper();
    Hashtable allData = helper.getAllDevice();
    Vector vector = null;
    List deviceList = new ArrayList();
    String file = ""; // 保存到项目文件夹下的指定文件夹
    String filePath = ""; // 获取系统文件夹路径
    if (allData != null) {
      if (allData.containsKey("deviceVec")) {
        vector = (Vector) allData.get("deviceVec");
        helper.createPie(vector);
      }
      if (allData.containsKey("deviceList")) {
        deviceList = (List) allData.get("deviceList");
        if (type.equals("doc")) {
          file = "/temp/allDevice.doc";
          filePath = ResourceCenter.getInstance().getSysPath() + file;
          try {
            helper.createDoc(vector, deviceList, filePath);
          } catch (DocumentException e) {
            e.printStackTrace();
          } catch (IOException e) {
            e.printStackTrace();
          }
        } else if (type.equals("xls")) {

          file = "/temp/allDevice.xls";
          filePath = ResourceCenter.getInstance().getSysPath() + file;

          try {
            helper.createExcel(vector, deviceList, filePath);
          } catch (WriteException e) {
            e.printStackTrace();
          }

        } else if (type.equals("pdf")) {
          file = "/temp/allDevice.pdf";
          filePath = ResourceCenter.getInstance().getSysPath() + file;
          try {
            helper.createPdf(vector, deviceList, filePath);
          } catch (DocumentException e) {
            e.printStackTrace();
          } catch (IOException e) {
            e.printStackTrace();
          }
        }
      }
    }
    request.setAttribute("filename", filePath);
    return "/capreport/net/download.jsp";
  }
Exemplo n.º 3
0
 private void collectCfgInfo() {
   BaseDaoImp cd = null;
   String sql = "SELECT * FROM sys_gather_acllist";
   ArrayList<Map<String, String>> ssconfAL = null;
   try {
     cd = new BaseDaoImp();
     ssconfAL = cd.executeQuery(sql);
   } catch (Exception e1) {
     e1.printStackTrace();
   } finally {
     if (cd != null) {
       cd.close();
     }
   }
   Map<String, String> ssidAL = null;
   if (ssconfAL != null) {
     try {
       SimpleDateFormat sdf = new SimpleDateFormat("yyyyMMdd-HH-mm");
       for (int i = 0; i < ssconfAL.size(); i++) {
         ssidAL = ssconfAL.get(i);
         //					String id = ssidAL.get("id");
         String ipaddress = ssidAL.get("ipaddress");
         String command = ssidAL.get("command");
         String isMonitor = ssidAL.get("isMonitor");
         if (!ipaddress.equals("") && ipaddress != null && isMonitor.equals("1")) {
           HaweitelnetconfDao dao = null;
           try {
             dao = new HaweitelnetconfDao();
             Huaweitelnetconf vo = (Huaweitelnetconf) dao.loadByIp(ipaddress);
             if (vo == null) {
               continue;
             }
             //							String b_time = sdf.format(new Date());
             String prefix = ResourceCenter.getInstance().getSysPath().replace("\\", "/");
             String fileName = prefix + "script/" + vo.getIpaddress() + "acl.log";
             bkpCfg(ipaddress, fileName, command);
           } catch (Exception e) {
             e.printStackTrace();
           } finally {
             if (dao != null) {
               dao.close();
             }
           }
         }
       }
     } catch (Exception e) {
       log.error("", e);
     }
   }
 }
 public String downloadReportDay() {
   String ids = getParaValue("ids");
   String type = getParaValue("type");
   String reportType = getParaValue("reportType");
   String exportType = getParaValue("exportType");
   SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
   if (ids == null || ids.equals("") || ids.equals("null")) {
     String id = request.getParameter("id");
     if (id.equals("null")) return null;
     CompreReportInfo report = new CompreReportInfo();
     CompreReportUtilDao dao = new CompreReportUtilDao();
     report = (CompreReportInfo) dao.findByID(id);
     ids = report.getIds();
   }
   String filename = "";
   if ("hostNet".equalsIgnoreCase(type)) {
     if (exportType.equals("xls")) {
       filename = "/temp/compreDay_report.xls";
     } else if (exportType.equals("doc")) {
       filename = "/temp/compreDay_report.doc";
     } else if (exportType.equals("pdf")) {
       filename = "/temp/compreDay_report.pdf";
     }
   }
   String filePath = ResourceCenter.getInstance().getSysPath() + filename;
   String startTime = getParaValue("startdate");
   String toTime = startTime;
   if (startTime == null) {
     startTime = sdf.format(new Date()) + " 00:00:00";
   } else {
     startTime = startTime + " 00:00:00";
   }
   if (toTime == null) {
     toTime = sdf.format(new Date()) + " 23:59:59";
   } else {
     toTime = toTime + " 23:59:59";
   }
   CompreReportExport export = new CompreReportExport();
   export.exportReportByDay(ids, type, reportType, filePath, startTime, toTime, exportType, null);
   request.setAttribute("filename", filePath);
   return "/capreport/net/download.jsp";
 }
Exemplo n.º 5
0
  private String importExcel() {
    String discrictid = "";
    String saveDirPath = ResourceCenter.getInstance().getSysPath() + "WEB-INF/macConfig";
    Fileupload fileupload = new Fileupload(saveDirPath);
    fileupload.doupload(request);
    List formFieldList = fileupload.getFormFieldList();
    List allMacList = null;
    for (int i = 0; i < formFieldList.size(); i++) {
      List formField = (List) formFieldList.get(i);
      String formFieldType = (String) formField.get(0);
      String formFieldName = (String) formField.get(1);
      String formFieldValue = (String) formField.get(2);
      if ("file".equals(formFieldType)) {
        if ("fileName".equals(formFieldName)) {
          List excellist = ExcelUtil.readExcel(new File(formFieldValue));
          allMacList = getAllMacList(excellist);
        }

      } else if ("formField".equals(formFieldType)) {
        if ("discrictid".equals(formFieldName)) {
          discrictid = formFieldValue;
        }
      }
    }
    MacconfigDao macconfigDao = new MacconfigDao();
    List allMacConfiglist = null;
    try {
      allMacConfiglist = macconfigDao.loadAll();
    } catch (RuntimeException e) {
      // TODO Auto-generated catch block
      e.printStackTrace();
    } finally {
      macconfigDao.close();
    }
    if (allMacConfiglist == null) {
      allMacConfiglist = new ArrayList();
    }
    List macConfigList = new ArrayList();
    if (allMacList != null && allMacList.size() > 0) {
      for (int i = 0; i < allMacList.size(); i++) {
        String mac = (String) allMacList.get(i);
        for (int j = 0; j < allMacConfiglist.size(); j++) {
          Macconfig macConfigflag = new Macconfig();
          macConfigflag = (Macconfig) allMacConfiglist.get(j);
          if (mac.trim().equals(macConfigflag.getMac().trim())) {
            allMacConfiglist.remove(j);
          }
        }
        Macconfig macConfig = new Macconfig();
        macConfig.setMac(mac);
        macConfig.setDiscrictid(Integer.parseInt(discrictid));
        macConfig.setMacdesc("");
        allMacConfiglist.add(macConfig);
      }
    }
    macconfigDao = new MacconfigDao();

    try {
      macconfigDao.deleteAll();
    } catch (RuntimeException e) {
      // TODO Auto-generated catch block
      e.printStackTrace();
    } finally {
      macconfigDao.close();
    }

    macconfigDao = new MacconfigDao();

    try {
      macconfigDao.saveBatch(allMacConfiglist);
    } catch (RuntimeException e) {
      // TODO Auto-generated catch block
      e.printStackTrace();
    } finally {
      macconfigDao.close();
    }

    return list();
  }
Exemplo n.º 6
0
  private String importVisioTopo() {

    String flag = request.getParameter("flag");
    HostNode importVisioTopohostnode = new HostNode();
    List _list = new ArrayList();
    if ("1".equals(flag)) {

      String discrictid = "";
      String saveDirPath = ResourceCenter.getInstance().getSysPath() + "WEB-INF/macConfig";

      String community = getParaValue("community");
      String writecommunity = getParaValue("writecommunity");
      int snmpversion = getParaIntValue("snmpversion");
      int collecttype = 0;
      try {
        collecttype = getParaIntValue("collecttype");
      } catch (Exception e) {

      }
      String bid = getParaValue("bid");

      importVisioTopohostnode.setCommunity(community);
      importVisioTopohostnode.setWriteCommunity(writecommunity);
      importVisioTopohostnode.setSnmpversion(snmpversion);
      importVisioTopohostnode.setCollecttype(collecttype);
      importVisioTopohostnode.setBid(bid);

      session.setAttribute("importVisioTopohostnode", importVisioTopohostnode);

      return "/tool/importvisiotopo_list.jsp";
    }
    if ("2".equals(flag)) {
      String discrictid = "";
      String saveDirPath = ResourceCenter.getInstance().getSysPath() + "WEB-INF/macConfig";
      Fileupload fileupload = new Fileupload(saveDirPath);
      fileupload.doupload(request, 10000000);

      HostNode _importVisioTopohostnode =
          (HostNode) session.getAttribute("importVisioTopohostnode");

      List formFieldList = fileupload.getFormFieldList();

      if (null == formFieldList || formFieldList.size() == 0) {
        request.setAttribute("success", false);
      } else {
        for (int i = 0; i < formFieldList.size(); i++) {

          List formField = (List) formFieldList.get(i);
          String formFieldType = (String) formField.get(0);
          String formFieldName = (String) formField.get(1);
          String formFieldValue = (String) formField.get(2);

          if ("file".equals(formFieldType)) {
            if ("fileName".equals(formFieldName)) {
              visio.IVInvisibleApp app = ClassFactory.createInvisibleApp();
              try {
                IVDocument doc = app.documents().open(formFieldValue);
                IVPages pages = doc.pages();
                System.out.println(pages.count());

                for (int index = 1; index <= pages.count(); index++) {
                  IVPage page = pages.item(index);
                  System.out.println(page.nameU());
                  importOnePage(page);
                }
                request.setAttribute("success", true);
              } catch (Exception e) {
                e.printStackTrace();
                request.setAttribute("success", false);
              } finally {
                app.quit();
              }
            }
          }
        }
      }
      return "/tool/importvisiotopo_list.jsp";
    }
    return null;
  }
  /** @author nielin modify at 2010-01-08 */
  public int writeXml(int flag) {
    int done = 0;
    // 需要做分布式判断
    String runmodel = PollingEngine.getCollectwebflag();
    try {
      I_HostLastCollectData hostlastmanager = new HostLastCollectDataManager();
      Hashtable ipAllData = (Hashtable) ShareData.getSharedata().get(ipaddress);

      Vector vector = new Vector();
      String[] netInterfaceItem = {
        "index",
        "ifDescr",
        "ifSpeed",
        "ifAdminStatus",
        "ifOperStatus",
        "OutBandwidthUtilHdx",
        "InBandwidthUtilHdx"
      };
      try {
        if ("0".equals(runmodel)) {
          // 采集与访问是集成模式
          vector = hostlastmanager.getInterface_share(ipaddress, netInterfaceItem, "index", "", "");
        } else {
          // 采集与访问是分离模式
          vector = hostlastmanager.getInterface(ipaddress, netInterfaceItem, "index", "", "");
        }
      } catch (Exception e) {
        e.printStackTrace();
        return done;
      }
      try {
        _fis =
            new FileInputStream(
                ResourceCenter.getInstance().getSysPath()
                    + "panel/model/"
                    + oid
                    + "_"
                    + imageType
                    + ".jsp");
      } catch (Exception e) {
        e.printStackTrace();
        _fis.close();
        return done;
      }
      _fis.skip(headBytes.getBytes().length);
      _builder = new SAXBuilder();
      _doc = _builder.build(_fis);
      _root = _doc.getRootElement();
      _nodes = _root.getChild("nodes");

      List list = _nodes.getChildren();

      PortconfigDao dao = new PortconfigDao();

      try {

        for (int i = 0; i < list.size(); i++) {
          Element eleNode = (Element) list.get(i);
          if (eleNode.getChildText("index") == null) break;
          int index = Integer.valueOf(eleNode.getChildText("index")).intValue();
          String x = eleNode.getChildText("x");
          String y = eleNode.getChildText("y");
          String img = eleNode.getChildText("img");
          String direction = eleNode.getChildText("direction");
          String ifname = "";
          String OutBandwidthUtilHdx = "0";
          String InBandwidthUtilHdx = "0";
          String portuse = "";
          if (vector != null && vector.size() > 0) {
            for (int m = 0; m < vector.size(); m++) {
              String[] strs = (String[]) vector.get(m);
              String _ifname = strs[1];
              String _index = strs[0];
              String opstatus = strs[4];
              OutBandwidthUtilHdx = strs[5];
              InBandwidthUtilHdx = strs[6];

              Portconfig portconfig = null;
              try {
                portconfig = dao.getPanelByipandindex(ipaddress, index + "");
              } catch (Exception e) {

              }
              if (portconfig != null
                  && portconfig.getLinkuse() != null
                  && portconfig.getLinkuse().trim().length() > 0) {
                portuse = portconfig.getLinkuse();
              }

              // SysLogger.info(ipaddress+"====ifOperStatus====="+strs[4]);
              if (Integer.parseInt(_index) == index) {
                ifname = _ifname;
                if ("down".equalsIgnoreCase(opstatus)) {
                  // DOWN
                  if ("1".equalsIgnoreCase(direction)) {
                    // 向上的端口
                    img = "image/up_down_gray.gif";
                  } else {
                    // 向下的端口
                    img = "image/down_down_gray.gif";
                  }
                } else {
                  // UP
                  if ("1".equalsIgnoreCase(direction)) {
                    // 向上的端口
                    img = "image/up_up_green.gif";
                  } else {
                    // 向下的端口
                    img = "image/down_up_green.gif";
                  }
                }
                break;
              }
            }
          }
          addNode(
              index + "",
              InBandwidthUtilHdx,
              OutBandwidthUtilHdx,
              img,
              ipaddress,
              ifname,
              portuse,
              x,
              y);
        }

      } catch (Exception e) {
        e.printStackTrace();
      } finally {
        dao.close();
      }

      Format format = Format.getCompactFormat();
      format.setEncoding("GB2312");
      format.setIndent("	");
      serializer = new XMLOutputter(format);
      // SysLogger.info("path==="+fullPath);
      fos = new FileOutputStream(fullPath);
      fos.write(headBytes.getBytes());
      serializer.output(doc, fos);
      fos.close();
      done = 1;
    } catch (Exception e) {
      done = 0;
      e.printStackTrace();
      SysLogger.error("Error in XmlOperator.close()", e);
    }
    return done;
  }