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('
'.PHP_EOL); // tableau 3 pending echo(' '.PHP_EOL); foreach($header["pendingMissions"] as $columnHeader) { echo(" ".PHP_EOL); } echo(" ".PHP_EOL); foreach ($missionStatus["pending"] as $rows) { echo(' '); if ($_SESSION["userId"] == $rows["proId"]) { echo(' '); } echo(' '.PHP_EOL); } echo('
".$columnHeader."
'.$rows["date"].'
 
'.$rows["lastname"].'
 
'.$rows["jobCategoryId"][0]["jobCategoryName".ucwords($_SESSION["lang"])].'
 
'.$rows["subject"].'
'); // tableau 4 ongoing echo(' '.PHP_EOL); foreach($header["ongoingMissions"] as $columnHeader) { echo(" ".PHP_EOL); } echo(" ".PHP_EOL); foreach ($missionStatus["ongoing"] as $rows) { echo(' '); if (!$rows["validatedByClient"] && $_SESSION["userStatus"] == 2 || (!$rows["validatedByPro"] && $_SESSION["userStatus"] == 1) ) { echo(' '); } echo(' '.PHP_EOL); } echo('
".$columnHeader."
'.$rows["acceptedByPro"].'
 
'.$rows["lastname"].'
 
'.$rows["jobCategoryId"][0]["jobCategoryName".ucwords($_SESSION["lang"])].'
 
'.$rows["subject"].'
 
'.$rows["validatedByClient"].'
 
'.$rows["validatedByPro"].'
'); // tableau 5 completed echo(' '.PHP_EOL); foreach($header["completedMissions"] as $columnHeader) { echo(" ".PHP_EOL); } echo(" ".PHP_EOL); foreach ($missionStatus["completed"] as $rows) { echo(' '); if ($rows["review"]) { echo(''); } else { echo(''); } if ($rows["note"]) { echo(''); } else { echo(''); } echo(''.PHP_EOL); } echo('
".$columnHeader."
'.$rows["date"].'
 
'.$rows["acceptedByPro"].'
 
'.$rows["validatedByClient"].'
 
'.$rows["validatedByPro"].'
 
'.$rows["lastname"].'
 
'.$rows["jobCategoryId"][0]["jobCategoryName".ucwords($_SESSION["lang"])].'
 
'.$rows["subject"].'
'.$rows["review"].'
N/A
'.$rows["note"].'
N/A
'); // fin echo('
'.PHP_EOL); ?>