chado_linker__prop.inc 5.4 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138
  1. <?php
  2. class chado_linker__prop extends TripalField {
  3. // --------------------------------------------------------------------------
  4. // EDITABLE STATIC CONSTANTS
  5. //
  6. // The following constants SHOULD be set for each descendent class. They are
  7. // used by the static functions to provide information to Drupal about
  8. // the field and it's default widget and formatter.
  9. // --------------------------------------------------------------------------
  10. // The default lable for this field.
  11. public static $default_label = 'Property';
  12. // The default description for this field.
  13. public static $description = 'Add details about this property.';
  14. // Provide a list of global settings. These can be accessed witihn the
  15. // globalSettingsForm. When the globalSettingsForm is submitted then
  16. // Drupal will automatically change these settings for all fields.
  17. public static $default_settings = array(
  18. 'chado_table' => '',
  19. 'chado_column' => '',
  20. 'base_table' => '',
  21. );
  22. // Provide a list of instance specific settings. These can be access within
  23. // the instanceSettingsForm. When the instanceSettingsForm is submitted
  24. // then Drupal with automatically change these settings for the instnace.
  25. // It is recommended to put settings at the instance level whenever possible.
  26. // If you override this variable in a child class be sure to replicate the
  27. // term_name, term_vocab, term_accession and term_fixed keys as these are
  28. // required for all TripalFields.
  29. public static $default_instance_settings = array(
  30. // The short name for the vocabulary (e.g. shcema, SO, GO, PATO, etc.).
  31. 'term_vocabulary' => 'local',
  32. // The name of the term.
  33. 'term_name' => 'property',
  34. // The unique ID (i.e. accession) of the term.
  35. 'term_accession' => 'property',
  36. // Set to TRUE if the site admin is allowed to change the term
  37. // type. This will create form elements when editing the field instance
  38. // to allow the site admin to change the term settings above.
  39. 'term_fixed' => FALSE,
  40. );
  41. // Set this to the name of the storage backend that by default will support
  42. // this field.
  43. public static $storage = 'field_chado_storage';
  44. // The default widget for this field.
  45. public static $default_widget = 'chado_linker__prop_widget';
  46. // The default formatter for this field.
  47. public static $default_formatter = 'chado_linker__prop_formatter';
  48. // --------------------------------------------------------------------------
  49. // PROTECTED CLASS MEMBERS -- DO NOT OVERRIDE
  50. // --------------------------------------------------------------------------
  51. // An array containing details about the field. The format of this array
  52. // is the same as that returned by field_info_fields()
  53. protected $field;
  54. // An array containing details about an instance of the field. A field does
  55. // not have to have an instance. But if dealing with an instance (such as
  56. // when using the widgetForm, formatterSettingsForm, etc.) it should be set.
  57. protected $instance;
  58. /**
  59. *
  60. * @see TripalField::validate()
  61. */
  62. public function validate($entity_type, $entity, $field, $items, &$errors) {
  63. }
  64. /**
  65. *
  66. * @see TripalField::load()
  67. */
  68. public function load($entity, $details = array()) {
  69. $field_name = $this->field['field_name'];
  70. $field_type = $this->field['type'];
  71. $field_table = $this->field['settings']['chado_table'];
  72. $field_column = $this->field['settings']['chado_column'];
  73. $base_table = $this->field['settings']['base_table'];
  74. $matches = array();
  75. preg_match('/(.*?)__(\d+)/', $field_name, $matches);
  76. $table_name = $matches[1];
  77. $cvterm_id = $matches[2];
  78. // Get the FK that links to the base record.
  79. $schema = chado_get_schema($field_table);
  80. $pkey = $schema['primary key'][0];
  81. $fkey_lcolumn = key($schema['foreign keys'][$base_table]['columns']);
  82. $fkey_rcolumn = $schema['foreign keys'][$base_table]['columns'][$fkey_lcolumn];
  83. // Set some defaults for the empty record.
  84. $chado_record = $entity->chado_record;
  85. $entity->{$field_name}['und'][0] = array(
  86. 'value' => '',
  87. 'chado-' . $field_table . '__' . $pkey => '',
  88. 'chado-' . $field_table . '__' . $fkey_lcolumn => $chado_record->{$fkey_lcolumn},
  89. 'chado-' . $field_table . '__value' => '',
  90. 'chado-' . $field_table . '__type_id' => '',
  91. 'chado-' . $field_table . '__rank' => '',
  92. );
  93. // Get the properties associated with this base record for this fields
  94. // given type.
  95. $columns = array('*');
  96. $match = array(
  97. $fkey_lcolumn => $chado_record->{$fkey_lcolumn},
  98. 'type_id' => $cvterm_id,
  99. );
  100. $options = array(
  101. 'return_array' => TRUE,
  102. 'order_by' => array('rank' => 'ASC')
  103. );
  104. $properties = chado_select_record($field_table, $columns, $match, $options);
  105. for ($i = 0; $i < count($properties); $i++) {
  106. $property = $properties[$i];
  107. foreach ($schema['fields'] as $fname => $details) {
  108. $entity->{$field_name}['und'][$i] = array(
  109. 'value' => array(),
  110. 'chado-' . $field_table . '__' . $pkey => $property->$pkey,
  111. 'chado-' . $field_table . '__' . $fkey_lcolumn => $property->$fkey_lcolumn,
  112. 'chado-' . $field_table . '__value' => $property->value,
  113. 'chado-' . $field_table . '__type_id' => $property->type_id,
  114. 'chado-' . $field_table . '__rank' => $property->rank,
  115. );
  116. }
  117. }
  118. }
  119. }