<?php
include "config.php";

header("Access-Control-Allow-Origin: *");
header('Content-Type: application/json');

$exam_id=$_REQUEST['exam_id'];

$getlinkDates="SELECT el.exam_id,el.entity_id,el.display_text,el.display_text_dates,el.links,el.date_type,el.date,ee.name from sp_exam_links as el left join sp_exam_entity as ee on ee.id=el.entity_id left join sp_exam as e on e.exam_id=el.exam_id where FIND_IN_SET('$exam_id',e.sp_exam_id) order by ee.display_order asc";
$sql=$db->prepare($getlinkDates);
$sql->execute();
$mainarray=array();
while($row=$sql->fetch()){
	$entity_id=$row['entity_id'];
	$en_name=$row['name'];
	$en_display_text=$row['display_text'];
	$en_date_text=$row['display_text_dates'];
	$en_links=$row['links'];
	$en_date_type=$row['date_type'];
	$en_date=$row['date'];

	$array=array("entity_id"=>$entity_id,"title"=>$en_name,"display_text"=>$en_display_text,"display_text_dates"=>$en_date_text,"link"=>$en_links,"date_type"=>$en_date_type,"date"=>$en_date);
	$getArray[]=$array;

}		
$getExamDetails="SELECT e.off_web_link,e.qualification_id, e.qualification_desc, q.quali_name, e.age_id, e.age_to, e.age_from, e.age_desc, a.age, e.fee_desc, e.exam_name, e.exam_summary, e.total_vacancy, e.exam_mode, e.important_notes, e.other_info, e.other_info_tabname from sp_exam as e left join sp_qualification as q on q.qualification_id=e.qualification_id left join sp_age_limit as a on a.age_lim_id=e.age_id where FIND_IN_SET('$exam_id',e.sp_exam_id)";
$stmt=$db->prepare($getExamDetails);
$stmt->execute();
while($data=$stmt->fetch()){
	
	$qualification_id=$data['qualification_id'];
	$qualification_name=$data['quali_name'];
	$qualification_desc = strip_tags($data['qualification_desc']);
	$exam_name=$data['exam_name'];
	$exam_summary=strip_tags($data['exam_summary']);
	$total_vacancy=$data['total_vacancy'];
	$exam_mode = $data['exam_mode'];
	$important_notes = strip_tags($data['important_notes']);
	$off_web_link = $data['off_web_link'];
	$other_info = $data['other_info'];
	$other_info_tabname = $data['other_info_tabname'];

	$age_id=$data['age_id'];
	$ageto=$data['age_to'];
	$agefrom=$data['age_from'];
	$ageDesc = strip_tags($data['age_desc']);
	$ageValue=$data['age'];
	if( ($age_id==0 || $age_id=='') && ($ageto!='0' && $agefrom!='0') )
	{
		$ageData = $ageto.'-'.$agefrom.' Years';
	}
	else if(($age_id==0 || $age_id=='') && ($ageto!='0' && $agefrom=='0'))
	{
		$ageData = 'Min '.$ageto.' years';
	}
	else if(($age_id==0 || $age_id=='') && ($ageto=='0' && $agefrom!='0'))
	{
		$ageData = 'Max '.$agefrom.' years';
	}
	else if(($age_id!=0 || $age_id!='') && ($ageto=='0' && $agefrom=='0'))
	{
		$ageData = $ageValue.' years';
	}
	$feeDesc = $data['fee_desc'];


	$detailArray=array("qfic_id"=>$qualification_id, "qfic_name"=>$qualification_name, "qfic_desc"=>$qualification_desc, "age_id"=>$age_id,"age_data"=>$ageData, "age_desc"=>$ageDesc, "fee_desc"=>$feeDesc, "exam_id"=>$exam_id, "exam_name"=>$exam_name, "exam_summary"=>$exam_summary, "total_vacancy"=>$total_vacancy, "exam_mode"=>$exam_mode, "important_notes"=>$important_notes,"off_web_link"=>$off_web_link, "other_info"=>$other_info, "other_info_tabname"=>$other_info_tabname);
	$detail[]=$detailArray;
}


$mainarray[]=array("linkArray"=>$getArray,"examDetail"=>$detail);

echo json_encode($mainarray);
?>