From c9d4c87b21f1050a780f5296961d24bd17c9cdc8 Mon Sep 17 00:00:00 2001
From: Debulois <quentin@debulois.fr>
Date: Thu, 24 Mar 2022 19:30:30 +0100
Subject: Grosse mise à jour, principalement changement du système des missions
 et de "mes missions".
MIME-Version: 1.0
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: 8bit

---
 Views/Includes/incl_table_myMission.php | 147 +++++++++++++++++++++++++++++---
 1 file changed, 133 insertions(+), 14 deletions(-)

(limited to 'Views/Includes/incl_table_myMission.php')

diff --git a/Views/Includes/incl_table_myMission.php b/Views/Includes/incl_table_myMission.php
index b4c7e04..de071b1 100644
--- a/Views/Includes/incl_table_myMission.php
+++ b/Views/Includes/incl_table_myMission.php
@@ -7,33 +7,152 @@ require_once(dirname(__FILE__)."/".$_SESSION["lang"]."/text.php");
 // Import des en-tête des tables.
 require_once(dirname(__FILE__)."/".$_SESSION["lang"]."/table.php");
 // Import des metodes de la base de donnée pour les recherches.
+require_once(dirname(__FILE__)."/../../Database/meth_dbsearch.php");
 require_once(dirname(__FILE__)."/../../Database/meth_dbmission.php");
 // Instanciation de la bdd avec les méthodes de recherche.
+$dbsearch = new DbSearch;
 $dbmission = new DbMission;
+
+// TODO: commenter
 // Recherches des missions avec l'id de l'utilisateur actuellement connecté.
-$result = $dbmission->get_mission_by_id($_SESSION["userId"]);
+switch ($_SESSION["userStatus"]) {
+    case 1:
+        $result = $dbmission->get_mission_by_pro_id($_SESSION["userId"]);
+        for ($i = 0; $i < count($result); $i++) {
+            $result[$i]["jobCategoryId"] = $dbsearch->get_job_category_by_id($result[$i]["jobCategoryId"]);
+        }
+        break;
+    case 2:
+        $result = $dbmission->get_mission_by_client_id($_SESSION["userId"]);
+        for ($i = 0; $i < count($result); $i++) {
+            $result[$i]["jobCategoryId"] = $dbsearch->get_job_category_by_id($result[$i]["jobCategoryId"]);
+        }
+        break;
+    default:
+        break;
+}
+
+$missionStatus = [
+    "pending"   => [],
+    "ongoing"   => [],
+    "completed" => []
+];
+
+for ($i = 0; $i < count($result); $i++) {
+    if (!$result[$i]["acceptedByPro"]
+    ) {
+        array_push($missionStatus["pending"], $result[$i]);
+    } elseif (!$result[$i]["validatedByPro"] 
+              || !$result[$i]["validatedByClient"]
+    ) {
+        array_push($missionStatus["ongoing"], $result[$i]);
+    } else {
+        array_push($missionStatus["completed"], $result[$i]);
+    }
+}
+
 echo('        <!-- Separateur -->
         <div class="separator"></div>
         <!-- Mes missions -->
         <div id="myMission">
-            <h2>'.$text[basename(__FILE__, ".php")]["h2"].'</h2>
-            <table>
+            <div id="missionButtons">
+                <button onclick="show(\'pendingTable\')"><h2>'.$text[basename(__FILE__, ".php")]["pendingMission"].'</h2></button>
+                <button onclick="show(\'ongoingTable\')"><h2>'.$text[basename(__FILE__, ".php")]["ongoingMission"].'</h2></button>
+                <button onclick="show(\'completedTable\')"><h2>'.$text[basename(__FILE__, ".php")]["completedMission"].'</h2></button>
+            </div>'.PHP_EOL);
+
+// tableau 3 pending
+echo('            <table id="pendingTable">
+                <!-- En-tête -->
+                <tr>'.PHP_EOL);
+foreach($header["pendingMissions"] as $columnHeader) {
+    echo("                    <th>".$columnHeader."</th>".PHP_EOL);
+}
+echo("                </tr>".PHP_EOL);
+foreach ($missionStatus["pending"] as $rows) {
+    echo('                <!-- Missions -->
+                <tr>
+                    <td><pre>'.$rows["date"].'</pre></td>
+                    <td><pre>'.$rows["lastname"].'</pre></td>
+                    <td><pre>'.$rows["jobCategoryId"][0]["jobCategoryName".ucwords($_SESSION["lang"])].'</pre></td>
+                    <td><pre>'.$rows["subject"].'</pre></td>');
+    if ($_SESSION["userId"] == $rows["proId"]) {
+        echo('                <td class="noBorder" >
+                            <form action="/Wrapper/wrapper.php" method="post">
+                            <input type="hidden" name="acceptedMissionId" value="'.$rows["missionId"].'">
+                            <input type="submit" value="'.$text[basename(__FILE__, ".php")]["accept"].'">
+                            </form>
+                        </td>');
+    }
+    echo('            </tr>'.PHP_EOL);
+}
+echo('            </table>');
+
+// tableau 4 ongoing
+echo('            <table id="ongoingTable">
                 <!-- En-tête -->
                 <tr>'.PHP_EOL);
-foreach($header[3] as $header) {
-    echo("                    <th>".$header."</th>".PHP_EOL);
+foreach($header["ongoingMissions"] as $columnHeader) {
+    echo("                    <th>".$columnHeader."</th>".PHP_EOL);
 }
 echo("                </tr>".PHP_EOL);
-foreach ($result as $rows) {
-    echo("                <!-- Missions -->
-                <tr>".PHP_EOL);
-    foreach ($rows as $value) {
-        echo("                    <td><pre>".$value."</pre></td>".PHP_EOL);
+foreach ($missionStatus["ongoing"] as $rows) {
+    echo('                <!-- Missions -->
+                <tr>
+                    <td><pre>'.$rows["acceptedByPro"].'</pre></td>
+                    <td><pre>'.$rows["lastname"].'</pre></td>
+                    <td><pre>'.$rows["jobCategoryId"][0]["jobCategoryName".ucwords($_SESSION["lang"])].'</pre></td>
+                    <td><pre>'.$rows["subject"].'</pre></td>
+                    <td><pre>'.$rows["validatedByClient"].'</pre></td>
+                    <td><pre>'.$rows["validatedByPro"].'</pre></td>');
+    if (!$rows["validatedByClient"] && $_SESSION["userStatus"] == 2 
+        || (!$rows["validatedByPro"] && $_SESSION["userStatus"] == 1)
+    ) {
+        echo('                <td class="noBorder" >
+                            <form action="/Wrapper/wrapper.php" method="post">
+                            <input type="hidden" name="validatedMissionId" value="'.$rows["missionId"].'">
+                            <input type="submit" value="'.$text[basename(__FILE__, ".php")]["validate"].'">
+                            </form>
+                        </td>');
     }
-    echo("                </tr>".PHP_EOL);
+    echo('            </tr>'.PHP_EOL);
+}
+echo('            </table>');
+
+// tableau 5 completed
+echo('          <table id="completedTable">
+    <!-- En-tête -->
+    <tr>'.PHP_EOL);
+foreach($header["completedMissions"] as $columnHeader) {
+    echo("                    <th>".$columnHeader."</th>".PHP_EOL);
+}
+echo("                </tr>".PHP_EOL);
+foreach ($missionStatus["completed"] as $rows) {
+    echo('                <!-- Missions -->
+                <tr>
+                    <td><pre>'.$rows["date"].'</pre></td>
+                    <td><pre>'.$rows["acceptedByPro"].'</pre></td>
+                    <td><pre>'.$rows["validatedByClient"].'</pre></td>
+                    <td><pre>'.$rows["validatedByPro"].'</pre></td>
+                    <td><pre>'.$rows["lastname"].'</pre></td>
+                    <td><pre>'.$rows["jobCategoryId"][0]["jobCategoryName".ucwords($_SESSION["lang"])].'</pre></td>
+                    <td><pre>'.$rows["subject"].'</pre></td>');
+                    if ($rows["review"]) {
+                        echo('<td><pre>'.$rows["review"].'</pre></td>');
+                    } else {
+                        echo('<td><pre>N/A</pre></td>');
+                    }
+                    if ($rows["note"]) {
+                        echo('<td><pre>'.$rows["note"].'</pre></td>');
+                    } else {
+                        echo('<td><pre>N/A</pre></td>');
+                    }
+                echo('</tr>'.PHP_EOL);
 }
 echo('            </table>
-            <!-- Espace vide si le tableau est petit -->
-            <div class="spacer"></div>
-        </div>'.PHP_EOL);
+<!-- Espace vide si le tableau est petit -->
+<div class="spacer"></div>');
+
+// fin
+echo('        </div>'.PHP_EOL);
 ?>
\ No newline at end of file
-- 
cgit v1.2.3