| New file |
|---|
| 0,0 → 1,88 |
|---|
| <?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 ; |
| } |
| } |
| |
| } |
| |
| ?> |