package org.argeo.slc.web.mvc.result;

import java.util.Map;

import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import jxl.write.Label;
import jxl.write.WritableSheet;
import jxl.write.WritableWorkbook;

import org.argeo.slc.SlcException;
import org.argeo.slc.core.structure.tree.TreeSPath;
import org.argeo.slc.core.test.SlcTestUtils;
import org.argeo.slc.core.test.tree.PartSubList;
import org.argeo.slc.core.test.tree.TreeTestResult;
import org.argeo.slc.test.TestResultPart;
import org.springframework.web.servlet.view.document.AbstractJExcelView;

public class ResultExcelView extends AbstractJExcelView {
	@SuppressWarnings(value={"unchecked"})
	protected void buildExcelDocument(Map model, WritableWorkbook workbook,
			HttpServletRequest request, HttpServletResponse response) {
		try {
			if (workbook.getNumberOfSheets() == 0) {
				workbook.createSheet("SLC", 0);
			}
			WritableSheet sheet = workbook.getSheet("SLC");

			TreeTestResult ttr = (TreeTestResult) model
					.get(GetResultController.MODELKEY_RESULT);

			sheet.addCell(new Label(0, 0, "Result " + ttr.getUuid()));

			int currentRow = 1;
			for (TreeSPath path : ttr.getResultParts().keySet()) {
				PartSubList lst = ttr.getResultParts().get(path);
				sheet.addCell(new Label(0, currentRow, "Path " + path));
				currentRow++;
				for (TestResultPart part : lst.getParts()) {
					sheet.addCell(new Label(0, currentRow, SlcTestUtils
							.statusToString(part.getStatus())));
					sheet.addCell(new Label(1, currentRow, part.getMessage()));
					currentRow++;
				}
				currentRow++;// add an empty line between paths
			}
		} catch (Exception e) {
			throw new SlcException("Could not write spreadsheet.", e);
		}
	}
}