<?php include('include/sidebar.php'); ?>
<!-- Start Welcome area -->
<style>
    .table > thead > tr > th, .table > tbody > tr > th, .table > tfoot > tr > th, .table > thead > tr > td, .table > tbody > tr > td, .table > tfoot > tr > td {
        vertical-align: middle!important;
        text-align: center;
    }
</style>
<?php include('include/header.php'); ?>
<div class="breadcome-area">
    <div class="container-fluid">
        <div class="row">
            <div class="col-lg-12 col-md-12 col-sm-12 col-xs-12">
                <div class="breadcome-list">
                    <div class="row">
                        <div class="col-lg-6 col-md-6 col-sm-6 col-xs-6">
                            <div class="breadcomb-wp">
                                <div class="breadcomb-icon">
                                    <i class="icon nalika-home"></i>
                                </div>
                                <div class="breadcomb-ctn">
                                    <h2>Results </h2>
                                </div>
                            </div>
                        </div>
                        <div class="col-lg-6 col-md-6 col-sm-6 col-xs-6">
                         
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>
</div>
</div>

<div class="product-status mg-b-30">

    <div class="container-fluid">

        <div class="row">

            <div class="col-lg-12 col-md-12 col-sm-12 col-xs-12">

                <div class="product-status-wrap">

                    <h4>Result List</h4>

                    <div class="add-product">

                        <a href="add-term-2">Add</a>

                    </div>
                    <div class="table-responsive">
                    <table id="example" class="table table-hover table-striped">
                        <thead>

                       <tr class="text-white">
                                <th rowspan="2">Roll No.</th>
                                <th rowspan="2">S.NO</th>
                                <th rowspan="2">Student Name</th>
                                <th class="text-center" colspan="8">Marks</th>
                                <th class="text-center" colspan="5">Grades</th>
                                <th rowspan="2">Action</th>
                            </tr>



                            <tr>
                               <?php
                               $q = "SELECT term1_result.*,subjects.subject_name FROM term1_result LEFT JOIN subjects ON subjects.id=term1_result.subject_id WHERE type='term2' GROUP BY subjects.id";
                               $query = mysqli_query($conn,$q);
                               $i=1;
                               while($res = mysqli_fetch_array($query)) { ?>
                                <th><?php echo $res['subject_name'] ?></th>
                            <?php } ?>
                            
                            <th>Total</th>
                            <th>%</th>
                            <th>Rank</th>

                            <?php
                            $sql = "SELECT * FROM term1_result WHERE type='term2' GROUP BY subject";
                            $qry = mysqli_query($conn,$sql);
                            while($resu = mysqli_fetch_array($qry)) { ?>
                                <th><?php echo $resu['subject'] ?></th>
                            <?php } ?>
                        </tr>
                    </thead>
                    <?php
                    $q = "SELECT term1_result.*,students.student_name FROM term1_result LEFT JOIN students ON students.id=term1_result.student_id WHERE type='term2' GROUP BY student_id";
                    $query = mysqli_query($conn,$q);
                    $i=1;
                    $x=1;
                    while($res = mysqli_fetch_array($query)) { ?>
                        <tr>

                         <td><?php echo $res['student_id'] ?></td>
                         <td><?php echo $i++; ?></td>
                         <td><?php echo $res['student_name'] ?></td>
                         <?php  $qry = "SELECT * FROM term1_result WHERE type='term2' AND student_id='".$res['student_id']."' ORDER BY total desc";
                         $sql = mysqli_query($conn,$qry);
                         $total=0;

                         while($row = mysqli_fetch_array($sql)) {
                            $total+=$row['marks'];
                            $percentage = ($total/200) * 100;
                            ?>
                            <td><?php echo $row['marks']; ?></td>
                        <?php } ?>
                        <td><?php echo $total ?></td>
                        <td><?php echo round($percentage,2); ?></td>
                        <td><?php echo $x++; ?></td>
                        <?php  $qry = "SELECT * FROM term1_result WHERE type='term2' AND student_id='".$res['student_id']."' ORDER BY total desc";
                         $sql = mysqli_query($conn,$qry);
                         $total=0;

                         while($rows = mysqli_fetch_array($sql)) {
                            ?>
                            <td><?php echo $rows['grade']; ?></td>
                        <?php } ?>
                        <td>

                            <button data-toggle="tooltip" title="View" class="pd-setting-ed"><a style="color: #fff;" href="edit_term?student_id=<?php echo $res['student_id'] ?>&type=term2"><i class="fa fa-eye" aria-hidden="true"></i></a></button>

                                    <button onclick="del('<?php echo $res['roll_no'] ?>')" data-toggle="tooltip" title="Trash" class="pd-setting-ed"><i class="fa fa-trash-o" aria-hidden="true"></i></button>

                                </td>

                            </tr>
                        <?php } ?>

                        </table>
                    </div>
                   </div>

               </div>

           </div>

       </div>

   </div>
<script>
    function del(e) {
      var verify = confirm("Do you really want to delete!!!");
      if(verify) {
          $.ajax({
              url: "delete.php",
              type: "POST",
              data: {
                  term2: e,
              },
              success: function(response){
                 location.reload();
              },
          })
      }
  }
</script>
   <?php include('include/footer.php'); ?>