public static function getsaleandnosendall($sku, $storeId = 1)
{
//获取虚拟/待发货库存（除超大订单进来的待发货）
self::initDB();
$totalnums = 0;
$combineskus = GoodsModel::getCombineBySku($sku);
//var_dump($combineskus);
$skus = empty($combineskus) ? array() : array_keys($combineskus);
array_push($skus, $sku);
//var_dump($skus); echo "<br>";
$skus_str = implode("','", $skus);
$skus_str = "'" . $skus_str . "'";
//echo "<pre>";
//$skus = GoodsModel::getCombineANDSKU($sku); //$combineskus
//var_dump($skus); echo "<br>";
//exit;
//return 0;
$menuList = StatusMenuModel::getStatusMenuList("*", " where dStatus = 1 and groupId = 0 and is_delete=0 and storeId= {$storeId} ");
//var_dump($menuList); exit;
$dStatusCodes = array();
foreach ($menuList as $value) {
if ($value['statusCode']) {
$dStatusCodes[] = $value['statusCode'];
}
}
$tendaytime = time() - 10 * 24 * 60 * 60;
//待发货二级状态已经暂不寄超过十天时间
$ordersql = 'SELECT b.sku, b.amount FROM om_unshipped_order AS a JOIN om_unshipped_order_detail AS b ON a.id = b.omOrderId where a.orderStatus in (' . join(',', $dStatusCodes) . ') and a.is_delete=0 and a.storeId= ' . $storeId . ' AND b.sku in (' . $skus_str . ') and b.is_delete=0 and b.storeId= ' . $storeId;
$query = self::$dbConn->query($ordersql);
$skunums = self::$dbConn->fetch_array_all($query);
foreach ($skunums as $sku_info) {
$realtimes = get_realtime($sku_info["sku"]);
$totalnums += $sku_info["amount"] * $realtimes;
}
$ordersql = 'SELECT b.sku, b.amount FROM om_unshipped_order AS a JOIN om_unshipped_order_detail AS b ON a.id = b.omOrderId where a.orderStatus = ' . C('STATESENDTEMP') . ' and a.paymentTime > ' . $tendaytime . ' and a.is_delete=0 and a.storeId= ' . $storeId . ' AND b.sku in (' . $skus_str . ') and b.is_delete=0 and b.storeId= ' . $storeId;
$query = self::$dbConn->query($ordersql);
$skunums = self::$dbConn->fetch_array_all($query);
foreach ($skunums as $sku_info) {
$realtimes = get_realtime($sku_info["sku"]);
$totalnums += $sku_info["amount"] * $realtimes;
}
/*$ordersql = 'SELECT a.id FROM om_unshipped_order AS a where a.orderStatus in ('.join(',', $dStatusCodes).') and a.is_delete=0 and a.storeId= '.$storeId;
$ordersql .= ' UNION ';
$ordersql .= 'SELECT a.id FROM om_unshipped_order AS a where a.orderStatus = '.C('STATESENDTEMP').' and a.paymentTime > '.$tendaytime.' and a.is_delete=0 and a.storeId= '.$storeId;
//echo $ordersql; echo "<br>"; exit;
$query = self::$dbConn->query($ordersql);
$orders = self::$dbConn->fetch_array_all($query);*/
//var_dump($orders); exit;
//return 10;
/*foreach($orders as $value){
//foreach($skus as $_sku => $_num){
$detailsql = 'SELECT b.sku, b.amount FROM om_unshipped_order_detail AS b where b.omOrderId = '.$value['id'].' AND b.sku in ('.$skus_str.') and b.is_delete=0 and b.storeId= '.$storeId;
echo $detailsql; echo "<br>";
exit;
$query = self::$dbConn->query($detailsql);
$detail = self::$dbConn->fetch_array_all($query);
if(empty($detail)){
continue;
}
//var_dump($detail);
foreach($detail as $val){
//$_sku = $val['sku'];
$amount = intval($val['amount']);
$totalnums += ($amount*$_num);
}
//}
}*/
//var_dump($totalnums);
//新的待发货计算没有数据，并且缺货配货记录，等待配货的信息@2013-11-10
return json_encode($totalnums);
}
function get_waiting_sale($sku)
{
global $dbcon;
$totalnums = 0;
$combineskus = get_combinesku($sku);
$skus = empty($combineskus) ? array() : array_keys($combineskus);
array_push($skus, $sku);
$skus_str = implode("','", $skus);
$skus_str = "'" . $skus_str . "'";
$sql = "SELECT b.ebay_amount ,b.sku\n\t\t\t\t\tFROM ebay_order AS a \n\t\t\t\t\tLEFT JOIN ebay_orderdetail AS b ON a.ebay_ordersn = b.ebay_ordersn \n\t\t\t\t\tWHERE a.ebay_status IN (705,706,707,710)\n\t\t\t\t\tAND b.sku in ({$skus_str})\n\t\t\t\t\tAND a.ebay_combine!='1'\n\t\t\t\t\t";
$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;
}
