File: /var/www/nclive/backend/sp_exam_api/sp_get_exam_dates_links.php
<?php
include "../config.php";
header("Access-Control-Allow-Origin: *");
header('Content-Type: application/json');
$exam_id = $_REQUEST['exam_id'] ?? null;
$jsonFile = __DIR__ . "/exam_data.json";
$jsonData = json_decode(file_get_contents($jsonFile), true);
if ($jsonData === null) {
echo json_encode(["error" => "Invalid JSON data"]);
exit;
}
$dateArrayData = array();
$linkArrayData = array();
$officialArrayData = array();
if (isset($jsonData[$exam_id])) {
foreach ($jsonData[$exam_id] as $row) {
$entity_id = $row['entity_id'];
$en_name = $row['name'];
$en_display_text = $row['display_text'];
$en_date_text = $row['display_text_dates'];
$en_links = $row['links'];
$en_date_type = $row['date_type'];
$en_date = $row['date'];
$en_off_web = $row['off_web_link'];
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_link"] = $en_links;
$linkArray["entity_display"] = $en_display_text;
$linkArrayData[] = $linkArray;
}
$dateArray = array();
if ($en_date != '') {
$dateArray["entity_id"] = $entity_id;
$dateArray["entity_name"] = $en_name;
$dateArray["entity_text"] = $en_display_text;
$linkArray["entity_display"] = $en_display_text;
$dateArray["entity_date_text"] = $en_date_text;
$dateArray["entity_date"] = $date;
$dateArrayData[] = $dateArray;
}
if (in_array($en_off_web, $officialArrayData)) {
continue; // skip repeated entity_id
}
$officialArrayData[] = $en_off_web;
}
}
$mainarray[] = array("dateArray" => $dateArrayData, "linkArray" => $linkArrayData, "officialArray" => $officialArrayData);
echo json_encode($mainarray);