[SOLVED] Add Member Since & Ending Date date fields

Hi,

We have a Joomla 3.3.x site with CB 1.9.1 and CBSubs 3.0.0.

In CB I have a Member Since date field (cb_membersince) and an Ending Date field (cb_endingdate).

What I want to do, is add the date to the Member Since field when the user subscribes to a plan AND there isn't already a date in the field. So, this field will only be filled in the first membership they take out.

Also each time that a user subscribes to a plan I want to update their Ending Date CB field to the plan's expiration date.

I tried to use an Auto Action to add the Member Since date, but it isn't working. Here is how I set it up:
Type: Field
Triggers: onCPayAfterPaymentStatusUpdateEvent
User: Automatic
Access: Everybody
Conditionals: [var3] less than or equal 2 <- my plan ids are 1 and 2
[var2] Equal to A
[cb_membersince] Equal to NULL
Field Actions:
Field: Member Since Date <- cb_membersince
Operator: Set (Field=Value)
Value: [cb:date format="Y-m-d" /]

I looked in the database and the cb_membersince field has NULL in it after the user registers.

Then once that is working, I need to add the Ending date update field action but I don't know how to get the expiry date. I haven't been able to find any CBSubs substitions.

Field: Last Expiry Date <-cb_endingdate
Operator: Set (Field=Value)
Value: <- don't know what to put in here.

Maybe there is an easier way to do this?

Thank you for your help on how to do this.

To combine to date fields I suggest using CB Query Field then in your database query do the calculation using MYSQL date functions. CB Auto Actions can't combine two date fields like what you're wanting to do without using a Query action and MYSQL functions or a Code action with PHP.

Hi Kyle,

The Member Since doesn't have any date calculation or combining of any fields. It should just put the current date into the Member Since field, if it doesn't already have a date in it. Can't I use an auto action like I showed below to add the current date?

For the Ending Date field, it doesn't need a calculation either, it just needs to have the member's expiry date put in the field.

The admin has to be able to edit either of these fields, if they need to. So, a query field wouldn't work for the Ending Date field.

Thank you.

onCPayAfterPaymentStatusUpdateEvent isn't the correct trigger to be using for subscription state changes. You need to use the following.

Plan Active
Triggers: onCPayUserStateChange
User: Automatic
Access: Everybody
Conditional 1: [var3] Equal To PLAN_ID_HERE
Conditional 2: [var2] Equal To A

Plan Expired
Triggers: onCPayUserStateChange
User: Automatic
Access: Everybody
Conditional 1: [var3] Equal To PLAN_ID_HERE
Conditional 2: [var2] Equal To X

Trying to modify user data on the trigger you're currently using will likely just result in the data being overridden shortly after it by CBSubs since CBSub is still acting off a reference.

To get the subscription expiration date from onCPayUserStateChange you should be able to use the below substitution. The var9 is the subscription object for that trigger.

[var9_expiry_date]

Hi Kyle,

Thank you for your help once again. I now have the Ending Expiry date working, but I still can't get the Member Since one working.

It must be the condition of checking the Member Since field that is causing the issue. I tried checking if it was Equal To NULL and also if it was Empty, but neither is triggering.

When I look at the comprofiler table record the cb_membersince field is showing NULL as the contents of the field, when it hasn't had anything added to it yet.

I tried this condition:
Conditionals: [var3] less than or equal 2 <- my plan ids are 1 and 2
[var2] Equal to A
[cb_membersince] Equal to NULL

and this condition:
Conditionals: [var3] less than or equal 2 <- my plan ids are 1 and 2
[var2] Equal to A
[cb_membersince] Empty

So, how do I check for the cb_membersince field being NULL?

Thank you.

If membersince is a Date field then it's never empty. You'd need to condition against 0000-00-00 00:00:00 if it's datetime or 0000-00-00 if it's date.