<?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('Manage Fee',$menuper)){
		  
	   }else{
		 
	header("location:index.php");
		   
		}
include('include/function.php');
include("include/header.php");
include("include/sidebar.php");
if(isset($_REQUEST['did']) && $_REQUEST['did']!=''){
	$dovalue="";
	$doid=$_REQUEST['did'];
	
	$check=mysqli_query($con,"delete from setinstallment where id='$doid'");
	
	if($check){
	$_SESSION['msg']='Record Deleted Successfully';
	}
	echo '<META HTTP-EQUIV="Refresh" Content="0; URL=setinstallmentreports.php">';
	exit;
}
?>

		<script src="plugins/jQuery/jQuery-2.1.4.min.js"  type="text/javascript"></script>
	
<div class="content-wrapper">
  <section class="content-header">
    <h1> Misc Fee Monthly Reports</h1>
    <ol class="breadcrumb">
      <li><a href="#"><i class="fa fa-dashboard"></i> Home</a></li>
      <li><a href="#">Misc Fee Monthly Reports</a></li>
    </ol>
  </section>
  <!-- Main content -->
  <section class="content">
    <div class="row">
      <div class="col-xs-12">
        <div class="box">
          <div class="box-header">
            
          </div><!-- /.box-header -->
          <div class="box-body">
		 <!-- <form action="" method="get" id="tables">
		  	<select class='form-control col-md-3' id="tablechange" name="table"  style="width: 24%;" >
				<option value="0" <?php  //if($_GET['table']==0){ echo "selected";}?>> Admission Enquiry Form </option>
				<option value="1" <?php  //if($_GET['table']==1){ echo "selected";}?>>Direct Admission  </option>
			</select>
			<input type="submit" value="Search" class="btn btn-primary"/>
		</form>  -->
	
				
            <table id="example1" class="table table-bordered table-striped">
			
              <thead>
                <tr>
                  <th>SR NO</th>
				
                  <th>Student ID</th>
			  
              
                
                 
                 
                  <th scope="col">Amount</th>
				  
				    <th scope="col">Start Date</th>
				    <th scope="col">End Date</th>
					 <th scope="col">Total Due</th>
					 
					    
				    <th scope="col">Pay</th>
				 
                </tr>
              </thead>
              <tbody>

              <?php 
			 
		
			 
		
			$Query= mysqli_query($con,"select * from addmiscfeeparticular  group by student_id
				  ");
			  
			  		$i = 1;
					
	  				  while($Row2=mysqli_fetch_array($Query)){ 
					
						$numrows=mysqli_num_rows(mysqli_query($con,"SELECT * FROM `paymiscfee` WHERE month(now())=month(created_at) and year(now())=year(created_at) 
				  and student_id='".$Row2['student_id']."' and types='monthly' order by id desc"));
				  if($numrows){}else{
					  ?>
					  
                    <tr>
					
                      <td><span id="ContentPlaceHolder1_GridViewEnquiry_LabelStudentFirstName_0"><?=$i;?></span></td>	  
                       <td><span id="ContentPlaceHolder1_GridViewEnquiry_LabelStudentFirstName_0"><?=$Row2['student_id'];?></span></td>	
                      
					
                       
						
						  <td>
						      <?php
						$Query2= mysqli_query($con,"select * from addmiscfeeparticular  where student_id='".$Row2['student_id']."' and dates<=now()
				  ");
			  
			  	
					
	  				  while($Row22=mysqli_fetch_array($Query2)){  ?>
					  <span id="ContentPlaceHolder1_GridViewEnquiry_LabelLastQualification_0"><?=$Row22['amount'];?></span><br/>
					  <?php } ?>
					  
                        </td>
				   
						<td>
					  <?php
						$Query2= mysqli_query($con,"select * from addmiscfeeparticular  where student_id='".$Row2['student_id']."' and dates<=now()
				  ");
			  
			  	
					
	  				  while($Row22=mysqli_fetch_array($Query2)){  ?>
					  <span id="ContentPlaceHolder1_GridViewEnquiry_LabelLastQualification_0"><?=$Row22['dates'];?></span><br/>
					  <?php } ?> 
					 
                        </td>
						<td>
					  <?php
						$Query2= mysqli_query($con,"select * from addmiscfeeparticular  where student_id='".$Row2['student_id']."' and dates<=now()
				  ");
			  
			  	
					
	  				  while($Row22=mysqli_fetch_array($Query2)){  ?>
					  <span id="ContentPlaceHolder1_GridViewEnquiry_LabelLastQualification_0"><?=$Row22['enddate'];?></span><br/>
					 <?php } ?>
                        </td>
							<td>
					  <?php
						$Query2= mysqli_query($con,"select * from addmiscfeeparticular  where student_id='".$Row2['student_id']."' and dates<=now()
				  ");
			  
			  	
					
	  				  while($Row22=mysqli_fetch_array($Query2)){  ?>
					  <span id="ContentPlaceHolder1_GridViewEnquiry_LabelLastQualification_0"><?=$Row22['totalamount'];?></span><br/>
					 <?php } ?>
                        </td>
                        
                       
				   <td>
			

<a href="./paymiscfeemonthlypayment.php?upid=<?php echo $Row2['student_id']; ?>" ><i class="fa fa-paypal text-red" aria-hidden="true"></i>
</a><br/>		
					  
					
						
						
						</td>
						 
											
					  
					
                    </tr>                
						  <?php 
						  } } ?>                    
              </tbody>
            </table>
			
          </div><!-- /.box-body -->
        </div><!-- /.box -->
      </div><!-- /.col -->
    </div><!-- /.row -->
  </section><!-- /.content -->
</div><!-- /.content-wrapper -->
<!-- footer start -->
<?php
include('include/footer.php');
?>
<!-- footer end -->
<!-- DataTables -->
<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( {
        dom: 'Bfrtip',
        columnDefs: [
            {
                targets: 1,
                className: 'noVis'
            }
        ],
        buttons: [
            {
                extend: 'colvis',
                columns: ':not(.noVis)'
            }
        ],
		 buttons: [
		  { extend: 'colvis', text: 'COLOUMNS' },
		 { extend: 'csv', text: 'Export to CSV' },
		 { extend: 'excel', text: 'Export to Excel' },
           { extend: 'pdfHtml5', text: 'Create PDF', orientation: 'landscape', exportOptions: { columns: ':visible' } },
{ extend: 'print', text: 'Print', exportOptions:{columns: ':visible',autoPrint: true}}
        ],
		
    } );
} );
	//$(function () {
	//$("#example1").DataTable();
	
	//});
</script>