<?php
                                        if ($_SESSION['type'] == 1)
                                        {
                                            echo '<br /><button style="margin-top :  15px;"   class="btn btn-primary" type="submit"  name ="supprimer"   value="supprimer" >Supprimer votre compte</button>';
                                            if(!empty($_POST['supprimer']))
                                            {
                                                $idlisteUser = array() ;
                                                $recuperation_infosbuild = $pdo-> prepare('SELECT idListe FROM `liste` WHERE USER_idUSER = ?  ');
                                                $recuperation_infosbuild -> execute([$_SESSION['id']]);

                                                foreach($recuperation_infosbuild as $idListe)
                                                {
                                                    $idListe            = $idListe->idListe;
                                                    array_push($idlisteUser,$idListe) ;
                                                }
                                                for ($i=0 ; $i < count($idlisteUser) ; $i++)
                                                {
                                                    $recuperation_infosbuild = $pdo-> prepare('DELETE FROM contient WHERE Liste_idListe = ?');
                                                    $recuperation_infosbuild -> execute([$idListe]);

                                                    $recuperation_infosbuild = $pdo-> prepare('DELETE FROM liste WHERE idListe = ?');
                                                    $recuperation_infosbuild -> execute([$idListe]);
                                                }


                                                $recuperation_infosbuild = $pdo-> prepare('DELETE FROM users WHERE idUSER = ?');
                                                $recuperation_infosbuild -> execute([$_SESSION['id']]);
                                                header('location:index.php');
                                                session_destroy();                  }
                                        }
                                        else
                                        {
                                            echo'<p><strong><u><h3 class="text-dark">Modification Utilisateurs  </h3></u></strong></p>';


                                                $recupUser = $pdo->prepare('SELECT idUSER, username FROM users');
                                                $recupUser -> execute();

                                                echo '<br/><select name ="selectUser">
                                                    <option value="null"> Choisissez un utilisateur</option>';
                                                foreach ($recupUser as $user)
                                                {
                                                    $idUser         = $user->idUSER;
                                                    $userName       = $user->username;

                                                    if(!empty($idUser))
                                                    {
                                                        echo '<option value="',$idUser,'">id :',$idUser,' nom : ',$userName,' </option>';
                                                    }
                                                }
                                                echo'</select>';
                                                if(!empty($_POST['selectUser']) and $_POST['selectUser'] != "null")
                                                $idUserSelected =  $_POST['selectUser'];
                                                {

                                                    echo '
                                                        <div class="form-inline">
                                                            <div class="form-group">
                                                                <label for="input_username"><h3>Nom : </h3></label>
                                                                <input type="text" class="form-control" name="usernameUtil"></input>
                                                            </div>
                                                        </div>
                                                        <div class="form-inline">
                                                            <div class="form-group">
                                                                <label for="input_userfirstname"><h3>Prénom : </h3></label>
                                                                <input type="text" class="form-control" name="userfirstnameUtil"></input>
                                                            </div>
                                                        </div>
                                                        <div class="form-inline">
                                                            <div class="form-group">
                                                                <label for="Email"><h3>Email : </h3></label>
                                                                <input type="text" class="form-control" name="emailUtil"></input>
                                                            </div>
                                                        </div>
                                                        <div class="form-inline">
                                                            <div class="form-group">
                                                                <label for="password"><h3>Mot de passe : </h3></label>
                                                                <input type="text" class="form-control" name="passwordUtil"></input>
                                                        </div>';

                                                echo'<br /><br/><button type ="submit" class="btn btn-primary" name ="choisirUtil" value="choisirUtil"   >Modifier un utilisateur </button>';
                                                if(!empty($_POST['emailUtil']) OR !empty($_POST['passwordUtil']) OR !empty($_POST['usernameUtil']) OR !empty($_POST['userfirstnameUtil']))
                                                {
                                                    $errorsUser = array();
                                                    $nouveau_passwordUser = $_POST['passwordUtil'];
                                                    $emailUser = $_POST['emailUtil'];
                                                    $usernameUser = $_POST['usernameUtil'];
                                                    $userfirstnameUser =$_POST['userfirstnameUtil'];



                                                    if(!empty($usernameUser))
                                                    {
                                                        if(!preg_match('/^[a-zA-Z0-9_]+$/', $usernameUser))
                                                        {
                                                            $errorsUser['username'] = "pseudo invalide" ;
                                                        }
                                                        else
                                                        {
                                                            $req = $pdo-> prepare('SELECT idUSER FROM users WHERE username = ?');
                                                            $req -> execute([$usernameUser]);
                                                            $user = $req -> fetch();
                                                            if($user){
                                                                $errorsUser['username'] = "peuso déja pris";
                                                            }

                                                        }
                                                    }

                                                    if(!empty($userfirstnameUser))
                                                    {
                                                        if(!preg_match('/^[a-zA-Z0-9_]+$/', $userfirstnameUser))
                                                        {
                                                            $errorsUser['userfirstname'] = "pseudo invalide" ;
                                                        }
                                                        else
                                                        {
                                                            $req = $pdo-> prepare('SELECT idUSER FROM users WHERE userfirstname = ?');
                                                            $req -> execute([$userfirstnameUser]);
                                                            $user = $req -> fetch();
                                                            if($user){
                                                                $errorsUser['userfirstname'] = "peuso déja pris";
                                                            }

                                                        }
                                                    }
                                                    if(!empty($emailUser))
                                                    {
                                                        if(!filter_var($emailUser,FILTER_VALIDATE_EMAIL))
                                                        {
                                                            $errorsUser['email'] ="votre email n'est pas valide" ;
                                                        }
                                                        else
                                                        {
                                                            $req = $pdo-> prepare('SELECT idUSER FROM users WHERE email = ?');
                                                            $req -> execute([$emailUser]);
                                                            $user = $req -> fetch();
                                                            if($user){
                                                                $errorsUser['email'] = "email déja pris";
                                                            }

                                                        }
                                                    }


                                                    if(empty($errorsUser))

                                                    {

                                                        if(!empty($usernameUser))
                                                        {
                                                            $req = $pdo -> prepare("UPDATE users SET username = ? WHERE idUSER = ?");
                                                            $req-> execute([$usernameUser,$idUserSelected]);


                                                        }
                                                        if(!empty($userfirstnameUser))
                                                        {
                                                            $req = $pdo -> prepare("UPDATE users SET userfirstname = ? WHERE idUSER = ?");
                                                            $req-> execute([$userfirstnameUser,$idUserSelected] );

                                                        }

                                                        if(!empty($emailUser))
                                                        {
                                                            $req = $pdo -> prepare("UPDATE users SET email = ? WHERE idUSER = ?");
                                                            $req-> execute([$emailUser,$idUserSelected ]);


                                                        }

                                                        if(!empty($nouveau_passwordUser))
                                                        {
                                                            $req = $pdo -> prepare("UPDATE users SET password = ? WHERE idUSER = ?");

                                                            $req-> execute([sha1($nouveau_passwordUser),$idUserSelected ]);

                                                        }
                                                        echo '<script>window.location.href="profil.php"</script>';

                                                    }
                                                }
                                                echo'<button style="margin-left : 10px;" type ="submit" class="btn btn-primary" name ="SupprimerUtil" value="SupprimerUtil"   >Supprimer un utilisateur </button>';
                                                if(!empty($_POST['SupprimerUtil']))
                                                {
                                                    $idlisteUser = array() ;
                                                    $recuperation_infosbuild = $pdo-> prepare('SELECT idListe FROM `liste` WHERE USER_idUSER = ?  ');
                                                    $recuperation_infosbuild -> execute([$idUserSelected]);

                                                    foreach($recuperation_infosbuild as $idListe)
                                                    {
                                                        $idListe            = $idListe->idListe;
                                                        array_push($idlisteUser,$idListe) ;
                                                    }
                                                    for ($i=0 ; $i < count($idlisteUser) ; $i++)
                                                    {
                                                        $recuperation_infosbuild = $pdo-> prepare('DELETE FROM contient WHERE Liste_idListe = ?');
                                                        $recuperation_infosbuild -> execute([$idListe]);

                                                        $recuperation_infosbuild = $pdo-> prepare('DELETE FROM liste WHERE idListe = ?');
                                                        $recuperation_infosbuild -> execute([$idListe]);
                                                    }

                                                    $recuperation_infosbuild = $pdo-> prepare('DELETE FROM users WHERE idUSER = ?');
                                                    $recuperation_infosbuild -> execute([$idUserSelected]);
                                                    echo '<script>window.location.href="profil.php"</script>';


                                                }


                                            }

                                        }

                                        ?>