public static function overWeightSplitB2B($omOrderId)
{
!self::$dbConn ? self::initDB() : null;
global $memc_obj;
//调用memcache获取sku信息
$mctime = time();
//var_dump($moOrderIdArr);
$tableName = 'om_unshipped_order';
$where = ' WHERE id = ' . $omOrderId . ' and is_delete = 0 and storeId = 1';
$orderData = OrderindexModel::showOrderList($tableName, $where);
$orderDetail = $orderData[$omOrderId]['orderDetail'];
$obj_order_data = $orderData[$omOrderId]['orderData'];
$orderExtenData = $orderData[$omOrderId]['orderExtenData'];
$orderUserInfoData = $orderData[$omOrderId]['orderUserInfoData'];
$_actualTotal = $obj_order_data['actualTotal'];
$_actualShipping = $obj_order_data['actualShipping'];
$_platformId = $obj_order_data['platformId'];
$_mainId = $obj_order_data['id'];
$_transportId = $obj_order_data['transportId'];
//var_dump($orderDetail); exit;
$omAvailableAct = new OmAvailableAct();
$GLOBAL_EBAY_ACCOUNT = $omAvailableAct->act_getTNameList2arrById('om_account', 'id', 'account', ' WHERE is_delete=0 AND platformId in(1,5) ');
$weightlists = array();
$skuinfo = array();
$goods_sn_nums = 0;
$shippfee_arr = array();
$ebay_total_be = 0;
foreach ($orderDetail as $k => $f) {
$sku = trim($f['orderDetailData']['sku']);
$amount = $f['orderDetailData']['amount'];
$shippingFee = $f['orderDetailData']['shippingFee'];
$goods_sn_nums += $amount;
$ebay_total_be += $f['orderDetailData']['amount'] * $f['orderDetailData']['itemPrice'];
$shippfee_arr[$sku] = round($shippingFee / $amount, 3);
//单个料号的运费
$skuinfo[$sku] = $f;
for ($i = 1; $i <= $amount; $i++) {
$var = $sku;
$oneskuweight = CommonModel::calcOnlySkuWeight($var, 1);
//一个sku的重量
$weightlists[$var][] = $oneskuweight[0];
}
}
$rate = $_actualTotal / $ebay_total_be;
//var_dump($weightlists); exit;
if ($goods_sn_nums <= 1) {
self::$errCode = '0020';
self::$errMsg = "只有一个料号组成，不允许超重拆分";
return false;
}
//echo "==========="; exit;
$keyarray = array();
$keyarrays = array();
$checkweight = 0;
$arrinfo = CommonModel::calcNowOrderWeight($omOrderId);
//var_dump($arrinfo); exit;
$realweight = $arrinfo[0];
$realcosts = $arrinfo[2];
$itemprices = $arrinfo[3];
foreach ($weightlists as $wk => $wv) {
foreach ($wv as $weightlist) {
$checkweight += $weightlist;
if ($checkweight > 1.85) {
$keyarrays[] = $keyarray;
$keyarray = array();
$checkweight = $weightlist;
$keyarray[$wk][] = $wk;
} else {
$keyarray[$wk][] = $wk;
}
}
}
if (!empty($keyarray)) {
$keyarrays[] = $keyarray;
}
//var_dump($keyarrays); exit;
BaseModel::begin();
//开始事务
$insert_orderData = array();
foreach ($keyarrays as $keyarray) {
$ebay_total = 0;
$totalweight = 0;
$insert_ebay_ids = array();
//var_dump($skuinfo); echo "<br>";
foreach ($keyarray as $k => $kav) {
//var_dump($skuinfo[$k]['orderDetailData']['itemPrice'], count($kav));
//$ebay_total += ($skuinfo[$k]['orderDetailData']['itemPrice'] + $shippfee_arr[$k]) * count($kav);
$ebay_total += $skuinfo[$k]['orderDetailData']['itemPrice'] * count($kav);
}
$ebay_total = $rate * $ebay_total;
$shipfee = 0;
//$val = generateOrdersn();
$insert_obj_order_data = $obj_order_data;
unset($insert_obj_order_data['id']);
$insert_obj_order_data['actualTotal'] = $ebay_total;
$insert_obj_order_data['orderType'] = C('STATEPENDING_OWDONE');
$insert_obj_order_data['orderAddTime'] = $mctime;
$insert_obj_order_data['isSplit'] = 2;
$insert_orderExtenData = $orderExtenData;
unset($insert_orderExtenData['id']);
$insert_orderUserInfoData = $orderUserInfoData;
unset($insert_orderUserInfoData['id']);
$insert_orderData = array('orderData' => $insert_obj_order_data, 'orderExtenData' => $insert_orderExtenData, 'orderUserInfoData' => $insert_orderUserInfoData);
/*$sql = "insert into ebay_splitorder (recordnumber, main_order_id, split_order_id, create_date) values ('$recordnumber', '$ebay_id', '$insert_ebay_id', '".date("Y-m-d H:i:s")."')";
$split_log .= "添加主定单和拆分订单到关系表中\r\n".$sql ."\r\n";
$dbcon->execute($sql) or die("Fail : $sql");*/
$obj_order_detail_data = array();
foreach ($keyarray as $k => $kav) {
$sku = $k;
$amount = count($kav);
$insert_orderDetailData = $skuinfo[$k]['orderDetailData'];
unset($insert_orderDetailData['id']);
$insert_orderDetailData['sku'] = strtoupper($sku);
$insert_orderDetailData['amount'] = $amount;
$insert_orderDetailData['createdTime'] = $mctime;
if (isset($shippfee_arr[$sku])) {
$insert_orderDetailData['shippingFee'] = $shippfee_arr[$sku] * $amount;
//相同料号运费拆分
}
$insert_orderDetailExtenData = $skuinfo[$k]['orderDetailExtenData'];
unset($insert_orderDetailExtenData['id']);
$obj_order_detail_data[] = array('orderDetailData' => $insert_orderDetailData, 'orderDetailExtenData' => $insert_orderDetailExtenData);
}
$insert_orderData['orderDetail'] = $obj_order_detail_data;
//echo "<pre>";
//var_dump($obj_order_detail_data); exit;
$calcInfo = CommonModel::calcAddOrderWeight($obj_order_detail_data);
//计算重量和包材
//var_dump($calcInfo); exit;
$insert_orderData['orderData']['calcWeight'] = $calcInfo[0];
$insert_orderData['orderData']['pmId'] = $calcInfo[1];
//var_dump($insert_orderData); exit;
$calcShippingInfo = CommonModel::calcAddOrderShippingFee($insert_orderData, 1);
//计算运费
//var_dump($calcShippingInfo); exit;
$insert_orderData['orderData']['calcShipping'] = $calcShippingInfo['fee']['fee'];
$insert_orderData['orderData']['channelId'] = $calcShippingInfo['fee']['channelId'];
/*$interceptInfo = CommonModel :: auto_contrast_intercept($orderData);
//print_r($interceptInfo); exit;
$orderData['orderData']['orderStatus'] = $interceptInfo['orderStatus'];
$orderData['orderData']['orderType'] = $interceptInfo['orderType'];*/
if ($_spitId = OrderAddModel::insertAllOrderRowNoEvent($insert_orderData)) {
//echo $split_log .= 'insert success!' . "\n"; exit;
//var_dump($_mainId,$_spitId); exit;
if (!OrderLogModel::insertOrderLog($_spitId, 'INSERT ORDER')) {
BaseModel::rollback();
self::$errCode = '0021';
self::$errMsg = "split error!";
return false;
}
if (!OrderRecordModel::insertSpitRecords($_mainId, $_spitId)) {
BaseModel::rollback();
self::$errCode = '0022';
self::$errMsg = "split error!";
return false;
}
} else {
$split_log .= 'insert error!' . "\n";
BaseModel::rollback();
self::$errCode = '0023';
self::$errMsg = "split error!";
return false;
}
if (!OrderindexModel::deleteOrderData($tableName, $where)) {
self::$errCode = '0024';
self::$errMsg = "split error!";
return false;
}
if (!OrderLogModel::insertOrderLog($_mainId, 'DELETE ORDER')) {
BaseModel::rollback();
self::$errCode = '0025';
self::$errMsg = "split error!";
return false;
}
BaseModel::commit();
BaseModel::autoCommit();
}
self::$errCode = '200';
self::$errMsg = "split success!";
return true;
}
public function act_handSplitOrder()
{
global $memc_obj;
$skus = isset($_POST['skus']) ? $_POST['skus'] : "";
$orderid = isset($_POST['orderid']) ? $_POST['orderid'] : "";
$type = isset($_POST['type']) ? $_POST['type'] : "";
//$userId = $_SESSION['sysUserId'];
$sku_arr = explode(",", $skus);
if (empty($orderid)) {
die(json_encode(array('errCode' => '1', 'status' => 'error', 'errMsg' => '订单号为空')));
}
$origin_orderData = M('Order')->getFullUnshippedOrderById(array($orderid));
if (empty($origin_orderData)) {
//订单号不存在
die(json_encode(array('errCode' => '1', 'status' => 'error', 'errMsg' => '拆分失败：' . get_promptmsg(10080))));
}
$origin_orderData = $origin_orderData[$orderid];
$isExpressDelivery = $origin_orderData['order']['isExpressDelivery'];
if ($isExpressDelivery != 1) {
$return_result = array('errCode' => '1', 'status' => 'error', 'errMsg' => '非快递订单，禁止手动拆分');
die(json_encode($return_result));
}
$flag = SplitOrderModel::handSplitOrder($orderid, $skus);
//拆分订单
if (!$flag) {
self::$errCode = SplitOrderModel::$errCode;
self::$errMsg = SplitOrderModel::$errMsg;
return false;
}
self::$errCode = SplitOrderModel::$errCode;
self::$errMsg = SplitOrderModel::$errMsg;
return true;
}
public function act_handSplitOrder()
{
global $memc_obj;
$skus = isset($_POST['skus']) ? $_POST['skus'] : "";
$orderid = isset($_POST['orderid']) ? $_POST['orderid'] : "";
$type = isset($_POST['type']) ? $_POST['type'] : "";
//$userId = $_SESSION['sysUserId'];
$sku_arr = explode(",", $skus);
if (empty($orderid)) {
self::$errCode = '0061';
self::$errMsg = "empty orderid";
return false;
}
$flag = SplitOrderModel::handSplitOrder($orderid, $skus);
//拆分订单
if (!$flag) {
self::$errCode = SplitOrderModel::$errCode;
self::$errMsg = SplitOrderModel::$errMsg;
return false;
}
self::$errCode = SplitOrderModel::$errCode;
self::$errMsg = SplitOrderModel::$errMsg;
return true;
}
