[SOLVED] CBSubs invoices for single payments using the offline engine

Hi Kyle,

I deleted all the lists and recreated them again and now there all working with, e.g.

( ( SELECT COUNT(*) FROM `#__cbsubs_subscriptions` AS sub WHERE sub.`user_id` = u.`id` AND sub.`status` = 'X' ) >= 1 ) AND ue.`cb_branch_code` = 'NSW'

( ( SELECT COUNT(*) FROM `#__cbsubs_subscriptions` AS sub WHERE sub.`user_id` = u.`id` AND sub.`status` = 'X' ) >= 1 ) AND ue.`cb_branch_code` = 'ACT'

Not sure what was causing this issue, but it's all good now.

Thank you,

Dion.

Hi Kyle,

I'm still struggling with the Advanced Filters in the CB lists...

I am using your suggestion "It's typically more reliable to just check for not active, which is done with the below"

( ( SELECT COUNT(*) FROM `#__cbsubs_subscriptions` AS sub WHERE sub.`user_id` = u.`id` AND sub.`status` != 'A' ) >= 1 )

But this still shows members that have upgraded to another plan, but are still being listed in the Expired lists.

Can you please help configure the display of members who are only expired and have not upgraded to other plans?

I had sent you a PM with admin login details with this request on the 22 September 2016, can you please help resolve this issue?

We need to be able to display Expired members on frontend lists and backend CB User Management lists who have not upgraded to another plan.

Thank you for your assistance.

Dion

Upgrade subscriptions have a status of U so != 'A' is going to match them. If you strictly want active then use = 'A'. For strictly expired use = 'X'. Use whichever best fits your needs.

Kyle,

`status` = 'X' ) >= 1 does not filter out members that also have an "Active" subscription.

How can users with 2 subscriptions, one Active, and the other Expired, not be listed in the Expired listings?

How can we also filter out users with 2 subscriptions, one Active, and the other Expired, from the Expired listings in the backend CB User Managment searches?

When searching CB Paid Subscriptions, it clearly shows that users who have upgraded to another plan have two subscriptions, one Active (new subscription) and one Expired (previous subscription).

If a user has upgraded to a new plan and is Active we need to be able to filter out these users (who still have an Expired sunscription associated to them) as they are not currently Expired.

Hope you can help sort this out.

Thanks,

Dion.

How can users with 2 subscriptions, one Active, and the other Expired, not be listed in the Expired listings?

Add 2 checks to the query. One to see if they have an expired subscription and one to see if they don't have an active one. Again, you've fully access to SQL for the Advanced filtering. Example as follows.

Thanks Kyle.

That resolves the front end lists issue, but what about the CB backend?

How can we also filter out users with 2 subscriptions, one Active, and the other Expired, from the Expired listings in the backend CB User Managment searches?

Hope you can help resolve this issue as well.

Thanks,

Dion.