comp_result.php - airscore - Project Hosting on Google Code

‹r63

r93

Source path: svn/ trunk/ comp_result.php

<?php
function taskcmp($a, $b)
{
    if ($a['tname'] == $b['tname']) 
    {
        return 0;
    }
    return ($a['tname'] < $b['tname']) ? -1 : 1;
}
function olc_result($link,$top,$restrict)
{
    $lastpil = 0;
    $toptasks = array();
    $topscores = array();

    $sql = "SELECT P.*, T.traPk, T.traScore FROM tblTrack T, tblPilot P, tblComTaskTrack CTT where CTT.traPk=T.traPk and T.pilPk=P.pilPk and T.traScore is not null $restrict order by P.pilPk, T.traScore desc";
    $result = mysql_query($sql,$link) or die('Top score: ' . mysql_error());
    ;

    while ($row = mysql_fetch_array($result))
    {
        // another pilot .. finish it off
        $pilPk = $row['pilPk'];
        if (!$toptasks[$pilPk])
        {
            $toptasks[$pilPk] = array();
        }
        array_push($toptasks[$pilPk], $row);
    }

    // do the totals ...
    foreach ($toptasks as $pilPk => $scores)
    {
        // cut to max ..
        $scores = array_slice($scores,0,$top);
        $total = 0;

        foreach ($scores as $row)
        {
            $total = $total + $row['traScore'];
            $first = $row['pilFirstName'];
            $last = $row['pilLastName'];
        }

        $total = $total . $last;
        $topscores[$total] = array( 
                    'total' => $total,
                    'tasks' => $scores,
                    'pilpk' => $pilPk,
                    'firstname' => $first,
                    'lastname' => $last
            );
    }

    krsort($topscores, SORT_NUMERIC);

    return $topscores;
}

function team_comp_result($comPk, $how, $param)
{
    $sql = "select TK.*,TR.*,P.* from tblTeamResult TR, tblTask TK, tblTeam P, tblCompetition C where C.comPk=$comPk and TR.tasPk=TK.tasPk and TK.comPk=C.comPk and P.teaPk=TR.teaPk order by P.teaPk, TK.tasPk";
    $result = mysql_query($sql) or die('Task result query failed: ' . mysql_error());
    $results = array();
    while ($row = mysql_fetch_array($result))
    {
        $score = round($row['terScore']);
        $validity = $row['tasQuality'] * 1000;
        $pilPk = $row['teaPk'];
        $tasName = $row['tasName'];
    
        if (!$results[$pilPk])
        {
            $results[$pilPk] = array();
            $results[$pilPk]['name'] = $row['teaName'];
        }
        //echo "pilPk=$pilPk tasname=$tasName, result=$score<br>\n";
        $perf = 0;
        if ($how == 'ftv') 
        {
            $perf = 0;
            if ($validity > 0)
            {
                $perf = round($score / $validity, 3) * 1000;
            }
        }
        else
        {
            $perf = round($score, 0);
        }
        $results[$pilPk]["${perf}${tasName}"] = array('score' => $score, 'validity' => $validity, 'tname' => $tasName);
    }

    // Do the scoring totals (FTV/X or Y tasks etc)
    $sorted = array();
    foreach ($results as $pil => $arr)
    {
        krsort($arr, SORT_NUMERIC);

        $pilscore = 0;
        if ($how != 'ftv')
        {
            # Max rounds scoring
            $count = 0;
            foreach ($arr as $perf => $taskresult)
            {
                if ($perf == 'name') 
                {
                    continue;
                }
                if ($count < $param)
                {
                    $arr[$perf]['perc'] = 100;
                    $pilscore = $pilscore + $taskresult['score'];
                }
                else
                {
                    $arr[$perf]['perc'] = 0;
                }
                $count++;
                
            }
        }
        else
        {
            # FTV scoring
            $pilvalid = 0;
            foreach ($arr as $perf => $taskresult)
            {
                if ($perf == 'name') 
                {
                    continue;
                }

                //echo "pil=$pil perf=$perf valid=", $taskresult['validity'], " score=", $taskresult['score'], "<br>";
                if ($pilvalid < $param)
                {
                    $gap = $param - $pilvalid;
                    $perc = 0;
                    if ($taskresult['validity'] > 0)
                    {
                        $perc = $gap / $taskresult['validity'];
                    }
                    if ($perc > 1)
                    {
                        $perc = 1;
                    }
                    $pilvalid = $pilvalid + $taskresult['validity'] * $perc;
                    $pilscore = $pilscore + $taskresult['score'] * $perc;
                    $arr[$perf]['perc'] = $perc * 100;
                }
            }   
        }
        // resort arr by task?
        uasort($arr, "taskcmp");
        #echo "pil=$pil pilscore=$pilscore<br>";
        foreach ($arr as $key => $res)
        {
            if ($key != 'name')
            {
                $arr[$res['tname']] = $res;
                unset($arr[$key]);
            }
        }
        $pilscore = round($pilscore,0);
        $sorted["${pilscore}!${pil}"] = $arr;
    }

    krsort($sorted, SORT_NUMERIC);
    return $sorted;
}

function team_handicap_result($comPk,$how,$param)
{
    $query = "select T.tasPk, T.tasName, max(TR.tarScore) as maxScore from tblTaskResult TR, tblTask T where T.tasPk=TR.tasPk and T.comPk=$comPk group by TR.tasPk";
    $result = mysql_query($query) or die('Team aggregate query failed: ' . mysql_error());
    $row = mysql_fetch_array($result);
    $tinfo = array();
    while ($row)
    {
        $tinfo[$row['tasPk']] = array( 'name' => $row['tasName'], 'maxscore' => $row['maxScore']);
        $row = mysql_fetch_array($result);
    }

    $hteams = array();
    $count = 0;
    foreach ($tinfo as $task => $tasinfo)
    {
        $maxscore = intval($tasinfo['maxscore']);
        if ($maxscore < 1)
        {
            next;
        }
        $query = "select TM.teaPk,TK.tasPk,TK.tasName,TM.teaName,sum(TR.tarScore-H.hanHandicap*$maxscore) as handiscore from tblTaskResult TR, tblTask TK, tblTrack K, tblPilot P, tblTeam TM, tblTeamPilot TP, tblHandicap H, tblCompetition C where TP.teaPk=TM.teaPk and P.pilPk=TP.pilPk and C.comPk=TK.comPk and K.traPk=TR.traPk and K.pilPk=P.pilPk and H.pilPk=P.pilPk and TR.tasPk=TK.tasPk and TM.comPk=C.comPk and TK.tasPk=$task group by TM.teaPk";
        $result = mysql_query($query) or die('Team handicap query failed: ' . mysql_error());
        $row = mysql_fetch_array($result);
        while ($row)
        {
            //echo "task=$task teaPk=" . $row['teaPk'] . "=" . $row['handiscore'] . "<br>";
            if (array_key_exists($row['teaPk'], $hteams))
            {
                $htable = $hteams[$row['teaPk']];
                $htable['scores'][$count] = $row['handiscore'];
                $htable['total'] = round($htable['total'] + $row['handiscore'],0);
                $hteams[$row['teaPk']] = $htable;
            }
            else
            {
                $htable = array();
                $htable['team'] = $row['teaName'];
                $htable['scores'] = array();
                for ($i = 0; $i < $count; $i++)
                {
                    $htable['scores'][$i] = 0;
                }
                $htable['scores'][$count] = $row['handiscore'];
                $htable['total'] =  round($row['handiscore'],0);
                $hteams[$row['teaPk']] = $htable;
            }


            $row = mysql_fetch_array($result);
        }
        $count++;
    
    }
    $hres = array();
    foreach ($hteams as $res)
    {
        $total = $res['total'];
        $team = $res['team'];
        $hres["${total}${team}"] = $res;
    }
    krsort($hres, SORT_NUMERIC);

    $sorted = array();
    $place = 1;
    $htable = array();
    $title = array( fb("Res"), fb("Team"), fb("Total"));
    foreach ($tinfo as $task => $tasinfo)
    {
        $title[] = fb($tasinfo['name']);
    }
    $htable[] = $title;

    foreach ($hres as $res => $pils)
    {
        $row = array( fb("$place"), $pils['team'], $pils['total'] );
        foreach ($pils['scores'] as $tas => $sco)
        {
            $row[] = round($sco,0);
        }
        $htable[] = $row;
        $place = $place + 1;
    }

    echo ftable($htable, "border=\"5\" cellpadding=\"3\" alternate-colours=\"yes\" align=\"center\"", array('class="l"', 'class="d"'), '');
}

function comp_result($comPk, $how, $param, $cls)
{
    $sql = "select TK.*,TR.*,P.* from tblTaskResult TR, tblTask TK, tblTrack T, tblPilot P, tblCompetition C where C.comPk=$comPk and TK.comPk=C.comPk and TK.tasPk=TR.tasPk and TR.traPk=T.traPk and T.traPk=TR.traPk and P.pilPk=T.pilPk $cls order by P.pilPk, TK.tasPk";
    $result = mysql_query($sql) or die('Task result query failed: ' . mysql_error());
    $results = array();
    while ($row = mysql_fetch_array($result))
    {
        $score = round($row['tarScore']);
        $validity = $row['tasQuality'] * 1000;
        $pilPk = $row['pilPk'];
        $tasName = $row['tasName'];
    
        if (!$results[$pilPk])
        {
            $results[$pilPk] = array();
            $results[$pilPk]['name'] = $row['pilFirstName'] . ' ' . $row['pilLastName'];
        }
        //echo "pilPk=$pilPk tasname=$tasName, result=$score<br>\n";
        $perf = 0;
        if ($how == 'ftv') 
        {
            $perf = 0;
            if ($validity > 0)
            {
                $perf = round($score / $validity, 3) * 1000;
            }
        }
        else
        {
            $perf = round($score, 0);
        }
        $results[$pilPk]["${perf}${tasName}"] = array('score' => $score, 'validity' => $validity, 'tname' => $tasName);
    }

    // Do the scoring totals (FTV/X or Y tasks etc)
    $sorted = array();
    foreach ($results as $pil => $arr)
    {
        krsort($arr, SORT_NUMERIC);

        $pilscore = 0;
        if ($how != 'ftv')
        {
            # Max rounds scoring
            $count = 0;
            foreach ($arr as $perf => $taskresult)
            {
                if ($perf == 'name') 
                {
                    continue;
                }
                if ($count < $param)
                {
                    $arr[$perf]['perc'] = 100;
                    $pilscore = $pilscore + $taskresult['score'];
                }
                else
                {
                    $arr[$perf]['perc'] = 0;
                }
                $count++;
                
            }
        }
        else
        {
            # FTV scoring
            $pilvalid = 0;
            foreach ($arr as $perf => $taskresult)
            {
                if ($perf == 'name') 
                {
                    continue;
                }

                //echo "pil=$pil perf=$perf valid=", $taskresult['validity'], " score=", $taskresult['score'], "<br>";
                if ($pilvalid < $param)
                {
                    $gap = $param - $pilvalid;
                    $perc = 0;
                    if ($taskresult['validity'] > 0)
                    {
                        $perc = $gap / $taskresult['validity'];
                    }
                    if ($perc > 1)
                    {
                        $perc = 1;
                    }
                    $pilvalid = $pilvalid + $taskresult['validity'] * $perc;
                    $pilscore = $pilscore + $taskresult['score'] * $perc;
                    $arr[$perf]['perc'] = $perc * 100;
                }
            }   
        }
        // resort arr by task?
        uasort($arr, "taskcmp");
        #echo "pil=$pil pilscore=$pilscore<br>";
        foreach ($arr as $key => $res)
        {
            if ($key != 'name')
            {
                $arr[$res['tname']] = $res;
                unset($arr[$key]);
            }
        }
        $pilscore = round($pilscore,0);
        $sorted["${pilscore}!${pil}"] = $arr;
    }

    krsort($sorted, SORT_NUMERIC);
    return $sorted;
}

require 'authorisation.php';
require 'format.php';
require 'hc.php';

$comPk = intval($_REQUEST['comPk']);
$start = intval($_REQUEST['start']);
$tmsc = intval($_REQUEST['tmsc']);
if ($start < 0)
{
    $start = 0;
}
$link = db_connect();
$title = 'highcloud.net';

$query = "SELECT T.*,F.* FROM tblCompetition T left outer join tblFormula F on F.comPk=T.comPk where T.comPk=$comPk";
$result = mysql_query($query) or die('Comp query failed: ' . mysql_error());
$row = mysql_fetch_array($result);
if ($row)
{
    $comName = $row['comName'];
    $title = $row['comName'];
    $comDateFrom = substr($row['comDateFrom'],0,10);
    $comDateTo = substr($row['comDateTo'],0,10);
    #$comPk = $row['comPk'];
    $comOverall = $row['comOverallScore'];
    $comOverallParam = $row['comOverallParam'];
    $comDirector = $row['comMeetDirName'];
    $comLocation = $row['comLocation'];
    $comFormula = $row['forClass'] . ' ' . $row['forVersion'];
    $comSanction = $row['comSanction'];
    $comOverall = $row['comOverallScore'];
    $comTeamScoring = $row['comTeamScoring'];
    $comCode = $row['comCode'];
    $comType = $row['comType'];
    $forNomGoal = $row['forNomGoal'];
    $forMinDistance = $row['forMinDistance'];
    $forNomDistance = $row['forNomDistance'];
    $forNomTime = $row['forNomTime'];
}

$fdhv= '';
$classstr = '';
if (array_key_exists('class', $_REQUEST))
{
    $cval = intval($_REQUEST['class']);
    $carr = array (
        "'1/2'", "'2'", "'2/3'", "'competition'"       
        );
    $cstr = array ( "Fun", "Sport", "Serial", "Open", "Women", "Seniors", "Juniors" );
    $classstr = "<b>" . $cstr[intval($_REQUEST['class'])] . "</b> - ";
    if ($cval == 4)
    {
        $fdhv = "and P.pilSex='F'";
    }
    else if ($cval == 5)
    {
        $fdhv = "and P.pilBirthdate < '1959-03-14'";
    }
    else if ($cval == 6)
    {
        $fdhv = "and P.pilBirthdate > '1974-03-14'";
    }
    else
    {
        $fdhv = $carr[intval($_REQUEST['class'])];
        $fdhv = "and traDHV=$fdhv ";
    }
}


$embed = addslashes($_REQUEST['embed']);
if ($embed == '')
{
    hcheader($title, 2, "$classstr $comDateFrom - $comDateTo");

    echo "<div id=\"content\">";
    echo "<div id=\"text\">";
}
else
{
    echo "<link HREF=\"$embed\" REL=\"stylesheet\" TYPE=\"text/css\">";
    echo "</head><body>";
}

//echo "<h1>Details</h1>";
// Determine scoring params / details ..

$tasTotal = 0;
$query = "select count(*) from tblTask where comPk=$comPk";
$result = mysql_query($query); // or die('Task total failed: ' . mysql_error());
if ($result)
{
    $tasTotal = mysql_result($result, 0, 0);
}
if ($comOverall == 'all')
{
    # total # of tasks
    $comOverallParam = $tasTotal;
    $overstr = "All rounds";
}
else if ($comOverall == 'round')
{
    $overstr = "$comOverallParam rounds";
}
else if ($comOverall == 'round-perc')
{
    $comOverallParam = round($tasTotal * $comOverallParam / 100, 0);
    $overstr = "$comOverallParam rounds";
}
else if ($comOverall == 'ftv')
{
    $sql = "select sum(tasQuality) as totValidity from tblTask where comPk=$comPk";
    $result = mysql_query($sql) or die('Task validity query failed: ' . mysql_error());
    $totalvalidity = round(mysql_result($result, 0, 0) * $comOverallParam * 10,0);
    $overstr = "FTV $comOverallParam% ($totalvalidity pts)";
    $comOverallParam = $totalvalidity;
}

//echo ftable($detarr, '', '', '');

echo "<h1>Results</h1>";


echo "<table border=\"2\" cellpadding=\"1\" alternate-colours=\"yes\" align=\"center\">";
echo "<tr class=\"h\"><td><b>Res</b></td><td><b>Pilot</b></td><td><b>Total</b></td>";

# find each task details
$alltasks = array();
$taskinfo = array();
$sorted = array();
if ($tmsc > 0)
{
    //if ($comTeamScoring == 'handicap')
    {
        team_handicap_result($comPk,$how,$param);
    }
}
else if ($tasTotal > 0)
{
    $query = "select T.* from tblTask T where T.comPk=$comPk order by T.tasDate";
    $result = mysql_query($query) or die('Task query failed: ' . mysql_error());
    while ($row = mysql_fetch_array($result))
    {
        $alltasks[] = $row['tasName'];
        $taskinfo[] = $row;
    }

    if ($comType == 'Team-RACE')
    {
        $sorted = team_comp_result($comPk, $comOverall, $comOverallParam);
        $subtask = 'team_';
    }
    else
    {
        $sorted = comp_result($comPk, $comOverall, $comOverallParam, $fdhv);
        $subtask = '';
    }

    foreach ($taskinfo as $row)
    {
        $tasName = $row['tasName'];
        $tasPk = $row['tasPk'];
        $tasDate = substr($row['tasDate'],0,10);
        echo "<td><b><a href=\"${subtask}task_result.php?comPk=$comPk&tasPk=$tasPk\">$tasName</a></b></td>";
    }
    echo "</tr>\n";
    echo "<tr class=\"h\"><td></td><td></td><td></td>";
    foreach ($taskinfo as $row)
    {
        $tasPk = $row['tasPk'];
        echo "<td><a href=\"route_map.php?comPk=$comPk&tasPk=$tasPk\">Map</a></td>";
    }
    echo "</tr>\n";
    $count = 1;
    foreach ($sorted as $pil => $arr)
    {
        if ($count % 2)
        {
            $class = "d";
        }
        else
        {
            $class = "l";
        }
        echo "<tr class=\"$class\"><td>${count}</td><td>";
        echo $arr['name'] . "</td>";
        $tot = 0 + $pil;
        echo "<td><b>$tot</b></td>";
        foreach ($alltasks as $num => $name)
        {
            $score = $arr[$name]['score'];
            $perc = round($arr[$name]['perc'], 0);
            if (!$score)
            {
                $score = 0;
            }
            if ($perc == 100)
            {
                echo "<td><b>$score</b></td>";
            }
            else if ($perc > 0)
            {
                echo "<td><b>$score</b> $perc%</td>";
            }
            else
            {
                echo "<td>$score</td>";
            }
        }
        echo "</tr>\n";
        $count++;
    }
}
elseif ($comType != 'RACE')
{
    $top = 25;
    if (!$comOverallParam)
    {
        $comOverallParam = 4;
    }
    $restrict = '';
    if ($comPk > 1)
    {
        $restrict = " and CTT.comPk=$comPk";
    }
    $sorted = olc_result($link,$comOverallParam, $restrict);
    $size = sizeof($sorted);

    #echo "<tr class=\"h\"><td><b>Place</b></td><td><b>Pilot</b></td><td><b>Total</b></td><td><b>Task 1</b1></td><td><b>Task 2</b></td><td><b>Task 3</b></td><td><b>Task 4</b></td></tr>\n";
    $count = $start+1;
    $sorted = array_slice($sorted,$start,$top);
    foreach ($sorted as $total => $row)
    {
        if ($count % 2)
        {
            echo "<tr class=\"d\">";
        }
        else
        {
            echo "<tr class=\"l\">";
        }
        $name = $row['firstname'] . " " . $row['lastname'];
        $key = $row['pilpk'];
        $total = round($total/1000,2);
        echo "<td>$count</td><td><a href=\"index.php?pil=$key\">$name</a></td><td>$total</td>\n";
        foreach ($row['tasks'] as $task)
        {
            $score = round($task['traScore']/1000,1);
            $id = $task['traPk'];
            echo "<td><a href=\"tracklog_map.php?comPk=$comPk&trackid=$id\">$score</a></td>";
        }
        $count++;
        if ($count >= $top + $start) 
        {
            break;
        }
        echo "</tr>";
    }
    echo "</table>";
    
    if ($count == 1)
    {
        echo "<b>No tracks submitted for $comName yet.</b>\n";
    }
    else 
    {
        if ($start >= 0)
        {
            echo "<b class=\"left\"><a href=\"comp_result.php?comPk=$comPk&start=" . ($start-$top) . "\">Prev 25</a></b>\n";
        }
        if ($count < $size)
        {
            echo "<b class=\"right\"><a href=\"comp_result.php?comPk=$comPk&start=" . ($count) . "\">Next 25</a></b>\n";
        }
    }


}

echo "</table>";
if ($comOverall == 'ftv')
{
    echo "1. Click <a href=\"ftv.php?comPk=$comPk\">here</a> for an explanation of FTV<br>";
    echo "2. Scores in bold 100%, or indicated %, other scores not counted<br>";
}
if ($embed == '')
{
    // Only emit image if results table is "narrow"
    echo "</div>";
    if (sizeof($taskinfo) > 8)
    {
        echo "<div id=\"image\" background=\"images/pilots.jpg\"></div>";
    }
    else
    {
        hcimage($link,$comPk);
    }
    echo "<div id=\"sideBar\">";

    echo "<h1>Comp Details</h1>";
    $detarr = array(
        array("<b>Location</b> ", "<i>$comLocation</i>"),
        array ("<b>Director</b> ", "<i>$comDirector</i>"),
        array("<i>$comDateFrom</i>", "<i>$comDateTo</i>")
    );

    if ($comType == 'RACE' || $comType == 'Team-RACE')
    {
        $scarr = array();
        $scarr[] = array("<b>Type</b> ", "<i>$comType ($comFormula)</i>");
        $scarr[] = array("<b>Scoring</b> ","<i>$overstr</i>");
        $scarr[] = array("<b>Min Dist</b>", "<i>$forMinDistance kms</i>");
        $scarr[] = array("<b>Nom Dist</b>", "<i>$forNomDistance kms</i>");
        $scarr[] = array("<b>Nom Time</b>", "<i>$forNomTime mins</i>");
        $scarr[] = array("<b>Nom Goal</b>", "<i>$forNomGoal%</i>");
        echo ftable($detarr, 'border="0" cellpadding="0" width="185"', '', array('', 'align="right"'));
        echo "<h1>Scoring Parameters</h1>";
        echo ftable($scarr, 'border="0" cellpadding="0" width="185"', '', array('', 'align="right"'));
    }
    else
    {
        $detarr[] = array("<b>Type</b> ", "<i>$comType ($comFormula)</i>");
        $detarr[] = array("<b>Scoring</b> ","<i>$overstr</i>");
        echo ftable($detarr, 'border="0" cellpadding="0" width="185"', '', array('', 'align="right"'));
    }


    hcopencomps($link);
    hcclosedcomps($link);
    echo "</div>";
    hcfooter();
}
?>
</body>
</html>

Show details Hide details

Change log

r74 by geoff.wong on Aug 25, 2009 Diff

A few minor display updates.

Go to:

Project members, sign in to write a code review

Older revisions

r63 by geoff.wong on Mar 22, 2009 Diff

Various minor fixes and clean ups.

r61 by geoff.wong on Mar 12, 2009 Diff

Handicap team scoring.

r58 by geoff.wong on Mar 09, 2009 Diff

Some forgotten commits. Mostly to do
with making a printer css.

All revisions of this file

File info

Size: 21428 bytes, 705 lines

View raw file