Family chart

Once you become a Member you'll be able to view your family's events alongside your own.

uid; $family_ids_raw = db_query("SELECT DISTINCT e.endpoints_entity_id AS myid FROM sen_field_data_endpoints e JOIN sen_relation r ON r.vid = e.entity_id JOIN sen_field_data_field_family_order f ON f.entity_id = e.endpoints_entity_id WHERE e.delta = 0 AND r.uid = :userid ORDER BY f.field_family_order_value ASC", array(":userid" => $chart_owner)); foreach($family_ids_raw AS $family_idResult_raw) { #see if show on lists is set to 'show' $show = ''; $show = db_query("SELECT field_family_show_value FROM sen_field_data_field_family_show WHERE entity_id = :userid", array(":userid" => $family_idResult_raw->myid))->fetchField(); #print "

$family_idResult_raw->myid status is $show

"; if ($show == 'hide'){ }else{ $family_ids[] = $family_idResult_raw->myid; } } watchdog('eventlogger alter2','raw family ids are ' . print_r($family_ids, true) . ''); if (!$family_ids){ print 'No family members or subusers'; watchdog('eventlogger alter2','No family members or subusers'); $subuser_group_id = db_query("SELECT entity_id FROM sen_field_data_endpoints WHERE endpoints_entity_id = :userid", array(":userid" => $user->uid))->fetchField(); watchdog('eventlogger alter2','user has no subusers but uid is: ' . $user->uid . ' and belongs to group ' . $subuser_group_id . ''); if (!empty($subuser_group_id)) { $subuser_owner_id = db_query("SELECT endpoints_entity_id FROM sen_field_data_endpoints WHERE delta = 1 AND entity_id = :userid", array(":userid" => $subuser_group_id))->fetchField(); if (!empty($subuser_owner_id )) { $family_idsResult = db_query("SELECT DISTINCT e.endpoints_entity_id AS myid, u.name AS myname FROM sen_field_data_endpoints e JOIN sen_relation r ON r.vid = e.entity_id JOIN sen_users u ON u.uid = e.endpoints_entity_id WHERE e.delta = 0 AND r.uid = :userid", array(":userid" => $subuser_owner_id )); $family_ids_count = 1; } } # if the user is part of family, present a list of family members that they can reassign ownership of the Event if ($family_ids_count > 0){ foreach($family_idsResult AS $family_idResult) { #see if show on lists is set to 'show' $show = ''; $show = db_query("SELECT field_family_show_value FROM sen_field_data_field_family_show WHERE entity_id = :userid", array(":userid" => $family_idResult->myid))->fetchField(); print "

$family_idResult->myid status is $show

"; if ($show == 'hide'){ }else{ $family_ids[] = $family_idResult->myid; } } $family_ids[] = $subuser_owner_id; }else { print 'No Family Members found. You can use the "Subusers" tab in the Menu to add Family Members but it\'s experimental at this point.'; } } ?>