12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091929394959697 |
- <?php
- function tripal_organism_get_organism_by_nid($nid) {
- return node_load($nid);
- }
- function tripal_organism_get_organism_by_organism_id($organism_id) {
- $sql = "SELECT nid FROM {chado_organism} WHERE organism_id = :organism_id";
- $r = db_query($sql, array(':organism_id' => $organism_id))->fetchObject();
- if (!empty($r->nid)) {
- return node_load($r->nid);
- }
- else {
- drupal_set_message(t("Function: tripal_organism_get_organism_by_organism_id() -no organism with that organism id sync'd with drupal"), 'error');
- }
- return 0;
- }
- function tripal_organism_get_synced() {
-
- $dsql = "SELECT * FROM {chado_organism}";
- $orgs = db_query($dsql);
-
- $csql = "SELECT * FROM {Organism} " .
- "WHERE organism_id = :organism_id";
- $org_list = array();
-
- foreach ($orgs as $org) {
- $args = array(':organism_id' => $org->organism_id);
- $org = chado_query($csql, $args)->fetchObject();
- $org_list[] = $org;
- }
- return $org_list;
- }
- function tripal_organism_get_image_url($organism, $nid = NULL) {
- $url = '';
-
-
-
-
-
- $base_path = realpath('.');
- $image_dir = tripal_get_moddir('tripal_organism') . "/images";
- $image_name = $organism->genus . "_" . $organism->species . ".jpg";
- if (file_exists("$base_path/$image_dir/$image_name")) {
- $url = file_create_url("$image_dir/$image_name");
- }
- else {
- $image_name = $nid . ".jpg";
- if (file_exists("$base_path/$image_dir/$image_name")) {
- $url = file_create_url("$image_dir/$image_name");
- }
- }
- return $url;
- }
|