Community Forums

by **darknefrit** » Sun Aug 14, 2011 3:13 pm

Как сделать несколько цен в одном товаре?
В атрибутах есть только прибавить и вычесть из цены. Как добавить равно ? тоесть выбрал цену и она заменила в корзине основную?

by **darknefrit** » Mon Aug 15, 2011 9:33 am

В шаблоне admin/view/template/catalog/product_form.tpl в 430 строке добавил «=» по аналогии с + и –
там же нхаодим
"html += ' <option value="-">-</option>';" 952 строка
и вставляем
"html += ' <option value="=">=</option>';"

В cart.php добавил
if ($option_value_query->num_rows) {
if ($option_value_query->row['price_prefix'] == '+') {$option_price += $option_value_query->row['price'];
} elseif ($option_value_query->row['price_prefix'] == '-') {$option_price -= $option_value_query->row['price'];
} elseif ($option_value_query->row['price_prefix'] == '=') {$option_price = $option_value_query->row['price'];}

И
добавить
if (!$option_price){$option_price=$price;}
а тут отредакотировать
$product_data[$key] = array( 'key' => $key,
'product_id' => $product_query->row['product_id'],
'name' => $product_query->row['name'],
'model' => $product_query->row['model'],
'shipping' => $product_query->row['shipping'],
'image' => $product_query->row['image'],
'option' => $option_data,
'download' => $download_data,
'quantity' => $quantity,
'minimum' => $product_query->row['minimum'],
'subtract' => $product_query->row['subtract'],
'stock' => $stock,
'price' => ($price + $option_price), заменил на ($option_price),
'total' => ($price + $option_price) * $quantity, заменил на ($option_price) * $quantity,
'reward' => $reward * $quantity,
'points' => ($product_query->row['points'] + $option_points) * $quantity,
'tax_class_id' => $product_query->row['tax_class_id'],
'weight' => ($product_query->row['weight'] + $option_weight) * $quantity,
'weight_class_id' => $product_query->row['weight_class_id'],
'length' => $product_query->row['length'],
'width' => $product_query->row['width'],
'height' => $product_query->row['height'],
'length_class_id' => $product_query->row['length_class_id']

Может ещё что то где то надо делать. Точнее нужно правильно написать условие если + или - в
'price' => ($price + $option_price), заменил на ($option_price),
'total' => ($price + $option_price) * $quantity, заменил на ($option_price) * $quantity,
потому что иначе работает только замена цены

by **over9000** » Sat Oct 29, 2011 8:50 pm

darknefrit wrote:В cart.php добавил

darknefrit wrote:И
добавить

будем очень рады, если объясните что куда именно вставлять =)

by **darknefrit** » Sun Oct 30, 2011 5:00 am

В файле карт cart.php найди
if ($option_value_query->num_rows) {
и добавь строку:
elseif ($option_value_query->row['price_prefix'] == '=') {$option_price = $option_value_query->row['price'];}

после
elseif ($option_value_query->row['price_prefix'] == '-') {$option_price -= $option_value_query->row['price'];

В том же файл найди блок начинающийся с $product_data[$key] = array( 'key' => $key,
'product_id' => $product_query->row['product_id'],

и перед ним добавь условие
if (!$option_price){$option_price=$price;}

а дальше находишь там
'price' => ($price + $option_price), и меняешь на ($option_price),
а это total' => ($price + $option_price) * $quantity, заменил на total' => ($option_price) * $quantity,

by **over9000** » Mon Oct 31, 2011 12:18 pm

блин не получается:

Code: Select all: Parse error: syntax error, unexpected T_ELSE in /var/www/***/data/www/***.ua/system/library/cart.php on line 130

не могли бы вы выложить Ваши product_form.tpl и cart.php ? понимаю, что синт.ошибка, но вроде все по инструкции $:-\$

by **darknefrit** » Mon Oct 31, 2011 2:35 pm

cart.php который в папке system/library

Code: Select all: <?php final class Cart { public function __construct($registry) { $this->config = $registry->get('config'); $this->customer = $registry->get('customer'); $this->session = $registry->get('session'); $this->db = $registry->get('db'); $this->tax = $registry->get('tax'); $this->weight = $registry->get('weight'); if (!isset($this->session->data['cart']) || !is_array($this->session->data['cart'])) { $this->session->data['cart'] = array(); } } public function getProducts() { $product_data = array(); foreach ($this->session->data['cart'] as $key => $quantity) { $product = explode(':', $key); $product_id = $product[0]; $stock = true; // Options if (isset($product[1])) { $options = unserialize(base64_decode($product[1])); } else { $options = array(); } $product_query = $this->db->query("SELECT * FROM " . DB_PREFIX . "product p LEFT JOIN " . DB_PREFIX . "product_description pd ON (p.product_id = pd.product_id) WHERE p.product_id = '" . (int)$product_id . "' AND pd.language_id = '" . (int)$this->config->get('config_language_id') . "' AND p.date_available <= NOW() AND p.status = '1'"); if ($product_query->num_rows) { $option_price = 0; $option_points = 0; $option_weight = 0; $option_data = array(); foreach ($options as $product_option_id => $option_value) { $option_query = $this->db->query("SELECT po.product_option_id, po.option_id, od.name, o.type FROM " . DB_PREFIX . "product_option po LEFT JOIN `" . DB_PREFIX . "option` o ON (po.option_id = o.option_id) LEFT JOIN " . DB_PREFIX . "option_description od ON (o.option_id = od.option_id) WHERE po.product_option_id = '" . (int)$product_option_id . "' AND po.product_id = '" . (int)$product_id . "' AND od.language_id = '" . (int)$this->config->get('config_language_id') . "'"); if ($option_query->num_rows) { if ($option_query->row['type'] == 'select' || $option_query->row['type'] == 'radio') { $option_value_query = $this->db->query("SELECT pov.option_value_id, ovd.name, pov.quantity, pov.subtract, pov.price, pov.price_prefix, pov.points, pov.points_prefix, pov.weight, pov.weight_prefix FROM " . DB_PREFIX . "product_option_value pov LEFT JOIN " . DB_PREFIX . "option_value ov ON (pov.option_value_id = ov.option_value_id) LEFT JOIN " . DB_PREFIX . "option_value_description ovd ON (ov.option_value_id = ovd.option_value_id) WHERE pov.product_option_value_id = '" . (int)$option_value . "' AND pov.product_option_id = '" . (int)$product_option_id . "' AND ovd.language_id = '" . (int)$this->config->get('config_language_id') . "'"); if ($option_value_query->num_rows) { if ($option_value_query->row['price_prefix'] == '+') { $option_price += $option_value_query->row['price']; } elseif ($option_value_query->row['price_prefix'] == '-') { $option_price -= $option_value_query->row['price']; } elseif ($option_value_query->row['price_prefix'] == '=') { $option_price = $option_value_query->row['price'];} if ($option_value_query->row['points_prefix'] == '+') { $option_points += $option_value_query->row['points']; } elseif ($option_value_query->row['points_prefix'] == '-') { $option_points -= $option_value_query->row['points']; } if ($option_value_query->row['weight_prefix'] == '+') { $option_weight += $option_value_query->row['weight']; } elseif ($option_value_query->row['weight_prefix'] == '-') { $option_weight -= $option_value_query->row['weight']; } if ($option_value_query->row['subtract'] && (!$option_value_query->row['quantity'] || ($option_value_query->row['quantity'] < $quantity))) { $stock = false; } $option_data[] = array( 'product_option_id' => $product_option_id, 'product_option_value_id' => $option_value, 'option_id' => $option_query->row['option_id'], 'option_value_id' => $option_value_query->row['option_value_id'], 'name' => $option_query->row['name'], 'option_value' => $option_value_query->row['name'], 'type' => $option_query->row['type'], 'quantity' => $option_value_query->row['quantity'], 'subtract' => $option_value_query->row['subtract'], 'price' => $option_value_query->row['price'], 'price_prefix' => $option_value_query->row['price_prefix'], 'points' => $option_value_query->row['points'], 'points_prefix' => $option_value_query->row['points_prefix'], 'weight' => $option_value_query->row['weight'], 'weight_prefix' => $option_value_query->row['weight_prefix'] ); } } elseif ($option_query->row['type'] == 'checkbox' && is_array($option_value)) { foreach ($option_value as $product_option_value_id) { $option_value_query = $this->db->query("SELECT pov.option_value_id, ovd.name, pov.quantity, pov.subtract, pov.price, pov.price_prefix, pov.points, pov.points_prefix, pov.weight, pov.weight_prefix FROM " . DB_PREFIX . "product_option_value pov LEFT JOIN " . DB_PREFIX . "option_value ov ON (pov.option_value_id = ov.option_value_id) LEFT JOIN " . DB_PREFIX . "option_value_description ovd ON (ov.option_value_id = ovd.option_value_id) WHERE pov.product_option_value_id = '" . (int)$product_option_value_id . "' AND pov.product_option_id = '" . (int)$product_option_id . "' AND ovd.language_id = '" . (int)$this->config->get('config_language_id') . "'"); if ($option_value_query->num_rows) { if ($option_value_query->row['price_prefix'] == '+') { $option_price += $option_value_query->row['price']; } elseif ($option_value_query->row['price_prefix'] == '-') { $option_price -= $option_value_query->row['price']; } elseif ($option_value_query->row['price_prefix'] == '=') { $option_price = $option_value_query->row['price'];} if ($option_value_query->row['points_prefix'] == '+') { $option_points += $option_value_query->row['points']; } elseif ($option_value_query->row['points_prefix'] == '-') { $option_points -= $option_value_query->row['points']; } if ($option_value_query->row['weight_prefix'] == '+') { $option_weight += $option_value_query->row['weight']; } elseif ($option_value_query->row['weight_prefix'] == '-') { $option_weight -= $option_value_query->row['weight']; } if ($option_value_query->row['subtract'] && (!$option_value_query->row['quantity'] || ($option_value_query->row['quantity'] < $quantity))) { $stock = false; } $option_data[] = array( 'product_option_id' => $product_option_id, 'product_option_value_id' => $product_option_value_id, 'option_id' => $option_query->row['option_id'], 'option_value_id' => $option_value_query->row['option_value_id'], 'name' => $option_query->row['name'], 'option_value' => $option_value_query->row['name'], 'type' => $option_query->row['type'], 'quantity' => $option_value_query->row['quantity'], 'subtract' => $option_value_query->row['subtract'], 'price' => $option_value_query->row['price'], 'price_prefix' => $option_value_query->row['price_prefix'], 'points' => $option_value_query->row['points'], 'points_prefix' => $option_value_query->row['points_prefix'], 'weight' => $option_value_query->row['weight'], 'weight_prefix' => $option_value_query->row['weight_prefix'] ); } } } elseif ($option_query->row['type'] == 'text' || $option_query->row['type'] == 'textarea' || $option_query->row['type'] == 'file' || $option_query->row['type'] == 'date' || $option_query->row['type'] == 'datetime' || $option_query->row['type'] == 'time') { $option_data[] = array( 'product_option_id' => $product_option_id, 'product_option_value_id' => '', 'option_id' => $option_query->row['option_id'], 'option_value_id' => '', 'name' => $option_query->row['name'], 'option_value' => $option_value, 'type' => $option_query->row['type'], 'quantity' => '', 'subtract' => '', 'price' => '', 'price_prefix' => '', 'points' => '', 'points_prefix' => '', 'weight' => '', 'weight_prefix' => '' ); } } } if ($this->customer->isLogged()) { $customer_group_id = $this->customer->getCustomerGroupId(); } else { $customer_group_id = $this->config->get('config_customer_group_id'); } $price = $product_query->row['price']; // Product Discounts $discount_quantity = 0; foreach ($this->session->data['cart'] as $key_2 => $quantity_2) { $product_2 = explode(':', $key_2); if ($product_2[0] == $product_id) { $discount_quantity += $quantity_2; } } $product_discount_query = $this->db->query("SELECT price FROM " . DB_PREFIX . "product_discount WHERE product_id = '" . (int)$product_id . "' AND customer_group_id = '" . (int)$customer_group_id . "' AND quantity <= '" . (int)$discount_quantity . "' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY quantity DESC, priority ASC, price ASC LIMIT 1"); if ($product_discount_query->num_rows) { $price = $product_discount_query->row['price']; } // Product Specials $product_special_query = $this->db->query("SELECT price FROM " . DB_PREFIX . "product_special WHERE product_id = '" . (int)$product_id . "' AND customer_group_id = '" . (int)$customer_group_id . "' AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY priority ASC, price ASC LIMIT 1"); if ($product_special_query->num_rows) { $price = $product_special_query->row['price']; } // Reward Points $query = $this->db->query("SELECT points FROM " . DB_PREFIX . "product_reward WHERE product_id = '" . (int)$product_id . "' AND customer_group_id = '" . (int)$customer_group_id . "'"); if ($query->num_rows) { $reward = $query->row['points']; } else { $reward = 0; } // Downloads $download_data = array(); $download_query = $this->db->query("SELECT * FROM " . DB_PREFIX . "product_to_download p2d LEFT JOIN " . DB_PREFIX . "download d ON (p2d.download_id = d.download_id) LEFT JOIN " . DB_PREFIX . "download_description dd ON (d.download_id = dd.download_id) WHERE p2d.product_id = '" . (int)$product_id . "' AND dd.language_id = '" . (int)$this->config->get('config_language_id') . "'"); foreach ($download_query->rows as $download) { $download_data[] = array( 'download_id' => $download['download_id'], 'name' => $download['name'], 'filename' => $download['filename'], 'mask' => $download['mask'], 'remaining' => $download['remaining'] ); } // Stock if (!$product_query->row['quantity'] || ($product_query->row['quantity'] < $quantity)) { $stock = false; } if (!$option_price){$option_price=$price;} $product_data[$key] = array( 'key' => $key, 'product_id' => $product_query->row['product_id'], 'name' => $product_query->row['name'], 'model' => $product_query->row['model'], 'shipping' => $product_query->row['shipping'], 'image' => $product_query->row['image'], 'option' => $option_data, 'download' => $download_data, 'quantity' => $quantity, 'minimum' => $product_query->row['minimum'], 'subtract' => $product_query->row['subtract'], 'stock' => $stock, 'price' => ($option_price), 'total' => ($option_price) * $quantity, 'reward' => $reward * $quantity, 'points' => ($product_query->row['points'] + $option_points) * $quantity, 'tax_class_id' => $product_query->row['tax_class_id'], 'weight' => ($product_query->row['weight'] + $option_weight) * $quantity, 'weight_class_id' => $product_query->row['weight_class_id'], 'length' => $product_query->row['length'], 'width' => $product_query->row['width'], 'height' => $product_query->row['height'], 'length_class_id' => $product_query->row['length_class_id'] ); } else { $this->remove($key); } } return $product_data; } public function add($product_id, $qty = 1, $options = array()) { if (!$options) { $key = (int)$product_id; } else { $key = (int)$product_id . ':' . base64_encode(serialize($options)); } if ((int)$qty && ((int)$qty > 0)) { if (!isset($this->session->data['cart'][$key])) { $this->session->data['cart'][$key] = (int)$qty; } else { $this->session->data['cart'][$key] += (int)$qty; } } } public function update($key, $qty) { if ((int)$qty && ((int)$qty > 0)) { $this->session->data['cart'][$key] = (int)$qty; } else { $this->remove($key); } } public function remove($key) { if (isset($this->session->data['cart'][$key])) { unset($this->session->data['cart'][$key]); } } public function clear() { $this->session->data['cart'] = array(); } public function getWeight() { $weight = 0; foreach ($this->getProducts() as $product) { if ($product['shipping']) { $weight += $this->weight->convert($product['weight'], $product['weight_class_id'], $this->config->get('config_weight_class_id')); } } return $weight; } public function getSubTotal() { $total = 0; foreach ($this->getProducts() as $product) { $total += $product['total']; } return $total; } public function getTaxes() { $taxes = array(); foreach ($this->getProducts() as $product) { if ($product['tax_class_id']) { if (!isset($taxes[$product['tax_class_id']])) { $taxes[$product['tax_class_id']] = $product['total'] / 100 * $this->tax->getRate($product['tax_class_id']); } else { $taxes[$product['tax_class_id']] += $product['total'] / 100 * $this->tax->getRate($product['tax_class_id']); } } } return $taxes; } public function getTotal() { $total = 0; foreach ($this->getProducts() as $product) { $total += $this->tax->calculate($product['total'], $product['tax_class_id'], $this->config->get('config_tax')); } return $total; } public function getTotalRewardPoints() { $total = 0; foreach ($this->getProducts() as $product) { $total += $product['reward']; } return $total; } public function countProducts() { $product_total = 0; $products = $this->getProducts(); foreach ($products as $product) { $product_total += $product['quantity']; } return $product_total; } public function hasProducts() { return count($this->session->data['cart']); } public function hasStock() { $stock = true; foreach ($this->getProducts() as $product) { if (!$product['stock']) { $stock = false; } } return $stock; } public function hasShipping() { $shipping = false; foreach ($this->getProducts() as $product) { if ($product['shipping']) { $shipping = true; break; } } return $shipping; } public function hasDownload() { $download = false; foreach ($this->getProducts() as $product) { if ($product['download']) { $download = true; break; } } return $download; } } ?>

Вот а вообще я как бы ушол с opencart бесить начал

by **over9000** » Mon Oct 31, 2011 11:39 pm

Огромное спасибо!

Извиняюсь за настойчивость, но вот здесь не совсем ясно:

Code: Select all: <select name="product_option[<?php echo $option_row; ?>][product_option_value][<?php echo $option_value_row; ?>][prefix]"> <?php if ($product_option_value['prefix'] != '-') { ?> <option value="+" selected="selected"><?php echo $text_plus; ?></option> <option value="-"><?php echo $text_minus; ?></option> <?php } else { ?> <option value="+"><?php echo $text_plus; ?></option> <option value="-" selected="selected"><?php echo $text_minus; ?></option> <?php } ?> </select>

что ставить вместо

Code: Select all: <?php echo $text_plus; ?>

и

Code: Select all: <?php echo $text_minus; ?>

в третьем случае?

P.S.: А на что перешли, если не секрет?

by **partizzzzzan** » Thu Nov 17, 2011 9:41 pm

Кстати перевел на OC 1.5.1.3 возник глюк в cart.php

by **partizzzzzan** » Thu Nov 17, 2011 9:42 pm

Кстати было классно на для vqmod сделать доп!

by **Serhiy** » Thu Dec 29, 2011 5:23 pm

darknefrit не вые****йся і повертайся на opencart

by **darknefrit** » Thu Feb 02, 2012 7:45 am

over9000 wrote:Огромное спасибо!

Извиняюсь за настойчивость, но вот здесь не совсем ясно:
Code: Select all
<select name="product_option[<?php echo $option_row; ?>][product_option_value][<?php echo $option_value_row; ?>][prefix]"> <?php if ($product_option_value['prefix'] != '-') { ?> <option value="+" selected="selected"><?php echo $text_plus; ?></option> <option value="-"><?php echo $text_minus; ?></option> <?php } else { ?> <option value="+"><?php echo $text_plus; ?></option> <option value="-" selected="selected"><?php echo $text_minus; ?></option> <?php } ?> </select>

что ставить вместо
Code: Select all
<?php echo $text_plus; ?>
и
Code: Select all
<?php echo $text_minus; ?>
в третьем случае?
это где?:))) я к сожалению не смогу помочь, потому опенкарт удалил, а вообщемто в php полный ноль )
P.S.: А на что перешли, если не секрет?