<?php
ob_start();
include('headMain.php');
//late registration
//die();
$matNo=	 $_SESSION['matNo'];
/*$sqlr=$db->query("select late from realdata where matNo='$matNo'");
$numr=$sqlr->rowCount();
$numr=1;
if ($numr==1) {
    $sqlr_fetch = $sqlr->fetch(PDO::FETCH_BOTH);
     $late=$sqlr_fetch['late'];
}else{
    $late=1;
}

if ($late==0){
    echo "<h2 style='color: red'>2015/2016 Second Semester Registration Has Closed</h2>";

}else {
*/
    //header('location:'.'../student/remitaschoolfee.php');
    //require_once('../connect.php');
    $db = db_connect();
    if (!isset($_SESSION['matNo'])) {
        header('location:' . 'login.php');
    }
    $matNo = $_SESSION['matNo'];
    $semester = $_SESSION['asemester'];
    $asession = $_SESSION['asession'];
    $deptID = $_SESSION['deptID'];
   //
    $s = "select * from eace_remitaorder where regNo='$matNo'and paymenttype like '%School Fees' and transApproved='True'";
    $r = $db->query($s);
    $n = $r->rowCount();
    if ($n == 0) {
        header('location:' . 'remitaschoolfee.php');
    }
   // die("$matNo");
    ?>
    <?php
    //			 require_once('../connect.php');
    extract($_POST);
    /*  $sql_current=mysql_query("select * from current");
      $num_current=mysql_num_rows($sql_current);
      if ($num_current>0){
          $semester=$_SESSION['asemester']=mysql_result($sql_current,0,'asemester');
          $asession=$_SESSION['asession']=mysql_result($sql_current,0,'asession');

      }
      */ ?>
    <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 Outstanding Courses for <?php echo $semester.'-('.$_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
    // echo $deptID.'kjhkjdgasgj';
    $levelID = $_SESSION['levelID'];

    $levelID = $_SESSION['levelID'] - 1;
    if ($levelID == '6') {
        $levelID2 = $_SESSION['levelID'] - 2;
    } else {
        $levelID2 = $_SESSION['levelID'] - 1;
    }

    $dept = $_SESSION['course'];

    if ($dept == 'Office Technology and Management') {
        $sql = $db->query("select * from coursepool where (levelID='$levelID' or levelID='$levelID2') and dept='$dept' and (semester='$semester' or postR='1')");
    } 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 eace_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();
                //echo $carryNum.'kjlskhdlkhlh';
                //echo $levelID;
                //echo $levelID2;
                if (($levelID == 1) or ($levelID == 3) or ($levelID == 5) or ($levelID == 6) or ($levelID == 8)) {
                    if ($carryNum > 0) {
                        ?>
                        <a href="courseReg.php"> Go Back</a>
                        <?php
                        $sSQL = $db->query("select * from eace_realdata where matNo='$matNo' and fresher LIKE '%0'");
                        $sNum = $sSQL->rowCount();
                        if ($sNum > 0) {
                            echo '<br><a href="courseRegc.php"> Select Outstanding Second Semester Courses</a> ';
                        }
                    }
                    // echo $carryNum.'kjlskhdlkhlh<br>';
                    // echo $deptID.'hhhhhhh';
                    if (($deptID == '12') and ($carryNum > 0)) {
                        echo '<br><a href="courseRegSTAT.php"> Select Outstanding Courses From DPT I/II</a> ';
                    }

                    if (($deptID == '20') and ($carryNum > 0)) {
                        echo '<a href="courseRegOTM.php"> Select Special Outstanding 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');
?>