<?php if (__FILE__ == $_SERVER['SCRIPT_FILENAME']) exit('No direct access allowed.');
/**
* Cart class
*/
class Cart {
/**
* Config
*
* @access private
*/
private static $config;
/**
* Database
*
* @access private
*/
private $db;
/**
* Session
*
* @access private
*/
private $session;
/**
* Error
*
* @access private
*/
private $error;
/**
* Constructor
*
* @access public
*/
public function __construct() {
self::$config = config_load('cart');
$this->db = new Database();
$this->session = new Session();
$this->error = new Error();
$this->delete_carts();
if (!$this->session->get('cart_session'))
$this->cart_session();
}
/**
* Generates the session of the cart
*
* @access private
*/
private function cart_session() {
if (!$this->session->get('cart_session'))
$this->session->set('cart_session', md5(uniqid(mt_rand())));
}
/**
* Add product
*
* @access public
*/
public function add_product($product_id, $options = array()) {
$product_id = filter_var($product_id, FILTER_SANITIZE_NUMBER_INT);
$sql = "SELECT product_id, product_name, product_thumbnail, product_description, product_quantity FROM " . self::$config['table_products'] . " WHERE product_id = '" . $product_id . "'";
if ($this->db->row_count($sql)) {
$result = $this->db->fetch_row_assoc($sql);
if ($result['product_quantity'] == 0) {
$this->error->set_error('The ' . $result['product_name'] . ' product is no in stock.');
} else {
if (empty($options[0]))
$sql = "SELECT * FROM " . self::$config['table_carts'] . " WHERE product_id = '" . $product_id . "' AND cart_session = '" . $this->session->get('cart_session') . "'";
else
$sql = "SELECT * FROM " . self::$config['table_carts'] . " WHERE product_id = '" . $product_id . "' AND cart_session = '" . $this->session->get('cart_session') . "' AND options = '" . implode(':', $options) . "'";
if ($this->db->row_count($sql) == 0) {
if (!empty($options[0])) {
foreach ($options as $value) {
$product_options = $this->db->fetch_row_assoc("SELECT p.product_name, pov.option_value, pov.option_quantity FROM " . self::$config['table_products'] . " p, " . self::$config['table_product_option_values'] . " pov WHERE pov.option_value_id = '" . $value . "' AND pov.product_id = p.product_id");
if ($product_options['option_quantity'] == 0) {
$this->error->set_error('The quantity you have requested for ' . $product_options['product_name'] . ' ' . $product_options['option_value'] . ' is more than that into stock.');
return;
}
}
}
$custom_product_one = $_POST['custom_product_one'];
$custom_product_two = $_POST['custom_product_two'];
if (empty($result['custom_product_one'])) {
$custom_product_qty = $_POST['product_quantity'];
}
$custom_product = "$custom_product_qty $custom_product_one $custom_product_two";
$values = array(
'cart_session' => $this->session->get('cart_session'),
'product_id' => $product_id,
'product_quantity' => $_POST['product_quantity'],
'cart_created' => time(),
'custom_image' => $_POST['custom_image'],
'custom_product' => $custom_product
);
if ($options) $values['options'] = implode(':', $options);
$this->db->insert(self::$config['table_carts'], $values);
} else {
$result = $this->db->fetch_row_assoc($sql);
$product = $this->db->fetch_row_assoc("SELECT product_id, product_name, product_quantity FROM " . self::$config['table_products'] . " WHERE product_id = '" . $product_id . "'");
$new_quantity = $result['product_quantity'] + $_POST['product_quantity'];
if (empty($options[0])) {
if ($new_quantity > $product['product_quantity']) {
$new_quantity = $result['product_quantity'];
$this->error->set_error('The quantity you have requested for ' . $product['product_name'] . ' is more than that into stock.');
}
} else {
$data = explode(':', $result['options']);
foreach ($data as $value) {
$product_options = $this->db->fetch_row_assoc("SELECT option_value, option_quantity FROM " . self::$config['table_product_option_values'] . " WHERE option_value_id = '" . $value . "'");
if ($new_quantity > $product_options['option_quantity']) {
$new_quantity = $result['product_quantity'];
$this->error->set_error('The quantity you have requested for ' . $product['product_name'] . ' ' . $product_options['option_value'] . ' is more than that into stock.');
}
}
}
if (empty($result['custom_product_one'])) {
$custom_product_qty = $_POST['product_quantity'];
}
$custom_product = "$custom_product_qty $custom_product_one $custom_product_two";
if (empty($result['custom_image_2'])) {
$values = array(
'product_quantity' => $new_quantity,
'custom_image_2' => $_POST['custom_image'],
'custom_product_2' => $custom_product
);
$where = array(
'cart_session' => $this->session->get('cart_session'),
'product_id' => $product_id
);
}
elseif (empty($result['custom_image_3'])) {
$values = array(
'product_quantity' => $new_quantity,
'custom_image_3' => $_POST['custom_image'],
'custom_product_3' => $custom_product
);
$where = array(
'cart_session' => $this->session->get('cart_session'),
'product_id' => $product_id
);
}
elseif (empty($result['custom_image_4'])) {
$values = array(
'product_quantity' => $new_quantity,
'custom_image_4' => $_POST['custom_image'],
'custom_product_4' => $custom_product
);
$where = array(
'cart_session' => $this->session->get('cart_session'),
'product_id' => $product_id
);
}
elseif (empty($result['custom_image_5'])) {
$values = array(
'product_quantity' => $new_quantity,
'custom_image_5' => $_POST['custom_image'],
'custom_product_5' => $custom_product
);
$where = array(
'cart_session' => $this->session->get('cart_session'),
'product_id' => $product_id
);
}
elseif (empty($result['custom_image_6'])) {
$values = array(
'product_quantity' => $new_quantity,
'custom_image_6' => $_POST['custom_image'],
'custom_product_6' => $custom_product
);
$where = array(
'cart_session' => $this->session->get('cart_session'),
'product_id' => $product_id
);
}
elseif (empty($result['custom_image_7'])) {
$values = array(
'product_quantity' => $new_quantity,
'custom_image_7' => $_POST['custom_image'],
'custom_product_7' => $custom_product
);
$where = array(
'cart_session' => $this->session->get('cart_session'),
'product_id' => $product_id
);
}
elseif (empty($result['custom_image_8'])) {
$values = array(
'product_quantity' => $new_quantity,
'custom_image_8' => $_POST['custom_image'],
'custom_product_8' => $custom_product
);
$where = array(
'cart_session' => $this->session->get('cart_session'),
'product_id' => $product_id
);
}
elseif (empty($result['custom_image_9'])) {
$values = array(
'product_quantity' => $new_quantity,
'custom_image_9' => $_POST['custom_image'],
'custom_product_9' => $custom_product
);
$where = array(
'cart_session' => $this->session->get('cart_session'),
'product_id' => $product_id
);
}
elseif (empty($result['custom_image_10'])) {
$values = array(
'product_quantity' => $new_quantity,
'custom_image_10' => $_POST['custom_image'],
'custom_product_10' => $custom_product
);
$where = array(
'cart_session' => $this->session->get('cart_session'),
'product_id' => $product_id
);
}
elseif (empty($result['custom_image_11'])) {
$values = array(
'product_quantity' => $new_quantity,
'custom_image_11' => $_POST['custom_image']
);
$where = array(
'cart_session' => $this->session->get('cart_session'),
'product_id' => $product_id
);
}
elseif (empty($result['custom_image_12'])) {
$values = array(
'product_quantity' => $new_quantity,
'custom_image_12' => $_POST['custom_image']
);
$where = array(
'cart_session' => $this->session->get('cart_session'),
'product_id' => $product_id
);
}
elseif (empty($result['custom_image_13'])) {
$values = array(
'product_quantity' => $new_quantity,
'custom_image_13' => $_POST['custom_image']
);
$where = array(
'cart_session' => $this->session->get('cart_session'),
'product_id' => $product_id
);
}
elseif (empty($result['custom_image_14'])) {
$values = array(
'product_quantity' => $new_quantity,
'custom_image_14' => $_POST['custom_image']
);
$where = array(
'cart_session' => $this->session->get('cart_session'),
'product_id' => $product_id
);
}
elseif (empty($result['custom_image_15'])) {
$values = array(
'product_quantity' => $new_quantity,
'custom_image_15' => $_POST['custom_image']
);
$where = array(
'cart_session' => $this->session->get('cart_session'),
'product_id' => $product_id
);
}
elseif (empty($result['custom_image_16'])) {
$values = array(
'product_quantity' => $new_quantity,
'custom_image_16' => $_POST['custom_image']
);
$where = array(
'cart_session' => $this->session->get('cart_session'),
'product_id' => $product_id
);
}
elseif (empty($result['custom_image_17'])) {
$values = array(
'product_quantity' => $new_quantity,
'custom_image_17' => $_POST['custom_image']
);
$where = array(
'cart_session' => $this->session->get('cart_session'),
'product_id' => $product_id
);
}
elseif (empty($result['custom_image_18'])) {
$values = array(
'product_quantity' => $new_quantity,
'custom_image_18' => $_POST['custom_image']
);
$where = array(
'cart_session' => $this->session->get('cart_session'),
'product_id' => $product_id
);
}
elseif (empty($result['custom_image_19'])) {
$values = array(
'product_quantity' => $new_quantity,
'custom_image_19' => $_POST['custom_image']
);
$where = array(
'cart_session' => $this->session->get('cart_session'),
'product_id' => $product_id
);
}
elseif (empty($result['custom_image_20'])) {
$values = array(
'product_quantity' => $new_quantity,
'custom_image_20' => $_POST['custom_image']
);
$where = array(
'cart_session' => $this->session->get('cart_session'),
'product_id' => $product_id
);
}
$custom_product_one = $_POST['custom_product_one'];
$custom_product_two = $_POST['custom_product_two'];
if (empty($result['custom_product_one'])) {
$custom_product_qty = $_POST['product_quantity'];
}
$custom_product = "$custom_product_qty $custom_product_one $custom_product_two";
if (empty($result['custom_image'])) {
if (empty($result['custom_product_2'])) {
$values = array(
'product_quantity' => $new_quantity,
'custom_product_2' => $custom_product
);
$where = array(
'cart_session' => $this->session->get('cart_session'),
'product_id' => $product_id
);
}
elseif (empty($result['custom_product_3'])) {
$values = array(
'product_quantity' => $new_quantity,
'custom_product_3' => $custom_product
);
$where = array(
'cart_session' => $this->session->get('cart_session'),
'product_id' => $product_id
);
}
elseif (empty($result['custom_product_4'])) {
$values = array(
'product_quantity' => $new_quantity,
'custom_product_4' => $custom_product
);
$where = array(
'cart_session' => $this->session->get('cart_session'),
'product_id' => $product_id
);
}
elseif (empty($result['custom_product_5'])) {
$values = array(
'product_quantity' => $new_quantity,
'custom_product_5' => $custom_product
);
$where = array(
'cart_session' => $this->session->get('cart_session'),
'product_id' => $product_id
);
}
elseif (empty($result['custom_product_6'])) {
$values = array(
'product_quantity' => $new_quantity,
'custom_product_6' => $custom_product
);
$where = array(
'cart_session' => $this->session->get('cart_session'),
'product_id' => $product_id
);
}
elseif (empty($result['custom_product_7'])) {
$values = array(
'product_quantity' => $new_quantity,
'custom_product_7' => $custom_product
);
$where = array(
'cart_session' => $this->session->get('cart_session'),
'product_id' => $product_id
);
}
elseif (empty($result['custom_product_8'])) {
$values = array(
'product_quantity' => $new_quantity,
'custom_product_8' => $custom_product
);
$where = array(
'cart_session' => $this->session->get('cart_session'),
'product_id' => $product_id
);
}
elseif (empty($result['custom_product_9'])) {
$values = array(
'product_quantity' => $new_quantity,
'custom_product_9' => $custom_product
);
$where = array(
'cart_session' => $this->session->get('cart_session'),
'product_id' => $product_id
);
}
elseif (empty($result['custom_product_10'])) {
$values = array(
'product_quantity' => $new_quantity,
'custom_product_10' => $custom_product
);
$where = array(
'cart_session' => $this->session->get('cart_session'),
'product_id' => $product_id
);
}
}
if ($options) $where['options'] = implode(':', $options);
$this->db->where($where);
$this->db->update(self::$config['table_carts'], $values);
}
}
} else {
$this->error->set_error('Sorry but the product is no longer in stock.');
}
}
/**
* Get cart
*
* @access public
*/
public function get_cart() {
$cart = array();
foreach ($this->db->query("SELECT p.product_id, p.product_name, p.product_price, p.shipping, c.cart_id, c.product_quantity FROM " . self::$config['table_products'] . " p, " . self::$config['table_carts'] . " c WHERE p.product_id = c.product_id AND c.cart_session = '" . $this->session->get('cart_session') . "'") as $row) {
$option_price = 0;
$options = array();
foreach ($this->db->query("SELECT * FROM " . self::$config['table_carts'] . " WHERE cart_id = '" . $row['cart_id'] . "'") as $product_options) {
$data = explode(':', $product_options['options']);
foreach ($data as $value) {
$option_values = $this->db->fetch_row_assoc("SELECT *, po.option_name, pov.option_value FROM " . self::$config['table_product_options'] . " po, " . self::$config['table_product_option_values'] . " pov WHERE po.option_id = pov.option_id AND pov.option_value_id = '" . $value . "'");
if ($option_values['option_type'] == '+')
$option_price = $option_price + $option_values['option_price'];
elseif ($option_values['option_type'] == '-')
$option_price = $option_price - $option_values['option_price'];
$options[] = array(
'option_value_id' => $option_values['option_value_id'],
'option_name' => $option_values['option_name'],
'option_value' => $option_values['option_value'],
'option_quantity' => $option_values['option_quantity']
);
}
}
$cart[] = array(
'cart_id' => $row['cart_id'],
'product_id' => $row['product_id'],
'product_name' => $row['product_name'],
'product_price' => $row['product_price'] + $option_price,
'product_quantity' => $row['product_quantity'],
'shipping' => $row['shipping'],
'total_price' => ($row['product_price'] + $option_price) * $row['product_quantity'],
'options' => $options
);
}
if (isset($cart))
return $cart;
}
/**
* Empty cart
*
* @access public
*/
public function empty_cart() {
$where = array(
'cart_session' => $this->session->get('cart_session')
);
$this->db->where($where);
$this->db->delete(self::$config['table_carts']);
$this->session->delete('cart_session');
$this->session->delete('coupon');
}
/**
* Remove item
*
* @access public
*/
public function remove_item($cart_id, $product_id) {
$cart_id = filter_var($cart_id, FILTER_SANITIZE_NUMBER_INT);
$product_id = filter_var($product_id, FILTER_SANITIZE_NUMBER_INT);
$where = array(
'cart_id' => $cart_id,
'product_id' => $product_id
);
$this->db->where($where);
$this->db->delete(self::$config['table_carts']);
}
/**
* Subtotal
*
* @access public
*/
public function subtotal() {
$subtotal = 0;
$discount = 0;
foreach ($this->db->query("SELECT p.product_price, c.product_quantity, c.cart_id FROM " . self::$config['table_products'] . " p, " . self::$config['table_carts'] . " c WHERE p.product_id = c.product_id AND c.cart_session = '" . $this->session->get('cart_session') . "'") as $row) {
$option_price = 0;
foreach ($this->db->query("SELECT * FROM " . self::$config['table_carts'] . " WHERE cart_id = '" . $row['cart_id'] . "'") as $product_options) {
$data = explode(':', $product_options['options']);
foreach ($data as $value) {
$option_values = $this->db->fetch_row_assoc("SELECT option_price, option_type FROM " . self::$config['table_product_option_values'] . " WHERE option_value_id = '" . $value . "'");
if ($option_values['option_type'] == '+')
$option_price = $option_price + $option_values['option_price'];
elseif ($option_values['option_type'] == '-')
$option_price = $option_price - $option_values['option_price'];
}
}
$subtotal += ($row['product_price'] + $option_price) * $row['product_quantity'];
}
return $subtotal;
}
/**
* Shipping cost
*
* @access public
*/
public function shipping_cost() {
if ($this->has_shipping())
return self::$config['shipping_cost'];
else
return 0;
}
/**
* Tax rate
*
* @access public
*/
public function tax_rate() {
$subtotal = 0;
$tax_shipping = 0;
foreach ($this->db->query("SELECT p.product_price, c.cart_id, c.product_quantity FROM " . self::$config['table_products'] . " p, " . self::$config['table_carts'] . " c WHERE p.product_id = c.product_id AND c.cart_session = '" . $this->session->get('cart_session') . "'") as $row) {
$option_price = 0;
foreach ($this->db->query("SELECT * FROM " . self::$config['table_carts'] . " WHERE cart_id = '" . $row['cart_id'] . "'") as $product_options) {
$data = explode(':', $product_options['options']);
foreach ($data as $value) {
$option_values = $this->db->fetch_row_assoc("SELECT option_price, option_type FROM " . self::$config['table_product_option_values'] . " WHERE option_value_id = '" . $value . "'");
if ($option_values['option_type'] == '+')
$option_price = $option_price + $option_values['option_price'];
elseif ($option_values['option_type'] == '-')
$option_price = $option_price - $option_values['option_price'];
}
}
$subtotal += ($row['product_price'] + $option_price) * $row['product_quantity'];
}
if (self::$config['tax_shipping'])
$tax_shipping = self::$config['shipping_cost'];
return (($subtotal + $tax_shipping) * self::$config['tax_rate'] / 100);
}
/**
* Total
*
* @access public
*/
public function total() {
$subtotal = 0;
$discount = 0;
$tax_shipping = 0;
foreach ($this->db->query("SELECT p.product_price, c.product_quantity, c.cart_id FROM " . self::$config['table_products'] . " p, " . self::$config['table_carts'] . " c WHERE p.product_id = c.product_id AND c.cart_session = '" . $this->session->get('cart_session') . "'") as $row) {
$option_price = 0;
foreach ($this->db->query("SELECT * FROM " . self::$config['table_carts'] . " WHERE cart_id = '" . $row['cart_id'] . "'") as $product_options) {
$data = explode(':', $product_options['options']);
foreach ($data as $value) {
$option_values = $this->db->fetch_row_assoc("SELECT option_price, option_type FROM " . self::$config['table_product_option_values'] . " WHERE option_value_id = '" . $value . "'");
if ($option_values['option_type'] == '+')
$option_price = $option_price + $option_values['option_price'];
elseif ($option_values['option_type'] == '-')
$option_price = $option_price - $option_values['option_price'];
}
}
$subtotal += ($row['product_price'] + $option_price) * $row['product_quantity'];
}
if ($this->session->get('coupon_id')) {
$counpon_data = $this->db->fetch_row_assoc("SELECT coupon_id, coupon_type, coupon_discount FROM " . self::$config['table_coupons'] . " WHERE coupon_id = '" . $this->session->get('coupon_id') . "'");
if ($counpon_data['coupon_type'] == 'F')
$discount = $counpon_data['coupon_discount'];
elseif ($counpon_data['coupon_type'] == 'P')
$discount = $subtotal * $counpon_data['coupon_discount'] / 100;
}
if (self::$config['tax_shipping'])
$tax_shipping = self::$config['shipping_cost'];
if ($this->has_shipping())
return (($subtotal + $tax_shipping) * self::$config['tax_rate'] / 100) + ($subtotal + self::$config['shipping_cost']) - $discount;
else
return (($subtotal + $tax_shipping) * self::$config['tax_rate'] / 100) + ($subtotal - $discount);
}
/**
* Delete carts
*
* @access private
*/
private function delete_carts() {
foreach ($this->db->query("SELECT cart_id FROM " . self::$config['table_carts'] . " WHERE cart_created < '" . time() . "' - '" . self::$config['cart_expire'] . "'") as $row) {
$where = array(
'cart_id' => $row['cart_id']
);
$this->db->where($where);
$this->db->delete(self::$config['table_carts']);
}
}
/**
* Get product
*
* @access public
*/
public function get_product($product_id) {
$product_id = filter_var($product_id, FILTER_SANITIZE_NUMBER_INT);
foreach ($this->db->query("SELECT * FROM " . self::$config['table_products'] . " WHERE product_id = '" . $product_id . "'") as $row) {
$details[] = array(
'product_name' => $row['product_name'],
'product_description' => $row['product_description'],
'product_image' => $row['product_image'],
'product_thumbnail' => $row['product_thumbnail'],
'product_price' => $row['product_price']
);
}
if (isset($details))
return $details;
}
/**
* Get product options
*
* @access public
*/
public function get_product_options($product_id) {
$product_id = filter_var($product_id, FILTER_SANITIZE_NUMBER_INT);
$options = array();
foreach ($this->db->query("SELECT * FROM " . self::$config['table_product_options'] . " WHERE product_id = '" . $product_id . "' ORDER BY position") as $product_options) {
$option_values = array();
foreach ($this->db->query("SELECT * FROM " . self::$config['table_product_option_values'] . " WHERE option_id = '" . $product_options['option_id'] . "' ORDER BY position") as $row) {
$option_values[] = array(
'option_value_id' => $row['option_value_id'],
'option_value' => $row['option_value'],
'option_price' => $row['option_price'],
'option_quantity' => $row['option_quantity'],
'option_type' => $row['option_type'],
'position' => $row['position']
);
}
$options[] = array(
'option_id' => $product_options['option_id'],
'option_name' => $product_options['option_name'],
'position' => $product_options['position'],
'option_values' => $option_values
);
}
if (isset($options))
return $options;
}
/**
* Get product images
*
* @access public
*/
public function get_product_images($product_id) {
$product_id = filter_var($product_id, FILTER_SANITIZE_NUMBER_INT);
$images = array();
foreach ($this->db->query("SELECT * FROM " . self::$config['table_product_images'] . " WHERE product_id = '" . $product_id . "'") as $row) {
$images[] = array(
'image_id' => $row['image_id'],
'image' => $row['image'],
'thumbnail' => $row['thumbnail']
);
}
if (isset($images))
return $images;
}
/**
* Get products
*
* @access public
*/
public function get_products($category_id) {
$category_id = filter_var($category_id, FILTER_SANITIZE_NUMBER_INT);
foreach ($this->db->query("SELECT * FROM " . self::$config['table_products'] . " p, " . self::$config['table_category_products'] . " cp WHERE p.product_id = cp.product_id AND cp.category_id = '" . $category_id . "'") as $row) {
$products[] = array(
'product_id' => $row['product_id'],
'product_name' => $row['product_name'],
'product_description' => $row['product_description'],
'product_image' => $row['product_image'],
'product_thumbnail' => $row['product_thumbnail'],
'product_price' => $row['product_price']
);
}
if (isset($products))
return $products;
}
/**
* Get categories
*
* @access public
*/
public function get_categories($category_id = 0) {
$category_id = filter_var($category_id, FILTER_SANITIZE_NUMBER_INT);
$categories = array();
foreach ($this->db->query("SELECT * FROM " . self::$config['table_categories'] . " WHERE parent_id = '" . $category_id . "' AND category_status = 1 ORDER BY category_name ASC") as $row) {
$categories[] = array(
'category_id' => $row['category_id'],
'category_name' => $row['category_name']
);
}
return $categories;
}
/**
* Get category
*
* @access public
*/
public function get_category($category_id) {
$category_id = filter_var($category_id, FILTER_SANITIZE_NUMBER_INT);
foreach ($this->db->query("SELECT * FROM " . self::$config['table_categories'] . " WHERE category_id = '" . $category_id . "'") as $row) {
$category = array(
'category_id' => $row['category_id'],
'category_name' => $row['category_name']
);
}
if (isset($category))
return $category;
}
/**
* Has shipping
*
* @access public
*/
public function has_shipping() {
$shipping = false;
foreach ($this->get_cart() as $product) {
if ($product['shipping']) {
$shipping = true;
break;
}
}
return $shipping;
}
/**
* Update cart
*
* @access public
*/
public function update_cart($cart_id, $product_id, $quantity) {
for ($i = 0; $i < count($quantity); $i++) {
$sql = "SELECT product_id, product_name, product_quantity FROM " . self::$config['table_products'] . " WHERE product_id = '" . $product_id[$i] . "'";
if ($this->db->row_count($sql)) {
$result = $this->db->fetch_row_assoc($sql);
if ($result['product_quantity'] == 0) {
$this->error->set_error('The ' . $result['product_name'] . ' product is no in stock.');
} else {
if ($quantity[$i] < 1) {
$where = array(
'product_id' => $product_id[$i]
);
$this->db->where($where);
$this->db->delete(self::$config['table_carts']);
} else {
$new_quantity = $quantity[$i];
$cart = $this->db->fetch_row_assoc("SELECT product_quantity, options FROM " . self::$config['table_carts'] . " WHERE product_id = '" . $product_id[$i] . "' AND cart_id = '" . $cart_id[$i] . "' AND cart_session = '" . $this->session->get('cart_session') . "'");
if (!$cart['options']) {
if ($quantity[$i] > $result['product_quantity']) {
$new_quantity = $result['product_quantity'];
$this->error->set_error('The quantity you have requested for ' . $result['product_name'] . ' is more than that into stock.');
}
} else {
$data = explode(':', $cart['options']);
foreach ($data as $value) {
$product_options = $this->db->fetch_row_assoc("SELECT option_value, option_quantity FROM " . self::$config['table_product_option_values'] . " WHERE option_value_id = '" . $value . "'");
if ($quantity[$i] > $product_options['option_quantity']) {
$new_quantity = $cart['product_quantity'];
$this->error->set_error('The quantity you have requested for ' . $result['product_name'] . ' ' . $product_options['option_value'] . ' is more than that into stock.');
}
}
}
$values = array(
'product_quantity' => $new_quantity
);
$where = array(
'cart_session' => $this->session->get('cart_session'),
'product_id' => $product_id[$i]
);
if ($cart['options'])
$where['options'] = $cart['options'];
$this->db->where($where);
$this->db->update(self::$config['table_carts'], $values);
}
}
} else {
$this->error->set_error('Sorry but the product is no longer in stock.');
}
}
}
/**
* Check coupon
*
* @access public
*/
public function check_coupon($coupon_code) {
$sql = "SELECT coupon_id FROM " . self::$config['table_coupons'] . " WHERE coupon_code = '" . $coupon_code . "' AND date_start < CURDATE() AND date_end > CURDATE() AND coupon_status = 1";
if ($this->db->row_count($sql)) {
$result = $this->db->fetch_row_assoc($sql);
$this->session->set('coupon_id', $result['coupon_id']);
} else {
$this->error->set_error('Coupon error.');
}
}
/**
* Get coupon
*
* @access public
*/
public function get_coupon($coupon_id) {
$subtotal = 0;
foreach ($this->db->query("SELECT p.product_price, c.product_quantity, c.cart_id FROM " . self::$config['table_products'] . " p, " . self::$config['table_carts'] . " c WHERE p.product_id = c.product_id AND c.cart_session = '" . $this->session->get('cart_session') . "'") as $row) {
$option_price = 0;
foreach ($this->db->query("SELECT * FROM " . self::$config['table_carts'] . " WHERE cart_id = '" . $row['cart_id'] . "'") as $product_options) {
$data = explode(':', $product_options['options']);
foreach ($data as $value) {
$option_values = $this->db->fetch_row_assoc("SELECT option_price, option_type FROM " . self::$config['table_product_option_values'] . " WHERE option_value_id = '" . $value . "'");
if ($option_values['option_type'] == '+')
$option_price = $option_price + $option_values['option_price'];
elseif ($option_values['option_type'] == '-')
$option_price = $option_price - $option_values['option_price'];
}
}
$subtotal += ($row['product_price'] + $option_price) * $row['product_quantity'];
}
foreach ($this->db->query("SELECT * FROM " . self::$config['table_coupons'] . " WHERE coupon_id = '" . $coupon_id . "'") as $row) {
if ($row['coupon_type'] == 'F')
$coupon_discount = $row['coupon_discount'];
elseif ($row['coupon_type'] == 'P')
$coupon_discount = ($subtotal * $row['coupon_discount'] / 100);
$details[] = array(
'coupon_name' => $row['coupon_name'],
'coupon_discount' => $coupon_discount
);
}
if (isset($details))
return $details;
}
/**
* Checkout
*
* @access public
*/
public function checkout($user_id, $user_email, $comment) {
$result = $this->db->fetch_row_assoc("SELECT * FROM " . self::$config['table_customers'] . " customer, " . self::$config['table_addresses'] . " address, " . self::$config['table_countries'] . " countries WHERE customer.user_id = '" . $user_id . "' AND address.country_id = countries.country_id AND address.user_id = '" . $user_id . "'");
$values = array(
'user_id' => $user_id,
'first_name' => $result['first_name'],
'last_name' => $result['last_name'],
'customer_email' => $result['customer_email'],
'customer_telephone' => $result['customer_telephone'],
'shipping_company' => $result['company'],
'shipping_first_name' => $result['first_name'],
'shipping_last_name' => $result['last_name'],
'shipping_address' => $result['address'],
'shipping_post_code' => $result['post_code'],
'shipping_city' => $result['city'],
'shipping_country_id' => $result['country_id'],
'shipping_zone' => $result['zone'],
'shipping_method' => 'Flat Rate',
'payment_company' => $result['company'],
'payment_first_name' => $result['first_name'],
'payment_last_name' => $result['last_name'],
'payment_address' => $result['address'],
'payment_post_code' => $result['post_code'],
'payment_city' => $result['city'],
'payment_country_id' => $result['country_id'],
'payment_zone' => $result['zone'],
'comment' => $comment,
'total' => $this->total(),
'tax_description' => self::$config['tax_description'],
'tax_rate' => self::$config['tax_rate'],
'currency' => self::$config['currency_symbol'],
'order_status_description_id' => '1',
'date_added' => time(),
'ip' => $_SERVER['REMOTE_ADDR']
);
if ($this->has_shipping())
$values['shipping_cost'] = self::$config['shipping_cost'];
else
$values['shipping_cost'] = 0;
if (self::$config['tax_shipping'])
$values['tax_shipping'] = 1;
else
$values['tax_shipping'] = 0;
if ($this->session->get('coupon_id')) {
$counpon_data = $this->db->fetch_row_assoc("SELECT coupon_name, coupon_type, coupon_discount FROM " . self::$config['table_coupons'] . " WHERE coupon_id = '" . $this->session->get('coupon_id') . "'");
$values['coupon_name'] = $counpon_data['coupon_name'];
if ($counpon_data['coupon_type'] == 'F')
$values['coupon_discount'] = $counpon_data['coupon_discount'];
elseif ($counpon_data['coupon_type'] == 'P')
$values['coupon_discount'] = $this->subtotal() * $counpon_data['coupon_discount'] / 100;
}
$this->db->insert(self::$config['table_orders'], $values);
$order_id = $this->db->last_insert_id();
$values = array(
'order_id' => $order_id,
'order_status_description_id' => '1',
'date_added' => time()
);
$this->db->insert(self::$config['table_order_status'], $values);
$values = array();
$values['order_id'] = $order_id;
$values['tax'] = self::$config['tax_rate'];
foreach ($this->db->query("SELECT p.product_id, p.product_name, p.product_price, c.product_quantity, c.custom_image, c.custom_image_2, c.custom_image_3, c.custom_image_4, c.custom_image_5, c.custom_image_6, c.custom_image_7, c.custom_image_8, c.custom_image_9, c.custom_image_10, c.custom_image_11, c.custom_image_12, c.custom_image_13, c.custom_image_14, c.custom_image_15, c.custom_image_16, c.custom_image_17, c.custom_image_18, c.custom_image_19, c.custom_image_20, c.custom_product, c.custom_product_2, c.custom_product_3, c.custom_product_4, c.custom_product_5, c.custom_product_6, c.custom_product_7, c.custom_product_8, c.custom_product_9, c.custom_product_10, c.options FROM " . self::$config['table_products'] . " p, " . self::$config['table_carts'] . " c WHERE p.product_id = c.product_id AND c.cart_session = '" . $this->session->get('cart_session') . "'") as $row) {
$values['product_id'] = $row['product_id'];
$values['product_name'] = $row['product_name'];
$values['product_price'] = $row['product_price'];
$values['product_quantity'] = $row['product_quantity'];
$values['custom_image'] = $row['custom_image'];
$values['custom_image_2'] = $row['custom_image_2'];
$values['custom_image_3'] = $row['custom_image_3'];
$values['custom_image_4'] = $row['custom_image_4'];
$values['custom_image_5'] = $row['custom_image_5'];
$values['custom_image_6'] = $row['custom_image_6'];
$values['custom_image_7'] = $row['custom_image_7'];
$values['custom_image_8'] = $row['custom_image_8'];
$values['custom_image_9'] = $row['custom_image_9'];
$values['custom_image_10'] = $row['custom_image_10'];
$values['custom_image_11'] = $row['custom_image_11'];
$values['custom_image_12'] = $row['custom_image_12'];
$values['custom_image_13'] = $row['custom_image_13'];
$values['custom_image_14'] = $row['custom_image_14'];
$values['custom_image_15'] = $row['custom_image_15'];
$values['custom_image_16'] = $row['custom_image_16'];
$values['custom_image_17'] = $row['custom_image_17'];
$values['custom_image_18'] = $row['custom_image_18'];
$values['custom_image_19'] = $row['custom_image_19'];
$values['custom_image_20'] = $row['custom_image_20'];
$values['custom_product'] = $row['custom_product'];
$values['custom_product_2'] = $row['custom_product_2'];
$values['custom_product_3'] = $row['custom_product_3'];
$values['custom_product_4'] = $row['custom_product_4'];
$values['custom_product_5'] = $row['custom_product_5'];
$values['custom_product_6'] = $row['custom_product_6'];
$values['custom_product_7'] = $row['custom_product_7'];
$values['custom_product_8'] = $row['custom_product_8'];
$values['custom_product_9'] = $row['custom_product_9'];
$values['custom_product_10'] = $row['custom_product_10'];
$values['total'] = ($row['product_price'] * $row['product_quantity']);
$this->db->insert(self::$config['table_order_products'], $values);
if ($row['options']) {
$data = explode(':', $row['options']);
foreach ($data as $value) {
$order_products = $this->db->fetch_row_assoc("SELECT order_product_id FROM order_products ORDER BY order_product_id DESC");
$option_data = $this->db->fetch_row_assoc("SELECT po.option_name, pov.option_value_id, pov.option_value, pov.option_price, pov.option_type FROM " . self::$config['table_product_options'] . " po, " . self::$config['table_product_option_values'] . " pov WHERE po.option_id = pov.option_id AND pov.option_value_id = '" . $value . "'");
$options = array(
'order_id' => $order_id,
'order_product_id' => $order_products['order_product_id'],
'option_value_id' => $option_data['option_value_id'],
'option_name' => $option_data['option_name'],
'option_value' => $option_data['option_value'],
'option_price' => $option_data['option_price'],
'option_type' => $option_data['option_type']
);
$this->db->insert(self::$config['table_order_options'], $options);
}
}
}
foreach ($this->db->query("SELECT dg.*, c.product_id FROM " . self::$config['table_digital_goods'] . " dg, " . self::$config['table_carts'] . " c WHERE dg.product_id = c.product_id AND c.cart_session = '" . $this->session->get('cart_session') . "'") as $row) {
$values = array(
'order_id' => $order_id,
'product_id' => $row['product_id'],
'display_filename' => $row['display_filename'],
'filename' => $row['filename'],
'date_added' => time(),
'number_days' => $row['number_days'],
'number_downloadable' => $row['number_downloadable'],
'download_hash' => md5(time())
);
$this->db->insert(self::$config['table_order_digital_goods'], $values);
}
$count = 1;
$checkout = "?cmd=_cart";
$checkout .= "&upload=1";
$checkout .= "&business=" . urlencode(self::$config['paypal_email']);
$checkout .= "&custom=" . urlencode($order_id);
$checkout .= "¤cy_code=" . urlencode(self::$config['currency_code']);
$checkout .= "&country=" . urlencode($result['iso_code_2']);
$checkout .= "&return=" . urlencode(self::$config['paypal_return']);
$checkout .= "&cancel_return=" . urlencode(self::$config['paypal_cancel_return']);
$checkout .= "¬ify_url=" . urlencode(self::$config['paypal_notify_url']);
if (self::$config['tax_shipping'])
$checkout .= "&tax_cart=" . urlencode(number_format(($this->subtotal() + self::$config['shipping_cost']) * self::$config['tax_rate'] / 100, 2, '.', ','));
else
$checkout .= "&tax_cart=" . urlencode(number_format($this->subtotal() * self::$config['tax_rate'] / 100, 2, '.', ','));
if ($this->session->get('coupon_id')) {
foreach ($this->get_coupon($this->session->get('coupon_id')) as $value)
$checkout .= "&discount_amount_cart=" . urlencode(number_format($value['coupon_discount'], 2, '.', ','));
}
if ($this->has_shipping())
$checkout .= "&shipping_1=" . urlencode(number_format(self::$config['shipping_cost'], 2, '.', ','));
foreach ($this->get_cart() as $value) {
$result = $this->db->fetch_row_assoc("SELECT product_quantity FROM " . self::$config['table_products'] . " WHERE product_id = '" . $value['product_id'] . "'");
if (!empty($value['options'][0]['option_value_id'])) {
foreach ($value['options'] as $option) {
$values = array(
'product_quantity' => $option['option_quantity'] - $value['product_quantity']
);
}
} else {
$values = array(
'product_quantity' => $result['product_quantity'] - $value['product_quantity']
);
}
$where = array(
'product_id' => $value['product_id']
);
$this->db->where($where);
$this->db->update(self::$config['table_products'], $values);
$i = 0;
foreach ($value['options'] as $option) {
$values = array(
'option_quantity' => $option['option_quantity'] - $value['product_quantity']
);
$where = array(
'option_value_id' => $option['option_value_id']
);
$this->db->where($where);
$this->db->update(self::$config['table_product_option_values'], $values);
$checkout .= "&on" . $i . "_" . $count . "=" . urlencode($option['option_name']);
$checkout .= "&os" . $i . "_" . $count . "=" . urlencode($option['option_value']);
$i++;
}
$checkout .= "&item_number_" . $count . "=" . urlencode($value['product_id']);
$checkout .= "&item_name_" . $count . "=" . urlencode($value['product_name']);
$checkout .= "&amount_" . $count . "=" . urlencode(number_format($value['product_price'], 2, '.', ','));
$checkout .= "&quantity_" . $count . "=" . urlencode($value['product_quantity']);
$count++;
}
$result = $this->db->fetch_row_assoc("SELECT * FROM " . self::$config['table_customers'] . " customer, " . self::$config['table_addresses'] . " address, " . self::$config['table_countries'] . " countries WHERE customer.user_id = '" . $user_id . "' AND address.country_id = countries.country_id AND address.user_id = '" . $user_id . "'");
$message = file_get_contents(self::$config['email_templates'] . self::$config['email_order']);
$message = str_replace('%%ORDER_ID%%', $order_id, $message);
$message = str_replace('%%DATE%%', strftime("%A %d %B %Y"), $message);
