<?php

session_start();
include "../modeles/Modele.php";
include "../modeles/Modele_extend.php";
include 'Controleur_Class/Controleur_class_candidat.php';
include 'Controleur_Class/Controleur_class_vehicule.php';
include 'Controleur_Class/Controleur_class_lecon.php';
include 'Controleur_Class/Controleur_class_moniteur.php';
include 'Controleur_Class/Controleur_class_planning.php';
$unMoniteur = new Moniteur();
$unModele = new Modele("localhost", "auto_ecole_ppe", "root", "");
$unModele->renseigner("moniteur", "nummoniteur");
$unModelextend = new ModelExtend("localhost", "auto_ecole_ppe", "root", "");
$view = "planningmoniteur";
$chaine = "";
$resultat = $unModelextend->selectAllTablePlanningMoniteur($view);
$chaine = "<table class='table table-striped'>\n\t\t\t<tr><td>Date debut</td><td>Date fin</><td>Heure debut leçon</td><td>Heure fin leçon</td><td>Numéro vehicule</td><td>Nom candidat</td><td>Etat du planning</td><td>Nom du Moniteur</td></tr>";
foreach ($resultat as $key => $value) {
    $unPlanning = new Planning();
    $unPlanning->renseigner($value);
    $chaine .= $unPlanning->afficherPlanning();
}
$chaine .= "</table>";
include "../Vues/Vue_planning_moniteur.html";
?>
			
			
<?php

include "../Modeles/Modele.php";
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) {