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.3 TB

🔧 Quick Actions

✏️ Editing: stock-management.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();

// CSRF helper
if (empty($_SESSION['csrf_token'])) {
  $_SESSION['csrf_token'] = bin2hex(random_bytes(16));
}
$csrf = $_SESSION['csrf_token'];

// Low-stock threshold (keep across redirects)
$threshold = isset($_GET['threshold']) ? max(0, (int)$_GET['threshold']) : 5;

// ---------- handle add-stock POST ----------
$flashMsg = null; $flashType = 'info';
if ($_SERVER['REQUEST_METHOD'] === 'POST' && isset($_POST['action']) && $_POST['action'] === 'add_stock') {
    // Basic CSRF check
    if (!isset($_POST['csrf']) || $_POST['csrf'] !== $_SESSION['csrf_token']) {
        $flashMsg = 'Invalid request token.';
        $flashType = 'danger';
    } else {
        $pid = isset($_POST['product_id']) ? (int)$_POST['product_id'] : 0;
        $addQty = isset($_POST['add_qty']) ? (int)$_POST['add_qty'] : 0;

if ($pid <= 0 || $addQty <= 0) {
            $flashMsg = 'Please provide a valid product and a positive quantity.';
            $flashType = 'warning';
        } else {
            // Optional: clamp to a sane upper bound to prevent mistakes
            if ($addQty > 100000) $addQty = 100000;

// Update: quantity = quantity + ?
            $stmt = mysqli_prepare($conn, "UPDATE products SET quantity = quantity + ? WHERE id = ?");
            if ($stmt) {
                mysqli_stmt_bind_param($stmt, 'ii', $addQty, $pid);
                if (mysqli_stmt_execute($stmt)) {
                    // Get product name for a nicer message
                    $name = '';
                    $q = mysqli_query($conn, "SELECT product_name FROM products WHERE id = {$pid} LIMIT 1");
                    if ($q && mysqli_num_rows($q) > 0) {
                        $rowN = mysqli_fetch_assoc($q);
                        $name = $rowN['product_name'];
                    }
                    $flashMsg = 'Added ' . (int)$addQty . ' units to ' . htmlspecialchars($name ?: ('Product #' . $pid)) . '.';
                    $flashType = 'success';
                } else {
                    $flashMsg = 'Failed to update stock.';
                    $flashType = 'danger';
                }
                mysqli_stmt_close($stmt);
            } else {
                $flashMsg = 'Failed to prepare statement.';
                $flashType = 'danger';
            }
        }
    }

// PRG: redirect to self (preserve threshold)
    $loc = 'stock-management.php?threshold=' . (int)$threshold . '&msg=' . urlencode($flashMsg) . '&type=' . urlencode($flashType);
    header("Location: {$loc}");
    exit;
}

// Surface flash (from PRG)
if (isset($_GET['msg'])) {
    $flashMsg = $_GET['msg'];
    $flashType = $_GET['type'] ?? 'info';
}
?>

<?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; ?>

<?php
        // ---- Fetch stock data ----
        $sql = "SELECT p.id, p.product_name, p.price, p.quantity, p.created_at, c.category_name
                FROM products p
                LEFT JOIN categories c ON p.category_id = c.id
                ORDER BY p.id DESC";
        $result = mysqli_query($conn, $sql);

$rows = [];
        $totalSkus = 0;
        $totalUnits = 0;
        $totalValue = 0.00;
        $lowStock = [];

if ($result && mysqli_num_rows($result) > 0) {
          while ($r = mysqli_fetch_assoc($result)) {
            $id   = (int)$r['id'];
            $name = (string)$r['product_name'];
            $cat  = $r['category_name'] ?? 'N/A';
            $price = (float)$r['price'];
            $qty   = (int)$r['quantity'];
            $val   = $price * $qty;

$rows[] = [
              'id' => $id,
              'name' => $name,
              'cat' => $cat,
              'price' => $price,
              'qty' => $qty,
              'value' => $val,
              'created_at' => $r['created_at']
            ];

$totalSkus++;
            $totalUnits += $qty;
            $totalValue += $val;

if ($qty <= $threshold) {
              $lowStock[] = [
                'id' => $id, 'name' => $name, 'cat' => $cat, 'qty' => $qty
              ];
            }
          }
        }

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

<div class="d-flex align-items-center justify-content-between">
          <h4 class="mb-3">Stock Management</h4>
          <form class="d-flex" method="get" action="">
            <label class="me-2">Low-stock threshold</label>
            <input type="number" class="form-control form-control-sm me-2" name="threshold" value="<?php echo (int)$threshold; ?>" min="0" style="width:110px;">
            <button class="btn btn-sm btn-primary">Apply</button>
          </form>
        </div>

<div class="row">
          <div class="col-md-3">
            <div class="card"><div class="card-body">
              <div class="text-muted">Total SKUs</div>
              <div class="h4 mb-0"><?php echo (int)$totalSkus; ?></div>
            </div></div>
          </div>
          <div class="col-md-3">
            <div class="card"><div class="card-body">
              <div class="text-muted">Total Units</div>
              <div class="h4 mb-0"><?php echo (int)$totalUnits; ?></div>
            </div></div>
          </div>
          <div class="col-md-3">
            <div class="card"><div class="card-body">
              <div class="text-muted">Inventory Value (₹)</div>
              <div class="h4 mb-0"><?php echo number_format($totalValue, 2); ?></div>
            </div></div>
          </div>
          <div class="col-md-3">
            <div class="card"><div class="card-body">
              <div class="text-muted">Low Stock (≤ <?php echo (int)$threshold; ?>)</div>
              <div class="h4 mb-0"><?php echo count($lowStock); ?></div>
            </div></div>
          </div>
        </div>

<?php if (!empty($lowStock)): ?>
          <div class="alert alert-warning alert-dismissible fade show" role="alert">
            <strong>Low Stock:</strong>
            <?php
              $labels = [];
              foreach ($lowStock as $ls) {
                $labels[] = h($ls['name'])." (".h($ls['cat']).": ".(int)$ls['qty'].")";
              }
              echo implode(' · ', $labels);
            ?>
            <button type="button" class="btn-close" data-bs-dismiss="alert" aria-label="Close"></button>
          </div>
        <?php endif; ?>

<div class="card">
          <div class="card-body">
            <div class="d-flex justify-content-between align-items-center mb-3">
              <h5 class="mb-0">Stock Details</h5>
              <div>
                <button id="toggleLowOnly" class="btn btn-sm btn-outline-secondary">Show Low Stock Only</button>
              </div>
            </div>

<table id="stockTable" class="table table-bordered table-striped" style="width:100%">
              <thead>
                <tr>
                  <th>#</th>
                  <th>Product</th>
                  <th>Category</th>
                  <th>Price (₹)</th>
                  <th>Quantity</th>
                  <th>Stock Value (₹)</th>
                  <th>Status</th>
                  <th>Created</th>
                  <th>Actions</th>
                </tr>
              </thead>
              <tbody>
                <?php
                if (!empty($rows)) {
                  $i=1;
                  foreach ($rows as $r) {
                    $isLow = ($r['qty'] <= $threshold);
                    $badge = $isLow
                      ? '<span class="badge-soft-danger">Low Stock</span>'
                      : ($r['qty'] <= ($threshold*2) ? '<span class="badge-soft-warning">Moderate</span>' : '<span class="badge-soft-success">OK</span>');

$created = $r['created_at'];
                    if ($ts = strtotime($created)) $created = date("Y-m-d H:i", $ts);

echo '<tr'.($isLow ? ' data-low="1"' : ' data-low="0"').'>
                            <td>'.($i++).'</td>
                            <td>'.h($r['name']).'</td>
                            <td>'.h($r['cat']).'</td>
                            <td>'.number_format($r['price'], 2).'</td>
                            <td>'.(int)$r['qty'].'</td>
                            <td>'.number_format($r['value'], 2).'</td>
                            <td>'.$badge.'</td>
                            <td>'.h($created).'</td>
                            <td>
                              <button 
                                class="btn btn-sm btn-primary addStockBtn"
                                data-product-id="'.$r['id'].'"
                                data-product-name="'.h($r['name']).'"
                              >Add Stock</button>
                            </td>
                          </tr>';
                  }
                } else {
                  echo "<tr><td colspan='9' class='text-center'>No products found</td></tr>";
                }
                ?>
              </tbody>
            </table>

</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="addStockModal" tabindex="-1" aria-labelledby="addStockLabel" aria-hidden="true">
  <div class="modal-dialog">
    <form method="post" class="modal-content" id="addStockForm">
      <div class="modal-header">
        <h5 class="modal-title" id="addStockLabel">Add Stock</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="add_stock">
          <input type="hidden" name="csrf" value="<?php echo $csrf; ?>">
          <input type="hidden" name="product_id" id="product_id">
          <div class="mb-2">
            <label class="form-label">Product</label>
            <input type="text" class="form-control" id="product_name" readonly>
          </div>
          <div class="mb-2">
            <label class="form-label">Add Quantity</label>
            <input type="number" class="form-control" name="add_qty" id="add_qty" min="1" step="1" required>
            <div class="form-text">Enter how many units to add to current stock.</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">Add 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).ready(function () {
  var table = $('#stockTable').DataTable({
    pageLength: 10,
    order: [[0, 'asc']],
    columnDefs: [{ orderable: false, targets: 8 }] // actions not sortable
  });

// Low stock toggle
  var lowOnly = false;
  $('#toggleLowOnly').on('click', function() {
    lowOnly = !lowOnly;
    if (lowOnly) {
      $.fn.dataTable.ext.search.push(function(settings, data, dataIndex) {
        var node = table.row(dataIndex).node();
        return $(node).attr('data-low') === '1';
      });
      $(this).text('Show All Stock');
    } else {
      $.fn.dataTable.ext.search.pop();
      $(this).text('Show Low Stock Only');
    }
    table.draw();
  });

// Add Stock modal populate
  $(document).on('click', '.addStockBtn', function(){
    var pid = $(this).data('product-id');
    var pname = $(this).data('product-name');
    $('#product_id').val(pid);
    $('#product_name').val(pname);
    $('#add_qty').val('');
    var modalEl = document.getElementById('addStockModal');
    var modal = new bootstrap.Modal(modalEl);
    modal.show();
  });
});
</script>

</body>
</html>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: stock-management.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation