Index: trunk/MagicSoft/Mars/datacenter/db/ganymed.php =================================================================== --- trunk/MagicSoft/Mars/datacenter/db/ganymed.php (revision 7516) +++ trunk/MagicSoft/Mars/datacenter/db/ganymed.php (revision 7516) @@ -0,0 +1,293 @@ +\n"); + printf("
\n"); + + printf("DataSet#    \n"); + + if (empty($_GET["fRunMin"])) + $min = GetMin("fDataSetNumber", "DataSets", $db); + else + $min = $_GET["fRunMin"]; + + if (empty($_GET["fRunMax"])) + $max = GetMax("fDataSetNumber", "DataSets", $db); + else + $max = $_GET["fRunMax"]; + + printf("DataSets from \n", $min); + printf("to    \n", $max); + + if ($_GET["fAll"]=="On") + $checked = "checked"; + else + $checked = ""; + printf("plots\n", $checked); + + printf("

\n"); + + printf("Source (regexp)    \n"); + + + ini_set("mysql.trace_mode", "Off"); + ini_set("display_errors", "Off"); + + printf("   \n"); + printf("   \n"); + if (strchr($_SERVER["REQUEST_URI"], '?')!=FALSE) + printf("   \n", $_SERVER["REQUEST_URI"]); + 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 PrintSequenceInfo($result0, $db_id, $db) + { + $numres = mysql_num_rows($result0); + + printf("
"); + printf("\n"); + 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("# of DataSets: %d ", $numres); + printf("
"); + + printf(" "); + printf(" \n"); + printf(" ", $datasetno); + printf(" \n"); + printf(" \n"); + + printf(" \n"); + + if (!is_null($fillganymed)) + { + printf(" "); + printf(" \n"); + printf(" \n"); + printf(" \n"); + printf(" \n"); + printf(" \n"); + printf(" \n"); + printf(" \n"); + printf(" "); + printf(" \n", $excess); + printf(" \n", $bg); + printf(" \n", $signal); + printf(" \n", $signif); + printf(" \n", $scale); + printf(" \n", $effontime); + } + + + if ($_GET["fAll"]=="On" && !is_null($ganymed)) + { + printf("
DataSet#: %s
%s - Wobble %s ", $comment, $wobble); + if (!is_null($ganymed)) + printf(", ganymed done "); + printf("
results
excess eventsbackground eventssignal eventssignificancescale factoreffective ontime
%s%s%s%s%s%s
\n"); + + printf(" "); + printf(" \n"); + printf(" "); + printf(" \n"); + printf("
plots
\n"); + $num=sprintf("%08d",$datasetno); + printf(" files", + substr($num,0,5), $num); + printf("
"); + + } + printf("
"); + printf("

\n"); + + printf("
\n"); + printf("\n"); + } + + function PrintPage($html, $db) + { + $db_id = mysql_connect("hercules.astro.uni-wuerzburg.de", "MAGIC", "d99swMT!"); + 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") + PrintSequenceInfo($result0, $db_id, $db); + 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", $db); + } + else + { + echo (file_get_contents("index-header.html")); + + $environment = sizeof($_GET); + + InitGet($_GET); + if (empty($_GET["fPrintTable"])) + PrintForm($_GET, $db); + + if ($environment==0) + printf("No query submitted yet.
"); + else + { + if (empty($_GET["fPrintTable"])) + PrintPage("1", $db); + else + PrintPage("2", $db); + } + + echo (file_get_contents("index-footer.html")); + } + + ini_set("display_errors", "Off"); + ini_set("mysql.trace_mode", "Off"); +} +?>