<?php

include "../Modeles/Modele.php";
include "../Modeles/Modele_extend.php";
include 'Controleur_class/Controleur_class_moniteur.php';
include 'Controleur_class/Controleur_class_VueConnexionMoniteur.php';
include '../Vues/Vue_connexion_moniteur.html';
$unModel = new Modele("localhost", "auto_ecole_ppe", "root", "");
$unModel->renseigner("moniteur", "nummoniteur");
if (isset($_POST['connexion'])) {
    $mail = $_POST['mailmoniteur'];
    $mdp = $_POST['mdpmoniteur'];
    try {
        $resultat = $unModel->selectwhereconnexion($mail);
        if ($resultat == false) {
            echo "Requette non effectuée.<br/>";
        }
        foreach ($resultat as $key => $value) {
            if ($value == $mdp) {
                header('Location: Controleur_moniteur.php');
            }
        }
    } catch (EXEPTION $e) {
        echo "Erreur" . $e;
    }
}
include "../Modeles/Modele_extend.php";
include '../Controleurs/Controleur_Class/Controleur_class_candidat.php';
$unModele = new Modele("localhost", "auto_ecole_ppe", "root", "");
$unModele->renseigner("candidat", "numclient");
$unModelextend = new ModelExtend("localhost", "auto_ecole_ppe", "root", "");
if (isset($_POST['inserer'])) {
    $id = 'numclient';
    $champ1 = 'nomclient';
    $champ2 = 'mailclient';
    $valeur1 = $_POST['nomclient'];
    $valeur2 = $_POST['mailclient'];
    $unModelextend->renseigner("candidat", "numclient");
    $resultat = $unModelextend->selectwhereici($id, $champ1, $champ2, $valeur1, $valeur2);
    if (!$resultat) {
        $unModele = new Modele("localhost", "auto_ecole_ppe", "root", "");
        $unModele->renseigner("candidat", "numclient");
        $unCandidat = new Candidat();
        $unCandidat->renseigner($_POST);
        $tab = $unCandidat->serialiser();
        $unModele->insert($tab);
        $notif = "Nouveau client ajouté.";
    } else {
        $notif = "Client déjà enregistré";
    }
}
$resultats = $unModele->selectAll();
$Chaine = "<table class='table table-striped'>\n\t\t\t\t\t\t<tr><td> Numero Client</td><td>Nom Client</td><td> Prenom Client</td><td>Adresse Client</td>\n\t\t\t\t\t\t<td>Date de naissance</td><td>Telephone Client</td><td>Mail Client</td><td>Date d'inscription</td>\n\t\t\t\t\t\t<td>Mode de facturation</td><td>Catégorie</td><td>Actions</td></tr>";
foreach ($resultats as $unresultat) {
    $unCandidat = new Candidat();
    $unCandidat->renseigner($unresultat);
    $Chaine .= "<tr>" . $unCandidat->afficher();