Tiny File Manager

Back Back Up Advanced Editor

<?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>

// 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>