CiviCRM Community Forums (archive)

For Mailchimp integration, I need to be able to find all groups (static and smart).  I've written some initial code that does the trick, and am wondering if something like this could be turned into an API call, say ('SmartGroup','get', $params)?

// Return array of Smart Group ids that Contact is a member of
function SmartGroup_ContactGet($cid) {
    SmartGroup_CacheUpdate();
    $groups = array();
    $sql = "
SELECT DISTINCT group_id
FROM   civicrm_group_contact_cache
WHERE  contact_id = $cid";

    require_once 'CRM/Core/DAO.php';
    $groupsDAO = CRM_Core_DAO::executeQuery( $sql );

    while ( $groupsDAO->fetch() ) {
        $groups[] = $groupsDAO->group_id;
    }
    return $groups;
}

// Update Smart Group cache
function SmartGroup_CacheUpdate() {
    $groups = SmartGroup_GetIds();
    require_once 'CRM/Contact/BAO/GroupContactCache.php';

    foreach ($groups as $gid) {
        CRM_Contact_BAO_GroupContactCache::check( $gid );
    }
}

// Return array of all Smart Group IDs
function SmartGroup_GetIds() {
    $smart = array();

    // FIXME: Use offset, limit to get all groups (when more than 25)
    // FIXME: Can Group Get return just smart groups?
    $results = civicrm_api('Group','get',array('version' => 3));

    foreach ($results['values'] as $id => $group) {
        if ($group['saved_search_id']) {
            $smart[] = $id;
        }
    }
    return $smart;
}

Sounds great - it would be great to have a better way to do this (and would be interested in reviving the smart group optimization MIH).  It takes about 25 seconds for my SmartGroup_CacheUpdate() function to run (six smart groups across 50K contacts).  What could help (I think) is being smarter about when to invalidate the cache.

I don't have Coleman's email address - is this @colemanw? - can you point him to this discussion for comment?