<?php
include 'ominterior_db.php';

$id = $_GET['id'] ?? null;

if ($id && is_numeric($id)) {
    // 1. Check in project_list
    $stmt = $conn->prepare("SELECT id FROM project_list WHERE id = ?");
    $stmt->bind_param("i", $id);
    $stmt->execute();
    $stmt->store_result();

    if ($stmt->num_rows > 0) {
        $stmt->close();

        $deleteStmt = $conn->prepare("DELETE FROM project_list WHERE id = ?");
        $deleteStmt->bind_param("i", $id);
        if ($deleteStmt->execute()) {
            header("Location: project-list.php?msg=deleted");
            exit;
        } else {
            echo "Delete from project_list failed!";
        }
        $deleteStmt->close();

    } else {
        $stmt->close();

        // 2. Check in contact_us
        $stmt = $conn->prepare("SELECT id FROM contact_us WHERE id = ?");
        $stmt->bind_param("i", $id);
        $stmt->execute();
        $stmt->store_result();

        if ($stmt->num_rows > 0) {
            $stmt->close();

            $deleteStmt = $conn->prepare("DELETE FROM contact_us WHERE id = ?");
            $deleteStmt->bind_param("i", $id);
            if ($deleteStmt->execute()) {
                header("Location: contactus.php?msg=deleted");
                exit;
            } else {
                echo "Delete from contact_us failed!";
            }
            $deleteStmt->close();

        } else {
            $stmt->close();

            // 3. Check in menu
            $stmt = $conn->prepare("SELECT id FROM menu WHERE id = ?");
            $stmt->bind_param("i", $id);
            $stmt->execute();
            $stmt->store_result();

            if ($stmt->num_rows > 0) {
                $stmt->close();

                $deleteStmt = $conn->prepare("DELETE FROM menu WHERE id = ?");
                $deleteStmt->bind_param("i", $id);
                if ($deleteStmt->execute()) {
                    header("Location: menus.php?msg=deleted");
                    exit;
                } else {
                    echo "Delete from menu failed!";
                }
                $deleteStmt->close();

            } else {
                $stmt->close();

                // 4. Check in slider_images
                $stmt = $conn->prepare("SELECT slider_name FROM slider_images WHERE id = ?");
                $stmt->bind_param("i", $id);
                $stmt->execute();
                $stmt->bind_result($sliderName);
                if ($stmt->fetch()) {
                    $stmt->close();

                    $deleteStmt = $conn->prepare("DELETE FROM slider_images WHERE id = ?");
                    $deleteStmt->bind_param("i", $id);
                    if ($deleteStmt->execute()) {
                        $sliderFolder = "uploads/sliders/$sliderName/";
                        if (is_dir($sliderFolder)) {
                            $files = glob($sliderFolder . '*');
                            foreach ($files as $file) {
                                if (is_file($file)) {
                                    unlink($file);
                                }
                            }
                            rmdir($sliderFolder);
                        }

                        header("Location: gallery.php?msg=deleted");
                        exit;
                    } else {
                        echo "Delete from slider_images failed!";
                    }
                    $deleteStmt->close();

                } else {
                    $stmt->close();

                    // 5. Check in faq
                    $stmt = $conn->prepare("SELECT id FROM faq WHERE id = ?");
                    $stmt->bind_param("i", $id);
                    $stmt->execute();
                    $stmt->store_result();

                    if ($stmt->num_rows > 0) {
                        $stmt->close();

                        $deleteStmt = $conn->prepare("DELETE FROM faq WHERE id = ?");
                        $deleteStmt->bind_param("i", $id);
                        if ($deleteStmt->execute()) {
                            header("Location: faq.php?msg=deleted");
                            exit;
                        } else {
                            echo "Delete from faq failed!";
                        }
                        $deleteStmt->close();

                    } else {
                        echo "ID not found in any table!";
                    }
                }
            }
        }
    }
} else {
    echo "Invalid ID!";
}
?>