Need a query for payment method!

[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!

[Jan]

Hi, the footer is rendered here:

administrator\components\com_virtuemart\pdf\phoca.tcpdf.php

in Footer() method...

[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!

[Jan]

I only know where the footer information are saved, but I have no idea where VM stores the information about payment ...

[Majino]

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

[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