var $worksheet= false;
- function Pman_Core_SimpleExcel($data,$cfg)
+ function __construct($data,$cfg)
{
// print_r($cfg);exit;
require_once 'Spreadsheet/Excel/Writer.php';
$cfg['formats'] = isset($cfg['formats']) ? $cfg['formats'] : array();
$this->formats['_default_date_format_'] = $workbook->addFormat();;
- $this->formats['_default_date_format_']->setNumFormat('YYYY-MM-DD');
+ $this->formats['_default_date_format_']->setNumFormat('YYYY-MM-DD');
foreach($cfg['formats'] as $f=>$fcfg) {
if (empty($data)) {
return;
}
+
foreach($cfg['cols'] as $c => $col_cfg) {
if (isset($col_cfg['renderer'])) {
$hasRender = true;
continue;
}
if (!empty($col_cfg['renderer'])) {
-
- if (is_a($col_cfg['renderer'], 'Closure')) {
+ if (is_a($col_cfg['renderer'], 'Closure')) {
$col_cfg['renderer']($cl[$col_cfg['dataIndex']], $worksheet, $r+1, $c, $cl);
} else {
// not sure if row is correct here...!!!?
if (preg_match('/^[0-9]{4}-[0-9]{2}-[0-9]{2}$/', $v)) {
$dataFormat = 'date';
- $format = empty($format) ? 'YYYY-MM-DD' : $format;
+ $format = empty($format) ? $this->formats['_default_date_format_']: $format;
$ut_to_ed_diff = 86400 * 25569;
+ $gmt = strtotime('1970-01-01');
- $v = (strtotime($v) + $ut_to_ed_diff) / 86400;
- var_Dump(array($format, $v));
+ $v = (strtotime($v) + $ut_to_ed_diff - $gmt) / 86400;
+ // need to +8hrs to get real time..
+
+
}
if ( (is_numeric($v) && strlen($v) > 1 && substr($v,0,1) == '0' && substr($v,1,1) != '.' )