public void executeManualUT() throws Exception {

    StatisticsService statisticsService =
        (StatisticsService) JndiFactory.lookup("statisticsService");
    MaterialService materialService = (MaterialService) JndiFactory.lookup("materialService");

    String departmentUuid = request.getParameter("departmentUuid");
    String campusUuid = request.getParameter("campusUuid");
    String flag = request.getParameter("flag");
    String beginDate = request.getParameter("beginDate");
    String endDate = request.getParameter("endDate");
    String offset = request.getParameter("offset");
    String recnum = request.getParameter("recnum");

    String sql = "select distinct M.* from MaterialScrap M where M.ifUsing = true ";
    Constraint c = new Constraint("MaterialScrap");
    c.addCondition("ifUsing", true);
    if (flag.equals("1")) {
      sql += "and M.keeperUuid = '" + EMPLOYEE.getUuid() + "' ";
      c.addCondition("keeperUuid", EMPLOYEE.getUuid());
    }
    if (departmentUuid != null && departmentUuid.length() > 0) {
      sql += "and M.departmentUuid = '" + departmentUuid + "' ";
      c.addCondition("departmentUuid", departmentUuid);
    }
    if (campusUuid != null && campusUuid.length() > 0) {
      sql += "and M.campusUuid = '" + campusUuid + "' ";
      c.addCondition("campusUuid", campusUuid);
    }
    if (beginDate != null && beginDate.length() > 0) {
      sql += " and recordTime >= '" + beginDate + " 00:00:00'";
      c.addCondition(
          "recordTime", Constants.DATE_FORMAT.parse(beginDate + " 00:00:00' "), Constraint.RTE);
    }
    if (endDate != null && endDate.length() > 0) {
      sql += " and recordTime <= '" + endDate + " 23:59:59' ";
      c.addCondition(
          "recordTime", Constants.DATE_FORMAT.parse(endDate + " 23:59:59'"), Constraint.LTE);
    }

    String sqlCount =
        "select '"
            + statVirtualUuid++
            + "' as uuid, 1 as timeStamp, count from ("
            + sql.replace("distinct M.*", " count(*) as count ")
            + ") as JdoVirtual";
    int count = 0;
    Constraint jdoVirtualC = new Constraint("JdoVirtual");
    jdoVirtualC.addSQLCondition(sqlCount, null);
    JdoVirtual jdoVirtual = statisticsService.selectJdoVirtual(jdoVirtualC);
    if (jdoVirtual.getCount() != null) {
      count = jdoVirtual.getCount().intValue();
    }

    c.addOrderCondition("recordTime", "asc");
    c.addLimitedCondition(Integer.parseInt(offset) - 1, Constraint.OFFSET);
    c.addLimitedCondition(Integer.parseInt(recnum), Constraint.LIMIT);

    List<MaterialScrap> list = materialService.selectMaterialScraps(c);
    List<String[]> tempList = new ArrayList<String[]>();
    for (int i = 0; i < list.size(); i++) {
      MaterialScrap materialScrap = list.get(i);

      String[] str = new String[6];
      str[0] = Integer.toString(Integer.parseInt(offset) + i);
      str[1] = materialScrap.getMaterial().getType().getDescription();
      str[2] = Integer.toString(materialScrap.getAmount());
      str[3] = materialScrap.getDepartment().getDescription();
      str[4] =
          materialScrap.getRecordTime() != null
              ? Constants.DATE_FORMAT_YMD.format(materialScrap.getRecordTime())
              : "";
      str[5] = materialScrap.getUuid();
      tempList.add(str);
    }

    List<Object> resultList = new ArrayList<Object>();
    resultList.add(tempList);
    resultList.add(count);
    setResponseText(resultList);
  }
Esempio n. 2
0
  public void executeManualUT() throws Exception {

    StatisticsService statisticsService =
        (StatisticsService) JndiFactory.lookup("statisticsService");
    MistakeService mistakeService = (MistakeService) JndiFactory.lookup("mistakeService");

    String title = request.getParameter("title");
    String beginDate = request.getParameter("beginDate");
    String endDate = request.getParameter("endDate");
    String offset = request.getParameter("offset");
    String recnum = request.getParameter("recnum");

    String sql = "select distinct M.* from Mistake M where M.ifUsing = true ";
    Constraint c = new Constraint("Mistake");
    c.addCondition("ifUsing", true);
    if (title != null && title.length() > 0) {
      sql += " and title like '%" + title + "%' ";
      c.addCondition("title", "%" + title + "%");
    }
    if (beginDate != null && beginDate.length() > 0) {
      sql += " and recordTime >= '" + beginDate + " 00:00:00'";
      c.addCondition(
          "recordTime", Constants.DATE_FORMAT.parse(beginDate + " 00:00:00' "), Constraint.RTE);
    }
    if (endDate != null && endDate.length() > 0) {
      sql += " and recordTime <= '" + endDate + " 23:59:59' ";
      c.addCondition(
          "recordTime", Constants.DATE_FORMAT.parse(endDate + " 23:59:59'"), Constraint.LTE);
    }

    String sqlCount =
        "select '"
            + statVirtualUuid++
            + "' as uuid, 1 as timeStamp, count from ("
            + sql.replace("distinct M.*", " count(*) as count ")
            + ") as JdoVirtual";
    int count = 0;
    Constraint jdoVirtualC = new Constraint("JdoVirtual");
    jdoVirtualC.addSQLCondition(sqlCount, null);
    JdoVirtual jdoVirtual = statisticsService.selectJdoVirtual(jdoVirtualC);
    if (jdoVirtual.getCount() != null) {
      count = jdoVirtual.getCount().intValue();
    }

    c.addOrderCondition("recordTime", "asc");
    c.addLimitedCondition(Integer.parseInt(offset) - 1, Constraint.OFFSET);
    c.addLimitedCondition(Integer.parseInt(recnum), Constraint.LIMIT);

    List<Mistake> list = mistakeService.selectMistakes(c);
    List<String[]> tempList = new ArrayList<String[]>();
    for (int i = 0; i < list.size(); i++) {
      Mistake mistake = list.get(i);

      String[] str = new String[5];
      str[0] = Integer.toString(Integer.parseInt(offset) + i);
      str[1] = mistake.getTitle();
      str[2] = mistake.getRecorder().getPerson().getName();
      str[3] =
          mistake.getRecordTime() != null
              ? Constants.DATE_FORMAT_YMD.format(mistake.getRecordTime())
              : "";
      str[4] = mistake.getUuid();
      tempList.add(str);
    }

    List<Object> resultList = new ArrayList<Object>();
    resultList.add(tempList);
    resultList.add(count);
    setResponseText(resultList);
  }