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

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

<?php include('includes/head.php'); ?>
<?php include('includes/db.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">Edit 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">Edit Offer</li>
                                </ol>
                            </div>
                        </div>
                    </div>
                </div>

<div class="row">
                    <div class="col-xl-12">
                        <div class="card">
                            <div class="card-body">
                                <h4 class="card-title mb-4">Edit Offer</h4>

<?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'];
                                $offer = null;

// Fetch offer data
                                $sql = "SELECT o.*, c.category_name, p.product_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();
                                }

// Handle form submission
                                if ($_SERVER['REQUEST_METHOD'] == 'POST') {
                                    $offer_title = mysqli_real_escape_string($conn, $_POST['offer_title']);
                                    $offer_type = mysqli_real_escape_string($conn, $_POST['offer_type']);
                                    $discount_value = (float)$_POST['discount_value'];
                                    $apply_to = mysqli_real_escape_string($conn, $_POST['apply_to']);
                                    $category_id = isset($_POST['category_id']) ? (int)$_POST['category_id'] : null;
                                    $product_id = isset($_POST['product_id']) ? (int)$_POST['product_id'] : null;
                                    $start_date = mysqli_real_escape_string($conn, $_POST['start_date']);
                                    $end_date = mysqli_real_escape_string($conn, $_POST['end_date']);
                                    $min_purchase = (float)$_POST['min_purchase'];
                                    $max_discount = (float)$_POST['max_discount'];
                                    $offer_description = mysqli_real_escape_string($conn, $_POST['offer_description']);
                                    $status = mysqli_real_escape_string($conn, $_POST['status']);
                                    $usage_limit = (int)$_POST['usage_limit'];

// Validate required fields
                                    if (empty($offer_title) || empty($offer_type) || empty($apply_to) || empty($start_date) || empty($end_date)) {
                                        $error = 'Please fill all required fields!';
                                    } else {
                                        // Validate dates
                                        $start_timestamp = strtotime($start_date);
                                        $end_timestamp = strtotime($end_date);
                                        
                                        if ($end_timestamp <= $start_timestamp) {
                                            $error = 'End date must be after start date!';
                                        } else {
                                            // Validate discount value for non-BOGO offers
                                            if ($offer_type !== 'bogo' && $discount_value <= 0) {
                                                $error = 'Please enter a valid discount value!';
                                            } else if ($offer_type === 'percentage' && $discount_value > 100) {
                                                $error = 'Percentage discount cannot exceed 100%!';
                                            } else {
                                                // Validate conditional fields
                                                if ($apply_to === 'category' && empty($category_id)) {
                                                    $error = 'Please select a category!';
                                                } else if ($apply_to === 'product' && empty($product_id)) {
                                                    $error = 'Please select a product!';
                                                } else {
                                                    // Update offer
                                                    $update_sql = "UPDATE offers SET 
                                                                  offer_title = ?, 
                                                                  offer_type = ?, 
                                                                  discount_value = ?, 
                                                                  apply_to = ?, 
                                                                  category_id = ?, 
                                                                  product_id = ?, 
                                                                  start_date = ?, 
                                                                  end_date = ?, 
                                                                  min_purchase = ?, 
                                                                  max_discount = ?, 
                                                                  offer_description = ?, 
                                                                  status = ?, 
                                                                  usage_limit = ? 
                                                                  WHERE id = ?";
                                                    
                                                    $update_stmt = mysqli_prepare($conn, $update_sql);
                                                    mysqli_stmt_bind_param($update_stmt, "ssdssiissddssi", 
                                                        $offer_title, $offer_type, $discount_value, $apply_to, $category_id, 
                                                        $product_id, $start_date, $end_date, $min_purchase, $max_discount, 
                                                        $offer_description, $status, $usage_limit, $offer_id
                                                    );

if (mysqli_stmt_execute($update_stmt)) {
                                                        // Refresh offer data after update
                                                        $refresh_sql = "SELECT o.*, c.category_name, p.product_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 = ?";
                                                        $refresh_stmt = mysqli_prepare($conn, $refresh_sql);
                                                        mysqli_stmt_bind_param($refresh_stmt, "i", $offer_id);
                                                        mysqli_stmt_execute($refresh_stmt);
                                                        $refresh_result = mysqli_stmt_get_result($refresh_stmt);
                                                        $offer = mysqli_fetch_assoc($refresh_result);
                                                        mysqli_stmt_close($refresh_stmt);
                                                        
                                                        $success = 'Offer updated successfully!';
                                                    } else {
                                                        $error = 'Error updating offer: ' . mysqli_error($conn);
                                                    }
                                                    mysqli_stmt_close($update_stmt);
                                                }
                                            }
                                        }
                                    }
                                }
                                ?>

<?php if (isset($success)): ?>
                                    <div class="alert alert-success alert-dismissible fade show" role="alert">
                                        <?php echo $success; ?>
                                        <button type="button" class="btn-close" data-bs-dismiss="alert"></button>
                                    </div>
                                <?php endif; ?>

<?php if (isset($error)): ?>
                                    <div class="alert alert-danger alert-dismissible fade show" role="alert">
                                        <?php echo $error; ?>
                                        <button type="button" class="btn-close" data-bs-dismiss="alert"></button>
                                    </div>
                                <?php endif; ?>

<form action="edit-offer.php?id=<?php echo $offer_id; ?>" method="POST" id="offerForm">
                                    <div class="row">
                                        
                                        <div class="col-md-6 mb-3">
                                            <div class="form-group">
                                                <label for="offerTitle" class="form-label">Offer Title *</label>
                                                <input type="text" id="offerTitle" name="offer_title" class="form-control" required 
                                                       value="<?php echo htmlspecialchars($offer['offer_title']); ?>"
                                                       placeholder="e.g., Summer Sale, Festival Discount">
                                            </div>
                                        </div>

<div class="col-md-6 mb-3">
                                            <div class="form-group">
                                                <label for="offerType" class="form-label">Offer Type *</label>
                                                <select id="offerType" name="offer_type" class="form-control" required>
                                                    <option value="">-- Select Offer Type --</option>
                                                    <option value="percentage" <?php echo $offer['offer_type'] == 'percentage' ? 'selected' : ''; ?>>Percentage Discount</option>
                                                    <option value="fixed" <?php echo $offer['offer_type'] == 'fixed' ? 'selected' : ''; ?>>Fixed Amount Discount</option>
                                                    <option value="bogo" <?php echo $offer['offer_type'] == 'bogo' ? 'selected' : ''; ?>>Buy One Get One</option>
                                                    <option value="combo" <?php echo $offer['offer_type'] == 'combo' ? 'selected' : ''; ?>>Combo Offer</option>
                                                    <option value="special" <?php echo $offer['offer_type'] == 'special' ? 'selected' : ''; ?>>Special Price</option>
                                                </select>
                                            </div>
                                        </div>
                                    </div>

<div class="row">
                                        
                                        <div class="col-md-6 mb-3">
                                            <div class="form-group">
                                                <label for="discountValue" class="form-label">Discount Value *</label>
                                                <div class="input-group">
                                                    <input type="number" id="discountValue" name="discount_value" class="form-control" 
                                                           step="0.01" min="0" required 
                                                           value="<?php echo $offer['discount_value']; ?>"
                                                           placeholder="e.g., 10">
                                                    <span class="input-group-text" id="discountSuffix">
                                                        <?php echo $offer['offer_type'] == 'percentage' ? '%' : ($offer['offer_type'] == 'fixed' ? '₹' : ''); ?>
                                                    </span>
                                                </div>
                                                <small class="form-text text-muted" id="discountHelp">
                                                    <?php
                                                    if ($offer['offer_type'] == 'percentage') {
                                                        echo 'Enter percentage discount (e.g., 10 for 10%)';
                                                    } elseif ($offer['offer_type'] == 'fixed') {
                                                        echo 'Enter fixed discount amount in rupees';
                                                    } elseif ($offer['offer_type'] == 'bogo') {
                                                        echo 'For BOGO offers, this field is not used';
                                                    } else {
                                                        echo 'Enter discount value';
                                                    }
                                                    ?>
                                                </small>
                                            </div>
                                        </div>

<div class="col-md-6 mb-3">
                                            <div class="form-group">
                                                <label for="applyTo" class="form-label">Apply Offer To *</label>
                                                <select id="applyTo" name="apply_to" class="form-control" required>
                                                    <option value="">-- Select Target --</option>
                                                    <option value="all_products" <?php echo $offer['apply_to'] == 'all_products' ? 'selected' : ''; ?>>All Products</option>
                                                    <option value="category" <?php echo $offer['apply_to'] == 'category' ? 'selected' : ''; ?>>Specific Category</option>
                                                    <option value="product" <?php echo $offer['apply_to'] == 'product' ? 'selected' : ''; ?>>Specific Product</option>
                                                </select>
                                            </div>
                                        </div>
                                    </div>

<div class="row" id="categorySection" style="display: <?php echo $offer['apply_to'] == 'category' ? 'block' : 'none'; ?>;">
                                        <div class="col-md-6 mb-3">
                                            <div class="form-group">
                                                <label for="offerCategory" class="form-label">Select Category *</label>
                                                <select id="offerCategory" name="category_id" class="form-control" <?php echo $offer['apply_to'] == 'category' ? 'required' : ''; ?>>
                                                    <option value="">-- Select Category --</option>
                                                    <?php
                                                    $catQuery = "SELECT id, category_name FROM categories WHERE status = 'active' ORDER BY category_name ASC";
                                                    $catResult = mysqli_query($conn, $catQuery);
                                                    if ($catResult && mysqli_num_rows($catResult) > 0) {
                                                        while ($catRow = mysqli_fetch_assoc($catResult)) {
                                                            $selected = ($catRow['id'] == $offer['category_id']) ? 'selected' : '';
                                                            echo "<option value='{$catRow['id']}' {$selected}>" . htmlspecialchars($catRow['category_name']) . "</option>";
                                                        }
                                                    } else {
                                                        echo "<option value=''>No categories found</option>";
                                                    }
                                                    ?>
                                                </select>
                                            </div>
                                        </div>
                                    </div>

<div class="row" id="productSection" style="display: <?php echo $offer['apply_to'] == 'product' ? 'block' : 'none'; ?>;">
                                        <div class="col-md-6 mb-3">
                                            <div class="form-group">
                                                <label for="offerProduct" class="form-label">Select Product *</label>
                                                <select id="offerProduct" name="product_id" class="form-control" <?php echo $offer['apply_to'] == 'product' ? 'required' : ''; ?>>
                                                    <option value="">-- Select Product --</option>
                                                    <?php
                                                    $prodQuery = "SELECT id, product_name FROM products WHERE quantity > 0 ORDER BY product_name ASC";
                                                    $prodResult = mysqli_query($conn, $prodQuery);
                                                    if ($prodResult && mysqli_num_rows($prodResult) > 0) {
                                                        while ($prodRow = mysqli_fetch_assoc($prodResult)) {
                                                            $selected = ($prodRow['id'] == $offer['product_id']) ? 'selected' : '';
                                                            echo "<option value='{$prodRow['id']}' {$selected}>" . htmlspecialchars($prodRow['product_name']) . "</option>";
                                                        }
                                                    } else {
                                                        echo "<option value=''>No products found</option>";
                                                    }
                                                    ?>
                                                </select>
                                            </div>
                                        </div>
                                    </div>

<div class="row">
                                        
                                        <div class="col-md-6 mb-3">
                                            <div class="form-group">
                                                <label for="startDate" class="form-label">Start Date *</label>
                                                <input type="datetime-local" id="startDate" name="start_date" class="form-control" 
                                                       value="<?php echo date('Y-m-d\TH:i', strtotime($offer['start_date'])); ?>" required>
                                            </div>
                                        </div>

<div class="col-md-6 mb-3">
                                            <div class="form-group">
                                                <label for="endDate" class="form-label">End Date *</label>
                                                <input type="datetime-local" id="endDate" name="end_date" class="form-control" 
                                                       value="<?php echo date('Y-m-d\TH:i', strtotime($offer['end_date'])); ?>" required>
                                            </div>
                                        </div>
                                    </div>

<div class="row">
                                        
                                        <div class="col-md-6 mb-3">
                                            <div class="form-group">
                                                <label for="minPurchase" class="form-label">Minimum Purchase Amount (₹)</label>
                                                <div class="input-group">
                                                    <span class="input-group-text">₹</span>
                                                    <input type="number" id="minPurchase" name="min_purchase" class="form-control" 
                                                           step="0.01" min="0" 
                                                           value="<?php echo $offer['min_purchase']; ?>"
                                                           placeholder="0 for no minimum">
                                                </div>
                                                <small class="form-text text-muted">Minimum cart value to apply this offer</small>
                                            </div>
                                        </div>

<div class="col-md-6 mb-3">
                                            <div class="form-group">
                                                <label for="maxDiscount" class="form-label">Maximum Discount (₹)</label>
                                                <div class="input-group">
                                                    <span class="input-group-text">₹</span>
                                                    <input type="number" id="maxDiscount" name="max_discount" class="form-control" 
                                                           step="0.01" min="0" 
                                                           value="<?php echo $offer['max_discount']; ?>"
                                                           placeholder="0 for no limit">
                                                </div>
                                                <small class="form-text text-muted">Maximum discount amount (for percentage offers)</small>
                                            </div>
                                        </div>
                                    </div>

<div class="row">
                                        
                                        <div class="col-md-12 mb-3">
                                            <div class="form-group">
                                                <label for="offerDescription" class="form-label">Offer Description</label>
                                                <textarea id="offerDescription" name="offer_description" class="form-control" 
                                                          rows="3" placeholder="Describe the offer details..."><?php echo htmlspecialchars($offer['offer_description']); ?></textarea>
                                            </div>
                                        </div>
                                    </div>

<div class="row">
                                        
                                        <div class="col-md-6 mb-3">
                                            <div class="form-group">
                                                <label for="offerStatus" class="form-label">Status</label>
                                                <select id="offerStatus" name="status" class="form-control" required>
                                                    <option value="active" <?php echo $offer['status'] == 'active' ? 'selected' : ''; ?>>Active</option>
                                                    <option value="inactive" <?php echo $offer['status'] == 'inactive' ? 'selected' : ''; ?>>Inactive</option>
                                                    <option value="scheduled" <?php echo $offer['status'] == 'scheduled' ? 'selected' : ''; ?>>Scheduled</option>
                                                </select>
                                            </div>
                                        </div>

<div class="col-md-6 mb-3">
                                            <div class="form-group">
                                                <label for="usageLimit" class="form-label">Usage Limit</label>
                                                <input type="number" id="usageLimit" name="usage_limit" class="form-control" 
                                                       min="0" 
                                                       value="<?php echo $offer['usage_limit']; ?>"
                                                       placeholder="0 for unlimited">
                                                <small class="form-text text-muted">Maximum number of times this offer can be used</small>
                                            </div>
                                        </div>
                                    </div>

<div class="row">
                                        <div class="col-md-12 mb-3">
                                            <div class="alert alert-info">
                                                <strong>Usage Statistics:</strong><br>
                                                Times Used: <strong><?php echo $offer['times_used']; ?></strong><br>
                                                Created: <strong><?php echo date('M j, Y g:i A', strtotime($offer['created_at'])); ?></strong><br>
                                                Last Updated: <strong><?php echo date('M j, Y g:i A', strtotime($offer['updated_at'])); ?></strong>
                                            </div>
                                        </div>
                                    </div>

<div class="form-row mt-4">
                                        <div class="col-md-12 text-center">
                                            <button type="submit" class="btn btn-primary btn-lg px-5">Update Offer</button>
                                            <a href="manage-offers.php" class="btn btn-secondary btn-lg px-5">Cancel</a>
                                            <a href="view-offer.php?id=<?php echo $offer_id; ?>" class="btn btn-info btn-lg px-5">View Offer</a>
                                        </div>
                                    </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'); ?>

// Handle offer type changes
    offerType.addEventListener('change', function() {
        const type = this.value;
        
        switch(type) {
            case 'percentage':
                discountSuffix.textContent = '%';
                discountHelp.textContent = 'Enter percentage discount (e.g., 10 for 10%)';
                discountValue.placeholder = 'e.g., 10';
                discountValue.disabled = false;
                break;
            case 'fixed':
                discountSuffix.textContent = '₹';
                discountHelp.textContent = 'Enter fixed discount amount in rupees';
                discountValue.placeholder = 'e.g., 50';
                discountValue.disabled = false;
                break;
            case 'bogo':
                discountSuffix.textContent = '';
                discountHelp.textContent = 'For BOGO offers, this field is not used';
                discountValue.placeholder = 'Not applicable';
                discountValue.value = '';
                discountValue.disabled = true;
                break;
            case 'combo':
            case 'special':
                discountSuffix.textContent = '₹';
                discountHelp.textContent = 'Enter special price or combo discount amount';
                discountValue.placeholder = 'e.g., 100';
                discountValue.disabled = false;
                break;
            default:
                discountSuffix.textContent = '%';
                discountHelp.textContent = 'Enter discount value';
                discountValue.placeholder = 'e.g., 10';
                discountValue.disabled = false;
        }
    });

// Handle apply to changes
    applyTo.addEventListener('change', function() {
        const target = this.value;
        
        // Hide all sections first
        categorySection.style.display = 'none';
        productSection.style.display = 'none';
        
        // Remove required attributes
        document.getElementById('offerCategory').removeAttribute('required');
        document.getElementById('offerProduct').removeAttribute('required');
        
        // Show relevant section
        switch(target) {
            case 'category':
                categorySection.style.display = 'block';
                document.getElementById('offerCategory').setAttribute('required', 'required');
                break;
            case 'product':
                productSection.style.display = 'block';
                document.getElementById('offerProduct').setAttribute('required', 'required');
                break;
            default:
                // For all products, hide both sections
                categorySection.style.display = 'none';
                productSection.style.display = 'none';
        }
    });

// Form validation
    form.addEventListener('submit', function(e) {
        const startDate = new Date(document.getElementById('startDate').value);
        const endDate = new Date(document.getElementById('endDate').value);
        const now = new Date();

// Check if end date is after start date
        if (endDate <= startDate) {
            alert('End date must be after start date!');
            e.preventDefault();
            document.getElementById('endDate').focus();
            return;
        }

// Validate discount value for non-BOGO offers
        const offerTypeValue = offerType.value;
        const discountValueNum = parseFloat(discountValue.value) || 0;
        
        if (offerTypeValue !== 'bogo') {
            if (discountValueNum <= 0) {
                alert('Please enter a valid discount value!');
                e.preventDefault();
                discountValue.focus();
                return;
            }

if (offerTypeValue === 'percentage' && discountValueNum > 100) {
                alert('Percentage discount cannot exceed 100%!');
                e.preventDefault();
                discountValue.focus();
                return;
            }
        }

// Validate conditional fields
        const applyToValue = applyTo.value;
        if (applyToValue === 'category' && !document.getElementById('offerCategory').value) {
            alert('Please select a category!');
            e.preventDefault();
            document.getElementById('offerCategory').focus();
            return;
        }

if (applyToValue === 'product' && !document.getElementById('offerProduct').value) {
            alert('Please select a product!');
            e.preventDefault();
            document.getElementById('offerProduct').focus();
            return;
        }
    });

// Auto focus on first field
    document.getElementById('offerTitle').focus();
});
</script>

</body>
</html>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: edit-offer.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation