<?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);
$exam=$_REQUEST['slug'];

$query="SELECT t1.exam_id,t1.exam_name,t1.url_slug,t1.total_vacancy,t1.cat_id,e.img_icon,t1.age_id,t3.age,t4.quali_name,t1.physical,t1.display_order,t1.fee_desc,t1.exam_summary FROM sp_exam as t1
LEFT JOIN sp_age_limit as t3 on t1.age_id=t3.age_lim_id
LEFT JOIN sp_qualification as t4 ON t1.qualification_id=t4.qualification_id
LEFT JOIN sp_exam_category as e on e.cat_id=t1.cat_id 
WHERE t1.url_slug='$exam'";
$sql=$db->prepare($query);
$sql->execute();
$mainarray=array();

while($row=$sql->fetch()){
$exam_id=$row['exam_id'];
$img='/images/'. $row['img_icon'];	
$summary=$row['exam_summary'];
$examname=$row['exam_name'];
$vacancy=$row['total_vacancy'];
$agelimit=$row['age'];
$quali=$row['quali_name'];
$phy=$row['physical'];
$fee=$row['fee_desc'];

$query2="SELECT t1.exam_id,t1.entity_id,t1.display_text,t1.links,t1.date_type,t1.date,t2.name FROM sp_exam_links as t1
LEFT JOIN sp_exam_entity as t2 on t2.id=t1.entity_id WHERE exam_id='$exam_id'";
$sql2=$db->prepare($query2);
$sql2->execute();

$mainSub = array();
while($row2=$sql2->fetch()){	
$displaytext=$row2['name'];
$desc=$row2['display_text'];
$date_type=$row2["date_type"];
$dates=$row2["date"];
$date="";
if($date_type=="N"){
$d=explode(",",$dates);
$e=array();
for($p=0;$p<count($d);$p++){
$new_date = date('d-m-Y', strtotime($d[$p]));
$e[]=$new_date;
$date=implode(" ,",$e);
}}
if($date_type=="FT"){
$dd=explode(",",$dates);
$date1 = date('d-m-Y', strtotime($dd[0]));
$date2 = date('d-m-Y', strtotime($dd[1]));
$date=' From '.$date1.' To '.$date2;
}

$main=array("display_text"=>$displaytext,"date"=>$date);
$mainSub[]=$main;
}


$query3="SELECT tab1.id,tab1.name,tab1.status,tab2.links,tab2.display_text,tab2.description,tab2.status,tab2.date FROM sp_exam_entity as tab1
LEFT JOIN sp_exam_links As tab2 ON  tab2.entity_id=tab1.id and tab2.exam_id='$exam_id' order by display_order asc";
$sql3=$db->prepare($query3);
$sql3->execute();

$mainSub2 = array();
while($row3=$sql3->fetch()){	
$enti=$row3['name'];
$display=$row3['display_text'];
$descrip=$row3['description'];
$links=$row3['links'];
$dates=$row3['date'];
$statuss=$row3['status'];
$main2=array("enti_name"=>$enti,"text"=>$display,"description"=>$descrip,"link"=>$links,"date"=>$dates,"status"=>$statuss);
$mainSub2[]=$main2;
}


$query4="SELECT t6.exam_id, t6.subject_name, t6.no_of_question,t6.marks_for_subject,t6.exam_id, t6.subject_name, t6.marks_for_subject, t6.date_added, t6.status FROM sp_exam_pattern as t6 WHERE t6.exam_id='$exam_id'";
$sql4=$db->prepare($query4);
$sql4->execute();

$mainSub3 = array();
while($row4=$sql4->fetch()){	
$sub=$row4['subject_name'];
$que=$row4['no_of_question'];
$marks=$row4['marks_for_subject'];
$d=$row4['date_added'];
$status3=$row4['status'];
$main3=array("subject"=>$sub,"question"=>$que,"marks"=>$marks,"date"=>$d,"status"=>$status3);
$mainSub3[]=$main3;
}

$query5="SELECT exam_id, st_sc, obc, gen, women, ex_servicemen, others,year, status FROM sp_exam_cutoff WHERE exam_id='$exam_id' AND status='1'";
$sql5=$db->prepare($query5);
$sql5->execute();

$mainSub4 = array();
while($row5=$sql5->fetch()){	
$year=$row5['year'];
$st_sc=$row5['st_sc'];
$obc=$row5['obc'];
$gen=$row5['gen'];
$women=$row5['women'];
$ex_servicemen=$row5['ex_servicemen'];
$others=$row5['others'];
$status=$row5['status'];
$main4=array("year"=>$year,"st/sc"=>$st_sc,"obc"=>$obc,"general"=>$gen,"women"=>$women,"ex_servicemen"=>$ex_servicemen,"other"=>$others,"status"=>$status);
$mainSub4[]=$main4;
}


$query6="SELECT id, exam_id, type_id, type_name, gen, obc, sc, st, ebc, wbc, total_vac, age_limit, eligibility FROM sp_vacancy_detail WHERE exam_id='$exam_id' AND status='1'";
$sql6=$db->prepare($query6);
$sql6->execute();

$mainSub5 = array();
while($row6=$sql6->fetch()){
$id= $row6['id'];
$exam= $row6['exam_id'];
$type= $row6['type_id'];
$typename= $row6['type_name'];
$gen= $row6['gen'];
$obc= $row6['obc'];
$sc= $row6['sc'];
$st= $row6['st'];
$ebc= $row6['ebc'];
$wbc= $row6['wbc'];
$total= $row6['total_vac'];
$age= $row6['age_limit'];
$eligibility= $row6['eligibility'];

$main5=array("id"=>$id,"exam_id"=>$exam,"type"=>$type,"type_name"=>$typename,"gen"=>$gen,"obc"=>$obc,"sc"=>$sc,"st"=>$st,"ebc"=>$ebc,"wbc"=>$wbc,"total_vac"=>$total,"age_limit"=>$age,"eligibility"=>$eligibility);
$mainSub5[]=$main5;
}

$array=array("image"=>$img,"exam_name"=>$examname,"exam_summary"=>$summary,"vacancy"=>$vacancy,"age_limit"=>$agelimit,"qualification"=>$quali,"fee_description"=>$fee,"physical"=>$phy,"dates"=>$mainSub,"links"=>$mainSub2,"pattern"=>$mainSub3,"cutoff"=>$mainSub4,"vacancy"=>$mainSub5);
$mainarray[]=$array;
}
//print_r($mainarray);
echo json_encode($mainarray);

?>