function GetTeam($inId = null, $inTeamName = null, $inCoachName = null, $inSquadId = null)
{
$sq = new Squad(null, null);
$db = new MySQL("localhost", "root", "n4UVFpHeHr", "bulilit");
$db->connect();
$s = new SquadDao($db, $sq);
if (!empty($inId)) {
$query = $db->query("SELECT * FROM Team T WHERE T.TeamID=" . $inId . " ORDER BY T.TeamID DESC") or die("Error retrieving team with team id" . $inId);
} else {
if (!empty($inTeamName)) {
$query = $db->query("SELECT * FROM Team T WHERE T.TeamName like '%" . $inTeamName . "%' ORDER BY T.TeamID ASC");
} else {
if (!empty($inCoachName)) {
$query = $db->query("SELECT * FROM Team T where T.TeamID in(SELECT TC.TeamID FROM TeamCoach TC where TC.CoachID in (SELECT C.CoachID FROM Coach C where C.Name like '%" . $inCoachName . "%')) ORDER BY T.TeamID");
} else {
//$query = mysql_query("SELECT * FROM Team T ORDER BY T.TeamName ASC") or die ("asdfa123123123");
$query = $db->query("SELECT * FROM Team T ORDER BY T.TeamName ASC");
}
}
}
$teamArray = array();
while ($row = mysql_fetch_assoc($query)) {
$teamId = $row["TeamID"];
$myCoachArray = GetCoach(null, null, null, $teamId);
$mySquadArray = $s->GetSquad(null, null, $teamId);
$myTeam = new Team($row["TeamID"], $row['TeamName'], $row['SportID'], $myCoachArray, $mySquadArray);
array_push($teamArray, $myTeam);
}
return $teamArray;
}
