$stmt = $this->conn->prepare($sql);
if ($stmt === false) {
trigger_error('Database error: ' . $sql . ' Error: ' . $this->conn->errno . ' ' . $this->conn->error, E_USER_ERROR);
} else {
$stmt->bind_param("ss", $stock_quantity, $stock_id);
$stmt->execute();
}
$stmt->close();
}
}
$_cron = new CRON_EXPIRED_ORDER();
$_cron_email = 1;
/* --- MINUS STOCK PREVENTED --- */
$_count_minus_stock = $_cron->count_minus_stock();
if ($_count_minus_stock->rows > 0) {
$_data_minus_stock = $_cron->get_minus_stock();
foreach ($_data_minus_stock as $_data_minus_stock) {
$_cron->update_minus_stock(0, $_data_minus_stock->stock_id);
}
}
$header_check_expired = $_cron->header_count_order('Open', 'Unpaid');
if ($header_check_expired->rows > 0) {
$header_get_expired = $_cron->header_get_order('Open', 'Unpaid');
foreach ($header_get_expired as $key => $header_get_expired) {
$_time = 86400;
$_order_living_time = $_cron->check_on_hold($header_get_expired->order_date);
if ($_order_living_time->second > $_time) {
$_cron->header_update_expired_order($header_get_expired->order_id);
$status = 'Expired';
$date = date('Y-m-d H:i:s');
$payment = $header_get_expired->payment_status;
