<?php 

include_once 'connection.php';

#include 'header.php';
#include 'html.php';

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

function getPlayerImage ($playerid) {
	$PDOProfileConnect = createNDBH();
	
	$playerimageSQL = $PDOProfileConnect->prepare('SELECT imagelocation FROM CSSplayerassignment WHERE PlayertableRef = "playerassignment" AND PlayeridRef = :idPlayer LIMIT 1');
	$playerimageSQL->bindParam(':idPlayer', $playerid, PDO::PARAM_INT);
	$playerimageSQL->execute();
	$getimage = $playerimageSQL->fetch(PDO::FETCH_ASSOC);
	if (!empty($getimage['imagelocation'])) 
		{
			$playerimagelocation .= 'playerimages/'.$getimage['imagelocation'];			
	} else $playerimagelocation = '';
return $playerimagelocation;
}

function addPlayerImage($array) {
	$fetchPlayerImage = getPlayerImage ($array['PlayerAssignmentid']);
	
	if (!empty($fetchPlayerImage)) {
		$array['playerImage'] = $fetchPlayerImage;
	} else {
		$array['playerImage'] = NULL;
	}
return $array;
}

function teamJSONroster($currentteam) {
	$PDOStatConnect = createDBH();

	#Set Query for Team
	$Playerstatquery = $PDOStatConnect->prepare('SELECT playerassignment.idPlayerAssignment AS PlayerAssignmentid, concat(PlayerFirst, " ", PlayerLast) AS Player, PlayerNumber as "Number", jjglover_GLSHockey_NewsCss.cssplayerassignment.imagelocation AS PlayerImage, PlayerStatus AS "Status", ShortPosition AS "Position", SUM(PlayerGames) AS GP, SUM(PlayerGoals) AS G, SUM(PlayerAssists) AS A, SUM(PlayerPoints) AS Pts, SUM(PlayerPIM) AS PIM, SUM(GoalieGames) AS "GoalieGP", ROUND((SUM(GoalieGoalsAllowed)/SUM(GoalieGames))) AS "GAA", ROUND((1-(SUM(GoalieGoalsAllowed)/SUM(GoalieShotsAgainst))), 3) AS "SaveP" FROM skaterstat JOIN playerassignment ON playerassignment.idPlayerAssignment = skaterstat.idPlayerAssignment LEFT JOIN css_teamplayer_listing ON playerassignment.idPlayerAssignment = css_teamplayer_listing.PlayeridRef JOIN players ON playerassignment.idPlayerskey=players.idPlayers JOIN subseason ON skaterstat.idsubseasonkey = subseason.idsubseason LEFT JOIN goaliestat ON playerassignment.idPlayerAssignment = goaliestat.idPlayerAssignment  LEFT JOIN jjglover_GLSHockey_NewsCss.cssplayerassignment ON playerassignment.idPlayerAssignment = cssplayerassignment.PlayeridRef AND jjglover_GLSHockey_NewsCss.cssplayerassignment.PlayertableRef = "playerassignment" JOIN teamassignment ON playerassignment.idTeamAssignmentkey = teamassignment.idTeamAssignment WHERE idTeamAssignment = :teamid AND (PlayerStatus <> "Sub Goalie" OR PlayerStatus IS NULL) GROUP BY PlayerAssignmentid ORDER BY -PlayerNumber DESC, PlayerLast, PlayerFirst');
	$Playerstatquery->bindParam(':teamid', $currentteam, PDO::PARAM_INT);
	$Playerstatquery->execute();

$statFetched = $Playerstatquery->fetchAll(PDO::FETCH_ASSOC);

return $statFetched;
}

function GetRosterTeamInfo($currentteam) {		
	$PDOStatConnect = createDBH();
	$STHHeader = $PDOStatConnect->prepare('SELECT TeamName, SeasonDisplay FROM teamstatview JOIN season ON teamstatview.idSeason = season.idSeason WHERE idTeamAssignment = :teamid');
	$STHHeader->bindParam(':teamid', $currentteam, PDO::PARAM_INT);
			
	$STHHeader->execute();
	$HeaderTeamInfo = $STHHeader->fetch(PDO::FETCH_ASSOC);

	return $HeaderTeamInfo;
}

$headerDeadline = GetRosterTeamInfo($currentteam);

$outputJSONArray = teamJSONroster($currentteam);

//$outputJSONArray = array_map("addPlayerImage", $getRosterData);


$prepJSONdataArray = array(
	'header' => 'Current Roster for the '.$headerDeadline['TeamName'],
	'subheader' => 'Season: '.$headerDeadline['SeasonDisplay'],
	'dataarray' => $outputJSONArray,
	'tableid' => 'roster',
	'tableclass' => 'tablesorter',
	'tablesort' => '',
	'linkslist' => array(array('link'=>'playercard.html?playerteamid=','linktarget'=>'PlayerAssignmentid','linkname'=>'Player')),
	'imagelist' => array('image'=>'PlayerImage','imagetarget'=>'Player')
);

$JSONecho = json_encode($prepJSONdataArray);

echo $JSONecho;

?>