<?php

$checkwhere = array
    (
     "fRunTypeName"                      => CheckWhere("fRunTypeKEY"),
    );

$checkgroup = array
    (
     "fRunTypeName"                      => CheckGroup("fRunTypeKEY"),
    );


            //don't put a '#' at the beginning of the alias, else SortBy won't work anymore
$alias = array
    (
     "NumRuns"                          => "#Runs",
     "Run"                              => "Run",
     "fRunTypeName"                     => "RunType",
     "fMd5sumRaw"                       => "md5",
     "fMd5sumRawZip"                    => "md5(zip)",
     "fROI"                             => "roi",
     "fROITimeMarker"                   => "roi-tm",
     "fLastUpdate"                      => "LastUpd",
     //"SUM(fRunTime)/3600"               => "Time [h]",
     "SUM(fNumEvents)"                  => "Evts",
     "Min(fZenithDistanceMin)"          => "ZDMin",
     "Max(fZenithDistanceMax)"          => "ZDMax",
     "Min(fZenithDistance)"             => "ZdMin",
     "Max(fZenithDistance)"             => "ZdMax",
     "fNumEvents"                       => "#Evts",
     "fRunStart"                        => "start",
     "fRunStop"                         => "stop",
     "fFitsFileErrors"                  => "file err",
     "fHasDrsFile"                      => "num drs",
     "TimeDiff(fRunStop,fRunStart)"     => "duration",
     "Round(fNumPhysicsTrigger/Time_to_sec(TimeDiff(fRunStop,fRunStart)),1)"  => "phys rate [Hz]",
     "fNumPhysicsTrigger"               => "#Phys",
     "fNumExt1Trigger"                  => "#Ext1",
     "fNumExt2Trigger"                  => "#Ext2",
     "fNumELPTrigger"                   => "#ELP",
     "fNumILPTrigger"                   => "#ILP",
     "fNumPedestalTrigger"              => "#Ped",
     "fNumTimeTrigger"                  => "#Time",
     "fNumOtherTrigger"                 => "#Other",
     "Round(Sum(TimeDiff(fRunStop,fRunStart))/60./60.,1)"  => "Time [h]",
     "fTriggerRateMedian"               => "mean rate",
     "fBiasVoltageMedian"               => "mean bias",
     "fThresholdMedian"                 => "mean threshold",
     "fRightAscension"                  => "RA",
     "fDeclination"                     => "Decl",
    );


$rightalign = array
    (
     //$alias["fRunTypeName"]              => "1",
     $alias["fNumEvents"]                => "1",
     $alias["Round(fNumPhysicsTrigger/Time_to_sec(TimeDiff(fRunStop,fRunStart)),1)"] => "1",
     $alias["fNumPhysicsTrigger"]        => "1",
     $alias["fNumExt1Trigger"]           => "1",
     $alias["fNumExt2Trigger"]           => "1",
     $alias["fNumELPTrigger"]            => "1",
     $alias["fNumILPTrigger"]            => "1",
     $alias["fNumPedestalTrigger"]       => "1",
     $alias["fNumTimeTrigger"]           => "1",
     $alias["fNumOtherTrigger"]          => "1",
     $alias["fFitsFileErrors"]           => "1",
     $alias["fROI"]                      => "1",
     $alias["fROITimeMarker"]            => "1",
     "Time [h]"                          => "1",
     "NumRuns"                           => "1",
     "Evts"                              => "1",
);

function GetCheck($fromtable, $val)
{
    $checks = array
        (
         "fRunTypeName"                      => $fromtable . ".fRunTypeKEY",
        );

    $check="";
    if (!empty($checks[$val]))
        $check=$checks[$val];
    return $check;
}


function GetJoin($fromtable, $val)
{
    $joins = array
        (
         "fRunTypeName"                     => " LEFT JOIN RunType                     USING(fRunTypeKEY) ",
        );


    $join="";
    if (!empty($joins[$val]))
        $join=$joins[$val];
    return $join;
}


?>