pub;
// expand the pub object to include the records from the pub_dbxref table
$options = array('return_array' => 1);
$pub = chado_expand_var($pub, 'table', 'pub_dbxref', $options);
$pub_dbxrefs = $pub->pub_dbxref;
$references = array();
if (count($pub_dbxrefs) > 0 ) {
foreach ($pub_dbxrefs as $pub_dbxref) {
$references[] = $pub_dbxref->dbxref_id;
}
}
if(count($references) > 0){ ?>
This publication is also available in the following databases:
db_id->name . ': ' . $dbxref->db_id->description;
if ($dbxref->db_id->url) {
$database = l($dbxref->db_id->name, $dbxref->db_id->url, array('attributes' => array('target' => '_blank'))) . ': ' . $dbxref->db_id->description;
}
$accession = $dbxref->db_id->name . ':' . $dbxref->accession;
if ($dbxref->db_id->urlprefix) {
$accession = l($accession, tripal_get_dbxref_url($dbxref), array('attributes' => array('target' => '_blank')));
}
if (property_exists($dbxref, 'is_primary')) {
$accession .= " (primary cross-reference)";
}
$rows[] = array(
$database,
$accession
);
}
// 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-references',
'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);
}