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; }