0) { foreach ($checkgroup as $key => $element) if ($element==-1) $query0 .= $key . " as '" . $alias[$key] . "' " . ", "; //-------------------------------------------------- $query0 .= "SUM(fRunTime)/3600 as '" . $alias["SUM(fRunTime)/3600"] . "', "; //-------------------------------------------------- $query0 .= " SUM(fNumEvents) as '" . $alias["SUM(fNumEvents)"] . "', "; $query0 .= " Min(fZenithDistanceMin) as '" . $alias["Min(fZenithDistanceMin)"] . "', "; $query0 .= " Max(fZenithDistanceMax) as '" . $alias["Max(fZenithDistanceMax)"] . "', "; $query0 .= " COUNT(*) as 'Sequence' "; } else { if ($statusgroups>0) { foreach ($checkstatusgroup as $key => $element) if ($element==-1) $query0 .= " (if(IsNull(" . $key . "), if(isnull(fStartTime), 'not done', if(isnull(fFailedTime),if(isnull(" . $needs[$key] . "),'not done',if(date_sub(Now(),interval 12 hour) < fStartTime,'running','crashed')),if(isnull(" . $needs[$key] . "),'not done','failed'))) ,if(" . $key . "='1970-01-01 00:00:00','dont do','done'))) as '" . $alias[$key] . "', "; // $query0 .= " (if(IsNull(" . $key . "), 'not done' ,if(" . $key . "='1970-01-01 00:00:00','dont do','done'))) as '" . $alias[$key] . "', "; $query0 .= " count(*) as 'Sequence'"; } else { if (!empty($_GET["fSendTxt"])) $query0 .= " " . $fromtable . ".fSequenceFirst as '" . $alias["fSequenceFirst"] . "' "; else { $query0 .= " CONCAT('', Sequences.fSequenceFirst, '') "; $query0 .= " as " . $alias["fSequenceFirst"]; if (!empty($_GET["fLinks"])) { $query0 .= ", CONCAT('cl'"; $query0 .= ", ' c'"; $query0 .= ", ' sl'"; $query0 .= ", ' s'"; $query0 .= ", ' ', 'f ') "; $query0 .= " as 'Links'"; } } foreach ($_GET as $key => $element) if ($_GET[$key]=="On") if ($key!="fLinks" && $key!="fTest") if (empty($checkwhere[$key]) || $checkwhere[$key]==0) $query0 .= ", " . $key . " as '" . $alias[$key] . "' "; } } $query0 .= " FROM " . $fromtable; $query0 .= " LEFT JOIN SequenceProcessStatus ON Sequences.fSequenceFirst=SequenceProcessStatus.fSequenceFirst "; $query0 .= " LEFT JOIN Calibration ON Sequences.fSequenceFirst=Calibration.fSequenceFirst "; $query0 .= " LEFT JOIN Star ON Sequences.fSequenceFirst=Star.fSequenceFirst "; // foreach ($_GET as $key => $element) // if (($_GET[$key]=="On" || $groups>0) && !empty($joins[$key])) // $query0 .= $joins[$key]; foreach ($_GET as $key => $element) if (($_GET[$key]=="On" || $groups>0))// && !empty(GetJoin($fromtable,$key))) $query0 .= GetJoin($fromtable,$key); if ($_GET["fTest"]!="On") { if ($_GET["fSource"]!="On") $query0 .= " LEFT JOIN Source ON Sequences.fSourceKEY=Source.fSourceKEY "; $query0 .= " WHERE fTest='no'"; } foreach ($checkwhere as $key => $element) { if (empty($element) || $element<=0) continue; if (strpos($query0, " WHERE ")==FALSE) $query0 .= " WHERE "; else if ($element!=-1) if (strrpos($query0, " AND ")!=strlen($query0)-5) $query0 .= " AND "; if ($element!=-1) $query0 .= GetCheck($fromtable, $key) . "=" . $element; } if (strpos($query0, " WHERE ")==FALSE) $query0 .= " WHERE "; else $query0 .= " AND "; $query0 .= StatusQuery("fSequenceFileWritten", $needs); $query0 .= StatusQuery("fAllFilesAvail", $needs); $query0 .= StatusQuery("fCallisto", $needs); $query0 .= StatusQuery("fFillCallisto", $needs); $query0 .= StatusQuery("fStar", $needs); $query0 .= StatusQuery("fFillStar", $needs); if (!empty($_GET["fRunMin"]) && !empty($_GET["fRunMax"])) $query0 .= "Sequences.fSequenceFirst BETWEEN " . $_GET["fRunMin"] . " AND " . $_GET["fRunMax"] . " "; else $query0 = substr($query0, 0, -4); /* if (!empty($_GET["fDate"])) $query0 .= " AND fRunStart REGEXP \"^" . $_GET["fDate"] . "\" "; */ if (!empty($_GET["fSourceN"])) $query0 .= " AND fSourceName REGEXP \"^" . $_GET["fSourceN"] . "\" "; if (!empty($_GET["fStartDate"])) { if (strpos(strrev($query0), " DNA ")!=0 || !strpos(strrev($query0), " DNA ")) $query0 .= " AND "; $startdate=substr($_GET["fStartDate"], 0, 10); if ($startdate=="0000-00-00") $query0 .=" fRunStart >= '" . $startdate . " 00:00:00' "; else $query0 .= " fRunStart >= ADDDATE('" . $startdate . " 13:00:00', INTERVAL -1 DAY) "; } if (!empty($_GET["fStopDate"])) { if (strpos(strrev($query0), " DNA ")!=0 || !strpos(strrev($query0), " DNA ")) $query0 .= " AND "; $stopdate=substr($_GET["fStopDate"], 0, 10); $query0 .= " fRunStart < '" . $stopdate . " 13:00:00' "; } if ($groups>0) { $query0 .= " GROUP BY "; $num = $groups; foreach ($checkgroup as $key => $element) if ($element==-1) { $query0 .= GetCheck($fromtable,$key); if ($num-->1) $query0 .= ", "; } } if ($statusgroups>0) { $query0 .= " GROUP BY "; $num = $statusgroups; foreach ($checkstatusgroup as $key => $element) if ($element==-1) { $query0 .= $alias[$key]; if ($num-->1) $query0 .= ", "; } } if (!empty($_GET["fSortBy"])) { $val=substr($_GET["fSortBy"], 0, -1); $query0 .= " ORDER BY " . GetTable($fromtable,$val) . " "; if (substr($_GET["fSortBy"], -1)=="-") $query0 .= "DESC"; } if (empty($_GET["fSortBy"]) && $groups==0 && $statusgroups==0) $query0 .= "ORDER BY Sequences.fSequenceFirst ASC "; if (empty($_GET["fNumStart"])) $_GET["fNumStart"]=0; if (empty($_GET["fSendTxt"])) $query0 .= " LIMIT " . $_GET["fNumStart"] . ", " . $_GET["fNumResults"]; return $query0; } function InitGet($_GET) { // Find out whether it is the first call to the php script $first = empty($_GET["fRunMin"]) && empty($_GET["fRunMax"]); if (empty($_GET["fNumResults"])) $_GET["fNumResults"]="20"; if (empty($_GET["fLastUpdate"])) $_GET["fLastUpdate"]="Off"; if (empty($_GET["fNumEvents"])) $_GET["fNumEvents"]=$first?"On":""; if (empty($_GET["fRunStart"])) $_GET["fRunStart"]=$first?"On":""; if (empty($_GET["fRunTime/60"])) $_GET["fRunTime/60"]=$first?"On":""; if (empty($_GET["fSequenceLast"])) $_GET["fSequenceLast"]=$first?"On":""; if (empty($_GET["fLinks"])) $_GET["fLinks"]=$first?"On":""; if (empty($_GET["fTest"])) $_GET["fTest"]=$first?"On":""; if (empty($_GET["fAzimuthMin"])) $_GET["fAzimuthMin"]="Off"; if (empty($_GET["fAzimuthMax"])) $_GET["fAzimuthMax"]="Off"; if (empty($_GET["fZenithDistanceMin"])) $_GET["fZenithDistanceMin"]=$first?"On":""; if (empty($_GET["fZenithDistanceMax"])) $_GET["fZenithDistanceMax"]="Off"; if (empty($_GET["fManuallyChangedName"])) $_GET["fManuallyChangedName"]="Off"; if (empty($_GET["fSourceName"])) $_GET["fSourceName"]=$first?"On":""; if (empty($_GET["fProjectName"])) $_GET["fProjectName"]="Off"; if (empty($_GET["fL1TriggerTableName"])) $_GET["fL1TriggerTableName"]="Off"; if (empty($_GET["fL2TriggerTableName"])) $_GET["fL2TriggerTableName"]="Off"; if (empty($_GET["fHvSettingsName"])) $_GET["fHvSettingsName"]="Off"; if (empty($_GET["fDiscriminatorThresholdTableName"])) $_GET["fDiscriminatorThresholdTableName"]="Off"; if (empty($_GET["fTriggerDelayTableName"])) $_GET["fTriggerDelayTableName"]="Off"; if (empty($_GET["fLightConditionsName"])) $_GET["fLightConditionsName"]="Off"; if (empty($_GET["fTestFlagName"])) $_GET["fTestFlagName"]="Off"; if (empty($_GET["fSequenceFileWritten"])) $_GET["fSequenceFileWritten"]="Off"; if (empty($_GET["fSequenceFileWrittenStatus"])) $_GET["fSequenceFileWrittenStatus"]="0"; if (empty($_GET["fAllFilesAvail"])) $_GET["fAllFilesAvail"]="Off"; if (empty($_GET["fAllFilesAvailStatus"])) $_GET["fAllFilesAvailStatus"]="0"; if (empty($_GET["fCallisto"])) $_GET["fCallisto"]="Off"; if (empty($_GET["fCallistoStatus"])) $_GET["fCallistoStatus"]="0"; if (empty($_GET["fFillCallisto"])) $_GET["fFillCallisto"]="Off"; if (empty($_GET["fFillCallistoStatus"])) $_GET["fFillCallistoStatus"]="0"; if (empty($_GET["fStar"])) $_GET["fStar"]=$first?"On":""; if (empty($_GET["fStarStatus"])) $_GET["fStarStatus"]="0"; if (empty($_GET["fFillStar"])) $_GET["fFillStar"]="Off"; if (empty($_GET["fFillStarStatus"])) $_GET["fFillStarStatus"]="0"; if (empty($_GET["fUnreliableInner"])) $_GET["fUnreliableInner"]="Off"; if (empty($_GET["fUnsuitableOuter"])) $_GET["fUnsuitableOuter"]="Off"; if (empty($_GET["fUnreliableOuter"])) $_GET["fUnreliableOuter"]="Off"; if (empty($_GET["fUnsuitableInner"])) $_GET["fUnsuitableInner"]="Off"; if (empty($_GET["fIsolatedInner"])) $_GET["fIsolatedInner"]="Off"; if (empty($_GET["fIsolatedOuter"])) $_GET["fIsolatedOuter"]="Off"; if (empty($_GET["fMeanPedRmsInner"])) $_GET["fMeanPedRmsInner"]="Off"; if (empty($_GET["fMeanPedRmsOuter"])) $_GET["fMeanPedRmsOuter"]="Off"; if (empty($_GET["fIsolatedMaxCluster"])) $_GET["fIsolatedMaxCluster"]="Off"; if (empty($_GET["fArrTimeMeanInner"])) $_GET["fArrTimeMeanInner"]="Off"; if (empty($_GET["fArrTimeMeanOuter"])) $_GET["fArrTimeMeanOuter"]="Off"; if (empty($_GET["fArrTimeRmsInner"])) $_GET["fArrTimeRmsInner"]="Off"; if (empty($_GET["fArrTimeRmsOuter"])) $_GET["fArrTimeRmsOuter"]="Off"; if (empty($_GET["fMeanSignalInner"])) $_GET["fMeanSignalInner"]=$first?"Off":""; if (empty($_GET["fMeanSignalOuter"])) $_GET["fMeanSignalOuter"]=$first?"Off":""; if (empty($_GET["fPulsePosMean"])) $_GET["fPulsePosMean"]=$first?"Off":""; if (empty($_GET["fConvFactorInner"])) $_GET["fConvFactorInner"]=$first?"On":""; if (empty($_GET["fConvFactorOuter"])) $_GET["fConvFactorOuter"]=$first?"On":""; if (empty($_GET["fMeanNumberIslands"])) $_GET["fMeanNumberIslands"]="Off"; if (empty($_GET["fPSF"])) $_GET["fPSF"]=$first?"On":""; if (empty($_GET["fRatio"])) $_GET["fRatio"]=$first?"On":""; if (empty($_GET["fMuonNumber"])) $_GET["fMuonNumber"]=$first?"On":""; if (empty($_GET["fEffOnTime"])) $_GET["fEffOnTime"]="Off"; if (empty($_GET["fMuonRate"])) $_GET["fMuonRate"]="Off"; if (empty($_GET["fInhomogeneity"])) $_GET["fInhomogeneity"]="Off"; if (empty($_GET["fDataRate"])) $_GET["fDataRate"]="Off"; if (empty($_GET["fMaxHumidity"])) $_GET["fMaxHumidity"]="Off"; if (empty($_GET["fStartTime"])) $_GET["fStartTime"]="Off"; if (empty($_GET["fFailedTime"])) $_GET["fFailedTime"]="Off"; if (empty($_GET["fReturnCode"])) $_GET["fReturnCode"]="Off"; if (empty($_GET["fFailedCode"])) $_GET["fFailedCode"]="Off"; if (empty($_GET["fFailedCodeAdd"])) $_GET["fFailedCodeAdd"]="Off"; } function PrintForm($_GET, $host, $user, $pw, $db) { printf("
\n"); printf("
\n"); printf(" \n"); printf(" \n"); CheckBox("fRunStart", "Start time"); CheckBox("fAzimuthMin", "Azimuth min"); CheckBox("fAzimuthMax", "Azimuth max"); CheckBox("fZenithDistanceMin", "Zenith distance min"); CheckBox("fZenithDistanceMax", "Zenith distance max"); printf(" \n"); CheckBox("fNumEvents", "Num of events"); CheckBox("fRunTime/60", "Duration"); CheckBox("fSequenceLast", "Last run"); CheckBox("fLinks", "Links"); CheckBox("fTest", "incl. TestSources"); printf("
\n"); printf("

\n"); printf("
\n"); PrintStatusMenu("fSequenceFileWritten", "Sequfile"); printf(" \n"); PrintStatusMenu("fAllFilesAvail", "Files avail"); printf(" \n"); PrintStatusMenu("fCallisto", "Callisto"); printf(" \n"); PrintStatusMenu("fStar", "Star"); printf(" \n"); PrintStatusMenu("fFillCallisto", "Fillcallisto"); printf(" \n"); PrintStatusMenu("fFillStar", "Fillstar"); printf("
\n"); printf("

\n"); printf(" \n"); printf(" \n"); CheckBox("fStartTime", "StartTime"); CheckBox("fFailedTime", "FailedTime"); CheckBox("fReturnCode", "ErrCode"); CheckBox("fFailedCode", "RetCode"); CheckBox("fFailedCodeAdd", "CodeAdd"); printf(" \n"); printf("
\n"); printf("

\n"); printf(" \n"); printf(" \n"); CheckBox("fUnsuitableInner", "Unsuitable inner"); CheckBox("fUnsuitableOuter", "Unsuitable outer"); CheckBox("fUnreliableInner", "Unreliable inner"); CheckBox("fUnreliableOuter", "Unreliable outer"); printf(" \n"); CheckBox("fIsolatedInner", "Isolated inner"); CheckBox("fIsolatedOuter", "Isolated outer"); CheckBox("fIsolatedMaxCluster", "IsolatedMaxCluster"); printf(" \n"); CheckBox("fArrTimeMeanInner", "ArrTimeMean inner "); CheckBox("fArrTimeMeanOuter", "ArrTimeMean outer "); CheckBox("fArrTimeRmsInner", "ArrTimeRms inner "); CheckBox("fArrTimeRmsOuter", "ArrTimeRms outer "); printf(" \n"); CheckBox("fMeanPedRmsInner", "MeanPedRms inner"); CheckBox("fMeanPedRmsOuter", "MeanPedRms outer"); CheckBox("fMeanSignalInner", "MeanSignal inner"); CheckBox("fMeanSignalOuter", "MeanSignal outer"); printf(" \n"); CheckBox("fConvFactorInner", "Conv inner "); CheckBox("fConvFactorOuter", "Conv outer "); CheckBox("fPulsePosMean", "Mean PulsePos"); printf("
\n"); printf("

\n"); printf(" \n"); printf(" \n"); CheckBox("fMeanNumberIslands", "MeanNumIslands"); CheckBox("fPSF", "PSF"); CheckBox("fRatio", "Ratio"); printf(" \n"); CheckBox("fMuonRate", "MuonRate"); CheckBox("fMuonNumber", "MuonNumber"); CheckBox("fEffOnTime", "EffOnTime"); printf(" \n"); CheckBox("fMaxHumidity", "MaxHumidity"); CheckBox("fDataRate", "CleanedEvtRate"); CheckBox("fInhomogeneity", "Inhomogeneity"); printf(" \n"); printf("
\n"); printf("

\n"); // pull down boxes printf(" \n"); printf(" \n"); printf("
\n"); PrintPullDown($host, $user, $pw, $db, "Source", "fSourceName", "fSourceKEY", "Source Name"); printf(" \n"); PrintPullDown($host, $user, $pw, $db, "L1TriggerTable", "fL1TriggerTableName", "fL1TriggerTableKEY", "L1Trigger Table"); printf(" \n"); PrintPullDown($host, $user, $pw, $db, "L2TriggerTable", "fL2TriggerTableName", "fL2TriggerTableKEY", "L2Trigger Table"); printf(" \n"); PrintPullDown($host, $user, $pw, $db, "TriggerDelayTable", "fTriggerDelayTableName", "fTriggerDelayTableKEY", "Trigger Delay Table"); printf("
\n"); PrintPullDown($host, $user, $pw, $db, "LightConditions", "fLightConditionsName", "fLightConditionsKEY", "Light Conditions"); printf(" \n"); PrintPullDown($host, $user, $pw, $db, "Project", "fProjectName", "fProjectKEY", "Project Name"); printf(" \n"); PrintPullDown($host, $user, $pw, $db, "HvSettings", "fHvSettingsName", "fHvSettingsKEY", "HV Settings"); printf(" \n"); PrintPullDown($host, $user, $pw, $db, "DiscriminatorThresholdTable", "fDiscriminatorThresholdTableName", "fDiscriminatorThresholdTableKEY", "DT Table"); printf("
\n"); PrintPullDown($host, $user, $pw, $db, "ManuallyChanged", "fManuallyChangedName", "fManuallyChangedKEY", "Manually changed"); printf(" \n"); PrintPullDown($host, $user, $pw, $db, "TestFlag", "fTestFlagName", "fTestFlagKEY", "Test Flag"); printf("
\n"); printf("

\n"); if (empty($_GET["fStartDate"])) $timemin = GetMin("fRunStart", "Sequences", $host, $user, $pw, $db); else $timemin = $_GET["fStartDate"]; if (empty($_GET["fStopDate"])) $timemax = GetMax("fRunStart", "Sequences", $host, $user, $pw, $db); else $timemax = $_GET["fStopDate"]; printf("Night (yyyy-mm-dd) from \n", $timemin); printf("to     \n", $timemax); if (empty($_GET["fRunMin"])) $min = GetMin("fSequenceFirst", "Sequences", $host, $user, $pw, $db); else $min = $_GET["fRunMin"]; if (empty($_GET["fRunMax"])) $max = GetMax("fSequenceFirst", "Sequences", $host, $user, $pw, $db); else $max = $_GET["fRunMax"]; /* printf("Date (yyyy-mm-dd)    \n"); */ printf("Sequences from \n", $min); printf("to    \n", $max); printf("

\n"); printf("Source (regexp)    \n"); printf(" Results:\n"); printf(" \n"); printf("    \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"]); if (strchr($_SERVER["REQUEST_URI"], '?')!=FALSE) printf("   \n", $_SERVER["REQUEST_URI"]); printf("

\n"); printf("
\n"); printf("\n"); printf("\n"); printf("\n"); printf("\n"); } function PrintPage($html, $host, $user, $pw, $db, $alias, $rightalign, $checkwhere, $checkgroup, $checkstatusgroup, $needs) { $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, $alias, $checkwhere, $checkgroup, $checkstatusgroup, $needs); $result0 = mysql_query($query0, $db_id); if ($result0) { if ($html=="1" || $html=="2") PrintMagicTable($result0, $alias, $rightalign, "", "", $_GET); 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"); include ("magicdefs.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, $alias, $rightalign, $checkwhere, $checkgroup, $checkstatusgroup, $needs); } 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, $alias, $rightalign, $checkwhere, $checkgroup, $checkstatusgroup, $needs); else PrintPage("2", $host, $user, $pw, $db, $alias, $rightalign, $checkwhere, $checkgroup, $checkstatusgroup, $needs); } echo (file_get_contents("index-footer.html")); } ini_set("display_errors", "Off"); ini_set("mysql.trace_mode", "Off"); } ?>