");
echo("| ".$n++." | ");
echo("".$inst_type." | ");
echo("".$abbr." | ");
//echo("".$fice_code." | ");
$query2 = "SELECT DISTINCT g.ssn_id,
g.degree_level AS dl,
g.degree_1,
g.graduation_date
FROM sisdb.dbo.graduated_student_table g
WHERE g.fice_code = '".$fice_code."'
AND g.academic_year = '".$acadyr."'
".$dl_code."
GROUP BY g.ssn_id, g.degree_level, g.degree_1, g.graduation_date;";
//echo("".$query2."
");
$doc19 = 0; $doc1925 = 0; $doc18 = 0; $doc1825 = 0; $doc17 = 0; $doc1725 = 0;
$pfpd = 0; $pfpd25 = 0; $pfpc = 0; $pfpc25 = 0;
$doc10 = 0; $doc1025 = 0; $doc09 = 0; $doc0925 = 0;
$spec = 0; $spec25 = 0; $mast = 0; $mast25 = 0; $pbacc = 0; $pbacc25 = 0;
$grd = 0; $grd25 = 0;
$bacc = 0; $bacc25 = 0;
$ac = 0; $ac25 = 0; $assoc = 0; $assoc25 = 0;
$tc = 0; $tc25 = 0; $cp = 0; $cp25 = 0;
$result2 = mssql_query($query2, $conn_id);
$num2 = mssql_num_rows($result2);
for ($b = 0; $b < $num2; $b++)
{
$line2 = mssql_fetch_assoc($result2);
$ssn_id = $line2['ssn_id'];
$dl = $line2['dl'];
$graduation_date = $line2['graduation_date'];
// begin multiple birthday test
$query3a = "SELECT DISTINCT s.ssn_id AS ssn,
COUNT(DISTINCT(s.date_of_birth)) AS cnt
FROM student_table s
WHERE s.fice_code = '".$fice_code."'
AND s.academic_year BETWEEN '".$acadyr_1."' AND '".$acadyr."'
AND s.ssn_id = '".$ssn_id."'
GROUP BY s.ssn_id
ORDER BY s.ssn_id;";
//echo("Query 3a = ".$query3a."
");
$result3a = mssql_query($query3a, $conn_id);
$num3a = mssql_num_rows($result3a);
for ($c = 0; $c < $num3a; $c++)
{
$line3a = mssql_fetch_assoc($result3a);
$ssn = $line3a['ssn'];
$cnt = $line3a['cnt'];
//echo("".$ssn."-".$cnt."
");
$dob = '';
if($cnt == 1)
{
$query3b = "SELECT DISTINCT(s.date_of_birth) AS dob
FROM student_table s
WHERE s.fice_code = '".$fice_code."'
AND s.academic_year BETWEEN '".$acadyr_1."' AND '".$acadyr."'
AND s.ssn_id = '".$ssn_id."'
ORDER BY s.date_of_birth;";
//echo("Query 3b = ".$query3b."
");
$result3b = mssql_query($query3b, $conn_id);
$num3b = mssql_num_rows($result3b);
for ($d = 0; $d < $num3b; $d++)
{
$line3b = mssql_fetch_assoc($result3b);
$dob = $line3b['dob'];
}
//echo($dob."
");
}
if($cnt > 1)
{
$query3c = "SELECT s.date_of_birth AS dob,
MAX(s.academic_year + s.term) AS yrtrm
FROM student_table s
WHERE s.fice_code = '".$fice_code."'
AND s.academic_year BETWEEN '".$acadyr_1."' AND '".$acadyr."'
AND s.ssn_id = '".$ssn_id."'
AND s.term IN ('0', '1', '2', '3')
GROUP BY s.date_of_birth
ORDER BY yrtrm;";
$result3c = mssql_query($query3c, $conn_id);
$num3c = mssql_num_rows($result3c);
for ($e = 0; $e < $num3c; $e++)
{
$line3c = mssql_fetch_assoc($result3c);
$dob = $line3c['dob'];
$yrtrm = $line3c['yrtrm'];
}
}
// end multiple birthday test
}
if($dl == '19')
{
$doc19++;
$grad_mo = (substr($graduation_date,0,2) / 12);
$grad_yr = substr($graduation_date,2,4);
$dob_mo = (substr($dob,0,2) / 12);
$dob_yr = substr($dob,4,4);
$age_doc19 = ($grad_yr - $dob_yr) + ($grad_mo - $dob_mo);
// echo(number_format($age_doc19,2)."
");
if ($age_doc19 >= 25.00)
{ $doc1925++; }
}
if($dl == '18')
{
$doc18++;
$grad_mo = (substr($graduation_date,0,2) / 12);
$grad_yr = substr($graduation_date,2,4);
$dob_mo = (substr($dob,0,2) / 12);
$dob_yr = substr($dob,4,4);
$age_doc18 = ($grad_yr - $dob_yr) + ($grad_mo - $dob_mo);
// echo(number_format($age_doc18,2)."
");
if ($age_doc18 >= 25.00)
{ $doc1825++; }
}
if($dl == '17')
{
$doc17++;
$grad_mo = (substr($graduation_date,0,2) / 12);
$grad_yr = substr($graduation_date,2,4);
$dob_mo = (substr($dob,0,2) / 12);
$dob_yr = substr($dob,4,4);
$age_doc17 = ($grad_yr - $dob_yr) + ($grad_mo - $dob_mo);
// echo(number_format($age_doc17,2)."
");
if ($age_doc17 >= 25.00)
{ $doc1725++; }
}
if($dl == '12')
{
$pfpd++;
$grad_mo = (substr($graduation_date,0,2) / 12);
$grad_yr = substr($graduation_date,2,4);
$dob_mo = (substr($dob,0,2) / 12);
$dob_yr = substr($dob,4,4);
$age_pfpd = ($grad_yr - $dob_yr) + ($grad_mo - $dob_mo);
// echo(number_format($age_pfpd,2)."
");
if ($age_pfpd >= 25.00)
{ $pfpd25++; }
}
if($dl == '11')
{
$pfpc++;
$grad_mo = (substr($graduation_date,0,2) / 12);
$grad_yr = substr($graduation_date,2,4);
$dob_mo = (substr($dob,0,2) / 12);
$dob_yr = substr($dob,4,4);
$age_pfpc = ($grad_yr - $dob_yr) + ($grad_mo - $dob_mo);
// echo(number_format($age_pfpc,2)."
");
if ($age_pfpc >= 25.00)
{ $pfpc25++; }
}
if($dl == '10')
{
$doc10++;
$grad_mo = (substr($graduation_date,0,2) / 12);
$grad_yr = substr($graduation_date,2,4);
$dob_mo = (substr($dob,0,2) / 12);
$dob_yr = substr($dob,4,4);
$age_doc10 = ($grad_yr - $dob_yr) + ($grad_mo - $dob_mo);
// echo(number_format($age_doc10,2)."
");
if ($age_doc10 >= 25.00)
{ $doc1025++; }
}
if($dl == '09')
{
$doc09++;
$grad_mo = (substr($graduation_date,0,2) / 12);
$grad_yr = substr($graduation_date,2,4);
$dob_mo = (substr($dob,0,2) / 12);
$dob_yr = substr($dob,4,4);
$age_doc09 = ($grad_yr - $dob_yr) + ($grad_mo - $dob_mo);
// echo(number_format($age_doc09,2)."
");
if ($age_doc09 >= 25.00)
{ $doc0925++; }
}
if($dl == '08')
{
$spec++;
$grad_mo = (substr($graduation_date,0,2) / 12);
$grad_yr = substr($graduation_date,2,4);
$dob_mo = (substr($dob,0,2) / 12);
$dob_yr = substr($dob,4,4);
$age_spec = ($grad_yr - $dob_yr) + ($grad_mo - $dob_mo);
// echo(number_format($age_spec,2)."
");
if ($age_spec >= 25.00)
{ $spec25++; }
}
if($dl == '07')
{
$mast++;
$grad_mo = (substr($graduation_date,0,2) / 12);
$grad_yr = substr($graduation_date,2,4);
$dob_mo = (substr($dob,0,2) / 12);
$dob_yr = substr($dob,4,4);
$age_mast = ($grad_yr - $dob_yr) + ($grad_mo - $dob_mo);
// echo(number_format($age_mast,2)."
");
if ($age_mast >= 25.00)
{ $mast25++; }
}
if($dl == '06')
{
$pbacc++;
$grad_mo = (substr($graduation_date,0,2) / 12);
$grad_yr = substr($graduation_date,2,4);
$dob_mo = (substr($dob,0,2) / 12);
$dob_yr = substr($dob,4,4);
$age_pbacc = ($grad_yr - $dob_yr) + ($grad_mo - $dob_mo);
// echo(number_format($age_pbacc,2)."
");
if ($age_pbacc >= 25.00)
{ $pbacc25++; }
}
if ($dl == '05')
{
$bacc++;
$grad_mo = (substr($graduation_date,0,2) / 12);
$grad_yr = substr($graduation_date,2,4);
$dob_mo = (substr($dob,0,2) / 12);
$dob_yr = substr($dob,4,4);
$age_bacc = ($grad_yr - $dob_yr) + ($grad_mo - $dob_mo);
// echo(number_format($age_bacc,2)."
");
if ($age_bacc >= 25.00)
{ $bacc25++; }
}
if ($dl == '04')
{
$ac++;
$grad_mo = (substr($graduation_date,0,2) / 12);
$grad_yr = substr($graduation_date,2,4);
$dob_mo = (substr($dob,0,2) / 12);
$dob_yr = substr($dob,4,4);
$age_ac = ($grad_yr - $dob_yr) + ($grad_mo - $dob_mo);
// echo(number_format($age_ac,2)."
");
if ($age_ac >= 25.00)
{ $ac25++; }
}
if ($dl == '03')
{
$assoc++;
$grad_mo = (substr($graduation_date,0,2) / 12);
$grad_yr = substr($graduation_date,2,4);
$dob_mo = (substr($dob,0,2) / 12);
$dob_yr = substr($dob,4,4);
$age_assoc = ($grad_yr - $dob_yr) + ($grad_mo - $dob_mo);
// echo(number_format($age_assoc,2)."
");
if ($age_assoc >= 25.00)
{ $assoc25++; }
}
if ($dl == '02')
{
$tc++;
$grad_mo = (substr($graduation_date,0,2) / 12);
$grad_yr = substr($graduation_date,2,4);
$dob_mo = (substr($dob,0,2) / 12);
$dob_yr = substr($dob,4,4);
$age_tc = ($grad_yr - $dob_yr) + ($grad_mo - $dob_mo);
// echo(number_format($age_tc,2)."
");
if ($age_tc >= 25.00)
{ $tc25++; }
}
if ($dl == '01')
{
$cp++;
$grad_mo = (substr($graduation_date,0,2) / 12);
$grad_yr = substr($graduation_date,2,4);
$dob_mo = (substr($dob,0,2) / 12);
$dob_yr = substr($dob,4,4);
$age_cp = ($grad_yr - $dob_yr) + ($grad_mo - $dob_mo);
// echo(number_format($age_cp,2)."
");
if ($age_cp >= 25.00)
{ $cp25++; }
}
if (($dl == '06') || ($dl == '07') || ($dl == '08') || ($dl == '09') || ($dl == '10') || ($dl == '11') || ($dl == '12') || ($dl == '17') || ($dl == '18') || ($dl == '19'))
{
$grd++;
$grad_mo = (substr($graduation_date,0,2) / 12);
$grad_yr = substr($graduation_date,2,4);
$dob_mo = (substr($dob,0,2) / 12);
$dob_yr = substr($dob,4,4);
$age_grd = ($grad_yr - $dob_yr) + ($grad_mo - $dob_mo);
// echo(number_format($age_cp,2)."
");
if ($age_grd >= 25.00)
{ $grd25++; }
}
}
$profprac = $doc18 + $doc10;
$profprac25 = $doc1825 + $doc1025;
$resscholar = $doc17 + $doc19 + $doc09;
$resscholar25 = $doc1725 + $doc1925 + $doc0925;
$specplus = $spec + $pfpc + $pfpd;
$specplus25 = $spec25 + $pfpc25 + $pfpd25;
echo("".number_format($profprac,0)." | ");
echo("".number_format($profprac25,0)." | ");
echo("".number_format($resscholar,0)." | ");
echo("".number_format($resscholar25,0)." | ");
echo("".number_format($specplus,0)." | ");
echo("".number_format($specplus25,0)." | ");
echo("".number_format($mast,0)." | ");
echo("".number_format($mast25,0)." | ");
echo("".number_format($pbacc,0)." | ");
echo("".number_format($pbacc25,0)." | ");
echo("".number_format($bacc,0)." | ");
echo("".number_format($bacc25,0)." | ");
echo("".number_format($ac,0)." | ");
echo("".number_format($ac25,0)." | ");
echo("".number_format($assoc,0)." | ");
echo("".number_format($assoc25,0)." | ");
echo("".number_format($tc,0)." | ");
echo("".number_format($tc25,0)." | ");
echo("".number_format($cp,0)." | ");
echo("".number_format($cp25,0)." | ");
$all = $bacc + $ac + $assoc + $tc + $cp;
$all25 = $bacc25 + $ac25 + $assoc25 + $tc25 + $cp25;
//echo("".number_format($all,0)." | ");
//echo("".number_format($all25,0)." | ");
// all graduates above bachelors
//echo("".number_format($grd,0)." | ");
//echo("".number_format($grd25,0)." | ");
$profprac_total = $profprac_total + $profprac;
$resscholar_total = $resscholar_total + $resscholar;
$specplus_total = $specplus_total + $specplus;
$mast_total = $mast_total + $mast;
$pbacc_total = $pbacc_total + $pbacc;
$bacc_total = $bacc_total + $bacc;
$ac_total = $ac_total + $ac;
$assoc_total = $assoc_total + $assoc;
$tc_total = $tc_total + $tc;
$cp_total = $cp_total + $cp;
$profprac25_total = $profprac25_total + $profprac25;
$resscholar25_total = $resscholar25_total + $resscholar25;
$specplus25_total = $specplus25_total + $specplus25;
$mast25_total = $mast25_total + $mast25;
$pbacc25_total = $pbacc25_total + $pbacc25;
$bacc25_total = $bacc25_total + $bacc25;
$ac25_total = $ac25_total + $ac25;
$assoc25_total = $assoc25_total + $assoc25;
$tc25_total = $tc25_total + $tc25;
$cp25_total = $cp25_total + $cp25;
$grand_total = ($bacc_total + $ac_total + $assoc_total + $tc_total + $cp_total);
$grand25_total = ($bacc25_total + $ac25_total + $assoc25_total + $tc25_total + $cp25_total);
echo("
");
}
// all totals
echo("");
echo("| Grand Totals | ");
echo("".number_format($profprac_total,0)." | ");
echo("".number_format($profprac25_total,0)." | ");
echo("".number_format($resscholar_total,0)." | ");
echo("".number_format($resscholar25_total,0)." | ");
echo("".number_format($specplus_total,0)." | ");
echo("".number_format($specplus25_total,0)." | ");
echo("".number_format($mast_total,0)." | ");
echo("".number_format($mast25_total,0)." | ");
echo("".number_format($pbacc_total,0)." | ");
echo("".number_format($pbacc25_total,0)." | ");
echo("".number_format($bacc_total,0)." | ");
echo("".number_format($bacc25_total,0)." | ");
echo("".number_format($ac_total,0)." | ");
echo("".number_format($ac25_total,0)." | ");
echo("".number_format($assoc_total,0)." | ");
echo("".number_format($assoc25_total,0)." | ");
echo("".number_format($tc_total,0)." | ");
echo("".number_format($tc25_total,0)." | ");
echo("".number_format($cp_total,0)." | ");
echo("".number_format($cp25_total,0)." | ");
echo("
");
echo("