<?php error_reporting(E_ERROR | E_PARSE);
include('includes/config/config.php');
include('includes/functions.php');
$sql_patient_physical_parameters = "select a.*,b.* from checkup_form a left join patient_master b on b.id=a.emp_id where a.checkup_id='" . $_REQUEST['checkup_id'] . "'";
//echo $sql_patient_physical_parameters;
error_log("PARAMS:" . $sql_patient_physical_parameters);

if (!$result_patient_physical_parameters = @mysqli_query($conn, $sql_patient_physical_parameters)) {
	exit(mysqli_error($conn));
}

//echo mysqli_num_rows($result_stock_issue_item);
$data = array();
if (mysqli_num_rows($result_patient_physical_parameters) > 0) {
	while ($row_patient_physical_parameters = mysqli_fetch_assoc($result_patient_physical_parameters)) {


		$sql_sign = "select * from employee_signature where emp_id='" . $row_patient_physical_parameters['doc_attend'] . "'";
		$result_sign = mysqli_query($conn, $sql_sign);
		$row_sign = mysqli_fetch_assoc($result_sign);

		error_log("sign query " . $sql_sign);
		//extract($row);
		$data['dob'] = date("Y", strtotime($row_patient_physical_parameters['dob']));
		$data['birth'] = date("d-m-Y",strtotime($row_patient_physical_parameters['dob']));

		$data['doj'] = date_format(date_create($row_patient_physical_parameters['doj']), "d-M-Y ");
		$data['age'] = ageCalculator($row_patient_physical_parameters['dob']);
		$data['gender'] = ($row_patient_physical_parameters['gender'] == 'F' ? "Female" : "Male");
		$data['village'] = $row_patient_physical_parameters['village'];
		$data['post'] = $row_patient_physical_parameters['post'];
		$data['ps'] = $row_patient_physical_parameters['ps'];
		$data['pin_code'] = $row_patient_physical_parameters['pin_code'];
		$data['tehsil'] = $row_patient_physical_parameters['tehsil'];
		$data['district'] = $row_patient_physical_parameters['district'];
		$data['father_name'] = $row_patient_physical_parameters['father_name'];
		$data['patient_name'] = $row_patient_physical_parameters['patient_name'];
		$data['emp_id'] = $row_patient_physical_parameters['id'];
		$data['state'] = $row_patient_physical_parameters['state'];
		$data['dept_name'] = getTableFieldValue('department', 'dept_name', 'dept_id', $row_patient_physical_parameters['dept_id']);
		$data['designation'] = getTableFieldValue('designation', 'designation_name', 'designation_id', $row_patient_physical_parameters['designation_id']);

		$data['father_name'] = $row_patient_physical_parameters['father_name'];
		// $data['document_no'] = $row_patient_physical_parameters['document_no'];
		$data['serial_no'] = $row_patient_physical_parameters['emp_code'];
		$data['peme_no'] = $row_patient_physical_parameters['ticket_no'];
		$data['approval_date'] = date_format(date_create($row_patient_physical_parameters['approve_date']), "d-M-Y ");
		$data['emp_sign'] = base64_encode($row_sign['emp_sign']);
		$data['image_type'] = $row_sign['image_type'];
		$doc_emp_id = $row_patient_physical_parameters['doc_attend'];
		$data['doctor_name'] = getTableFieldValue('patient_master', 'patient_name', 'id', $doc_emp_id);
		$data['designation'] = getTableFieldValue('designation', 'designation_name', 'designation_id', $row_patient_physical_parameters['designation_id']);
		$data['department'] = getTableFieldValue('department', 'dept_name', 'dept_id', $row_patient_physical_parameters['dept_id']);
		$data['qualification'] = $row_sign['qualification'];
		$data['registration_no'] = $row_sign['registration_no'];
		// $data['task'] = $row_patient_physical_parameters['task'];
		$data['department_works'] = $row_patient_physical_parameters['department_works'];
		// $data['byproducts_exposedto'] = $row_patient_physical_parameters['byproducts_exposedto'];

		$data['physical_status'] = $row_patient_physical_parameters['fit_unfit_status'];
		//$data['task'] = $row_patient_physical_parameters['task'];

		$data['leaving_date'] = $row_patient_physical_parameters['leaving_date'];
		$data['reason_leaving'] = $row_patient_physical_parameters['reason_leaving'];
		$data['identi_mark'] = $row_patient_physical_parameters['identity'];
		error_log("identi mark " . $data['identi_mark']);
		$data['hazardous_process'] = getTableFieldValue('department', 'hazardous_process', 'dept_id', $row_patient_physical_parameters['dept_id']);
		$data['dangerous_operation'] = getTableFieldValue('department', 'dangerous_process', 'dept_id', $row_patient_physical_parameters['dept_id']);

		$data['fit_status'] = $row_patient_physical_parameters['fit_unfit_status'];
		$data['doc_finding'] = $row_patient_physical_parameters['doc_findings'];

		$data['checkup_test_names'] = getCommaSeperatedValuesForInClause("select section_name from checkup_form_section", 'section_id', $row_patient_physical_parameters['checkup_section_ids']);

		$approval_date = $row_patient_physical_parameters['approve_date'];

		// $valid_date  = date("Y-m-d", strtotime(date("Y-m-d", strtotime($approval_date)) . " + 1 year"));
		$data['valid_date'] = date_format(date_create($row_patient_physical_parameters['valid_upto']), "d-M-Y ");

		$sql_factory = "select * from ohc_type where ohc_type_id='" . $_SESSION['current_ohcttype'] . "'";
		// echo $sql_factory;

		if (!$result_factory = @mysqli_query($conn, $sql_factory)) {
			exit(mysqli_error($conn));
		}

		if (mysqli_num_rows($result_factory) > 0) {
			while ($row_factory = mysqli_fetch_assoc($result_factory)) {
				$data['factoryAddress'] = $row_factory['address'];
				$data['company_name'] = $row_factory['ohc_type_name'];
			}
		}
	}
} else {
	$data['status'] = 200;
	$data['message'] = "Data not found!";
}

echo  json_encode($data);