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); }