data__accession.inc 6.7 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172
  1. <?php
  2. class data__accession extends ChadoField {
  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 = 'Site Accession';
  12. // The default description for this field.
  13. public static $description = 'The unique stable accession (ID) for this record on this site.';
  14. // Provide a list of instance specific settings. These can be access within
  15. // the instanceSettingsForm. When the instanceSettingsForm is submitted
  16. // then Drupal with automatically change these settings for the instnace.
  17. // It is recommended to put settings at the instance level whenever possible.
  18. // If you override this variable in a child class be sure to replicate the
  19. // term_name, term_vocab, term_accession and term_fixed keys as these are
  20. // required for all TripalFields.
  21. public static $default_instance_settings = array(
  22. // The short name for the vocabulary (e.g. shcema, SO, GO, PATO, etc.).
  23. 'term_vocabulary' => 'data',
  24. // The name of the term.
  25. 'term_name' => 'accession',
  26. // The unique ID (i.e. accession) of the term.
  27. 'term_accession' => '2091',
  28. // Set to TRUE if the site admin is allowed to change the term
  29. // type. This will create form elements when editing the field instance
  30. // to allow the site admin to change the term settings above.
  31. 'term_fixed' => FALSE,
  32. );
  33. // In order for this field to integrate with Drupal Views, a set of
  34. // handlers must be specififed. These include handlers for
  35. // the field, for the filter, and the sort. Within this variable,
  36. // the key must be one of: field, filter, sort; and the value
  37. // is the settings for those handlers as would be provided by
  38. // a hook_views_data(). The following defaults make a field visible
  39. // using the default formatter of the field, allow for filtering using
  40. // a string value and sortable. in order for filters to work you
  41. // must implement the query() function.
  42. public static $default_view_handlers = array(
  43. 'field' => array(
  44. 'handler' => 'tripal_views_handler_field',
  45. 'click sortable' => TRUE,
  46. ),
  47. 'filter' => array(
  48. 'handler' => 'tripal_views_handler_filter_string',
  49. ),
  50. 'sort' => array(
  51. 'handler' => 'views_handler_sort',
  52. ),
  53. );
  54. // The default widget for this field.
  55. public static $default_widget = 'data__accession_widget';
  56. // The default formatter for this field.
  57. public static $default_formatter = 'data__accession_formatter';
  58. /**
  59. * @see TripalField::load()
  60. */
  61. public function load($entity) {
  62. $record = $entity->chado_record;
  63. $field_name = $this->field['field_name'];
  64. $field_type = $this->field['type'];
  65. $field_table = $this->instance['settings']['chado_table'];
  66. $field_column = $this->instance['settings']['chado_column'];
  67. // Set some defauls for the empty record
  68. $entity->{$field_name}['und'][0] = array(
  69. 'value' => '',
  70. 'chado-' . $field_table . '__' . $field_column => '',
  71. 'db_id' => '',
  72. 'accession' => '',
  73. 'version' => '',
  74. 'description' => '',
  75. );
  76. // Get the primary dbxref record (if it's not NULL). Because we have a
  77. // dbxref_id passed in by the base record, we will only have one record.
  78. if ($record->$field_column) {
  79. $dbxref = $record->$field_column;
  80. $value = $dbxref->db_id->name . ':' . $dbxref->accession;
  81. $entity->{$field_name}['und'][0] = array(
  82. 'value' => $dbxref->accession,
  83. 'chado-' . $field_table . '__' . $field_column => $record->$field_column->$field_column,
  84. 'db_id' => $dbxref->db_id->db_id,
  85. 'accession' => $dbxref->accession,
  86. 'version' => $dbxref->version,
  87. 'description' => $dbxref->description,
  88. );
  89. }
  90. }
  91. /**
  92. * @see ChadoField::query()
  93. */
  94. public function query($query, $condition) {
  95. $chado_table = $this->instance['settings']['chado_table'];
  96. $base_table = $this->instance['settings']['base_table'];
  97. $bschema = chado_get_schema($base_table);
  98. $bpkey = $bschema['primary key'][0];
  99. $alias = 'dbx_linker';
  100. $operator = $condition['operator'];
  101. // We don't offer any sub elements so the value coming in should
  102. // always be the field_name.
  103. if ($condition['column'] == 'data__accession') {
  104. $query->join('dbxref', 'DBX', "DBX.dbxref_id = base.dbxref_id");
  105. $query->condition("DBX.accession", $condition['value'], $operator);
  106. }
  107. }
  108. /**
  109. * @see TripalField::validate()
  110. */
  111. public function validate($entity_type, $entity, $field, $items, &$errors) {
  112. $field_name = $this->field['field_name'];
  113. $settings = $this->field['settings'];
  114. $field_type = $this->field['type'];
  115. $field_table = $this->instance['settings']['chado_table'];
  116. $field_column = $this->instance['settings']['chado_column'];
  117. // Get the field values.
  118. foreach ($items as $delta => $values) {
  119. $fk_val = $values['chado-' . $field_table . '__' . $field_column];
  120. $db_id = $values['db_id'];
  121. $accession = $values['accession'];
  122. $version = $values['version'];
  123. $description = $values['description'];
  124. // Make sure that if a database ID is provided that an accession is also
  125. // provided. Here we use the form_set_error function rather than the
  126. // form_error function because the form_error will add a red_highlight
  127. // around all of the fields in the fieldset which is confusing as it's not
  128. // clear to the user what field is required and which isn't. Therefore,
  129. // we borrow the code from the 'form_error' function and append the field
  130. // so that the proper field is highlighted on error.
  131. if (!$db_id and $accession) {
  132. $errors[$field_name][$delta]['und'][] = array(
  133. 'message' => t("A database and the accession must both be provided for the primary cross reference."),
  134. 'error' => 'chado_base__dbxref',
  135. );
  136. }
  137. if ($db_id and !$accession) {
  138. $errors[$field_name][$delta]['und'][] = array(
  139. 'message' => t("A database and the accession must both be provided for the primary cross reference."),
  140. 'error' => 'chado_base__dbxref',
  141. );
  142. }
  143. if (!$db_id and !$accession and ($version or $description)) {
  144. $errors[$field_name][$delta]['und'][] = array(
  145. 'message' => t("A database and the accession must both be provided for the primary cross reference."),
  146. 'error' => 'chado_base__dbxref',
  147. );
  148. }
  149. }
  150. }
  151. }