prepare("UPDATE leave_applications SET status=? WHERE id=?");
$stmt->bind_param("si", $st, $id);
$stmt->execute();
$message = "Leave application marked as {$st}!";
}
}
// Handle Leave Delete
if (isset($_GET['delete_leave'])) {
$id = intval($_GET['delete_leave']);
$conn->query("DELETE FROM leave_applications WHERE id = $id");
$message = "Leave application deleted successfully!";
}
// Handle TC Status Update
if (isset($_GET['tc_status']) && isset($_GET['id'])) {
$id = intval($_GET['id']);
$st = trim($_GET['tc_status']);
if (in_array($st, ['Under Process', 'Approved & Ready', 'Issued', 'Rejected'])) {
$stmt = $conn->prepare("UPDATE tc_applications SET status=? WHERE id=?");
$stmt->bind_param("si", $st, $id);
$stmt->execute();
$message = "TC application status updated to {$st}!";
}
}
// Handle TC Delete
if (isset($_GET['delete_tc'])) {
$id = intval($_GET['delete_tc']);
$conn->query("DELETE FROM tc_applications WHERE id = $id");
$message = "TC application deleted successfully!";
}
// Handle Admission Delete
if (isset($_GET['delete_adm'])) {
$id = intval($_GET['delete_adm']);
$conn->query("DELETE FROM admission_enquiries WHERE id = $id");
$message = "Admission enquiry deleted successfully!";
}
// Active Tab
$tab = $_GET['tab'] ?? 'leave';
// Fetch Counts
$pending_leaves = $conn->query("SELECT COUNT(*) as c FROM leave_applications WHERE status = 'Pending'")->fetch_assoc()['c'] ?? 0;
$total_leaves = $conn->query("SELECT COUNT(*) as c FROM leave_applications")->fetch_assoc()['c'] ?? 0;
$total_tc = $conn->query("SELECT COUNT(*) as c FROM tc_applications")->fetch_assoc()['c'] ?? 0;
$total_adm = $conn->query("SELECT COUNT(*) as c FROM admission_enquiries")->fetch_assoc()['c'] ?? 0;
// Fetch Data based on active tab
$leave_rows = $conn->query("SELECT * FROM leave_applications ORDER BY id DESC");
$tc_rows = $conn->query("SELECT * FROM tc_applications ORDER BY id DESC");
$adm_rows = $conn->query("SELECT * FROM admission_enquiries ORDER BY id DESC");
?>
Student Applications Box | BSPS Admin