if (isset($_POST['submit']) or isset($_SESSION['where'])) {
?>
<div id="results" style="float:left" class="transparent">
<form>
<table id="showSchools">
<tr>
<th>Federal<br/>Code</th>
<th>System</th>
<th><a href="findSchool.php?sort=name">University</a></th>
<th><a href="findSchool.php?sort=city">City</a></th>
<th>County</th>
<th><a href="findSchool.php?sort=size">Student Size</a></th>
<th><a href="findSchool.php?sort=rate">Acceptance<br/> Rate (%)</a></th>
</tr>
<?php
$records = getSchools($where);
foreach ($records as $record) {
echo '<tr>';
for ($i = 0; $i < count($record) / 2; $i++) {
if ($i != 0) {
echo '<td>';
if ($i == 3) {
echo '<a href=admissions.php?id=' . $record[0] . '>';
echo htmlentities($record[$i]);
echo '</a>';
} else {
echo htmlentities($record[$i]);
}
echo '</td>';
}
}
{
getInCycle('getRegions', $countries, 'country_id', 'regions');
}
function getCities($countries)
{
getInCycle('getCities', $countries, 'country_id', 'cities');
}
function getUniversities($cities)
{
getInCycle('getUniversities', $cities, 'city_id', 'universities');
}
function getSchools($cities)
{
getInCycle('getSchools', $cities, 'city_id', 'schools');
}
function getFaculties($universities)
{
getInCycle('getFaculties', $universities, 'university_id', 'faculties');
}
function getChairs($faculties)
{
getInCycle('getChairs', $faculties, 'faculty_id', 'chairs');
}
getCountries();
getRegions('countries');
getCities('countries');
getUniversities('cities');
getFaculties('universities');
getChairs('faculties');
getSchools('cities');
for ($i = $start_year; $i < date('Y') + 2; $i++) {
if ($i == $split_year) {
echo "<option value=\"{$i}\" selected>{$i}</option>\n";
} else {
echo "<option value=\"{$i}\">{$i}</option>\n";
}
}
?>
</td></tr>
<?php
echo "<tr><td><div style=\"width:350px; height:468px; overflow-y:scroll; border:1px solid #828790; font-size:90%\">";
// Get all users for teams within the schools of the current user
// Also get all admin users for those schools
$school_sql = '';
$admin_school_sql = '';
$schools = getSchools($staff_modules, $mysqli);
if (count($schools) > 0) {
$schools_list = implode(',', $schools);
if ($userObject->has_role('SysAdmin')) {
$school_sql = '';
} else {
$school_sql = "AND schoolid IN ({$schools_list})";
}
$admin_school_sql = <<<SQL
UNION SELECT DISTINCT users.id, title, initials, surname, first_names
FROM users, admin_access
WHERE users.id = admin_access.userID AND admin_access.schools_id IN ({$schools_list})
SQL;
}
// Make sure that current reviewers always appear on the list
$current_internals = $properties->get_internal_reviewers();