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

//entity - 7,2,
$limit = isset($_REQUEST['limit']) && ($_REQUEST['limit']!='') ? "limit ".$_REQUEST['limit'] : "limit 20";

$entityArray = array('7,8' => 'latestJob', 2 => 'latestAdmitCard', 4 => 'latestResults');

$resultArrayData = array();

foreach($entityArray as $key => $value){
	//echo $key;
	$getLinksQuery = "select sel.exam_id, sel.entity_id, sel.display_text, sel.links, sel.date_type, sel.date, see.name as entity_name, se.exam_name, se.url_slug, cat.name as category_name, cat.img_icon, s.image_icon FROM sp_exam_links as sel 
	LEFT JOIN sp_exam_links as sel2 ON (sel2.exam_id=sel.exam_id AND sel.entity_id=sel2.entity_id AND sel.id < sel2.id ) 
	LEFT JOIN sp_exam_entity as see ON see.id=sel.entity_id 
	LEFT JOIN sp_exam as se on se.exam_id=sel.exam_id 
	LEFT JOIN sp_exam_category as cat ON cat.cat_id=se.cat_id 
	LEFT JOIN sp_states as s on s.state_id=se.state_id 
	WHERE see.id IN('$key') and sel2.id IS NULL and sel.status!='0' and se.status!='0' 
	order by sel.update_date desc $limit";
	$sqlLinksQuery=$db->prepare($getLinksQuery);
	$sqlLinksQuery->execute();
	$entiryArrayData=array();
	while($rowLQ=$sqlLinksQuery->fetch()){	
		$entiryArray=array("exam_id"=>$rowLQ['exam_id'], "entity_name"=>$rowLQ['entity_name'], "exam_name"=>$rowLQ['exam_name'], "url_slug"=>$rowLQ['url_slug'], "cat_icon"=>$rowLQ['img_icon'], "state_icon"=>$rowLQ['image_icon']);
		$entiryArrayData[]=$entiryArray;
	}
	$resultArrayData[]=array("entityName"=>$value, $value=>$entiryArrayData);
}
echo json_encode($resultArrayData);

?>