public function testSpreadsheetModelBuilder()
{
$modelBuilder = new SpreadsheetModelBuilder();
$cells = [];
$cell1 = new \stdClass();
$cell1->name = 'Foo';
$inputSet11 = new \stdClass();
$input111 = new \stdClass();
$input111->value = 10;
$input111->uncertainty = 0.15;
$inputSet11->inputs = [$input111];
$cell1->inputSets = [$inputSet11];
$cells[] = $cell1;
$cell2 = new \stdClass();
$cell2->name = 'Bar';
$cell2->inputSets = [];
$cells[] = $cell2;
$modelBuilder->bind('cells', $cells);
/** @var Document $result */
$result = $modelBuilder->build(new YamlMappingReader(__DIR__ . '/../Fixtures/mapping.yml'));
$this->assertTrue($result instanceof Document);
$this->assertCount(2, $result->getSheets());
foreach ($result->getSheets() as $sheet) {
$this->assertTrue($sheet instanceof Sheet);
}
$sheet = $result->getSheets()[0];
$this->assertEquals('1 - Foo', $sheet->getLabel());
$this->assertCount(1, $sheet->getTables());
$table = $sheet->getTables()[0];
$this->assertCount(1, $table->getLines());
$this->assertCount(2, $table->getColumns());
$this->assertCount(2, $table->getCells());
}
public function testComplexForeachStructure()
{
/** @var Document $result */
$mappingReader = new YamlMappingReader(__DIR__ . '/../Fixtures/maximalStructure.yml');
$modelBuilder = new SpreadsheetModelBuilder();
$simpleItem1 = new \stdClass();
$simpleItem1->label = 'Test 1';
$simpleItem1->value = 15;
$simpleItem2 = new \stdClass();
$simpleItem2->label = 'Test 2';
$simpleItem2->value = 28;
$simpleItem3 = new \stdClass();
$simpleItem3->label = 'Test 3';
$simpleItem3->value = 34;
$simpleItem4 = new \stdClass();
$simpleItem4->label = 'Test 4';
$simpleItem4->value = 7;
$modelBuilder->bind('listItemsSheet1', [$simpleItem1, $simpleItem2]);
$modelBuilder->bind('listSheets2', ['Sheet 2', 'Sheet 3', 'Sheet 4']);
$modelBuilder->bind('listItemsSheet2', [$simpleItem1, $simpleItem2, $simpleItem3, $simpleItem4]);
$complexItem = new \stdClass();
$category1 = new \stdClass();
$category1->label = 'Category 1';
$category2 = new \stdClass();
$category2->label = 'Category 2';
$category3 = new \stdClass();
$category3->label = 'Category 3';
$complexItem->categories = [1 => $category1, 2 => $category2, 3 => $category3];
$valueItem1 = new \stdClass();
$valueItem1->label = 'Value 1';
$valueItem1->values[1] = 40;
$valueItem1->values[2] = 35;
$valueItem1->values[3] = 25;
$valueItem2 = new \stdClass();
$valueItem2->label = 'Value 2';
$valueItem2->values[1] = 10;
$valueItem2->values[2] = 20;
$valueItem2->values[3] = 70;
$valueItem3 = new \stdClass();
$valueItem3->label = 'Value 3';
$valueItem3->values[1] = 45;
$valueItem3->values[2] = 5;
$valueItem3->values[3] = 50;
$valueItem4 = new \stdClass();
$valueItem4->label = 'Value 4';
$valueItem4->values[1] = 30;
$valueItem4->values[2] = 25;
$valueItem4->values[3] = 45;
$valueItem5 = new \stdClass();
$valueItem5->label = 'Value 5';
$valueItem5->values[1] = 65;
$valueItem5->values[2] = 25;
$valueItem5->values[3] = 10;
$complexItem->values = [$valueItem1, $valueItem2, $valueItem3, $valueItem4, $valueItem5];
$modelBuilder->bind('listItemsSheet3', $complexItem);
$modelBuilder->bindFunction('categoryPercent', function (\stdClass $item, $indexCategory) {
return $item->values[$indexCategory] / array_sum($item->values) * 100;
});
$result = $modelBuilder->build($mappingReader);
$this->assertTrue($result instanceof Document);
$this->assertCount(5, $result->getSheets());
// Sheet 0 ----------------------------------------------------|
$sheet0 = $result->getSheets()[0];
$this->assertEquals('First', $sheet0->getLabel());
$this->assertCount(1, $sheet0->getTables());
// Table
$table = $sheet0->getTables()[0];
$this->assertCount(3, $table->getLines());
$this->assertEquals('Test', $table->getLabel());
// Columns
$this->assertCount(2, $table->getColumns());
$this->assertEquals('F 1', $table->getColumns()[0]->getLabel());
$this->assertEquals('F 2', $table->getColumns()[1]->getLabel());
// Cells
$this->assertEquals('Test 1', $table->getCell($table->getLines()[0], $table->getColumns()[0])->getContent());
$this->assertEquals('Test 2', $table->getCell($table->getLines()[1], $table->getColumns()[0])->getContent());
$this->assertEquals('15', $table->getCell($table->getLines()[0], $table->getColumns()[1])->getContent());
$this->assertEquals('28', $table->getCell($table->getLines()[1], $table->getColumns()[1])->getContent());
// Sheet 1 ----------------------------------------------------|
$sheet1 = $result->getSheets()[1];
$this->assertEquals('Sheet 2 (0)', $sheet1->getLabel());
$this->assertCount(2, $sheet1->getTables());
// Table 0
$table0 = $sheet1->getTables()[0];
$this->assertCount(4, $table0->getLines());
$this->assertNull($table0->getLabel());
// Columns
$this->assertCount(2, $table0->getColumns());
$this->assertEquals('S2-0 1', $table0->getColumns()[0]->getLabel());
$this->assertEquals('S2-0 2', $table0->getColumns()[1]->getLabel());
// Cells
$this->assertCount(8, $table0->getCells());
$this->assertEquals('Test 1', $table0->getCell($table0->getLines()[0], $table0->getColumns()[0])->getContent());
$this->assertEquals('Test 2', $table0->getCell($table0->getLines()[1], $table0->getColumns()[0])->getContent());
$this->assertEquals('Test 3', $table0->getCell($table0->getLines()[2], $table0->getColumns()[0])->getContent());
$this->assertEquals('Test 4', $table0->getCell($table0->getLines()[3], $table0->getColumns()[0])->getContent());
$this->assertEquals('15', $table0->getCell($table0->getLines()[0], $table0->getColumns()[1])->getContent());
$this->assertEquals('28', $table0->getCell($table0->getLines()[1], $table0->getColumns()[1])->getContent());
$this->assertEquals('34', $table0->getCell($table0->getLines()[2], $table0->getColumns()[1])->getContent());
$this->assertEquals('7', $table0->getCell($table0->getLines()[3], $table0->getColumns()[1])->getContent());
// Table 1
$table1 = $sheet1->getTables()[1];
$this->assertCount(1, $table1->getLines());
$this->assertNull($table1->getLabel());
$this->assertCount(0, $table1->getColumns());
$this->assertCount(0, $table1->getCells());
// Sheet 2 ----------------------------------------------------|
$sheet2 = $result->getSheets()[2];
$this->assertEquals('Sheet 3 (1)', $sheet2->getLabel());
$this->assertCount(2, $sheet2->getTables());
// Table 0
$table0 = $sheet2->getTables()[0];
$this->assertCount(4, $table0->getLines());
$this->assertNull($table0->getLabel());
// Columns
$this->assertCount(2, $table0->getColumns());
$this->assertEquals('S2-1 1', $table0->getColumns()[0]->getLabel());
$this->assertEquals('S2-1 2', $table0->getColumns()[1]->getLabel());
// Cells
$this->assertCount(8, $table0->getCells());
$this->assertEquals('Test 1', $table0->getCell($table0->getLines()[0], $table0->getColumns()[0])->getContent());
$this->assertEquals('Test 2', $table0->getCell($table0->getLines()[1], $table0->getColumns()[0])->getContent());
$this->assertEquals('Test 3', $table0->getCell($table0->getLines()[2], $table0->getColumns()[0])->getContent());
$this->assertEquals('Test 4', $table0->getCell($table0->getLines()[3], $table0->getColumns()[0])->getContent());
$this->assertEquals('15', $table0->getCell($table0->getLines()[0], $table0->getColumns()[1])->getContent());
$this->assertEquals('28', $table0->getCell($table0->getLines()[1], $table0->getColumns()[1])->getContent());
$this->assertEquals('34', $table0->getCell($table0->getLines()[2], $table0->getColumns()[1])->getContent());
$this->assertEquals('7', $table0->getCell($table0->getLines()[3], $table0->getColumns()[1])->getContent());
// Table 1
$table1 = $sheet2->getTables()[1];
$this->assertCount(1, $table1->getLines());
$this->assertNull($table1->getLabel());
$this->assertCount(0, $table1->getColumns());
$this->assertCount(0, $table1->getCells());
// Sheet 3 ----------------------------------------------------|
$sheet3 = $result->getSheets()[3];
$this->assertEquals('Sheet 4 (2)', $sheet3->getLabel());
$this->assertCount(2, $sheet3->getTables());
// Table 0
$table0 = $sheet3->getTables()[0];
$this->assertCount(4, $table0->getLines());
$this->assertNull($table0->getLabel());
// Columns
$this->assertCount(2, $table0->getColumns());
$this->assertEquals('S2-2 1', $table0->getColumns()[0]->getLabel());
$this->assertEquals('S2-2 2', $table0->getColumns()[1]->getLabel());
// Cells
$this->assertCount(8, $table0->getCells());
$this->assertEquals('Test 1', $table0->getCell($table0->getLines()[0], $table0->getColumns()[0])->getContent());
$this->assertEquals('Test 2', $table0->getCell($table0->getLines()[1], $table0->getColumns()[0])->getContent());
$this->assertEquals('Test 3', $table0->getCell($table0->getLines()[2], $table0->getColumns()[0])->getContent());
$this->assertEquals('Test 4', $table0->getCell($table0->getLines()[3], $table0->getColumns()[0])->getContent());
$this->assertEquals('15', $table0->getCell($table0->getLines()[0], $table0->getColumns()[1])->getContent());
$this->assertEquals('28', $table0->getCell($table0->getLines()[1], $table0->getColumns()[1])->getContent());
$this->assertEquals('34', $table0->getCell($table0->getLines()[2], $table0->getColumns()[1])->getContent());
$this->assertEquals('7', $table0->getCell($table0->getLines()[3], $table0->getColumns()[1])->getContent());
// Table 1
$table1 = $sheet3->getTables()[1];
$this->assertCount(1, $table1->getLines());
$this->assertNull($table1->getLabel());
$this->assertCount(0, $table1->getColumns());
$this->assertCount(0, $table1->getCells());
// Sheet 4 ----------------------------------------------------|
$sheet4 = $result->getSheets()[4];
$this->assertEquals('Inter', $sheet4->getLabel());
$this->assertCount(1, $sheet4->getTables());
// Table
$table = $sheet4->getTables()[0];
$this->assertCount(5, $table->getLines());
$this->assertNull($table->getLabel());
// Columns
$this->assertCount(10, $table->getColumns());
$this->assertEquals('I 1', $table->getColumns()[0]->getLabel());
$this->assertEquals('', $table->getColumns()[1]->getLabel());
$this->assertEquals('Category 1', $table->getColumns()[2]->getLabel());
$this->assertEquals('ratio', $table->getColumns()[3]->getLabel());
$this->assertEquals('', $table->getColumns()[4]->getLabel());
$this->assertEquals('Category 2', $table->getColumns()[5]->getLabel());
$this->assertEquals('ratio', $table->getColumns()[6]->getLabel());
$this->assertEquals('', $table->getColumns()[7]->getLabel());
$this->assertEquals('Category 3', $table->getColumns()[8]->getLabel());
$this->assertEquals('ratio', $table->getColumns()[9]->getLabel());
// Cells
$this->assertCount(50, $table->getCells());
$this->assertEquals('Value 1', $table->getCell($table->getLines()[0], $table->getColumns()[0])->getContent());
$this->assertEquals('Value 2', $table->getCell($table->getLines()[1], $table->getColumns()[0])->getContent());
$this->assertEquals('Value 3', $table->getCell($table->getLines()[2], $table->getColumns()[0])->getContent());
$this->assertEquals('Value 4', $table->getCell($table->getLines()[3], $table->getColumns()[0])->getContent());
$this->assertEquals('Value 5', $table->getCell($table->getLines()[4], $table->getColumns()[0])->getContent());
$this->assertEquals('', $table->getCell($table->getLines()[0], $table->getColumns()[1])->getContent());
$this->assertEquals('', $table->getCell($table->getLines()[1], $table->getColumns()[1])->getContent());
$this->assertEquals('', $table->getCell($table->getLines()[2], $table->getColumns()[1])->getContent());
$this->assertEquals('', $table->getCell($table->getLines()[3], $table->getColumns()[1])->getContent());
$this->assertEquals('', $table->getCell($table->getLines()[4], $table->getColumns()[1])->getContent());
$this->assertEquals('40', $table->getCell($table->getLines()[0], $table->getColumns()[2])->getContent());
$this->assertEquals('10', $table->getCell($table->getLines()[1], $table->getColumns()[2])->getContent());
$this->assertEquals('45', $table->getCell($table->getLines()[2], $table->getColumns()[2])->getContent());
$this->assertEquals('30', $table->getCell($table->getLines()[3], $table->getColumns()[2])->getContent());
$this->assertEquals('65', $table->getCell($table->getLines()[4], $table->getColumns()[2])->getContent());
$this->assertEquals('40', $table->getCell($table->getLines()[0], $table->getColumns()[3])->getContent());
$this->assertEquals('10', $table->getCell($table->getLines()[1], $table->getColumns()[3])->getContent());
$this->assertEquals('45', $table->getCell($table->getLines()[2], $table->getColumns()[3])->getContent());
$this->assertEquals('30', $table->getCell($table->getLines()[3], $table->getColumns()[3])->getContent());
$this->assertEquals('65', $table->getCell($table->getLines()[4], $table->getColumns()[3])->getContent());
$this->assertEquals('', $table->getCell($table->getLines()[0], $table->getColumns()[4])->getContent());
$this->assertEquals('', $table->getCell($table->getLines()[1], $table->getColumns()[4])->getContent());
$this->assertEquals('', $table->getCell($table->getLines()[2], $table->getColumns()[4])->getContent());
$this->assertEquals('', $table->getCell($table->getLines()[3], $table->getColumns()[4])->getContent());
$this->assertEquals('', $table->getCell($table->getLines()[4], $table->getColumns()[4])->getContent());
$this->assertEquals('35', $table->getCell($table->getLines()[0], $table->getColumns()[5])->getContent());
$this->assertEquals('20', $table->getCell($table->getLines()[1], $table->getColumns()[5])->getContent());
$this->assertEquals('5', $table->getCell($table->getLines()[2], $table->getColumns()[5])->getContent());
$this->assertEquals('25', $table->getCell($table->getLines()[3], $table->getColumns()[5])->getContent());
$this->assertEquals('25', $table->getCell($table->getLines()[4], $table->getColumns()[5])->getContent());
$this->assertEquals('35', $table->getCell($table->getLines()[0], $table->getColumns()[6])->getContent());
$this->assertEquals('20', $table->getCell($table->getLines()[1], $table->getColumns()[6])->getContent());
$this->assertEquals('5', $table->getCell($table->getLines()[2], $table->getColumns()[6])->getContent());
$this->assertEquals('25', $table->getCell($table->getLines()[3], $table->getColumns()[6])->getContent());
$this->assertEquals('25', $table->getCell($table->getLines()[4], $table->getColumns()[6])->getContent());
$this->assertEquals('', $table->getCell($table->getLines()[0], $table->getColumns()[7])->getContent());
$this->assertEquals('', $table->getCell($table->getLines()[1], $table->getColumns()[7])->getContent());
$this->assertEquals('', $table->getCell($table->getLines()[2], $table->getColumns()[7])->getContent());
$this->assertEquals('', $table->getCell($table->getLines()[3], $table->getColumns()[7])->getContent());
$this->assertEquals('', $table->getCell($table->getLines()[4], $table->getColumns()[7])->getContent());
$this->assertEquals('25', $table->getCell($table->getLines()[0], $table->getColumns()[8])->getContent());
$this->assertEquals('70', $table->getCell($table->getLines()[1], $table->getColumns()[8])->getContent());
$this->assertEquals('50', $table->getCell($table->getLines()[2], $table->getColumns()[8])->getContent());
$this->assertEquals('45', $table->getCell($table->getLines()[3], $table->getColumns()[8])->getContent());
$this->assertEquals('10', $table->getCell($table->getLines()[4], $table->getColumns()[8])->getContent());
$this->assertEquals('25', $table->getCell($table->getLines()[0], $table->getColumns()[9])->getContent());
$this->assertEquals('70', $table->getCell($table->getLines()[1], $table->getColumns()[9])->getContent());
$this->assertEquals('50', $table->getCell($table->getLines()[2], $table->getColumns()[9])->getContent());
$this->assertEquals('45', $table->getCell($table->getLines()[3], $table->getColumns()[9])->getContent());
$this->assertEquals('10', $table->getCell($table->getLines()[4], $table->getColumns()[9])->getContent());
}