function connexion()
{
global $page;
global $base;
global $message;
$page['gabarit'] = "base";
$page['vue'] = "connexion.vue.php";
if (isset($_POST['loginForm_sent'])) {
$res = connexion_user($_POST['login'], $_POST['password']);
if ($res == NULL) {
$page['message'] = $message['erreur_login'];
} else {
$_SESSION['id_user'] = $res[0]['id_user'];
$_SESSION['nom_prenom'] = $res[0]['prenom_user'] . ' ' . $res[0]['nom_user'];
$roles = detail_affectation($res[0]['id_user']);
$tab_role = array();
foreach ($roles as $r) {
array_push($tab_role, $r['id_role']);
}
$_SESSION['role_user'] = $tab_role;
$_SESSION['id_lieu'] = $res[0]['id_organisme'];
header('Location: ' . $url . '?controleur=administration&tache=base');
}
}
}
function get_id_user_by_role_json($id_role, $page, $limit)
{
global $db;
$start = $limit * $page - $limit;
$sqlc = "select count(*) as count from utilisateur, affectation where affectation.id_user=utilisateur.id_user ";
$reqc = $db->prepare($sqlc);
if (!$reqc->execute()) {
write_log('Erreur SQL:' . $sql . ' sur fonction : ' . __FUNCTION__ . ' ligne : ' . __LINE__);
}
$resc = $reqc->fetchAll(PDO::FETCH_ASSOC);
$sql = "select * from utilisateur , organisme where organisme.id_organisme=utilisateur.id_organisme ";
$req = $db->prepare($sql);
if (!$req->execute()) {
write_log('Erreur SQL:' . $sql . ' sur fonction : ' . __FUNCTION__ . ' ligne : ' . __LINE__);
}
$res = $req->fetchAll(PDO::FETCH_ASSOC);
$reponse = (object) array('records' => "", 'total' => "", 'page' => "", 'rows' => "");
$count = $resc[0]['count'];
$total = ceil($count / $limit);
$reponse->page = $page;
$reponse->total = $total;
$reponse->records = $count;
$i = 0;
foreach ($res as $key => $user) {
foreach ($res[$key] as $k => $v) {
$res[$key][$k] = htmlentities(utf8_encode($v));
}
$roles = detail_affectation($user['id_user']);
if (in_array(array('id_role' => $id_role), $roles)) {
$res[$key]['identifiant'] = "<input name='users[]' type='checkbox' value='" . $user['id_user'] . "' checked='checked' />";
} else {
$res[$key]['identifiant'] = "<input name='users[]' type='checkbox' value='" . $user['id_user'] . "' />";
}
}
foreach ($res as $line) {
$reponse->rows[$i]['id'] = $line['id_user'];
$reponse->rows[$i]['cell'] = array($line['identifiant'], $line['nom_user'], $line['prenom_user'], $line['libelle_court_organisme']);
$i++;
}
return $reponse;
}
function supprimer_user()
{
global $page;
global $message;
global $url;
global $administration;
$page['gabarit'] = "administration";
if (isset($_SESSION['role_user']) && droit_acces($administration['supprimer_user'], $_SESSION['role_user'])) {
$page['vue'] = "utilisateurs/user.vue.php";
$id = "";
if (isset($_GET['id'])) {
$id = $_GET['id'];
} elseif (isset($_POST['id_user'])) {
$id = $_POST['id_user'];
}
$page['lieux'] = liste_lieux();
$page['armee'] = liste_armee();
$page['role'] = liste_role();
$page['user'] = detail_user($id);
$page['user'] = $page['user'][0];
$page['user']['roles'] = detail_affectation($id);
if (isset($_POST['suppr_user']) && !isset($_GET['id'])) {
if ($_POST['id_user'] != $_SESSION['id_user']) {
if (count_admin() > 1 || count_admin() == 1 && !is_admin($_POST['id_user'])) {
suppression_user($_POST['id_user']);
lister_user();
} else {
$page['message'] = $message['1_seul_admin'];
}
} else {
$page['message'] = $message['auto_suppression'];
}
}
} else {
$page['vue'] = "erreur_droit.vue.php";
}
}
