File: /var/www/nclive/backend/sp_exampage_new.php
<?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); */
$json = file_get_contents('php://input');
$data = json_decode($json);
$slug = $data->slug;
$getExamDetails="Select e.exam_id, e.exam_name, e.post_name, e.total_vacancy, e.exam_summary, e.cat_id, ec.img_icon, ec.name as catname, e.state_id, s.state_name, s.image_icon, s.state_code, e.important_notes, e.total_time, e.total_marks, e.exam_mode, e.negative_marking, q.quali_name, e.qualification_desc, e.age_id, e.age_to, e.age_from, e.age_desc, e.fee, e.fee_desc, e.other_info, e.other_info_tabname, e.off_web_link from sp_exam as e LEFT JOIN sp_exam_category as ec ON ec.cat_id=e.cat_id LEFT JOIN sp_states as s ON s.state_id=e.state_id left join sp_qualification as q on q.qualification_id=e.qualification_id where e.url_slug ='$slug'";
$stmtExam=$db->prepare($getExamDetails);
$stmtExam->execute();
$dataExam=$stmtExam->fetch();
/*********** exam details ***********/
$exam_id = $dataExam['exam_id'];
$exam_name = $dataExam['exam_name'];
$post_name = $dataExam['post_name'];
$vacancy = $dataExam['total_vacancy'];
$summary = $dataExam['exam_summary'];
$cat_id = $dataExam['cat_id'];
$cat_name = $dataExam['catname'];
$cat_image = $dataExam['img_icon'];
$state_id = $dataExam['state_id'];
$state_name = $dataExam['state_name'];
$state_code = $dataExam['state_code'];
$state_image = $dataExam['image_icon'];
$officialWeb = $dataExam['off_web_link'];
$examDetailArray = array("exam_id"=>$exam_id, "exam_name"=>$exam_name, "post_name"=>$post_name, "vacancy"=>$vacancy, "summary"=>$summary, "cat_id"=>$cat_id, "cat_name"=>$cat_name, "cat_image"=>$cat_image, "state_id"=>$state_id, "state_name"=>$state_name, "state_code"=>$state_code, "state_image"=>$state_image, "officialWeb"=>$officialWeb);
$examDetailArrayData[]=$examDetailArray;
/*********** important notes ***********/
$important_notes = $dataExam['important_notes'];
$impArray = array("notes"=>$important_notes);
$impArrayData[]=$impArray;
/*********** important date and links ***********/
$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 el.exam_id='$exam_id' order by ee.display_order asc";
$sqlLinkDate=$db->prepare($getlinkDates);
$sqlLinkDate->execute();
$dateArrayData=array();
$linkArrayData=array();
while($rowLinkDate=$sqlLinkDate->fetch()){
$entity_id=$rowLinkDate['entity_id'];
$en_name=$rowLinkDate['name'];
$en_display_text=$rowLinkDate['display_text'];
$en_date_text=$rowLinkDate['display_text_dates'];
$en_links=$rowLinkDate['links'];
$en_date_type=$rowLinkDate['date_type'];
$en_date=$rowLinkDate['date'];
if($en_date_type =='N'){
$dates = $en_date;
$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);
}
} else if($en_date_type == 'FT'){
$ft = $en_date;
$exp = explode(",",$ft);
$date1 = date('d-m-y',strtotime($exp[0]));
$date2 = date('d-m-y',strtotime($exp[1]));
$date = $date1 . ' to ' . $date2;
} else if($en_date_type == 'T'){
$date = $en_date;
}
$linkArray=array();
if($en_links!=''){
$linkArray["entity_id"] = $entity_id;
$linkArray["entity_name"] = $en_name;
$linkArray["entity_display"] = $en_display_text;
$linkArray["entity_link"] = $en_links;
$linkArrayData[]=$linkArray;
}
$dateArray=array();
if($en_date!=''){
$dateArray["entity_id"] = $entity_id;
$dateArray["entity_name"] = $en_name;
$dateArray["entity_date_text"] = $en_date_text;
$dateArray["entity_date"] = $date;
$dateArrayData[]=$dateArray;
}
}
/*********** question pattern ***********/
$total_marks = $dataExam['total_marks'];
$total_time = $dataExam['total_time'];
$exam_mode = $dataExam['exam_mode'];
$negative_marking = $dataExam['negative_marking'];
$getQuestionPattern="SELECT ep.subject_name, ep.no_of_question, ep.marks_for_subject FROM sp_exam_pattern as ep WHERE ep.exam_id='$exam_id'";
$sqlQuestionPattern=$db->prepare($getQuestionPattern);
$sqlQuestionPattern->execute();
$questionPatternData = array();
while($rowPat=$sqlQuestionPattern->fetch()){
$questionPattern=array("subject_name"=>$rowPat['subject_name'], "no_of_question"=>$rowPat['no_of_question'], "marks_for_subject"=>$rowPat['marks_for_subject']);
$questionPatternData[]=$questionPattern;
}
// $questionPatternArray = array("total_marks"=>$total_marks, "total_time"=>$total_time, "exam_mode"=>$exam_mode, "negative_marking"=>$negative_marking, "pattern"=>$questionPatternData);
$questionPatternArray = array();
$questionPatternArrayData[]=$questionPatternArray;
/*********** elegibility & fee structure ***********/
$qname=$dataExam['quali_name'];
$qdesc = $dataExam['qualification_desc'];
$ageto=$dataExam['age_to'];
$agefrom=$dataExam['age_from'];
if($ageto!='0' && $agefrom!='0'){
$age=$ageto.' - '.$agefrom .' Years';
} else if($ageto!='0' && $agefrom=='0'){
$age= 'Min '.$ageto.' Years';
} else if($ageto=='0' && $agefrom!='0'){
$age= 'Max '.$agefrom.' Years';
} else {
$age= '';
}
$ageDesc = $dataExam['age_desc'];
$fee = $dataExam['fee'];
if($fee!=''){
$feeD = 'Rs. '.$fee.'/-';
} else {
$feeD = '';
}
$feeDesc = $dataExam['fee_desc'];
$eligiArray=array("qname"=>$qname, "qdesc"=>$qdesc, "ageData"=>$age, "ageDesc"=>$ageDesc, "fee"=>$feeD, "feeDesc"=>$feeDesc);
$eligiArrayData[]=$eligiArray;
/*********** Post Wise Vacancy Detail ***********/
$getPostVacancy="SELECT type_name, gen, obc, sc, st, ebc, wbc, total_vac, age_limit, eligibility FROM sp_vacancy_detail WHERE exam_id='$exam_id'";
$sqlPostVacancy=$db->prepare($getPostVacancy);
$sqlPostVacancy->execute();
$vacancyArrayData = array();
while($rowVacancy=$sqlPostVacancy->fetch()){
$vacancyArray=array("type_name"=>$rowVacancy['type_name'], "gen"=>$rowVacancy['gen'], "obc"=>$rowVacancy['obc'], "sc"=>$rowVacancy['sc'], "st"=>$rowVacancy['st'], "ebc"=>$rowVacancy['ebc'], "wbc"=>$rowVacancy['wbc'], "total_vac"=>$rowVacancy['total_vac'], "age_limit"=>$rowVacancy['age_limit'], "eligibility"=>$rowVacancy['eligibility']);
$vacancyArrayData[]=$vacancyArray;
}
/*********** Physical eligibility Detail ***********/
$getPhyElig="SELECT gender, categories, height, chest, race, time, long_jump, high_jump, short_put, chances FROM sp_physical_eligibility WHERE exam_id='$exam_id' and status='1'";
$sqlPhyElig=$db->prepare($getPhyElig);
$sqlPhyElig->execute();
$physicalArrayData = array();
while($rowPhy=$sqlPhyElig->fetch()){
if($rowPhy['gender']=='M'){
$gender="Male";
} else if($rowPhy['gender']=='F'){
$gender="Female";
} else {
$gender="others";
}
$physicalArray=array("gender"=>$gender, "categories"=>$rowPhy['categories'], "height"=>$rowPhy['height'], "chest"=>$rowPhy['chest'], "race"=>$rowPhy['race'], "time"=>$rowPhy['time'], "long_jump"=>$rowPhy['long_jump'], "high_jump"=>$rowPhy['high_jump'], "short_put"=>$rowPhy['short_put'], "chances"=>$rowPhy['chances']);
$physicalArrayData[]=$physicalArray;
}
/*********** other tab ***********/
$otherTabArray = array("tab_name"=>$dataExam['other_info_tabname'], "tab_content"=>$dataExam['other_info']);
$otherTabArrayData[]=$otherTabArray;
/*********** upload files ***********/
$getOtherUpload="SELECT title, tabname, upload_file, showing_image FROM sp_exam_uploads WHERE exam_id='$exam_id'";
$sqlgetOtherUpload=$db->prepare($getOtherUpload);
$sqlgetOtherUpload->execute();
$otherUploadArrayData = array();
while($rowUpload=$sqlgetOtherUpload->fetch()){
$uploadPath = "https://naukriconnect.com/all_uploads/".$rowUpload['upload_file'];
$otherUploadArray=array("title"=>$rowUpload['title'], "tabname"=>$rowUpload['tabname'], "upload_file"=>$uploadPath, "showing_image"=>$rowUpload['showing_image']);
$otherUploadArrayData[]=$otherUploadArray;
}
/*********** exam cutoff ***********/
$getExamCutoff="SELECT type_name, year, ur, obc, sc, st, oh, vh, hh, ex_servicemen FROM sp_exam_cutoff WHERE exam_id='$exam_id' and status='1' order by display_order";
$sqlCutoff=$db->prepare($getExamCutoff);
$sqlCutoff->execute();
$cutOffArrayData = array();
while($rowCutoff=$sqlCutoff->fetch()){
$cutOffArray=array("type_name"=>$rowCutoff['type_name'], "year"=>$rowCutoff['year'], "ur"=>$rowCutoff['ur'], "obc"=>$rowCutoff['obc'], "sc"=>$rowCutoff['sc'], "st"=>$rowCutoff['st'], "oh"=>$rowCutoff['oh'], "vh"=>$rowCutoff['vh'], "hh"=>$rowCutoff['hh'], "ex_servicemen"=>$rowCutoff['ex_servicemen']);
$cutOffArrayData[]=$cutOffArray;
}
$mainArrayData[]=array("examDetails"=>$examDetailArrayData, "importantNotes"=>$impArrayData, "importantDates"=>$dateArrayData, "importantLinks"=>$linkArrayData, "question_pattern"=>$questionPatternArrayData, "eligibilityStructure"=>$eligiArrayData, "vacancyDetails"=>$vacancyArrayData, "physical_eligibility"=>$physicalArrayData, "otherTab"=>$otherTabArrayData, "otherUpload"=>$otherUploadArrayData, "cutOff"=>$cutOffArrayData);
echo json_encode($mainArrayData);
?>