123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355 |
- <?php
- class so__transcript extends ChadoField {
-
-
-
-
-
-
-
-
- public static $default_label = 'Transcripts';
-
- public static $description = 'An RNA synthesized on a DNA or RNA template by an RNA polymerase.';
-
-
-
-
-
-
-
- public static $default_instance_settings = [
-
- 'term_vocabulary' => 'SO',
-
- 'term_name' => 'transcript',
-
- 'term_accession' => '0000673',
-
-
-
- 'term_fixed' => FALSE,
-
-
-
- 'transcript_fields' => []
- ];
-
- public static $default_widget = 'so__transcript_widget';
-
- public static $default_formatter = 'so__transcript_formatter';
-
-
-
-
-
- protected $field;
-
-
-
- protected $instance;
-
- public function elementInfo() {
- $field_term = $this->getFieldTermID();
- return [
- $field_term => [
- 'operations' => [],
- 'sortable' => FALSE,
- 'searchable' => FALSE,
- 'type' => 'xs:complexType',
- 'readonly' => TRUE,
- 'elements' => [
- 'rdfs:type' => [
- 'name' => 'transcript_type',
- 'label' => 'Transcript Type',
- 'help' => 'The type of a transcript.',
- 'searchable' => FALSE,
- 'operations' => ['eq', 'ne', 'contains', 'starts'],
- 'sortable' => FALSE,
- 'type' => 'xs:string',
- 'readonly' => TRUE,
- 'required' => FALSE,
- ],
- 'schema:name' => [
- 'name' => 'transcript_name',
- 'label' => 'Transcript Name',
- 'help' => 'The name of a transcript.',
- 'searchable' => FALSE,
- 'operations' => ['eq', 'ne', 'contains', 'starts'],
- 'sortable' => FALSE,
- 'type' => 'xs:string',
- 'readonly' => TRUE,
- 'required' => FALSE,
- ],
- 'data:0842' => [
- 'name' => 'transcript_uniquename',
- 'label' => 'Transcript Identifier',
- 'help' => 'The unique identifier of a transcript.',
- 'searchable' => FALSE,
- 'operations' => ['eq', 'ne', 'contains', 'starts'],
- 'sortable' => FALSE,
- 'type' => 'xs:string',
- 'readonly' => TRUE,
- 'required' => FALSE,
- ],
- 'SO:0000735' => [
- 'name' => 'loc',
- 'label' => 'Transcript Location',
- 'help' => 'The location of the transcript on a reference feature.',
- 'searchable' => FALSE,
- 'operations' => ['eq', 'ne', 'contains', 'starts'],
- 'sortable' => FALSE,
- 'type' => 'xs:string',
- 'readonly' => TRUE,
- 'required' => FALSE,
- ],
- 'entity' => [
- 'searchable' => FALSE,
- 'sortable' => FALSE,
- ],
- ],
- ],
- ];
- }
-
- public function load($entity) {
- $record = $entity->chado_record;
- $field_name = $this->field['field_name'];
- $field_type = $this->field['type'];
- $field_table = $this->instance['settings']['chado_table'];
- $field_column = $this->instance['settings']['chado_column'];
-
- $entity->{$field_name}['und'][0] = [
- 'value' => '',
- ];
- if (!$record) {
- return;
- }
-
- $sql = "
- SELECT FS.name, FS.uniquename, FS.feature_id, FCVT.name as type
- FROM {feature_relationship} FR
- INNER JOIN {feature} FS on FS.feature_id = FR.subject_id
- INNER JOIN {cvterm} FCVT on FCVT.cvterm_id = FS.type_id
- INNER JOIN {cv} CV on CV.cv_id = FCVT.cv_id
- WHERE
- FR.object_id = :feature_id and
- FCVT.name = 'mRNA' and
- CV.name = 'sequence'
- ";
- $results = chado_query($sql, [':feature_id' => $record->feature_id]);
- $i = 0;
- while ($transcript = $results->fetchObject()) {
-
- $sql = "
- SELECT FL.*, F.name as srcfeature_name
- FROM {featureloc} FL
- INNER JOIN {feature} F on F.feature_id = FL.srcfeature_id
- WHERE FL.feature_id = :object_id
- ";
- $floc_results = chado_query($sql, [':object_id' => $transcript->feature_id]);
- $loc = "";
- while ($location = $floc_results->fetchObject()) {
- $loc .= $location->srcfeature_name . ":" . $location->fmin . ".." . $location->fmax;
- }
- $entity->{$field_name}['und'][$i]['value'] = [
- 'rdfs:type' => $transcript->type,
- 'schema:name' => $transcript->name,
- 'data:0842' => $transcript->uniquename,
- 'SO:0000735' => $loc,
- ];
- $feature = chado_generate_var('feature', ['feature_id' => $transcript->feature_id]);
- if (property_exists($feature, 'entity_id')) {
- $entity->{$field_name}['und'][$i]['value']['entity'] = 'TripalEntity:' . $feature->entity_id;
- }
- $i++;
- }
- }
-
- public function instanceSettingsForm() {
- $element = parent::instanceSettingsForm();
- $settings = $this->instance['settings'];
- $element['transcript_fields'] = [
- '#type' => 'value',
- '#default_value' => $settings['transcript_fields'],
- ];
-
-
- $bundle = tripal_load_bundle_entity(['accession' => 'SO:0000234']);
- if (!$bundle) {
- return $element;
- }
- $fields = field_info_instances('TripalEntity', $bundle->name);
- foreach ($fields as $field_name => $details) {
- $defaults = [];
- if (array_key_exists($field_name, $settings['transcript_fields'])) {
- $defaults = $settings['transcript_fields'][$field_name];
- }
- $weight = array_key_exists('weight', $defaults) ? $defaults['weight'] : $details['display']['default']['weight'];
- $checked = array_key_exists('show', $defaults) ? $defaults['show'] : 0;
- $element['themeable']['field-'. $weight] = [
- '#type' => 'value',
- '#value' => $field_name,
- '#weight' => $weight,
- ];
- $element['themeable']['field-'. $weight . '-check'] = [
- '#type' => 'checkbox',
- '#weight' => $weight,
- '#default_value' => $checked,
- ];
- $element['themeable']['field-'. $weight . '-label'] = [
- '#type' => 'markup',
- '#markup' => t($details['label']),
- '#weight' => $weight,
- ];
- $element['themeable']['field-'. $weight . '-description'] = [
- '#type' => 'markup',
- '#markup' => t($details['description']),
- '#weight' => $weight,
- ];
- $element['themeable']['field-'. $weight . '-weight'] = [
- '#type' => 'textfield',
- '#default_value' => $weight,
- '#weight' => $weight,
- '#size' => 3,
- '#attributes' => [
- 'class' => ['tripal-field-settings-table-weights'],
- ],
- ];
- }
- return $element;
- }
-
- public function instanceSettingsFormValidate($form, &$form_state) {
- $settings = $form_state['values']['instance']['settings']['themeable'];
-
-
- $temp = [];
- foreach ($settings as $element => $value) {
- $matches = [];
- if (preg_match('/^field-(\d+)-check$/', $element, $matches)) {
- $orig_weight = $matches[1];
- $new_weight = $settings['field-' . $orig_weight . '-weight'];
- $field_name = $settings['field-' . $orig_weight];
- $temp[$new_weight]['name'] = $field_name;
- $temp[$new_weight]['show'] = $value;
- }
- }
-
- ksort($temp);
- $temp = array_values($temp);
-
- $transcript_fields = [];
- foreach ($temp as $weight => $field) {
- $field_name = $field['name'];
- $transcript_fields[$field_name] = [
- 'weight' => $weight,
- 'show' => $field['show'],
- ];
- }
-
- $form_state['values']['instance']['settings']['transcript_fields'] = $transcript_fields;
- unset($form_state['values']['instance']['settings']['themeable']);
- }
-
- public function settingsTheme($element) {
- $headers = ['', 'Field', 'Description', ''];
- $rows = [];
- foreach (element_children($element) as $child) {
- $matches = [];
- if (preg_match('/^field-(\d+)-(.+)$/', $child, $matches)) {
- $weight = $matches[1];
- switch ($matches[2]) {
- case 'check':
- $rows[$weight]['data'][0] = drupal_render($element[$child]);
- break;
- case 'label':
- $rows[$weight]['data'][1] = drupal_render($element[$child]);
- break;
- case 'description':
- $rows[$weight]['data'][2] = drupal_render($element[$child]);
- break;
- case 'weight':
- $rows[$weight]['data'][3] = drupal_render($element[$child]);
- break;
- }
- ksort($rows[$weight]['data']);
- $rows[$weight]['class'] = ['draggable'];
- }
- }
- ksort($rows);
- $table = [
- 'header' => $headers,
- 'rows' => $rows,
- 'attributes' => ["id" => 'tripal-field-settings-table'],
- 'sticky' => TRUE,
- 'caption' => t('Content Panes Available in the TOC'),
- 'colgroups' => [],
- 'empty' => t('There are no content panes for this page. The mRNA content type must exist to customize.'),
- ];
- drupal_add_tabledrag('tripal-field-settings-table', 'order', 'sibling', 'tripal-field-settings-table-weights');
- $fset = [];
- $fset['fields'] = [
- '#type' => 'fieldset',
- '#title' => 'Transcript (mRNA) Field Selection',
- '#description' => t('Here, you can customize what information is provided to the end-user about transcripts. Select the fields that you want displayed on the page. If no fields are selected then a default display is provided. All mRNA for a gene must be published or the default display will be provided.'),
- '#collapsible' => TRUE,
- '#collapsed' => TRUE,
- '#attributes' => ['class' => ['collapsible', 'collapsed']],
- ];
- drupal_add_library('system', 'drupal.collapse');
- $fset['fields']['table'] = [
- '#type' => 'markup',
- '#markup' => theme_table($table),
- ];
- return drupal_render($fset['fields']);
- }
- }
|