diff options
| author | Erich Eckner <git@eckner.net> | 2018-03-09 20:32:43 +0100 |
|---|---|---|
| committer | Erich Eckner <git@eckner.net> | 2018-03-09 20:32:43 +0100 |
| commit | 08f69a1eb1f6a71751cda4df67213fa086eeae53 (patch) | |
| tree | b201014bf0987c30f0ef205a4a20bec3aeadcd81 /web-scripts/build-list.php | |
| parent | fe3ae1c23523c824fb3fe1e7904c24b949b7ce6f (diff) | |
| download | builder-08f69a1eb1f6a71751cda4df67213fa086eeae53.tar.xz | |
web-scripts/build-list.php: "?show=next" new
Diffstat (limited to 'web-scripts/build-list.php')
| -rw-r--r-- | web-scripts/build-list.php | 42 |
1 files changed, 26 insertions, 16 deletions
diff --git a/web-scripts/build-list.php b/web-scripts/build-list.php index 1bb985d..98217de 100644 --- a/web-scripts/build-list.php +++ b/web-scripts/build-list.php @@ -1,27 +1,32 @@ <html> <head> <?php - if (isset($_GET["broken"])) - print "<title>List of broken package builds</title>\n"; - else - print "<title>List of scheduled package builds</title>\n"; -?> -<link rel="stylesheet" type="text/css" href="/static/style.css"> -</head> -<body> -<a href="/build-logs/">build logs</a><br> -<?php + +if (isset($_GET["show"])) + $to_show=$_GET["show"]; +else + $to_show="all"; + +if ($to_show == "all") + $match = ""; +elseif ($to_show == "broken") + $match = " AND (`build_assignments`.`is_broken` OR `build_assignments`.`is_blocked` IS NOT NULL)"; +elseif ($to_show == "next") + $match = ""; +else + die(); + +print "<title>List of " . $to_show . " package builds</title>\n"; +print "<link rel=\"stylesheet\" type=\"text/css\" href=\"/static/style.css\">\n"; +print "</head>\n"; +print "<body>\n"; +print "<a href=\"/build-logs/\">build logs</a><br>\n"; $mysql = new mysqli("localhost", "webserver", "empty", "buildmaster"); if ($mysql->connect_error) { die("Connection failed: " . $mysql->connect_error); } -if (isset($_GET["broken"])) - $match_broken = "AND (`build_assignments`.`is_broken` OR `build_assignments`.`is_blocked` IS NOT NULL)"; -else - $match_broken = ""; - $result = $mysql -> query( "SELECT DISTINCT " . "`build_assignments`.`id`," . @@ -55,7 +60,7 @@ $result = $mysql -> query( "JOIN `git_repositories` ON `upstream_repositories`.`git_repository`=`git_repositories`.`id` " . "JOIN `binary_packages` ON `binary_packages`.`build_assignment` = `build_assignments`.`id` " . "JOIN `repositories` ON `binary_packages`.`repository` = `repositories`.`id` " . - "WHERE `repositories`.`name`=\"build-list\"" . $match_broken + "WHERE `repositories`.`name`=\"build-list\"" . $match ); if ($result -> num_rows > 0) { @@ -63,6 +68,11 @@ if ($result -> num_rows > 0) { while($row = $result->fetch_assoc()) { + if (($to_show == "next") && + ($row["loops"]==0) && + ($row["dependencies_pending"]==1)) + continue; + $fail_result = $mysql -> query( "SELECT " . "`fail_reasons`.`name`, " . |