$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;