Showing taxes on pdf invoice

  • Posts: 63
  • Thank you received: 0
10 years 1 month 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
10 years 1 month 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: 84044
  • Thank you received: 13620
  • MODERATOR
10 years 1 month 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: 10 years 1 month ago by Xavier.

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

  • Posts: 63
  • Thank you received: 0
10 years 1 month 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
10 years 2 weeks 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: 84044
  • Thank you received: 13620
  • MODERATOR
10 years 2 weeks 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
10 years 2 weeks 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.076 seconds
Powered by Kunena Forum