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; }