<?php
include "includes/config/config.php";
include "includes/functions.php";
$patientsList_array =array();
$patient_array = array();
$medicine_array = array();
$medicine_array_ext = array();
$page = $limit = $search="";

$page = $_REQUEST['_page'];
$limit = $_REQUEST['_limit'];
$search =  $_REQUEST['_search'];


      $sql_opd = "SELECT b.patient_name,b.emp_code,b.father_name,b.gender,b.employer_contractor_id,b.dept_id,b.dob,a.* FROM medical_examination a left join  patient_master b on b.id = a.patient_id  WHERE a.forward_status = 'A'";
      
if (!empty($limit)) {
    $sql_opd .= "ORDER BY a.medical_exam_id DESC LIMIT $page , $limit";
}
    
    if (!empty($search)) {
        $sql_opd .= "and ( b.patient_name like '%$search%' or b.emp_code like '%$search%')"; 
    }


error_log("OPD::" .$sql_opd);
$fetch_patients = mysqli_query($conn, $sql_opd) or die(mysqli_error($conn));
while ($row_patients = mysqli_fetch_assoc($fetch_patients)) {
    $age = isset($row_patients['dob']) ? date_diff(date_create($row_patients['dob']), date_create('today'))->y : "Not Available";
    $patient_array['medical_exam_id'] = (int)$row_patients['medical_exam_id'];
    if ($row_patients['IsEmergency'] == 1) {

                $patient_array['ans'] = "Yes";
            } else {

                $patient_array['ans'] = "No";
            }
    $patient_array['employer_contractor'] = getTableFieldValue('employer_contractor', 'employer_contractor_name', 'id', $row_patients['employer_contractor_id'], '');
    $patient_array['dept'] = getTableFieldValue('department', 'dept_name', 'dept_id', $row_patients['dept_id'], '');  
    $patient_array['dob'] = (string)$age;      
    $patient_array['patient_name'] = $row_patients['patient_name'];
    $patient_array['emp_code'] = $row_patients['emp_code'];
    $patient_array['father_name'] = $row_patients['father_name'];
    $patient_array['gender'] = $row_patients['gender'] == 'M' ? "Male" : "Female";
    $patient_array['ticket_no'] = $row_patients['peme_no'];
    $patient_array['height'] = $row_patients['height'];
    $patient_array['weight'] = $row_patients['weight'];
    $patient_array['bmi'] = $row_patients['bmi'];
    $patient_array['bp'] = $row_patients['bp'];
    $patient_array['pulse'] = $row_patients['pulse'];
    $patient_array['chest'] = $row_patients['chest'];
    $patient_array['chest_in'] = $row_patients['chest_in'];
    $patient_array['chest_exp'] = $row_patients['chest_exp'];
    $patient_array['skin'] = $row_patients['skin'];
    $patient_array['musculo_skeletal'] = $row_patients['musculo_skeletal'];
    $patient_array['temp'] = $row_patients['temp'];
    $patient_array['spo2'] = $row_patients['spo2'];
    $patient_array['cold_cough'] = $row_patients['cold_cough'];
    $patient_array['general_weakness'] = $row_patients['general_weakness'];
    $patient_array['smell'] = $row_patients['smell'];
    $patient_array['deformities'] = $row_patients['deformities'];
    $patient_array['hb'] = $row_patients['hb'];
    $patient_array['tlc'] = $row_patients['tlc'];
    $patient_array['dlc_n'] = $row_patients['dlc_n'];
    $patient_array['dlc_l'] = $row_patients['dlc_l'];
    $patient_array['dlc_m'] = $row_patients['dlc_m'];
    $patient_array['dlc_e'] = $row_patients['dlc_e'];
    $patient_array['dlc_b'] = $row_patients['dlc_b'];
    $patient_array['esr'] = $row_patients['esr'];
    $patient_array['blood_sugar_fbs'] = $row_patients['blood_sugar_fbs'];
    $patient_array['blood_sugar_rbs'] = $row_patients['blood_sugar_rbs'];
    $patient_array['blood_sugar_ppbs'] = $row_patients['blood_sugar_ppbs'];
    $patient_array['hiv'] = $row_patients['hiv'];
    $patient_array['hcv'] = $row_patients['hcv'];
    $patient_array['hbsag'] = $row_patients['hbsag'];
    $patient_array['uric_acid'] = $row_patients['uric_acid'];
    $patient_array['s_urea'] = $row_patients['s_urea'];
    $patient_array['s_creatinine'] = $row_patients['s_creatinine'];
    $patient_array['sodium'] = $row_patients['sodium'];
    $patient_array['potassium'] = $row_patients['potassium'];
    $patient_array['calcium'] = $row_patients['calcium'];
    $patient_array['phosphate'] = $row_patients['phosphate'];
    $patient_array['hco3'] = $row_patients['hco3'];
    $patient_array['total_bilirubin'] = $row_patients['total_bilirubin'];
    $patient_array['conj'] = $row_patients['conj'];
    $patient_array['uniconj'] = $row_patients['uniconj'];
    $patient_array['sgop'] = $row_patients['sgop'];
    $patient_array['sgpt'] = $row_patients['sgpt'];
    $patient_array['alk_phosphatase'] = $row_patients['alk_phosphatase'];
    $patient_array['total_protein'] = $row_patients['total_protein'];
    $patient_array['albumin'] = $row_patients['albumin'];
    $patient_array['globulin'] = $row_patients['globulin'];
    $patient_array['speech'] = $row_patients['speech'];
    $patient_array['higher_function'] = $row_patients['higher_function'];
    $patient_array['vertigo'] = $row_patients['vertigo'];
    $patient_array['reflexes'] = $row_patients['reflexes'];
    $patient_array['st_line_walking'] = $row_patients['st_line_walking'];
    $patient_array['vibration_syndrome'] = $row_patients['vibration_syndrome'];
    $patient_array['conversational_hearing'] = $row_patients['conversational_hearing'];
    $patient_array['eac'] = $row_patients['eac'];
    $patient_array['nose'] = $row_patients['nose'];
    $patient_array['throat'] = $row_patients['throat'];
    $patient_array['s1'] = $row_patients['s1'];
    $patient_array['any_other_sound'] = $row_patients['any_other_sound'];
    $patient_array['ecg_findings'] = $row_patients['ecg_findings'];
    $patient_array['teeth_n_gum'] = $row_patients['teeth_n_gum'];
    $patient_array['spiro_remarks'] = $row_patients['spiro_remarks'];
    $patient_array['liver'] = $row_patients['liver'];
    $patient_array['speen'] = $row_patients['speen'];
    $patient_array['tenderness'] = $row_patients['tenderness'];
    $patient_array['any_other_abnormality'] = $row_patients['any_other_abnormality'];
    $patient_array['xray_findings'] = $row_patients['xray_findings'];
    $patient_array['near_with_right_eye'] = $row_patients['near_with_right_eye'];
    $patient_array['near_without_right_eye'] = $row_patients['near_without_right_eye'];
    $patient_array['dis_with_right_eye'] = $row_patients['dis_with_right_eye'];
    $patient_array['dis_without_right_eye'] = $row_patients['dis_without_right_eye'];
    $patient_array['dis_without_left_eye'] = $row_patients['dis_without_left_eye'];
    $patient_array['dis_with_left_eye'] = $row_patients['dis_with_left_eye'];
    $patient_array['near_without_left_eye'] = $row_patients['near_without_left_eye'];
    $patient_array['near_with_left_eye'] = $row_patients['near_with_left_eye'];
    $patient_array['color_vision'] = $row_patients['color_vision'];
    $patient_array['hernia_details'] = $row_patients['hernia_details'];
    $patient_array['hydrocele_details'] = $row_patients['hydrocele_details'];
    $patient_array['phimosis'] = $row_patients['phimosis'];
    $patient_array['piles'] = $row_patients['piles'];
    $patient_array['fistula'] = $row_patients['fistula'];
    $patient_array['total_cholestrol'] = $row_patients['total_cholestrol'];
    $patient_array['ldl'] = $row_patients['ldl'];
    $patient_array['hdl'] = $row_patients['hdl'];
    $patient_array['vldl'] = $row_patients['vldl'];
    $patient_array['ln_v'] = $row_patients['ln_v'];
    $patient_array['ln_axis'] = $row_patients['ln_axis'];
    $patient_array['ln_dcyl'] = $row_patients['ln_dcyl'];
    $patient_array['ln_dsph'] = $row_patients['ln_dsph'];
    $patient_array['rn_v'] = $row_patients['rn_v'];
    $patient_array['rn_axis'] = $row_patients['rn_axis'];
    $patient_array['rn_dcyl'] = $row_patients['rn_dcyl'];
    $patient_array['rn_dsph'] = $row_patients['rn_dsph'];
    $patient_array['ld_v'] = $row_patients['ld_v'];
    $patient_array['ld_axis'] = $row_patients['ld_axis'];
    $patient_array['ld_dcyl'] = $row_patients['ld_dcyl'];
    $patient_array['ld_dsph'] = $row_patients['ld_dsph'];
    $patient_array['rd_v'] = $row_patients['rd_v'];
    $patient_array['rd_axis'] = $row_patients['rd_axis'];
    $patient_array['rd_dcyl'] = $row_patients['rd_dcyl'];
    $patient_array['rd_dsph'] = $row_patients['rd_dsph'];
    $patient_array['lair_250'] = $row_patients['lair_250'];
    $patient_array['lair_500'] = $row_patients['lair_500'];
    $patient_array['lair_1000'] = $row_patients['lair_1000'];
    $patient_array['lair_2000'] = $row_patients['lair_2000'];
    $patient_array['lair_4000'] = $row_patients['lair_4000'];
    $patient_array['lair_8000'] = $row_patients['lair_8000'];
    $patient_array['lbone_250'] = $row_patients['lbone_250'];
    $patient_array['lbone_500'] = $row_patients['lbone_500'];
    $patient_array['lbone_1000'] = $row_patients['lbone_1000'];
    $patient_array['lbone_2000'] = $row_patients['lbone_2000'];
    $patient_array['lbone_4000'] = $row_patients['lbone_4000'];
    $patient_array['lbone_8000'] = $row_patients['lbone_8000'];
    $patient_array['rair_250'] = $row_patients['rair_250'];
    $patient_array['rair_500'] = $row_patients['rair_500'];
    $patient_array['rair_1000'] = $row_patients['rair_1000'];
    $patient_array['rair_2000'] = $row_patients['rair_2000'];
    $patient_array['rair_4000'] = $row_patients['rair_4000'];
    $patient_array['rair_8000'] = $row_patients['rair_8000'];
    $patient_array['rbone_250'] = $row_patients['rbone_250'];
    $patient_array['rbone_500'] = $row_patients['rbone_500'];
    $patient_array['rbone_1000'] = $row_patients['rbone_1000'];
    $patient_array['rbone_2000'] = $row_patients['rbone_2000'];
    $patient_array['rbone_4000'] = $row_patients['rbone_4000'];
    $patient_array['rbone_8000'] = $row_patients['rbone_8000'];
    $patient_array['bn_findings'] = $row_patients['bn_findings'];
    $patient_array['a'] = $row_patients['a'];
    $patient_array['cy'] = $row_patients['cy'];
    $patient_array['i'] = $row_patients['i'];
    $patient_array['cl'] = $row_patients['cl'];
    $patient_array['e'] = $row_patients['e'];
    $patient_array['motor_function'] = $row_patients['motor_function'];
    $patient_array['other_findings'] = $row_patients['other_findings'];
    $patient_array['triglycerides'] = $row_patients['triglycerides'];

    array_push($patientsList_array,$patient_array);
}


$jsonData = json_encode($patientsList_array, JSON_PRETTY_PRINT);


echo $jsonData; 

?>