public function view_editMenu()
{
$id = intval($_GET['id']);
$menu = StatusMenuModel::getStatusMenuList("*", "where id={$id}");
$this->smarty->assign('menu', $menu);
$group = StatusMenuGroupModel::getMenuGroupList("*", "where storeId=1 and groupId = 0 and is_delete=0");
$this->smarty->assign('group', $group);
$navlist = array(array('url' => '', 'title' => '系统设置'), array('url' => 'index.php?mod=StatusMenu&act=statusMenu', 'title' => '订单流程'), array('url' => '', 'title' => '修改流程'));
$this->smarty->assign('navlist', $navlist);
$this->smarty->assign('toptitle', '修改流程');
$toplevel = 3;
//一级菜单的序号
$this->smarty->assign('toplevel', $toplevel);
$secondlevel = 39;
//当前的二级菜单
$this->smarty->assign('secondlevel', $secondlevel);
$this->smarty->assign('curusername', $_SESSION['userName']);
$this->smarty->display('menuAdd.htm');
}
public static function getsaleandnosendall($sku, $storeId = 1)
{
//获取虚拟/待发货库存（除超大订单进来的待发货）
self::initDB();
$totalnums = 0;
$combineskus = GoodsModel::getCombineBySku($sku);
//var_dump($combineskus);
$skus = empty($combineskus) ? array() : array_keys($combineskus);
array_push($skus, $sku);
//var_dump($skus); echo "<br>";
$skus_str = implode("','", $skus);
$skus_str = "'" . $skus_str . "'";
//echo "<pre>";
//$skus = GoodsModel::getCombineANDSKU($sku); //$combineskus
//var_dump($skus); echo "<br>";
//exit;
//return 0;
$menuList = StatusMenuModel::getStatusMenuList("*", " where dStatus = 1 and groupId = 0 and is_delete=0 and storeId= {$storeId} ");
//var_dump($menuList); exit;
$dStatusCodes = array();
foreach ($menuList as $value) {
if ($value['statusCode']) {
$dStatusCodes[] = $value['statusCode'];
}
}
$tendaytime = time() - 10 * 24 * 60 * 60;
//待发货二级状态已经暂不寄超过十天时间
$ordersql = 'SELECT b.sku, b.amount FROM om_unshipped_order AS a JOIN om_unshipped_order_detail AS b ON a.id = b.omOrderId where a.orderStatus in (' . join(',', $dStatusCodes) . ') and a.is_delete=0 and a.storeId= ' . $storeId . ' AND b.sku in (' . $skus_str . ') and b.is_delete=0 and b.storeId= ' . $storeId;
$query = self::$dbConn->query($ordersql);
$skunums = self::$dbConn->fetch_array_all($query);
foreach ($skunums as $sku_info) {
$realtimes = get_realtime($sku_info["sku"]);
$totalnums += $sku_info["amount"] * $realtimes;
}
$ordersql = 'SELECT b.sku, b.amount FROM om_unshipped_order AS a JOIN om_unshipped_order_detail AS b ON a.id = b.omOrderId where a.orderStatus = ' . C('STATESENDTEMP') . ' and a.paymentTime > ' . $tendaytime . ' and a.is_delete=0 and a.storeId= ' . $storeId . ' AND b.sku in (' . $skus_str . ') and b.is_delete=0 and b.storeId= ' . $storeId;
$query = self::$dbConn->query($ordersql);
$skunums = self::$dbConn->fetch_array_all($query);
foreach ($skunums as $sku_info) {
$realtimes = get_realtime($sku_info["sku"]);
$totalnums += $sku_info["amount"] * $realtimes;
}
/*$ordersql = 'SELECT a.id FROM om_unshipped_order AS a where a.orderStatus in ('.join(',', $dStatusCodes).') and a.is_delete=0 and a.storeId= '.$storeId;
$ordersql .= ' UNION ';
$ordersql .= 'SELECT a.id FROM om_unshipped_order AS a where a.orderStatus = '.C('STATESENDTEMP').' and a.paymentTime > '.$tendaytime.' and a.is_delete=0 and a.storeId= '.$storeId;
//echo $ordersql; echo "<br>"; exit;
$query = self::$dbConn->query($ordersql);
$orders = self::$dbConn->fetch_array_all($query);*/
//var_dump($orders); exit;
//return 10;
/*foreach($orders as $value){
//foreach($skus as $_sku => $_num){
$detailsql = 'SELECT b.sku, b.amount FROM om_unshipped_order_detail AS b where b.omOrderId = '.$value['id'].' AND b.sku in ('.$skus_str.') and b.is_delete=0 and b.storeId= '.$storeId;
echo $detailsql; echo "<br>";
exit;
$query = self::$dbConn->query($detailsql);
$detail = self::$dbConn->fetch_array_all($query);
if(empty($detail)){
continue;
}
//var_dump($detail);
foreach($detail as $val){
//$_sku = $val['sku'];
$amount = intval($val['amount']);
$totalnums += ($amount*$_num);
}
//}
}*/
//var_dump($totalnums);
//新的待发货计算没有数据，并且缺货配货记录，等待配货的信息@2013-11-10
return json_encode($totalnums);
}
public function act_getExpressShipOrderInfo()
{
$recordnumber = !empty($_GET["recordnumber"]) ? addslashes(trim($_GET["recordnumber"])) : '';
$selleraccount = !empty($_GET["selleraccount"]) ? addslashes(trim($_GET["selleraccount"])) : '';
//$selleraccount='sunwebzone';
//$recordnumber='537995';
if (empty($recordnumber)) {
$data['errCode'] = '5806';
$data['errMsg'] = 'recordnumber is null.';
exit(json_encode($data));
}
if (empty($selleraccount)) {
$data['errCode'] = '5806';
$data['errMsg'] = 'selleraccount is null.';
exit(json_encode($data));
}
$field = "a.*";
$condition = "ORDER BY a.id DESC LIMIT 50";
$orders = OrderInfoModel::getExpressOrderInfo($selleraccount, $recordnumber, $field, $condition = '');
if (empty($orders)) {
$data['errCode'] = '5806';
$data['errMsg'] = 'No data or get a order information error';
exit(json_encode($data));
}
foreach ($orders as &$order) {
if ($order['orderStatus'] == 2) {
$order['catename'] = '已发货';
} else {
$select = 'statusName';
$where = " WHERE groupId = '{$order['orderStatus']}' AND statusCode = '{$order['orderType']}' LIMIT 1 ";
$cates = StatusMenuModel::getStatusMenuList($select, $where);
$order['catename'] = $cates[0]['statusName'];
}
$order['orderdetail'] = OrderInfoModel::getShipOrderDetailByOrderId($order['id']);
}
$data['data'] = $orders;
exit(json_encode($data));
}
public function getPartPackageOrder($oid)
{
$statusObj = new StatusMenuModel();
$waitingsendStatus = $statusObj->getWaitingsend();
$statusStr = implode(",", $waitingsendStatus);
$skuNum = $this->getStatusSkuNum($sku, $statusStr);
return $skuNum;
}
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 function act_changeOstatusId()
{
$ostatus = $_POST['ostatus'];
$list = $this->sql("SELECT * FROM " . C('DB_PREFIX') . "status_menu WHERE groupId='{$ostatus}' AND is_delete=0")->select(array('mysql'));
self::$errCode = StatusMenuModel::$errCode;
self::$errMsg = StatusMenuModel::$errMsg;
if ($list) {
return $list;
} else {
return false;
}
}
public static function idTransferName($movefolders)
{
!self::$dbConn ? self::initDB() : null;
$movefolders = json_decode($movefolders, true);
$movefolderNames = array();
//获取所有文件夹名字，不用循环读取数据库
$select = " statusName,statusCode ";
$where = " WHERE 1";
$statusMenus = StatusMenuModel::getStatusMenuListById($select, $where);
foreach ($movefolders as $key => $movefolder) {
/*$ids = $movefolder;
array_push($ids, $key);
$ids_str = "'".implode("','",$movefolder)."'";
$select = " SELECT statusName,statusCode ";
$where = " WHERE statusCode in({$id_str})";
$statusMenus = StatusMenuModel::getStatusMenuListById($select, $where);*/
if (!empty($key)) {
foreach ($movefolder as $statusCode) {
$movefolderNames[$statusMenus[$key]][] = $statusMenus[$statusCode];
}
}
}
return json_encode($movefolderNames, JSON_UNESCAPED_UNICODE);
}
public function act_getMenuGroupList()
{
$list = StatusMenuModel::getStatusMenuList('statusName,statusCode,groupId', 'where is_delete = 0 ORDER BY groupId ASC,statusCode ASC');
$grouplists = array();
$group0 = array();
foreach ($list as $key => $value) {
if ($value['groupId'] == 0) {
$group0[$value['statusCode']]['name'] = $value['statusName'];
$group0[$value['statusCode']]['list'] = $value;
}
}
foreach ($list as $k => $v) {
foreach ($group0 as $k0 => $v0) {
if ($k0 == $v['groupId']) {
$grouplists[$v['groupId']]['name'] = $v0['name'];
$grouplists[$v['groupId']]['subCode'] .= $v['statusCode'] . ',';
$grouplists[$v['groupId']]['list'][] = $v;
}
}
}
self::$errCode = StatusMenuModel::$errCode;
self::$errMsg = StatusMenuModel::$errMsg;
if ($list) {
return $grouplists;
} else {
return false;
}
}
/**
* 根据状态获取读取状态列表(最新版)
* last modified by Herman.Xi @20131205
$ @where as String
*/
public static function getOrderNameByStatus($ostatus, $otype, $storeId = 1)
{
self::initDB();
if (!$ostatus && !$otype) {
//预防状态不选择，如何选择分表搜索的情况@20140226
return 'om_unshipped_order';
}
$select = 'oType';
//echo $ostatus.'--'.$otype;
if ($otype) {
$where = ' where statusCode = ' . $otype;
} else {
$where = ' where statusCode = ' . $ostatus;
}
$where .= ' and storeId = ' . $storeId . ' and is_delete = 0 ';
$sql = "select {$select} from " . self::$table . " {$where} ";
$query = self::$dbConn->query($sql);
if ($query) {
$ret = self::$dbConn->fetch_array($query);
if ($ret['oType'] == 1) {
$orderTable = 'om_unshipped_order';
} else {
$orderTable = 'om_shipped_order';
}
return $orderTable;
//成功， 返回列表数据
} else {
self::$errCode = "003";
self::$errMsg = "error";
return false;
}
}
