<?php 
session_start();
include_once('include/config.inc.php');
$emparray=array();
$studentsid=$_POST['studentsid'];
$student_id=$_POST['student_id'];
$newvar=$student_id.','.$studentsid;
$id=$_POST['id'];

$check = "select * from directsetinstallment where student_id='".$id."' "; 
$result1 = mysqli_query($con, $check) or die("Error in Selecting " . mysqli_error($con));
$rowcount=mysqli_num_rows($result1);
if($rowcount==0){
    $sql = "select * from direct_admission 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))
			{
				$emparray= $row;
				$total=$row['bookingamount']+$row['submitfee']+$row['lessdiscount'];
				$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);
?>