/mnt/web601/b3/14/57451114/htdocs/httpdocs/admin/includes/classes/shopping_cart.php
<?php
/*
--------------------------------------------------------------
shopping_cart.php 2023-05-12
Gambio GmbH
http://www.gambio.de
Copyright (c) 2023 Gambio GmbH
Released under the GNU General Public License (Version 2)
[http://www.gnu.org/licenses/gpl-2.0.html]
IMPORTANT! THIS FILE IS DEPRECATED AND WILL BE REPLACED IN THE FUTURE.
MODIFY IT ONLY FOR FIXES. DO NOT APPEND IT WITH NEW FEATURES, USE THE
NEW GX-ENGINE LIBRARIES INSTEAD.
--------------------------------------------------------------
--------------------------------------------------------------
$Id: shopping_cart.php 950 2005-05-14 16:45:21Z mz $
XT-Commerce - community made shopping
http://www.xt-commerce.com
Copyright (c) 2003 XT-Commerce
--------------------------------------------------------------
based on:
(c) 2000-2001 The Exchange Project (earlier name of osCommerce)
(c) 2002-2003 osCommerce(shopping_cart.php,v 1.7 2002/05/16); www.oscommerce.com
(c) 2003 nextcommerce (shopping_cart.php,v 1.6 2003/08/18); www.nextcommerce.org
Released under the GNU General Public License
--------------------------------------------------------------*/
defined( '_VALID_XTC' ) or die( 'Direct Access to this location is not allowed.' );
class shoppingCart_ORIGIN {
var $contents, $total, $weight;
function __construct() {
$this->reset();
}
function restore_contents() {
if (empty($_SESSION['customer_id'])) return 0;
// insert current cart contents in database
if ($this->contents) {
reset($this->contents);
foreach($this->contents as $products_id => $value) {
$qty = $this->contents[$products_id]['qty'];
$product_query = xtc_db_query("select products_id from " . TABLE_CUSTOMERS_BASKET . " where customers_id = '" . $_SESSION['customer_id'] . "' and products_id = '" . $products_id . "'");
if (!xtc_db_num_rows($product_query)) {
xtc_db_query("insert into " . TABLE_CUSTOMERS_BASKET . " (customers_id, products_id, customers_basket_quantity, customers_basket_date_added) values ('" . $_SESSION['customer_id'] . "', '" . $products_id . "', '" . $qty . "', '" . date('Ymd') . "')");
if ($this->contents[$products_id]['attributes']) {
reset($this->contents[$products_id]['attributes']);
foreach($this->contents[$products_id]['attributes'] as $option => $value) {
xtc_db_query("insert into " . TABLE_CUSTOMERS_BASKET_ATTRIBUTES . " (customers_id, products_id, products_options_id, products_options_value_id) values ('" . $_SESSION['customer_id'] . "', '" . $products_id . "', '" . $option . "', '" . $value . "')");
}
}
} else {
xtc_db_query("update " . TABLE_CUSTOMERS_BASKET . " set customers_basket_quantity = '" . $qty . "' where customers_id = '" . $_SESSION['customer_id'] . "' and products_id = '" . $products_id . "'");
}
}
}
// reset per-session cart contents, but not the database contents
$this->reset(FALSE);
$products_query = xtc_db_query("select products_id, customers_basket_quantity from " . TABLE_CUSTOMERS_BASKET . " where customers_id = '" . $_SESSION['customer_id'] . "'");
while ($products = xtc_db_fetch_array($products_query)) {
$this->contents[$products['products_id']] = array('qty' => $products['customers_basket_quantity']);
// attributes
$attributes_query = xtc_db_query("select products_options_id, products_options_value_id from " . TABLE_CUSTOMERS_BASKET_ATTRIBUTES . " where customers_id = '" . $_SESSION['customer_id'] . "' and products_id = '" . $products['products_id'] . "'");
while ($attributes = xtc_db_fetch_array($attributes_query)) {
$this->contents[$products['products_id']]['attributes'][$attributes['products_options_id']] = $attributes['products_options_value_id'];
}
}
$this->cleanup();
}
function reset($reset_database = FALSE) {
$this->contents = array();
$this->total = 0;
if (!empty($_SESSION['customer_id']) && $reset_database) {
xtc_db_query("delete from " . TABLE_CUSTOMERS_BASKET . " where customers_id = '" . $_SESSION['customer_id'] . "'");
xtc_db_query("delete from " . TABLE_CUSTOMERS_BASKET_ATTRIBUTES . " where customers_id = '" . $_SESSION['customer_id'] . "'");
}
}
function add_cart($products_id, $qty = '', $attributes = '') {
$products_id = xtc_get_uprid($products_id, $attributes);
if ($this->in_cart($products_id)) {
$this->update_quantity($products_id, $qty, $attributes);
} else {
if ($qty == '') $qty = '1'; // if no quantity is supplied, then add '1' to the customers basket
$this->contents[] = array($products_id);
$this->contents[$products_id] = array('qty' => $qty);
// insert into database
if (!empty($_SESSION['customer_id'])) xtc_db_query("insert into " . TABLE_CUSTOMERS_BASKET . " (customers_id, products_id, customers_basket_quantity, customers_basket_date_added) values ('" . $_SESSION['customer_id'] . "', '" . $products_id . "', '" . $qty . "', '" . date('Ymd') . "')");
if (is_array($attributes)) {
reset($attributes);
foreach($attributes as $option => $value) {
$this->contents[$products_id]['attributes'][$option] = $value;
// insert into database
if (!empty($_SESSION['customer_id'])) xtc_db_query("insert into " . TABLE_CUSTOMERS_BASKET_ATTRIBUTES . " (customers_id, products_id, products_options_id, products_options_value_id) values ('" . $_SESSION['customer_id'] . "', '" . $products_id . "', '" . $option . "', '" . $value . "')");
}
}
$_SESSION['new_products_id_in_cart'] = $products_id;
}
$this->cleanup();
}
function update_quantity($products_id, $quantity = '', $attributes = '') {
if ($quantity == '') return true; // nothing needs to be updated if theres no quantity, so we return true..
$this->contents[$products_id] = array('qty' => $quantity);
// update database
if (!empty($_SESSION['customer_id'])) xtc_db_query("update " . TABLE_CUSTOMERS_BASKET . " set customers_basket_quantity = '" . $quantity . "' where customers_id = '" . $_SESSION['customer_id'] . "' and products_id = '" . $products_id . "'");
if (is_array($attributes)) {
reset($attributes);
foreach($attributes as $option => $value) {
$this->contents[$products_id]['attributes'][$option] = $value;
// update database
if (!empty($_SESSION['customer_id'])) xtc_db_query("update " . TABLE_CUSTOMERS_BASKET_ATTRIBUTES . " set products_options_value_id = '" . $value . "' where customers_id = '" . $_SESSION['customer_id'] . "' and products_id = '" . $products_id . "' and products_options_id = '" . $option . "'");
}
}
}
function cleanup() {
reset($this->contents);
foreach($this->contents as $key => $value) {
if ($this->contents[$key]['qty'] < 1) {
unset($this->contents[$key]);
// remove from database
if (!empty($_SESSION['customer_id'])) {
xtc_db_query("delete from " . TABLE_CUSTOMERS_BASKET . " where customers_id = '" . $_SESSION['customer_id'] . "' and products_id = '" . $key . "'");
xtc_db_query("delete from " . TABLE_CUSTOMERS_BASKET_ATTRIBUTES . " where customers_id = '" . $_SESSION['customer_id'] . "' and products_id = '" . $key . "'");
}
}
}
}
function count_contents() { // get total number of items in cart
$total_items = 0;
if (is_array($this->contents)) {
reset($this->contents);
foreach($this->contents as $products_id => $value) {
$total_items += $this->get_quantity($products_id);
}
}
return $total_items;
}
function get_quantity($products_id) {
if ($this->contents[$products_id]) {
return $this->contents[$products_id]['qty'];
} else {
return 0;
}
}
function in_cart($products_id) {
if ($this->contents[$products_id]) {
return true;
} else {
return false;
}
}
function remove($products_id) {
unset($this->contents[$products_id]);
// remove from database
if (!empty($_SESSION['customer_id'])) {
xtc_db_query("delete from " . TABLE_CUSTOMERS_BASKET . " where customers_id = '" . $_SESSION['customer_id'] . "' and products_id = '" . $products_id . "'");
xtc_db_query("delete from " . TABLE_CUSTOMERS_BASKET_ATTRIBUTES . " where customers_id = '" . $_SESSION['customer_id'] . "' and products_id = '" . $products_id . "'");
}
}
function remove_all() {
$this->reset();
}
function get_product_id_list() {
$product_id_list = '';
if (is_array($this->contents)) {
reset($this->contents);
foreach($this->contents as $products_id => $value) {
$product_id_list .= ', ' . $products_id;
}
}
return substr($product_id_list, 2);
}
function calculate() {
$this->total = 0;
$this->weight = 0;
if (!is_array($this->contents)) return 0;
reset($this->contents);
foreach($this->contents as $products_id => $value) {
$qty = $this->contents[$products_id]['qty'];
// products price
$product_query = xtc_db_query("select products_id, products_price, products_tax_class_id, products_weight from " . TABLE_PRODUCTS . " where products_id='" . xtc_get_prid($products_id) . "'");
if ($product = xtc_db_fetch_array($product_query)) {
$prid = $product['products_id'];
$products_tax = xtc_get_tax_rate($product['products_tax_class_id']);
$products_price = $product['products_price'];
$products_weight = $product['products_weight'];
$specials_query = xtc_db_query("select specials_new_products_price from " . TABLE_SPECIALS . " where products_id = '" . $prid . "' and status = '1'");
if (xtc_db_num_rows ($specials_query)) {
$specials = xtc_db_fetch_array($specials_query);
$products_price = $specials['specials_new_products_price'];
}
$this->total += xtc_add_tax($products_price, $products_tax) * $qty;
$this->weight += ($qty * $products_weight);
}
// attributes price
if (!empty($this->contents[$products_id]['attributes'])) {
reset($this->contents[$products_id]['attributes']);
foreach($this->contents[$products_id]['attributes'] as $option => $value) {
$attribute_price_query = xtc_db_query("select options_values_price, price_prefix from " . TABLE_PRODUCTS_ATTRIBUTES . " where products_id = '" . $prid . "' and options_id = '" . $option . "' and options_values_id = '" . $value . "'");
$attribute_price = xtc_db_fetch_array($attribute_price_query);
if (($attribute_price['price_prefix'] ?? null) == '+') {
$this->total += $qty * xtc_add_tax($attribute_price['options_values_price'], $products_tax);
} else {
$this->total -= $qty * xtc_add_tax($attribute_price['options_values_price'] ?? null, $products_tax);
}
}
}
}
}
function attributes_price($products_id) {
if ($this->contents[$products_id]['attributes']) {
reset($this->contents[$products_id]['attributes']);
foreach($this->contents[$products_id]['attributes'] as $option => $value) {
$attribute_price_query = xtc_db_query("select options_values_price, price_prefix from " . TABLE_PRODUCTS_ATTRIBUTES . " where products_id = '" . $products_id . "' and options_id = '" . $option . "' and options_values_id = '" . $value . "'");
$attribute_price = xtc_db_fetch_array($attribute_price_query);
if ($attribute_price['price_prefix'] == '+') {
$attributes_price += $attribute_price['options_values_price'];
} else {
$attributes_price -= $attribute_price['options_values_price'];
}
}
}
return $attributes_price;
}
function get_products() {
if (!is_array($this->contents)) return 0;
$products_array = array();
reset($this->contents);
foreach($this->contents as $products_id => $value) {
$products_query = xtc_db_query("select p.products_id, pd.products_name, p.products_model, p.products_price, p.products_weight, p.products_tax_class_id from " . TABLE_PRODUCTS . " p, " . TABLE_PRODUCTS_DESCRIPTION . " pd where p.products_id='" . xtc_get_prid($products_id) . "' and pd.products_id = p.products_id and pd.language_id = '" . $_SESSION['languages_id'] . "'");
if ($products = xtc_db_fetch_array($products_query)) {
$prid = $products['products_id'];
$products_price = $products['products_price'];
$specials_query = xtc_db_query("select specials_new_products_price from " . TABLE_SPECIALS . " where products_id = '" . $prid . "' and status = '1'");
if (xtc_db_num_rows($specials_query)) {
$specials = xtc_db_fetch_array($specials_query);
$products_price = $specials['specials_new_products_price'];
}
$products_array[] = array('id' => $products_id,
'name' => $products['products_name'],
'model' => $products['products_model'],
'price' => $products_price,
'quantity' => $this->contents[$products_id]['qty'],
'weight' => $products['products_weight'],
'final_price' => ($products_price + $this->attributes_price($products_id)),
'tax_class_id' => $products['products_tax_class_id'],
'attributes' => $this->contents[$products_id]['attributes']);
}
}
return $products_array;
}
function show_total() {
$this->calculate();
return $this->total;
}
function show_weight() {
$this->calculate();
return $this->weight;
}
function unserialize($broken) {
foreach($broken as $key => $value)
{
$this->{$key} = $value;
}
}
}
MainFactory::load_origin_class('shoppingCart');
Unexpected error occurred...
Class "main_ORIGIN" not found