pub;
// expand the pub to include the pubauthors.
$options = array(
'return_array' => 1,
'order_by' => array('rank' => 'ASC'),
);
$pub = chado_expand_var($pub, 'table', 'pubauthor', $options);
// see if we have authors as contacts if so then we'll add this resource
$authors = $pub->pubauthor;
$has_contacts = FALSE;
if (count($authors) > 0) {
foreach ($authors as $author) {
// expand the author to include the pubauthor_contact table records
$options = array(
'return_array' => 1,
'include_fk' => array(
'contact_id' => array(
'type_id' => 1,
),
),
);
$author = chado_expand_var($author, 'table', 'pubauthor_contact', $options);
if ($author->pubauthor_contact) {
$has_contacts = TRUE;
}
}
}
if ($has_contacts) { ?>
Additional information about authors:
pubauthor_contact[0]->contact_id;
$options = array(
'return_array' => 1,
'include_fk' => array(
'type_id' => 1,
),
);
$contact = chado_expand_var($contact, 'table', 'contactprop', $options);
$properties = $contact->contactprop;
$options = array('order_by' => array('rank' => 'ASC'));
$properties = chado_expand_var($properties, 'field', 'contactprop.value', $options);
// link the contact to it's node if one exists
$contact_name = $author->givennames . " " . $author->surname;
if (property_exists($contact, 'nid')) {
$contact_name = l($contact_name, 'node/' . $contact->nid);
}
// Get some additional details about this contact if they exists.
$details = '';
if (is_array($properties)) {
foreach ($properties as $property) {
// skip the description and name properties
if ($property->type_id->name == "contact_description" or
$property->type_id->name == "Surname" or
$property->type_id->name == "Given Name" or
$property->type_id->name == "First Initials" or
$property->type_id->name == "Suffix") {
continue;
}
$details .= "
" . $property->type_id->name . " : " . $property->value;
}
}
$rows[] = array(
$rank,
$contact_name . $details,
);
$rank++;
}
// the $table array contains the headers and rows array as well as other
// options for controlling the display of the table. Additional
// documentation can be found here:
// https://api.drupal.org/api/drupal/includes%21theme.inc/function/theme_table/7
$table = array(
'header' => $headers,
'rows' => $rows,
'attributes' => array(
'id' => 'tripal_pub-table-contacts',
'class' => 'tripal-data-table'
),
'sticky' => FALSE,
'caption' => '',
'colgroups' => array(),
'empty' => '',
);
// once we have our table array structure defined, we call Drupal's theme_table()
// function to generate the table.
print theme_table($table);
}