public static function applyTheLineEUBTrackNumber($recordnumber, $tracknumber)
{
!self::$dbConn ? self::initDB() : null;
$SYSTEM_ACCOUNTS = OmAvailableModel::getPlatformAccount();
$accountIds = array();
foreach ($SYSTEM_ACCOUNTS['Amazon'] as $id => $account) {
$accountIds[] = $id;
}
//print_r($SYSTEM_ACCOUNTS['Amazon']);
$tableName = 'om_unshipped_order';
$where = " WHERE recordNumber='{$recordnumber}' AND accountId in ('" . join("','", $accountIds) . "') AND is_delete =0 AND storeId=1 ";
$tinfo = OrderindexModel::showOnlyOrderList($tableName, $where);
self::$errMsg = '';
if ($tinfo) {
$omOrderId = $tinfo[0]['id'];
$trackinfo = OrderindexModel::selectOrderTracknumber(" WHERE tracknumber = '" . $tracknumber . "' AND is_delete = 0 ");
//var_dump($trackinfo);
if ($trackinfo) {
self::$errCode = "001";
self::$errMsg = " 第" . $row . "行已经存在跟踪" . $tinfo['ebay_tracknumber'] . " 新跟踪号[{$tracknumber}]更新失败<br>";
return false;
} else {
$data['omOrderId'] = $omOrderId;
$data['tracknumber'] = $tracknumber;
$data['addUser'] = $_SESSION['sysUserId'];
$data['createdTime'] = time();
$msg = OrderRecordModel::insertOrderTrackRow($data);
//echo $msg;
if (!$msg) {
self::$errCode = "001";
self::$errMsg = " 第" . $row . "行订单号[{$recordnumber}]添加跟踪号[{$tracknumber}]失败<br>";
return false;
}
}
self::$errCode = "200";
self::$errMsg = "获取数据成功";
return true;
//失败则设置错误码和错误信息， 返回false
} else {
self::$errCode = "001";
self::$errMsg = " 第" . $row . "行订单号[{$recordnumber}]不是亚马孙订单或者不存在系统<br>";
return false;
}
}
//echo $maxNum;exit;
$ids = 0;
$times = 0;
for ($i = 0; $i < $maxNum; $i++) {
$dat = array();
//对数组清零
$orderIds = array();
for ($num = $i * $interval; $num < $i * $interval + $interval; $num++) {
$express = '';
$carrier = '';
if (!isset($orders[$num])) {
continue;
}
$ids = $num;
$carrier = $delivery_arr[$orders[$num]['transportId']];
$orderTracknumber = OrderindexModel::selectOrderTracknumber('where is_delete=0 and omOrderId = ' . $orders[$num]['id']);
$tracknumber = $orderTracknumber[0]['tracknumber'];
//echo $tracknumber; echo "\n";
switch ($carrier) {
case 'EUB':
$carrier = 'China Post';
$express = 'ePackage';
break;
case 'FedEx':
$carrier = 'FedEx';
$express = 'Express';
break;
case '德国邮政':
$carrier = 'Specify carrier';
$express = 'Deutsche Post';
break;
