<?php
// Connexion à la base de donnée
$conn = new PDO('mysql:host=db5000078384.hosting-data.io;port=3306;dbname=dbs73017','dbu252833','BDD@ST@g1@1rE2019');

$dateD = $_POST['dateD'];
$nomD = $_POST['nomD'];
$prenomD = $_POST['prenomD'];
$statutD = $_POST['statutD'];
$centre = $_POST['centre'];
$dest = $_POST['dest'];
$obj = $_POST['obj'];
$dateS = $_POST['dateS'];
$heureD = $_POST['heureD'];
$heureR = $_POST['heureR'];
$nbrKM = $_POST['nbrKM'];
$coutE = $_POST['coutE'];
$lien = $_POST['lien'];
/////////////////////- Véhicules -////////////////////////////
$clio1 = $_POST['clio1'];
$immat1 = $_POST['immat1'];

$clio2 = $_POST['clio2'];
$immat2 = $_POST['immat2'];

$clio3 = $_POST['clio3'];
$immat3 = $_POST['immat3'];
$info1 = $_POST['info1'];

$voit1 = $_POST['5008'];
$immat4 = $_POST['immat4'];

$voit2 = $_POST['modus'];
$immat5 = $_POST['immat5'];
$info2 = $_POST['info2'];

$master1 = $_POST['master1'];
$immat6 = $_POST['immat6'];
$info3 = $_POST['info3'];

$master2 = $_POST['master2'];
$immat7 = $_POST['immat7'];
$info4 = $_POST['info4'];

$traffic1 = $_POST['traffic1'];
$immat8 = $_POST['immat8'];
$info5 = $_POST['info5'];

$traffic2 = $_POST['traffic2'];
$immat9 = $_POST['immat9'];
$info6 = $_POST['info6'];

$bus = $_POST['bus'];
$info7 = $_POST['info7'];

$ticketSETRAM = $_POST['ticket'];

/////////////////////////////////////////////////

$classe = $_POST['classe'];
$nbrAp = $_POST['nbA'];
$RespS = $_POST['RespS'];
$accomp = $_POST['accomp'];

////////////////////- Cours remplacé -//////////////////////
$classe1 = $_POST['Class1'];
$creneau1 = $_POST['Creneau1'];
$rempl1 = $_POST['Rempl1'];

$classe2 = $_POST['Class2'];
$creneau2 = $_POST['Creneau2'];
$rempl2 = $_POST['Rempl2'];

$classe3 = $_POST['Class3'];
$creneau3 = $_POST['Creneau3'];
$rempl3 = $_POST['Rempl3'];

$classe4 = $_POST['Class4'];
$creneau4 = $_POST['Creneau4'];
$rempl4 = $_POST['Rempl4'];

$classe5 = $_POST['Class5'];
$creneau5 = $_POST['Creneau5'];
$rempl5 = $_POST['Rempl5'];

$classe6 = $_POST['Class6'];
$creneau6 = $_POST['Creneau6'];
$rempl6 = $_POST['Rempl6'];

$classe7 = $_POST['Class7'];
$creneau7 = $_POST['Creneau7'];
$rempl7 = $_POST['Rempl7'];

$classe8 = $_POST['Class8'];
$creneau8 = $_POST['Creneau8'];
$rempl8 = $_POST['Rempl8'];


/////////////////////////////- Repas -////////////////////////////

$typeRepas = $_POST['Repas'];
$nbInterne = $_POST['int'];
$nbDP = $_POST['dp'];
$nbExterne = $_POST['ext'];
$nbAccomp = $_POST['accompRepas'];

$Hcuisine = $_POST['horaire'];


// Connexion à la base de donnée
$conn = new PDO('mysql:host=db5000078384.hosting-data.io;port=3306;dbname=dbs73017','dbu252833','BDD@ST@g1@1rE2019');

$req1 = ("INSERT INTO ordresmission(TYPEREPAS, NBREPASINT, NBREPASDP, NBREPASEXT, NBREPASACCOMP, HORAIRE_CUISINE) VALUES('".$typeRepas."','".$nbInterne."','".$nbDP."','".$nbExterne."','".$nbAccomp."','".$Hcuisine."');");
$conn -> exec($req1);

$req2 = ("INSERT INTO classe(LIBELLE) VALUES('".$classe1."','".$classe2."','".$classe3."','".$classe4."','".$classe5."','".$classe6."','".$classe7."','".$classe8."');");
$conn -> exec($req2);

$req3 = ("INSERT INTO remplacement(CREANEAU, COURS) VALUES('".$creneau1."','".$rempl1."','".$creneau2."','".$rempl2."','".$creneau3."','".$rempl3."','".$creneau4."','".$creneau4."','".$rempl5."','".$creneau5."','".$creneau6."','".$rempl6."','".$creneau7."','".$creneau7."','".$rempl8."','".$creneau8."');");
$conn -> exec($req3);

$req4 = ("INSERT INTO classe(LIBELLE) VALUES('".$classe."');");
$conn -> exec($req4);

$req5 = ("INSERT INTO demandeur(nom) VALUES('".$accomp."');");
$conn -> exec($req5);

$req6 = ("INSERT INTO ordresmission(ID_ETRE_RESPONSABLE) VALUES('".$RespS."');");
$conn -> exec($req6);

$req7 = ("INSERT INTO ordresmission(NBRAPPRENANT) VALUES('".$nbrAp."');");
$conn -> exec($req7);

$req8 = ("INSERT INTO vehicule(IMMAT, NOM, INFO) VALUES('".$immat1."','".$clio1."','".$immat2."','".$clio2."','".$immat3."','".$clio3."','".$info1."','".$immat4."','".$voit1."', '".$immat5."','".$voit2."','".$immat6."','".$master1."','".$info2."','".$immat7."','".$master2."','".$info4."','".$immat8."','".$traffic1."','".$info5."','".$immat9."','".$traffic2."','".$info6."','".$bus."','".$info7."');");
$conn -> exec($req8);

//$req9 = ("INSERT INTO centre(nom) VALUES('".$centre."');");
//$conn -> exec($req9);

$req10 = ("INSERT INTO demandeur(NOM, PRENOM,STATUT) VALUES('".$nomD."','".$prenomD."','".$statutD."');");
$conn -> exec($req10);


$req11 = ("INSERT INTO ordresmission(DATEDEMANDE, DESTINATION, NATURE,DATESORTIE, HEURED,HEURER, NBKM, COUTESTIME, LIEN) VALUES('".$dateD."','".$dest."','".$obj."','".$dateS."','".$heureD."','".$heureR."','".$nbrKM."','".$coutE."','".$lien."');");
$conn -> exec($req11);


header("Location: ../GestionDemande.php");
?>