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

🔧 Quick Actions

✏️ Editing: reports-inventory.php

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

// Check if user is logged in as branch
if (!isset($_SESSION['branch_id'])) {
    header("Location: login.php");
    exit();
}

// Get branch ID from session
$branch_id = $_SESSION['branch_id'];

// Get branch info for display
$branch_sql = "SELECT branch_name, branch_code FROM branches WHERE id = $branch_id";
$branch_result = $conn->query($branch_sql);
$branch_info = $branch_result->fetch_assoc();

// Get filter parameters
$category_filter = isset($_GET['category']) ? intval($_GET['category']) : '';
$brand_filter = isset($_GET['brand']) ? intval($_GET['brand']) : '';
$stock_level_filter = isset($_GET['stock_level']) ? $_GET['stock_level'] : '';
$date_from = isset($_GET['date_from']) ? $_GET['date_from'] : '';
$date_to = isset($_GET['date_to']) ? $_GET['date_to'] : '';
$report_type = isset($_GET['report_type']) ? $_GET['report_type'] : 'stock_summary';

// Get summary statistics for the branch
$total_products_sql = "SELECT COUNT(*) as total FROM products WHERE status = 'active' AND branch_id = $branch_id";
$total_products = $conn->query($total_products_sql)->fetch_assoc()['total'];

$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";
$low_stock_count = $conn->query($low_stock_sql)->fetch_assoc()['low_stock'];

$out_stock_sql = "SELECT COUNT(*) as out_stock FROM products WHERE status = 'active' AND branch_id = $branch_id AND stock_quantity = 0";
$out_stock_count = $conn->query($out_stock_sql)->fetch_assoc()['out_stock'];

// Enhanced financial statistics for the branch
$financial_stats_sql = "SELECT 
    SUM(stock_quantity * purchase_price) as total_stock_value,
    SUM(stock_quantity * selling_price) as total_sellable_value,
    SUM(stock_quantity * (selling_price - purchase_price)) as total_potential_profit,
    AVG(selling_price - purchase_price) as avg_profit_margin,
    COUNT(DISTINCT product_name) as unique_products
FROM products WHERE status = 'active' AND branch_id = $branch_id";
    
$financial_stats = $conn->query($financial_stats_sql)->fetch_assoc();
$total_stock_value = $financial_stats['total_stock_value'] ?? 0;
$total_sellable_value = $financial_stats['total_sellable_value'] ?? 0;
$total_potential_profit = $financial_stats['total_potential_profit'] ?? 0;
$avg_profit_margin = $financial_stats['avg_profit_margin'] ?? 0;
$unique_products = $financial_stats['unique_products'] ?? 0;
?>

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

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

<div id="layout-wrapper">

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

<div class="vertical-menu">
        <div data-simplebar class="h-100">
            
            <?php include('includes/sidebar.php')?>
            
        </div>
    </div>

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

<div class="branch-info">
                    <div class="row align-items-center">
                        <div class="col-md-8">
                            <h4 class="mb-1">
                                <i class="fas fa-store-alt me-2"></i>
                                <?php echo htmlspecialchars($branch_info['branch_name']); ?>
                                <span class="badge bg-primary"><?php echo $branch_info['branch_code']; ?></span>
                            </h4>
                            <p class="text-muted mb-0">
                                <i class="fas fa-info-circle me-1"></i>
                                Viewing inventory reports for your branch only
                            </p>
                        </div>
                        <div class="col-md-4 text-end">
                            <a href="inventory-purchase-add.php" class="btn btn-primary">
                                <i class="fas fa-shopping-cart me-2"></i>Add Purchase
                            </a>
                        </div>
                    </div>
                </div>

<div class="row">
                    <div class="col-md-3">
                        <div class="card bg-primary text-white">
                            <div class="card-body">
                                <div class="d-flex justify-content-between">
                                    <div>
                                        <h4 class="mb-0"><?php echo $unique_products; ?></h4>
                                        <p class="mb-0">Unique Products</p>
                                    </div>
                                    <div class="align-self-center">
                                        <i class="fas fa-boxes 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 echo $low_stock_count; ?></h4>
                                        <p class="mb-0">Low Stock Items</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-success text-white">
                            <div class="card-body">
                                <div class="d-flex justify-content-between">
                                    <div>
                                        <h4 class="mb-0">₹<?php echo number_format($total_sellable_value, 2); ?></h4>
                                        <p class="mb-0">Sellable Value</p>
                                    </div>
                                    <div class="align-self-center">
                                        <i class="fas fa-rupee-sign 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 echo number_format($total_potential_profit, 2); ?></h4>
                                        <p class="mb-0">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>

<div class="row mt-4">
                    <div class="col-lg-12">
                        <div class="card">
                            <div class="card-header">
                                <div class="d-flex justify-content-between align-items-center flex-wrap">
                                    <h5 class="card-title mb-0">Branch Inventory Reports Dashboard</h5>
                                    <div class="d-flex gap-2 flex-wrap">
                                        <button type="button" class="btn btn-success" onclick="exportToExcel()">
                                            <i class="fas fa-file-excel me-2"></i>Export to Excel
                                        </button>
                                        <button type="button" class="btn btn-danger" onclick="window.print()">
                                            <i class="fas fa-print me-2"></i>Print Report
                                        </button>
                                        <a href="inventory-stock.php" class="btn btn-outline-primary">
                                            <i class="fas fa-boxes me-2"></i>View Stock
                                        </a>
                                    </div>
                                </div>
                            </div>
                            <div class="card-body">

<form method="GET" action="" id="reportForm">
                                    <div class="row mb-4">
                                        <div class="col-12">
                                            <div class="btn-group w-100" role="group">
                                                <input type="radio" class="btn-check" name="report_type" id="stock_summary" value="stock_summary" <?php echo $report_type == 'stock_summary' ? 'checked' : ''; ?> onchange="this.form.submit()">
                                                <label class="btn btn-outline-primary" for="stock_summary">Stock Summary</label>

<input type="radio" class="btn-check" name="report_type" id="low_stock" value="low_stock" <?php echo $report_type == 'low_stock' ? 'checked' : ''; ?> onchange="this.form.submit()">
                                                <label class="btn btn-outline-warning" for="low_stock">Low Stock</label>

<input type="radio" class="btn-check" name="report_type" id="stock_movement" value="stock_movement" <?php echo $report_type == 'stock_movement' ? 'checked' : ''; ?> onchange="this.form.submit()">
                                                <label class="btn btn-outline-info" for="stock_movement">Stock Movement</label>

<input type="radio" class="btn-check" name="report_type" id="purchase_summary" value="purchase_summary" <?php echo $report_type == 'purchase_summary' ? 'checked' : ''; ?> onchange="this.form.submit()">
                                                <label class="btn btn-outline-success" for="purchase_summary">Purchase Summary</label>
                                            </div>
                                        </div>
                                    </div>

<div class="row mb-4">
                                        <div class="col-md-3">
                                            <div class="mb-3">
                                                <label class="form-label">Category</label>
                                                <select class="form-select" name="category" onchange="this.form.submit()">
                                                    <option value="">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 = ($category_filter == $cat['id']) ? 'selected' : '';
                                                        echo '<option value="' . $cat['id'] . '" ' . $selected . '>' . htmlspecialchars($cat['category_name']) . '</option>';
                                                    }
                                                    ?>
                                                </select>
                                            </div>
                                        </div>
                                        <div class="col-md-3">
                                            <div class="mb-3">
                                                <label class="form-label">Brand</label>
                                                <select class="form-select" name="brand" onchange="this.form.submit()">
                                                    <option value="">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 = ($brand_filter == $brand['id']) ? 'selected' : '';
                                                        echo '<option value="' . $brand['id'] . '" ' . $selected . '>' . htmlspecialchars($brand['brand_name']) . '</option>';
                                                    }
                                                    ?>
                                                </select>
                                            </div>
                                        </div>
                                        <div class="col-md-2">
                                            <div class="mb-3">
                                                <label class="form-label">Stock Level</label>
                                                <select class="form-select" name="stock_level" onchange="this.form.submit()">
                                                    <option value="">All Stock</option>
                                                    <option value="critical" <?php echo ($stock_level_filter == 'critical') ? 'selected' : ''; ?>>Critical (≤2)</option>
                                                    <option value="low" <?php echo ($stock_level_filter == 'low') ? 'selected' : ''; ?>>Low Stock</option>
                                                    <option value="out" <?php echo ($stock_level_filter == 'out') ? 'selected' : ''; ?>>Out of Stock</option>
                                                    <option value="healthy" <?php echo ($stock_level_filter == 'healthy') ? 'selected' : ''; ?>>Healthy Stock</option>
                                                </select>
                                            </div>
                                        </div>
                                        <div class="col-md-2">
                                            <div class="mb-3">
                                                <label class="form-label">Date From</label>
                                                <input type="date" class="form-control" name="date_from" value="<?php echo htmlspecialchars($date_from); ?>" onchange="this.form.submit()">
                                            </div>
                                        </div>
                                        <div class="col-md-2">
                                            <div class="mb-3">
                                                <label class="form-label">Date To</label>
                                                <input type="date" class="form-control" name="date_to" value="<?php echo htmlspecialchars($date_to); ?>" onchange="this.form.submit()">
                                            </div>
                                        </div>
                                    </div>

<div class="row mb-4">
                                        <div class="col-12">
                                            <div class="d-flex gap-2 flex-wrap">
                                                <a href="reports-inventory.php" class="btn btn-outline-secondary">
                                                    <i class="fas fa-times me-2"></i>Clear Filters
                                                </a>
                                                <div class="ms-auto">
                                                    <span class="badge bg-info" id="reportSummary">
                                                        <?php
                                                        // Generate summary text based on report type
                                                        switch($report_type) {
                                                            case 'stock_summary':
                                                                echo "Stock Summary Report";
                                                                break;
                                                            case 'low_stock':
                                                                echo "Low Stock Alert Report";
                                                                break;
                                                            case 'stock_movement':
                                                                echo "Stock Movement Report";
                                                                break;
                                                            case 'purchase_summary':
                                                                echo "Purchase Summary Report";
                                                                break;
                                                        }
                                                        ?>
                                                    </span>
                                                </div>
                                            </div>
                                        </div>
                                    </div>
                                </form>

<div class="row">
                                    <div class="col-12">
                                        <div id="reportContent">
                                            <?php
                                            // Display the appropriate report based on report type
                                            switch($report_type) {
                                                case 'low_stock':
                                                    displayLowStockReport($conn, $category_filter, $brand_filter, $stock_level_filter, $branch_id);
                                                    break;
                                                case 'stock_movement':
                                                    displayStockMovementReport($conn, $category_filter, $brand_filter, $date_from, $date_to, $branch_id);
                                                    break;
                                                case 'purchase_summary':
                                                    displayPurchaseSummaryReport($conn, $category_filter, $brand_filter, $date_from, $date_to, $branch_id);
                                                    break;
                                                case 'stock_summary':
                                                default:
                                                    displayStockSummaryReport($conn, $category_filter, $brand_filter, $stock_level_filter, $branch_id);
                                                    break;
                                            }
                                            ?>
                                        </div>
                                    </div>
                                </div>

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

</div>
            
        </div>

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

</div>

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

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

// Auto-refresh page every 5 minutes
setInterval(() => {
    window.location.reload();
}, 300000);
</script>

</body>
</html>

<?php
// Report Display Functions

function displayStockSummaryReport($conn, $category_filter, $brand_filter, $stock_level_filter, $branch_id) {
    // Build where conditions with branch filter
    $where_conditions = ["p.status = 'active'", "p.branch_id = $branch_id"];
    $params = [];
    $param_types = '';

if ($category_filter) {
        $where_conditions[] = "p.category_id = ?";
        $params[] = $category_filter;
        $param_types .= 'i';
    }

if ($brand_filter) {
        $where_conditions[] = "p.brand_id = ?";
        $params[] = $brand_filter;
        $param_types .= 'i';
    }

$where_sql = implode(" AND ", $where_conditions);

// Group products by name to get total quantities and values
    $sql = "SELECT 
                p.product_name,
                p.model,
                c.category_name,
                b.brand_name,
                MAX(p.purchase_price) as purchase_price,
                MAX(p.selling_price) as selling_price,
                MAX(p.min_stock) as min_stock,
                SUM(p.stock_quantity) as total_quantity,
                SUM(p.stock_quantity * p.purchase_price) as total_stock_value,
                SUM(p.stock_quantity * p.selling_price) as total_sellable_value,
                SUM(p.stock_quantity * (p.selling_price - p.purchase_price)) as total_potential_profit,
                AVG(p.selling_price - p.purchase_price) as avg_profit_per_unit
            FROM products p 
            LEFT JOIN categories c ON p.category_id = c.id 
            LEFT JOIN brands b ON p.brand_id = b.id 
            WHERE $where_sql 
            GROUP BY p.product_name, p.model, c.category_name, b.brand_name
            ORDER BY total_quantity ASC, p.product_name ASC";

if ($params) {
        $stmt = $conn->prepare($sql);
        $stmt->bind_param($param_types, ...$params);
        $stmt->execute();
        $result = $stmt->get_result();
    } else {
        $result = $conn->query($sql);
    }

// Apply stock level filtering after grouping
    $filtered_products = [];
    $total_stock_value = 0;
    $total_sellable_value = 0;
    $total_potential_profit = 0;
    $total_items = 0;

while($product = $result->fetch_assoc()) {
        // Apply stock level filter
        $include_product = true;
        if ($stock_level_filter) {
            switch($stock_level_filter) {
                case 'critical':
                    $include_product = ($product['total_quantity'] <= 2 && $product['total_quantity'] > 0);
                    break;
                case 'low':
                    $include_product = ($product['total_quantity'] <= $product['min_stock'] && $product['total_quantity'] > 2);
                    break;
                case 'out':
                    $include_product = ($product['total_quantity'] == 0);
                    break;
                case 'healthy':
                    $include_product = ($product['total_quantity'] > $product['min_stock']);
                    break;
            }
        }

if ($include_product) {
            $filtered_products[] = $product;
            $total_stock_value += $product['total_stock_value'];
            $total_sellable_value += $product['total_sellable_value'];
            $total_potential_profit += $product['total_potential_profit'];
            $total_items++;
        }
    }
    ?>
    
    <div class="card">
        <div class="card-header">
            <h5 class="card-title mb-0">
                <i class="fas fa-boxes me-2"></i>Branch Stock Summary Report
                <small class="text-muted">(Products grouped by name with total quantities)</small>
            </h5>
        </div>
        <div class="card-body">
            <?php if (count($filtered_products) > 0): ?>
                
                <div class="row mb-4">
                    <div class="col-md-4">
                        <div class="card bg-primary text-white">
                            <div class="card-body">
                                <div class="d-flex justify-content-between">
                                    <div>
                                        <h4 class="mb-0">₹<?php echo number_format($total_stock_value, 2); ?></h4>
                                        <p class="mb-0">Total Stock 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-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 echo number_format($total_sellable_value, 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-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 echo number_format($total_potential_profit, 2); ?></h4>
                                        <p class="mb-0">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>

<div class="table-responsive">
                    <table class="table table-bordered table-hover" id="reportTable">
                        <thead class="table-light">
                            <tr>
                                <th>Product</th>
                                <th>Category</th>
                                <th>Brand</th>
                                <th>Total Quantity</th>
                                <th>Min Stock</th>
                                <th>Stock Status</th>
                                <th>Purchase Price</th>
                                <th>Selling Price</th>
                                <th>Profit/Unit</th>
                                <th>Stock Value</th>
                                <th>Sellable Value</th>
                                <th>Potential Profit</th>
                            </tr>
                        </thead>
                        <tbody>
                            <?php foreach($filtered_products as $product): 
                                // Stock status
                                $stock_status = '';
                                $stock_class = '';
                                if ($product['total_quantity'] == 0) {
                                    $stock_status = 'Out of Stock';
                                    $stock_class = 'stock-out';
                                } elseif ($product['total_quantity'] <= 2) {
                                    $stock_status = 'Critical';
                                    $stock_class = 'stock-critical';
                                } elseif ($product['total_quantity'] <= $product['min_stock']) {
                                    $stock_status = 'Low Stock';
                                    $stock_class = 'stock-low';
                                } else {
                                    $stock_status = 'Healthy';
                                    $stock_class = 'stock-healthy';
                                }

// Profit per unit
                                $profit_per_unit = $product['selling_price'] - $product['purchase_price'];
                                $profit_class = $profit_per_unit >= 0 ? 'profit-positive' : 'profit-negative';
                            ?>
                            <tr class="<?php echo $stock_class; ?>">
                                <td>
                                    <strong><?php echo htmlspecialchars($product['product_name']); ?></strong>
                                    <br><small class="text-muted"><?php echo htmlspecialchars($product['model']); ?></small>
                                </td>
                                <td><?php echo htmlspecialchars($product['category_name']); ?></td>
                                <td><?php echo htmlspecialchars($product['brand_name']); ?></td>
                                <td class="text-center">
                                    <strong><?php echo $product['total_quantity']; ?></strong>
                                </td>
                                <td class="text-center"><?php echo $product['min_stock']; ?></td>
                                <td>
                                    <span class="badge 
                                        <?php echo $product['total_quantity'] == 0 ? 'bg-danger' : 
                                               ($product['total_quantity'] <= 2 ? 'bg-danger' : 
                                               ($product['total_quantity'] <= $product['min_stock'] ? 'bg-warning' : 'bg-success')); ?>">
                                        <?php echo $stock_status; ?>
                                    </span>
                                </td>
                                <td class="text-end">₹<?php echo number_format($product['purchase_price'], 2); ?></td>
                                <td class="text-end">₹<?php echo number_format($product['selling_price'], 2); ?></td>
                                <td class="text-end <?php echo $profit_class; ?>">
                                    ₹<?php echo number_format($profit_per_unit, 2); ?>
                                </td>
                                <td class="text-end">₹<?php echo number_format($product['total_stock_value'], 2); ?></td>
                                <td class="text-end">₹<?php echo number_format($product['total_sellable_value'], 2); ?></td>
                                <td class="text-end <?php echo $profit_class; ?>">
                                    ₹<?php echo number_format($product['total_potential_profit'], 2); ?>
                                </td>
                            </tr>
                            <?php endforeach; ?>
                        </tbody>
                        <tfoot class="table-light">
                            <tr>
                                <td colspan="9" class="text-end"><strong>Totals:</strong></td>
                                <td class="text-end"><strong>₹<?php echo number_format($total_stock_value, 2); ?></strong></td>
                                <td class="text-end"><strong>₹<?php echo number_format($total_sellable_value, 2); ?></strong></td>
                                <td class="text-end"><strong class="profit-positive">₹<?php echo number_format($total_potential_profit, 2); ?></strong></td>
                            </tr>
                            <tr>
                                <td colspan="12" class="text-center">
                                    <small class="text-muted">
                                        Total Products: <?php echo $total_items; ?> | 
                                        Total Stock Value: ₹<?php echo number_format($total_stock_value, 2); ?> | 
                                        Total Sellable Value: ₹<?php echo number_format($total_sellable_value, 2); ?> | 
                                        Potential Profit: ₹<?php echo number_format($total_potential_profit, 2); ?>
                                    </small>
                                </td>
                            </tr>
                        </tfoot>
                    </table>
                </div>
            <?php else: ?>
                <div class="text-center py-4">
                    <i class="fas fa-box-open display-4 text-muted"></i>
                    <h5 class="mt-3">No Products Found</h5>
                    <p class="text-muted">No products match your current filter criteria in your branch.</p>
                </div>
            <?php endif; ?>
        </div>
    </div>
    <?php
}

function displayLowStockReport($conn, $category_filter, $brand_filter, $stock_level_filter, $branch_id) {
    // Build where conditions for low stock - group by product name first with branch filter
    $where_conditions = ["p.status = 'active'", "p.branch_id = $branch_id"];
    $params = [];
    $param_types = '';

if ($category_filter) {
        $where_conditions[] = "p.category_id = ?";
        $params[] = $category_filter;
        $param_types .= 'i';
    }

if ($brand_filter) {
        $where_conditions[] = "p.brand_id = ?";
        $params[] = $brand_filter;
        $param_types .= 'i';
    }

$where_sql = implode(" AND ", $where_conditions);

// Group products by name to get total quantities
    $sql = "SELECT 
                p.product_name,
                p.model,
                c.category_name,
                b.brand_name,
                MAX(p.purchase_price) as purchase_price,
                MAX(p.selling_price) as selling_price,
                MAX(p.min_stock) as min_stock,
                SUM(p.stock_quantity) as total_quantity,
                (MAX(p.min_stock) - SUM(p.stock_quantity)) as stock_deficit,
                MAX(p.updated_at) as last_updated
            FROM products p 
            LEFT JOIN categories c ON p.category_id = c.id 
            LEFT JOIN brands b ON p.brand_id = b.id 
            WHERE $where_sql 
            GROUP BY p.product_name, p.model, c.category_name, b.brand_name
            HAVING total_quantity <= MAX(p.min_stock) OR total_quantity = 0
            ORDER BY total_quantity ASC, stock_deficit DESC";

// Apply additional stock level filtering after grouping
    $filtered_products = [];
    $critical_count = 0;
    $low_count = 0;
    $out_count = 0;
    $total_items = 0;

while($product = $result->fetch_assoc()) {
        $include_product = true;
        if ($stock_level_filter) {
            switch($stock_level_filter) {
                case 'critical':
                    $include_product = ($product['total_quantity'] <= 2 && $product['total_quantity'] > 0);
                    break;
                case 'low':
                    $include_product = ($product['total_quantity'] <= $product['min_stock'] && $product['total_quantity'] > 2);
                    break;
                case 'out':
                    $include_product = ($product['total_quantity'] == 0);
                    break;
            }
        }

if ($include_product) {
            $filtered_products[] = $product;
            $total_items++;
            
            if ($product['total_quantity'] == 0) {
                $out_count++;
            } elseif ($product['total_quantity'] <= 2) {
                $critical_count++;
            } elseif ($product['total_quantity'] <= $product['min_stock']) {
                $low_count++;
            }
        }
    }
    ?>

<div class="card">
        <div class="card-header">
            <h5 class="card-title mb-0">
                <i class="fas fa-exclamation-triangle me-2"></i>Branch Low Stock Alert Report
                <small class="text-muted">(Products grouped by name with total quantities)</small>
            </h5>
        </div>
        <div class="card-body">
            <?php if (count($filtered_products) > 0): ?>
                
                <div class="row mb-4">
                    <div class="col-md-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 echo $critical_count; ?></h4>
                                        <p class="mb-0">Critical Stock</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-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 echo $low_count; ?></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-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 echo $out_count; ?></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>

<div class="table-responsive">
                    <table class="table table-bordered table-hover" id="reportTable">
                        <thead class="table-light">
                            <tr>
                                <th>Product</th>
                                <th>Category</th>
                                <th>Brand</th>
                                <th>Total Quantity</th>
                                <th>Min Stock</th>
                                <th>Stock Deficit</th>
                                <th>Stock Status</th>
                                <th>Urgency</th>
                                <th>Last Updated</th>
                                <th>Action</th>
                            </tr>
                        </thead>
                        <tbody>
                            <?php foreach($filtered_products as $product): 
                                // Stock status and urgency
                                $stock_status = '';
                                $stock_class = '';
                                $urgency_level = '';
                                $urgency_class = '';
                                $urgency_icon = '';
                                
                                if ($product['total_quantity'] == 0) {
                                    $stock_status = 'Out of Stock';
                                    $stock_class = 'stock-out';
                                    $urgency_level = 'High';
                                    $urgency_class = 'danger';
                                    $urgency_icon = 'fa-skull-crossbones';
                                } elseif ($product['total_quantity'] <= 2) {
                                    $stock_status = 'Critical';
                                    $stock_class = 'stock-critical';
                                    $urgency_level = 'High';
                                    $urgency_class = 'danger';
                                    $urgency_icon = 'fa-exclamation-triangle';
                                } elseif ($product['total_quantity'] <= $product['min_stock']) {
                                    $stock_status = 'Low Stock';
                                    $stock_class = 'stock-low';
                                    $urgency_level = 'Medium';
                                    $urgency_class = 'warning';
                                    $urgency_icon = 'fa-exclamation-circle';
                                }

// Last updated time
                                $last_updated = '';
                                $update_class = '';
                                if (date('Y-m-d') == date('Y-m-d', strtotime($product['last_updated']))) {
                                    $last_updated = 'Today ' . date('g:i A', strtotime($product['last_updated']));
                                    $update_class = 'text-success';
                                } else {
                                    $last_updated = date('M j, Y g:i A', strtotime($product['last_updated']));
                                    $update_class = 'text-muted';
                                }
                            ?>
                            <tr class="<?php echo $stock_class; ?>">
                                <td>
                                    <strong><?php echo htmlspecialchars($product['product_name']); ?></strong>
                                    <br><small class="text-muted"><?php echo htmlspecialchars($product['model']); ?></small>
                                </td>
                                <td><?php echo htmlspecialchars($product['category_name']); ?></td>
                                <td><?php echo htmlspecialchars($product['brand_name']); ?></td>
                                <td class="text-center">
                                    <strong><?php echo $product['total_quantity']; ?></strong>
                                </td>
                                <td class="text-center"><?php echo $product['min_stock']; ?></td>
                                <td class="text-center">
                                    <?php if ($product['stock_deficit'] > 0): ?>
                                        <span class="badge bg-danger"><?php echo $product['stock_deficit']; ?> units</span>
                                    <?php else: ?>
                                        <span class="badge bg-secondary">0</span>
                                    <?php endif; ?>
                                </td>
                                <td>
                                    <span class="badge bg-<?php echo $urgency_class; ?>">
                                        <i class="fas <?php echo $urgency_icon; ?> me-1"></i><?php echo $stock_status; ?>
                                    </span>
                                </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>
                                    <small class="<?php echo $update_class; ?>"><?php echo $last_updated; ?></small>
                                </td>
                                <td>
                                    <a href="inventory-purchase-add.php" class="btn btn-sm btn-success">
                                        <i class="fas fa-cart-plus"></i> Purchase
                                    </a>
                                </td>
                            </tr>
                            <?php endforeach; ?>
                        </tbody>
                        <tfoot class="table-light">
                            <tr>
                                <td colspan="10" class="text-center">
                                    <small class="text-muted">
                                        Total Low Stock Items in Branch: <?php echo $total_items; ?> | 
                                        Critical: <?php echo $critical_count; ?> | 
                                        Low: <?php echo $low_count; ?> | 
                                        Out of Stock: <?php echo $out_count; ?>
                                    </small>
                                </td>
                            </tr>
                        </tfoot>
                    </table>
                </div>
            <?php else: ?>
                <div class="text-center py-4">
                    <i class="fas fa-check-circle display-4 text-success"></i>
                    <h5 class="mt-3">No Low Stock Items</h5>
                    <p class="text-muted">All products have sufficient stock levels in your branch.</p>
                </div>
            <?php endif; ?>
        </div>
    </div>
    <?php
}

function displayStockMovementReport($conn, $category_filter, $brand_filter, $date_from, $date_to, $branch_id) {
    // This is a simplified version - you would need to implement actual stock movement tracking
    ?>
    <div class="card">
        <div class="card-header">
            <h5 class="card-title mb-0">
                <i class="fas fa-exchange-alt me-2"></i>Branch Stock Movement Report
            </h5>
        </div>
        <div class="card-body">
            <div class="alert alert-info">
                <i class="fas fa-info-circle me-2"></i>
                Stock movement tracking requires additional database tables for sales and purchase history.
                This feature can be implemented with proper transaction tracking.
            </div>
            
            <div class="table-responsive">
                <table class="table table-bordered table-hover" id="reportTable">
                    <thead class="table-light">
                        <tr>
                            <th>Date</th>
                            <th>Product</th>
                            <th>Type</th>
                            <th>Quantity</th>
                            <th>Reference</th>
                            <th>User</th>
                        </tr>
                    </thead>
                    <tbody>
                        <tr>
                            <td colspan="6" class="text-center text-muted py-4">
                                <i class="fas fa-cogs display-4"></i>
                                <h5 class="mt-3">Feature Under Development</h5>
                                <p>Branch stock movement tracking will be available in the next update.</p>
                            </td>
                        </tr>
                    </tbody>
                </table>
            </div>
        </div>
    </div>
    <?php
}

function displayPurchaseSummaryReport($conn, $category_filter, $brand_filter, $date_from, $date_to, $branch_id) {
    // Build where conditions for purchase orders
    $where_conditions = ["1=1"];
    $params = [];
    $param_types = '';

if ($date_from) {
        $where_conditions[] = "po.order_date >= ?";
        $params[] = $date_from;
        $param_types .= 's';
    }

if ($date_to) {
        $where_conditions[] = "po.order_date <= ?";
        $params[] = $date_to;
        $param_types .= 's';
    }

$where_sql = implode(" AND ", $where_conditions);

// Note: Purchase orders table doesn't have branch_id in your schema
    // This would need to be added for proper branch-based purchase tracking
    $sql = "SELECT po.*, s.name as supplier_name,
                   (SELECT COUNT(*) FROM purchase_order_items WHERE purchase_order_id = po.id) as item_count
            FROM purchase_orders po 
            LEFT JOIN suppliers s ON po.supplier_id = s.id 
            WHERE $where_sql 
            ORDER BY po.order_date DESC";

$total_orders = 0;
    $total_amount = 0;
    $pending_orders = 0;
    $completed_orders = 0;
    ?>

<div class="card">
        <div class="card-header">
            <h5 class="card-title mb-0">
                <i class="fas fa-shopping-cart me-2"></i>Branch Purchase Summary Report
                <small class="text-muted">Note: Purchase orders are shared across all branches</small>
            </h5>
        </div>
        <div class="card-body">
            <?php if ($result->num_rows > 0): ?>
                
                <div class="row mb-4">
                    <div class="col-md-3">
                        <div class="card bg-primary text-white">
                            <div class="card-body">
                                <div class="d-flex justify-content-between">
                                    <div>
                                        <h4 class="mb-0"><?php echo $result->num_rows; ?></h4>
                                        <p class="mb-0">Total Orders</p>
                                    </div>
                                    <div class="align-self-center">
                                        <i class="fas fa-shopping-cart 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
                                            $completed_sql = "SELECT COUNT(*) as count FROM purchase_orders WHERE status = 'completed'";
                                            $completed_result = $conn->query($completed_sql);
                                            echo $completed_result->fetch_assoc()['count'];
                                            ?>
                                        </h4>
                                        <p class="mb-0">Completed</p>
                                    </div>
                                    <div class="align-self-center">
                                        <i class="fas fa-check-circle 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
                                            $pending_sql = "SELECT COUNT(*) as count FROM purchase_orders WHERE status = 'pending'";
                                            $pending_result = $conn->query($pending_sql);
                                            echo $pending_result->fetch_assoc()['count'];
                                            ?>
                                        </h4>
                                        <p class="mb-0">Pending</p>
                                    </div>
                                    <div class="align-self-center">
                                        <i class="fas fa-clock 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_amount_sql = "SELECT SUM(total_amount) as total FROM purchase_orders";
                                            $total_amount_result = $conn->query($total_amount_sql);
                                            echo '₹' . number_format($total_amount_result->fetch_assoc()['total'] ?? 0, 2);
                                            ?>
                                        </h4>
                                        <p class="mb-0">Total Value</p>
                                    </div>
                                    <div class="align-self-center">
                                        <i class="fas fa-rupee-sign display-4 opacity-50"></i>
                                    </div>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>

<div class="table-responsive">
                    <table class="table table-bordered table-hover" id="reportTable">
                        <thead class="table-light">
                            <tr>
                                <th>PO Number</th>
                                <th>Supplier</th>
                                <th>Order Date</th>
                                <th>Expected Date</th>
                                <th>Items</th>
                                <th>Total Amount</th>
                                <th>Status</th>
                                <th>Actions</th>
                            </tr>
                        </thead>
                        <tbody>
                            <?php while($order = $result->fetch_assoc()): 
                                $total_orders++;
                                $total_amount += $order['total_amount'];
                                
                                // Status badge
                                $status_badge = '';
                                switch($order['status']) {
                                    case 'pending':
                                        $status_badge = '<span class="badge bg-warning"><i class="fas fa-clock me-1"></i>Pending</span>';
                                        $pending_orders++;
                                        break;
                                    case 'shipped':
                                        $status_badge = '<span class="badge bg-info"><i class="fas fa-shipping-fast me-1"></i>Shipped</span>';
                                        break;
                                    case 'completed':
                                        $status_badge = '<span class="badge bg-success"><i class="fas fa-check-circle me-1"></i>Completed</span>';
                                        $completed_orders++;
                                        break;
                                    case 'cancelled':
                                        $status_badge = '<span class="badge bg-danger"><i class="fas fa-times-circle me-1"></i>Cancelled</span>';
                                        break;
                                }

// Date formatting
                                $order_date = date('M j, Y', strtotime($order['order_date']));
                                $expected_date = date('M j, Y', strtotime($order['expected_date']));
                            ?>
                            <tr>
                                <td>
                                    <strong class="text-primary"><?php echo $order['po_number']; ?></strong>
                                </td>
                                <td><?php echo htmlspecialchars($order['supplier_name']); ?></td>
                                <td><?php echo $order_date; ?></td>
                                <td><?php echo $expected_date; ?></td>
                                <td>
                                    <span class="badge bg-secondary"><?php echo $order['item_count']; ?> items</span>
                                </td>
                                <td class="text-end">
                                    <strong class="text-success">₹<?php echo number_format($order['total_amount'], 2); ?></strong>
                                </td>
                                <td><?php echo $status_badge; ?></td>
                                <td>
                                    <a href="inventory-purchase-view.php?id=<?php echo $order['id']; ?>" class="btn btn-sm btn-outline-primary">
                                        <i class="fas fa-eye"></i> View
                                    </a>
                                </td>
                            </tr>
                            <?php endwhile; ?>
                        </tbody>
                        <tfoot class="table-light">
                            <tr>
                                <td colspan="5" class="text-end"><strong>Totals:</strong></td>
                                <td class="text-end"><strong>₹<?php echo number_format($total_amount, 2); ?></strong></td>
                                <td colspan="2">
                                    <small class="text-muted">
                                        Total Orders: <?php echo $total_orders; ?> | 
                                        Completed: <?php echo $completed_orders; ?> | 
                                        Pending: <?php echo $pending_orders; ?>
                                    </small>
                                </td>
                            </tr>
                        </tfoot>
                    </table>
                </div>
            <?php else: ?>
                <div class="text-center py-4">
                    <i class="fas fa-shopping-cart display-4 text-muted"></i>
                    <h5 class="mt-3">No Purchase Orders Found</h5>
                    <p class="text-muted">No purchase orders match your current filter criteria.</p>
                </div>
            <?php endif; ?>
        </div>
    </div>
    <?php
}

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

❌ Cancel

🗂️ Enhanced PHP File Manager

📊 Server Information

🔧 Quick Actions

✏️ Editing: reports-inventory.php

📤 Upload File

📁 Create Folder

📄 Create File

✏️ Rename Item

🗑️ Delete Confirmation