Sélectionner une révision Git
Après avoir pris connaissance de ces consignes de contribution, vous serez prêt à
contribue à ce projet.
db_data.php 8,62 Kio
<?php
/**
* Created by PhpStorm.
* User: JALIK
* Date: 09/04/2019
* Time: 08:37
*/
require_once('db_connect.php');
require_once('Classes/Evenement.php');
require_once('Classes/Commande.php');
require_once('Classes/Utilisateur.php');
/**@brief récupère le nom de l'evenement actuel
*
* @return NULL Si il n'y a aucun evenement courant
@return Evenement si il y a un evenement
*/
function db_getActuelEvenement(){
$pdo = $GLOBALS['connection'];
$dateToday = date("Y-m-d");
$statement = $pdo->prepare("SELECT * FROM event WHERE event.date_start < '?' AND event.date_end > '?'");
$statement->execute([$dateToday, $dateToday]);
$event = $statement->fetch();
if($event == false || !isset($event))
return NULL;
$evenement = new Evenement($event['eventID'],
$event['typeEvent'],
$event['numeroEvent'],
$event['date_end']);
return $evenement;
}
function db_getAllFoods(){
$pdo = $GLOBALS['connection'];
$statement = $pdo->prepare(
"SELECT idPartenariat, nomPartenariat FROM partenariat"
);
$statement->execute();
$parts = array();
while($part = $statement->fetch()){
$typeFoods = array();
$typeFoods['Nom'] = $part['nomPartenariat'];
$typeFoods['idPart'] = $part['idPartenariat'];
$typeFoods['typeFood'] = array();
$statement_typeFoods = $pdo->prepare(
"SELECT DISTINCT TF.foodTypeID, TF.nomTypeFood
FROM foods AS F INNER JOIN foodtype AS TF ON F.foodTypeID = TF.foodtypeID
WHERE F.partID = ?
GROUP BY foodTypeID"
);
$statement_typeFoods->execute([$typeFoods['idPart']]);
while($type_db = $statement_typeFoods->fetch()){
$type = array();
$type['idType'] = $type_db['foodTypeID'];
$type['nomType'] = $type_db['nomTypeFood'];
$type['foods'] = array();
$statement_foods = $pdo->prepare(
"SELECT F.isAvailable, F.nomFood, F.priceIIE, F.pricePart, F.foodID
FROM foods AS F
WHERE foodTypeID = ? AND partID = ?"
);
$statement_foods->execute([$type['idType'], $typeFoods['idPart']]);
while($foods_db = $statement_foods->fetch()){
if($foods_db['isAvailable'] == 0){
continue; //On ajoute pas la nourriture au tableausi elle n'est pas dispo
}
$food = array();
$food['foodID'] = $foods_db['foodID'];
$food['nameFood'] = $foods_db['nomFood'];