[SOLVED] Need help for a query integration
- myann
- OFFLINE
-
Premium Member
- Posts: 154
- Thanks: 5
- Karma: 1
10 years 11 months ago #227507
by myann
Replied by myann on topic Need help for a query integration
I need a custom invoicing because my users have to pay for other services, not only CBSubs and I want all my invoices have the same template and numbers with the same format. It's better for my accountant.
Then all my users will be able to see all their invoics in the same metu item, do you understand ?
It's not a problem if I have to create a mulptiple database tables query, I am ready. Just have to find where I can find all the information I need to construct the price paid.
Then all my users will be able to see all their invoics in the same metu item, do you understand ?
It's not a problem if I have to create a mulptiple database tables query, I am ready. Just have to find where I can find all the information I need to construct the price paid.
Please Log in to join the conversation.
krileon
Team Member- OFFLINE
- Posts: 68528
- Thanks: 9093
- Karma: 1434
10 years 11 months ago #227565
by krileon
Kyle (Krileon)
Community Builder Team Member
Before posting on forums: Read FAQ thoroughly + Read our Documentation + Search the forums
CB links: Documentation - Localization - CB Quickstart - CB Paid Subscriptions - Add-Ons - Forge
--
If you are a Professional, Developer, or CB Paid Subscriptions subscriber and have a support issue please always post in your respective support forums for best results!
--
If I've missed your support post with a delay of 3 days or greater and are a Professional, Developer, or CBSubs subscriber please send me a private message with your thread and will reply when possible!
--
Please note I am available Monday - Friday from 8:00 AM CST to 4:00 PM CST. I am away on weekends (Saturday and Sunday) and if I've missed your post on or before a weekend after business hours please wait for the next following business day (Monday) and will get to your issue as soon as possible, thank you.
--
My role here is to provide guidance and assistance. I cannot provide custom code for each custom requirement. Please do not inquire me about custom development.
Replied by krileon on topic Need help for a query integration
Ok, believe I've figured out how you can get this information. The below SELECT query should give you the total price based off the subscription id. It does this by grabbing its payment item row, uses the basket id from that row, then selects the price from the basket row for that subscription.
Substitution usage example:
phpMyAdmin example:
Substitution usage example:
SELECT `mc_gross` FROM `#__cbsubs_payment_baskets` WHERE `id` = ( SELECT `payment_basket_id` FROM `#__cbsubs_payment_items` WHERE `subscription_id` = '[subscription_id]' ORDER BY `id` DESC LIMIT 1 )phpMyAdmin example:
SELECT `mc_gross` FROM `jos_cbsubs_payment_baskets` WHERE `id` = ( SELECT `payment_basket_id` FROM `jos_cbsubs_payment_items` WHERE `subscription_id` = '5' ORDER BY `id` DESC LIMIT 1 )Kyle (Krileon)
Community Builder Team Member
Before posting on forums: Read FAQ thoroughly + Read our Documentation + Search the forums
CB links: Documentation - Localization - CB Quickstart - CB Paid Subscriptions - Add-Ons - Forge
--
If you are a Professional, Developer, or CB Paid Subscriptions subscriber and have a support issue please always post in your respective support forums for best results!
--
If I've missed your support post with a delay of 3 days or greater and are a Professional, Developer, or CBSubs subscriber please send me a private message with your thread and will reply when possible!
--
Please note I am available Monday - Friday from 8:00 AM CST to 4:00 PM CST. I am away on weekends (Saturday and Sunday) and if I've missed your post on or before a weekend after business hours please wait for the next following business day (Monday) and will get to your issue as soon as possible, thank you.
--
My role here is to provide guidance and assistance. I cannot provide custom code for each custom requirement. Please do not inquire me about custom development.
Please Log in to join the conversation.
- myann
- OFFLINE
-
Premium Member
- Posts: 154
- Thanks: 5
- Karma: 1
10 years 11 months ago #227592
by myann
Replied by myann on topic Need help for a query integration
Hi, I use what you propose me and I manage to get the values I need.
Thank you very much
Regards
Myann
Thank you very much
Regards
Myann
The following user(s) said Thank You: krileon
Please Log in to join the conversation.
Moderators: beat, nant, krileon
Time to create page: 0.195 seconds
-
You are here:
- Home
- Forums
- Archive
- CBSubs Support
- [SOLVED] Need help for a query integration