<?php
session_start();
     $_SESSION['active'] = 'bannerReport';

   include('include/header.php');
      

   $select_about_data = select_banner_data(); 
?>
<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">Reports</li>
          <li class="breadcrumb-item ">Banner Report</li>
        </ol>
      </nav>
    </div> 
    <?php
         if(!empty($_GET['upd'])){
  ?>
  <div align="center"><h4 style="color:green;">Updated Data Successfully </h4></div>
  <?php
}
  
   if(!empty($_GET['succ'])){
     ?>
     <div align="center"><h4 style="color:green;">Data Insert Sucessfully </h4></div>
     <?php
  }
?>

 

    <section class="section">

<div class="row">
        <div class="col-lg-12">
            
          <div class="card">
            <div class="card-body">
              <h5 class="card-title">Banner Report</h5> 
                 <div class="col-md-4"></div>
                      <div class="col-md-6"></div>
                      <div class="col-md-2"><a href="banner.php" style="background-color: #69F0AE; color: #000000;" class="btn">Add Banner Form</a></div>
                       <br><br>

              <div class="row mt-4">
              	     
                      <table class="table datatable mt-4" id="getting_data">

                        <thead style="background-color:#7E57C2; color: #ffff;">
                          <tr role="row">
                           <th scope="col" style="display: none;">Id</th> 
                           <th scope="col">S.No</th>
                           <th scope="col">Name</th>
                           <th scope="col">Image</th>
    		                   <th scope="col">Title</th>
    		                    <th scope="col">Action</th>


                          </tr>
                        </thead> 

              
                <tbody>
                          <?php  
                          $i=1; 
                          while($facility = mysqli_fetch_array($select_about_data))
                           {  

                          ?>

                          <tr> 
                            <td><?= $i;?></td>
                             <td><?= $facility['name']?></td>
                             <td><img src="<?= $facility['image']?>" width="60px;"></td>
                             <td><?= $facility['title']?></td>
                           
                             
                             <td><a href="banner_edit.php?edit=<?= $facility['id']?>" class="btn"style="background-color: #69F0AE;">Edit</a>
                                 <a href="javascript:void();" onclick="confirmDelete(<?php echo $facility['id']?>)" class="btn"style="background-color: #ff5252;">Delete</a>
                             </td>
                         </tr> 
                       <?php $i++;} ?>
                     </tbody>
                   </table> 





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

  </main> 


 <script>
  $(document).ready(function() {

   $('#getting_data tfoot th').each(function () {
     var title = $('#getting_data thead th').eq($(this).index()).text();
     $(this).html('<input type="text" placeholder="Search ' + title + '" />');
   });

   var table = $('#getting_data').DataTable({
    dom: 'Bfrtip',
    buttons: [
    'colvis',
    {
      extend: 'excelHtml5',
      exportOptions: {
        columns: ':visible'
      }
    },
    {
      extend: 'pdfHtml5',
      messageTop: function(){
      return "Total Value: " + $('#Sum_TotalRecords').text();
      },
      exportOptions: {
        columns: ':visible'
      }
    },
    ],

   

      CountofAmount = api
      .column(7, { 'search': 'applied' })
      .data()
      .reduce(function (a, b) {
        return intVal(a) + intVal(b);
      }, 0);


      CountofAmountcurrent = api
      .column(7, { page: 'current' })
      .data()
      .reduce(function (a, b) {
        return intVal(a) + intVal(b);
      }, 0);


      $('#Sum_TotalRecords').text('Rs.'+ CountofAmountcurrent + '(' +'Rs.'+ CountofAmount + ')');
    }

  });

   $("#getting_data tfoot input").on('keyup change', function () {
     table
     .column($(this).parent().index() + ':visible')
     .search(this.value)
     .draw();
   });
 });
</script> 

<script type="text/javascript">

  $(document).ready(function() {
   $.fn.dataTable.ext.search.push(
     function(settings, data, dataIndex) {
       var min = $('#min').datepicker("getDate");
       var max = $('#max').datepicker("getDate");

       var startDate = new Date(data[3]);
       if (min == null && max == null) {
         return true;
       }
       if (min == null && startDate <= max) {
         return true;
       }
       if (max == null && startDate >= min) {
         return true;
       }
       if (startDate <= max && startDate >= min) {
         return true;
       }
       return false;
     }
     );


   $("#min").datepicker({ 
    dateFormat: "dd-M-yy",
      type:  'datetime',
     onSelect: function() {
       table.draw();
     },
     changeMonth: true,
     changeYear: true
   });
   $("#max").datepicker({
    dateFormat: "dd-M-yy",
      type:  'datetime', 
     onSelect: function() {
       table.draw();
     },
     changeMonth: true,
     changeYear: true
   });
   var table = $('#getting_data').DataTable();
   $('#min, #max').change(function() {
     table.draw();
   });
 });



</script> 

 <script>
       function confirmDelete(bannerid)
       {
        
          if (bannerid != '') {
            var x = confirm('Are you sure to Delete?');
          if(x){
          $.ajax({
            url : "delete.php",
            data :  {bannerid : bannerid},
            type : 'POST',
            success : function(response) {
              if(response ==1){
                window.location.href = "banner_report.php";
              }
                
               
            }
        });
        }
       }
     }
    </script>

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