\n");
printf("\n");
printf("\n");
printf("\n");
printf("\n");
printf("\n");
printf("| \n");
}
function GetStatus($step)
{
if (is_null($step))
return "not done";
else
{
if (strpos($step, "1970-01-01 00:00:00")==FALSE)
return "done";
else
return "not to be done";
}
return "there is an error -> tell Dani";
}
/*
function GetSequences($datasetfile)
// function QueryRuns($type, $sequ, $db_id, $db)
{
printf(" | ");
printf(" to be done");
printf(" | \n");
printf(" to be done ");
printf(" | \n");
}
function QueryMissingFiles($sequ, $db_id, $db)
{
$query2 = "SELECT fSequenceFirst FROM SequencesSequenceProcessStatus ";
$query2 .= " WHERE fSequenceFirst=" . $sequ . " AND IsNull(fStar)";
mysql_select_db($db);
$files = mysql_query($query2, $db_id);
$numfiles = mysql_num_rows($files);
printf(" ");
for ($i=0 ; $i<$numfiles ; $i++)
{
$file=mysql_result($files, $i, 0);
if ($i!=0)
printf(", ");
printf(" %s ", $file);
}
printf(" | \n");
}
*/
function PrintDataSetInfo($result0)
{
$numres = mysql_num_rows($result0);
printf("");
printf("\n");
printf("| ");
printf("# of DataSets: %d ", $numres);
printf(" |
");
for ($i=0 ; $i<$numres ; $i++)
{
$datasetno=mysql_result($result0, $i, 0);
$wobble=mysql_result($result0, $i, 1);
$comment=mysql_result($result0, $i, 2);
$source=mysql_result($result0, $i, 3);
$inserted=mysql_result($result0, $i, 4);
$filesavail=mysql_result($result0, $i, 5);
$ganymed=mysql_result($result0, $i, 6);
$fillganymed=mysql_result($result0, $i, 7);
$excess=mysql_result($result0, $i, 8);
$bg=mysql_result($result0, $i, 9);
$signal=mysql_result($result0, $i, 10);
$signif=mysql_result($result0, $i, 11);
$scale=mysql_result($result0, $i, 12);
$effontime=mysql_result($result0, $i, 13);
printf("");
printf(" ");
printf(" \n");
printf(" | DataSet#: %s - %s | ", $datasetno, $source);
printf(" \n");
printf(" | %s ", $comment);
printf(" | \n");
printf(" | Wobble: %s", $wobble);
if (!is_null($ganymed))
printf(", ganymed done ");
printf(" | ");
if (!is_null($fillganymed))
{
printf(" | \n");
printf(" | results - ");
$num=sprintf("%08d",$datasetno);
printf(" plots",
substr($num,0,5), $num);
printf(" |
|---|
\n");
printf(" | excess events | \n");
printf(" background events | \n");
printf(" signal events | \n");
printf(" significance | \n");
printf(" scale factor | \n");
printf(" effective ontime | \n");
printf(" ");
printf(" | %s | \n", $excess);
printf(" %s | \n", $bg);
printf(" %s | \n", $signal);
printf(" %s | \n", $signif);
printf(" %s | \n", $scale);
printf(" %s | \n", $effontime);
}
if ($_GET["fAll"]=="On" && !is_null($ganymed))
{
printf(" | \n");
printf(" plots (to be added) | ");
}
printf(" ");
printf(" |
|
");
}
printf("
\n");
printf("\n");
printf("
\n");
}
function PrintPage($html, $host, $user, $pw, $db)
{
$db_id = mysql_connect($host, $user, $pw);
if ($db_id==FALSE)
{
printf("mysql_connect returned the following error: %s\n", mysql_error());
die("");
}
mysql_select_db($db);
$query0 = CreateQuery($_GET);
$result0 = mysql_query($query0, $db_id);
if ($result0)
{
if ($html=="1" || $html=="2")
PrintDataSetInfo($result0);
else
PrintText($result0);
mysql_free_result($result0);
}
mysql_close($db_id);
if ($html=="1")
printf("submitted query:
%s
", htmlspecialchars($query0));
}
include ("include.php");
include ("db.php");
ini_set("display_errors", "On");
ini_set("mysql.trace_mode", "On");
if (!empty($_GET["fSendTxt"]))
{
header("Content-type: application/octet");
header("Content-Disposition: attachment; filename=query-result.txt");
PrintPage("0", $host, $user, $pw, $db);
}
else
{
echo (file_get_contents("index-header.html"));
$environment = sizeof($_GET);
InitGet($_GET);
if (empty($_GET["fPrintTable"]))
PrintForm($_GET, $host, $user, $pw, $db);
if ($environment==0)
printf("No query submitted yet.
");
else
{
if (empty($_GET["fPrintTable"]))
PrintPage("1", $host, $user, $pw, $db);
else
PrintPage("2", $host, $user, $pw, $db);
}
echo (file_get_contents("index-footer.html"));
}
ini_set("display_errors", "Off");
ini_set("mysql.trace_mode", "Off");
}
?>
|