public void setup() throws Exception {

    setupProperties();

    ReportDefinition rd = createReportDefinition();

    ReportDesign design =
        h.createRowPerPatientXlsOverviewReportDesign(
            rd,
            "ChemotherapyDailyExpectedPatientList.xls",
            "ChemotherapyDailyPatientList.xls_",
            null);

    Properties props = new Properties();
    props.put("repeatingSections", "sheet:1,row:7,dataset:dataSet");
    props.put("sortWeight", "5000");
    design.setProperties(props);

    h.saveReportDesign(design);

    ReportDesign designTwo =
        h.createRowPerPatientXlsOverviewReportDesign(
            rd,
            "ChemotherapyDailyTreatmentSummary.xls",
            "ChemotherapyDailyTreatmentSummary.xls_",
            null);

    Properties propsTwo = new Properties();
    propsTwo.put("repeatingSections", "sheet:1,row:7,dataset:dataSet");
    props.put("sortWeight", "5000");
    designTwo.setProperties(propsTwo);

    h.saveReportDesign(designTwo);
  }
 public void delete() {
   ReportService rs = Context.getService(ReportService.class);
   for (ReportDesign rd : rs.getAllReportDesigns(false)) {
     if ("ChemotherapyDailyPatientList.xls_".equals(rd.getName())
         || "ChemotherapyDailyTreatmentSummary.xls_".equals(rd.getName())) {
       rs.purgeReportDesign(rd);
     }
   }
   h.purgeReportDefinition("ONC-Chemotherapy Daily Expected Patient List");
 }
コード例 #3
0
  /** Tests that the Report and associated ReportDesigns are successfully saved */
  @Test
  public void shouldSetupReport() throws Exception {
    List<ReportDefinition> l = getReportDefinitionService().getDefinitions(getReportName(), true);
    Assert.assertEquals(0, l.size());

    ReportDefinition reportDefinition = setupReport();
    Assert.assertEquals(getReportName(), reportDefinition.getName());

    ReportService rs = Context.getService(ReportService.class);
    List<ReportDesign> designs = rs.getReportDesigns(reportDefinition, null, false);

    Assert.assertEquals(getReportDesignNames().size(), designs.size());
    int numMatches = 0;
    for (ReportDesign rd : designs) {
      if (getReportDesignNames().contains(rd.getName())) {
        numMatches++;
      }
    }
    Assert.assertEquals(getReportDesignNames().size(), numMatches);
  }
  @Override
  public ReportDesign getReportDesign() {
    ReportDesign design = new ReportDesign();
    design.setName("MOH 361A Register Design");
    design.setReportDefinition(this.getReportDefinition());
    design.setRendererType(ExcelTemplateRenderer.class);

    Properties props = new Properties();
    props.put("repeatingSections", "sheet:2,row:4,dataset:allPatients");

    design.setProperties(props);

    ReportDesignResource resource = new ReportDesignResource();
    resource.setName("template.xls");
    InputStream is =
        OpenmrsClassLoader.getInstance()
            .getResourceAsStream("templates/MOH361AReportTemplate_0_2.xls");

    if (is == null) throw new APIException("Could not find report template.");

    try {
      resource.setContents(IOUtils.toByteArray(is));
    } catch (IOException ex) {
      throw new APIException("Could not create report design for MOH 361A Register.", ex);
    }

    IOUtils.closeQuietly(is);
    design.addResource(resource);

    return design;
  }
コード例 #5
0
 /**
  * @return a Map of String to String that can be used to find repeating sections This converts a
  *     user design property in the format: sheet:3,dataset:allPatients |
  *     sheet:1,row:6-8,dataset:allPatients | sheet:2,column:4,dataset:malePatients into a Map
  *     which can be quickly accessed as each row / column combination is accessed during
  *     processing
  */
 protected Map<String, String> getRepeatingSections(ReportDesign design) {
   Map<String, String> m = new HashMap<String, String>();
   String propertyValue = design.getPropertyValue("repeatingSections", null);
   if (propertyValue != null) {
     for (String sectionConfig : propertyValue.split("\\|")) {
       try {
         Integer sheetNum = null;
         Integer rowNum = null;
         Integer columnNum = null;
         Integer spanNum = null;
         String dataSetName = null;
         for (String sectionComponent : sectionConfig.split(",")) {
           String[] keyValue = sectionComponent.split("\\:");
           String key = keyValue[0].trim().toLowerCase();
           String[] valueSplit = keyValue[1].trim().split("\\-");
           String lowerBound = valueSplit[0].trim();
           String upperBound = valueSplit.length == 1 ? lowerBound : valueSplit[1].trim();
           if ("sheet".equals(key)) {
             sheetNum = Integer.parseInt(lowerBound);
           } else if ("row".equals(key)) {
             rowNum = Integer.parseInt(lowerBound);
             spanNum = Integer.parseInt(upperBound) - rowNum + 1;
           } else if ("column".equals(key)) {
             columnNum = Integer.parseInt(lowerBound);
             spanNum = Integer.parseInt(upperBound) - columnNum + 1;
           } else if ("dataset".equals(key)) {
             dataSetName = lowerBound;
           }
         }
         String key =
             "repeatSheet"
                 + sheetNum
                 + (rowNum != null ? "Row" + rowNum : "")
                 + (columnNum != null ? "Column" + columnNum : "");
         String value = dataSetName + (spanNum != null ? "," + spanNum : "");
         m.put(key, value);
       } catch (Exception e) {
         log.warn(
             "Error in configuration of repeating sections of ExcelTemplateRenderer.  Please check your configuration.",
             e);
       }
     }
   }
   return m;
 }
  @RequestMapping(method = RequestMethod.POST)
  public void process(
      final @RequestParam(required = false, value = "cohort") Integer cohortId,
      final @RequestParam(required = true, value = "template") MultipartFile template,
      final HttpServletResponse response)
      throws IOException, EvaluationException {

    EvaluationContext context = new EvaluationContext();
    context.addParameterValue("currentDate", new Date());
    if (cohortId != null) {
      context.setBaseCohort(Context.getCohortService().getCohort(cohortId));
    }

    PatientDataSetDefinition definition = new PatientDataSetDefinition();

    definition.addColumn(
        "id", new PatientIdDataDefinition(), StringUtils.EMPTY, new ObjectFormatter());

    ListConverter listConverter = new ListConverter();
    listConverter.setMaxNumberOfItems(1);

    PatientIdentifierDataDefinition preferredIdentifier = new PatientIdentifierDataDefinition();
    preferredIdentifier.addType(Context.getPatientService().getPatientIdentifierType(1));
    definition.addColumn("identifier", preferredIdentifier, StringUtils.EMPTY, listConverter);

    definition.addColumn(
        "name",
        new PreferredNameDataDefinition(),
        StringUtils.EMPTY,
        new ObjectFormatter("{familyName}, {givenName}"));

    AgeDataDefinition ageOnDate = new AgeDataDefinition();
    ageOnDate.addParameter(new Parameter("effectiveDate", "effective date", Date.class));
    definition.addColumn("age", ageOnDate, "effectiveDate=${currentDate}", new AgeConverter());

    definition.addColumn(
        "birthdate",
        new BirthdateDataDefinition(),
        StringUtils.EMPTY,
        new BirthdateConverter("dd-MMM-yyyy"));
    definition.addColumn(
        "gender", new GenderDataDefinition(), StringUtils.EMPTY, new ObjectFormatter());

    ReportDefinition reportDefinition = new ReportDefinition();
    reportDefinition.setName("Test Report");
    reportDefinition.addDataSetDefinition("PatientDataSetDefinition", definition, null);

    final ReportDesign design = new ReportDesign();
    design.setName("Test Report Design With Excel Template Renderer");
    design.setReportDefinition(reportDefinition);
    design.setRendererType(ExcelTemplateRenderer.class);

    Properties properties = new Properties();
    properties.put("repeatingSections", "sheet:1,dataset:PatientDataSetDefinition");
    design.setProperties(properties);

    ReportDesignResource resource = new ReportDesignResource();
    resource.setName("excel-template.xls");
    InputStream inputStream = template.getInputStream();
    resource.setContents(IOUtils.toByteArray(inputStream));
    IOUtils.closeQuietly(inputStream);
    design.addResource(resource);

    ExcelTemplateRenderer renderer =
        new ExcelTemplateRenderer() {
          public ReportDesign getDesign(String argument) {
            return design;
          }
        };

    ReportDefinitionService rs = Context.getService(ReportDefinitionService.class);
    ReportData data = rs.evaluate(reportDefinition, context);

    CsvReportRenderer csvReportRenderer = new CsvReportRenderer();
    csvReportRenderer.render(data, "output:csv", System.out);

    File file = File.createTempFile("excel", "summary");
    BufferedOutputStream bufferedOutputStream =
        new BufferedOutputStream(new FileOutputStream(file));
    renderer.render(data, "output:xls", bufferedOutputStream);
    bufferedOutputStream.close();

    response.setHeader("Content-Disposition", "attachment; filename=patient-summary.xls");
    response.setContentType("application/vnd.ms-excel");
    response.setContentLength((int) file.length());

    FileCopyUtils.copy(new FileInputStream(file), response.getOutputStream());
    if (file.delete()) log.info("Temporary file deleted!");
  }