";
echo "
Seneff Honors College Scholar
";
echo "
| Graduate |
Program |
Awarded |
";
$getstudents = "select * from BANINST1.Z_SZRGRHR where TERM_CODE_GRADUATED='".$term_Select."' order by DIPLOMA_NAME, STUDENT_NAME_LFMI";
$results2 = oci_parse( $Oracleconn, $getstudents );
oci_execute( $results2 );
while ( ( $row2 = oci_fetch_array( $results2, OCI_ASSOC ) ) != false ) {
$Degree_Status_Code = $row2['DEGREE_STATUS_CODE'] ?? '';
$GPA = $row2['GRADUATION_GPA'] ?? '0';
if ($Degree_Status_Code === 'PD')
{$Posthumous = " ";}
else {$Posthumous = "";}
if ($GPA >= 3.75)
{$GPAHonors = " ";}
else {$GPAHonors = '';}
$Degree_Honors = $row2['DEGREE_HONORS'] ?? '';
switch ($Degree_Honors){
case "Seneff Honors College Scholar":
$Honors = " ";
break;
case "Valencia Honors Scholar":
$Honors = " ";
break;
case "Honors Certificate":
$Honors =" ";
break;
default:
$Honors = $Degree_Honors;
break;
}
$Program_Description = $row2['PROGRAM_DESCRIPTION'] ?? '';
$Degree_Description = $row2['DEGREE_DESCRIPTION'] ?? '';
$name = $row2['DIPLOMA_NAME']??$row2['STUDENT_NAME_FMIL'];
echo "
| ".$name.$GPAHonors.$Honors." |
".$Program_Description." |
".$Degree_Description.$Posthumous." |
";
}
if ($term_Select == '202420')
{
//Adding AST students
$ast_filename = "ast-spring-2024-graduate-list.json";
$ast_url = $directory."\\".$ast_filename;
$ast_string = file_get_contents($ast_url);
$ast_array = json_decode($ast_string, true);
foreach ($ast_array as $info) {echo "| ".$info['Graduate']." | ".$info['Program']." | ".$info['Awarded']." |
"; }
}
echo "
";
($_SERVER['DOCUMENT_ROOT'] . "//students/graduation/grad-list-modals.inc");
?>