81 lines
3.8 KiB
PHP
81 lines
3.8 KiB
PHP
<?php
|
|
include('includes/config/config.php');
|
|
include('includes/functions.php');
|
|
include('log_entry.php');
|
|
|
|
$response = array('success' => false);
|
|
|
|
if ($_SERVER['REQUEST_METHOD'] === 'POST') {
|
|
|
|
$bene_detail_id = mysqli_real_escape_string($conn, $_POST['bene_detail_id']);
|
|
$beneficiary = mysqli_real_escape_string($conn, $_POST['beneficiary']);
|
|
$drip_date = mysqli_real_escape_string($conn, $_POST['drip_date']);
|
|
$ggrc_no = mysqli_real_escape_string($conn, $_POST['ggrc_no']);
|
|
$name_of_site = mysqli_real_escape_string($conn, $_POST['name_of_site']);
|
|
$case_no = mysqli_real_escape_string($conn, $_POST['case_no']);
|
|
$category = mysqli_real_escape_string($conn, $_POST['category']);
|
|
$diagnosis = mysqli_real_escape_string($conn, $_POST['diagnosis']);
|
|
$roleCode = "'".$_SESSION['RoleCode']."'";
|
|
$ohcTypeId = $_SESSION['current_ohcttype'];
|
|
|
|
if (!empty($bene_detail_id)) {
|
|
// Update existing record
|
|
$sql = "UPDATE beneficiary_medical_add_details
|
|
SET beneficiary = '$beneficiary',drip_date = '$drip_date',name_of_site='$name_of_site',category='$category',diagnosis='$diagnosis',case_no='$case_no',ggrc_no='$ggrc_no', RoleCode = $roleCode, ohc_type_id = $ohcTypeId
|
|
WHERE id = $bene_detail_id";
|
|
error_log($sql . " dipak mali beneficiary_medical_add_details");
|
|
if (mysqli_query($conn, $sql)) {
|
|
$response['success'] = true;
|
|
$response['message'] = 'Record updated successfully';
|
|
} else {
|
|
$response['error'] = 'Error updating data into beneficiary_medical_add_details table: ' . mysqli_error($conn);
|
|
}
|
|
} else {
|
|
// Insert new record
|
|
$sql = "INSERT INTO beneficiary_medical_add_details (beneficiary, drip_date,ggrc_no,case_no,category,diagnosis,name_of_site, RoleCode, ohc_type_id)
|
|
VALUES ('$beneficiary', '$drip_date','$ggrc_no','$case_no','$category','$diagnosis','$name_of_site',$roleCode, '$ohcTypeId')";
|
|
error_log($sql . " dipak mali beneficiary_medical_add_details");
|
|
if (mysqli_query($conn, $sql)) {
|
|
$beneId = mysqli_insert_id($conn);
|
|
$response['success'] = true;
|
|
$response['message'] = 'Record inserted successfully';
|
|
} else {
|
|
$response['error'] = 'Error inserting data into beneficiary_medical_add_details table: ' . mysqli_error($conn);
|
|
}
|
|
}
|
|
|
|
// Handle form key-value pairs
|
|
if ($response['success']) {
|
|
$sql = "DELETE FROM beneficiary_medical_form_key_value WHERE bene_detail_id = " . ($bene_detail_id ?: $beneId);
|
|
if (!mysqli_query($conn, $sql)) {
|
|
error_log('Error deleting old form key-value pairs: ' . mysqli_error($conn));
|
|
$response['error'] = 'Error deleting old form key-value pairs';
|
|
} else {
|
|
foreach ($_POST as $key => $value) {
|
|
if (in_array($key, ['beneficiary', 'program', 'role_code', 'ohc_type_id', 'bene_detail_id'])) {
|
|
continue;
|
|
}
|
|
|
|
$formKeyId = $key;
|
|
$formValue = $value;
|
|
|
|
$sql = "INSERT INTO beneficiary_medical_form_key_value (bene_detail_id, bene_form_key, checkup_form_value)
|
|
VALUES (" . ($bene_detail_id ?: $beneId) . ", '$formKeyId', '$formValue')";
|
|
error_log($sql . " dipak mali beneficiary_medical_form_key_value");
|
|
if (!mysqli_query($conn, $sql)) {
|
|
error_log('Error executing statement: ' . mysqli_error($conn));
|
|
$response['error'] = 'Error executing statement for form key ' . $formKeyId;
|
|
break;
|
|
}
|
|
}
|
|
}
|
|
}
|
|
} else {
|
|
$response['error'] = 'Invalid request method.';
|
|
}
|
|
|
|
// Return JSON response
|
|
header('Content-Type: application/json');
|
|
echo json_encode($response);
|
|
?>
|