Index: /trunk/Mars/datacenter/db/fact_runinfo.php =================================================================== --- /trunk/Mars/datacenter/db/fact_runinfo.php (revision 12665) +++ /trunk/Mars/datacenter/db/fact_runinfo.php (revision 12665) @@ -0,0 +1,357 @@ +0) + { + foreach ($checkgroup as $key => $element) + if ($element==-1) + $query0 .= $key . " as '" . $alias[$key] . "' " . ", "; + //don't put a '#' at the beginning of the alias, else SortBy won't work anymore + $query0 .= " COUNT(*) as 'NumRuns', "; + $query0 .= " Round(Sum(TimeDiff(fRunStop,fRunStart))/60./60.,1) as 'Time [h]' "; + } + else + { + $query0 .= " Concat(fRunNumber,'_', LPAD(fFileNumber, 3, 0)) as 'Run' "; + + if (!empty($_GET["fComments"])) + { + $query0 .= ", if (Count(fComment)>0, Concat('', Count(fComment), ''), ' ') "; + $query0 .= " as 'Comments'"; + } + + foreach ($_GET as $key => $element) + if ($_GET[$key]=="On") + if ($key!="fComments") + if (empty($checkwhere[$key]) || $checkwhere[$key]==0) + $query0 .= ", " . $key . " as '" . $alias[$key] . "' "; + } + + $query0 .= " FROM " . $fromtable; + + foreach ($_GET as $key => $element) + if (($_GET[$key]=="On" || $groups>0))// && !empty($joins[$key])) + $query0 .= GetJoin($fromtable, $key); + $query0 .= " LEFT JOIN RunComments USING (fRunNumber, fFileNumber) "; + + 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)// this if clause doesn't work + $query0 .= " AND "; + + if ($element!=-1) + $query0 .= GetCheck($fromtable, $key) . "=" . $element; + } + + if (strpos($query0, " WHERE ")==FALSE) + $query0 .= " WHERE "; + else + $query0 .= " AND "; + + if (!empty($_GET["fStartDate"])) + { + $startdate=substr($_GET["fStartDate"], 0, 10); + if ($startdate=="0000-00-00") + $query0 .=" fRunNumber >= " . $startdate . " "; + else + $query0 .= " fRunNumber >= " . $startdate . " - 1 "; + } + + if (!empty($_GET["fStopDate"])) + { +// if (strpos(strrev($query0), " DNA ")!=0) +// $query0 .= " AND "; + + $stopdate=substr($_GET["fStopDate"], 0, 10); + $query0 .= " AND fRunNumber <= " . $stopdate . " "; + } + + if ($groups>0) + { + $query0 .= " GROUP BY "; + $num = $groups; + foreach ($checkgroup as $key => $element) + if ($element==-1) + { + $query0 .= GetCheck($fromtable, $key); + if ($num-->1) + $query0 .= ", "; + } + } + else + $query0 .= " GROUP BY fRunNumber, fFileNumber "; + + + + if (!empty($_GET["fSortBy"])) + { + $query0 .= " ORDER BY " . substr($_GET["fSortBy"], 0, -1) . " "; + if (substr($_GET["fSortBy"], -1)=="-") + $query0 .= "DESC"; + } + else + if ($groups==0) + $query0 .= " ORDER BY Run DESC"; + + 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["fNumEvents"])) + $_GET["fNumEvents"]=$first?"Off":""; + + if (empty($_GET["fComments"])) + $_GET["fComments"]=$first?"On":""; + + if (empty($_GET["fNumPhysicsTrigger"])) + $_GET["fNumPhysicsTrigger"]=$first?"On":""; + + if (empty($_GET["Round(fNumPhysicsTrigger/Time_to_sec(TimeDiff(fRunStop,fRunStart)),1)"])) + $_GET["Round(fNumPhysicsTrigger/Time_to_sec(TimeDiff(fRunStop,fRunStart)),1)"]=$first?"On":""; + + if (empty($_GET["fNumPedestalTrigger"])) + $_GET["fNumPedestalTrigger"]=$first?"On":""; + + if (empty($_GET["fNumELPTrigger"])) + $_GET["fNumELPTrigger"]=$first?"On":""; + + if (empty($_GET["fNumTimeTrigger"])) + $_GET["fNumTimeTrigger"]=$first?"On":""; + + if (empty($_GET["fNumExt1Trigger"])) + $_GET["fNumExt1Trigger"]=$first?"Off":""; + + if (empty($_GET["fNumExt2Trigger"])) + $_GET["fNumExt2Trigger"]=$first?"Off":""; + + if (empty($_GET["fNumILPTrigger"])) + $_GET["fNumILPTrigger"]=$first?"Off":""; + + if (empty($_GET["fNumOtherTrigger"])) + $_GET["fNumOtherTrigger"]=$first?"Off":""; + + if (empty($_GET["TimeDiff(fRunStop,fRunStart)"])) + $_GET["TimeDiff(fRunStop,fRunStart)"]=$first?"On":""; + + if (empty($_GET["fRunStart"])) + $_GET["fRunStart"]=$first?"On":""; + + if (empty($_GET["fRunStop"])) + $_GET["fRunStop"]=$first?"Off":""; + + if (empty($_GET["fROI"])) + $_GET["fROI"]=$first?"On":""; + + if (empty($_GET["fROITimeMarker"])) + $_GET["fROITimeMarker"]=$first?"On":""; + + if (empty($_GET["fFitsFileErrors"])) + $_GET["fFitsFileErrors"]=$first?"On":""; + + if (empty($_GET["fHasDrsFile"])) + $_GET["fHasDrsFile"]=$first?"Off":""; + + if (empty($_GET["fMd5sumRaw"])) + $_GET["fMd5sumRaw"]=$first?"Off":""; + + if (empty($_GET["fMd5sumRawZip"])) + $_GET["fMd5sumRawZip"]=$first?"Off":""; + + if (empty($_GET["fRunTypeName"])) + $_GET["fRunTypeName"]=$first?"On":""; + + } + + function PrintForm($_GET, $host, $user, $pw, $db) + { + printf("
\n"); + printf("
\n"); + + // pull down boxes + + printf(" \n"); + printf("
\n"); + PrintPullDown($host, $user, $pw, $db, "RunType", "fRunTypeName", "fRunTypeKEY", "RunType"); + printf("
\n"); + printf("

\n"); + + printf(" \n"); + printf(" \n"); + + CheckBox("fComments", "comments"); + CheckBox("fRunStart", "start time"); + CheckBox("fRunStop", "stop time"); + CheckBox("TimeDiff(fRunStop,fRunStart)", "duration"); + CheckBox("fROI", "roi"); + CheckBox("fNumEvents", "#Evts"); + + printf(" \n"); + printf(" \n"); + + CheckBox("Round(fNumPhysicsTrigger/Time_to_sec(TimeDiff(fRunStop,fRunStart)),1)", "phys rate"); + CheckBox("fNumPhysicsTrigger", "#Phys"); + CheckBox("fNumPedestalTrigger", "#Ped"); + CheckBox("fNumELPTrigger", "#ELP"); + CheckBox("fNumTimeTrigger", "#Time"); + + printf(" \n"); + printf(" \n"); + + CheckBox("fNumExt1Trigger", "#Ext1"); + CheckBox("fNumExt2Trigger", "#Ext2"); + CheckBox("fNumILPTrigger", "#ILP"); + CheckBox("fNumOtherTrigger", "#Other"); + + printf(" \n"); + printf(" \n"); + + CheckBox("fROITimeMarker", "roi-tm"); + CheckBox("fFitsFileErrors", "file err"); + CheckBox("fHasDrsFile", "num drs"); + CheckBox("fMd5sumRaw", "md5"); + CheckBox("fMd5sumRawZip", "md5(gz)"); + + printf(" \n"); + printf("
\n"); + printf("

\n"); + + if (empty($_GET["fStartDate"])) + $timemin = GetMin("fRunNumber", "RunInfo", $host, $user, $pw, $db); + else + $timemin = $_GET["fStartDate"]; + + if (empty($_GET["fStopDate"])) + $timemax = GetMax("fRunnumber", "RunInfo", $host, $user, $pw, $db); + else + $timemax = $_GET["fStopDate"]; + + printf("Run (yyyymmdd) from \n", $timemin); + printf("to     \n", $timemax); + + 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"]); + printf("

\n"); + printf("
\n"); + printf("\n"); + printf("\n"); + printf("\n"); + printf("\n"); + } + + function PrintPage($html, $host, $user, $pw, $db, $alias, $rightalign, $checkwhere, $checkgroup, $checkstatusgroup) + { + $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); + mysql_query("SET BIG_TABLES=1"); // necessary for mySQL <= 4 + + + $query0 = CreateQuery($_GET, $alias, $checkwhere, $checkgroup, $checkstatusgroup); + + $result0 = mysql_query($query0, $db_id); + $result1 = mysql_query("SELECT FOUND_ROWS()", $db_id); + + if ($result0) + { + if ($html=="1") + PrintMagicTable($result0, $alias, $rightalign, "", "", "", $result1); + else + PrintText($result0); + + mysql_free_result($result0); + mysql_free_result($result1); + } + mysql_close($db_id); + + if ($html=="1") + PrintSubmittedQuery($query0, $db, "old"); + } + + include ("include.php"); + include ("db.php"); + include ("factdefs.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); + } + else + { + echo (file_get_contents("index-header.html")); + + $environment = sizeof($_GET); + + InitGet($_GET); + PrintForm($_GET, $host, $user, $pw, $db); + + if ($environment==0) + printf("No query submitted yet.
"); + else + PrintPage("1", $host, $user, $pw, $db, $alias, $rightalign, $checkwhere, $checkgroup, $checkstatusgroup); + + echo (file_get_contents("index-footer.html")); + } + + ini_set("display_errors", "Off"); + ini_set("mysql.trace_mode", "Off"); +} +?>