");
echo("");
echo("| AY".$acadyr." | ");
echo("
");
echo("");
echo("| # | ");
echo("Inst. Type | ");
echo("Institution | ");
echo("Total | ");
echo("
");
$n = 1;
while (odbc_fetch_row($result1))
{
echo("");
echo("| ");
echo($n++);
echo(" | ");
echo("");
$inst_type = (odbc_result($result1, "inst_type"));
echo($inst_type);
echo(" | ");
$fice_code = (odbc_result($result1, "fice_code"));
echo("");
echo(odbc_result($result1, "school_abbr"));
echo(" | ");
// remedial graduates
//$queryX = $distinct;
/*$queryX = "SELECT MAX(s.academic_year),
MAX(s.term),
".$distinct."
FROM graduated_student_table g
JOIN student_table s
ON g.ssn_id = s.ssn_id
WHERE g.fice_code = '".$fice_code."'
".$dl_code."
AND g.academic_year = '".$acadyr."'
AND s.enroll_status = '01'
AND s.degree_intent IN ('2', '4', '6')
AND (
((s.test_type_math = '0' and s.test_math < 19 and s.math_placement_stat = '3')
OR (s.test_type_math = '1' and s.test_math < 460 and s.math_placement_stat = '3')
OR (s.test_type_math = '2' and s.test_math < 39 and s.math_placement_stat = '3')
OR (s.test_type_math = '2' and s.test_math = 999 and s.math_placement_stat = '3')
OR (s.test_type_math = '3' and s.test_math < 41 and s.math_placement_stat = '3'))
OR ((s.test_type_english = '0' and s.test_english < 19 and s.english_placement_stat = '3')
OR (s.test_type_english = '1' and s.test_english < 470 and s.english_placement_stat = '3')
OR (s.test_type_english = '2' and s.test_english < 45 and s.english_placement_stat = '3')
OR (s.test_type_english = '2' and s.test_english = 999 and s.english_placement_stat = '3')
OR (s.test_type_english = '3' and s.test_english < 75 and s.english_placement_stat = '3'))
OR ((s.test_type_reading = '0' and s.test_reading < 19 and s.reading_placement_stat = '3')
OR (s.test_type_reading = '1' and s.test_reading < 470 and s.reading_placement_stat = '3')
OR (s.test_type_reading = '2' and s.test_reading < 43 and s.reading_placement_stat = '3')
OR (s.test_type_reading = '2' and s.test_reading = 999 and s.reading_placement_stat = '3')
OR (s.test_type_reading = '3' and s.test_reading < 82 and s.reading_placement_stat = '3'))
)
GROUP BY g.ssn_id
ORDER BY g.ssn_id; "; */
//echo("".$queryX."
");
if($credgrad == 'A')
{
$cnt = 0;
$queryX = "SELECT g.degree_level,
COUNT(DISTINCT(s.ssn_id)) AS dlcnt
FROM graduated_student_table g
JOIN student_table s
ON g.ssn_id = s.ssn_id
WHERE g.fice_code = '".$fice_code."'
".$dl_code."
AND g.academic_year = '".$acadyr."'
AND s.academic_year <= '".$acadyr."'
AND s.enroll_status = '01'
AND s.degree_intent IN ('2', '4', '6')
AND ( ((s.test_type_math = '0' and s.test_math < 19 and s.math_placement_stat = '3') OR (s.test_type_math = '1' and s.test_math < 460 and s.math_placement_stat = '3') OR (s.test_type_math = '2' and s.test_math < 39 and s.math_placement_stat = '3') OR (s.test_type_math = '2' and s.test_math = 999 and s.math_placement_stat = '3') OR (s.test_type_math = '3' and s.test_math < 41 and s.math_placement_stat = '3')) OR ((s.test_type_english = '0' and s.test_english < 19 and s.english_placement_stat = '3') OR (s.test_type_english = '1' and s.test_english < 470 and s.english_placement_stat = '3') OR (s.test_type_english = '2' and s.test_english < 45 and s.english_placement_stat = '3') OR (s.test_type_english = '2' and s.test_english = 999 and s.english_placement_stat = '3') OR (s.test_type_english = '3' and s.test_english < 75 and s.english_placement_stat = '3')) OR ((s.test_type_reading = '0' and s.test_reading < 19 and s.reading_placement_stat = '3') OR (s.test_type_reading = '1' and s.test_reading < 470 and s.reading_placement_stat = '3') OR (s.test_type_reading = '2' and s.test_reading < 43 and s.reading_placement_stat = '3') OR (s.test_type_reading = '2' and s.test_reading = 999 and s.reading_placement_stat = '3') OR (s.test_type_reading = '3' and s.test_reading < 82 and s.reading_placement_stat = '3')) )
GROUP BY g.degree_level
ORDER BY g.degree_level;";
//echo("".$queryX."
");
$resultX = odbc_exec($conn_id, $queryX);
while (odbc_fetch_row($resultX))
{
$degree_level = odbc_result($resultX, "degree_level");
$dlcnt = odbc_result($resultX, "dlcnt");
$cnt = $cnt + $dlcnt;
}
}
if($credgrad == 'B')
{
$cnt = 0;
$queryX = "SELECT COUNT(DISTINCT(s.ssn_id)) AS cnt
FROM graduated_student_table g
JOIN student_table s
ON g.ssn_id = s.ssn_id
WHERE g.fice_code = '".$fice_code."'
".$dl_code."
AND g.academic_year = '".$acadyr."'
AND s.academic_year <= '".$acadyr."'
AND s.enroll_status = '01'
AND s.degree_intent IN ('2', '4', '6')
AND ( ((s.test_type_math = '0' and s.test_math < 19 and s.math_placement_stat = '3') OR (s.test_type_math = '1' and s.test_math < 460 and s.math_placement_stat = '3') OR (s.test_type_math = '2' and s.test_math < 39 and s.math_placement_stat = '3') OR (s.test_type_math = '2' and s.test_math = 999 and s.math_placement_stat = '3') OR (s.test_type_math = '3' and s.test_math < 41 and s.math_placement_stat = '3')) OR ((s.test_type_english = '0' and s.test_english < 19 and s.english_placement_stat = '3') OR (s.test_type_english = '1' and s.test_english < 470 and s.english_placement_stat = '3') OR (s.test_type_english = '2' and s.test_english < 45 and s.english_placement_stat = '3') OR (s.test_type_english = '2' and s.test_english = 999 and s.english_placement_stat = '3') OR (s.test_type_english = '3' and s.test_english < 75 and s.english_placement_stat = '3')) OR ((s.test_type_reading = '0' and s.test_reading < 19 and s.reading_placement_stat = '3') OR (s.test_type_reading = '1' and s.test_reading < 470 and s.reading_placement_stat = '3') OR (s.test_type_reading = '2' and s.test_reading < 43 and s.reading_placement_stat = '3') OR (s.test_type_reading = '2' and s.test_reading = 999 and s.reading_placement_stat = '3') OR (s.test_type_reading = '3' and s.test_reading < 82 and s.reading_placement_stat = '3')) )
;";
//echo("".$queryX."
");
$resultX = odbc_exec($conn_id, $queryX);
while (odbc_fetch_row($resultX))
{
$cnt = odbc_result($resultX, 'cnt');
}
}
echo("".number_format($cnt,0)." | ");
$cnt_total = $cnt_total + $cnt;
if ($inst_type == '1') { $cnt_1 = $cnt_1 + $cnt; }
if ($inst_type == '2') { $cnt_2 = $cnt_2 + $cnt; }
if ($inst_type == 'P') { $cnt_P = $cnt_P + $cnt; }
if ($inst_type == 'V') { $cnt_V = $cnt_V + $cnt; }
echo("
");
}
// SUMMARY
echo("");
echo("| 4-Year Universities | ");
echo("".number_format($cnt_1,0)." | ");
echo("
");
// TOTALS FOR 2-YEAR COLLEGES
echo("");
echo("| 2-Year Colleges | ");
echo("".number_format($cnt_2,0)." | ");
echo("
");
// TOTALS FOR PRIVATES
/*echo("");
echo("| ".number_format($cnt_P,0)." | ");
echo("
"); */
// TOTALS FOR BSN AND JSN
/*echo("");
echo("| ".number_format($cnt_V,0)." | ");
echo("
"); */
// TOTALS FOR ALL
echo("");
echo("| Totals | ");
echo("".number_format($cnt_total,0)." | ");
echo("
");
echo("
");
odbc_free_result($result1);
odbc_free_result($result2);
odbc_free_result($result3);
odbc_free_result($result4);
odbc_free_result($result5);
odbc_free_result($result6);
odbc_free_result($result7);
odbc_free_result($result8);
odbc_free_result($resultX);
odbc_free_result($resultx);
odbc_error();
odbc_close($conn_id);
?>