including Tax an buy-button into modules

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?

Aw: including Tax an buy-button into modules

Look at the product category
Take, by analogy

Aw: including Tax an buy-button into modules

if i insert this code into the template-file

the tax will not be displayed

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)

---

Aw: including Tax an buy-button into modules

there ist no change

Aw: including Tax an buy-button into modules

???

OLD


NEW

---

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

Aw: including Tax an buy-button into modules

Module template
...

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

Aw: including Tax an buy-button into modules

no change, taxrate is always 0%

Aw: including Tax an buy-button into modules

Sorry.
Perhaps you have an error.

Test

---

Aw: including Tax an buy-button into modules

File?

---

Aw: including Tax an buy-button into modules

tables\product.php

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 ) )

Aw: including Tax an buy-button into modules

tax???

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

---

Aw: including Tax an buy-button into modules

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

thx