1: <?php
2:
3: namespace webservices\listing;
4:
5: use \PDO as PDO;
6: 7: 8: 9:
10: class Organism_release extends \WebService {
11:
12: 13: 14:
15: public function execute($querydata) {
16: global $db;
17: $constant = 'constant';
18:
19:
20:
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: