tripal_chado.fields.inc 29 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822
  1. <?php
  2. /**
  3. * Implements hook_field_info().
  4. *
  5. * This function would normally provide a large info array for all of the
  6. * fields provided by this module. But instead it will call a hook that
  7. * can be implmented within each individual field file. This will allow
  8. * all of the code for a single field to be self contained in a single file.
  9. *
  10. * New fields can be added automatically by including a new file in the
  11. * tripal_chado/includes/fields directory. The file must be named with a
  12. * 'chado_' prefix and end with a '.inc' suffix. After adding the file,
  13. * the cache must be cleared.
  14. *
  15. */
  16. function tripal_chado_field_info() {
  17. $info = array();
  18. // Find all of the files in the tripal_chado/includes/fields directory.
  19. $fields_path = drupal_get_path('module', 'tripal_chado') . '/includes/fields';
  20. $field_files = file_scan_directory($fields_path, '/^chado_.*\.inc$/');
  21. // Iterate through the fields, include the file and run the info function.
  22. foreach ($field_files as $file) {
  23. $field_type = $file->name;
  24. module_load_include('inc', 'tripal_chado', 'includes/fields/' . $field_type);
  25. if (preg_match('/^chado/', $field_type) and class_exists($field_type)) {
  26. $field_obj = new $field_type();
  27. $info[$field_type] = $field_obj->field_info();
  28. }
  29. $function = $field_type . '_info';
  30. if (function_exists($function)) {
  31. $info[$field_type] = $function();
  32. }
  33. }
  34. return $info;
  35. }
  36. /**
  37. * Implements hook_field_widget_info().
  38. *
  39. * This function would normally provide a large info array for all of the
  40. * widgets provided by this module. But instead it will call a hook that
  41. * can be implmented within each individual field file. This will allow
  42. * all of the code for a single field to be self contained in a single file.
  43. */
  44. function tripal_chado_field_widget_info() {
  45. $widgets = array();
  46. $fields = field_info_fields();
  47. foreach ($fields as $field) {
  48. $field_type = $field['type'];
  49. if ($field['storage']['type'] == 'field_chado_storage') {
  50. module_load_include('inc', 'tripal_chado', 'includes/fields/' . $field_type);
  51. if (preg_match('/^chado/', $field_type) and class_exists($field_type)) {
  52. $field_obj = new $field_type();
  53. $widgets[$field_type . '_widget'] = $field_obj->widget_info();
  54. }
  55. $function = $field_type . '_widget_info';
  56. if (function_exists($function)) {
  57. $widgets[$field_type . '_widget'] = $function();
  58. }
  59. }
  60. }
  61. return $widgets;
  62. }
  63. /**
  64. * Implements hook_field_formatter_info().
  65. *
  66. * This function would normally provide a large info array for all of the
  67. * formatters provided by this module. But instead it will call a hook that
  68. * can be implmented within each individual field file. This will allow
  69. * all of the code for a single field to be self contained in a single file.
  70. */
  71. function tripal_chado_field_formatter_info() {
  72. $formatters = array();
  73. $fields = field_info_fields();
  74. foreach ($fields as $field) {
  75. $field_type = $field['type'];
  76. if ($field['storage']['type'] == 'field_chado_storage') {
  77. module_load_include('inc', 'tripal_chado', 'includes/fields/' . $field_type);
  78. if (preg_match('/^chado/', $field_type) and class_exists($field_type)) {
  79. $field_obj = new $field_type();
  80. $formatters[$field_type . '_formatter'] = $field_obj->formatter_info();
  81. }
  82. $function = $field_type . '_formatter_info';
  83. if (function_exists($function)) {
  84. $formatters[$field_type . '_formatter'] = $function();
  85. }
  86. }
  87. }
  88. return $formatters;
  89. }
  90. /**
  91. * Implements hook_field_settings_form()
  92. */
  93. function tripal_chado_field_settings_form($field, $instance, $has_data) {
  94. $form = '';
  95. $field_type = $field['type'];
  96. module_load_include('inc', 'tripal_chado', 'includes/fields/' . $field_type);
  97. if (preg_match('/^chado/', $field_type) and class_exists($field_type)) {
  98. $field_obj = new $field_type();
  99. $form = $field_obj->settings_form($field, $instance, $has_data);
  100. }
  101. $function = $field_type . '_settings_form';
  102. if (function_exists($function)) {
  103. $form = $function($field, $instance, $has_data);
  104. }
  105. return $form;
  106. }
  107. /**
  108. * Implements hook_field_formatter_settings_summary().
  109. */
  110. function tripal_chado_field_formatter_settings_summary($field, $instance, $view_mode) {
  111. $summary = '';
  112. $field_type = $field['type'];
  113. module_load_include('inc', 'tripal_chado', 'includes/fields/' . $field_type);
  114. if (preg_match('/^chado/', $field_type) and class_exists($field_type)) {
  115. $field = new $field_type();
  116. $summary = $field->formatter_settings_summary($field, $instance, $view_mode);
  117. }
  118. $function = $field_type . '_formatter_settings_summary';
  119. if (function_exists($function)) {
  120. $summary = $function($field, $instance, $view_mode);
  121. }
  122. return $summary;
  123. }
  124. /**
  125. * Implements hook_field_formatter_settings_form().
  126. */
  127. function tripal_chado_field_formatter_settings_form($field, $instance,
  128. $view_mode, $form, &$form_state) {
  129. $element = array();
  130. $field_type = $field['type'];
  131. form_load_include($form_state, 'inc', 'tripal_chado', 'includes/fields/' . $field_type);
  132. module_load_include('inc', 'tripal_chado', 'includes/fields/' . $field_type);
  133. if (preg_match('/^chado/', $field_type) and class_exists($field_type)) {
  134. $field_obj = new $field_type();
  135. $element = $field_obj->formatter_settings_form($field, $instance, $view_mode, $form, $form_state);
  136. }
  137. $function = $field_type . '_formatter_settings_form';
  138. if (function_exists($function)) {
  139. $element = $function($field, $instance, $view_mode, $form, $form_state);
  140. }
  141. return $element;
  142. }
  143. /**
  144. * Implements hook_field_formatter_view().
  145. */
  146. function tripal_chado_field_formatter_view($entity_type, $entity, $field,
  147. $instance, $langcode, $items, $display) {
  148. $element = array();
  149. $field_type = $field['type'];
  150. module_load_include('inc', 'tripal_chado', 'includes/fields/' . $field_type);
  151. if (preg_match('/^chado/', $field_type) and class_exists($field_type)) {
  152. $field_obj = new $field_type();
  153. $field_obj->formatter_view($element, $entity_type, $entity, $field, $instance, $langcode, $items, $display);
  154. }
  155. $function = $display['type'];
  156. if (function_exists($function)) {
  157. $function($element, $entity_type, $entity, $field, $instance, $langcode, $items, $display);
  158. }
  159. return $element;
  160. }
  161. /**
  162. * Implements hook_field_widget_form().
  163. */
  164. function tripal_chado_field_widget_form(&$form, &$form_state, $field,
  165. $instance, $langcode, $items, $delta, $element) {
  166. $widget = $element;
  167. $field_name = $instance['field_name'];
  168. $field_type = $field['type'];
  169. form_load_include($form_state, 'inc', 'tripal_chado', 'includes/fields/' . $field_type);
  170. module_load_include('inc', 'tripal_chado', 'includes/fields/' . $field_name);
  171. if (preg_match('/^chado/', $field_type) and class_exists($field_type)) {
  172. $field_obj = new $field_type();
  173. $field_obj->widget_form($widget, $form, $form_state, $field, $instance, $langcode, $items, $delta, $element);
  174. }
  175. $function = $field_type . '_widget';
  176. if (function_exists($function)) {
  177. $function($widget, $form, $form_state, $field, $instance, $langcode, $items, $delta, $element);
  178. }
  179. return $widget;
  180. }
  181. /**
  182. * Returns the values of the field from the $form_state.
  183. */
  184. function tripal_chado_get_field_form_values($field_name, $form_state, $delta = 0, $child = NULL) {
  185. $value = NULL;
  186. // The form_state must have the 'values' key. If not then just return.
  187. if (!array_key_exists('values', $form_state)) {
  188. return $value;
  189. }
  190. // If the field name is not in the form_state['values'] then return.
  191. if (!array_key_exists($field_name, $form_state['values'])) {
  192. return $value;
  193. }
  194. // Iterate through the values looking for the field_name provided.
  195. foreach ($form_state['values'][$field_name] as $langcode => $items) {
  196. if (!array_key_exists($delta, $items)) {
  197. continue;
  198. }
  199. $item = $items[$delta];
  200. if ($child){
  201. if(array_key_exists($child, $item) and $item[$child] != '') {
  202. $value = $item[$child];
  203. }
  204. }
  205. else {
  206. $value = $item['value'];
  207. }
  208. }
  209. return $value;
  210. }
  211. /**
  212. * Sets the values of the field from the $form_state. If no child
  213. * argument is specified then the 'value' field is set.
  214. *
  215. * @param $field_name
  216. * The name of the field to set.
  217. * @param $form_state
  218. * The form's form_state array.
  219. * @param $newvalue
  220. * The new value to set for the field.
  221. * @param $delta
  222. * If cardinality of a field is greater than 1 the delta indicates
  223. * which instance to set.
  224. * @param $child
  225. * The name of the property to set iff other than 'value'.
  226. *
  227. * @return
  228. * TRUE if the value was set, FALSE otherwise.
  229. */
  230. function tripal_chado_set_field_form_values($field_name, &$form_state, $newvalue, $delta = 0, $child = NULL) {
  231. // The form_state must have the 'values' key. If not then just return.
  232. if (!array_key_exists('values', $form_state)) {
  233. return FALSE;
  234. }
  235. // If the field name is not in the form_state['values'] then reutrn.
  236. if (!array_key_exists($field_name, $form_state['values'])) {
  237. return FALSE;
  238. }
  239. foreach ($form_state['values'][$field_name] as $langcode => $items) {
  240. if ($child) {
  241. $form_state['values'][$field_name][$langcode][$delta][$child] = $newvalue;
  242. }
  243. else {
  244. $form_state['values'][$field_name][$langcode][$delta]['value'] = $newvalue;
  245. }
  246. }
  247. return TRUE;
  248. }
  249. /**
  250. * Implements hook_field_widget_form_alter().
  251. */
  252. function tripal_chado_field_widget_form_alter(&$element, &$form_state, $context) {
  253. if (array_key_exists('#field_name', $element)) {
  254. $field_name = $element['#field_name'];
  255. $matches = array();
  256. if (preg_match('/(.+?)__(.+?)$/', $field_name, $matches)) {
  257. $tablename = $matches[1];
  258. $colname = $matches[2];
  259. $schema = chado_get_schema($tablename);
  260. if (!$schema) {
  261. return;
  262. }
  263. // The timelastmodified field exists in many Chado tables. We want
  264. // the form element to update to the most recent time rather than the time
  265. // in the database.
  266. if ($colname == 'timelastmodified' and $schema['fields'][$colname]['type'] == 'datetime') {
  267. // We want the default value for the field to be the current time.
  268. $element['#default_value']['value'] = format_date(time(), 'custom', "Y-m-d H:i:s", 'UTC');
  269. $element['#date_items']['value'] = $element['#default_value']['value'];
  270. }
  271. // We want the date combo fieldset to be collaspible so we will
  272. // add our own theme_wrapper to replace the one added by the date
  273. // module.
  274. if (array_key_exists($colname, $schema['fields']) and $schema['fields'][$colname]['type'] == 'datetime') {
  275. $element['#theme_wrappers'] = array('tripal_chado_date_combo');
  276. }
  277. }
  278. }
  279. }
  280. /**
  281. * Returns a $field_info array for a field based on a database column.
  282. *
  283. */
  284. function tripal_chado_get_bundle_fields_base__fields_defaults($table_name, $schema, $column_name) {
  285. $details = $schema['fields'][$column_name];
  286. // Create an array with information about this field.
  287. $field = array(
  288. 'field_type' => '',
  289. 'widget_type' => '',
  290. 'description' => '',
  291. 'label' => ucwords(preg_replace('/_/', ' ', $column_name)),
  292. 'is_required' => 0,
  293. 'storage' => 'field_chado_storage',
  294. 'widget_settings' => array(
  295. 'display_label' => 1
  296. ),
  297. 'field_settings' => array(
  298. // The table in Chado where this field maps to.
  299. 'chado_table' => $table_name,
  300. // The column in the Chado table that this field maps to.
  301. 'chado_column' => $column_name,
  302. 'semantic_web' => array(
  303. // The type is the term from a vocabulary that desribes this field..
  304. 'name' => '',
  305. // The accession ID for this term in the vocaulary.
  306. 'accession' => '',
  307. // The namepsace for the vocabulary (e.g. 'foaf').
  308. 'ns' => '',
  309. // The URL for the namespace. It must be that the type can be
  310. // appended to the URL.
  311. 'nsurl' => '',
  312. ),
  313. ),
  314. );
  315. // Alter the field info array depending on the column details.
  316. switch($details['type']) {
  317. case 'char':
  318. $field['field_type'] = 'text';
  319. $field['widget_type'] = 'text_textfield';
  320. $field['field_settings']['max_length'] = $details['length'];
  321. break;
  322. case 'varchar':
  323. $field['field_type'] = 'text';
  324. $field['widget_type'] = 'text_textfield';
  325. $field['field_settings']['max_length'] = $details['length'];
  326. break;
  327. case 'text':
  328. $field['field_type'] = 'text';
  329. $field['widget_type'] = 'text_textarea';
  330. $field['field_settings']['max_length'] = 17179869184;
  331. $field['field_settings']['text_processing'] = 1;
  332. $field['format'] = filter_default_format();
  333. break;
  334. case 'blob':
  335. // not sure how to support a blob field.
  336. continue;
  337. break;
  338. case 'int':
  339. $field['field_type'] = 'number_integer';
  340. $field['widget_type'] = 'number';
  341. break;
  342. case 'float':
  343. $field['field_type'] = 'number_float';
  344. $field['widget_type'] = 'number';
  345. $field['field_settings']['precision'] = 10;
  346. $field['field_settings']['scale'] = 2;
  347. $field['field_settings']['decimal_separator'] = '.';
  348. break;
  349. case 'numeric':
  350. $field['field_type'] = 'number_decimal';
  351. $field['widget_type'] = 'number';
  352. break;
  353. case 'serial':
  354. // Serial fields are most likely not needed as a field.
  355. break;
  356. case 'boolean':
  357. $field['field_type'] = 'list_boolean';
  358. $field['widget_type'] = 'options_onoff';
  359. $field['field_settings']['allowed_values'] = array(0 => "No", 1 => "Yes");
  360. break;
  361. case 'datetime':
  362. // Use the Drupal Date and Date API to create the field/widget
  363. $field['field_type'] = 'datetime';
  364. $field['widget_type'] = 'date_select';
  365. $field['widget_settings']['increment'] = 1;
  366. $field['widget_settings']['tz_handling'] = 'none';
  367. $field['widget_settings']['collapsible'] = TRUE;
  368. // TODO: Add settings so that the minutes increment by 1.
  369. // And turn off the timezone, as the Chado field doesn't support it.
  370. break;
  371. }
  372. // Set some default semantic web information
  373. if ($column_name == 'uniquename') {
  374. $field['field_settings']['semantic_web']['name'] = 'name';
  375. $field['field_settings']['semantic_web']['accession'] = 'name';
  376. $field['field_settings']['semantic_web']['ns'] = 'foaf';
  377. $field['field_settings']['semantic_web']['nsurl'] = 'http://xmlns.com/foaf/0.1/';
  378. $field['widget_type'] = 'text_textfield';
  379. $field['field_settings']['text_processing'] = 0;
  380. }
  381. if ($column_name == 'name') {
  382. // If this table also has a unqiuename field then use the 'name' field
  383. // as an alternate name.
  384. if (array_key_exists('uniquename', $schema['fields'])) {
  385. $field['field_settings']['semantic_web']['name'] = 'alternateName';
  386. $field['field_settings']['semantic_web']['accession'] = 'alternateName';
  387. $field['field_settings']['semantic_web']['ns'] = 'schema';
  388. $field['field_settings']['semantic_web']['nsurl'] = 'https://schema.org/';
  389. }
  390. else {
  391. $field['field_settings']['semantic_web']['name'] = 'name';
  392. $field['field_settings']['semantic_web']['accession'] = 'name';
  393. $field['field_settings']['semantic_web']['ns'] = 'foaf';
  394. $field['field_settings']['semantic_web']['nsurl'] = 'http://xmlns.com/foaf/0.1/';
  395. }
  396. }
  397. if ($column_name == 'description' or $column_name == 'definition' or
  398. $column_name == 'comment') {
  399. $field['field_settings']['semantic_web']['name'] = 'description';
  400. $field['field_settings']['semantic_web']['accession'] = 'description';
  401. $field['field_settings']['semantic_web']['ns'] = 'hydra';
  402. $field['field_settings']['semantic_web']['nsurl'] = 'http://www.w3.org/ns/hydra/core#';
  403. }
  404. if ($field['label'] == 'Timeaccessioned') {
  405. $field['label'] = 'Time Accessioned';
  406. $field['description'] = 'Please enter the time that this record was first added to the database.';
  407. }
  408. elseif ($field['label'] == 'Timelastmodified') {
  409. $field['label'] = 'Time Last Modified';
  410. $field['description'] = 'Please enter the time that this record was last modified. The default is the current time.';
  411. }
  412. //
  413. // ORGANISM TABLE
  414. //
  415. elseif ($field['field_settings']['chado_table'] == 'organism' and $field['field_settings']['chado_column'] == 'comment') {
  416. $field['label'] = 'Description';
  417. }
  418. //
  419. // FEATURE TABLE
  420. //
  421. elseif ($field['field_settings']['chado_table'] == 'pub' and $field['field_settings']['chado_column'] == 'uniquename') {
  422. $field['field_type'] = 'text';
  423. $field['widget_type'] = 'text_textfield';
  424. $field['field_settings']['text_processing'] = 0;
  425. $field['field_settings']['semantic_web']['name'] = 'Comment';
  426. $field['field_settings']['semantic_web']['accession'] = 'Comment';
  427. $field['field_settings']['semantic_web']['ns'] = 'schema';
  428. $field['field_settings']['semantic_web']['nsurl'] = 'https://www.schema.org/';
  429. }
  430. //
  431. // ANALYSIS TABLE
  432. //
  433. elseif ($field['field_settings']['chado_table'] == 'analysis' and $field['field_settings']['chado_column'] == 'program') {
  434. $field['field_settings']['semantic_web']['name'] = 'SoftwareApplication';
  435. $field['field_settings']['semantic_web']['accession'] = 'SoftwareApplication';
  436. $field['field_settings']['semantic_web']['ns'] = 'schema';
  437. $field['field_settings']['semantic_web']['nsurl'] = 'https://schema.org/';
  438. $field['description'] = 'The program name (e.g. blastx, blastp, sim4, genscan. If the analysis was not derived from a software package then provide a very brief description of the pipeline, workflow or method.';
  439. $field['label'] = 'Program, Pipeline, Workflow or Method Name.';
  440. }
  441. elseif ($field['field_settings']['chado_table'] == 'analysis' and $field['field_settings']['chado_column'] == 'sourceuri') {
  442. $field['field_type'] = 'text';
  443. $field['widget_type'] = 'text_textfield';
  444. $field['field_settings']['text_processing'] = 0;
  445. $field['label'] = 'Source URL';
  446. $field['description'] = 'The URL where the original source data was derived. Ideally, this should link to the page where more information about the source data can be found.';
  447. }
  448. elseif ($field['field_settings']['chado_table'] == 'analysis' and $field['field_settings']['chado_column'] == 'sourcename') {
  449. $field['label'] = 'Source Name';
  450. $field['description'] = 'The name of the source data. This could be a file name, data set or a small description for how the data was collected. For long descriptions use the larger description field.';
  451. }
  452. elseif ($field['field_settings']['chado_table'] == 'analysis' and $field['field_settings']['chado_column'] == 'sourceversion') {
  453. $field['label'] = 'Source Version';
  454. $field['description'] = 'If hte source data set has a version include it here.';
  455. }
  456. elseif ($field['field_settings']['chado_table'] == 'analysis' and $field['field_settings']['chado_column'] == 'algorithm') {
  457. $field['label'] = 'Source Version';
  458. $field['description'] = 'The name of the algorithm used to produce the dataset if different from the program.';
  459. }
  460. elseif ($field['field_settings']['chado_table'] == 'analysis' and $field['field_settings']['chado_column'] == 'programversion') {
  461. $field['label'] = 'Program Version';
  462. $field['description'] = 'The version of the program used to perform this analysis. (e.g. TBLASTX 2.0MP-WashU [09-Nov-2000]. Enter "n/a" if no version is available or applicable.';
  463. }
  464. //
  465. // PROJECT TABLE
  466. //
  467. elseif ($field['field_settings']['chado_table'] == 'project' and $field['field_settings']['chado_column'] == 'description') {
  468. $field['label'] = 'Short Description';
  469. }
  470. return $field;
  471. }
  472. /**
  473. * Implements hook_form_FORM_ID_alter().
  474. *
  475. * The field_ui_display_overview_form is used for formatting the display
  476. * or layout of fields attached to an entity and shown on the entity view page.
  477. *
  478. * This function removes the cvterm class and property adder field as those are
  479. * really not meant for users to show or manage.
  480. */
  481. function tripal_chado_form_field_ui_display_overview_form_alter(&$form, &$form_state, $form_id) {
  482. // Remove the kvproperty_addr field as it isn't ever displayed. It's just used
  483. // on the add/edit form of an entity for adding new property fields.
  484. $fields_names = element_children($form['fields']);
  485. foreach ($fields_names as $field_name) {
  486. $field_info = field_info_field($field_name);
  487. if ($field_info['type'] == 'kvproperty_adder') {
  488. unset($form['fields'][$field_name]);
  489. }
  490. if ($field_info['type'] == 'cvterm_class_adder') {
  491. unset($form['fields'][$field_name]);
  492. }
  493. }
  494. }
  495. /**
  496. * Implements hook_form_FORM_ID_alter().
  497. *
  498. * The field_ui_field_overview_form is used for ordering and configuring the
  499. * fields attached to an entity.
  500. *
  501. * This function removes the property adder field as that is really not meant
  502. * for users to show or manage.
  503. */
  504. function tripal_chado_form_field_ui_field_overview_form_alter(&$form, &$form_state, $form_id) {
  505. // Remove the kvproperty_addr field as it isn't ever displayed. It's just used
  506. // on the add/edit form of an entity for adding new property fields.
  507. $fields_names = element_children($form['fields']);
  508. foreach ($fields_names as $field_name) {
  509. $field_info = field_info_field($field_name);
  510. if ($field_info['type'] == 'kvproperty_adder') {
  511. unset($form['fields'][$field_name]);
  512. }
  513. if ($field_info['type'] == 'cvterm_class_adder') {
  514. unset($form['fields'][$field_name]);
  515. }
  516. }
  517. }
  518. /**
  519. * Implements hook_field_is_empty().
  520. */
  521. function tripal_chado_field_is_empty($item, $field) {
  522. // If there is no value field then the field is empty.
  523. if (!array_key_exists('value', $item)) {
  524. return TRUE;
  525. }
  526. // Iterate through all of the fields and if at least one has a value
  527. // the field is not empty.
  528. foreach ($item as $form_field_name => $value) {
  529. if (isset($value) and $value != NULL and $value != '') {
  530. return FALSE;
  531. }
  532. }
  533. // Otherwise, the field is empty.
  534. return TRUE;
  535. }
  536. /**
  537. * Implements hook_update_bundle_fields().
  538. *
  539. */
  540. function tripal_chado_update_bundle_fields($entity_type, $bundle, $term) {
  541. // Get the list of fields that should be attached to this bundle and
  542. // add them.
  543. $bundle_name = $bundle->name;
  544. $fields = tripal_chado_get_bundle_fields($entity_type, $bundle, $term);
  545. foreach ($fields as $field_name => $field_info) {
  546. tripal_update_bundle_field($field_name, $field_info, $entity_type, $bundle_name);
  547. }
  548. }
  549. /**
  550. * Implements hook_add_bundle_fields().
  551. */
  552. function tripal_chado_add_bundle_fields($entity_type, $bundle, $term) {
  553. // Get the list of fields that should be attached to this bundle and
  554. // add them.
  555. $bundle_name = $bundle->name;
  556. $fields = tripal_chado_get_bundle_fields($entity_type, $bundle, $term);
  557. foreach ($fields as $field_name => $field_info) {
  558. tripal_add_bundle_field($field_name, $field_info, $entity_type, $bundle_name);
  559. }
  560. }
  561. /**
  562. * Retreives a list of the fields that should be attached to the bundle.
  563. *
  564. * @return
  565. * An associative array of fields to attach to the bundle. The keys are the
  566. * field names and the values is an info array that can be passed to the
  567. * tripal_add_bundle_field() function.
  568. */
  569. function tripal_chado_get_bundle_fields($entity_type, $bundle, $term) {
  570. $fields = array();
  571. $bundle_name = $bundle->name;
  572. // This array will hold details that map the bundle to tables in Chado.
  573. $bundle_data = array();
  574. // Get the cvterm that corresponds to this TripalTerm object.
  575. $vocab = entity_load('TripalVocab', array($term->vocab_id));
  576. $vocab = reset($vocab);
  577. $match = array(
  578. 'dbxref_id' => array(
  579. 'db_id' => array(
  580. 'name' => $vocab->namespace,
  581. ),
  582. 'accession' => $term->accession
  583. ),
  584. );
  585. $cvterm = chado_generate_var('cvterm', $match);
  586. // The organism table does not have a type_id so we won't ever find
  587. // a record for it in the tripal_cv_defaults table.
  588. if ($cvterm->name == 'organism') {
  589. $bundle_data = array(
  590. 'cv_id' => $cvterm->cv_id->cv_id,
  591. 'cvterm_id' => $cvterm->cvterm_id,
  592. 'data_table' => 'organism',
  593. 'type_table' => 'organism',
  594. 'field' => '',
  595. );
  596. }
  597. // The analysis table does not have a type_id so we won't ever find
  598. // a record for it in the tripalcv_defaults table.
  599. else if ($cvterm->name == 'analysis') {
  600. $bundle_data = array(
  601. 'cv_id' => $cvterm->cv_id->cv_id,
  602. 'cvterm_id' => $cvterm->cvterm_id,
  603. 'data_table' => 'analysis',
  604. 'type_table' => 'analysis',
  605. 'field' => '',
  606. );
  607. }
  608. else if ($cvterm->name == 'project') {
  609. $bundle_data = array(
  610. 'cv_id' => $cvterm->cv_id->cv_id,
  611. 'cvterm_id' => $cvterm->cvterm_id,
  612. 'data_table' => 'project',
  613. 'type_table' => 'project',
  614. 'field' => '',
  615. );
  616. }
  617. else {
  618. // TODO: WHAT TO DO IF A VOCABULARY IS USED AS A DEFAULT FOR MULTIPLE
  619. // TABLES.
  620. // Look to see if this vocabulary is used as a default for any table.
  621. $default = db_select('tripal_cv_defaults', 't')
  622. ->fields('t')
  623. ->condition('cv_id', $cvterm->cv_id->cv_id)
  624. ->execute()
  625. ->fetchObject();
  626. if ($default) {
  627. $bundle_data = array(
  628. 'cv_id' => $cvterm->cv_id->cv_id,
  629. 'cvterm_id' => $cvterm->cvterm_id,
  630. 'data_table' => $default->table_name,
  631. 'type_table' => $default->table_name,
  632. 'field' => $default->field_name,
  633. );
  634. }
  635. }
  636. // Save the mapping information so that we can reuse it when we need to
  637. // look things up for later for an entity
  638. tripal_set_bundle_variable('chado_cvterm_id', $bundle->id, $bundle_data['cvterm_id']);
  639. tripal_set_bundle_variable('chado_table', $bundle->id, $bundle_data['data_table']);
  640. tripal_set_bundle_variable('chado_column', $bundle->id, $bundle_data['field']);
  641. // Find all of the files in the tripal_chado/includes/fields directory.
  642. $fields_path = drupal_get_path('module', 'tripal_chado') . '/includes/fields';
  643. $field_files = file_scan_directory($fields_path, '/^chado_.*\.inc$/');
  644. // Add fields from the base table.
  645. tripal_chado_get_bundle_fields_base__fields($fields, $entity_type, $bundle_name, $bundle_data);
  646. // Iterate through the fields, include the file and run the info function.
  647. foreach ($field_files as $file) {
  648. $field_type = $file->name;
  649. module_load_include('inc', 'tripal_chado', 'includes/fields/' . $field_type);
  650. if (preg_match('/^chado/', $field_type) and class_exists($field_type)) {
  651. $field_obj = new $field_type();
  652. $field_info = $field_obj->attach_info($entity_type, $bundle, $bundle_data);
  653. }
  654. $function = $field_type . '_attach_info';
  655. if (function_exists($function)) {
  656. $field_info = $function($entity_type, $bundle, $bundle_data);
  657. }
  658. if (!is_array($field_info) or count(array_keys($field_info)) == 0) {
  659. continue;
  660. }
  661. $field_name = $field_info['field_name'];
  662. $fields[$field_name] = $field_info;
  663. }
  664. return $fields;
  665. }
  666. /**
  667. * Adds the fields for the base table to the entity.
  668. */
  669. function tripal_chado_get_bundle_fields_base__fields(&$fields, $entity_type_name, $bundle_name, $bundle_data) {
  670. $table_name = $bundle_data['data_table'];
  671. $type_table = $bundle_data['type_table'];
  672. $type_field = $bundle_data['field'];
  673. // Iterate through the columns of the table and see if fields have been
  674. // created for each one. If not, then create them.
  675. $schema = chado_get_schema($table_name);
  676. $columns = $schema['fields'];
  677. foreach ($columns as $column_name => $details) {
  678. $field_name = $table_name . '__' . $column_name;
  679. // Skip the primary key field.
  680. if ($column_name == $schema['primary key'][0]) {
  681. continue;
  682. }
  683. // Skip the type field.
  684. if ($table_name == $type_table and $column_name == $type_field) {
  685. continue;
  686. }
  687. // Get the field defaults for this column.
  688. $field_info = tripal_chado_get_bundle_fields_base__fields_defaults($table_name, $schema, $column_name);
  689. // TODO: add in a call to drupal_alter to allow other modules to change
  690. // the field settings.
  691. // Determine if the field is required.
  692. if (array_key_exists('not null', $details) and $details['not null'] === TRUE) {
  693. $field_info['is_required'] = array_key_exists('default', $details) ? 0 : 1;
  694. }
  695. // If we don't have a field type then we don't need to create a field.
  696. if (!$field_info['field_type']) {
  697. // If we don't have a field type but it is required and doesn't have
  698. // a default value then we are in trouble.
  699. if ($field_info['is_required'] and !array_key_exists('default', $details)) {
  700. throw new Exception(t('The %table.%field type, %type, is not yet supported for Entity fields, but it is required,',
  701. array('%table' => $table_name, '%field' => $column_name, '%type' => $details['type'])));
  702. }
  703. continue;
  704. }
  705. // If this field is a foreign key field then we will have a custom field.
  706. $is_fk = FALSE;
  707. if (array_key_exists('foreign keys', $schema)) {
  708. foreach ($schema['foreign keys'] as $remote_table => $fk_details) {
  709. if (array_key_exists($column_name, $fk_details['columns'])) {
  710. $is_fk = TRUE;
  711. }
  712. }
  713. }
  714. // Add the field to the bundle.
  715. $fields[$field_name] = $field_info;
  716. }
  717. }