runtime/org.argeo.slc.server/src/main/java/org/argeo/slc/web/mvc/result/ResultExcelView.java

   1 package org.argeo.slc.web.mvc.result;
   2
   3 import java.util.Map;
   4
   5 import javax.servlet.http.HttpServletRequest;
   6 import javax.servlet.http.HttpServletResponse;
   7
   8 import jxl.write.Label;
   9 import jxl.write.WritableSheet;
  10 import jxl.write.WritableWorkbook;
  11
  12 import org.argeo.slc.SlcException;
  13 import org.argeo.slc.core.structure.tree.TreeSPath;
  14 import org.argeo.slc.core.test.SlcTestUtils;
  15 import org.argeo.slc.core.test.tree.PartSubList;
  16 import org.argeo.slc.core.test.tree.TreeTestResult;
  17 import org.argeo.slc.test.TestResultPart;
  18 import org.springframework.web.servlet.view.document.AbstractJExcelView;
  19
  20 public class ResultExcelView extends AbstractJExcelView {
  21         @SuppressWarnings(value={"unchecked"})
  22         protected void buildExcelDocument(Map model, WritableWorkbook workbook,
  23                         HttpServletRequest request, HttpServletResponse response) {
  24                 try {
  25                         if (workbook.getNumberOfSheets() == 0) {
  26                                 workbook.createSheet("SLC", 0);
  27                         }
  28                         WritableSheet sheet = workbook.getSheet("SLC");
  29
  30                         TreeTestResult ttr = (TreeTestResult) model
  31                                         .get(GetResultController.MODELKEY_RESULT);
  32
  33                         sheet.addCell(new Label(0, 0, "Result " + ttr.getUuid()));
  34
  35                         int currentRow = 1;
  36                         for (TreeSPath path : ttr.getResultParts().keySet()) {
  37                                 PartSubList lst = ttr.getResultParts().get(path);
  38                                 sheet.addCell(new Label(0, currentRow, "Path " + path));
  39                                 currentRow++;
  40                                 for (TestResultPart part : lst.getParts()) {
  41                                         sheet.addCell(new Label(0, currentRow, SlcTestUtils
  42                                                         .statusToString(part.getStatus())));
  43                                         sheet.addCell(new Label(1, currentRow, part.getMessage()));
  44                                         currentRow++;
  45                                 }
  46                                 currentRow++;// add an empty line between paths
  47                         }
  48                 } catch (Exception e) {
  49                         throw new SlcException("Could not write spreadsheet.", e);
  50                 }
  51         }
  52 }