<?php 
session_start();
include_once('include/config.inc.php');
$emparray=array();

$id=$_POST['id'];

$check = "select * from setinstallment where studentid='".$id."' "; 
$result1 = mysqli_query($con, $check) or die("Error in Selecting " . mysqli_error($con));
$rowcount=mysqli_num_rows($result1);
	$emparray['num']=$rowcount;
if($rowcount==0){
	
    $sql = "select * from admission_enquiry_form where student_id='".$_POST['id']."' and status='1'"; 
    $result = mysqli_query($con, $sql) or die("Error in Selecting " . mysqli_error($con));
    $rowcounts=mysqli_num_rows($result);
	
	
	
	
	if($rowcounts==1){
			if($row =mysqli_fetch_assoc($result))
			{
			    
			     $sqllo = "select * from commenacademicyear where id='".$row['academicyear']."'"; 
    $result26 = mysqli_query($con, $sqllo) or die("Error in Selecting " . mysqli_error($con));
    $acede =mysqli_fetch_assoc($result26);
    
				$emparray= $row;
				
				$emparray['academicstartdate']=$acede['academicstartdate'];
				$emparray['academicenddate']=$acede['academicenddate'];
				$total=$row['submitfee'];
				$lesstotal=$row['bookingamount']+$row['submitfee']+$row['lessdiscount'];
				$due=$row['totalfee']-$lesstotal;
				
			}
			if($total>0){
			$emparray['totalsubmitfee']=$total;
			$emparray['due']=$due;
			
			 echo json_encode($emparray);
			}else{
			$emparray=array();
			$emparray['status']='notfound';
			 echo json_encode($emparray);
			}
	}else{
		$emparray['status']='notfound';
		 echo json_encode($emparray);
	}	
}else{
	$emparray['status']='error';
     echo json_encode($emparray);
}
    
    mysqli_close($con);
?>