CiviCRM Community Forums (archive)

I'm just starting to dabble with the CiviCRM v3 API and am presently porting an older drupal plugin to use this API.  I'm trying to replace lines like:

db_query("SELECT id,start_date,end_date FROM {civicrm_membership} WHERE contact_id=:cid ORDER BY end_date DESC", array(':cid' => $cid));

and

db_update("UPDATE civicrm_membership SET end_date = SYSDATE WHERE contact_id = :cid ORDER BY end_date DESC", array(':cid' => $cid));

Is it possible to recreate this functionality using the API, namely, is it possible for an API call to only return or update the membership with the most recent end date?

Have had a look at the API documentation, can certainly retrieve a membership based on some criteria however in terms of date it seems to only allow searching for memberships that have a specific end date, rather than the most recent end date.

There is some work needed on the API.

The issue is that if contact_id is passed in it calls a BAO function which supports the param ['active_only'] but not much else.

If contact id is passed in it calls basic_get which supports the options 'sort', 'limit', 'offset' & 'return' => (array of fields to return) along with filter.start_date_high & filter.start_date_low

Probably it should be made to handle 'active_only' within the api & to always call basic_get (& of course a test should be added)

    CRM_Member_BAO_Membership::getValues( $membershipParams, $membershipValues, $activeOnly );
    if(empty($params['contact_id'])){
      //added this as contact_id was the only acceptable field so this was a quick way to improve
        $membershipValues = _civicrm_api3_basic_get(_civicrm_api3_get_BAO(__FUNCTION__), $params, FALSE);
    }