public function checkBookingById($customerId, $bookingId, $bookingDate)
{
$database = new Database();
if ($database->queryOne('SELECT COUNT(*) as result FROM Booking WHERE Customer_Id = ? AND Id = ? AND BookingDate = ?', [$customerId, $bookingId, $bookingDate])['result'] == 1) {
return true;
}
return false;
}
private function getNumberOfTryConnectionByIp($ip)
{
$database = new Database();
return $database->queryOne('
SELECT COUNT(LoginIp) AS total
FROM Login
WHERE (LoginTime BETWEEN DATE_SUB(NOW(),INTERVAL 5 MINUTE) AND NOW())
AND LoginIp = ?', [$ip]);
}
public function findWithCredentials($email, $password)
{
$Database = new Database();
$user = $Database->queryOne('SELECT Id, Password FROM Customer WHERE Email = ?', [$email]);
if (!$user) {
return 'Error=4';
} else {
$verificationPassword = $this->verifyPassword($password, $user['Password']);
if ($verificationPassword) {
return $user['Id'];
} else {
return 'Error=5';
}
}
}
public function findWithCredentials($name, $password)
{
$Database = new Database();
$user = $Database->queryOne('SELECT AdminId, Password FROM Admin WHERE Name = ?', [$name]);
if (!$user) {
return 'Error';
} else {
$verificationPassword = $this->verifyPassword($password, $user['Password']);
if ($verificationPassword) {
return $user['AdminId'];
} else {
return 'Error';
}
}
}
public function httpPostMethod(Http $http, array $formFields)
{
$dateTime = date_create($formFields['resaDate']);
$resaDate = date_format($dateTime, 'Y-m-d');
//var_dump($_POST, $resaDate);
$booking = new Database();
$userSession = new UserSession();
$userId = $userSession->getId();
//var_dump($userId);
if (ctype_digit($userId)) {
$bookingList = $booking->queryOne('SELECT COUNT(Id) AS count FROM Booking WHERE Customer_Id = ? AND BookingDate = ?', [$userId, $resaDate]);
/*var_dump(json_encode($bookingList['count']));*/
$http->sendJsonResponse($bookingList);
}
}
public function findWithCredentials($email, $password, $ip)
{
//TROP DE CONNEXION FAILLED
$userSession = new UserSession();
$userSession->tryConnection($ip);
//EXCEPTION INSIDE
$Database = new Database();
$user = $Database->queryOne('SELECT Id, Password FROM Customer WHERE Email = ?', [$email]);
if (!$user) {
$userSession->createLoginByIp($ip);
throw new DomainException('Email inconnu');
} else {
$verificationPassword = $this->verifyPassword($password, $user['Password']);
if ($verificationPassword) {
$this->updateLastLoginTimestamp($user['Id']);
$userSession->createLoginByIp($ip, $user['Id'], 1);
return $user['Id'];
} else {
$userSession->createLoginByIp($ip);
throw new DomainException('Mauvaise Mots de Passe');
}
}
}
public function getPriceById($mealId)
{
//var_dump($mealId);
$query = new Database();
return $query->queryOne('SELECT SalePrice FROM Meal WHERE Id = ?', [$mealId]);
}
public static function getOne($id)
{
$db = new Database();
return $db->queryOne("SELECT * FROM articles WHERE id={$id}", 'News');
}
public function getOneBooking($Customer_Id)
{
$query = new Database();
return $query->queryOne('SELECT * FROM Booking WHERE Customer_Id = ? ', [$Customer_Id]);
}
public function findOrder($order_Id)
{
$database = new Database();
return $database->queryOne('SELECT Customer_Id, TotalAmount, TaxeAmount FROM `Order` WHERE Id
= ?', [$order_Id]);
}
public function find($mealId)
{
//var_dump($mealId);
$query = new Database();
return $query->queryOne('SELECT * FROM Meal WHERE Id = ?', [$mealId]);
}
