Get option value from plan and insert in to field

That works great. 

I've changed the code slightly to truncate to two decimal places to allow to odd amounts when upgrading. Pasted here for others reference.

SELECT TRUNCATE(p.`rate`, 2)
FROM `#__cbsubs_subscriptions` AS s
JOIN `#__cbsubs_payment_items` AS p
ON p.`subscription_id` = s.`id`
WHERE s.`user_id` = '[user_id]'
AND s.`plan_id` = 16
ORDER BY s.`id` DESC
LIMIT 1

 

Ok, a new CBSubs build release is now available expanding the available substitutions from the CBSubs Content Plugin. The following are now available.

Subscription Formatted Price: [cbsubs:subscriptions plan="PLAN_ID" output="price" /]
Subscription Formatted Rate: [cbsubs:subscriptions plan="PLAN_ID" output="rate" /]
Subscription Rate: [cbsubs:subscriptions plan="PLAN_ID" output="rate_number" /]
Subscription Formatted First Rate: [cbsubs:subscriptions plan="PLAN_ID" output="first_rate" /]
Subscription First Rate: [cbsubs:subscriptions plan="PLAN_ID" output="first_rate_number" /]

The above can grab current plan pricing, renewal pricing, or upgrade pricing for an existing subscription for the provided plan id. This will include the adjusted price from CBSubs Options. I've also completely updated the "cbpaidsubsbot" description in System > Manage > Plugins > cbpaidsubsbot > Description with a much easier to understand syntax guide with multiple examples.

So you can either continue using CB Query Field or switch to these. It's entirely up to you as either should be fine.

You are a genius. I wish other extension devs would respond as quickly and as helpfully as this.

I'll update my custom profile to use this now.

Thanks

OK, same question but for a different site.

How do I get the gateway name/ID and coupon usage in to a field for use in a user list?

Thanks

There's no substitution for those. You'd have to use a CB Query Field for that. Is there a reason you need this information as a field? They should be able to see all relevant payment details in their invoices that CBSubs provides for them. We even have per-payment invoices as well now for recurring subscriptions.

It's for a client report. They want to see who has used a coupon code and which one and how they paid. I was thinking of showing it as fields in a CB list along with the fee paid which I already have.

(I'm trying to avoid them wandering around the backend and potentially breaking something)