<?php

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

//die();
require_once('../connect.php');
$kk="select * from coursereg where matNo='$matNo' and matNo NOT IN (select matNo from realdata where matNo LIKE 'MC2024%')";
if ($matNo=='MS20240109384XX'){
    echo $kk;
}
//$kk="select * from coursereg where matNo='$matNo' and matNo NOT LIKE (select matNo from realdata where matNo LIKE 'MC2024%')";
 $aspoaCount = $db->query($kk);
echo $asp=$aspoaCount->rowCount();
$asp=0;
if ($asp>=1) {
    die('<h2>Course Registration Has Closed</h2>');
}else {
    {

//require_once('check_passport_sign.php');
//require_once('closedSemester.php');
        $check_reparation = $db->query("select * from remitaorder where regNo='$matNo'and paymenttype='Reparation Fee' and transApproved='True' and status<>'Re-fund'")->rowCount();
        $check_reparation = 1;
        if ($check_reparation == 0) {
            header('location:reparation_remitaPayment.php');
            die("Kindly Pay for Reparation Fee");
            echo "<div align='right'><a href='javascript:history.go(-1)'> Go to Previous page</a></div>";
            include('footMain.php');
//echo '<div> <br /><a href="paymentHistory.php"> Click to check Payment History</a></div>';
        }


//require_once('check_payment2.php');

        require_once('check_payment_Consultant.php');
//die("am here");
        $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 = '';
        }
//die("select * from summertable where matNo='$matNo'");
        require_once('print/check_maxUnit_admin.php');
        echo $remark;
//die();
        ?>
    <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="alert alert-info">Outstanding Course(s): <?php echo $_SESSION['trayCourse'] = $Remark; ?> </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'];
        // $semester = $_SESSION['asemester']='First Semester';
        //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);
                               //                           echo "select * from coursereg where matNo='$matNo' and  courseCode='$courseEnable' and semester='$semester' ";
                               $matNoReal = $_SESSION['matNo'];
                               $aspoa = $db->query("select * from coursereg where matNo='$matNoReal' 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
                    $haystack = $Remark;
                    $needle = "OC";
                    if (strpos($haystack, $needle) !== false) {
                        $carryNum = 1;
//        die($haystack);
                    } else {
                        $carryNum = 0;
//
                    }
                    //                $carrySQL = $db->query("select * from summertable where  matNo='$matNo' and carryCourse not LIKE 'PASSED.%' order by sn limit 0,1");
                    // echo $semester;
                    //                echo $carryNum;

                    //                $carryNum = $carrySQL->rowCount();
                    //                echo $levelID;
                    //                if (($levelID == 2) or ($levelID == 4) or ($levelID == 6) or ($levelID == 7) or ($levelID == 9)or ($levelID == 12)) {
                    $_SESSION['carryNum'] = $carryNum;

                    if ($carryNum > 0) {
                        ?>
                        <div><a href="courseRegb.php"> Select Outstanding Courses</a></div>
                        <?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
//}
        /*}else{
            echo $levelID.'<br>';
            echo $deptID.'<br>';
            echo $status.'<br>';

           echo "<h2>Unable to Confirm the Payment Status, Kindly come to ICT for the confirmation</h2>";

        }*/
    }
}
include('footMain.php');
?>