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

}else{
    $late=0;
}
$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');
    if (!isset($_SESSION['matNo'])) {
        header('location:' . 'login.php');
    }
    $matNo = $_SESSION['matNo'];
    $semester = $_SESSION['asemester'];
    $asession = $_SESSION['asession'];
    $course = $_SESSION['course'];
    $res = $db->query("select * from dept where dOption='$course'");
    $res_fetch = $res->fetch(PDO::FETCH_BOTH);
    $n = $res->rowCount();
    if ($n > 0) {
        $deptID = $_SESSION['deptID'] = $res_fetch['sn'];
    }

    $statusFinder = $db->query("select * from realdata where matNo='$matNo' and levelID in ('8','9') and status<>''");
    $statusCount = $statusFinder->rowCount();
    if ($statusCount == '1') {
        $statusFinder_fetch = $statusFinder->fetch(PDO::FETCH_BOTH);
        $status = $statusFinder_fetch['status'];
    } else {
        $statusFinder2 = $db->query("select * from realdata where matNo='$matNo' and levelID not in ('8','9')");
        $statusCount2 = $statusFinder2->rowCount();
        $statusFinder_fetch2 = $statusFinder2->fetch(PDO::FETCH_BOTH);
        $formNoo = $statusFinder_fetch2['formNo'];
        $de_status = $statusFinder_fetch2['status'];
        $formNo1 = $db->query("select * from admitted where formNo='$formNoo'");
        if ($formNo1->rowCount() > 0) {
            $formStatus_fetch = $formNo1->fetch(PDO::FETCH_BOTH);
            $formStatus = $formStatus_fetch['status'];
            $status = $formStatus;
        } else {

            $status = 'Normal';
        }
        if ($de_status == 'Deferment') {
            $status = 'Repeater';
        }
    }

    $checkRemark = "select * from rawcgpa where matNo='$matNo' and `remark` LIKE '%REPE%'";
    $resultRemark = $db->query($checkRemark);
    $numRemark = $resultRemark->rowCount();
    if ($numRemark > 0) {
        $status = 'Repeater';
    }
//if (($levelID=='8')or ($levelID=='9')){
    //echo  $status=$_SESSION['repeater'];
//echo $levelID;
//echo $status;
    $checkAmt = $db->query("select * from schoolfee where dept='$deptID' and level='$levelID' and status ='$status'");
    $checkAmt_num = $checkAmt->rowCount();
    if ($checkAmt_num > 0) {
        $amtToPay_fetch = $checkAmt->fetch(PDO::FETCH_BOTH);
        $amtToPay = $amtToPay_fetch['amount'];
    }
    // $amtToPay = $amtToPay_fetch['amount'];
    // $amtToPay = $amtToPay_fetch['amount'];
    $bal = $amtToPay - $_SESSION['amtPaidSF'];
    if (($matNo == 'HO201504341') or ($matNo == 'HO201504340') or ($matNo == 'BH201302600')) {
        $bal = 0;
    }

    if ($bal > 0) {


        echo '<h2><p><div style="color: #FF0000" class="alert-danger"><a href="remitaschoolfeeAdd.php">Click to Pay Your School Fees Balance</a></p></div></h2>';
        die();
        // }
    }
    $s = "select * from remitaorder where regNo='$matNo'and paymenttype='School Fees' and transApproved='True'";
    $r = $db->query($s);
    $n = $r->rowCount();
    if ($n == 0) {
        //  header('location:'.'remitaschoolfee.php');
    }

    ?>
    <?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">
                                            Course Registration(<?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-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'];
    //if ($dept=='Office Technology and Management'){
    //  $sql=$db->query("select * from coursepool where levelID='$levelID' and dept='$dept' and (semester='$semester' or postR='1')");
    // }else{
    $sql = $db->query("select * from coursepool where levelID='$levelID' and dept='$dept' 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 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 remark 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 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');
?>