/*!
* This program is free software; you can redistribute it and/or modify it under the
* terms of the GNU Lesser General Public License, version 2.1 as published by the Free Software
* Foundation.
*
* You should have received a copy of the GNU Lesser General Public License along with this
* program; if not, you can obtain a copy at http://www.gnu.org/licenses/old-licenses/lgpl-2.1.html
* or from the Free Software Foundation, Inc.,
* 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301 USA.
*
* This program is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY;
* without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.
* See the GNU Lesser General Public License for more details.
*
* Copyright (c) 2002-2013 Pentaho Corporation.. All rights reserved.
*/
package org.pentaho.reporting.engine.classic.core.crosstab;
import junit.framework.AssertionFailedError;
import junit.framework.TestCase;
import org.apache.commons.logging.Log;
import org.apache.commons.logging.LogFactory;
import org.pentaho.reporting.engine.classic.core.AttributeNames;
import org.pentaho.reporting.engine.classic.core.ClassicEngineBoot;
import org.pentaho.reporting.engine.classic.core.CrosstabCell;
import org.pentaho.reporting.engine.classic.core.CrosstabCellBody;
import org.pentaho.reporting.engine.classic.core.CrosstabColumnGroup;
import org.pentaho.reporting.engine.classic.core.CrosstabColumnGroupBody;
import org.pentaho.reporting.engine.classic.core.CrosstabGroup;
import org.pentaho.reporting.engine.classic.core.CrosstabRowGroup;
import org.pentaho.reporting.engine.classic.core.CrosstabRowGroupBody;
import org.pentaho.reporting.engine.classic.core.Element;
import org.pentaho.reporting.engine.classic.core.MasterReport;
import org.pentaho.reporting.engine.classic.core.ReportProcessingException;
import org.pentaho.reporting.engine.classic.core.TableDataFactory;
import org.pentaho.reporting.engine.classic.core.filter.types.LabelType;
import org.pentaho.reporting.engine.classic.core.filter.types.TextFieldType;
import org.pentaho.reporting.engine.classic.core.function.AbstractExpression;
import org.pentaho.reporting.engine.classic.core.states.LayoutProcess;
import org.pentaho.reporting.engine.classic.core.states.crosstab.CrosstabSpecification;
import org.pentaho.reporting.engine.classic.core.style.ElementStyleKeys;
import org.pentaho.reporting.engine.classic.core.testsupport.DebugReportRunner;
import org.pentaho.reporting.engine.classic.core.util.TypedTableModel;
/**
* @noinspection HardCodedStringLiteral
*/
public class CrosstabDataTest extends TestCase
{
private static final Log logger = LogFactory.getLog(CrosstabMultiFactDataTest.class);
public CrosstabDataTest(final String name)
{
super(name);
}
public CrosstabDataTest()
{
}
protected void setUp() throws Exception
{
ClassicEngineBoot.getInstance().start();
}
public void testDiagonalMasterDatarow() throws ReportProcessingException
{
final TypedTableModel model = new TypedTableModel(new String[]{"Rows", "Cols", "Data"});
model.addRow("R0", "C0", 1);
model.addRow("R1", "C1", 2);
model.addRow("R2", "C2", 3);
model.addRow("R3", "C3", 4);
final String[][] validateData = new String[][]
{
{"R0", "C0"},
{"R0", "C1"},
{"R0", "C2"},
{"R0", "C3"},
{"R1", "C0"},
{"R1", "C1"},
{"R1", "C2"},
{"R1", "C3"},
{"R2", "C0"},
{"R2", "C1"},
{"R2", "C2"},
{"R2", "C3"},
{"R3", "C0"},
{"R3", "C1"},
{"R3", "C2"},
{"R3", "C3"},
};
final CrosstabSpecification crosstabSpecification = CrosstabTestUtil.fillSortedCrosstabSpec(model);
final int itCount = CrosstabTestUtil.advanceCrosstab(crosstabSpecification, model, validateData);
assertEquals(16, itCount);
}
private static CrosstabGroup createCrosstab()
{
final CrosstabGroup crosstabGroup = new CrosstabGroup();
final CrosstabRowGroupBody rowBody = (CrosstabRowGroupBody) crosstabGroup.getBody();
final CrosstabRowGroup rowGroup = rowBody.getGroup();
rowGroup.setField("Rows");
rowGroup.getTitleHeader().addElement(createDataItem("Rows"));
rowGroup.getHeader().addElement(createFieldItem("Rows"));
final CrosstabColumnGroupBody columnGroupBody = (CrosstabColumnGroupBody) rowGroup.getBody();
final CrosstabColumnGroup columnGroup = columnGroupBody.getGroup();
columnGroup.setField("Cols");
columnGroup.getTitleHeader().addElement(createDataItem("Cols"));
columnGroup.getHeader().addElement(createFieldItem("Cols"));
final CrosstabCellBody body = (CrosstabCellBody) columnGroup.getBody();
final CrosstabCell cell = new CrosstabCell();
cell.addElement(createFieldItem("Data"));
body.addElement(cell);
return crosstabGroup;
}
public static Element createDataItem(final String text)
{
final Element label = new Element();
label.setElementType(LabelType.INSTANCE);
label.setAttribute(AttributeNames.Core.NAMESPACE, AttributeNames.Core.VALUE, text);
label.getStyle().setStyleProperty(ElementStyleKeys.MIN_WIDTH, 100f);
label.getStyle().setStyleProperty(ElementStyleKeys.MIN_HEIGHT, 200f);
return label;
}
public static Element createFieldItem(final String text)
{
final Element label = new Element();
label.setElementType(TextFieldType.INSTANCE);
label.setAttribute(AttributeNames.Core.NAMESPACE, AttributeNames.Core.FIELD, text);
label.getStyle().setStyleProperty(ElementStyleKeys.MIN_WIDTH, 100f);
label.getStyle().setStyleProperty(ElementStyleKeys.MIN_HEIGHT, 200f);
return label;
}
public void testDiagonalReverseMasterRow() throws ReportProcessingException
{
final TypedTableModel model = new TypedTableModel(new String[]{"Rows", "Cols", "Data"});
model.addRow("R0", "C3", 1);
model.addRow("R1", "C2", 2);
model.addRow("R2", "C1", 3);
model.addRow("R3", "C0", 4);
final String[][] validateData = new String[][]
{
{"R0", "C3"},
{"R0", "C2"},
{"R0", "C1"},
{"R0", "C0"},
{"R1", "C3"},
{"R1", "C2"},
{"R1", "C1"},
{"R1", "C0"},
{"R2", "C3"},
{"R2", "C2"},
{"R2", "C1"},
{"R2", "C0"},
{"R3", "C3"},
{"R3", "C2"},
{"R3", "C1"},
{"R3", "C0"},
};
final CrosstabSpecification crosstabSpecification = CrosstabTestUtil.fillOrderedCrosstabSpec(model);
final int itCount = CrosstabTestUtil.advanceCrosstab(crosstabSpecification, model, validateData);
assertEquals(16, itCount);
}
public void testDiagonalReportProcessing() throws Exception
{
final TypedTableModel model = new TypedTableModel(new String[]{"Rows", "Cols", "Data"});
model.addRow("R0", "C0", 1);
model.addRow("R1", "C1", 2);
model.addRow("R2", "C2", 3);
model.addRow("R3", "C3", 4);
final MasterReport report = new MasterReport();
report.setQuery("default");
report.setDataFactory(new TableDataFactory("default", model));
report.setRootGroup(createCrosstab());
report.addExpression(new ValidateExpression(false));
DebugReportRunner.showDialog(report);
DebugReportRunner.layoutPage(report, 0);
}
public void testDiagonalReverseReportProcessing() throws Exception
{
final TypedTableModel model = new TypedTableModel(new String[]{"Rows", "Cols", "Data"});
model.addRow("R0", "C3", 4);
model.addRow("R1", "C2", 3);
model.addRow("R2", "C1", 2);
model.addRow("R3", "C0", 1);
final MasterReport report = new MasterReport();
report.setQuery("default");
report.setDataFactory(new TableDataFactory("default", model));
report.setRootGroup(createCrosstab());
report.addExpression(new ValidateExpression(true));
DebugReportRunner.showDialog(report);
DebugReportRunner.layoutPage(report, 0);
}
private static class ValidateExpression extends AbstractExpression
{
private Object[][] validateData;
private ValidateExpression(final boolean reverse)
{
setName("Validate");
if (reverse)
{
validateData = new Object[][]
{
{"R0", "C0", null},
{"R0", "C1", null},
{"R0", "C2", null},
{"R0", "C3", Integer.valueOf(4)},
{"R1", "C0", null},
{"R1", "C1", null},
{"R1", "C2", Integer.valueOf(3)},
{"R1", "C3", null},
{"R2", "C0", null},
{"R2", "C1", Integer.valueOf(2)},
{"R2", "C2", null},
{"R2", "C3", null},
{"R3", "C0", Integer.valueOf(1)},
{"R3", "C1", null},
{"R3", "C2", null},
{"R3", "C3", null},
};
}
else
{
validateData = new Object[][]
{
{"R0", "C0", Integer.valueOf(1)},
{"R0", "C1", null},
{"R0", "C2", null},
{"R0", "C3", null},
{"R1", "C0", null},
{"R1", "C1", Integer.valueOf(2)},
{"R1", "C2", null},
{"R1", "C3", null},
{"R2", "C0", null},
{"R2", "C1", null},
{"R2", "C2", Integer.valueOf(3)},
{"R2", "C3", null},
{"R3", "C0", null},
{"R3", "C1", null},
{"R3", "C2", null},
{"R3", "C3", Integer.valueOf(4)},
};
}
}
public Object getValue()
{
if (getRuntime().getProcessingContext().getProcessingLevel() == LayoutProcess.LEVEL_STRUCTURAL_PREPROCESSING)
{
return false;
}
if (getRuntime().isCrosstabActive() == false)
{
return false;
}
final int currentRow = getRuntime().getCurrentRow();
final Object row = getDataRow().get("Rows");
final Object col = getDataRow().get("Cols");
final Object data = getDataRow().get("Data");
try
{
assertEquals(validateData[currentRow][0], row);
assertEquals(validateData[currentRow][1], col);
assertEquals(validateData[currentRow][2], data);
return currentRow;
}
catch (AssertionFailedError afe)
{
//throw afe;
return afe;
}
}
}
public void testInvalidReportProcessing() throws Exception
{
final TypedTableModel model = new TypedTableModel();
model.addRow();
model.addRow();
model.addRow();
final MasterReport report = new MasterReport();
report.setQuery("default");
report.setDataFactory(new TableDataFactory("default", model));
report.setRootGroup(createCrosstab());
report.addExpression(new ValidateExpression(false));
DebugReportRunner.layoutPage(report, 0);
}
}