<?php
ob_start();

require_once('headMain.php');
//if(!isset($_SESSION['matNo'])){
//header('location:login.php');
//}
//die("am here");

 $matNo=$_SESSION['matNo'];
			require_once('../connect.php');
$db=db_connect();
			$s="select * from 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');
}
//echo $graduated_count
//if (isset($_SESSION['graduated']) and ($_SESSION['graduated']=='1')) {
//echo $graduated_count;

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_admin.php');
//    require_once('result_fetch.php');
//    die();
    ?>
    <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>-->
            <?php
            $sql=$db->query("select * from realdata where matNo='$matNo'");
            if ($sql->rowCount()==1){
            $sql_fetch=$sql->fetch(PDO::FETCH_ASSOC);
              $genda=$sql_fetch['sex'];
            if ($genda=='Female'){
                $genda_id=$_SESSION['sex']=0;
            }elseif ($genda=='Male'){
                $genda_id=$_SESSION['sex']=1;
            }
//                echo $_SESSION['sex'];
            }

            echo $allo_check="select * from room_allocation where  matNo='$matNo'";
            $allo_check_exe=$db->query($allo_check);
             $allo_check_count=$allo_check_exe->rowCount();
            if ($allo_check_count>0) {
                $allo_check_fetch = $allo_check_exe->fetch(PDO::FETCH_ASSOC);
                $all_status = $allo_check_fetch['status'];
                echo $all_paid = $allo_check_fetch['paid'];
                $all_hall_id=$allo_check_fetch['hostel_id'];
                $all_room_id=$allo_check_fetch['room_id'];
                $all_bed_id=$allo_check_fetch['bed_space'];
                $sn=$allo_check_fetch['sn'];

                if ($all_status==0){
                    $flag="An Error Has Occur, contact ICT on 07061230735";
                }elseif($all_paid>0){
                    $flag="You Have Been Allocated and Payment Has been Made". '<p><h4 class="widget-thumb-heading"><a href="accommodationPrint.php?all_hall_id='.$all_hall_id.' & all_room_id='.$all_room_id.' & all_bed_id='.$all_bed_id.'"> Click here to Print Hostel  Allocation Clearance</a></h4>';
                }elseif($all_paid==0){
                    $flag="You Have Been Allocated and Payment Has NOT been Made, Kindly Make Payment".'<h4 class="widget-thumb-heading"><a href="index_pay_accomodation.php?ID='.$sn.'"> Click here to PAY  </a></h4>';
                }

echo $flag;

            }else{
                echo "select regNo from remitaorder where regNo='$matNo' and paymentType='School Fees' and transApproved='True'";
                $solagbade=$db->query("select regNo from remitaorder where regNo='$matNo' and paymentType='School Fees' and transApproved='True'")  ;
//             $solagbade->rowCount();
                if ($solagbade->rowCount()==0){
                    echo '<h4 class="widget-thumb-heading">No Accommodation Booking without School Fees Payment<a href="remitaschoolfee.php" style="font-style: oblique">  <p>Click here to Pay School Fees First</a></h4>';
                }else{
                    echo $aspoaRM="select * from room_allocation where status=0 and sex='$genda_id' and matNo=''";
                    $aspoa=$db->query($aspoaRM);
                      $aspoa_count=$aspoa->rowCount();
                    if ($n>0) {
                        if ($aspoa_count > 2) {
                            echo '<h4 class="widget-thumb-heading" style="display: "><a href="hostel.php" style="text-decoration: blink;text-blink"> Click Here to Book for Accommodation</a></h4>';
                        } else {
                            echo '<h4 class="widget-thumb-heading"><a href="#"> Check Back Later /No More Space</a></h4>';
                        }
                    }else{
                        echo '<h4 class="widget-thumb-heading"><a href="accommodationPrint.php"> Click here to Print Hostel  Allocation Clearance</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>