diff options
Diffstat (limited to 'Database/meth_dbmission.php')
| -rw-r--r-- | Database/meth_dbmission.php | 86 |
1 files changed, 43 insertions, 43 deletions
diff --git a/Database/meth_dbmission.php b/Database/meth_dbmission.php index f44edfc..bd23506 100644 --- a/Database/meth_dbmission.php +++ b/Database/meth_dbmission.php @@ -11,7 +11,7 @@ // https://www.freecodecamp.org/news/sql-joins-tutorial/ // Import de dbmain -require_once(dirname( __FILE__ )."./dbmain.php"); +require_once(dirname( __FILE__ )."/dbmain.php"); // Extension de cette classe avec dbmain class DbMission extends DbMain { @@ -23,9 +23,9 @@ class DbMission extends DbMain { final public function register_mission($subject, $clientId, $proId, $jobId) { // Préparation de la requète pour enregistrement de la mission $reqAddMission = " - INSERT INTO ".$this->tableMission." - (date, subject, clientId, proId, jobCategoryId) - VALUES + INSERT INTO ".$this->tableMission." + (date, subject, clientId, proId, jobCategoryId) + VALUES (?, ?, ?, ?, ?)"; // Exécution de la requète $this->exec_cmd($reqAddMission, array(date("Y-m-d H:i:s"), $subject, $clientId, $proId, $jobId)); @@ -36,11 +36,11 @@ class DbMission extends DbMain { final public function accept_mission_by_missionid($missionId) { // Préparation de la requète pour enregistrement de la mission $reqAddMission = " - UPDATE - ".$this->tableMission." + UPDATE + ".$this->tableMission." SET - acceptedByPro = ? - WHERE + acceptedByPro = ? + WHERE missionId = ?"; // Exécution de la requète $this->exec_cmd($reqAddMission, array(date("Y-m-d H:i:s"), $missionId)); @@ -50,11 +50,11 @@ class DbMission extends DbMain { final public function validate_mission_pro_by_missionid($missionId) { // Préparation de la requète pour enregistrement de la mission $reqAddMission = " - UPDATE - ".$this->tableMission." + UPDATE + ".$this->tableMission." SET - validatedByPro = ? - WHERE + validatedByPro = ? + WHERE missionId = ?"; // Exécution de la requète $this->exec_cmd($reqAddMission, array(date("Y-m-d H:i:s"), $missionId)); @@ -64,11 +64,11 @@ class DbMission extends DbMain { final public function validate_mission_client_by_missionid($missionId) { // Préparation de la requète pour enregistrement de la mission $reqAddMission = " - UPDATE - ".$this->tableMission." + UPDATE + ".$this->tableMission." SET - validatedByClient = ? - WHERE + validatedByClient = ? + WHERE missionId = ?"; // Exécution de la requète $this->exec_cmd($reqAddMission, array(date("Y-m-d H:i:s"), $missionId)); @@ -78,11 +78,11 @@ class DbMission extends DbMain { final public function review_mission($missionId, $review, $note) { // Préparation de la requète pour enregistrement de la mission $reqAddMission = " - UPDATE - ".$this->tableMission." + UPDATE + ".$this->tableMission." SET review = ?, note = ? - WHERE + WHERE missionId = ?"; // Exécution de la requète $this->exec_cmd($reqAddMission, array($review, $note, $missionId)); @@ -95,17 +95,17 @@ class DbMission extends DbMain { // Récupérations des missions d'un pro par son id final public function get_mission_by_proid($proId) { $reqGetMissionsProId = " - SELECT + SELECT missionId, date, subject, note, review, - acceptedByPro, validatedByClient, - validatedByPro, jobCategoryId, proId, lastname - FROM + acceptedByPro, validatedByClient, + validatedByPro, jobCategoryId, proId, lastname + FROM ".$this->tableMission." - LEFT JOIN - ".$this->tableUserInfo." - ON + LEFT JOIN + ".$this->tableUserInfo." + ON ".$this->tableMission.".proId = ".$this->tableUserInfo.".userId - WHERE + WHERE proId = ?"; $result = $this->exec_cmd($reqGetMissionsProId, array($proId))->fetchAll(PDO::FETCH_ASSOC); return $result; @@ -114,17 +114,17 @@ class DbMission extends DbMain { // Récupérations des missions d'un client par son id final public function get_mission_by_clientid($clientId) { $reqGetMissionsClientId = " - SELECT + SELECT missionId, date, subject, note, review, - acceptedByPro, validatedByClient, - validatedByPro, jobCategoryId, proId, lastname - FROM + acceptedByPro, validatedByClient, + validatedByPro, jobCategoryId, proId, lastname + FROM ".$this->tableMission." - LEFT JOIN - ".$this->tableUserInfo." - ON + LEFT JOIN + ".$this->tableUserInfo." + ON ".$this->tableMission.".proId = ".$this->tableUserInfo.".userId - WHERE + WHERE clientId = ?"; $result = $this->exec_cmd($reqGetMissionsClientId, array($clientId))->fetchAll(PDO::FETCH_ASSOC); return $result; @@ -133,9 +133,9 @@ class DbMission extends DbMain { // Récupérations des missions d'un client par son id final public function get_all_missions() { $reqGetAllMission = " - SELECT - * - FROM + SELECT + * + FROM ".$this->tableMission; $result = $this->exec_cmd($reqGetAllMission, array())->fetchAll(PDO::FETCH_NUM); return $result; @@ -144,13 +144,13 @@ class DbMission extends DbMain { // Compte le nombre de mission d'un consultant par son nom final public function count_pro_missions_by_proid($proId) { $reqCountMission = " - SELECT COUNT(*) FROM + SELECT COUNT(*) FROM ".$this->tableMission." - INNER JOIN - ".$this->tableUserInfo." - ON + INNER JOIN + ".$this->tableUserInfo." + ON ".$this->tableMission.".proId = ".$this->tableUserInfo.".userId - WHERE + WHERE proId = ?"; $result = $this->exec_cmd($reqCountMission, array($proId))->fetchAll(PDO::FETCH_NUM); return $result; |