CiviCRM Community Forums (archive)

(Posting on behalf of man4mac)
----------
I spent quite a while slaving over the way the CiviCRM API works to return a useful result set of custom content regardless of how the field was configured (multiple value field set...or not). This is piece of a bigger drupal module I'm creating for a more seamless developer experience with CiviCRM. This is my first post on the CiviForum, and frankly there is probably a better way to do this, but this snippet may be useful to someone Enjoy!

<?php
function civi_unify_custom_values($contact_id){
$data = $groups = $fields = $values = array();

$custom_values = civicrm_api("CustomValue","get", array("version"=>3,'sequential' =>'1',"entity_id"=>$contact_id));

if(!$custom_values['is_error']){
$custom_fields = civicrm_api("CustomField","get", array("version"=>3,'sequential' =>'1'));
$custom_groups = civicrm_api("CustomGroup","get", array("version"=>3,'sequential' =>'1'));

foreach($custom_values['values'] as $key => $value_set){
$values[$value_set['id']] = numeric_set($value_set);
}
foreach($custom_groups['values'] as $key => $group){
$groups[$group['id']] = $group['name'];
}
foreach($custom_fields['values'] as $key => $field){
$data[$groups[$field['custom_group_id']]][$field['name']] = $values[$field['id']];
}
return $data;
}else{
return false;
}
}

function numeric_set($array){
foreach($array as $key=>$value){
if(!is_numeric($key)){
unset($array[$key]);
}
}
return $array;
}
?>

Ideally you would use it in this manner:

<?php 
function get_profile($contact_id){
$contact_id = 1; //for simplicity sake
$profile = civicrm_api("Contact","get", array('version'=>3,'sequential'=>1,"contact_id"=>$contact_id));
if($custom = civi_unify_custom_values($contact_id)){
$profile['values'][0] = $profile['values'][0]+$custom;
}
return $profile['values'][0];
}
?>


I probably should have posted a sample result set. Attached is a sample output, this is 2 different field sets of custom content. Profile_Additions is the name of the first set, it only has 1 field named "Shipping_Address" with a text entry. As an example, the second field set is a multi value set with 2 fields "Social_Media" and "URL". You can see the data is returned in a fairly contextual result. Nothing too spiffy, but definitely helpful for custom development in drupal.

[Profile_Additions] => Array
        (
            [Shipping_Address] => Array
                (
                    [0] => home
                )

        )

    [Social_Media] => Array
        (
            [Service] => Array
                (
                    [1] => facebook
                    [2] => twitter
                    [3] => dribble
                )

            [URL] => Array
                (
                    [1] => http://www.facebook.com/justinpschroeder
                    [2] => http://www.twitter.com/jpschroeder
                    [3] =>
                )

        )