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)); }