$dataarray, 'tableclass' => $tableclass, 'linkslist' => $linklist, 'imagelist' => $imagelist, 'tableid' => $tableid, 'priority' => $priority ); return $JSONboxTable; } function Createlink($omit) { $currentteam = ( isset( $_GET['teamid'] ) && is_numeric( $_GET['teamid'] ) ) ? intval( $_GET['teamid'] ) : 0; $currentlevel = ( isset( $_GET['levelid'] ) && is_numeric( $_GET['levelid'] ) ) ? intval( $_GET['levelid'] ) : 0; $currentdivision = $_GET['divid']; $currentseason = ( isset( $_GET['seasonid'] ) && is_numeric( $_GET['seasonid'] ) ) ? intval( $_GET['seasonid'] ) : 0; $currentsubseason = ( isset( $_GET['subseasonid'] ) && is_numeric( $_GET['subseasonid'] ) ) ? intval( $_GET['subseasonid'] ) : 0; $pageselect = ( isset( $_GET['page'] ) && is_numeric( $_GET['page'] ) ) ? intval( $_GET['page'] ) : 1; $sortcondition = $_GET['sort']; $startcondition = array("teamid"=>$currentteam, "levelid"=>$currentlevel, "divid"=>$currentdivision, "seasonid"=>$currentseason,"subseasonid"=>$currentsubseason, "goalie"=>$currentgoalie, "page"=>$pageselect, "sort"=>$sortcondition); $setlink = ''; $uniqueelement = 0; foreach($startcondition as $var => $var_value) { if($var_value != 0 && $var != $omit) { $uniqueelement ++; if($uniqueelement >1) { $setlink .= '&'; } $setlink .= $var.'='.$var_value; } } return $setlink; } function sortinghandle($target) { $pdoConnect = createDBH(); $sortcondition = isset($_GET['sort']) ? $_GET['sort'] : NULL; $Sortmenufetch = $pdoConnect->prepare('SELECT TargetSQL FROM SortingStatTable WHERE Goalie = 2 AND StatShort = :selectsort'); $Sortmenufetch->bindParam(':selectsort', $target, PDO::PARAM_STR); $Sortmenufetch->execute(); $SortTargetfetch = $Sortmenufetch->fetch(PDO::FETCH_ASSOC); return $SortTargetfetch['TargetSQL']; } function assemblesortmenu($link) { $pdoConnect = createDBH(); $Sortmenustart = $pdoConnect->prepare('SELECT TargetSQL, StatShort FROM SortingStatTable WHERE Goalie = 2 ORDER BY SortPriority ASC'); $Sortmenustart->execute(); $Sortingmenu = ''; while($rowsort = $Sortmenustart->fetch(PDO::FETCH_ASSOC)) { $Sortingmenu .= ' '.$rowsort['StatShort'].' | '; } return $Sortingmenu; } function getRanking($dataarray, $targetteamid, $targetlevel, $targetdivision) { #Function performs ranking operation. Takes in target team and compares to data array. #Fudge factor if target division is null if (empty($targetdivision)) {$targetdivision = '0';} $LeagueTotal = 0; $LevelTotal = 0; $DivisionTotal = 0; $maxdataarray = count($dataarray[0]); $teamidarray = $dataarray[0]; $teamnamearray = $dataarray[1]; $teamstatarray = $dataarray[2]; $teamlevelarray = $dataarray[3]; $teamdivisionarray = $dataarray[4]; for($i=0; $i<$maxdataarray; $i++) { $LeagueTotal++; if ($teamlevelarray[$i] == $targetlevel && $teamdivisionarray[$i] == $targetdivision) { $LevelTotal++; $DivisionTotal++; } elseif ($teamlevelarray[$i] == $targetlevel) { $LevelTotal++; } if ($teamidarray[$i] == $targetteamid) { $LeagueRank = $LeagueTotal; $LevelRank = $LevelTotal; $DivisionRank = $DivisionTotal; } } #print_r(array("LeagueRank"=>$LeagueRank, "LeagueTotal"=>$LeagueTotal, "LevelRank"=>$LevelRank, "LevelTotal"=>$LevelTotal, "DivisionRank"=>$DivisionRank, "DivisionTotal"=>$DivisionTotal)); return array("LeagueRank"=>$LeagueRank, "LeagueTotal"=>$LeagueTotal, "LevelRank"=>$LevelRank, "LevelTotal"=>$LevelTotal, "DivisionRank"=>$DivisionRank, "DivisionTotal"=>$DivisionTotal); } function adjacentranked($sortedarray, $targetseasonposition, $targetfilter, $targetrank, $fetchteamsadjacent) { #Creates columns from a sorted stat array (teamid, team name, stat, team level, team division) $maxdataarray = count($sortedarray[0]); $teamidarray = $sortedarray[0]; $teamnamearray = $sortedarray[1]; $teamstatarray = $sortedarray[2]; $teamlevelarray = $sortedarray[3]; $teamdivisionarray = $sortedarray[4]; $targetinarray = $targetseasonposition - 1; #Filtering process - creates new array to match filter if ($targetfilter == 'Division') { $targetdivision = $teamdivisionarray[$targetinarray]; $targetlevel = $teamlevelarray[$targetinarray]; for ($i = 0; $i < $maxdataarray; $i++) { if ($targetdivision == $teamdivisionarray[$i] AND $targetlevel == $teamlevelarray[$i]) { $rankedarray[] = array("Teamid" => $teamidarray[$i], "Team" => $teamnamearray[$i], "Stat" => $teamstatarray[$i]); } } } elseif ($targetfilter == 'Level') { $targetlevel = $teamlevelarray[$targetinarray]; for ($i = 0; $i < $maxdataarray; $i++) { if ($targetlevel == $teamlevelarray[$i]) { $rankedarray[] = array("Teamid" => $teamidarray[$i], "Team" => $teamnamearray[$i], "Stat" => $teamstatarray[$i]); } } } else { for ($i = 0; $i < $maxdataarray; $i++) { $rankedarray[] = array("Teamid" => $teamidarray[$i], "Team" => $teamnamearray[$i], "Stat" => $teamstatarray[$i]); } } $startspot = $targetrank-$fetchteamsadjacent-1; $endspot = $targetrank+$fetchteamsadjacent-1; $keyspot = $targetrank-$fetchteamsadjacent; #Adjustment in case start goes beyond the beginning of the array if ($startspot < 0) {$startspot = 0; $keyspot = 1;} if ($endspot>$maxdataarray) {$endspot = $maxdataarray-1;} for($i = $startspot; $i <= $endspot; $i++) { if (isset($rankedarray[$i])) { #$rankedarray[$i]['Rank'] = $keyspot; $rankedarray[$i] = array('Rank' => $keyspot) + $rankedarray[$i]; $outputarray[] = $rankedarray[$i];} else {NULL;} $keyspot++; } return $outputarray; } function getRuleSet() { $pdoConnect = createDBH(); $RuleSQL = 'SELECT StatCategory, SortBig FROM SortingStatTable WHERE Goalie = 2'; $RuleFetch = $pdoConnect->prepare($RuleSQL); $RuleFetch->execute(); $RuleSet = $RuleFetch->fetchAll(PDO::FETCH_ASSOC); return $RuleSet; } function makeStatArray ($dataset, $targetcolumn, $sortbigontop, $statnumbertype) { foreach ($dataset as $key=>$row) { $sortteam[$key] = $row['idTeamAssignment']; $sortteamid[$key] = $row['TeamName']; $sortlevel[$key] = $row['idLevelSeasonkey']; $sortdivision[$key] = $row['TeamDivision']; $sorttargetstat[$key] = $row[$targetcolumn]; if ($statnumbertype == 'Percent') {$sortdisplaystat[$key] = round($row[$targetcolumn]*100,2).'%'; } elseif ($statnumbertype == 'PlusMinus') { if ($row[$targetcolumn] > 0) {$sortdisplaystat[$key] = '+'.$row[$targetcolumn];} else {$sortdisplaystat[$key] = $row[$targetcolumn];} } else {$sortdisplaystat[$key] = $row[$targetcolumn];} } if ($sortbigontop == 1) {array_multisort($sorttargetstat, SORT_DESC, SORT_NUMERIC, $sortdisplaystat, $sortteam, $sortteamid, $sortlevel, $sortdivision);} elseif ($sortbigontop == 0) {array_multisort($sorttargetstat, SORT_ASC, SORT_NUMERIC, $sortdisplaystat, $sortteam, $sortteamid, $sortlevel, $sortdivision);} $returnarray = array($sortteam, $sortteamid, $sortdisplaystat, $sortlevel, $sortdivision); return $returnarray; } function convertNumtoStat($stat, $statType) { if ($statType == 'Percent') {$statOutput = round($stat*100,2).'%';} elseif ($statType == 'PlusMinus') { if ($stat > 0) {$statOutput = '+'.$stat;} else {$statOutput = $stat;} } else {$statOutput = $stat;} return $statOutput; } function teamstatdataset($currentseason) { $pdoConnect = createDBH(); $SQLWhere = ''; $SQLJoin = ''; $SQLGroup = ' GROUP BY idTeamAssignment'; $SQLOrderBy = ''; if ($currentseason != 0) { $SQLWhere .= ' WHERE idSeasonkey = :idseason AND TeamGamesPlayed > 0'; } #Set Query for Team $Teamstatfetchstart = 'SELECT idTeamAssignment, idLevelSeasonkey, TeamDivision, TeamName, SUM(TeamGamesPlayed), SUM(TeamWins), SUM(TeamLoss), SUM(TeamTie), SUM(TeamOTLoss), SUM(TeamPts), SUM(TeamGoals), SUM(TeamGoalsAgainst), SUM(TeamGoals)-SUM(TeamGoalsAgainst) AS GD, SUM(TeamShots), IF(SUM(TeamShots) > 0, (ROUND(SUM(TeamShots)/SUM(TeamGamesPlayed),2)), 0) As SPG, SUM(TeamShotsAgainst), IF(SUM(TeamShotsAgainst) > 0, (ROUND(SUM(TeamShotsAgainst)/SUM(TeamGamesPlayed),2)), 0) As SAPG, SUM(TeamShots)-SUM(TeamShotsAgainst) AS SD, SUM(TeamPIM), SUM(TeamPN), SUM(TeamPIMA), SUM(TeamPNA), SUM(TeamPPChance), SUM(TeamPPGoal), SUM(TeamPKChance), SUM(TeamPPGAllowed), SUM(SHG), SUM(SHGAllowed), SUM(EmptyNetGoal), SUM(EmptyNetGoalAllowed), (SUM(TeamPPGoal) + SUM(SHG) - SUM(TeamPPGAllowed) - SUM(SHGAllowed)) AS SpTEff, IF(SUM(TeamShots) > 0, ROUND((SUM(TeamGoals)-SUM(EmptyNetGoal))/(SUM(TeamShots)-SUM(EmptyNetGoal)),4), 0) AS ShotEff, IF(SUM(TeamShotsAgainst) > 0, 1-(ROUND(((SUM(TeamGoalsAgainst)-SUM(EmptyNetGoalAllowed))/(SUM(TeamShotsAgainst)-SUM(EmptyNetGoalAllowed))),4)), 0) As DefEff, IF(SUM(TeamPPChance) > 0, SUM(TeamPPGoal)/SUM(TeamPPChance), 0) AS PPConvert, IF(SUM(TeamPKChance) > 0, 1-(SUM(TeamPPGAllowed)/SUM(TeamPKChance)), 0) AS PKConvert FROM teamstatassignment JOIN teamassignment ON teamstatassignment.idTeamAssignmentkey = teamassignment.idTeamAssignment JOIN subseason ON teamstatassignment.idsubseasonkey = subseason.idsubseason JOIN team ON teamassignment.idTeamkey = team.idTeam'; $Teamstatquery = $pdoConnect->prepare($Teamstatfetchstart.$SQLWhere.$SQLGroup.$SQLOrderBy); if ($currentseason != 0) { $Teamstatquery->bindParam(':idseason', $currentseason, PDO::PARAM_INT); } $Teamstatquery->execute(); $Teamplayerstat = $Teamstatquery->fetchAll(PDO::FETCH_ASSOC); return $Teamplayerstat; } function designRankBox($title, $teamstatsort, $season, $level, $div, $rank, $adjacentList) { #Takes arrays and converts them into Divs $titlediv = divBuilder('rankTitle','class',$title); $leftside = ''; $footerLinks = 'Full Team Stats: '; if (!empty($rank['DivisionRank'])) { $target = $rank['DivisionRank']; $leftside .= ''; $footerLinks .= 'Division Stats | '; $footerLinks .= 'Level Stats | '; } else { $target = $rank['LevelRank']; $leftside .= ''; $footerLinks .= 'Level Stats | '; } $leftside .= '
'.divBuilder('smallrank','class','Division').' '.divBuilder('bigrank','class',$rank['DivisionRank']).' / '.divBuilder('smallrank','class',$rank['DivisionTotal']).'
Level '.divBuilder('smallrank','class',$rank['LevelRank']).' / '.divBuilder('smallrank','class',$rank['LevelTotal']).'
League '.divBuilder('smallrank','class',$rank['LeagueRank']).' / '.divBuilder('smallrank','class',$rank['LeagueTotal']).'
'.divBuilder('smallrank','class','Level').' '.divBuilder('bigrank','class',$rank['LevelRank']).' / '.divBuilder('smallrank','class',$rank['LevelTotal']).'
League '.divBuilder('smallrank','class',$rank['LeagueRank']).' / '.divBuilder('smallrank','class',$rank['LeagueTotal']).'
'; $footerLinks .= 'League Stats'; $rightside = ''; foreach ($adjacentList as $key=>$row) { if (!empty($row)) { if ($key == $target) { $rightside .= '';} else {$rightside .= '';} } } $rightside .= '
RankTeam NameStat
'.$key.''.$row['TeamName'].''.$row['TeamStat'].'
'.$key.''.$row['TeamName'].''.$row['TeamStat'].'
'; $leftSideDiv = divBuilder('leftsideRank','class',$leftside); $rightSideDiv = divBuilder('rightsideRank','class',$rightside); $footerDiv = divBuilder('rankFooter','class',$footerLinks); $RankDiv = divBuilder('fullRank','class',$titlediv."\n\r".$leftSideDiv."\n\r".$rightSideDiv.$footerDiv); $RankBoxDiv = divBuilder('RankBox','class',$RankDiv); return $RankBoxDiv; } function buildSkaterLeaders ($teamtarget, $target, $header) { $pdoConnect = createDBH(); ##Gets necessary starting steps $currentteam = ( isset( $_GET['teamid'] ) && is_numeric( $_GET['teamid'] ) ) ? intval( $_GET['teamid'] ) : 0; $currentlevel = ( isset( $_GET['levelid'] ) && is_numeric( $_GET['levelid'] ) ) ? intval( $_GET['levelid'] ) : 0; $currentdivision = isset($_GET['divid']) ? $_GET['divid'] : NULL; $currentseason = ( isset( $_GET['seasonid'] ) && is_numeric( $_GET['seasonid'] ) ) ? intval( $_GET['seasonid'] ) : 0; $currentsubseason = ( isset( $_GET['subseasonid'] ) && is_numeric( $_GET['subseasonid'] ) ) ? intval( $_GET['subseasonid'] ) : 0; $currentgame = ( isset( $_GET['gameid'] ) && is_numeric( $_GET['gameid'] ) ) ? intval( $_GET['gameid'] ) : 0; if ($currentgame > 0) {$currentteam = $teamtarget;} $SQL = 'SELECT DISTINCT idTeamAssignment, skaterstat.idPlayerAssignment AS playerassignid, idPlayers, TeamName, PlayerLast, PlayerFirst, PlayerNumber, SUM(PlayerGames), '.$target.' FROM skaterstat JOIN playerassignment ON playerassignment.idPlayerAssignment = skaterstat.idPlayerAssignment JOIN players ON playerassignment.idPlayerskey=players.idPlayers JOIN subseason ON skaterstat.idsubseasonkey = subseason.idsubseason JOIN teamassignment ON playerassignment.idTeamAssignmentkey = teamassignment.idTeamAssignment JOIN team ON teamassignment.idTeamkey = team.idTeam WHERE idTeamAssignment IN (SELECT DISTINCT idteamassignmentkey FROM teamstatassignment'; $SQLWhere = ''; $SQLJoin = ''; $SQLGroup = ') GROUP BY playerassignid HAVING SUM(PlayerGames) > 0 ORDER BY '.$target.' DESC, SUM(PlayerGames) DESC LIMIT 5'; if ($currentseason != 0) { $SQLWhere .= ' WHERE idSeasonkey = :idseason'; } elseif ($currentteam != 0 || $currentgame != 0) { $SQLWhere .= ' WHERE idTeamAssignmentkey = :teamid'; } if ($currentsubseason != 0) { $SQLWhere .= ' AND idsubseasonkey = :idsubseason'; } if ($currentlevel != 0) { $SQLWhere .= ' AND idLevelSeasonkey = :idlevel'; } if (!empty($currentdivision)) { $SQLWhere .= ' AND TeamDivision = :division'; } #Set Query for Skaterstats $Leaderstatquery = $pdoConnect->prepare($SQL.$SQLWhere.$SQLGroup); if ($currentseason != 0) { $Leaderstatquery->bindParam(':idseason', $currentseason, PDO::PARAM_INT); } elseif ($currentteam != 0) { $Leaderstatquery->bindParam(':teamid', $currentteam, PDO::PARAM_INT); } if ($currentsubseason != 0) { $Leaderstatquery->bindParam(':idsubseason', $currentsubseason, PDO::PARAM_INT); } if ($currentlevel != 0) { $Leaderstatquery->bindParam(':idlevel', $currentlevel, PDO::PARAM_INT); } if (!empty($currentdivision)) { $Leaderstatquery->bindParam(':division', $currentdivision, PDO::PARAM_STR); } $Leaderstatquery->execute(); #Prepare Output for HTML $playerleader = ''; while($row = $Leaderstatquery->fetch(PDO::FETCH_ASSOC)) { $playerleader .= ''; } $playerleader .= '
'.$header.' Leader
Team NamePlayerGP'.$header.'
'.$row['TeamName'].''.$row['PlayerFirst'].' '.$row['PlayerLast'].''.$row['PlayerStatus'].''.$row['SUM(PlayerGames)'].''.$row[$target].'
'; return $playerleader; } function buildGoalieLeader ($targetteam, $target, $header, $sortorder) { $pdoConnect = createDBH(); ##Gets necessary starting steps $currentteam = ( isset( $_GET['teamid'] ) && is_numeric( $_GET['teamid'] ) ) ? intval( $_GET['teamid'] ) : 0; $currentlevel = ( isset( $_GET['levelid'] ) && is_numeric( $_GET['levelid'] ) ) ? intval( $_GET['levelid'] ) : 0; $currentdivision = isset($_GET['divid']) ? $_GET['divid'] : NULL; $currentseason = ( isset( $_GET['seasonid'] ) && is_numeric( $_GET['seasonid'] ) ) ? intval( $_GET['seasonid'] ) : 0; $currentsubseason = ( isset( $_GET['subseasonid'] ) && is_numeric( $_GET['subseasonid'] ) ) ? intval( $_GET['subseasonid'] ) : 0; $subgoalie = ( isset( $_GET['subgoalie'] ) && is_numeric( $_GET['subgoalie'] ) ) ? intval( $_GET['subgoalie'] ) : 0; $currentgame = ( isset( $_GET['gameid'] ) && is_numeric( $_GET['gameid'] ) ) ? intval( $_GET['gameid'] ) : 0; if ($currentgame > 0) {$currentteam = $targetteam;} $SQL = 'SELECT DISTINCT idTeamAssignment, goaliestat.idPlayerAssignment AS playerassignid, idPlayers, TeamName, PlayerLast, PlayerFirst, PlayerNumber, SUM(GoalieGames), '.$target.' '.$sortorder.' FROM goaliestat JOIN playerassignment ON playerassignment.idPlayerAssignment = goaliestat.idPlayerAssignment JOIN players ON playerassignment.idPlayerskey=players.idPlayers JOIN subseason ON goaliestat.idsubseasonkey = subseason.idsubseason JOIN teamassignment ON playerassignment.idTeamAssignmentkey = teamassignment.idTeamAssignment JOIN team ON teamassignment.idTeamkey = team.idTeam WHERE idTeamAssignment IN (SELECT DISTINCT idteamassignmentkey FROM teamstatassignment'; $SQLWhere = ''; $SQLJoin = ''; $SQLGroup = ') GROUP BY playerassignid HAVING SUM(GoalieGames) > 0 ORDER BY '.$target.' '.$sortorder.', SUM(GoalieGames) DESC LIMIT 5'; if ($currentseason != 0) { $SQLWhere .= ' WHERE idSeasonkey = :idseason'; } elseif ($currentteam != 0) { $SQLWhere .= ' WHERE idTeamAssignmentkey = :teamid'; } if ($currentsubseason != 0) { $SQLWhere .= ' AND idsubseasonkey = :idsubseason'; } if ($currentlevel != 0) { $SQLWhere .= ' AND idLevelSeasonkey = :idlevel'; } if (!empty($currentdivision)) { $SQLWhere .= ' AND TeamDivision = :division'; } if ($subgoalie == 0) { $SQLWhere .= ' AND (PlayerStatus <> "Sub Goalie" OR PlayerStatus IS NULL)'; } #Set Query for Skaterstats $Goaliestatquery = $pdoConnect->prepare($SQL.$SQLWhere.$SQLGroup); if ($currentseason != 0) { $Goaliestatquery->bindParam(':idseason', $currentseason, PDO::PARAM_INT); } elseif ($currentteam != 0) { $Goaliestatquery->bindParam(':teamid', $currentteam, PDO::PARAM_INT); } if ($currentsubseason != 0) { $Goaliestatquery->bindParam(':idsubseason', $currentsubseason, PDO::PARAM_INT); } if ($currentlevel != 0) { $Goaliestatquery->bindParam(':idlevel', $currentlevel, PDO::PARAM_INT); } if (!empty($currentdivision)) { $Goaliestatquery->bindParam(':division', $currentdivision, PDO::PARAM_STR); } $Goaliestatquery->execute(); #Prepare Output for HTML $playerleader = ''; while($row = $Goaliestatquery->fetch(PDO::FETCH_ASSOC)) { $playerleader .= ''; } $playerleader .= '
'.$header.' Leader
Team NamePlayerGP'.$header.'
'.$row['TeamName'].''.$row['PlayerFirst'].' '.$row['PlayerLast'].''.$row['PlayerStatus'].''.$row['SUM(GoalieGames)'].''.$row[$target].'
'; return $playerleader; } ?>