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;
}
//exit();
}
}
if (!$err_flag) {
//states : View, Start Promotion, Checking Done
//transitions: view-> edit, edit ->update, update->views, or *->view * (default)
$form_opt_menu_open = "";
$form_opt_menu_close = "";
//Connect to database and make connection
$con = new MySQL("localhost", MYSQL_USERNAME, MYSQL_PASSWORD, MYSQL_DATABASE);
try {
$con->connect();
} catch (Exception $e) {
echo $e->getMessage();
}
$sqd = new SquadDao($con);
$result_array = $sqd->getAllCandidateForPromotion();
//initialize parameter for content generations
$table_head = "";
$table = "";
$i = 0;
$c = count($result_array);
$page_state = "";
$candidates = array();
//view => edit
// if(isset($_POST['submit'])){
// print "<p>Post Captured value: $_POST['submit']</p>";
// }
$form_opt_menu_open = "<form action='PromoteSquadMember.php' method= 'post'>";
// view controller start
//var_dump($_POST['submit']);
Location("header : ../User/main.php");
exit(1);
} else {
if ($session->isCoach() || $session->isAdmin()) {
$nav_admin_menu = "<a href='PromoteSquadMember.php'>Promote Squad Member</a>";
} else {
//Location("header : $session->referrer");
}
}
$con = new MySQL("localhost", MYSQL_USERNAME, MYSQL_PASSWORD, MYSQL_DATABASE);
try {
$con->connect();
} catch (Exception $e) {
echo $e->getMessage();
}
$sqd = new SquadDao($con);
//$sort_criteria ="MembershipID"
$result_array = $sqd->GetAllSquadMem();
$table = "";
$i = 0;
$c = count($result_array);
while ($i < $c) {
$nm = $result_array[$i]->name;
$gn = $result_array[$i]->gender;
$st = $result_array[$i]->status;
$sq = $result_array[$i]->squadkind;
if ($i % 2 == 1) {
$table .= "<tr class='alt'>\n\t\t\t\t <td><font face='Arial, Helvetica, sans-serif'>{$nm}</font></td>\n\t\t\t\t <td><font face='Arial, Helvetica, sans-serif'>{$gn}</font></td>\n\t\t\t\t <td><font face='Arial, Helvetica, sans-serif'>{$st}</font></td>\n <td><font face='Arial, Helvetica, sans-serif'>{$sq}</font></td>\n\t\t\t\t</tr>";
} else {
$table .= "<tr>\n\t\t\t\t <td><font face='Arial, Helvetica, sans-serif'>{$nm}</font></td>\n\t\t\t <td><font face='Arial, Helvetica, sans-serif'>{$gn}</font></td>\n\t\t\t\t <td><font face='Arial, Helvetica, sans-serif'>{$st}</font></td>\n <td><font face='Arial, Helvetica, sans-serif'>{$sq}</font></td>\n\t\t\t\t </tr>";
}
