HEX
Server: Apache/2.4.58 (Ubuntu)
System: Linux ip-172-31-18-78 6.17.0-1017-aws #17~24.04.1-Ubuntu SMP Tue May 26 21:09:53 UTC 2026 aarch64
User: ubuntu (1000)
PHP: 8.2.31
Disabled: NONE
Upload Files
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);