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

   1 /*
   2  * Copyright (C) 2010 Mathieu Baudier <mbaudier@argeo.org>
   3  *
   4  * Licensed under the Apache License, Version 2.0 (the "License");
   5  * you may not use this file except in compliance with the License.
   6  * You may obtain a copy of the License at
   7  *
   8  *         http://www.apache.org/licenses/LICENSE-2.0
   9  *
  10  * Unless required by applicable law or agreed to in writing, software
  11  * distributed under the License is distributed on an "AS IS" BASIS,
  12  * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
  13  * See the License for the specific language governing permissions and
  14  * limitations under the License.
  15  */
  16
  17 package org.argeo.slc.web.mvc.result;
  18
  19 import java.util.Map;
  20
  21 import javax.servlet.http.HttpServletRequest;
  22 import javax.servlet.http.HttpServletResponse;
  23
  24 import jxl.write.Label;
  25 import jxl.write.WritableSheet;
  26 import jxl.write.WritableWorkbook;
  27
  28 import org.argeo.slc.SlcException;
  29 import org.argeo.slc.core.structure.tree.TreeSPath;
  30 import org.argeo.slc.core.test.SlcTestUtils;
  31 import org.argeo.slc.core.test.tree.PartSubList;
  32 import org.argeo.slc.core.test.tree.TreeTestResult;
  33 import org.argeo.slc.test.TestResultPart;
  34 import org.springframework.web.servlet.view.document.AbstractJExcelView;
  35
  36 public class ResultExcelView extends AbstractJExcelView {
  37         public final static String MODELKEY_RESULT = "result";
  38
  39
  40         @SuppressWarnings(value = { "unchecked" })
  41         protected void buildExcelDocument(Map model, WritableWorkbook workbook,
  42                         HttpServletRequest request, HttpServletResponse response) {
  43                 try {
  44                         if (workbook.getNumberOfSheets() == 0) {
  45                                 workbook.createSheet("SLC", 0);
  46                         }
  47                         WritableSheet sheet = workbook.getSheet("SLC");
  48
  49                         TreeTestResult ttr = (TreeTestResult) model
  50                                         .get(MODELKEY_RESULT);
  51
  52                         sheet.addCell(new Label(0, 0, "Result " + ttr.getUuid()));
  53
  54                         int currentRow = 1;
  55                         for (TreeSPath path : ttr.getResultParts().keySet()) {
  56                                 PartSubList lst = ttr.getResultParts().get(path);
  57                                 sheet.addCell(new Label(0, currentRow, "Path " + path));
  58                                 currentRow++;
  59                                 for (TestResultPart part : lst.getParts()) {
  60                                         sheet.addCell(new Label(0, currentRow, SlcTestUtils
  61                                                         .statusToString(part.getStatus())));
  62                                         sheet.addCell(new Label(1, currentRow, part.getMessage()));
  63                                         currentRow++;
  64                                 }
  65                                 currentRow++;// add an empty line between paths
  66                         }
  67                 } catch (Exception e) {
  68                         throw new SlcException("Could not write spreadsheet.", e);
  69                 }
  70         }
  71 }