pub; // expand the pub object to include the records from the pub_dbxref table $options = ['return_array' => 1]; $pub = chado_expand_var($pub, 'table', 'pub_dbxref', $options); $pub_dbxrefs = $pub->pub_dbxref; $references = []; 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, ['attributes' => ['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), ['attributes' => ['target' => '_blank']]); } if (property_exists($dbxref, 'is_primary')) { $accession .= " (primary cross-reference)"; } $rows[] = [ $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 = [ 'header' => $headers, 'rows' => $rows, 'attributes' => [ 'id' => 'tripal_pub-table-references', 'class' => 'tripal-data-table', ], 'sticky' => FALSE, 'caption' => '', 'colgroups' => [], 'empty' => '', ]; // once we have our table array structure defined, we call Drupal's theme_table() // function to generate the table. print theme_table($table); }