@extends('layouts.app')
@section('title', 'Inventory Valuation')
@section('breadcrumb')
<li class="breadcrumb-item"><a href="#">Reports</a></li>
<li class="breadcrumb-item active">Inventory Valuation</li>
@endsection
@section('content')

<div class="page-header d-flex justify-content-between align-items-center">
    <div>
        <h1 class="page-title"><i class="bi bi-boxes me-2" style="color:#0284c7;"></i>Inventory Valuation</h1>
        <p class="page-subtitle">Current stock value as of {{ now()->format('d M Y H:i') }}</p>
    </div>
    <button onclick="window.print()" class="btn btn-outline-secondary btn-sm"><i class="bi bi-printer me-1"></i>Print</button>
</div>

<div class="card mb-3">
    <div class="card-body py-2">
        <form method="GET" class="row g-2 align-items-center">
            <div class="col-auto">
                <select name="category_id" class="form-select form-select-sm">
                    <option value="">All Categories</option>
                    @foreach($categories as $cat)<option value="{{ $cat->id }}" {{ request('category_id') == $cat->id ? 'selected' : '' }}>{{ $cat->name }}</option>@endforeach
                </select>
            </div>
            <div class="col-auto">
                <select name="brand_id" class="form-select form-select-sm">
                    <option value="">All Brands</option>
                    @foreach($brands as $br)<option value="{{ $br->id }}" {{ request('brand_id') == $br->id ? 'selected' : '' }}>{{ $br->name }}</option>@endforeach
                </select>
            </div>
            <div class="col-auto d-flex gap-1">
                <button type="submit" class="btn btn-primary btn-sm"><i class="bi bi-search me-1"></i>Filter</button>
                <a href="{{ route('reports.inventory') }}" class="btn btn-outline-secondary btn-sm"><i class="bi bi-x"></i></a>
                <button type="button" class="btn btn-outline-secondary btn-sm" onclick="window.print()"><i class="bi bi-printer"></i></button>
            </div>
        </form>
    </div>
</div>

<div class="row g-3 mb-3">
    <div class="col-6 col-md-3">
        <div class="stat-card"><div class="stat-icon" style="background:#dbeafe;"><i class="bi bi-boxes" style="color:#1d4ed8;"></i></div>
        <div><div class="stat-value">{{ number_format($summary['total_items']) }}</div><div class="stat-label">Unique Items</div></div></div>
    </div>
    <div class="col-6 col-md-3">
        <div class="stat-card"><div class="stat-icon" style="background:#d1fae5;"><i class="bi bi-stack" style="color:#059669;"></i></div>
        <div><div class="stat-value">{{ number_format($summary['total_qty']) }}</div><div class="stat-label">Total Units</div></div></div>
    </div>
    <div class="col-6 col-md-3">
        <div class="stat-card"><div class="stat-icon" style="background:#fef3c7;"><i class="bi bi-currency-exchange" style="color:#d97706;"></i></div>
        <div><div class="stat-value" style="font-size:.95rem;color:#d97706;">৳{{ number_format($summary['total_cost_value'],0) }}</div><div class="stat-label">Cost Value</div></div></div>
    </div>
    <div class="col-6 col-md-3">
        <div class="stat-card"><div class="stat-icon" style="background:#dcfce7;"><i class="bi bi-graph-up" style="color:#16a34a;"></i></div>
        <div><div class="stat-value" style="font-size:.95rem;color:#16a34a;">৳{{ number_format($summary['potential_profit'],0) }}</div><div class="stat-label">Potential Profit</div></div></div>
    </div>
</div>

<div class="row g-3 mb-3">
    <div class="col-12 col-md-5">
        <div class="card">
            <div class="card-header fw-600">By Category</div>
            <div class="card-body p-0">
                <table class="table table-sm mb-0" style="font-size:.82rem;">
                    <thead><tr><th>Category</th><th class="text-end">Items</th><th class="text-end">Qty</th><th class="text-end">Cost Value</th></tr></thead>
                    <tbody>
                        @foreach($byCategory as $catName => $cat)
                        <tr>
                            <td class="fw-600">{{ $catName }}</td>
                            <td class="text-end">{{ $cat['count'] }}</td>
                            <td class="text-end">{{ number_format($cat['qty']) }}</td>
                            <td class="text-end fw-700">৳{{ number_format($cat['cost_value'],0) }}</td>
                        </tr>
                        @endforeach
                    </tbody>
                    <tfoot style="background:#f8fafc;">
                        <tr>
                            <td class="fw-700">Total</td>
                            <td class="text-end fw-700">{{ $summary['total_items'] }}</td>
                            <td class="text-end fw-700">{{ number_format($summary['total_qty']) }}</td>
                            <td class="text-end fw-800" style="color:#059669;">৳{{ number_format($summary['total_cost_value'],0) }}</td>
                        </tr>
                    </tfoot>
                </table>
            </div>
        </div>
    </div>
    <div class="col-12 col-md-7">
        <div class="row g-2">
            <div class="col-6">
                <div class="card text-center p-3" style="border-left:3px solid #d97706;">
                    <div style="font-size:.72rem;font-weight:700;color:#d97706;text-transform:uppercase;">Low Stock</div>
                    <div style="font-size:2rem;font-weight:900;color:#d97706;">{{ $lowStock }}</div>
                    <a href="{{ route('inventory.index', ['stock'=>'low']) }}" class="btn btn-sm btn-outline-warning mt-1">View</a>
                </div>
            </div>
            <div class="col-6">
                <div class="card text-center p-3" style="border-left:3px solid #dc2626;">
                    <div style="font-size:.72rem;font-weight:700;color:#dc2626;text-transform:uppercase;">Out of Stock</div>
                    <div style="font-size:2rem;font-weight:900;color:#dc2626;">{{ $outOfStock }}</div>
                    <a href="{{ route('inventory.index', ['stock'=>'out']) }}" class="btn btn-sm btn-outline-danger mt-1">View</a>
                </div>
            </div>
        </div>
    </div>
</div>

<div class="card">
    <div class="card-header fw-600">Stock Valuation Detail ({{ $variants->count() }} items)</div>
    <div class="card-body p-0">
        <div class="table-responsive">
            <table class="table mb-0" style="font-size:.8rem;">
                <thead><tr><th>Product / Variant</th><th>SKU</th><th>Category</th><th class="text-end">Stock</th><th class="text-end">Cost Price</th><th class="text-end">Sell Price</th><th class="text-end">Cost Value</th><th class="text-end">Sell Value</th><th class="text-end">Potential Profit</th></tr></thead>
                <tbody>
                    @foreach($variants as $v)
                    <tr>
                        <td>
                            <div class="fw-600">{{ $v->product->name }}</div>
                            <div style="font-size:.72rem;color:#64748b;">{{ $v->variant_name }}</div>
                        </td>
                        <td><code style="font-size:.72rem;">{{ $v->sku }}</code></td>
                        <td style="font-size:.78rem;color:#64748b;">{{ $v->product->category?->name }}</td>
                        <td class="text-end">
                            <span class="badge {{ $v->current_stock <= 0 ? 'bg-danger' : ($v->is_low_stock ? 'bg-warning text-dark' : 'bg-success') }}">
                                {{ $v->current_stock }}
                            </span>
                        </td>
                        <td class="text-end">৳{{ number_format($v->cost_price,2) }}</td>
                        <td class="text-end">৳{{ number_format($v->selling_price,2) }}</td>
                        <td class="text-end fw-600">৳{{ number_format($v->current_stock * $v->cost_price,0) }}</td>
                        <td class="text-end" style="color:#059669;">৳{{ number_format($v->current_stock * $v->selling_price,0) }}</td>
                        <td class="text-end" style="color:{{ ($v->selling_price-$v->cost_price) >= 0 ? '#059669' : '#dc2626' }};">৳{{ number_format($v->current_stock * ($v->selling_price - $v->cost_price),0) }}</td>
                    </tr>
                    @endforeach
                </tbody>
                <tfoot style="background:#f8fafc;">
                    <tr>
                        <td colspan="6" class="fw-700 text-end">Totals:</td>
                        <td class="text-end fw-800">৳{{ number_format($summary['total_cost_value'],0) }}</td>
                        <td class="text-end fw-800" style="color:#059669;">৳{{ number_format($summary['total_sell_value'],0) }}</td>
                        <td class="text-end fw-800" style="color:#059669;">৳{{ number_format($summary['potential_profit'],0) }}</td>
                    </tr>
                </tfoot>
            </table>
        </div>
    </div>
</div>
@endsection