return $row;
}
function update_minus_stock($stock_quantity, $stock_id)
{
$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;
/* --- 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);
$stmt->close();
}
function order_update_stock($stock_quantity, $stock_id)
{
$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);
$stmt->close();
}
function updateCartItem($lastUpdate, $status, $cartHash)
{
$sql = "UPDATE `tbl_cart_item` SET `LAST_UPDATE` = ?, STATUS = ? WHERE `CART_HASH` = ?";
$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("sss", $lastUpdate, $status, $cartHash);
$stmt->execute();
}
$stmt->close();
}
}
$_cron = new CRON_EXPIRED_ORDER();
$_cron_email = 1;
/*$getTypeID = $_cron->getTypeIdForOrder();
foreach($getTypeID as $getTypeID){
$_cron->updateTypeIdForOrder($getTypeID->type_id, $getTypeID->type_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) {
$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;
