/content/jobstatus.php

<?php

	function get_status($num){
		if ( $num == 0 ) {
			return "Not started yet.";
		} else if ( $num == 1 ) {
			return "In progress.";
		} else {
			return "Completed.";
		}
	}

	function get_status2($num, $fail, $error, $total){
		if ( $num == 0 ) {
			return "notstarted notdone";
		} else if ( $num == 1 ) {
			return "progress notdone";
		} else if ( $num == 2 && $fail == -1 ) {
			return "timeout";
		} else if ( $num == 2 && ($error > 0 || $total == 0) ) {
			return "error";
		} else {
			return $fail > 0 ? "fail" : "pass";
		}
	}

	$job_id = preg_replace("/[^0-9]/", "", $_REQUEST["job_id"]);

	$result = mysql_queryf("SELECT jobs.name, jobs.status, users.name FROM jobs, users WHERE jobs.id=%u AND users.id=jobs.user_id;", $job_id);

	if ( $row = mysql_fetch_array($result) ) {
		$job_name = $row[0];
		$job_status = get_status(intval($row[1]));
		$owner = ($row[2] == $_SESSION["username"]);
	}

?>

<h3><?php echo $job_name; ?></h3>

<?php if ( $owner && $_SESSION["auth"] == "yes" ) { ?>
<form action="" method="POST">
	<input type="hidden" name="state" value="wipejob"/>
	<input type="hidden" name="job_id" value="<?php echo $job_id; ?>"/>
	<input type="submit" name="type" value="delete"/>
	<input type="submit" name="type" value="reset"/>
</form>
<?php } ?>

<table class="results"><tbody>
<?php

	$result = mysql_queryf("SELECT runs.id as run_id, runs.url as run_url, runs.name as run_name, useragents.engine as browser, useragents.name as browsername, useragents.id as useragent_id, run_useragent.status as status FROM run_useragent, runs, useragents WHERE runs.job_id=%u AND run_useragent.run_id=runs.id AND run_useragent.useragent_id=useragents.id ORDER BY run_id, browsername;", $job_id);

	$last = "";
	$output = "";
	$browsers = array();
	$addBrowser = true;

	while ( $row = mysql_fetch_assoc($result) ) {
		if ( $row["run_id"] != $last ) {
			if ( $last ) {
				$addBrowser = false;
			}
			$useragents = array();

			$runResult = mysql_queryf("SELECT run_client.client_id as client_id, run_client.status as status, run_client.fail as fail, run_client.error as error, run_client.total as total, clients.useragent_id as useragent_id FROM run_client, clients WHERE run_client.run_id=%u AND run_client.client_id=clients.id ORDER BY useragent_id;", $row["run_id"]);

			while ( $ua_row = mysql_fetch_assoc($runResult) ) {
				if ( !$useragents[ $ua_row['useragent_id'] ] ) {
					$useragents[ $ua_row['useragent_id'] ] = array();
				}

				array_push( $useragents[ $ua_row['useragent_id'] ], $ua_row );
			}

			$output .= '<tr><th><a href="' . $row["run_url"] . '">' . $row["run_name"] . "</a></th>\n";
		}

		if ( $addBrowser ) {
			array_push( $browsers, array(
				"name" => $row["browsername"],
				"engine" => $row["browser"],
				"id" => $row["useragent_id"]
			) );
		}

		#echo "<li>" . $row["browser"] . " (" . get_status(intval($row["status"])) . ")<ul>";

		$last_browser = -1;

		if ( $useragents[ $row["useragent_id"] ] ) {
			foreach ( $useragents[ $row["useragent_id"] ] as $ua ) {
				$status = get_status2(intval($ua["status"]), intval($ua["fail"]), intval($ua["error"]), intval($ua["total"]));
				if ( $last_browser != $ua["useragent_id"] ) {
					$output .= "<td class='$status " . $row["browser"] . "'><a href='" . swarmpath ( '/' ) . "?state=runresults&run_id=" . $row["run_id"] . "&client_id=" . $ua["client_id"] . "'>" .
						($ua["status"] == 2 ?
							($ua["total"] < 0 ?
								"Err" :
								($ua["error"] > 0 ?
									$ua["error"] :
									($ua["fail"] > 0 ?
										$ua["fail"] :
										$ua["total"])))
							: "") . "</a></td>\n";
				}
				$last_browser = $ua["useragent_id"];
			}
		} else {
			$output .= "<td class='notstarted notdone'>&nbsp;</td>";
		}

		#echo "</ul></li>";

		$last = $row["run_id"];
	}

	if ( $last ) {
		$header = "<tr><th></th>\n";
		$last_browser = array();
		foreach ( $browsers as $browser ) {
			if ( $last_browser["id"] != $browser["id"] ) {
				$header .= '<th><div class="browser">' .
					'<img src="' . swarmpath( 'images/' ) . $browser["engine"] .
					'.sm.png" class="browser-icon ' . $browser["engine"] .
					'" alt="' . $browser["name"] .
					'" title="' . $browser["name"] .
					'"/><span class="browser-name">' .
					preg_replace('/\w+ /', "", $browser["name"]) . ', ' .
					'</span></div></th>';
			}
			$last_browser = $browser;
		}
		$header .= "</tr>\n";
		$output = $header . $output;
		$output .= "</tr>\n";
	}

	echo "$output</tr>\n</tbody>\n</table>";