function enregistreReserv($connexion, $listePrest, $client, $date, $heure, $paye, $duree, $prix)
{
$nomE = $_SESSION["nomE"];
$info = infosEntreprise();
if ($info->CreneauLibre == 0) {
$minute = intval(substr($heure, 3, 4));
$limite = array(0, 15, 30, 45);
while (!in_array($minute, $limite)) {
$minute--;
}
$heure = intval(substr($heure, 0, 2));
$heure = new DateTime($heure . ':' . $minute . ':00');
$heure = $heure->format('H:i:s');
while ($duree % 15 != 0) {
$duree++;
}
}
$id = code($nomE . "_reserv", 'id_reserv');
$emp = employeOk($listePrest);
$emp = $emp[0];
$rqtAjoutRes = $connexion->prepare("INSERT INTO " . $nomE . "_reserv(id_reserv, client, employe, paye, date, heure, prix, duree)\r\n\t\t\t\t\tVALUES (:id, :cli, :emp, :payer, :d, :h, :p, :du)");
$rqtAjoutRes->execute(array('id' => $id, 'cli' => $client, 'emp' => $emp, 'payer' => $paye, 'd' => $date, 'h' => $heure, 'p' => $prix, 'du' => $duree));
$id2 = code($nomE . "_prestresv", 'id_prestresv');
foreach ($listePrest as $val) {
$rqtAjoutPresRes = $connexion->prepare("INSERT INTO " . $nomE . "_prestresv(id_prestresv, reservation, prestation)\r\n\t\t\t\t\tVALUES (:id, :res, :prest)");
$rqtAjoutPresRes->execute(array('id' => $id2, 'res' => $id, 'prest' => $val));
$id2++;
}
}
<ul class="events">
<li>
<?php
if ($date->days[$w - 1] != 'Dimanche') {
if ($m < 10) {
$mF = '0' . $m;
} else {
$mF = $m;
}
if ($d < 10) {
$dF = '0' . $d;
} else {
$dF = $d;
}
$dateF = $year . '-' . $mF . '-' . $dF;
$emp2 = employeOk($_SESSION['prestListe']);
$i = 0;
echo "Créneau occupé par employé : </br>";
while ($i < sizeof($emp2)) {
$num = $i + 1;
echo "Employe " . $num . " : ";
$jm = $date->days[$w - 1] . 'M';
$ja = $date->days[$w - 1] . 'A';
$rqtPlan = $connexion->prepare("SELECT " . $jm . ", " . $ja . " FROM " . $nomE . "_planning WHERE code_employe = '" . $emp2[$i] . "'");
$rqtPlan->execute();
$donnees = $rqtPlan->fetch(PDO::FETCH_OBJ);
if ($donnees->{$jm} == 0 && $donnees->{$ja} == 0) {
echo "Absent";
} else {
$rqtAbs = $connexion->prepare("SELECT dateDebut, dateFin, demiJourDebut, demiJourFin FROM " . $nomE . "_absence WHERE '" . $dateF . "' BETWEEN dateDebut AND dateFin AND code_employe = '" . $emp2[$i] . "' ORDER BY dateDebut ASC");
$rqtAbs->execute();
}
if ($c->categorie == $categAncienne) {
if (!in_array($val, $_POST['choix'])) {
unset($_SESSION["prestListe"][array_search($val, $_SESSION["prestListe"])]);
}
}
}
$liste = employeOk($_SESSION["prestListe"]);
if (sizeof($liste) != 0) {
$_SESSION["employeRes"] = $liste->employe;
header('Location: dateReserv.php?nomEntreprise=' . $nomE);
} else {
$erreur = 2;
}
} else {
$liste = employeOk($_SESSION["prestListe"]);
if (sizeof($liste) != 0) {
$_SESSION["employeRes"] = $liste->employe;
header('Location: dateReserv.php?nomEntreprise=' . $nomE);
} else {
$erreur = 2;
}
}
}
}
}
if (isset($_POST['annule'])) {
header('Location: accueil_client.php?nomEntreprise=' . $nomE);
unset($_SESSION['prestListe']);
unset($_SESSION['date']);
unset($_SESSION['heure']);
