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