function func_manually_split_orders($ebay_id, $other = array())
{
/**
* @author Herman.Xi (席慧超)
* @version 1.0
* add by Herman.Xi @ 20130224
* 手动拆分订单函数
*/
global $dbcon, $user;
$split_log = "\r\n\r\n";
$isend = false;
if ($isend) {
continue;
}
//如果是里面有拦截的不能自动拦截
$sql = "select a.* from ebay_order as a where ebay_id = '{$ebay_id}' and ebay_combine != '1' and ebay_user = '******' ";
$result = $dbcon->execute($sql);
$corder = $dbcon->fetch_one($result);
if (empty($corder)) {
echo "目前系统无法找到订单 {$ebay_id} !";
}
$ebay_ordersn = $corder['ebay_ordersn'];
$ebay_paystatus = $corder['ebay_paystatus'];
$recordnumber = $corder['recordnumber'];
$ebay_tid = $corder['ebay_tid'];
$ebay_ptid = $corder['ebay_ptid'];
$ebay_total0 = $corder['ebay_total'];
$ebay_orderid = $corder['ebay_orderid'];
$ebay_createdtime = $corder['ebay_createdtime'];
$ebay_paidtime = $corder['ebay_paidtime'];
//$ebay_user = $corder['ebay_user'];
$ebay_userid = mysql_real_escape_string($corder['ebay_userid']);
$ebay_username = addslashes($corder['ebay_username']);
$ebay_usermail = addslashes($corder['ebay_usermail']);
$ebay_street = addslashes($corder['ebay_street']);
$ebay_street1 = addslashes($corder['ebay_street1']);
$ebay_city = addslashes($corder['ebay_city']);
$ebay_state = addslashes($corder['ebay_state']);
$ebay_countryname = addslashes($corder['ebay_countryname']);
$ebay_postcode = addslashes($corder['ebay_postcode']);
$ebay_phone = $corder['ebay_phone'];
$ebay_status = 655;
$ebay_addtime = time();
$ebay_shipfee = $corder['ebay_shipfee'];
$ebay_tracknumber = $corder['ebay_tracknumber'];
$ebay_account = $corder['ebay_account'];
$ebay_note = mysql_real_escape_string($corder['ebay_note']);
$ebay_carrier = $corder['ebay_carrier'];
$ebay_warehouse = $corder['ebay_warehouse'];
$ebay_currency = $corder['ebay_currency'];
$ebay_phone1 = $corder['ebay_phone1'];
$is_main_order = $corder['is_main_order'];
$combine_package = $corder['combine_package'];
$packingtype = $corder['packingtype'];
$scantime = $corder['scantime'];
$ebay_couny = $corder['ebay_couny'];
$ebayorder_site = $corder['ebay_site'];
$eBayPaymentStatus = $corder['eBayPaymentStatus'];
$orderweight = $corder['orderweight'];
if ($ebay_account == 'dresslink.com') {
//支持dresslink.com
$ebay_noteb = $corder['ebay_noteb'] . ' 拆分 订单';
} else {
$ebay_noteb = '拆分 订单';
}
if (in_array($ebay_carrier, array('UPS', 'DHL', 'TNT', 'EMS', 'FedEx'))) {
echo "订单 {$ebay_id} 运输方式为快递,请确认该订单是否需要拆分!<br>";
continue;
}
$order_statistics->deleteAll($ebay_ordersn);
//删除statistics表中的记录
if (empty($ebay_carrier)) {
$fees = calcshippingfee($orderweight, $ebay_countryname, $ebay_id, $ebay_account, $corder['ebay_total']);
$ebay_carrier = $fees[0];
}
$dbcon->free_result($result);
$sql = "SELECT * FROM ebay_orderdetail as eo WHERE eo.ebay_ordersn = '{$ebay_ordersn}'";
$result = $dbcon->execute($sql);
$eo = $dbcon->getResultArray($result);
$dbcon->free_result($result);
$weightlists = array();
$skuinfo = array();
$goods_sn_nums = 0;
$shippfee_arr = array();
foreach ($eo as $k => $f) {
$sku = $f['sku'];
$ebay_amount = $f['ebay_amount'];
$goods_sn_nums += $ebay_amount;
if (strpos($sku, "#")) {
$sku = str_replace("#", "", $sku);
}
$shippfee_arr[$sku] = round($f['shipingfee'] / $ebay_amount, 3);
$sql = "select * from ebay_goods where goods_sn='{$sku}' and ebay_user ='******' ";
$result = $dbcon->execute($sql);
$eg = $dbcon->fetch_one($result);
$dbcon->free_result($result);
$ebay_packingmaterial = $eg['ebay_packingmaterial'];
$goods_weight = $eg['goods_weight'];
$capacity = $eg['capacity'];
$sql = "select * from ebay_packingmaterial where model='{$ebay_packingmaterial}' and ebay_user ='******' ";
$result = $dbcon->execute($sql);
$ep = $dbcon->fetch_one($result);
$dbcon->free_result($result);
$pweight = isset($ep['weight']) ? $ep['weight'] : 0;
$skuinfo[$sku] = $f;
for ($i = 1; $i <= $ebay_amount; $i++) {
$var = $sku;
if ($ebay_amount <= $capacity) {
$ppweight = $pweight / $ebay_amount;
} else {
$ppweight = (1 + ($ebay_amount - $capacity) / $capacity * 0.6) * $pweight / $ebay_amount;
}
$weightlists[$var][] = $goods_weight + $ppweight;
}
}
//echo $goods_sn_nums; echo "<br>";
if ($goods_sn_nums <= 1) {
continue;
}
$sql = "update ebay_order set ebay_combine = '1' where ebay_id = '{$ebay_id}' ";
$split_log .= "更新被拆分的订单信息,设置为隐藏\r\n" . $sql . "\r\n";
$dbcon->execute($sql) or die("Fail : {$sql}");
//echo "<pre>"; print_r($skuinfo); echo "\r\n";
//echo "<pre>"; print_r($weightlists); echo "\r\n";
$keyarray = array();
$keyarrays = array();
$checkweight = 0;
$arrinfo = get_order_productsweight($ebay_ordersn);
$realweight = $arrinfo[0];
$realcosts = $arrinfo[1];
$itemprices = $arrinfo[2];
/*foreach($weightlists AS $wk => $wv){
foreach($wv as $weightlist){
$checkweight += $weightlist;
}
}
echo $checkweight; echo "<br>"; exit;*/
foreach ($weightlists as $wk => $wv) {
foreach ($wv as $weightlist) {
$checkweight += $weightlist;
//$realweight += $weightlist;
if ($checkweight > 1.85) {
$keyarrays[] = $keyarray;
$keyarray = array();
$checkweight = $weightlist;
$keyarray[$wk][] = $wk;
} else {
$keyarray[$wk][] = $wk;
}
}
}
if (!empty($keyarray)) {
$keyarrays[] = $keyarray;
}
/*echo "<pre>"; print_r($keyarrays); echo "\r\n";
exit;*/
foreach ($keyarrays as $keyarray) {
$ebay_total = 0;
$totalweight = 0;
$insert_ebay_ids = array();
foreach ($keyarray as $k => $kav) {
$ebay_total += $skuinfo[$k]['ebay_itemprice'] * count($kav);
}
//echo $ebay_total; echo "\r\n";
$shipfee = 0;
$val = generateOrdersn();
$sql = "insert into ebay_order(ebay_ordersn,ebay_paystatus,recordnumber,ebay_tid,ebay_ptid,ebay_orderid,ebay_createdtime,ebay_paidtime,ebay_userid,ebay_username,ebay_usermail,ebay_street,ebay_street1,ebay_city,ebay_state,ebay_couny,ebay_countryname,ebay_postcode,ebay_phone,ebay_total,ebay_status,ebay_user,ebay_addtime,ebay_shipfee,ebay_account,ebay_note,ebay_noteb,ebay_carrier,ebay_warehouse,ebay_tracknumber,ebay_site,eBayPaymentStatus,ebay_currency,ordershipfee,scantime,orderweight,ebay_phone1,packingtype,is_main_order,combine_package) values('{$val}','{$ebay_paystatus}','{$recordnumber}','{$ebay_tid}','{$ebay_ptid}','{$ebay_orderid}','{$ebay_createdtime}','{$ebay_paidtime}','{$ebay_userid}','{$ebay_username}','{$ebay_usermail}','{$ebay_street}','{$ebay_street1}','{$ebay_city}','{$ebay_state}','{$ebay_couny}','{$ebay_countryname}','{$ebay_postcode}','{$ebay_phone}','{$ebay_total}','{$ebay_status}','{$user}','{$mctime}','{$ebay_shipfee}','{$ebay_account}','{$ebay_note}','{$ebay_noteb}','{$ebay_carrier}','{$ebay_warehouse}','{$ebay_tracknumber}','{$ebayorder_site}','{$eBayPaymentStatus}','{$ebay_currency}','{$shipfee}','{$scantime}','{$totalweight}','{$ebay_phone1}','{$packingtype}','{$is_main_order}','{$combine_package}')";
//$split_log .= "添加拆分订单信息到订单列表中\r\n".$sql ."\r\n";
if ($dbcon->execute($sql)) {
$insert_ebay_id = $dbcon->insert_id();
$insert_ebay_ids[] = $insert_ebay_id;
mark_shipping($insert_ebay_id, $ebay_status);
$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}");
foreach ($keyarray as $k => $kav) {
$ebay_itemid = $skuinfo[$k]['ebay_itemid'];
$ebay_itemtitle = mysql_real_escape_string($skuinfo[$k]['ebay_itemtitle']);
$ebay_shiptype = $skuinfo[$k]['ebay_shiptype'];
$shipingfee = $skuinfo[$k]['shipingfee'];
$ebay_itemurl = $skuinfo[$k]['ebay_itemurl'];
$ebay_site = $skuinfo[$k]['ebay_site'];
$storeid = $skuinfo[$k]['storeid'];
$ListingType = $skuinfo[$k]['ListingType'];
$ebaydetail_tid = $skuinfo[$k]['ebay_tid'];
$FeeOrCreditAmount = $skuinfo[$k]['FeeOrCreditAmount'];
$FinalValueFee = $skuinfo[$k]['FinalValueFee'];
$attribute = $skuinfo[$k]['attribute'];
$notes = $skuinfo[$k]['notes'];
$sku = $k;
$ebay_amount = count($kav);
if ($ebay_account == 'dresslink.com') {
//支持dresslink.com
if (isset($shippfee_arr[$sku])) {
$shipingfee = $shippfee_arr[$sku] * $ebay_amount;
//相同料号运费拆分
}
}
$ebay_itemprice = $skuinfo[$k]['ebay_itemprice'];
$goods_location = $skuinfo[$k]['goods_location'];
$sql = "INSERT INTO `ebay_orderdetail` (`ebay_ordersn` ,`ebay_itemid` ,`ebay_itemtitle` ,`ebay_itemprice` ,";
$sql .= "`ebay_amount` ,`ebay_createdtime` ,`ebay_shiptype` ,`ebay_user`,`sku`,`shipingfee`,`ebay_account`,`addtime`,`ebay_itemurl`,`ebay_site`,`recordnumber`,`storeid`,`ListingType`,`ebay_tid`,`FeeOrCreditAmount`,`FinalValueFee`,`attribute`,`notes`,`goods_location`)VALUES ('{$val}', '{$ebay_itemid}' , '{$ebay_itemtitle}' , '{$ebay_itemprice}' , '{$ebay_amount}'";
$sql .= " , '{$mctime}' , '{$ebay_shiptype}' , '{$user}','{$sku}','{$shipingfee}','{$ebay_account}','{$mctime}','{$ebay_itemurl}','{$ebay_site}','{$recordnumber}','{$storeid}','{$ListingType}','{$ebaydetail_tid}','{$FeeOrCreditAmount}','{$FinalValueFee}','{$attribute}','{$notes}','{$goods_location}')";
//$split_log .= "添加对应的产品orderdetail信息\r\n".$sql ."\r\n";
$dbcon->execute($sql) or die("Fail : {$sql}");
}
$totalweight = recalcorderweight($val, $ebay_packingmaterial);
if ($ebay_account == 'dresslink.com') {
$ordershipfee = calctrueshippingfee($ebay_carrier, $totalweight, $ebay_countryname, $insert_ebay_id);
$arrinfo2 = get_order_productsweight($val);
$splitweight = $arrinfo2[0];
$splitcosts = $arrinfo2[1];
$splititemprices = $arrinfo2[2];
$ebay_total2 = round($splititemprices / $itemprices * $ebay_total0, 2);
//成本价比例拆分
$ebay_shipfee2 = round($splitweight / $realweight * $ebay_shipfee, 3);
//运费按重量拆分
//echo $val."--------".$splititemprices."------------".$itemprices."<br>";
$sql = "update ebay_order set ebay_total = '{$ebay_total2}', ebay_shipfee = '{$ebay_shipfee2}', ordershipfee='{$ordershipfee}', orderweight ='{$totalweight}' ,packingtype ='{$ebay_packingmaterial}' where ebay_id ='{$insert_ebay_id}' ";
//echo $sql."<br>";
} else {
$ordershipfee = calctrueshippingfee2($ebay_carrier, $totalweight, $ebay_countryname, $insert_ebay_id);
$sql = "update ebay_order set ordershipfee='{$ordershipfee}', orderweight ='{$totalweight}' ,packingtype ='{$ebay_packingmaterial}' where ebay_id ='{$insert_ebay_id}' ";
//$split_log .= "超重订单 $ebay_id 拆分出新订单 $insert_ebay_id \r\n";
}
$dbcon->execute($sql) or die("Fail : {$sql}");
$order_statistics->replaceData($val, array('mask' => 1), array('mask' => 1));
//添加statistics记录
$split_log .= "[" . date("Y-m-d H:i:s") . "]\t原订单---{$ebay_id}--被{$truename}--拆分出新订单( " . join(',', $insert_ebay_ids) . " )\r\n";
} else {
echo "超重订单 {$recordnumber} 拆分失败!<br>";
break;
}
}
//echo $split_log;
write_log('split_order_' . date("Ymd") . '/' . date("H") . '.txt', $split_log);
}
function auto_contrast_intercept($ebay_orders)
{
//订单自动拦截完整版 支持虚拟料号
//add Herman.Xi 2012-12-20
/*
* 订单进入系统首先判断 是否为超大订单，如果为超大订单，文件夹为640；
* B2B 抓取超大订单自动进入 超大订单待确认 modified by Herman.Xi @ 2013.05.20
* 判断订单下，料号是否全部有货，部分有货，全部没货：
如果部分有货，判断其运输方式，如果为快递，文件夹为659；非快递则为660；（订单自动部分包货）
如果全部没货，判断其运输方式，如果为快递，文件夹为658；非快递则为661；（订单自动拦截）
如果全部有货：
先判断如果为组合订单，文件夹为606；
如果超重订单，文件夹为608；
如果快递订单，文件夹为639；
全部不满足则为导入状态
自动拦截时，判断自动拦截快递，非快递，自动部分包货快递，非快递里面的订单，自动每隔十五分钟执行一次
//支持 速卖通导入，敦煌导入，ebay线下导入，dresslink导入，快递导入，出口通导入
*/
global $dbcon, $defaultstoreid, $SYSTEM_ACCOUNTS, $order_statistics, $__liquid_items_fenmocsku, $__liquid_items_SuperSpecific, $__liquid_items_postbyhkpost, $__liquid_items_cptohkpost, $__liquid_items_BuiltinBattery, $__liquid_items_Paste;
$log_data = "";
$express_delivery = array('UPS', 'DHL', 'TNT', 'EMS', 'FedEx');
$no_express_delivery = array('中国邮政平邮', '中国邮政挂号', '香港小包平邮', '香港小包挂号', 'EUB', 'Global Mail');
foreach ($ebay_orders as $ebay_order) {
//$import_status = now_order_status_log($osn, false);
$ebay_id = $ebay_order['ebay_id'];
$ebay_status = $ebay_order['ebay_status'];
//$ebay_orderid = $ebay_order['ebay_orderid'];
$ebay_note = $ebay_order['ebay_note'];
$order_sn = $ebay_order['ebay_ordersn'];
$ebay_carrier = $ebay_order['ebay_carrier'];
$ebay_countryname = $ebay_order['ebay_countryname'];
$ebay_account = $ebay_order['ebay_account'];
$ebay_username = $ebay_order['ebay_username'];
$totalweight = $ebay_order['orderweight'];
$ebay_total = $ebay_order['ebay_total'];
$recal_weight = recalcorderweight($order_sn, $ebay_packingmaterial);
//modified by Herman.Xi 2012-10-17
if (empty($totalweight)) {
//按照如果没有重量的即默认为
$totalweight = $recal_weight;
}
$sql = "SELECT sku,ebay_amount FROM ebay_orderdetail WHERE ebay_ordersn='{$order_sn}'";
$result = $dbcon->execute($sql);
$orderdetaillist = $dbcon->getResultArray($result);
$contain_special_item = false;
$shippment_cptohkpost = false;
foreach ($orderdetaillist as $orderdetail) {
$sku_arr = get_realskuinfo($orderdetail['sku']);
foreach ($sku_arr as $or_sku => $or_nums) {
if (in_array($or_sku, $__liquid_items_fenmocsku) || in_array($or_sku, $__liquid_items_SuperSpecific)) {
//粉末状，超规格产品 走福建邮局
$contain_special_item = true;
}
if (in_array($or_sku, $__liquid_items_postbyhkpost) || in_array($or_sku, $__liquid_items_cptohkpost) || in_array($or_sku, $__liquid_items_BuiltinBattery) || in_array($or_sku, $__liquid_items_Paste)) {
//包含特殊料号，中国邮政转香港小包
$shippment_cptohkpost = true;
}
}
}
if (!empty($ebay_carrier)) {
//$fees = calcshippingfee($totalweight,$ebay_countryname,$ebay_id,$ebay_account,$ebay_total);
if ($shippment_cptohkpost && strpos($ebay_carrier, '中国邮政') !== false) {
if (count($orderdetaillist) == 1) {
$ebay_carrier = '香港小包挂号';
} else {
$ebay_carrier = '';
$aliexpress_ebay_noteb = "系统提示：包含特殊料号不走中国邮政，请重新选择运输方式或者拆包！";
}
//$fee = $fees[1];
//$totalweight = $fees[2];
$bb = "update ebay_order set ebay_carrier = '{$ebay_carrier}', orderweight ='{$totalweight}', packingtype ='{$ebay_packingmaterial}', ebay_noteb = '{$aliexpress_ebay_noteb}' where ebay_id ='{$ebay_id}' ";
} else {
//$ebay_carrier = $fees[0];
//$fee = $fees[1];
//$totalweight = $fees[2];
$shipfee = calctrueshippingfee($ebay_carrier, $totalweight, $ebay_countryname, $ebay_id);
$bb = "update ebay_order set ebay_carrier = '{$ebay_carrier}', ordershipfee='{$shipfee}', orderweight ='{$totalweight}', packingtype ='{$ebay_packingmaterial}' where ebay_id ='{$ebay_id}' ";
}
$dbcon->execute($bb);
}
if ($contain_special_item) {
$sql = "update ebay_order set ebay_carrierstyle ='1' where ebay_id ={$ebay_id}";
//add by Herman.Xi 记录该订单含有特殊料号
$dbcon->execute($sql);
$log_data .= "[" . date("Y-m-d H:i:s") . "]\t包含粉末状超规格产品---{$ebay_id}---!\n\n";
}
$record_details = array();
$is_640 = false;
foreach ($orderdetaillist as $orderdetail) {
$sku_arr = get_realskuinfo($orderdetail['sku']);
$hava_goodscount = true;
foreach ($sku_arr as $or_sku => $or_nums) {
$allnums = $or_nums * $orderdetail['ebay_amount'];
if (!check_sku($or_sku, $allnums, $ebay_id)) {
//超大订单状态
if (in_array($ebay_account, $SYSTEM_ACCOUNTS['aliexpress']) || in_array($ebay_account, $SYSTEM_ACCOUNTS['B2B外单']) || in_array($ebay_account, $SYSTEM_ACCOUNTS['DHgate']) || in_array($ebay_account, $SYSTEM_ACCOUNTS['出口通']) || in_array($ebay_account, $SYSTEM_ACCOUNTS['线下结算客户'])) {
$sql = "UPDATE ebay_order SET ebay_status='698' WHERE ebay_id ='{$ebay_id}' ";
$log_data .= "[" . date("Y-m-d H:i:s") . "]\t自动跳转---{$ebay_id}---的状态为---698!\n\n";
} else {
$sql = "UPDATE ebay_order SET ebay_status='640' WHERE ebay_id ='{$ebay_id}' ";
$log_data .= "[" . date("Y-m-d H:i:s") . "]\t自动跳转---{$ebay_id}---的状态为---640!\n\n";
}
$dbcon->execute($sql) or die("Fail : {$sql}");
//$order_statistics->replaceData($order_sn, array('mask'=>1), array('mask'=>1));
insert_mark_shipping($ebay_id);
write_log('contrast_intercept_' . date("Ymd") . '/' . date("H") . '.txt', $log_data . "\n\n");
$is_640 = true;
break;
} else {
$skuinfo = get_sku_info($or_sku);
$salensend = getsaleandnosendall($or_sku, $defaultstoreid);
$sql = "UPDATE ebay_sku_statistics SET salensend = {$salensend} WHERE sku = 'or_sku' ";
$dbcon->execute($sql);
$log_data .= "[" . date("Y-m-d H:i:s") . "]\t---{$sql}\n\n";
if ($skuinfo['realnums'] - $salensend < 0) {
$hava_goodscount = false;
break;
}
}
}
if ($hava_goodscount) {
$record_details[] = $orderdetail;
}
}
if ($is_640) {
continue;
}
$count_record_details = count($record_details);
$count_orderdetaillist = count($orderdetaillist);
$final_status = $ebay_status;
if ($count_record_details == 0) {
//更新至自动拦截发货状态
if (!in_array($ebay_carrier, $no_express_delivery)) {
$final_status = 658;
} else {
$final_status = 661;
}
$sql = "UPDATE ebay_order SET ebay_status='{$final_status}' WHERE ebay_id ='{$ebay_id}' ";
$log_data .= "[" . date("Y-m-d H:i:s") . "]\t自动跳转---{$ebay_id}---的状态为---{$final_status}!\n\n";
$dbcon->execute($sql) or die("Fail : {$sql}");
//$order_statistics->replaceData($order_sn, array('mask'=>1), array('mask'=>1));
insert_mark_shipping($ebay_id);
write_log('contrast_intercept_' . date("Ymd") . '/' . date("H") . '.txt', $log_data . "\n\n");
continue;
} else {
if ($count_record_details < $count_orderdetaillist) {
//更新至自动部分发货状态
if (!in_array($ebay_carrier, $no_express_delivery)) {
//$final_status = 659;
$final_status = 640;
//modified by Herman.Xi @ 20130401
} else {
$final_status = 660;
}
$sql = "UPDATE ebay_order SET ebay_status='{$final_status}' WHERE ebay_id ='{$ebay_id}' ";
$log_data .= "[" . date("Y-m-d H:i:s") . "]\t自动跳转---{$ebay_id}---的状态为---{$final_status}!\n\n";
$dbcon->execute($sql) or die("Fail : {$sql}");
//$order_statistics->replaceData($order_sn, array('mask'=>1), array('mask'=>1));
insert_mark_shipping($ebay_id);
write_log('contrast_intercept_' . date("Ymd") . '/' . date("H") . '.txt', $log_data . "\n\n");
continue;
} else {
if ($count_record_details == $count_orderdetaillist) {
//正常发货状态
if (in_array($ebay_account, $SYSTEM_ACCOUNTS['ebay平台'])) {
if ($ebay_note != '') {
$final_status = 593;
} else {
$final_status = 1;
}
} else {
if (in_array($ebay_account, $SYSTEM_ACCOUNTS['海外销售平台'])) {
$final_status = 629;
//德国订单
$sql = "UPDATE ebay_order SET ebay_status='{$final_status}' WHERE ebay_id ='{$ebay_id}' ";
$log_data .= "[" . date("Y-m-d H:i:s") . "]\t自动跳转---{$ebay_id}---的状态为---{$final_status}!\n\n";
$dbcon->execute($sql) or die("Fail : {$sql}");
//$order_statistics->replaceData($order_sn, array('mask'=>1), array('mask'=>1));
write_log('contrast_intercept_' . date("Ymd") . '/' . date("H") . '.txt', $log_data . "\n\n");
continue;
} else {
if (in_array($ebay_account, $SYSTEM_ACCOUNTS['aliexpress']) || in_array($ebay_account, $SYSTEM_ACCOUNTS['B2B外单'])) {
if ($ebay_note != '') {
$final_status = 593;
} else {
$final_status = 595;
}
if (in_array($ebay_countryname, array('Russian Federation', 'Russia')) && strpos($ebay_carrier, '中国邮政') !== false && str_word_count($ebay_username) < 2) {
$final_status = 683;
$sql = "UPDATE ebay_order SET ebay_status='{$final_status}' WHERE ebay_id ='{$ebay_id}' ";
$log_data .= "[" . date("Y-m-d H:i:s") . "]\t自动跳转---{$ebay_id}---的状态为---{$final_status}!\n\n";
$dbcon->execute($sql) or die("Fail : {$sql}");
//$order_statistics->replaceData($order_sn, array('mask'=>1), array('mask'=>1));
write_log('contrast_intercept_' . date("Ymd") . '/' . date("H") . '.txt', $log_data . "\n\n");
continue;
}
} else {
if (in_array($ebay_account, $SYSTEM_ACCOUNTS['DHgate'])) {
$final_status = 620;
} else {
if (in_array($ebay_account, $SYSTEM_ACCOUNTS['dresslink'])) {
$final_status = 1;
} else {
if (in_array($ebay_account, $SYSTEM_ACCOUNTS['cndirect'])) {
$final_status = 1;
} else {
$final_status = 1;
}
}
}
}
}
}
if (judge_contain_combinesku($order_sn)) {
$final_status = 606;
}
if ($totalweight > 2) {
$final_status = 608;
}
if (!in_array($ebay_carrier, $no_express_delivery)) {
if (in_array($ebay_account, $SYSTEM_ACCOUNTS['ebay平台']) || in_array($ebay_account, $SYSTEM_ACCOUNTS['海外销售平台'])) {
$final_status = 641;
//ebay和海外都跳转到 待打印线下和异常订单
} else {
$final_status = 639;
}
}
$sql = "UPDATE ebay_order SET ebay_status='{$final_status}' WHERE ebay_id ='{$ebay_id}' ";
$log_data .= "[" . date("Y-m-d H:i:s") . "]\t自动跳转---{$ebay_id}---的状态为---{$final_status}!\n\n";
$dbcon->execute($sql) or die("Fail : {$sql}");
//$order_statistics->replaceData($order_sn, array('mask'=>1), array('mask'=>1));
write_log('contrast_intercept_' . date("Ymd") . '/' . date("H") . '.txt', $log_data . "\n\n");
} else {
$log_data .= "[" . date("Y-m-d H:i:s") . "]\t订单{$ebay_id同步状态有误，请联系IT解决！}";
}
}
}
}
if (!empty($log_data)) {
write_log('contrast_intercept_' . date("Ymd") . '/' . date("H") . '.txt', $log_data . "\n\n");
}
}
function calcWeight($orderid)
{
global $dbcon;
$sql = "SELECT ebay_ordersn from ebay_order where ebay_id={$orderid} ";
$sql = $dbcon->execute($sql);
$ordersn_arr = $dbcon->fetch_one($sql);
$ordersn = $ordersn_arr["ebay_ordersn"];
$totalweight = recalcorderweight($ordersn, $ebay_packingmaterial);
$sql = "update ebay_order set orderweight ='{$totalweight}' where ebay_id ={$orderid} ";
$dbcon->execute($sql);
return $totalweight;
}
