public function DenyProject($_projectID)
{
$projectTitle = parent::DBQuery("SELECT title FROM projects\n WHERE ID = " . $_projectID);
$businessID = parent::DBQuery("SELECT business.ID FROM business\n INNER JOIN projects ON business.ID = projects.businessID\n WHERE projects.ID = " . $_projectID);
$result = parent::DBQuery("SELECT email,userID FROM business WHERE ID = " . $businessID['ID']);
$user = parent::DBQuery("SELECT name FROM users WHERE ID=" . $result['userID']);
parent::DBExecute("DELETE FROM ratings WHERE projectID = " . $_projectID);
parent::DBExecute("DELETE FROM projects WHERE ID = " . $_projectID);
$msg = "Votre projet, " . $projectTitle['title'] . ", de l'entreprise," . $user["name"] . ",a été refusé.";
//Envoi du courriel de confirmation.
$mail = mail($result['email'], $user["name"] . " projet non validé", $msg);
}
public function TokenLogin($_token)
{
//Valider la connexion.
$cmd = "SELECT ID, name, rank FROM users WHERE token = '" . $_token . "'";
$result = parent::DBQuery($cmd);
return $result;
}
public function FindRateByID($_internID, $_projectID)
{
return parent::DBQuery("SELECT * FROM ratings WHERE internID=" . $_internID . " AND projectID=" . $_projectID);
}
