| Server IP : 172.64.80.1 / Your IP : 172.71.120.136 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/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 sn>1397 LIMIT 0,10";
$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;
$sqlk = $db->query("select * from preolevel where formNo='$formNo'");
$numk = $sqlk->rowCount();
// die();
//$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]);
}
}
$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");
$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)) {
$deptID = 11;
}
if (($deptID == 24) or ($deptID == 26)) {
$deptID = 23;
}
$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'];
if ($Group1 == 1) {
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;
} 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 ($Group1 == 3) {
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 ($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;
}
//echo $subject_pool2;
}
echo $counter.' Calculated Successfully';
echo '<hr>'.$counterFailed.' Not Qualify or Not having O\'level less than 5';