api: Get renewal activity for a contact

Question

I need to find out in php if 'the current user' has recently renewed membership (or just signed up as a new member).

I don't think I can get data about renewal from the Membership entity. The 'Join date' seems to be the same as the 'Start date'. So for renewal, I'd have to look at Activities of the type renewal.

• I hoped I could do this with the ActivityContact entity, but it doesn't allow me to filter on activity type.
• I hoped I could do this with the Activity entity, but it doesn't allow me to filter on the 'target_contact', or 'assignee', or whatever it's called.

So .. do I need to join api calls - how would I do that ? - or is there another way ?

Answer 1

Why not check against membership status New? The length of time it's New from and for is configurable I believe.

Personally I'd try to use the API with a get command. If the API for this didn't work on the install that I was working on, I would write a custom SQL query for CRM_Core_DAO. Happy to help you further with that if needed.

Answer 2

After a brand new update, the api explorer works fine. And the answer is, in PHP

$result = civicrm_api3('Activity', 'get', array(
  'sequential' => 1,
  'activity_type_id' => array('IN' => array("Membership Signup", "Membership Renewal")),
  'activity_date_time' => array('>' => time()-30*24*60*60),
  'source_contact_id' => $contactid,
));
$recent = ($result['count']>0);