function import($smarty, $module_name, $local_templates_dir, $pDB_customer, $arrLang, $arrConf)
{
include "modules/{$module_name}/libs/importExcel.php";
include_once "libs/JSON.php";
$import_dir = "modules/customer/libs/Upload/server/php/files";
$sFileName = getParameter('file');
$filePath = "{$import_dir}/{$sFileName}";
$filePath2 = "/var/www/html/{$import_dir}/{$sFileName}";
$sFileSize = strval(filesize($filePath2));
if (!file_exists($filePath)) {
$response['action'] = 'error';
$response['message'] = 'Lỗi: không tìm thấy file ' . $filePath;
$json = new Services_JSON();
Header('Content-Type: application/json');
return $json->encode($response);
}
$oImport = new importExcel($pDB_customer);
$result = $oImport->import2Db($filePath);
if (!$result) {
$response['action'] = 'error';
$response['message'] = 'Lỗi - ' . $oImport->errMsg;
$json = new Services_JSON();
Header('Content-Type: application/json');
return $json->encode($response);
}
$response['action'] = 'import';
$response['message'] = $result;
$response['message']['filename'] = $sFileName;
$response['message']['filesize'] = $sFileSize;
$json = new Services_JSON();
Header('Content-Type: application/json');
return $json->encode($response);
//echo '<pre>'.print_r($result->import2Db('tmp/KLE.xls'),1).'</pre>';
//echo '<pre>'.print_r($result->arrError,1).'</pre>';
}
{
switch ($type) {
case 'type':
switch ($value) {
case 'CTY':
return 2;
case 'DLY':
return 3;
case 'KLE':
return 0;
default:
return 4;
}
break;
case 'district':
break;
case 'province':
break;
case 'booker':
break;
case 'accountant':
break;
case 'sale':
break;
default:
break;
}
}
}
$result = new importExcel();
echo '<pre>' . print_r($result->convert2Array('sample.xls'), 1) . '</pre>';
