/**
  * Affiche le détail d'une offre d'emploi
  */
 public function displayGroupeAction()
 {
     $reposUser = new GroupeRepository();
     $groupes = $reposUser->findAll();
     $reposGroupe = new GroupeRepository();
     $groupesCount = $reposGroupe->findAllWithCount();
     //var_dump($groupes);
     $reposUser = new UserRepository();
     $users = $reposUser->findUsersInGroupeUser();
     require_once '../View/header.php';
     require_once '../View/Groupe/displayGroupe.php';
     //require_once('../View/User/index.php');
     require_once '../View/footer.php';
 }
 /**
  * Traite le formulaire de création d'une offre d'emploi et persiste l'objet Job correspondant dans la base de données.
  * Informe par mail le créateur
  */
 public function handleFormLoginAction()
 {
     /*** begin our session ***/
     if (session_id() === "") {
         session_start();
         //var_dump("handle  : " );
         //var_dump($_POST['formLogin_token']);
     }
     /*if(is_array($where)){
           $condition = "";
       }
       */
     /*** begin our session ***/
     //session_start();
     /*** first check that both the username, password and form token have been sent ***/
     if (!isset($_POST['_username'], $_POST['_password'], $_POST['formLogin_token'])) {
         $message = 'Veuillez un identifiant et un mot de passe valides';
     } elseif ($_POST['formLogin_token'] != $_POST['formLogin_token']) {
         $message = 'Soummission non valide';
     } elseif (strlen($_POST['_username']) > 20 || strlen($_POST['_username']) < 4) {
         $message = 'Longueur identifiant invalide';
     } elseif (strlen($_POST['_password']) > 20 || strlen($_POST['_password']) < 4) {
         $message = 'Longueur mot de passe invalide';
     } else {
         try {
             /*** if we are here the data is valid and we can insert it into database ***/
             $_username = filter_var($_POST['_username'], FILTER_SANITIZE_STRING);
             $_password = filter_var($_POST['_password'], FILTER_SANITIZE_STRING);
             $where = array("_username" => $_username, "_password" => $_password);
             $repos = new UserRepository();
             $userLogged = $repos->findWhere($where);
             var_dump("userLogged");
             var_dump($userLogged);
             /*** unset the form token session variable ***/
             unset($_SESSION['formLogin_token']);
             /*** if all is done, say thanks ***/
             $message = 'Félicitations, vous êtes correctement authentifié';
         } catch (Exception $e) {
             echo 'Erreur de vérification des données';
         }
     }
     return $this->indexAction($message);
     // Redirect to index
 }
 public function handleFormUploadFileAction()
 {
     $users = array();
     // check there are no errors
     if ($_FILES['file']['error'] == 0) {
         $name = $_FILES['file']['name'];
         $fileinfo = pathinfo($_FILES['file']['name']);
         $tmpName = $_FILES['file']['tmp_name'];
         // check the file is a csv
         if ($fileinfo['extension'] == 'csv') {
             if (($handle = fopen($tmpName, 'r')) !== FALSE) {
                 // necessary if a large csv file
                 set_time_limit(0);
                 $row = 0;
                 while (($data = fgetcsv($handle, 1000, ',')) !== FALSE) {
                     $users[$row] = $data[0];
                     // inc the row
                     $row++;
                     // get the values from the csv
                 }
                 fclose($handle);
             }
         }
     }
     if (!empty($users)) {
         $aUsers = array();
         foreach ($users as $key => $value) {
             $aUsers[] = explode(";", $value);
         }
         $reposUser = new UserRepository();
         try {
             foreach ($aUsers as $userKey => $userVal) {
                 $user = new User('', $userVal[0], $userVal[1], $userVal[2], $userVal[3], $userVal[4], array(), array());
                 $id = $reposUser->persist($user);
                 // On persiste l'objet dans la base et on récupère son id
             }
         } catch (\Exception $e) {
             echo "erreur parse CSV";
         }
         $this->indexAction('<strong>Succès :</strong> les utilisateurs ont bien été créés.');
         // Redirect to index
     }
 }