Post by cagbaazee » Wed Feb 13, 2013 7:22 pm

After study this at https://github.com/opencart/opencart/co ... a5e1e85702

But i found some error problem

Notice: Undefined variable: product_data in /home/rapbaycx/public_html/eshoppy.org/opencart/catalog/model/checkout/coupon.php on line 68Notice: Undefined variable: product_data in /home/rapbaycx/public_html/eshoppy.org/opencart/catalog/model/checkout/coupon.php on line 68Notice: Undefined variable: product_data in /home/rapbaycx/public_html/eshoppy.org/opencart/catalog/model/checkout/coupon.php on line 68



The coupon.php file as below
<?php
class ModelCheckoutCoupon extends Model {
public function getCoupon($code) {
$status = true;

$coupon_query = $this->db->query("SELECT * FROM `" . DB_PREFIX . "coupon` WHERE code = '" . $this->db->escape($code) . "' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) AND status = '1'");

if ($coupon_query->num_rows) {
if ($coupon_query->row['total'] >= $this->cart->getSubTotal()) {
$status = false;
}

$coupon_history_query = $this->db->query("SELECT COUNT(*) AS total FROM `" . DB_PREFIX . "coupon_history` ch WHERE ch.coupon_id = '" . (int)$coupon_query->row['coupon_id'] . "'");

if ($coupon_query->row['uses_total'] > 0 && ($coupon_history_query->row['total'] >= $coupon_query->row['uses_total'])) {
$status = false;
}

if ($coupon_query->row['logged'] && !$this->customer->getId()) {
$status = false;
}

if ($this->customer->getId()) {
$coupon_history_query = $this->db->query("SELECT COUNT(*) AS total FROM `" . DB_PREFIX . "coupon_history` ch WHERE ch.coupon_id = '" . (int)$coupon_query->row['coupon_id'] . "' AND ch.customer_id = '" . (int)$this->customer->getId() . "'");

if ($coupon_query->row['uses_customer'] > 0 && ($coupon_history_query->row['total'] >= $coupon_query->row['uses_customer'])) {
$status = false;
}
}

// Products
$coupon_product_data = array();

$coupon_product_query = $this->db->query("SELECT * FROM `" . DB_PREFIX . "coupon_product` WHERE coupon_id = '" . (int)$coupon_query->row['coupon_id'] . "'");

foreach ($coupon_product_query->rows as $product) {
$coupon_product_data[] = $product['product_id'];
}

// Categories
$coupon_category_data = array();

$coupon_category_query = $this->db->query("SELECT * FROM `" . DB_PREFIX . "coupon_category` cc LEFT JOIN `" . DB_PREFIX . "category_path` cp ON (cc.category_id = cp.path_id) WHERE cc.coupon_id = '" . (int)$coupon_query->row['coupon_id'] . "'");

foreach ($coupon_category_query->rows as $category) {
$coupon_category_data[] = $category['category_id'];
}

if ($coupon_product_data || $coupon_category_data) {
foreach ($this->cart->getProducts() as $product) {
if (in_array($product['product_id'], $coupon_product_data)) {
$product_data[] = $product['product_id'];

continue;
}

foreach ($coupon_category_data as $category_id) {
$coupon_category_query = $this->db->query("SELECT COUNT(*) AS total FROM `" . DB_PREFIX . "product_to_category` WHERE `product_id` = '" . (int)$product['product_id'] . "' AND category_id = '" . (int)$category_id . "'");

if ($coupon_category_query->row['total']) {
$product_data[] = $product['product_id'];

continue;
}
}
}

if (!$product_data) {
$status = false;
}
}
} else {
$status = false;
}

if ($status) {
return array(
'coupon_id' => $coupon_query->row['coupon_id'],
'code' => $coupon_query->row['code'],
'name' => $coupon_query->row['name'],
'type' => $coupon_query->row['type'],
'discount' => $coupon_query->row['discount'],
'shipping' => $coupon_query->row['shipping'],
'total' => $coupon_query->row['total'],
'product' => $product_data,
'date_start' => $coupon_query->row['date_start'],
'date_end' => $coupon_query->row['date_end'],
'uses_total' => $coupon_query->row['uses_total'],
'uses_customer' => $coupon_query->row['uses_customer'],
'status' => $coupon_query->row['status'],
'date_added' => $coupon_query->row['date_added']
);
}
}

public function redeem($coupon_id, $order_id, $customer_id, $amount) {
$this->db->query("INSERT INTO `" . DB_PREFIX . "coupon_history` SET coupon_id = '" . (int)$coupon_id . "', order_id = '" . (int)$order_id . "', customer_id = '" . (int)$customer_id . "', amount = '" . (float)$amount . "', date_added = NOW()");
}
}
?>
please help it out.

Thanks

Newbie

Posts

Joined
Wed Feb 13, 2013 1:31 pm

Post by jfer3 » Tue Apr 02, 2013 7:16 am

I am also having the same problem, can someone please advise ?

Web designer at http://www.3rddesign.com. Specializing in Joomla and creative marketing.


New member

Posts

Joined
Tue Mar 05, 2013 2:59 pm
Who is online

Users browsing this forum: No registered users and 6 guests