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

ini_set('display_errors', 1);
ini_set('display_startup_errors', 1);
error_reporting(E_ALL);

$cur_date=date("Y-m-d", strtotime('-7 days'));
$entity=$_REQUEST['entity'];

$query="SELECT t3.name,t1.exam_id,t1.links,t2.cat_id,t3.url_slug as slug,t1.update_date,t1.description,t1.status,t1.display_text,t2.exam_name,t3.img_icon,st.image_icon,t2.url_slug,t2.status FROM sp_exam_links as t1
LEFT JOIN sp_exam as t2 ON t1.exam_id=t2.exam_id
LEFT JOIN sp_exam_category as t3 ON t2.cat_id=t3.cat_id
LEFT JOIN sp_states as st on st.state_id=t2.state_id
where t1.entity_id='$entity' AND t1.status!='0' AND t2.status!='0' AND t1.links!='' group by t2.exam_name
ORDER BY t1.update_date DESC limit 0,20";
$sql2=$db->prepare($query);
$sql2->execute();

$mainSub = array();
while($row=$sql2->fetch()){	
if($row['cat_id']==0){
$img=$row['image_icon'];	
}
else{
$img=$row['img_icon'];
}		
$category=$row['name'];
$examname=$row['exam_name'];
$link=$row['links'];
$display_text=$row['display_text'];
$slu=$row['slug'];
$date=$row['update_date'];
$url_slug=$row['url_slug'];
$badge = false;
if($date>=$cur_date){
$badge = true;	
	
}
$main=array("category"=>$category,"cat_url"=>$slu,"img_icon"=>$img,"exam"=>$examname,"link"=>$link,"url_slug"=>$url_slug,"date"=>$date,'badge'=> $badge);
$mainSub[]=$main;

}

echo json_encode($mainSub);

?>