123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134 |
- <?php
- /* Typically in a Tripal template, the data needed is retrieved using a call to
- * chado_expand_var function. For example, to retrieve all
- * of the contact relationships for this node, the following function call would be made:
- *
- * $contact = chado_expand_var($contact,'table','contact_relationship');
- *
- * However, this function call can be extremely slow when there are numerous relationships.
- * This is because the chado_expand_var function is recursive and expands
- * all data following the foreign key relationships tree. Therefore, to speed retrieval
- * of data, a special variable is provided to this template:
- *
- * $contact->all_relationships;
- *
- * This variable is an array with two sub arrays with the keys 'object' and 'subject'. The array with
- * key 'object' contains relationships where the contact is the object, and the array with
- * the key 'subject' contains relationships where the contact is the subject
- */
- $contact = $variables['node']->contact;
- $all_relationships = $contact->all_relationships;
- $object_rels = $all_relationships['object'];
- $subject_rels = $all_relationships['subject'];
- if (count($object_rels) > 0 or count($subject_rels) > 0) { ?>
- <div class="tripal_contact-data-block-desc tripal-data-block-desc"></div> <?php
- // first add in the subject relationships.
- foreach ($subject_rels as $rel_type => $rels) {
- foreach ($rels as $obj_type => $objects) { ?>
- <p>This <?php print strtolower($contact->type_id->name); ?>
- <b><?php print $rel_type ?></b> with the
- following <?php print strtolower($obj_type) ?> contact(s): <?php
- // the $headers array is an array of fields to use as the colum headers.
- // additional documentation can be found here
- // https://api.drupal.org/api/drupal/includes%21theme.inc/function/theme_table/7
- $headers = ['Name'];
- // the $rows array contains an array of rows where each row is an array
- // of values for each column of the table in that row. Additional documentation
- // can be found here:
- // https://api.drupal.org/api/drupal/includes%21theme.inc/function/theme_table/7
- $rows = [];
- foreach ($objects as $object) {
- // link the contact to it's node
- $contact_name = $object->record->object_id->name;
- if (property_exists($object->record, 'nid')) {
- $contact_name = "<a href=\"" . url("node/" . $object->record->nid) . "\" target=\"_blank\">" . $object->record->object_id->name . "</a>";
- }
- $rows[] = [
- $contact_name,
- ];
- }
- // 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_contact-table-relationship-object',
- '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); ?>
- </p>
- <br><?php
- }
- }
- // second add in the object relationships.
- foreach ($object_rels as $rel_type => $rels) {
- foreach ($rels as $subject_type => $subjects) {
- ?>
- <p>The following
- <b><?php print $subjects[0]->record->subject_id->type_id->name ?></b>
- contact(s) are <?php print $rel_type ?>
- this <?php print $contact->type_id->name; ?>: <?php
- // the $headers array is an array of fields to use as the colum headers.
- // additional documentation can be found here
- // https://api.drupal.org/api/drupal/includes%21theme.inc/function/theme_table/7
- $headers = ['Name'];
- // the $rows array contains an array of rows where each row is an array
- // of values for each column of the table in that row. Additional documentation
- // can be found here:
- // https://api.drupal.org/api/drupal/includes%21theme.inc/function/theme_table/7
- $rows = [];
- foreach ($subjects as $subject) {
- // link the contact to it's node
- $contact_name = $subject->record->subject_id->name;
- if (property_exists($subject->record, 'nid')) {
- $contact_name = "<a href=\"" . url("node/" . $subject->record->nid) . "\" target=\"_blank\">" . $subject->record->subject_id->name . "</a>";
- }
- $rows[] = [
- $contact_name,
- ];
- }
- // 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_contact-table-relationship-subject',
- '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); ?>
- </p>
- <br><?php
- }
- }
- }
|