<?php
include "dbconnect.php";

// Check if the form is submitted
if ($_SERVER['REQUEST_METHOD'] == 'POST') {
    // Get and sanitize the form input
    $id = $_POST['id'];
    $name = $con->real_escape_string($_POST['name']);
    $passport_no = $con->real_escape_string($_POST['passport_no']);
    $medical_date = $con->real_escape_string($_POST['medical_date']);
    $medical_exp_date = $con->real_escape_string($_POST['medical_exp_date']);
    $sleep = isset($_POST['sleep']) ? 1 : 0;

    // Handle file upload (if a file is selected)
    if (isset($_FILES['medical_upload']) && $_FILES['medical_upload']['error'] == UPLOAD_ERR_OK) {
        $medical_upload = $_FILES['medical_upload']['name'];
        $upload_dir = 'uploads/';
        $file_path = $upload_dir . basename($medical_upload);

        if (move_uploaded_file($_FILES['medical_upload']['tmp_name'], $file_path)) {
            // File upload successful, use the new file path
            $medical_upload = $file_path;
        } else {
            echo "Error uploading the file.";
            exit;
        }
    } else {
        // If no file is uploaded, keep the existing file path (fetch it from the database)
        $query = "SELECT medical_upload FROM medical_records WHERE applicant_id = $id";
        $result = $con->query($query);
        if ($result && $row = $result->fetch_assoc()) {
            $medical_upload = $row['medical_upload'];
        } else {
            $medical_upload = null;
        }
    }

    // Update the medical record in the medical_records table
    $sql = "UPDATE medical_records SET 
            medical_date = '$medical_date',
            medical_exp_date = '$medical_exp_date',
            medical_upload = '$medical_upload',
            sleep = '$sleep'
            WHERE applicant_id = $id";

    if ($con->query($sql)) {
        // Redirect to a page (e.g., a list of records) after successful update
        header("Location: medicallist.php");
        exit;
    } else {
        echo "Error updating record: " . $con->error;
    }
}
?>
