$sql = "UPDATE tbl_product_stock SET `stock_quantity` = ? WHERE `stock_id` = ?";
$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;
$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) {
$status = 'Expired';
$date = date('Y-m-d H:i:s');
$payment = $header_get_expired->payment_status;
$fulfillment = $header_get_expired->fulfillment_status;
$order_id = $header_get_expired->order_id;
$order_item = $_cron->order_get_size_type($order_id);
foreach ($order_item as $order_item) {
$temp_stock = $_cron->get_product_stock($order_item->type_id, $order_item->stock_name);
$stock = $temp_stock->stock_quantity + $order_item->item_quantity;
$_cron->order_update_stock($stock, $temp_stock->stock_id);
}
$_cron->update_status_expired($status, $date, $payment, $fulfillment, $order_id);
/* --- ORDER LOG --- */
$description = 14;
