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;
}
public static function getPdoSio()
{
if (PdoSio::$myPdoSio == null) {
PdoSio::$myPdoSio = new PdoSio();
}
return PdoSio::$myPdoSio;
}
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_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 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;
}
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 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;
}
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 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;
}
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 recuperation_hebergement($id)
{
$pdo = PdoSio::getPdoSio();
$req = $pdo->selectRequest('SELECT id_hebergement,nom_hebergement from hebergement where id_proprietaire =' . $id . '');
return $req[0];
}
function affichage_services()
{
$pdo = PdoSio::getPdoSio();
$req = $pdo->selectRequest('SELECT nom_service,description_service FROM service');
return $req;
}
function affichage_news()
{
$pdo = PdoSio::getPdoSio();
$req = $pdo->selectRequest('SELECT * FROM news ORDER BY id DESC');
return $req;
}
function affichage_events()
{
$pdo = PdoSio::getPdoSio();
$req = $pdo->selectRequest('SELECT * FROM evenements ORDER BY id_event DESC');
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;
}
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_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'];
}
