<?php
   include('include/header.php');
   
   $select_academic = select_academic();
   $select_class = select_class();
   $select_section = select_section1();
   $select_SubjectData = select_SubjectData()
?> 


<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 active">Student Fee</li>
    </ol>
  </nav>
</div><!-- End Page Title -->
<?php
  if(isset($_POST['Subm']))
  {
     student_feeData();
  }
?>
<section class="section">
      <div class="row">
        <div class="col-lg-12">

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

<form method="post">
<div class="row">
  
               <div class="col-md-3 mt-4">
                         <label for="exampleInputEmail1" class="form-label">Academic Year</label>
                          
                           <select name="yearOf" id="yearOf" required class="form-control" onChange="select_studentData()">
                            <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 class="col-md-3 mt-4">
                         <label for="exampleInputEmail1" class="form-label">Classes</label>
                          <select name="Class" id="Class" required class="form-control" onChange="select_studentData()">
                            <option value="">Please Select Class</option>
                            <?php
                               while($class= mysqli_fetch_array($select_class))
                               {


                            ?>
                               <option value="<?= $class['name']?>"><?= $class['name']?></option>
                               <?php
                                  }
                               ?>
                              </select>
                    </div>  

                    <div class="col-md-3 mt-4">
                         <label for="exampleInputEmail1" class="form-label">Section</label>
                          <select name="Section" id="Section" required class="form-control" onChange="select_studentData()">
                            <option value="">Please Select Section</option>
                            <?php
                               while($section= mysqli_fetch_array($select_section))
                               {


                            ?>
                               <option value="<?= $section['section']?>"><?= $section['section']?></option>
                               <?php
                                  }
                               ?>
                              </select>
                    </div>  
                  <div class="col-md-3 mt-4">

                      <label for="exampleInputEmail1" class="form-label">Syllabus Type</label>
                           <select name="syllabusdata" id="syllabusdata" class="form-control" onChange="select_studentData()" required>
                            <option value="">Please Select Syllabus</option>
                            <?php
                            $select_SyllabusData = select_SyllabusData();
                                while($syllabus = mysqli_fetch_array($select_SyllabusData)){
                            ?>
                            <option value="<?= $syllabus['name']?>"><?= $syllabus['name']?></option>
                            <?php
                                 }
                            ?>
                         </select>

                  </div>
                  <div class="col-md-3 mt-4">

                      <label for="exampleInputEmail1" class="form-label">Branch</label>
                           <select name="Branch" id="Branch" class="form-control" onChange="select_studentData()" required>
                            <option value="">Please Select Branch</option>
                            <?php
                            $select_branch = executework("SELECT * from branch_list");

                                while($branchrow = mysqli_fetch_array($select_branch)){
                            ?>
                            <option value="<?= $branchrow['branch_code']?>"><?= $branchrow['branch_name']?></option>
                            <?php
                                 }
                            ?>
                         </select>

                  </div>
                     <div class="col-md-3 mt-4">
                         <label for="exampleInputEmail1" class="form-label">Student Names</label>
                          <select name="Student_name" id="Student_name" class="form-control" onChange="FeeData()">
                            <option value="">Please Select Student Names</option>
                           
                          </select>
                    </div>  
                     <div class="col-md-3 mt-4">
                         <label for="exampleInputEmail1" class="form-label">Total Amount</label>
                          <input type="text" name="total_amount" id="total_amount" class="form-control" placeholder="Please Enter Fee Amount" readonly>
                    </div>  
                   <div class="col-md-3 mt-4">
                         <label for="exampleInputEmail1" class="form-label">Paid Amount</label>
                          <input type="text" name="paid_amount" id="paid_amount" class="form-control" placeholder="Please Enter Paid Amount">
                    </div>  

                   <!--  <div class="col-md-3 mt-4">
                         <label for="exampleInputEmail1" class="form-label">Fee Amount</label>
                          <input type="text" name="fee_amount" id="fee_amount" class="form-control" placeholder="Please Enter  Amount" required>
                    </div>   -->

                     <div class="col-md-3 mt-4">
                         <label for="exampleInputEmail1" class="form-label">Date</label>
                          <input type="text" name="amount_date" id="datepicker" class="form-control" placeholder="Please Enter  Amount" readonly required>
                    </div>  

                  </div>
                  <div class="mt-4">
                   <input type="submit" class="btn btn-primary" value="Submit" name="Subm">
                </div>
                  </div>
                  </div>
                 
                
           </form> 
   
    </div>
      
     </div>
          </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>

   -->


   <script>
     function select_studentData()
     {
        var YearOf = $('#yearOf').val();
        var sClass = $('#Class').val();
        var Section = $('#Section').val();
        var syllabusdata = $('#syllabusdata').val();
        var Branch = $('#Branch').val();
        if(YearOf !='' && sClass !='' && Section !='' && syllabusdata !='' && Branch !='')
        {
           $.ajax({
            url : "marks.php",
            data :  {YearOf : YearOf,sClass : sClass,Section : Section,syllabusdata : syllabusdata,type : 2,Branch : Branch},
            type : 'POST',
            success : function(data) {
             
                $('#Student_name').html(data);
               
               
            
        }
        });
        }
     }
   </script>

   <script>
     function FeeData()
     {
         var YearOf = $('#yearOf').val();
        var sClass = $('#Class').val();
        var Section = $('#Section').val();
        var syllabusdata = $('#syllabusdata').val();
        var Branch = $('#Branch').val();
        var student_name = $('#Student_name').val();
         if(YearOf !='' && sClass !='' && Section !='' && syllabusdata !='' && Branch !='')
        {
           $.ajax({
            url : "marks.php",
            data :  {YearOf : YearOf,sClass : sClass,Section : Section,syllabusdata : syllabusdata,type : 3,Branch : Branch,student_name : student_name},
            type : 'POST',
            success : function(data) {
             var response = JSON.parse(data);

                $('#total_amount').val(response.totalamount);
               
                $('#paid_amount').val(response.paid_amount);
            
        }
        });
        }
     }
   </script>