function getaccountsale($sku, $accounts)
{
global $dbcon;
$totalnums = 0;
$combineskus = get_combinesku($sku);
$mouthtime = strtotime(date("Y-m") . '-1 00:00:01');
$skus = empty($combineskus) ? array() : array_keys($combineskus);
array_push($skus, $sku);
$account_sql = implode(',', array2strarray($accounts));
foreach ($skus as $_sku) {
$realtimes = 1;
if ($_sku != $sku && $combineskus[$_sku]) {
$skulist = explode(',', $combineskus[$_sku]);
foreach ($skulist as $sku_info) {
list($_s, $times) = explode('*', $sku_info);
if ($_s == $sku) {
$realtimes = $times;
}
}
} else {
$realtimes = 1;
}
$sql = "SELECT sum(b.ebay_amount) AS qty \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=2\n\t\t\t\t\tAND b.sku='{$_sku}'\n\t\t\t\t\tAND a.ebay_account IN ({$account_sql})\n\t\t\t\t\tAND a.scantime>{$mouthtime}\n\t\t\t\t\tLIMIT 1";
$sql = $dbcon->execute($sql);
$skunums = $dbcon->getResultArray($sql);
if (!empty($skunums)) {
$totalnums += $skunums[0]['qty'] * $realtimes;
}
}
return $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;
}
