1087 lines
48 KiB
PHP
1087 lines
48 KiB
PHP
<?php
|
|
include ('includes/config/config.php');
|
|
include ('includes/functions.php');
|
|
include ('log_entry.php');
|
|
// $conn = mysqli_connect("localhost","root","","phpsamples");
|
|
require_once ('excel/vendor/php-excel-reader/excel_reader2.php');
|
|
require_once ('excel/vendor/SpreadsheetReader.php');
|
|
header ( 'Content-type: application/json' );
|
|
error_reporting ( E_ALL & ~ E_NOTICE & ~ E_DEPRECATED & ~ E_WARNING );
|
|
|
|
$response_array = array ();
|
|
$response_mssages = "";
|
|
$ohc_type = $_SESSION ['current_ohcttype'];
|
|
begin ();
|
|
$allowedFileType = [
|
|
'application/vnd.ms-excel',
|
|
'text/xls',
|
|
'text/xlsx',
|
|
'application/vnd.openxmlformats-officedocument.spreadsheetml.sheet'
|
|
];
|
|
$dbColumnNameList = array ();
|
|
|
|
if (in_array ( $_FILES ["file"] ["type"], $allowedFileType )) {
|
|
|
|
$targetPath = 'excel/uploads/' . $_FILES ['file'] ['name'];
|
|
move_uploaded_file ( $_FILES ['file'] ['tmp_name'], $targetPath );
|
|
|
|
$Reader = new SpreadsheetReader ( $targetPath );
|
|
|
|
$sheetCount = count ( $Reader->sheets () );
|
|
$insert_counter = 0;
|
|
$update_counter = 0;
|
|
$fail_counter = 0;
|
|
$new_emp_counter = 0;
|
|
|
|
for($i = 0; $i < 1; $i ++) {
|
|
|
|
$Reader->ChangeSheet ( $i );
|
|
$j = 0;
|
|
$max_cols = 0;
|
|
$crntColIndex = 0;
|
|
foreach ( $Reader as $Row ) {
|
|
$crntColIndex = 0;
|
|
// read row first to read table fields
|
|
if ($j == 0) {
|
|
$crntColIndex = 0;
|
|
$nondb_col = 0;
|
|
|
|
while ( isset ( $Row [$crntColIndex] ) && mysqli_real_escape_string($conn,$Row [$crntColIndex] ) != null && trim ( $Row [$crntColIndex] ) != '' ) {
|
|
$colVal = mysqli_real_escape_string($conn,$Row [$crntColIndex] );
|
|
//
|
|
if ($colVal != 'NA') {
|
|
$dbColumnNameList [$crntColIndex] = $Row [$crntColIndex];
|
|
} else {
|
|
// if NA for DB col found... then just record it with NA_Prefix to distinguish and discard later
|
|
$dbColumnNameList [$crntColIndex] = "NA_" + $nondb_col;
|
|
$nondb_col ++;
|
|
}
|
|
$crntColIndex ++;
|
|
} // end of while -- reading all columns for first row
|
|
|
|
$j ++;
|
|
$max_cols = $crntColIndex;
|
|
error_log ( "db_fields_Array:" . $dbColumnNameList );
|
|
// print_r($dbColumnNameList);
|
|
continue;
|
|
} // end reading first row db fields
|
|
|
|
if ($j < 3) {
|
|
// ignore for other header rows
|
|
$j ++;
|
|
continue;
|
|
}
|
|
if ($Row [0] == '') {
|
|
// if a blank row is encountered stop reading
|
|
break;
|
|
}
|
|
// read data rows - start
|
|
$emp_code = "";
|
|
$task = "";
|
|
$patient_name = "";
|
|
$designation = "";
|
|
$department = "";
|
|
$medical_date = "";
|
|
$dbColumnValueList = array ();
|
|
$histParam = array ();
|
|
$aadhar_no = "";
|
|
$asthama = "";
|
|
$diabetes = "";
|
|
$tb = "";
|
|
$epilepsy = "";
|
|
$hbd = "";
|
|
$psychiatric = "";
|
|
$heart_deases = "";
|
|
$typhoid = "";
|
|
$major_injury = "";
|
|
$smoking = "";
|
|
$tobacco = "";
|
|
$alcohol = "";
|
|
$hiv = "";
|
|
$fvc = "";
|
|
$waist = "";
|
|
$height = "";
|
|
$weight = "";
|
|
$hip = "";
|
|
$nails = "";
|
|
$bmi = "";
|
|
$pulse = "";
|
|
$bp = "";
|
|
$s1 = "";
|
|
$s2 = "";
|
|
$any_other_sound = "";
|
|
$ecg_findings = "";
|
|
$tmt_findings = "";
|
|
$near_with_right_eye = "";
|
|
$near_without_right_eye = "";
|
|
$dis_with_right_eye = "";
|
|
$dis_without_right_eye = "";
|
|
$dis_without_left_eye = "";
|
|
$dis_with_left_eye = "";
|
|
$near_without_left_eye = "";
|
|
$near_with_left_eye = "";
|
|
$skin = "";
|
|
$color_vision = "";
|
|
$ident_of_individual_colors="";
|
|
$rs = "";
|
|
$musculo_skeletal = "";
|
|
$cns = "";
|
|
$ent = "";
|
|
$chest_radiograph = "";
|
|
$urine_re_me = "";
|
|
$stool_re_me = "";
|
|
$fvc_pre = "";
|
|
$fvc_post = "";
|
|
$fev1_pre = "";
|
|
$fev1_post = "";
|
|
$fev1_fvc_post = "";
|
|
$fev1_fvc_pre = "";
|
|
$peak_expiratory_flow_pre = "";
|
|
$peak_expiratory_flow_post = "";
|
|
$air_cond_left = "";
|
|
$air_cond_right = "";
|
|
$bone_cond_left = "";
|
|
$bone_cond_right = "";
|
|
$hb = "";
|
|
$tlc = "";
|
|
$dlc_n = "";
|
|
$dlc_l = "";
|
|
$dlc_m = "";
|
|
$dlc_e = "";
|
|
$platelets = "";
|
|
$s_urea = "";
|
|
$s_creatinine = "";
|
|
$blood_sugar = "";
|
|
$esr = "";
|
|
$bun = "";
|
|
$uric_acid = "";
|
|
$acid_phosphatase = "";
|
|
$psa = "";
|
|
$lipid_profile = "";
|
|
$profusion_opacitites = "";
|
|
$live_function_test = "";
|
|
$thyroid_profile = "";
|
|
$dental_exam_report = "";
|
|
$mammography = "";
|
|
$conversational_hearing = "";
|
|
$pap_smear = "";
|
|
$any_other = "";
|
|
$auroscopy = "";
|
|
$throat = "";
|
|
$nose = "";
|
|
$eac = "";
|
|
$liver = "";
|
|
$speen = "";
|
|
$tenderness = "";
|
|
$any_other_abnormality = "";
|
|
$appearance = "";
|
|
$pus_cells = "";
|
|
$rbcs = "";
|
|
$epithelial_cells = "";
|
|
$other_relevant_findings = "";
|
|
$albumin = "";
|
|
$sugar = "";
|
|
$blood_group = "";
|
|
$pallor = "";
|
|
$cvs = "";
|
|
$ident_of_individual_colors = "";
|
|
$physical_status = "";
|
|
$abdomen = "";
|
|
$opinion_remarks_medical_assistant = "";
|
|
$opinion_remarks = "";
|
|
$vdrl = "";
|
|
$speech = "";
|
|
$higher_function = "";
|
|
$motor_function = "";
|
|
$vertigo = "";
|
|
$reflexes = "";
|
|
$vibration_syndrome = "";
|
|
$ppo = "";
|
|
$grade = "";
|
|
$type = "";
|
|
$hydrocele = "";
|
|
$phimosis = "";
|
|
$piles = "";
|
|
$fistula = "";
|
|
$hiv = "";
|
|
$fvc = "";
|
|
$addiction = "";
|
|
$father_name = "";
|
|
$identi_mark = "";
|
|
$marital_status = "";
|
|
$no_of_child = "";
|
|
$adopting_family_planning = "";
|
|
$typhoid_findings = "";
|
|
$urine_findings="";
|
|
$lft_findings="";
|
|
$xray_findings="";
|
|
$sputum_findings="";
|
|
$health_index="";
|
|
$p="";
|
|
$cy="";
|
|
$cl="";
|
|
$e="";
|
|
$a="";
|
|
$oe="";
|
|
$pr="";
|
|
$p_abd="";
|
|
$ln_v="";
|
|
$ln_axis="";
|
|
$ln_dcyl="";
|
|
$ln_dsph="";
|
|
$rn_v="";
|
|
$rn_axis="";
|
|
$rn_dcyl="";
|
|
$rn_dsph="";
|
|
$ld_v="";
|
|
$ld_axis="";
|
|
$ld_dcyl="";
|
|
$ld_dsph="";
|
|
$rd_v="";
|
|
$rd_axis="";
|
|
$rd_dcyl="";
|
|
$rd_dsph="";
|
|
$blood_sugar_ppbs="";
|
|
$blood_sugar_fbs="";
|
|
$blood_sugar_rbs="";
|
|
$blood_sugar_hb1ac="";
|
|
$deformities="";
|
|
|
|
|
|
|
|
// print_r($histParam);
|
|
$arrayHistoryParam = array ();
|
|
$history_list="";
|
|
$sql_hist_param = "select param_id, param_name from history_parameter ";
|
|
|
|
$result_hist_param = mysqli_query($conn,$sql_hist_param );
|
|
while ( $row_hist_param = mysqli_fetch_assoc ( $result_hist_param ) ) {
|
|
$arrayHistoryParam[$row_hist_param['param_name']]=$row_hist_param['param_id'];
|
|
}
|
|
|
|
error_log ( "max value" . $max_cols );
|
|
$crntColIndex = 0;
|
|
while ( $crntColIndex < $max_cols ) {
|
|
|
|
$colVal = trim ( mysqli_real_escape_string($conn,$Row [$crntColIndex] ) );
|
|
|
|
$dbColumnValueList [$crntColIndex] = $colVal; // store the column value into valuearray
|
|
|
|
// custom logic, validations and calculations -- start
|
|
|
|
if ($dbColumnNameList [$crntColIndex] == 'emp_code') {
|
|
$emp_code = $colVal;
|
|
} else if ($dbColumnNameList [$crntColIndex] == 'task') {
|
|
$task = $colVal;
|
|
if ($task == 'Annual Examination') {
|
|
$task = 'ame_greater_40';
|
|
} else if ($task == 'Periodic Examination') {
|
|
$task = 'ame_less_40';
|
|
} else if ($task == 'IME Long') {
|
|
$task = 'ime_long';
|
|
} else if ($task == 'PME') {
|
|
$task = 'pme';
|
|
} else if ($task == 'IME Short') {
|
|
$task = 'ime_short';
|
|
} else {
|
|
$task = 'ime_long';
|
|
}
|
|
|
|
if ($task == "" && $task == NULL) {
|
|
$response_mssages .= "<br>Medical Examination Type Missing at row: " . + $j;
|
|
$fail_counter ++;
|
|
continue;
|
|
}
|
|
} else if ($dbColumnNameList [$crntColIndex] == 'patient_id') {
|
|
$patient_name = $colVal;
|
|
if ($patient_name == "" && $patient_name == NULL) {
|
|
$response_mssages .= "<br>Patient Name Missing at row: " . + $j;
|
|
$fail_counter ++;
|
|
continue;
|
|
} else if ($dbColumnNameList [$crntColIndex] == 'father_name') {
|
|
$father_name = $colVal;
|
|
$dbColumnValueList [$crntColIndex] = $father_name;
|
|
}
|
|
} else if ($dbColumnNameList [$crntColIndex] == 'designation') {
|
|
$designation = $colVal;
|
|
if ($designation == "" && $designation == NULL) {
|
|
$response_mssages .= "<br>Designation Name Missing at row: " . + $j;
|
|
$fail_counter ++;
|
|
continue;
|
|
}
|
|
} else if ($dbColumnNameList [$crntColIndex] == 'department') {
|
|
$department = $colVal;
|
|
if ($department == NULL) {
|
|
$response_mssages .= "<br>Department Name Missing at row: " . + $j;
|
|
$fail_counter ++;
|
|
continue;
|
|
}
|
|
} else if ($dbColumnNameList [$crntColIndex] == 'medical_entry_date') {
|
|
$medical_date = $colVal;
|
|
} else if ($dbColumnNameList [$crntColIndex] == 'aadhar_no') {
|
|
$aadhar_no = $colVal;
|
|
if ($aadhar_no == "" && $aadhar_no == NULL && minlength == "12" && maxlength == "12") {
|
|
$response_mssages .= "<br>Aadhar No Missing at row: " . + $j;
|
|
$fail_counter ++;
|
|
continue;
|
|
}
|
|
}
|
|
|
|
else if ($dbColumnNameList [$crntColIndex] == 'asthama') {
|
|
$asthama = $colVal;
|
|
if (strtolower ( $asthama ) == 'yes') {
|
|
array_push ( $histParam, "asthama" );
|
|
$asthama = 1;
|
|
$history_list.=$arrayHistoryParam['ASTHMA'].",";
|
|
}
|
|
|
|
else
|
|
$asthama = 0;
|
|
$dbColumnValueList [$crntColIndex] = $asthama;
|
|
} else if ($dbColumnNameList [$crntColIndex] == 'diabetes') {
|
|
$diabetes = $colVal;
|
|
if (strtolower ( $diabetes ) == 'yes'){
|
|
$diabetes = 1;
|
|
$history_list.=$arrayHistoryParam['DIABETES'].",";
|
|
}
|
|
else
|
|
$diabetes = 0;
|
|
$dbColumnValueList [$crntColIndex] = $diabetes;
|
|
} else if ($dbColumnNameList [$crntColIndex] == 'tb') {
|
|
$tb = $colVal;
|
|
if (strtolower ( $tb ) == 'yes'){
|
|
$tb = 1;
|
|
$history_list.=$arrayHistoryParam['T.B'].",";
|
|
}
|
|
else
|
|
$tb = 0;
|
|
$dbColumnValueList [$crntColIndex] = $tb;
|
|
} else if ($dbColumnNameList [$crntColIndex] == 'hbd') {
|
|
$hbd = $colVal;
|
|
if (strtolower ( $hbd ) == 'yes'){
|
|
$hbd = 1;
|
|
$history_list.=$arrayHistoryParam['HIGH BLOOD PRESSURE'].",";
|
|
}
|
|
else
|
|
$hbd = 0;
|
|
$dbColumnValueList [$crntColIndex] = $hbd;
|
|
} else if ($dbColumnNameList [$crntColIndex] == 'epilepsy') {
|
|
$epilepsy = $colVal;
|
|
if (strtolower ( $epilepsy ) == 'yes'){
|
|
$epilepsy = 1;
|
|
$history_list.=$arrayHistoryParam['EPILEPSY'].",";
|
|
}
|
|
else
|
|
$epilepsy = 0;
|
|
$dbColumnValueList [$crntColIndex] = $epilepsy;
|
|
} else if ($dbColumnNameList [$crntColIndex] == 'psychiatric') {
|
|
$psychiatric = $colVal;
|
|
if (strtolower ( $psychiatric ) == 'yes'){
|
|
|
|
$psychiatric = 1;
|
|
$history_list.=$arrayHistoryParam['PSYCHIATRIC ILLNESS'].",";
|
|
}
|
|
else
|
|
$psychiatric = 0;
|
|
$dbColumnValueList [$crntColIndex] = $psychiatric;
|
|
} else if ($dbColumnNameList [$crntColIndex] == 'heart_dis') {
|
|
$heart_deases = $colVal;
|
|
if (strtolower ( $heart_deases ) == 'yes'){
|
|
$heart_deases = 1;
|
|
$history_list.=$arrayHistoryParam['HEART DISEASE'].",";
|
|
}
|
|
else
|
|
$heart_deases = 0;
|
|
$dbColumnValueList [$crntColIndex] = $heart_deases;
|
|
} else if ($dbColumnNameList [$crntColIndex] == 'piles') {
|
|
$piels = $colVal;
|
|
if (strtolower ( $piels ) == 'yes'){
|
|
$piels = 1;
|
|
$history_list.=$arrayHistoryParam['PILES/ FISTULA'].",";
|
|
}
|
|
else
|
|
$piels = 0;
|
|
$dbColumnValueList [$crntColIndex] = $piels;
|
|
} else if ($dbColumnNameList [$crntColIndex] == 'typhoid ') {
|
|
$typhoid = $colVal;
|
|
if (strtolower ( $typhoid ) == 'yes'){
|
|
$typhoid = 1;
|
|
$history_list.=$arrayHistoryParam['TYPHOID'].",";
|
|
}
|
|
else
|
|
$typhoid = 0;
|
|
$dbColumnValueList [$crntColIndex] = $typhoid;
|
|
} else if ($dbColumnNameList [$crntColIndex] == 'major_injury') {
|
|
$major_injury = $colVal;
|
|
if (strtolower ( $major_injury ) == 'yes'){
|
|
$major_injury = 1;
|
|
$history_list.=$arrayHistoryParam['MAJOR INJURY/FRACTURE/ OPERATION'].",";
|
|
}
|
|
else
|
|
$major_injury = 0;
|
|
$dbColumnValueList [$crntColIndex] = $major_injury;
|
|
} else if ($dbColumnNameList [$crntColIndex] == 'smoking') {
|
|
$smoking = $colVal;
|
|
if (strtolower ( $smoking ) == 'yes') {
|
|
$smoking = 1;
|
|
$addiction = $addiction . "SMOKING";
|
|
$history_list.=$arrayHistoryParam['SMOKING'].",";
|
|
}
|
|
|
|
else
|
|
$smoking = 0;
|
|
$dbColumnValueList [$crntColIndex] = $smoking;
|
|
} else if ($dbColumnNameList [$crntColIndex] == 'tobacco') {
|
|
$tobacco = $colVal;
|
|
if (strtolower ( $tobacco ) == 'yes') {
|
|
$tobacco = 1;
|
|
if ($addiction != "") {
|
|
$addiction = $addiction . ",TOBACCO";
|
|
} else {
|
|
$addiction = $addiction . "TOBACCO";
|
|
}
|
|
$history_list.=$arrayHistoryParam['TOBACCO'].",";
|
|
} else
|
|
$tobacco = 0;
|
|
$dbColumnValueList [$crntColIndex] = $tobacco;
|
|
} else if ($dbColumnNameList [$crntColIndex] == 'alcohol') {
|
|
$alcohol = $colVal;
|
|
if (strtolower ( $alcohol ) == 'yes') {
|
|
$alcohol = 1;
|
|
if ($addiction != "") {
|
|
$addiction = $addiction . ",ALCOHOL";
|
|
} else {
|
|
$addiction = $addiction . "ALCOHOL";
|
|
}
|
|
$history_list.=$arrayHistoryParam['ALCOHOL'].",";
|
|
} else
|
|
$alcohol = 0;
|
|
$dbColumnValueList [$crntColIndex] = $alcohol;
|
|
} else if ($dbColumnNameList [$crntColIndex] == 'dob') {
|
|
$dob = $colVal;
|
|
$dbColumnValueList [$crntColIndex] = $dob;
|
|
} else if ($dbColumnNameList [$crntColIndex] == 'age') {
|
|
$age = $colVal;
|
|
error_log ( "dob:" . $dob );
|
|
error_log ( "age:" . $age );
|
|
if ($dob == '') {
|
|
$dob = getCalculatedDOBFromAge ( $age );
|
|
// $dob=$dob->format('d-m-Y');
|
|
error_log ( "calculated dob:" . $dob );
|
|
}
|
|
$dbColumnValueList [$crntColIndex] = $age;
|
|
} else if ($dbColumnNameList [$crntColIndex] == 'gender') {
|
|
$gender = $colVal;
|
|
$dbColumnValueList [$crntColIndex] = $gender;
|
|
} else if ($dbColumnNameList [$crntColIndex] == 'height') {
|
|
$height = $colVal;
|
|
$dbColumnValueList [$crntColIndex] = $height;
|
|
} else if ($dbColumnNameList [$crntColIndex] == 'weight') {
|
|
$weight = $colVal;
|
|
$dbColumnValueList [$crntColIndex] = $weight;
|
|
} else if ($dbColumnNameList [$crntColIndex] == 'pulse') {
|
|
$pulse = $colVal;
|
|
$dbColumnValueList [$crntColIndex] = $pulse;
|
|
} else if ($dbColumnNameList [$crntColIndex] == 'bp') {
|
|
$bp = $colVal;
|
|
$dbColumnValueList [$crntColIndex] = $bp;
|
|
} else if ($dbColumnNameList [$crntColIndex] == 'nails') {
|
|
$nails = $colVal;
|
|
$dbColumnValueList [$crntColIndex] = $nails;
|
|
error_log ( "naileddddddddd" . $nails );
|
|
error_log ( "nailllllled" . $dbColumnValueList [$crntColIndex] );
|
|
} else if ($dbColumnNameList [$crntColIndex] == 'bmi') {
|
|
$bmi = $colVal;
|
|
$dbColumnValueList [$crntColIndex] = $bmi;
|
|
} else if ($dbColumnNameList [$crntColIndex] == 'waist') {
|
|
$waist = $colVal;
|
|
$dbColumnValueList [$crntColIndex] = $waist;
|
|
} else if ($dbColumnNameList [$crntColIndex] == 'hip') {
|
|
$hip = $colVal;
|
|
$dbColumnValueList [$crntColIndex] = $hip;
|
|
} else if ($dbColumnNameList [$crntColIndex] == 'sgpt') {
|
|
$sgpt = $colVal;
|
|
$dbColumnValueList [$crntColIndex] = $sgpt;
|
|
} else if ($dbColumnNameList [$crntColIndex] == 'status') {
|
|
$status = $colVal;
|
|
$dbColumnValueList [$crntColIndex] = $status;
|
|
} else if ($dbColumnNameList [$crntColIndex] == 'SpO2') {
|
|
$SpO2 = $colVal;
|
|
$dbColumnValueList [$crntColIndex] = $SpO2;
|
|
} else if ($dbColumnNameList [$crntColIndex] == 'dlc_b') {
|
|
$dlc_b = $colVal;
|
|
$dbColumnValueList [$crntColIndex] = $dlc_b;
|
|
} else if ($dbColumnNameList [$crntColIndex] == 's1') {
|
|
$s1 = $colVal;
|
|
$dbColumnValueList [$crntColIndex] = $s1;
|
|
} else if ($dbColumnNameList [$crntColIndex] == 's2') {
|
|
$s2 = $colVal;
|
|
$dbColumnValueList [$crntColIndex] = $s2;
|
|
} else if ($dbColumnNameList [$crntColIndex] == 'any_other_sound') {
|
|
$any_other_sound = $colVal;
|
|
$dbColumnValueList [$crntColIndex] = $any_other_sound;
|
|
} else if ($dbColumnNameList [$crntColIndex] == 'ecg_findings') {
|
|
$ecg_findings = $colVal;
|
|
$dbColumnValueList [$crntColIndex] = $ecg_findings;
|
|
} else if ($dbColumnNameList [$crntColIndex] == 'tmt_findings') {
|
|
$tmt_findings = $colVal;
|
|
$dbColumnValueList [$crntColIndex] = $tmt_findings;
|
|
} else if ($dbColumnNameList [$crntColIndex] == 'near_without_right_eye') {
|
|
$near_without_right_eye = $colVal;
|
|
$dbColumnValueList [$crntColIndex] = $near_without_right_eye;
|
|
} else if ($dbColumnNameList [$crntColIndex] == 'dis_without_right_eye') {
|
|
$dis_without_right_eye = $colVal;
|
|
$dbColumnValueList [$crntColIndex] = $dis_without_right_eye;
|
|
} else if ($dbColumnNameList [$crntColIndex] == 'dis_without_left_eye') {
|
|
$dis_without_left_eye = $colVal;
|
|
$dbColumnValueList [$crntColIndex] = $dis_without_left_eye;
|
|
} else if ($dbColumnNameList [$crntColIndex] == 'near_without_left_eye') {
|
|
$near_without_left_eye = $colVal;
|
|
$dbColumnValueList [$crntColIndex] = $near_without_left_eye;
|
|
} else if ($dbColumnNameList [$crntColIndex] == 'near_with_right_eye') {
|
|
$near_with_right_eye = $colVal;
|
|
$dbColumnValueList [$crntColIndex] = $near_with_right_eye;
|
|
} else if ($dbColumnNameList [$crntColIndex] == 'dis_with_right_eye') {
|
|
$dis_with_right_eye = $colVal;
|
|
$dbColumnValueList [$crntColIndex] = $dis_with_right_eye;
|
|
} else if ($dbColumnNameList [$crntColIndex] == 'dis_with_left_eye') {
|
|
$dis_with_left_eye = $colVal;
|
|
$dbColumnValueList [$crntColIndex] = $dis_with_left_eye;
|
|
} else if ($dbColumnNameList [$crntColIndex] == 'near_with_left_eye') {
|
|
$near_with_left_eye = $colVal;
|
|
$dbColumnValueList [$crntColIndex] = $near_with_left_eye;
|
|
} else if ($dbColumnNameList [$crntColIndex] == 'skin') {
|
|
$skin = $colVal;
|
|
$dbColumnValueList [$crntColIndex] = $skin;
|
|
} else if ($dbColumnNameList [$crntColIndex] == 'color_vision') {
|
|
$color_vision = $colVal;
|
|
$dbColumnValueList [$crntColIndex] = $color_vision;
|
|
} else if ($dbColumnNameList [$crntColIndex] == 'ident_of_individual_colors') {
|
|
$ident_of_individual_colors = $colVal;
|
|
$dbColumnValueList [$crntColIndex] = $ident_of_individual_colors;
|
|
} else if ($dbColumnNameList [$crntColIndex] == 'rs') {
|
|
$rs = $colVal;
|
|
$dbColumnValueList [$crntColIndex] = $rs;
|
|
} else if ($dbColumnNameList [$crntColIndex] == 'musculo_skeletal') {
|
|
$musculo_skeletal = $colVal;
|
|
$dbColumnValueList [$crntColIndex] = $musculo_skeletal;
|
|
} else if ($dbColumnNameList [$crntColIndex] == 'chest_radiograph') {
|
|
$chest_radiograph = $colVal;
|
|
$dbColumnValueList [$crntColIndex] = $chest_radiograph;
|
|
} else if ($dbColumnNameList [$crntColIndex] == 'stool_re_me') {
|
|
$stool_re_me = $colVal;
|
|
$dbColumnValueList [$crntColIndex] = $stool_re_me;
|
|
} else if ($dbColumnNameList [$crntColIndex] == 'cns') {
|
|
$cns = $colVal;
|
|
$dbColumnValueList [$crntColIndex] = $cns;
|
|
} else if ($dbColumnNameList [$crntColIndex] == 'fvc_pre') {
|
|
$fvc_pre = $colVal;
|
|
$dbColumnValueList [$crntColIndex] = $fvc_pre;
|
|
} else if ($dbColumnNameList [$crntColIndex] == 'fvc_post') {
|
|
$fvc_post = $colVal;
|
|
$dbColumnValueList [$crntColIndex] = $fvc_post;
|
|
} else if ($dbColumnNameList [$crntColIndex] == 'fev1_pre') {
|
|
$fev1_pre = $colVal;
|
|
$dbColumnValueList [$crntColIndex] = $fev1_pre;
|
|
} else if ($dbColumnNameList [$crntColIndex] == 'fev1_post') {
|
|
$fev1_post = $colVal;
|
|
$dbColumnValueList [$crntColIndex] = $fev1_post;
|
|
} else if ($dbColumnNameList [$crntColIndex] == 'fev1_fvc_post') {
|
|
$fev1_fvc_post = $colVal;
|
|
$dbColumnValueList [$crntColIndex] = $fev1_fvc_post;
|
|
} else if ($dbColumnNameList [$crntColIndex] == 'peak_expiratory_flow_pre') {
|
|
$peak_expiratory_flow_pre = $colVal;
|
|
$dbColumnValueList [$crntColIndex] = $peak_expiratory_flow_pre;
|
|
} else if ($dbColumnNameList [$crntColIndex] == 'fev1_fvc_pre') {
|
|
$fev1_fvc_pre = $colVal;
|
|
$dbColumnValueList [$crntColIndex] = $fev1_fvc_pre;
|
|
} else if ($dbColumnNameList [$crntColIndex] == 'peak_expiratory_flow_post') {
|
|
$peak_expiratory_flow_post = $colVal;
|
|
$dbColumnValueList [$crntColIndex] = $peak_expiratory_flow_post;
|
|
} else if ($dbColumnNameList [$crntColIndex] == 'air_cond_left') {
|
|
$air_cond_left = $colVal;
|
|
$dbColumnValueList [$crntColIndex] = $air_cond_left;
|
|
} else if ($dbColumnNameList [$crntColIndex] == 'air_cond_right') {
|
|
$air_cond_right = $colVal;
|
|
$dbColumnValueList [$crntColIndex] = $air_cond_right;
|
|
} else if ($dbColumnNameList [$crntColIndex] == 'bone_cond_left') {
|
|
$bone_cond_left = $colVal;
|
|
$dbColumnValueList [$crntColIndex] = $bone_cond_left;
|
|
} else if ($dbColumnNameList [$crntColIndex] == 'bone_cond_right') {
|
|
$bone_cond_right = $colVal;
|
|
$dbColumnValueList [$crntColIndex] = $bone_cond_right;
|
|
} else if ($dbColumnNameList [$crntColIndex] == 'hb') {
|
|
$hb = $colVal;
|
|
$dbColumnValueList [$crntColIndex] = $hb;
|
|
} else if ($dbColumnNameList [$crntColIndex] == 'tlc') {
|
|
$tlc = $colVal;
|
|
$dbColumnValueList [$crntColIndex] = $tlc;
|
|
} else if ($dbColumnNameList [$crntColIndex] == 'vdrl') {
|
|
$vdrl = $colVal;
|
|
$dbColumnValueList [$crntColIndex] = $vdrl;
|
|
} else if ($dbColumnNameList [$crntColIndex] == 'dlc_n') {
|
|
$dlc_n = $colVal;
|
|
$dbColumnValueList [$crntColIndex] = $dlc_n;
|
|
} else if ($dbColumnNameList [$crntColIndex] == 'dlc_l') {
|
|
$dlc_l = $colVal;
|
|
$dbColumnValueList [$crntColIndex] = $dlc_l;
|
|
} else if ($dbColumnNameList [$crntColIndex] == 'dlc_m') {
|
|
$dlc_m = $colVal;
|
|
$dbColumnValueList [$crntColIndex] = $dlc_m;
|
|
} else if ($dbColumnNameList [$crntColIndex] == 'dlc_e') {
|
|
$dlc_e = $colVal;
|
|
$dbColumnValueList [$crntColIndex] = $dlc_e;
|
|
} else if ($dbColumnNameList [$crntColIndex] == 'platelets') {
|
|
$platelets = $colVal;
|
|
$dbColumnValueList [$crntColIndex] = $platelets;
|
|
} else if ($dbColumnNameList [$crntColIndex] == 's_urea') {
|
|
$s_urea = $colVal;
|
|
$dbColumnValueList [$crntColIndex] = $s_urea;
|
|
} else if ($dbColumnNameList [$crntColIndex] == 's_creatinine') {
|
|
$s_creatinine = $colVal;
|
|
$dbColumnValueList [$crntColIndex] = $s_creatinine;
|
|
} else if ($dbColumnNameList [$crntColIndex] == 's_cholesterol') {
|
|
$s_cholesterol = $colVal;
|
|
$dbColumnValueList [$crntColIndex] = $s_cholesterol;
|
|
} else if ($dbColumnNameList [$crntColIndex] == 'blood_gluose') {
|
|
$blood_gluose = $colVal;
|
|
$dbColumnValueList [$crntColIndex] = $blood_gluose;
|
|
} else if ($dbColumnNameList [$crntColIndex] == 'esr') {
|
|
$esr = $colVal;
|
|
$dbColumnValueList [$crntColIndex] = $esr;
|
|
} else if ($dbColumnNameList [$crntColIndex] == 'bun') {
|
|
$bun = $colVal;
|
|
$dbColumnValueList [$crntColIndex] = $bun;
|
|
} else if ($dbColumnNameList [$crntColIndex] == 'lipid_profile') {
|
|
$lipid_profile = $colVal;
|
|
$dbColumnValueList [$crntColIndex] = $lipid_profile;
|
|
} else if ($dbColumnNameList [$crntColIndex] == 'profusion_opacities') {
|
|
$profusion_opacitites = $colVal;
|
|
$dbColumnValueList [$crntColIndex] = $profusion_opacitites;
|
|
} else if ($dbColumnNameList [$crntColIndex] == 'blood_group') {
|
|
$blood_group = $colVal;
|
|
$dbColumnValueList [$crntColIndex] = $blood_group;
|
|
error_log ( "blooooooood" . $blood_group );
|
|
error_log ( "bloooooooodyyyyyy" . $dbColumnValueList [$crntColIndex] );
|
|
} else if ($dbColumnNameList [$crntColIndex] == 'hiv') {
|
|
$hiv = $colVal;
|
|
$dbColumnValueList [$crntColIndex] = $hiv;
|
|
} else if ($dbColumnNameList [$crntColIndex] == 'psa') {
|
|
$psa = $colVal;
|
|
$dbColumnValueList [$crntColIndex] = $psa;
|
|
} else if ($dbColumnNameList [$crntColIndex] == 'acid_phosphatase') {
|
|
$acid_phosphatase = $colVal;
|
|
$dbColumnValueList [$crntColIndex] = $acid_phosphatase;
|
|
} else if ($dbColumnNameList [$crntColIndex] == 'uric_acid') {
|
|
$uric_acid = $colVal;
|
|
$dbColumnValueList [$crntColIndex] = $uric_acid;
|
|
} else if ($dbColumnNameList [$crntColIndex] == 'live_function_test') {
|
|
$live_function_test = $colVal;
|
|
$dbColumnValueList [$crntColIndex] = $live_function_test;
|
|
} else if ($dbColumnNameList [$crntColIndex] == 'blood_gluose') {
|
|
$blood_gluose = $colVal;
|
|
$dbColumnValueList [$crntColIndex] = $blood_gluose;
|
|
} else if ($dbColumnNameList [$crntColIndex] == 'dental_exam_report') {
|
|
$dental_exam_report = $colVal;
|
|
$dbColumnValueList [$crntColIndex] = $dental_exam_report;
|
|
} else if ($dbColumnNameList [$crntColIndex] == 'mammography') {
|
|
$mammography = $colVal;
|
|
$dbColumnValueList [$crntColIndex] = $mammography;
|
|
} else if ($dbColumnNameList [$crntColIndex] == 'thyroid_profile') {
|
|
$thyroid_profile = $colVal;
|
|
$dbColumnValueList [$crntColIndex] = $thyroid_profile;
|
|
} else if ($dbColumnNameList [$crntColIndex] == 'pap_smear') {
|
|
$pap_smear = $colVal;
|
|
$dbColumnValueList [$crntColIndex] = $pap_smear;
|
|
} else if ($dbColumnNameList [$crntColIndex] == 'any_other') {
|
|
$any_other = $colVal;
|
|
$dbColumnValueList [$crntColIndex] = $any_other;
|
|
} else if ($dbColumnNameList [$crntColIndex] == 'conversational_hearing') {
|
|
$conversational_hearing = $colVal;
|
|
$dbColumnValueList [$crntColIndex] = $conversational_hearing;
|
|
} else if ($dbColumnNameList [$crntColIndex] == 'auroscopy') {
|
|
$auroscopy = $colVal;
|
|
$dbColumnValueList [$crntColIndex] = $auroscopy;
|
|
} else if ($dbColumnNameList [$crntColIndex] == 'throat') {
|
|
$throat = $colVal;
|
|
$dbColumnValueList [$crntColIndex] = $throat;
|
|
} else if ($dbColumnNameList [$crntColIndex] == 'nose') {
|
|
$nose = $colVal;
|
|
$dbColumnValueList [$crntColIndex] = $nose;
|
|
} else if ($dbColumnNameList [$crntColIndex] == 'heart_sound') {
|
|
$heart_sound = $colVal;
|
|
$dbColumnValueList [$crntColIndex] = $heart_sound;
|
|
} else if ($dbColumnNameList [$crntColIndex] == 'eac') {
|
|
$eac = $colVal;
|
|
$dbColumnValueList [$crntColIndex] = $eac;
|
|
} else if ($dbColumnNameList [$crntColIndex] == 'speen') {
|
|
$speen = $colVal;
|
|
$dbColumnValueList [$crntColIndex] = $speen;
|
|
} else if ($dbColumnNameList [$crntColIndex] == 'tenderness') {
|
|
$tenderness = $colVal;
|
|
$dbColumnValueList [$crntColIndex] = $tenderness;
|
|
} else if ($dbColumnNameList [$crntColIndex] == 'liver') {
|
|
$liver = $colVal;
|
|
$dbColumnValueList [$crntColIndex] = $liver;
|
|
} else if ($dbColumnNameList [$crntColIndex] == 'any_other_abnormality') {
|
|
$any_other_abnormality = $colVal;
|
|
$dbColumnValueList [$crntColIndex] = $any_other_abnormality;
|
|
} else if ($dbColumnNameList [$crntColIndex] == 'appearance') {
|
|
$appearance = $colVal;
|
|
$dbColumnValueList [$crntColIndex] = $appearance;
|
|
} else if ($dbColumnNameList [$crntColIndex] == 'pus_cells') {
|
|
$pus_cells = $colVal;
|
|
$dbColumnValueList [$crntColIndex] = $pus_cells;
|
|
} else if ($dbColumnNameList [$crntColIndex] == 'rbcs') {
|
|
$rbcs = $colVal;
|
|
$dbColumnValueList [$crntColIndex] = $rbcs;
|
|
} else if ($dbColumnNameList [$crntColIndex] == 'epithelial_cells') {
|
|
$epithelial_cells = $colVal;
|
|
$dbColumnValueList [$crntColIndex] = $epithelial_cells;
|
|
} else if ($dbColumnNameList [$crntColIndex] == 'other_relevant_findings') {
|
|
$other_relevant_findings = $colVal;
|
|
$dbColumnValueList [$crntColIndex] = $other_relevant_findings;
|
|
} else if ($dbColumnNameList [$crntColIndex] == 'albumin') {
|
|
$albumin = $colVal;
|
|
$dbColumnValueList [$crntColIndex] = $albumin;
|
|
} else if ($dbColumnNameList [$crntColIndex] == 'sugar') {
|
|
$sugar = $colVal;
|
|
$dbColumnValueList [$crntColIndex] = $sugar;
|
|
}
|
|
// else if ($dbColumnNameList [$crntColIndex] == 'blood_sugar') {
|
|
// $blood_sugar = $colVal;
|
|
// $dbColumnValueList [$crntColIndex] = $blood_sugar;
|
|
// }
|
|
else if ($dbColumnNameList [$crntColIndex] == 'ident_of_individual_colors') {
|
|
$ident_of_individual_colors = $colVal;
|
|
$dbColumnValueList [$crntColIndex] = $ident_of_individual_colors;
|
|
} else if ($dbColumnNameList [$crntColIndex] == 'physical_status') {
|
|
$physical_status = $colVal;
|
|
$dbColumnValueList [$crntColIndex] = $physical_status;
|
|
} else if ($dbColumnNameList [$crntColIndex] == 'opinion_remarks_medical_assistant') {
|
|
$opinion_remarks_medical_assistant = $colVal;
|
|
$dbColumnValueList [$crntColIndex] = $opinion_remarks_medical_assistant;
|
|
} else if ($dbColumnNameList [$crntColIndex] == 'opinion_remarks') {
|
|
$opinion_remarks = $colVal;
|
|
$dbColumnValueList [$crntColIndex] = $opinion_remarks;
|
|
} else if ($dbColumnNameList [$crntColIndex] == 'speech') {
|
|
$speech = $colVal;
|
|
$dbColumnValueList [$crntColIndex] = $speech;
|
|
} else if ($dbColumnNameList [$crntColIndex] == 'higher_function') {
|
|
$higher_function = $colVal;
|
|
$dbColumnValueList [$crntColIndex] = $higher_function;
|
|
} else if ($dbColumnNameList [$crntColIndex] == 'motor_function') {
|
|
$motor_function = $colVal;
|
|
$dbColumnValueList [$crntColIndex] = $motor_function;
|
|
} else if ($dbColumnNameList [$crntColIndex] == 'vertigo') {
|
|
$vertigo = $colVal;
|
|
$dbColumnValueList [$crntColIndex] = $vertigo;
|
|
} else if ($dbColumnNameList [$crntColIndex] == 'reflexes') {
|
|
$reflexes = $colVal;
|
|
$dbColumnValueList [$crntColIndex] = $reflexes;
|
|
} else if ($dbColumnNameList [$crntColIndex] == 'vibration_syndrome') {
|
|
$vibration_syndrome = $colVal;
|
|
$dbColumnValueList [$crntColIndex] = $vibration_syndrome;
|
|
} else if ($dbColumnNameList [$crntColIndex] == 'ppo') {
|
|
$ppo = $colVal;
|
|
$dbColumnValueList [$crntColIndex] = $ppo;
|
|
} else if ($dbColumnNameList [$crntColIndex] == 'grade') {
|
|
$grade = $colVal;
|
|
$dbColumnValueList [$crntColIndex] = $grade;
|
|
} else if ($dbColumnNameList [$crntColIndex] == 'type') {
|
|
$type = $colVal;
|
|
$dbColumnValueList [$crntColIndex] = $type;
|
|
} else if ($dbColumnNameList [$crntColIndex] == 'any_other_eye_disease') {
|
|
$any_other_eye_disease = $colVal;
|
|
$dbColumnValueList [$crntColIndex] = $any_other_eye_disease;
|
|
} else if ($dbColumnNameList [$crntColIndex] == 'hernia') {
|
|
$hernia = $colVal;
|
|
$dbColumnValueList [$crntColIndex] = $hernia;
|
|
error_log ( "herniaaaaaa" . $hernia );
|
|
error_log ( "herniaaaaa" . $dbColumnValueList [$crntColIndex] );
|
|
} else if ($dbColumnNameList [$crntColIndex] == 'hydrocele') {
|
|
$hydrocele = $colVal;
|
|
$dbColumnValueList [$crntColIndex] = $hydrocele;
|
|
} else if ($dbColumnNameList [$crntColIndex] == 'phimosis') {
|
|
$phimosis = $colVal;
|
|
$dbColumnValueList [$crntColIndex] = $phimosis;
|
|
} else if ($dbColumnNameList [$crntColIndex] == 'piles') {
|
|
$piles = $colVal;
|
|
$dbColumnValueList [$crntColIndex] = $piles;
|
|
} else if ($dbColumnNameList [$crntColIndex] == 'fistula') {
|
|
$fistula = $colVal;
|
|
$dbColumnValueList [$crntColIndex] = $fistula;
|
|
} else if ($dbColumnNameList [$crntColIndex] == 'gate') {
|
|
$gate = $colVal;
|
|
$dbColumnValueList [$crntColIndex] = $gate;
|
|
} else if ($dbColumnNameList [$crntColIndex] == 'hair') {
|
|
$hair = $colVal;
|
|
$dbColumnValueList [$crntColIndex] = $hair;
|
|
} else if ($dbColumnNameList [$crntColIndex] == 'lung_exam') {
|
|
$lung_exam = $colVal;
|
|
$dbColumnValueList [$crntColIndex] = $lung_exam;
|
|
} else if ($dbColumnNameList [$crntColIndex] == 'dr_emp_code') {
|
|
$dr_emp_code = $colVal;
|
|
$dbColumnValueList [$crntColIndex] = $dr_emp_code;
|
|
} else if ($dbColumnNameList [$crntColIndex] == 'spectable') {
|
|
$spectable = $colVal;
|
|
$dbColumnValueList [$crntColIndex] = $spectable;
|
|
} else if ($dbColumnNameList [$crntColIndex] == 'primary_phone') {
|
|
$primary_phone = $colVal;
|
|
$dbColumnValueList [$crntColIndex] = $primary_phone;
|
|
} else if ($dbColumnNameList [$crntColIndex] == 'identificaton_mark') {
|
|
$identi_mark = $colVal;
|
|
$dbColumnValueList [$crntColIndex] = $identi_mark;
|
|
} else if ($dbColumnNameList [$crntColIndex] == 'marital') {
|
|
$marital_status = $colVal;
|
|
$dbColumnValueList [$crntColIndex] = $marital_status;
|
|
} else if ($dbColumnNameList [$crntColIndex] == 'no_of_children') {
|
|
$no_of_child = $colVal;
|
|
$dbColumnValueList [$crntColIndex] = $no_of_child;
|
|
} else if ($dbColumnNameList [$crntColIndex] == 'family_planning') {
|
|
$adopting_family_planning = $colVal;
|
|
$dbColumnValueList [$crntColIndex] = $adopting_family_planning;
|
|
} else if ($dbColumnNameList [$crntColIndex] == 'past_present_illness') {
|
|
$past_present_illness = $colVal;
|
|
$dbColumnValueList [$crntColIndex] = $past_present_illness;
|
|
} else if ($dbColumnNameList [$crntColIndex] == 'typhoid_findings') {
|
|
$typhoid_findings = $colVal;
|
|
$dbColumnValueList [$crntColIndex] = $typhoid_findings;
|
|
} else if ($dbColumnNameList [$crntColIndex] == 'urine_findings') {
|
|
$urine_findings = $colVal;
|
|
$dbColumnValueList [$crntColIndex] = $urine_findings;
|
|
} else if ($dbColumnNameList [$crntColIndex] == 'lft_findings') {
|
|
$lft_findings = $colVal;
|
|
$dbColumnValueList [$crntColIndex] = $lft_findings;
|
|
} else if ($dbColumnNameList [$crntColIndex] == 'xray_findings') {
|
|
$xray_findings = $colVal;
|
|
$dbColumnValueList [$crntColIndex] = $xray_findings;
|
|
} else if ($dbColumnNameList [$crntColIndex] == 'sputum_findings') {
|
|
$sputum_findings = $colVal;
|
|
$dbColumnValueList [$crntColIndex] = $sputum_findings;
|
|
} else if ($dbColumnNameList [$crntColIndex] == 'health_index') {
|
|
$health_index = $colVal;
|
|
$dbColumnValueList [$crntColIndex] = $health_index;
|
|
}else if ($dbColumnNameList [$crntColIndex] == 'p') {
|
|
$p = $colVal;
|
|
$dbColumnValueList [$crntColIndex] = $p;
|
|
} else if ($dbColumnNameList [$crntColIndex] == 'cy') {
|
|
$cy = $colVal;
|
|
$dbColumnValueList [$crntColIndex] = $cy;
|
|
} else if ($dbColumnNameList [$crntColIndex] == 'cl') {
|
|
$cl = $colVal;
|
|
$dbColumnValueList [$crntColIndex] = $cl;
|
|
} else if ($dbColumnNameList [$crntColIndex] == 'e') {
|
|
$e = $colVal;
|
|
$dbColumnValueList [$crntColIndex] = $e;
|
|
} else if ($dbColumnNameList [$crntColIndex] == 'a') {
|
|
$a = $colVal;
|
|
$dbColumnValueList [$crntColIndex] = $a;
|
|
} else if ($dbColumnNameList [$crntColIndex] == 'oe') {
|
|
$oe = $colVal;
|
|
$dbColumnValueList [$crntColIndex] = $oe;
|
|
} else if ($dbColumnNameList [$crntColIndex] == 'pr') {
|
|
$pr = $colVal;
|
|
$dbColumnValueList [$crntColIndex] = $pr;
|
|
} else if ($dbColumnNameList [$crntColIndex] == 'p_abd') {
|
|
$p_abd = $colVal;
|
|
$dbColumnValueList [$crntColIndex] = $p_abd;
|
|
} else if ($dbColumnNameList [$crntColIndex] == 'ln_v') {
|
|
$ln_v = $colVal;
|
|
$dbColumnValueList [$crntColIndex] = $ln_v;
|
|
} else if ($dbColumnNameList [$crntColIndex] == 'ln_axis') {
|
|
$ln_axis = $colVal;
|
|
$dbColumnValueList [$crntColIndex] = $ln_axis;
|
|
} else if ($dbColumnNameList [$crntColIndex] == 'ln_dcyl') {
|
|
$ln_dcyl = $colVal;
|
|
$dbColumnValueList [$crntColIndex] = $ln_dcyl;
|
|
} else if ($dbColumnNameList [$crntColIndex] == 'ln_dsph') {
|
|
$ln_dsph = $colVal;
|
|
$dbColumnValueList [$crntColIndex] = $ln_dsph;
|
|
} else if ($dbColumnNameList [$crntColIndex] == 'rn_v') {
|
|
$rn_v = $colVal;
|
|
$dbColumnValueList [$crntColIndex] = $rn_v;
|
|
}else if ($dbColumnNameList [$crntColIndex] == 'rn_axis') {
|
|
$rn_axis = $colVal;
|
|
$dbColumnValueList [$crntColIndex] = $rn_axis;
|
|
} else if ($dbColumnNameList [$crntColIndex] == 'rn_dcyl') {
|
|
$rn_dcyl = $colVal;
|
|
$dbColumnValueList [$crntColIndex] = $rn_dcyl;
|
|
} else if ($dbColumnNameList [$crntColIndex] == 'rn_dsph') {
|
|
$rn_dsph = $colVal;
|
|
$dbColumnValueList [$crntColIndex] = $rn_dsph;
|
|
} else if ($dbColumnNameList [$crntColIndex] == 'ld_v') {
|
|
$ld_v = $colVal;
|
|
$dbColumnValueList [$crntColIndex] = $ld_v;
|
|
} else if ($dbColumnNameList [$crntColIndex] == 'ld_axis') {
|
|
$ld_axis = $colVal;
|
|
$dbColumnValueList [$crntColIndex] = $ld_axis;
|
|
} else if ($dbColumnNameList [$crntColIndex] == 'ld_dcyl') {
|
|
$ld_dcyl = $colVal;
|
|
$dbColumnValueList [$crntColIndex] = $ld_dcyl;
|
|
} else if ($dbColumnNameList [$crntColIndex] == 'ld_dsph') {
|
|
$ld_dsph = $colVal;
|
|
$dbColumnValueList [$crntColIndex] = $ld_dsph;
|
|
} else if ($dbColumnNameList [$crntColIndex] == 'rd_v') {
|
|
$rd_v = $colVal;
|
|
$dbColumnValueList [$crntColIndex] = $rd_v;
|
|
} else if ($dbColumnNameList [$crntColIndex] == 'rd_axis') {
|
|
$rd_axis = $colVal;
|
|
$dbColumnValueList [$crntColIndex] = $rd_axis;
|
|
} else if ($dbColumnNameList [$crntColIndex] == 'rd_dcyl') {
|
|
$rd_dcyl = $colVal;
|
|
$dbColumnValueList [$crntColIndex] = $rd_dcyl;
|
|
} else if ($dbColumnNameList [$crntColIndex] == 'rd_dsph') {
|
|
$rd_dsph = $colVal;
|
|
$dbColumnValueList [$crntColIndex] = $rd_dsph;
|
|
} else if ($dbColumnNameList [$crntColIndex] == 'blood_sugar_ppbs') {
|
|
$blood_sugar_ppbs = $colVal;
|
|
$dbColumnValueList [$crntColIndex] = $blood_sugar_ppbs;
|
|
} else if ($dbColumnNameList [$crntColIndex] == 'blood_sugar_fbs') {
|
|
$blood_sugar_fbs = $colVal;
|
|
$dbColumnValueList [$crntColIndex] = $blood_sugar_fbs;
|
|
} else if ($dbColumnNameList [$crntColIndex] == 'blood_sugar_rbs') {
|
|
$blood_sugar_rbs = $colVal;
|
|
$dbColumnValueList [$crntColIndex] = $blood_sugar_rbs;
|
|
} else if ($dbColumnNameList [$crntColIndex] == 'blood_sugar_hb1ac') {
|
|
$blood_sugar_hb1ac = $colVal;
|
|
$dbColumnValueList [$crntColIndex] = $blood_sugar_hb1ac;
|
|
} else if ($dbColumnNameList [$crntColIndex] == 'deformities') {
|
|
$deformities = $colVal;
|
|
$dbColumnValueList [$crntColIndex] = $deformities;
|
|
}
|
|
|
|
// custom logic, validations and calculations -- End
|
|
|
|
$crntColIndex ++; // continue reading next column value
|
|
} // end of while -- reading data rows- end
|
|
|
|
$id = "";
|
|
|
|
print_r ( $histParam [0] );
|
|
|
|
$paramId = getCommaSeperatedValuesForInClause ( "select param_id from history_parameter", "param_name", $histParam );
|
|
error_log ( "param id:::::" . $paramId );
|
|
|
|
if (! empty ( $emp_code )) {
|
|
|
|
$id = getTableFieldValue ( 'patient_master', 'id', 'aadhar_no', "'" . $aadhar_no . "'" );
|
|
// $aadhar_no = getTableFieldValue ( 'patient_master', 'aadhar_no', 'emp_code', "'" .$emp_code . "'" );
|
|
|
|
$dept_id = getTableFieldValue ( 'department', 'dept_id', 'dept_name', "'" . $department . "'" );
|
|
if ($dept_id == null or $dept_id == "") {
|
|
mysqli_query($conn,"insert into department set dept_name='" . $department . "'" );
|
|
$dept_id = getTableFieldValue ( 'department', 'dept_id', 'dept_name', "'" . $department . "'" );
|
|
}
|
|
|
|
$designation_id = getTableFieldValue ( 'designation', 'designation_id', 'designation_name', "'" . $designation . "'" );
|
|
if ($designation_id == null or $designation_id == "") {
|
|
mysqli_query($conn,"insert into designation set designation_name='" . $designation . "'" );
|
|
$designation_id = getTableFieldValue ( 'designation', 'designation_id', 'designation_name', "'" . $designation . "'" );
|
|
}
|
|
|
|
$initquery = "";
|
|
$endquery = "";
|
|
|
|
if (isset ( $id )) {
|
|
$initquery = "update patient_master set ";
|
|
$endquery = " where aadhar_no = '" . $aadhar_no . "' ";
|
|
} else {
|
|
$initquery = "insert into patient_master set ";
|
|
$endquery = "";
|
|
$new_emp_counter ++;
|
|
}
|
|
$query_patient = $initquery . " dob=STR_TO_DATE('" . $dob . "','%d-%m-%Y'),primary_phone ='" . $primary_phone . "',emp_code='" . $emp_code . "',patient_name='" . $patient_name . "',father_name='" . $father_name . "',blood_group='" . $blood_group . "',gender='" . $gender . "',dept_id='" . $dept_id . "',designation_id='" . $designation_id . "',aadhar_no='" . $aadhar_no . "'" . $endquery;
|
|
// error_log($query_patient);
|
|
// $result = @mysqli_query($conn,$query_patient);
|
|
// error_log ("upload medical data".$query_patient);
|
|
// echo $query_patient;
|
|
if (! $result = @mysqli_query($conn,$query_patient )) {
|
|
error_log ( "Exception:" . mysqli_error($conn) );
|
|
error_log ( "Failed to Execute Patient Insert/Update Query::: " . $query_patient );
|
|
// $response_array['responseText']=mysqli_error($conn);
|
|
rollback ();
|
|
exit ( mysqli_error($conn) );
|
|
}
|
|
|
|
if ($result) {
|
|
$response_array ['status'] = 'success';
|
|
} else {
|
|
$response_array ['status'] = 'error';
|
|
}
|
|
}
|
|
// $blood_group = getTableFieldValue('blood_group', 'id', 'type', "'" . $blood_group . "'");
|
|
$id = getTableFieldValue ( 'patient_master', 'id', 'emp_code', "'" . $emp_code . "'" );
|
|
error_log ( $id );
|
|
$medical_update = "SELECT count(*) count FROM medical_examination where task='" . $task . "' and patient_id='" . $id . "'
|
|
and medical_entry_date=STR_TO_DATE('" . $medical_date . "','%d-%m-%Y')";
|
|
error_log ( "query for medical" . $medical_update );
|
|
$result_medical_count = mysqli_query($conn,$medical_update );
|
|
$count = 0;
|
|
if ($row_medical_count = mysqli_fetch_array ( $result_medical_count )) {
|
|
$count = $row_medical_count ['count'];
|
|
// echo $count;
|
|
}
|
|
// $ailment_array = explode ( ',', $row_medical_count );
|
|
error_log ( $count );
|
|
|
|
if ($count > 0) {
|
|
$initquery = "update medical_examination set ";
|
|
$endquery = " where patient_id = '" . $id . "' ";
|
|
$update_counter ++;
|
|
} else {
|
|
$initquery = "insert into medical_examination set ";
|
|
$endquery = "";
|
|
$insert_counter ++;
|
|
}
|
|
|
|
if ($height != null && $height != '' && $weight != null && $weight != '') {
|
|
if ($height != 0.0)
|
|
$bmi = ($weight / ($height / 100 * $height / 100));
|
|
}
|
|
|
|
$medical_query = $initquery . " patient_id='" . $id . "',gate='" . $gate . "',hair='" . $hair . "',lung_exam='" . $lung_exam . "',dr_emp_code='" . $dr_emp_code . "',spectable='" . $spectable . "',asthma='" . $asthama . "',diabetes='" . $diabetes . "',tb='" . $tb . "',hbd='" . $hbd . "',epilepsy='" . $epilepsy . "',typhoid='" . $typhoid . "',night_blind='" . $night_blind . "',psychiatric='" . $psychiatric . "',heart_dis='" . $heart_deases . "',major_injury='" . $major_injury . "',height='" . $height . "',weight='" . $weight . "',pulse='" . $pulse . "',bp='" . $bp . "',bmi='" . $bmi . "',waist='" . $waist . "',hip='" . $hip . "',past_present_illness='" . $history_list . "',blood_gluose='" . $blood_gluose . "',heart_sound='" . $heart_sound . "',s_cholesterol='" . $s_cholesterol . "',sgpt='" . $sgpt . "',s1 = '".$s1."',s2 = '".$s2."',SpO2='" . $SpO2 . "',dlc_b='" . $dlc_b . "',any_other_sound='" . $any_other_sound . "',ecg_findings='" . $ecg_findings . "',tmt_findings='" . $tmt_findings . "',near_with_right_eye='" . $near_with_right_eye . "',near_without_right_eye='" . $near_without_right_eye . "',dis_with_right_eye='" . $dis_with_right_eye . "',dis_without_right_eye='" . $dis_without_right_eye . "',dis_without_left_eye='" . $dis_without_left_eye . "',dis_with_left_eye='" . $dis_with_left_eye . "',near_without_left_eye='" . $near_without_left_eye . "',near_with_left_eye='" . $near_with_left_eye . "',nails='" . $nails . "',skin='" . $skin . "',color_vision='" . $color_vision . "',rs='" . $rs . "',musculo_skeletal='" . $musculo_skeletal . "',cns='" . $cns . "',ent='" . $ent . "',chest_radiograph='" . $chest_radiograph . "',phimosis = '".$phimosis."',fistula='".$fistula."',urine_re_me='" . $urine_re_me . "',hernia='" . $hernia . "',hydrocele='" . $hydrocele . "',stool_re_me='" . $stool_re_me . "',fvc_pre='" . $fvc_pre . "',fvc_post='" . $fvc_post . "',fev1_pre='" . $fev1_pre . "',fev1_post='" . $fev1_post . "',fev1_fvc_post='" . $fev1_fvc_post . "',fev1_fvc_pre='" . $fev1_fvc_pre . "',peak_expiratory_flow_pre='" . $peak_expiratory_flow_pre . "',peak_expiratory_flow_post='" . $peak_expiratory_flow_post . "',air_cond_left='" . $air_cond_left . "',air_cond_right='" . $air_cond_right . "',bone_cond_left='" . $bone_cond_left . "',bone_cond_right='" . $bone_cond_right . "',hb='" . $hb . "',tlc='" . $tlc . "',dlc_n='" . $dlc_n . "',dlc_l='" . $dlc_l . "',dlc_m='" . $dlc_m . "',dlc_e='" . $dlc_e . "',platelets='" . $platelets . "',s_urea='" . $s_urea . "',s_creatinine='" . $s_creatinine . "',esr='" . $esr . "',bun='" . $bun . "',uric_acid='" . $uric_acid . "',acid_phosphatase='" . $acid_phosphatase . "',ohc_location_id='" . $ohc_type . "',psa='" . $psa . "',lipid_profile='" . $lipid_profile . "',profusion_opacities='" .$profusion_opacitites. "',live_function_test='" . $live_function_test . "',thyroid_profile='" . $thyroid_profile . "',dental_exam_report='" . $dental_exam_report . "',mammography='" . $mammography . "',conversational_hearing='" . $conversational_hearing . "',pap_smear='" . $pap_smear . "',any_other='" . $any_other . "',auroscopy='" . $auroscopy . "',throat='" . $throat . "',nose='" . $nose . "' ,eac='" . $eac . "',liver='" . $liver . "',speen='" . $speen . "',tenderness='" . $tenderness . "',any_other_abnormality='" . $any_other_abnormality . "',appearance='" . $appearance . "' ,pus_cells='" . $pus_cells . "',rbcs='" . $rbcs . "',epithelial_cells='" . $epithelial_cells . "',other_relevant_findings='" . $other_relevant_findings . "' ,albumin='" . $albumin . "',sugar='" . $sugar . "' ,blood_group='" . $blood_group . "',pallor='" . $pallor . "' ,cvs='" . $cvs . "',ident_of_individual_colors='" . $ident_of_individual_colors . "' ,physical_status='" . $physical_status . "',abdomen='" . $abdomen . "' ,opinion_remarks_medical_assistant='" . $opinion_remarks_medical_assistant . "',opinion_remarks='" . $opinion_remarks . "' ,vdrl='" . $vdrl . "',speech='" . $speech . "' ,higher_function='" . $higher_function . "',motor_function='" . $motor_function . "' ,vertigo='" . $vertigo . "',reflexes='" . $reflexes . "',vibration_syndrome='" . $vibration_syndrome . "',medical_entry_date=STR_TO_DATE('" . $medical_date . "','%d-%m-%Y'),ppo='" . $ppo . "' ,grade='" . $grade . "',type = '".$type."',any_other_eye_disease='" . $any_other_eye_disease . "' ,fvc='" . $fvc . "',task='" . $task . "',hiv='" . $hiv . "' ,smoking='" . $smoking . "',tobacco='" . $tobacco . "' ,alcohol='" . $alcohol . "',forward_status='D',addiction='" . $addiction . "',typhoid_findings='" . $typhoid_findings . "',urine_findings='" . $urine_findings . "',lft_findings='" . $lft_findings . "',xray_findings='" . $xray_findings . "',sputum_findings='" . $sputum_findings . "',health_index='" . $health_index . "',
|
|
p='" . $p . "',cy='" . $cy . "',cl='" . $cl . "',e='" . $e . "',a='" . $a . "',oe='" . $oe . "',pr='" . $pr . "',p_abd='" . $p_abd . "',ln_v='" . $ln_v . "',ln_axis='" . $ln_axis . "',ln_dcyl='" . $ln_dcyl . "',ln_dsph='" . $ln_dsph . "',rn_v='" . $rn_v . "',rn_axis='" . $rn_axis . "',rn_dcyl='" . $rn_dcyl . "',rn_dsph='" . $rn_dsph . "',ld_v='" . $ld_v . "',ld_axis='" . $ld_axis . "',ld_dcyl='" . $ld_dcyl . "',ld_dsph='" . $ld_dsph . "',rd_v='" . $rd_v . "',rd_axis='" . $rd_axis . "',rd_dcyl='" . $rd_dcyl . "',rd_dsph='" . $rd_dsph . "',blood_sugar_ppbs='" . $blood_sugar_ppbs . "',blood_sugar_fbs='" . $blood_sugar_fbs . "',blood_sugar_rbs='" . $blood_sugar_rbs . "',blood_sugar_hb1ac='" . $blood_sugar_hb1ac . "',deformities='" . $deformities . "'" . $endquery;
|
|
// echo $medical_query;
|
|
error_log ( $medical_query );
|
|
|
|
// echo $medical_query;
|
|
// $result = @mysqli_query($conn,$medical_query);
|
|
// error_log ($results);
|
|
if (! $result = @mysqli_query($conn,$medical_query )) {
|
|
// echo $query_patient;
|
|
// $response_array['responseText']=mysqli_error($conn);
|
|
if (substr ( $medical_query, 0, 6 ) === "insert") {
|
|
$insert_counter --;
|
|
} else {
|
|
$update_counter --;
|
|
}
|
|
error_log ( "Exception:" . mysqli_error($conn) );
|
|
error_log ( "Failed to Execute the Medical Examination Query::: " . $medical_query );
|
|
rollback ();
|
|
exit ( mysqli_error($conn) );
|
|
}
|
|
|
|
// /////////// personal info data insert ////////////////////////////////////////////////
|
|
|
|
$My_Family = " insert into patient_personal_information set identi_mark='" . $identi_mark . "',marital_status='" . $marital_status . "',no_of_child='" . $no_of_child . "',adopting_family_planning='" . $adopting_family_planning . "' ";
|
|
error_log ( "personal information:: " . $My_Family );
|
|
if (! $result11 = @mysqli_query($conn,$My_Family )) {
|
|
|
|
error_log ( "Exception:" . mysqli_error($conn) );
|
|
error_log ( "Failed to Execute the Personal info Query::: " . $My_Family );
|
|
rollback ();
|
|
exit ( mysqli_error($conn) );
|
|
}
|
|
}
|
|
}
|
|
}
|
|
commit ();
|
|
$response_mssages1 = $insert_counter . " " . "Medical Examination records inserted<br> ";
|
|
$response_mssages1 .= $update_counter . " " . "Medical Examination records updated<br>";
|
|
$response_mssages1 .= $fail_counter . " " . "Medical Examination records skipped<br> ";
|
|
$response_mssages1 .= $new_emp_counter . " " . " New Employee records Found<br> ";
|
|
|
|
$response_array ['responseText'] = "<br>" . $response_mssages1 . $response_mssages;
|
|
echo json_encode ( $response_array );
|
|
?>
|