| 1 | <?php
|
|---|
| 2 |
|
|---|
| 3 | $checkwhere = array
|
|---|
| 4 | (
|
|---|
| 5 | "fRunTypeName" => CheckWhere("fRunTypeKEY"),
|
|---|
| 6 | );
|
|---|
| 7 |
|
|---|
| 8 | $checkgroup = array
|
|---|
| 9 | (
|
|---|
| 10 | "fRunTypeName" => CheckGroup("fRunTypeKEY"),
|
|---|
| 11 | );
|
|---|
| 12 |
|
|---|
| 13 |
|
|---|
| 14 | //don't put a '#' at the beginning of the alias, else SortBy won't work anymore
|
|---|
| 15 | $alias = array
|
|---|
| 16 | (
|
|---|
| 17 | "NumRuns" => "#Runs",
|
|---|
| 18 | "Run" => "Run",
|
|---|
| 19 | "fRunTypeName" => "RunType",
|
|---|
| 20 | "fMd5sumRaw" => "md5",
|
|---|
| 21 | "fMd5sumRawZip" => "md5(zip)",
|
|---|
| 22 | "fROI" => "roi",
|
|---|
| 23 | "fROITimeMarker" => "roi-tm",
|
|---|
| 24 | "fLastUpdate" => "LastUpd",
|
|---|
| 25 | //"SUM(fRunTime)/3600" => "Time [h]",
|
|---|
| 26 | "SUM(fNumEvents)" => "Evts",
|
|---|
| 27 | "Min(fZenithDistanceMin)" => "ZDMin",
|
|---|
| 28 | "Max(fZenithDistanceMax)" => "ZDMax",
|
|---|
| 29 | "Min(fZenithDistance)" => "ZdMin",
|
|---|
| 30 | "Max(fZenithDistance)" => "ZdMax",
|
|---|
| 31 | "fNumEvents" => "#Evts",
|
|---|
| 32 | "fRunStart" => "start",
|
|---|
| 33 | "fRunStop" => "stop",
|
|---|
| 34 | "fFitsFileErrors" => "file err",
|
|---|
| 35 | "fHasDrsFile" => "num drs",
|
|---|
| 36 | "TimeDiff(fRunStop,fRunStart)" => "duration",
|
|---|
| 37 | "Round(fNumPhysicsTrigger/Time_to_sec(TimeDiff(fRunStop,fRunStart)),1)" => "phys rate [Hz]",
|
|---|
| 38 | "fNumPhysicsTrigger" => "#Phys",
|
|---|
| 39 | "fNumExt1Trigger" => "#Ext1",
|
|---|
| 40 | "fNumExt2Trigger" => "#Ext2",
|
|---|
| 41 | "fNumELPTrigger" => "#ELP",
|
|---|
| 42 | "fNumILPTrigger" => "#ILP",
|
|---|
| 43 | "fNumPedestalTrigger" => "#Ped",
|
|---|
| 44 | "fNumTimeTrigger" => "#Time",
|
|---|
| 45 | "fNumOtherTrigger" => "#Other",
|
|---|
| 46 | "Round(Sum(TimeDiff(fRunStop,fRunStart))/60./60.,1)" => "Time [h]",
|
|---|
| 47 | );
|
|---|
| 48 |
|
|---|
| 49 |
|
|---|
| 50 | $rightalign = array
|
|---|
| 51 | (
|
|---|
| 52 | //$alias["fRunTypeName"] => "1",
|
|---|
| 53 | $alias["fNumEvents"] => "1",
|
|---|
| 54 | $alias["Round(fNumPhysicsTrigger/Time_to_sec(TimeDiff(fRunStop,fRunStart)),1)"] => "1",
|
|---|
| 55 | $alias["fNumPhysicsTrigger"] => "1",
|
|---|
| 56 | $alias["fNumExt1Trigger"] => "1",
|
|---|
| 57 | $alias["fNumExt2Trigger"] => "1",
|
|---|
| 58 | $alias["fNumELPTrigger"] => "1",
|
|---|
| 59 | $alias["fNumILPTrigger"] => "1",
|
|---|
| 60 | $alias["fNumPedestalTrigger"] => "1",
|
|---|
| 61 | $alias["fNumTimeTrigger"] => "1",
|
|---|
| 62 | $alias["fNumOtherTrigger"] => "1",
|
|---|
| 63 | $alias["fFitsFileErrors"] => "1",
|
|---|
| 64 | $alias["fROI"] => "1",
|
|---|
| 65 | $alias["fROITimeMarker"] => "1",
|
|---|
| 66 | "Time [h]" => "1",
|
|---|
| 67 | "NumRuns" => "1",
|
|---|
| 68 | "Evts" => "1",
|
|---|
| 69 | );
|
|---|
| 70 |
|
|---|
| 71 | function GetCheck($fromtable, $val)
|
|---|
| 72 | {
|
|---|
| 73 | $checks = array
|
|---|
| 74 | (
|
|---|
| 75 | "fRunTypeName" => $fromtable . ".fRunTypeKEY",
|
|---|
| 76 | );
|
|---|
| 77 |
|
|---|
| 78 | $check="";
|
|---|
| 79 | if (!empty($checks[$val]))
|
|---|
| 80 | $check=$checks[$val];
|
|---|
| 81 | return $check;
|
|---|
| 82 | }
|
|---|
| 83 |
|
|---|
| 84 |
|
|---|
| 85 | function GetJoin($fromtable, $val)
|
|---|
| 86 | {
|
|---|
| 87 | $joins = array
|
|---|
| 88 | (
|
|---|
| 89 | "fRunTypeName" => " LEFT JOIN RunType USING(fRunTypeKEY) ",
|
|---|
| 90 | );
|
|---|
| 91 |
|
|---|
| 92 |
|
|---|
| 93 | $join="";
|
|---|
| 94 | if (!empty($joins[$val]))
|
|---|
| 95 | $join=$joins[$val];
|
|---|
| 96 | return $join;
|
|---|
| 97 | }
|
|---|
| 98 |
|
|---|
| 99 |
|
|---|
| 100 | ?>
|
|---|
