Page 1 of 1
(1.0.9 VM IDnR) solved anybody missing payment in invoice?
Posted: 19 Mar 2013, 20:52
by anazoolik
Has anybody a working solution to show payment_name in the invoice?
In the forum are some solutions, but nothing is working with the latest downloadable files...
I tried also a direct database request, but my knowledge is to poor.
Thanks,
Holger
Re: (1.0.9 VM IDnR) solved anybody missing payment in invoic
Posted: 21 Mar 2013, 13:56
by anazoolik
Code: Select all
case 'dbp':
$query = "SELECT a.payment_method_id, p.payment_method_name FROM #__{vm}_order_payment AS a"
." LEFT JOIN #__{vm}_payment_method AS p ON a.payment_method_id = p.payment_method_id"
." WHERE order_id='".(int)$var['order_id']."'";
break;
The problem is, that in table "order_payment" is no column "payment_method_name"... only in "#__{vm}_payment_method".
Could anybody correct the query? My knowledge is to poor to get this working (i tried some hours...)
Thanks,
Holger
Re: (1.0.9 VM IDnR) solved anybody missing payment in invoic
Posted: 22 Mar 2013, 02:15
by Jan
Hi, the query should be OK
You as for p.payment_method_name - p means, that you will ask table p which is:
LEFT JOIN #__{vm}_payment_method AS p
Re: (1.0.9 VM IDnR) solved anybody missing payment in invoic
Posted: 25 Mar 2013, 09:57
by anazoolik
Thanks,
meanwhile i worked through the code and realized this. But i can't find any failure.
It is also not possible to request "payment_method_name" directly.
I believe i have to give up... it is pity, 'cause it would be a really good plugin.
Holger