remote__data.inc 15 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381
  1. <?php
  2. /**
  3. * @class
  4. * Purpose:
  5. *
  6. * Data:
  7. * Assumptions:
  8. */
  9. class remote__data extends WebServicesField {
  10. // --------------------------------------------------------------------------
  11. // EDITABLE STATIC CONSTANTS
  12. //
  13. // The following constants SHOULD be set for each descendant class. They are
  14. // used by the static functions to provide information to Drupal about
  15. // the field and it's default widget and formatter.
  16. // --------------------------------------------------------------------------
  17. // The default label for this field.
  18. public static $default_label = 'Remote Tripal Site';
  19. // The default description for this field.
  20. public static $default_description = 'Allows for inclusion of remote data from another Tripal site.';
  21. // The default widget for this field.
  22. public static $default_widget = 'remote__data_widget';
  23. // The default formatter for this field.
  24. public static $default_formatter = 'remote__data_formatter';
  25. // The module that manages this field.
  26. public static $module = 'tripal_ws';
  27. // A list of global settings. These can be accessed within the
  28. // globalSettingsForm. When the globalSettingsForm is submitted then
  29. // Drupal will automatically change these settings for all fields.
  30. // Once instances exist for a field type then these settings cannot be
  31. // changed.
  32. public static $default_settings = array(
  33. 'storage' => 'field_tripal_ws_storage',
  34. // It is expected that all fields set a 'value' in the load() function.
  35. // In many cases, the value may be an associative array of key/value pairs.
  36. // In order for Tripal to provide context for all data, the keys should
  37. // be a controlled vocabulary term (e.g. rdfs:type). Keys in the load()
  38. // function that are supported by the query() function should be
  39. // listed here.
  40. 'searchable_keys' => array(),
  41. );
  42. // Provide a list of instance specific settings. These can be access within
  43. // the instanceSettingsForm. When the instanceSettingsForm is submitted
  44. // then Drupal with automatically change these settings for the instance.
  45. // It is recommended to put settings at the instance level whenever possible.
  46. // If you override this variable in a child class be sure to replicate the
  47. // term_name, term_vocab, term_accession and term_fixed keys as these are
  48. // required for all TripalFields.
  49. public static $default_instance_settings = array(
  50. // The short name for the vocabulary (e.g. schema, SO, GO, PATO, etc.).
  51. 'term_vocabulary' => 'schema',
  52. // The name of the term.
  53. 'term_name' => 'Thing',
  54. // The unique ID (i.e. accession) of the term.
  55. 'term_accession' => 'property',
  56. // Set to TRUE if the site admin is not allowed to change the term
  57. // type, otherwise the admin can change the term mapped to a field.
  58. 'term_fixed' => FALSE,
  59. // Indicates if this field should be automatically attached to display
  60. // or web services or if this field should be loaded separately. This
  61. // is convenient for speed. Fields that are slow should for loading
  62. // should have auto_attach set to FALSE so tha their values can be
  63. // attached asynchronously.
  64. 'auto_attach' => FALSE,
  65. // Settings to allow the site admin to set the remote data source info.
  66. 'data_info' => array(
  67. 'query' => '',
  68. 'remote_site' => '',
  69. 'description' => '',
  70. 'rd_field_name' => '',
  71. 'site_logo' => '',
  72. ),
  73. );
  74. // A boolean specifying that users should not be allowed to create
  75. // fields and instances of this field type through the UI. Such
  76. // fields can only be created programmatically with field_create_field()
  77. // and field_create_instance().
  78. public static $no_ui = FALSE;
  79. // A boolean specifying that the field will not contain any data. This
  80. // should exclude the field from web services or downloads. An example
  81. // could be a quick search field that appears on the page that redirects
  82. // the user but otherwise provides no data.
  83. public static $no_data = FALSE;
  84. // Holds an object describing the remote site that tihs field connects to.
  85. private $remote_site = NULL;
  86. // Set to TRUE if this field is being loaded via web services. WE don't
  87. // want remote fields loaded when a web-service call is made.
  88. private $loaded_via_ws = FALSE;
  89. public function __construct($field, $instance) {
  90. parent::__construct($field, $instance);
  91. // This field should not do anything if it is loaded via web-services.
  92. // We don't want remote content to be available in web services. There
  93. // is an if statement to not show this field in the web services but the
  94. // entity_load function doesn't know this field shouldn't be loaded so
  95. // we need to short-circuit that.
  96. $_SERVER['REQUEST_URI'];
  97. if (preg_match('/^web-services/', $_SERVER['REQUEST_URI'])) {
  98. $this->loaded_via_ws = TRUE;
  99. return;
  100. }
  101. // Get the site url from the tripal_sites table.
  102. if (array_key_exists('data_info', $instance['settings'])) {
  103. $site_id_ws = $instance['settings']['data_info']['remote_site'];
  104. if ($site_id_ws) {
  105. $this->remote_site = db_select('tripal_sites', 'ts')
  106. ->fields('ts')
  107. ->condition('ts.id', $site_id_ws)
  108. ->execute()
  109. ->fetchObject();
  110. }
  111. }
  112. }
  113. /**
  114. * @see WebServicesField::load()
  115. */
  116. public function load($entity) {
  117. $field_name = $this->field['field_name'];
  118. $field_type = $this->field['type'];
  119. // Set some defaults for the empty record.
  120. $entity->{$field_name}['und'][0] = array(
  121. 'value' => array(),
  122. 'remote_entity' => array(),
  123. 'error' => FALSE,
  124. 'warning' => FALSE,
  125. );
  126. // If this field is being loaded via web services then just return.
  127. if ($this->loaded_via_ws == TRUE) {
  128. return;
  129. }
  130. // Get the query set by the admin for this field and replace any tokens
  131. $query_str = $this->instance['settings']['data_info']['query'];
  132. $bundle = tripal_load_bundle_entity(array('name' => $entity->bundle));
  133. $query_str = tripal_replace_entity_tokens($query_str, $entity, $bundle);
  134. // Make the request.
  135. $data = $this->makeRemoteRequest($query_str);
  136. dpm($data);
  137. if(!$data){
  138. return;
  139. }
  140. $total_items = $data['totalItems'];
  141. if ($total_items == 0) {
  142. $entity->{$field_name}['und'][0]['value'] = 'Content from the remote site is currently not available' .
  143. tripal_set_message("The remote content is currently not available. " .
  144. "It could be that remote services are unavailable or the query " .
  145. "string does not match content appropriate for this content. Please check.",
  146. TRIPAL_WARNING, ['return_html' => TRUE]);
  147. $entity->{$field_name}['und'][0]['warning'] = TRUE;
  148. $entity->{$field_name}['und'][0]['remote_entity'] = NULL;
  149. }
  150. // Iterate through the members returned and save those for the field.
  151. for ($i = 0; $i < $total_items; $i++) {
  152. $member = $data['member'][$i];
  153. // Get the cotent type and remote entity id
  154. $content_type = $member['@type'];
  155. $remote_entity_id = $member['@id'];
  156. $remote_entity_id = preg_replace('/^.*\/(\d+)/', '$1', $remote_entity_id);
  157. // Save the member information for use later.
  158. $entity->{$field_name}['und'][$i]['remote_entity'] = $member;
  159. $entity->{$field_name}['und'][$i]['error'] = FALSE;
  160. $entity->{$field_name}['und'][$i]['warning'] = FALSE;
  161. // Separate the query_field if it has subfields.
  162. $rd_field_name = $this->instance['settings']['data_info']['rd_field_name'];
  163. $subfields = explode(',', $rd_field_name);
  164. $query_field = $subfields[0];
  165. // Next get the the details about this member.
  166. $query_field_url = $content_type . '/' . $remote_entity_id . '/' . $query_field;
  167. $field_data = $this->makeRemoteRequest($query_field_url);
  168. if(!$field_data){
  169. // If we encounter any type of error, we'll reset the field and return.
  170. $entity->{$field_name}['und'][$i]['value'] = 'Unable to retrieve remote content' .
  171. tripal_set_message("Something is wrong with the remote site. It returned " .
  172. "a list of matches for the query but did not return details about each match.",
  173. TRIPAL_ERROR, ['return_html' => TRUE]);
  174. $entity->{$field_name}['und'][$i]['error'] = TRUE;
  175. return;
  176. }
  177. // Set the field data as the value.
  178. $field_data_type = $field_data['@type'];
  179. $entity->{$field_name}['und'][$i]['value'] = $field_data;
  180. }
  181. }
  182. /**
  183. * Makes a request to a remote Tripal web services site.
  184. *
  185. * @param $query
  186. * The query string. This string is added to the URL for the remote
  187. * website.
  188. */
  189. private function makeRemoteRequest($query) {
  190. $path = $query;
  191. $q = '';
  192. if (preg_match('/\?/', $query)) {
  193. list($path, $q) = explode('?', $query);
  194. }
  195. dpm($path);
  196. dpm($q);
  197. $data = tripal_get_remote_content($this->remote_site->id, $path, $q);
  198. return $data;
  199. }
  200. /**
  201. *
  202. * @see TripalField::settingsForm()
  203. */
  204. public function instanceSettingsForm() {
  205. $element = parent::instanceSettingsForm();
  206. // Get the setting for the option for how this widget.
  207. $instance = $this->instance;
  208. $settings = '';
  209. $site_list = '';
  210. $tokens = array();
  211. // Get the form info from the bundle about to be saved.
  212. $bundle = tripal_load_bundle_entity(array('name' => $instance['bundle']));
  213. // Retrieve all available tokens.
  214. $tokens = tripal_get_entity_tokens($bundle);
  215. $element['data_info'] = array(
  216. '#type' => 'fieldset',
  217. '#title' => 'Remote Data Settings',
  218. '#description' => 'These settings allow you to provide a Tripal web
  219. services query to identify content on another Tripal site and display
  220. that here within this field. You must specify the query to execute and
  221. the field to display.',
  222. '#collapsible' => TRUE,
  223. '#collapsed' => FALSE,
  224. '#prefix' => "<div id='set_titles-fieldset'>",
  225. '#suffix' => '</div>',
  226. );
  227. // Get the site info from the tripal_sites table.
  228. $sites = db_select('tripal_sites', 's')
  229. ->fields('s')
  230. ->execute()->fetchAll();
  231. foreach ($sites as $site) {
  232. $rows[$site->id] =$site->name;
  233. }
  234. $element['data_info']['remote_site'] = array(
  235. '#type' => 'select',
  236. '#title' => t('Remote Tripal Site'),
  237. '#options' => $rows,
  238. '#default_value' => $this->instance['settings']['data_info']['remote_site'],
  239. );
  240. $element['data_info']['query'] = array(
  241. '#type' => 'textarea',
  242. '#title' => 'Query to Execute',
  243. '#description' => 'Enter the query that will retreive the remote records. ' .
  244. 'If the full URL to the content web service is ' .
  245. 'https://[tripal_site]/web-services/content/v0.1/. Then this field should ' .
  246. 'contain the text immediately after the content/v0.1 portion of the URL. ' .
  247. 'For information about building web services queries see the ' .
  248. 'online documentation at ' . l('The Tripal v3 User\'s Guide', 'http://tripal.info/tutorials/v3.x/web-services') . '. ' .
  249. 'For example, suppose this field is attached to an ' .
  250. 'Organism content type on the local site, and you want to retrieve a ' .
  251. 'field for the same organism on a remote Tripal site then you will ' .
  252. 'want to query on the genus and species. Also, you want the genus and ' .
  253. 'species to match the organism that this field is attached to. You can ' .
  254. 'use tokens to do this (see the "Available Tokesn" fieldset below). ' .
  255. 'For this example, the query text should be ' .
  256. 'Organism?genus=[taxrank__genus]&species=[taxrank__species].',
  257. '#default_value' => $this->instance['settings']['data_info']['query'],
  258. '#rows' => 5,
  259. '#required' => TRUE
  260. );
  261. $element['data_info']['rd_field_name'] = array(
  262. '#type' => 'textfield',
  263. '#title' => 'Field to Display',
  264. '#description' => 'The results returned by the query should match
  265. entities (or records) from the selected remote site. That entity
  266. will have multiple fields. Only one remote field can be shown by
  267. this field. Please enter the name of the field you would like
  268. to display. Some fields have "subfields". You can display a subfield
  269. rather than the entire field by entering a comma-separated sequence
  270. of subfields. For example, for relationships, you may only want to
  271. show the "clause", therefore, the entry here would be: realtionship,clause.',
  272. '#default_value' => $this->instance['settings']['data_info']['rd_field_name'],
  273. '#required' => TRUE
  274. );
  275. $element['data_info']['token_display']['tokens'] = array(
  276. '#type' => 'hidden',
  277. '#value' => serialize($tokens)
  278. );
  279. $element['data_info']['token_display'] = array(
  280. '#type' => 'fieldset',
  281. '#title' => 'Available Tokens',
  282. '#description' => 'Copy the token and paste it into the "Query" text field above.',
  283. '#collapsible' => TRUE,
  284. '#collapsed' => TRUE
  285. );
  286. $element['data_info']['token_display']['content'] = array(
  287. '#type' => 'item',
  288. '#markup' => theme_token_list($tokens),
  289. );
  290. $element['data_info']['description'] = array(
  291. '#type' => 'textarea',
  292. '#title' => 'Description',
  293. '#description' => 'Describe the data being pulled in.',
  294. '#default_value' => $this->instance['settings']['data_info']['description'],
  295. '#rows' => 1
  296. );
  297. $fid = $this->instance['settings']['data_info']['site_logo'] ? $this->instance['settings']['data_info']['site_logo'] : NULL;
  298. $file = NULL;
  299. if ($fid) {
  300. $file = file_load($fid);
  301. }
  302. $element['data_info']['site_logo'] = array(
  303. '#title' => 'Remote Site Logo',
  304. '#description' => t('When data is taken from a remote site and shown to the user,
  305. the site from which the data was retrieved is indicated. If you would like to
  306. include the logo for the remote site, please upload an image here.'),
  307. '#type' => 'managed_file',
  308. '#default_value' => $file ? $file->fid : NULL,
  309. '#theme' => 'image_widget',
  310. '#attached' => array(
  311. 'css' => array(
  312. 'image-preview' => drupal_get_path('module', 'image') . '/image.css',
  313. ),
  314. ),
  315. 'preview' => array(
  316. '#markup' => theme('image_style', array('style_name' => 'thumbnail', 'path' => $file ? $file->uri : '')),
  317. ),
  318. );
  319. return $element;
  320. }
  321. /**
  322. *
  323. * @param unknown $form
  324. * @param unknown $form_state
  325. */
  326. public function instanceSettingsFormValidate($form, &$form_state) {
  327. $site_logo = $form_state['values']['instance']['settings']['data_info']['site_logo'];
  328. // If we have a site logo then add usage information.
  329. if ($site_logo) {
  330. $file = file_load($site_logo);
  331. $file_usage = file_usage_list($file);
  332. if (!array_key_exists('tripal_ws', $file_usage)) {
  333. file_usage_add($file, 'tripal_ws', 'site-logo', 1);
  334. }
  335. }
  336. }
  337. }