tripal_feature.chado_node.inc 30 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859860861862863864865866867868869
  1. <?php
  2. /**
  3. * Provide information to drupal about the node types that we're creating
  4. * in this module
  5. *
  6. * @ingroup tripal_feature
  7. */
  8. function tripal_feature_node_info() {
  9. $nodes = array();
  10. $nodes['chado_feature'] = array(
  11. 'name' => t('Feature'),
  12. 'base' => 'chado_feature',
  13. 'description' => t('A feature from the chado database'),
  14. 'has_title' => FALSE,
  15. 'title_label' => t('Feature'),
  16. 'has_body' => FALSE,
  17. 'body_label' => t('Feature Description'),
  18. 'locked' => TRUE,
  19. 'chado_node_api' => array(
  20. 'base_table' => 'feature',
  21. 'hook_prefix' => 'chado_feature',
  22. 'record_type_title' => array(
  23. 'singular' => t('Feature'),
  24. 'plural' => t('Features')
  25. ),
  26. 'sync_filters' => array(
  27. 'type_id' => TRUE,
  28. 'organism_id' => TRUE
  29. ),
  30. )
  31. );
  32. return $nodes;
  33. }
  34. /**
  35. * Implementation of hook_form
  36. *
  37. * @param $node
  38. * @param $param
  39. *
  40. * @return
  41. * Drupal form array
  42. *
  43. * @ingroup tripal_feature
  44. */
  45. function chado_feature_form($node, &$form_state) {
  46. $form = array();
  47. // Default values can come in the following ways:
  48. //
  49. // 1) as elements of the $node object. This occurs when editing an existing feature
  50. // 2) in the $form_state['values'] array which occurs on a failed validation or
  51. // ajax callbacks from non submit form elements
  52. // 3) in the $form_state['input'[ array which occurs on ajax callbacks from submit
  53. // form elements and the form is being rebuilt
  54. //
  55. // set form field defaults
  56. $feature = null;
  57. $feature_id = null;
  58. $uniquename = '';
  59. $fname = '';
  60. $feature_type = '';
  61. $organism_id = '';
  62. $residues = '';
  63. $is_obsolete = '';
  64. $analyses = '';
  65. $references = '';
  66. $synonyms = '';
  67. // if we are editing an existing node then the feature is already part of the node
  68. if (property_exists($node, 'feature')) {
  69. $feature = $node->feature;
  70. $feature = tripal_core_expand_chado_vars($feature, 'field', 'feature.residues');
  71. $feature_id = $feature->feature_id;
  72. $uniquename = $feature->uniquename;
  73. $fname = $feature->name;
  74. $feature_type = $feature->type_id->name;
  75. $organism_id = $feature->organism_id->organism_id;
  76. $residues = $feature->residues;
  77. $is_obsolete = $feature->is_obsolete;
  78. // get the synonyms from a previous post
  79. $synonyms = '';
  80. if(property_exists($node, 'synonyms')) {
  81. $synonyms = $node->synonyms;
  82. }
  83. // get synonyms from the database if we don't already have them
  84. if (!$synonyms) {
  85. $options = array('return_array' => 1);
  86. $feature = tripal_core_expand_chado_vars($feature, 'table', 'feature_synonym', $options);
  87. $feature_synonyms = $feature->feature_synonym;
  88. foreach ($feature_synonyms as $index => $synonym) {
  89. $synonyms .= $synonym->synonym_id->name . "\n";
  90. }
  91. }
  92. // keep track of the feature id
  93. $form['feature_id'] = array(
  94. '#type' => 'value',
  95. '#value' => $feature_id,
  96. );
  97. }
  98. // if we are re constructing the form from a failed validation or ajax callback
  99. // then use the $form_state['values'] values
  100. if (array_key_exists('values', $form_state)) {
  101. $uniquename = $form_state['values']['uniquename'];
  102. $fname = $form_state['values']['fname'];
  103. $feature_type = $form_state['values']['feature_type'];
  104. $organism_id = $form_state['values']['organism_id'];
  105. $residues = $form_state['values']['residues'];
  106. $is_obsolete = $form_state['values']['is_obsolete'];
  107. $synonyms = $form_state['values']['synonyms'];
  108. }
  109. // if we are re building the form from after submission (from ajax call) then
  110. // the values are in the $form_state['input'] array
  111. if (array_key_exists('input', $form_state) and !empty($form_state['input'])) {
  112. $uniquename = $form_state['input']['uniquename'];
  113. $fname = $form_state['input']['fname'];
  114. $feature_type = $form_state['input']['feature_type'];
  115. $organism_id = $form_state['input']['organism_id'];
  116. $residues = $form_state['input']['residues'];
  117. $is_obsolete = array_key_exists('is_obsolete', $form_state['input']) ? $form_state['input']['is_obsolete'] : FALSE;
  118. $synonyms = $form_state['input']['synonyms'];
  119. }
  120. $form['fname']= array(
  121. '#type' => 'textfield',
  122. '#title' => t('Feature Name'),
  123. '#required' => TRUE,
  124. '#default_value' => $fname,
  125. '#description' => t('Enter the name used by humans to refer to this feature.'),
  126. '#maxlength' => 255
  127. );
  128. $form['uniquename']= array(
  129. '#type' => 'textfield',
  130. '#title' => t('Unique Feature Name'),
  131. '#required' => TRUE,
  132. '#default_value' => $uniquename,
  133. '#description' => t('Enter a unique name for this feature. This name must be unique for the organism and feature type.'),
  134. '#maxlength' => 255
  135. );
  136. // get the sequence ontology CV ID
  137. $values = array('name' => 'sequence');
  138. $cv = tripal_core_chado_select('cv', array('cv_id'), $values);
  139. $cv_id = $cv[0]->cv_id;
  140. $form['feature_type'] = array(
  141. '#title' => t('Feature Type'),
  142. '#type' => 'textfield',
  143. '#description' => t("Choose the feature type."),
  144. '#required' => TRUE,
  145. '#default_value' => $feature_type,
  146. '#autocomplete_path' => "admin/tripal/chado/tripal_cv/cvterm/auto_name/$cv_id",
  147. );
  148. // get the list of organisms
  149. $sql = "SELECT * FROM {Organism} ORDER BY genus, species";
  150. $org_rset = chado_query($sql);
  151. $organisms = array();
  152. $organisms[''] = '';
  153. while ($organism = $org_rset->fetchObject()) {
  154. $organisms[$organism->organism_id] = "$organism->genus $organism->species ($organism->common_name)";
  155. }
  156. $form['organism_id'] = array(
  157. '#title' => t('Organism'),
  158. '#type' => t('select'),
  159. '#description' => t("Choose the organism with which this feature is associated"),
  160. '#required' => TRUE,
  161. '#default_value' => $organism_id,
  162. '#options' => $organisms,
  163. );
  164. // Get synonyms
  165. $syn_text = '';
  166. if ($synonyms) {
  167. if (is_array($synonyms)) {
  168. foreach ($synonyms as $synonym) {
  169. $syn_text .= "$synonym->name\n";
  170. }
  171. }
  172. else {
  173. $syn_text = $synonyms;
  174. }
  175. }
  176. $form['synonyms']= array(
  177. '#type' => 'textarea',
  178. '#title' => t('Synonyms'),
  179. '#required' => FALSE,
  180. '#default_value' => $syn_text,
  181. '#description' => t('Enter alternate names (synonmys) for this feature to help in searching and identification. You may enter as many alternate names as needed each on different lines.'),
  182. );
  183. $form['residues']= array(
  184. '#type' => 'textarea',
  185. '#title' => t('Residues'),
  186. '#required' => FALSE,
  187. '#default_value' => $residues,
  188. '#description' => t('Enter the nucelotide sequences for this feature'),
  189. );
  190. $checked = '';
  191. if ($is_obsolete == 't') {
  192. $checked = '1';
  193. }
  194. $form['is_obsolete']= array(
  195. '#type' => 'checkbox',
  196. '#title' => t('Is Obsolete'),
  197. '#required' => FALSE,
  198. '#default_value' => $checked,
  199. '#description' => t('Check this box if this sequence should be retired'),
  200. );
  201. return $form;
  202. }
  203. /**
  204. * Implementation of hook_validate
  205. *
  206. * This validation is being used for three activities:
  207. * CASE A: Update a node that exists in both drupal and chado
  208. * CASE B: Synchronizing a node from chado to drupal
  209. * CASE C: Inserting a new node that exists in niether drupal nor chado
  210. *
  211. * @param $node
  212. *
  213. *
  214. * @ingroup tripal_feature
  215. */
  216. function chado_feature_validate($node, $form, &$form_state) {
  217. // remove surrounding white-space on submitted values
  218. $node->uniquename = trim($node->uniquename);
  219. $node->fname = trim($node->fname);
  220. $node->feature_type = trim($node->feature_type);
  221. $node->residues = trim($node->residues);
  222. // if this is a delete then don't validate
  223. if($node->op == 'Delete') {
  224. return;
  225. }
  226. // we are syncing if we do not have a node ID but we do have a feature_id. We don't
  227. // need to validate during syncing so just skip it.
  228. if (is_null($node->nid) and property_exists($node, 'feature_id') and $node->feature_id != 0) {
  229. return;
  230. }
  231. // Validating for an update
  232. if (property_exists($node, 'nid')) {
  233. // make sure the feature type is a real sequence ontology term
  234. $type = tripal_cv_get_cvterm_by_name($node->feature_type, NULL, 'sequence');
  235. if (!$type) {
  236. form_set_error('feature_type', t("The feature type is not a valid name from the Sequence Ontology."));
  237. }
  238. // if this is an update, we want to make sure that a different feature for
  239. // the organism doesn't already have this uniquename. We don't want to give
  240. // two sequences the same uniquename
  241. if (property_exists($node, 'feature_id') and $node->feature_id != 0) {
  242. $sql = "
  243. SELECT *
  244. FROM {feature} F
  245. INNER JOIN {cvterm} CVT ON F.type_id = CVT.cvterm_id
  246. WHERE
  247. F.uniquename = :uname AND
  248. F.organism_id = :organism_id AND
  249. CVT.name = :cvtname AND
  250. NOT f.feature_id = :feature_id
  251. ";
  252. $args = array(':uname' => $node->uniquename, ':organism_id' => $node->organism_id,
  253. ':cvtname' => $node->feature_type, ':feature_id' => $node->feature_id);
  254. $result = chado_query($sql, $args)->fetchObject();
  255. if ($result) {
  256. form_set_error('uniquename', t("Feature update cannot proceed. The feature name '$node->uniquename' is not unique for this organism. Please provide a unique name for this feature."));
  257. }
  258. }
  259. }
  260. // Validating for an insert
  261. else {
  262. // make sure the feature type is a real sequence ontology term
  263. $type = tripal_cv_get_cvterm_by_name($node->feature_type, NULL, 'sequence');
  264. if (!$type) {
  265. form_set_error('feature_type', t("The feature type is not a valid name from the Sequence Ontology."));
  266. }
  267. // if this is an insert then we just need to make sure this name doesn't
  268. // already exist for this organism if it does then we need to throw an error
  269. $sql = "
  270. SELECT *
  271. FROM {feature} F
  272. INNER JOIN {cvterm} CVT ON F.type_id = CVT.cvterm_id
  273. WHERE
  274. F.uniquename = :name AND
  275. F.organism_id = :organism_id AND
  276. CVT.name = :cvtname
  277. ";
  278. $args = array(':name' => $node->uniquename, ':organism_id' => $node->organism_id, ':cvtname' => $node->feature_type);
  279. $result = chado_query($sql, $args)->fetchObject();
  280. if ($result) {
  281. form_set_error('uniquename', t("Feature insert cannot proceed. The feature name '$node->uniquename' already exists for this organism. Please provide a unique name for this feature."));
  282. }
  283. }
  284. }
  285. /**
  286. * Implement hook_access().
  287. *
  288. * This hook allows node modules to limit access to the node types they define.
  289. *
  290. * @param $node
  291. * The node on which the operation is to be performed, or, if it does not yet exist, the
  292. * type of node to be created
  293. *
  294. * @param $op
  295. * The operation to be performed
  296. *
  297. * @param $account
  298. * A user object representing the user for whom the operation is to be performed
  299. *
  300. * @return
  301. * If the permission for the specified operation is not set then return FALSE. If the
  302. * permission is set then return NULL as this allows other modules to disable
  303. * access. The only exception is when the $op == 'create'. We will always
  304. * return TRUE if the permission is set.
  305. *
  306. * @ingroup tripal_feature
  307. */
  308. function chado_feature_node_access($node, $op, $account) {
  309. if ($op == 'create') {
  310. if (!user_access('create chado_feature content', $account)) {
  311. return FALSE;
  312. }
  313. return TRUE;
  314. }
  315. if ($op == 'update') {
  316. if (!user_access('edit chado_feature content', $account)) {
  317. return FALSE;
  318. }
  319. }
  320. if ($op == 'delete') {
  321. if (!user_access('delete chado_feature content', $account)) {
  322. return FALSE;
  323. }
  324. }
  325. if ($op == 'view') {
  326. if (!user_access('access chado_feature content', $account)) {
  327. return FALSE;
  328. }
  329. }
  330. return NULL;
  331. }
  332. /**
  333. * When a new chado_feature node is created we also need to add information
  334. * to our chado_feature table. This function is called on insert of a new node
  335. * of type 'chado_feature' and inserts the necessary information.
  336. *
  337. * @ingroup tripal_feature
  338. */
  339. function chado_feature_insert($node) {
  340. $node->uniquename = trim($node->uniquename);
  341. $node->fname = trim($node->fname);
  342. $node->feature_type = trim($node->feature_type);
  343. $node->residues = trim($node->residues);
  344. // remove spaces, newlines from residues
  345. $residues = preg_replace("/[\n\r\s]/", "", $node->residues);
  346. $obsolete = 'FALSE';
  347. if ($node->is_obsolete) {
  348. $obsolete = 'TRUE';
  349. }
  350. $feature_id = '';
  351. // if there is an feature_id in the $node object then this must be a sync so
  352. // we can skip adding the feature as it is already there, although
  353. // we do need to proceed with the rest of the insert
  354. if (!property_exists($node, 'feature_id')) {
  355. $values = array(
  356. 'organism_id' => $node->organism_id,
  357. 'name' => $node->fname,
  358. 'uniquename' => $node->uniquename,
  359. 'residues' => $residues,
  360. 'seqlen' => drupal_strlen($residues),
  361. 'is_obsolete' => $obsolete,
  362. 'type_id' => $type[0]->cvterm_id,
  363. 'md5checksum' => md5($residues)
  364. );
  365. $feature = tripal_core_chado_insert('feature', $values);
  366. if (!$feature) {
  367. drupal_set_message(t('Unable to add feature.'), 'warning');
  368. watchdog('tripal_feature', 'Insert feature: Unable to create feature where values: %values',
  369. array('%values' => print_r($values, TRUE)), WATCHDOG_WARNING);
  370. return;
  371. }
  372. $feature_id = $feature->feature_id;
  373. // add the genbank accession and synonyms
  374. chado_feature_add_synonyms($node->synonyms, $node->feature_id);
  375. }
  376. else {
  377. $feature_id = $node->feature_id;
  378. }
  379. // Make sure the entry for this feature doesn't already exist in the
  380. // chado_feature table if it doesn't exist then we want to add it.
  381. $check_org_id = chado_get_id_for_node('feature', $node->nid);
  382. if (!$check_org_id) {
  383. $record = new stdClass();
  384. $record->nid = $node->nid;
  385. $record->vid = $node->vid;
  386. $record->feature_id = $feature_id;
  387. drupal_write_record('chado_feature', $record);
  388. }
  389. }
  390. /**
  391. *
  392. *
  393. * @ingroup tripal_feature
  394. */
  395. function chado_feature_update($node) {
  396. $node->uniquename = trim($node->uniquename);
  397. $node->fname = trim($node->fname);
  398. $node->feature_type = trim($node->feature_type);
  399. $node->residues = trim($node->residues);
  400. $residues = preg_replace("/[\n\r\s]/", "", $node->residues);
  401. $obsolete = 'FALSE';
  402. if ($node->is_obsolete) {
  403. $obsolete = 'TRUE';
  404. }
  405. // get the feature type id
  406. $values = array(
  407. 'cv_id' => array(
  408. 'name' => 'sequence'
  409. ),
  410. 'name' => $node->feature_type
  411. );
  412. $type = tripal_core_chado_select('cvterm', array('cvterm_id'), $values);
  413. $feature_id = chado_get_id_for_node('feature', $node->nid) ;
  414. if (sizeof($type) > 0) {
  415. $match = array(
  416. 'feature_id' => $feature_id,
  417. );
  418. $values = array(
  419. 'organism_id' => $node->organism_id,
  420. 'name' => $node->fname,
  421. 'uniquename' => $node->uniquename,
  422. 'residues' => $residues,
  423. 'seqlen' => drupal_strlen($residues),
  424. 'is_obsolete' => $obsolete,
  425. 'type_id' => $type[0]->cvterm_id,
  426. 'md5checksum' => md5($residues)
  427. );
  428. $options = array('return_record' => TRUE);
  429. $status = tripal_core_chado_update('feature', $match, $values, $options);
  430. // add the genbank synonyms
  431. chado_feature_add_synonyms($node->synonyms, $feature_id);
  432. }
  433. else {
  434. drupal_set_message(t('Unable to update feature.'), 'warning');
  435. watchdog('tripal_feature',
  436. 'Update feature: Unable to update feature where values: %values',
  437. array('%values' => print_r($values, TRUE)),
  438. WATCHDOG_WARNING
  439. );
  440. }
  441. }
  442. /**
  443. *
  444. *
  445. * @ingroup tripal_feature
  446. */
  447. function chado_feature_delete($node) {
  448. $feature_id = chado_get_id_for_node('feature', $node->nid);
  449. // if we don't have a library id for this node then this isn't a node of
  450. // type chado_library or the entry in the chado_library table was lost.
  451. if (!$feature_id) {
  452. return;
  453. }
  454. // remove the drupal content
  455. $sql_del = "DELETE FROM {chado_feature} WHERE nid = :nid AND vid = :vid";
  456. db_query($sql_del, array(':nid' => $node->nid, ':vid' => $node->vid));
  457. $sql_del = "DELETE FROM {node} WHERE nid = :nid AND vid = :vid";
  458. db_query($sql_del, array(':nid' => $node->nid, ':vid' => $node->vid));
  459. $sql_del = "DELETE FROM {node_revision} WHERE nid = :nid AND vid = :vid";
  460. db_query($sql_del, array(':nid' => $node->nid, ':vid' => $node->vid));
  461. // Remove data from feature tables of chado database. This will
  462. // cause a cascade delete and remove all data in referencing tables
  463. // for this feature
  464. chado_query("DELETE FROM {feature} WHERE feature_id = :feature_id", array(':feature_id' => $feature_id));
  465. drupal_set_message(t("The feature and all associated data were removed from") .
  466. "chado");
  467. }
  468. /**
  469. *
  470. *
  471. * @ingroup tripal_feature
  472. */
  473. function chado_feature_add_synonyms($synonyms, $feature_id) {
  474. // separate synomys by carriage returns
  475. $synonyms = preg_replace("/[\n\r]+/", " ", $synonyms);
  476. // split the synonyms into an array based on a space as the delimieter
  477. $syn_array = array();
  478. $syn_array = explode(" ", $synonyms);
  479. // remove any old synonyms
  480. $feature_syn_dsql = "DELETE FROM {feature_synonym} WHERE feature_id = :feature_id";
  481. if (!chado_query($feature_syn_dsql, array(':feature_id' => $feature_id))) {
  482. watchdog('tripal_feature', "Could not remove synonyms from feature. ", array(), WATCHDOG_ERROR);
  483. return;
  484. }
  485. // return if we don't have any synonmys to add
  486. if (!$synonyms) {
  487. return;
  488. }
  489. // iterate through each synonym and add it to the database
  490. foreach ($syn_array as $syn) {
  491. // skip this item if it's empty
  492. if (!$syn) {
  493. break;
  494. }
  495. // check to see if we have this accession number already in the database
  496. // if so then don't add it again. it messes up drupal if the insert fails.
  497. // It is possible for the accession number to be present and not the feature
  498. $synonym_sql = "SELECT synonym_id FROM {synonym} WHERE name = :name";
  499. $synonym = chado_query($synonym_sql, array(':name' => $syn))->fetchObject();
  500. if (!$synonym) {
  501. $synonym_isql = "
  502. INSERT INTO {synonym} (name, synonym_sgml, type_id)
  503. VALUES (:name, :synonym_sgml,
  504. (SELECT cvterm_id
  505. FROM {cvterm} CVT
  506. INNER JOIN {cv} ON CVT.cv_id = CV.cv_id
  507. WHERE CV.name = 'feature_property' and CVT.name = 'synonym')
  508. )
  509. ";
  510. if (!chado_query($synonym_isql, array(':name' => $syn, ':synonym_sgml' => $syn))) {
  511. watchdog('tripal_feature', "Could not add synonym. ", array(), WATCHDOG_WARNING);
  512. return;
  513. }
  514. // now get the synonym we just added
  515. $synonym_sql = "SELECT synonym_id FROM {synonym} WHERE name = :name";
  516. $synonym = chado_query($synonym_sql, array(':name' => $syn))->fetchObject();
  517. }
  518. // now add in our new sysnonym
  519. $feature_syn_isql = "
  520. INSERT INTO {feature_synonym} (synonym_id,feature_id,pub_id)
  521. VALUES (:synonym_id, :feature_id, :pub_id)";
  522. $args = array(':synonym_id' => $synonym->synonym_id, ':feature_id' => $feature_id, ':pub_id'=> 1);
  523. if (!chado_query($feature_syn_isql, $args)) {
  524. watchdog('tripal_feature', "Could not associate synonym with feature. ", array(), WATCHDOG_WARNING);
  525. return;
  526. }
  527. }
  528. }
  529. /**
  530. * When a node is requested by the user this function is called to allow us
  531. * to add auxiliary data to the node object.
  532. *
  533. * @ingroup tripal_feature
  534. */
  535. function chado_feature_load($nodes) {
  536. foreach ($nodes as $nid => $node) {
  537. // find the feature and add in the details
  538. $feature_id = chado_get_id_for_node('feature', $nid);
  539. // build the feature variable
  540. $values = array('feature_id' => $feature_id);
  541. $feature = tripal_core_generate_chado_var('feature', $values);
  542. $nodes[$nid]->feature = $feature;
  543. // by default, the titles are saved using the unique constraint. We will
  544. // keep it the same, but remove the duplicate name if the unique name and name
  545. // are identical. This doesn't change the title saved in the database, just what is shown
  546. // to the user on the page
  547. $title_type = variable_get('chado_feature_title', 'unique_constraint');
  548. if ($title_type == 'unique_constraint') {
  549. if (strcmp($feature->name, $feature->uniquename)==0) {
  550. $node->title = $feature->name . " (" . $feature->type_id->name . ") " . $feature->organism_id->genus . " " . $feature->organism_id->species ;
  551. }
  552. // in previous version of Tripal, the feature title was simply the unique name.
  553. // so, we recreate the title just to be sure all of our feature pages are consistent
  554. else {
  555. $node->title = $feature->name . ", " . $feature->uniquename . " (" . $feature->type_id->name . ") " . $feature->organism_id->genus . " " . $feature->organism_id->species ;
  556. }
  557. }
  558. // set the title to be the feature name or uniquename as configured
  559. if ($title_type == 'feature_name') {
  560. $node->title = $feature->name;
  561. }
  562. if ($title_type == 'feature_unique_name') {
  563. $node->title = $feature->uniquename;
  564. }
  565. }
  566. }
  567. /**
  568. *
  569. * @ingroup tripal_feature
  570. */
  571. function tripal_feature_node_presave($node) {
  572. // set the title to ensure it is always unique
  573. switch ($node->type) {
  574. case 'chado_feature':
  575. // for a form submission the fields part of the node object
  576. // but for a sync the feilds are in an object of the node
  577. $name = '';
  578. $uname = '';
  579. $type = '';
  580. $organism_id = null;
  581. if(property_exists($node, 'feature')) {
  582. $organism_id = $node->feature->organism_id;
  583. $name = $node->feature->name;
  584. $uname = $node->feature->uniquname;
  585. $type_id = $node->feature->type_id;
  586. $values = array('cvterm_id' => $type_id);
  587. $ftype = tripal_core_chado_select('cv', array('name'), $values);
  588. $type = $ftype[0]->name;
  589. }
  590. else {
  591. $organism_id = $node->organism_id;
  592. $name = $node->name;
  593. $uname = $node->uniquname;
  594. $type = $node->feature_type;
  595. }
  596. $values = array('organism_id' => $organism_id);
  597. $organism = tripal_core_chado_select('organism', array('genus', 'species'), $values);
  598. $node->title = $fname . ', ' . $uniquename . ' (' . $type . ') ' . $organism[0]->genus . ' ' . $organism[0]->species;
  599. break;
  600. }
  601. }
  602. /**
  603. *
  604. * @ingroup tripal_feature
  605. */
  606. function tripal_feature_node_insert($node) {
  607. // set the URL path after inserting. We do it here because we do not
  608. // know the feature_id in the presave
  609. switch ($node->type) {
  610. case 'chado_feature':
  611. if (!$node->feature_id) {
  612. $sql = "SELECT * FROM {chado_feature} WHERE nid = :nid";
  613. $chado_feature = db_query($sql, array(':nid' => $node->nid))->fetchObject();
  614. $node->feature_id = $chado_feature->feature_id;
  615. }
  616. // remove any previous alias
  617. db_query("DELETE FROM {url_alias} WHERE source = :source", array(':source' => "node/$node->nid"));
  618. // set the URL for this feature page
  619. $url_alias = tripal_feature_get_feature_url($node);
  620. $path_alias = array("source" => "node/$node->nid", "alias" => $url_alias);
  621. path_save($path_alias);
  622. break;
  623. }
  624. }
  625. /**
  626. *
  627. * @param $node
  628. * A node object containing at least the feature_id and nid
  629. * @param $url_alias
  630. * Optional. This should be the URL alias syntax string that contains
  631. * placeholders such as [id], [genus], [species], [name], [uniquename],
  632. * and [type]. These placeholders will be substituted for actual values.
  633. * If this parameter is not provided then the value of the
  634. * chado_feature_url_string Drupal variable will be used.
  635. */
  636. function tripal_feature_get_feature_url($node, $url_alias = NULL) {
  637. // get the starting URL alias
  638. if(!$url_alias) {
  639. $url_alias = variable_get('chado_feature_url_string', '/feature/[genus]/[species]/[type]/[uniquename]');
  640. if (!$url_alias) {
  641. $url_alias = '/feature/[genus]/[species]/[type]/[uniquename]';
  642. }
  643. $url_alias = preg_replace('/^\//', '', $url_alias); // remove any preceeding forward slash
  644. }
  645. // get the feature
  646. $values = array('feature_id' => $node->feature_id);
  647. $feature = tripal_core_chado_select('feature', array('*'), $values);
  648. if (!$feature) {
  649. watchdog('trp-seturl', "Cannot find feature when setting URL alias for feature: %id", array('%id' => $node->feature_id), WATCHDOG_ERROR);
  650. return FALSE;
  651. }
  652. $feature = (object) $feature[0];
  653. // get the organism
  654. $values = array('organism_id' => $feature->organism_id);
  655. $organism = tripal_core_chado_select('organism', array('*'), $values);
  656. if (!$organism) {
  657. watchdog('trp-seturl', "Cannot find organism when setting URL alias for feature: %id", array('%id' => $node->feature_id), WATCHDOG_ERROR);
  658. return FALSE;
  659. }
  660. $genus = preg_replace('/\s/', '_', strtolower($organism[0]->genus));
  661. $species = preg_replace('/\s/', '_', strtolower($organism[0]->species));
  662. // get the type
  663. $values = array('cvterm_id' => $feature->type_id);
  664. $cvterm = tripal_core_chado_select('cvterm', array('name'), $values);
  665. if (!$cvterm) {
  666. watchdog('trp-seturl', "Cannot find type when setting URL alias for feature: %id", array('%id' => $node->feature_id), WATCHDOG_ERROR);
  667. return FALSE;
  668. }
  669. $type = preg_replace('/\s/', '_', $cvterm[0]->name);
  670. // now substitute in the values
  671. $url_alias = preg_replace('/\[id\]/', $feature->feature_id, $url_alias);
  672. $url_alias = preg_replace('/\[genus\]/', $genus, $url_alias);
  673. $url_alias = preg_replace('/\[species\]/', $species, $url_alias);
  674. $url_alias = preg_replace('/\[type\]/', $type, $url_alias);
  675. $url_alias = preg_replace('/\[name\]/', $feature->name, $url_alias);
  676. $url_alias = preg_replace('/\[uniquename\]/', $feature->uniquename, $url_alias);
  677. // the dst field of the url_alias table is only 128 characters long.
  678. // if this is the case then simply return the node URL, we can't set this one
  679. if (strlen($url_alias) > 128) {
  680. watchdog('trp-seturl', "Cannot set alias longer than 128 characters: %alias.", array('%alias' => $url_alias), WATCHDOG_ERROR);
  681. return "node/" . $node->nid;
  682. }
  683. return $url_alias;
  684. }
  685. /**
  686. *
  687. * @ingroup tripal_feature
  688. */
  689. function tripal_feature_node_view($node, $view_mode, $langcode) {
  690. switch ($node->type) {
  691. case 'chado_feature':
  692. // Show feature browser and counts
  693. if ($view_mode == 'full') {
  694. $node->content['tripal_feature_base'] = array(
  695. '#value' => theme('tripal_feature_base', array('node' => $node)),
  696. '#tripal_toc_id' => 'base',
  697. '#tripal_toc_title' => 'Details',
  698. '#weight' => 0,
  699. );
  700. $node->content['tripal_feature_alignments'] = array(
  701. '#value' => theme('tripal_feature_alignments', array('node' => $node)),
  702. '#tripal_toc_id' => 'alignments',
  703. '#tripal_toc_title' => 'Alignments',
  704. );
  705. $node->content['tripal_feature_analyses'] = array(
  706. '#value' => theme('tripal_feature_analyses', array('node' => $node)),
  707. '#tripal_toc_id' => 'analyses',
  708. '#tripal_toc_title' => 'Analyses',
  709. );
  710. $node->content['tripal_feature_featurepos'] = array(
  711. '#value' => theme('tripal_feature_featurepos', array('node' => $node)),
  712. '#tripal_toc_id' => 'featurepos',
  713. '#tripal_toc_title' => 'Maps',
  714. );
  715. $node->content['tripal_feature_properties'] = array(
  716. '#value' => theme('tripal_feature_properties', array('node' => $node)),
  717. '#tripal_toc_id' => 'properties',
  718. '#tripal_toc_title' => 'Properties',
  719. );
  720. $node->content['tripal_feature_publications'] = array(
  721. '#value' => theme('tripal_feature_publications', array('node' => $node)),
  722. '#tripal_toc_id' => 'publications',
  723. '#tripal_toc_title' => 'Publications',
  724. );
  725. $node->content['tripal_feature_references'] = array(
  726. '#value' => theme('tripal_feature_references', array('node' => $node)),
  727. '#tripal_toc_id' => 'references',
  728. '#tripal_toc_title' => 'Cross References',
  729. );
  730. $node->content['tripal_feature_relationships'] = array(
  731. '#value' => theme('tripal_feature_relationships', array('node' => $node)),
  732. '#tripal_toc_id' => 'relationships',
  733. '#tripal_toc_title' => 'Relationships',
  734. );
  735. $node->content['tripal_feature_seqence'] = array(
  736. '#value' => theme('tripal_feature_sequence', array('node' => $node)),
  737. '#tripal_toc_id' => 'sequence',
  738. '#tripal_toc_title' => 'Sequence',
  739. );
  740. $node->content['tripal_feature_synonyms'] = array(
  741. '#value' => theme('tripal_feature_synonyms', array('node' => $node)),
  742. '#tripal_toc_id' => 'synonyms',
  743. '#tripal_toc_title' => 'Synonyms',
  744. );
  745. $node->content['tripal_feature_terms'] = array(
  746. '#value' => theme('tripal_feature_terms', array('node' => $node)),
  747. '#tripal_toc_id' => 'terms',
  748. '#tripal_toc_title' => 'Annotated Terms',
  749. );
  750. }
  751. if ($view_mode == 'teaser') {
  752. $node->content['tripal_feature_teaser'] = array(
  753. '#value' => theme('tripal_feature_teaser', array('node' => $node)),
  754. );
  755. }
  756. break;
  757. case 'chado_organism':
  758. // Show feature browser and counts
  759. if ($view_mode == 'full') {
  760. $node->content['tripal_organism_feature_counts'] = array(
  761. '#value' => theme('tripal_organism_feature_counts', array('node' => $node)),
  762. '#tripal_toc_id' => 'feature_counts',
  763. '#tripal_toc_title' => 'Data Type Summary',
  764. );
  765. $node->content['tripal_organism_feature_browser'] = array(
  766. '#value' => theme('tripal_organism_feature_browser', array('node' => $node)),
  767. '#tripal_toc_id' => 'feature_browser',
  768. '#tripal_toc_title' => 'Feature Browser',
  769. );
  770. }
  771. break;
  772. // TODO: handle these node types. Should we also have a feature browser?
  773. case 'chado_library':
  774. break;
  775. case 'chado_stock':
  776. break;
  777. case 'chado_analysis':
  778. break;
  779. }
  780. }
  781. /**
  782. *
  783. * @ingroup tripal_feature
  784. */
  785. function tripal_feature_node_update($node) {
  786. // add items to other nodes, build index and search results
  787. switch ($node->type) {
  788. case 'chado_feature':
  789. // remove any previous alias
  790. db_query("DELETE FROM {url_alias} WHERE source = :source", array(':source' => "node/$node->nid"));
  791. // set the URL for this feature page
  792. $url_alias = tripal_feature_get_feature_url($node);
  793. $path_alias = array("source" => "node/$node->nid", "alias" => $url_alias);
  794. path_save($path_alias);
  795. break;
  796. }
  797. }