| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122 | 
							- <?php
 
- $node = $variables['node'];
 
- // Retrieve Template
 
- $template = db_select('tripal_bulk_loader_template', 't')
 
-   ->fields('t')
 
-   ->condition('template_id', $node->template->template_id, '=')
 
-   ->execute()
 
-   ->fetchObject();
 
- $template->template_array = unserialize($template->template_array);
 
- // Summarize Template
 
- $fields = [];
 
- $constants = [];
 
- foreach ($template->template_array as $priority => $table_array) {
 
-   if (!is_array($table_array)) {
 
-     continue;
 
-   }
 
-   $table = $table_array['table'];
 
-   $record = $table_array['record_id'];
 
-   foreach ($table_array['fields'] as $field) {
 
-     if (preg_match('/table field/', $field['type'])) {
 
-       $field['table'] = $table;
 
-       $field['record'] = $record;
 
-       $sheet = 0;//$field['spreadsheet sheet'];
 
-       $column = $field['spreadsheet column'];
 
-       $fields[$sheet . '-' . $column][] = $field;
 
-     }
 
-     elseif ($field['type'] == 'constant') {
 
-       $field['table'] = $table;
 
-       $field['record'] = $record;
 
-       $constants[] = $field;
 
-     }
 
-   }
 
- } ?>
 
-     <p><b>Constants</b></p> <?php
 
- // add a table describing the constants specified in the file
 
- if (sizeof($constants)) {
 
-   $headers = [
 
-     'Record Name',
 
-     'Field Name',
 
-     'Value',
 
-     'Chado Table',
 
-     'Chado Field',
 
-   ];
 
-   $rows = [];
 
-   // iterate through the fields and add rows to the table
 
-   foreach ($constants as $field) {
 
-     $rows[] = [
 
-       $field['record'],
 
-       $field['title'],
 
-       $field['constant value'],
 
-       $field['table'],
 
-       $field['field'],
 
-     ];
 
-   }
 
-   // theme the table
 
-   $table = [
 
-     'header' => $headers,
 
-     'rows' => $rows,
 
-     'attributes' => [
 
-       'id' => 'tripal_bulk_loader-table-constants',
 
-       'class' => 'tripal-data-table',
 
-     ],
 
-     'sticky' => FALSE,
 
-     'caption' => '',
 
-     'colgroups' => [],
 
-     'empty' => '',
 
-   ];
 
-   print theme_table($table);
 
- }
 
- ?>
 
-     <br><p><b>Data Columns</b></p> <?php
 
- // add a table specifying the data file columns
 
- if (sizeof($fields)) {
 
-   $headers = [
 
-     'Record Name',
 
-     'Field Name',
 
-     'Data File Column',
 
-     'Chado Table',
 
-     'Chado Field',
 
-   ];
 
-   $rows = [];
 
-   // iterate through the fields and add rows to the table
 
-   foreach ($fields as $column) {
 
-     foreach ($column as $field) {
 
-       $rows[] = [
 
-         $field['record'],
 
-         $field['title'],
 
-         $field['spreadsheet column'],
 
-         $field['table'],
 
-         $field['field'],
 
-       ];
 
-     }
 
-   }
 
-   // theme the table
 
-   $table = [
 
-     'header' => $headers,
 
-     'rows' => $rows,
 
-     'attributes' => [
 
-       'id' => 'tripal_bulk_loader-table-columns',
 
-       'class' => 'tripal-data-table',
 
-     ],
 
-     'sticky' => FALSE,
 
-     'caption' => '',
 
-     'colgroups' => [],
 
-     'empty' => '',
 
-   ];
 
-   print theme_table($table);
 
- }
 
 
  |