$price_received = $i['price_received'];
$price_received_total = $qty * $price_received;
$provision = $price_gross_total - $price_received_total;
$stat['returns'] += $price_gross_total;
$stat['returns_ap'] += $price_received_total;
$stat['gross_sales_received'] -= $price_received_total;
$stat['returns_prov'] += $provision;
$stat['provision_paid'] -= $provision;
if (!in_array($order_id, $orders_returned)) {
$orders_returned[] = $order_id;
$stat['orders_returned']++;
}
$stat['products_returned'] += $qty;
}
$stat['net_sales_received'] = $stat['gross_sales_received'] / (1 + $tax);
$packages = $class_jp->retrieveDailyPackages($jng_sp_id, $date_to_get);
$stat['packages_sent'] = $packages['total'];
$stat['freight_charges'] = ($stat['orders_sent'] + $stat['orders_returned']) * $stat['freight_rate'];
$stat['final_contribution'] = $stat['net_sales_received'] - $stat['freight_charges'];
$check_exist = tep_db_query("SELECT stat_id FROM minierp_statistic_daily_sp WHERE jng_sp_id={$jng_sp_id} AND DATE(stat_date)=DATE('{$date_to_get}')");
if (tep_db_num_rows($check_exist) > 0) {
$existing = tep_db_fetch_array($check_exist);
$stat_id = $existing['stat_id'];
tep_db_perform('minierp_statistic_daily_sp', $stat, 'update', "stat_id={$stat_id}");
} else {
tep_db_perform('minierp_statistic_daily_sp', $stat);
}
/* WE STOP CALCULATING VC USING OLD METHOD
* NEW VC CALCULATION IS NOT IN ORDER BASED, BUT IN SP BASED
foreach($orders_canceled as $order_id) {
if(!in_array($order_id, $vc_processed)) {
