<?php
session_start();
include "dbconnect.php";

// Check if ID is passed
if (!isset($_GET['id'])) {
    echo "<script>alert('No applicant selected for deletion.'); window.location.href='approvallistedit.php';</script>";
    exit;
}

$applicant_id = intval($_GET['id']);

// Get the file path before deleting
$sql = "SELECT file_upload FROM work_permit_approval WHERE applicant_id = ?";
$stmt = $con->prepare($sql);
$stmt->bind_param("i", $applicant_id);
$stmt->execute();
$result = $stmt->get_result();

if ($result->num_rows == 0) {
    echo "<script>alert('No record found to delete.'); window.location.href='approvallistedit.php';</script>";
    exit;
}

$row = $result->fetch_assoc();
$file_path = $row['file_upload'];

// Delete the record
$delete_sql = "DELETE FROM work_permit_approval WHERE applicant_id = ?";
$stmt_delete = $con->prepare($delete_sql);
$stmt_delete->bind_param("i", $applicant_id);

if ($stmt_delete->execute()) {
    // Delete file if exists
    if (!empty($file_path) && file_exists($file_path)) {
        unlink($file_path);
    }

    echo "<script>alert('Record deleted successfully.'); window.location.href='approvallistdelete.php';</script>";
} else {
    echo "<script>alert('Failed to delete record.'); window.location.href='approvallistdelete.php';</script>";
}
?>
