//Set the date range to calculate
if (isset($_GET['start']) && isset($_GET['end'])) {
//MANUAL SET DATE RANGE
$date_start = date('Y-m-d', strtotime($_GET['start']));
$date_end = date('Y-m-d', strtotime($_GET['end']));
} else {
$lookback = '60 days';
$date_end = date('Y-m-d', strtotime('yesterday'));
$date_start = date('Y-m-d', strtotime("{$date_end} -{$lookback}"));
}
$logger->write('Date range is ' . $date_start . ' until ' . $date_end);
//PROCESS JNG, use $jng_sp_id = 0
$jng_sp_id = '0';
$logger->write('Delete existing data from J&G');
ReportCOGS::clear($jng_sp_id, $date_start, $date_end);
$logger->write('Query orders from J&G and process as data');
$total_rows = ReportCOGS::queryAndAddB2COrders($jng_sp_id, $date_start, $date_end);
$logger->write('Total orders found: ' . $total_rows);
//PROCESS B2C SP
foreach ($sp_ids_included as $jng_sp_id) {
$logger->write('Delete existing data from SPID ' . $jng_sp_id);
ReportCOGS::clear($jng_sp_id, $date_start, $date_end);
$logger->write('Query orders from SPID ' . $jng_sp_id . ' and process as data');
$total_rows = ReportCOGS::queryAndAddB2COrders($jng_sp_id, $date_start, $date_end);
$logger->write('Total orders found: ' . $total_rows);
}
$logger->write('Optimize report_cogs table');
ReportCOGS::optimizeDatabaseTable();
$logger->close();
echo 'Done!';
tep_db_close();
