| Server IP : 172.64.80.1 / Your IP : 172.70.50.62 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'];
$title="National Diploma Admission Progress (ND RPT)";
$levelName=$_SESSION['levelName'];
$formT=$_SESSION['formT'];
include('headMain.php');
//die("here");
//require_once('check_passport_sign.php');
//$matNo= $_SESSION['matNo'];
//extract($_POST);
$dept=$_SESSION['dept'];
if ($dept=="Select Option..."){
header('location:adm_recommend.php?IDD=1&ID=$levelID');
}
if($dept=="All Department"){
$sqla=$db->query("select * from vw_stddata_pts where level='$levelName' and (admStatus=3 or admStatus=3)");
$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=3";
}else{
$sqla=$db->query("select * from vw_stddata_pts where level='$levelName' and `option`='$dept' and (admStatus=3 or admStatus=3)");
$sqlb="select $formT 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[$formT];
}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;
$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='';
}
//require_once('print/check_maxUnit.php')
?>
<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="adm_app_ndft_process2.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>
<div style="font-size: 18px"> <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>Screening Score</strong></td>
<th><strong>Aggregate</strong></td>
<th><strong>Operator</strong></td>
</tr>
</thead>
<tbody>
<?php
// echo "select * from vw_stddata_utmeform where level='$levelName' and `option`='$dept' and admStatus=1";
$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="iNum"
id="hiddenField4"
value="<?php echo $k; ?>"/>
</td>
<td><a href="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['score']; ?>
<input type="hidden"
name="<?php echo 'postUTME[' . $i . ']'; ?>"
id="hiddenField"
value="<?php echo $row['score']; ?>"/>
</td>
<td><?php echo $agg=$row['aggregate']; ?>
<input type="hidden"
name="<?php echo 'aggregate[' . $i . ']'; ?>"
id="hiddenField"
value="<?php echo $agg; ?>"/>
</td>
<td><label for="checkbox"><a href="remove_app.php?formNo='<?php echo $row['formNo'];?>'">Revert Approval</a></label></td>
</tr>
<?php
++$i;
}
?>
<?php
} else {
?>
<tr>
<td colspan="4"><?php echo "No Candidate Recommended for Approval";
}
?></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');
?>