including Tax an buy-button into modules

08.11.2010 09:06
#1
papa-chicco
Joomshopping forum user no avatar
Name: Alex
17.10.2010
Posts: 123
Quote
including Tax an buy-button into modules

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:29
#2
webdesigner
(Support Team)
User webdesigner
Name: Admin
05.08.2010
Posts: 16475
Quote
Aw: including Tax an buy-button into modules

Look at the product category
Take, by analogy

 
08.11.2010 09:58
#3
papa-chicco
Joomshopping forum user no avatar
Name: Alex
17.10.2010
Posts: 123
Quote
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
#4
webdesigner
(Support Team)
User webdesigner
Name: Admin
05.08.2010
Posts: 16475
Quote
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;



Letzte Änderung: 08.11.2010 10:17
 
08.11.2010 10:32
#5
papa-chicco
Joomshopping forum user no avatar
Name: Alex
17.10.2010
Posts: 123
Quote
Aw: including Tax an buy-button into modules

there ist no change

 
08.11.2010 10:38
#6
webdesigner
(Support Team)
User webdesigner
Name: Admin
05.08.2010
Posts: 16475
Quote
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;



Letzte Änderung: 08.11.2010 10:39
 
08.11.2010 11:36
#7
papa-chicco
Joomshopping forum user no avatar
Name: Alex
17.10.2010
Posts: 123
Quote
Aw: including Tax an buy-button into modules

also no change

it works if you display the product-details but in the module "latest Product" the tax-rate will not displayed!

please have a look at
http://bio.avp-web.de

i mean the mopdule who's displayed in the middle of my hp

 
08.11.2010 11:56
#8
webdesigner
(Support Team)
User webdesigner
Name: Admin
05.08.2010
Posts: 16475
Quote
Aw: including Tax an buy-button into modules

Module template
...

<span class="taxinfo"><?php print sprintf(_JSHOP_INC_PERCENT_TAX, formattax($curr->tax));?></span>

 
08.11.2010 12:01
#9
papa-chicco
Joomshopping forum user no avatar
Name: Alex
17.10.2010
Posts: 123
Quote
Aw: including Tax an buy-button into modules

no change, taxrate is always 0%

 
08.11.2010 12:16
#10
webdesigner
(Support Team)
User webdesigner
Name: Admin
05.08.2010
Posts: 16475
Quote
Aw: including Tax an buy-button into modules

Sorry.
Perhaps you have an error.

Test

function getLastProducts(
.....
print_r($products);
return $products;



Letzte Änderung: 08.11.2010 12:18
 
08.11.2010 12:19
#11
papa-chicco
Joomshopping forum user no avatar
Name: Alex
17.10.2010
Posts: 123
Quote
Aw: including Tax an buy-button into modules

File?


Letzte Änderung: 08.11.2010 12:22
 
08.11.2010 12:21
#12
webdesigner
(Support Team)
User webdesigner
Name: Admin
05.08.2010
Posts: 16475
Quote
Aw: including Tax an buy-button into modules

tables\product.php

 
08.11.2010 12:31
#13
papa-chicco
Joomshopping forum user no avatar
Name: Alex
17.10.2010
Posts: 123
Quote
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
#14
webdesigner
(Support Team)
User webdesigner
Name: Admin
05.08.2010
Posts: 16475
Quote
Aw: including Tax an buy-button into modules

tax???

..SELECT tax.tax_value as tax, prod.`".$lang->get('name')."` as name, ............


Letzte Änderung: 08.11.2010 12:38
 
08.11.2010 12:45
#15
papa-chicco
Joomshopping forum user no avatar
Name: Alex
17.10.2010
Posts: 123
Quote
Aw: including Tax an buy-button into modules

sorry my mistake, i#ve forgotten to change the query
now it works

thx

 
Copyrights MAXXmarketing GmbH. All Rights Reserved