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;