<?php
   session_start();
   $_SESSION['active'] = 'academicList';
  include('include/header.php');
 
  if(!empty($_POST['submit'])){
    academic_insert();
}
$select_academic = select_academic();
 
?>
<main id="main" class="main">

<div class="pagetitle">
  <h1>Apple IIT Schools</h1>
  <nav>
    <ol class="breadcrumb">
      <li class="breadcrumb-item"><a href="index.php">Home</a></li>
      <li class="breadcrumb-item ">Academic Entry</li>
    </ol>
  </nav>
</div> 

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

          <div class="card">
            <div class="card-body">
             <h5 class="card-title">Academic Entry</h5>
<div id="update">
<?php
  
  
  if(!empty($_GET['upd'])){
  ?>
  <div align="center"><h4 style="color:green;">Academic Data Updated  Successfully </h4></div>
  <?php
}
?>
</div>
<div id="succ">
 <?php
   if(!empty($_GET['succ'])){
     ?>
    <div align="center"><h4 style="color:green;">Academic Data Inserted Successfully </h4></div>
     <?php
  }
?>
</div>
<div id="fail">
<?php
   if(!empty($_GET['failed'])){
     ?>
    <div align="center"><h4 style="color:red;">Already Academic Data Inserted  Successfully </h4></div>
     <?php
  }
?>
</div>
<div id="delete_data" style="display: none;">
  <h4 style="color:red; text-align: center; ">Academic Data Deleted Successfully</h4>
</div>
    <form  method="post" onsubmit="return book_validation()"> 
          <div class="col-md-6">
            <label for="exampleInputEmail1" class="form-label">Academic Year</label>
            <input type="text" class="form-control" id="academicYear" name="academicYear" placeholder="e.g. 2021-22">
            
        </div>
        <div class="mt-4">
        <input type="submit" class="btn" value="Add" name="submit" style="background-color: #69F0AE; color: #000000;">
        </div>
        
    </form>
    <h5 class="card-title">Reports</h5>
    <div class="col-md-6">
    
    <table class="table">
      <thead style="background-color:#7E57C2; color: #ffff;">
      <tr>
        <th>S.No</th>
        <th>Academic Year</th>
        <?php
            if($_SESSION['user']=='admin'){
        ?>    
         <th>Actions</th>
         <?php
          }
         ?>
      </tr>
    </thead>
    <tbody>
      <?php
   $i=1;
   while($academic = mysqli_fetch_array($select_academic)){ 
    ?>

      <tr>
        <td><?= $i?></td>
        <td><?= $academic['yearOf']?></td>
         <?php
            if($_SESSION['user']=='admin'){
        ?> 
        <td>
        <div class="dropdown">
                            <button class="btn btn-secondary dropdown-toggle" type="button" id="dropdownMenuButton1" data-bs-toggle="dropdown" aria-expanded="false" style="background-color:#69F0AE;">
                              Action
                            </button>
                            <ul class="dropdown-menu" aria-labelledby="dropdownMenuButton1">
                              <li><a class="dropdown-item text-center" href="academic_edit.php?edit=<?php echo $academic['id']?>">EDIT</a></li>
                              <li><a class="dropdown-item text-center" href="javascript:void();" onclick="confirmDelete(<?php echo $academic['id']?>)">DELETE</a></li>
                             
                            </ul>
                          </div>
                        </td>
                        <?php
                         }
                        ?>
      </tr>
      <?php
      $i++;
      }
      ?>
    </tbody>
    </table>
   
    </div>


     </div>
          </div>

        </div>
      </div>
    </section>
  
  
   

</main> 

<script src="https://code.jquery.com/jquery-1.11.1.min.js"></script>
<script src="https://cdn.jsdelivr.net/jquery.validation/1.16.0/jquery.validate.min.js"></script>
<script src="https://cdn.jsdelivr.net/jquery.validation/1.16.0/additional-methods.min.js"></script>
  <script src="https://unpkg.com/sweetalert/dist/sweetalert.min.js"></script>

  <script>
    function book_validation()
    {
      
        var branchname = $('#academicYear').val();
        var academic = $('#academic').val();
       
        if(branchname == '')
        {
          swal('Please Enter Academic Year');
          return false;
        }
      
       
        else{
          return true;
        }
    }
  </script>
  <script>
       function confirmDelete(academicid)
       {
        
          if (academicid != '') {
            var x = confirm('Are you sure to Delete?');
            if(x){
          $.ajax({
            url : "delete.php",
            data :  {academicid : academicid},
            type : 'POST',
            success : function(response) {
              if(response ==1){
                 $('#succ').hide();
                 $('#update').hide();
                 $('#fail').hide();

                 $('#delete_data').show();
                  window.location.href = "academicEntry.php";
              }
                
               
            }
        });
        
       }
     }
     }
    </script>
    
  <?php  include('include/footer.php'); ?>