chado_linker__synonym.inc 14 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382
  1. <?php
  2. class chado_linker__synonym extends TripalField {
  3. /**
  4. * @see TripalField::field_info()
  5. */
  6. function field_info() {
  7. return array(
  8. 'label' => t('Synonyms'),
  9. 'description' => t('Adds an alternative name (synonym or alias) to this record.'),
  10. 'default_widget' => 'chado_linker__synonym_widget',
  11. 'default_formatter' => 'chado_linker__synonym_formatter',
  12. 'settings' => array(),
  13. 'storage' => array(
  14. 'type' => 'field_chado_storage',
  15. 'module' => 'tripal_chado',
  16. 'active' => TRUE
  17. ),
  18. );
  19. }
  20. /**
  21. * @see TripalField::attach_info()
  22. */
  23. function attach_info($entity_type, $bundle, $target) {
  24. $field_info = array();
  25. $table_name = $target['data_table'];
  26. $type_table = $target['type_table'];
  27. $type_field = $target['field'];
  28. $cv_id = $target['cv_id'];
  29. $cvterm_id = $target['cvterm_id'];
  30. // If the linker table does not exists then we don't want to add attach.
  31. $syn_table = $table_name . '_synonym';
  32. if (!chado_table_exists($syn_table)) {
  33. return $field_info;
  34. }
  35. $schema = chado_get_schema($syn_table);
  36. $pkey = $schema['primary key'][0];
  37. // Initialize the field array.
  38. $field_info = array(
  39. 'field_name' => $table_name . '__synonym',
  40. 'field_type' => 'chado_linker__synonym',
  41. 'widget_type' => 'chado_linker__synonym_widget',
  42. 'widget_settings' => array('display_label' => 1),
  43. 'description' => '',
  44. 'label' => 'Synonyms',
  45. 'is_required' => 0,
  46. 'cardinality' => FIELD_CARDINALITY_UNLIMITED,
  47. 'storage' => 'field_chado_storage',
  48. 'field_settings' => array(
  49. 'chado_table' => $syn_table,
  50. 'chado_column' => $pkey,
  51. 'base_table' => $table_name,
  52. 'semantic_web' => array(
  53. 'name' => 'alternateName',
  54. 'accession' => 'alternateName',
  55. 'ns' => 'schema',
  56. 'nsurl' => 'https://schema.org/',
  57. ),
  58. ),
  59. );
  60. return $field_info;
  61. }
  62. /**
  63. * @see TripalField::widget_info()
  64. */
  65. function widget_info() {
  66. return array(
  67. 'label' => t('Synonyms'),
  68. 'field types' => array('chado_linker__synonym'),
  69. );
  70. }
  71. /**
  72. * @see TripalField::formatter_info()
  73. */
  74. function formatter_info() {
  75. return array(
  76. 'label' => t('Synonyms'),
  77. 'field types' => array('chado_linker__synonym'),
  78. 'settings' => array(
  79. ),
  80. );
  81. }
  82. /**
  83. * @see TripalField::formatter_view()
  84. */
  85. function formatter_view(&$element, $entity_type, $entity, $field,
  86. $instance, $langcode, $items, $display) {
  87. $chado_table = $field['settings']['chado_table'];
  88. foreach ($items as $delta => $item) {
  89. if ($item[$chado_table . '__synonym_id']) {
  90. $synonym = chado_generate_var('synonym', array('synonym_id' => $item[$chado_table . '__synonym_id']));
  91. $name = $synonym->name;
  92. if ($synonym->type_id->name != 'exact') {
  93. $name .= ' (<i>' . $synonym->type_id->name . '</i>)';
  94. }
  95. $element[$delta] = array(
  96. '#type' => 'markup',
  97. '#markup' => $name,
  98. );
  99. }
  100. }
  101. }
  102. /**
  103. * @see TripalField::widget_form()
  104. */
  105. function widget_form(&$widget, $form, $form_state, $field,
  106. $instance, $langcode, $items, $delta, $element) {
  107. $entity = $form['#entity'];
  108. $field_name = $field['field_name'];
  109. // Get the FK column that links to the base table.
  110. $table_name = $field['settings']['chado_table'];
  111. $base_table = $field['settings']['base_table'];
  112. $schema = chado_get_schema($table_name);
  113. $pkey = $schema['primary key'][0];
  114. $fkeys = array_values($schema['foreign keys'][$base_table]['columns']);
  115. $fkey = $fkeys[0];
  116. // Get the field defaults.
  117. $record_id = '';
  118. $fkey_value = $element['#entity']->chado_record_id;
  119. $synonym_id = '';
  120. $pub_id = '';
  121. $is_current = TRUE;
  122. $is_internal = FALSE;
  123. $syn_name = '';
  124. $syn_type = '';
  125. // If the field already has a value then it will come through the $items
  126. // array. This happens when editing an existing record.
  127. if (array_key_exists($delta, $items)) {
  128. $record_id = $items[$delta]['value'];
  129. $fkey_value = $items[$delta][$table_name . '__' . $fkey];
  130. $synonym_id = $items[$delta][$table_name . '__synonym_id'];
  131. $pub_id = $items[$delta][$table_name . '__pub_id'];
  132. $is_current = $items[$delta][$table_name . '__is_current'];
  133. $is_internal = $items[$delta][$table_name . '__is_internal'];
  134. $syn_name = $items[$delta][$table_name . '--synonym__name'];
  135. $syn_type = $items[$delta][$table_name . '--synonym__type_id'];
  136. }
  137. // Check $form_state['values'] to see if an AJAX call set the values.
  138. if (array_key_exists('values', $form_state) and array_key_exists($delta, $form_state['values'])) {
  139. $record_id = tripal_chado_get_field_form_values($table_name, $form_state, $delta, $table_name);
  140. $fkey_value = tripal_chado_get_field_form_values($table_name, $form_state, $delta, $table_name . '__' . $fkey);
  141. $synonym_id = tripal_chado_get_field_form_values($table_name, $form_state, $delta, $table_name . '__synonym_id');
  142. $pub_id = tripal_chado_get_field_form_values($table_name, $form_state, $delta, $table_name . '__pub_id');
  143. $is_current = tripal_chado_get_field_form_values($table_name, $form_state, $delta, $table_name . '__is_current');
  144. $is_internal = tripal_chado_get_field_form_values($table_name, $form_state, $delta, $table_name . '__is_internal');
  145. $syn_name = tripal_chado_get_field_form_values($table_name, $form_state, $delta, $table_name . '--synonym__name');
  146. $syn_type = tripal_chado_get_field_form_values($table_name, $form_state, $delta, $table_name . '--synonym__type_id');
  147. }
  148. // Get the synonym type terms. There shouldn't be too many.
  149. $cv = tripal_get_default_cv('synonym', 'type_id');
  150. $options = tripal_get_cvterm_select_options($cv->cv_id);
  151. // Get the schema for the synonym table so we can make sure we limit the
  152. // size of the name field to the proper size.
  153. $schema = chado_get_schema('synonym');
  154. $widget['#table_name'] = $table_name;
  155. $widget['#fkey_field'] = $fkey;
  156. $widget['#element_validate'] = array('chado_linker__synonym_widget_validate');
  157. $widget['#theme'] = 'chado_linker__synonym_widget';
  158. $widget['#prefix'] = "<span id='$table_name-$delta'>";
  159. $widget['#suffix'] = "</span>";
  160. $widget['value'] = array(
  161. '#type' => 'value',
  162. '#default_value' => $record_id,
  163. );
  164. $widget[$table_name . '__' . $fkey] = array(
  165. '#type' => 'value',
  166. '#default_value' => $fkey_value,
  167. );
  168. $widget[$table_name . '--synonym__type_id'] = array(
  169. '#type' => 'select',
  170. '#title' => t('Type'),
  171. '#options' => $options,
  172. '#default_value' => $syn_type,
  173. );
  174. $widget[$table_name . '--synonym__name'] = array(
  175. '#type' => 'textfield',
  176. '#title' => t('Synonym Name'),
  177. '#default_value' => $syn_name,
  178. '#size' => 25,
  179. );
  180. $widget[$table_name . '__is_current'] = array(
  181. '#type' => 'checkbox',
  182. '#title' => t('Is Current'),
  183. '#default_value' => $is_current,
  184. '#required' => $element['#required'],
  185. );
  186. $widget[$table_name . '__is_internal'] = array(
  187. '#type' => 'checkbox',
  188. '#title' => t('Is Internal'),
  189. '#default_value' => $is_internal,
  190. '#required' => $element['#required'],
  191. );
  192. }
  193. /**
  194. * @see TripalField::load()
  195. */
  196. function load($field, $entity, $details) {
  197. $record = $details['record'];
  198. $base_table = $field['settings']['base_table'];
  199. $field_name = $field['field_name'];
  200. $field_type = $field['type'];
  201. $field_table = $field['settings']['chado_table'];
  202. $field_column = $field['settings']['chado_column'];
  203. // Get the FK that links to the base record.
  204. $schema = chado_get_schema($field_table);
  205. $pkey = $schema['primary key'][0];
  206. $fkey_lcolumn = key($schema['foreign keys'][$base_table]['columns']);
  207. $fkey_rcolumn = $schema['foreign keys'][$base_table]['columns'][$fkey_lcolumn];
  208. // Set some defaults for the empty record.
  209. $entity->{$field_name}['und'][0] = array(
  210. 'value' => '',
  211. $field_table . '__' . $fkey_lcolumn => '',
  212. $field_table . '__' . 'synonym_id' => '',
  213. $field_table . '__' . 'pub_id' => '',
  214. $field_table . '__' . 'is_current' => TRUE,
  215. $field_table . '__' . 'is_internal' => '',
  216. $field_table . '--' . 'synonym__name' => '',
  217. $field_table . '--' . 'synonym__type_id' => '',
  218. // Ignore the synonym_sgml column for now.
  219. );
  220. $linker_table = $base_table . '_synonym';
  221. $options = array('return_array' => 1);
  222. $record = chado_expand_var($record, 'table', $linker_table, $options);
  223. if (count($record->$linker_table) > 0) {
  224. $i = 0;
  225. foreach ($record->$linker_table as $index => $linker) {
  226. $synonym = $linker->synonym_id;
  227. $entity->{$field_name}['und'][$i] = array(
  228. 'value' => $linker->$pkey,
  229. $field_table . '__' . $fkey_lcolumn => $linker->$fkey_lcolumn->$fkey_lcolumn,
  230. $field_table . '__' . 'synonym_id' => $synonym->synonym_id,
  231. $field_table . '__' . 'pub_id' => $linker->pub_id->pub_id,
  232. $field_table . '__' . 'is_current' => $linker->is_current,
  233. $field_table . '__' . 'is_internal' => $linker->is_internal,
  234. $field_table . '--' . 'synonym__name' => $synonym->name,
  235. $field_table . '--' . 'synonym__type_id' => $synonym->type_id->cvterm_id,
  236. );
  237. $i++;
  238. }
  239. }
  240. }
  241. }
  242. /**
  243. * Theme function for the synonym widget.
  244. *
  245. * @param $variables
  246. */
  247. function theme_chado_linker__synonym_widget($variables) {
  248. $element = $variables['element'];
  249. // These two fields were added to the widget to help identify the fields
  250. // for layout.
  251. $table_name = $element['#table_name'];
  252. $fkey = $element['#fkey_field'];
  253. $layout = "
  254. <div class=\"synonym-widget\">
  255. <div class=\"synonym-widget-item\">" .
  256. drupal_render($element[$table_name . '--synonym__name']) . "
  257. </div>
  258. <div>" .
  259. drupal_render($element[$table_name . '--synonym__type_id']) . "
  260. </div>
  261. <div class=\"synonym-widget-item\">" .
  262. drupal_render($element[$table_name . '__is_internal']) . "
  263. </div>
  264. <div>" .
  265. drupal_render($element[$table_name . '__is_current']) . "
  266. </div>
  267. </div>
  268. ";
  269. return $layout;
  270. }
  271. /**
  272. * Callback function for validating the chado_linker__synonym_widget.
  273. */
  274. function chado_linker__synonym_widget_validate($element, &$form_state) {
  275. $field_name = $element['#field_name'];
  276. $delta = $element['#delta'];
  277. $table_name = $element['#table_name'];
  278. $fkey = $element['#fkey_field'];
  279. // If the form ID is field_ui_field_edit_form, then the user is editing the
  280. // field's values in the manage fields form of Drupal. We don't want
  281. // to validate it as if it were being used in a data entry form.
  282. if ($form_state['build_info']['form_id'] =='field_ui_field_edit_form') {
  283. return;
  284. }
  285. // Get the field values.
  286. $fkey_value = tripal_chado_get_field_form_values($table_name, $form_state, $delta, $table_name . '__' . $fkey);
  287. $synonym_id = tripal_chado_get_field_form_values($table_name, $form_state, $delta, $table_name . '__synonym_id');
  288. $pub_id = tripal_chado_get_field_form_values($table_name, $form_state, $delta, $table_name . '__pub_id');
  289. $is_current = tripal_chado_get_field_form_values($table_name, $form_state, $delta, $table_name . '__is_current');
  290. $is_internal = tripal_chado_get_field_form_values($table_name, $form_state, $delta, $table_name . '__is_internal');
  291. $syn_name = tripal_chado_get_field_form_values($table_name, $form_state, $delta, $table_name . '--synonym__name');
  292. $syn_type = tripal_chado_get_field_form_values($table_name, $form_state, $delta, $table_name . '--synonym__type_id');
  293. // Make sure that if a synonym is provided that a type is also
  294. // provided.
  295. if ($syn_name and !$syn_type) {
  296. form_set_error(implode('][', $element ['#parents']) . '][' . $table_name . '--synonym__type_id', t("Please set a synonym type."));
  297. }
  298. if (!$syn_name and $syn_type) {
  299. form_set_error(implode('][', $element ['#parents']) . '][' . $table_name . '--synonym__name', t("Please set a synonym name."));
  300. }
  301. // If the user provided a cv_id and a name then we want to set the
  302. // foreign key value to be the chado_record_idd
  303. if ($syn_name and $syn_type) {
  304. // Get the synonym. If one with the same name and type is already present
  305. // then use that. Otherwise, insert a new one.
  306. if (!$synonym_id) {
  307. $synonym = chado_generate_var('synonym', array('name' => $syn_name, 'type_id' => $syn_type));
  308. if (!$synonym) {
  309. $synonym = chado_insert_record('synonym', array(
  310. 'name' => $syn_name,
  311. 'type_id' => $syn_type,
  312. 'synonym_sgml' => '',
  313. ));
  314. $synonym = (object) $synonym;
  315. }
  316. // Set the synonym_id and FK value
  317. tripal_chado_set_field_form_values($field_name, $form_state, $synonym->synonym_id, $delta, $table_name . '__synonym_id');
  318. $fkey_value = $element['#entity']->chado_record_id;
  319. tripal_chado_set_field_form_values($field_name, $form_state, $fkey_value, $delta, $table_name . '__' . $fkey);
  320. }
  321. if (!$pub_id) {
  322. $pub = chado_generate_var('pub', array('uniquename' => 'null'));
  323. tripal_chado_set_field_form_values($field_name, $form_state, $pub->pub_id, $delta, $table_name . '__pub_id');
  324. }
  325. }
  326. else {
  327. // If the $syn_name is not set, then remove the linker FK value to the base table.
  328. tripal_chado_set_field_form_values($field_name, $form_state, '', $delta, $table_name . '__' . $fkey);
  329. tripal_chado_set_field_form_values($field_name, $form_state, '', $delta, $table_name . '__synonym_id');
  330. tripal_chado_set_field_form_values($field_name, $form_state, '', $delta, $table_name . '__is_internal');
  331. tripal_chado_set_field_form_values($field_name, $form_state, '', $delta, $table_name . '__is_current');
  332. }
  333. }
  334. /**
  335. * An Ajax callback for the synonym widget.
  336. */
  337. function chado_linker__synonym_widget_form_ajax_callback($form, $form_state) {
  338. $field_name = $form_state['triggering_element']['#parents'][0];
  339. $delta = $form_state['triggering_element']['#parents'][2];
  340. return $form[$field_name]['und'][$delta];
  341. }