$Countahtlete_pending = "(<font style='color:red;'>" . $Countahtlete_pending . " Pending</font>)";
} else {
$Countahtlete_pending = "";
}
?>
<p><img src="img/bullet-grey.gif"><a href="CoachAthapprove.php">Athlete Approval <?php
echo $Countahtlete_pending;
?>
</a>
</p>
<?php
//Count Pending Athlete Stats
$ahtlete_stat_pending = $func->selectTableOrdergroupby(TBL_ATHELETE_STAT, "fldAtheleteId,fldStatus,fldPrograme", "fldPrograme", "where fldCoachId='" . $_SESSION['Coach_id'] . "' and fldStatus = '0'");
$Countahtlete_stat_pending = count($ahtlete_stat_pending);
if ($Countahtlete_stat_pending > 0) {
$Countahtlete_stat_pending = "(<font style='color:red;'>" . $Countahtlete_stat_pending . " Pending</font>)";
} else {
$Countahtlete_stat_pending = "";
}
?>
<p><img src="img/bullet-grey.gif"><a href="ViewAthletesStats.php">Athlete Stats Approval <?php
echo $Countahtlete_stat_pending;
?>
</a>
</p>
echo $fldHSCoachName;
?>
">
</span><font color="#0000ff"> *</font> </p>
<p>
<label>High School:</label>
<span>
<select name="fldSchool" id="fldSchool" style="width:276px" >
<!--onchange="select_val(this.value)"-->
<option value="select" class="selectgrey">Select High School</option>
<?php
#$categorylist = $func -> selectTableOrdergroupby(TBL_HS_AAU_TEAM, "fldId,fldSchoolname", "fldState");
#for ($i = 0; $i < count($categorylist); $i++) {
#echo '<option value ="' . $categorylist[$i]['fldId'] . '" >' . $categorylist[$i]['fldSchoolname'] . '</option>';
#}
$statelist = $func2->selectTableOrdergroupby(TBL_HS_AAU_TEAM, "fldState", "fldState", "WHERE fldStatus='ACTIVE'");
for ($x = 0; $x < count($statelist); $x++) {
echo '<optgroup label="========' . $statelist[$x]['fldState'] . '========">';
#echo '<option value ="' . $statelist[$x]['fldState'] . '" >' . $statelist[$x]['fldState'] . '</option>';
$whereclaus = "WHERE fldState = '" . $statelist[$x]['fldState'] . "' ";
$categorylist = $func->selectTableOrder(TBL_HS_AAU_TEAM, "fldId,fldSchoolname", "fldSchoolname", $whereclaus);
for ($i = 0; $i < count($categorylist); $i++) {
?>
<option value ="<?php
echo $categorylist[$i]['fldId'];
?>
"<?php
if ($categorylist[$i]['fldId'] == $fldSchool) {
?>
selected="selected" <?php
}
public static function getSchoolList()
{
$func = new COMMONFUNC();
$schoolList = array();
$groups = $func->selectTableOrdergroupby(TBL_HS_AAU_TEAM, "fldState", "fldState", "WHERE fldStatus='ACTIVE'");
for ($i = 0; $i < count($groups); $i++) {
$groupLabel = '========' . $groups[$i]['fldState'] . '========';
$schoolList[$groupLabel] = array();
//School Loop (in state)
$where = "WHERE fldState='" . $groups[$i]['fldState'] . "'";
$schools = $func->selectTableOrder(TBL_HS_AAU_TEAM, "fldId,fldSchoolname", "fldSchoolname", $where);
for ($j = 0; $j < count($schools); $j++) {
$key = $schools[$j]['fldId'];
$value = $schools[$j]['fldSchoolname'];
$schoolList[$groupLabel][$key] = $value;
}
}
return $schoolList;
}
$query1 = "SELECT fldSport from " . TBL_ATHELETE_REGISTER . " WHERE fldUsername='******'";
$db1->query($query1);
$db1->next_record();
$fldSport = $func->output_fun($db1->f('fldSport'));
if ($_SESSION['mode'] == 'coach' || $_SESSION['mode'] == 'college') {
echo "<h2 style='padding-left:160px;'>Send Message to HS/AAU Coach</h2><br><form name='messageform' action='' method=post onsubmit='return validate()'>";
echo "<p><label>To:</label><span>";
echo $strcombo = '<select name="to" style="width:276px">';
echo $strcombo = '<option value="">----- Please Select -----</option>';
$coachlist = $func->selectTableOrder(TBL_HS_AAU_COACH, "fldId,fldName,fldLastName,fldUsername", "fldLastName");
} else {
echo "<h2 style='padding-left:160px;'>Send Message to HS/AAU Coach</h2><br><form name='messageform' action='' method=post onsubmit='return validate()'>";
echo "<p><label>To:</label><span>";
echo $strcombo = '<select name="to" style="width:276px">';
echo $strcombo = '<option value = "">----- Please Select -----</option>';
$coachlist = $func->selectTableOrdergroupby("tbl_hs_aau_coach_sportposition cs, tbl_hs_aau_coach ac", "fldId,fldName,fldLastName,fldUsername", "ac.fldLastName", "where ac.fldId = cs.fldCoachNameId and cs.fldSportId = " . $fldSport);
}
for ($i = 0; $i < count($coachlist); $i++) {
if (!in_array($coachlist[$i]['fldId'], $coachid)) {
if ($_REQUEST['to'] == $coachlist[$i]['fldUsername']) {
echo '<option value ="' . $coachlist[$i]['fldUsername'] . '" selected="selected" >' . ucfirst($coachlist[$i]['fldLastName']) . ', ' . ucfirst($coachlist[$i]['fldName']) . '</option>';
} else {
echo '<option value ="' . $coachlist[$i]['fldUsername'] . '">' . ucfirst($coachlist[$i]['fldLastName']) . ', ' . ucfirst($coachlist[$i]['fldName']) . '</option>';
}
}
}
echo $strcombo = '</select>';
} else {
if ($_REQUEST['value'] == 'athlete') {
##TO ATHLETE##
echo "<h2 style='padding-left:160px;'>Send Message to an Athlete</h2><br><form name='messageform' action='' method=post onsubmit='return validate()'>";
<span>
<input type="text" name="fldAlternativePhone" id="fldAlternativePhone" value="<?php
echo $fldAlternativePhone;
?>
"
>
</span>
</p>
<hr class="line" />
<p>
<label>College:</label>
<span> <?php
echo $strcombo = '<select name="fldCollegename" id="fldSchool">';
echo $strcombo = '<option value="select" class="selectgrey">Select College</option>';
$statelist = $func2->selectTableOrdergroupby(TBL_COLLEGE, "fldState", "fldState", "WHERE fldStatus='1'");
for ($x = 0; $x < count($statelist); $x++) {
echo '<optgroup label="========' . $statelist[$x]['fldState'] . '========">';
$whereclaus = "WHERE fldState = '" . $statelist[$x]['fldState'] . "' ";
$collegelist = $func->selectTableOrder(TBL_COLLEGE, "fldId,fldName", "fldName", $whereclaus);
for ($i = 0; $i < count($collegelist); $i++) {
echo '<option value ="' . $collegelist[$i]['fldId'] . '" >' . $collegelist[$i]['fldName'] . '</option>';
}
echo '<option value ="other" class="addcustom_normal">****Other (Add Your College) ****</option>';
echo '</optgroup>';
}
echo '<option value ="other" class="addcustom">Not Listed? Add Your College</option>';
echo $strcombo = '</select>';
?>
</span><font color="#0000ff">*</font>
</p>
