Subversion Repositories Applications.papyrus

<?php
class liste_admin_model extends Model { 
        
        var $config = array() ;
        
        function __construct() {
                
                parent::Model() ;
        }
                
        function loadAdmin() {
                        
                $this->load->database() ;       
                $query = 'SELECT * FROM  gen_annuaire ORDER BY ga_id_administrateur' ;
                $res = $this->db->query($query) ;
                $admin = array() ;
                foreach ($res->result() as $ligne)
                {
                        $admin[] = $ligne ;
                }
        
                return $admin ;
        }
        
        function loadDetailsAdmin($id) {
                        
                $this->load->database() ;       
                $query = 'SELECT * FROM  gen_annuaire where ga_id_administrateur="'.$id.'"' ;
                $res = $this->db->query($query) ;
                $admin = array() ;
                foreach ($res->result() as $ligne)
                {
                        $admin[] = $ligne ;
                }
        
                return $admin ;
        }
        
        function modifDetailsAdmin($id,$nom,$prenom,$mail,$lang) {
                
                $this->load->database() ;       
                $query = 'UPDATE gen_annuaire SET ga_ce_i18n="'.$lang.'", ga_nom="'.$nom.'",ga_prenom="'.$prenom.'",ga_mail="'.$mail.'"
                WHERE ga_id_administrateur="'.$id.'"' ;
                
                if($res = $this->db->query($query)) {
                        return true ;
                } else {
                        return false ;
                }
                
        }
        
        function suppAdmin($id) {
                
                $this->load->database() ;
                $query = 'DELETE FROM gen_annuaire WHERE ga_id_administrateur="'.$id.'"' ;
                
                if($res = $this->db->query($query)) {
                        return true ;
                } else {
                        return false ;
                }
        }
        
        function ajoutAdmin($nom,$prenom,$mail,$lang,$pass,$pass_conf) {
                $this->load->database() ;
                $nouvel_id = 0 ;
                $query = 'SELECT MAX(ga_id_administrateur) as nouvel_id FROM gen_annuaire' ;
                
                if($res = $this->db->query($query)) {
                        
                        $ligne = $res->result() ;
                        $nouvel_id = $ligne[0]->nouvel_id + 1 ;                 
                } else {
                        return false ;
                }
                
                $query = 'INSERT INTO gen_annuaire VALUES ("'.$nouvel_id.'","'.$lang.'","'.$nom.'","'.$prenom.'","'.md5($pass).'","'.$mail.'")' ;
                if($res = $this->db->query($query)) {
                        return true ;
                } else {
                        return false ;
                }
        }

}
        
?>