Enhanced PHP File Manager

⬆️ Go Up (..)

📊 Server Information

Server:

LiteSpeed

System:

Linux 5.14.0-503.34.1.el9_5.x86_64

PHP Version:

8.2.30

User:

u329947844

Directory:

/home/u329947844/domains/style29.in/public_html/admin

Free Space:

10.3 TB

🔧 Quick Actions

✏️ Editing: delete-offer.php

<?php
include('includes/db.php');

// Start session if not already started
if (session_status() === PHP_SESSION_NONE) {
    session_start();
}

// Check if offer ID is provided
if (!isset($_GET['id']) || empty($_GET['id'])) {
    $_SESSION['flash_message'] = 'Offer ID is missing!';
    $_SESSION['flash_type'] = 'danger';
    header('Location: manage-offers.php');
    exit();
}

$offer_id = (int)$_GET['id'];

// Check if offer exists and get details for confirmation message
$check_sql = "SELECT o.*, 
                     c.category_name,
                     p.product_name,
                     CASE 
                         WHEN o.apply_to = 'category' THEN c.category_name
                         WHEN o.apply_to = 'product' THEN p.product_name
                         ELSE 'All Products'
                     END as target_name
              FROM offers o
              LEFT JOIN categories c ON o.category_id = c.id
              LEFT JOIN products p ON o.product_id = p.id
              WHERE o.id = ?";
$check_stmt = mysqli_prepare($conn, $check_sql);
mysqli_stmt_bind_param($check_stmt, "i", $offer_id);
mysqli_stmt_execute($check_stmt);
$result = mysqli_stmt_get_result($check_stmt);
$offer = mysqli_fetch_assoc($result);

if (!$offer) {
    $_SESSION['flash_message'] = 'Offer not found!';
    $_SESSION['flash_type'] = 'danger';
    header('Location: manage-offers.php');
    exit();
}

// Handle confirmation and deletion
if ($_SERVER['REQUEST_METHOD'] === 'POST') {
    // Verify confirmation
    if (isset($_POST['confirm_delete']) && $_POST['confirm_delete'] === 'yes') {
        
        // Optional: Log the deletion for audit purposes
        $offer_title = mysqli_real_escape_string($conn, $offer['offer_title']);
        $log_sql = "INSERT INTO deletion_logs (table_name, record_id, record_details, deleted_by, deleted_at) 
                    VALUES ('offers', ?, ?, 'admin', NOW())";
        $log_stmt = mysqli_prepare($conn, $log_sql);
        $record_details = "Offer: {$offer_title} (ID: {$offer_id})";
        mysqli_stmt_bind_param($log_stmt, "is", $offer_id, $record_details);
        mysqli_stmt_execute($log_stmt);
        mysqli_stmt_close($log_stmt);
        
        // Delete the offer
        $delete_sql = "DELETE FROM offers WHERE id = ?";
        $delete_stmt = mysqli_prepare($conn, $delete_sql);
        mysqli_stmt_bind_param($delete_stmt, "i", $offer_id);

if (mysqli_stmt_execute($delete_stmt)) {
            $_SESSION['flash_message'] = 'Offer deleted successfully!';
            $_SESSION['flash_type'] = 'success';
        } else {
            $_SESSION['flash_message'] = 'Error deleting offer: ' . mysqli_error($conn);
            $_SESSION['flash_type'] = 'danger';
        }
        
        mysqli_stmt_close($delete_stmt);
    } else {
        $_SESSION['flash_message'] = 'Offer deletion cancelled.';
        $_SESSION['flash_type'] = 'info';
    }
    
    header('Location: manage-offers.php');
    exit();
}

// If not POST, show confirmation page
?>

<!doctype html>
<html lang="en">

<?php include('includes/head.php'); ?>

<?php include('includes/pre-loader.php'); ?>

<div id="layout-wrapper">

<?php include('includes/topbar.php'); ?>

<div class="vertical-menu">
        <div data-simplebar class="h-100">
            <?php include('includes/sidebar.php'); ?>
        </div>
    </div>

<div class="main-content">
        <div class="page-content">
            <div class="container-fluid">

<div class="row">
                    <div class="col-12">
                        <div class="page-title-box d-sm-flex align-items-center justify-content-between">
                            <h4 class="mb-sm-0">Delete Offer</h4>
                            <div class="page-title-right">
                                <ol class="breadcrumb m-0">
                                    <li class="breadcrumb-item"><a href="javascript: void(0);">Offers</a></li>
                                    <li class="breadcrumb-item"><a href="manage-offers.php">Manage Offers</a></li>
                                    <li class="breadcrumb-item active">Delete Offer</li>
                                </ol>
                            </div>
                        </div>
                    </div>
                </div>

<div class="row">
                    <div class="col-xl-12">
                        <div class="card delete-card">
                            <div class="card-body text-center">
                                
                                
                                <div class="mb-4">
                                    <i class="fas fa-exclamation-triangle warning-icon"></i>
                                </div>

<h4 class="card-title text-danger mb-3">Confirm Offer Deletion</h4>
                                <p class="lead mb-4">Are you sure you want to delete this offer? This action cannot be undone.</p>

<div class="offer-details text-start">
                                    <h6 class="mb-3">Offer Details:</h6>
                                    
                                    <div class="detail-item">
                                        <span class="detail-label">Offer Title:</span>
                                        <span class="detail-value"><?php echo htmlspecialchars($offer['offer_title']); ?></span>
                                    </div>
                                    
                                    <div class="detail-item">
                                        <span class="detail-label">Offer Type:</span>
                                        <span class="detail-value">
                                            <?php
                                            $type_names = [
                                                'percentage' => 'Percentage Discount',
                                                'fixed' => 'Fixed Amount Discount',
                                                'bogo' => 'Buy One Get One',
                                                'combo' => 'Combo Offer',
                                                'special' => 'Special Price'
                                            ];
                                            echo $type_names[$offer['offer_type']] ?? $offer['offer_type'];
                                            ?>
                                        </span>
                                    </div>
                                    
                                    <div class="detail-item">
                                        <span class="detail-label">Discount Value:</span>
                                        <span class="detail-value">
                                            <?php
                                            switch($offer['offer_type']) {
                                                case 'percentage':
                                                    echo $offer['discount_value'] . '%';
                                                    break;
                                                case 'fixed':
                                                    echo '₹' . number_format($offer['discount_value'], 2);
                                                    break;
                                                default:
                                                    echo ucfirst($offer['offer_type']);
                                            }
                                            ?>
                                        </span>
                                    </div>
                                    
                                    <div class="detail-item">
                                        <span class="detail-label">Apply To:</span>
                                        <span class="detail-value">
                                            <?php
                                            $apply_names = [
                                                'all_products' => 'All Products',
                                                'category' => 'Specific Category',
                                                'product' => 'Specific Product'
                                            ];
                                            echo $apply_names[$offer['apply_to']] ?? $offer['apply_to'];
                                            ?>
                                        </span>
                                    </div>
                                    
                                    <div class="detail-item">
                                        <span class="detail-label">Target:</span>
                                        <span class="detail-value"><?php echo htmlspecialchars($offer['target_name']); ?></span>
                                    </div>
                                    
                                    <div class="detail-item">
                                        <span class="detail-label">Times Used:</span>
                                        <span class="detail-value"><?php echo $offer['times_used']; ?> times</span>
                                    </div>
                                    
                                    <div class="detail-item">
                                        <span class="detail-label">Created:</span>
                                        <span class="detail-value"><?php echo date('M j, Y g:i A', strtotime($offer['created_at'])); ?></span>
                                    </div>
                                </div>

<div class="alert alert-warning text-start">
                                    <h6 class="alert-heading"><i class="fas fa-exclamation-circle me-2"></i>Important Notice</h6>
                                    <ul class="mb-0 ps-3">
                                        <li>This action is permanent and cannot be undone</li>
                                        <li>Any active usage of this offer will be immediately disabled</li>
                                        <li>Sales history referencing this offer will remain intact</li>
                                        <li>Consider deactivating the offer instead if you might need it later</li>
                                    </ul>
                                </div>

<form method="POST" id="deleteForm">
                                    <div class="row justify-content-center">
                                        <div class="col-md-8">
                                            <div class="mb-3">
                                                <label for="confirmText" class="form-label">
                                                    Type <strong>"DELETE"</strong> to confirm:
                                                </label>
                                                <input type="text" class="form-control text-center" 
                                                       id="confirmText" name="confirm_text" 
                                                       placeholder="Type DELETE here" required
                                                       oninput="validateConfirmation(this)">
                                                <div class="form-text">This extra step prevents accidental deletion.</div>
                                            </div>
                                        </div>
                                    </div>

<div class="d-flex justify-content-center gap-3 mt-4">
                                        <button type="submit" class="btn btn-danger btn-lg px-5" id="deleteBtn" disabled>
                                            <i class="fas fa-trash me-2"></i>Delete Offer
                                        </button>
                                        <a href="manage-offers.php" class="btn btn-secondary btn-lg px-5">
                                            <i class="fas fa-times me-2"></i>Cancel
                                        </a>
                                    </div>

<div class="mt-3">
                                        <a href="view-offer.php?id=<?php echo $offer_id; ?>" class="text-muted">
                                            <i class="fas fa-eye me-1"></i>View offer details before deleting
                                        </a>
                                    </div>
                                </form>

</div>
                        </div>
                    </div>
                </div>

</div>
        </div>

<?php include('includes/footer.php'); ?>
    </div>

</div>

<?php include('includes/rightbar.php'); ?>
<?php include('includes/scripts.php'); ?>

</body>
</html>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: delete-offer.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation