function act_modify_dhl_shenzhen()
{
$objPHPExcel = new PHPExcel();
$PHPReader = new PHPExcel_Reader_Excel2007();
if (!$PHPReader->canRead($filepath)) {
$PHPReader = new PHPExcel_Reader_Excel5();
if (!$PHPReader->canRead($filepath)) {
echo 'no excel!';
return false;
}
}
if (!empty($_FILES)) {
// echo $_FILES['upfile']['name'];
if ($_FILES['upfile1']) {
$filename = date("Y-m-d H:i:s") . rand(1, 3009) . ".xls";
if (move_uploaded_file($_FILES["upfile1"]["tmp_name"], "../xls/" . $filename)) {
$filepath = "../xls/" . $filename;
} else {
self::$errCode = 444;
self::$errMsg = "文件上传失败！";
return;
}
$PHPExcel = $PHPReader->load($filepath);
$excellists = self::excel2array($PHPExcel, $filepath, 0, 11);
for ($i = 1; $i <= 10; $i++) {
unset($excellists[$i]);
}
$weight_freight = array();
$weightlists = array();
foreach ($excellists as $key => $excellist) {
foreach ($excellist as $k => $v) {
if ($k > 1) {
$tekey = isset($excellists[$key - 1]) ? $excellists[$key - 1][1] : 0;
if (!empty($excellist[1])) {
$weightlists[$k - 2][] = $tekey . "-" . $excellist[1] . ":" . $v;
}
}
}
}
foreach ($weightlists as $key => $value) {
$weightfreight = implode(",", $value);
$partition = $key + 1;
shipfeeModel::modify_dhl_shenzhen1($weightfreight, $partition, 1);
}
}
if ($_FILES['upfile2']) {
$filename = date("Y-m-d H:i:s") . rand(1, 3009) . ".xls";
if (move_uploaded_file($_FILES["upfile2"]["tmp_name"], "../xls/" . $filename)) {
$filepath = "../xls/" . $filename;
} else {
self::$errCode = 444;
self::$errMsg = "文件上传失败！";
return;
}
$PHPExcel = $PHPReader->load($filepath);
//$sheet = $PHPExcel->getSheet(0);
$excellists = self::excel2array($PHPExcel, $filepath, 0, 9);
for ($i = 1; $i <= 8; $i++) {
unset($excellists1[$i]);
}
foreach ($excellists1 as $key1 => $excellist) {
$weightlist = '';
if (isset($excellist[1])) {
$weightlist = "20-30:{$excellist[3]},30-70:{$excellist[4]},70-100:{$excellist[5]},100-300:{$excellist[6]},300-500:{$excellist[7]},500-:{$excellist[8]}";
$partition = $key1 + 1;
shipfeeModel::modify_dhl_shenzhen1($weightlist, $partition, 2);
}
}
$partition_list = excel2array($PHPExcel, $filepath, 1, 7);
$country_arr_mode1 = array();
$country_arr_mode2 = array();
foreach ($partition_list as $key => $partition) {
if ($key > 1) {
$country_arr_mode1[$partition[5]][] = "[" . $partition[3] . "]";
$country_arr_mode2[$partition[6]][] = "[" . $patition[3] . "]";
}
}
foreach ($country_arr_mode1 as $key => $country_arr) {
$countries_mode1 = implode(",", $country_arr);
shipfeeModel::modify_dhl_shenzhen2($countries_mode1, $key, 1);
}
foreach ($country_arr_mode2 as $key => $country_arr) {
$countries_mode2 = implode(",", $country_arr);
shipfeeModel::modify_dhl_shenzhen2($countries_mode2, $key, 2);
}
}
}
}
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;
}
