<?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,t4.image_icon,t2.display_order,t3.url_slug as slug,t1.update_date,t1.description,t1.status,t1.display_text,t2.exam_name,t3.img_icon,t2.url_slug,t1.status,t2.status FROM sp_exam_links as t1
LEFT JOIN sp_exam as t2 ON t1.exam_id=t2.exam_id
LEFT JOIN sp_states as t4 on t2.state_id=t4.state_id
LEFT JOIN sp_exam_category as t3 ON t2.cat_id=t3.cat_id where t1.links!='' and t1.entity_id='$entity' and t1.status!='0' and t2.status!='0' group by t2.exam_id
ORDER BY t2.add_date DESC limit 0,20";
$sql2=$db->prepare($query);
$sql2->execute();

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

}

echo json_encode($mainSub);

?>