CiviCRM Community Forums (archive)

I need to alter a membership type so that a different relationship will cause contacts to inherit the membership. I've changed the id of the membership type needed in civicrm_membership_type table. I now need to refresh the relationships so that any old memberships are deleted and new ones created where appropriate.

I have written a chunk of code to try and do this but so far it isn't working. Code that I'm running is below if anyone can give me pointers. I based it on the postProcess of the relationships tab for a contact record.

require_once 'CRM/Contact/BAO/Relationship.php';
require_once('CRM/Core/Action.php');
//query to get relationships
$q = "SELECT * FROM {civicrm_relationship}";
$res = db_query($q);

//for each rel

while($row = db_fetch_array($res)) {

// Create vars needed for relationship membership stuff.
$contactId = $row['contact_id_a'];

$params = array (
    'hidden_custom' => 1,
    'relationship_type_id' => $row['relationship_type_id'] . '_a_b',
    'start_date' => array (
            'M' => null,
            'd' => null,
            'Y' => null,
        ),

    'end_date' => array (
            'M' => null,
            'd' => null,
            'Y' => null,
        ),

    'is_active' => 1,
    'description' => null,
    'note' => null,
);

$ids = array(
'contact' => $row['contact_id_a'],
'relationship' => $row['id'],
'contactTarget' => $row['contact_id_b'],
);

$action = CRM_Core_Action::UPDATE;

CRM_Contact_BAO_Relationship::relatedMemberships( $contactId, $params, $ids, $action, true );

// run it
}


Good call, I'll give it a go.

Chris - unfortunately the current data model doesn't support this (civicrm_membership_type.relationship_type_id column represents a single relationship inheritance). Not sure if there's any easy / less drastic solution for solving this without wholesale changes to the schema and methods :-(

I think I managed to hack something together. Must add the problem to my list ready for the dev camp.