require_once '../functions.php';
require_once '../functions-2.php';
require_once DIR_WS_FUNCTIONS . 'html_output.php';
tep_db_connect();
use_class('logger');
$logger = new logger('cron', 'set-leadtime-start-date');
use_class('jng_sp_orders');
$class_jo = new jng_sp_orders();
$conf_open_orders = load_config('open-orders');
$shipping_window_release_buffer = $conf_open_orders['shipwin-rel-buffer'];
$payment_method_vorkasse = strtoupper(trim(PAYMENT_METHOD_BANK_TRANSFER));
$payment_method_prepayment = strtoupper(trim(PAYMENT_METHOD_PREPAYMENT));
$q = "SELECT joi.*, DATE_ADD(jo.order_date, INTERVAL {$shipping_window_release_buffer} DAY) leadtime_start_date";
$q .= " FROM jng_sp_orders jo";
$q .= " INNER JOIN jng_sp_orders_items joi ON joi.jng_sp_orders_id = jo.jng_sp_orders_id";
$q .= " WHERE " . $class_jo->filterQueryForShippingWindow($shipping_window_release_buffer);
$q .= " AND joi.status = 1 AND joi.stock_status = '0'";
$q .= " AND UPPER(jo.payment_method) NOT IN ('{$payment_method_vorkasse}', '{$payment_method_prepayment}')";
$res = tep_db_query($q);
$leadtime_start_date = date('Y-m-d H:i:s');
$n_updated = 0;
while ($r = tep_db_fetch_array($res)) {
$oiid = $r['jng_sp_orders_items_id'];
$leadtime_start_date = $r['leadtime_start_date'];
//activate reset lsd in case there changes of config value "shipwin-rel-buffer"
$item_updated = $class_jo->leadtimeSetStart($leadtime_start_date, $r, '', true);
if ($item_updated > 0) {
$logger->write("SP-{$oiid} set with leadtime start date = {$leadtime_start_date}");
$n_updated++;
}
}
