<!DOCTYPE HTML> <?php session_start(); require "fonctions.inc.php"; require "bd.inc.php"; $i = infosEntreprise(); $connexion = connect(); $nomE = $_GET['nomEntreprise']; if (isset($_POST['mdp'])) { //$mdp = md5($_POST['mdp']); $mdp = $_POST['mdp']; } if (isset($_POST['nomClient']) && isset($_POST['mailClient']) && isset($_POST['prenomClient']) && isset($_POST['loginClient']) && isset($_POST['mdpClient'])) { //récupération des infos de connexion des clients $code = code($nomE . "_client", 'id_client'); $id = $code; $nomClient = $_POST['nomClient']; $prenomClient = $_POST['prenomClient']; $mail = $_POST['mailClient']; $login = $_POST['loginClient']; //$mdpHash = md5($_POST['mdp']); $mdp = $_POST['mdpClient']; //faire fonction ajouter client ajoutClient($connexion, $id, $nomClient, $prenomClient, $mail, $login, $mdp, $nomE); $_SESSION["estConnecte"] = 1; $_SESSION["nomSession"] = $_GET['nomEntreprise']; ?> <SCRIPT language="javascript"> javascript:parent.opener.location.reload(); window.close(); </SCRIPT>
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++; } }