<?php
   include('include/header.php');
   $select_exam_time_table = select_exam_time_table();
   $select_academic = select_academic();
?> 


<main id="main" class="main">

<div class="pagetitle">
  <h1>School Data</h1>
  <nav>
    <ol class="breadcrumb">
      <li class="breadcrumb-item"><a href="index.php">Home</a></li>
      <li class="breadcrumb-item active">Student Attendance</li>
    </ol>
  </nav>
</div><!-- End Page Title -->

<section class="section">
      <div class="row">
        <div class="col-lg-12">

          <div class="card">
            <div class="card-body">
              <h5 class="card-title">Student Attendance</h5>

<form method="post" onsubmit="return book_validation()" >
<div class="row">
  
    
                     <div class="col-md-3">
                         <label for="exampleInputEmail1" class="form-label">Classes</label>
                          <select name="Class" id="Class" class="form-control">
                            <option value="">Please Select Class</option>
                            <option value="First Class">First Class</option>
                            <option value="Second Class">Second Class</option>
                            <option value="Third Class">Third Class</option>
                            <option value="Four Class">Fourth Class</option>
                            <option value="Five Class">Fifth Class</option>
                            <option value="Six Class">Sixth Class</option>
                            <option value="Seven Class">Seventh Class</option>
                            <option value="Eight Class">Eighth Class</option>
                            <option value="Nine Class">Ninth Class</option>
                            <option value="Ten Class">Tenth Class</option>
                          </select>
                    </div>  

                     <div class="col-md-3">
                         <label for="exampleInputEmail1" class="form-label">Academic Year</label>
                          <select name="yearOf" id="yearOf" class="form-control">
                            <option value="">Please Select Academic Year</option>
                            <?php
                               while($year = mysqli_fetch_array($select_academic)){
                            ?>
                            <option value="<?= $year['yearOf']?>"><?= $year['yearOf']?></option>
                           <?php
                              }
                           ?>
                          </select>
                    </div>  
                  
                  </div>
                  <a onClick="search_student(this.value)" class="btn btn-primary mt-4">Submit</a>
                <!-- <div class="mt-4">
                   <input type="submit" class="btn btn-warning" value="Search" name="Search" onClick="search_student(this.value)">
                </div> -->
           </form> 
   
    </div>
  
     </div>
          </div>
<div id="result">
  
</div>
<div class="col-md-4">
  <form action="attendance_report.php">
  <input type="submit" style="display:none; margin-left: 1000px;" class="btn btn-primary" value="Submit" id="subm">
</form>
</div>
        </div>
      </div>
    </section>
   

</main><!-- End #main -->
  
<script src="https://code.jquery.com/jquery-1.11.1.min.js"></script>

  <script src="https://unpkg.com/sweetalert/dist/sweetalert.min.js"></script>

  

  

  <?php include('include/footer.php'); ?> 

  <script>
    function search_student()
    {
        var Class = $('#Class').val();
         var yearOf = $('#yearOf').val();
            if(Class == '')
        {
          swal('Please Select Class');
          return false;
        }
          else if(yearOf == '')
        {
          swal('Please Select Year');
          return false;
        }
        else{

         $.ajax({
            url : "fetch.php",
            data :  {Class : Class,yearOf:yearOf},
            type : 'POST',
            success : function(data) {
             
                $('#result').html(data);
                $('#subm').show();
              
               
            
        }
        });
       }
    }


  </script>