project; // expand project to include pubs $options = ['return_array' => 1]; $project = chado_expand_var($project, 'table', 'project_pub', $options); $project_pubs = $project->project_pub; if (count($project_pubs) > 0) { ?>
pub_id; $pub = chado_expand_var($pub, 'field', 'pub.title'); $citation = $pub->title; // use the title as the default citation // get the citation for this pub if it exists $values = [ 'pub_id' => $pub->pub_id, 'type_id' => [ 'name' => 'Citation', ], ]; $options = ['return_array' => 1]; $citation_prop = chado_generate_var('pubprop', $values, $options); if (count($citation_prop) == 1) { $citation_prop = chado_expand_var($citation_prop, 'field', 'pubprop.value'); $citation = $citation_prop[0]->value; } // if the publication is synced then link to it if ($pub->nid) { // replace the title with a link $link = l($pub->title, 'node/' . $pub->nid, ['attributes' => ['target' => '_blank']]); $patterns = [ '/(\()/', '/(\))/', '/(\])/', '/(\[)/', '/(\{)/', '/(\})/', '/(\+)/', '/(\.)/', '/(\?)/', ]; $fixed_title = preg_replace($patterns, "\\\\$1", $pub->title); $citation = preg_replace('/' . $fixed_title . '/', $link, $citation); } $rows[] = [ $pub->pyear, $citation, ]; } // 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_project-table-publications', '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); }