<?php
ob_start();
//die("The page is not available presently");
require_once('headMain.php');
//if(!isset($_SESSION['matNo'])){
//header('location:login.php');
//}
			 $matNo=$_SESSION['matNo'];
			require_once('../connect.php');

$db=db_connect();
			 $s="select * from ace_remitaorder where regNo='$matNo' and paymenttype='School Fees' and transApproved='True'";
$r=$db->query($s);
$re=$r->fetch(PDO::FETCH_BOTH);
$n=$r->rowCount();
if ($n==0){
//header('location:'.'remitaschoolfee.php');
}


//if (isset($_SESSION['graduated']) and ($_SESSION['graduated']=='1')) {
if ($graduated_count==1) {
    ?>
<div style="background-color: #ffffff">
    <div class="row" align="center">
    <div class="col-md-3 col-sm-6 no-space">
        <!-- BEGIN WIDGET SUBSCRIBE -->
        <div class="panel panel-primary">
            <span class="widget-subscribe-no"></span>
            <h2 class="widget-subscribe-title widget-title-color-gray-dark text-uppercase text-info">Input  <br /> Records</h2>
            <p class="widget-subscribe-subtitle widget-title-color-dark-light">
                Fill in all the Required Details of your Records <br>
                <a style="margin: 12px 0px 0px 0px;" class="btn btn-primary" href="biodata.php">
                    <span>View/Edit Details</span>            </a>
            </p>
        </div>
        </div>
    <div class="col-md-3 col-sm-6 no-space">
        <!-- BEGIN WIDGET SUBSCRIBE -->
        <div class="panel panel-primary">
            <span class="widget-subscribe-no"></span>
            <h2 class="widget-subscribe-title widget-title-color-gray-dark text-uppercase text-info">Register  <br /> Courses</h2>
            <p class="widget-subscribe-subtitle widget-title-color-dark-light">
                Choose Courses you wish to Register for First Semester <br>
                <a style="margin: 12px 0px 0px 0px; display: none" class="btn btn-primary" href="courseReg.php">
                    <span>Register Now</span>        </a>
            </p>
        </div>
    </div>
    <div class="col-md-3 col-sm-6 no-space">
        <!-- BEGIN WIDGET SUBSCRIBE -->
        <div class="panel panel-primary">
            <span class="widget-subscribe-no"></span>
            <h2 class="widget-subscribe-title widget-title-color-gray-dark text-uppercase text-info">Register  <br /> Courses</h2>
            <p class="widget-subscribe-subtitle widget-title-color-dark-light">
                Choose Courses you wish to Register for Second Semester <br>
                <a style="margin: 12px 0px 0px 0px" class="btn btn-primary" href="courseReg_second.php">
                    <span>Register Now</span>        </a>
            </p>
        </div>
    </div>
</div>
<p>
<!--
			<u><h2>Procedure to Complete First Semester Registration</h2></u>
<ul>
  <li>Click on 'Registration' to Update your Biodata.</li>
  <li>Click on 'Payment' to pay your School Fees</li>
  <li>Then, Click 'Printing/Downloading' Link to Print ALL REQUIRED DOCUMENTS</li>
  <li>All documents printed must be duly  signed by appropriate officers and return it back to school office for final  submission.</li>
    <li><b>Make sure you register for First Semester and Second Semester Courses.</b></li>
</ul>
<p><strong>NOTE</strong>:  Confirm the <strong>Official</strong> <strong>Approved</strong> <strong>School</strong> <strong>Fees</strong> from the  School Portal before Making Payment.</p>
    -->
    <?php
    $sql1 = $db->query("select * from coursereg where levelID='$levelID' and matNo='$matNo' and semester='First Semester'");
    $num1 = $sql1->rowCount();
    $sql2 = $db->query("select * from coursereg where levelID='$levelID' and matNo='$matNo' and semester='Second Semester'");
    $num2 = $sql2->rowCount();

    $sqlC1 = $db->query("select sum(courseUnit) as course from coursereg where levelID='$levelID' and matNo='$matNo' and semester='First Semester'");
    $num_sqlC1 = $db->query("select courseUnit from coursereg where levelID='$levelID' and matNo='$matNo' and semester='First Semester'")->rowCount();
    $numC1 = $sqlC1->rowCount();
    if ($numC1 > 0) {
        $value_f = $sqlC1->fetch(PDO::FETCH_BOTH);
        $noC1 = $value_f['course'];
    } else {
        $noC1 = 0;
    }
    $sqlC2 = $db->query("select sum(courseUnit) as course from coursereg where levelID='$levelID' and matNo='$matNo' and semester='Second Semester'");
    $num_sqlC2 = $db->query("select courseUnit from coursereg where levelID='$levelID' and matNo='$matNo' and semester='Second Semester'")->rowCount();
    $numC2 = $sqlC2->rowCount();
    if ($numC2 > 0) {
        $value_f2 = $sqlC2->fetch(PDO::FETCH_BOTH);
        $noC2 = $value_f2['course'];
    } else {
        $noC2 = 0;
    }
    $sqlC3 = $db->query("select sum(courseUnit) as course from coursereg where levelID='$levelID' and matNo='$matNo' and semester='Summer Semester'");
    $num_sqlC3 = $db->query("select courseUnit from coursereg where levelID='$levelID' and matNo='$matNo' and semester='Summer Semester'")->rowCount();
    $numC3 = $sqlC3->rowCount();
    if ($numC3 > 0) {
        $value_f3 = $sqlC3->fetch(PDO::FETCH_BOTH);
        $noC3 = $value_f3['course'];
    } else {
        $noC3 = 0;
    }
    require_once('print/check_maxUnit.php');

    ?>


    <div class="row" align="center">
        <div class="col-md-3">
            <!-- BEGIN WIDGET THUMB -->

            <div class="panel panel-info alert-success text-uppercase">
                <h4 class="widget-thumb-heading">First Semester Courses Details</h4>
                <div class="widget-thumb-wrap">
                    <i class="widget-thumb-icon widget-bg-color-blue icon-screen-desktop"></i>
                    <div class="widget-thumb-body"><hr>
                        <span class="counter widget-thumb-body-stat text-danger"><b> Maximum Units - <?php echo $maxUnit; ?></b> </span>
                        <hr>
                        <span class="widget-thumb-subtitle text-danger">No. of Courses -<?php echo $num_sqlC1; ?></span><br>
                        <span class="counter widget-thumb-body-stat text-danger">Total Units -<?php echo $noC1; ?> </span>
                    </div>
                </div>
                </div>

            <!-- END WIDGET THUMB -->
        </div>



            <div class="col-md-3">
                <!-- BEGIN WIDGET THUMB -->
                <div class="panel panel-info alert-success text-uppercase">
                    <h4 class="widget-thumb-heading">Second Semester Courses Details</h4>
                    <div class="widget-thumb-wrap">
                        <i class="widget-thumb-icon widget-bg-color-blue icon-screen-desktop"></i>
                        <div class="widget-thumb-body"><hr>
                            <span class="counter widget-thumb-body-stat text-danger"><b>Maximum Units - <?php echo $maxUnit; ?></b> </span>
                            <hr>
                            <span class="widget-thumb-subtitle text-danger">No. of Courses - <?php echo $num_sqlC2; ?></span><br>
                            <span class="counter widget-thumb-body-stat text-danger">Total Units - <?php echo $noC2; ?> </span><br>

                        </div>
                    </div>
                </div>
            <!-- END WIDGET THUMB -->
        </div>
    <div class="col-md-3">
            <!-- BEGIN WIDGET THUMB -->
            <div class="panel panel-info alert-success text-uppercase" style="display: none">
                <h4 class="widget-thumb-heading">Summer Semester Courses Details</h4>
                <div class="widget-thumb-wrap">
                    <i class="widget-thumb-icon widget-bg-color-blue icon-screen-desktop"></i>
                    <div class="widget-thumb-body"><hr>
                        <span class="widget-thumb-subtitle text-danger">No. of Courses - <?php echo $num_sqlC3; ?></span><br>
                        <span class="counter widget-thumb-body-stat text-danger">Total Units - <?php echo $noC3; ?> </span>
                    </div>
                </div>
            </div>

        <div class="panel panel-info alert-danger text-uppercase">
            <h4 class="widget-thumb-heading"><a href="print/examSlip.php" target="_blank"> Click to print Examination Slip</a></h4>
            <div class="widget-thumb-wrap">
                <i class="widget-thumb-icon widget-bg-color-blue icon-screen-desktop"></i>
                <div class="widget-thumb-body"><hr>
                    <span class="widget-thumb-subtitle text-danger">Examination Slip</span><br>
                    <span class="counter widget-thumb-body-stat text-danger"> </span>
                </div>
            </div>
        </div>
            <!-- END WIDGET THUMB -->
        </div>
        <!-- END WIDGET THUMB -->
    </div>


<?php
}
?>

    <hr>
<!--<p><a href="remitaschoolfeeAdd.php">Click to Pay your School Fees Balance</a></p>
<p><a href="remitaschoolfeeOlevel.php">Click to Pay for Verification of Additional O'Level Result</a></p>-->
<br /><br />

            <a onclick="window.open('../chat/student_chat.php?chatwith=ICT ADMIN','_blank','height=500,width=430,left=10,top=10, resizable=no,scrollbars=no,titlebar=no, toolbar=no,menubar=no,location=no,directories=no,status=no');" style="text-decoration:underline; cursor:pointer; font-weight:bold;" >Online ICT Support </a><br /><br />
<?php
include('footMain.php');
ob_end_flush();
?>
</div>