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']);