X-Git-Url: http://git.roojs.org/?p=Pman.Core;a=blobdiff_plain;f=ExcelToJson.php;h=e981d32901cb7910e25123b2dcd4a4f95dc6b694;hp=39696cfcda0d3350e21ce04cbc8197436df18e62;hb=refs%2Fheads%2Fwip_edward_T5851_download_old_offer_sheet;hpb=8e393c49eac2a2698f298d882fa29ce5aaf13ee4 diff --git a/ExcelToJson.php b/ExcelToJson.php index 39696cfc..e981d329 100644 --- a/ExcelToJson.php +++ b/ExcelToJson.php @@ -12,7 +12,7 @@ class Pman_Core_ExcelToJson extends Pman_Roo return parent::getAuth(); } - function post() + function post($v) { $this->transObj = DB_DataObject::Factory('invhist_transfer'); @@ -29,10 +29,10 @@ class Pman_Core_ExcelToJson extends Pman_Roo require_once 'File/Convert.php'; $fc = new File_Convert($img->getStoreName(), $img->mimetype ); - $csv = $fc->convert('text/csv'); - $ret = $this->importCsv($csv); + $csv = $fc->convert('text/csv'); + $ret = $this->importCsv($csv); - print_R($ret);exit; + $this->jdata($ret['data'], false, isset($ret['extra']) ? $ret['extra'] : array() ); @@ -54,7 +54,9 @@ class Pman_Core_ExcelToJson extends Pman_Roo $extra = array(); while(false !== ($n = fgetcsv($fh,10000, ',', '"'))) { - if(!array_filter($n)){ + + + if(!strlen(trim(implode('', $n)))){ // blank line; if ($header) { continue; } @@ -89,6 +91,8 @@ class Pman_Core_ExcelToJson extends Pman_Roo } fclose($fh); + + return array('extra' => $extra, 'data' => $rows);; } } \ No newline at end of file