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         @SuppressWarnings(value={"unchecked"})
  38         protected void buildExcelDocument(Map model, WritableWorkbook workbook,
  39                         HttpServletRequest request, HttpServletResponse response) {
  40                 try {
  41                         if (workbook.getNumberOfSheets() == 0) {
  42                                 workbook.createSheet("SLC", 0);
  43                         }
  44                         WritableSheet sheet = workbook.getSheet("SLC");
  45
  46                         TreeTestResult ttr = (TreeTestResult) model
  47                                         .get(GetResultController.MODELKEY_RESULT);
  48
  49                         sheet.addCell(new Label(0, 0, "Result " + ttr.getUuid()));
  50
  51                         int currentRow = 1;
  52                         for (TreeSPath path : ttr.getResultParts().keySet()) {
  53                                 PartSubList lst = ttr.getResultParts().get(path);
  54                                 sheet.addCell(new Label(0, currentRow, "Path " + path));
  55                                 currentRow++;
  56                                 for (TestResultPart part : lst.getParts()) {
  57                                         sheet.addCell(new Label(0, currentRow, SlcTestUtils
  58                                                         .statusToString(part.getStatus())));
  59                                         sheet.addCell(new Label(1, currentRow, part.getMessage()));
  60                                         currentRow++;
  61                                 }
  62                                 currentRow++;// add an empty line between paths
  63                         }
  64                 } catch (Exception e) {
  65                         throw new SlcException("Could not write spreadsheet.", e);
  66                 }
  67         }
  68 }