<?php
session_start();
?>
<script src='js/far-custom.js'></script>
<script type="text/javascript" language="javascript" src="../js/jquery-1.7.1.js"></script>
<!--<script type="text/javascript" language="javascript" src="js/scriptFileLong.js"></script>-->
<!--<script type="text/javascript" language="javascript" src="js/scriptPropose.js"></script>-->
<script>
//    window.history.replaceState('','','../admissionProcessing/nd_ft_quota.php');
</script>
<script>
    $(function(){
        $("#dept").change(function(){
            alert ($("#dept").val());
            $.post("js/getQuota_dpt.php",{dept:$("#dept").val()},function(data){
                $("#quotaN").val(data);
            });
        });
    });

//    $(function(){
//        $("#myVal").click(function(){
////            alert ($("#dept").val());
//            $.post("js/getmyVal.php",{dept:$("#dept").val()},function(data){
//                $("#quotaN").val(data);
//            });
//        });
//    });

//
//        var passedArray =
//            <?php //echo json_encode($passedArray); ?>//;
//        for(var i = 0; i < passedArray.length; i++) {
//            alert(passedArray[i]);
//
//        };
//
//    var passedArray =
//        <?php //echo json_encode($sampleArray); ?>//;
//
//    // Display the array elements
//    for(var i = 0; i < passedArray.length; i++){
//       alert(passedArray.length);
//    }
</script>
<?php
if(isset($_GET['K']) && ($_GET['K']==1)){
    echo '
    <script>
    alert("Kindly Supply Valid Quota Number");
</script>';
}elseif(isset($_GET['K']) && ($_GET['K']==2)) {
    echo '
    <script>
    alert("Record Updated Successfully");
</script>';
}elseif(isset($_GET['K']) && ($_GET['K']==3)) {
    echo '
    <script>
    alert("Transaction Failed");
</script>';
}

if(isset($_GET['IDD']) && (isset($_GET['IDDD']) )){
    $de=$_GET['IDD'];
    $deQ=$_GET['IDDD'];
}else{
    $de="Select Option...";
    $deQ=0;
}
?>

<?php
/**
 * Created by PhpStorm.
 * User: fpe
 * Date: 4/21/2020
 * Time: 1:01 PM
 */

$levelID=$_SESSION['levelID']=5;
$title="National Diploma Admission Progress (ND DPT)- Quota Setting";
$levelName=$_SESSION['levelName']='dptForm';
$formT=$_SESSION['formT']='nddpt';
$level='dptForm';
require_once('headMain.php');
?>

<div class="col-lg-10 col-lg-offset-1">
    <form class="form-group-sm" action="nd_dpt_quota_process.php" method="POST">
        <div class="row"><div class="col-lg-2" align="right" style="height: 50px">Department</div>
        <div class="col-lg-4" style="height: 50px">
            <select name="txtdept" class="form-control" id="dept">
                <?php
                $sql="SELECT distinct `doption` FROM dept where dptForm=1";
                $result=$db->query($sql);
                echo '<option>'.$de.'</option>';
                while ($row=$result->fetch(PDO::FETCH_BOTH)) {
                    echo '<option>' . $row[0] . '</option>';
                }
                ?>
            </select>
            </div>
        </div>
       <div class="row">
           <div class="col-lg-2 " align="right" style="height: 50px">Quota</div>
           <div class="col-lg-4" style="height: 50px"><input type="text" class="form-control" name="quotaNo" id="quotaN" value="<?php echo $deQ ;?>"></div>
        </div>
         <div class="row">
            <div class="col-lg-2 " align="right"></div>
            <div class="col-lg-4"><input type="submit" class="form-control btn-primary img-rounded" value="Submit"></div>
            </div>

    </form>
    </div>

    <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>Department</strong></td>
                    <th><strong>Quota</strong></td>
                    <th><strong>Operator</strong></td>
                </tr>
                </thead>
                <tbody>
                <?php
 $kk_aspoa="select * from dept where dptForm=1";
$sql =  $db->query($kk_aspoa);
$num = $sql->rowCount();
$i = 0;
if ($num > 0) {
    while ($row = $sql->fetch(PDO::FETCH_BOTH)) {
        $b=$i+1;
$kA=$row['dOption'];
        $kB=$row['nddpt'];
       echo ' <tr>
            <td>'.$b.'</td>
            <td>'.$row['dOption'].'</td>
            <td>'.$row['nddpt'].'</td>
            <td><a href="nd_dpt_quota.php?ID=1&IDD='.$kA.'&IDDD='.$kB.'"><i class="far fa-edit"></i></a></td>

        </tr>';



//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>

                                </table>
            </div>
        </div>
    </div>







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