Beispiel #1
0
 @PostConstruct
 public void init() throws SQLException {
   SEARCH_NUM = config.getWebShowNum();
   String startTime = DateUtil.getTime(-(TIME_DIF * (SEARCH_NUM - 1)));
   startTime = startTime.substring(0, 11) + "0";
   START_TIME_CACHE = startTime;
   String sql = "select * from t_com_flow_monitor where substr(collect_time,0,12)>=?";
   List<Map<String, String>> list = dbHelper.getMapList(sql, new Object[] {startTime});
   List<FlowInfo> orderList = new ArrayList<FlowInfo>();
   if (list != null && list.size() > 0) {
     for (Map<String, String> map : list) {
       FlowInfo order = new FlowInfo();
       order.setId(map.get("seq_id"));
       order.setType(map.get("type"));
       order.setSpCode(map.get("sp_code"));
       order.setCollectTime(map.get("collect_time"));
       order.setNum(ChartDataUtil.doubleFormat(Double.parseDouble(map.get("flow_num")), "#.##"));
       orderList.add(order);
     }
   }
   // 列名称
   List<String> seriesList = new ArrayList<String>();
   List<Double> mo85 = new ArrayList<Double>();
   List<Double> mt85 = new ArrayList<Double>();
   List<Double> mo18 = new ArrayList<Double>();
   List<Double> mt18 = new ArrayList<Double>();
   if (orderList.size() > 0) {
     // 存入时间
     for (int i = 0; i < SEARCH_NUM; i++) {
       Double vmo85 = 0D;
       Double vmt85 = 0D;
       Double vmo18 = 0D;
       Double vmt18 = 0D;
       String time = DateUtil.getTime(startTime, i * TIME_DIF);
       if (i == 0) {
         List<String> start = new ArrayList<String>();
         start.add(DateUtil.getWebTime(time));
         cache.put(Type.START, start);
       }
       if (i == (SEARCH_NUM - 1)) {
         List<String> end = new ArrayList<String>();
         end.add(DateUtil.getWebTime(time));
         cache.put(Type.END, end);
       }
       seriesList.add(DateUtil.getShowTime(time));
       for (FlowInfo o : orderList) {
         if (o.getCollectTime().substring(0, 12).equals(time)) {
           if (o.getSpCode().equals("10658585")) {
             if (o.getType().equalsIgnoreCase("mo")) vmo85 = o.getNum();
             if (o.getType().equalsIgnoreCase("mt")) vmt85 = o.getNum();
           }
           if (o.getSpCode().equals("10658618")) {
             if (o.getType().equalsIgnoreCase("mo")) vmo18 = o.getNum();
             if (o.getType().equalsIgnoreCase("mt")) vmt18 = o.getNum();
           }
         }
       }
       mo85.add(vmo85);
       mt85.add(vmt85);
       mo18.add(vmo18);
       mt18.add(vmt18);
     }
   }
   cache.put(Type.FIELD, seriesList);
   cache.put(Type.mo85, mo85);
   cache.put(Type.mt85, mt85);
   cache.put(Type.mo18, mo18);
   cache.put(Type.mt18, mt18);
 }
Beispiel #2
0
  public Map<Type, List> getAllOrder(String startTime, String endTime, int type)
      throws SQLException {
    if (!startTime.endsWith("0")) {
      startTime = DateUtil.getTime(startTime, 10);
      startTime = startTime.substring(0, 11) + "0";
    }
    endTime = endTime.substring(0, 11) + "0";
    int num = 0;
    String sql = "";
    // type:1、分 2、小时 3、天 4、周  5、月
    if (type == 1) {
      try {
        num = DateUtil.getDifTime(startTime, endTime) / TIME_DIF + 1;
      } catch (ParseException e) {
        e.printStackTrace();
      }
      sql =
          "select * from t_com_flow_monitor where substr(collect_time,0,12)>=? and substr(collect_time,0,12)<=?";
    } else if (type == 2) {
      try {
        num = DateUtil.getDifHour(startTime, endTime) + 1;
        sql =
            "select sp_code,type,substr(collect_time,0,10) collect_time,sum(flow_num) flow_num "
                + "from t_com_flow_monitor "
                + "where substr(collect_time,0,12)>=? and substr(collect_time,0,12)<=?"
                + "group by type,sp_code,substr(collect_time,0,10)";
      } catch (ParseException e) {
        e.printStackTrace();
      }
    } else if (type == 3 || type == 4) {
      try {
        if (type == 3) num = DateUtil.getDifDay(startTime, endTime) + 1;
        else if (type == 4) num = DateUtil.getDifDay(startTime, endTime) / 7 + 1;
        sql =
            "select sp_code,type,substr(collect_time,0,8) collect_time,sum(flow_num) flow_num "
                + "from t_com_flow_monitor "
                + "where substr(collect_time,0,12)>=? and substr(collect_time,0,12)<=?  "
                + "group by type,sp_code,substr(collect_time,0,8)";
      } catch (ParseException e) {
        e.printStackTrace();
      }
    } else if (type == 5) {
      try {
        num = DateUtil.getDifMonth(startTime, endTime) + 1;
        sql =
            "select sp_code,type,substr(collect_time,0,6) collect_time,sum(flow_num) flow_num "
                + "from t_com_flow_monitor "
                + "where substr(collect_time,0,12)>=? and substr(collect_time,0,12)<=?  "
                + "group by type,sp_code,substr(collect_time,0,6)";
      } catch (ParseException e) {
        e.printStackTrace();
      }
    }
    Map<Type, List> listMap = new HashMap<Type, List>();
    List<Map<String, String>> list =
        dbHelper.getMapList(
            sql, new Object[] {startTime.substring(0, 12), endTime.substring(0, 12)});
    // 列名称
    List<String> seriesList = new ArrayList<String>();
    List<Double> mo85 = new ArrayList<Double>();
    List<Double> mt85 = new ArrayList<Double>();
    List<Double> mo18 = new ArrayList<Double>();
    List<Double> mt18 = new ArrayList<Double>();
    List<FlowInfo> orderList = new ArrayList<FlowInfo>();
    if (list != null && list.size() > 0) {
      for (Map<String, String> map : list) {
        FlowInfo order = new FlowInfo();
        order.setId(map.get("seq_id"));
        order.setType(map.get("type"));
        order.setSpCode(map.get("sp_code"));
        order.setCollectTime(map.get("collect_time"));
        order.setNum(ChartDataUtil.doubleFormat(Double.parseDouble(map.get("flow_num")), "#.##"));
        orderList.add(order);
      }
    }
    if (orderList.size() > 0 && num > 0) {
      // 存入时间
      for (int i = 0; i < num; i++) {
        Double vmo85 = 0D;
        Double vmt85 = 0D;
        Double vmo18 = 0D;
        Double vmt18 = 0D;
        String time = "";
        if (type == 1) {
          time = DateUtil.getTime(startTime, i * TIME_DIF);
        } else if (type == 2) {
          time = DateUtil.getTime(startTime, i * TIME_DIF * 6).substring(0, 10);
        } else if (type == 3) {
          time = DateUtil.getTime(startTime, i * TIME_DIF * 6 * 24).substring(0, 8);
        } else if (type == 4) {
          time = DateUtil.getTime(startTime, i * TIME_DIF * 6 * 24 * 7).substring(0, 8);
        } else if (type == 5) {
          time = DateUtil.getMonth(startTime, i).substring(0, 6);
        }
        String showTime = DateUtil.getShowTime(time);
        String end = time;
        if (type == 4) {
          end = DateUtil.getTime(startTime, (i * 7 + 6) * TIME_DIF * 6 * 24).substring(0, 8);
          int dif = 0;
          try {
            dif = DateUtil.getDifTime(end, endTime.substring(0, 8));
          } catch (ParseException e) {
            e.printStackTrace();
          }
          if (dif < 0) {
            end = endTime.substring(0, 8);
          }
          showTime = showTime + "~" + DateUtil.getShowTime(end);
        }
        for (FlowInfo o : orderList) {
          if (type == 1) {
            if (o.getCollectTime().substring(0, 12).equals(time)) {

              if (o.getSpCode().equals("10658585")) {
                if (o.getType().equalsIgnoreCase("mo")) vmo85 = o.getNum();
                if (o.getType().equalsIgnoreCase("mt")) vmt85 = o.getNum();
              }
              if (o.getSpCode().equals("10658618")) {
                if (o.getType().equalsIgnoreCase("mo")) vmo18 = o.getNum();
                if (o.getType().equalsIgnoreCase("mt")) vmt18 = o.getNum();
              }
            }
          } else if (type == 2) {
            if (o.getCollectTime().substring(0, 10).equals(time)) {

              if (o.getSpCode().equals("10658585")) {
                if (o.getType().equalsIgnoreCase("mo")) vmo85 = o.getNum();
                if (o.getType().equalsIgnoreCase("mt")) vmt85 = o.getNum();
              }
              if (o.getSpCode().equals("10658618")) {
                if (o.getType().equalsIgnoreCase("mo")) vmo18 = o.getNum();
                if (o.getType().equalsIgnoreCase("mt")) vmt18 = o.getNum();
              }
            }

          } else if (type == 3) {
            if (o.getCollectTime().substring(0, 8).equals(time)) {

              if (o.getSpCode().equals("10658585")) {
                if (o.getType().equalsIgnoreCase("mo")) vmo85 = o.getNum();
                if (o.getType().equalsIgnoreCase("mt")) vmt85 = o.getNum();
              }
              if (o.getSpCode().equals("10658618")) {
                if (o.getType().equalsIgnoreCase("mo")) vmo18 = o.getNum();
                if (o.getType().equalsIgnoreCase("mt")) vmt18 = o.getNum();
              }
            }
          } else if (type == 4) {
            for (int j = 0; j < 7; j++) {
              String newDate = DateUtil.getTime(time, 60 * 24 * j).substring(0, 8);
              if (o.getCollectTime().substring(0, 8).equals(newDate)) {
                if (o.getSpCode().equals("10658585")) {
                  if (o.getType().equalsIgnoreCase("mo")) vmo85 = o.getNum();
                  if (o.getType().equalsIgnoreCase("mt")) vmt85 = o.getNum();
                }
                if (o.getSpCode().equals("10658618")) {
                  if (o.getType().equalsIgnoreCase("mo")) vmo18 = o.getNum();
                  if (o.getType().equalsIgnoreCase("mt")) vmt18 = o.getNum();
                }
              }
            }

          } else if (type == 5) {
            if (o.getCollectTime().substring(0, 6).equals(time)) {
              if (o.getSpCode().equals("10658585")) {
                if (o.getType().equalsIgnoreCase("mo")) vmo85 = o.getNum();
                if (o.getType().equalsIgnoreCase("mt")) vmt85 = o.getNum();
              }
              if (o.getSpCode().equals("10658618")) {
                if (o.getType().equalsIgnoreCase("mo")) vmo18 = o.getNum();
                if (o.getType().equalsIgnoreCase("mt")) vmt18 = o.getNum();
              }
            }
          }
        }
        mo85.add(vmo85);
        mt85.add(vmt85);
        mo18.add(vmo18);
        mt18.add(vmt18);
        seriesList.add(showTime);
      }
    }
    // 列名称
    listMap.put(Type.FIELD, seriesList);
    listMap.put(Type.mo85, mo85);
    listMap.put(Type.mt85, mt85);
    listMap.put(Type.mo18, mo18);
    listMap.put(Type.mt18, mt18);
    return listMap;
  }