1: <?php
 2: 
 3: namespace webservices\listing;
 4: 
 5: use \PDO as PDO;
 6: /**
 7:  * Web Service.
 8:  * Returns all Organism-Release combinations
 9:  */
10: class Organism_release extends \WebService {
11: 
12:     /**
13:      * @inheritDoc
14:      */
15:     public function execute($querydata) {
16:         global $db;
17:         $constant = 'constant';
18: 
19: 
20: #UI hint
21:         if (false)
22:             $db = new PDO();
23: 
24:         $query_get_features = <<<EOF
25: SELECT organism.common_name AS organism_name, organism.organism_id AS organism_id, dbxref.accession AS release_name
26: FROM organism
27:     JOIN organism_dbxref ON (organism.organism_id = organism_dbxref.organism_id)
28:     JOIN dbxref ON (organism_dbxref.dbxref_id = dbxref.dbxref_id)
29: WHERE
30:    dbxref.db_id = {$constant('DB_ID_IMPORTS')}
31: EOF;
32: 
33:         $stm_get_organism_release = $db->prepare($query_get_features);
34: 
35:         $data = array('results' => array());
36: 
37:         $stm_get_organism_release->execute();
38:         while ($row = $stm_get_organism_release->fetch(PDO::FETCH_ASSOC)) {
39:             $data['results']['organism'][$row['organism_id']] = array('organism_name'=>$row['organism_name'], 'organism_id'=>$row['organism_id']);
40:             $data['results']['release'][$row['organism_id']][$row['release_name']] = array('release'=>$row['release_name']);
41:         }
42: 
43:         return $data;
44:     }
45: 
46: }
47: 
48: ?>
49: