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/spmodern.in/public_html/admin

Free Space:

10.2 TB

🔧 Quick Actions

✏️ Editing: online-inventory.php

<!doctype html>
<html lang="en">
<?php
// ---------- server bootstrap ----------
include('includes/head.php');
include('includes/db.php');
if (session_status() === PHP_SESSION_NONE) session_start();

// Handle stock updates
$flashMsg = null; $flashType = 'info';
if ($_SERVER['REQUEST_METHOD'] === 'POST' && isset($_POST['action'])) {
    if ($_POST['action'] === 'update_stock') {
        $variantId = (int)$_POST['variant_id'];
        $newStock = (int)$_POST['stock'];
        
        $sql = "UPDATE online_product_variants SET stock = ? WHERE id = ?";
        $stmt = mysqli_prepare($conn, $sql);
        if ($stmt) {
            mysqli_stmt_bind_param($stmt, 'ii', $newStock, $variantId);
            
            if (mysqli_stmt_execute($stmt)) {
                $flashMsg = 'Stock updated successfully!';
                $flashType = 'success';
            } else {
                $flashMsg = 'Failed to update stock.';
                $flashType = 'danger';
            }
            mysqli_stmt_close($stmt);
        }
    } elseif ($_POST['action'] === 'bulk_update_stock') {
        $productId = (int)$_POST['product_id'];
        $stockChange = (int)$_POST['stock_change'];
        $operation = mysqli_real_escape_string($conn, $_POST['operation']);
        
        if ($operation === 'set') {
            $sql = "UPDATE online_product_variants SET stock = ? WHERE product_id = ?";
            $stmt = mysqli_prepare($conn, $sql);
            if ($stmt) {
                mysqli_stmt_bind_param($stmt, 'ii', $stockChange, $productId);
                mysqli_stmt_execute($stmt);
                mysqli_stmt_close($stmt);
            }
        } elseif ($operation === 'add') {
            $sql = "UPDATE online_product_variants SET stock = stock + ? WHERE product_id = ?";
            $stmt = mysqli_prepare($conn, $sql);
            if ($stmt) {
                mysqli_stmt_bind_param($stmt, 'ii', $stockChange, $productId);
                mysqli_stmt_execute($stmt);
                mysqli_stmt_close($stmt);
            }
        } elseif ($operation === 'subtract') {
            $sql = "UPDATE online_product_variants SET stock = GREATEST(0, stock - ?) WHERE product_id = ?";
            $stmt = mysqli_prepare($conn, $sql);
            if ($stmt) {
                mysqli_stmt_bind_param($stmt, 'ii', $stockChange, $productId);
                mysqli_stmt_execute($stmt);
                mysqli_stmt_close($stmt);
            }
        }
        
        $flashMsg = 'Bulk stock update completed!';
        $flashType = 'success';
    }
}

// Get filter parameters
$categoryFilter = isset($_GET['category']) ? (int)$_GET['category'] : 0;
$statusFilter = isset($_GET['status']) ? mysqli_real_escape_string($conn, $_GET['status']) : '';
$stockFilter = isset($_GET['stock']) ? mysqli_real_escape_string($conn, $_GET['stock']) : '';

// Build WHERE clause for filters
$whereConditions = [];
$params = [];
$types = '';

if ($categoryFilter > 0) {
    $whereConditions[] = "p.category_id = ?";
    $params[] = $categoryFilter;
    $types .= 'i';
}

if ($statusFilter) {
    $whereConditions[] = "p.status = ?";
    $params[] = $statusFilter;
    $types .= 's';
}

if ($stockFilter === 'low') {
    $whereConditions[] = "v.stock <= 10";
} elseif ($stockFilter === 'out') {
    $whereConditions[] = "v.stock = 0";
} elseif ($stockFilter === 'in_stock') {
    $whereConditions[] = "v.stock > 0";
}

$whereClause = '';
if (!empty($whereConditions)) {
    $whereClause = "WHERE " . implode(" AND ", $whereConditions);
}

// Fetch inventory data with variants
$sql = "SELECT 
            p.id as product_id,
            p.product_name,
            p.status as product_status,
            p.thumbnail_image,
            c.category_name,
            v.id as variant_id,
            v.size,
            v.color,
            v.stock,
            v.price,
            v.variant_image,
            (SELECT SUM(stock) FROM online_product_variants WHERE product_id = p.id) as total_stock
        FROM online_products p
        LEFT JOIN categories c ON p.category_id = c.id
        LEFT JOIN online_product_variants v ON p.id = v.product_id
        $whereClause
        ORDER BY p.product_name, v.size, v.color";

$stmt = mysqli_prepare($conn, $sql);
if (!empty($params)) {
    mysqli_stmt_bind_param($stmt, $types, ...$params);
}
mysqli_stmt_execute($stmt);
$result = mysqli_stmt_get_result($stmt);

$inventory = [];
$products = [];
$totalProducts = 0;
$totalStockValue = 0;
$lowStockCount = 0;
$outOfStockCount = 0;

while ($row = mysqli_fetch_assoc($result)) {
    $productId = $row['product_id'];
    
    if (!isset($products[$productId])) {
        $products[$productId] = [
            'product_name' => $row['product_name'],
            'product_status' => $row['product_status'],
            'thumbnail_image' => $row['thumbnail_image'],
            'category_name' => $row['category_name'],
            'total_stock' => $row['total_stock'],
            'variants' => []
        ];
        $totalProducts++;
    }
    
    if ($row['variant_id']) {
        $products[$productId]['variants'][] = [
            'variant_id' => $row['variant_id'],
            'size' => $row['size'],
            'color' => $row['color'],
            'stock' => $row['stock'],
            'price' => $row['price'],
            'variant_image' => $row['variant_image']
        ];
        
        // Calculate statistics
        $totalStockValue += $row['stock'] * $row['price'];
        if ($row['stock'] <= 10 && $row['stock'] > 0) {
            $lowStockCount++;
        } elseif ($row['stock'] == 0) {
            $outOfStockCount++;
        }
    }
}

mysqli_stmt_close($stmt);

// Fetch categories for filter
$categories = [];
$catQuery = mysqli_query($conn, "SELECT id, category_name FROM categories WHERE status = 'active' ORDER BY category_name");
while ($cat = mysqli_fetch_assoc($catQuery)) {
    $categories[] = $cat;
}

function h($v){ return htmlspecialchars((string)$v, ENT_QUOTES, 'UTF-8'); }
?>

<?php if (!empty($flashMsg)): ?>
          <div class="alert alert-<?php echo htmlspecialchars($flashType); ?> alert-dismissible fade show" role="alert">
            <?php echo htmlspecialchars($flashMsg); ?>
            <button type="button" class="btn-close" data-bs-dismiss="alert" aria-label="Close"></button>
          </div>
        <?php endif; ?>

<div class="d-flex align-items-center justify-content-between">
          <h4 class="mb-3">Online Inventory Management</h4>
          <a href="online-manage-products.php" class="btn btn-secondary">
            <i class="fas fa-box me-2"></i>Manage Products
          </a>
        </div>

<div class="row mb-4">
          <div class="col-md-3">
            <div class="card">
              <div class="card-body">
                <div class="d-flex align-items-center">
                  <div class="flex-grow-1">
                    <h4 class="mb-0"><?php echo $totalProducts; ?></h4>
                    <span class="text-muted">Total Products</span>
                  </div>
                  <div class="flex-shrink-0">
                    <div class="avatar-sm">
                      <span class="avatar-title bg-primary rounded-circle">
                        <i class="fas fa-box fs-4"></i>
                      </span>
                    </div>
                  </div>
                </div>
              </div>
            </div>
          </div>
          <div class="col-md-3">
            <div class="card">
              <div class="card-body">
                <div class="d-flex align-items-center">
                  <div class="flex-grow-1">
                    <h4 class="mb-0">₹<?php echo number_format($totalStockValue, 2); ?></h4>
                    <span class="text-muted">Total Stock Value</span>
                  </div>
                  <div class="flex-shrink-0">
                    <div class="avatar-sm">
                      <span class="avatar-title bg-success rounded-circle">
                        <i class="fas fa-rupee-sign fs-4"></i>
                      </span>
                    </div>
                  </div>
                </div>
              </div>
            </div>
          </div>
          <div class="col-md-3">
            <div class="card">
              <div class="card-body">
                <div class="d-flex align-items-center">
                  <div class="flex-grow-1">
                    <h4 class="mb-0 text-warning"><?php echo $lowStockCount; ?></h4>
                    <span class="text-muted">Low Stock (≤10)</span>
                  </div>
                  <div class="flex-shrink-0">
                    <div class="avatar-sm">
                      <span class="avatar-title bg-warning rounded-circle">
                        <i class="fas fa-exclamation-triangle fs-4"></i>
                      </span>
                    </div>
                  </div>
                </div>
              </div>
            </div>
          </div>
          <div class="col-md-3">
            <div class="card">
              <div class="card-body">
                <div class="d-flex align-items-center">
                  <div class="flex-grow-1">
                    <h4 class="mb-0 text-danger"><?php echo $outOfStockCount; ?></h4>
                    <span class="text-muted">Out of Stock</span>
                  </div>
                  <div class="flex-shrink-0">
                    <div class="avatar-sm">
                      <span class="avatar-title bg-danger rounded-circle">
                        <i class="fas fa-times-circle fs-4"></i>
                      </span>
                    </div>
                  </div>
                </div>
              </div>
            </div>
          </div>
        </div>

<div class="card filter-card mb-4">
          <div class="card-body">
            <h5 class="card-title">Filters</h5>
            <form method="get" class="row g-3">
              <div class="col-md-3">
                <label class="form-label">Category</label>
                <select class="form-select" name="category">
                  <option value="">All Categories</option>
                  <?php foreach ($categories as $category): ?>
                    <option value="<?php echo $category['id']; ?>" <?php echo $categoryFilter == $category['id'] ? 'selected' : ''; ?>>
                      <?php echo h($category['category_name']); ?>
                    </option>
                  <?php endforeach; ?>
                </select>
              </div>
              <div class="col-md-3">
                <label class="form-label">Product Status</label>
                <select class="form-select" name="status">
                  <option value="">All Status</option>
                  <option value="active" <?php echo $statusFilter === 'active' ? 'selected' : ''; ?>>Active</option>
                  <option value="inactive" <?php echo $statusFilter === 'inactive' ? 'selected' : ''; ?>>Inactive</option>
                </select>
              </div>
              <div class="col-md-3">
                <label class="form-label">Stock Status</label>
                <select class="form-select" name="stock">
                  <option value="">All Stock</option>
                  <option value="in_stock" <?php echo $stockFilter === 'in_stock' ? 'selected' : ''; ?>>In Stock</option>
                  <option value="low" <?php echo $stockFilter === 'low' ? 'selected' : ''; ?>>Low Stock (≤10)</option>
                  <option value="out" <?php echo $stockFilter === 'out' ? 'selected' : ''; ?>>Out of Stock</option>
                </select>
              </div>
              <div class="col-md-3">
                <label class="form-label">&nbsp;</label>
                <div class="d-grid gap-2">
                  <button type="submit" class="btn btn-primary">Apply Filters</button>
                  <a href="online-inventory.php" class="btn btn-outline-secondary">Clear Filters</a>
                </div>
              </div>
            </form>
          </div>
        </div>

<div class="card">
          <div class="card-body">
            <div class="d-flex justify-content-between align-items-center mb-3">
              <h5 class="mb-0">Product Inventory</h5>
              <div class="d-flex gap-2">
                <button id="exportBtn" class="btn btn-outline-secondary btn-sm">
                  <i class="fas fa-download me-1"></i>Export
                </button>
                <button class="btn btn-outline-primary btn-sm" data-bs-toggle="modal" data-bs-target="#bulkUpdateModal">
                  <i class="fas fa-edit me-1"></i>Bulk Update
                </button>
              </div>
            </div>

<?php if (!empty($products)): ?>
              <div class="table-responsive">
                <table id="inventoryTable" class="table table-bordered" style="width:100%">
                  <thead class="table-light">
                    <tr>
                      <th>Product</th>
                      <th>Category</th>
                      <th>Variant</th>
                      <th>Price</th>
                      <th>Stock</th>
                      <th>Status</th>
                      <th>Actions</th>
                    </tr>
                  </thead>
                  <tbody>
                    <?php foreach ($products as $productId => $product): ?>
                      <?php if (empty($product['variants'])): ?>
                        <tr class="stock-out">
                          <td>
                            <div class="d-flex align-items-center">
                              <img src="uploads/<?php echo h($product['thumbnail_image']); ?>" 
                                   class="product-image me-3" 
                                   alt="<?php echo h($product['product_name']); ?>"
                                   onerror="this.src='https://via.placeholder.com/50x50?text=No+Image'">
                              <div>
                                <strong><?php echo h($product['product_name']); ?></strong>
                                <div class="text-muted small">No variants</div>
                              </div>
                            </div>
                          </td>
                          <td><?php echo h($product['category_name']); ?></td>
                          <td colspan="3" class="text-center text-muted">No variants configured</td>
                          <td>
                            <span class="badge bg-<?php echo $product['product_status'] === 'active' ? 'success' : 'danger'; ?>">
                              <?php echo ucfirst(h($product['product_status'])); ?>
                            </span>
                          </td>
                          <td>
                            <a href="online-edit-product.php?id=<?php echo $productId; ?>" class="btn btn-sm btn-outline-primary">
                              <i class="fas fa-edit"></i>
                            </a>
                          </td>
                        </tr>
                      <?php else: ?>
                        <?php foreach ($product['variants'] as $index => $variant): ?>
                          <tr class="<?php 
                            echo $variant['stock'] == 0 ? 'stock-out' : 
                                 ($variant['stock'] <= 10 ? 'stock-low' : 'stock-ok'); 
                          ?>">
                            <?php if ($index === 0): ?>
                              <td rowspan="<?php echo count($product['variants']); ?>">
                                <div class="d-flex align-items-center">
                                  <img src="uploads/<?php echo h($product['thumbnail_image']); ?>" 
                                       class="product-image me-3" 
                                       alt="<?php echo h($product['product_name']); ?>"
                                       onerror="this.src='https://via.placeholder.com/50x50?text=No+Image'">
                                  <div>
                                    <strong><?php echo h($product['product_name']); ?></strong>
                                    <div class="text-muted small">ID: <?php echo $productId; ?></div>
                                  </div>
                                </div>
                              </td>
                              <td rowspan="<?php echo count($product['variants']); ?>">
                                <?php echo h($product['category_name']); ?>
                              </td>
                            <?php endif; ?>
                            <td>
                              <div class="d-flex align-items-center">
                                <?php if ($variant['variant_image']): ?>
                                  <img src="uploads/<?php echo h($variant['variant_image']); ?>" 
                                       class="variant-image me-2" 
                                       alt="<?php echo h($variant['size'] . ' ' . $variant['color']); ?>"
                                       onerror="this.style.display='none'">
                                <?php endif; ?>
                                <div>
                                  <strong><?php echo h($variant['size']); ?></strong>
                                  <div class="d-flex align-items-center">
                                    <span class="color-swatch" style="background-color: <?php
                                      $colorMap = [
                                        'Black' => '#000000',
                                        'White' => '#FFFFFF',
                                        'Red' => '#FF0000',
                                        'Blue' => '#0000FF',
                                        'Green' => '#008000',
                                        'Yellow' => '#FFFF00'
                                      ];
                                      echo $colorMap[$variant['color']] ?? '#CCCCCC';
                                    ?>"></span>
                                    <?php echo h($variant['color']); ?>
                                  </div>
                                </div>
                              </div>
                            </td>
                            <td>
                              <strong>₹<?php echo number_format($variant['price'], 2); ?></strong>
                            </td>
                            <td>
                              <form method="post" class="d-inline">
                                <input type="hidden" name="action" value="update_stock">
                                <input type="hidden" name="variant_id" value="<?php echo $variant['variant_id']; ?>">
                                <div class="input-group input-group-sm">
                                  <input type="number" class="form-control stock-input" name="stock" 
                                         value="<?php echo (int)$variant['stock']; ?>" min="0" required>
                                  <button type="submit" class="btn btn-outline-primary" title="Update Stock">
                                    <i class="fas fa-save"></i>
                                  </button>
                                </div>
                              </form>
                            </td>
                            <?php if ($index === 0): ?>
                              <td rowspan="<?php echo count($product['variants']); ?>">
                                <span class="badge bg-<?php echo $product['product_status'] === 'active' ? 'success' : 'danger'; ?>">
                                  <?php echo ucfirst(h($product['product_status'])); ?>
                                </span>
                              </td>
                              <td rowspan="<?php echo count($product['variants']); ?>">
                                <div class="d-flex flex-column gap-1">
                                  <a href="online-edit-product.php?id=<?php echo $productId; ?>" class="btn btn-sm btn-outline-primary" title="Edit Product">
                                    <i class="fas fa-edit"></i>
                                  </a>
                                  <a href="online-view-product.php?id=<?php echo $productId; ?>" class="btn btn-sm btn-outline-info" title="View Product">
                                    <i class="fas fa-eye"></i>
                                  </a>
                                </div>
                              </td>
                            <?php endif; ?>
                          </tr>
                        <?php endforeach; ?>
                      <?php endif; ?>
                    <?php endforeach; ?>
                  </tbody>
                </table>
              </div>
            <?php else: ?>
              <div class="text-center py-5">
                <i class="fas fa-boxes fa-3x text-muted mb-3"></i>
                <h5>No Inventory Found</h5>
                <p class="text-muted">No products match your current filters.</p>
                <a href="online-inventory.php" class="btn btn-primary">Clear Filters</a>
              </div>
            <?php endif; ?>
          </div>
        </div>

</div>
    </div>

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

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

<div class="modal fade" id="bulkUpdateModal" tabindex="-1" aria-labelledby="bulkUpdateLabel" aria-hidden="true">
  <div class="modal-dialog">
    <form method="post" class="modal-content">
      <div class="modal-header">
        <h5 class="modal-title" id="bulkUpdateLabel">Bulk Stock Update</h5>
        <button type="button" class="btn-close" data-bs-dismiss="modal" aria-label="Close"></button>
      </div>
      <div class="modal-body">
        <input type="hidden" name="action" value="bulk_update_stock">
        
        <div class="mb-3">
          <label class="form-label">Select Product</label>
          <select class="form-select" name="product_id" required>
            <option value="">Choose Product</option>
            <?php foreach ($products as $productId => $product): ?>
              <option value="<?php echo $productId; ?>">
                <?php echo h($product['product_name']); ?> (<?php echo h($product['category_name']); ?>)
              </option>
            <?php endforeach; ?>
          </select>
        </div>
        
        <div class="mb-3">
          <label class="form-label">Operation</label>
          <select class="form-select" name="operation" id="bulkOperation" required>
            <option value="set">Set to specific value</option>
            <option value="add">Add quantity</option>
            <option value="subtract">Subtract quantity</option>
          </select>
        </div>
        
        <div class="mb-3">
          <label class="form-label">Quantity</label>
          <input type="number" class="form-control" name="stock_change" min="0" required>
          <div class="form-text" id="operationHelp">
            Set all variants to this stock quantity
          </div>
        </div>
      </div>
      <div class="modal-footer">
        <button type="button" class="btn btn-light" data-bs-dismiss="modal">Cancel</button>
        <button type="submit" class="btn btn-primary">Update Stock</button>
      </div>
    </form>
  </div>
</div>

<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>
document.addEventListener('DOMContentLoaded', function() {
    // Initialize DataTable
    $('#inventoryTable').DataTable({
        pageLength: 25,
        order: [[0, 'asc']],
        columnDefs: [
            { orderable: false, targets: [6] } // Actions column not sortable
        ]
    });

// Bulk update operation help text
    const bulkOperation = document.getElementById('bulkOperation');
    const operationHelp = document.getElementById('operationHelp');
    
    if (bulkOperation && operationHelp) {
        bulkOperation.addEventListener('change', function() {
            const helpTexts = {
                'set': 'Set all variants to this stock quantity',
                'add': 'Add this quantity to current stock of all variants',
                'subtract': 'Subtract this quantity from current stock of all variants (minimum 0)'
            };
            operationHelp.textContent = helpTexts[this.value] || '';
        });
    }

// Quick stock update with Enter key
    document.querySelectorAll('.stock-input').forEach(input => {
        input.addEventListener('keypress', function(e) {
            if (e.key === 'Enter') {
                this.closest('form').submit();
            }
        });
    });

// Export functionality
    document.getElementById('exportBtn').addEventListener('click', function() {
        let csv = [];
        let rows = document.querySelectorAll('#inventoryTable tr');
        
        // Add headers
        csv.push(['Product Name', 'Category', 'Variant', 'Size', 'Color', 'Price', 'Stock', 'Status']);
        
        for (let i = 1; i < rows.length; i++) {
            let cols = rows[i].querySelectorAll('td');
            if (cols.length >= 7) {
                let row = [
                    cols[0].querySelector('strong')?.innerText || '',
                    cols[1].innerText,
                    cols[2].querySelector('strong')?.innerText || '',
                    cols[2].querySelector('.color-swatch')?.nextSibling?.textContent?.trim() || '',
                    '₹' + (cols[3].querySelector('strong')?.innerText.replace('₹', '') || '0'),
                    cols[4].querySelector('input')?.value || '0',
                    cols[5].querySelector('.badge')?.innerText || ''
                ];
                csv.push(row);
            }
        }

let csvString = csv.map(row => row.map(cell => `"${cell}"`).join(',')).join('\n');
        let blob = new Blob([csvString], { type: 'text/csv' });
        let url = window.URL.createObjectURL(blob);
        let a = document.createElement('a');
        
        a.setAttribute('hidden', '');
        a.setAttribute('href', url);
        a.setAttribute('download', 'inventory_' + new Date().toISOString().split('T')[0] + '.csv');
        document.body.appendChild(a);
        a.click();
        document.body.removeChild(a);
    });
});
</script>

</body>
</html>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: online-inventory.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation