\n"; else echo "\n"; ?>
Grid statistics
Note
Next stats are dynamically extracted and represent data still in the server
(i.e. removed jobs are out of these statistics)
Job/worker/day
Back to workers stats
Job/day/worker
"; echo "
4500)) $couleur = "red"; ?> Jobs/workers
COMPLETED (RUNNING)
"; echo " "; echo $rowsWorker["name"]." : "; echo "".$rowsWorker["os"]."; ".$rowsWorker["cputype"]."; ".$rowsWorker["cpuspeed"]."Mhz
"; echo "Ping : ".$rowsWorker["lastAlive"].""; echo "\n"; $queryWorker = "select apps.name as app,tasks.laststartdate as sdate,tasks.removaldate as cdate,tasks.status as status from hosts,tasks,apps"; $queryWorker = $queryWorker." where tasks.host=hosts.uid and hosts.uid='".$WORKER."'"; $queryWorker = $queryWorker." and tasks.app=apps.uid order by tasks.laststartdate"; $resultWorker = dbQuery ($connection, $queryWorker); $i = 0; while ($rowsWorker= mysql_fetch_array($resultWorker)) { echo " Application Start date Completion date Status \n"; echo " \n"; } echo "".$rowsWorker["app"]." \n"; echo "".$rowsWorker["sdate"]." \n"; if (isset ($rowsWorker["cdate"])) echo "".$rowsWorker["cdate"]." \n"; else echo "n/a \n"; echo "".$rowsWorker["status"]." \n"; echo "\n"; return; } // end of if (isset($WORKER)) /* $queryHost = "select *,now()-lastAlive as delai from hosts having delai<=4500"; $queryHost = "select *,now()-max(lastAlive) as delai from hosts group by name,ipaddr"; */ $queryHost = "select *,unix_timestamp(now())-unix_timestamp(max(lastAlive)) as delai from hosts group by name,ipaddr"; $queryHost = $queryHost." order by name"; $resultHost = dbQuery ($connection, $queryHost); $i = 0; while ($rowsHost= mysql_fetch_array($resultHost)) { echo " Back to workers stats
\n"; $queryRunning = "select count(*) from hosts,tasks"; /* $queryRunning = $queryRunning." where tasks.status='RUNNING' and tasks.host=hosts.uid and hosts.name='".$rowsHost["name"]."'"; */ $queryRunning = $queryRunning." where tasks.status='RUNNING' and tasks.host=hosts.uid and hosts.name='".$rowsHost["name"]."'"; $resultRunning = dbQuery ($connection, $queryRunning); $rowsRunning = mysql_fetch_array($resultRunning); /* $queryCompleted = "select count(*) from hosts,tasks"; $queryCompleted = $queryCompleted." where tasks.status='COMPLETED' and tasks.host=hosts.uid and hosts.name='".$rowsHost["name"]."'"; $resultCompleted = dbQuery ($connection, $queryCompleted); $rowsCompleted = mysql_fetch_array($resultCompleted); */ /* if(($rowsCompleted["count(*)"] < 1) && ($rowsRunning["count(*)"] < 1) && ($rowsHost["delai"] > 4500)) { continue; } */ $contentClass = "CONTENT".(($i % 2) + 1); echo " \n"; $i++; } ?>\n \n"; echo "\n"; /* echo $rowsCompleted["count(*)"]." (".($rowsRunning["count(*)"] == "" ? 0 : $rowsRunning["count(*)"]).") "; */ echo ($rowsHost["nbJobs"] == "" ? 0 : $rowsHost["nbJobs"])." (".($rowsRunning["count(*)"] == "" ? 0 : $rowsRunning["count(*)"]).") "; echo "
\n \n"; echo "\n"; $couleur[$rowsHost["name"]] = "#16e82a"; if ($rowsHost["available"] == "false") $couleur[$rowsHost["name"]] = "#b48622"; if ($rowsHost["active"] == "false") $couleur[$rowsHost["name"]] = "gray"; if (($rowsHost["delai"] == "") || ($rowsHost["delai"] > 4500)) $couleur[$rowsHost["name"]] = "red"; echo "".$rowsHost["name"]."
\n \n"; echo "\n"; echo "details
\n \n"; echo "\n"; echo "\n"; echo "\n"; echo "".$rowsHost["os"]." ; ".$rowsHost["cpunb"]." CPUs ; ".$rowsHost["cpuspeed"]."Mhz \n"; if (substr($rowsHost["ipaddr"], 0, 7) == "134.158") { if(substr($rowsHost["ipaddr"], 0, 10) == "134.158.92") echo "IPN"; if(substr($rowsHost["ipaddr"], 0, 11) == "134.158.121") echo "LPC - Clermont Ferrand"; if((substr($rowsHost["ipaddr"], 8, 2) == "88") || (substr($rowsHost["ipaddr"], 8, 2) == "89") || (substr($rowsHost["ipaddr"], 8, 2) == "90") || (substr($rowsHost["ipaddr"], 8, 2) == "91")) echo "LAL"; } else if (substr($rowsHost["ipaddr"], 0, 9) == "129.175.7") echo "LRI"; else if (substr($rowsHost["ipaddr"], 0, 6) == "82.226") echo "proxad.net"; else if (substr($rowsHost["ipaddr"], 0, 5) == "81.66") echo "noos.fr"; else if (substr($rowsHost["ipaddr"], 0, 7) == "192.168") echo "private network"; echo "
Job/worker
Job/worker/day
\n"; if ($date != $rows["left(tasks.startdate,10)"]) { $date = $rows["left(tasks.startdate,10)"]; echo " Jobs/day/worker
"; echo " \n"; } $contentClass = "CONTENT".(($i % 2) + 1); echo "\n"; echo " \n"; echo "".$date."
\n"; echo "\n"; echo " \n"; $contentClass = "CONTENT".(($i % 2) + 1); echo "\n"; echo $rows["host"]; echo "
\n"; echo "\n"; echo " \n"; ?>\n"; echo $rows["count(*)"]; echo "
\n"; echo "
Job/worker
Job/day/worker
\n"; if ($worker != $rows["host"]) { $worker = $rows["host"]; echo " Jobs/worker/day
"; echo " \n"; } $contentClass = "CONTENT".(($i % 2) + 1); echo "\n"; echo "\n"; echo " \n"; echo "".$worker." top
\n"; echo "\n"; echo " \n"; $contentClass = "CONTENT".(($i % 2) + 1); echo "\n"; echo $rows["left(tasks.startdate,10)"]; echo "
\n"; echo "\n"; echo " \n"; ?>\n"; echo $rows["count(*)"]; echo "
\n"; echo "
Job/worker
Job/day/worker
Job/worker/day