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