public function testArrayDatasource_TypeString()
{
$fieldSet = new FieldSet();
$fieldSet->addField('i', '#', FieldType::STRING);
$model = $this->arrayArray('i', array('umbrella', 'simpletablereport', null, '', ' ', 'kelsoncm', "line1\nline2"));
$datasource = new ArrayDatasource($model);
$template = new BaseTemplate($fieldSet);
$renderer = new CsvRenderer($datasource, $template);
$renderer->render($datasource, $template);
$this->assertEquals("umbrella\nsimpletablereport\n\n\n\nkelsoncm\nline1 line2\n", $renderer->getStringBuffer());
}
public function testArrayDatasource_TypeTimestamp()
{
$now = time();
$today = new DateTime("now");
$title = 'H1-Timestamp';
$fieldSet = new FieldSet();
$fieldSet->addField('i', $title, FieldType::TIMESTAMP);
$model = $this->arrayArray('i', array($now, $today, '13/12/2011 00:00:00', '01/01/1901 23:59:59', array('year' => 2013, 'mon' => 12, 'mday' => 15, 'hours' => 23, 'minutes' => 59, 'seconds' => 59), '15/12/2013 23:59:59', null, ''));
$datasource = new ArrayDatasource($model);
$template = new BaseTemplate($fieldSet);
$renderer = new XlsxRenderer($datasource, $template);
$renderer->render($datasource, $template);
/*
$this->assertEquals($this->getTableXML_1Col($title), $renderer->getTableString());
$this->assertEquals(
$this->getSheetXML_1Col_fromArray(array("<c r=\"A1\" t=\"s\"><v>0</v></c>", "<c r=\"A2\" s=\"2\"><v>2.00</v></c>",
"<c r=\"A3\" s=\"2\"><v>3.00</v></c>", "<c r=\"A7\" s=\"2\"><v>6.70</v></c>", "<c r=\"A8\" s=\"2\"><v>7.80</v></c>"))
, $renderer->getSheetString());
$this->assertEquals($this->getSharedXML_1Col($title, 0), $renderer->getSharedStringsString());
*/
}
/**
* Create the fieldset for test of columnCount
* @return FieldSet
*/
public function getFieldsetCount()
{
$fieldSet = new FieldSet();
return $fieldSet->addField('nome', 'Nome', FieldType::STRING)->addField('salario', 'Salário', FieldType::INTEGER)->addField('pagamento', 'Razao', FieldType::INTEGER);
}
public function getFieldset()
{
$fieldSet = new FieldSet();
return $fieldSet->addField('id', '#', FieldType::INTEGER)->addField('nome', 'Nome', FieldType::STRING)->addField('qtde', 'Quantidade', FieldType::INTEGER);
}
