(1.0.9 VM IDnR) solved anybody missing payment in invoice?

[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

[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

[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

[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