Subversion Repositories Applications.papyrus

Compare Revisions

Ignore whitespace Rev 2002 → Rev 2003

/trunk/papyrus/applications/admin_administrateur/models/liste_admin_model.php
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 ;
}
}
 
}
?>
/trunk/papyrus/applications/admin_administrateur/models/index.html
New file
0,0 → 1,10
<html>
<head>
<title>403 Forbidden</title>
</head>
<body>
 
<p>Directory access is forbidden.</p>
 
</body>
</html>