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: manage-offers.php

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

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

<link rel="stylesheet" href="https://cdn.datatables.net/1.13.7/css/jquery.dataTables.min.css">

<link rel="stylesheet" href="https://cdn.datatables.net/responsive/2.5.0/css/responsive.dataTables.min.css">

.offer-active { border-left: 4px solid #28a745; }
.offer-expired { border-left: 4px solid #dc3545; }
.offer-scheduled { border-left: 4px solid #ffc107; }
.offer-inactive { border-left: 4px solid #6c757d; }

.status-badge {
    font-size: 0.75rem;
    padding: 0.35em 0.65em;
}

.small-helper {
    font-size: 12px;
    color: #6c757d;
}

@media (max-width: 576px) {
    .btn-group-sm-stack > a { display: block; width: 100%; margin-bottom: 6px; }
}
</style>

<?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">Manage Offers</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 active">Manage Offers</li>
                                </ol>
                            </div>
                        </div>
                    </div>
                </div>

<div class="row">
                    <div class="col-xl-12">
                        <div class="card">
                            <div class="card-body">

<div class="d-flex justify-content-between align-items-center mb-4">
                                    <h4 class="card-title mb-0">All Offers</h4>
                                    <a href="add-offer.php" class="btn btn-primary">
                                        <i class="fas fa-plus me-1"></i> Add New Offer
                                    </a>
                                </div>

<p class="small-helper mb-4">Tip: Tap the <strong>#</strong> column on mobile to expand details.</p>

<?php if (isset($_GET['msg'])): ?>
                                    <div class="alert alert-<?php echo $_GET['type'] ?? 'info'; ?> alert-dismissible fade show">
                                        <?php echo htmlspecialchars($_GET['msg']); ?>
                                        <button type="button" class="btn-close" data-bs-dismiss="alert"></button>
                                    </div>
                                <?php endif; ?>

<table id="offersTable" class="table table-bordered table-striped display nowrap" style="width:100%">
                                    <thead>
                                        <tr>
                                            <th>#</th>
                                            <th>Offer Title</th>
                                            <th>Type</th>
                                            <th>Discount</th>
                                            <th>Apply To</th>
                                            <th>Target</th>
                                            <th>Date Range</th>
                                            <th>Status</th>
                                            <th>Usage</th>
                                            <th>Created</th>
                                            <th>Actions</th>
                                        </tr>
                                    </thead>
                                    <tbody>
                                        <?php
                                        $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
                                                ORDER BY o.created_at DESC";
                                        $result = mysqli_query($conn, $sql);

if ($result && mysqli_num_rows($result) > 0) {
                                            $count = 1;
                                            while ($row = mysqli_fetch_assoc($result)) {
                                                $id = (int)$row['id'];
                                                $offer_title = htmlspecialchars($row['offer_title']);
                                                $offer_type = htmlspecialchars($row['offer_type']);
                                                $discount_value = (float)$row['discount_value'];
                                                $apply_to = htmlspecialchars($row['apply_to']);
                                                $target_name = htmlspecialchars($row['target_name'] ?? 'N/A');
                                                $start_date = $row['start_date'];
                                                $end_date = $row['end_date'];
                                                $status = htmlspecialchars($row['status']);
                                                $usage_limit = (int)$row['usage_limit'];
                                                $times_used = (int)$row['times_used'];
                                                $min_purchase = (float)$row['min_purchase'];
                                                $max_discount = (float)$row['max_discount'];
                                                $created_at = $row['created_at'];

// Determine current status based on dates
                                                $now = time();
                                                $start_ts = strtotime($start_date);
                                                $end_ts = strtotime($end_date);
                                                
                                                $actual_status = $status;
                                                if ($status === 'active' && $now > $end_ts) {
                                                    $actual_status = 'expired';
                                                } elseif ($status === 'scheduled' && $now >= $start_ts && $now <= $end_ts) {
                                                    $actual_status = 'active';
                                                } elseif ($status === 'scheduled' && $now > $end_ts) {
                                                    $actual_status = 'expired';
                                                }

// Status badge
                                                $status_badge = '';
                                                $row_class = '';
                                                switch($actual_status) {
                                                    case 'active':
                                                        $status_badge = '<span class="badge badge-soft-success status-badge">Active</span>';
                                                        $row_class = 'offer-active';
                                                        break;
                                                    case 'expired':
                                                        $status_badge = '<span class="badge badge-soft-danger status-badge">Expired</span>';
                                                        $row_class = 'offer-expired';
                                                        break;
                                                    case 'scheduled':
                                                        $status_badge = '<span class="badge badge-soft-warning status-badge">Scheduled</span>';
                                                        $row_class = 'offer-scheduled';
                                                        break;
                                                    case 'inactive':
                                                        $status_badge = '<span class="badge badge-soft-secondary status-badge">Inactive</span>';
                                                        $row_class = 'offer-inactive';
                                                        break;
                                                }

// Offer type badge
                                                $type_badge = '';
                                                switch($offer_type) {
                                                    case 'percentage':
                                                        $type_badge = '<span class="badge badge-soft-info">Percentage</span>';
                                                        $discount_display = $discount_value . '%';
                                                        break;
                                                    case 'fixed':
                                                        $type_badge = '<span class="badge badge-soft-info">Fixed</span>';
                                                        $discount_display = '₹' . $discount_value;
                                                        break;
                                                    case 'bogo':
                                                        $type_badge = '<span class="badge badge-soft-info">BOGO</span>';
                                                        $discount_display = 'BOGO';
                                                        break;
                                                    case 'combo':
                                                        $type_badge = '<span class="badge badge-soft-info">Combo</span>';
                                                        $discount_display = 'Combo';
                                                        break;
                                                    case 'special':
                                                        $type_badge = '<span class="badge badge-soft-info">Special</span>';
                                                        $discount_display = 'Special';
                                                        break;
                                                    default:
                                                        $type_badge = '<span class="badge badge-soft-secondary">' . $offer_type . '</span>';
                                                        $discount_display = $discount_value;
                                                }

// Apply to badge
                                                $apply_badge = '';
                                                switch($apply_to) {
                                                    case 'all_products':
                                                        $apply_badge = '<span class="badge badge-soft-success">All Products</span>';
                                                        break;
                                                    case 'category':
                                                        $apply_badge = '<span class="badge badge-soft-warning">Category</span>';
                                                        break;
                                                    case 'product':
                                                        $apply_badge = '<span class="badge badge-soft-primary">Product</span>';
                                                        break;
                                                }

// Date range display
                                                $date_display = date('M j, Y', strtotime($start_date)) . ' to ' . date('M j, Y', strtotime($end_date));
                                                
                                                // Usage display
                                                $usage_display = $times_used;
                                                if ($usage_limit > 0) {
                                                    $usage_display .= ' / ' . $usage_limit;
                                                } else {
                                                    $usage_display .= ' / ∞';
                                                }

// Created date
                                                $created_display = date('M j, Y', strtotime($created_at));

echo "<tr class='{$row_class}'>
                                                        <td>{$count}</td>
                                                        <td><strong>{$offer_title}</strong></td>
                                                        <td>{$type_badge}</td>
                                                        <td>{$discount_display}</td>
                                                        <td>{$apply_badge}</td>
                                                        <td>{$target_name}</td>
                                                        <td>
                                                            <small class='text-muted'>{$date_display}</small>
                                                        </td>
                                                        <td>{$status_badge}</td>
                                                        <td>
                                                            <small>{$usage_display}</small>
                                                            " . ($min_purchase > 0 ? "<br><small class='text-muted'>Min: ₹{$min_purchase}</small>" : "") . "
                                                            " . ($max_discount > 0 ? "<br><small class='text-muted'>Max: ₹{$max_discount}</small>" : "") . "
                                                        </td>
                                                        <td>{$created_display}</td>
                                                        <td class='btn-group-sm-stack'>
                                                            <a href='edit-offer.php?id={$id}' class='btn btn-sm btn-warning mb-1'>Edit</a>
                                                            <a href='view-offer.php?id={$id}' class='btn btn-sm btn-info mb-1'>View</a>
                                                            <a href='delete-offer.php?id={$id}' class='btn btn-sm btn-danger' onclick=\"return confirm('Are you sure you want to delete this offer?');\">Delete</a>
                                                        </td>
                                                      </tr>";
                                                $count++;
                                            }
                                        } else {
                                            echo "<tr><td colspan='11' class='text-center'>No offers found</td></tr>";
                                        }
                                        ?>
                                    </tbody>
                                </table>

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

</div>
        </div>

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

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

<script src="https://code.jquery.com/jquery-3.7.1.min.js"></script>
<script src="https://cdn.datatables.net/1.13.7/js/jquery.dataTables.min.js"></script>
<script src="https://cdn.datatables.net/responsive/2.5.0/js/dataTables.responsive.min.js"></script>

// Auto-refresh status badges every minute
    setInterval(function() {
        location.reload();
    }, 60000); // Refresh every 60 seconds to update statuses
});
</script>

</body>
</html>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: manage-offers.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation