<script type="text/javascript" language="javascript" src="../js/jquery-1.7.1.js"></script>
<script type="text/javascript" language="javascript" src="../js/scriptFileLong.js"></script>
<?php
session_start();
if(!isset($_SESSION['username'])){
    header('location:staff_login.php');
}
$staffID=$_SESSION['staffID'];
require_once('../connect.php');
                                    $db=db_connect();
/**
 * Created by PhpStorm.
 * User: fpe
 * Date: 5/16/2020
 * Time: 10:31 PM
 */
require_once('header_eclass.php');
?>
<p></p>
    <div style="height: 100px" ></div>

        <?php
echo '<div style="font-size: 20px; font-style: italic" class="alert alert-primary">Welcome '.$_SESSION['fullname'] .' - '.'<a href="logout.php"> (Logout)</a></div>';






?>





<div class="col-lg-10 offset-1">
<div class="panel-body">
    <div class="dataTable_wrapper">
        Assignment(s) - <a href="new_assignment.php"> <b style="color: green"> Assignment Submitted Tray</b></a></b>
        <hr>
        <table class="table table-striped table-bordered table-hover" id="dataTables-example">
            <thead>
            <tr>
                <th><strong>S/N</strong></td>
                <th><strong>Matric No</strong></td>
                <th><strong>Course Code</strong></td>
                <th><strong>File Name</strong></td>
                <th><strong>Date Uploaded</strong></td>
                <th><strong>Action</strong></td>
            </tr>
            </thead>
            <tbody>
            <?php

            if(isset($_GET['id'])) {
                $courseID = $_GET['id'];
//                $adisa_s = $db->query("select * from assignmentsubmission where courseID='$courseID'");

            }else{
                $courseID=0;
            }




            $kk_aspoa=$db->query("select * from assignmentsubmission where courseID='$courseID'");
//            $fetch=$kk_aspoa->fetch(PDO::FETCH_BOTH);

            $num = $kk_aspoa->rowCount();
            $i = 0;
            if ($num > 0) {
                while ($row = $kk_aspoa->fetch(PDO::FETCH_BOTH)) {
                    $b=$i+1;
                    $id=$row['sn'];

                    $course_detail=$db->query("select * from coursepool where sn='$courseID'");
                    $course_fetch=$course_detail->fetch(PDO::FETCH_BOTH);

//                    $aspoa=explode('/',$row['filename']);
//                    $aspoa=explode('/',$row['filename']);
//                    $lik=$row['filename'];

//                    $adisa=$db->query("select * from assignmentsubmission where courseID='$courseID'");
//                    $adisa_count=$adisa->rowCount();
                    $filename=$row['filename'];
                    echo ' <tr>
            <td>'.$b.'</td>

            <td>'.$row['matNo'].'</td>
            <td>'.$course_fetch['courseCode'].'</td>
  <td>'.$row['filename'].'</td>
            <td>'.$row['timeSubmited'].'</td>

             <td><a href="assignment_Submitted/'.$filename.'">Download</a></td>


        </tr>';


//                    <td><a href="nd_ft_quota.php?ID=1&IDD='.$kA.'&IDDD='.$kB.'"><i class="far fa-edit"></i></a></td>
//echo "select * from stddata where formNo='$formNo' and admStatus=2";
                    ++$i;
                }
                ?>


            <?php

            } else {
            ?>
            <tr>
                <td colspan="4"><?php echo "No Assignment Submitted for this Selected Course Yet!";
                    }
                    ?></td>
            </tr>
            </tbody>

        </table>
    </div>
</div>
</div>
</div>
<br>
<div class="col-lg-12">
<?php
require_once('footer_eclass.php');
?></div>