Showing taxes on pdf invoice

  • Posts: 63
  • Thank you received: 0
9 years 6 months ago #201587

-- url of the page with the problem -- : www.dreamlordpress.it
-- HikaShop version -- : 2.4.0
-- Joomla version -- : 3.4.1

Hi,

I'd like to show the TAX category beside the product name, in the pdf invoice generated, like:

Product name | Unit price | product quantity | price | tax category

How to do that?

Dreamlord Press
www.dreamlordpress.it
Roleplaying Games in the new era

Please Log in or Create an account to join the conversation.

  • Posts: 63
  • Thank you received: 0
9 years 6 months ago #201607

It would be enough for me to access the Tax_category data inside the invoice.
Is there an easy way to get access to it?

Dreamlord Press
www.dreamlordpress.it
Roleplaying Games in the new era

Please Log in or Create an account to join the conversation.

  • Posts: 82863
  • Thank you received: 13372
  • MODERATOR
9 years 6 months ago #201591

Hi,

You'll have to edit the file plugins/hikashop/attachinvoice/attachinvoice/invoice.php in order to modify the PHP code there to add that extra line. It will require some MySQL query to load the tax category from the product_id of each product.

Last edit: 9 years 6 months ago by Xavier.

Please Log in or Create an account to join the conversation.

  • Posts: 63
  • Thank you received: 0
9 years 6 months ago #202097

Perfectly solved, thank you.

Dreamlord Press
www.dreamlordpress.it
Roleplaying Games in the new era

Please Log in or Create an account to join the conversation.

  • Posts: 59
  • Thank you received: 0
9 years 5 months ago #205557

Hi,

could you please tell me the query and where should I have to add it to show tax category as you said?

Regards,

Please Log in or Create an account to join the conversation.

  • Posts: 82863
  • Thank you received: 13372
  • MODERATOR
9 years 5 months ago #205569

The query itself is easy but won't be enough to show the tax category. You will need the code to run the query, process the result, do the display...
The query should be:
SELECT * FROM #__hikashop_order_product WHERE product_id=XXX;
where XXX should be your product_id.
If you're not a developer, I would recommend to find one to help you do it.

Please Log in or Create an account to join the conversation.

  • Posts: 59
  • Thank you received: 0
9 years 5 months ago #205610

Ok thanks for support, I solved with another method. I created a "tax" custom field in table product which is showed in PDF invoice. Is not so "elegant solution" but it works! :)

Please Log in or Create an account to join the conversation.

Time to create page: 0.072 seconds
Powered by Kunena Forum