<?php
session_start();

if (!isset($_SESSION['user_id'])) {
    header("Location: login.php");
    exit();
}

require_once 'db_connection.php';

if (!isset($_GET['id'])) {
    $_SESSION['error'] = "Category ID is required.";
    header("Location: base.php");
    exit();
}

$categoryId = intval($_GET['id']);

try {
    $stmt = $conn->prepare("DELETE FROM expense_categories WHERE id = ?");
    $stmt->bind_param("i", $categoryId);
    $stmt->execute();
    $stmt->close();
    $_SESSION['success'] = "Expense category deleted successfully!";
} catch (Exception $e) {
    $_SESSION['error'] = "Cannot delete category. It may have expense heads or expenses.";
    error_log("Delete category error: " . $e->getMessage());
}

header("Location: base.php");
exit();
?>