Goalie Stats

<?php

include_once 'connection.php';

#include 'header.php';
include 'goallinefunctionsJSON.php';

#include 'html.php';

$idplayer = (( isset( $_GET['playerid'] ) && is_numeric( $_GET['playerid'] ) ) ? intval( $_GET['playerid'] ) : 0 );
$idplayerassignment = ( isset( $_GET['playerteamid'] ) && is_numeric( $_GET['playerteamid'] ) ? intval( $_GET['playerteamid'] ) : 0);

function activeTeams($idplayerassignment) {
	$pdoConnect = createDBH();

	$seasonSelector = $pdoConnect->prepare('SELECT idSeasonkey FROM teamassignment JOIN playerassignment ON teamassignment.idTeamAssignment = playerassignment.idTeamAssignmentkey WHERE idPlayerAssignment = :playerassignment LIMIT 1');
	$seasonSelector->bindParam(':playerassignment', $idplayerassignment, PDO::PARAM_INT);
	$seasonSelector->execute();
	$seasonHistory = $seasonSelector->fetch(PDO::FETCH_ASSOC);
	$seasonHistoryID = $seasonHistory['idSeasonkey'];
	
	$playerhistoryFetch = $pdoConnect->prepare('SELECT idPlayers FROM players JOIN playerassignment ON playerassignment.idPlayerskey = players.idPlayers WHERE idPlayerAssignment = :playerassignment LIMIT 1');
	$playerhistoryFetch->bindParam(':playerassignment', $idplayerassignment, PDO::PARAM_INT);
	$playerhistoryFetch->execute();
	$idplayerset = $playerhistoryFetch->fetch(PDO::FETCH_ASSOC);
	$idplayer = $idplayerset['idPlayers'];
	
	$teamactiveFetch = $pdoConnect->prepare('SELECT idteamassignment, TeamName FROM teamassignment JOIN playerassignment ON teamassignment.idTeamAssignment = playerassignment.idTeamAssignmentkey JOIN team ON teamassignment.idteamkey = team.idteam WHERE idPlayerskey = :playerassignment AND idSeasonkey = :idSeason AND (PlayerStatus is NULL OR PlayerStatus <> "Sub Goalie")');
	$teamactiveFetch->bindParam(':playerassignment', $idplayer, PDO::PARAM_INT);
	$teamactiveFetch->bindParam(':idSeason', $seasonHistoryID, PDO::PARAM_INT);
	
	$teamactiveFetch->execute();
	$teamactiveOutput = '</br><table><thead><tr><th>Active Teams</th></tr></thead><tbody>';
	while ($row = $teamactiveFetch->fetch(PDO::FETCH_ASSOC))
		{$teamactiveOutput .= '<tr><td><a href="index.php?teamid='.$row['idteamassignment'].'">'.$row['TeamName'].'</td></tr>';}
	$teamactiveOutput .= '</tbody></table>';
return $teamactiveOutput;
}

function statsPlayer($currentgroup) {
	$pdoConnect = createDBH();
	
	$idplayer = ( isset( $_GET['playerid'] ) && is_numeric( $_GET['playerid'] ) ) ? intval( $_GET['playerid'] ) : 0;
	$idplayerassignment = ( isset( $_GET['playerteamid'] ) && is_numeric( $_GET['playerteamid'] ) ) ? intval( $_GET['playerteamid'] ) : 0;
	
	$playerfetchSELECT = 'SELECT PlayerLast, PlayerFirst, PlayerNumber, PlayerStatus, PlayerLine, PlayerPosition, SUM(PlayerGames), SUM(PlayerGoals), SUM(PlayerAssists), SUM(PlayerPoints), SUM(PlayerPIM), SUM(PlayerPN), SUM(PlayerPPG), SUM(PlayerSHG), SUM(PlayerPPP), SUM(PlayerSHP), SUM(PlayerGWG), SUM(PlayerGWP), SUM(PlayerGTG), SUM(PlayerGTP), SUM(PlayerOTG), SUM(PlayerOTP), SUM(PlayerENG), SUM(PlayerENP)';
	
	$playerfetchFROM = ' FROM playerassignment JOIN players ON playerassignment.idPlayerskey = players.idPlayers JOIN skaterstat ON playerassignment.idPlayerAssignment = skaterstat.idPlayerAssignment JOIN subseason ON skaterstat.idsubseasonkey = subseason.idsubseason ';
	
	
	if ($idplayerassignment != 0)
	{
		#Determine team history number to pull historical stats for just the team
		$teamhistoryFetch = $pdoConnect->prepare('SELECT idTeamkey FROM teamassignment JOIN playerassignment ON teamassignment.idTeamAssignment = playerassignment.idTeamAssignmentkey WHERE idPlayerAssignment = :playerassignment LIMIT 1');
		$teamhistoryFetch->bindParam(':playerassignment', $idplayerassignment, PDO::PARAM_INT);
		$teamhistoryFetch->execute();
		$teamHistory = $teamhistoryFetch->fetch(PDO::FETCH_ASSOC);
		$teamHistoryID = $teamHistory['idTeamkey'];
		
		$playerhistoryFetch = $pdoConnect->prepare('SELECT idPlayers FROM players JOIN playerassignment ON playerassignment.idPlayerskey = players.idPlayers WHERE idPlayerAssignment = :playerassignment LIMIT 1');
		$playerhistoryFetch->bindParam(':playerassignment', $idplayerassignment, PDO::PARAM_INT);
		$playerhistoryFetch->execute();
		$idplayerset = $playerhistoryFetch->fetch(PDO::FETCH_ASSOC);
		$idplayer = $idplayerset['idPlayers'];
		
		$playerfetchSELECT .= ', idSeason, SeasonDisplay, SubSeasonName, idTeamAssignment, TeamName'; 
		$playerfetchFROM .= ' JOIN teamassignment ON playerassignment.idTeamAssignmentkey = teamassignment.idTeamAssignment JOIN season ON teamassignment.idSeasonkey = season.idSeason JOIN team ON teamassignment.idTeamkey = team.idTeam';
		#$playerassignwhere = ' WHERE playerassignment.idPlayerAssignment = :playerassignment AND PlayerGames > 0';
		$playerassignwhere = ' WHERE playerassignment.idPlayerskey = :idplayer AND teamassignment.idTeamkey = :idteam';
		$playerassigngroup = ' GROUP BY idTeamAssignment';
		$playerassignorder = ' ORDER BY SeasonStart DESC, idsubseason ASC';		
	}
	elseif ($idplayer != 0)
	{
		$playerassignwhere = ' WHERE idPlayers = :idplayer';
		$playerfetchFROM .= ' JOIN teamassignment ON playerassignment.idTeamAssignmentkey = teamassignment.idTeamAssignment JOIN season ON teamassignment.idSeasonkey = season.idSeason JOIN team ON teamassignment.idTeamkey = team.idTeam JOIN teamstatassignment ON teamassignment.idTeamAssignment = teamstatassignment.idTeamAssignmentkey AND teamstatassignment.idsubseasonkey = skaterstat.idsubseasonkey JOIN level ON teamstatassignment.idLevelSeasonkey = level.idLevelSeason';
		$playerassignorder = ' ORDER BY SeasonStart DESC, idLevelSeason ASC, idsubseason DESC, PlayerGames DESC, TeamName ASC';
		
		if ($currentgroup == 'season') {
			$playerfetchSELECT .= ', idTeamAssignment, idSeason, SeasonDisplay, idLevelSeason, Level, TeamDivision, TeamName';
			$playerassigngroup = ' GROUP BY idTeamAssignment, idSeasonkey';
		} elseif ($currentgroup == 'subseason') {
			$playerfetchSELECT .= ', SubSeasonName';
			$playerassigngroup = ' GROUP BY skaterstat.idsubseasonkey';
			$playerassignorder = ' ORDER BY subseason.SortOrder DESC';
		} elseif ($currentgroup == 'seasonsubseason') {
			$playerfetchSELECT .= ', idTeamAssignment, idSeason, SeasonDisplay, SubSeasonName, idLevelSeason, Level, TeamDivision, TeamName';
			$playerassigngroup = ' GROUP BY idTeamAssignment, idSeasonkey, skaterstat.idsubseasonkey';
		}
	}

	$playerfetchSQL = $playerfetchSELECT.$playerfetchFROM.$playerassignwhere.$playerassigngroup.$playerassignorder;
	#echo $playerfetchSQL;
	$playerstatsfetch = $pdoConnect->prepare($playerfetchSQL);
	if ($idplayerassignment != 0)
	{
		#$playerstatsfetch->bindParam(':playerassignment', $idplayerassignment, PDO::PARAM_INT);
		$playerstatsfetch->bindParam(':idteam', $teamHistoryID, PDO::PARAM_INT);
	}
	#elseif ($idplayer != 0)
	#{
		$playerstatsfetch->bindParam(':idplayer', $idplayer, PDO::PARAM_INT);
	#}
	$playerstatsfetch->execute();

	$stattableheader = '<h5>Season Summary</h5><table id="playerstat" class="tablesorter"><caption>Skater Stats</caption><thead>';
	$stattableheaderitems = '<tr>';
	if ($idplayerassignment != 0) {$stattableheaderitems = '<th>Season</th>';}
	else {
		if ($currentgroup != 'subseason') {$stattableheaderitems = '<th>Season</th><th>Team Name</th><th>Level</th>';}
		if ($currentgroup != 'season') {$stattableheaderitems .= '<th>Subseason</th>';}
	}
	$stattableheaderitems .= '<th>Games Played</th><th>Goals</th><th>Assists</th><th>Points</th><th>PN</th><th>PIM</th><th>PPG</th><th>PPP</th><th>SHG</th><th>SHP</th><th>GWG</th><th>GWP</th><th>GTG</th><th>GTP</th><th>OTG</th><th>OTP</th><th>ENG</th><th>ENP</th></tr></thead><tbody>';
	#Grand total Array 
	$GrandTotal = array('games'=>0, 'goals'=>0, 'assists'=>0, 'points'=>0, 'pn'=>0, 'pim'=>0, 'ppg'=>0, 'ppp'=>0, 'shg'=>0, 'shp'=>0, 'gwg'=>0, 'gwp'=>0, 'gtg'=>0, 'gtp'=>0, 'otg'=>0, 'otp'=>0, 'eng'=>0, 'enp'=>0, 'enp'=>0);
	$stattablestart = '';
	while ($row = $playerstatsfetch->fetch(PDO::FETCH_ASSOC))
	{
		$stattablestart .= '<tr>';
		if ($idplayerassignment != 0) {$stattablestart .= '<td><a href="index.php?seasonid='.$row['idSeason'].'">'.$row['SeasonDisplay'].'</a></td>';}
		else {
			if ($currentgroup != 'subseason') 
				{$stattablestart .= '<td><a href="index.php?seasonid='.$row['idSeason'].'">'.$row['SeasonDisplay'].'</a></td>
				<td><a href="index.php?teamid='.$row['idTeamAssignment'].'">'.$row['TeamName'].'</a></td>
				<td><a href="index.php?seasonid='.$row['idSeason'].'&levelid='.$row['idLevelSeason'].'&divid='.$row['TeamDivision'].'">'.$row['Level'].' '.$row['TeamDivision'].'</a></td>';}
			if ($currentgroup != 'season') {$stattablestart .= '<td>'.$row['SubSeasonName'].'</td>';}
		}
		$stattablestart .= '<td>'.$row['SUM(PlayerGames)'].'</td><td>'.$row['SUM(PlayerGoals)'].'</td><td>'.$row['SUM(PlayerAssists)'].'</td><td>'.$row['SUM(PlayerPoints)'].'</td><td>'.$row['SUM(PlayerPN)'].'</td><td>'.$row['SUM(PlayerPIM)'].'</td><td>'.$row['SUM(PlayerPPG)'].'</td><td>'.$row['SUM(PlayerPPP)'].'</td><td>'.$row['SUM(PlayerSHG)'].'</td><td>'.$row['SUM(PlayerSHP)'].'</td><td>'.$row['SUM(PlayerGWG)'].'</td><td>'.$row['SUM(PlayerGWP)'].'</td><td>'.$row['SUM(PlayerGTG)'].'</td><td>'.$row['SUM(PlayerGTP)'].'</td><td>'.$row['SUM(PlayerOTG)'].'</td><td>'.$row['SUM(PlayerOTP)'].'</td><td>'.$row['SUM(PlayerENG)'].'</td><td>'.$row['SUM(PlayerENP)'].'</td></tr>';
		$GrandTotal['games'] = $row['SUM(PlayerGames)']+$GrandTotal['games'];
		$GrandTotal['goals'] = $row['SUM(PlayerGoals)']+$GrandTotal['goals'];
		$GrandTotal['assists'] = $row['SUM(PlayerAssists)']+$GrandTotal['assists'];
		$GrandTotal['points'] = $row['SUM(PlayerPoints)']+$GrandTotal['points'];
		$GrandTotal['pn'] = $row['SUM(PlayerPN)']+$GrandTotal['pn'];
		$GrandTotal['pim'] = $row['SUM(PlayerPIM)']+$GrandTotal['pim'];
		$GrandTotal['ppg'] = $row['SUM(PlayerPPG)']+$GrandTotal['ppg'];
		$GrandTotal['ppp'] = $row['SUM(PlayerPPP)']+$GrandTotal['ppp'];
		$GrandTotal['shg'] = $row['SUM(PlayerSHG)']+$GrandTotal['shg'];
		$GrandTotal['shp'] = $row['SUM(PlayerSHP)']+$GrandTotal['shp'];
		$GrandTotal['gwg'] = $row['SUM(PlayerGWG)']+$GrandTotal['gwg'];
		$GrandTotal['gwp'] = $row['SUM(PlayerGWP)']+$GrandTotal['gwp'];
		$GrandTotal['gtg'] = $row['SUM(PlayerGTG)']+$GrandTotal['gtg'];
		$GrandTotal['gtp'] = $row['SUM(PlayerGTP)']+$GrandTotal['gtp'];
		$GrandTotal['otg'] = $row['SUM(PlayerOTG)']+$GrandTotal['otg'];
		$GrandTotal['otp'] = $row['SUM(PlayerOTP)']+$GrandTotal['otp'];
		$GrandTotal['eng'] = $row['SUM(PlayerENG)']+$GrandTotal['eng'];
		$GrandTotal['enp'] = $row['SUM(PlayerENP)']+$GrandTotal['enp'];
	}
	#Insert Grand Total Row
	$stattablestart .= '<tr id="grandtotal"><td>Totals</td>';
	if ($idplayerassignment == 0) {
		if ($currentgroup != 'subseason') {$stattablestart .= '<td></td><td></td>';}
		if ($currentgroup == 'seasonsubseason') {$stattablestart .= '<td></td>';}
	}
	$stattablestart .= '<td>'.$GrandTotal['games'].'</td><td>'.$GrandTotal['goals'].'</td><td>'.$GrandTotal['assists'].'</td><td>'.$GrandTotal['points'].'</td><td>'.$GrandTotal['pn'].'</td><td>'.$GrandTotal['pim'].'</td><td>'.$GrandTotal['ppg'].'</td><td>'.$GrandTotal['ppp'].'</td><td>'.$GrandTotal['shg'].'</td><td>'.$GrandTotal['shp'].'</td><td>'.$GrandTotal['gwg'].'</td><td>'.$GrandTotal['gwp'].'</td><td>'.$GrandTotal['gtg'].'</td><td>'.$GrandTotal['gtp'].'</td><td>'.$GrandTotal['otg'].'</td><td>'.$GrandTotal['otp'].'</td><td>'.$GrandTotal['eng'].'</td><td>'.$GrandTotal['enp'].'</td></tr>';
	#Finish Grand Total Row
	$stattablefooter = '</tbody></table>';
	$playerstatbody = $stattableheader.$stattableheaderitems.$stattablestart.$stattablefooter;
return $playerstatbody;
}

function statsGoalie($currentgroup) {
	##Start Goalie Fetch
	$idplayer = ( isset( $_GET['playerid'] ) && is_numeric( $_GET['playerid'] ) ) ? intval( $_GET['playerid'] ) : 0;
	$idplayerassignment = ( isset( $_GET['playerteamid'] ) && is_numeric( $_GET['playerteamid'] ) ) ? intval( $_GET['playerteamid'] ) : 0;
	$subgoalie = ( isset( $_GET['subgoalie'] ) && is_numeric( $_GET['subgoalie'] ) ) ? intval( $_GET['subgoalie'] ) : 2;
	
	$pdoConnect = createDBH();
	
	$goaliefetchSELECT = 'SELECT playerassignment.idPlayerAssignment AS playerassignid, idSeason, SeasonDisplay, SubSeasonName, TeamName, idTeamAssignment, PlayerFirst, PlayerLast, PlayerNumber, PlayerStatus, SUM(GoalieGames), SUM(GoalieShotsAgainst), SUM(GoalieGoalsAllowed), SUM(GoalieGoalsPP), SUM(GoalieGoalsSH), SUM(GoalieWins), SUM(GoalieLosses), SUM(GoalieTies), SUM(GoalieOTL), SUM(GoalieShutout), ((SUM(GoalieGoalsAllowed))-((SUM(GoalieGoalsPP))+(SUM(GoalieGoalsSH)))) AS GAEven, (SUM(GoalieGoalsAllowed))/(SUM(GoalieGames)) AS GAA, ((SUM(GoalieGoalsAllowed))-((SUM(GoalieGoalsPP))+(SUM(GoalieGoalsSH))))/(SUM(GoalieGames)) AS GAAEven, 1-((SUM(GoalieGoalsAllowed))/(SUM(GoalieShotsAgainst))) AS SavePercent';
	$goaliefetchFROM = ' FROM playerassignment JOIN players ON playerassignment.idPlayerskey = players.idPlayers JOIN goaliestat ON playerassignment.idPlayerAssignment = goaliestat.idPlayerAssignment JOIN subseason ON goaliestat.idsubseasonkey = subseason.idsubseason';

	if ($idplayerassignment != 0)
	{
		#Determine team history number to pull historical stats for just the team
		$teamhistoryFetch = $pdoConnect->prepare('SELECT idTeamkey FROM teamassignment JOIN playerassignment ON teamassignment.idTeamAssignment = playerassignment.idTeamAssignmentkey WHERE idPlayerAssignment = :playerassignment LIMIT 1');
		$teamhistoryFetch->bindParam(':playerassignment', $idplayerassignment, PDO::PARAM_INT);
		$teamhistoryFetch->execute();
		$teamHistory = $teamhistoryFetch->fetch(PDO::FETCH_ASSOC);
		$teamHistoryID = $teamHistory['idTeamkey'];
		
		$playerhistoryFetch = $pdoConnect->prepare('SELECT idPlayers FROM players JOIN playerassignment ON playerassignment.idPlayerskey = players.idPlayers WHERE idPlayerAssignment = :playerassignment LIMIT 1');
		$playerhistoryFetch->bindParam(':playerassignment', $idplayerassignment, PDO::PARAM_INT);
		$playerhistoryFetch->execute();
		$idplayerset = $playerhistoryFetch->fetch(PDO::FETCH_ASSOC);
		$idplayer = $idplayerset['idPlayers'];
		
		$goaliefetchSELECT .= ', idSeason, SeasonDisplay, SubSeasonName, idTeamAssignment, TeamName'; 
		$goaliefetchFROM .= ' JOIN teamassignment ON playerassignment.idTeamAssignmentkey = teamassignment.idTeamAssignment JOIN season ON teamassignment.idSeasonkey = season.idSeason JOIN team ON teamassignment.idTeamkey = team.idTeam';
		#$goaliewhere = ' WHERE playerassignment.idPlayerAssignment = :playerassignment AND GoalieGames > 0';
		$goaliewhere = ' WHERE playerassignment.idPlayerskey = :idplayer AND teamassignment.idTeamkey = :idteam';
		$goaliegroupby = ' GROUP BY idTeamAssignment';
		$goalieassignorder = ' ORDER BY SeasonStart DESC, idsubseason ASC';		
	}
	elseif ($idplayer != 0)
	{
		$goaliefetchFROM .= ' JOIN teamassignment ON playerassignment.idTeamAssignmentkey = teamassignment.idTeamAssignment JOIN season ON teamassignment.idSeasonkey = season.idSeason JOIN team ON teamassignment.idTeamkey = team.idTeam JOIN teamstatassignment ON teamassignment.idTeamAssignment = teamstatassignment.idTeamAssignmentkey AND teamstatassignment.idsubseasonkey = goaliestat.idsubseasonkey JOIN level ON teamstatassignment.idLevelSeasonkey = level.idLevelSeason';
		$goaliewhere = ' WHERE idPlayers = :idplayer';
		$goalieassignorder = ' ORDER BY SeasonStart DESC, idLevelSeason ASC, subseason.SortOrder DESC, GoalieGames DESC, TeamName ASC';
		if ($subgoalie == 0) {$goaliewhere .= ' AND (PlayerStatus <> "Sub Goalie" OR PlayerStatus IS NULL)';}
		elseif ($subgoalie == 1) {$goaliewhere .= ' AND PlayerStatus = "Sub Goalie"';}
		elseif ($subgoalie == 2) {$goaliewhere .= '';}
		
		
		if ($currentgroup == 'season') {
			$goaliefetchSELECT .= ', idSeason, SeasonDisplay, idLevelSeason, Level, TeamDivision, TeamName';
			$goaliegroupby = ' GROUP BY idTeamAssignment, idSeasonkey';
		} elseif ($currentgroup == 'subseason') {
			$goaliefetchSELECT .= ', SubSeasonName';
			$goaliegroupby = ' GROUP BY goaliestat.idsubseasonkey';
			$goalieassignorder = ' ORDER BY subseason.SortOrder DESC';
		} elseif ($currentgroup == 'seasonsubseason') {
			$goaliefetchSELECT .= ', idSeason, SeasonDisplay, SubSeasonName, Level, TeamDivision, TeamName';
			$goaliegroupby = ' GROUP BY idTeamAssignment, idSeasonkey, goaliestat.idsubseasonkey';
		}
	}
	
	$goaliefetchSQL = $goaliefetchSELECT.$goaliefetchFROM.$goaliewhere.$goaliegroupby.$goalieassignorder;
	#echo $goaliefetchSQL;
	$goaliestatsfetch = $pdoConnect->prepare($goaliefetchSQL);
	if ($idplayerassignment != 0)
	{
		#$goaliestatsfetch->bindParam(':playerassignment', $idplayerassignment, PDO::PARAM_INT);
		$goaliestatsfetch->bindParam(':idteam', $teamHistoryID, PDO::PARAM_INT);
	}
	#elseif ($idplayer != 0)
	#{
		$goaliestatsfetch->bindParam(':idplayer', $idplayer, PDO::PARAM_INT);
	#}
	$goaliestatsfetch->execute();
	$goalierowcount = $goaliestatsfetch->rowCount();
	if ($goalierowcount > 0)
	{
		$goaliestattable = '<h5>Season Summary</h5><table id="playergoaliestat" class="tablesorter"><caption>Goalie Stats</caption><thead><tr>';
		if ($idplayerassignment != 0) {$goaliestattable .= '<th>Season</th>';}
		else {
			if ($currentgroup != 'subseason') {$goaliestattable .= '<th>Season</th><th>Team Name</th><th>Level</th>';}
			if ($currentgroup != 'season') {$goaliestattable .= '<th>Subseason</th>';}
		}
		$goaliestattable .= '<th>Games Played</th><th>Wins</th><th>Losses</th><th>Ties</th><th>OTL</th><th>Shutouts</th><th>SA</th><th>GA</th><th>Save%</th><th>GAA</th><th>GA Even</th></tr></thead><tbody>';
		$goalieGrandTotal = array('games'=>0, 'wins'=>0, 'losses'=>0, 'ties'=>0, 'otl'=>0, 'shutout'=>0, 'sa'=>0, 'ga'=>0, 'gaeven'=>0);
		while ($row = $goaliestatsfetch->fetch(PDO::FETCH_ASSOC))
	{
		$goaliestattable .= '<tr>';
			if ($idplayerassignment != 0) {$goaliestattable .= '<td><a href="index.php?seasonid='.$row['idSeason'].'">'.$row['SeasonDisplay'].'</a></td>';}
			else {
				if ($currentgroup != 'subseason') 
				{$goaliestattable .= '<td><a href="index.php?seasonid='.$row['idSeason'].'">'.$row['SeasonDisplay'].'</a></td>
				<td><a href="index.php?teamid='.$row['idTeamAssignment'].'">'.$row['TeamName'].'</a></td><td><a href="index.php?seasonid='.$row['idSeason'].'&levelid='.$row['idLevelSeason'].'">'.$row['Level'].' '.$row['TeamDivision'].'</a></td>';}
				if ($currentgroup != 'season') {$goaliestattable .= '<td>'.$row['SubSeasonName'].'</td>';}
			}
			$goaliestattable .= '<td>'.$row['SUM(GoalieGames)'].'</td>
			<td>'.$row['SUM(GoalieWins)'].'</td>
			<td>'.$row['SUM(GoalieLosses)'].'</td>
			<td>'.$row['SUM(GoalieTies)'].'</td>
			<td>'.$row['SUM(GoalieOTL)'].'</td>
			<td>'.$row['SUM(GoalieShutout)'].'</td>
			<td>'.$row['SUM(GoalieShotsAgainst)'].'</td>
			<td>'.$row['SUM(GoalieGoalsAllowed)'].'</td>
			<td>'.number_format($row['SavePercent'],3,'.','').'</td>
			<td>'.number_format($row['GAA'],2,'.','').'</td>
			<td>'.number_format($row['GAAEven'],2,'.','').'</td>
			</tr>';
			$goalieGrandTotal['games'] = $row['SUM(GoalieGames)']+$goalieGrandTotal['games'];
			$goalieGrandTotal['wins'] = $row['SUM(GoalieWins)']+$goalieGrandTotal['wins'];
			$goalieGrandTotal['losses'] = $row['SUM(GoalieLosses)']+$goalieGrandTotal['losses'];
			$goalieGrandTotal['ties'] = $row['SUM(GoalieTies)']+$goalieGrandTotal['ties'];
			$goalieGrandTotal['otl'] = $row['SUM(GoalieOTL)']+$goalieGrandTotal['otl'];
			$goalieGrandTotal['shutout'] = $row['SUM(GoalieShutout)']+$goalieGrandTotal['shutout'];
			$goalieGrandTotal['sa'] = $row['SUM(GoalieShotsAgainst)']+$goalieGrandTotal['sa'];
			$goalieGrandTotal['ga'] = $row['SUM(GoalieGoalsAllowed)']+$goalieGrandTotal['ga'];
			$goalieGrandTotal['gaeven'] = $row['GAEven']+$goalieGrandTotal['gaeven'];			
		}
		#Grand Total segment
		$goaliestattable .= '<tr id="grandtotal"><td>Total</td>';
		if ($idplayerassignment == 0) {
			if ($currentgroup != 'subseason') {$goaliestattable .= '<td></td><td></td>';}
			if ($currentgroup == 'seasonsubseason') {$goaliestattable .= '<td></td>';}
		}
		$goaliestattable .= '<td>'.$goalieGrandTotal['games'].'</td>
			<td>'.$goalieGrandTotal['wins'].'</td>
			<td>'.$goalieGrandTotal['losses'].'</td>
			<td>'.$goalieGrandTotal['ties'].'</td>
			<td>'.$goalieGrandTotal['otl'].'</td>
			<td>'.$goalieGrandTotal['shutout'].'</td>
			<td>'.$goalieGrandTotal['sa'].'</td>
			<td>'.$goalieGrandTotal['ga'].'</td>
			<td>'.number_format(1-($goalieGrandTotal['ga']/$goalieGrandTotal['sa']),3,'.','').'</td>
			<td>'.number_format($goalieGrandTotal['ga']/$goalieGrandTotal['games'],2,'.','').'</td>
			<td>'.number_format($goalieGrandTotal['gaeven']/$goalieGrandTotal['games'],2,'.','').'</td></tr>';
		$goaliestattable .= '</tbody></table>';	
	} else {$goaliestattable = NULL;}
return $goaliestattable;
}
		
function boxscoreGoalie() {
##Goalie Box Score Builder	
	$idplayer = ( isset( $_GET['playerid'] ) && is_numeric( $_GET['playerid'] ) ) ? intval( $_GET['playerid'] ) : 0;
	$idplayerassignment = ( isset( $_GET['playerteamid'] ) && is_numeric( $_GET['playerteamid'] ) ) ? intval( $_GET['playerteamid'] ) : 0;
	
	$pdoConnect = createDBH();
	
	$goalieboxSQLselect = 'SELECT idGame, GameDate, AwayTeamName.TeamName AS AwayTeamName, HomeTeamName.TeamName AS HomeTeamName, idPlayerAssignment, GoalieResult, GoalieShots, GoalieGoalsAllowed, 1-(SUM(GoalieGoalsAllowed)/SUM(GoalieShots)) AS SavePercent FROM game JOIN teamassignment AS HomeTeamFound ON game.HomeTeam = HomeTeamFound.idTeamAssignment JOIN team AS HomeTeamName ON HomeTeamFound.idTeamkey = HomeTeamName.idTeam JOIN teamassignment AS AwayTeamFound ON game.AwayTeam = AwayTeamFound.idTeamAssignment JOIN team AS AwayTeamName ON AwayTeamFound.idTeamkey = AwayTeamName.idTeam JOIN gamegoaliesave ON game.idGame = gamegoaliesave.idGamekey JOIN playerassignment ON gamegoaliesave.idPlayerAssignmentkey = playerassignment.idPlayerassignment JOIN players ON playerassignment.idPlayerskey = players.idPlayers';
	if ($idplayerassignment != 0)
	{
		$goalieboxSQLwhere = ' WHERE playerassignment.idPlayerAssignment = :playerassignment';
	}
	elseif ($idplayer != 0)
	{
		$goalieboxSQLwhere = ' WHERE idPlayers = :idplayer';
	}
	$goalieboxSQLorderby = ' GROUP BY idGame ORDER BY GameDate DESC';
	
	$goalieboxscorefetch = $pdoConnect->prepare($goalieboxSQLselect.$goalieboxSQLwhere.$goalieboxSQLorderby);
	if ($idplayerassignment != 0)
	{
		$goalieboxscorefetch->bindParam(':playerassignment', $idplayerassignment, PDO::PARAM_INT );
	}
	elseif ($idplayer != 0)
	{
		$goalieboxscorefetch->bindParam(':idplayer', $idplayer, PDO::PARAM_INT );
	}
	$goalieboxscorefetch->execute();
	$goaliebox = '<h1>Goalie Stats</h1><h5>Goalie Game Log</h5><table id="goalieboxscore"><thead><tr><th>Game</th><th>Date</th><th>Game Results</th><th>Shots Faced</th><th>Saves</th><th>Goals Allowed</th><th>Save%</th></tr></thead><tbody>';
	while ($goalieline=$goalieboxscorefetch->fetch(PDO::FETCH_ASSOC))
	{
		if ($idplayerassignment != 0 OR strtotime($goalieline['GameDate']) >= strtotime('-30 days'))
		{$goaliebox .= '<tr><td><a href="gamerecap.php?gameID='.$goalieline['idGame'].'">'.$goalieline['AwayTeamName'].' vs '.$goalieline['HomeTeamName'].'</a></td><td>'.$goalieline['GameDate'].'</td><td>'.$goalieline['GoalieResult'].'</td><td>'.$goalieline['GoalieShots'].'</td><td>'.($goalieline['GoalieShots']-$goalieline['GoalieGoalsAllowed']).'</td><td>'.$goalieline['GoalieGoalsAllowed'].'</td><td>'.number_format($goalieline['SavePercent'],3,'.','').'</td></tr>';}
	}
	$goaliebox .= '</tbody></table>';
return $goaliebox;
}

function boxscoreSkater() {
	$idplayer = ( isset( $_GET['playerid'] ) && is_numeric( $_GET['playerid'] ) ) ? intval( $_GET['playerid'] ) : 0;
	$idplayerassignment = ( isset( $_GET['playerteamid'] ) && is_numeric( $_GET['playerteamid'] ) ) ? intval( $_GET['playerteamid'] ) : 0;

	$pdoConnect = createDBH();
	
	$TeamArray = array();
	
	$GamesSQL = 'SELECT idGame, GameDate, AwayTeamName.TeamName AS AwayTeamName, HomeTeamName.TeamName AS HomeTeamName, idPlayerAssignment FROM game JOIN teamassignment AS HomeTeamFound ON game.HomeTeam = HomeTeamFound.idTeamAssignment JOIN team AS HomeTeamName ON HomeTeamFound.idTeamkey = HomeTeamName.idTeam JOIN teamassignment AS AwayTeamFound ON game.AwayTeam = AwayTeamFound.idTeamAssignment JOIN team AS AwayTeamName ON AwayTeamFound.idTeamkey = AwayTeamName.idTeam JOIN gameattendance ON game.idGame = gameattendance.idGamekey JOIN playerassignment ON gameattendance.Playerassignmentkey = playerassignment.idPlayerassignment';
	
	if ($idplayerassignment != 0) 
	{
		$playeridbox = $idplayerassignment;
		$GamesSQLPlayer = ' WHERE idPlayerAssignment = :idPlayer AND Attend = 1 ORDER BY GameDate DESC';
	}
	elseif ($idplayer != 0) 
	{
		$playeridbox = $idplayer;
		$GamesSQLPlayer = ' JOIN players ON playerassignment.idPlayerskey = players.idplayers WHERE idPlayers = :idPlayer AND Attend = 1 ORDER BY GameDate DESC';
	}
	
	$Games = $pdoConnect->prepare($GamesSQL.$GamesSQLPlayer);
	$Games->bindParam(':idPlayer', $playeridbox, PDO::PARAM_INT );
	$Games->execute();
	while($Gamesline=$Games->fetch(PDO::FETCH_ASSOC))
	{
		array_push($TeamArray, array('idGame' => $Gamesline['idGame'], 'Teams' => $Gamesline['AwayTeamName'].' vs. '.$Gamesline['HomeTeamName'],'GameDate' => $Gamesline['GameDate'], 'playergoals' => 0, 'playerassists' => 0, 'playerppg' => 0, 'playershg' => 0, 'playerPN' => 0, 'playerPIM' => 0));
	}
	$Assists = $pdoConnect->prepare('SELECT idGamekey FROM gameevents JOIN goalevent ON gameevents.idGameEvents = goalevent.idGameEvents WHERE PlayerAssist IS NOT NULL AND (PlayerAssist = :idPlayer OR PlayerAssist2 = :idPlayer)');
	$Assists->bindParam(':idPlayer', $playeridbox, PDO::PARAM_INT );
	$Assists->execute();
	if ($Assists->rowCount() != 0)
	{while ($Assistrow = $Assists->fetch(PDO::FETCH_ASSOC))
		{foreach ($TeamArray as &$array)
			{if ($array['idGame'] == $Assistrow['idGamekey'])
				{$array['playerassists'] ++;}
			}
		} unset($array);
	}
	$Goals = $pdoConnect->prepare('SELECT idGamekey, goalclasskey FROM gameevents JOIN goalevent ON gameevents.idGameEvents = goalevent.idGameEvents  LEFT JOIN (SELECT idgoalclassevent, goaleventkey, goalclasskey FROM goalclassevent WHERE goalclasskey = 2 OR goalclasskey = 3) AS goalclasspossible ON goalevent.idGameEvents = goalclasspossible.goaleventkey WHERE GoalScorer = :idPlayer');
	$Goals->bindParam(':idPlayer', $playeridbox, PDO::PARAM_INT );
	$Goals->execute();
	if ($Goals->rowCount() != 0)
	{while ($Goalsrow = $Goals->fetch(PDO::FETCH_ASSOC))
		{foreach ($TeamArray as &$array)
			{if ($array['idGame'] == $Goalsrow['idGamekey'])
				{$array['playergoals'] ++;
					if ($Goalsrow['goalclasskey'] == 2)
						{$array['playerppg'] ++;}
					if ($Goalsrow['goalclasskey'] == 3)
						{$array['playershg'] ++;}
				}
			}
		} unset($array);
	}
	$Penalties = $pdoConnect->prepare('SELECT idGamekey, PenaltyLength FROM gameevents JOIN penaltyevent ON gameevents.idGameEvents = penaltyevent.idGameEvents WHERE idPlayerAssignmentkey = :idPlayer');
	$Penalties->bindParam(':idPlayer', $playeridbox, PDO::PARAM_INT );
	$Penalties->execute();
	{while ($Penaltyrow = $Penalties->fetch(PDO::FETCH_ASSOC))
		{foreach ($TeamArray as &$array)
			{if ($array['idGame'] == $Penaltyrow['idGamekey'])
				{$array['playerPN'] ++;
				$array['playerPIM'] = $array['playerPIM'] + $Penaltyrow['PenaltyLength'];}
			}
		} unset($array);
	}
	$boxtable = '<h1>Skater Stats</h1><h5>Game Log</h5><table id="'.$playeridbox.'boxscore"><thead><tr><th>Game</th><th>Date</th><th>Goals</th><th>Assists</th><th>Points</th><th>PPG</th><th>SHG</th><th>PN</th><th>PIM</th></thead><tbody>';
	foreach ($TeamArray as $array)
	{
		if ($idplayerassignment != 0 OR strtotime($array['GameDate']) >= strtotime('-30 days'))
		{$boxtable .= '<tr><td><a href="gamerecap.php?gameID='.$array['idGame'].'">'.$array['Teams'].'</a></td><td>'.$array['GameDate'].'</td><td>'.$array['playergoals'].'</td><td>'.$array['playerassists'].'</td><td>'.($array['playergoals']+$array['playerassists']).'</td><td>'.$array['playerppg'].'</td><td>'.$array['playershg'].'</td><td>'.$array['playerPN'].'</td><td>'.$array['playerPIM'].'</td></tr>';}
	}
	$boxtable .= '</tbody></table>';
	return $boxtable;
}

function getPlayerUpdate($playerid, $playerteamid) {
	$pdoConnect = createNDBH();
	
	$fetchPlayerUpdateSQLSelect = 'SELECT idNews, NewsDate, NewsTitle, NewsItem, NewsAuthor, NewsAuthorLink, Target, Targetid, TargetDivision FROM news JOIN newsdeliver ON news.idNews = newsdeliver.NewsidRef WHERE Targetid = :targetid AND newsApprove = 1 AND NewsDate <= CURDATE() AND NewsDate > CURDATE()-INTERVAL 31 DAY';
	$fetchPlayerUpdateSQLOrder = ' ORDER BY NewsDate DESC LIMIT 5';
	
	if (!empty($playerid)) {
		$fetchPlayerUpdateSQLWhere = ' AND Target = "player"';
		$targetid = $playerid;
	} elseif (!empty($playerteamid)) {
		$fetchPlayerUpdateSQLWhere = ' AND Target = "playerteam"';
		$targetid = $playerteamid;
	}
	$fetchPlayerUpdateSQL = $fetchPlayerUpdateSQLSelect.$fetchPlayerUpdateSQLWhere.$fetchPlayerUpdateSQLOrder;
	
	$fetchUpdatePlayer = $pdoConnect->prepare($fetchPlayerUpdateSQL);
	$fetchUpdatePlayer->bindParam(':targetid', $targetid, PDO::PARAM_INT );
	$fetchUpdatePlayer->execute();
	$fetchedUpdates = $fetchUpdatePlayer->fetchAll(PDO::FETCH_ASSOC);
	
return $fetchedUpdates;
}

$prepcontent = '';

$idplayer = ( isset( $_GET['playerid'] ) && is_numeric( $_GET['playerid'] ) ) ? intval( $_GET['playerid'] ) : 0;
$idplayerassignment = ( isset( $_GET['playerteamid'] ) && is_numeric( $_GET['playerteamid'] ) ) ? intval( $_GET['playerteamid'] ) : 0;

$baselink = (isset($idplayer)) ? 'playerid='.$idplayer : 'playerteamid='.$idplayerassignment;

$currentgroup = (isset($_GET['group'])) ? $_GET['group'] : 'season';

$playersUpdates = getPlayerUpdate($idplayer, $idplayerassignment);

$newssection = '';
$splitcondition = isset($_GET['split']) ? $_GET['split'] : 'standard';

if (!empty($playersUpdates)) {
	$newsSectionHeader = '<h1>Player Updates</h1>';
	$NewsSectionBody = '';
	if ($idplayer > 0) {$NewsLink = '&playerid='.$idplayer;}
	elseif ($idplayerassignment > 0) {$NewsLink = '&playerteamid='.$idplayerassignment;}
	foreach ($playersUpdates as $news) {
		$ConvertDate = date("M d, Y", strtotime($news['NewsDate']));
		$NewsArticle = '<h4><a href="news.php?newsid='.$news['idNews'].$NewsLink.'">'.$news['NewsTitle'].'</a></h4>Posted by '.$news['NewsAuthor'].' on '.$ConvertDate;
		$NewsArticle = divBuilder('newsarticle','class',$NewsArticle);
		$NewsSectionBody .= $NewsArticle;
	}
	$newssection = divBuilder('newssection','id',$newsSectionHeader.$NewsSectionBody);
	$prepcontent .= $newssection;
}

#$skaterstat = statsPlayer($currentgroup);
$skaterbox = boxscoreskater();
/*
$goaliestat = statsGoalie($currentgroup);
if (!empty($goaliestat)) {
	$goaliebox = boxscoreGoalie();
	$subgoaliefilter = divBuilder('SubGoalie','id', '<a href="playercard.php?'.$baselink.'&subgoalie=2">Overall</a> | <a href="playercard.php?'.$baselink.'&subgoalie=0">Starting Goalie</a> | <a href="playercard.php?'.$baselink.'&subgoalie=1">Sub Goalie</a>');
	#Pulls data into goalie div sections
	$GoalieBoxStatDiv = divBuilder('GoalieBoxStat','id',$goaliebox);
	$GoalieSeasonStatDiv = divBuilder('GoalieSeasonStat','id',$goaliestat);
	$prepcontent .= $subgoaliefilter."\n\r".$GoalieBoxStatDiv."\n\r".$groupgoalieSelect."\n\r".$GoalieSeasonStatDiv;
} else {$goaliebox = NULL;}
*/
/*
if ($idplayer > 0) {
$groupSelect = '<a href="playercard.php?'.$baselink.'&group=season">Season Totals</a> | <a href="playercard.php?'.$baselink.'&group=seasonsubseason">Show Subseason Breakdown</a> | <a href="playercard.php?'.$baselink.'&group=subseason">Subseason Totals</a>';
} else {$groupSelect = '';}
*/
#Add HTML Header
#$HTMLstart = HTMLHeader(NULL);
/*
#Skater Box Score and Season Score sections
$SkaterBoxStatDiv = divBuilder('SkaterBoxStat','id',$skaterbox);
$SkaterSeasonStatDiv = divBuilder('SkaterSeasonStat','id', $skaterstat);
$prepcontent .= $SkaterBoxStatDiv."\n\r".$SkaterSeasonStatDiv;
*/
#Search for all active teams if idplayerassignment is selected

/*
if ($idplayerassignment != 0) 
{
	$activeteamList = activeTeams($idplayerassignment);
	$activeteamDiv = divBuilder('activeTeam','id',$activeteamList);
	$prepcontent .= $activeteamDiv;
}
*/
#Adds maincontent div and echos out
#$MainContentDiv = divBuilder('sectionblock','class',$groupSelect."\n\r".$prepcontent);

#Final Output
#$Header = HTMLHeader(NULL);
#$TotalContainer = divBuilder('container','id',$HeaderDiv.$MainContentDiv);

#echo $Header;
#echo $TotalContainer;
/*
$step = $_GET['step'];
switch($step) {
	case 1: 
	statsPlayer($currentgroup);
	break;
	case 2:
	statsGoalie($currentgroup);
	break;
}
*/
#include 'footer.php';

function JSONstatsPlayer($currentgroup) {
	$pdoConnect = createDBH();
	
	$idplayer = ( isset( $_GET['playerid'] ) && is_numeric( $_GET['playerid'] ) ) ? intval( $_GET['playerid'] ) : 0;
	$idplayerassignment = ( isset( $_GET['playerteamid'] ) && is_numeric( $_GET['playerteamid'] ) ) ? intval( $_GET['playerteamid'] ) : 0;
	
	$playerfetchSELECT = 'SELECT PlayerLast, PlayerFirst, PlayerNumber, PlayerStatus, PlayerLine, PlayerPosition, SUM(PlayerGames), SUM(PlayerGoals), SUM(PlayerAssists), SUM(PlayerPoints), SUM(PlayerPIM), SUM(PlayerPN), SUM(PlayerPPG), SUM(PlayerSHG), SUM(PlayerPPP), SUM(PlayerSHP), SUM(PlayerGWG), SUM(PlayerGWP), SUM(PlayerGTG), SUM(PlayerGTP), SUM(PlayerOTG), SUM(PlayerOTP), SUM(PlayerENG), SUM(PlayerENP)';
	
	$playerfetchFROM = ' FROM playerassignment JOIN players ON playerassignment.idPlayerskey = players.idPlayers JOIN skaterstat ON playerassignment.idPlayerAssignment = skaterstat.idPlayerAssignment JOIN subseason ON skaterstat.idsubseasonkey = subseason.idsubseason ';
	
	
	if ($idplayerassignment != 0)
	{
		#Determine team history number to pull historical stats for just the team
		$teamhistoryFetch = $pdoConnect->prepare('SELECT idTeamkey FROM teamassignment JOIN playerassignment ON teamassignment.idTeamAssignment = playerassignment.idTeamAssignmentkey WHERE idPlayerAssignment = :playerassignment LIMIT 1');
		$teamhistoryFetch->bindParam(':playerassignment', $idplayerassignment, PDO::PARAM_INT);
		$teamhistoryFetch->execute();
		$teamHistory = $teamhistoryFetch->fetch(PDO::FETCH_ASSOC);
		$teamHistoryID = $teamHistory['idTeamkey'];
		
		$playerhistoryFetch = $pdoConnect->prepare('SELECT idPlayers FROM players JOIN playerassignment ON playerassignment.idPlayerskey = players.idPlayers WHERE idPlayerAssignment = :playerassignment LIMIT 1');
		$playerhistoryFetch->bindParam(':playerassignment', $idplayerassignment, PDO::PARAM_INT);
		$playerhistoryFetch->execute();
		$idplayerset = $playerhistoryFetch->fetch(PDO::FETCH_ASSOC);
		$idplayer = $idplayerset['idPlayers'];
		
		$playerfetchSELECT .= ', idSeason, SeasonDisplay, SubSeasonName, idTeamAssignment, TeamName'; 
		$playerfetchFROM .= ' JOIN teamassignment ON playerassignment.idTeamAssignmentkey = teamassignment.idTeamAssignment JOIN season ON teamassignment.idSeasonkey = season.idSeason JOIN team ON teamassignment.idTeamkey = team.idTeam';
		#$playerassignwhere = ' WHERE playerassignment.idPlayerAssignment = :playerassignment AND PlayerGames > 0';
		$playerassignwhere = ' WHERE playerassignment.idPlayerskey = :idplayer AND teamassignment.idTeamkey = :idteam';
		$playerassigngroup = ' GROUP BY idTeamAssignment';
		$playerassignorder = ' ORDER BY SeasonStart DESC, idsubseason ASC';		
	}
	elseif ($idplayer != 0)
	{
		$playerassignwhere = ' WHERE idPlayers = :idplayer';
		$playerfetchFROM .= ' JOIN teamassignment ON playerassignment.idTeamAssignmentkey = teamassignment.idTeamAssignment JOIN season ON teamassignment.idSeasonkey = season.idSeason JOIN team ON teamassignment.idTeamkey = team.idTeam JOIN teamstatassignment ON teamassignment.idTeamAssignment = teamstatassignment.idTeamAssignmentkey AND teamstatassignment.idsubseasonkey = skaterstat.idsubseasonkey JOIN level ON teamstatassignment.idLevelSeasonkey = level.idLevelSeason';
		$playerassignorder = ' ORDER BY SeasonStart DESC, idLevelSeason ASC, idsubseason DESC, PlayerGames DESC, TeamName ASC';
		
		if ($currentgroup == 'season') {
			$playerfetchSELECT .= ', idTeamAssignment, idSeason, SeasonDisplay, idLevelSeason, Level, TeamDivision, TeamName';
			$playerassigngroup = ' GROUP BY idTeamAssignment, idSeasonkey';
		} elseif ($currentgroup == 'subseason') {
			$playerfetchSELECT .= ', SubSeasonName';
			$playerassigngroup = ' GROUP BY skaterstat.idsubseasonkey';
			$playerassignorder = ' ORDER BY subseason.SortOrder DESC';
		} elseif ($currentgroup == 'seasonsubseason') {
			$playerfetchSELECT .= ', idTeamAssignment, idSeason, SeasonDisplay, SubSeasonName, idLevelSeason, Level, TeamDivision, TeamName';
			$playerassigngroup = ' GROUP BY idTeamAssignment, idSeasonkey, skaterstat.idsubseasonkey';
		}
	}

	$playerfetchSQL = $playerfetchSELECT.$playerfetchFROM.$playerassignwhere.$playerassigngroup.$playerassignorder;
	#echo $playerfetchSQL;
	$playerstatsfetch = $pdoConnect->prepare($playerfetchSQL);
	if ($idplayerassignment != 0)
	{
		#$playerstatsfetch->bindParam(':playerassignment', $idplayerassignment, PDO::PARAM_INT);
		$playerstatsfetch->bindParam(':idteam', $teamHistoryID, PDO::PARAM_INT);
	}
	#elseif ($idplayer != 0)
	#{
		$playerstatsfetch->bindParam(':idplayer', $idplayer, PDO::PARAM_INT);
	#}
	$playerstatsfetch->execute();
	$getSkaterStats = $playerstatsfetch->fetchAll(PDO::FETCH_ASSOC);

	$fetchedPlayerStats = $getSkaterStats[0];
	$outputArray = array();

	$startGrandTotal = array('Grand Total' => 'Grand Total');
	if ($idplayerassignment == 0) {
		if ($currentgroup != 'subseason') {
			$startGrandTotal += ['Team' => '', 'teamid' => '', 'Level' =>''];
		}
		if ($currentgroup == 'seasonsubseason') {
			$startGrandTotal += ['extra' => ''];
		}
	}
	
	$StatTemplate = array('GP'=>0, 'G'=>0, 'A'=>0, 'Pts'=>0, 'PN'=>0, 'PIM'=>0, 'PPG'=>0, 'PPP'=>0, 'SHG'=>0, 'SHP'=>0, 'GWG'=>0, 'GWP'=>0, 'GTP'=>0, 'GTG'=>0, 'OTG'=>0, 'OTP'=>0, 'ENG'=>0, 'ENP'=>0);
	$GrandTotal = $startGrandTotal+$StatTemplate;
	
	foreach ($getSkaterStats as $row)
	{
		$startDataRow = array();
		if ($idplayerassignment != 0) {
			$startDataRow += ['Season' => $row['SeasonDisplay']];
		}
		else {
			if ($currentgroup != 'subseason') {
				$startDataRow += ['Season' => $row['SeasonDisplay'], 'Team' => $row['TeamName'], 'teamid' => $row['idTeamAssignment'], 'Level' => $row['Level'].' '.$row['TeamDivision']];
			}
			if ($currentgroup != 'season') {
				$startDataRow += ['Subseason' => $row['SubSeasonName']];
			}
		}
		
		$dataRow = array();
		
		$dataRow += ['GP'=> $row['SUM(PlayerGames)'], 'G'=>$row['SUM(PlayerGoals)'], 'A'=> $row['SUM(PlayerAssists)'], 'Pts'=>$row['SUM(PlayerPoints)'], 'PN'=>$row['SUM(PlayerPN)'], 'PIM'=>$row['SUM(PlayerPIM)'], 'PPG'=>$row['SUM(PlayerPPG)'], 'PPP'=>$row['SUM(PlayerPPP)'], 'SHG'=>$row['SUM(PlayerSHG)'], 'SHP'=>$row['SUM(PlayerSHP)'], 'GWG'=>$row['SUM(PlayerGWG)'], 'GWP'=>$row['SUM(PlayerGWP)'], 'GTG'=>$row['SUM(PlayerGTG)'], 'GTP'=>$row['SUM(PlayerGTP)'], 'OTG'=>$row['SUM(PlayerOTG)'], 'OTP'=>$row['SUM(PlayerOTP)'], 'ENG'=>$row['SUM(PlayerENG)'], 'ENP'=> $row['SUM(PlayerENP)']];
		$GrandTotal['GP'] = $row['SUM(PlayerGames)']+$GrandTotal['GP'];
		$GrandTotal['G'] = $row['SUM(PlayerGoals)']+$GrandTotal['G'];
		$GrandTotal['A'] = $row['SUM(PlayerAssists)']+$GrandTotal['A'];
		$GrandTotal['Pts'] = $row['SUM(PlayerPoints)']+$GrandTotal['Pts'];
		$GrandTotal['PN'] = $row['SUM(PlayerPN)']+$GrandTotal['PN'];
		$GrandTotal['PIM'] = $row['SUM(PlayerPIM)']+$GrandTotal['PIM'];
		$GrandTotal['PPG'] = $row['SUM(PlayerPPG)']+$GrandTotal['PPG'];
		$GrandTotal['PPP'] = $row['SUM(PlayerPPP)']+$GrandTotal['PPP'];
		$GrandTotal['SHG'] = $row['SUM(PlayerSHG)']+$GrandTotal['SHG'];
		$GrandTotal['SHP'] = $row['SUM(PlayerSHP)']+$GrandTotal['SHP'];
		$GrandTotal['GWG'] = $row['SUM(PlayerGWG)']+$GrandTotal['GWG'];
		$GrandTotal['GWP'] = $row['SUM(PlayerGWP)']+$GrandTotal['GWP'];
		$GrandTotal['GTG'] = $row['SUM(PlayerGTG)']+$GrandTotal['GTG'];
		$GrandTotal['GTP'] = $row['SUM(PlayerGTP)']+$GrandTotal['GTP'];
		$GrandTotal['OTG'] = $row['SUM(PlayerOTG)']+$GrandTotal['OTG'];
		$GrandTotal['OTP'] = $row['SUM(PlayerOTP)']+$GrandTotal['OTP'];
		$GrandTotal['ENG'] = $row['SUM(PlayerENG)']+$GrandTotal['ENG'];
		$GrandTotal['ENP'] = $row['SUM(PlayerENP)']+$GrandTotal['ENP'];

		$outputArray[] = $startDataRow+$dataRow;
	}
	
	$outputArray[] = $GrandTotal;
	#Finish Grand Total Row
	
return $outputArray;
}

function JSONstatsGoalie($currentgroup) {
	##Start Goalie Fetch
	$idplayer = ( isset( $_GET['playerid'] ) && is_numeric( $_GET['playerid'] ) ) ? intval( $_GET['playerid'] ) : 0;
	$idplayerassignment = ( isset( $_GET['playerteamid'] ) && is_numeric( $_GET['playerteamid'] ) ) ? intval( $_GET['playerteamid'] ) : 0;
	$subgoalie = ( isset( $_GET['subgoalie'] ) && is_numeric( $_GET['subgoalie'] ) ) ? intval( $_GET['subgoalie'] ) : 2;
	
	$pdoConnect = createDBH();
	
	$goaliefetchSELECT = 'SELECT playerassignment.idPlayerAssignment AS playerassignid, idSeason, SeasonDisplay, SubSeasonName, TeamName, idTeamAssignment, PlayerFirst, PlayerLast, PlayerNumber, PlayerStatus, SUM(GoalieGames), SUM(GoalieShotsAgainst), SUM(GoalieGoalsAllowed), SUM(GoalieGoalsPP), SUM(GoalieGoalsSH), SUM(GoalieWins), SUM(GoalieLosses), SUM(GoalieTies), SUM(GoalieOTL), SUM(GoalieShutout), ((SUM(GoalieGoalsAllowed))-((SUM(GoalieGoalsPP))+(SUM(GoalieGoalsSH)))) AS GAEven, (SUM(GoalieGoalsAllowed))/(SUM(GoalieGames)) AS GAA, ((SUM(GoalieGoalsAllowed))-((SUM(GoalieGoalsPP))+(SUM(GoalieGoalsSH))))/(SUM(GoalieGames)) AS GAAEven, 1-((SUM(GoalieGoalsAllowed))/(SUM(GoalieShotsAgainst))) AS SavePercent';
	$goaliefetchFROM = ' FROM playerassignment JOIN players ON playerassignment.idPlayerskey = players.idPlayers JOIN goaliestat ON playerassignment.idPlayerAssignment = goaliestat.idPlayerAssignment JOIN subseason ON goaliestat.idsubseasonkey = subseason.idsubseason';

	if ($idplayerassignment != 0)
	{
		#Determine team history number to pull historical stats for just the team
		$teamhistoryFetch = $pdoConnect->prepare('SELECT idTeamkey FROM teamassignment JOIN playerassignment ON teamassignment.idTeamAssignment = playerassignment.idTeamAssignmentkey WHERE idPlayerAssignment = :playerassignment LIMIT 1');
		$teamhistoryFetch->bindParam(':playerassignment', $idplayerassignment, PDO::PARAM_INT);
		$teamhistoryFetch->execute();
		$teamHistory = $teamhistoryFetch->fetch(PDO::FETCH_ASSOC);
		$teamHistoryID = $teamHistory['idTeamkey'];
		
		$playerhistoryFetch = $pdoConnect->prepare('SELECT idPlayers FROM players JOIN playerassignment ON playerassignment.idPlayerskey = players.idPlayers WHERE idPlayerAssignment = :playerassignment LIMIT 1');
		$playerhistoryFetch->bindParam(':playerassignment', $idplayerassignment, PDO::PARAM_INT);
		$playerhistoryFetch->execute();
		$idplayerset = $playerhistoryFetch->fetch(PDO::FETCH_ASSOC);
		$idplayer = $idplayerset['idPlayers'];
		
		$goaliefetchSELECT .= ', idSeason, SeasonDisplay, SubSeasonName, idTeamAssignment, TeamName'; 
		$goaliefetchFROM .= ' JOIN teamassignment ON playerassignment.idTeamAssignmentkey = teamassignment.idTeamAssignment JOIN season ON teamassignment.idSeasonkey = season.idSeason JOIN team ON teamassignment.idTeamkey = team.idTeam';
		#$goaliewhere = ' WHERE playerassignment.idPlayerAssignment = :playerassignment AND GoalieGames > 0';
		$goaliewhere = ' WHERE playerassignment.idPlayerskey = :idplayer AND teamassignment.idTeamkey = :idteam';
		$goaliegroupby = ' GROUP BY idTeamAssignment';
		$goalieassignorder = ' ORDER BY SeasonStart DESC, idsubseason ASC';		
	}
	elseif ($idplayer != 0)
	{
		$goaliefetchFROM .= ' JOIN teamassignment ON playerassignment.idTeamAssignmentkey = teamassignment.idTeamAssignment JOIN season ON teamassignment.idSeasonkey = season.idSeason JOIN team ON teamassignment.idTeamkey = team.idTeam JOIN teamstatassignment ON teamassignment.idTeamAssignment = teamstatassignment.idTeamAssignmentkey AND teamstatassignment.idsubseasonkey = goaliestat.idsubseasonkey JOIN level ON teamstatassignment.idLevelSeasonkey = level.idLevelSeason';
		$goaliewhere = ' WHERE idPlayers = :idplayer';
		$goalieassignorder = ' ORDER BY SeasonStart DESC, idLevelSeason ASC, subseason.SortOrder DESC, GoalieGames DESC, TeamName ASC';
		if ($subgoalie == 0) {$goaliewhere .= ' AND (PlayerStatus <> "Sub Goalie" OR PlayerStatus IS NULL)';}
		elseif ($subgoalie == 1) {$goaliewhere .= ' AND PlayerStatus = "Sub Goalie"';}
		elseif ($subgoalie == 2) {$goaliewhere .= '';}
		
		
		if ($currentgroup == 'season') {
			$goaliefetchSELECT .= ', idSeason, SeasonDisplay, idLevelSeason, Level, TeamDivision, TeamName';
			$goaliegroupby = ' GROUP BY idTeamAssignment, idSeasonkey';
		} elseif ($currentgroup == 'subseason') {
			$goaliefetchSELECT .= ', SubSeasonName';
			$goaliegroupby = ' GROUP BY goaliestat.idsubseasonkey';
			$goalieassignorder = ' ORDER BY subseason.SortOrder DESC';
		} elseif ($currentgroup == 'seasonsubseason') {
			$goaliefetchSELECT .= ', idSeason, SeasonDisplay, SubSeasonName, Level, TeamDivision, TeamName';
			$goaliegroupby = ' GROUP BY idTeamAssignment, idSeasonkey, goaliestat.idsubseasonkey';
		}
	}
	
	$goaliefetchSQL = $goaliefetchSELECT.$goaliefetchFROM.$goaliewhere.$goaliegroupby.$goalieassignorder;
	#echo $goaliefetchSQL;
	$goaliestatsfetch = $pdoConnect->prepare($goaliefetchSQL);
	if ($idplayerassignment != 0)
	{
		#$goaliestatsfetch->bindParam(':playerassignment', $idplayerassignment, PDO::PARAM_INT);
		$goaliestatsfetch->bindParam(':idteam', $teamHistoryID, PDO::PARAM_INT);
	}
	#elseif ($idplayer != 0)
	#{
		$goaliestatsfetch->bindParam(':idplayer', $idplayer, PDO::PARAM_INT);
	#}
	$goaliestatsfetch->execute();

	$goalierowcount = $goaliestatsfetch->rowCount();
	$getGoalieStats = $goaliestatsfetch->fetchAll(PDO::FETCH_ASSOC);
	if ($goalierowcount > 0)
	{
		$fetchedGoalieStats = $getGoalieStats[0];
		$outputArray = array();
		
		$startGrandTotal = array('Grand Total' => 'Grand Total');
		if ($idplayerassignment == 0) {
			if ($currentgroup != 'subseason') {
				$startGrandTotal += ['Team' => '', 'teamid' => '', 'Level' =>''];
			}
			if ($currentgroup == 'seasonsubseason') {
				$startGrandTotal += ['extra' => ''];
			}
		}

		
		$StatTemplate = array('GP'=>0, 'W'=>0, 'L'=>0, 'T'=>0, 'OTL'=>0, 'Shutouts'=>0, 'SA'=>0, 'GA'=>0, 'GA Even'=>0);
		$goalieGrandTotal = $startGrandTotal+$StatTemplate;

		foreach ($getGoalieStats as $row) {
			$startDataRow = array();
			if ($idplayerassignment != 0) {
				$startDataRow += ['Season' => $row['SeasonDisplay']];
			}
			else {
				$startGrandTotal += ['Grand Total' => 'Grand Total'];
				if ($currentgroup != 'subseason') {
					$startDataRow += ['Season' => $row['SeasonDisplay'], 'Team' => $row['TeamName'], 'teamid' => $row['idTeamAssignment'], 'Level' => $row['Level'].' '.$row['TeamDivision']];
				}
				if ($currentgroup != 'season') {
					$startDataRow += ['Subseason' => $row['SubSeasonName']];
				}
			}

			$dataRow = array();
		
			$dataRow += ['GP' => $row['SUM(GoalieGames)'], 
			'W'=>$row['SUM(GoalieWins)'], 
			'L'=> $row['SUM(GoalieLosses)'], 
			'T'=>$row['SUM(GoalieTies)'], 
			'OTL'=>$row['SUM(GoalieOTL)'], 
			'Shutouts'=>$row['SUM(GoalieShutout)'], 
			'SA'=>$row['SUM(GoalieShotsAgainst)'], 
			'GA'=>$row['SUM(GoalieGoalsAllowed)'],
			'GA Even'=>$row['GAEven'],
			'Save%'=>number_format($row['SavePercent'],3,'.',''), 
			'GAA'=>number_format($row['GAA'],2,'.',''), 
			'GAA Even'=>number_format($row['GAAEven'],2,'.','')];


			$goalieGrandTotal['GP'] = $row['SUM(GoalieGames)']+$goalieGrandTotal['GP'];
			$goalieGrandTotal['W'] = $row['SUM(GoalieWins)']+$goalieGrandTotal['W'];
			$goalieGrandTotal['L'] = $row['SUM(GoalieLosses)']+$goalieGrandTotal['L'];
			$goalieGrandTotal['T'] = $row['SUM(GoalieTies)']+$goalieGrandTotal['T'];
			$goalieGrandTotal['OTL'] = $row['SUM(GoalieOTL)']+$goalieGrandTotal['OTL'];
			$goalieGrandTotal['Shutouts'] = $row['SUM(GoalieShutout)']+$goalieGrandTotal['Shutouts'];
			$goalieGrandTotal['SA'] = $row['SUM(GoalieShotsAgainst)']+$goalieGrandTotal['SA'];
			$goalieGrandTotal['GA'] = $row['SUM(GoalieGoalsAllowed)']+$goalieGrandTotal['GA'];
			$goalieGrandTotal['GA Even'] = $row['GAEven']+$goalieGrandTotal['GA Even'];

			$outputArray[] = $startDataRow+$dataRow;
		}
		$goalieGrandTotal += ['Save%' => number_format(1-($goalieGrandTotal['GA']/$goalieGrandTotal['SA']),3,'.','')];
		$goalieGrandTotal += ['GAA' => number_format($goalieGrandTotal['GA']/$goalieGrandTotal['GP'],2,'.','')];
		$goalieGrandTotal += ['GAA Even' => number_format($goalieGrandTotal['GA Even']/$goalieGrandTotal['GP'],2,'.','')];
		$outputArray[] = $startGrandTotal+$goalieGrandTotal;
	
	} else {
		$outputArray = NULL;
	}
return $outputArray;
}

function JSONboxscoreSkater() {
	$idplayer = ( isset( $_GET['playerid'] ) && is_numeric( $_GET['playerid'] ) ) ? intval( $_GET['playerid'] ) : 0;
	$idplayerassignment = ( isset( $_GET['playerteamid'] ) && is_numeric( $_GET['playerteamid'] ) ) ? intval( $_GET['playerteamid'] ) : 0;

	$pdoConnect = createDBH();
	
	$TeamArray = array();
	
	$GamesSQL = 'SELECT idGame, GameDate, AwayTeamName.TeamName AS AwayTeamName, HomeTeamName.TeamName AS HomeTeamName, idPlayerAssignment FROM game JOIN teamassignment AS HomeTeamFound ON game.HomeTeam = HomeTeamFound.idTeamAssignment JOIN team AS HomeTeamName ON HomeTeamFound.idTeamkey = HomeTeamName.idTeam JOIN teamassignment AS AwayTeamFound ON game.AwayTeam = AwayTeamFound.idTeamAssignment JOIN team AS AwayTeamName ON AwayTeamFound.idTeamkey = AwayTeamName.idTeam JOIN gameattendance ON game.idGame = gameattendance.idGamekey JOIN playerassignment ON gameattendance.Playerassignmentkey = playerassignment.idPlayerassignment';
	
	if ($idplayerassignment != 0) 
	{
		$playeridbox = $idplayerassignment;
		$GamesSQLPlayer = ' WHERE idPlayerAssignment = :idPlayer AND Attend = 1 ORDER BY GameDate DESC';
	}
	elseif ($idplayer != 0) 
	{
		$playeridbox = $idplayer;
		$GamesSQLPlayer = ' JOIN players ON playerassignment.idPlayerskey = players.idplayers WHERE idPlayers = :idPlayer AND GameDate BETWEEN CURDATE() AND CURDATE()-30 AND Attend = 1 ORDER BY GameDate DESC';
	}
	
	$Games = $pdoConnect->prepare($GamesSQL.$GamesSQLPlayer);
	$Games->bindParam(':idPlayer', $playeridbox, PDO::PARAM_INT );
	$Games->execute();
	while($Gamesline=$Games->fetch(PDO::FETCH_ASSOC))
	{
		array_push($TeamArray, array('gameID' => $Gamesline['idGame'], 'Game' => $Gamesline['AwayTeamName'].' vs. '.$Gamesline['HomeTeamName'],'GameDate' => $Gamesline['GameDate'], 'Goals' => 0, 'Assists' => 0, 'PPG' => 0, 'SHG' => 0, 'PN' => 0, 'PIM' => 0));
	}

	$Assists = $pdoConnect->prepare('SELECT idGamekey FROM gameevents JOIN goalevent ON gameevents.idGameEvents = goalevent.idGameEvents WHERE PlayerAssist IS NOT NULL AND (PlayerAssist = :idPlayer OR PlayerAssist2 = :idPlayer)');
	$Assists->bindParam(':idPlayer', $playeridbox, PDO::PARAM_INT );
	$Assists->execute();
	if ($Assists->rowCount() != 0)	{
		while ($Assistrow = $Assists->fetch(PDO::FETCH_ASSOC))	{
			foreach ($TeamArray as &$array)	{
				if ($array['gameID'] == $Assistrow['idGamekey']) {
					$array['Assists'] ++;
				}
			}
		} 
		unset($array);
	}
	$Goals = $pdoConnect->prepare('SELECT idGamekey, goalclasskey FROM gameevents JOIN goalevent ON gameevents.idGameEvents = goalevent.idGameEvents  LEFT JOIN (SELECT idgoalclassevent, goaleventkey, goalclasskey FROM goalclassevent WHERE goalclasskey = 2 OR goalclasskey = 3) AS goalclasspossible ON goalevent.idGameEvents = goalclasspossible.goaleventkey WHERE GoalScorer = :idPlayer');
	$Goals->bindParam(':idPlayer', $playeridbox, PDO::PARAM_INT );
	$Goals->execute();
	if ($Goals->rowCount() != 0) {
		while ($Goalsrow = $Goals->fetch(PDO::FETCH_ASSOC))	{
			foreach ($TeamArray as &$array)	{
				if ($array['gameID'] == $Goalsrow['idGamekey'])	{
					$array['Goals'] ++;
					if ($Goalsrow['goalclasskey'] == 2)	{$array['PPG'] ++;}
					if ($Goalsrow['goalclasskey'] == 3)	{$array['SHG'] ++;}
				}
			}
		} 
		unset($array);
	}
	$Penalties = $pdoConnect->prepare('SELECT idGamekey, PenaltyLength FROM gameevents JOIN penaltyevent ON gameevents.idGameEvents = penaltyevent.idGameEvents WHERE idPlayerAssignmentkey = :idPlayer');
	$Penalties->bindParam(':idPlayer', $playeridbox, PDO::PARAM_INT );
	$Penalties->execute();
	if ($Penalties->rowCount() != 0) {
		while ($Penaltyrow = $Penalties->fetch(PDO::FETCH_ASSOC)) {
			foreach ($TeamArray as &$array)	{
				if ($array['gameID'] == $Penaltyrow['idGamekey']) {
					$array['PN']++;
					$array['PIM'] = $array['PIM'] + $Penaltyrow['PenaltyLength'];
				}
			}
		} 
		unset($array);
	}

return $TeamArray;
}

function JSONboxscoreGoalie() {
	##Goalie Box Score Builder	
		$idplayer = ( isset( $_GET['playerid'] ) && is_numeric( $_GET['playerid'] ) ) ? intval( $_GET['playerid'] ) : 0;
		$idplayerassignment = ( isset( $_GET['playerteamid'] ) && is_numeric( $_GET['playerteamid'] ) ) ? intval( $_GET['playerteamid'] ) : 0;
		
		$pdoConnect = createDBH();
		
		$goalieboxSQLselect = 'SELECT idGame, GameDate, AwayTeamName.TeamName AS AwayTeamName, HomeTeamName.TeamName AS HomeTeamName, idPlayerAssignment, GoalieResult, GoalieShots, GoalieGoalsAllowed, 1-(SUM(GoalieGoalsAllowed)/SUM(GoalieShots)) AS SavePercent FROM game JOIN teamassignment AS HomeTeamFound ON game.HomeTeam = HomeTeamFound.idTeamAssignment JOIN team AS HomeTeamName ON HomeTeamFound.idTeamkey = HomeTeamName.idTeam JOIN teamassignment AS AwayTeamFound ON game.AwayTeam = AwayTeamFound.idTeamAssignment JOIN team AS AwayTeamName ON AwayTeamFound.idTeamkey = AwayTeamName.idTeam JOIN gamegoaliesave ON game.idGame = gamegoaliesave.idGamekey JOIN playerassignment ON gamegoaliesave.idPlayerAssignmentkey = playerassignment.idPlayerassignment JOIN players ON playerassignment.idPlayerskey = players.idPlayers';
		if ($idplayerassignment != 0)
		{
			$goalieboxSQLwhere = ' WHERE playerassignment.idPlayerAssignment = :playerassignment';
		}
		elseif ($idplayer != 0)
		{
			$goalieboxSQLwhere = ' WHERE idPlayers = :idplayer AND GameDate BETWEEN CURDATE() AND CURDATE()-30';
		}
		$goalieboxSQLorderby = ' GROUP BY idGame ORDER BY GameDate DESC';
		
		$goalieboxscorefetch = $pdoConnect->prepare($goalieboxSQLselect.$goalieboxSQLwhere.$goalieboxSQLorderby);
		if ($idplayerassignment != 0)
		{
			$goalieboxscorefetch->bindParam(':playerassignment', $idplayerassignment, PDO::PARAM_INT );
		}
		elseif ($idplayer != 0)
		{
			$goalieboxscorefetch->bindParam(':idplayer', $idplayer, PDO::PARAM_INT );
		}
		$goalieboxscorefetch->execute();

		$goalieOutputArray = array();
		while ($goalieline=$goalieboxscorefetch->fetch(PDO::FETCH_ASSOC))
		{
			$goalieOutputArray[] = array('gameID' => $goalieline['idGame'], 'Game' => $goalieline['AwayTeamName'].' vs '.$goalieline['HomeTeamName'], 'Date' => $goalieline['GameDate'], 'Result' => $goalieline['GoalieResult'], 'SA' => $goalieline['GoalieShots'], 'Saves' =>($goalieline['GoalieShots']-$goalieline['GoalieGoalsAllowed']), 'GA' => $goalieline['GoalieGoalsAllowed'], 'Save%' => number_format($goalieline['SavePercent'],3,'.',''));
		}
	return $goalieOutputArray;
	}
	
if ($idplayer != 0) {
	$tableTeamLink = array(array('link' => 'team?teamid=', 'linktarget' => 'teamid', 'linkname' => 'Team'));
} else {$tableTeamLink = null;}

$groupFilterArray = array(array('value'=>'season', 'text'=>'Season'), array('value'=>'seasonsubseason', 'text'=>'Subseason Breakdown'), array('value'=>'subseason', 'text'=>'Subseason'));

$starterFilterArray = array(array('value'=>'0', 'text' =>'Starters'), array('value'=>'1', 'text' =>'Sub Goalies'), array('value'=>'2', 'text' =>'All Goalies'));

if($idplayer != 0) {
	$filterSplitMenu = array(
		array('value' => 'standard', 'text'=>"Standard"),
		array('value' => 'alltime', 'text'=>"All Time"),
		array('value' => 'subseason', 'text'=>"Type of Game"),
		array('value' => 'level', 'text'=>"Level"),
		array('value'=>'location', 'text'=>"Location"),
		array('value'=>'homeaway', 'text'=>"Home vs Away"),
		array('value'=>'weekend', 'text'=>"Weekday vs Weekend"),
		array('value'=>'timestart', 'text'=>"Start Time Split"),
	);
} else {
	$filterSplitMenu = array(
		array('value' => 'standard', 'text'=>"Standard"),
		array('value' => 'subseason', 'text'=>"Type of Game"),
		array('value' => 'level', 'text'=>"Level"),
		array('value'=>'location', 'text'=>"Location"),
		array('value'=>'homeaway', 'text'=>"Home vs Away"),
		array('value'=>'weekend', 'text'=>"Weekday vs Weekend"),
		array('value'=>'timestart', 'text'=>"Start Time Split"),
	);
}


$step = (( isset( $_GET['step'] ) && is_numeric( $_GET['step'] ) ) ? intval( $_GET['step'] ) : 0 );

switch($step) {
	case 0:
		$skaterTableData = buildJSONdataTable(JSONstatsPlayer($currentgroup), null, null, $tableTeamLink, null, null);
		$goalieTableData = buildJSONdataTable(JSONstatsGoalie($currentgroup), null, null, $tableTeamLink, null, null);
	
		$JSONOutput = array(
			'skaterTable' => array(
				'dataarray' => JSONstatsPlayer($currentgroup),
				'tableid' => 'playerstat',
				'tableclass' => 'tablesorter',
				'tablesort' => null,
				'linkslist' => $tableTeamLink,
				'imagelist' => null,
				'filterMenu' => null,
				'groupMenu' => null,
				'subseasonMenu' => null,
				'splitMenu' => $filterSplitMenu
			),
			'goalieTable' => array(
				'dataarray' => JSONstatsGoalie($currentgroup),
				'tableid' => 'playerstat',
				'tableclass' => 'tablesorter',
				'tablesort' => null,
				'linkslist' => null,
				'imagelist' => null,
				'filterMenu' => null,
				'groupMenu' => $starterFilterArray,
				'subseasonMenu' => null,
				'splitMenu' => $filterSplitMenu
			),
			'skaterBoxScore' => buildJSONdataTable(JSONboxscoreSkater(), null, null, array(array('link' => 'gamerecap?gameID=', 'linktarget' => 'gameID', 'linkname' => 'Game')), null, null),
			'goalieBoxScore' => buildJSONdataTable(JSONboxscoreGoalie(), null, null, array(array('link' => 'gamerecap?gameID=', 'linktarget' => 'gameID', 'linkname' => 'Game')), null, null)
			);
		echo JSON_encode($JSONOutput);
	break;
	case 1: 
		$skaterTableData = array(
			'dataarray' => JSONstatsPlayer($currentgroup),
			'tableid' => 'playerstat',
			'tableclass' => 'tablesorter',
			'tablesort' => null,
			'linkslist' => $tableTeamLink,
			'imagelist' => null,
			'filterMenu' => null,
			'groupMenu' => null,
			'subseasonMenu' => null,
			'splitMenu' => $filterSplitMenu
		);
		echo JSON_encode($skaterTableData);
	break;
	case 2:
		$goalieTableData = array(
			'dataarray' => JSONstatsGoalie($currentgroup),
			'tableid' => 'playerstat',
			'tableclass' => 'tablesorter',
			'tablesort' => null,
			'linkslist' => null,
			'imagelist' => null,
			'filterMenu' => null,
			'groupMenu' => $starterFilterArray,
			'subseasonMenu' => null,
			'splitMenu' => $filterSplitMenu
		);
		echo JSON_encode($goalieTableData);
	break;
	case 3:
		include_once 'goalieStatSplitJSON.php';
		break;
	case 4:
		include_once 'skaterStatSplitJSON.php';
		break;

}


?>
Season	Season	Team Name	Level	Subseason	Games Played	Goals	Assists	Points	PN	PIM	PPG	PPP	SHG	SHP	GWG	GWP	GTG	GTP	OTG	OTP	ENG	ENP
'.$row['SeasonDisplay'].'	'.$row['SeasonDisplay'].'	'.$row['TeamName'].'	'.$row['Level'].' '.$row['TeamDivision'].'	'.$row['SubSeasonName'].'	'.$row['SUM(PlayerGames)'].'	'.$row['SUM(PlayerGoals)'].'	'.$row['SUM(PlayerAssists)'].'	'.$row['SUM(PlayerPoints)'].'	'.$row['SUM(PlayerPN)'].'	'.$row['SUM(PlayerPIM)'].'	'.$row['SUM(PlayerPPG)'].'	'.$row['SUM(PlayerPPP)'].'	'.$row['SUM(PlayerSHG)'].'	'.$row['SUM(PlayerSHP)'].'	'.$row['SUM(PlayerGWG)'].'	'.$row['SUM(PlayerGWP)'].'	'.$row['SUM(PlayerGTG)'].'	'.$row['SUM(PlayerGTP)'].'	'.$row['SUM(PlayerOTG)'].'	'.$row['SUM(PlayerOTP)'].'	'.$row['SUM(PlayerENG)'].'	'.$row['SUM(PlayerENP)'].'
Totals				'.$GrandTotal['games'].'	'.$GrandTotal['goals'].'	'.$GrandTotal['assists'].'	'.$GrandTotal['points'].'	'.$GrandTotal['pn'].'	'.$GrandTotal['pim'].'	'.$GrandTotal['ppg'].'	'.$GrandTotal['ppp'].'	'.$GrandTotal['shg'].'	'.$GrandTotal['shp'].'	'.$GrandTotal['gwg'].'	'.$GrandTotal['gwp'].'	'.$GrandTotal['gtg'].'	'.$GrandTotal['gtp'].'	'.$GrandTotal['otg'].'	'.$GrandTotal['otp'].'	'.$GrandTotal['eng'].'	'.$GrandTotal['enp'].'