\n");
+ printf("\n");
+ }
+
+ function PrintPage($html, $host, $user, $pw, $db, $alias, $rightalign, $checkwhere, $checkgroup, $checkstatusgroup, $limitsmean, $limitsmin, $limitsmax, $needs)
+ {
+ $db_id = mysql_pconnect($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, $alias, $checkwhere, $checkgroup, $checkstatusgroup, $needs);
+
+ $result0 = mysql_query($query0, $db_id);
+
+ if ($result0)
+ {
+ if ($html=="1" || $html=="2")
+ {
+ PrintMagicTable($result0, $alias, $rightalign, $limitsmean, $limitsmin, $limitsmax, "yes", $_GET);
+ foreach($_POST as $key => $val)
+ if ($val=="On")
+ {
+ if (ereg("ON$", $key))
+ $sequon.=str_replace("ON", " ", $key);
+ if (ereg("Off$", $key))
+ $sequoff.=str_replace("Off", " ", $key);
+ }
+ printf("
\n");
+ printf("pw: %s
", crypt("IutWDC+B"));
+ printf("\n");
+
+ $on=str_replace(" ", ",", trim($sequon));
+ $off=str_replace(" ", ",", trim($sequoff));
+
+ $values=array("Sum(fRunTime)/60" => $runtime,
+ "Min(fRunTime)/60" => $runtimemin,
+ "Max(fUnsuitableInner)" => $unsuitablemax,
+ "Max(fUnreliableInner)" => $unreliablemax,
+ "Max(fIsolatedInner)" => $isolatedmax,
+ "Max(fIsolatedMaxCluster)" => $imcmax,
+ "Max(fArrTimeMeanInner)" => $arrtimemax,
+ "Min(fArrTimeMeanInner)" => $arrtimemin,
+ "Max(fArrTimeRmsInner)" => $arrtimermsmax,
+ "Avg(fMeanPedRmsInner)" => $pedrmsmean,
+ "Std(fMeanPedRmsInner)" => $pedrmsrms,
+ "Min(fMeanPedRmsInner)" => $pedrmsmin,
+ "Max(fMeanPedRmsInner)" => $pedrmsmax,
+ "Min(fPulsePosMean)" => $pulseposmin,
+ "Max(fPulsePosMean)" => $pulseposmax,
+ "Max(fPulsePosRms)" => $pulseposrmsmax,
+ "Max(fMaxHumidity)" => $hummax,
+ "Max(fInhomogeneity)" => $inhommax,
+ "Avg(fInhomogeneity)" => $inhommean,
+ "Std(fInhomogeneity)" => $inhomrms,
+ "Min(fMeanNumberIslands)" => $numislmin,
+ "Max(fMeanNumberIslands)" => $numislmax,
+ "Min(fDataRate)" => $clratemin,
+ "Max(fDataRate)" => $clratemax,
+ "Min(fMuonRate)" => $muonratemin,
+ "Max(fMuonRate)" => $muonratemax,
+ "Min(fMuonNumber)" => $muonnumbermin,
+ "Avg(fPSF)" => $psfmean,
+ "Std(fPSF)" => $psfrms,
+ "Min(fPSF)" => $psfmin,
+ "Max(fPSF)" => $psfmax,
+ "Min(fEffOnTime/fRunTime)" => $relontimemin,
+ "Max(fEffOnTime/fRunTime)" => $relontimemax,
+ "Min(fBrightnessMed)" => $brightmin,
+ "Max(fBrightnessMed)" => $brightmax,
+ "Min(fNumStarsMed)" => $idstarsmin,
+ "Max(fNumStarsMed)" => $idstarsmax,
+ "Min(fNumStarsCorMed)" => $corstarsmin,
+ "Max(fNumStarsCorMed)" => $corstarsmax,
+ "Min(fZenithDistanceMin)" => $zdmin,
+ "Max(fZenithDistanceMax)" => $zdmax,
+ "Min(fRunStart)" => $starttime,
+ "Max(fRunStop)" => $stoptime,
+ );
+ //get runtimes of dataset
+ function GetSequenceValues($db_id, $sequences, $txt,&$values)
+ {
+ $query="SELECT COUNT(*) ";
+ foreach($values as $name => $varname)
+ $query.=", " . $name;
+ $query.=" FROM Sequences ";
+ $query.=" LEFT JOIN Calibration ON Calibration.fSequenceFirst=Sequences.fSequenceFirst ";
+ $query.=" LEFT JOIN Star ON Star.fSequenceFirst=Sequences.fSequenceFirst ";
+ $query.=" WHERE Sequences.fSequenceFirst IN (" . $sequences . ")";
+ $result = mysql_query($query, $db_id);
+ $row = mysql_fetch_assoc($result);
+ foreach($values as $name => $varname)
+ $values[$name][$txt]=$row[$name];
+ mysql_free_result($result);
+ }
+
+ //get next dataset#
+ $query="SELECT fDataSetNumber+1 FROM DataSets ORDER BY fDataSetNumber LIMIT 0,1";
+ $result = mysql_query($query, $db_id);
+ $row = mysql_fetch_assoc($result);
+ $dataset=$row["fDataSetNumber+1"];
+ if (empty($dataset))
+ $dataset=1;
+ mysql_free_result($result);
+
+ //get sourcenames
+ function GetSources($db_id, $sequences)
+ {
+ $query="SELECT fSourceName FROM Source LEFT JOIN Sequences ON Sequences.fSourceKEY=Source.fSourceKEY ";
+ $query.="WHERE fSequenceFirst IN (" . $sequences . ") GROUP BY fSourceName";
+ $result = mysql_query($query, $db_id);
+ while ($row = mysql_fetch_assoc($result))
+ $sources.=" " . $row["fSourceName"];
+ mysql_free_result($result);
+ return $sources;
+ }
+ $sourceson=GetSources($db_id, $on);
+ $sourcesoff=GetSources($db_id, $off);
+
+ //get sourcename for dataset
+ $son=str_replace(" ", "','", trim($sourceson));
+ $query="SELECT fRealSourceKEY, Count(*) FROM Source where fSourcename IN ('" . $son . "') GROUP BY fRealSourceKEY";
+// printf("q: %s
", $query);
+ $result = mysql_query($query, $db_id);
+ $row = mysql_fetch_assoc($result);
+ $numsources=$row["Count(*)"];
+ $numrealkeys=mysql_num_rows($result);
+ $realsourcekey=$row["fRealSourceKEY"];
+ mysql_free_result($result);
+// printf("found %s sources with real sourcekey %s", $numsources, $realsourcekey);
+// printf("found %s keys", $numrealkeys);
+
+
+ $runtimelimit=5;
+ $unsuitablemaxlimit=15;
+ $isolatedlimit=0;
+ $imclimit=0;
+ $pedrmsrms=0.09;
+ $scalelimit=1.3;
+
+
+ $numerr=0;
+ if (!empty($on))
+ {
+ $color=array("INFO" => "#000000",
+ "WARN" => "#FF9900",
+ "ERROR" => "#FF0000");
+ printf("\n");
+ $vals=array("on", "off");
+ foreach($vals as $num => $val)
+ {
+ if (empty(${$val}))
+ continue;
+ GetSequenceValues($db_id, ${$val}, $val, $values);
+
+ if ($values["Min(fRunTime)/60"][$val]<$runtimelimit)
+ printf("- %s: one of your %s-sequences is shorter than %s min (%s min)
",
+ $color["WARN"], "WARN", $val, $runtimelimit, $values["Min(fRunTime)/60"][$val]);
+ if ($values["Max(fUnsuitableInner)"][$val]>$unsuitablemaxlimit)
+ printf("- %s: one of your %s-sequences has more than %s unsuitable inner pixel (%s)
",
+ $color["WARN"], "WARN", $val, $unsuitablemaxlimit, $values["Max(fUnsuitableInner)"][$val]);
+ if ($values["Max(fIsolatedInner)"][$val]>$isolatedlimit)
+ printf("- %s: one of your %s-sequences has more than %s isolated inner pixel (%s)
",
+ $color["WARN"], "WARN", $val, $isolatedlimit, $values["Max(fIsolatedInner)"][$val]);
+ if ($values["Max(fIsolatedMaxCluster)"][$val]>$imclimit)
+ printf("- %s: one of your %s-sequences has more than %s isolated max cluster (%s)
",
+ $color["WARN"], "WARN", $val, $imclimit, $values["Max(fIsolatedMaxCluster)"][$val]);
+ }
+ if (!empty($on) && $values["Max(fMeanPedRmsInner)"]["on"]>$values["Avg(fMeanPedRmsInner)"]["on"]+$pedrmsrms)
+ printf("- %s: one of your on-sequences has a PedRms larger than %s (%s)
",
+ $color["WARN"], "WARN", $values["Avg(fMeanPedRmsInner)"]["on"]+$pedrmsrms, $values["Max(fMeanPedRmsInner)"]["on"]);
+ if (!empty($off) && $values["Max(fMeanPedRmsInner)"]["off"]>$values["Avg(fMeanPedRmsInner)"]["on"]+$pedrmsrms)
+ printf("- %s: one of your off-sequences has a PedRms larger than %s (%s)
",
+ $color["WARN"], "WARN", $values["Avg(fMeanPedRmsInner)"]["on"]+$pedrmsrms, $values["Max(fMeanPedRmsInner)"]["off"]);
+ if (!empty($off) && $values["Min(fMeanPedRmsInner)"]["off"]<$values["Avg(fMeanPedRmsInner)"]["on"]-$pedrmsrms)
+ printf("- %s: one of your off-sequences has a PedRms smaller than %s (%s)
",
+ $color["WARN"], "WARN", $values["Avg(fMeanPedRmsInner)"]["on"]-$pedrmsrms, $values["Min(fMeanPedRmsInner)"]["off"]);
+ $scale=$values["Sum(fRunTime)/60"]["on"]/$values["Sum(fRunTime)/60"]["off"];
+ if ($scale > $scalelimit)
+ printf("- %s: Your scale factor is larger than %s (%0.2f). Try to find more offdata!",
+ $color["WARN"], "WARN", $scalelimit, $scale);
+ /*
+ if (str_word_count($sourceson) > 1)
+ printf("
- %s: You have selected more than one (%s) on source",
+ $color["WARN"], "WARN", str_word_count($sourceson));
+ */
+ if ($numrealkeys>1)
+ {
+ printf("
- %s: You have selected more than one (%s) on source",
+ $color["ERROR"], "ERROR", $numrealkeays);
+ $numerr=$numerr+1;
+ }
+ if (empty($realsourcekey))
+ {
+ printf("
- %s: The source you selected doesn't have real sourceskeys yet.",
+ $color["ERROR"], "ERROR");
+ $numerr=$numerr+1;
+ }
+ if (empty($_POST["fObservationModeKEY"]))
+ {
+ printf("
- %s: You have to choose an observation mode.",
+ $color["ERROR"], "ERROR");
+ $numerr=$numerr+1;
+ }
+ if (empty($_POST["name"]))
+ {
+ printf("
- %s: You have to choose a name.",
+ $color["ERROR"], "ERROR");
+ $numerr=$numerr+1;
+ }
+ if (empty($_POST["comment"]))
+ {
+ printf("
- %s: You have to comment your dataset.",
+ $color["ERROR"], "ERROR");
+ $numerr=$numerr+1;
+ }
+ // printf("
");
+ printf(" \n");
+
+ printf(" ");
+ printf("SequencesOn: %s
", $sequon);
+ printf("SequencesOff: %s
", $sequoff);
+ $insquery[0]="INSERT DataSets SET fDataSetNumber=" . $dataset;
+ $insquery[0].=", fComment='" . $_POST["comment"] . "', fObservationModeKEY=" . $_POST["fObservationModeKEY"];
+ $insquery[0].=", fDataSetName='" . $_POST["name"] . "', fSourceKEY= " . $realsourcekey;
+ $insquery[0].=", fRunStart='" . $values["Min(fRunStart)"]["on"];
+ $insquery[0].="', fRunStop='" . $values["Max(fRunStop)"]["on"];
+ $insquery[0].="', fZenithDistanceMin=" . $values["Min(fZenithDistanceMin)"]["on"];
+ $insquery[0].=", fZenithDistanceMax=" . $values["Max(fZenithDistanceMax)"]["on"];
+ $insquery[0].=", fRunTime=" . $values["Sum(fRunTime)/60"]["on"];
+ $insquery[1]="INSERT DataSetProcessStatus SET fDataSetNumber=" . $dataset . ", fDataSetInserted=Now()";
+ $i=2;
+ foreach(explode(" ", trim($sequon)) as $key => $sequ)
+ {
+ $insquery[$i]="INSERT DataSetSequenceMapping SET fDataSetNumber=" . $dataset;
+ $insquery[$i].=", fSequenceFirst=" . $sequ . ", fOnOff=1";
+ $i=$i+1;
+ }
+ if (!empty($off))
+ {
+ foreach(explode(" ", trim($sequoff)) as $key => $sequ)
+ {
+ $insquery[$i]="INSERT DataSetSequenceMapping SET fDataSetNumber=" . $dataset;
+ $insquery[$i].=", fSequenceFirst=" . $sequ . ", fOnOff=2";
+ $i=$i+1;
+ }
+ }
+ foreach($insquery as $num => $q)
+ {
+ if (!empty($_POST["insert"]) && $numerr==0)
+ {
+ $insresult=mysql_query($q);
+ printf("inserted query ");
+ printf("
result:
");
+ printf("errorno: %s
", mysql_errno());
+ printf("errormsg: %s
", mysql_error());
+ printf("info: %s
", mysql_info());
+ printf("affected rows: %s
", mysql_affected_rows());
+ mysql_free_result($insresult);
+ }
+ printf(" %s: %s
", $num, $q);
+ }
+ printf(" ");
+ if (empty($_POST["name"]) && !empty($_GET["name"]))
+ $_POST["name"]=$_GET["name"];
+ if (empty($_POST["comment"]) && !empty($_GET["comment"]))
+ $_POST["comment"]=$_GET["comment"];
+ if (empty($_POST["fObservationModeKEY"]) && !empty($_GET["obsmode"]))
+ $_POST["fObservationModeKEY"]=$_GET["obsmode"];
+ printf("Name: \n", $_POST["name"]);
+ printf("Comment: \n", $_POST["comment"]);
+
+ $query = "SELECT fObservationModeKEY, fObservationModeName FROM ObservationMode ORDER BY fObservationModeName";
+ $result = mysql_query($query);
+ if (!$result)
+ printf("-N/A-");
+
+ $numrows = mysql_num_rows($result);
+
+ printf("ObservationMode \n");
+ mysql_free_result($result);
+
+ printf("Remark: only datasets without errors can be inserted. ");
+ if ($numerr!=0)
+ printf("Your dataset has %s error(s). ", $numerr);
+ printf(" insert\n");
+
+ printf(" | Dataset | ");
+ printf("| proposed DataSet#: | %s | ", $dataset);
+ printf("| SequencesOn: | %s | ", $sequon);
+ if (!empty($sequoff))
+ printf("| SequencesOff: | %s | ", $sequoff);
+ printf("| Scale: | %0.2f | ", $scale);
+ printf("| SourcenamesOn[%s]: | %s | ", str_word_count($sourceson), $sourceson);
+ printf("| SourcenamesOff[%s]: | %s | ", str_word_count($sourcesoff), $sourcesoff);
+ printf("
\n");
+
+ printf(" \n");
+ printf("| Value | On | ");
+ if (!empty($off))
+ printf("Off | \n");
+ foreach($values as $name => $varname)
+ {
+ printf("| %s | \n", $name);
+ foreach($vals as $num => $val)
+ if (!empty(${$val}))
+ printf("%s | \n", $varname[$val]);
+ printf(" \n");
+ }
+ printf(" \n");
+ }
+
+ printf(" \n");
+ printf("| -- | \n");
+ foreach($values as $name => $varname)
+ printf("%s | \n", $name);
+ $vals=array("on", "off");
+ foreach($vals as $num => $val)
+ {
+ GetSequenceValues($db_id, ${$val}, $val, $values);
+ printf(" \n");
+ printf("| On | \n");
+ foreach($values as $name => $varname)
+ printf("%s | \n", $varname[$val]);
+ }
+ printf("
\n");
+ */
+
+ printf("\n");
+ printf(" | \n");
+ printf("
\n");
+
+ printf("