<?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");
		   
		}
$_SESSION['page_name']="Fee";
include('include/function.php');
include("include/header.php");
include("include/sidebar.php");

if(isset($_REQUEST['upid']) && $_REQUEST['upid']!=''){
	  $dovalue="PaySetInstallment";
	  $doid=$_REQUEST['upid'];
	  $upuserresult=mysqli_query($con,"select * from payinstallment where id='".$_REQUEST['upid']."'");
	  $upuserarr=mysqli_fetch_array($upuserresult);
	  

		 
        $installment_id=mysqli_query($con,"select * from setinstallment where id='".$upuserarr['installment_id']."'");
	  $installment_id=mysqli_fetch_array($installment_id);
	  $upuserresult1=mysqli_query($con,"select * from admission_enquiry_form where student_id='".$installment_id['studentid']."'");
	  $upuserarr1=mysqli_fetch_array($upuserresult1);
}else{
 	  $dovalue="StudentEnquiryEntry";
	  $doid='';
} 
?>
<style>
table.t01 tr:nth-child(even) {
    background-color: #eee;
}
table.t01 tr:nth-child(odd) {
   background-color: #fff;
}
table.t01 th {
    background-color: black;
    color: white;
}
</style>
<div class="content-wrapper">
  <!-- Content Header (Page header) -->
  <section class="content-header">
    <h1> Student Ledger <small></small> </h1>
    <ol class="breadcrumb">
      <li><a href="#"><i class="fa fa-dashboard"></i> Home</a></li>
      <li><a href="#">Student Ledger</a></li>
    </ol>
  </section>
  <!-- Main content -->
  <section class="content">
    <div class="row">
      <div class="col-md-12">
        <div class="box box-info">
          <div class="box-header">
            <h3 class="box-title">Student Ledger <small></small></h3>
            <!-- tools box -->
            <div class="pull-right box-tools">
              <button class="btn btn-info btn-sm" data-widget="collapse" data-toggle="tooltip" title="Collapse"><i class="fa fa-minus"></i></button>
              <button class="btn btn-info btn-sm" data-widget="remove" data-toggle="tooltip" title="Remove"><i class="fa fa-times"></i></button>
            </div><!-- /. tools -->
          </div><!-- /.box-header -->
          <div class="box-body pad">
            <div class="col-md-12">

              <input type="hidden"  name="do" value="<?php echo $dovalue;?>" />
                <input type="hidden"  name="doid1" value="<?php echo $doid;?>" />
                <input type="hidden"  name="UserID" value="<?php echo $_SESSION["ecomid"];?>" />
             
			    <div class="col-md-12">
                      
                <form action="" method="post" >
				<input type="text" name="mobile" placeholder="Search By Mobile No "
value="<?php if(!empty($_POST['mobile'])){ echo $_POST['mobile']; }else{ } ?>"
				class="form-control col-md-3" style="width:300px;" />
				<input type="submit" value="Search" class="btn btn-primary"/>
                </div> 
				
				<?php 
				$mobile=$_POST['mobile'];
				if(!empty($mobile)){ 
				
				$upuserresult1=mysqli_query($con,"select * from admission_enquiry_form where student_id='".$mobile."'");
	  $upuserarr1=mysqli_fetch_array($upuserresult1);

				?>
				
			  <div class="form-group col-md-4">
                 <h4> Student Id  :              
                 <?php echo $upuserarr1['student_id']."</h4>";?>
                </div> 
				  <div class="form-group col-md-4">
                 <h4> Name  :              
                 <?php echo $upuserarr1['name']."</h4>";?>
                </div> 
				
				<div class="form-group col-md-4">
                  <h4> Total Amount :
                  <?php echo $upuserarr1['totalfee']."</h4>";?>               
                </div>
                <div class="form-group col-md-4">
                  <h4>Discount :                 
                  <?php echo $upuserarr1['lessdiscount']."</h4>";?>
                </div>
				 <div class="form-group col-md-4">
                  <h4>MISC Fee :                 
                  <?php echo $upuserarr1['miscfeetotal']."</h4>";?>
                </div>
				
			<?php
			$setinstallmentq=mysqli_query($con,"select * from setinstallment left JOIN payinstallment ON 
			  setinstallment.id=payinstallment.installment_id  where setinstallment.studentid='".$upuserarr1['student_id']."'");
	  $setinstallment=mysqli_num_rows($setinstallmentq); ?>
	 <div class="form-group col-md-4">
                  <h3>No Of Installment :                 
                  <?php echo $setinstallment."</h3>";?>
                </div> 
	 <?php 
	  if($setinstallment>0){
		  echo "<table style='width:100%; margin-top:30px;' class='t01'>";
		  echo "<tr><th>Installment Date</th><th>Amount</th><th>Late Fine</th><th>Payment Date</th><th>Payment Amount</th>
		  <th>Fine </th><th>Payment Mode </th></tr>";
		  while($setinstallment=mysqli_fetch_array($setinstallmentq)){ 
			  echo "<tr><td>" . $setinstallment['installmentdate'] . "</td><td> " . $setinstallment['amount'] . "</td>
			  <td> " . $setinstallment['latefine'] . "</td><td> " . $setinstallment['payment_date'] . "</td>
			  <td> " . $setinstallment['payment_amount'] . "</td><td> " . $setinstallment['fine'] . "</td>
			  <td> " . $setinstallment['payment_mode'] . "</td></tr>";
			  
		  }
		  echo "</table>";
	  }else{
		  echo "No Record Found!";
	  }
			?>
              
                <?php
				$miscfee=$upuserarr1['miscfee'];
				$miscfees=explode(',',$miscfee);
				$miscfeed=count($miscfees);
				//echo $miscfeed;
						  echo "<table style='width:100%; margin-top:30px;' class='t01'>";
		  echo "<tr><th>Fee</th><th>Amount</th></tr>";
			for($i=0; $i<=$miscfeed; $i++)
			{
				
			$setinstallmentq=mysqli_query($con,"select * from miscfeemaster where id='".$miscfees[$i]."'");
	        $setinstallmentl=mysqli_fetch_array($setinstallmentq);
			  echo "<tr><td>" . $setinstallmentl['feemaster'] . "</td><td> " . $setinstallmentl['amount'] . "</td>
                          </tr>";
			  
		 }
			 echo "</table>";
			?>

				
				                                                          
                <div class="box-footer">
				
                <button class="btn btn-primary" onclick="window.print();">Print</button>         
				  
                </div>
				<?php } ?>
			
			
            </div> 
          </div>   
        </div><!-- /.box -->
      </div><!-- /.col-->
    </div><!-- ./row -->
  </section><!-- /.content -->
</div>
<?php include('include/footer.php');?>