public static function get_waiting_sale($sku)
{
//获取海外仓待发货数据 Herman.Xi
$totalnums = 0;
$combineskus = GoodsModel::getCombineBySku($sku);
$skus = array($sku => 1) + $combineskus;
/*$combineskus = get_combinesku($sku);
$skus = empty($combineskus) ? array() : array_keys($combineskus);
array_push($skus, $sku);*/
$StatusMenuAct = new StatusMenuAct();
$menuList = $StatusMenuAct->act_getStatusMenuList("*", " where dStatus = 1 and groupId = 0 and is_delete=0 and storeId= {$storeId} ");
//var_dump($menuList); exit;
$dStatusCodes = array();
foreach ($menuList as $value) {
$dStatusCodes[] = $value['statusCode'];
}
//var_dump($dStatusCodes);
foreach ($skus as $_sku => $_num) {
$ordersql = "SELECT \t\ta.id,b.sku,b.amount\n\t\t\t\t\t\tFROM \t\t\tom_unshipped_order AS a \n\t\t\t\t\t\tLEFT JOIN om_unshipped_order_detail AS b \n\t\t\t\t\t\tON \t\t\t\tb.omOrderId = a.id \n\t\t\t\t\t\tWHERE \t\t\ta.orderStatus NOT IN (" . join(',', $dStatusCodes) . ") \n\t\t\t\t\t\tAND \t\t\ta.is_delete = 0 \n\t\t\t\t\t\tAND \t\t\tb.sku='{$_sku}' \n\t\t\t\t\t\tAND\t\t\t\ta.storeId = " . $storeId;
//echo $ordersql;
$query = self::$dbConn->query($ordersql);
$ebay_ids = self::$dbConn->fetch_array_all($query);
if (!empty($ebay_ids)) {
foreach ($ebay_ids as $ebay_id) {
$realtimes = self::get_realtime($sku_info["sku"]);
$totalnums += $sku_info["amount"] * $realtimes;
}
}
}
return $totalnums;
/*$sql = "SELECT b.ebay_amount ,b.sku
FROM ebay_order AS a
LEFT JOIN ebay_orderdetail AS b ON a.ebay_ordersn = b.ebay_ordersn
WHERE a.ebay_status IN (705,706,707,710)
AND b.sku in ({$skus_str})
AND a.ebay_combine!='1'
";
$sql = $dbcon->execute($sql);
$skunums = $dbcon->getResultArray($sql);
foreach($skunums as $sku_info){
$realtimes = get_realtime($sku_info["sku"]);
$totalnums += ($sku_info["ebay_amount"]*$realtimes);
}
return $totalnums;*/
}