public function view_reculculateShippingWay()
{
$ids = isset($_GET['ids']) ? trim($_GET['ids']) : '';
$ids = explode(',', $ids);
$ids = array_map('intval', $ids);
$succesResult = array();
//存储处理成功的结果集
$failureResult = array();
//处理存储失败的结果集
$owOrderMG = new OwOrderManageModel();
$owShipfeeCul = new OwShippingWayDesisionModel();
$oderIndex = new OrderindexAct();
$exApply = new ExpressLabelApplyModel();
foreach ($ids as $orderId) {
$orderInfo = $owOrderMG->getOrderInfoById($orderId, array('id', 'recordNumber', 'calcWeight'));
if (FALSE == $orderInfo) {
$failureResult[] = array('oderid' => $orderId, 'recordNumber' => '', 'calcWeight' => 0, 'errMsg' => '订单不存在');
continue;
}
if (0 == $orderInfo['calcWeight']) {
//重量未0 不予打印
$failureResult[] = array('oderid' => $orderId, 'recordNumber' => $orderInfo['recordNumber'], 'calcWeight' => 0, 'errMsg' => '订单重量为0! 请确认重量!');
continue;
}
$userInfo = $owOrderMG->getBuyerInfoById($orderId);
if (FALSE == $userInfo) {
$failureResult[] = array('oderid' => $orderId, 'recordNumber' => $orderInfo['recordNumber'], 'calcWeight' => $orderInfo['calcWeight'], 'errMsg' => '不能获取买家信息!');
continue;
}
$shipInfo = $owOrderMG->getShippingInfo($orderId);
if ($shipInfo) {
if ($shipInfo['isCanceled'] == 0) {
//之前已经申请过跟踪号 如果未取消则不予重复申请
$failureResult[] = array('oderid' => $orderId, 'recordNumber' => $orderInfo['recordNumber'], 'calcWeight' => $orderInfo['calcWeight'], 'shippingWay' => $shipInfo['shippingWay'], 'errMsg' => '原有跟踪号未取消!', 'trackNumber' => $shipInfo['trackNumber']);
continue;
}
}
$skuList = $oderIndex->act_getRealskulist($orderId);
$outSide = $owShipfeeCul->culPackageLWH($skuList);
$zone = $exApply->getZoneCode($userInfo['zipCode']);
$shipingWay = $owShipfeeCul->chooseShippingWay($skuList, $orderInfo['calcWeight'], $outSide, $zone);
if (FALSE == $shipingWay) {
$failureResult[] = array('oderid' => $orderId, 'recordNumber' => $orderInfo['recordNumber'], 'calcWeight' => $orderInfo['calcWeight'], 'errMsg' => '未找到合适的运输方式!', 'trackNumber' => '');
continue;
} else {
//执行成功 更新运输方式
$transId = $exApply->reflectCodeToId($shipingWay['shippingCode']);
$owOrderMG->updateFeildData(array('transportId' => $transId), $orderId);
$owOrderMG->changeOrderStatus(911, 916, $orderId);
//移动到待打印
$succesResult[] = array('oderid' => $orderId, 'recordNumber' => $orderInfo['recordNumber'], 'calcWeight' => $orderInfo['calcWeight'], 'errMsg' => '成功!', 'trackNumber' => $shipingWay['shippingCode']);
continue;
}
}
// print_r($failureResult);
// print_r($succesResult);
$this->smarty->assign('success', $succesResult);
$this->smarty->assign('failure', $failureResult);
$this->smarty->display('owReculShipping.htm');
}
public function act_getEbayShipOrderInfo()
{
$userid = !empty($_GET["buyeraccount"]) ? addslashes(trim($_GET["buyeraccount"])) : '';
$selleraccount = !empty($_GET["selleraccount"]) ? addslashes(trim($_GET["selleraccount"])) : '';
if (empty($userid)) {
$data['errCode'] = '5806';
$data['errMsg'] = 'userid is null.';
exit(json_encode($data));
}
if (empty($selleraccount)) {
$data['errCode'] = '5806';
$data['errMsg'] = 'selleraccount is null.';
exit(json_encode($data));
}
$owOrderMg = new OwOrderManageModel();
$selerInfo = $owOrderMg->getSellerInfo($selleraccount);
if (FALSE === $selerInfo) {
//未找到销售账号信息
$data['errCode'] = '5806';
$data['errMsg'] = 'invalide seller ID';
exit(json_encode($data));
}
$sellerId = $selerInfo['id'];
$finalResult = $owOrderMg->getBuyerHistory($userid, $sellerId);
echo json_encode($finalResult);
exit;
}
<?php
/*
* 同步海外仓已打印订单到海外仓
*/
if (!defined('WEB_PATH')) {
define("WEB_PATH", dirname(dirname(__DIR__)) . "/");
}
require_once WEB_PATH . "crontab/scripts.comm.php";
$currentTime = date('Y-m-d H:i:s');
$url = "http://us.oversea.valsun.cn/api/get_owtoerp_data.php?action=updatestock";
echo "--------- 同步海外仓已打印订单 [ {$currentTime} ] ---------\n";
$sql = "select * from om_unshipped_order where orderStatus=900 and orderType=910";
$resultData = $dbConn->fetch_array_all($dbConn->query($sql));
$owOrderMg = new OwOrderManageModel();
$orderAct = new OrderindexAct();
$orderSync = new OwOrderSyncModel();
foreach ($resultData as $row) {
$orderId = $row['id'];
$userSql = "select * from om_unshipped_order_userInfo where omOrderId = '{$orderId}'";
$UserInfo = $dbConn->fetch_first($userSql);
//获取用户信息
if (empty($UserInfo)) {
echo "订单未找到用户信息 [订单号：] === {$orderId} \n\n";
continue;
}
$skuList = $orderAct->act_getRealskulist($orderId);
//获取sku信息列表
if (empty($skuList)) {
echo "无法获取该订单的料号信息 [订单号：] === {$orderId} \n\n";
continue;
public function view_syncLocalPickUpOrder()
{
$orderId = isset($_GET['orderId']) ? $_GET['orderId'] : FALSE;
$returnData = array('code' => 0, 'msg' => '');
if (FALSE == $orderId) {
$returnData['msg'] = ' 未指定订单号';
echo json_encode($returnData);
exit;
}
$owOrderMg = new OwOrderManageModel();
$orderInfo = $owOrderMg->getOrderInfoById($orderId, '*');
if (FALSE == $orderInfo) {
$returnData['msg'] = '不存在的订单';
echo json_encode($returnData);
exit;
}
if ($orderInfo['orderStatus'] != 911 || $orderInfo['orderType'] != 928) {
$returnData['msg'] = '该订购单不是上门取件订单';
echo json_encode($returnData);
exit;
}
$orderAct = new OrderindexAct();
$orderSync = new OwOrderSyncModel();
$skuList = $orderAct->act_getRealskulist($orderId);
//获取sku信息列表
if (empty($skuList)) {
$returnData['msg'] = '未找到sku';
echo json_encode($returnData);
exit;
}
$transInfo = $owOrderMg->getShippingInfo($orderId);
if (empty($transInfo)) {
//获取运输方式信息
$transInfo = array('shippingWay' => 'localPickup', 'tracknumber' => '');
}
$platformInfo = $owOrderMg->getPlatformInfoByPid($orderInfo['platformId']);
if (FALSE == $platformInfo) {
$returnData['msg'] = '无法获取平台信息';
echo json_encode($returnData);
exit;
}
$platSuffix = $platformInfo['suffix'];
$extensionTabel = 'om_unshipped_order_extension_' . $platSuffix;
//扩展信息表名
$extensionInfo = $owOrderMg->getExtensionInfo($extensionTabel, $orderId);
if ($extensionInfo) {
if ("amazon" == $platSuffix) {
//亚马逊订单
$orderInfo['note'] = $extensionInfo['note'];
} else {
if ('ebay' == $platSuffix) {
//ebay订单
$orderInfo['note'] = $extensionInfo['feedback'];
}
}
}
$UserInfo = $owOrderMg->getBuyerInfoById($orderId);
$sellerInfo = $owOrderMg->getSellerInfoById($orderInfo['accountId']);
//获得卖家账号信息
if ($sellerInfo) {
$orderInfo['account'] = $sellerInfo['ebay_account'];
} else {
$orderInfo['account'] = '';
}
$orderInfo['putstatus'] = 16;
$submitData = array('orderInfo' => $orderInfo, 'userInfo' => $UserInfo, 'transInfo' => $transInfo, 'skuList' => $skuList);
// print_r($submitData);exit;
$reuslt = $orderSync->pushPrintedOrderToUsWh($orderId, $submitData);
if (TRUE == $reuslt) {
$returnData['code'] = 1;
} else {
$returnData['msg'] = OwOrderSyncModel::$errMsg;
}
echo json_encode($returnData);
}
<?php
/*
* 同步海外仓已打印订单到海外仓
*/
if (!defined('WEB_PATH')) {
define("WEB_PATH", dirname(dirname(__DIR__)) . "/");
}
require_once WEB_PATH . "crontab/scripts.comm.php";
$currentTime = date('Y-m-d H:i:s');
$resultAr = array();
$info = array();
$sql = "select * from om_unshipped_order where orderStatus=911 and orderType=917";
$order = $dbConn->fetch_array_all($dbConn->query($sql));
$owOrderMg = new OwOrderManageModel();
foreach ($order as $or) {
$orderId = $or['id'];
//订单号
$sellerInfo = $owOrderMg->getSellerInfoById($or['accountId']);
$seller = $sellerInfo['ebay_account'];
//卖家ID
$recordNum = $or['recordNumber'];
//recordNum
$trackInfo = $owOrderMg->getShippingInfo($orderId);
$trackNum = $trackInfo['tracknumber'];
//跟踪号
$shippnig = $trackInfo['shippingWay'];
//运输方式
$pid = $or['platformId'];
//平台id
$resultAr[] = array('orderId' => $orderId, 'seller' => $seller, 'recordNum' => $recordNum, 'trackNum' => $trackNum, 'shipping' => $shippnig);
public function view_cancelShippingWay()
{
$returnData = array('code' => 0, 'msg' => '');
$orderId = isset($_GET['orderId']) ? intval($_GET['orderId']) : FALSE;
if (empty($orderId)) {
$returnData['msg'] = '未指定订单号';
echo json_encode($returnData);
exit;
}
$owOrderMg = new OwOrderManageModel();
$transInfo = $owOrderMg->getShippingInfo($orderId);
if (FALSE == $transInfo) {
$returnData['msg'] = '该订单不存未生产运输方式!';
echo json_encode($returnData);
exit;
}
if (1 == $transInfo['isCanceled']) {
//已经取消过
$returnData['code'] = 1;
echo json_encode($returnData);
exit;
}
$trackNumber = $transInfo['tracknumber'];
if ('UPS Ground' == $transInfo['shippingWay'] || 0 == strlen($trackNumber)) {
//若是UPS 或 跟踪号为空 则直接置为已取消
$result = $owOrderMg->updateOwTransInfo(array('isCanceled' => 1), $orderId);
if (TRUE == $result) {
$returnData['code'] = 1;
echo json_encode($returnData);
exit;
} else {
$returnData['msg'] = '申请退款失败!';
echo json_encode($returnData);
exit;
}
}
if ('USPS' == $transInfo['shippingWay']) {
$uspsApp = new ApplyUSPSLabelModel();
$result = $uspsApp->refoundUSPS($trackNumber);
if ($result) {
$Upresult = $owOrderMg->updateOwTransInfo(array('isCanceled' => 1), $orderId);
$returnData['code'] = 1;
echo json_encode($returnData);
exit;
} else {
$returnData['msg'] = ApplyUSPSLabelModel::$errMsg;
echo json_encode($returnData);
exit;
}
}
}