<?php
	header("Access-Control-Allow-Origin: *");
	header('Content-Type: application/json');	

	include 'config.php';

	$requestData = $_REQUEST;
	$columns = array(
		0 => 'id',
		1 => 'exam_id',
		2 => 'exam_name',
		3 => 'name',
		4 => 'display_text_dates',
	    5 => 'description',
	    6 => 'links',
	    7 => 'update_date',
		8 => 'date',
		9 => 'status',
		10 => 'action',
		11 => 'display_entity'
	);

	$getDataQuery  = "SELECT el.id,el.exam_id,el.display_text,el.display_text_dates, el.description, el.links, el.date_type,el.date, el.status,el.update_date, e.exam_name,ee.name,el.entity_id,el.display_entity FROM sp_exam_links as el left join sp_exam as e on e.exam_id=el.exam_id left join sp_exam_entity as ee on ee.id=el.entity_id WHERE el.exam_id !=''  ";
	$getData=$db->prepare($getDataQuery);
	$getData->execute();
	$totalData = $getData->rowCount();
	$totalFiltered = $totalData;

	$searchTerms = "";
	if (!empty($requestData['search']['value'])) {
		$searchTerms .= " AND ( el.exam_id LIKE '" . $requestData['search']['value'] . "%' ";
		$searchTerms .= " OR el.display_text LIKE '%" . $requestData['search']['value'] . "%' ";
		$searchTerms .= " OR el.description LIKE '%" . $requestData['search']['value'] . "%' ";
		$searchTerms .= " OR el.links LIKE '%" . $requestData['search']['value'] . "%' ";
		$searchTerms .= " OR e.exam_name LIKE '%" . $requestData['search']['value'] . "%' ) ";
	}

	$getDataQuery  = "SELECT el.id,el.exam_id,el.display_text,el.display_text_dates, el.description, el.links, el.date_type,el.date, el.status,el.update_date, e.exam_name,ee.name,el.entity_id,el.display_entity FROM sp_exam_links as el left join sp_exam as e on e.exam_id=el.exam_id left join sp_exam_entity as ee on ee.id=el.entity_id WHERE el.exam_id !=''  $searchTerms";

	$getData=$db->prepare($getDataQuery);
	$getData->execute();
	$totalFiltered = $getData->rowCount();

	$getDataQuery .= " ORDER BY " . $columns[$requestData['order'][0]['column']] . " " . $requestData['order'][0]['dir'] . "  LIMIT " . $requestData['start'] . ", " . $requestData['length'] . "   ";

	$getData=$db->prepare($getDataQuery);
	$getData->execute();

	$data = array();
	while ($querydata = $getData->fetch()) {

		$nestedData = array();
		$nestedData["id"] = $querydata['id'];
		$nestedData["exam_id"] = $querydata['exam_id'];
		$nestedData["exam_name"] = $querydata['exam_name'];
		$nestedData["name"] = $querydata['name'];
		$nestedData["display_text_dates"] = $querydata['display_text_dates'];
		$nestedData["description"] = $querydata['description'];
	    $nestedData["links"] = $querydata['links'];
	    $nestedData["update_date"] = $querydata['update_date'];
	    $nestedData["date"] = $querydata['date'];
	    $nestedData["status"] = $querydata['status'];
	    $nestedData["display_text"] = $querydata['display_text'];
	    $nestedData["display_entity"] = $querydata['display_entity'];
		$data[] = $nestedData;
	}

	$json_data = array(
		"draw"            => intval($requestData['draw']),
		"recordsTotal"    => intval($totalData),
		"recordsFiltered" => intval($totalFiltered),
		"data"            => $data
	);
	echo json_encode($json_data);
?>