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/ecommer.in/public_html/billing/vkmobiles/admin

Free Space:

10.27 TB

🔧 Quick Actions

✏️ Editing: inventory-stock.php

<?php
session_start();
?>
<!doctype html>
<html lang="en">

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

<?php include('includes/pre-loader.php')?>

<div id="layout-wrapper">

<?php include('includes/topbar.php')?>

<div class="vertical-menu">

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

<div class="main-content">
        <div class="page-content">
           
            <div class="container-fluid">

<?php
                // Include database connection
                include('includes/db.php');

// Determine logged-in branch
                $branch_id = isset($_SESSION['branch_id']) ? intval($_SESSION['branch_id']) : null;
                
                if ($branch_id === null) {
                    echo '<div class="alert alert-danger">No branch logged in. Please login to continue.</div>';
                    include('includes/footer.php');
                    exit();
                }
                
                $branch_name = "Branch";
                
                // Get branch name
                $branch_sql = "SELECT branch_name FROM branches WHERE id = $branch_id";
                $branch_result = $conn->query($branch_sql);
                if ($branch_result && $branch_result->num_rows > 0) {
                    $branch_data = $branch_result->fetch_assoc();
                    $branch_name = $branch_data['branch_name'];
                }

// Helper: check if a table has a column
                function columnExists($conn, $table, $column) {
                    $table_safe = $conn->real_escape_string($table);
                    $column_safe = $conn->real_escape_string($column);
                    $res = $conn->query("SHOW COLUMNS FROM `{$table_safe}` LIKE '{$column_safe}'");
                    return ($res && $res->num_rows > 0);
                }

// Check if products table has branch_id column
                $products_has_branch = columnExists($conn, 'products', 'branch_id');
                
                if (!$products_has_branch) {
                    echo '<div class="alert alert-danger">The products table does not have a branch_id column. Cannot filter by branch.</div>';
                    include('includes/footer.php');
                    exit();
                }

// Handle stock update (single product)
                if ($_SERVER["REQUEST_METHOD"] == "POST" && isset($_POST['update_stock'])) {
                    $product_id = intval($_POST['product_id']);
                    $new_stock = intval($_POST['stock_quantity']);
                    $min_stock = intval($_POST['min_stock']);

// Update only products from logged-in branch
                    $sql = "UPDATE products SET stock_quantity = $new_stock, min_stock = $min_stock, updated_at = NOW() WHERE id = $product_id AND branch_id = $branch_id";
                    
                    if ($conn->query($sql) === TRUE) {
                        echo '<div class="alert alert-success alert-dismissible fade show" role="alert">
                                <i class="fas fa-check-circle me-2"></i>Stock updated successfully!
                                <button type="button" class="btn-close" data-bs-dismiss="alert" aria-label="Close"></button>
                              </div>';
                    } else {
                        echo '<div class="alert alert-danger alert-dismissible fade show" role="alert">
                                <i class="fas fa-exclamation-triangle me-2"></i>Error updating stock: ' . htmlspecialchars($conn->error) . '
                                <button type="button" class="btn-close" data-bs-dismiss="alert" aria-label="Close"></button>
                              </div>';
                    }
                }

// Handle bulk stock update
                if (isset($_POST['bulk_update_stock'])) {
                    $product_ids_raw = isset($_POST['product_ids']) ? $_POST['product_ids'] : '';
                    if (is_array($product_ids_raw)) {
                        $product_ids = $product_ids_raw;
                    } else {
                        $product_ids = array_filter(array_map('trim', explode(',', $product_ids_raw)));
                    }

$stock_action = $_POST['stock_action'];
                    $stock_value = intval($_POST['stock_value']);
                    
                    if (!empty($product_ids)) {
                        $id_list = implode(',', array_map('intval', $product_ids));

// Update only products from logged-in branch
                        switch($stock_action) {
                            case 'set':
                                $sql = "UPDATE products SET stock_quantity = $stock_value WHERE id IN ($id_list) AND branch_id = $branch_id";
                                break;
                            case 'add':
                                $sql = "UPDATE products SET stock_quantity = stock_quantity + $stock_value WHERE id IN ($id_list) AND branch_id = $branch_id";
                                break;
                            case 'subtract':
                                $sql = "UPDATE products SET stock_quantity = GREATEST(0, stock_quantity - $stock_value) WHERE id IN ($id_list) AND branch_id = $branch_id";
                                break;
                            default:
                                $sql = '';
                        }
                        
                        if ($sql && $conn->query($sql) === TRUE) {
                            echo '<div class="alert alert-success alert-dismissible fade show" role="alert">
                                    <i class="fas fa-check-circle me-2"></i>Bulk stock update completed successfully!
                                    <button type="button" class="btn-close" data-bs-dismiss="alert" aria-label="Close"></button>
                                  </div>';
                        } else {
                            echo '<div class="alert alert-danger alert-dismissible fade show" role="alert">
                                    <i class="fas fa-exclamation-triangle me-2"></i>Error updating stock: ' . htmlspecialchars($conn->error) . '
                                    <button type="button" class="btn-close" data-bs-dismiss="alert" aria-label="Close"></button>
                                  </div>';
                        }
                    } else {
                        echo '<div class="alert alert-warning alert-dismissible fade show" role="alert">
                                <i class="fas fa-exclamation-triangle me-2"></i>No products selected for bulk update.
                                <button type="button" class="btn-close" data-bs-dismiss="alert" aria-label="Close"></button>
                              </div>';
                    }
                }

// Get filter parameters
                $selected_category_id = isset($_GET['category']) ? intval($_GET['category']) : null;
                $selected_brand_id = isset($_GET['brand']) ? intval($_GET['brand']) : null;
                $selected_stock_status = isset($_GET['stock_status']) ? $_GET['stock_status'] : null;
                $search_term = isset($_GET['search']) ? trim($_GET['search']) : '';
                
                $selected_category_name = "All Categories";
                $selected_brand_name = "All Brands";
                
                if ($selected_category_id && $selected_category_id != 'all') {
                    $cat_sql = "SELECT category_name FROM categories WHERE id = " . intval($selected_category_id);
                    $cat_result = $conn->query($cat_sql);
                    if ($cat_result && $cat_result->num_rows > 0) {
                        $selected_category_name = $cat_result->fetch_assoc()['category_name'];
                    }
                }
                
                if ($selected_brand_id && $selected_brand_id != 'all') {
                    $brand_sql = "SELECT brand_name FROM brands WHERE id = " . intval($selected_brand_id);
                    $brand_result = $conn->query($brand_sql);
                    if ($brand_result && $brand_result->num_rows > 0) {
                        $selected_brand_name = $brand_result->fetch_assoc()['brand_name'];
                    }
                }
                ?>

<div class="row mb-3">
                    <div class="col-12">
                        <div class="card bg-primary text-white">
                            <div class="card-body">
                                <div class="d-flex justify-content-between align-items-center">
                                    <div>
                                        <h4 class="mb-1"><i class="fas fa-store me-2"></i><?php echo htmlspecialchars($branch_name); ?></h4>
                                        <p class="mb-0">Complete Stock Management - Your Branch Inventory</p>
                                    </div>
                                    <div>
                                        <span class="badge bg-light text-primary fs-6">Branch ID: <?php echo $branch_id; ?></span>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>

<div class="row">
                    <div class="col-md-2 col-sm-4">
                        <div class="card bg-success text-white">
                            <div class="card-body">
                                <div class="d-flex justify-content-between">
                                    <div>
                                        <h4 class="mb-0">
                                            <?php
                                            $total_sql = "SELECT COUNT(*) as total FROM products WHERE status = 'active' AND branch_id = $branch_id";
                                            echo intval($conn->query($total_sql)->fetch_assoc()['total']);
                                            ?>
                                        </h4>
                                        <p class="mb-0">Total Items</p>
                                    </div>
                                    <div class="align-self-center">
                                        <i class="fas fa-box display-4 opacity-50"></i>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>

<div class="col-md-2 col-sm-4">
                        <div class="card bg-warning text-white">
                            <div class="card-body">
                                <div class="d-flex justify-content-between">
                                    <div>
                                        <h4 class="mb-0">
                                            <?php
                                            $low_stock_sql = "SELECT COUNT(*) as low_stock FROM products WHERE status = 'active' AND branch_id = $branch_id AND stock_quantity <= min_stock AND stock_quantity > 0";
                                            echo intval($conn->query($low_stock_sql)->fetch_assoc()['low_stock']);
                                            ?>
                                        </h4>
                                        <p class="mb-0">Low Stock</p>
                                    </div>
                                    <div class="align-self-center">
                                        <i class="fas fa-exclamation-triangle display-4 opacity-50"></i>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>

<div class="col-md-2 col-sm-4">
                        <div class="card bg-danger text-white">
                            <div class="card-body">
                                <div class="d-flex justify-content-between">
                                    <div>
                                        <h4 class="mb-0">
                                            <?php
                                            $out_stock_sql = "SELECT COUNT(*) as out_stock FROM products WHERE status = 'active' AND branch_id = $branch_id AND stock_quantity = 0";
                                            echo intval($conn->query($out_stock_sql)->fetch_assoc()['out_stock']);
                                            ?>
                                        </h4>
                                        <p class="mb-0">Out of Stock</p>
                                    </div>
                                    <div class="align-self-center">
                                        <i class="fas fa-times-circle display-4 opacity-50"></i>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>

<div class="col-md-2 col-sm-4">
                        <div class="card bg-dark text-white">
                            <div class="card-body">
                                <div class="d-flex justify-content-between">
                                    <div>
                                        <h4 class="mb-0">
                                            <?php
                                            $critical_sql = "SELECT COUNT(*) as critical FROM products WHERE status = 'active' AND branch_id = $branch_id AND stock_quantity <= 2 AND stock_quantity > 0";
                                            echo intval($conn->query($critical_sql)->fetch_assoc()['critical']);
                                            ?>
                                        </h4>
                                        <p class="mb-0">Critical (≤2)</p>
                                    </div>
                                    <div class="align-self-center">
                                        <i class="fas fa-skull-crossbones display-4 opacity-50"></i>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>

<div class="col-md-2 col-sm-4">
                        <div class="card bg-info text-white">
                            <div class="card-body">
                                <div class="d-flex justify-content-between">
                                    <div>
                                        <h4 class="mb-0">
                                            <?php
                                            $excess_sql = "SELECT COUNT(*) as excess FROM products WHERE status = 'active' AND branch_id = $branch_id AND stock_quantity > min_stock * 2";
                                            echo intval($conn->query($excess_sql)->fetch_assoc()['excess']);
                                            ?>
                                        </h4>
                                        <p class="mb-0">Excess Stock</p>
                                    </div>
                                    <div class="align-self-center">
                                        <i class="fas fa-chart-line display-4 opacity-50"></i>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>

<div class="col-md-2 col-sm-4">
                        <div class="card bg-purple text-white">
                            <div class="card-body">
                                <div class="d-flex justify-content-between">
                                    <div>
                                        <h4 class="mb-0">
                                            <?php
                                            $optimal_sql = "SELECT COUNT(*) as optimal FROM products WHERE status = 'active' AND branch_id = $branch_id AND stock_quantity > min_stock AND stock_quantity <= min_stock * 2";
                                            echo intval($conn->query($optimal_sql)->fetch_assoc()['optimal']);
                                            ?>
                                        </h4>
                                        <p class="mb-0">Optimal</p>
                                    </div>
                                    <div class="align-self-center">
                                        <i class="fas fa-check-circle display-4 opacity-50"></i>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>

<div class="row mt-3">
                    <div class="col-md-3">
                        <div class="card bg-secondary text-white">
                            <div class="card-body">
                                <div class="d-flex justify-content-between">
                                    <div>
                                        <h4 class="mb-0">
                                            <?php
                                            $total_cost_sql = "SELECT SUM(stock_quantity * purchase_price) as total_cost FROM products WHERE status = 'active' AND branch_id = $branch_id";
                                            $total_cost = $conn->query($total_cost_sql)->fetch_assoc()['total_cost'] ?? 0;
                                            echo '₹' . number_format($total_cost, 2);
                                            ?>
                                        </h4>
                                        <p class="mb-0">Total Cost Value</p>
                                    </div>
                                    <div class="align-self-center">
                                        <i class="fas fa-money-bill-wave display-4 opacity-50"></i>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>

<div class="col-md-3">
                        <div class="card bg-success text-white">
                            <div class="card-body">
                                <div class="d-flex justify-content-between">
                                    <div>
                                        <h4 class="mb-0">
                                            <?php
                                            $total_sellable_sql = "SELECT SUM(stock_quantity * selling_price) as total_sellable FROM products WHERE status = 'active' AND branch_id = $branch_id";
                                            $total_sellable = $conn->query($total_sellable_sql)->fetch_assoc()['total_sellable'] ?? 0;
                                            echo '₹' . number_format($total_sellable, 2);
                                            ?>
                                        </h4>
                                        <p class="mb-0">Total Sellable Value</p>
                                    </div>
                                    <div class="align-self-center">
                                        <i class="fas fa-tags display-4 opacity-50"></i>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>

<div class="col-md-3">
                        <div class="card bg-info text-white">
                            <div class="card-body">
                                <div class="d-flex justify-content-between">
                                    <div>
                                        <h4 class="mb-0">
                                            <?php
                                            $total_profit_sql = "SELECT SUM(stock_quantity * (selling_price - purchase_price)) as total_profit FROM products WHERE status = 'active' AND branch_id = $branch_id";
                                            $total_profit = $conn->query($total_profit_sql)->fetch_assoc()['total_profit'] ?? 0;
                                            echo '₹' . number_format($total_profit, 2);
                                            ?>
                                        </h4>
                                        <p class="mb-0">Total Potential Profit</p>
                                    </div>
                                    <div class="align-self-center">
                                        <i class="fas fa-chart-line display-4 opacity-50"></i>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>

<div class="col-md-3">
                        <div class="card bg-warning text-white">
                            <div class="card-body">
                                <div class="d-flex justify-content-between">
                                    <div>
                                        <h4 class="mb-0">
                                            <?php
                                            $profit_margin_sql = "SELECT AVG(((selling_price - purchase_price) / purchase_price) * 100) as avg_margin FROM products WHERE status = 'active' AND branch_id = $branch_id AND purchase_price > 0";
                                            $avg_margin = $conn->query($profit_margin_sql)->fetch_assoc()['avg_margin'] ?? 0;
                                            echo number_format($avg_margin, 1) . '%';
                                            ?>
                                        </h4>
                                        <p class="mb-0">Average Margin</p>
                                    </div>
                                    <div class="align-self-center">
                                        <i class="fas fa-percent display-4 opacity-50"></i>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>

<div class="row mt-3">
                    <div class="col-lg-12">
                        <div class="card">
                            <div class="card-header">
                                <div class="d-flex justify-content-between align-items-center flex-wrap">
                                    <div>
                                        <h5 class="card-title mb-0">Complete Stock Management</h5>
                                        <p class="text-muted mb-0">
                                            <span class="badge bg-info"><?php echo htmlspecialchars($selected_category_name); ?></span>
                                            <span class="badge bg-secondary ms-1"><?php echo htmlspecialchars($selected_brand_name); ?></span>
                                            <span class="badge bg-primary ms-1"><i class="fas fa-store me-1"></i><?php echo htmlspecialchars($branch_name); ?></span>
                                            <?php if ($selected_stock_status): ?>
                                                <span class="badge bg-<?php echo getStockStatusColor($selected_stock_status); ?> ms-1"><?php echo ucwords(str_replace('_', ' ', $selected_stock_status)); ?></span>
                                            <?php endif; ?>
                                        </p>
                                    </div>
                                    <div class="d-flex gap-2 flex-wrap">
                                        <button type="button" class="btn btn-success" data-bs-toggle="modal" data-bs-target="#bulkStockModal">
                                            <i class="fas fa-edit me-2"></i>Bulk Update
                                        </button>
                                        <a href="inventory-purchase.php" class="btn btn-primary">
                                            <i class="fas fa-shopping-cart me-2"></i>Create Purchase Order
                                        </a>
                                        <a href="products-import.php" class="btn btn-info">
                                            <i class="fas fa-file-import me-2"></i>Import Products
                                        </a>
                                        <a href="inventory-lowstock.php" class="btn btn-outline-warning">
                                            <i class="fas fa-exclamation-triangle me-2"></i>View Low Stock
                                        </a>
                                    </div>
                                </div>
                            </div>
                            <div class="card-body">

<div class="row mb-3">
                                    <div class="col-md-3">
                                        <div class="input-group">
                                            <input type="text" class="form-control" id="searchInput" placeholder="Search products..." value="<?php echo htmlspecialchars($search_term); ?>">
                                            <button class="btn btn-outline-secondary" type="button" id="searchButton">
                                                <i class="fas fa-search"></i>
                                            </button>
                                        </div>
                                    </div>
                                    <div class="col-md-2">
                                        <select class="form-select" id="categoryFilter">
                                            <option value="all">All Categories</option>
                                            <?php
                                            $cat_sql = "SELECT * FROM categories ORDER BY category_name";
                                            $cat_result = $conn->query($cat_sql);
                                            while($cat = $cat_result->fetch_assoc()) {
                                                $selected = ($selected_category_id == $cat['id']) ? 'selected' : '';
                                                echo '<option value="' . intval($cat['id']) . '" ' . $selected . '>' . htmlspecialchars($cat['category_name']) . '</option>';
                                            }
                                            ?>
                                        </select>
                                    </div>
                                    <div class="col-md-2">
                                        <select class="form-select" id="brandFilter">
                                            <option value="all">All Brands</option>
                                            <?php
                                            $brand_sql = "SELECT * FROM brands ORDER BY brand_name";
                                            $brand_result = $conn->query($brand_sql);
                                            while($brand = $brand_result->fetch_assoc()) {
                                                $selected = ($selected_brand_id == $brand['id']) ? 'selected' : '';
                                                echo '<option value="' . intval($brand['id']) . '" ' . $selected . '>' . htmlspecialchars($brand['brand_name']) . '</option>';
                                            }
                                            ?>
                                        </select>
                                    </div>
                                    <div class="col-md-2">
                                        <select class="form-select" id="stockStatusFilter">
                                            <option value="all">All Stock Levels</option>
                                            <option value="optimal" <?php echo ($selected_stock_status == 'optimal') ? 'selected' : ''; ?>>Optimal Stock</option>
                                            <option value="low_stock" <?php echo ($selected_stock_status == 'low_stock') ? 'selected' : ''; ?>>Low Stock</option>
                                            <option value="critical" <?php echo ($selected_stock_status == 'critical') ? 'selected' : ''; ?>>Critical Stock</option>
                                            <option value="out_of_stock" <?php echo ($selected_stock_status == 'out_of_stock') ? 'selected' : ''; ?>>Out of Stock</option>
                                            <option value="excess_stock" <?php echo ($selected_stock_status == 'excess_stock') ? 'selected' : ''; ?>>Excess Stock</option>
                                        </select>
                                    </div>
                                    <div class="col-md-2">
                                        <select class="form-select" id="sortFilter">
                                            <option value="name" <?php echo (isset($_GET['sort']) && $_GET['sort'] == 'name') ? 'selected' : ''; ?>>Sort by Name</option>
                                            <option value="stock_low" <?php echo (isset($_GET['sort']) && $_GET['sort'] == 'stock_low') ? 'selected' : ''; ?>>Sort by Stock (Low to High)</option>
                                            <option value="stock_high" <?php echo (isset($_GET['sort']) && $_GET['sort'] == 'stock_high') ? 'selected' : ''; ?>>Sort by Stock (High to Low)</option>
                                            <option value="updated" <?php echo (isset($_GET['sort']) && $_GET['sort'] == 'updated') ? 'selected' : ''; ?>>Sort by Last Updated</option>
                                            <option value="value_high" <?php echo (isset($_GET['sort']) && $_GET['sort'] == 'value_high') ? 'selected' : ''; ?>>Sort by Value (High to Low)</option>
                                        </select>
                                    </div>
                                    <div class="col-md-1">
                                        <button type="button" class="btn btn-outline-danger w-100" id="clearFilters">
                                            <i class="fas fa-times"></i>
                                        </button>
                                    </div>
                                </div>

<div class="row mb-3">
                                    <div class="col-12">
                                        <div class="d-flex gap-2 align-items-center flex-wrap">
                                            <select class="form-select" id="bulkAction" style="width: auto;">
                                                <option value="">Bulk Actions</option>
                                                <option value="purchase_order">Create Purchase Order</option>
                                                <option value="update_stock">Update Stock Levels</option>
                                                <option value="export">Export Selected</option>
                                            </select>
                                            <button type="button" class="btn btn-outline-primary" id="applyBulkAction">
                                                Apply
                                            </button>
                                            <div class="ms-auto">
                                                <span id="selectedCount" class="badge bg-primary">0 products selected</span>
                                            </div>
                                        </div>
                                    </div>
                                </div>

<div class="table-responsive">
                                    <table class="table table-bordered table-hover mb-0" id="stockTable">
                                        <thead class="table-light">
                                            <tr>
                                                <th width="50">
                                                    <div class="form-check">
                                                        <input class="form-check-input" type="checkbox" id="selectAll">
                                                    </div>
                                                </th>
                                                <th>Product Details</th>
                                                <th>Category</th>
                                                <th>Brand</th>
                                                <th>Current Stock</th>
                                                <th>Min Stock</th>
                                                <th>Stock Status</th>
                                                <th>Cost Price</th>
                                                <th>Selling Price</th>
                                                <th>Profit/Unit</th>
                                                <th>Stock Value</th>
                                                <th>Sellable Value</th>
                                                <th>Margin</th>
                                                <th>Last Updated</th>
                                                <th>Actions</th>
                                            </tr>
                                        </thead>
                                        <tbody>
                                            <?php
                                            // Build query with filters - ONLY FOR LOGGED-IN BRANCH
                                            $where_conditions = array();
                                            $where_conditions[] = "p.branch_id = $branch_id"; // Only show products from logged-in branch
                                            $where_conditions[] = "p.status = 'active'";

// Category filter
                                            if ($selected_category_id && $selected_category_id != 'all') {
                                                $where_conditions[] = "p.category_id = " . intval($selected_category_id);
                                            }

// Brand filter
                                            if ($selected_brand_id && $selected_brand_id != 'all') {
                                                $where_conditions[] = "p.brand_id = " . intval($selected_brand_id);
                                            }

// Stock status filter
                                            if ($selected_stock_status && $selected_stock_status != 'all') {
                                                switch($selected_stock_status) {
                                                    case 'optimal':
                                                        $where_conditions[] = "p.stock_quantity > p.min_stock AND p.stock_quantity <= p.min_stock * 2";
                                                        break;
                                                    case 'low_stock':
                                                        $where_conditions[] = "p.stock_quantity <= p.min_stock AND p.stock_quantity > 2";
                                                        break;
                                                    case 'critical':
                                                        $where_conditions[] = "p.stock_quantity <= 2 AND p.stock_quantity > 0";
                                                        break;
                                                    case 'out_of_stock':
                                                        $where_conditions[] = "p.stock_quantity = 0";
                                                        break;
                                                    case 'excess_stock':
                                                        $where_conditions[] = "p.stock_quantity > p.min_stock * 2";
                                                        break;
                                                }
                                            }

// Search filter
                                            if (!empty($search_term)) {
                                                $search = $conn->real_escape_string($search_term);
                                                $where_conditions[] = "(p.product_name LIKE '%$search%' OR b.brand_name LIKE '%$search%' OR p.model LIKE '%$search%' OR p.serial_number LIKE '%$search%')";
                                            }

$where_sql = "";
                                            if (!empty($where_conditions)) {
                                                $where_sql = "WHERE " . implode(" AND ", $where_conditions);
                                            }

// Build order by clause based on sort filter
                                            $order_by = "p.product_name ASC"; // Default
                                            if (isset($_GET['sort']) && !empty($_GET['sort'])) {
                                                switch($_GET['sort']) {
                                                    case 'name':
                                                        $order_by = "p.product_name ASC";
                                                        break;
                                                    case 'stock_low':
                                                        $order_by = "p.stock_quantity ASC";
                                                        break;
                                                    case 'stock_high':
                                                        $order_by = "p.stock_quantity DESC";
                                                        break;
                                                    case 'updated':
                                                        $order_by = "p.updated_at DESC";
                                                        break;
                                                    case 'value_high':
                                                        $order_by = "(p.stock_quantity * p.selling_price) DESC";
                                                        break;
                                                }
                                            }

// Get total count for pagination
                                            $count_sql = "SELECT COUNT(*) as total FROM products p 
                                                         LEFT JOIN brands b ON p.brand_id = b.id 
                                                         $where_sql";
                                            $count_result = $conn->query($count_sql);
                                            $total_products = $count_result ? intval($count_result->fetch_assoc()['total']) : 0;

// Pagination
                                            $per_page = 20;
                                            $current_page = isset($_GET['page']) ? max(1, intval($_GET['page'])) : 1;
                                            $offset = ($current_page - 1) * $per_page;
                                            $total_pages = $per_page > 0 ? ceil($total_products / $per_page) : 1;

// Main query
                                            $sql = "SELECT p.*, c.category_name, b.brand_name 
                                                    FROM products p 
                                                    LEFT JOIN categories c ON p.category_id = c.id 
                                                    LEFT JOIN brands b ON p.brand_id = b.id 
                                                    $where_sql 
                                                    ORDER BY $order_by
                                                    LIMIT $offset, $per_page";
                                            
                                            $result = $conn->query($sql);

if ($result && $result->num_rows > 0) {
                                                $total_stock_value = 0;
                                                $total_sellable_value = 0;
                                                $total_potential_profit = 0;
                                                $total_units = 0;
                                                
                                                while($product = $result->fetch_assoc()) {
                                                    // Stock status
                                                    $stock_status = getStockStatus($product['stock_quantity'], $product['min_stock']);
                                                    $stock_class = getStockStatusClass($product['stock_quantity'], $product['min_stock']);
                                                    $stock_icon = getStockStatusIcon($product['stock_quantity'], $product['min_stock']);

// Calculate financial values
                                                    $profit_per_unit = $product['selling_price'] - $product['purchase_price'];
                                                    $profit_margin = $product['purchase_price'] > 0 ? ($profit_per_unit / $product['purchase_price']) * 100 : 0;
                                                    
                                                    $stock_value = $product['stock_quantity'] * $product['purchase_price'];
                                                    $sellable_value = $product['stock_quantity'] * $product['selling_price'];
                                                    $potential_profit = $product['stock_quantity'] * $profit_per_unit;
                                                    
                                                    // Add to totals
                                                    $total_stock_value += $stock_value;
                                                    $total_sellable_value += $sellable_value;
                                                    $total_potential_profit += $potential_profit;
                                                    $total_units += $product['stock_quantity'];

// Calculate stock deficit/surplus
                                                    $stock_diff = $product['stock_quantity'] - $product['min_stock'];

// Last updated time
                                                    $last_updated = '';
                                                    $update_class = '';
                                                    if (!empty($product['updated_at']) && date('Y-m-d') == date('Y-m-d', strtotime($product['updated_at']))) {
                                                        $last_updated = 'Today ' . date('g:i A', strtotime($product['updated_at']));
                                                        $update_class = 'text-success';
                                                    } else {
                                                        $last_updated = !empty($product['updated_at']) ? date('M j, Y g:i A', strtotime($product['updated_at'])) : 'Never';
                                                        $update_class = 'text-muted';
                                                    }
                                            ?>
                                            <tr data-category="<?php echo intval($product['category_id']); ?>" 
                                                data-brand="<?php echo intval($product['brand_id']); ?>"
                                                data-status="<?php echo htmlspecialchars($product['status']); ?>"
                                                data-stock="<?php echo $stock_class; ?>">
                                                <td>
                                                    <div class="form-check">
                                                        <input class="form-check-input product-checkbox" type="checkbox" value="<?php echo intval($product['id']); ?>">
                                                    </div>
                                                </td>
                                                <td>
                                                    <div class="d-flex align-items-center">
                                                        <div class="flex-shrink-0">
                                                            <div class="avatar-xs bg-light rounded">
                                                                <i class="fas fa-box font-size-13 text-primary"></i>
                                                            </div>
                                                        </div>
                                                        <div class="flex-grow-1 ms-2">
                                                            <h6 class="mb-0"><?php echo htmlspecialchars($product['product_name']); ?></h6>
                                                            <small class="text-muted">
                                                                <?php echo htmlspecialchars($product['model']); ?>
                                                                <?php if (!empty($product['serial_number'])): ?>
                                                                    <br><small class="text-info">S/N: <?php echo $product['serial_number']; ?></small>
                                                                <?php endif; ?>
                                                            </small>
                                                        </div>
                                                    </div>
                                                </td>
                                                <td>
                                                    <span class="badge bg-info"><?php echo htmlspecialchars($product['category_name']); ?></span>
                                                </td>
                                                <td>
                                                    <span class="badge bg-secondary"><?php echo htmlspecialchars($product['brand_name']); ?></span>
                                                </td>
                                                <td>
                                                    <div class="text-center">
                                                        <strong class="h5 mb-0"><?php echo intval($product['stock_quantity']); ?></strong>
                                                        <div class="mt-1">
                                                            <small class="text-muted">units</small>
                                                        </div>
                                                        <?php if ($stock_diff != 0): ?>
                                                            <div class="mt-1">
                                                                <small class="<?php echo $stock_diff > 0 ? 'text-success' : 'text-danger'; ?>">
                                                                    <?php echo $stock_diff > 0 ? '+' . $stock_diff : $stock_diff; ?> from min
                                                                </small>
                                                            </div>
                                                        <?php endif; ?>
                                                    </div>
                                                </td>
                                                <td>
                                                    <div class="text-center">
                                                        <strong class="h6 mb-0"><?php echo intval($product['min_stock']); ?></strong>
                                                    </div>
                                                </td>
                                                <td>
                                                    <span class="badge bg-<?php echo $stock_class; ?>">
                                                        <i class="fas <?php echo $stock_icon; ?> me-1"></i><?php echo $stock_status; ?>
                                                    </span>
                                                </td>
                                                <td>
                                                    <div class="text-nowrap">
                                                        <strong class="text-info">₹<?php echo number_format($product['purchase_price'], 2); ?></strong>
                                                    </div>
                                                </td>
                                                <td>
                                                    <div class="text-nowrap">
                                                        <strong class="text-success">₹<?php echo number_format($product['selling_price'], 2); ?></strong>
                                                    </div>
                                                </td>
                                                <td>
                                                    <div class="text-nowrap">
                                                        <strong class="<?php echo $profit_per_unit >= 0 ? 'text-success' : 'text-danger'; ?>">
                                                            ₹<?php echo number_format($profit_per_unit, 2); ?>
                                                        </strong>
                                                    </div>
                                                </td>
                                                <td>
                                                    <strong class="text-primary">₹<?php echo number_format($stock_value, 2); ?></strong>
                                                </td>
                                                <td>
                                                    <strong class="text-purple">₹<?php echo number_format($sellable_value, 2); ?></strong>
                                                </td>
                                                <td>
                                                    <strong class="<?php echo $profit_margin >= 0 ? 'text-success' : 'text-danger'; ?>">
                                                        <?php echo number_format($profit_margin, 1); ?>%
                                                    </strong>
                                                </td>
                                                <td>
                                                    <small class="<?php echo $update_class; ?>"><?php echo $last_updated; ?></small>
                                                </td>
                                                <td>
                                                    <div class="btn-group btn-group-sm">
                                                        <button type="button" class="btn btn-outline-primary edit-stock" 
                                                                data-bs-toggle="modal" data-bs-target="#editStockModal"
                                                                data-product-id="<?php echo intval($product['id']); ?>"
                                                                data-product-name="<?php echo htmlspecialchars($product['product_name']); ?>"
                                                                data-current-stock="<?php echo intval($product['stock_quantity']); ?>"
                                                                data-min-stock="<?php echo intval($product['min_stock']); ?>">
                                                            <i class="fas fa-edit"></i>
                                                        </button>
                                                        <a href="inventory-purchase.php?product_id=<?php echo intval($product['id']); ?>" class="btn btn-outline-success" title="Purchase Order">
                                                            <i class="fas fa-cart-plus"></i>
                                                        </a>
                                                        <a href="products-edit.php?id=<?php echo intval($product['id']); ?>" class="btn btn-outline-info" title="Edit Product">
                                                            <i class="fas fa-cog"></i>
                                                        </a>
                                                    </div>
                                                </td>
                                            </tr>
                                            <?php 
                                                } 
                                            } else { 
                                            ?>
                                            <tr>
                                                <td colspan="15" class="text-center py-4">
                                                    <i class="fas fa-box-open display-4 text-muted"></i>
                                                    <h5 class="mt-2">No Products Found</h5>
                                                    <p class="text-muted">No products match your search criteria in <?php echo htmlspecialchars($branch_name); ?>.</p>
                                                    <a href="products-add.php?branch_id=<?php echo $branch_id; ?>" class="btn btn-primary me-2">
                                                        <i class="fas fa-plus-circle me-2"></i>Add Product
                                                    </a>
                                                    <a href="products-import.php" class="btn btn-info">
                                                        <i class="fas fa-file-import me-2"></i>Import Products
                                                    </a>
                                                </td>
                                            </tr>
                                            <?php } ?>
                                        </tbody>
                                    </table>
                                </div>

<?php if (isset($total_units) && $total_units > 0): ?>
                                <div class="row mt-3">
                                    <div class="col-12">
                                        <div class="card">
                                            <div class="card-header bg-light">
                                                <h5 class="card-title mb-0">Stock Summary (Showing <?php echo min($total_products, $per_page); ?> of <?php echo $total_products; ?> products)</h5>
                                            </div>
                                            <div class="card-body">
                                                <div class="row text-center">
                                                    <div class="col-md-2">
                                                        <h4 class="text-dark"><?php echo number_format($total_units); ?></h4>
                                                        <p class="text-muted mb-0">Total Units</p>
                                                    </div>
                                                    <div class="col-md-2">
                                                        <h4 class="text-primary">₹<?php echo number_format($total_stock_value, 2); ?></h4>
                                                        <p class="text-muted mb-0">Total Cost Value</p>
                                                    </div>
                                                    <div class="col-md-2">
                                                        <h4 class="text-success">₹<?php echo number_format($total_sellable_value, 2); ?></h4>
                                                        <p class="text-muted mb-0">Total Sellable Value</p>
                                                    </div>
                                                    <div class="col-md-2">
                                                        <h4 class="text-info">₹<?php echo number_format($total_potential_profit, 2); ?></h4>
                                                        <p class="text-muted mb-0">Total Potential Profit</p>
                                                    </div>
                                                    <div class="col-md-2">
                                                        <?php
                                                        $avg_margin_display = $total_stock_value > 0 ? ($total_potential_profit / $total_stock_value) * 100 : 0;
                                                        ?>
                                                        <h4 class="text-warning"><?php echo number_format($avg_margin_display, 1); ?>%</h4>
                                                        <p class="text-muted mb-0">Overall Margin</p>
                                                    </div>
                                                    <div class="col-md-2">
                                                        <h4 class="text-purple"><?php echo $per_page > 0 ? ceil($total_products / $per_page) : 1; ?></h4>
                                                        <p class="text-muted mb-0">Total Pages</p>
                                                    </div>
                                                </div>
                                            </div>
                                        </div>
                                    </div>
                                </div>
                                <?php endif; ?>

<?php if ($total_pages > 1): ?>
                                <div class="row mt-3">
                                    <div class="col-12">
                                        <nav>
                                            <ul class="pagination justify-content-center">
                                                <li class="page-item <?php echo $current_page == 1 ? 'disabled' : ''; ?>">
                                                    <a class="page-link" href="<?php echo build_page_url($current_page - 1); ?>">Previous</a>
                                                </li>
                                                
                                                <?php for ($i = 1; $i <= $total_pages; $i++): ?>
                                                    <li class="page-item <?php echo $i == $current_page ? 'active' : ''; ?>">
                                                        <a class="page-link" href="<?php echo build_page_url($i); ?>"><?php echo $i; ?></a>
                                                    </li>
                                                <?php endfor; ?>
                                                
                                                <li class="page-item <?php echo $current_page == $total_pages ? 'disabled' : ''; ?>">
                                                    <a class="page-link" href="<?php echo build_page_url($current_page + 1); ?>">Next</a>
                                                </li>
                                            </ul>
                                        </nav>
                                    </div>
                                </div>
                                <?php endif; ?>

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

</div>
            
        </div>

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

</div>

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

<div class="modal fade" id="editStockModal" tabindex="-1" aria-labelledby="editStockModalLabel" aria-hidden="true">
    <div class="modal-dialog">
        <div class="modal-content">
            <div class="modal-header">
                <h5 class="modal-title" id="editStockModalLabel">Update Stock - <?php echo htmlspecialchars($branch_name); ?></h5>
                <button type="button" class="btn-close" data-bs-dismiss="modal" aria-label="Close"></button>
            </div>
            <form method="POST" action="">
                <div class="modal-body">
                    <input type="hidden" name="product_id" id="edit_product_id">
                    <div class="mb-3">
                        <label class="form-label">Product</label>
                        <input type="text" class="form-control" id="edit_product_name" readonly>
                    </div>
                    <div class="mb-2">
                        <span class="badge bg-primary"><i class="fas fa-store me-1"></i><?php echo htmlspecialchars($branch_name); ?></span>
                    </div>
                    <div class="row">
                        <div class="col-md-6">
                            <div class="mb-3">
                                <label for="stock_quantity" class="form-label">Current Stock</label>
                                <input type="number" class="form-control" id="stock_quantity" name="stock_quantity" min="0" required>
                            </div>
                        </div>
                        <div class="col-md-6">
                            <div class="mb-3">
                                <label for="min_stock" class="form-label">Minimum Stock Level</label>
                                <input type="number" class="form-control" id="min_stock" name="min_stock" min="0" required>
                                <div class="form-text">Alert when stock goes below this level</div>
                            </div>
                        </div>
                    </div>
                </div>
                <div class="modal-footer">
                    <button type="button" class="btn btn-secondary" data-bs-dismiss="modal">Cancel</button>
                    <button type="submit" name="update_stock" class="btn btn-primary">Update Stock</button>
                </div>
            </form>
        </div>
    </div>
</div>

<div class="modal fade" id="bulkStockModal" tabindex="-1" aria-labelledby="bulkStockModalLabel" aria-hidden="true">
    <div class="modal-dialog">
        <div class="modal-content">
            <div class="modal-header">
                <h5 class="modal-title" id="bulkStockModalLabel">Bulk Stock Update - <?php echo htmlspecialchars($branch_name); ?></h5>
                <button type="button" class="btn-close" data-bs-dismiss="modal" aria-label="Close"></button>
            </div>
            <form method="POST" action="">
                <div class="modal-body">
                    <div class="mb-3">
                        <label for="stock_action" class="form-label">Action</label>
                        <select class="form-select" id="stock_action" name="stock_action" required>
                            <option value="set">Set to specific value</option>
                            <option value="add">Add to current stock</option>
                            <option value="subtract">Subtract from current stock</option>
                        </select>
                    </div>
                    <div class="mb-3">
                        <label for="stock_value" class="form-label">Value</label>
                        <input type="number" class="form-control" id="stock_value" name="stock_value" min="0" required>
                    </div>
                    <div class="alert alert-info">
                        <i class="fas fa-info-circle me-2"></i>
                        This action will be applied to all selected products in <strong><?php echo htmlspecialchars($branch_name); ?></strong>.
                    </div>
                </div>
                <div class="modal-footer">
                    <button type="button" class="btn btn-secondary" data-bs-dismiss="modal">Cancel</button>
                    <button type="submit" name="bulk_update_stock" class="btn btn-primary">Update Stock</button>
                </div>
                <input type="hidden" name="product_ids" id="bulk_product_ids">
            </form>
        </div>
    </div>
</div>

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

// Dynamically track product checkboxes (works for current page)
    function getProductCheckboxes() {
        return document.querySelectorAll('.product-checkbox');
    }

// Update selected count
    function updateSelectedCount() {
        const selected = document.querySelectorAll('.product-checkbox:checked').length;
        selectedCount.textContent = selected + ' products selected';
    }

// Delegate checkbox change listeners
    document.addEventListener('change', function(e) {
        if (e.target && e.target.matches('.product-checkbox')) {
            updateSelectedCount();
        }
        if (e.target && e.target.matches('#selectAll')) {
            const checked = e.target.checked;
            getProductCheckboxes().forEach(cb => cb.checked = checked);
            updateSelectedCount();
        }
    });

// Edit Stock Modal
    if (editStockModal) {
        editStockModal.addEventListener('show.bs.modal', function (event) {
            const button = event.relatedTarget;
            const productId = button.getAttribute('data-product-id');
            const productName = button.getAttribute('data-product-name');
            const currentStock = button.getAttribute('data-current-stock');
            const minStock = button.getAttribute('data-min-stock');

document.getElementById('edit_product_id').value = productId;
            document.getElementById('edit_product_name').value = productName;
            document.getElementById('stock_quantity').value = currentStock;
            document.getElementById('min_stock').value = minStock;
        });
    }

// Bulk Stock Modal
    if (bulkStockModal) {
        bulkStockModal.addEventListener('show.bs.modal', function (event) {
            const selectedProducts = getSelectedProductIds();
            if (selectedProducts.length === 0) {
                alert('Please select at least one product for bulk update.');
                event.preventDefault();
                return;
            }
            document.getElementById('bulk_product_ids').value = selectedProducts.join(',');
        });
    }

// Get selected product IDs
    function getSelectedProductIds() {
        return Array.from(document.querySelectorAll('.product-checkbox:checked'))
            .map(checkbox => checkbox.value);
    }

// Bulk action (apply purchase order, update stock, export)
    if (applyBulkAction) {
        applyBulkAction.addEventListener('click', function() {
            const action = bulkAction.value;
            const selectedProducts = getSelectedProductIds();

if (!action) {
                alert('Please select a bulk action.');
                return;
            }

if (selectedProducts.length === 0) {
                alert('Please select at least one product.');
                return;
            }

if (action === 'purchase_order') {
                // Redirect to purchase order page with selected products
                const productIds = selectedProducts.join(',');
                window.location.href = 'inventory-purchase.php?products=' + productIds;
            } else if (action === 'update_stock') {
                // Open bulk stock update modal
                const modal = new bootstrap.Modal(bulkStockModal);
                modal.show();
            } else if (action === 'export') {
                exportToCsv(selectedProducts);
            }
        });
    }

// Export to CSV function
    function exportToCsv(selectedProducts) {
        // Get product data for selected products
        const productData = [];
        document.querySelectorAll('.product-checkbox:checked').forEach(checkbox => {
            const row = checkbox.closest('tr');
            const cells = row.cells;
            let cellIndex = 1;
            
            const productName = cells[cellIndex++].querySelector('h6').textContent;
            const category = cells[cellIndex++].textContent;
            const brand = cells[cellIndex++].textContent;
            const currentStock = cells[cellIndex++].querySelector('strong').textContent;
            const minStock = cells[cellIndex++].querySelector('strong').textContent;
            const stockStatus = cells[cellIndex++].querySelector('.badge').textContent;
            const costPrice = cells[cellIndex++].querySelector('strong').textContent;
            const sellingPrice = cells[cellIndex++].querySelector('strong').textContent;
            const profitUnit = cells[cellIndex++].querySelector('strong').textContent;
            const stockValue = cells[cellIndex++].textContent;
            const sellableValue = cells[cellIndex++].textContent;
            const margin = cells[cellIndex++].textContent;
            
            productData.push({
                name: productName,
                category: category,
                brand: brand,
                currentStock: currentStock,
                minStock: minStock,
                status: stockStatus,
                costPrice: costPrice,
                sellingPrice: sellingPrice,
                profitUnit: profitUnit,
                stockValue: stockValue,
                sellableValue: sellableValue,
                margin: margin
            });
        });

// Create CSV content
        let csvContent = "Product Name,Category,Brand,Current Stock,Min Stock,Stock Status,Cost Price,Selling Price,Profit per Unit,Stock Value,Sellable Value,Margin\n";
        
        productData.forEach(product => {
            csvContent += `"${product.name}","${product.category}","${product.brand}","${product.currentStock}","${product.minStock}","${product.status}","${product.costPrice}","${product.sellingPrice}","${product.profitUnit}","${product.stockValue}","${product.sellableValue}","${product.margin}"\n`;
        });

// Create and download CSV file
        const blob = new Blob([csvContent], { type: 'text/csv' });
        const url = window.URL.createObjectURL(blob);
        const a = document.createElement('a');
        a.setAttribute('hidden', '');
        a.setAttribute('href', url);
        a.setAttribute('download', 'stock_inventory_<?php echo str_replace(' ', '_', strtolower($branch_name)); ?>.csv');
        document.body.appendChild(a);
        a.click();
        document.body.removeChild(a);
    }

// Filter functionality
    function applyFilters() {
        const params = new URLSearchParams();
        
        if (categoryFilter && categoryFilter.value && categoryFilter.value !== 'all') params.set('category', categoryFilter.value);
        if (brandFilter && brandFilter.value && brandFilter.value !== 'all') params.set('brand', brandFilter.value);
        if (stockStatusFilter && stockStatusFilter.value && stockStatusFilter.value !== 'all') params.set('stock_status', stockStatusFilter.value);
        if (sortFilter && sortFilter.value) params.set('sort', sortFilter.value);
        if (searchInput && searchInput.value) params.set('search', searchInput.value);
        
        window.location.href = 'inventory-stock.php?' + params.toString();
    }

// Clear filters
    if (clearFilters) {
        clearFilters.addEventListener('click', function() {
            window.location.href = 'inventory-stock.php';
        });
    }

if (searchButton) searchButton.addEventListener('click', applyFilters);
    if (searchInput) searchInput.addEventListener('keypress', function(e) {
        if (e.key === 'Enter') applyFilters();
    });
    
    if (categoryFilter) categoryFilter.addEventListener('change', applyFilters);
    if (brandFilter) brandFilter.addEventListener('change', applyFilters);
    if (stockStatusFilter) stockStatusFilter.addEventListener('change', applyFilters);
    if (sortFilter) sortFilter.addEventListener('change', applyFilters);

// Quick stock adjustment
    document.addEventListener('dblclick', function(e) {
        if (e.target.classList.contains('h5') && e.target.textContent.match(/^\d+$/)) {
            const currentValue = parseInt(e.target.textContent);
            const newValue = prompt('Enter new stock quantity:', currentValue);
            if (newValue !== null && !isNaN(newValue)) {
                // In a real implementation, you would make an AJAX call here
                // For now, just update the display
                e.target.textContent = newValue;
            }
        }
    });
});
</script>

</body>
</html>

<?php
// Helper function for building pagination URLs
function build_page_url($page) {
    $params = $_GET;
    $params['page'] = max(1, intval($page));
    return 'inventory-stock.php?' . http_build_query($params);
}

// Helper functions for stock status
function getStockStatus($current_stock, $min_stock) {
    if ($current_stock == 0) return 'Out of Stock';
    if ($current_stock <= 2) return 'Critical';
    if ($current_stock <= $min_stock) return 'Low Stock';
    if ($current_stock > $min_stock * 2) return 'Excess Stock';
    return 'Optimal Stock';
}

function getStockStatusClass($current_stock, $min_stock) {
    if ($current_stock == 0) return 'danger';
    if ($current_stock <= 2) return 'danger';
    if ($current_stock <= $min_stock) return 'warning';
    if ($current_stock > $min_stock * 2) return 'info';
    return 'success';
}

function getStockStatusIcon($current_stock, $min_stock) {
    if ($current_stock == 0) return 'fa-times-circle';
    if ($current_stock <= 2) return 'fa-skull-crossbones';
    if ($current_stock <= $min_stock) return 'fa-exclamation-triangle';
    if ($current_stock > $min_stock * 2) return 'fa-chart-line';
    return 'fa-check-circle';
}

function getStockStatusColor($status) {
    switch($status) {
        case 'optimal': return 'success';
        case 'low_stock': return 'warning';
        case 'critical': return 'danger';
        case 'out_of_stock': return 'danger';
        case 'excess_stock': return 'info';
        default: return 'secondary';
    }
}

// Close database connection
$conn->close();
?>

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: inventory-stock.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation