function creation_reservation($liste_chambres, $donnees, $nb_places, $chambre_commune) { $pdo = PdoSio::getPdoSio(); $date_debut = explode("/", $donnees[1]); $date_debut_sql = $date_debut[2] . '-' . $date_debut[0] . '-' . $date_debut[1]; $date_fin = explode("/", $donnees[2]); $date_fin_sql = $date_fin[2] . '-' . $date_fin[0] . '-' . $date_fin[1]; if ($chambre_commune != NULL) { $valeurs = array($donnees[0]['id_hebergement'], $date_debut_sql, $date_fin_sql, $donnees[5], 'non', $nb_places, $nb_places); } else { $valeurs = array($donnees[0]['id_hebergement'], $date_debut_sql, $date_fin_sql, $donnees[5], 'non', $nb_places, '1'); } $colonnes = array('id_hebergement', 'date_debut', 'date_fin', 'prix_reservation', 'paye', 'nb_personnes', 'taille_chambre'); $req = $pdo->InsertRequest('reservation', $colonnes, $valeurs); $req = $pdo->selectRequest('SELECT id_reservation FROM reservation ORDER BY id_reservation desc LIMIT 1'); $id_reservation = $req[0]['id_reservation']; if ($chambre_commune != NULL) { $valeurs = array($id_reservation, $liste_chambres['numero_chambre_0'], $liste_chambres['nom_1'], $liste_chambres['prenom_1'], $liste_chambres['mail_1']); $colonnes = array('id_reservation', 'id_chambre', 'nom_loge', 'prenom_loge', 'email_loge'); $req = $pdo->InsertRequest('reservation_chambre', $colonnes, $valeurs); $pdo->actionRequest('UPDATE hebergement SET lit_' . $nb_places . ' = lit_' . $nb_places . '-' . $nb_places . ' WHERE id_hebergement=' . $donnees[0]['id_hebergement'] . ''); } else { for ($i = 1; $i <= $nb_places; $i++) { $valeurs = array($id_reservation, $liste_chambres['numero_chambre_' . $i], $liste_chambres['nom_' . $i], $liste_chambres['prenom_' . $i], $liste_chambres['mail_' . $i]); $colonnes = array('id_reservation', 'id_chambre', 'nom_loge', 'prenom_loge', 'email_loge'); $req = $pdo->InsertRequest('reservation_chambre', $colonnes, $valeurs); } $pdo->actionRequest('UPDATE hebergement SET lit_1 = lit_1-' . $nb_places . ' WHERE id_hebergement=' . $donnees[0]['id_hebergement'] . ''); } echo '<p>Numero réservation a transmettre au client : ' . $id_reservation . '</br><a href="accueil">Revenir a l\'accueil </a></p>'; }
function afficher_hebergement_dispo($data) { $reponse = array(); //on construit la requete au fur et à mesure $requete = ''; $requete .= 'SELECT * FROM hebergement WHERE resident_hebergement="' . $data['client'] . '" '; //selection du bon type d'etablissement if ($data['residence'] != 'osef') { $requete .= 'AND categorie_hebergement ="' . $data['residence'] . '" '; } //selection de la bonne categorie de chambre if (!isset($data['chambre_commune'])) { $requete .= 'AND lit_1 > ' . intval($data['nb_places']) . ' '; } else { $requete .= 'AND lit_' . $data['nb_places'] . ' > 0 '; } $pdo = PdoSio::getPdoSio(); $req = $pdo->selectRequest($requete); //On va maintenant récupérer les services associées à chaque etablissement $liste_services = array(); foreach ($req as $key => $value) { $services = Hebergement::getServices($value['id_hebergement']); $liste_services[$key] = $services; } $reponse[0] = $req; $reponse[1] = $liste_services; return $reponse; }
function facturation_reservation($id) { $pdo = PdoSio::getPdoSio(); $pdo->actionRequest('UPDATE reservation SET paye = "oui" where id_reservation =' . $id . ''); header('Location: /loungehotel/affichage_reservation '); exit; }
function ajout_service($description) { $nom = str_replace(" ", "", $description); $valeurs = array($nom, $description); $colonnes = array('nom_service', 'description_service'); $pdo = PdoSio::getPdoSio(); $req = $pdo->InsertRequest('service', $colonnes, $valeurs); }
function suppression_events($id) { $pdo = PdoSio::getPdoSio(); $pdo->actionRequest('DELETE FROM covoiturage WHERE id_event = ' . $id . ''); $pdo->actionRequest('DELETE FROM evenements WHERE id_event = ' . $id . ''); header('Location: /scout/moderation/events '); exit; }
function suppression_news($id) { $pdo = PdoSio::getPdoSio(); $pdo->actionRequest('DELETE FROM commentaires WHERE id_news = ' . $id . ''); $pdo->actionRequest('DELETE FROM news WHERE id = ' . $id . ''); header('Location: /scout/moderation/news '); exit; }
function ajout_news($data) { $date = date('Y-m-d'); $valeurs = array($data['titre'], $data['message'], $date); $colonnes = array('titre', 'message', 'date_creation'); $pdo = PdoSio::getPdoSio(); $pdo->insertRequest('news', $colonnes, $valeurs); header('Location: /scout/accueil '); exit; }
function proposer_covoiturage($data) { $date = date('Y-m-d'); $valeurs = array($data['nom_event'], $data['description_event'], $date, $data['lieu_event'], $data['id_organisateur']); $colonnes = array('nom_event', 'description_event', 'date_event', 'lieu_event', 'organisateur_id_event'); $pdo = PdoSio::getPdoSio(); $pdo->insertRequest('evenements', $colonnes, $valeurs); header('Location: /scout/evenements '); exit; }
function get_participants_covoiturage($liste_covoiturages) { $liste = array(); foreach ($liste_covoiturages as $covoiturage) { $pdo = PdoSio::getPdoSio(); $req = $pdo->selectRequest('SELECT id_covoiturage,id_passager,nom_passager FROM participation_covoiturage WHERE id_covoiturage = ' . $covoiturage['id_covoiturage'] . ' '); if (isset($req[0])) { $liste[$covoiturage['id_covoiturage']] = $req; } } return $liste; }
public static function connexion($username, $password) { $pdo = PdoSio::getPdoSio(); $requete = 'SELECT id_proprietaire FROM proprietaire WHERE email_proprietaire = "' . $username . '" and mdp_proprietaire = "' . md5($password) . '"'; $req = $pdo->selectRequest($requete); print_r($req); if ($req) { return $req[0]['id_proprietaire']; } else { return 'false'; } }
function suppression_reservation($id) { $pdo = PdoSio::getPdoSio(); $pdo->actionRequest('DELETE from reservation_chambre where id_reservation = ' . $id . ''); $req = $pdo->selectRequest('SELECT nb_personnes,taille_chambre,hebergement.id_hebergement from hebergement,reservation where id_reservation =' . $id . ' and hebergement.id_hebergement = reservation.id_hebergement'); $infos_hebergement = $req[0]; print_r($infos_hebergement); $pdo->actionRequest('DELETE from reservation where id_reservation = ' . $id . ''); $pdo->actionRequest('UPDATE hebergement SET lit_' . $infos_hebergement['taille_chambre'] . ' = lit_' . $infos_hebergement['taille_chambre'] . '+' . $infos_hebergement['nb_personnes'] . ' WHERE id_hebergement=' . $infos_hebergement['id_hebergement'] . ''); header('Location: /loungehotel/affichage_reservation '); exit; }
function suppression_users($id) { $requete = 'DELETE FROM membres WHERE id_event = ' . $id . ''; echo $requete; $pdo = PdoSio::getPdoSio(); $pdo->actionRequest('DELETE FROM participation_covoiturage WHERE id_passager = ' . $id . ''); $pdo->actionRequest('DELETE FROM participation WHERE id_participant = ' . $id . ''); $pdo->actionRequest('DELETE FROM evenements WHERE organisateur_id_event = ' . $id . ''); $pdo->actionRequest('DELETE FROM covoiturage WHERE nom_chauffeur = ' . $id . ''); $pdo->actionRequest('DELETE FROM membres WHERE id = ' . $id . ''); header('Location: /scout/moderation/users '); exit; }
function preparation_formulaire($nb_places, $chambre_commune, $id, $data) { $pdo = PdoSio::getPdoSio(); //recuperation infos hebergement $req = $pdo->selectRequest('SELECT * FROM hebergement WHERE id_proprietaire = "' . $id . '"'); $infos_hebergement = $req[0]; //recuperation + formatage du nombre de jours que va passe le logé $date_debut = explode('/', $data['from']); $date_fin = explode('/', $data['to']); $date_debut_bd = new DateTime($data['from']); $date_fin_bd = new DateTime($data['to']); $date_debut_formatee = mktime(0, 0, 0, intval($date_debut[0]), intval($date_debut[1]), intval($date_debut[2])); $date_fin_formatee = mktime(0, 0, 0, intval($date_fin[0]), intval($date_fin[1]), intval($date_fin[2])); $diff = $date_fin_formatee - $date_debut_formatee; $retour = array(); $tmp = $diff; $retour['second'] = $tmp % 60; $tmp = floor(($tmp - $retour['second']) / 60); $retour['minute'] = $tmp % 60; $tmp = floor(($tmp - $retour['minute']) / 60); $retour['hour'] = $tmp % 24; $tmp = floor(($tmp - $retour['hour']) / 24); $retour['day'] = $tmp; $duree = $retour['day']; //recuperation des chambres correspondantes + calcul du prix if ($chambre_commune == NULL) { $chambres = array(1, $infos_hebergement['lit_1']); $prix = $infos_hebergement['prix_hebergement'] * $nb_places * $duree; } else { $chambres = array($nb_places, $infos_hebergement['lit_' . $nb_places]); $prix = $infos_hebergement['prix_hebergement'] * $duree; } //Recuperation des services selectionnes et MaJ du prix $liste_services = Hebergement::getServicesTab(Hebergement::getId($id)); $services_selectionnes = array(); foreach ($liste_services as $service) { if (isset($data[$service['nom_service']])) { $services_selectionnes[$service['nom_service']] = $service['prix_service']; $prix += $service['prix_service'] * $nb_places * $duree; } } //variable contenant toutes les données $donnees = array($infos_hebergement, $data['from'], $data['to'], $duree, $chambres, $prix, $services_selectionnes); print_r($donnees); return $donnees; }
function ajout_commentaire($message, $id_news, $id_auteur, $auteur) { /*//ajout d'un commentaire dans la bdd if (isset($message) && strlen($message)<50){ global $bdd; $req = $bdd->prepare('INSERT INTO commentaires(id_news, id_auteur, auteur, message, date_creation) VALUES(:id_news, :id_auteur, :auteur, :message, :date_creation)'); $req->execute(array('id_news' => $id_news, 'id_auteur' => $id_auteur, 'auteur' => $auteur, 'message' => $message, 'date_creation' => date('Y-m-d h:i:s'))); $req->closeCursor(); }*/ $date = date('Y-m-d h:i:s'); $valeurs = array($id_news, $id_auteur, $auteur, $message, $date); $colonnes = array('id_news', 'id_auteur', 'auteur', 'message', 'date_creation'); $pdo = PdoSio::getPdoSio(); $req = $pdo->InsertRequest('commentaires', $colonnes, $valeurs); }
function recuperation_hebergement($id) { $pdo = PdoSio::getPdoSio(); $req = $pdo->selectRequest('SELECT id_hebergement,nom_hebergement from hebergement where id_proprietaire =' . $id . ''); return $req[0]; }
function get_particular_news($id_news) { $pdo = PdoSio::getPdoSio(); $req = $pdo->selectRequest('SELECT id,titre,message,date_creation,image FROM news WHERE id = ' . $id_news . ' '); return $req[0]; }
function affichage_reservation($id) { $pdo = PdoSio::getPdoSio(); $req = $pdo->selectRequest('SELECT * from reservation where id_hebergement =' . $id . ''); return $req; }
function affichage_users() { $pdo = PdoSio::getPdoSio(); $req = $pdo->selectRequest('SELECT * FROM membres where id != 1 ORDER BY id DESC'); return $req; }
function get_news($offset, $limite) { $pdo = PdoSio::getPdoSio(); $req = $pdo->selectRequest('SELECT id,titre,message,date_creation,image FROM news ORDER BY id DESC LIMIT ' . $offset . ', ' . $limite . ' '); return $req; }
public static function getDroitGalerie($id) { $pdo = PdoSio::getPdoSio(); $req = $pdo->selectRequest('SELECT droit_galerie FROM membres WHERE id = "' . $id . '" and droit_galerie="oui"'); if ($req) { return $req[0]; } else { return 'false'; } }
function get_commentaires($id_news) { $pdo = PdoSio::getPdoSio(); $req = $pdo->selectRequest('SELECT id,id_news, auteur, message, date_creation FROM commentaires WHERE id_news=' . $id_news . ' ORDER BY id ASC'); return $req; }
function affichage_news() { $pdo = PdoSio::getPdoSio(); $req = $pdo->selectRequest('SELECT * FROM news ORDER BY id DESC'); return $req; }
function affichage_services() { $pdo = PdoSio::getPdoSio(); $req = $pdo->selectRequest('SELECT nom_service,description_service FROM service'); return $req; }
public static function getListeImages() { $pdo = PdoSio::getPdoSio(); $req = $pdo->selectRequest('SELECT id_image, nom_image, date_creation_image FROM images ORDER BY id_image DESC'); return $req; }
function affichage_events() { $pdo = PdoSio::getPdoSio(); $req = $pdo->selectRequest('SELECT * FROM evenements ORDER BY id_event DESC'); return $req; }
function get_covoiturages($id_event) { $pdo = PdoSio::getPdoSio(); $req = $pdo->selectRequest('SELECT id_covoiturage,id_chauffeur,nom_chauffeur,places,fumeur,lieu_depart,heure_depart FROM covoiturage WHERE id_event = ' . $id_event . ' '); return $req; }
public static function getId($id_proprietaire) { $pdo = PdoSio::getPdoSio(); $req = $pdo->selectRequest('SELECT id_hebergement FROM hebergement WHERE id_proprietaire = ' . $id_proprietaire . ''); return $req[0]['id_hebergement']; }