<?php
include_once 'header.php';

?>

<div class="page-wrapper">
        <!-- ============================================================== -->
        <!-- Bread crumb and right sidebar toggle -->
        <!-- ============================================================== -->
        <div class="page-breadcrumb">
          <div class="row">
            <div class="col-12 d-flex no-block align-items-center">
              <h4 class="page-title">All Pending Fee List</h4>
              <div class="ms-auto text-end">
                <nav aria-label="breadcrumb">
                  <ol class="breadcrumb">
                    <li class="breadcrumb-item"><a href="#">Dashboard</a></li>
                    <li class="breadcrumb-item active" aria-current="page">
                     Student Fee
                    </li>   
                    <li class="breadcrumb-item"><a href="#">Send Email All</a></li>              
                  </ol>
                </nav>
              </div>
            </div>
          </div>
        </div>
        <!-- ============================================================== -->
        <!-- End Bread crumb and right sidebar toggle -->
    
        <div class="container-fluid row">
            <div class="col-12">  
              <div class="card">
                <div class="card-body">
                  <h5 class="card-title"> </h5>
                  <div class="table-responsive">
                    <table id="zero_config" class="table table-striped table-bordered">
                      <thead>
                        <tr>
                          <th>S.No</th>       
                          <th>Batch No</th>
                          <th>Student Name</th>
                          <th>Course Fee</th>
                          <th>Paid Amount</th>
                          <th>Pending Amount</th>
                          <th>Action</th>
                        </tr>
                      </thead>
                      <tbody>                       
                              <?php
                              
                                $obj=new Database();
                                $obj->select('students_course','*',null,null,null,null);
                                $result=$obj->getResult(); 
                                $c=0;
                                                              
                                foreach($result as list("f_id"=>$id,"student_name"=>$s_name,"batch_no"=>$batch_no,"course_fee"=>$pay_mode))
                                {
                                  $id="batch_no='".$batch_no."'";
                                  $paid=$obj->Amount_Count('txn_details',$id,'credit');
                                  $fee=$obj->Amount_Count('txn_details',$id,'debit');
                                  $fee=$fee-$paid;
                                  
                                  if($fee>0)
                                  {
                                    $c=$c+1;
                                    echo "<tr><td>$c</td><td class='id'>$batch_no</td><td>$s_name</td><td>$pay_mode</td><td>$paid</td><td>$fee</td><td><a class='link mdi mdi-email btn-email' data-id=".$batch_no."></a></td></tr>";
                               
                                  }
                               }
                            
                                ?>
                      </tbody>
                  
                    </table>
                  </div>
                </div>
              </div>
            </div>
          </div>
          <!-- ============================================================== -->
          <footer class="footer text-center">
          All Rights Reserved by ECI. Designed and Developed by
          <a href="https://www.ntlogix.in">NTLogix</a>.
        </footer>
       
   <!-- All Jquery -->
    <!-- ============================================================== -->
    <script src="../assets/libs/jquery/dist/jquery.min.js"></script>
    <!-- Bootstrap tether Core JavaScript -->
    <script src="../assets/libs/bootstrap/dist/js/bootstrap.bundle.min.js"></script>
    <!-- slimscrollbar scrollbar JavaScript -->
    <script src="../assets/libs/perfect-scrollbar/dist/perfect-scrollbar.jquery.min.js"></script>
    <script src="../assets/extra-libs/sparkline/sparkline.js"></script>
    <!--Wave Effects -->
    <script src="../dist/js/waves.js"></script>
    <!--Menu sidebar -->
    <script src="../dist/js/sidebarmenu.js"></script>
    <!--Custom JavaScript -->
    <script src="../dist/js/custom.min.js"></script>
    <!-- this page js -->
    <script src="../assets/extra-libs/multicheck/datatable-checkbox-init.js"></script>
    <script src="../assets/extra-libs/multicheck/jquery.multicheck.js"></script>
    <script src="../assets/extra-libs/DataTables/datatables.min.js"></script>
    <script src="https://cdn.jsdelivr.net/npm/sweetalert2@11"></script>
    <script>
      /****************************************
       *       Basic Table                   *
       ****************************************/
      
    </script>
    <script>
    var msg;
      var icon;
      function showAlert(msg,icon) {
          Swal.fire({
              title: msg,
              icon: icon,
              confirmButtonText: 'Close'
          });
      }
      $(document).ready(function(){

                $("#zero_config").DataTable();
                $("table").on("click",".btn-email",function(){
                    var id = $(this).closest('tr').find('td.id').text();                   
                    $.ajax({
                                url:"core/sendEmail.php",
                                method:"post",
                                data: {
                                   id:id,
                                   state:'fee',                          
                                },
                                success: function(data){                        
                                  if(data.length===1)
                                  {                            
                                    showAlert('Email Successfully Sent!','success');
                                    setTimeout(function(){window.location='./pending-fee.php';}, 2000);                                   
                                  }
                                }
                            });   
                  

                });

      })




</script>

  </body>
</html>