public static function auto_contrast_intercept($orderData)
{
global $SYSTEM_ACCOUNTS, $__liquid_items_fenmocsku, $__liquid_items_BuiltinBattery, $__liquid_items_SuperSpecific, $__liquid_items_Paste;
global $GLOBAL_EBAY_ACCOUNT;
global $express_delivery, $no_express_delivery;
if (!$SYSTEM_ACCOUNTS) {
$__liquid_items_array = PurchaseAPIModel::getAdjustransportFromPurchase();
//var_dump($__liquid_items_array);
//echo time(); echo "<br>";
$__liquid_items_postbyhkpost = array_filter(explode(",", $__liquid_items_array['液体产品']));
//液体产品
$__liquid_items_postbyfedex = array_filter(explode(",", $__liquid_items_array['贵重产品']));
//贵重物品走联邦
$__liquid_items_cptohkpost = array_filter(explode(",", $__liquid_items_array['指甲油产品']));
//指甲油转香港小包
$__liquid_items_elecsku = array_filter(explode(",", $__liquid_items_array['电子类产品']));
//电子类产品走香港小包
//$__elecsku_countrycn_array = array_filter(explode(",", $__liquid_items_array['']));//电子类产品指定国家
$__liquid_items_fenmocsku = array_filter(explode(",", $__liquid_items_array['粉末状产品']));
//粉末状SKU
$__liquid_items_BuiltinBattery = array_filter(explode(",", $__liquid_items_array['内置电池产品']));
//内置电池类产品
$__liquid_items_SuperSpecific = array('6471', '14995');
//超规格的产品，长度大于60cm, 三边大于 90cm
$__liquid_items_Paste = array_filter(explode(",", $__liquid_items_array['膏状产品']));
//膏状SKU*/
$__liquid_items_elecWithoutBattery = array_filter(explode(",", $__liquid_items_array['电子类【不带电池】']));
//电子类【不带电池】*/
$__liquid_items_OutWeight = array_filter(explode(",", $__liquid_items_array['超重产品>=1.9kg']));
//超重产品>=1.9kg*/
//取统一包装材料重量数据
//$MaterInfo = CommonModel::getMaterInfo();
//取统一国家中文名对应英文名
/*$ec = "select * from ebay_countrys where ebay_user='******' ";
$result = $dbConn->execute($ec);
$ebay_country_lists = $dbConn->getResultArray($result);
$global_countrycn_coutryen = array();
foreach($ebay_country_lists AS $ebay_country_list){
$global_countrycn_coutryen[trim($ebay_country_list['countryen'])] = trim($ebay_country_list['countrycn']);
}*/
//取各个平台的账号名称
$SYSTEM_ACCOUNTS = OmAvailableModel::getPlatformAccount();
//echo "<pre>";print_r($SYSTEM_ACCOUNTS);
$express_delivery = array();
$express_delivery_value = array();
$no_express_delivery = array();
$no_express_delivery_value = array();
$express_delivery_value = CommonModel::getCarrierListById(1);
/*foreach($express_delivery_arr as $value){
$express_delivery_value[$value['id']] = $value['carrierNameCn'];
}*/
$express_delivery = array_keys($express_delivery_value);
//var_dump($express_delivery);
$no_express_delivery_value = CommonModel::getCarrierListById(0);
/*foreach($no_express_delivery_arr as $value){
$no_express_delivery_value[$value['id']] = $value['carrierNameCn'];
}*/
$no_express_delivery = array_keys($no_express_delivery_value);
}
if (!$GLOBAL_EBAY_ACCOUNT) {
$GLOBAL_EBAY_ACCOUNT = array();
foreach ($SYSTEM_ACCOUNTS as $acct) {
foreach ($acct as $key => $value) {
$GLOBAL_EBAY_ACCOUNT[$key] = $value;
}
}
}
//var_dump($GLOBAL_EBAY_ACCOUNT);exit;
self::initDB();
//var_dump($orderData); echo "\n";
$log_data = "";
$actualTotal0 = 0;
//该订单实际总数
//$ebay_id = $orderData['orderData']['id'];
$orderStatus = empty($orderData['orderData']['orderStatus']) ? C('STATEPENDING') : $orderData['orderData']['orderStatus'];
$orderType = empty($orderData['orderData']['orderType']) ? C('STATEPENDING_CONV') : $orderData['orderData']['orderType'];
$returnStatus = array('orderStatus' => $orderStatus, 'orderType' => $orderType);
$isNote = $orderData['orderData']['isNote'];
if ($isNote) {
$orderType = C('STATEPENDING_MSG');
}
$calcWeight = $orderData['orderData']['calcWeight'];
$pmId = $orderData['orderData']['pmId'];
//var_dump($calcWeight); echo "\n";
$orderdetaillist = $orderData['orderDetail'];
if (empty($calcWeight)) {
$calcInfo = CommonModel::calcAddOrderWeight($orderdetaillist);
//计算重量和包材
$calcWeight = $calcInfo[0];
$pmId = $calcInfo[1];
$orderData['orderData']['calcWeight'] = $calcWeight;
$orderData['orderData']['pmId'] = $pmId;
}
//var_dump($calcWeight); echo "\n";
$transportId = @$orderData['orderData']['transportId'];
$countryName = $orderData['orderUserInfoData']['countryName'];
$accountId = $orderData['orderData']['accountId'];
$actualTotal = $orderData['orderData']['actualTotal'];
$ebay_username = $orderData['orderUserInfoData']['username'];
$orderDataid = $orderData['orderExtenData']['orderId'];
$ebay_usermail = $orderData['orderUserInfoData']['email'];
$PayPalEmailAddress = @$orderData['orderExtenData']['PayPalEmailAddress'];
//echo "------$countryName-----\n";
//echo "订单计算重量:$calcWeight\t\n";
$contain_special_item = false;
$contain_os_item = false;
$ow_status = array();
//foreach ($orderdetaillist AS $orderdetail){
for ($i = 0; $i < count($orderdetaillist); $i++) {
$sku = $orderdetaillist[$i]['orderDetailData']['sku'];
$itemPrice = $orderdetaillist[$i]['orderDetailData']['itemPrice'];
$amount = $orderdetaillist[$i]['orderDetailData']['amount'];
$shippingFee = $orderdetaillist[$i]['orderDetailData']['shippingFee'];
//var_dump($sku);
$sku_arr = GoodsModel::get_realskuinfo($sku);
//var_dump($sku_arr); exit;
$actualTotal0 += $itemPrice * $amount + $shippingFee;
foreach ($sku_arr as $or_sku => $or_nums) {
if (in_array($or_sku, $__liquid_items_fenmocsku) || in_array($or_sku, $__liquid_items_SuperSpecific) || in_array($or_sku, $__liquid_items_BuiltinBattery)) {
//粉末状,超规格产品 走福建邮局
$contain_special_item = true;
}
if (preg_match("/^US01\\+.*/", $or_sku, $matchArr) || preg_match("/^US1\\+.*/", $or_sku, $matchArr)) {
//$log_data .= "[".date("Y-m-d H:i:s")."]\t包含海外仓料号订单---{$ebay_id}-----料号：{$or_sku}--!\n\n";
$contain_os_item = true;
if (strpos($or_sku, "US01+") !== false) {
$matchStr = substr($matchArr[0], 5);
//去除前面
//$matchStr = str_replace("US1+", "", $or_sku);
} else {
//$matchStr=substr($matchArr[0],5);//去除前面
$matchStr = str_replace("US1+", "", $or_sku);
}
$n = strpos($matchStr, ':');
//寻找位置
if ($n) {
$matchStr = substr($matchStr, 0, $n);
}
//删除后面
if (preg_match("/^0+(\\w+)/", $matchStr, $matchArr)) {
$matchStr = $matchArr[1];
}
$orderData['orderDetail'][$i]['orderDetailData']['sku'] = $matchStr;
//OrderAddModel::updateDetailExtension(array('sku'=>$matchStr), " id = {$orderdetail['ebay_id']} ");
//$virtualnum = check_oversea_stock($matchStr); //检查海外仓虚拟库存
$virtualnum = 1;
//预留获取海外仓虚拟库存接口 20131225
if ($virtualnum >= 0) {
$ow_status[] = C('STATEPENDING_OVERSEA');
//海外仓待处理
} else {
$ow_status[] = C('STATEOUTOFSTOCK_OVERSEA');
//海外仓缺货
}
}
}
}
if ($contain_special_item) {
/*$sql = "update ebay_order set ebay_carrierstyle ='1' where ebay_id ={$ebay_id}"; //add by Herman.Xi 记录该订单含有特殊料号
$dbConnn->query($sql);
$log_data .= "[".date("Y-m-d H:i:s")."]\t包含粉末状超规格产品---{$ebay_id}---!\n\n";*/
}
if ($contain_os_item) {
if (in_array(C('STATEOUTOFSTOCK_OVERSEA'), $ow_status)) {
$orderData['orderData']['orderStatus'] = C('STATEPENDING_OS');
$orderData['orderData']['orderType'] = C('STATEOUTOFSTOCK_OVERSEA');
} else {
$orderData['orderData']['orderStatus'] = C('STATEPENDING_OS');
$orderData['orderData']['orderType'] = C('STATEPENDING_OVERSEA');
}
//$log_data .= "[".date("Y-m-d H:i:s")."]\t更新海外仓料号订单状态为{$final_status}---{$ebay_id}--{$sql}-!\n\n";
/*if($final_status == C('STATEPENDING_OVERSEA')){
$calcWeight = calcWeight($ebay_id);
$skunums = checkSkuNum($ebay_id);
if($skunums === true){
continue;
}else if ($calcWeight>20) {
if($skunums==1){
usCalcShipCost($ebay_id);
}
} else {
usCalcShipCost($ebay_id);
}
}*/
//$calcWeight = recalcorderweight($order_sn, $ebay_packingmaterial); //modified by Herman.Xi 2012-10-17
$log_data .= "[" . date("Y-m-d H:i:s") . "]\t包含海外仓料号---自动跳转---的状态为---{$final_status}!\n\n";
CommonModel::write_scripts_log('auto_contrast_intercept', $GLOBAL_EBAY_ACCOUNT[$accountId], $log_data);
return $orderData;
//continue;
}
$interceptrtn = self::intercept_exception_orders($orderData);
//var_dump($interceptrtn);
if ($interceptrtn) {
$orderData['orderData']['orderStatus'] = $interceptrtn['orderStatus'];
$orderData['orderData']['orderType'] = $interceptrtn['orderType'];
$log_data .= "[" . date("Y-m-d H:i:s") . "]\t自动跳转的状态为--" . $orderStatus . "--" . $orderType . "!\n\n";
CommonModel::write_scripts_log('auto_contrast_intercept', $GLOBAL_EBAY_ACCOUNT[$accountId], $log_data);
return $orderData;
}
$record_details = array();
$is_640 = false;
//var_dump($orderdetaillist); exit;
foreach ($orderdetaillist as $orderdetail) {
//var_dump($orderdetail['sku']);
$sku = $orderdetail['orderDetailData']['sku'];
//$itemPrice = $orderdetail['orderDetailData']['itemPrice'];
$amount = $orderdetail['orderDetailData']['amount'];
//$shippingFee = $orderdetail['orderDetailData']['shippingFee'];
$sku_arr = GoodsModel::get_realskuinfo($sku);
//var_dump($sku_arr); exit;
$hava_goodscount = true;
foreach ($sku_arr as $or_sku => $or_nums) {
$allnums = $or_nums * $amount;
if (!CommonModel::check_sku($or_sku, $allnums)) {
//超大订单状态
$orderStatus = C('STATEOVERSIZEDORDERS');
if (in_array($GLOBAL_EBAY_ACCOUNT[$accountId], $SYSTEM_ACCOUNTS['aliexpress']) || in_array($GLOBAL_EBAY_ACCOUNT[$accountId], $SYSTEM_ACCOUNTS['DHgate']) || in_array($GLOBAL_EBAY_ACCOUNT[$accountId], $SYSTEM_ACCOUNTS['出口通']) || in_array($GLOBAL_EBAY_ACCOUNT[$accountId], $SYSTEM_ACCOUNTS['线下结算客户'])) {
$orderType = C('STATEOVERSIZEDORDERS_CONFIRM');
} else {
$orderType = C('STATEOVERSIZEDORDERS_PEND');
}
//self::insert_mark_shipping($ebay_id);
$is_640 = true;
break;
} else {
$skuinfo = CommonModel::get_sku_info($or_sku);
$salensend = CommonModel::getpartsaleandnosendall($or_sku);
//$log_data .= "[".date("Y-m-d H:i:s")."]\t---{$sql}\n\n";
$log_data .= "订单==={$ebay_id}===料号=={$or_sku}===实际库存为{$skuinfo['realnums']}===需求量为{$allnums}===待发货数量为{$salensend}===\n";
if (!isset($skuinfo['realnums']) || empty($skuinfo['realnums']) || $skuinfo['realnums'] - $salensend - $allnums < 0) {
$hava_goodscount = false;
break;
}
}
}
if ($hava_goodscount) {
$record_details[] = $orderdetail;
}
}
if ($is_640) {
$orderData['orderData']['orderStatus'] = $orderStatus;
$orderData['orderData']['orderType'] = $orderType;
//$returnStatus = array('orderStatus'=>$orderStatus, 'orderType'=>$orderType);
$log_data .= "[" . date("Y-m-d H:i:s") . "]\t自动跳转的状态为--" . $orderStatus . "--" . $orderType . "!\n\n";
CommonModel::write_scripts_log('auto_contrast_intercept', $GLOBAL_EBAY_ACCOUNT[$accountId], $log_data);
return $orderData;
}
$count_record_details = count($record_details);
$count_orderdetaillist = count($orderdetaillist);
$final_status = $orderStatus;
//原始状态
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' and ebay_status = '{$orderStatus}' ";
$orderStatus = C('STATEOUTOFSTOCK');
$orderType = C('STATEOUTOFSTOCK_AO');
//$log_data .= "[".date("Y-m-d H:i:s")."]\t自动跳转的状态为---".C('STATEOUTOFSTOCK_AO')."!\n\n";
//self::insert_mark_shipping($ebay_id);
//self::write_scripts_log('auto_contrast_intercept', $GLOBAL_EBAY_ACCOUNT[$accountId], $log_data);
//$returnStatus = array('orderStatus'=>$orderStatus, 'orderType'=>$orderType);
$orderData['orderData']['orderStatus'] = $orderStatus;
$orderData['orderData']['orderType'] = $orderType;
$log_data .= "[" . date("Y-m-d H:i:s") . "]\t自动跳转的状态为--" . $orderStatus . "--" . $orderType . "!\n\n";
CommonModel::write_scripts_log('auto_contrast_intercept', $GLOBAL_EBAY_ACCOUNT[$accountId], $log_data);
return $orderData;
} else {
if ($count_record_details < $count_orderdetaillist) {
//更新至自动部分发货状态
/*if (!in_array($ebay_carrier, $no_express_delivery)){
//$final_status = 659;
$final_status = 640;
}else {
$final_status = 660;
}*/
$orderStatus = C('STATEOUTOFSTOCK');
$orderType = C('STATEOUTOFSTOCK_PO');
//$log_data .= "[".date("Y-m-d H:i:s")."]\t自动跳转的状态为---".C('STATEOUTOFSTOCK_PO')."!\n\n";
//self::insert_mark_shipping($ebay_id);
//$returnStatus = array('orderStatus'=>C('STATEOUTOFSTOCK'), 'orderType'=>C('STATEOUTOFSTOCK_PO'));
//self::write_scripts_log('auto_contrast_intercept', $GLOBAL_EBAY_ACCOUNT[$accountId], $log_data);
//$returnStatus = array('orderStatus'=>$orderStatus, 'orderType'=>$orderType);
$orderData['orderData']['orderStatus'] = $orderStatus;
$orderData['orderData']['orderType'] = $orderType;
$log_data .= "[" . date("Y-m-d H:i:s") . "]\t自动跳转的状态为--" . $orderStatus . "--" . $orderType . "!\n\n";
CommonModel::write_scripts_log('auto_contrast_intercept', $GLOBAL_EBAY_ACCOUNT[$accountId], $log_data);
return $orderData;
} else {
if ($count_record_details == $count_orderdetaillist) {
//正常发货状态
if (in_array($GLOBAL_EBAY_ACCOUNT[$accountId], $SYSTEM_ACCOUNTS['ebay'])) {
if (in_array($orderStatus, array(C('STATEOUTOFSTOCK_PO'), C('STATEOUTOFSTOCK_PO')))) {
//$final_status = 618;//ebay订单自动拦截有货不能移动到待处理和有留言 modified by Herman.Xi @ 20130325(移动到缺货需打印中)
$orderStatus = C('STATEPENDING');
if ($isNote == 1) {
echo "有留言\t";
$orderType = C('STATEPENDING_MSG');
} else {
$orderType = C('STATEPENDING_HASARRIVED');
}
} else {
$orderStatus = C('STATEPENDING');
if ($isNote == 1) {
echo "有留言\t";
$orderType = C('STATEPENDING_MSG');
} else {
$orderType = C('STATEPENDING_CONV');
}
}
} else {
if (in_array($GLOBAL_EBAY_ACCOUNT[$accountId], $SYSTEM_ACCOUNTS['aliexpress'])) {
if (in_array($countryName, array('Russian Federation', 'Russia')) && strpos($ebay_carrier, '中国邮政') !== false && str_word_count($ebay_username) < 2) {
$orderStatus = C('STATESYNCINTERCEPT');
$orderType = C('STATESYNCINTERCEPT_AB');
$orderData['orderData']['orderStatus'] = $orderStatus;
$orderData['orderData']['orderType'] = $orderType;
$log_data .= "[" . date("Y-m-d H:i:s") . "]\t自动跳转的状态为--" . $orderStatus . "--" . $orderType . "!\n\n";
CommonModel::write_scripts_log('auto_contrast_intercept', $GLOBAL_EBAY_ACCOUNT[$accountId], $log_data);
return $orderData;
}
} else {
if (in_array($GLOBAL_EBAY_ACCOUNT[$accountId], $SYSTEM_ACCOUNTS['DHgate'])) {
$orderStatus = C('STATEPENDING');
$orderType = C('STATEPENDING_CONV');
} else {
if (in_array($GLOBAL_EBAY_ACCOUNT[$accountId], $SYSTEM_ACCOUNTS['dresslink.com'])) {
$orderStatus = C('STATEPENDING');
$orderType = C('STATEPENDING_CONV');
} else {
if (in_array($GLOBAL_EBAY_ACCOUNT[$accountId], $SYSTEM_ACCOUNTS['cndirect.com'])) {
$orderStatus = C('STATEPENDING');
$orderType = C('STATEPENDING_CONV');
} else {
if (in_array($GLOBAL_EBAY_ACCOUNT[$accountId], $SYSTEM_ACCOUNTS['Amazon'])) {
$orderStatus = C('STATEPENDING');
$orderType = C('STATEPENDING_CONV');
} else {
$orderStatus = C('STATEPENDING');
$orderType = C('STATEPENDING_CONV');
}
}
}
}
}
}
if ($isNote == 1) {
echo "有留言\t";
$orderType = C('STATEPENDING_MSG');
}
/*if(self::judge_contain_combinesku_new($orderdetaillist)){
$final_status = 606;
}*/
if ($calcWeight > 2) {
echo "\t 超重订单";
$orderStatus = C('STATEPENDING');
$orderType = C('STATEPENDING_OW');
}
$expressArr = CommonModel::getCarrierInfoById(1);
if (in_array($transportId, $expressArr)) {
$orderType = C('STATEPENDING_HASARRIVED');
}
/*if (!in_array($ebay_carrier, $no_express_delivery) && !empty($ebay_carrier)){
if(in_array($GLOBAL_EBAY_ACCOUNT[$accountId],$SYSTEM_ACCOUNTS['ebay']) || in_array($GLOBAL_EBAY_ACCOUNT[$accountId],$SYSTEM_ACCOUNTS['海外销售平台'])){
$final_status = 641;//ebay和海外都跳转到 待打印线下和异常订单
}else{
$final_status = 639;
}
}*/
} else {
$log_data .= "[" . date("Y-m-d H:i:s") . "]\t订单同步状态有误,请联系IT解决!";
}
}
}
//$returnStatus = array('orderStatus'=>$orderStatus, 'orderType'=>$orderType);
$orderData['orderData']['orderStatus'] = $orderStatus;
$orderData['orderData']['orderType'] = $orderType;
$log_data .= "[" . date("Y-m-d H:i:s") . "]\t自动跳转的状态为--" . $orderStatus . "--" . $orderType . "!\n\n";
//print_r($GLOBAL_EBAY_ACCOUNT);
CommonModel::write_scripts_log('auto_contrast_intercept', $GLOBAL_EBAY_ACCOUNT[$accountId], $log_data);
return $orderData;
}
AND ebay_tracknumber!=''
AND ebay_carrier!=''
AND ebay_account = '".$account."'
AND ebay_site = '".$site."'";// limit 0,7";*/
/*$order_sql = " select a.omOrderId
from om_unshipped_order_warehouse as a
where (a.weighTime BETWEEN $start AND $end)
and a.storeId = 1 ";
$order_db = $dbConn->query($order_sql);
$orders = $dbConn->fetch_array_all($order_db);
//var_dump($orders); echo "\n"; exit;
$handle_cnt=count($orders);
if($handle_cnt<=0 ){
exit("No order to handel\n");
}*/
$delivery_arr = CommonModel::getCarrierListById();
$order_sql = "select a.id,a.recordNumber,a.transportId,a.combinePackage,a.orderStatus \n\t\t\t\tfrom om_shipped_order as a \n\t\t\t\tleft join om_shipped_order_warehouse as b\n\t\t\t\ton a.id = b.omOrderId\n\t\t\t\tleft join om_shipped_order_extension_amazon as c\n\t\t\t\ton a.id = c.omOrderId\n\t\t\t\twhere a.accountId = '{$accountId}'\n\t\t\t\tand\tc.site = '{$site}'\n\t\t\t\tand a.orderStatus ='" . C("STATESHIPPED") . "'\n\t\t\t\tand a.orderType ='" . C("STATEHASSHIPPED_CONV") . "'\n\t\t\t\tand (b.weighTime BETWEEN {$start} AND {$end}) and (a.ShippedTime ='' or a.ShippedTime is null) \n\t\t\t\tORDER BY b.weighTime ";
$order_db = $dbConn->query($order_sql);
$orders = $dbConn->fetch_array_all($order_db);
/*$order_sql = " select ebay_orderid,ebay_account,ebay_ordersn,ebay_countryname,
ebay_id,ebay_tracknumber,ebay_carrier,ebay_combine,recordnumber
from ebay_order where recordnumber in(
'002-8137713-8318634',
'115-9924496-2629023',
'107-8620600-1710651',
'109-4445248-2697864',
'112-8959307-6029052',
'112-8141525-2093001')
";*/
//$order_db = $dbcon->execute($order_sql);
$order_sql = "select id,recordNumber,transportId,combinePackage,orderStatus \n\t\t\t\tfrom om_shipped_order as a \n\t\t\t\tleft join om_shipped_order_warehouse as b \n\t\t\t\ton a.id = b.omOrderId\n\t\t\t\twhere a.accountId = '{$accountId}' \n\t\t\t\tand a.orderStatus ='" . C("STATESHIPPED") . "'\n\t\t\t\tand a.orderType = '" . C("STATEHASSHIPPED_CONV") . "' \n\t\t\t\tand b.weighTime > {$start} and (a.ShippedTime ='' or a.ShippedTime is null) \n\t\t\t\tORDER BY b.weighTime ";
// and ebay_status ='2'
//$testsql = " ORDER BY scantime"; $sql .= $testsql; // for test
/*$order_sql = " select a.omOrderId
from om_unshipped_order_warehouse as a
where (a.weighTime BETWEEN $start AND $end)
and a.storeId = 1 ";*/
//echo $order_sql;exit;
$order_db = $dbConn->query($order_sql);
$alldata = $dbConn->fetch_array_all($order_db);
//var_dump($alldata); echo "\n"; exit;
$sum = sizeof($alldata);
if ($sum <= 0) {
exit("No order to handel\n");
}
$transportData = CommonModel::getCarrierListById();
if ($sum > 0) {
foreach ($alldata as $val) {
$omOrderId = $val['id'];
$transportId = $val['transportId'];
$carrier = $delivery_arr[$transportId];
echo "开始上传订单【{$omOrderId}】 ----------运输方式={$carrier}------\n\n";
$recordnumber = $val['recordNumber'];
//$ebay_carrier = $val['transportId'];
/*$where = " where id = {$omOrderId} and storeId = 1 and is_delete = 0 ";
$orderList = OrderindexModel::showOrderList($tableName, $where);
$orderTracknumber = $orderList[$omOrderId]['orderTracknumber'];*/
$orderList = is_array($omOrderId) ? implode(',', $omOrderId) : $omOrderId;
$orderTracknumber = getTracknumber($orderList);
//获取订单的跟踪号
if (empty($orderTracknumber)) {
//电子类【不带电池】*/
$__liquid_items_OutWeight = array_filter(explode(",", $__liquid_items_array['超重产品>=1.9kg']));
//超重产品>=1.9kg*/
//取统一包装材料重量数据
//$MaterInfo = CommonModel::getMaterInfo();
//取统一国家中文名对应英文名
/*$ec = "select * from ebay_countrys where ebay_user='******' ";
$result = $dbConn->execute($ec);
$ebay_country_lists = $dbConn->getResultArray($result);
$global_countrycn_coutryen = array();
foreach($ebay_country_lists AS $ebay_country_list){
$global_countrycn_coutryen[trim($ebay_country_list['countryen'])] = trim($ebay_country_list['countrycn']);
}*/
//取各个平台的账号名称
$SYSTEM_ACCOUNTS = OmAvailableModel::getPlatformAccount();
//echo "<pre>";print_r($SYSTEM_ACCOUNTS);
$express_delivery = array();
$express_delivery_value = array();
$no_express_delivery = array();
$no_express_delivery_value = array();
$express_delivery_value = CommonModel::getCarrierListById(1);
/*foreach($express_delivery_arr as $value){
$express_delivery_value[$value['id']] = $value['carrierNameCn'];
}*/
$express_delivery = array_keys($express_delivery_value);
//var_dump($express_delivery);
$no_express_delivery_value = CommonModel::getCarrierListById(0);
/*foreach($no_express_delivery_arr as $value){
$no_express_delivery_value[$value['id']] = $value['carrierNameCn'];
}*/
$no_express_delivery = array_keys($no_express_delivery_value);
define("WEB_PATH", "/data/web/order.valsun.cn/");
}
//define('SCRIPTS_PATH_CRONTAB', '/data/web/erpNew/order.valsun.cn/crontab/');
require_once WEB_PATH . "crontab/scripts.comm.php";
require_once WEB_PATH_CONF_SCRIPTS . "script.ebay.config.php";
require_once WEB_PATH_LIB_SDK_DRESSLINK . "DLCommenScript.php";
//require_once "/data/web/erpNew/order.valsun.DL/lib/sdk/DL/DLCommenScript.php";
echo "调用DL订单接口,时间" . date("Y-m-d H:i:s") . "\r\n";
$orders = getDLOrders();
$orders = json_decode($orders, true);
//print_r($orders);
if (!$orders) {
echo "没有获取订单信息!\n";
exit;
}
$carrierList = CommonModel::getCarrierListById();
$flip_carrierList = array_flip($carrierList);
$orderids = $orders['OrderID'];
//print_r($orderids);
/*if(file_exists(WEB_PATH."crontab/dresslink/orderid.txt")&&!empty($orderids)){
$fp = fopen(WEB_PATH."crontab/dresslink/orderid.txt","a+");
$str = "******************".date("Y-m-d H:i:s")."*******************\r\n\r\n\r\n";
foreach($orderids as $id){
$str .= ",".$id;
}
$str .= "\r\n#############################################################";
fwrite($fp,$str);
fclose($fp);
}*/
if (empty($orderids)) {
//$orderids = array('DL100000204','DL100000398','DL100000407','DL100000411','DL100000420','DL100000422');
public function act_fetchOrder()
{
$message = "";
$accountId = isset($_POST['amazon_account']) ? $_POST['amazon_account'] : "";
$account = OmAvailableModel::getTNameList("om_account", "*", " where id={$accountId}");
$account = $account[0]['account'];
$recordNumber = isset($_POST['amazon_id']) ? $_POST['amazon_id'] : "";
$amazon_account = isset($_POST['amazon_account']) ? $_POST['amazon_account'] : "";
$site = isset($_POST['site']) ? $_POST['site'] : "";
$recordNumbers = explode(",", $recordNumber);
//print_r($recordNumbers);
//$rids = empty($_GET['rids']) ? array() : array_map('trim', explode(',', $_GET['rids']));
$rids = array_values(array_unique(array_filter(array_map('trim', $recordNumbers))));
if (!defined('WEB_PATH')) {
define("WEB_PATH", "/data/web/order.valsun.cn/");
}
//define('SCRIPTS_PATH_CRONTAB', '/data/web/erpNew/order.valsun.cn/crontab/');
require_once WEB_PATH . "crontab/scripts.comm.php";
require_once WEB_PATH_CONF_SCRIPTS . "script.ebay.config.php";
require_once WEB_PATH_LIB_SCRIPTS_AMAZON . "amazon_order_func.php";
if (strtoupper($site) == "US") {
$keyname = WEB_PATH_CONF_SCRIPTS_KEYS_AMAZON . "amazon_keys_{$account}.php";
} elseif (strtoupper($site) == "UK" || strtoupper($site) == "DE") {
$ext = strtolower($site);
$keyname = WEB_PATH_CONF_SCRIPTS_KEYS_AMAZON . "amazon_keys_{$ext}_{$account}.php";
}
//echo $keyname;
if (file_exists($keyname)) {
include_once $keyname;
} else {
//exit ("未找对应的key文件!\n");
$message .= "<font color='red'>未找对应的key文件</font>";
}
define('APPLICATION_NAME', $APPLICATION_NAME);
define('APPLICATION_VERSION', $APPLICATION_VERSION);
define('AWS_ACCESS_KEY_ID', $AWS_ACCESS_KEY_ID);
define('AWS_SECRET_ACCESS_KEY', $AWS_SECRET_ACCESS_KEY);
define('MERCHANT_ID', $MERCHANT_ID);
define('MARKETPLACE_ID', $MARKETPLACE_ID);
//echo "\n".get_include_path()."\n";
set_include_path(get_include_path() . PATH_SEPARATOR . WEB_PATH_LIB_SDK_AMAZON);
//
//echo "\n".get_include_path()."\n";
//
/*function __autoload($className){
$filePath = str_replace('_', DIRECTORY_SEPARATOR, $className) . '.php';
$includePaths = explode('/', get_include_path());
foreach($includePaths as $includePath){
if(file_exists($includePath . DIRECTORY_SEPARATOR . $filePath)){
require_once $filePath;
return;
}
}
}*/
require_once WEB_PATH_LIB_SDK . 'amazon/MarketplaceWebServiceOrders/Client.php';
require_once WEB_PATH_LIB_SDK . 'amazon/MarketplaceWebServiceOrders/Interface.php';
require_once WEB_PATH_LIB_SDK . 'amazon/MarketplaceWebServiceOrders/Exception.php';
require_once WEB_PATH_LIB_SDK . 'amazon/MarketplaceWebServiceOrders/Model/GetOrderRequest.php';
require_once WEB_PATH_LIB_SDK . 'amazon/MarketplaceWebServiceOrders/Model/OrderIdList.php';
require_once WEB_PATH_LIB_SDK . 'amazon/MarketplaceWebServiceOrders/Model/ListOrdersRequest.php';
require_once WEB_PATH_LIB_SDK . 'amazon/MarketplaceWebServiceOrders/Model/MarketplaceIdList.php';
require_once WEB_PATH_LIB_SDK . 'amazon/MarketplaceWebServiceOrders/Model/ListOrderItemsRequest.php';
$config = array('ServiceURL' => $serviceUrl, 'ProxyHost' => null, 'ProxyPort' => -1, 'MaxErrorRetry' => 3);
$minute = 100;
$start = date("Y-m-d H:i:s", time() - $minute * 60);
//$order_statistics = new OrderStatistics();
$service = new MarketplaceWebServiceOrders_Client(AWS_ACCESS_KEY_ID, AWS_SECRET_ACCESS_KEY, APPLICATION_NAME, APPLICATION_VERSION, $config);
$request = new MarketplaceWebServiceOrders_Model_GetOrderRequest();
$request->setSellerId(MERCHANT_ID);
//$request->setCreatedAfter(new DateTime($start, new DateTimeZone('UTC')));
//$request->setCreatedBefore(new DateTime('2012-08-03 12:00:00', new DateTimeZone('UTC')));
//$request->setMarketplaceId($marketplaceIdList);
//由account得出其accountId
/*$tName = 'om_account';
$select = 'id';
$where = "WHERE account='$account' AND platformId=11"; //亚马孙平台id为11
$accountIdList = OmAvailableModel :: getTNameList($tName, $select, $where);
if (empty ($accountIdList)) {
exit ("$account is not in om_account!\n");
}
$accountId = $accountIdList[0]['id'];*/
$transportList = CommonModel::getCarrierListById();
$flip_transportList = array_flip($transportList);
//var_dump($flip_transportList); exit;
$orderIds = new MarketplaceWebServiceOrders_Model_OrderIdList();
//echo "<pre>"; print_r($rids);
$orderIds->setId($rids);
$request->setAmazonOrderId($orderIds);
$info = self::act_invokeListOrders($service, $request, $account, $site, $accountId, $flip_transportList, $message);
return $info;
}
}
} else {
echo "notice: no data, exit\n";
exit;
}
//$TaobaoAct = new TaobaoAct();
//查询快递信息
/*$checkcarrier = array();
$carrierlists = CommonModel::getCarrierList();
//var_dump($carrierlists); exit;
if($carrierlists){
foreach($carrierlists AS $carrierlist){
$checkcarrier[] = "{$carrierlist['carrierNameCn']}";
}
}*/
$checkcarrier = CommonModel::getCarrierListById();
$flip_checkcarrier = array_flip($checkcarrier);
//var_dump($flip_checkcarrier); exit;
$total = 0;
//总订单条数
$error_data = array();
for ($cur_page = 1; $cur_page <= 1; $cur_page++) {
if ($cur_page > 1) {
$json_data = taobaoTradesSoldGet($url, $session, $appSecret, $appKey, $status, $cur_page, $page_size);
}
//出错处理
if (isset($json_data['error_response'])) {
echo "error: " . $json_data['error_response']['msg'] . " error code:" . $json_data['error_response']['code'] . "\n";
} else {
//数据入库
$data = $json_data['trades_sold_get_response']['trades']['trade'];
