Page 1 of 1
Need a query for payment method!
Posted: 13 Jul 2008, 14:52
by Majino
Hi... and really thanks for your add on! I need an extra field, because i need to show in the invoice the payment method (paypal, ecc ecc) ... but i really don't know where can i get it! i want to show it in the footer... so... can you guys help me? thanks a lot! bye!
Re: Need a query for payment method!
Posted: 13 Jul 2008, 20:56
by Jan
Hi, the footer is rendered here:
administrator\components\com_virtuemart\pdf\phoca.tcpdf.php
in Footer() method...
Re: Need a query for payment method!
Posted: 17 Jul 2008, 13:34
by Majino
i knew it was rendered there... i just want to know what code should i write to get the payment method in the footer
if you know, please, tell me
thanks!
Re: Need a query for payment method!
Posted: 18 Jul 2008, 22:06
by Jan
I only know where the footer information are saved, but I have no idea where VM stores the information about payment ...
Re: Need a query for payment method!
Posted: 19 Jul 2008, 14:45
by Majino
Jan wrote:I only know where the footer information are saved, but I have no idea where VM stores the information about payment ...
if i tell you where the info are, can you tell me how to do a query?
thanks
Re: Need a query for payment method!
Posted: 20 Jul 2008, 22:20
by Jan
If you know where you find this information, just copy some SQL query and do a new in:
function pdf_output( &$d ) method in: (row + 290)
ps_delivery...
Then the value you should paste into footer of a PDF... The problem why I cannot say you more detailed info is, that I don't have installed VM yet, so I cannot try it
but I can help you with e.g. the sql if you know the table where the information is stored...
Jan