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 ; |
} |
} |
|
} |
|
?> |