<?php
include ("include/makeSession.php"); 

$installment_id=mysqli_query($con,"select * from admin where id='".$_SESSION["ecomid"]."'");
	  $installment_id=mysqli_fetch_array($installment_id); 
$installment_id=$installment_id['menuper'];
	  $menuper=explode(',',$installment_id);
	   
	   if(in_array('Enquiry',$menuper)){
		  
	   }else{
		 
	header("location:index.php");
		   
		}
$_SESSION['page_name']="Fee";
include('include/function.php');
include("include/header.php");
include("include/sidebar.php");
?>
<div class="content-wrapper">
  <section class="content-header">
    <h1> Set One Time Fee</h1>
    <ol class="breadcrumb">
      <li><a href="#"><i class="fa fa-dashboard"></i> Home</a></li>
      <li><a href="#">Set One Time Fee</a></li>
    </ol>
  </section>
  <!-- Main content -->
  <section class="content">
    <div class="row">
      <div class="col-xs-12">
        <div class="box">
          <div class="box-header">
            <h3 class="box-title">Set One Time Fee :</h3>
          </div><!-- /.box-header -->
          <?php
            $action="";
            if(isset($_REQUEST['session'])&&isset($_REQUEST['course'])){
                $action="akshay_action.php";
            }
          ?>
          <form action="<?=$action;?>" method="POST">
              <input type="hidden" name="do" value="setonetimefee" />
              <div class="row">
              <div class="form-group col-md-4"style="margin-left:20px;">
              <select class="form-control" name="course" <?php if(isset($_REQUEST['course'])){ echo "disabled";} ?>>
                  <option>--select--</option>
                  <?php
                    $courseQ=mysqli_query($con,"select c_name,id from course");
                    while($courseR=mysqli_fetch_array($courseQ)){
                  ?>
                  <option value="<?=$courseR['id'];?>" <?php if(isset($_REQUEST['course'])&&$_REQUEST['course']==$courseR['id']){ echo "selected"; }?>><?=$courseR['c_name'];?></option>
                  <?php
                    }
                  ?>
              </select>
              <?php if(isset($_REQUEST['course'])){
                  ?>
                    <input type="hidden" name="course" value="<?=$_REQUEST['course'];?>" />
                  <?php
              } ?>
              </div>
              </div>
              <?php
                if(isset($_REQUEST['course'])){
              ?>
              <div class="row">
              <div class="form-group col-md-4"style="margin-left:20px;">
              <select class="form-control" name="session" <?php if(isset($_REQUEST['session'])){ echo "disabled";} ?>>
                  <option>--select--</option>
                  <?php
                    $sessionQ=mysqli_query($con,"select academictitle,id from commenacademicyear");
                    while($sessionR=mysqli_fetch_array($sessionQ)){
                  ?>
                  <option value="<?=$sessionR['id'];?>" <?php if(isset($_REQUEST['session'])&&$_REQUEST['session']==$sessionR['id']){ echo "selected"; }?>><?=$sessionR['academictitle'];?></option>
                  <?php
                    }
                  ?>
              </select>
              <?php if(isset($_REQUEST['session'])){
                  ?>
                    <input type="hidden" name="session" value="<?=$_REQUEST['session'];?>" />
                  <?php
              } ?>
              </div>
              </div>
              <?php
                }
                if(isset($_REQUEST['session'])){
                    $miscfeeQ=mysqli_query($con,"select id,feemaster from miscfeemaster where types='onetime' AND course_id='".$_REQUEST['course']."'");
                    while($miscfeeR=mysqli_fetch_array($miscfeeQ)){
                        ?>
                        <div class="row">
                        <div class="form-group col-md-4"style="margin-left:20px;">
                        <input type="checkbox" name="miscfees[]" class="form-group" value="<?=$miscfeeR['id'];?>" /><?=$miscfeeR['feemaster'];?>
                        </div>
                        </div>
                        <?php
                    }
                ?>
                
                
                <?php
                }
              ?>
              
          <?php
            if(isset($_REQUEST['course'])&&isset($_REQUEST['session'])){
          ?>
          <div class="box-body table-responsive">
		  		
            <table id="example1" class="table table-bordered table-striped">
			  <?php if(!empty($_SESSION['msg'])){
			  $msg=$_SESSION["msg"];
           echo '<div class="col-md-8">
			<div class="alert alert-success alert-dismissible">
  <a href="#" class="close" data-dismiss="alert" aria-label="close">&times;</a>
  '.$msg.'
		  </div>'; $_SESSION["msg"]='';} ?>
              <thead>
                <tr>
                  <th>#ID</th>
                  <th scope="col">Set Fee</th>
                  <th scope="col">Student Id</th>
                  <th scope="col">Student Name</th>
                </tr>
              </thead>
              <tbody>
              <?php $Query=mysqli_query($con,"select name, student_id from admission_enquiry_form where academicyear='".$_REQUEST['session']."'
                            AND course='".$_REQUEST['course']."'");
			  		$i = 1;	
	  				  while($Row=mysqli_fetch_array($Query)){ ?>
                    <tr>
                      <td><span><?=$i;?></span></td>
					  <td><span>
					      <div class="form-group col-md-4">
					      <input type="checkbox" name="students[]" class="form-group" value="<?=$Row['student_id'];?>" />
					      </div>
					      </span></td>
                      <td><span><?=$Row['student_id'];?></span></td>
                      <td><span><?=$Row['name'];?></span></td>
                    </tr>                
                <?php $i++;} ?>                    
              </tbody>
            </table>
          </div><!-- /.box-body -->
          <?php
            }
          ?>
          <div class="row">
            <div class="form-group col-md-4"style="margin-left:20px;margin-top:25px;">
            <input type="submit" class="btn btn-primary" value="<?php
                if(isset($_REQUEST['course'])&&isset($_REQUEST['session'])){
                    echo "Save Fee Settings";
                }else if(isset($_REQUEST['course'])){
                    echo "Search Fees";
                }else{
                    echo "Search Session";
                }
              ?>" />
              </div>
             </div>
          </form>
        </div><!-- /.box -->
      </div><!-- /.col -->
    </div><!-- /.row -->
  </section><!-- /.content -->
</div><!-- /.content-wrapper -->
<!-- footer start -->
<?php
include('include/footer.php');
?>
<!-- footer end -->
<script src="plugins/datatables/jquery.dataTables.min.js"  type="text/javascript"></script>
<script src="plugins/datatables/dataTables.bootstrap.min.js"  type="text/javascript"></script>
<script src="bootstrap/js/dataTables.buttons.min.js"  type="text/javascript"></script>

<script src="bootstrap/js/jszip.min.js"  type="text/javascript"></script>

<script src="bootstrap/js/pdfmake.min.js"  type="text/javascript"></script>
<script src="bootstrap/js/vfs_fonts.js"  type="text/javascript"></script>
<script src="bootstrap/js/buttons.html5.min.js"  type="text/javascript"></script>
<script src="bootstrap/js/buttons.print.min.js"  type="text/javascript"></script>

<script src="bootstrap/js/buttons.colVis.min.js"  type="text/javascript"></script>
<script src="bootstrap/js/buttons.flash.min.js"  type="text/javascript"></script>

<script  type="text/javascript">
$(document).ready(function() {
    $('#example1').DataTable( {
        
    } );
} );
	//$(function () {
	//$("#example1").DataTable();
	
	//});
</script>