//--------------------------------------------------------------
$table = new Doctrine\DBAL\Schema\Table('ledger_voucher');
$table->addColumn('voucher_slug', 'string', array('length' => 150));
$table->addColumn("voucher_enabled_from", "datetime", array());
$table->addColumn("voucher_enabled_to", "datetime", array());
$table->addColumn('voucher_name', 'string', array('length' => 100));
$table->addColumn('voucher_description', 'string', array('length' => 500));
$table->addColumn('voucher_prefix', 'string', array('length' => 20));
$table->addColumn('voucher_suffix', 'string', array('length' => 20));
$table->addColumn('voucher_sequence_strategy', 'string', array('length' => 20));
$table->addColumn('voucher_sequence_no', 'integer', array('unsiged' => true));
$table->addColumn('voucher_sequence_padding_char', 'string', array('legnth' => '1'));
$table->addColumn('voucher_formatter', 'string', array('length' => 100));
$table->setPrimaryKey(array('voucher_slug', 'voucher_enabled_from'));
$types = array();
foreach ($table->getColumns() as $column) {
$types[$column->getName()] = $column->getType();
}
foreach ($baseVouchers as $result) {
$r = $result->toArray();
echo $result->voucher_slug . ' :: ' . $result->voucher_enabled_from->format('d/m/Y') . ' - ' . $result->voucher_enabled_to->format('d/m/Y') . PHP_EOL;
# We want type list and column is to have same index order
# since both index are column names we can just use same sort function.
ksort($r);
ksort($types);
$project->getDatabase()->insert('ledger_voucher', $r, array_values($types));
}
//-------------------------------------------------------------------
// Return null as we using entity generator not PHP Builder Composite
//
//--------------------------------------------------------------------
