function testBasicUsage()
{
$model = new \Core3\Model\Spreadsheet();
$model->addRow(array(37, 'hej', '2000-05-05'));
$model->addRow(array(11, 'vö rääå', '2010-12-31'));
$writer = new \Core3\Writer\Spreadsheet\Json();
$this->assertEquals('[[37,"hej","2000-05-05"],[11,"vö rääå","2010-12-31"]]', $writer->render($model));
}
function testFooterColumn()
{
// NOTE tests that footer column colspan is calculated correctly
$model = new \Core3\Model\Spreadsheet();
$model->defineColumns(array('id', 'name', 'result'));
$model->addRow(array(1, 'a', 200.57));
$model->addRow(array(2, 'b', 319.11));
$model->setFooter(array('SUMMARY', 'TOTAL'));
$writer = new \Core3\Writer\Spreadsheet\Xhtml();
$this->assertEquals($writer->render($model), '<table class="htmlBox">' . '<tr><th>id</th><th>name</th><th>result</th></tr>' . '<tr><td>1</td><td>a</td><td>200.57</td></tr>' . '<tr><td>2</td><td>b</td><td>319.11</td></tr>' . '<tr><th colspan="2">SUMMARY</th><th>TOTAL</th></tr>' . '</table>');
}
function testEmbedHtmlImage()
{
// NOTE: to embed images, use <img src=""> tag but specify a path to an existing file
$model = new \Core3\Model\Spreadsheet();
$model->defineColumns(array('id', 'name'));
$model->addRow(array('1', 'kalle'));
$model->addRow(array('2', 'olle'));
$imgFile = tempnam('/tmp', 'embedHtmlImage');
$this->createJpeg($imgFile);
$writer = new Pdf();
$writer->setStartHtmlBlock('<img src="' . $imgFile . '"/><br/>');
$writer->setEndHtmlBlock('<h2>GOODBYE</h2>');
$data = $writer->render($model);
unlink($imgFile);
$reader = new \Core3\Reader\BinaryData\Document();
$this->assertEquals(true, $reader->isRecognized($data));
$this->assertEquals(true, $reader->isPdfData($data));
}
function testRequiredEscaping()
{
// NOTE verifies that columns with special characters are escaped properly
$model = new \Core3\Model\Spreadsheet();
$model->defineColumns(array('ti,tel', 'namn', 'datum', 'antal'));
$model->addRow(array('a 1', 'böp,på', 'cdwd', 'devef'));
$writer = new Csv();
$writer->setLineEnding("\n");
$this->assertEquals($writer->render($model), '"ti,tel";namn;datum;antal' . "\n" . 'a 1;"böp,på";cdwd;devef' . "\n");
}
function testRecognizePdf()
{
$model = new \Core3\Model\Spreadsheet();
$model->defineColumns(array('name'));
$model->addRow(array('kalle'));
$writer = new \Core3\Writer\Spreadsheet\Pdf();
$data = $writer->render($model);
$reader = new \Core3\Reader\BinaryData\Document();
$this->assertEquals(true, $reader->isRecognized($data));
$this->assertEquals(true, $reader->isPdfData($data));
}
/**
* @expectedException \Core3\Exception\InvalidArgument
*/
function testAddRowWrongColumns()
{
$model = new \Core3\Model\Spreadsheet();
$model->defineColumns(array('c1', 'c2'));
$model->addRow(array(1, 2, 3));
}
