function userLeaderboard($club, $discipline)
{
$disciplines = getDisciplines();
$users = getTable("SELECT u.id AS uid, u.fname AS fname, u.sname AS sname, u.sex AS sex, SUM(t.score) AS score, AVG(t.score) AS avg\r\n\t\t\t\t\t\t\tFROM users AS u, timeline AS t, rounds AS r\r\n\t\t\t\t\t\t\tWHERE u.clubid='" . $club['cid'] . "' AND u.id = t.userid AND r.id = t.roundid " . $disciplines[$discipline] . "\r\n\t\t\t\t\t\t\tGROUP BY u.id\r\n\t\t\t\t\t\t\tORDER BY score DESC");
$output = "<h2>Leaderboard:</h2>" . "<table class='leaderboard'>" . "<tr><td>Name</td><td>Total Score</td><td>Average Score</td></tr>";
for ($i = 0; $i < count($users); $i++) {
$output .= "<tr><td><a href='/group3/dashboard?uid=" . $users[$i]['uid'] . "'>" . $users[$i]['fname'] . " " . $users[$i]['sname'] . "</a></td><td>" . $users[$i]['score'] . "</td><td>" . round($users[$i]['avg'], 2) . "</td></tr>";
}
$output .= "</table>";
return $output;
}
for ($i = 3; $i <= 278; $i += 5) {
$total15 = $objWorksheet15->getCell('AI' . $i)->getCalculatedValue();
$total16 = $objWorksheet16->getCell('AI' . $i)->getCalculatedValue();
if ($total15 == 0 && $total16 == 0) {
continue;
}
$industry = new StdClass();
$industry->name = $objWorksheet15->getCell('A' . $i)->getValue();
// 2015
$industry->y15 = new StdClass();
$industry->y15->total = $total15;
$industry->y15->disciplines = getDisciplines($cellConfig, $objWorksheet15, $i);
// 2016
$industry->y16 = new StdClass();
$industry->y16->total = $total16;
$industry->y16->disciplines = getDisciplines($cellConfig, $objWorksheet16, $i);
$list[] = $industry;
}
function getDisciplines($cellConfig, $objWorksheet, $i)
{
$disciplines = array();
foreach ($cellConfig as $c) {
$discipline = new StdClass();
$discipline->name = explode("\n", $objWorksheet->getCell($c->totalCell . '1')->getValue())[0];
$discipline->value = $objWorksheet->getCell($c->totalCell . $i)->getValue();
$discipline->isvalid = true;
$discipline->type = $c->percentType;
$discipline->detail = new StdClass();
// find detail
switch ($discipline->type) {
case 1: