X-Git-Url: http://git.roojs.org/?a=blobdiff_plain;f=SimpleExcel.php;h=6515710c392420ebbe241cb58dc0134621642591;hb=e39d2ef242655925971dc44404b4d5ce287424a2;hp=e07fa122e8f2b0a0b2310ebd46a4656b097eb09c;hpb=d9dbee3adbdb72ced659f6cd0f8d12028138b15a;p=Pman.Core

diff --git a/SimpleExcel.php b/SimpleExcel.php
index e07fa122..6515710c 100644
--- a/SimpleExcel.php
+++ b/SimpleExcel.php
@@ -76,7 +76,7 @@ class Pman_Core_SimpleExcel extends Pman
     var $worksheet= false;
     
      
-    function Pman_Core_SimpleExcel($data,$cfg)
+    function __construct($data,$cfg)
     {
       // print_r($cfg);exit;
         require_once 'Spreadsheet/Excel/Writer.php';
@@ -94,7 +94,7 @@ class Pman_Core_SimpleExcel extends Pman
         $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) {
             
@@ -384,11 +384,14 @@ class Pman_Core_SimpleExcel extends Pman
           
             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) != '.' )