<?php
ob_start();
include('headMain.php');
$matNo=	 $_SESSION['matNo'];

    require_once('../connect.php');
//require_once('check_payment.php');
?>
    <div id="wrapper">
        <td><form id="form1" name="form1" method="post" action="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">
                                            Add Special CarryOver Courses (<?php echo $_SESSION['matNo']; ?>)
                                        </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-responsive">
                                                                        <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
    $dept = $_SESSION['course'];
    $levelID = $_SESSION['levelID'];
   echo $dept;
                                                                        echo $semester;


    // $levelID=$_SESSION['levelID']-1;


    //  if(strtoupper($dept)=='OFFICE TECHNOLOGY AND MANAGEMENT'){
                                                                        $levelID2=$levelID-1;
    $sql = $db->query("select * from coursepool where (levelID='$levelID' or levelID='$levelID2') and dept='$dept' and postR=1 and semester <>'$semester'");
    // $num=$sql->rowCount($sql);

    //  }else{

    //    $sql=$db->query("select * from coursepool where (levelID='$levelID' or levelID='$levelID2') and dept='$dept' and semester='$semester'");
    //   }
    $num = $sql->rowCount($sql);
    $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'];

                           $aspoa = $db->query("select * from coursereg where matNo='$matNo' and  courseCode='$courseEnable'");
                           $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 rawcgpa where  matNo='$matNo' and level not LIKE '%$semester%' and remark not LIKE 'PASSED.%'");
                //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 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> ';
                        }
                    }
                }
                ?>
            </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');
?>