$query = $this->conn->query($sql);
$result = $query->fetch_object();
return $result;
}
function update_temp_stock($qty, $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: ' . $conn->errno . ' ' . $conn->error, E_USER_ERROR);
} else {
$stmt->bind_param("ss", $qty, $stock_id);
$stmt->execute();
}
$stmt->close();
}
}
$_logout = new LOGOUT_CLEANER();
if (isset($_SESSION['cart_type_id']) && isset($_SESSION['cart_stock_id']) && isset($_SESSION['cart_qty'])) {
$_session_type = $_SESSION['cart_type_id'];
$_session_stock = $_SESSION['cart_stock_id'];
$_session_qty = $_SESSION['cart_qty'];
/* --- BAG HANDLER --- */
foreach ($_session_type as $key => $_session_type) {
$_stock_name = $_logout->get_stock_name($_session_stock[$key]);
$_stock = $_logout->get_product($_session_type, $_stock_name->stock_name);
$temp_stock = $_session_qty[$key] + $_stock_name->stock_quantity;
$_logout->update_temp_stock($temp_stock, $_session_stock[$key]);
}
}
safe_redirect('logout.php');
$stmt->close();
}
function updateCartItem($status, $lastUpdate, $cart_hash)
{
$sql = "UPDATE tbl_cart_item SET `status` = ?, `LAST_UPDATE` = ? WHERE `cart_hash` = ?";
$stmt = $this->conn->prepare($sql);
if ($stmt === false) {
trigger_error('Database error: ' . $sql . ' Error: ' . $conn->errno . ' ' . $conn->error, E_USER_ERROR);
} else {
$stmt->bind_param("sss", $status, $lastUpdate, $cart_hash);
$stmt->execute();
}
$stmt->close();
}
}
$_logout = new LOGOUT_CLEANER();
if (isset($_SESSION['cart']['hash'])) {
$cartHash = $_SESSION['cart']['hash'];
$time = date('Y-m-d H:i:s');
$_logout->updateCart(-1, $time, $cartHash);
$_logout->updateCartItem(-1, $time, $cartHash);
}
if (isset($_SESSION['cart_type_id']) && isset($_SESSION['cart_stock_id']) && isset($_SESSION['cart_qty'])) {
$_session_type = $_SESSION['cart_type_id'];
$_session_stock = $_SESSION['cart_stock_id'];
$_session_qty = $_SESSION['cart_qty'];
/* --- BAG HANDLER --- */
foreach ($_session_type as $key => $_session_type) {
$_stock_name = $_logout->get_stock_name($_session_stock[$key], $_session_type);
$_stock = $_logout->get_product($_session_type, $_stock_name->stock_name);
$temp_stock = $_session_qty[$key] + $_stock_name->stock_quantity;
