<?php
ob_start();
include('headMain.php');
//die("here");
//require_once('check_passport_sign.php');

$matNo=	 $_SESSION['matNo'];

    require_once('../connect.php');
require_once('check_payment2.php');

$outCourse=$db->query("select * from summertable where matNo='$matNo'");
$outCourse_num=$outCourse->rowCount();
if ($outCourse_num==1){
    $outCourse_fetch=$outCourse->fetch(PDO::FETCH_BOTH);
    $trayCourse=$outCourse_fetch['carryCourse'];
}else{
    $trayCourse='';
}
    ?>
    <div id="wrapper">

        <td><form id="form1" name="form1" method="post" action="nce_courseReg2.php" role="form" >
                <tr>
                    <fieldset>
                        <legend>
                            <div class="row">
                                <div ></div>
                                <div class="col-lg-12">
                                    <div class="panel panel-default">
                                        <div class="panel-heading">
                                            Course Registration(<?php echo $_SESSION['matNo'].' - '.$_SESSION['nce_deptName'];?>)
                                        </div>
                                        <div class="alert alert-info">Outstanding Course(s): <?php echo $trayCourse;?> </div>
                                        <div class="panel-body">

                                            <div class="row">
                                                <div class="col-lg-12">
                                                        <table width="100%" align="center" cellpadding="3" cellspacing="5">
                                                            <tr>
                                                                <td><table width="100%" cellspacing="5" cellpadding="3" class="table table-striped">
                                                                        <tr bgcolor="#999999">
                                                                            <td><strong>Course Code</strong></td>
                                                                            <td><strong>Course Title</strong></td>
                                                                            <td><strong>Course Unit</strong></td>
                                                                            <td><strong>Check to Select</strong></td>
                                                                        </tr>
                                                                        <?php
                                                                        $levelID = $_SESSION['levelID'];
                                                                        $dept = $_SESSION['course'];

                                                                        $nce="select * from dept where dOption='$dept'";
                                                                        $nce_ex=$db->query($nce);
//                                                                        echo $nce_ex->rowCount();
                                                                        if ($nce_ex->rowCount()>0){
                                                                            $nce_fetch=$nce_ex->fetch(PDO::FETCH_BOTH);
                                                                            $nce_dept=$nce_fetch['nce_dept'];
//                                                                            echo  $dept;
//
//die();
                                                                        }




    $sql = $db->query("select * from coursepool_nce where levelID='$levelID' and (dept='$nce_dept' or dept='General Studies' or dept='Education Courses') and semester='$semester' ");
    // }


    //$sql_fetch=$sql->fetch(PDO::FETCH_BOTH);
    $num = $sql->rowCount();
    $i = 0;
    if ($num > 0) {
        while ($row = $sql->fetch(PDO::FETCH_BOTH)) {
            ?>
            <tr>
                <td><?php echo $row['courseCode'];?>
                    <input type="hidden" name="<?php echo 'courseCode[' . $i . ']';?>" id="hiddenField3"
                           value="<?php echo $row['courseCode'];?>"/>
                    <input type="hidden" name="rNum" id="hiddenField4" value="<?php echo $num;?>"/></td>
                <td><?php echo $row['courseTitle'];?>
                    <input type="hidden" name="<?php echo 'courseTitle[' . $i . ']';?>" id="hiddenField2"
                           value="<?php echo $row['courseTitle'];?>"/></td>
                <td><?php echo $row['courseUnit'];?>
                    <input type="hidden" name="<?php echo 'courseUnit[' . $i . ']';?>" id="hiddenField"
                           value="<?php echo $row['courseUnit'];?>"/></td>
                <td><input type="checkbox" name="<?php echo 'course[' . $i . ']';?>" id="checkbox"
                           value="<?php echo $courseEnable = $row['courseCode'];

                           // if ($deptID==20);

                           $aspoa = $db->query("select * from eace_coursereg_nce where matNo='$matNo' and  courseCode='$courseEnable' and semester='$semester' ");
                           $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

            ++$i;
        }
        ?>
        <tr>
            <td>&nbsp;</td>
            <td>&nbsp;</td>
            <td>&nbsp;</td>
            <td><input class="btn btn-primary btn-block" type="submit" name="submit" id="submit" value="Add"/></td>
        </tr>
        <tr>
            <td colspan="4">
                <?php
                $carrySQL = $db->query("select * from summertable where  matNo='$matNo' and carryCourse not LIKE 'PASSED.%' order by sn limit 0,1");
                // echo $semester;

                $carryNum = $carrySQL->rowCount();
                if (($levelID == 2) or ($levelID == 4) or ($levelID == 6) or ($levelID == 7) or ($levelID == 9)) {
                    if ($carryNum > 0) {
                        ?>
                        <a href="courseRegb.php"> Select Outstanding Courses</a>
                        <?php
                        $sSQL = $db->query("select * from eace_realdata where matNo='$matNo' and fresher LIKE '%0'");
                        $sNum = $sSQL->rowCount();
                        if ($sNum > 0) {
//                            echo '<a href="courseRegc.php"> Select Outstanding Second Semester Courses</a> ';
                        }
                    }
                }
                // echo $dept;
                //echo $carryNum;


                ?>
            </td>
        </tr>
    <?php

    } else {
        ?>

        <tr>
        <td colspan="4"><?php echo "No Course was Setup for this level";
    }

    ?></td>
                                                                        </tr>
                                                                        </table>
                                                            </td>
                                                            </tr>
                                                            </table>
                                                    </div>
                                                </div>
                                            </div>
                                        </div>
                                    </div>
                                </div>
                            </legend>

                        </fieldset>
                    </tr>
                </form>
            </td>
    </div>
    </div>
            <?php
include('footMain.php');
?>