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_triple WHERE ot_ce_parent = (SELECT ot_id_triple WHERE ot_cle ='.$this->proteger($abreviation_triple).')';
                $resultat = $this->executerRequete($requete);
                
                return $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'];
                
        }
        
}

?>