100 lines
5.5 KiB
PHP
100 lines
5.5 KiB
PHP
<?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);
|