<?php
ob_start();
    include('headMain.php');
    //session_start();
    if(!isset($_SESSION['matNo'])){
        header('location:'.'login.php');
    }
			 require_once('../connect.php');
    $db=db_connect();
			 extract($_POST);
// $courseNum=count($course);
$semester=$_SESSION['asemester'];
$asession=$_SESSION['asession'];
$levelID=$_SESSION['levelID'];
$matNo=$_SESSION['matNo'];
    ?>
    <div id="wrapper">
   <td> <form id="form1" name="form1" method="post" action="aaaa.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">
                                            View Course Materials (<?php echo $_SESSION['matNo'].'-'.$semester ;?>)
                                        </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>Lecturer Name</strong></td>
                                                                            <td><strong>Date Uploaded</strong></td>
                                                                            <td><strong>Check to Select</strong></td>
                                                                        </tr>

                                                                        <?php
                                                                        $levelID=$_SESSION['levelID'];
                                                                        $dept=$_SESSION['course'];
                                                                        $courseTotal=0;

                                                                         $adisa="select * from uploading_tb where courseID in (select sn from coursepool where courseCode in (select courseCode from coursereg where matNo='$matNo') and levelID=$levelID and dept='$dept') and mode=1";
                                                                        $sql=$db->query($adisa);
                                                                        $num=$sql->rowCount();
                                                                        $i=0;
                                                                        if ($num>0){
                                                                            while ($row=$sql->fetch(PDO::FETCH_BOTH)){
                                                                                ?>
                                                                                <tr>
                                                                                    <td><?php
                                                                                        $courseID=$row['courseID'];
                                                                                        $course=$db->query("select * from coursepool where sn='$courseID'");
                                                                                        $course_fetch=$course->fetch(PDO::FETCH_BOTH);
                                                                                        echo $course_fetch['courseCode'];?></td>
                                                                                    <td><?php

                                                                                        echo $course_fetch['courseTitle'] ;?></td>
                                                                                    <td><?php
                                                                                        $staffID=$row['staffID'];
                                                                                        $lect=$db->query("select fullname from staff_biodata where staffID='$staffID'");
                                                                                        $lect_fetch=$lect->fetch(PDO::FETCH_BOTH);

                                                                                        echo $lect_fetch['fullname'] ;?></td>
                                                                                    <td><?php echo $row['timeFrom'] ;?></td>

                                                                                    <td><label for="checkbox"><a href="../eClass/<?php echo $row['filename'];?>">Download</a></label></td>
                                                                                </tr>

                                                                                <?php

                                                                                ++$i;
                                                                            }
                                                                            ?>


                                                                        <?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 class="col-lg-1"></div>
<?php
include('footMain.php');
ob_end_flush();
?>