X-Git-Url: http://git.roojs.org/?p=Pman.Core;a=blobdiff_plain;f=ExcelToJson.php;h=e981d32901cb7910e25123b2dcd4a4f95dc6b694;hp=8fe9738a59604faf6aeaa5dcb55f4df876952b77;hb=refs%2Fheads%2Fwip_edward_T5851_download_old_offer_sheet;hpb=ebd3c6efa0f328ac26a9c620bb5815419a30d4fd diff --git a/ExcelToJson.php b/ExcelToJson.php index 8fe9738a..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,8 +91,7 @@ class Pman_Core_ExcelToJson extends Pman_Roo } fclose($fh); - $ret = array('extra' => $extra, 'data' => $rows); - echo 'about to return?';print_R($ret);exit; + return array('extra' => $extra, 'data' => $rows);; }