public function act_getpartsaleandnosendall()
{
$sku = $_GET['sku'];
$isCache = true;
if (isset($_GET['cache'])) {
$isCache = $_GET['cache'];
}
if (empty($sku)) {
self::$errCode = '5806';
self::$errMsg = 'sku is error';
return array();
}
$data = OldsystemModel::getpartsaleandnosendall($sku, $isCache);
return $data;
}
function act_sureAddOrder()
{
$order_data = array();
$detail_data = array();
$exten_data = array();
$userinfo_data = array();
$buyer_data = array();
$time = time();
$platform_id = trim($_POST['platform']);
$username = trim($_POST['fullname']);
$account_id = trim($_POST['account']);
$street1 = trim($_POST['street1']);
$platformUsername = trim($_POST['userid']);
$email = trim($_POST['ebay_usermail1']);
$street2 = trim($_POST['street2']);
$recordNumber = trim($_POST['orderid']);
$city = trim($_POST['city']);
$ordersTime = strtotime(trim($_POST['ebay_createdtime']));
$state = trim($_POST['state']);
$paymentTime = strtotime(trim($_POST['ebay_paidtime']));
$countryname = trim($_POST['country']);
$ebay_itemprice = trim($_POST['ebay_itemprice']);
$zipCode = trim($_POST['zip']);
$shippingFee = trim($_POST['ebay_shipfee']);
$ebay_tel1 = trim($_POST['tel1']);
$actualTotal = trim($_POST['ebay_total']);
$ebay_tel2 = trim($_POST['tel2']);
$ebay_tel3 = trim($_POST['tel3']);
$currency = trim($_POST['ebay_currency']);
$other_currency = trim($_POST['other_currency']);
$isCheckOrder = self::act_checkOrder();
$returnArr = array();
//返回的数组信息
if (!$isCheckOrder) {
$returnArr['errCode'] = self::$errCode;
$returnArr['errMsg'] = self::$errMsg;
return $returnArr;
}
if ($currency == '其他') {
$currency = $other_currency;
}
$phone = trim($_POST['tel1']);
$transId = trim($_POST['ebay_ptid']);
$other_ptid = trim($_POST['other_ptid']);
if ($transId == 'paypal' || $transId == 'Escrow' || $transId == '其他') {
$transId = $other_ptid;
}
$PayPalPaymentId = $transId;
$orderweight = trim($_POST['orderweight']);
$ebay_usermail2 = trim($_POST['ebay_usermail2']);
$ebay_carrier = trim($_POST['ebay_carrier']);
$ebay_usermail3 = trim($_POST['ebay_usermail3']);
$ebay_tracknumber = trim($_POST['ebay_tracknumber']);
$ebay_noteb = trim($_POST['ebay_noteb']);
$orderStatus = 100;
$orderType = 101;
$tracknumber = trim($_POST['ebay_tracknumber']);
//order信息
$orderData[$recordNumber]['orderData']['recordNumber'] = $recordNumber;
$orderData[$recordNumber]['orderData']['ordersTime'] = $ordersTime;
$orderData[$recordNumber]['orderData']['paymentTime'] = $paymentTime;
$orderData[$recordNumber]['orderData']['actualTotal'] = $actualTotal;
$orderData[$recordNumber]['orderData']['onlineTotal'] = $actualTotal;
//默认线上总价和实际总价一样
$orderData[$recordNumber]['orderData']['orderAddTime'] = time();
//$orderData[$recordNumber]['orderData']['calcWeight'] = $orderweight;//估算重量
$orderData[$recordNumber]['orderData']['accountId'] = $account_id;
$orderData[$recordNumber]['orderData']['platformId'] = $platform_id;
//添加状态信息
$orderData[$recordNumber]['orderData']['orderStatus'] = 100;
$orderData[$recordNumber]['orderData']['orderType'] = 101;
$SYS_ACCOUNTS = OmAvailableModel::getPlatformAccount();
foreach ($SYS_ACCOUNTS as $platform => $accounts) {
foreach ($accounts as $accountId => $accountname) {
if ($account_id == $accountId) {
if ($platform == 'ebay') {
//为ebay平台
$orderData[$recordNumber]['orderData']['isFixed'] = 2;
} else {
$orderData[$recordNumber]['orderData']['isFixed'] = 1;
}
}
}
}
$transportation = CommonModel::getCarrierList();
//所有的
foreach ($transportation as $tranValue) {
if ($tranValue['id'] == $ebay_carrier) {
$orderData[$recordNumber]['orderData']['transportId'] = $tranValue['id'];
break;
}
}
//order扩展信息
$orderData[$recordNumber]['orderExtenData']['currency'] = $currency;
$orderData[$recordNumber]['orderExtenData']['paymentStatus'] = "PAY_SUCCESS";
//$orderData[$recordNumber]['orderExtenData']['transId'] = $transId;
$orderData[$recordNumber]['orderExtenData']['PayPalPaymentId'] = $PayPalPaymentId;
$orderData[$recordNumber]['orderExtenData']['platformUsername'] = $platformUsername;
//user信息
$orderData[$recordNumber]['orderUserInfoData']['platformUsername'] = $platformUsername;
$orderData[$recordNumber]['orderUserInfoData']['username'] = $username;
$orderData[$recordNumber]['orderUserInfoData']['email'] = $email;
$orderData[$recordNumber]['orderUserInfoData']['street'] = $street1;
$orderData[$recordNumber]['orderUserInfoData']['currency'] = $currency;
$orderData[$recordNumber]['orderUserInfoData']['address2'] = $street2;
$orderData[$recordNumber]['orderUserInfoData']['city'] = $city;
$orderData[$recordNumber]['orderUserInfoData']['state'] = $state;
$orderData[$recordNumber]['orderUserInfoData']['zipCode'] = $zipCode;
$orderData[$recordNumber]['orderUserInfoData']['countryName'] = $countryname;
$orderData[$recordNumber]['orderUserInfoData']['landline'] = !empty($ebay_tel2) ? $ebay_tel2 : $ebay_tel3;
$orderData[$recordNumber]['orderUserInfoData']['phone'] = $phone;
//note信息
if (!empty($ebay_noteb)) {
$orderData[$recordNumber]['orderNote']['content'] = $ebay_noteb;
$orderData[$recordNumber]['orderNote']['userId'] = $_SESSION['sysUserId'];
$orderData[$recordNumber]['orderNote']['createdTime'] = time();
}
//tracknumer信息
$orderData[$recordNumber]['orderTrack']['tracknumber'] = $tracknumber;
$sku_list = $_POST['sku'];
$sku_count = $_POST['qty'];
$ebay_itemtitle = $_POST['name'];
$count = count($sku_list);
for ($i = 0; $i < $count; $i++) {
//detail信息
$sku = $sku_list[$i];
$orderData[$recordNumber]['orderDetail'][$sku]['orderDetailData']['sku'] = $sku_list[$i];
$orderData[$recordNumber]['orderDetail'][$sku]['orderDetailData']['amount'] += $sku_count[$i];
//累加
$orderData[$recordNumber]['orderDetail'][$sku]['orderDetailData']['recordNumber'] = $recordNumber;
$orderData[$recordNumber]['orderDetail'][$sku]['orderDetailData']['createdTime'] = time();
$orderData[$recordNumber]['orderDetail'][$sku]['orderDetailExtenData']['itemTitle'] = $ebay_itemtitle[$i];
}
foreach ($orderData as $id => $order) {
//$orderData 中第一维只有一个元素，方便起见这里用foreach，虽然只循环一次
$ret = commonModel::checkOrder($recordNumber);
if ($ret) {
$returnArr['errCode'] = 101;
$returnArr['errMsg'] = "订单{$recordNumber}已存在！";
return $returnArr;
}
//计算订单属性
if (count($order['orderDetail']) == 1) {
$detail = current($order['orderDetail']);
if ($detail['orderDetailData']['amount'] == 1) {
$orderData[$id]['orderData']['orderAttribute'] = 1;
} else {
$orderData[$id]['orderData']['orderAttribute'] = 2;
}
} else {
$orderData[$id]['orderData']['orderAttribute'] = 3;
}
//计算订单重量及包材
$obj_order_detail_data = array();
foreach ($order['orderDetail'] as $sku => $detail) {
$obj_order_detail_data[] = $detail['orderDetailData'];
}
$weightfee = commonModel::calcOrderWeight($obj_order_detail_data);
$orderData[$id]['orderData']['calcWeight'] = $weightfee[0];
$orderData[$id]['orderData']['pmId'] = $weightfee[1];
$calcShippingInfo = CommonModel::calcAddOrderShippingFee($orderData[$id], $orderData[$id]['orderData']['isFixed']);
//计算运费
$orderData[$id]['orderData']['channelId'] = $calcShippingInfo['channelId'];
$orderData[$id]['orderData']['calcShipping'] = $calcShippingInfo['fee'];
//调用旧系统接口，先插入数据到旧系统
$rtn = OldsystemModel::orderErpInsertorder($orderData[$id]);
$insertData = array();
if (empty($rtn)) {
$returnArr['errCode'] = 102;
$returnArr['errMsg'] = "接口返回异常，请重试！";
return $returnArr;
}
if ($rtn['errcode'] == 200) {
$rtn_data = $rtn['data'];
$orderId = $rtn_data['orderId'];
//echo "插入老系统成功，订单编号 [$orderId] \n";
$pmId = $rtn_data['pmId'];
$totalweight = $rtn_data['totalweight'];
$shipfee = $rtn_data['shipfee'];
$carrier = $rtn_data['carrier'];
$carrierId = $rtn_data['carrierId'];
$status = $rtn_data['status'];
$orderData[$id]['orderData']['id'] = $orderId;
//赋予新系统订单编号
if ($orderData['orderData']['calcWeight'] != $totalweight) {
$insertData['old_totalweight'] = $totalweight;
$insertData['new_totalweight'] = $orderData[$id]['orderData']['calcWeight'];
$orderData[$id]['orderData']['calcWeight'] = $totalweight;
}
if ($orderData['orderData']['pmId'] != $pmId) {
$insertData['old_pmId'] = $pmId;
$insertData['new_pmId'] = $orderData[$id]['orderData']['pmId'];
$orderData[$id]['orderData']['pmId'] = $pmId;
}
if ($orderData['orderData']['calcShipping'] != $shipfee) {
$insertData['old_shippfee'] = $shipfee;
$insertData['new_shippfee'] = $orderData[$id]['orderData']['calcShipping'];
$orderData[$id]['orderData']['calcShipping'] = $shipfee;
}
if ($orderData['orderData']['transportId'] != $carrierId) {
$insertData['old_carrierId'] = $carrierId;
$insertData['new_carrierId'] = $orderData[$id]['orderData']['transportId'];
$orderData[$id]['orderData']['transportId'] = $carrierId;
}
if (!empty($insertData)) {
$insertData['ebay_id'] = $orderId;
$insertData['addtime'] = time();
//var_dump($insertData);
OldsystemModel::insertTempSyncRecords($insertData);
// 插入临时对比记录表
}
//缺货拦截
$orderData[$id] = AutoModel::auto_contrast_intercept($orderData[$id]);
//插入订单
$info = OrderAddModel::insertAllOrderRowNoEvent($orderData[$id]);
if ($info) {
$returnArr['errCode'] = 200;
$returnArr['errMsg'] = "订单{$id}上传成功！";
} else {
$returnArr['errCode'] = 404;
$returnArr['errMsg'] = "订单{$id}上传失败！";
}
} else {
$returnArr['errCode'] = 400;
$returnArr['errMsg'] = "添加失败，原因为：{$rtn['msg']}！";
}
}
return $returnArr;
}
public function view_deletePlatformList()
{
$id = isset($_GET['id']) ? post_check($_GET['id']) : '';
$status = '';
if (intval($id) == 0) {
$status = '数据异常，删除失败';
header("location:index.php?mod=omPlatform&act=getOmPlatformList&status={$status}");
exit;
}
$omAvailableAct = new OmAvailableAct();
$tName = 'om_platform';
$where = "WHERE is_delete=0 and id='{$id}'";
$count = $omAvailableAct->act_getTNameCount($tName, $where);
if (!$count) {
$status = '记录不存在，删除失败';
header("location:index.php?mod=omPlatform&act=getOmPlatformList&status={$status}");
exit;
}
//获取原始平台账号
$platformInfo = $omAvailableAct->act_getTNameList($tName, 'platform', ' where id=' . $id);
$old_platform = $platformInfo[0]['platform'];
$set = "SET is_delete=1 ";
$where = "WHERE id='{$id}'";
$affectRow = $omAvailableAct->act_updateTNameRow($tName, $set, $where);
if ($affectRow) {
//更新老系统
$returnInfo = OldsystemModel::erpSyncPlatform($old_platform, 'delete', $old_platform);
if ($returnInfo['res_code'] == 200) {
$status = '删除成功';
} else {
$status = '更新老系统失败';
}
} else {
$status = '删除失败';
}
header("location:index.php?mod=omPlatform&act=getOmPlatformList&status={$status}");
}
function act_addInStatusIds()
{
//global $memc_obj; //调用memcache获取sku信息
$outid = $_POST['outid'];
$idArr = $_POST['idArr'];
$uid = $_SESSION['sysUserId'];
$data = array();
$data['visible_movefolder'] = $this->act_getAllInStatusIds();
//var_dump($data);
$data['visible_movefolder'][$outid] = $idArr;
$data['visible_movefolder'] = json_encode($data['visible_movefolder'], JSON_UNESCAPED_UNICODE);
//var_dump($data);
$rtn = OmAccountModel::addUserCompense($uid, $data);
$visible_movefolder = omAccountModel::idTransferName($data['visible_movefolder']);
//调用老系统接口，同步老系统文件夹
$rtnInfo = OldsystemModel::erpSyncMovefolders($visible_movefolder, $_SESSION['userCnName']);
if ($rtnInfo['res_code'] == 200) {
self::$errCode = OmAccountModel::$errCode;
self::$errMsg = OmAccountModel::$errMsg;
return $rtn;
} else {
self::$errCode = $rtnInfo['res_code'];
self::$errMsg = '同步老系统文件夹移动权限失败';
return false;
}
}
function __handle_ebay_orderxml(&$SellerOrderArray, $ebay_account)
{
global $FLIP_GLOBAL_EBAY_ACCOUNT;
if (!isset($FLIP_GLOBAL_EBAY_ACCOUNT)) {
$omAvailableAct = new OmAvailableAct();
$GLOBAL_EBAY_ACCOUNT = $omAvailableAct->act_getTNameList2arrById('om_account', 'id', 'account', ' WHERE is_delete=0 ');
$FLIP_GLOBAL_EBAY_ACCOUNT = array_flip($GLOBAL_EBAY_ACCOUNT);
}
global $mctime, $_allow_spide_itemid;
$account_suffix = get_account_suffix($ebay_account);
$message = "";
foreach ($SellerOrderArray as $SellerOrder) {
//每个订单号
$oSellerOrderID = $SellerOrder->getElementsByTagName('OrderID')->item(0)->nodeValue;
//oCreatingUserRole用于判断是否是 combined payments
$oCreatingUserRole = @$SellerOrder->getElementsByTagName('CreatingUserRole')->item(0)->nodeValue;
$oAmountPaid = $SellerOrder->getElementsByTagName('AmountPaid')->item(0)->nodeValue;
$shippingDeatil = $SellerOrder->getElementsByTagName('ShippingDetails')->item(0);
$oRecordNumber = $shippingDeatil->getElementsByTagName('SellingManagerSalesRecordNumber')->item(0)->nodeValue;
$shippingDeatil = null;
unset($shippingDeatil);
//订单状态
$CheckoutStatus = $SellerOrder->getElementsByTagName('CheckoutStatus')->item(0);
$LastTimeModified = strtotime($CheckoutStatus->getElementsByTagName('LastModifiedTime')->item(0)->nodeValue);
$oeBayPaymentStatus = $CheckoutStatus->getElementsByTagName('eBayPaymentStatus')->item(0)->nodeValue;
$oCompleteStatus = $CheckoutStatus->getElementsByTagName('Status')->item(0)->nodeValue;
$oCheckStatus = $CheckoutStatus->getElementsByTagName('Status')->item(0)->nodeValue;
$CheckoutStatus = null;
unset($CheckoutStatus);
//该订单交易信息
$osoTransArray = $SellerOrder->getElementsByTagName('Transaction');
//其他交易信息比如payapl整合到ebay
$oTid = 0;
//兼容表结构,其实此时还没有交易号的概念
$ExtTran = $SellerOrder->getElementsByTagName('ExternalTransaction')->item(0);
$noptid_trans = false;
if (!empty($ExtTran)) {
$oPtid = $ExtTran->getElementsByTagName('ExternalTransactionID')->item(0)->nodeValue;
$oFeeOrCreditAmount = $ExtTran->getElementsByTagName('FeeOrCreditAmount')->item(0)->nodeValue;
} else {
$oPtid = '0';
$oFeeOrCreditAmount = 0.0;
echo " Notice : [{$oSellerOrderID}]Not ebay offical paypal trans\n";
$noptid_trans = true;
}
//以下信息强制以订单的transation数据中第一条交易为准而取
if (is_object($osoTransArray->item(0)->getElementsByTagName('Buyer')->item(0))) {
$oEmail = str_rep($osoTransArray->item(0)->getElementsByTagName('Buyer')->item(0)->getElementsByTagName('Email')->item(0)->nodeValue);
} else {
echo "\n同步订单未获取邮箱\n";
$oEmail = "";
}
$oSite = str_rep($osoTransArray->item(0)->getElementsByTagName('Item')->item(0)->getElementsByTagName('Site')->item(0)->nodeValue);
if (empty($oSite)) {
$oSite = str_rep($osoTransArray->item(0)->getElementsByTagName('TransactionSiteID')->item(0)->nodeValue);
}
//货币类型
$oCurrency = $osoTransArray->item(0)->getElementsByTagName('TransactionPrice')->item(0)->attributes->item(0)->nodeValue;
//userid
$oUserID = str_rep($SellerOrder->getElementsByTagName('BuyerUserID')->item(0)->nodeValue);
$BuyerInfo = $SellerOrder->getElementsByTagName('ShippingAddress')->item(0);
$oName = str_rep($BuyerInfo->getElementsByTagName('Name')->item(0)->nodeValue);
$oName = mysql_real_escape_string($oName);
$oStreet1 = str_rep($BuyerInfo->getElementsByTagName('Street1')->item(0)->nodeValue);
$oStreet2 = str_rep($BuyerInfo->getElementsByTagName('Street2')->item(0)->nodeValue);
$oCityName = str_rep($BuyerInfo->getElementsByTagName('CityName')->item(0)->nodeValue);
$oStateOrProvince = str_rep($BuyerInfo->getElementsByTagName('StateOrProvince')->item(0)->nodeValue);
$oCountry = str_rep($BuyerInfo->getElementsByTagName('Country')->item(0)->nodeValue);
$oCountryName = str_rep($BuyerInfo->getElementsByTagName('CountryName')->item(0)->nodeValue);
$oPostalCode = str_rep($BuyerInfo->getElementsByTagName('PostalCode')->item(0)->nodeValue);
$oPhone = $BuyerInfo->getElementsByTagName('Phone')->item(0)->nodeValue;
$BuyerInfo = null;
unset($BuyerInfo);
//顾客留言
$oBuyerCheckoutMessage = @str_rep($SellerOrder->getElementsByTagName('BuyerCheckoutMessage')->item(0)->nodeValue);
//顾客购买留言
$oBuyerCheckoutMessage = str_replace('<![CDATA[', '', $oBuyerCheckoutMessage);
$oBuyerCheckoutMessage = str_replace(']]>', '', $oBuyerCheckoutMessage);
//付款时间
$oPaidTime = strtotime($SellerOrder->getElementsByTagName('PaidTime')->item(0)->nodeValue);
$oCreateTime = strtotime($SellerOrder->getElementsByTagName('CreatedTime')->item(0)->nodeValue);
$oShippedTime = @strtotime($SellerOrder->getElementsByTagName('ShippedTime')->item(0)->nodeValue);
$SSS = $SellerOrder->getElementsByTagName('ShippingServiceSelected')->item(0);
$oShipingService = $SSS->getElementsByTagName('ShippingService')->item(0)->nodeValue;
$oShipingFee = $SSS->getElementsByTagName('ShippingServiceCost')->item(0)->nodeValue;
$SSS = null;
unset($SSS);
//店铺收款paypal account
//$oPayPalEmailAddress = @$SellerOrder->getElementsByTagName('PayPalEmailAddress')->item(0)->nodeValue;
$_itemid = $osoTransArray->item(0)->getElementsByTagName('ItemID')->item(0)->nodeValue;
$oPayPalEmailAddress = $this->getPayPalEmailAddress($_itemid);
//var_dump($Item_Elements);
//$oPayPalEmailAddress = $Item_Elements->getElementsByTagName('PayPalEmailAddress')->nodeValue;
//echo $oCompleteStatus."======".$oeBayPaymentStatus."======".$oPaidTime; echo "\n";
if ($oCompleteStatus == "Complete" && $oeBayPaymentStatus == "NoPaymentFailure" && $oPaidTime > 0) {
$oOrderStatus = 1;
}
if ($noptid_trans === true) {
//不是通过ebay官方交易的paypal交易
if ($oCompleteStatus == "Complete" && $oeBayPaymentStatus == "NoPaymentFailure" && $oPaidTime > 0) {
$oOrderStatus = 687;
}
}
$is_allow_spide_itemid = false;
if ($oPaidTime <= 0 || $oPaidTime == '' || empty($oPaidTime) && count($osoTransArray) == 1) {
$_QuantityPurchased = $osoTransArray->item(0)->getElementsByTagName('QuantityPurchased')->item(0)->nodeValue;
if (in_array($_itemid, $_allow_spide_itemid) && $_QuantityPurchased > 0) {
echo "未付款促销订单抓取--------";
$oOrderStatus = $_QuantityPurchased == 1 ? 687 : 688;
$oAmountPaid = 9999;
$oPaidTime = $oCreateTime;
$is_allow_spide_itemid = true;
$buyAddress = $this->getSellerTransactions($oSellerOrderID);
$oName = str_rep($buyAddress->getElementsByTagName('Name')->item(0)->nodeValue);
$oName = mysql_real_escape_string($oName);
$oStreet1 = str_rep($buyAddress->getElementsByTagName('Street1')->item(0)->nodeValue);
$oCityName = str_rep($buyAddress->getElementsByTagName('CityName')->item(0)->nodeValue);
$oStateOrProvince = str_rep($buyAddress->getElementsByTagName('StateOrProvince')->item(0)->nodeValue);
$oCountry = str_rep($buyAddress->getElementsByTagName('Country')->item(0)->nodeValue);
$oCountryName = str_rep($buyAddress->getElementsByTagName('CountryName')->item(0)->nodeValue);
$oPostalCode = str_rep($buyAddress->getElementsByTagName('PostalCode')->item(0)->nodeValue);
$oPhone = $buyAddress->getElementsByTagName('Phone')->item(0)->nodeValue;
}
}
if ($oShippedTime > 0) {
$oOrderStatus = 2;
}
//已经发货
$oRefundAmount = 0;
//表示未垦退款
if ($oOrderStatus == 1 && $oShippedTime <= 0 && $oPaidTime > 0 || $oOrderStatus == 4 && $oShippedTime <= 0 || in_array($oOrderStatus, array(687, 688)) && $oShippedTime <= 0 && $is_allow_spide_itemid == true) {
echo "eBay订单号[{$oSellerOrderID}]有效 ,订单类型[{$oOrderStatus}] ";
$check_ebayorderid = true;
//检查汇总表该 eBay 订单号是否已经存在
//echo "===={$oSellerOrderID}==={$ebay_account}====";//检测重复抓单信息
$where = " where orderid='" . $oSellerOrderID . "' and accountId='" . $FLIP_GLOBAL_EBAY_ACCOUNT[$ebay_account] . "' ";
$check_ebayorderid = OrderidsModel::judgeOrderidsList('orderid', $where);
//取消
$check_ebayorderid == false;
$new_ebay_id = true;
if ($check_ebayorderid === false) {
//添加订单汇总
/* 生成一个本地系统订单号 */
//$our_sys_ordersn=date('Y-m-d-His').mt_rand(100,999).$oRecordNumber;
$oorder_no = '';
//已废弃
$isNote = 0;
if (!empty($oBuyerCheckoutMessage)) {
$isNote = 1;
}
$orderData = array();
$orderData = array('orderData' => array('recordNumber' => $oRecordNumber, 'platformId' => 1, 'accountId' => $FLIP_GLOBAL_EBAY_ACCOUNT[$ebay_account], 'ordersTime' => $oCreateTime, 'paymentTime' => $oPaidTime, 'onlineTotal' => $oAmountPaid, 'actualTotal' => $oAmountPaid, 'transportId' => '', 'actualShipping' => $oShipingFee, 'orderStatus' => C("STATEPENDING"), 'orderType' => C("STATEPENDING_CONV"), 'orderAttribute' => 1, 'channelId' => '', 'orderAddTime' => $mctime, 'isNote' => $isNote, 'storeId' => 1), 'orderExtenData' => array('declaredPrice' => 0.0, 'paymentStatus' => $oCompleteStatus, 'transId' => 1, 'PayPalPaymentId' => $oPtid, 'site' => $oSite, 'orderId' => $oSellerOrderID, 'platformUsername' => $oUserID, 'currency' => $oCurrency, 'feedback' => $oBuyerCheckoutMessage, 'PayPalEmailAddress' => $oPayPalEmailAddress, 'eBayPaymentStatus' => $oeBayPaymentStatus), 'orderUserInfoData' => array('username' => $oName, 'platformUsername' => $oUserID, 'email' => $oEmail, 'countryName' => $oCountryName, 'countrySn' => $oCountry, 'currency' => $oCurrency, 'state' => $oStateOrProvince, 'city' => $oCityName, 'street' => $oStreet1, 'address2' => $oStreet2, 'address3' => '', 'landline' => $oPhone, 'phone' => $ebay_state, 'zipCode' => $oPostalCode));
echo "\tUserID:{$oUserID}" . " AMT:{$oAmountPaid} recordNO:{$oRecordNumber} 付款状态:{$oCompleteStatus} 付款时间:" . date('Y-m-d H:i:s', $oPaidTime) . "\n";
//添加订单明细
$obj_order_detail_data = array();
foreach ($osoTransArray as $transaction) {
//该交易的销售编号
$tran_recordnumber = $transaction->getElementsByTagName('ShippingDetails')->item(0)->getElementsByTagName('SellingManagerSalesRecordNumber')->item(0)->nodeValue;
/* 多属性订单 */
$attribute = '';
$buy_with_attr = false;
$tran_varia = $transaction->getElementsByTagName('Variation')->item(0);
if (is_object($tran_varia)) {
//未添加明细的属性 20130301
if ($tran_varia->hasChildNodes()) {
$Variation = $tran_varia->getElementsByTagName('NameValueList')->item(0);
if (!empty($Variation) && $Variation->hasChildNodes()) {
foreach ($Variation as $variate) {
$aname = $variate->getElementsByTagName('Name')->item(0)->nodeValue;
$avalue = $variate->getElementsByTagName('Value')->item(0)->nodeValue;
$attribute .= $aname . ":" . $avalue . " ";
}
}
$buy_with_attr = true;
$Variation = null;
unset($Variation);
}
}
$tran_id = $transaction->getElementsByTagName('TransactionID')->item(0)->nodeValue;
//该交易的物品信息
$odItem = $transaction->getElementsByTagName('Item')->item(0);
if ($buy_with_attr === true) {
$odItemTitle = @$tran_varia->getElementsByTagName('VariationTitle')->item(0)->nodeValue;
$odSKU = @$tran_varia->getElementsByTagName('SKU')->item(0)->nodeValue;
} else {
$odItemTitle = str_rep($odItem->getElementsByTagName('Title')->item(0)->nodeValue);
$odSKU = str_rep($odItem->getElementsByTagName('SKU')->item(0)->nodeValue);
}
$is_suffix = 0;
if (!empty($account_suffix)) {
list($truesku, $skusuffix) = explode(':', $odSKU);
if (!empty($skusuffix)) {
$odSKU = $truesku;
$is_suffix = 1;
}
}
###########悲剧 目前getorder api 无法取得下面2个值#########
//ebay刊登物品的分类ID,备用字段
//$CategoryID = @$odItem->getElementsByTagName('PrimaryCategory')->item(0)->getElementsByTagName('CategoryID')->item(0)->nodeValue;
//$ListingType = @$odItem->getElementsByTagName('ListingType')->item(0)->nodeValue;
$CategoryID = 0;
$ListingType = '';
//购买数量
$QuantityPurchased = $transaction->getElementsByTagName('QuantityPurchased')->item(0)->nodeValue;
//交易创建时间
$CreatedDate = strtotime($transaction->getElementsByTagName('CreatedDate')->item(0)->nodeValue);
$FinalValueFee = $transaction->getElementsByTagName('FinalValueFee')->item(0)->nodeValue;
$tran_price = $transaction->getElementsByTagName('TransactionPrice')->item(0)->nodeValue;
$goodsshippingcost = $transaction->getElementsByTagName('ActualShippingCost')->item(0)->nodeValue;
$goodsshippingcost = empty($goodsshippingcost) ? '0.0' : $goodsshippingcost;
$tran_itemid = $odItem->getElementsByTagName('ItemID')->item(0)->nodeValue;
$tran_site = $odItem->getElementsByTagName('Site')->item(0)->nodeValue;
//$obj_order_detail =new eBayOrderDetail();
$obj_order_detail_data[] = array('orderDetailData' => array('recordNumber' => $tran_recordnumber, 'itemPrice' => $tran_price, 'sku' => strtoupper($odSKU), 'amount' => $QuantityPurchased, 'shippingFee' => $goodsshippingcost, 'createdTime' => $mctime), 'orderDetailExtenData' => array('itemId' => $tran_itemid, 'transId' => $tran_id, 'itemTitle' => $odItemTitle, 'itemURL' => '', 'shippingType' => $oShipingService, 'FinalValueFee' => $FinalValueFee, 'FeeOrCreditAmount' => $oFeeOrCreditAmount, 'ListingType' => $ListingType, 'note' => $oBuyerCheckoutMessage));
}
$orderData['orderDetail'] = $obj_order_detail_data;
$rtn = OldsystemModel::orderErpInsertorder($orderData);
//var_dump($rtn);
$insertData = array();
if ($rtn['errcode'] == 200) {
var_dump($rtn);
$rtn_data = $rtn['data'];
$orderId = $rtn_data['orderId'];
echo "插入老系统成功，订单编号 [{$orderId}] \n";
$pmId = $rtn_data['pmId'];
$totalweight = $rtn_data['totalweight'];
$shipfee = $rtn_data['shipfee'];
$carrier = $rtn_data['carrier'];
$carrierId = $rtn_data['carrierId'];
$status = $rtn_data['status'];
$orderData['orderData']['id'] = $orderId;
//赋予新系统订单编号@20140501
$calcInfo = CommonModel::calcAddOrderWeight($obj_order_detail_data);
//计算重量和包材
//var_dump($calcInfo);
$orderData['orderData']['ORcalcWeight'] = $calcInfo[0];
$orderData['orderData']['calcWeight'] = $calcInfo[0];
$orderData['orderData']['pmId'] = $calcInfo[1];
if ($orderData['orderData']['calcWeight'] != $totalweight) {
$insertData['old_totalweight'] = $totalweight;
$insertData['new_totalweight'] = $orderData['orderData']['calcWeight'];
}
if ($orderData['orderData']['pmId'] != $pmId) {
$insertData['old_pmId'] = $pmId;
$insertData['new_pmId'] = $orderData['orderData']['pmId'];
}
if (count($orderData['orderDetail']) > 1) {
$orderData['orderData']['orderAttribute'] = 3;
} else {
if (isset($orderData['orderDetail'][0]['orderDetailData']['amount']) && $orderData['orderDetail'][0]['orderDetailData']['amount'] > 1) {
$orderData['orderData']['orderAttribute'] = 2;
}
}
$calcShippingInfo = TransAPIModel::trans_carriers_best_get($orderData['orderData']['calcWeight'], $orderData['orderUserInfoData']['countryName'], $ebay_account, $orderData['orderData']['actualTotal']);
//计算运费
//var_dump($calcShippingInfo);
$orderData['orderData']['calcShipping'] = $calcShippingInfo['fee'];
$orderData['orderData']['transportId'] = $calcShippingInfo['carrierId'];
$orderData['orderData']['ORtransportId'] = $calcShippingInfo['carrierId'];
$orderData['orderData']['channelId'] = $calcShippingInfo['channelId'];
$orderData['orderData']['ORchannelId'] = $calcShippingInfo['channelId'];
if ($orderData['orderData']['calcShipping'] != $shipfee) {
$insertData['old_shippfee'] = $shipfee;
$insertData['new_shippfee'] = $orderData['orderData']['calcShipping'];
}
if ($orderData['orderData']['transportId'] != $carrierId) {
$insertData['old_carrierId'] = $carrierId;
$insertData['new_carrierId'] = $orderData['orderData']['transportId'];
}
if (!empty($insertData)) {
$insertData['ebay_id'] = $orderId;
$insertData['addtime'] = time();
var_dump($insertData);
OldsystemModel::insertTempSyncRecords($insertData);
// 插入临时对比记录表
}
$orderData = AutoModel::auto_contrast_intercept($orderData);
$statusArr = StatusMenuModel::getStatusMenuByOldStatus($status);
if (empty($statusArr)) {
echo "未获取老系统状态{$status}转换新码\n";
} else {
$orderData['orderData']['ORorderStatus'] = $statusArr[0];
$orderData['orderData']['ORorderType'] = $statusArr[1];
$orderData['orderData']['orderStatus'] = $statusArr[0];
$orderData['orderData']['orderType'] = $statusArr[1];
}
if (OrderAddModel::insertAllOrderRow($orderData)) {
echo "本地 Record No. [{$oRecordNumber}] 入库成功\n";
$message .= "<font color='green'>本地订单号 [{$oRecordNumber}] 入库成功</font><br>";
} else {
echo OrderAddModel::$errMsg;
$message .= "<font color='red'>本地订单号 [{$oRecordNumber}] 入库失败</font><br>";
}
} else {
var_dump($rtn);
}
//exit;
} else {
echo "本地订单号 [{$oRecordNumber}] 入库失败\n";
$message .= "<font color='red'>本地订单号 [{$oRecordNumber}] 入库失败</font><br>";
}
} else {
echo "eBay订单号[{$oSellerOrderID}] 记录编号[{$oRecordNumber}] 无效 不入库...\t";
$message .= "<font color='red'>{$oSellerOrderID}无效 不入库...</font><br>";
if ($oShippedTime > 0 || $oOrderStatus == 2) {
echo "已经发货\t";
$message .= "<font color='red'>{$oSellerOrderID}已经发货</font><br>";
}
if ($oPaidTime <= 0 || $oPaidTime == '' || empty($oPaidTime)) {
echo "未付款\t";
$message .= "<font color='red'>{$oSellerOrderID}未付款</font><br>";
}
echo "\n";
//pop_ebay_orderid_queue($oSellerOrderID,$ebay_account);
}
}
return $message;
}
public static function insertTempSyncRecords($data)
{
!self::$dbConn ? self::initDB() : null;
$string = array2sql($data);
$sql = "INSERT INTO " . self::$tempsyncTable . " SET {$string} ";
//echo $sql; echo "\n";
if (!self::$dbConn->query($sql)) {
self::$errCode = "002";
self::$errMsg = " 插入临时信息失败！";
return false;
//失败则设置错误码和错误信息， 返回false
}
self::$errCode = "200";
self::$errMsg = " 插入临时信息成功！";
return true;
//失败则设置错误码和错误信息， 返回false
}
function act_invokeListOrders(MarketplaceWebServiceOrders_Interface $service, $request, $account, $site, $accountId, $flip_transportList, $message)
{
// /global $account, $site, $accountId, $flip_transportList , $message;
try {
$response = $service->getOrder($request);
//echo ("Service Response\n");
//echo ("=============================================================================\n");
if ($response->isSetGetOrderResult()) {
//echo ("ListOrdersResult\n");
$listOrdersResult = $response->getGetOrderResult();
/*if ($listOrdersResult->isSetNextToken()) {
//echo (" NextToken----");
//echo ($listOrdersResult->getNextToken() . "\n");
}
if ($listOrdersResult->isSetCreatedBefore()) {
//echo ("CreatedBefore----");
//echo ($listOrdersResult->getCreatedBefore() . "\n");
}
if ($listOrdersResult->isSetLastUpdatedBefore()) {
//echo ("LastUpdatedBefore----");
//echo ($listOrdersResult->getLastUpdatedBefore() . "\n");
}*/
if ($listOrdersResult->isSetOrders()) {
$orders = $listOrdersResult->getOrders();
$orderList = $orders->getOrder();
$orderIndex = 1;
$now = time();
//BaseModel :: begin(); //开始事务
foreach ($orderList as $order) {
//echo ("***********Orders $orderIndex************\n\n");
$orderIndex++;
$orderData = array();
//om_unshipped_order
$orderUserInfoData = array();
//om_unshipped_order_userInfo
$orderExtenData = array();
//om_unshipped_order_extension
$street2 = '';
//街道2
$street3 = '';
//街道3
if ($order->isSetAmazonOrderId() && $order->isSetOrderStatus() && $order->getOrderStatus() == 'Unshipped') {
//$orderData['ebay_status'] = 1; //同步进来的订单的状态
$orderData['recordNumber'] = $order->getAmazonOrderId();
//平台上的订单id
//echo "AmazonOrderId ==== {$orderData['recordNumber']}\n";
} else {
//echo 'getOrderStatus======' . $order->getOrderStatus() . "\n";
if ($order->getOrderStatus() == 'Shipped') {
//表示已经发货了的订单
$shippedRecordNum = $order->getAmazonOrderId();
$tName = 'om_shipped_order';
$where = "WHERE recordNumber='{$shippedRecordNum}' and accountId='{$accountId}' and ShippedTime=''";
$set = "SET ShippedTime='{$now}'";
//标记发货时间
$affectRow = OmAvailableModel::updateTNameRow($tName, $set, $where);
if ($affectRow) {
$message .= "<font color='green'>update {$shippedRecordNum} ShippedTime success" . "</font><br>";
} else {
$message .= "<font color='red'>update {$shippedRecordNum} ShippedTime fail may be has shippedTime or had no this recordNumber" . "</font><br>";
}
}
continue;
}
if ($order->isSetPurchaseDate()) {
//亚马逊平台上的下单时间
$orderData['ordersTime'] = strtotime($order->getPurchaseDate());
//echo ("addTime ==== {$order->getPurchaseDate()}\n");
}
if ($order->isSetLastUpdateDate()) {
//支付时间
$orderData['paymentTime'] = strtotime($order->getLastUpdateDate());
//echo ("paidTime ==== {$order->getLastUpdateDate()}\n");
}
$orderstatus = '';
//订单状态
//if ($order->isSetOrderStatus()) {
// if($order->getOrderStatus() == 'Unshipped'){
// $orderstatus = 1;
// }
// }
if ($order->isSetFulfillmentChannel()) {
$orderExtenData['FulfillmentChannel'] = $order->getFulfillmentChannel();
//echo ("FulfillmentChannel ==== "); //订单配送方式
//echo ($orderExtenData['FulfillmentChannel'] . "\n");
}
if ($order->isSetSalesChannel()) {
$orderExtenData['SalesChannel'] = $order->getSalesChannel();
//echo ("SalesChannel ==== ");
//echo ($orderExtenData['SalesChannel'] . "\n");
}
if ($order->isSetOrderChannel()) {
$orderExtenData['OrderChannel'] = $order->getOrderChannel();
//echo ("OrderChannel ====");
//echo ($orderExtenData['OrderChannel'] . "\n");
}
if ($order->isSetShipServiceLevel()) {
$orderExtenData['ShipServiceLevel'] = $order->getShipServiceLevel();
//echo ("ShipServiceLevel ==== ");
//echo ($orderExtenData['ShipServiceLevel'] . "\n");
}
if ($order->isSetShippingAddress()) {
//判断是否设置了地址
$shippingAddress = $order->getShippingAddress();
if ($shippingAddress->isSetName()) {
//获取收件人姓名
$orderUserInfoData['username'] = htmlentities($shippingAddress->getName(), ENT_QUOTES);
//echo ("username ==== ");
//echo ($orderUserInfoData['username'] . "\n");
}
if ($shippingAddress->isSetAddressLine1()) {
//街道1
$orderUserInfoData['street'] = htmlentities($shippingAddress->getAddressLine1(), ENT_QUOTES);
//echo ("street ==== ");
//echo ($orderUserInfoData['street'] . "\n");
}
if ($shippingAddress->isSetAddressLine2()) {
//街道2
$street2 = htmlentities($shippingAddress->getAddressLine2(), ENT_QUOTES);
}
if ($shippingAddress->isSetAddressLine3()) {
//街道3
$street3 = htmlentities($shippingAddress->getAddressLine3(), ENT_QUOTES);
}
if ($shippingAddress->isSetCity()) {
//城市
$orderUserInfoData['city'] = htmlentities($shippingAddress->getCity(), ENT_QUOTES);
//echo ("city ==== ");
//echo ($orderUserInfoData['city'] . "\n");
}
if ($shippingAddress->isSetCounty()) {
//郡，县
$orderUserInfoData['address2'] = htmlentities($shippingAddress->getCounty() . ' ' . $street2, ENT_QUOTES);
$orderUserInfoData['address3'] = htmlentities($shippingAddress->getCounty() . ' ' . $street3, ENT_QUOTES);
//echo ("address2 ==== ");
//echo ($orderUserInfoData['address2'] . "\n");
//echo ("address3 ==== ");
//echo ($orderUserInfoData['address3'] . "\n");
}
if ($shippingAddress->isSetDistrict()) {
//地方，区
//echo ("District ==== " . $shippingAddress->getDistrict() . "\n");
}
if ($shippingAddress->isSetStateOrRegion()) {
//州
$orderUserInfoData['state'] = htmlentities($shippingAddress->getStateOrRegion(), ENT_QUOTES);
//echo ("state ==== ");
//echo ($orderUserInfoData['state'] . "\n");
}
if ($shippingAddress->isSetPostalCode()) {
//邮编
$orderUserInfoData['zipCode'] = htmlentities($shippingAddress->getPostalCode(), ENT_QUOTES);
//echo ("zipCode ==== ");
//echo ($orderUserInfoData['zipCode'] . "\n");
}
if ($shippingAddress->isSetCountryCode()) {
//国家简称
/*$ebay_countrynames = array('US'=>'United States', "UK"=>"United Kingdom");
$orderData['ebay_couny'] = $shippingAddress->getCountryCode() ;
$orderData['ebay_site'] = $shippingAddress->getCountryCode() ;
$orderData['ebay_countryname'] = $ebay_countrynames[$shippingAddress->getCountryCode()];*/
//$sql = "SELECT regions_en FROM ebay_region WHERE regions_jc = '".$shippingAddress->getCountryCode()."'";
// $sql = $dbcon->execute($sql);
// $amazon_countryname = $dbcon->fetch_one($sql);
$orderUserInfoData['countrySn'] = $shippingAddress->getCountryCode();
//这里要调用运输方式管理系统的数据，获取国家简称对应的国家名称
$countryNameInfo = CommonModel::getCountrieInfoBySn($orderUserInfoData['countrySn']);
//根据国家简称获取该国家的信息
//$orderData['ebay_site'] = $shippingAddress->getCountryCode() ;
$orderUserInfoData['countryName'] = trim($countryNameInfo['regions_en']);
//获得国家名称
//echo ("getCountryCode==== " . $orderUserInfoData['countrySn'] . "\n");
}
if ($shippingAddress->isSetPhone()) {
//手机
$orderUserInfoData['phone'] = $shippingAddress->getPhone();
//echo ("phone ==== ");
//echo ($orderUserInfoData['phone'] . "\n");
}
}
if ($order->isSetOrderTotal()) {
$orderTotal = $order->getOrderTotal();
if ($orderTotal->isSetCurrencyCode()) {
//币种
$orderUserInfoData['currency'] = $orderTotal->getCurrencyCode();
//echo ("currency ==== ");
//echo ($orderUserInfoData['currency'] . "\n");
}
if ($orderTotal->isSetAmount()) {
//订单总价,线上总价
$orderData['onlineTotal'] = $orderTotal->getAmount();
$orderData['actualTotal'] = $orderTotal->getAmount();
//echo ("onlineTotal ==== ");
//echo ($orderData['onlineTotal'] . "\n");
}
}
if ($order->isSetNumberOfItemsShipped()) {
//echo ("ItemsShipped ==== " . $order->getNumberOfItemsShipped() . "\n");
}
if ($order->isSetNumberOfItemsUnshipped()) {
//echo ("NumberOfItemsUnshipped ==== " . $order->getNumberOfItemsUnshipped() . "\n");
}
if ($order->isSetPaymentExecutionDetail()) {
$paymentExecutionDetail = $order->getPaymentExecutionDetail();
$paymentExecutionDetailItemList = $paymentExecutionDetail->getPaymentExecutionDetailItem();
foreach ($paymentExecutionDetailItemList as $paymentExecutionDetailItem) {
echo "######PaymentExecutionDetailItem######\n";
if ($paymentExecutionDetailItem->isSetPayment()) {
$payment = $paymentExecutionDetailItem->getPayment();
if ($payment->isSetCurrencyCode()) {
//echo ("CurrencyCode ==== ");
//echo ($payment->getCurrencyCode() . "\n");
}
if ($payment->isSetAmount()) {
//echo (" Amount ==== ");
//echo ($payment->getAmount() . "\n");
}
}
if ($paymentExecutionDetailItem->isSetSubPaymentMethod()) {
//echo ("SubPaymentMethod ==== ");
//echo ($paymentExecutionDetailItem->getSubPaymentMethod() . "\n");
}
}
}
if ($order->isSetPaymentMethod()) {
$orderExtenData['PaymentMethod'] = $order->getPaymentMethod();
//echo ("PaymentMethod ==== ");
//echo ($orderExtenData['PaymentMethod'] . "\n");
}
if ($order->isSetMarketplaceId()) {
$orderExtenData['MarketplaceId'] = $order->getMarketplaceId();
//echo ("MarketplaceId ==== ");
//echo ($orderExtenData['MarketplaceId'] . "\n");
}
if ($order->isSetBuyerName()) {
//买家ID
$orderUserInfoData['platformUsername'] = htmlentities($order->getBuyerName(), ENT_QUOTES);
//echo ("platformUsername ==== ");
//echo ($orderUserInfoData['platformUsername'] . "\n");
}
if ($order->isSetBuyerEmail()) {
//买家email
$orderUserInfoData['email'] = $order->getBuyerEmail();
//echo ("email ==== ");
//echo ($orderUserInfoData['email'] . "\n");
}
if ($order->isSetShipmentServiceLevelCategory()) {
$orderExtenData['ShipmentServiceLevelCategory'] = $order->getShipmentServiceLevelCategory();
//echo ("ShipmentServiceLevelCategory ==== ");
//echo ($orderExtenData['ShipmentServiceLevelCategory'] . "\n");
}
//$orderData['ebay_user'] = $user;
$orderData['platformId'] = 11;
//amazon的平台ID为11
$orderData['accountId'] = $accountId;
//amazon的账号ID
//echo ("accountId ==== ");
//echo ($orderData['accountId'] . "\n");
$orderData['orderAddTime'] = time();
//添加到系统的时间
//echo ("orderAddTime ==== ");
//echo ($orderData['orderAddTime'] . "\n");
$orderData['orderStatus'] = C('STATEPENDING');
//默认订单状态
$orderData['orderType'] = C('STATEPENDING_INITIAL');
//默认订单类型
$orderData = array('orderData' => $orderData, 'orderExtenData' => $orderExtenData, 'orderUserInfoData' => $orderUserInfoData);
$tName = 'om_unshipped_order';
$where = "WHERE recordNumber='{$orderData['orderData']['recordNumber']}' AND platformId={$orderData['orderData']['platformId']} and is_delete ='0'";
$flagCountUnshipped = OmAvailableModel::getTNameCount($tName, $where);
$tName = 'om_shipped_order';
$flagCountshipped = OmAvailableModel::getTNameCount($tName, $where);
if (empty($flagCountUnshipped) && empty($flagCountshipped)) {
//判断订单是否已经在系统2个订单表（未发货和已发货）中存在
//$orderData['ebay_ordersn'] = generateOrdersn();
$detailrequest = new MarketplaceWebServiceOrders_Model_ListOrderItemsRequest();
$detailrequest->setSellerId(MERCHANT_ID);
$detailrequest->setAmazonOrderId($orderData['orderData']['recordNumber']);
$orderDetailArr = self::act_invokeListOrderItems($service, $detailrequest);
//var_dump($orderDetailArr); exit;
for ($i = 0; $i < count($orderDetailArr); $i++) {
$orderDetailArr[$i]['orderDetailData']['recordNumber'] = $orderData['orderData']['recordNumber'];
}
//print_r($orderDetailArr);
if (!empty($orderDetailArr)) {
$orderData['orderDetail'] = $orderDetailArr;
$insertData = array();
//var_dump($obj_order_detail_data); echo "<br>";
$calcInfo = CommonModel::calcAddOrderWeight($orderDetailArr);
//计算重量和包材
//var_dump($calcInfo); exit;
$orderData['orderData']['ORcalcWeight'] = $calcInfo[0];
$orderData['orderData']['calcWeight'] = $calcInfo[0];
$orderData['orderData']['pmId'] = $calcInfo[1];
if ($orderData['orderData']['calcWeight'] != $totalweight) {
$insertData['old_totalweight'] = $totalweight;
$insertData['new_totalweight'] = $orderData['orderData']['calcWeight'];
}
if ($orderData['orderData']['pmId'] != $pmId) {
$insertData['old_pmId'] = $pmId;
$insertData['new_pmId'] = $orderData['orderData']['pmId'];
}
$newcarrier = get_carrier($orderData['orderData']['calcWeight'], $orderData['orderUserInfoData']['countryName'], $account, $orderData['orderUserInfoData']['currency']);
$orderData['orderData']['transportId'] = $flip_transportList[$newcarrier];
$orderData['orderData']['ORtransportId'] = $flip_transportList[$newcarrier];
$rtn = OldsystemModel::orderErpInsertorder($orderData);
//var_dump($rtn);
if ($rtn['errcode'] == 200) {
//var_dump($rtn);
$rtn_data = $rtn['data'];
$orderId = $rtn_data['orderId'];
$message .= "<font color='green'>" . date("Y-m-d H:i:s") . " 插入老系统成功，订单编号 [{$orderId}] </font><br>";
$pmId = $rtn_data['pmId'];
$totalweight = $rtn_data['totalweight'];
$shipfee = $rtn_data['shipfee'];
$carrier = $rtn_data['carrier'];
$carrierId = $rtn_data['carrierId'];
$status = $rtn_data['status'];
$orderData['orderData']['id'] = $orderId;
//赋予新系统订单编号@20140501
if (count($orderData['orderDetail']) > 1) {
$orderData['orderData']['orderAttribute'] = 3;
} else {
if (isset($orderData['orderDetail'][0]['orderDetailData']['amount']) && $orderData['orderDetail'][0]['orderDetailData']['amount'] > 1) {
$orderData['orderData']['orderAttribute'] = 2;
}
}
/*$calcShippingInfo = CommonModel :: calcAddOrderShippingFee($orderData,1);//计算运费
//var_dump($calcShippingInfo); exit;
//$insert_orderData['orderData']['calcShipping'] = $calcShippingInfo['fee']['fee'];
$orderData['orderData']['channelId'] = $calcShippingInfo['fee']['channelId'];*/
$calcShippingInfo = TransAPIModel::trans_carriers_fix_get($orderData['orderData']['transportId'], $orderData['orderData']['calcWeight'], $orderData['orderUserInfoData']['countryName']);
//计算运费
//var_dump($calcShippingInfo);
$orderData['orderData']['calcShipping'] = $calcShippingInfo['fee'];
//$orderData['orderData']['transportId'] = $calcShippingInfo['carrierId'];
$orderData['orderData']['channelId'] = $calcShippingInfo['channelId'];
$orderData['orderData']['ORchannelId'] = $calcShippingInfo['channelId'];
if ($orderData['orderData']['calcShipping'] != $shipfee) {
$insertData['old_shippfee'] = $shipfee;
$insertData['new_shippfee'] = $orderData['orderData']['calcShipping'];
}
if ($orderData['orderData']['transportId'] != $carrierId) {
$insertData['old_carrierId'] = $carrierId;
$insertData['new_carrierId'] = $orderData['orderData']['transportId'];
}
if (!empty($insertData)) {
$insertData['ebay_id'] = $orderId;
$insertData['addtime'] = time();
//var_dump($insertData);
OldsystemModel::insertTempSyncRecords($insertData);
// 插入临时对比记录表
}
$orderData = AutoModel::auto_contrast_intercept($orderData);
//print_r($interceptInfo); exit;
/*$orderData['orderData']['orderStatus'] = $interceptInfo['orderStatus'];
$orderData['orderData']['orderType'] = $interceptInfo['orderType'];*/
//var_dump($orderData); exit;
if (OrderAddModel::insertAllOrderRow($orderData)) {
//echo 'insert success!' . "\n";
$message .= "<font color='green'>" . date("Y-m-d H:i:s") . ", 新增订单{$orderData['orderData']['recordNumber']}成功</font><br>";
} else {
$message .= "<font color='red'>" . date("Y-m-d H:i:s") . ", 新增订单{$orderData['orderData']['recordNumber']}失败</font><br>";
//echo OrderAddModel :: $errMsg;
}
}
} else {
//echo "Amazon ID: ".$orderData['recordnumber']." 订单详情添加失败\n";
$message .= "<font color='red'>Amazon ID: " . $orderData['orderData']['recordNumber'] . " has no detail </font><br>";
}
} else {
$message .= "<font color='red'>Amazon ID: " . $orderData['orderData']['recordNumber'] . " had exist</font><br>";
}
}
}
}
} catch (MarketplaceWebServiceOrders_Exception $ex) {
$message .= "Caught Exception: " . $ex->getMessage() . "<br>";
$message .= "Response Status Code: " . $ex->getStatusCode() . "<br>";
$message .= "Error Code: " . $ex->getErrorCode() . "<br>";
$message .= "Error Type: " . $ex->getErrorType() . "<br>";
$message .= "Request ID: " . $ex->getRequestId() . "<br>";
$message .= "XML: " . $ex->getXML() . "<br>";
} catch (Exception $e) {
BaseModel::rollback();
BaseModel::autoCommit();
$message .= $e->getMessage() . "<br>";
}
return $message;
}
public function view_dresslinkOrderImport()
{
include_once WEB_PATH . "lib/PHPExcel.php";
//phpexcel
include_once WEB_PATH . "conf/scripts/script.ebay.config.php";
$toptitle = 'dresslink线下订单导入';
//头部title
$this->smarty->assign('toptitle', $toptitle);
$this->smarty->assign('toplevel', 2);
$this->smarty->assign('secondlevel', 210);
$OmAccountAct = new OmAccountAct();
$dresslinkAccountList = $OmAccountAct->act_dresslinkaccountAllList();
//$dresslinkAccountList = array(array('id'=>8,'account'=>'dresslink.com'),array('id'=>10,'account'=>'cndirect.com'));
$this->smarty->assign("dresslinkAccountList", $dresslinkAccountList);
if (isset($_FILES['cndlFile']['tmp_name']) && isset($_POST['cndlAccount'])) {
$filePath = $_FILES['cndlFile']['tmp_name'];
$account = $_POST['cndlAccount'];
$PHPExcel = new PHPExcel();
$PHPReader = new PHPExcel_Reader_Excel2007();
if (!$PHPReader->canRead($filePath)) {
$PHPReader = new PHPExcel_Reader_Excel5();
if (!$PHPReader->canRead($filePath)) {
echo 'no Excel';
return;
}
}
$PHPExcel = $PHPReader->load($filePath);
$currentSheet = $PHPExcel->getSheet(0);
$allRow = $currentSheet->getHighestRow();
/**从第二行开始输出，因为excel表中第一行为列名*/
/**取得最大的列号*/
$allColumn = $currentSheet->getHighestColumn();
$orderData = array();
$cndlAccounts = array();
$transportation = CommonModel::getCarrierList();
//所有的
$transportationList = array();
foreach ($transportation as $tranValue) {
$transportationList[$tranValue['id']] = $tranValue['carrierNameCn'];
}
//账号对应
foreach ($dresslinkAccountList as $accounts) {
$cndlAccounts[$accounts['id']] = $accounts['account'];
}
$c = 2;
$dresslinks = array();
$ebay_fedex_remark = array();
$ChineseDescs = array();
for ($c = 2; $c <= $allRow; $c++) {
$aa = 'A' . $c;
$bb = 'B' . $c;
$cc = 'C' . $c;
$dd = 'D' . $c;
$ee = 'E' . $c;
$ff = 'F' . $c;
$gg = 'G' . $c;
$hh = 'H' . $c;
$ii = 'I' . $c;
$jj = 'J' . $c;
$kk = 'K' . $c;
$ll = 'L' . $c;
$mm = 'M' . $c;
$nn = 'N' . $c;
$oo = 'O' . $c;
$pp = 'P' . $c;
$qq = 'Q' . $c;
$rr = 'R' . $c;
$ss = 'S' . $c;
$tt = 'T' . $c;
$uu = 'U' . $c;
$vv = 'V' . $c;
$ww = 'W' . $c;
$xx = 'X' . $c;
$yy = 'Y' . $c;
$zz = 'Z' . $c;
$aaa = 'AA' . $c;
$abb = 'AB' . $c;
$acc = 'AC' . $c;
$add = 'AD' . $c;
$aee = 'AE' . $c;
$aff = 'AF' . $c;
$agg = 'AG' . $c;
$ahh = 'AH' . $c;
$aii = 'AI' . $c;
$ajj = 'AJ' . $c;
$akk = 'AK' . $c;
$all = 'AL' . $c;
$amm = 'AM' . $c;
$ann = 'AN' . $c;
$aww = 'AW' . $c;
$recordnumber = trim($currentSheet->getCell($aa)->getValue());
//订单号
$recordNumber = $recordnumber;
$is_order = intval($currentSheet->getCell($bb)->getValue());
//1代表为订单，0代表订单明细
if (empty($recordnumber)) {
$message .= "<font color=red> 第{$c}行recordnumber为空！</font><br>";
break;
}
/***************判断订单是否已存在***************/
$where = "where recordnumber='{$recordnumber}'";
$orderinfo = cndlModel::selectOrder($where);
if ($orderinfo) {
if ($is_order != 0) {
$message .= "<font color='blue'>订单 {$recordnumber}已存在！</font><br>";
}
continue;
}
/**************/
if ($is_order != 0) {
if ($cndlAccounts[$account] == "dresslink.com") {
$str = substr($recordnumber, 0, 2);
if ($str !== "DL") {
$message .= "<font color=red> {$recordnumber}不在账号{$cndlAccounts[$account]}中！</font><br>";
continue;
}
} elseif ($cndlAccounts[$account] == "cndirect.com") {
$str = substr($recordnumber, 0, 2);
if ($str !== "CN") {
$message .= "<font color=red> {$recordnumber}不在账号{$cndlAccounts[$account]}中！</font><br>";
continue;
}
}
$platformUsername = mysql_real_escape_string(trim($currentSheet->getCell($cc)->getValue()));
$email = mysql_real_escape_string(trim($currentSheet->getCell($dd)->getValue()));
$transId = mysql_real_escape_string(trim($currentSheet->getCell($ee)->getValue()));
$ordersTime = (array) PHPExcel_Shared_Date::ExcelToPHPObject(trim($currentSheet->getCell($ll)->getValue()));
$paymentTime = (array) PHPExcel_Shared_Date::ExcelToPHPObject(trim($currentSheet->getCell($mm)->getValue()));
$shippingFee = round_num(trim($currentSheet->getCell($oo)->getValue()), 2);
$calcWeight = round_num(trim($currentSheet->getCell($ahh)->getValue()), 3);
$actualTotal = round_num(trim($currentSheet->getCell($pp)->getValue()), 2);
$onlineTotal = round_num(trim($currentSheet->getCell($aff)->getValue()), 2);
$currency = mysql_real_escape_string(trim($currentSheet->getCell($qq)->getValue()));
//$orders['ebay_orderqk'] = round_num(trim($currentSheet->getCell($rr)->getValue()), 2);
$note = mysql_real_escape_string(trim($currentSheet->getCell($ss)->getValue()));
$username = mysql_real_escape_string(trim($currentSheet->getCell($tt)->getValue()));
$countryName = mysql_real_escape_string(trim($currentSheet->getCell($uu)->getValue()));
$state = mysql_real_escape_string(trim($currentSheet->getCell($vv)->getValue()));
$city = mysql_real_escape_string(trim($currentSheet->getCell($ww)->getValue()));
$street = mysql_real_escape_string(trim($currentSheet->getCell($xx)->getValue()));
$address2 = mysql_real_escape_string(trim($currentSheet->getCell($yy)->getValue()));
$zipCode = mysql_real_escape_string(trim($currentSheet->getCell($zz)->getValue()));
$phone = mysql_real_escape_string(trim($currentSheet->getCell($abb)->getValue()));
$landline = mysql_real_escape_string(trim($currentSheet->getCell($aaa)->getValue()));
if ($account == "dresslink.com") {
$feedback = mysql_real_escape_string(trim($currentSheet->getCell($ann)->getValue()));
} elseif ($account == "cndirect.com") {
$feedback = mysql_real_escape_string(trim($currentSheet->getCell($akk)->getValue()));
}
$carrierNameCn = strtolower(mysql_real_escape_string(trim($currentSheet->getCell($kk)->getValue())));
$carrierNameCn = cndlModel::carrier($carrierNameCn);
$payment_method = mysql_real_escape_string(trim($currentSheet->getCell($ff)->getValue()));
$payment_module = mysql_real_escape_string(trim($currentSheet->getCell($gg)->getValue()));
$bank_account = mysql_real_escape_string(trim($currentSheet->getCell($hh)->getValue()));
$bank_country = mysql_real_escape_string(trim($currentSheet->getCell($ii)->getValue()));
$shipping_method = mysql_real_escape_string(trim($currentSheet->getCell($jj)->getValue()));
$shipping_module = mysql_real_escape_string(trim($currentSheet->getCell($kk)->getValue()));
$dresslinks['payment_method'] = $payment_method;
$dresslinks['payment_module'] = $payment_module;
$dresslinks['bank_account'] = $bank_account;
$dresslinks['bank_country'] = $bank_country;
$dresslinks['shipping_method'] = $shipping_method;
$dresslinks['shipping_module'] = $shipping_module;
$PayPalPaymentId = $transId;
/***************BEGIN 订单表数据***************/
$orderData[$recordNumber]['orderData']['recordNumber'] = $recordnumber;
if ($cndlAccounts[$account] == "dresslink.com") {
$orderData[$recordNumber]['orderData']['platformId'] = 10;
$orderData[$recordNumber]['orderData']['accountId'] = $account;
} elseif ($cndlAccounts[$account] == "cndirect.com") {
$orderData[$recordNumber]['orderData']['platformId'] = 8;
$orderData[$recordNumber]['orderData']['accountId'] = $account;
}
$orderData[$recordNumber]['orderData']['orderStatus'] = C('STATEPENDING');
$orderData[$recordNumber]['orderData']['orderType'] = C('STATEPENDING_INITIAL');
$orderData[$recordNumber]['orderData']['ordersTime'] = strtotime($ordersTime['date']);
//平台下单时间
$orderData[$recordNumber]['orderData']['paymentTime'] = strtotime($paymentTime['date']);
$orderData[$recordNumber]['orderData']['onlineTotal'] = $onlineTotal;
//线上总金额
$orderData[$recordNumber]['orderData']['actualTotal'] = $actualTotal;
//付款总金额
$orderData[$recordNumber]['orderData']['isFixed'] = 1;
$orderData[$recordNumber]['orderData']['calcShipping'] = $shippingFee;
//物流费用
$orderData[$recordNumber]['orderData']['orderAddTime'] = time();
$orderData[$recordNumber]['orderData']['isNote'] = empty($note) ? 0 : 1;
foreach ($transportation as $tranValue) {
if ($tranValue['carrierNameCn'] == $carrierNameCn) {
$orderData[$recordNumber]['orderData']['transportId'] = $tranValue['id'];
//运输方式id
break;
}
}
/***************END 订单表数据***************/
/***************BEGIN 订单扩展表数据***************/
$orderData[$recordNumber]['orderExtenData']['paymentStatus'] = "Complete";
$orderData[$recordNumber]['orderExtenData']['transId'] = $transId;
$orderData[$recordNumber]['orderExtenData']['PayPalPaymentId'] = $PayPalPaymentId;
$orderData[$recordNumber]['orderExtenData']['paymentMethod'] = $payment_method;
$orderData[$recordNumber]['orderExtenData']['paymentModule'] = $payment_module;
$orderData[$recordNumber]['orderExtenData']['shippingMethod'] = $shipping_method;
$orderData[$recordNumber]['orderExtenData']['ShippingModule'] = $shipping_module;
$orderData[$recordNumber]['orderExtenData']['currency'] = $currency;
$orderData[$recordNumber]['orderExtenData']['feedback'] = $feedback;
//客户留言
/***************END 订单扩展表数据***************/
/***************BEGIN 订单用户表数据***************/
$orderData[$recordNumber]['orderUserInfoData']['username'] = $username;
$orderData[$recordNumber]['orderUserInfoData']['platformUsername'] = $platformUsername;
$orderData[$recordNumber]['orderUserInfoData']['email'] = $email;
$orderData[$recordNumber]['orderUserInfoData']['countryName'] = $countryName;
$orderData[$recordNumber]['orderUserInfoData']['currency'] = $currency;
$orderData[$recordNumber]['orderUserInfoData']['state'] = $state;
// 省
$orderData[$recordNumber]['orderUserInfoData']['city'] = $city;
// 市
$orderData[$recordNumber]['orderUserInfoData']['street'] = $street;
$orderData[$recordNumber]['orderUserInfoData']['address2'] = $address2;
$orderData[$recordNumber]['orderUserInfoData']['landline'] = $landline;
// 座机电话
$orderData[$recordNumber]['orderUserInfoData']['phone'] = $phone;
// 手机
$orderData[$recordNumber]['orderUserInfoData']['zipCode'] = $zipCode;
// 邮编
/*************END 订单用户表数据***************/
//note信息
if (!empty($note)) {
$orderData[$recordNumber]['orderNote'][$c]['content'] = $note;
$orderData[$recordNumber]['orderNote'][$c]['userId'] = $_SESSION['sysUserId'];
}
} else {
$sku = mysql_real_escape_string(trim($currentSheet->getCell($acc)->getValue()));
$itemTitle = mysql_real_escape_string(trim($currentSheet->getCell($add)->getValue()));
$itemPrice = round_num(trim($currentSheet->getCell($aff)->getValue()), 2);
$amount = intval(trim($currentSheet->getCell($agg)->getValue()));
$shipingfee = round_num(trim($currentSheet->getCell($ahh)->getValue()), 2);
/***************BEGIN 订单详细数据***************/
$orderData[$recordNumber]['orderDetail'][$c]['orderDetailData']['recordNumber'] = $recordnumber;
$orderData[$recordNumber]['orderDetail'][$c]['orderDetailData']['sku'] = $sku;
$orderData[$recordNumber]['orderDetail'][$c]['orderDetailData']['itemPrice'] = $itemPrice;
$orderData[$recordNumber]['orderDetail'][$c]['orderDetailData']['amount'] = $amount;
$orderData[$recordNumber]['orderDetail'][$c]['orderDetailData']["shippingFee"] = $shipingfee;
$orderData[$recordNumber]['orderDetail'][$c]['orderDetailData']['createdTime'] = time();
/*************END 订单详细数据***************/
/***************BEGIN 订单详细扩展表数据***************/
$orderData[$recordNumber]['orderDetail'][$c]['orderDetailExtenData']['itemTitle'] = $itemTitle;
$orderData[$recordNumber]['orderDetail'][$c]['orderDetailExtenData']['transId'] = $transId;
//$orderData['orderDetail']['orderDetailExtenData']['note'] = $value[10];
$categoryName = trim($currentSheet->getCell($ajj)->getValue());
$customCode = trim($currentSheet->getCell($akk)->getValue());
$material = trim($currentSheet->getCell($all)->getValue());
$ShenBaoQuantity = trim($currentSheet->getCell($amm)->getValue());
$ShenBaoUnitPrice = trim($currentSheet->getCell($ann)->getValue());
$ChineseDesc = trim($currentSheet->getCell($aww)->getValue());
//$salePrice = round_num(mysql_real_escape_string(trim($detail['SalePrice'])), 2); //实际SKU付款价
/*************END 订单详细扩展表数据***************/
$ebay_fedex_remark[$recordNumber][$categoryName][] = array('real_price' => $ShenBaoUnitPrice, 'qty' => $ShenBaoQuantity, 'hamcodes' => $customCode, 'detail' => $material);
$orderData[$recordNumber]['fedexRemark'] = $ebay_fedex_remark[$recordNumber];
$orderData[$recordNumber]['dresslinkInfo'] = $dresslinks;
$ChineseDescs[$recordNumber][$categoryName] = $ChineseDesc;
}
}
if ($orderData) {
foreach ($orderData as $id => $order) {
$msg = commonModel::checkOrder($id);
if ($msg) {
$message .= "<font color='red'>订单{$id}已存在！</font><br>";
continue;
}
//计算订单属性
if (count($order['orderDetail']) == 1) {
$detail = current($order['orderDetail']);
if ($detail['orderDetailData']['amount'] == 1) {
$orderData[$id]['orderData']['orderAttribute'] = 1;
} else {
$orderData[$id]['orderData']['orderAttribute'] = 2;
}
} else {
$orderData[$id]['orderData']['orderAttribute'] = 3;
}
//计算订单重量及包材
$obj_order_detail_data = array();
foreach ($order['orderDetail'] as $sku => $detail) {
$obj_order_detail_data[] = $detail['orderDetailData'];
}
$weightfee = commonModel::calcOrderWeight($obj_order_detail_data);
$orderData[$id]['orderData']['calcWeight'] = $weightfee[0];
$orderData[$id]['orderData']['pmId'] = $weightfee[1];
//计算运费
$calcShippingInfo = CommonModel::calcAddOrderShippingFee($insertOrder, $orderData[$id]['orderData']['isFixed']);
//计算运费
$orderData[$id]['orderData']['channelId'] = $calcShippingInfo['fee']['channelId'];
$orderData[$id]['orderData']['calcShipping'] = $calcShippingInfo['fee'];
$ChineseDescs_arr = array_filter(array_unique($ChineseDescs[$id]));
$orderData[$id]['orderNote'] = array('content' => join(' ', $ChineseDescs_arr), 'userId' => $_SESSION['sysUserId'], 'createdTime' => time());
/*//缺货拦截
$orderData[$id] = AutoModel :: auto_contrast_intercept($orderData[$id]);
//$orderData[$id] = cndlModel :: auto_contrast_intercept($orderData[$id]);*/
//插入订单OrderAddModel::insertAllOrderRow($orderData[$id],'cndl');
//调用旧系统接口，先插入数据到旧系统
//echo "<pre>"; var_dump($orderData[$id]); exit;
$rtn = OldsystemModel::orderErpInsertorder($orderData[$id]);
//echo "<pre>";print_r($rtn);exit;
$insertData = array();
if (empty($rtn)) {
$message .= "<font color='red'>订单{$id}同步ERP发生异常，跳过！</font><br>";
continue;
}
if ($rtn['errcode'] == 200) {
$rtn_data = $rtn['data'];
$orderId = $rtn_data['orderId'];
$message .= "<font color='green'>插入老系统成功，订单编号 [{$orderId}]</font><br>";
$pmId = $rtn_data['pmId'];
$totalweight = $rtn_data['totalweight'];
$shipfee = $rtn_data['shipfee'];
$carrier = $rtn_data['carrier'];
$carrierId = $rtn_data['carrierId'];
$status = $rtn_data['status'];
$orderData[$id]['orderData']['id'] = $orderId;
//赋予新系统订单编号,一切数据已老系统返回的为准
if ($orderData[$id]['orderData']['calcWeight'] != $totalweight) {
$insertData['old_totalweight'] = $totalweight;
$insertData['new_totalweight'] = $orderData[$id]['orderData']['calcWeight'];
$orderData[$id]['orderData']['calcWeight'] = $totalweight;
}
if ($orderData[$id]['orderData']['pmId'] != $pmId) {
$insertData['old_pmId'] = $pmId;
$insertData['new_pmId'] = $orderData[$id]['orderData']['pmId'];
$orderData[$id]['orderData']['pmId'] = $pmId;
}
if ($orderData[$id]['orderData']['calcShipping'] != $shipfee) {
$insertData['old_shippfee'] = $shipfee;
$insertData['new_shippfee'] = $orderData[$id]['orderData']['calcShipping'];
$orderData[$id]['orderData']['calcShipping'] = $shipfee;
}
if ($orderData[$id]['orderData']['transportId'] != $carrierId) {
$insertData['old_carrierId'] = $carrierId;
$insertData['new_carrierId'] = $orderData[$id]['orderData']['transportId'];
$orderData[$id]['orderData']['transportId'] = $carrierId;
}
if (!empty($insertData)) {
$insertData['ebay_id'] = $orderId;
$insertData['addtime'] = time();
OldsystemModel::insertTempSyncRecords($insertData);
// 插入临时对比记录表
}
//缺货拦截
$orderData[$id] = AutoModel::auto_contrast_intercept($orderData[$id]);
//插入订单
$info = OrderAddModel::insertAllOrderRowNoEvent($orderData[$id]);
if ($info) {
$dresslinkinfos = $orderData[$id]['dresslinkInfo'];
$dresslinkinfos['omOrderId'] = $orderId;
if (DresslinkinfoModel::insertDresslinkinfoList($dresslinkinfos)) {
$message .= "<font color='green'>订单{$id}上传dresslinkInfo成功！</font><br>";
} else {
$message .= "<font color='red'>订单{$id}上传dresslinkInfo失败！</font><br>";
}
$message .= "<font color='green'>新系统订单{$id}添加成功！</font><br>";
} else {
$message .= "<font color='red'>新系统订单{$id}添加失败！</font><br>";
}
} else {
$message .= "<font color='red'>添加失败，原因为：{$rtn['msg']}！</font><br>";
}
if ($orderId) {
foreach ($ebay_fedex_remark[$id] as $k => $v) {
$fedex_remark = array();
$fedex_remark['description'] = trim("[No Brand]" . $k . "{$v[0]['detail']}");
if (in_array($transportationList[$order['orderData']['transportId']], array('FedEx'))) {
//$fedex_remark['description'] = "[No Brand]". $k."({$v[0]['detail']})";
$fedex_remark['type'] = 1;
} else {
if (in_array($transportationList[$order['orderData']['transportId']], array('DHL', 'EMS', 'UPS美国专线'))) {
//$fedex_remark['description'] = trim($k);
$fedex_remark['type'] = 2;
} else {
continue;
}
}
$sku_price = 0;
$qty = 0;
foreach ($v as $v0) {
$sku_price += $v0['real_price'];
$qty += $v0['qty'];
}
//$fedex_remark['ebay_ordersn'] = $order['ebay_ordersn'];
$fedex_remark['price'] = round($sku_price / $qty, 2);
$fedex_remark['amount'] = $qty;
$fedex_remark['hamcodes'] = $v[0]['hamcodes'];
if (in_array($transportationList[$order['orderData']['transportId']], array('DHL', 'EMS', 'UPS美国专线'))) {
$fedex_remark['price'] = round($sku_price, 2);
}
$fedex_remark['createdTime'] = time();
$fedex_remark['omOrderId'] = $orderId;
$fedex_remark['creatorId'] = $_SESSION['sysUserId'];
//$insert_fedex_sql = "INSERT INTO fedex_remark set ".array2sql($fedex_remark);
$info = OmAvailableModel::insertRow("om_express_remark", " set " . array2sql_bak($fedex_remark));
if ($info) {
$message .= "<font color=green> {$id} 导入海关记录成功！</font><br>";
//echo "----<font color=green> {$order['recordnumber']} 导入海关记录成功！</font><br>";
} else {
//echo $insert_fedex_sql; echo "<br>";
$message .= "<font color=green> {$id} 导入海关记录失败！</font><br>";
//echo "----<font color=red>{$order['recordnumber']} 导入海关记录失败！</font><br>";
//$fail_order[] = $order['orderData']['recordnumber'];
}
}
}
}
}
$this->smarty->assign("showerrorinfo", $message);
}
$this->smarty->display('dresslinkOrderImport.htm');
}
