<?php
// Database connection
include_once("header.php");

// Define tables and respective date columns
$tableDateColumns = [
    "card_log" => "created_at",
    "history_work" => "order_time",
    "logsn" => "created_at",
    "order_list" => "order_time",
    "tin_data" => "created_at",
    "server_copy" => "created_at"
];

// Bengali table names
$tableNamesBn = [
    "card_log" => "📌 āĻ†āĻ‡āĻĄāĻŋ āĻ•āĻžāĻ°ā§āĻĄ āĻ˛āĻŋāĻˇā§āĻŸ",
    "history_work" => "📜 āĻ•āĻžāĻœā§‡āĻ° āĻšāĻŋāĻ¸ā§āĻŸā§‹āĻ°āĻŋ āĻ˛āĻŋāĻˇā§āĻŸ",
    "logsn" => "📂 āĻ¨āĻŋāĻŦāĻ¨ā§āĻ§āĻ¨ āĻ˛āĻŋāĻˇā§āĻŸ",
    "order_list" => "đŸ“Ļ āĻ…āĻ°ā§āĻĄāĻžāĻ° āĻ˛āĻŋāĻˇā§āĻŸ",
    "tin_data" => "🗃ī¸ āĻŸāĻŋāĻ¨ āĻĄāĻžāĻŸāĻž āĻ˛āĻŋāĻˇā§āĻŸ",
    "server_copy" => "💾 āĻ¸āĻžāĻ°ā§āĻ­āĻžāĻ° āĻ•āĻĒāĻŋ āĻ˛āĻŋāĻˇā§āĻŸ"
];

// Allowed days in Bengali
$validDays = [1, 3, 5, 7, 15];
$validDaysBn = [
    1 => "ā§§ āĻĻāĻŋāĻ¨",
    3 => "ā§Š āĻĻāĻŋāĻ¨",
    5 => "ā§Ģ āĻĻāĻŋāĻ¨",
    7 => "ā§­ āĻĻāĻŋāĻ¨",
    15 => "ā§§ā§Ģ āĻĻāĻŋāĻ¨"
];

// Initialize response variables
$message = "";
$alertClass = "";

// Handle Form Submission
if ($_SERVER["REQUEST_METHOD"] == "POST") {
    $days = isset($_POST['days']) ? intval($_POST['days']) : 7;
    $selectedTable = isset($_POST['table']) ? $_POST['table'] : "";

    if (!in_array($days, $validDays)) {
        $message = "⚠ī¸ āĻ…āĻŦā§ˆāĻ§ āĻĻāĻŋāĻ¨ā§‡āĻ° āĻ¸āĻ‚āĻ–ā§āĻ¯āĻž āĻ¨āĻŋāĻ°ā§āĻŦāĻžāĻšāĻ¨ āĻ•āĻ°āĻž āĻšāĻ¯āĻŧā§‡āĻ›ā§‡!";
        $alertClass = "alert-danger";
    } elseif (!array_key_exists($selectedTable, $tableDateColumns)) {
        $message = "⚠ī¸ āĻ…āĻŦā§ˆāĻ§ āĻŸā§‡āĻŦāĻŋāĻ˛ āĻ¨āĻŋāĻ°ā§āĻŦāĻžāĻšāĻ¨ āĻ•āĻ°āĻž āĻšāĻ¯āĻŧā§‡āĻ›ā§‡!";
        $alertClass = "alert-danger";
    } else {
        // Get correct date column
        $dateColumn = $tableDateColumns[$selectedTable];

        // Prepare & Execute SQL Query
        $sql = "DELETE FROM `$selectedTable` WHERE `$dateColumn` < NOW() - INTERVAL ? DAY";
        $stmt = $conn->prepare($sql);
        $stmt->bind_param("i", $days);

        if ($stmt->execute()) {
            $message = "✅ <b>{$tableNamesBn[$selectedTable]}</b> āĻĨā§‡āĻ•ā§‡ <b>$validDaysBn[$days]</b> āĻĻāĻŋāĻ¨ā§‡āĻ° āĻŦā§‡āĻļāĻŋ āĻĒā§āĻ°āĻ¨ā§‹ āĻ°ā§‡āĻ•āĻ°ā§āĻĄ āĻ¸āĻĢāĻ˛āĻ­āĻžāĻŦā§‡ āĻŽā§āĻ›ā§‡ āĻĢā§‡āĻ˛āĻž āĻšāĻ¯āĻŧā§‡āĻ›ā§‡!";
            $alertClass = "alert-success";
        } else {
            $message = "❌ āĻ¤ā§āĻ°ā§āĻŸāĻŋ: " . $stmt->error;
            $alertClass = "alert-danger";
        }
        $stmt->close();
    }
}

$conn->close();
?>

<!DOCTYPE html>
<html lang="bn">
<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title>āĻĄāĻžāĻŸāĻžāĻŦā§‡āĻ¸ āĻ•ā§āĻ˛āĻŋāĻ¨āĻžāĻ°</title>
    <link href="https://cdn.jsdelivr.net/npm/bootstrap@5.3.0/dist/css/bootstrap.min.css" rel="stylesheet">
    <style>
        body {
            background-color: #f4f6f9;
        }
        .container {
            max-width: 480px;
            margin-top: 50px;
            background: white;
            padding: 30px;
            border-radius: 12px;
            box-shadow: 0px 0px 15px rgba(0, 0, 0, 0.1);
        }
        h2 {
            font-weight: bold;
            color: #343a40;
            text-align: center;
            margin-bottom: 20px;
        }
        .btn-delete {
            background-color: #d9534f;
            color: white;
            font-weight: bold;
        }
        .btn-delete:hover {
            background-color: #c9302c;
        }
    </style>
</head>
<body>

<div class="container">
    <h2>🗑ī¸ āĻĒā§āĻ°āĻ¨ā§‹ āĻ°ā§‡āĻ•āĻ°ā§āĻĄ āĻŽā§āĻ›ā§āĻ¨</h2>

    <?php if (!empty($message)): ?>
        <div class="alert <?php echo $alertClass; ?>" role="alert">
            <?php echo $message; ?>
        </div>
    <?php endif; ?>

    <form id="deleteForm" method="POST">
        <div class="mb-3">
            <label for="table" class="form-label">📌 āĻŸā§‡āĻŦāĻŋāĻ˛ āĻ¨āĻŋāĻ°ā§āĻŦāĻžāĻšāĻ¨ āĻ•āĻ°ā§āĻ¨:</label>
            <select class="form-control" id="table" name="table" required>
                <option value="" disabled selected>đŸ”Ŋ āĻŸā§‡āĻŦāĻŋāĻ˛ āĻ¨āĻŋāĻ°ā§āĻŦāĻžāĻšāĻ¨ āĻ•āĻ°ā§āĻ¨</option>
                <?php foreach ($tableNamesBn as $table => $label): ?>
                    <option value="<?php echo $table; ?>"><?php echo $label; ?></option>
                <?php endforeach; ?>
            </select>
        </div>

        <div class="mb-3">
            <label for="days" class="form-label">📆 āĻĻāĻŋāĻ¨ āĻ¨āĻŋāĻ°ā§āĻŦāĻžāĻšāĻ¨ āĻ•āĻ°ā§āĻ¨:</label>
            <select class="form-control" id="days" name="days" required>
                <option value="" disabled selected>đŸ”Ŋ āĻĻāĻŋāĻ¨ āĻ¨āĻŋāĻ°ā§āĻŦāĻžāĻšāĻ¨ āĻ•āĻ°ā§āĻ¨</option>
                <?php foreach ($validDaysBn as $day => $label): ?>
                    <option value="<?php echo $day; ?>"><?php echo $label; ?></option>
                <?php endforeach; ?>
            </select>
        </div>

        <button type="submit" class="btn btn-delete w-100">🗑ī¸ āĻ°ā§‡āĻ•āĻ°ā§āĻĄ āĻŽā§āĻ›ā§āĻ¨</button>
    </form>
</div>

<script>
document.addEventListener("DOMContentLoaded", function() {
    document.getElementById("deleteForm").addEventListener("submit", function(event) {
        event.preventDefault(); // Prevent form submission

        // Get selected values
        let tableElement = document.getElementById("table");
        let daysElement = document.getElementById("days");

        let selectedTable = tableElement.options[tableElement.selectedIndex].text;
        let selectedDays = daysElement.options[daysElement.selectedIndex].text;

        // Show confirmation alert with selected table and days
        Swal.fire({
            title: "āĻ†āĻĒāĻ¨āĻŋ āĻ•āĻŋ āĻ¨āĻŋāĻļā§āĻšāĻŋāĻ¤?",
            html: `<b>📂 āĻŸā§‡āĻŦāĻŋāĻ˛:</b> ${selectedTable} <br> <b>📆 āĻĻāĻŋāĻ¨:</b> ${selectedDays}`,
            icon: "warning",
            showCancelButton: true,
            confirmButtonColor: "#d33",
            cancelButtonColor: "#3085d6",
            confirmButtonText: "✅ āĻšā§āĻ¯āĻžāĻ, āĻŽā§āĻ›ā§‡ āĻĢā§‡āĻ˛ā§āĻ¨!",
            cancelButtonText: "❌ āĻŦāĻžāĻ¤āĻŋāĻ˛ āĻ•āĻ°ā§āĻ¨"
        }).then((result) => {
            if (result.isConfirmed) {
                this.submit(); // Submit form if confirmed
            }
        });
    });
});

</script>

<script src="https://cdn.jsdelivr.net/npm/bootstrap@5.3.0/dist/js/bootstrap.bundle.min.js"></script>
</body>
</html>