| Server IP : 172.64.80.1 / Your IP : 172.70.50.63 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
ob_start();
session_start();
$levelID=$_SESSION['levelID']=1;
$title="National Diploma Admission Progress (ND FT)";
$levelName=$_SESSION['levelName']='utmeForm';
$formT=$_SESSION['formT']='ndft';
include('headMain.php');
//die("here");
//require_once('check_passport_sign.php');
//$matNo= $_SESSION['matNo'];
//extract($_POST);
$dept=$_SESSION['dept']=$_POST['txtdept'];
if ($dept=="Select Option..."){
header('location:adm_approval.php?IDD=1&ID=1');
}
if($dept=="All Department"){
$sqla=$db->query("select * from vw_stddata_utmeform where level='$levelName' and(admStatus=2)");
$sqlb="select sum(ndft) as ndft from dept";
$sqlc="select count(sn) as valNo from stddata where level='$levelName' and admStatus=3";
$sqld="select count(sn) as valNok from stddata where level='$levelName' and admStatus=2";
}else{
$sqla=$db->query("select * from vw_stddata_utmeform where level='$levelName' and `option`='$dept' and (admStatus=2)");
$sqlb="select ndft from dept where dOption='$dept'";
$sqlc="select count(sn) as valNo from stddata where level='$levelName' and admStatus=3 and `option`='$dept'";
$sqld="select count(sn) as valNok from stddata where level='$levelName' and `option`='$dept' and admStatus=3";
}
require_once('../connect.php');
//require_once('check_payment2.php');
//$query="SELECT ".$formT." as ty FROM dept WHERE dOption= '$dept'";
$quota=$db->query($sqlb);
$quota_count=$quota->rowCount();
if ($quota_count==1){
$quota_fetch=$quota->fetch(PDO::FETCH_BOTH);
$quota_no=$quota_fetch['ndft'];
}else{
$quota_no='';
}
//echo "---";
$quota_admitted=$db->query($sqlc);
$quota_admitted_count=$quota_admitted->rowCount();
if ($quota_admitted_count==1){
$quota_admitted_fetch=$quota_admitted->fetch(PDO::FETCH_BOTH);
$quota_admitted_value=$quota_admitted_fetch['valNo'];
}else{
$quota_admitted_value='';
}
$quota_bal=$quota_no-$quota_admitted_value;
//require_once('print/check_maxUnit.php')
$quota_propose=$db->query($sqld);
$quota_propose_count=$quota_propose->rowCount();
if ($quota_propose_count==1){
$quota_propose_fetch=$quota_propose->fetch(PDO::FETCH_BOTH);
$quota_propose_value=$quota_propose_fetch['valNok'];
}else{
$quota_propose_value='';
}
?>
<div id="wrapper">
<div style="text-align: right"><a href="javascript:history.go(-1)"> Go to Previous page</a></div>
<td><form id="form1" name="form1" method="post" action="approval_process.php" role="form" >
<div class="row">
<div class="col-lg-12">
<!--<h1 class="page-header"></h1>-->
</div>
<!-- /.col-lg-12 -->
</div>
<!-- /.row -->
<div class="row">
<div class="col-lg-12">
<div class="panel panel-danger">
<div class="panel-heading">
<div class="alert alert-info"><b style="font-size: 20px; color: mediumvioletred">SUMMARY</b><br>
<b> Department Name:</b><?php echo $dept;?><br>
<b>Total Quota:</b> <?php echo $quota_no;?><br>
<b>Quota Admitted: </b><?php echo $quota_admitted_value;?><br>
<b>Quota Balance: </b><?php echo $quota_bal;?></div>
<b style="font-size: 18px">Approval Tray: </b><?php echo $quota_propose_value;?></div>
</div>
<!-- /.panel-heading -->
<div class="panel-body">
<div class="dataTable_wrapper">
<table class="table table-striped table-bordered table-hover" id="dataTables-example">
<thead>
<tr>
<th><strong>S/N</strong></td>
<th><strong>FormNo</strong></td>
<th><strong>Full Names</strong></td>
<th><strong>Jamb Score</strong></td>
<th><strong>Post UTME</strong></td>
<th><strong>Aggregate</strong></td>
<th><strong>O'Level_1</strong></td>
<th><strong>O'Level_2</strong></td>
<th><strong>Operator</strong></td>
</tr>
</thead>
<tbody>
<?php
$sql = $sqla;
$num = $sql->rowCount();
$i = 0;
if ($num > 0) {
while ($row = $sql->fetch(PDO::FETCH_BOTH)) {
?>
<tr>
<td><?php echo $k=$i+1; ?>
<input type="hidden"
name="<?php echo 'sn[' . $k . ']'; ?>"
id="hiddenField3"
value="<?php echo $k; ?>"/>
<input type="hidden" name="rNum"
id="hiddenField4"
value="<?php echo $num; ?>"/>
</td>
<td><a href="can_detail.php?formNo=<?php echo $row['formNo']; ?>"><?php echo $row['formNo']; ?></a>
<input type="hidden"
name="<?php echo 'formNo[' . $i . ']'; ?>"
id="hiddenField3"
value="<?php echo $row['formNo']; ?>"/>
<input type="hidden" name="formNo"
id="hiddenField4"
value="<?php echo $formNo= $row['formNo']; ?>"/>
</td>
<td><?php echo $row['names']; ?>
<input type="hidden"
name="<?php echo 'names[' . $i . ']'; ?>"
id="hiddenField2"
value="<?php echo $row['names']; ?>"/>
</td>
<td><?php echo $row['totalScore']; ?>
<input type="hidden"
name="<?php echo 'jambScore[' . $i . ']'; ?>"
id="hiddenField"
value="<?php echo $row['totalScore']; ?>"/>
</td>
<td><?php echo $row['score']; ?>
<input type="hidden"
name="<?php echo 'postUTME[' . $i . ']'; ?>"
id="hiddenField"
value="<?php echo $row['score']; ?>"/>
</td>
<td><?php
// $agg=$row['totalScore']/8+$row['score'];
echo $agg= round($row['aggregate'], 2);?>
<input type="hidden"
name="<?php echo 'aggregate[' . $i . ']'; ?>"
id="hiddenField"
value="<?php echo $agg; ?>"/>
</td>
<td><?php echo $row['olevel1']; ?>
<input type="hidden"
name="<?php echo 'olevel[' . $i . ']'; ?>"
id="hiddenField"
value="<?php echo $row['olevel1']; ?>"/>
</td>
<td><?php echo $row['olevel2']; ?>
<input type="hidden"
name="<?php echo 'olevel[' . $i . ']'; ?>"
id="hiddenField"
value="<?php echo $row['olevel2']; ?>"/>
</td>
<td><input type="checkbox"
name="<?php echo 'formNox[' . $i . ']'; ?>"
id="checkbox"
value="<?php echo $courseEnable = $row['formNo'];
$aspoa = $db->query("select * from stddata where formNo='$formNo' and admStatus=3");
$aspoa_fetch = $aspoa->fetch(PDO::FETCH_BOTH);
$num_aspoa = $aspoa->rowCount();
?>" <?php if ($num_aspoa == 1) {
echo 'disabled="disabled" checked="checked"';
} ?> />
<label for="checkbox"></label></td>
</tr>
<?php
//echo "select * from stddata where formNo='$formNo' and admStatus=2";
++$i;
}
?>
<?php
} else {
?>
<tr>
<td colspan="4"><?php echo "No Candidate Proposed for Recommendation";
}
?></td>
</tr>
</tbody>
<tr>
<td colspan="7"> </td>
<td colspan="2"><input class="btn btn-primary btn-block"
type="submit" name="submit"
id="submit" value="Submit"/></td>
</tr>
</table>
</div>
<!-- /.table-responsive -->
<div class="well">
</div>
</div>
</div>
</div>
</div>
</form>
</td>
</div>
<?php
include('footMain.php');
?>