public static function combineOrder($orderIdArr)
{
self::initDB();
BaseModel::begin();
//开始事务
$serchSql = "SELECT * FROM om_unshipped_order WHERE id in ('" . join("','", $orderIdArr) . "') and is_delete = 0 and storeId = 1 ";
$querySql = self::$dbConn->query($serchSql);
$serchSqlArr = self::$dbConn->fetch_array_all($querySql);
//判断一：订单数量统计
if (count($serchSqlArr) < 2) {
self::$errCode = "1111";
self::$errMsg = "合并订单最少需要选择两个或两个以上的订单!";
return false;
}
$platfrom = omAccountModel::getPlatformSuffixById($serchSqlArr[0]['platformId']);
$extension = $platfrom['suffix'];
//获取后缀名称
$temporderStatus = "";
//相同状态一
$temporderStatus2 = "";
//相同状态二
$userinfo = array();
//订单相同条件
$orderSn = array();
//订单编号
$onlineTotal = 0;
//线上总价
$actualTotal = 0;
//实际收款总价
$calcWeight = 0;
//估算重量，单位是kg
$calcShipping = 0;
//估算运费
foreach ($serchSqlArr as $selectArr) {
$orderSn[] = $selectArr['id'];
$onlineTotal += $selectArr['onlineTotal'];
$actualTotal += $selectArr['actualTotal'];
$calcWeight += $selectArr['calcWeight'];
$calcShipping += $selectArr['calcShipping'];
//判断二：订单被其他人 <锁定> 订单判断
if ($selectArr['isLock'] == 1) {
self::$errCode = "2222";
self::$errMsg = "订单[" . $selectArr['id'] . "]已经被 [" . UserModel::getUsernameById($selectArr['lockUser']) . "] 锁定，不能合并操作。";
return false;
}
//判断三：已合并订单，无法再次合并判断
if (in_array($selectArr['combineOrder'], array(1, 2))) {
self::$errCode = "3333";
self::$errMsg = "订单[" . $selectArr['id'] . "]已经有订单合并操作，不能重复订单合并。";
return false;
}
//判断四：已合并包裹订单，无法合并判断
if (in_array($selectArr['combinePackage'], array(1, 2))) {
self::$errCode = "4444";
self::$errMsg = "订单[" . $selectArr['id'] . "]是合并包裹订单，不能订单合并操作。";
return false;
}
//判断五：订单信息不相同判断
$userinfsql = "SELECT * FROM om_unshipped_order_userInfo WHERE omOrderId = {$selectArr['id']}";
$userinfsql = self::$dbConn->fetch_first($userinfsql);
$tempArr = array();
$tempArr['accountId'] = trim($selectArr['accountId']);
$tempArr['platformUsername'] = trim($userinfsql['platformUsername']);
$tempArr['username'] = trim($userinfsql['username']);
$tempArr['countryName'] = trim($userinfsql['countryName']);
$tempArr['state'] = trim($userinfsql['state']);
$tempArr['city'] = trim($userinfsql['city']);
$tempArr['street'] = trim($userinfsql['street']);
$tempArr['currency'] = trim($userinfsql['currency']);
//币种判断
if (!empty($userinfo) && $userinfo != $tempArr) {
self::$errCode = "5555";
self::$errMsg = "订单信息不相同，无法合并订单操作。";
return false;
}
$userinfo = $tempArr;
//订单信息相同，进入下次比较。
//判断六：同状态判断
$orderStatus = "";
//订单状态一
$orderType = "";
//订单状态二
$orderStatus = $selectArr['orderStatus'];
$orderType = $selectArr['orderType'];
if (!empty($temporderStatus) && $temporderStatus != $orderStatus) {
self::$errCode = "6666";
self::$errMsg = "订单不在同一文件夹，无法合并订单操作。";
return false;
}
$temporderStatus = $orderStatus;
if (!empty($temporderStatus2) && $temporderStatus2 != $orderType) {
self::$errCode = "6666";
self::$errMsg = "订单不在同一文件夹，无法合并订单操作。";
return false;
}
$orderExtensql = "SELECT * FROM om_unshipped_order_extension_" . $extension . " WHERE omOrderId = {$selectArr['id']}";
$orderExtensql = self::$dbConn->fetch_first($orderExtensql);
$temporderStatus2 = $orderType;
}
$insertOrder = array();
$insertOrder['orderData'] = $serchSqlArr[0];
$insert_userinfo = $userinfsql;
unset($insert_userinfo['omOrderId']);
$insertOrder['orderUserInfoData'] = $insert_userinfo;
$insert_orderExtensql = $orderExtensql;
unset($insert_orderExtensql['omOrderId']);
$insertOrder['orderExtenData'] = $insert_orderExtensql;
//$insertOrder['orderNote'] = $userinfsql;
unset($insertOrder['orderData']['id']);
$insertOrder['orderData']['onlineTotal'] = $onlineTotal;
$insertOrder['orderData']['actualTotal'] = $actualTotal;
$insertOrder['orderData']['calcWeight'] = $calcWeight;
$insertOrder['orderData']['calcShipping'] = $calcShipping;
$insertOrder['orderData']['orderAddTime'] = time();
$insertOrder['orderData']['combineOrder'] = 2;
$insertOrder['orderData']['orderAttribute'] = 3;
//$insertOrder['orderDetail'] = array();
$detailSql = "SELECT * FROM om_unshipped_order_detail WHERE omOrderId in ('" . join("','", $orderIdArr) . "') and is_delete = 0 and storeId = 1 ";
$detailSql = self::$dbConn->query($detailSql);
$detailSqlArr = self::$dbConn->fetch_array_all($detailSql);
$orderDetail = array();
foreach ($detailSqlArr as $value) {
//$orderDetailData = array();
//$orderDetailExtenData = array();
$obj_orderDetail = $value;
unset($obj_orderDetail['id']);
unset($obj_orderDetail['omOrderId']);
$orderDetailData = $obj_orderDetail;
$detailExtenSql = "SELECT * FROM om_unshipped_order_detail_extension_" . $extension . " WHERE omOrderdetailId = '" . $value['id'] . "' ";
$detailExtenSql = self::$dbConn->query($detailExtenSql);
$detailExtenSqlArr = self::$dbConn->fetch_array($detailExtenSql);
$obj_orderDetailExten = $detailExtenSqlArr;
unset($obj_orderDetailExten['omOrderdetailId']);
$orderDetailExtenData = $obj_orderDetailExten;
$orderDetail[] = array('orderDetailData' => $orderDetailData, 'orderDetailExtenData' => $orderDetailExtenData);
}
$insertOrder['orderDetail'] = $orderDetail;
//var_dump($insertOrder); exit;
if ($insertId = OrderAddModel::insertAllOrderRowNoEvent($insertOrder)) {
//echo $split_log .= 'insert success!' . "\n"; exit;
//var_dump($_mainId,$_spitId); exit;
if (!OrderLogModel::insertOrderLog($insertId, '合并产生新订单')) {
BaseModel::rollback();
self::$errCode = '001';
self::$errMsg = "合并失败!";
return false;
}
if (!OrderRecordModel::insertCombineRecord($serchSqlArr[0]['id'], $insertId)) {
BaseModel::rollback();
self::$errCode = '002';
self::$errMsg = "合并订单失败添加记录失败!";
return false;
}
$updateOrder = array();
$updateOrder['is_delete'] = 1;
$updateOrder['combineOrder'] = 1;
if (!OrderindexModel::updateOrder("om_unshipped_order", $updateOrder, " WHERE id in ('" . join("','", $orderSn) . "')")) {
BaseModel::rollback();
//事物回滚
self::$errCode = "0012";
self::$errMsg = "合并更新原始订单失败!";
return false;
}
} else {
//$split_log .= '补寄新订单产生失败!' . "\n";
BaseModel::rollback();
self::$errCode = '003';
self::$errMsg = "合并新订单产生失败";
return false;
}
BaseModel::commit();
self::$errCode = '200';
self::$errMsg = "合并新订单成功！";
return TRUE;
}
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 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 view_guoneiSaleImport()
{
//var_dump($_POST);//exit;
include_once WEB_PATH . "lib/PHPExcel.php";
//phpexcel
include_once WEB_PATH . "conf/scripts/script.ebay.config.php";
//global $SYSTEM_ACCOUNTS,$__liquid_items_fenmocsku,$__liquid_items_BuiltinBattery,$__liquid_items_SuperSpecific,$__liquid_items_Paste;
$toptitle = '速卖通线下订单导入';
//头部title
$this->smarty->assign('toptitle', $toptitle);
$this->smarty->assign('toplevel', 2);
$this->smarty->assign('secondlevel', 220);
$OmAccountAct = new OmAccountAct();
$aliexpressAccountList = $OmAccountAct->act_getINNERAccountList();
$this->smarty->assign("aliexpressAccountList", $aliexpressAccountList);
if (isset($_FILES['aliexpressFile']['tmp_name'])) {
$filePath = $_FILES['aliexpressFile']['tmp_name'];
$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);
//$excellists = excel2array($PHPExcel, $filePath, 0, 0);
//print_r($excellists);print_r($_SESSION);
$orderid = array();
$orderData = array();
//$orderarr = OrderindexModel::showSearchOrderList("om_unshipped_order","where da.id=14448");
//echo "<pre>";print_r($orderarr);
$account = $_POST['aliexpressAccount'];
$transportation = CommonModel::getCarrierList();
//所有的
$c = 2;
while (true) {
$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;
$c++;
$recordNumber = trim($currentSheet->getCell($aa)->getValue());
$userId = trim($currentSheet->getCell($bb)->getValue());
$skuStr = trim($currentSheet->getCell($cc)->getValue());
$amount = trim($currentSheet->getCell($dd)->getValue());
$countryName = trim($currentSheet->getCell($ee)->getValue());
$actualTotal = trim($currentSheet->getCell($ff)->getValue());
$currency = trim($currentSheet->getCell($gg)->getValue());
$street1 = trim($currentSheet->getCell($hh)->getValue());
$street2 = trim($currentSheet->getCell($ii)->getValue());
$carrierNameCn = trim($currentSheet->getCell($jj)->getValue());
$city = trim($currentSheet->getCell($kk)->getValue());
$state = trim($currentSheet->getCell($ll)->getValue());
$zipCode = trim($currentSheet->getCell($mm)->getValue());
$phone = trim($currentSheet->getCell($nn)->getValue());
$trackNumber = trim($currentSheet->getCell($oo)->getValue());
$noteStr = trim($currentSheet->getCell($pp)->getValue());
$ordersTime = time();
$paymentTime = time();
$email = '';
$onlineTotal = '';
$shippingFee = '';
$transId = '';
$note = '';
$username = $userId;
$platformUsername = $userId;
$PayPalPaymentId = $transId;
if (empty($recordNumber)) {
break;
}
$skuArrlist = explode(',', $skuStr);
$noteArr = explode(',', $noteStr);
$skuCount = count($skuArrlist);
for ($i = 0; $i < $skuCount; $i++) {
list($sku, $amount) = explode('*', $skuArrlist[$i]);
//echo "--sku=$sku---amount=$amount-------";
//detail信息
$orderData[$recordNumber]['orderDetail'][$sku]['orderDetailData']['sku'] = $sku;
$orderData[$recordNumber]['orderDetail'][$sku]['orderDetailData']['amount'] = $amount;
$orderData[$recordNumber]['orderDetail'][$sku]['orderDetailData']['recordNumber'] = $recordNumber;
$orderData[$recordNumber]['orderDetail'][$sku]['orderDetailData']['createdTime'] = time();
$orderData[$recordNumber]['orderDetail'][$sku]['orderDetailExtenData']['itemTitle'] = $noteArr[$i];
$orderData[$recordNumber]['orderDetail'][$sku]['orderDetailExtenData']['transId'] = $transId;
if (!empty($note)) {
$orderData[$recordNumber]['orderNote'][$c]['content'] = $note;
$orderData[$recordNumber]['orderNote'][$c]['userId'] = $_SESSION['sysUserId'];
}
}
//order信息
$orderData[$recordNumber]['orderData']['recordNumber'] = $recordNumber;
$orderData[$recordNumber]['orderData']['ordersTime'] = $ordersTime;
$orderData[$recordNumber]['orderData']['paymentTime'] = $paymentTime;
$orderData[$recordNumber]['orderData']['onlineTotal'] = $onlineTotal;
$orderData[$recordNumber]['orderData']['actualTotal'] = $actualTotal;
$orderData[$recordNumber]['orderData']['actualShipping'] = $shippingFee;
$orderData[$recordNumber]['orderData']['calcShipping'] = $shippingFee;
$orderData[$recordNumber]['orderData']['orderAddTime'] = time();
$orderData[$recordNumber]['orderData']['orderStatus'] = 100;
$orderData[$recordNumber]['orderData']['orderType'] = 101;
$SYS_ACCOUNTS = OmAvailableModel::getTNameList("om_account", "*", " where account='{$account}'");
$orderData[$recordNumber]['orderData']['accountId'] = $SYS_ACCOUNTS[0]['id'];
$orderData[$recordNumber]['orderData']['platformId'] = $SYS_ACCOUNTS[0]['platformId'];
$plataccountId = $SYS_ACCOUNTS[0]['id'];
$platformId = $SYS_ACCOUNTS[0]['platformId'];
$SYS_ACCOUNTS = OmAvailableModel::getPlatformAccount();
foreach ($SYS_ACCOUNTS as $platform => $accounts) {
foreach ($accounts as $accountId => $accountname) {
if ($account == $accountname) {
if ($platform == "ebay") {
$orderData[$recordNumber]['orderData']['isFixed'] = 2;
} else {
$orderData[$recordNumber]['orderData']['isFixed'] = 1;
}
}
}
}
foreach ($transportation as $tranValue) {
if ($tranValue['carrierNameCn'] == $carrierNameCn) {
$orderData[$recordNumber]['orderData']['transportId'] = $tranValue['id'];
break;
}
}
if ($trackNumber != '') {
$orderData[$recordNumber]['orderTrack']['tracknumber'] = $trackNumber;
$orderData[$recordNumber]['orderTrack']['addUser'] = $_SESSION['sysUserId'];
$orderData[$recordNumber]['orderTrack']['createdTime'] = time();
}
//order扩展信息
$orderData[$recordNumber]['orderExtenData']['currency'] = $currency;
$orderData[$recordNumber]['orderExtenData']['paymentStatus'] = "PAY_SUCCESS";
$orderData[$recordNumber]['orderExtenData']['transId'] = $recordNumber;
// 交易id;;
$orderData[$recordNumber]['orderExtenData']['PayPalPaymentId'] = $PayPalPaymentId;
$orderData[$recordNumber]['orderExtenData']['platformUsername'] = $platformUsername;
$orderData[$recordNumber]['orderExtenData']['currency'] = $currency;
//user信息
$orderData[$recordNumber]['orderUserInfoData']['platformUsername'] = $platformUsername;
$orderData[$recordNumber]['orderUserInfoData']['username'] = $username;
$orderData[$recordNumber]['orderUserInfoData']['email'] = $email;
$orderData[$recordNumber]['orderUserInfoData']['street'] = $street1;
$orderData[$recordNumber]['orderUserInfoData']['address2'] = ${$street2};
$orderData[$recordNumber]['orderUserInfoData']['currency'] = $currency;
//$orderData[$recordNumber]['orderUserInfoData']['address3'] = $address3;
$orderData[$recordNumber]['orderUserInfoData']['city'] = $city;
$orderData[$recordNumber]['orderUserInfoData']['state'] = $state;
$orderData[$recordNumber]['orderUserInfoData']['zipCode'] = $zipCode;
$orderData[$recordNumber]['orderUserInfoData']['countryName'] = $countryName;
$orderData[$recordNumber]['orderUserInfoData']['landline'] = $phone;
$orderData[$recordNumber]['orderUserInfoData']['phone'] = $phone;
//note信息
if (!empty($note)) {
$orderData[$recordNumber]['orderNote'][$c]['content'] = $note;
$orderData[$recordNumber]['orderNote'][$c]['userId'] = $_SESSION['sysUserId'];
}
}
//print_r($orderData);
//echo "<pre>";print_r($orderData);//exit;
$message = "";
foreach ($orderData as $id => $order) {
//echo $id;
//$msg = commonModel::checkOrder($id);
$msg = commonModel::checkRecordNumber($id, $platformId, $plataccountId);
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[$value[0]]['orderData']['calcShipping'] = $weightfee[3];
$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']['fee'];
//缺货拦截
$orderData[$id] = AutoModel::auto_contrast_intercept($orderData[$id]);
/*$orderData[$id]['orderData']['orderStatus'] = $status['orderStatus'];
$orderData[$id]['orderData']['orderType'] = $status['orderType'];*/
//echo "<pre>";print_r($orderData[$id]);
//print_r($orderData);
//exit;
//插入订单
$info = OrderAddModel::insertAllOrderRowNoEvent($orderData[$id]);
if ($info) {
$message .= "<font color='green'>订单{$id}上传成功！</font><br>";
} else {
$message .= "<font color='red'>订单{$id}上传失败！</font><br>";
}
}
$this->smarty->assign("showerrorinfo", $message);
//header("location:index.php?mod=underLineOrderImport&act=importOrder");
}
$this->smarty->display('guoneiSaleImport.htm');
}
public function view_aliexpressimport()
{
$this->smarty->assign('toplevel', 2);
$this->smarty->assign('secondlevel', 24);
$OmAccountAct = new OmAccountAct();
//$aliexpressAccountList = $OmAccountAct->act_getAccountListByPid(2);
$aliexpressAccountList = $OmAccountAct->act_getAccountListAliexpress();
var_dump($aliexpressAccountList);
$aliexpressAccountList = json_decode($aliexpressAccountList, true);
$this->smarty->assign("aliexpressAccountList", $aliexpressAccountList);
$this->smarty->display('aliexpressImport.htm');
include_once WEB_PATH . "lib/PHPExcel.php";
//phpexcel
$toptitle = 'underLineOrderImport';
//头部title
$this->smarty->assign('toptitle', $toptitle);
$this->smarty->assign('toplevel', 2);
$this->smarty->assign('secondlevel', 22);
if (isset($_FILES['orderUpfile']['tmp_name'])) {
$filePath = $_FILES['orderUpfile']['tmp_name'];
$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);
//$excellists = excel2array($PHPExcel, $filePath, 0, 0);
//print_r($excellists);print_r($_SESSION);
$orderid = array();
$orderData = array();
//$orderarr = OrderindexModel::showSearchOrderList("om_unshipped_order","where da.id=14448");
//echo "<pre>";print_r($orderarr);
$c = 2;
while (true) {
$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;
$c++;
$account = trim($currentSheet->getCell($aa)->getValue());
$recordNumber = trim($currentSheet->getCell($bb)->getValue());
$platformUsername = trim($currentSheet->getCell($cc)->getValue());
$email = trim($currentSheet->getCell($dd)->getValue());
$ordersTime = trim($currentSheet->getCell($ee)->getValue());
$paymentTime = trim($currentSheet->getCell($ff)->getValue());
$sku = trim($currentSheet->getCell($gg)->getValue());
$amount = trim($currentSheet->getCell($hh)->getValue());
$itemTitle = trim($currentSheet->getCell($ii)->getValue());
$note = trim($currentSheet->getCell($jj)->getValue());
$itemPrice = trim($currentSheet->getCell($kk)->getValue());
$shippingFee = trim($currentSheet->getCell($ll)->getValue());
$actualTotal = trim($currentSheet->getCell($mm)->getValue());
$currency = trim($currentSheet->getCell($nn)->getValue());
$transId = trim($currentSheet->getCell($oo)->getValue());
$username = trim($currentSheet->getCell($pp)->getValue());
$street = trim($currentSheet->getCell($qq)->getValue());
$address2 = trim($currentSheet->getCell($rr)->getValue());
$address3 = trim($currentSheet->getCell($ss)->getValue());
$city = trim($currentSheet->getCell($tt)->getValue());
$state = trim($currentSheet->getCell($uu)->getValue());
$zipCode = trim($currentSheet->getCell($vv)->getValue());
$countryName = trim($currentSheet->getCell($ww)->getValue());
$landline = trim($currentSheet->getCell($xx)->getValue());
$carrierNameCn = trim($currentSheet->getCell($yy)->getValue());
if (empty($account)) {
break;
}
if (in_array($recordNumber, $orderid)) {
$orderData[$recordNumber]['orderDetail'][$sku]['orderDetailData']['sku'] = $sku;
$orderData[$recordNumber]['orderDetail'][$sku]['orderDetailData']['amount'] = $amount;
$orderData[$recordNumber]['orderDetail'][$sku]['orderDetailData']['itemPrice'] = $itemPrice;
$orderData[$recordNumber]['orderDetail'][$sku]['orderDetailData']['shippingFee'] = $shippingFee;
$orderData[$recordNumber]['orderDetail'][$sku]['orderDetailExtenData']['itemTitle'] = $itemTitle;
//$orderData['orderDetail']['orderDetailExtenData']['note'] = $value[10];
$orderData[$recordNumber]['orderDetail'][$sku]['orderDetailExtenData']['transId'] = $transId;
if (!empty($note)) {
$orderData[$recordNumber]['orderNote'][$c]['content'] = $note;
$orderData[$recordNumber]['orderNote'][$c]['userId'] = $_SESSION['sysUserId'];
}
} else {
$orderid[] = $recordNumber;
//order信息
$orderData[$recordNumber]['orderData']['recordNumber'] = $recordNumber;
$orderData[$recordNumber]['orderData']['ordersTime'] = strtotime($ordersTime);
$orderData[$recordNumber]['orderData']['paymentTime'] = strtotime($paymentTime);
$orderData[$recordNumber]['orderData']['actualTotal'] = $actualTotal;
$orderData[$recordNumber]['orderData']['orderAddTime'] = time();
$SYSTEM_ACCOUNTS = OmAvailableModel::getTNameList("om_account", "*", " where account='{$account}'");
$orderData[$recordNumber]['orderData']['accountId'] = $SYSTEM_ACCOUNTS[0]['id'];
$orderData[$recordNumber]['orderData']['platformId'] = $SYSTEM_ACCOUNTS[0]['platformId'];
$SYSTEM_ACCOUNTS = OmAvailableModel::getPlatformAccount();
foreach ($SYSTEM_ACCOUNTS as $platform => $accounts) {
foreach ($accounts as $accountId => $accountname) {
if ($account == $accountname) {
if ($platform == "ebay") {
$orderData[$recordNumber]['orderData']['isFixed'] = 2;
} else {
$orderData[$recordNumber]['orderData']['isFixed'] = 1;
}
}
}
}
$transportation = CommonModel::getCarrierList();
//所有的
foreach ($transportation as $tranValue) {
if ($tranValue['carrierNameCn'] == $carrierNameCn) {
$orderData[$recordNumber]['orderData']['transportId'] = $tranValue['id'];
break;
}
//$transportationList[$tranValue['id']] = $tranValue['carrierNameCn'];
}
//order扩展信息
$orderData[$recordNumber]['orderExtenData']['currency'] = $currency;
$orderData[$recordNumber]['orderExtenData']['paymentStatus'] = "PAY_SUCCESS";
$orderData[$recordNumber]['orderExtenData']['transId'] = $recordNumber;
// 交易id;;
$orderData[$recordNumber]['orderExtenData']['platformUsername'] = $platformUsername;
//$orderData[$recordNumber]['orderExtenData']['currency'] = $currency;
//user信息
$orderData[$recordNumber]['orderUserInfoData']['platformUsername'] = $platformUsername;
$orderData[$recordNumber]['orderUserInfoData']['username'] = $username;
$orderData[$recordNumber]['orderUserInfoData']['email'] = $email;
$orderData[$recordNumber]['orderUserInfoData']['street'] = $street;
$orderData[$recordNumber]['orderUserInfoData']['currency'] = $currency;
$orderData[$recordNumber]['orderUserInfoData']['address2'] = $address2;
$orderData[$recordNumber]['orderUserInfoData']['address3'] = $address3;
$orderData[$recordNumber]['orderUserInfoData']['city'] = $city;
$orderData[$recordNumber]['orderUserInfoData']['state'] = $state;
$orderData[$recordNumber]['orderUserInfoData']['zipCode'] = $zipCode;
$orderData[$recordNumber]['orderUserInfoData']['countryName'] = $countryName;
$orderData[$recordNumber]['orderUserInfoData']['landline'] = $landline;
//detail信息
$orderData[$recordNumber]['orderDetail'][$sku]['orderDetailData']['sku'] = $sku;
$orderData[$recordNumber]['orderDetail'][$sku]['orderDetailData']['amount'] = $amount;
$orderData[$recordNumber]['orderDetail'][$sku]['orderDetailData']['itemPrice'] = $itemPrice;
$orderData[$recordNumber]['orderDetail'][$sku]['orderDetailData']['shippingFee'] = $shippingFee;
$orderData[$recordNumber]['orderDetail'][$sku]['orderDetailData']['recordNumber'] = $recordNumber;
$orderData[$recordNumber]['orderDetail'][$sku]['orderDetailData']['createdTime'] = time();
$orderData[$recordNumber]['orderDetail'][$sku]['orderDetailExtenData']['itemTitle'] = $itemTitle;
//$orderData['orderDetail']['orderDetailExtenData']['note'] = $value[10];
$orderData[$recordNumber]['orderDetail'][$sku]['orderDetailExtenData']['transId'] = $transId;
//note信息
if (!empty($note)) {
$orderData[$recordNumber]['orderNote'][$c]['content'] = $note;
$orderData[$recordNumber]['orderNote'][$c]['userId'] = $_SESSION['sysUserId'];
}
}
}
//echo "<pre>";print_r($orderData);
$message = "";
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[$value[0]]['orderData']['calcShipping'] = $weightfee[3];
$orderData[$id]['orderData']['pmId'] = $weightfee[1];
//计算运费
$calcShippingInfo = CommonModel::calcAddOrderShippingFee($insertOrder, $orderData[$id]['orderData']['isFixed']);
//计算运费
$orderData[$id]['orderData']['channelId'] = $calcShippingInfo['fee']['channelId'];
//缺货拦截
$status = commonModel::auto_contrast_intercept($orderData[$id]);
$orderData[$id]['orderData']['orderStatus'] = $status['orderStatus'];
$orderData[$id]['orderData']['orderType'] = $status['orderType'];
//print_r($order);
//插入订单
$info = OrderAddModel::insertAllOrderRowNoEvent($order);
if ($info) {
$message .= "<font color='green'>订单{$id}上传成功！</font><br>";
} else {
$message .= "<font color='red'>订单{$id}上传失败！</font><br>";
}
}
$this->smarty->assign("showerrorinfo", $message);
//header("location:index.php?mod=underLineOrderImport&act=importOrder");
}
$this->smarty->display('underLineOrderImport.htm');
}
public function act_operateAbOrderAPI()
{
if (!isset($_POST['omData'])) {
self::$errCode = 500;
self::$errMsg = '未成功接收数据！';
return false;
}
$ostatus = 770;
$otype = 0;
$storeId = 1;
$orderstr = $_POST['omData'];
$orderstr2 = $_POST['omData2'];
$orderids = array_unique(explode(',', $orderstr));
$invoiceids = array_unique(explode(',', $orderstr2));
if (!$orderids) {
self::$errCode = 400;
self::$errMsg = '未获取订单编号信息！';
return false;
}
//var_dump($orderids); exit;
$OrderindexAct = new OrderindexAct();
$WarehouseAPIAct = new WarehouseAPIAct();
foreach ($orderids as $k => $orderId) {
BaseModel::begin();
//开始事务
$insertOrderData = array();
$AbOrderInfo = $WarehouseAPIAct->act_getAbOrderInfo($invoiceids[$k]);
//var_dump($AbOrderInfo); echo "<br>";
//exit;
$where = ' WHERE id = ' . $orderId . ' and is_delete = 0 AND storeId = ' . $storeId . ' LIMIT 1';
$orderList = $OrderindexAct->act_showOrderList($ostatus, $otype, $where);
//var_dump($orderList);exit;
$order = $orderList[$orderId];
$orderData = $order['orderData'];
$insert_orderData = $orderData;
unset($insert_orderData['id']);
$insert_orderData['orderStatus'] = C('STATEOUTOFSTOCK');
$insert_orderData['orderType'] = C('STATEOUTOFSTOCK_ABNORMAL');
$orderExtenData = $order['orderExtenData'];
$insert_orderExtenData = $orderExtenData;
unset($insert_orderExtenData['omOrderId']);
$orderUserInfoData = $order['orderUserInfoData'];
$insert_orderUserInfoData = $orderUserInfoData;
unset($insert_orderUserInfoData['omOrderId']);
//$orderTracknumber = $order['orderTracknumber'];
//$orderAudit = $order['orderAudit'];
$orderDetail = $order['orderDetail'];
$insertOrderData['orderData'] = $insert_orderData;
$insertOrderData['orderExtenData'] = $insert_orderExtenData;
$insertOrderData['orderUserInfoData'] = $insert_orderUserInfoData;
$insert_orderDetail = array();
$need_delete_ids = array();
foreach ($orderDetail as $dkey => $detailValue) {
$orderDetailData = $detailValue['orderDetailData'];
$orderDetailExtenData = $detailValue['orderDetailExtenData'];
if (!isset($AbOrderInfo[$orderDetailData['sku']]) || $AbOrderInfo[$orderDetailData['sku']] == 0) {
$insert_orderDetailData = $orderDetailData;
unset($insert_orderDetailData['id']);
unset($insert_orderDetailData['omOrderId']);
$insert_orderDetailExtenData = $orderDetailExtenData;
unset($insert_orderDetailExtenData['omOrderdetailId']);
$insert_orderDetail[$dkey]['orderDetailData'] = $insert_orderDetailData;
$insert_orderDetail[$dkey]['orderDetailExtenData'] = $insert_orderDetailExtenData;
$need_delete_ids[] = $orderDetailData['id'];
}
}
$insertOrderData['orderDetail'] = $insert_orderDetail;
$count_insert_orderDetail = count($insert_orderDetail);
$count_orderDetail = count($orderDetail);
$tableName = "om_unshipped_order";
if ($count_insert_orderDetail > 0 && $count_insert_orderDetail < $count_orderDetail) {
$calcWeight = CommonModel::calcNowOrderWeight($orderId);
//重新计算原来订单的重量
if (!OrderindexModel::deleteOrderDetail(array('is_delete' => 1), ' where id in(' . join(',', $need_delete_ids) . ')')) {
BaseModel::rollback();
self::$errCode = '005';
self::$errMsg = "删除原订单明细失败!";
return false;
}
$insertOrderData['orderData']['isCopy'] = 2;
$insertOrderData['orderData']['actualTotal'] = 0.0;
//var_dump($orderData);exit;
$calcInfo = CommonModel::calcAddOrderWeight($insert_orderDetail);
//计算重量和包材
//var_dump($calcInfo); exit;
$insertOrderData['orderData']['calcWeight'] = $calcInfo[0];
$insertOrderData['orderData']['pmId'] = $calcInfo[1];
if (count($insertOrderData['orderDetail']) > 1) {
$insertOrderData['orderData']['orderAttribute'] = 3;
} else {
if (isset($insertOrderData['orderDetail'][0]['orderDetailData']['amount']) && $insertOrderData['orderDetail'][0]['orderDetailData']['amount'] > 1) {
$insertOrderData['orderData']['orderAttribute'] = 2;
}
}
$calcShippingInfo = CommonModel::calcAddOrderShippingFee($insertOrder, 1);
//计算运费
$insertOrderData['orderData']['channelId'] = $calcShippingInfo['fee']['channelId'];
$insertOrderData['orderData']['calcShipping'] = $calcShippingInfo['fee']['fee'];
//print_r($insertOrderData); exit;
if ($_spitId = OrderAddModel::insertAllOrderRowNoEvent($insertOrderData)) {
if (!OrderLogModel::insertOrderLog($_spitId, 'INSERT ORDER')) {
BaseModel::rollback();
self::$errCode = '001';
self::$errMsg = "插入订单日志失败!";
return false;
}
if (!OrderRecordModel::insertSpitRecords($orderId, $_spitId)) {
BaseModel::rollback();
self::$errCode = '002';
self::$errMsg = "插入拆分日志失败!";
return false;
}
} else {
BaseModel::rollback();
self::$errCode = '010';
self::$errMsg = "插入订单信息失败!";
return false;
}
$returnStatus0 = array('isCopy' => 1, 'calcWeight' => $calcWeight);
$rtn = $WarehouseAPIAct->act_operateAbOrder($invoiceids[$k], $calcWeight);
if (!$rtn) {
BaseModel::rollback();
self::$errCode = '011';
self::$errMsg = "调用仓库系统拆分功能失败!";
return false;
}
} else {
$returnStatus0 = array('orderStatus' => $insert_orderData['orderStatus'], 'orderType' => $insert_orderData['orderType']);
}
if (!OrderindexModel::updateOrder($tableName, $returnStatus0, $where)) {
BaseModel::rollback();
self::$errCode = '002';
self::$errMsg = "订单移动到缺货异常失败!";
return false;
}
BaseModel::commit();
BaseModel::autoCommit();
}
self::$errCode = 200;
self::$errMsg = '缺货拆分完成！';
return true;
}
public static function resendOrder($orderid, $note, $type, $old_ostatus, $old_otype)
{
!self::$dbConn ? self::initDB() : NULL;
BaseModel::begin();
//开始事务
//$tableName = 'om_unshipped_order';
//echo $old_ostatus; echo "<br>";
//echo $old_otype; echo "<br>";
$StatusMenuAct = new StatusMenuAct();
$tableName = $StatusMenuAct->act_getOrderNameByStatus($old_ostatus, $old_otype);
//echo $tableName;
if ($type == 1) {
$updatesql = 'update ' . $tableName . ' set isBuji=1,isCopy=1 where id=' . $orderid . ' and is_delete = 0 and storeId = 1';
} else {
$updatesql = 'update ' . $tableName . ' set isCopy=1 where id=' . $orderid . ' and is_delete = 0 and storeId = 1';
}
if (!self::$dbConn->query($updatesql)) {
//更新状态失败
BaseModel::rollback();
self::$dbConn->query('SET AUTOCOMMIT=1');
self::$errCode = '003';
self::$errMsg = '订单信息不存在，无法复制!';
return FALSE;
}
//产生新订单
$where = ' WHERE id = ' . $orderid . ' and is_delete = 0 and storeId = 1';
$orderData = OrderindexModel::showOrderList($tableName, $where);
$orderDetail = $orderData[$orderid]['orderDetail'];
if (!$orderDetail) {
//更新状态失败
BaseModel::rollback();
self::$dbConn->query('SET AUTOCOMMIT=1');
return FALSE;
}
$insert_orderDetail = array();
foreach ($orderDetail as $detail) {
$insert_orderDetailData = $detail['orderDetailData'];
unset($insert_orderDetailData['id']);
$insert_orderDetailExtenData = $detail['orderDetailExtenData'];
unset($insert_orderDetailExtenData['omOrderdetailId']);
$insert_orderDetail[] = array('orderDetailData' => $insert_orderDetailData, 'orderDetailExtenData' => $insert_orderDetailExtenData);
}
$obj_order_data = $orderData[$orderid]['orderData'];
if ($obj_order_data['isBuji'] == 2) {
self::$errCode = '003';
self::$errMsg = "补寄产生订单不能补寄!";
BaseModel::rollback();
self::$dbConn->query('SET AUTOCOMMIT=1');
return FALSE;
}
if ($obj_order_data['isCopy'] == 2) {
self::$errCode = '003';
self::$errMsg = "复制产生订单不能复制!";
BaseModel::rollback();
self::$dbConn->query('SET AUTOCOMMIT=1');
return FALSE;
}
unset($obj_order_data['id']);
$orderExtenData = $orderData[$orderid]['orderExtenData'];
unset($orderExtenData['omOrderId']);
$orderUserInfoData = $orderData[$orderid]['orderUserInfoData'];
unset($orderExtenData['omOrderId']);
if ($type == 1) {
$obj_order_data['isCopy'] = 2;
$obj_order_data['actualTotal'] = 0.0;
} else {
$obj_order_data['isCopy'] = 2;
$obj_order_data['isBuji'] = 2;
$obj_order_data['actualTotal'] = 0.0;
$obj_order_data['orderStatus'] = C('STATEBUJI');
$obj_order_data['orderType'] = C('STATEBUJI_DONE');
}
$orderNote = array('content ' => $note, 'userId' => $_SESSION['sysUserId'], 'createdTime' => time());
$insert_orderData = array();
$insert_orderData = array('orderData' => $obj_order_data, 'orderExtenData' => $orderExtenData, 'orderUserInfoData' => $orderUserInfoData, 'orderDetail' => $insert_orderDetail, 'orderNote' => $orderNote);
//$orderNote = $orderData['orderNote'];
//echo $insertsql;
//var_dump($insert_orderData); exit;
if ($insertId = OrderAddModel::insertAllOrderRowNoEvent($insert_orderData)) {
//echo $split_log .= 'insert success!' . "\n"; exit;
//var_dump($_mainId,$_spitId); exit;
if (!OrderLogModel::insertOrderLog($insertId, '补寄产生订单')) {
BaseModel::rollback();
self::$errCode = '001';
self::$errMsg = "补寄失败!";
return false;
}
if (!OrderRecordModel::insertSendRecords($orderid, $insertId)) {
BaseModel::rollback();
self::$errCode = '002';
self::$errMsg = "补寄失败添加记录失败!";
return false;
}
} else {
//$split_log .= '补寄新订单产生失败!' . "\n";
BaseModel::rollback();
self::$errCode = '003';
self::$errMsg = "补寄新订单产生失败";
return false;
}
BaseModel::commit();
self::$errCode = '200';
self::$errMsg = "补寄新订单成功！";
return TRUE;
}
