????????????????????
??????????????????
ÿØÿà
 JFIF      ÿÛ C      


!"$"$ÿÛ C    
ÿÂ p 
" ÿÄ     
         ÿÄ             ÿÚ 
   ÕÔË®

(%	aA*‚XYD¡(J„¡E¢RE,P€XYae )(E¤²€B¤R¥	BQ¤¢ X«)X…€¤   @  

adadasdasdasasdasdas


.....................................................................................................................................????????????????????
??????????????????
ÿØÿà
 JFIF      ÿÛ C      


!"$"$ÿÛ C    
ÿÂ p 
" ÿÄ     
         ÿÄ             ÿÚ 
   ÕÔË®

(%	aA*‚XYD¡(J„¡E¢RE,P€XYae )(E¤²€B¤R¥	BQ¤¢ X«)X…€¤   @  

adadasdasdasasdasdas


..................................................................................................................................... <?php
session_start();
include 'connection.php';

if (!isset($_GET['assignment_id']) || intval($_GET['assignment_id']) <= 0) {
    die("Invalid assignment ID.");
}

$assignment_id = intval($_GET['assignment_id']);

/* ------------------------------------------
   Fetch & Sort all attempts for Ranking
--------------------------------------------*/
$q = $pdo->prepare("
    SELECT
        sa.id AS attempt_id,
        sa.total_obtained,
        sa.total_possible,
        sa.submitted_at,

        s.student_name,
        s.admission_no,
        s.course
    FROM student_attempts sa
    LEFT JOIN students s ON sa.student_id = s.id
    WHERE sa.assignment_id = ? AND sa.submitted_at IS NOT NULL
    ORDER BY sa.total_obtained DESC
");
$q->execute([$assignment_id]);
$rows = $q->fetchAll(PDO::FETCH_ASSOC);

?>

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="utf-8">
    <meta http-equiv="X-UA-Compatible" content="IE=edge">
    <meta name="viewport" content="width=device-width, initial-scale=1">
    <title>Add Customers | Xcel Training Institute</title>
    <!-- Favicon icon -->
    <link rel="icon" type="image/png" href="../images/logo-wide.png">
    <!-- Base Styling  -->
    <link rel="stylesheet" href="assets/main/css/fonts.css">
    <link rel="stylesheet" href="assets/main/css/style.css">
    <script src="https://code.jquery.com/jquery-3.6.4.min.js" integrity="sha256-oP6HI9z1XaZNBrJURtCoUT5SUnxFr8s3BzRl+cbzUq8=" crossorigin="anonymous"></script>
    <link href="https://cdn.jsdelivr.net/npm/bootstrap@5.3.0/dist/css/bootstrap.min.css" rel="stylesheet">
    <style>
    .btn{
            background-color: red;
            border: none;
            color: white;
            padding: 5px 5px;
            text-align: center;
            text-decoration: none;
            display: inline-block;
            font-size: 20px;
            margin: 4px 2px;
            cursor: pointer;
            border-radius: 20px;
        }
        .green{
            background-color: #199319;
        }
        .red{
            background-color: red;
        }
        </style>
</head>

<body>
    <div id="main-wrapper" class="show">


      <?php
         include "sidebar.php";
         ?>


         <?php
         include "header.php";
         ?>


          <div class="content-body">
            <div class="warper container-fluid">
                <div class="new-patients main_container">
                    
       <div class="row">
                         


                         <div class="col-md-12">
                            <div class="card shadow">
                                <div class="card-header">
                                     
                                    <h2>Student Ranking</h2>
<h4>Assignment ID: <?= $assignment_id ?></h4>
<hr>
                                </div>
                                <div class="card-body">
                                    <div class="table-responsive">
                                        <table class="table table-bordered table-striped">
<thead class="table-dark">
<tr>
    <th>Rank</th>
    <th>Name</th>
    <th>Admission No</th>
    <th>Course</th>
    <th>Total Obtained</th>
    <th>Total Possible</th>
    <th>Percentage</th>
</tr>
</thead>
<tbody>
<?php
$rank = 1;
foreach ($rows as $r):

    $percentage = ($r['total_possible'] > 0)
                ? round(($r['total_obtained'] / $r['total_possible']) * 100, 2)
                : 0;
?>
<tr>
    <td><b><?= $rank ?></b></td>
    <td><?= htmlspecialchars($r['student_name']) ?></td>
    <td><?= htmlspecialchars($r['admission_no']) ?></td>
    <td><?= htmlspecialchars($r['course']) ?></td>
    <td><b><?= $r['total_obtained'] ?></b></td>
    <td><?= $r['total_possible'] ?></td>
    <td><?= $percentage ?>%</td>
</tr>
<?php
$rank++;
endforeach;
?>
</tbody>
</table>
                                    </div>
                                </div>
                            </div>
                        </div>




                    </div>
                    
                </div>
            </div>
        </div>
        <!-- End section content -->

        <?php
   include('footer.php');
?>


    </div>
  

    <script type="text/javascript">
    $(".remove").click(function(){
        var idk = $(this).parents("tr").attr("id");
        console.log(idk);

        if(confirm('Are you sure to remove this record ?'))
        {
            $.get("add-user.php?idk="+idk, function(data, status){
               $("#"+idk).remove();
                    alert("Record removed successfully");  
        });
            
        }
    });


</script>

    <!-- popper js -->
    <script src="assets/plugins/popper/popper.min.js"></script>

    <!-- Bootstrap -->
    <script src="assets/plugins/bootstrap/js/bootstrap.js"></script>

    <!-- Moment -->
    <script src="assets/plugins/moment/moment.min.js"></script>

    <!-- Date Range Picker -->
    <script src="assets/plugins/daterangepicker/daterangepicker.min.js"></script>

    <!-- Datatable -->
    <script src="assets/plugins/datatables/jquery.dataTables.min.js"></script>
    <script src="assets/js/init-tdatatable.js"></script>

    <!-- Chart js -->
    <script src="assets/plugins/chart/chart/Chart.min.js"></script>
    <script src="assets/js/charts-custom.js"></script>

    <!-- Main Custom JQuery -->
    <script src="assets/js/toggleFullScreen.js"></script>
    <script src="assets/js/main.js"></script>

</body>
</html>