Exemplo n.º 1
0
  public WivArcCd4Form() {
    super(
        tr("menu.query.wiv.arc.cd4"),
        tr("form.query.wiv.label.arc.cd4"),
        tr("file.query.wiv.arc.cd4"));

    String query =
        "select tr, pc, bd "
            + "from TestResult tr join tr.patient p join p.patientAttributeValues bd join p.patientAttributeValues pc "
            + "where pc.attribute.name = 'PatCode' and bd.attribute.name = 'Birth date' "
            + "and (tr.test.testType.description = '"
            + StandardObjects.getCd4TestType().getDescription()
            + "' "
            + "or tr.test.testType.description = '"
            + StandardObjects.getCd4PercentageTestType().getDescription()
            + "') "
            + "and tr.testDate >= :var_start_date and tr.testDate <= :var_end_date "
            + "and "
            + getArcPatientQuery("p.id")
            + " "
            + "and "
            + getContactConstraint("p.id");

    setQuery(query);

    setStartDate(DateUtils.getDateOffset(getEndDate(), Calendar.YEAR, -1));
  }
Exemplo n.º 2
0
  @Override
  @SuppressWarnings("unchecked")
  protected void process(File csvFile) throws Exception {

    Transaction t = createTransaction();
    Query q = createQuery(t);

    List<Object[]> list = (List<Object[]>) q.list();
    if (list.size() < 1) throw new EmptyResultException();

    ArrayList<String> row;
    Table out = new Table();

    for (Object[] o : list) {
      TestResult tr = (TestResult) o[0];
      PatientAttributeValue pc = (PatientAttributeValue) o[1];
      PatientAttributeValue bdt = (PatientAttributeValue) o[2];
      Date bd = DateUtils.parseDate(bdt.getValue());

      Date tDate = tr.getTestDate();
      int testCode = TestCode.T4.getCode();

      if (bd != null
          && tDate != null
          && DateUtils.getDateOffset(bd, Calendar.YEAR, 15).after(tDate)) {
        // < 15 years old at time of test
        testCode = TestCode.T4PERCENT.getCode();
        if (!tr.getTest()
            .getTestType()
            .getDescription()
            .equals(StandardObjects.getCd4PercentageTestType().getDescription())) continue;
      } else {
        if (tr.getTest()
            .getTestType()
            .getDescription()
            .equals(StandardObjects.getCd4PercentageTestType().getDescription())) continue;
      }

      String value = tr.getValue();

      row = new ArrayList<String>();

      row.add(getCentreName());
      row.add(OriginCode.ARC.getCode() + "");
      row.add(pc.getValue());
      row.add(getFormattedDate(tDate));
      row.add(TypeOfInformationCode.LAB_RESULT.getCode() + "");
      row.add(testCode + "");
      row.add(getFormattedDecimal(value, 0, 0));
      row.add("");

      out.addRow(row);
    }

    t.commit();
    out.exportAsCsv(new FileOutputStream(csvFile), ';', false);
  }