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

🔧 Quick Actions

✏️ Editing: inventory-lowstock.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 = "Your 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 in ' . htmlspecialchars($branch_name) . '!
                                <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 in ' . htmlspecialchars($branch_name) . '!
                                    <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 selected category and brand
                $selected_category_id = isset($_GET['category']) ? intval($_GET['category']) : null;
                $selected_brand_id = isset($_GET['brand']) ? intval($_GET['brand']) : null;
                $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); ?> - Low Stock Management</h4>
                                        <p class="mb-0">Managing low stock alerts for <?php echo htmlspecialchars($branch_name); ?> (Branch ID: <?php echo $branch_id; ?>)</p>
                                    </div>
                                    <div>
                                        <span class="badge bg-light text-primary fs-6">Current Branch</span>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>

<div class="row">
                    <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
                                            $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 Items<br><small><?php echo htmlspecialchars($branch_name); ?></small></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-3">
                        <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<br><small><?php echo htmlspecialchars($branch_name); ?></small></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-3">
                        <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 Stock (≤2)<br><small><?php echo htmlspecialchars($branch_name); ?></small></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-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_low_sql = "SELECT COUNT(*) as total FROM products WHERE status = 'active' AND branch_id = $branch_id AND (stock_quantity <= min_stock OR stock_quantity = 0)";
                                            // Add category/brand filters
                                            if ($selected_category_id && $selected_category_id != 'all') {
                                                $total_low_sql .= " AND category_id = " . intval($selected_category_id);
                                            }
                                            if ($selected_brand_id && $selected_brand_id != 'all') {
                                                $total_low_sql .= " AND brand_id = " . intval($selected_brand_id);
                                            }
                                            echo intval($conn->query($total_low_sql)->fetch_assoc()['total']);
                                            ?>
                                        </h4>
                                        <p class="mb-0">Total Low Stock<br><small><?php echo htmlspecialchars($branch_name); ?></small></p>
                                    </div>
                                    <div class="align-self-center">
                                        <i class="fas fa-filter display-4 opacity-50"></i>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>

<div class="row mt-3">
                    <div class="col-md-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
                                            $cost_sql = "SELECT SUM(stock_quantity * purchase_price) as total_cost FROM products WHERE status = 'active' AND branch_id = $branch_id AND (stock_quantity <= min_stock OR stock_quantity = 0)";
                                            if ($selected_category_id && $selected_category_id != 'all') {
                                                $cost_sql .= " AND category_id = " . intval($selected_category_id);
                                            }
                                            if ($selected_brand_id && $selected_brand_id != 'all') {
                                                $cost_sql .= " AND brand_id = " . intval($selected_brand_id);
                                            }
                                            $total_cost = $conn->query($cost_sql)->fetch_assoc()['total_cost'] ?? 0;
                                            echo '₹' . number_format($total_cost, 2);
                                            ?>
                                        </h4>
                                        <p class="mb-0">Low Stock Cost Value<br><small><?php echo htmlspecialchars($branch_name); ?></small></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-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
                                            $sellable_sql = "SELECT SUM(stock_quantity * selling_price) as total_sellable FROM products WHERE status = 'active' AND branch_id = $branch_id AND (stock_quantity <= min_stock OR stock_quantity = 0)";
                                            if ($selected_category_id && $selected_category_id != 'all') {
                                                $sellable_sql .= " AND category_id = " . intval($selected_category_id);
                                            }
                                            if ($selected_brand_id && $selected_brand_id != 'all') {
                                                $sellable_sql .= " AND brand_id = " . intval($selected_brand_id);
                                            }
                                            $total_sellable = $conn->query($sellable_sql)->fetch_assoc()['total_sellable'] ?? 0;
                                            echo '₹' . number_format($total_sellable, 2);
                                            ?>
                                        </h4>
                                        <p class="mb-0">Low Stock Sellable Value<br><small><?php echo htmlspecialchars($branch_name); ?></small></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-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
                                            $profit_sql = "SELECT SUM(stock_quantity * (selling_price - purchase_price)) as total_profit FROM products WHERE status = 'active' AND branch_id = $branch_id AND (stock_quantity <= min_stock OR stock_quantity = 0)";
                                            if ($selected_category_id && $selected_category_id != 'all') {
                                                $profit_sql .= " AND category_id = " . intval($selected_category_id);
                                            }
                                            if ($selected_brand_id && $selected_brand_id != 'all') {
                                                $profit_sql .= " AND brand_id = " . intval($selected_brand_id);
                                            }
                                            $total_profit = $conn->query($profit_sql)->fetch_assoc()['total_profit'] ?? 0;
                                            $profit_percentage = $total_cost > 0 ? ($total_profit / $total_cost) * 100 : 0;
                                            echo '₹' . number_format($total_profit, 2);
                                            ?>
                                        </h4>
                                        <p class="mb-0">
                                            Potential Profit (<?php echo htmlspecialchars($branch_name); ?>)
                                            <small>(<?php echo number_format($profit_percentage, 1); ?>%)</small>
                                        </p>
                                    </div>
                                    <div class="align-self-center">
                                        <i class="fas fa-chart-line display-4 opacity-50"></i>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>

<div class="row">
                    <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">Low Stock Alert Management - <?php echo htmlspecialchars($branch_name); ?></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); ?> Branch</span>
                                        </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?branch_id=<?php echo $branch_id; ?>" class="btn btn-primary">
                                            <i class="fas fa-shopping-cart me-2"></i>Create Purchase Order
                                        </a>
                                        <a href="inventory-stock.php" class="btn btn-outline-info">
                                            <i class="fas fa-boxes me-2"></i>View All Stock
                                        </a>
                                    </div>
                                </div>
                            </div>
                            <div class="card-body">

<div class="row mb-4">
                                    <div class="col-12">
                                        <div class="alert alert-warning">
                                            <div class="d-flex align-items-center">
                                                <i class="fas fa-exclamation-triangle fa-2x me-3"></i>
                                                <div class="flex-grow-1">
                                                    <h5 class="alert-heading mb-1">Low Stock Alert Summary - <?php echo htmlspecialchars($branch_name); ?></h5>
                                                    <p class="mb-0">
                                                        <strong><?php echo htmlspecialchars($branch_name); ?></strong> has 
                                                        <strong><?php 
                                                            $low_count_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_count_sql)->fetch_assoc()['low_stock']); 
                                                        ?> products</strong> 
                                                        with low stock levels and <strong><?php 
                                                            $out_count_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_count_sql)->fetch_assoc()['out_stock']); 
                                                        ?> products</strong> 
                                                        that are out of stock. Consider creating purchase orders to replenish inventory for <?php echo htmlspecialchars($branch_name); ?>.
                                                    </p>
                                                </div>
                                                <div class="flex-shrink-0">
                                                    <button class="btn btn-outline-warning btn-sm" onclick="window.print()">
                                                        <i class="fas fa-print me-1"></i>Print Report for <?php echo htmlspecialchars($branch_name); ?>
                                                    </button>
                                                </div>
                                            </div>
                                        </div>
                                    </div>
                                </div>

<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 in <?php echo htmlspecialchars($branch_name); ?>..." value="<?php echo isset($_GET['search']) ? htmlspecialchars($_GET['search']) : ''; ?>">
                                            <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="stockLevelFilter">
                                            <option value="all">All Low Stock</option>
                                            <option value="critical" <?php echo (isset($_GET['stock_level']) && $_GET['stock_level'] == 'critical') ? 'selected' : ''; ?>>Critical (≤2)</option>
                                            <option value="low" <?php echo (isset($_GET['stock_level']) && $_GET['stock_level'] == 'low') ? 'selected' : ''; ?>>Low Stock</option>
                                            <option value="out" <?php echo (isset($_GET['stock_level']) && $_GET['stock_level'] == 'out') ? 'selected' : ''; ?>>Out of Stock</option>
                                        </select>
                                    </div>
                                    <div class="col-md-2">
                                        <select class="form-select" id="sortFilter">
                                            <option value="urgency" <?php echo (isset($_GET['sort']) && $_GET['sort'] == 'urgency') ? 'selected' : ''; ?>>Sort by Urgency</option>
                                            <option value="name" <?php echo (isset($_GET['sort']) && $_GET['sort'] == 'name') ? 'selected' : ''; ?>>Sort by Name</option>
                                            <option value="deficit" <?php echo (isset($_GET['sort']) && $_GET['sort'] == 'deficit') ? 'selected' : ''; ?>>Sort by Stock Deficit</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 for <?php echo htmlspecialchars($branch_name); ?></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 in <?php echo htmlspecialchars($branch_name); ?></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</th>
                                                <th>Category</th>
                                                <th>Brand</th>
                                                <th>Current Stock</th>
                                                <th>Min Stock</th>
                                                <th>Stock Status</th>
                                                <th>Urgency Level</th>
                                                <th>Cost Price</th>
                                                <th>Selling Price</th>
                                                <th>Profit/Unit</th>
                                                <th>Stock Value</th>
                                                <th>Sellable Value</th>
                                                <th>Potential Profit</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'";
                                            $where_conditions[] = "(p.stock_quantity <= p.min_stock OR p.stock_quantity = 0)";

// 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 level filter
                                            if (isset($_GET['stock_level']) && !empty($_GET['stock_level']) && $_GET['stock_level'] != 'all') {
                                                switch($_GET['stock_level']) {
                                                    case 'critical':
                                                        $where_conditions[] = "p.stock_quantity <= 2 AND p.stock_quantity > 0";
                                                        break;
                                                    case 'low':
                                                        $where_conditions[] = "p.stock_quantity <= p.min_stock AND p.stock_quantity > 2";
                                                        break;
                                                    case 'out':
                                                        $where_conditions[] = "p.stock_quantity = 0";
                                                        break;
                                                }
                                            }

// Search filter
                                            if (isset($_GET['search']) && !empty($_GET['search'])) {
                                                $search = $conn->real_escape_string($_GET['search']);
                                                $where_conditions[] = "(p.product_name LIKE '%$search%' OR b.brand_name LIKE '%$search%' OR p.model 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 = "";
                                            if (isset($_GET['sort']) && !empty($_GET['sort'])) {
                                                switch($_GET['sort']) {
                                                    case 'name':
                                                        $order_by = "p.product_name ASC";
                                                        break;
                                                    case 'deficit':
                                                        $order_by = "(p.min_stock - p.stock_quantity) DESC";
                                                        break;
                                                    case 'urgency':
                                                    default:
                                                        $order_by = "CASE 
                                                            WHEN p.stock_quantity = 0 THEN 1
                                                            WHEN p.stock_quantity <= 2 THEN 2
                                                            ELSE 3
                                                        END, p.stock_quantity ASC";
                                                        break;
                                                }
                                            } else {
                                                $order_by = "CASE 
                                                    WHEN p.stock_quantity = 0 THEN 1
                                                    WHEN p.stock_quantity <= 2 THEN 2
                                                    ELSE 3
                                                END, p.stock_quantity ASC";
                                            }

// 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 = 15;
                                            $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;
                                                
                                                while($product = $result->fetch_assoc()) {
                                                    // Stock status
                                                    $stock_status = '';
                                                    $stock_class = '';
                                                    $stock_icon = '';
                                                    $urgency_level = '';
                                                    $urgency_class = '';
                                                    $urgency_icon = '';
                                                    
                                                    if ($product['stock_quantity'] == 0) {
                                                        $stock_status = 'Out of Stock';
                                                        $stock_class = 'danger';
                                                        $stock_icon = 'fa-times-circle';
                                                        $urgency_level = 'High';
                                                        $urgency_class = 'danger';
                                                        $urgency_icon = 'fa-skull-crossbones';
                                                    } elseif ($product['stock_quantity'] <= 2) {
                                                        $stock_status = 'Critical';
                                                        $stock_class = 'danger';
                                                        $stock_icon = 'fa-exclamation-triangle';
                                                        $urgency_level = 'High';
                                                        $urgency_class = 'danger';
                                                        $urgency_icon = 'fa-exclamation-triangle';
                                                    } elseif ($product['stock_quantity'] <= $product['min_stock']) {
                                                        $stock_status = 'Low Stock';
                                                        $stock_class = 'warning';
                                                        $stock_icon = 'fa-exclamation-triangle';
                                                        $urgency_level = 'Medium';
                                                        $urgency_class = 'warning';
                                                        $urgency_icon = 'fa-exclamation-circle';
                                                    }

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

// Calculate stock deficit
                                                    $stock_deficit = $product['min_stock'] - $product['stock_quantity'];
                                                    if ($stock_deficit < 0) $stock_deficit = 0;

// 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']); ?></small>
                                                            <div><small class="text-primary"><i class="fas fa-store me-1"></i><?php echo htmlspecialchars($branch_name); ?></small></div>
                                                        </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>
                                                    </div>
                                                </td>
                                                <td>
                                                    <div class="text-center">
                                                        <strong class="h6 mb-0"><?php echo intval($product['min_stock']); ?></strong>
                                                        <div class="mt-1">
                                                            <small class="text-muted">min level</small>
                                                        </div>
                                                    </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>
                                                    <?php if ($stock_deficit > 0): ?>
                                                        <div class="mt-1">
                                                            <small class="text-<?php echo $stock_class; ?>">
                                                                <i class="fas fa-arrow-down"></i> 
                                                                <?php echo $stock_deficit; ?> below minimum
                                                            </small>
                                                        </div>
                                                    <?php endif; ?>
                                                </td>
                                                <td>
                                                    <span class="badge bg-<?php echo $urgency_class; ?>">
                                                        <i class="fas <?php echo $urgency_icon; ?> me-1"></i><?php echo $urgency_level; ?> Priority
                                                    </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>
                                                        <br>
                                                        <small class="text-muted">(<?php echo number_format($profit_margin, 1); ?>%)</small>
                                                    </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 $potential_profit >= 0 ? 'text-success' : 'text-danger'; ?>">
                                                        ₹<?php echo number_format($potential_profit, 2); ?>
                                                    </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']); ?>&branch_id=<?php echo $branch_id; ?>" class="btn btn-outline-success" title="Create Purchase Order for <?php echo htmlspecialchars($branch_name); ?>">
                                                            <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 in <?php echo htmlspecialchars($branch_name); ?>">
                                                            <i class="fas fa-cog"></i>
                                                        </a>
                                                    </div>
                                                </td>
                                            </tr>
                                            <?php 
                                                } 
                                            } else { 
                                            ?>
                                            <tr>
                                                <td colspan="16" class="text-center py-4">
                                                    <i class="fas fa-check-circle display-4 text-success"></i>
                                                    <h5 class="mt-2">No Low Stock Items Found in <?php echo htmlspecialchars($branch_name); ?></h5>
                                                    <p class="text-muted">Congratulations! No low stock products found in <?php echo htmlspecialchars($branch_name); ?> with the current filter criteria.</p>
                                                    <a href="products-add.php?branch_id=<?php echo $branch_id; ?>" class="btn btn-primary">
                                                        <i class="fas fa-plus-circle me-2"></i>Add Products to <?php echo htmlspecialchars($branch_name); ?>
                                                    </a>
                                                </td>
                                            </tr>
                                            <?php } ?>
                                        </tbody>
                                    </table>
                                </div>

<?php if (isset($total_stock_value) && $total_stock_value > 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">Financial Summary for Low Stock Items - <?php echo htmlspecialchars($branch_name); ?> (Shown for current page)</h5>
                                            </div>
                                            <div class="card-body">
                                                <div class="row text-center">
                                                    <div class="col-md-3">
                                                        <h4 class="text-primary">₹<?php echo number_format($total_stock_value, 2); ?></h4>
                                                        <p class="text-muted mb-0">Total Cost Value<br><small><?php echo htmlspecialchars($branch_name); ?></small></p>
                                                    </div>
                                                    <div class="col-md-3">
                                                        <h4 class="text-purple">₹<?php echo number_format($total_sellable_value, 2); ?></h4>
                                                        <p class="text-muted mb-0">Total Sellable Value<br><small><?php echo htmlspecialchars($branch_name); ?></small></p>
                                                    </div>
                                                    <div class="col-md-3">
                                                        <h4 class="text-success">₹<?php echo number_format($total_potential_profit, 2); ?></h4>
                                                        <p class="text-muted mb-0">Total Potential Profit<br><small><?php echo htmlspecialchars($branch_name); ?></small></p>
                                                    </div>
                                                    <div class="col-md-3">
                                                        <?php
                                                        $overall_profit_percentage = $total_stock_value > 0 ? ($total_potential_profit / $total_stock_value) * 100 : 0;
                                                        ?>
                                                        <h4 class="text-info"><?php echo number_format($overall_profit_percentage, 1); ?>%</h4>
                                                        <p class="text-muted mb-0">Overall Profit Margin<br><small><?php echo htmlspecialchars($branch_name); ?></small></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 class="row mt-4">
                                    <div class="col-12">
                                        <div class="card">
                                            <div class="card-header">
                                                <h6 class="card-title mb-0">Quick Actions for <?php echo htmlspecialchars($branch_name); ?></h6>
                                            </div>
                                            <div class="card-body">
                                                <div class="d-flex gap-2 flex-wrap">
                                                    <a href="inventory-purchase.php?branch_id=<?php echo $branch_id; ?>" class="btn btn-success">
                                                        <i class="fas fa-shopping-cart me-2"></i>Create Purchase Order for <?php echo htmlspecialchars($branch_name); ?>
                                                    </a>
                                                    <a href="reports-stock.php?branch_id=<?php echo $branch_id; ?>" class="btn btn-outline-info">
                                                        <i class="fas fa-chart-bar me-2"></i>Stock Reports for <?php echo htmlspecialchars($branch_name); ?>
                                                    </a>
                                                    <a href="products-add.php?branch_id=<?php echo $branch_id; ?>" class="btn btn-outline-primary">
                                                        <i class="fas fa-plus-circle me-2"></i>Add New Products to <?php echo htmlspecialchars($branch_name); ?>
                                                    </a>
                                                    <button type="button" class="btn btn-outline-warning" onclick="window.print()">
                                                        <i class="fas fa-print me-2"></i>Print Low Stock Report for <?php echo htmlspecialchars($branch_name); ?>
                                                    </button>
                                                </div>
                                            </div>
                                        </div>
                                    </div>
                                </div>

</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="alert alert-primary">
                        <i class="fas fa-store me-2"></i><strong>Branch:</strong> <?php echo htmlspecialchars($branch_name); ?>
                    </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 in <?php echo htmlspecialchars($branch_name); ?></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 in <?php echo htmlspecialchars($branch_name); ?></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="alert alert-info">
                        <i class="fas fa-store me-2"></i><strong>Branch:</strong> <?php echo htmlspecialchars($branch_name); ?>
                    </div>
                    <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-warning">
                        <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> only.
                    </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 in <?php echo htmlspecialchars($branch_name); ?></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 in <?php echo htmlspecialchars($branch_name); ?>';
    }

// 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 from <?php echo htmlspecialchars($branch_name); ?> 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 for <?php echo htmlspecialchars($branch_name); ?>.');
                return;
            }

if (selectedProducts.length === 0) {
                alert('Please select at least one product from <?php echo htmlspecialchars($branch_name); ?>.');
                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 + '&branch_id=<?php echo $branch_id; ?>';
            } 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 urgency = 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 potentialProfit = cells[cellIndex++].textContent;
            
            productData.push({
                name: productName,
                category: category,
                brand: brand,
                currentStock: currentStock,
                minStock: minStock,
                status: stockStatus,
                urgency: urgency,
                costPrice: costPrice,
                sellingPrice: sellingPrice,
                profitUnit: profitUnit,
                stockValue: stockValue,
                sellableValue: sellableValue,
                potentialProfit: potentialProfit
            });
        });

// Create CSV content
        let csvContent = "Product Name,Category,Brand,Current Stock,Min Stock,Stock Status,Urgency Level,Cost Price,Selling Price,Profit/Unit,Stock Value,Sellable Value,Potential Profit,Branch\n";
        
        productData.forEach(product => {
            csvContent += `"${product.name}","${product.category}","${product.brand}","${product.currentStock}","${product.minStock}","${product.status}","${product.urgency}","${product.costPrice}","${product.sellingPrice}","${product.profitUnit}","${product.stockValue}","${product.sellableValue}","${product.potentialProfit}","<?php echo htmlspecialchars($branch_name); ?>"\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', 'low_stock_products_<?php echo str_replace(' ', '_', strtolower($branch_name)); ?>_<?php echo date('Y-m-d'); ?>.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 (stockLevelFilter && stockLevelFilter.value && stockLevelFilter.value !== 'all') params.set('stock_level', stockLevelFilter.value);
        if (sortFilter && sortFilter.value) params.set('sort', sortFilter.value);
        if (searchInput && searchInput.value) params.set('search', searchInput.value);
        
        window.location.href = 'inventory-lowstock.php?' + params.toString();
    }

// Clear filters
    if (clearFilters) {
        clearFilters.addEventListener('click', function() {
            window.location.href = 'inventory-lowstock.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 (stockLevelFilter) stockLevelFilter.addEventListener('change', applyFilters);
    if (sortFilter) sortFilter.addEventListener('change', applyFilters);

// Auto-refresh every 30 seconds
    setInterval(function() {
        // placeholder for live refresh if desired
    }, 30000);
});
</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-lowstock.php?' . http_build_query($params);
}

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

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: inventory-lowstock.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation