63 lines
2.2 KiB
PHP
63 lines
2.2 KiB
PHP
<?php
|
|
include('includes/config/config.php');
|
|
include('includes/functions.php');
|
|
include('log_entry.php');
|
|
$id = $_POST['id'];
|
|
|
|
$noOfRows = $_POST['count_items'];
|
|
|
|
error_log("rows" . $noOfRows);
|
|
|
|
$query_initial = "";
|
|
|
|
$isUpdateCase = false;
|
|
|
|
if (!empty($id)) {
|
|
$query_initial = "update diagnosis_chronic_mapping ";
|
|
$end_query = "where id = '" . $id . "'";
|
|
$isUpdateCase = true;
|
|
} else {
|
|
$query_initial = "insert into diagnosis_chronic_mapping ";
|
|
}
|
|
|
|
$response = [];
|
|
|
|
$num = 0;
|
|
|
|
for ($i = 0; $i < $noOfRows; $i++) {
|
|
|
|
if (!$isUpdateCase) {
|
|
// check if that particular chronic illness and diagnosis mapped already because we cant allow one chronic illness mapped to multiple diagnosis
|
|
|
|
$exist_sql = "select * from diagnosis_chronic_mapping where chronic_id='" . ${"illness_name$i"} . "'";
|
|
error_log("exist query " . $exist_sql);
|
|
$result_exist = mysqli_query($conn, $exist_sql);
|
|
$row_exist = mysqli_num_rows($result_exist);
|
|
|
|
$chronic_name = getFieldFromTable('abnormality_name', 'abnormality', 'abnormality_id', ${"illness_name$i"});
|
|
|
|
if ($row_exist > 0) {
|
|
$response[$num++] = strtolower($chronic_name);
|
|
} else {
|
|
$query = $query_initial . " set ailment_id='" . ${"diag_name$i"} . "',chronic_id='" . ${"illness_name$i"} . "',modified_by = '" . $_SESSION['user_id'] . "'" . $end_query;
|
|
|
|
error_log("map update/insert query " . $query);
|
|
if (!$result = @mysqli_query($conn, $query)) {
|
|
error_log("Failed to Update the mapping. Error Found" . mysqli_error($conn) . ". Failing Query:" . $query);
|
|
exit(mysqli_error($conn));
|
|
}
|
|
}
|
|
} else {
|
|
$query = $query_initial . " set ailment_id='" . ${"diag_name$i"} . "',chronic_id='" . ${"illness_name$i"} . "',modified_by = '" . $_SESSION['user_id'] . "'" . $end_query;
|
|
|
|
error_log("map update/insert query " . $query);
|
|
if (!$result = @mysqli_query($conn, $query)) {
|
|
error_log("Failed to Update the mapping. Error Found" . mysqli_error($conn) . ". Failing Query:" . $query);
|
|
exit(mysqli_error($conn));
|
|
}
|
|
}
|
|
}
|
|
$response = array_unique($response);
|
|
error_log("data " . print_r($response, true));
|
|
echo json_encode($response);
|