function act_applyTheLineEUBTrackNumber()
{
global $memc_obj;
//调用memcache获取sku信息
//var_dump($SYSTEM_ACCOUNTS);
require_once WEB_PATH . "lib/PHPExcel.php";
//PHPExcel
//exit;
$addUser = $_SESSION['sysUserId'];
$filePath = WEB_PATH . "html/upload/eub/";
//var_dump($_FILES); exit;
if (!empty($_FILES['theline_upfile']['tmp_name'])) {
$uploadfile = date("Y") . date("m") . date("d") . rand(1, 3009) . ".xls";
$filePath .= $uploadfile;
//echo $filePath;
if (!move_uploaded_file($_FILES['theline_upfile']['tmp_name'], $filePath)) {
self::$errCode = '003';
self::$errMsg = "文件上传失败！";
echo self::$errMsg;
return false;
}
} else {
self::$errCode = '003';
self::$errMsg = "文件上传不成功！";
echo self::$errMsg;
return false;
}
//var_dump($addUser);
$PHPExcel = new PHPExcel();
//var_dump($PHPExcel); exit;
$PHPReader = new PHPExcel_Reader_Excel2007();
//var_dump($PHPReader); exit;
//exit;
//var_dump($PHPReader->canRead($filePath)); exit;
if (!$PHPReader->canRead($filePath)) {
$PHPReader = new PHPExcel_Reader_Excel5();
//var_dump($PHPReader); exit;
if (!$PHPReader->canRead($filePath)) {
echo 'no Excel';
return;
}
}
//exit;
$PHPExcel = $PHPReader->load($filePath);
$excellists = excel2array($PHPExcel, $filePath, 2, 0);
//echo "<pre>";print_r($excellists); exit;
$adjust_time = date('Y-m-d H:i:s');
$recordnumbers = array();
$tracknumbers = array();
foreach ($excellists as $key => $excellist) {
$recordnumbers[] = array_shift($excellist);
$tracknumbers[] = array_shift($excellist);
}
$total = count($recordnumbers);
BaseModel::begin();
//开始事务
for ($ii = 1; $ii < $total; $ii++) {
$recordnumber = $recordnumbers[$ii];
$tracknumber = $tracknumbers[$ii];
//盘点数量
$row = $ii;
if (!preg_match('/^LN[0-9]{9}CN$/', $tracknumber)) {
self::$errMsg .= " 第" . $row . "行" . $tracknumber . " 跟踪号格式有误<br>";
}
if ($tracknumber == "") {
self::$errMsg .= " 第" . $row . "行跟踪号为空请查证<br>";
}
if (!OmEUBTrackNumberModel::applyTheLineEUBTrackNumber($recordnumber, $tracknumber)) {
BaseModel::rollback();
}
}
self::$errCode .= OmEUBTrackNumberModel::$errCode;
self::$errMsg .= OmEUBTrackNumberModel::$errMsg;
BaseModel::commit();
BaseModel::autoCommit();
return true;
}
