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: view-offer.php

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

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

.status-active { border-left-color: #28a745; }
.status-expired { border-left-color: #dc3545; }
.status-scheduled { border-left-color: #ffc107; }
.status-inactive { border-left-color: #6c757d; }

.info-item {
    padding: 8px 0;
    border-bottom: 1px solid #f8f9fa;
}
.info-item:last-child {
    border-bottom: none;
}
.info-label {
    font-weight: 600;
    color: #495057;
    min-width: 150px;
}
.info-value {
    color: #6c757d;
}
.discount-badge {
    font-size: 1.5rem;
    font-weight: 700;
    padding: 10px 20px;
}
</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">View Offer Details</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">View Offer</li>
                                </ol>
                            </div>
                        </div>
                    </div>
                </div>

<?php
                // Check if offer ID is provided
                if (!isset($_GET['id']) || empty($_GET['id'])) {
                    echo '<div class="alert alert-danger">Offer ID is missing!</div>';
                    echo '<a href="manage-offers.php" class="btn btn-secondary">Back to Offers</a>';
                    exit();
                }

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

// Fetch offer data with details
                $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 = ?";
                $stmt = mysqli_prepare($conn, $sql);
                mysqli_stmt_bind_param($stmt, "i", $offer_id);
                mysqli_stmt_execute($stmt);
                $result = mysqli_stmt_get_result($stmt);
                $offer = mysqli_fetch_assoc($result);
                mysqli_stmt_close($stmt);

if (!$offer) {
                    echo '<div class="alert alert-danger">Offer not found!</div>';
                    echo '<a href="manage-offers.php" class="btn btn-secondary">Back to Offers</a>';
                    exit();
                }

// Determine current status based on dates
                $now = time();
                $start_ts = strtotime($offer['start_date']);
                $end_ts = strtotime($offer['end_date']);
                
                $actual_status = $offer['status'];
                $status_class = '';
                $status_badge = '';

if ($offer['status'] === 'active' && $now > $end_ts) {
                    $actual_status = 'expired';
                    $status_class = 'status-expired';
                    $status_badge = '<span class="badge badge-soft-danger">Expired</span>';
                } elseif ($offer['status'] === 'scheduled' && $now >= $start_ts && $now <= $end_ts) {
                    $actual_status = 'active';
                    $status_class = 'status-active';
                    $status_badge = '<span class="badge badge-soft-success">Active</span>';
                } elseif ($offer['status'] === 'scheduled' && $now > $end_ts) {
                    $actual_status = 'expired';
                    $status_class = 'status-expired';
                    $status_badge = '<span class="badge badge-soft-danger">Expired</span>';
                } else {
                    switch($offer['status']) {
                        case 'active':
                            $status_class = 'status-active';
                            $status_badge = '<span class="badge badge-soft-success">Active</span>';
                            break;
                        case 'scheduled':
                            $status_class = 'status-scheduled';
                            $status_badge = '<span class="badge badge-soft-warning">Scheduled</span>';
                            break;
                        case 'inactive':
                            $status_class = 'status-inactive';
                            $status_badge = '<span class="badge badge-soft-secondary">Inactive</span>';
                            break;
                    }
                }

// Format dates
                $start_date_formatted = date('F j, Y g:i A', strtotime($offer['start_date']));
                $end_date_formatted = date('F j, Y g:i A', strtotime($offer['end_date']));
                $created_date = date('F j, Y g:i A', strtotime($offer['created_at']));
                $updated_date = date('F j, Y g:i A', strtotime($offer['updated_at']));

// Calculate time remaining if active or scheduled
                $time_remaining = '';
                if (($actual_status === 'active' || $offer['status'] === 'scheduled') && $now < $end_ts) {
                    $diff = $end_ts - $now;
                    $days = floor($diff / (60 * 60 * 24));
                    $hours = floor(($diff % (60 * 60 * 24)) / (60 * 60));
                    $time_remaining = "{$days} days, {$hours} hours";
                }

// Offer type display
                $type_badge = '';
                $discount_display = '';
                switch($offer['offer_type']) {
                    case 'percentage':
                        $type_badge = '<span class="badge badge-soft-info">Percentage Discount</span>';
                        $discount_display = $offer['discount_value'] . '% OFF';
                        break;
                    case 'fixed':
                        $type_badge = '<span class="badge badge-soft-info">Fixed Amount Discount</span>';
                        $discount_display = '₹' . number_format($offer['discount_value'], 2) . ' OFF';
                        break;
                    case 'bogo':
                        $type_badge = '<span class="badge badge-soft-info">Buy One Get One</span>';
                        $discount_display = 'BOGO OFFER';
                        break;
                    case 'combo':
                        $type_badge = '<span class="badge badge-soft-info">Combo Offer</span>';
                        $discount_display = 'COMBO OFFER';
                        break;
                    case 'special':
                        $type_badge = '<span class="badge badge-soft-info">Special Price</span>';
                        $discount_display = 'SPECIAL PRICE';
                        break;
                }

// Apply to display
                $apply_badge = '';
                switch($offer['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">Specific Category</span>';
                        break;
                    case 'product':
                        $apply_badge = '<span class="badge badge-soft-primary">Specific Product</span>';
                        break;
                }

// Usage display
                $usage_display = $offer['times_used'];
                if ($offer['usage_limit'] > 0) {
                    $usage_display .= ' / ' . $offer['usage_limit'];
                    $usage_percentage = ($offer['times_used'] / $offer['usage_limit']) * 100;
                } else {
                    $usage_display .= ' / ∞';
                    $usage_percentage = 0;
                }
                ?>

<div class="row">
                    <div class="col-xl-8">
                        <div class="card offer-card <?php echo $status_class; ?>">
                            <div class="card-body">
                                <div class="d-flex justify-content-between align-items-start mb-4">
                                    <div>
                                        <h4 class="card-title mb-1"><?php echo htmlspecialchars($offer['offer_title']); ?></h4>
                                        <div class="d-flex gap-2 mb-2">
                                            <?php echo $type_badge; ?>
                                            <?php echo $status_badge; ?>
                                        </div>
                                    </div>
                                    <div class="text-end">
                                        <div class="discount-badge badge bg-primary text-white">
                                            <?php echo $discount_display; ?>
                                        </div>
                                    </div>
                                </div>

<?php if (!empty($offer['offer_description'])): ?>
                                    <div class="alert alert-light bg-light border-0 mb-4">
                                        <h6 class="alert-heading mb-2">Description:</h6>
                                        <p class="mb-0"><?php echo nl2br(htmlspecialchars($offer['offer_description'])); ?></p>
                                    </div>
                                <?php endif; ?>

<div class="row">
                                    <div class="col-md-6">
                                        <div class="info-item d-flex justify-content-between">
                                            <span class="info-label">Offer Type:</span>
                                            <span class="info-value"><?php echo $type_badge; ?></span>
                                        </div>
                                        <div class="info-item d-flex justify-content-between">
                                            <span class="info-label">Apply To:</span>
                                            <span class="info-value"><?php echo $apply_badge; ?></span>
                                        </div>
                                        <div class="info-item d-flex justify-content-between">
                                            <span class="info-label">Target:</span>
                                            <span class="info-value"><?php echo htmlspecialchars($offer['target_name']); ?></span>
                                        </div>
                                        <div class="info-item d-flex justify-content-between">
                                            <span class="info-label">Discount Value:</span>
                                            <span class="info-value font-weight-bold"><?php echo $discount_display; ?></span>
                                        </div>
                                    </div>
                                    <div class="col-md-6">
                                        <div class="info-item d-flex justify-content-between">
                                            <span class="info-label">Start Date:</span>
                                            <span class="info-value"><?php echo $start_date_formatted; ?></span>
                                        </div>
                                        <div class="info-item d-flex justify-content-between">
                                            <span class="info-label">End Date:</span>
                                            <span class="info-value"><?php echo $end_date_formatted; ?></span>
                                        </div>
                                        <?php if (!empty($time_remaining)): ?>
                                            <div class="info-item d-flex justify-content-between">
                                                <span class="info-label">Time Remaining:</span>
                                                <span class="info-value text-success"><?php echo $time_remaining; ?></span>
                                            </div>
                                        <?php endif; ?>
                                        <div class="info-item d-flex justify-content-between">
                                            <span class="info-label">Current Status:</span>
                                            <span class="info-value"><?php echo $status_badge; ?></span>
                                        </div>
                                    </div>
                                </div>
                            </div>
                        </div>

<div class="card mt-3">
                            <div class="card-body">
                                <h5 class="card-title mb-3">Offer Conditions</h5>
                                <div class="row">
                                    <div class="col-md-6">
                                        <div class="info-item d-flex justify-content-between">
                                            <span class="info-label">Minimum Purchase:</span>
                                            <span class="info-value">
                                                <?php echo $offer['min_purchase'] > 0 ? '₹' . number_format($offer['min_purchase'], 2) : 'No minimum'; ?>
                                            </span>
                                        </div>
                                    </div>
                                    <div class="col-md-6">
                                        <div class="info-item d-flex justify-content-between">
                                            <span class="info-label">Maximum Discount:</span>
                                            <span class="info-value">
                                                <?php echo $offer['max_discount'] > 0 ? '₹' . number_format($offer['max_discount'], 2) : 'No limit'; ?>
                                            </span>
                                        </div>
                                    </div>
                                </div>
                                <div class="row">
                                    <div class="col-md-6">
                                        <div class="info-item d-flex justify-content-between">
                                            <span class="info-label">Usage Limit:</span>
                                            <span class="info-value">
                                                <?php echo $offer['usage_limit'] > 0 ? $offer['usage_limit'] . ' times' : 'Unlimited'; ?>
                                            </span>
                                        </div>
                                    </div>
                                    <div class="col-md-6">
                                        <div class="info-item d-flex justify-content-between">
                                            <span class="info-label">Times Used:</span>
                                            <span class="info-value font-weight-bold"><?php echo $offer['times_used']; ?></span>
                                        </div>
                                    </div>
                                </div>

<?php if ($offer['usage_limit'] > 0): ?>
                                    <div class="mt-3">
                                        <label class="form-label mb-2">Usage Progress:</label>
                                        <div class="progress" style="height: 8px;">
                                            <div class="progress-bar <?php echo $usage_percentage >= 100 ? 'bg-danger' : 'bg-success'; ?>" 
                                                 role="progressbar" 
                                                 style="width: <?php echo min($usage_percentage, 100); ?>%;" 
                                                 aria-valuenow="<?php echo $usage_percentage; ?>" 
                                                 aria-valuemin="0" 
                                                 aria-valuemax="100">
                                            </div>
                                        </div>
                                        <small class="text-muted"><?php echo number_format($usage_percentage, 1); ?>% used (<?php echo $usage_display; ?>)</small>
                                    </div>
                                <?php endif; ?>
                            </div>
                        </div>
                    </div>

<div class="col-xl-4">
                        
                        <div class="card">
                            <div class="card-body">
                                <h5 class="card-title mb-3">Quick Stats</h5>
                                <div class="info-item d-flex justify-content-between">
                                    <span class="info-label">Created:</span>
                                    <span class="info-value"><?php echo $created_date; ?></span>
                                </div>
                                <div class="info-item d-flex justify-content-between">
                                    <span class="info-label">Last Updated:</span>
                                    <span class="info-value"><?php echo $updated_date; ?></span>
                                </div>
                                <div class="info-item d-flex justify-content-between">
                                    <span class="info-label">Database Status:</span>
                                    <span class="info-value"><?php echo ucfirst($offer['status']); ?></span>
                                </div>
                                <div class="info-item d-flex justify-content-between">
                                    <span class="info-label">Actual Status:</span>
                                    <span class="info-value"><?php echo ucfirst($actual_status); ?></span>
                                </div>
                                <div class="info-item d-flex justify-content-between">
                                    <span class="info-label">Offer ID:</span>
                                    <span class="info-value">#<?php echo $offer['id']; ?></span>
                                </div>
                            </div>
                        </div>

<div class="card mt-3">
                            <div class="card-body">
                                <h5 class="card-title mb-3">Actions</h5>
                                <div class="d-grid gap-2">
                                    <a href="edit-offer.php?id=<?php echo $offer_id; ?>" class="btn btn-warning">
                                        <i class="fas fa-edit me-2"></i>Edit Offer
                                    </a>
                                    <a href="manage-offers.php" class="btn btn-secondary">
                                        <i class="fas fa-arrow-left me-2"></i>Back to Offers
                                    </a>
                                    <a href="delete-offer.php?id=<?php echo $offer_id; ?>" 
                                       class="btn btn-danger" 
                                       onclick="return confirm('Are you sure you want to delete this offer? This action cannot be undone.');">
                                        <i class="fas fa-trash me-2"></i>Delete Offer
                                    </a>
                                </div>
                            </div>
                        </div>

<div class="card mt-3">
                            <div class="card-body">
                                <h5 class="card-title mb-3">Status Information</h5>
                                <div class="alert alert-<?php echo $actual_status === 'active' ? 'success' : ($actual_status === 'expired' ? 'danger' : 'warning'); ?> mb-0">
                                    <small>
                                        <strong>Current Status:</strong> <?php echo ucfirst($actual_status); ?><br>
                                        <?php if ($actual_status === 'active'): ?>
                                            This offer is currently active and can be used by customers.
                                        <?php elseif ($actual_status === 'expired'): ?>
                                            This offer has expired and is no longer valid.
                                        <?php elseif ($actual_status === 'scheduled'): ?>
                                            This offer is scheduled to become active in the future.
                                        <?php else: ?>
                                            This offer is currently inactive.
                                        <?php endif; ?>
                                    </small>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>

<div class="row mt-4">
                    <div class="col-12">
                        <div class="card">
                            <div class="card-body">
                                <h5 class="card-title mb-3">Customer View Preview</h5>
                                <div class="alert alert-info border-0">
                                    <div class="d-flex justify-content-between align-items-center">
                                        <div>
                                            <h6 class="alert-heading mb-1"><?php echo htmlspecialchars($offer['offer_title']); ?></h6>
                                            <p class="mb-0"><?php echo $discount_display; ?></p>
                                            <?php if (!empty($offer['offer_description'])): ?>
                                                <small class="text-muted"><?php echo htmlspecialchars($offer['offer_description']); ?></small>
                                            <?php endif; ?>
                                        </div>
                                        <div class="text-end">
                                            <small class="text-muted d-block">Valid until: <?php echo date('M j, Y', strtotime($offer['end_date'])); ?></small>
                                            <span class="badge bg-primary">Use Code: OFFER<?php echo $offer['id']; ?></span>
                                        </div>
                                    </div>
                                </div>
                                <small class="text-muted">This is how customers will see the offer in the application.</small>
                            </div>
                        </div>
                    </div>
                </div>

</div>
        </div>

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

</div>

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

// Add some interactive effects
    const offerCard = document.querySelector('.offer-card');
    if (offerCard) {
        offerCard.addEventListener('mouseenter', function() {
            this.style.transform = 'translateY(-2px)';
            this.style.boxShadow = '0 4px 15px rgba(0,0,0,0.1)';
        });
        
        offerCard.addEventListener('mouseleave', function() {
            this.style.transform = 'translateY(0)';
            this.style.boxShadow = 'none';
        });
    }
});
</script>

</body>
</html>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: view-offer.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation