Subversion Repositories Sites.obs-saisons.fr

Rev

Rev 31 | Rev 46 | Go to most recent revision | Only display areas with differences | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 31 Rev 33
1 
<?php
 1 
<?php
2 
 
 2 
 
3 
class GestionTriple extends JRestService {
 3 
class GestionTriple extends JRestService {
4
4
5 
	protected function obtenirValeursListeParId($id_liste) {
 5 
	protected function obtenirValeursListeParId($id_liste) {
6
6
7 
		$requete = 'SELECT * FROM ods_triple WHERE ot_ce_parent ='.$this->proteger($id_liste);
 7 
		$requete = 'SELECT * FROM ods_triple WHERE ot_ce_parent ='.$this->proteger($id_liste);
8 
		$resultat = $this->executerRequete($requete);
 8 
		$resultat = $this->executerRequete($requete);
9
9
10 
		return $resultat;
 10 
		return $resultat;
11
11
12 
	}
 12 
	}
13
13
14 
	protected function obtenirValeursListeParAbreviation($abreviation_triple) {
 14 
	protected function obtenirValeursListeParAbreviation($abreviation_triple) {
15
15
16 
		$requete = 'SELECT * FROM ods_triple WHERE ot_ce_parent = (SELECT ot_id_triple WHERE ot_cle ='.$this->proteger($abreviation_triple).')';
 16 
		$requete = 'SELECT * FROM ods_triples WHERE ot_ce_parent = (SELECT ot_id_triple FROM ods_triples WHERE ot_cle ='.$this->proteger($abreviation_triple).')';
17 
		$resultat = $this->executerRequete($requete);
 17 
		$resultat = $this->executerRequete($requete);
18
18
19 
		return $resultat;
 19 
		return $this->grouperResultat($resultat);
20
20
21 
	}
 21 
	}
22
22
23 
	protected function obtenirValeurTripleParId($id_triple) {
 23 
	protected function obtenirValeurTripleParId($id_triple) {
24
24
25 
		$requete = 'SELECT * FROM ods_triple WHERE ot_id_triple = '.$this->proteger($id_triple);
 25 
		$requete = 'SELECT * FROM ods_triple WHERE ot_id_triple = '.$this->proteger($id_triple);
26 
		$resultat = $this->executerRequete($requete);
 26 
		$resultat = $this->executerRequete($requete);
27
27
28 
		return $resultat['ot_valeur'];
 28 
		return $resultat['ot_valeur'];
29
29
30 
	}
 30 
	}
31
31
32 
	protected function obtenirValeurTripleParAbreviation($abreviation_triple) {
 32 
	protected function obtenirValeurTripleParAbreviation($abreviation_triple) {
33
33
34 
		$requete = 'SELECT * FROM ods_triple WHERE ot_cle = '.$this->proteger($abreviation_triple);
 34 
		$requete = 'SELECT * FROM ods_triple WHERE ot_cle = '.$this->proteger($abreviation_triple);
35 
		$resultat = $this->executerRequete($requete);
 35 
		$resultat = $this->executerRequete($requete);
36
36
37 
		return $resultat['ot_valeur'];
 37 
		return $resultat['ot_valeur'];
38
38
39 
	}
 39 
	}
- 
 
 40
- 
 
 41 
	private function grouperResultat($tableau_resultat_requete_triple) {
- 
 
 42
- 
 
 43 
		$tableau_resultat_requete_triple_ordonne = array();
- 
 
 44
- 
 
 45 
		foreach($tableau_resultat_requete_triple as $valeur_triple) {
- 
 
 46 
			$tableau_resultat_requete_triple_ordonne[$valeur_triple['ot_id_triple']] = $valeur_triple;
- 
 
 47 
		}
- 
 
 48
- 
 
 49 
		return $tableau_resultat_requete_triple_ordonne;
- 
 
 50 
	}
40
51
41 
}
 52 
}
42 
 
 53 
 
43 
?>
 54 
?>