<?php
ob_start();
session_start();
$levelID=$_SESSION['levelID']=8;
$title="National Diploma Admission Progress (ND DPT)- Proposing";
$levelName=$_SESSION['levelName']='dptForm';
$formT=$_SESSION['formT']='nddpt';
$level='dptForm';

$q_bal=$_SESSION['qbal'];
$q_admitted=$_SESSION['q_admitted'];
if ($q_bal>0){
    echo '<script>
alert("You have admitted '.$q_admitted.' remain '.$q_bal.'");
</script>';

}
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:dpt_propose.php?IDD=1&ID=5');
}
require_once('../connect.php');
//require_once('check_payment2.php');
//$query="SELECT ".$formT." as ty FROM dept WHERE dOption= '$dept'";
$quota=$db->query("select ".$formT." as nn from dept where dOption='$dept'");
$quota_count=$quota->rowCount();
if ($quota_count==1){
    $quota_fetch=$quota->fetch(PDO::FETCH_BOTH);
     $quota_no=$quota_fetch['nn'];
}else{
    $quota_no='';
}
//echo "---";
//echo $levelID;
//die();
$quota_admitted=$db->query("select count(sn) as valNo from stddata where level='$levelName' and `option`='$dept' and admStatus=3");
$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')
//echo "select count(sn) as valNok from stddata where level='$levelName' and `option`='$dept' and admStatus=0";
 $quota_propose=$db->query("select count(sn) as valNok from stddata where level='$levelName' and `option`='$dept' and admStatus=1");
$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="propose_dpt_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">Proposed Candidate: </b><?php echo $quota_propose_value;?></div>
                        </div>
                        <!-- /.panel-heading -->
                    <?php
                    if ($quota_no==0){
                        echo "Quota has to be setup before Proposing";
                        echo '<br><a href="nd_dpt_quota.php">Click Here</a>';

                    }else {


                        ?>
                        <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></th>
                                        <th><strong>FormNo</strong></th>
                                        <th><strong>Full Names</strong></th>

                                        <th><strong>Post UTME</strong></th>
                                        <th><strong>Aggregate</strong></th>
                                        <th><strong>O'Level_1</strong></th>
                                        <th><strong>O'Level_2</strong></th>
                                        <th><strong>Status</strong></th>
                                        <th><strong>Operator</strong></th>
                                    </tr>
                                    </thead>
                                    <tbody>
                                    <?php
                                    //                                        echo "select * from vw_stddata_pts where level='$levelName' and `option`='$dept' and admStatus=0 order by aggregate desc";
                                    $sql = $db->query("select * from vw_stddata_pts where level='$levelName' and `option`='$dept'  order by aggregate desc");
                                    $num = $sql->rowCount();
                                    $k = 0;
                                    $asp = 0;
                                    if ($num > 0) {
                                        while ($row = $sql->fetch(PDO::FETCH_BOTH)) {
//                                                $count_result=0;
                                            require('olevel_Check.php');
//                                                echo $count_result;
//                                                echo $row['formNo'];
//                                            }
//                                                die();
//                                            if($k==1){ss
                                              $ft=$row['admStatus'];
//                                            die();

                                            ?>
                                            <?php
                                            if ($ft==1){
                                                echo ' <tr style="background-color: rosybrown">';
                                            }
                                            if ($ft==2){
                                                echo ' <tr style="background-color: blue">';

                                            }
                                            if ($ft==3){
                                                echo ' <tr style="background-color: lightskyblue">';

                                            }
                                            if ($ft==0){
                                                echo ' <tr style="background-color: white">';

                                            }
                                            ?>

                                                <td><?php echo $asp + 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_pt.php?formNo=<?php echo $row['formNo']; ?>"><?php echo $row['formNo']; ?></a>
                                                    <input type="hidden"
                                                           name="<?php echo 'formNo[' . $asp . ']'; ?>"
                                                           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[' . $asp . ']'; ?>"
                                                           id="hiddenField2"
                                                           value="<?php echo $row['names']; ?>"/>
                                                </td>

                                                <td><?php echo $row['score']; ?>
                                                    <input type="hidden"
                                                           name="<?php echo 'postUTME[' . $asp . ']'; ?>"
                                                           id="hiddenField"
                                                           value="<?php echo $row['score']; ?>"/>
                                                </td>
                                                <td><?php //echo $agg=$row['totalScore']/8+$row['score'];
                                                    echo $agg = round($row['aggregate'], 2);
                                                    ?>
                                                    <input type="hidden"
                                                           name="<?php echo 'aggregate[' . $asp . ']'; ?>"
                                                           id="hiddenField"
                                                           value="<?php echo $agg; ?>"/>
                                                </td>
                                                <td><?php echo $row['olevel1']; ?>
                                                    <input type="hidden"
                                                           name="<?php echo 'olevel[' . $asp . ']'; ?>"
                                                           id="hiddenField"
                                                           value="<?php echo $row['olevel1']; ?>"/>
                                                </td>
                                                <td><?php echo $row['olevel2']; ?>
                                                    <input type="hidden"
                                                           name="<?php echo 'olevel[' . $asp . ']'; ?>"
                                                           id="hiddenField"
                                                           value="<?php echo $row['olevel2']; ?>"/>
                                                </td>
                                                <td><?php
                                            $gg='Not Admitted';
                                             $tetfund= $row['admStatus'];
                                            if ($tetfund==1) echo $gg='Proposed';
                                            if ($tetfund==2)echo $gg='Recommended';
                                            if ($tetfund==3)echo $gg='Approved';
                                            ?>
                                                                                <input type="hidden"
                                                                                       name="<?php echo 'postUTME[' . $asp . ']'; ?>"
                                                                                       id="hiddenField"
                                                                                       value="<?php echo $gg;?>
                                                                                       "/>
                                                                            </td>
                                                <td><input type="checkbox"
                                                           name="<?php echo 'formNox[' . $asp . ']'; ?>"
                                                           id="checkbox"
                                                           value="<?php echo $courseEnable = $row['formNo'];
                                                           $aspoa = $db->query("select * from stddata where formNo='$formNo' and admStatus>0");
                                                           $aspoa_fetch = $aspoa->fetch(PDO::FETCH_BOTH);
                                                           $num_aspoa = $aspoa->rowCount();
                                                           ?>"
                                                        <?php
                                                        if ($count_resultf < 5) {
                                                            echo 'disabled="disabled"';
                                                        } elseif ($num_aspoa == 1) {
                                                            echo 'disabled="disabled" checked="checked"';
                                                        } ?> />
                                                    <label
                                                        for="checkbox"></label><?php echo $count_resultf . '[' . $subject_pool . ']'; ?>
                                                </td>
                                            </tr>


                                            <?php

                                            $asp += 1;
                                        }
                                        ?>


                                    <?php

                                    } else {
                                    ?>
                                    <tr>
                                        <td colspan="4"><?php echo "No Candidate Applied for this Programme";
                                            }
                                            ?></td>
                                    </tr>
                                    </tbody>
                                    <tr>
                                        <td colspan="7">&nbsp;</td>

                                        <td colspan="2"><input class="btn btn-primary btn-block"
                                                               type="submit" name="submit"
                                                               id="submit" value="Submit"/></td>
                                    </tr>
                                </table>
                            </div>
                        </div>

                    <?php


                    }
                    ?>
                    </div>
                </div>
            </form>
        </td>
    </div>

<?php
include('footMain.php');
?>