<?php

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

//$examIDq = "SELECT links.exam_id FROM sp_exam_links as links LEFT JOIN sp_exam AS exam on exam.exam_id=links.exam_id WHERE links.status='1' group by links.exam_id ORDER BY exam.top_display_order, max(links.update_date) DESC limit 8 ";
$examIDq = "SELECT links.exam_id FROM sp_exam_links as links INNER JOIN sp_exam AS exam on exam.exam_id=links.exam_id where exam.status='1'  AND exam.top_display_order !=0 group by links.exam_id ORDER BY exam.top_display_order DESC limit 0,10";
$sqlexam = $db->prepare($examIDq);
$sqlexam->execute();


$sqlexamData = $sqlexam->fetchAll();

//echo "<pre> Data : ".print_r($sqlexamData,TRUE)."</pre>";

$examId = '';
for ($i=0; $i <count($sqlexamData); $i++) { 

$examId .= 	$sqlexamData[$i]['exam_id'].',';
}

 $examIDs = rtrim($examId,',');

  $query="SELECT t1.exam_id, t1.exam_name, t1.post_name, t1.url_slug, t1.cat_id, t1.state_id, t1.fee_desc, t1.physical, t1.total_vacancy, t1.sp_exam_id, t1.off_web_link, t1.display_order, t1.status,t1.add_date,t2.name,t2.img_icon,st.image_icon, t1.top_display_order FROM sp_exam AS t1
  LEFT JOIN sp_exam_links AS links ON links.exam_id=t1.exam_id
LEFT JOIN sp_exam_category AS t2 on t2.cat_id=t1.cat_id
LEFT JOIN sp_states AS st on st.state_id=t1.state_id
WHERE t1.exam_id IN  (".$examIDs.") 
group by t1.exam_id ORDER BY t1.top_display_order DESC limit 0,10";

$sql=$db->prepare($query);
$sql->execute();

$mainarray=array();

while($row=$sql->fetch()){	

$id=$row['exam_id'];
$exam=$row['exam_name'];
$post=$row['post_name'];
$display=$row['url_slug'];
$status=$row['status'];
$display_order=$row['display_order'];
$top_display_order=$row['top_display_order'];
if($row['cat_id']==0){
$image=$row['image_icon'];	
}
else{
$image=$row['img_icon'];
}

 $queryLinks ="SELECT sel.display_text,sel.links,sel.entity_id,e1.name,e1.status,sel.update_date,sel.display_entity FROM sp_exam_links As sel
        LEFT JOIN sp_exam_entity As e1 ON e1.id=sel.entity_id
        WHERE exam_id=$id and sel.display_entity='1' limit 0,1";

$sqleLinks=$db->prepare($queryLinks);
$sqleLinks->execute();

$linksArray = array();

while( $roweLinks = $sqleLinks->fetch() ){	
   

   $linksArray[] = array( 'entity_id'=>$roweLinks['entity_id'] , 'display_text'=>$roweLinks['display_text'] , 'links'=>$roweLinks['links'],'enti_name'=>$roweLinks['name'],'status'=>$roweLinks['status'],'add_date'=>$roweLinks['update_date'],'display_entity'=>$roweLinks['display_entity'] ); 
}

$array=array("exam_id"=>$id,"exam_name"=>$exam,"post_name"=>$post,'image'=>"images/".$image,"display_name"=>$display,"status"=>$status,"display_order"=>$display_order,"top_display_order"=>$top_display_order ,'links'=>$linksArray);
$mainarray[]=$array;

}

//print_r($mainarray);

echo json_encode($mainarray);
?>