foreach($re['join_names'] as $c=>$f) {
$re['cols'][$c] = $f;
}
+
+
foreach($re['cols'] as $c=>$f) {
$ret[] = array(
'name' => $c,
);
}
+
+
+ require_once 'Pman/Core/SimpleExcel.php';
+ $x = new Pman_Core_SimpleExcel(
+ array($bt,$et, $ut), array(
+ 'formats' => array(
+ 'vtop' => array('vAlign' => 'top'),
+ 'vcenter' => array('vAlign' => 'vcenter'),
+
+ 'percent' => array('vAlign' => 'vcenter', 'numFormat' => '0%'),
+ 'money' => array('vAlign' => 'vcenter', 'numFormat' => '$#,###'),
+ 'date' => array('vAlign' => 'vcenter', 'numFormat' => 'd/M/Y'),
+ ),
+ 'workbooks' => array(
+ array(
+ 'workbook' => 'Business',
+ 'cols' => explode('|', 'keyIdentity_taxId|description|type|countryIso3|countryRegion|addr1|addr2|addr3|city|zip')
+ ),
+ array(
+ 'workbook' => 'Employment',
+ 'cols' => explode('|', 'emailAddress|identity_taxId')
+ ),
+ array(
+ 'workbook' => 'Users',
+ 'cols' => explode('|', 'generateLogin|firstName|middleName|lastName|emailAddress|locale|countryIso3|countryRegion|addr1|addr2|addr3|city|zip|userStatus')
+ ),
+ )
+
+ ));
+ $x->send('test_'. date('d_M_Y').'.xls');
$this->jdata($ret);