| Server IP : 172.64.80.1 / Your IP : 172.71.120.135 Web Server : Apache System : Linux mail.federalpolyede.edu.ng 5.10.0-32-amd64 #1 SMP Debian 5.10.223-1 (2024-08-10) x86_64 User : federalpolyede.edu.ng_idh35skikv ( 10000) PHP Version : 7.4.33 Disable Function : opcache_get_status MySQL : OFF | cURL : ON | WGET : OFF | Perl : OFF | Python : OFF | Sudo : OFF | Pkexec : OFF Directory : /var/www/vhosts/federalpolyede.edu.ng/httpdocs_backup/admissionProcess/ |
Upload File : |
<?php
/**
* Created by PhpStorm.
* User: fpe
* Date: 7/3/2020
* Time: 10:02 PM
*/
ini_set('memory_limit', '512M');
require_once('../connect.php');
$db=db_connect();
$counter=0;
$counterFailed=0;
$dateIn=date('y-m-d');
//print_r(error_reporting(E_ALL));
// $adisa="select * from stddata where cal_status<>0 and formNo='FPE/ADM/2025/12282' LIMIT 0,1000";
$adisa="select * from stddata where cal_status=0 LIMIT 0,1000";
//die();
// $adisa="select * from stddata where formNo='FPE/ADM/2024/04931' LIMIT 0,1000";
$adisaSQL=$db->query($adisa);
$adisaSQL->rowCount();
//die();
while ($row1=$adisaSQL->fetch(PDO::FETCH_BOTH)) {
$formNo = $row1['formNo'];
$count_result = 0;
$count_result_g1 = 0;
$count_result_g11 = 0;
$count_result_g12 = 0;
$count_result_g13 = 0;
$count_result_g14 = 0;
$count_result_g15 = 0;
$count_result_g16 = 0;
$count_result_g17 = 0;
$count_result_g18 = 0;
$count_result_g2 = 0;
$count_result_g21 = 0;
$count_result_g22 = 0;
$count_result_g23 = 0;
$count_result_g24 = 0;
$count_result_g25 = 0;
$count_result_g26 = 0;
$count_result_g27 = 0;
$count_result_g28 = 0;
$count_result_g0 = 0;
$count_result_g3 = 0;
$count_result_g31 = 0;
$count_result_g32 = 0;
$count_result_g33 = 0;
$count_result_g34 = 0;
$count_result_g35 = 0;
$subject_pool = '';
$subject_pool2 = '';
$totalSC = 0;
//echo "select * from preolevel where formNo='$formNo'";
$sqlk = $db->query("select * from preolevel where formNo='$formNo'");
$numk = $sqlk->rowCount();
if ($numk==0){
// echo "select * from preolevel where formNo='$formNo'";
}
// die();
// die("am here");
//$i = 0;
if ($numk > 0) {
$row = $sqlk->fetch(PDO::FETCH_BOTH);
// echo "am jjj";
$oleve = ($row['olevel1'] . $row['olevel2']);
$r = strlen($oleve);
$olevel = substr($oleve, 0, $r - 2);
// echo $oleve[12];
// die();
// echo '=========================================<br>';
// echo $oleve;
$d = explode(',', trim($olevel));
// echo trim($olevel);
$coun = count($d) - 1;
$sola = '';
for ($j = 0; $j < $coun; ++$j) {
// echo $dww;
$subject_all = $d[$j];
// echo '<br>';
$ok = explode('-', $subject_all);
$countt = count($ok);
$subj[$j] = trim($ok[0]);
if (isset($ok[1])) {
$sub_grade[$j] = trim($ok[1]);
}
}
// echo $coun;
for ($r = 0; $r < $coun; ++$r) {
if ($sub_grade[$r] == 'D7') {
unset($subj[$r]);
}
}
for ($r = 0; $r < $coun; ++$r) {
if ($sub_grade[$r] == 'E8') {
unset($subj[$r]);
}
}
for ($r = 0; $r < $coun; ++$r) {
if ($sub_grade[$r] == 'AR') {
unset($subj[$r]);
}
}
for ($r = 0; $r < $coun; ++$r) {
if ($sub_grade[$r] == 'F9') {
unset($subj[$r]);
}
}
for ($r = 0; $r < $coun; ++$r) {
if ($sub_grade[$r] == 'P7') {
unset($subj[$r]);
}
}
for ($r = 0; $r < $coun; ++$r) {
if ($sub_grade[$r] == 'P8') {
unset($subj[$r]);
}
}
if (isset($subj)) {
$realOlevel = '';
$v = array_unique($subj);
// echo array_search('Mathematics', $v);
// $a=array_search($v[12], $v);
// var_dump($v);
$dd = count($v);
for ($p = 0; $p < 18; ++$p) {
if (isset($v[$p])) {
$a = array_search($v[$p], $v);
$jes = $d[$a] . ',';
$realOlevel .= $jes;
}
}
}
$dept = $row1['option'];
$rr = 0;
//echo $realOlevel;
// die("am here");
if ($formNo=='FPE/ADM/2024/14422' or $formNo=='FPE/ADM/2024/130w12'){
echo $subject_pool2;
die();
}
$sub = explode(",", $realOlevel);
$sub_count = count($sub) - 1;
for ($i = 0; $i <= $sub_count; ++$i) {
$subj = explode("-", $sub[$i]);
$jj = count($subj);
if ($jj == 2) {
$subject = trim($subj[0]);
$result = trim($subj[1]);
if (($subject == 'Principles of Accounts') || ($subject == 'Financial Accounting') || ($subject == 'Book Keeping')) {
$subject = 'Account';
}
if (($subject == 'Info. Comm. Tech.') || ($subject == 'Information and Comm. Tech.')) {
$subject = 'Info. Comm. Tech.';
}
if (($result == 'A1') || ($result == 'B2') || ($result == 'B3') || ($result == 'C4') || ($result == 'C5') || ($result == 'C6')) {
if (($subject == 'English') or ($subject == 'Mathematics')) {
if ($count_result_g0 < 2) {
$count_result_g0 += 1;
}
$subject_pool = $subject_pool . ',' . $subject;
$subject_pool2 = $subject_pool2 . ',' . $sub[$i];
}
$aspoa_fine = "select sn from dept where dOption='$dept'";
$sql_aspoa = $db->query($aspoa_fine);
$aspoa_fine_fetch = $sql_aspoa->fetch(PDO::FETCH_BOTH);
$deptID = $aspoa_fine_fetch['sn'];
if (($deptID == 1) or ($deptID == 2) or ($deptID == 7) or ($deptID == 9)or ($deptID==42)) {
$deptID = 11;
}
if (($deptID == 44) or ($deptID == 45)) {
$deptID = 25;
}
if (($deptID == 24) or ($deptID == 26)) {
$deptID = 23;
}
if (($deptID == 47) or ($deptID == 48)) {
$deptID = 3;
}
$aspoa_sub = "select * from olevelcourses where subject='$subject'";
$sql_aspoa_sub = $db->query($aspoa_sub);
$aspoa_sub_fetch = $sql_aspoa_sub->fetch(PDO::FETCH_BOTH);
$subID = $aspoa_sub_fetch['ID'];
//echo $deptID;
$aspoa_ID = "select * from tblolevelrequirement where dept_ID='$deptID' and OlevelCourse_ID='$subID'";
$sql_aspoa_ID = $db->query($aspoa_ID);
$aspoa_ID_fetch = $sql_aspoa_ID->fetch(PDO::FETCH_BOTH);
$Group1 = $aspoa_ID_fetch['Group1'];
$NumRequired = $aspoa_ID_fetch['NumRequired'];
$Child_Group = $aspoa_ID_fetch['Child_Group'];
$NumRequired_Childgroup = $aspoa_ID_fetch['NumRequired_Childgroup'];
//echo '===='.$Group1.'====';
if ($Group1 == 1) {
// if ($formNo=='FPE/ADM/2024/14422' or $formNo=='FPE/ADM/2024/13680'){
// echo $rr.'-------';
// }
if (($count_result_g1 < $NumRequired) and ($rr < 3)) {
if ($Child_Group == 0) {
// echo 'am 1here';
$count_result_g1 += 1;
$subject_pool = $subject_pool . ',' . $subject;
$subject_pool2 = $subject_pool2 . ',' . $sub[$i];
$rr = $count_result_g1 + $count_result_g2 + $count_result_g3;
// if ($formNo=='FPE/ADM/2024/14422' or $formNo=='FPE/ADM/2024/13680'){
// echo $rr.'-------';
// }
} elseif ($Child_Group == 1) {
if ($count_result_g11 < $NumRequired_Childgroup) {
$count_result_g11 += 1;
$count_result_g1 += 1;
$subject_pool = $subject_pool . ',' . $subject;
$subject_pool2 = $subject_pool2 . ',' . $sub[$i];
$rr = $count_result_g1 + $count_result_g2 + $count_result_g3;
}
} elseif ($Child_Group == 2) {
if ($count_result_g12 < $NumRequired_Childgroup) {
$count_result_g12 += 1;
$count_result_g1 += 1;
$subject_pool = $subject_pool . ',' . $subject;
$subject_pool2 = $subject_pool2 . ',' . $sub[$i];
$rr = $count_result_g1 + $count_result_g2 + $count_result_g3;
}
} elseif ($Child_Group == 3) {
if ($count_result_g13 < $NumRequired_Childgroup) {
$count_result_g13 += 1;
$count_result_g1 += 1;
$subject_pool = $subject_pool . ',' . $subject;
$subject_pool2 = $subject_pool2 . ',' . $sub[$i];
$rr = $count_result_g1 + $count_result_g2 + $count_result_g3;
}
} elseif ($Child_Group == 4) {
if ($count_result_g14 < $NumRequired_Childgroup) {
$count_result_g14 += 1;
$count_result_g1 += 1;
$subject_pool = $subject_pool . ',' . $subject;
$subject_pool2 = $subject_pool2 . ',' . $sub[$i];
$rr = $count_result_g1 + $count_result_g2 + $count_result_g3;
}
} elseif ($Child_Group == 5) {
if ($count_result_g15 < $NumRequired_Childgroup) {
$count_result_g15 += 1;
$count_result_g1 += 1;
// $subject_pool=$subject_pool.','.$subject;
$rr = $count_result_g1 + $count_result_g2 + $count_result_g3;
$subject_pool = $subject_pool . ',' . $subject;
$subject_pool2 = $subject_pool2 . ',' . $sub[$i];
}
} elseif ($Child_Group == 6) {
if ($count_result_g16 < $NumRequired_Childgroup) {
$count_result_g16 += 1;
$count_result_g1 += 1;
// $subject_pool = $subject_pool . ',' . $subject;
$rr = $count_result_g1 + $count_result_g2 + $count_result_g3;
$subject_pool = $subject_pool . ',' . $subject;
$subject_pool2 = $subject_pool2 . ',' . $sub[$i];
}
} elseif ($Child_Group == 7) {
if ($count_result_g17 < $NumRequired_Childgroup) {
$count_result_g17 += 1;
$count_result_g1 += 1;
// $subject_pool = $subject_pool . ',' . $subject;
$rr = $count_result_g1 + $count_result_g2 + $count_result_g3;
$subject_pool = $subject_pool . ',' . $subject;
$subject_pool2 = $subject_pool2 . ',' . $sub[$i];
}
} elseif ($Child_Group == 8) {
if ($count_result_g18 < $NumRequired_Childgroup) {
$count_result_g18 += 1;
$count_result_g1 += 1;
// $subject_pool = $subject_pool . ',' . $subject;
$rr = $count_result_g1 + $count_result_g2 + $count_result_g3;
$subject_pool = $subject_pool . ',' . $subject;
$subject_pool2 = $subject_pool2 . ',' . $sub[$i];
}
}
}
}
if ($Group1 == 2) {
if (($count_result_g2 < $NumRequired) and ($rr < 3)) {
if ($Child_Group == 0) {
$count_result_g2 += 1;
$subject_pool = $subject_pool . ',' . $subject;
$subject_pool2 = $subject_pool2 . ',' . $sub[$i];
$rr = $count_result_g1 + $count_result_g2 + $count_result_g3;
} elseif ($Child_Group == 1) {
if ($count_result_g21 < $NumRequired_Childgroup) {
$count_result_g21 += 1;
$count_result_g2 += 1;
$subject_pool = $subject_pool . ',' . $subject;
$subject_pool2 = $subject_pool2 . ',' . $sub[$i];
$rr = $count_result_g1 + $count_result_g2 + $count_result_g3;
}
} elseif ($Child_Group == 2) {
if ($count_result_g22 < $NumRequired_Childgroup) {
$count_result_g22 += 1;
$count_result_g2 += 1;
$subject_pool = $subject_pool . ',' . $subject;
$subject_pool2 = $subject_pool2 . ',' . $sub[$i];
$rr = $count_result_g1 + $count_result_g2 + $count_result_g3;
}
} else if ($Child_Group == 3) {
if ($count_result_g23 < $NumRequired_Childgroup) {
$count_result_g23 += 1;
$count_result_g2 += 1;
$subject_pool = $subject_pool . ',' . $subject;
$subject_pool2 = $subject_pool2 . ',' . $sub[$i];
$rr = $count_result_g1 + $count_result_g2 + $count_result_g3;
}
} elseif ($Child_Group == 4) {
if ($count_result_g24 < $NumRequired_Childgroup) {
$count_result_g24 += 1;
$count_result_g2 += 1;
$subject_pool = $subject_pool . ',' . $subject;
$subject_pool2 = $subject_pool2 . ',' . $sub[$i];
$rr = $count_result_g1 + $count_result_g2 + $count_result_g3;
}
} elseif ($Child_Group == 5) {
if ($count_result_g25 < $NumRequired_Childgroup) {
$count_result_g25 += 1;
$count_result_g2 += 1;
$subject_pool = $subject_pool . ',' . $subject;
$subject_pool2 = $subject_pool2 . ',' . $sub[$i];
$rr = $count_result_g1 + $count_result_g2 + $count_result_g3;
}
} elseif ($Child_Group == 6) {
if ($count_result_g26 < $NumRequired_Childgroup) {
$count_result_g26 += 1;
$count_result_g2 += 1;
// $subject_pool = $subject_pool . ',' . $subject;
$rr = $count_result_g1 + $count_result_g2 + $count_result_g3;
$subject_pool = $subject_pool . ',' . $subject;
$subject_pool2 = $subject_pool2 . ',' . $sub[$i];
}
} elseif ($Child_Group == 7) {
if ($count_result_g27 < $NumRequired_Childgroup) {
$count_result_g27 += 1;
$count_result_g2 += 1;
// $subject_pool = $subject_pool . ',' . $subject;
$rr = $count_result_g1 + $count_result_g2 + $count_result_g3;
$subject_pool = $subject_pool . ',' . $subject;
$subject_pool2 = $subject_pool2 . ',' . $sub[$i];
}
} elseif ($Child_Group == 7) {
if ($count_result_g27 < $NumRequired_Childgroup) {
$count_result_g27 += 1;
$count_result_g2 += 1;
// $subject_pool = $subject_pool . ',' . $subject;
$rr = $count_result_g1 + $count_result_g2 + $count_result_g3;
$subject_pool = $subject_pool . ',' . $subject;
$subject_pool2 = $subject_pool2 . ',' . $sub[$i];
}
}
}
}
// echo $Group1."=";
// if ($formNo=='FPE/ADM/2024/14422' or $formNo=='FPE/ADM/2024/13680'){
// echo $rr.$Group1."main";
// }
if ($Group1 == 3) {
// if ($formNo=='FPE/ADM/2024/14422' or $formNo=='FPE/ADM/2024/13680'){
// echo $rr.'am here';
// }
if (($count_result_g3 < $NumRequired) and ($rr < 3)) {
if ($Child_Group == 0) {
$count_result_g3 += 1;
$subject_pool = $subject_pool . ',' . $subject;
$rr = $count_result_g1 + $count_result_g2 + $count_result_g3;
} elseif ($Child_Group == 1) {
if ($count_result_g31 < $NumRequired_Childgroup) {
$count_result_g31 += 1;
$count_result_g3 += 1;
$subject_pool = $subject_pool . ',' . $subject;
$subject_pool2 = $subject_pool2 . ',' . $sub[$i];
$rr = $count_result_g1 + $count_result_g2 + $count_result_g3;
}
} elseif ($Child_Group == 2) {
if ($count_result_g32 < $NumRequired_Childgroup) {
$count_result_g32 += 1;
$count_result_g3 += 1;
$subject_pool = $subject_pool . ',' . $subject;
$subject_pool2 = $subject_pool2 . ',' . $sub[$i];
$rr = $count_result_g1 + $count_result_g2 + $count_result_g3;
}
} elseif ($Child_Group == 3) {
if ($count_result_g33 < $NumRequired_Childgroup) {
$count_result_g33 += 1;
$count_result_g3 += 1;
$subject_pool = $subject_pool . ',' . $subject;
$subject_pool2 = $subject_pool2 . ',' . $sub[$i];
$rr = $count_result_g1 + $count_result_g2 + $count_result_g3;
}
}
if ($Child_Group == 4) {
if ($count_result_g34 < $NumRequired_Childgroup) {
$count_result_g34 += 1;
$count_result_g3 += 1;
$subject_pool = $subject_pool . ',' . $subject;
$subject_pool2 = $subject_pool2 . ',' . $sub[$i];
$rr = $count_result_g1 + $count_result_g2 + $count_result_g3;
}
} elseif ($Child_Group == 5) {
if ($count_result_g25 < $NumRequired_Childgroup) {
$count_result_g25 += 1;
$count_result_g3 += 1;
$subject_pool = $subject_pool . ',' . $subject;
$subject_pool2 = $subject_pool2 . ',' . $sub[$i];
$rr = $count_result_g1 + $count_result_g2 + $count_result_g3;
}
}
}
}
}
}
}
$count_resultf = $count_result_g0 + $count_result_g1 + $count_result_g2 + $count_result_g3;
// echo "am here";
// die();
$subject_pool2 = trim($subject_pool2);
$kadisa = explode(' , ', $subject_pool2);
$rsk = count($kadisa);
$ssd = '';
$scALL = '';
// $totalSC=0;
// $scALL='';
// die();
$a = '';
for ($k = 0; $k < $rsk; ++$k) {
$h = substr($kadisa[$k], strlen($kadisa[$k]) - 2, 2);
if ($h == 'A1') {
$sc = 6;
} elseif ($h == 'B2') {
$sc = 5;
} elseif ($h == 'B3') {
$sc = 4;
} elseif ($h == 'C4') {
$sc = 3;
} elseif ($h == 'C5') {
$sc = 2;
} elseif ($h == 'C6') {
$sc = 1;
} else {
$sc = 0;
}
// echo $sc;
$scALL = $scALL . ',' . $sc;
$totalSC = $totalSC + $sc;
// echo $scALL;
}
$t = $totalSC . $scALL;
// die();
// echo $subject_pool2;
// echo $adisa="INSERT INTO `olevel_screening` (`ID`, `formNo`, `olevelResult`, `olevelGrades`, `dateIn`, `status`,`no_olevel`)VALUES (NULL, '$formNo', '$subject_pool2', '$t', '$dateIn', '1','$count_resultf')";
// die();
// echo $totalSC;
// $totalSC=0;
// echo $scALL;
// echo $t;
// die();
if ($formNo=='FPE/ADM/2025/122821'){
// echo $subject_pool2;
// echo $dept.'----'.$deptID.'----';
}
// die();
if ($count_resultf == 5) {
$adisa = "INSERT INTO `olevel_screening` (`ID`, `formNo`, `olevelResult`, `olevelGrades`, `dateIn`, `status`,`no_olevel`)
VALUES (NULL, '$formNo', '$subject_pool2', '$t', '$dateIn', '1','$count_resultf')";
$aspoa = $db->query($adisa);
$db->query("INSERT INTO `cbtscore` (`sn`, `formNo`, `score`, `dept`) VALUES (NULL, '$formNo', '$totalSC', '$dept')");
if ($adisa) {
$counter += 1;
$db->query("UPDATE stddata SET cal_status=1 where formNo='$formNo'");
}
} else {
// die("herererr");
$db->query("UPDATE stddata SET cal_status='$count_resultf' where formNo='$formNo'");
$counterFailed += 1;
}
// if ($formNo=='FPE/ADM/2024/14422' or $formNo=='FPE/ADM/2024/13680'){
// echo $subject_pool2;
// }
}
}
echo $counter.' Calculated Successfully';
echo '<hr>'.$counterFailed.' Not Qualify or Not having O\'level up to 5';