hello,
how can i include the german taxinfo and a picture for the basket (button lets buy) into the modules
latest products
and
bestseller products?
08.11.2010 09:06
|
|
papa-chicco
Name: Alex
17.10.2010
Сообщения: 123
|
|
08.11.2010 09:29
|
|
admin
(Support Team) Name: Admin
05.08.2010
Сообщения: 25936
|
|
08.11.2010 09:58
|
|
papa-chicco
Name: Alex
17.10.2010
Сообщения: 123
|
Aw: including Tax an buy-button into modules
if i insert this code into the template-file <?php if ($this->config->show_tax_in_product){?> <span class="taxinfo"><?php print sprintf(_JSHOP_INC_PERCENT_TAX, formattax($product->tax));?></span> <?php }?> <?php if ($this->config->show_plus_shipping_in_product){?> <span class="plusshippinginfo"><?php print sprintf(_JSHOP_PLUS_SHIPPING, $this->shippinginfo);?></span> <?php }?> the tax will not be displayed |
08.11.2010 10:17
|
|
admin
(Support Team) Name: Admin
05.08.2010
Сообщения: 25936
|
Aw: including Tax an buy-button into modules
Please add tax to Mysql Query (file tables\product.php) LEFT JOIN `#__jshopping_taxes` AS tax ON tax.tax_id = prod.product_tax_id example (getLastProducts) $query = "SELECT tax.tax_value as tax, prod.`".$lang->get('name')."` as name, prod.`".$lang->get('short_description')."` as short_description, prod.product_id, prod.product_ean, prod.product_url, prod.product_thumb_image, prod.product_full_image, pr_cat.category_id, (prod.product_price*".$jshopConfig->currency_value.") AS product_price, product_is_add_price FROM `#__jshopping_products` AS prod INNER JOIN `#__jshopping_products_to_categories` AS pr_cat ON pr_cat.product_id = prod.product_id LEFT JOIN `#__jshopping_categories` AS cat ON pr_cat.category_id = cat.category_id LEFT JOIN `#__jshopping_taxes` AS tax ON tax.tax_id = prod.product_tax_id WHERE prod.product_publish = '1' AND cat.category_publish='1' " . $where_add . " GROUP BY prod.product_id ORDER BY " . $order_add . " LIMIT " . $count;
Последнее изменение: 08.11.2010 10:17
|
08.11.2010 10:32
|
|
papa-chicco
Name: Alex
17.10.2010
Сообщения: 123
|
|
08.11.2010 10:38
|
|
admin
(Support Team) Name: Admin
05.08.2010
Сообщения: 25936
|
Aw: including Tax an buy-button into modules
??? OLD $query = "SELECT prod.`".$lang->get('name')."` as name, prod.`".$lang->get('short_description')."` as short_description, prod.product_id, prod.product_ean, prod.product_url, prod.product_thumb_image, prod.product_full_image, pr_cat.category_id, (prod.product_price*".$jshopConfig->currency_value.") AS product_price, product_is_add_price FROM `#__jshopping_products` AS prod INNER JOIN `#__jshopping_products_to_categories` AS pr_cat ON pr_cat.product_id = prod.product_id WHERE prod.product_publish = '1'" . $where_add . " GROUP BY prod.product_id ORDER BY " . $order_add . " LIMIT " . $count; NEW $query = "SELECT tax.tax_value as tax, prod.`".$lang->get('name')."` as name, prod.`".$lang->get('short_description')."` as short_description, prod.product_id, prod.product_ean, prod.product_url, prod.product_thumb_image, prod.product_full_image, pr_cat.category_id, (prod.product_price*".$jshopConfig->currency_value.") AS product_price, product_is_add_price FROM `#__jshopping_products` AS prod INNER JOIN `#__jshopping_products_to_categories` AS pr_cat ON pr_cat.product_id = prod.product_id LEFT JOIN `#__jshopping_categories` AS cat ON pr_cat.category_id = cat.category_id LEFT JOIN `#__jshopping_taxes` AS tax ON tax.tax_id = prod.product_tax_id WHERE prod.product_publish = '1' AND cat.category_publish='1' " . $where_add . " GROUP BY prod.product_id ORDER BY " . $order_add . " LIMIT " . $count;
Последнее изменение: 08.11.2010 10:39
|
08.11.2010 11:36
|
|
papa-chicco
Name: Alex
17.10.2010
Сообщения: 123
|
|
08.11.2010 11:56
|
|
admin
(Support Team) Name: Admin
05.08.2010
Сообщения: 25936
|
|
08.11.2010 12:01
|
|
papa-chicco
Name: Alex
17.10.2010
Сообщения: 123
|
|
08.11.2010 12:16
|
|
admin
(Support Team) Name: Admin
05.08.2010
Сообщения: 25936
|
|
08.11.2010 12:19
|
|
papa-chicco
Name: Alex
17.10.2010
Сообщения: 123
|
|
08.11.2010 12:21
|
|
admin
(Support Team) Name: Admin
05.08.2010
Сообщения: 25936
|
|
08.11.2010 12:31
|
|
papa-chicco
Name: Alex
17.10.2010
Сообщения: 123
|
Aw: including Tax an buy-button into modules
Array ( [0] => stdClass Object ( [name] => deo for man 100 ml [short_description] => Intimpflege [product_id] => 1 [product_ean] => [product_url] => [product_thumb_image] => [product_full_image] => [category_id] => 4 [product_price] => 12.9 [product_is_add_price] => 0 ) [1] => stdClass Object ( [name] => Intim for man 100 ml [short_description] => Intimpflege [product_id] => 2 [product_ean] => [product_url] => [product_thumb_image] => [product_full_image] => [category_id] => 1 [product_price] => 19.9 [product_is_add_price] => 0 ) [2] => stdClass Object ( [name] => Intim for man 100 ml [short_description] => Intimpflege [product_id] => 3 [product_ean] => [product_url] => [product_thumb_image] => [product_full_image] => [category_id] => 1 [product_price] => 19.9 [product_is_add_price] => 0 ) [3] => stdClass Object ( [name] => Intim for man 100 ml [short_description] => Intimpflege [product_id] => 4 [product_ean] => [product_url] => [product_thumb_image] => [product_full_image] => [category_id] => 1 [product_price] => 19.9 [product_is_add_price] => 0 ) [4] => stdClass Object ( [name] => Intim for man 100 ml [short_description] => Intimpflege [product_id] => 5 [product_ean] => [product_url] => [product_thumb_image] => [product_full_image] => [category_id] => 1 [product_price] => 19.9 [product_is_add_price] => 0 ) [5] => stdClass Object ( [name] => deo for man 100 ml [short_description] => Intimpflege [product_id] => 6 [product_ean] => [product_url] => [product_thumb_image] => [product_full_image] => [category_id] => 4 [product_price] => 12.9 [product_is_add_price] => 0 ) ) |
08.11.2010 12:38
|
|
admin
(Support Team) Name: Admin
05.08.2010
Сообщения: 25936
|
|
08.11.2010 12:45
|
|
papa-chicco
Name: Alex
17.10.2010
Сообщения: 123
|
|