<?php
header("Access-Control-Allow-Origin: *");
header('Content-Type: application/json');
include "config.php";

	$json = file_get_contents('php://input');
	$data = json_decode($json);
	$type = $data->type;

	$getTypeQuery = "SELECT kn.id, kn.type,kn.url_slug, kn.name, kn.state_id, s.state_name, s.image_icon, kn.city_id, c.city, kn.pincode, kn.address, kn.official_website_link, kn.online_apply_link, kn.online_fee_link, kn.result_link, kn.addmission_guidelines, kn.addmission_details FROM sp_kvs_navodya as kn LEFT JOIN sp_states as s on s.state_id=kn.state_id LEFT JOIN sp_city as c on c.city_id=kn.city_id WHERE kn.status='1' and  kn.type='$type' ORDER BY kn.display_order ";

	$sqlTypeQuery=$db->prepare($getTypeQuery);
	$sqlTypeQuery->execute();
	
	$kvsNvsDataArray=array();
	while($rowTypeQuery=$sqlTypeQuery->fetch()){	

		$kvsNvsArray=array("id"=>$rowTypeQuery['id'], "name"=>$rowTypeQuery['name'], "url_slug"=>$rowTypeQuery['url_slug'], "state_id"=>$rowTypeQuery['state_id'], "state_name"=>$rowTypeQuery['state_name'], "state_image"=>$rowTypeQuery['image_icon'], "city_id"=>$rowTypeQuery['city_id'], "city_name"=>$rowTypeQuery['city'], "pincode"=>$rowTypeQuery['pincode'], "address"=>$rowTypeQuery['address'], "official_website_link"=>$rowTypeQuery['official_website_link'], "addmission_guidelines"=>$rowTypeQuery['addmission_guidelines'], "addmission_details"=>$rowTypeQuery['addmission_details'], "online_apply_link"=>$rowTypeQuery['online_apply_link'], "online_fee_link"=>$rowTypeQuery['online_fee_link'], "result_link"=>$rowTypeQuery['result_link']);
		$kvsNvsDataArray[] = $kvsNvsArray;
	}
	
	$getKvsNvsStateQuery="SELECT kn.state_id, count(kn.id) as count, s.state_name, s.image_icon, s.state_slug FROM sp_kvs_navodya as kn INNER JOIN sp_states as s ON s.state_id=kn.state_id WHERE kn.type='$type' group by kn.state_id order by s.state_name";	

	$sqlKvsNvsState=$db->prepare($getKvsNvsStateQuery);
	$sqlKvsNvsState->execute();

	$kvsNvsStateDataArray = array();
	while($rowKvsNvsState=$sqlKvsNvsState->fetch()){	
		$state_id= $rowKvsNvsState['state_id'];
		$kn_count= $rowKvsNvsState['count'];
		$state_name = $rowKvsNvsState['state_name'];
		$state_slug = $rowKvsNvsState['state_slug'];
		$state_image = $rowKvsNvsState['image_icon'];
		
		$kvsNvsStateArray=array("state_id"=>$state_id, "state_name"=>$state_name, "kn_count"=>$kn_count, "state_slug"=>$state_slug, "state_image"=>$state_image);
		$kvsNvsStateDataArray[]=$kvsNvsStateArray;
	}
	
	$dataArray = array("kvs_nvs_data"=>$kvsNvsDataArray, "state_data"=>$kvsNvsStateDataArray);
	echo json_encode($dataArray, TRUE);


?>