Subversion Repositories Sites.obs-saisons.fr

<?php

class GestionTriple extends JRestService {
        
        protected function obtenirValeursListeParId($id_liste) {
                
                $requete = 'SELECT * FROM ods_triple WHERE ot_ce_parent ='.$this->proteger($id_liste);
                $resultat = $this->executerRequete($requete);
                
                return $resultat;
                
        }
        
        protected function obtenirValeursListeParAbreviation($abreviation_triple) {
                
                $requete = 'SELECT * FROM ods_triples WHERE ot_ce_parent = (SELECT ot_id_triple FROM ods_triples WHERE ot_cle ='.$this->proteger($abreviation_triple).')';              
                $resultat = $this->executerRequete($requete);
                
                return $this->grouperResultat($resultat);
                
        }
        
        protected function obtenirValeurTripleParId($id_triple) {
                
                $requete = 'SELECT * FROM ods_triple WHERE ot_id_triple = '.$this->proteger($id_triple);
                $resultat = $this->executerRequete($requete);
                
                return $resultat['ot_valeur'];
                
        }
        
        protected function obtenirValeurTripleParAbreviation($abreviation_triple) {
                
                $requete = 'SELECT * FROM ods_triple WHERE ot_cle = '.$this->proteger($abreviation_triple);
                $resultat = $this->executerRequete($requete);
                
                return $resultat['ot_valeur'];
                
        }
        
        private function grouperResultat($tableau_resultat_requete_triple) {
                
                $tableau_resultat_requete_triple_ordonne = array();
                
                foreach($tableau_resultat_requete_triple as $valeur_triple) {
                        $tableau_resultat_requete_triple_ordonne[$valeur_triple['ot_id_triple']] = $valeur_triple;
                }
                
                return $tableau_resultat_requete_triple_ordonne;
        }
        
}

?>