@extends('layouts.app')
@section('title', 'Profit by Product')
@section('breadcrumb')
<li class="breadcrumb-item"><a href="#">Reports</a></li>
<li class="breadcrumb-item active">Profit by Product</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-graph-up me-2" style="color:#059669;"></i>Profit by Product</h1>
        <p class="page-subtitle">{{ $from->format('d M Y') }} — {{ $to->format('d M Y') }}</p>
    </div>
    <button onclick="window.print()" class="btn btn-outline-secondary btn-sm"><i class="bi bi-printer me-1"></i>Print</button>
</div>

@include('reports.partials.date-filter')

<div class="row g-3 mb-3">
    <div class="col-4">
        <div class="stat-card"><div class="stat-icon" style="background:#dbeafe;"><i class="bi bi-cash-coin" style="color:#1d4ed8;"></i></div>
        <div><div class="stat-value" style="font-size:.95rem;color:#1d4ed8;">৳{{ number_format($summary->revenue,0) }}</div><div class="stat-label">Revenue</div></div></div>
    </div>
    <div class="col-4">
        <div class="stat-card"><div class="stat-icon" style="background:#fef3c7;"><i class="bi bi-cart" style="color:#d97706;"></i></div>
        <div><div class="stat-value" style="font-size:.95rem;color:#d97706;">৳{{ number_format($summary->cogs,0) }}</div><div class="stat-label">COGS</div></div></div>
    </div>
    <div class="col-4">
        <div class="stat-card"><div class="stat-icon" style="background:#d1fae5;"><i class="bi bi-graph-up" style="color:#059669;"></i></div>
        <div><div class="stat-value" style="font-size:.95rem;color:#059669;">৳{{ number_format($summary->profit,0) }}</div><div class="stat-label">Gross Profit</div></div></div>
    </div>
</div>

<div class="card">
    <div class="card-header fw-600">Product Profit Analysis ({{ $items->total() }} products)</div>
    <div class="card-body p-0">
        <div class="table-responsive">
            <table class="table mb-0" style="font-size:.82rem;">
                <thead><tr><th>#</th><th>Product</th><th class="text-end">Qty Sold</th><th class="text-end">Revenue</th><th class="text-end">COGS</th><th class="text-end">Profit</th><th class="text-end">Margin</th><th style="width:100px;">Bar</th></tr></thead>
                <tbody>
                    @php $maxProfit = $items->max('profit') ?: 1; @endphp
                    @foreach($items as $i => $item)
                    <tr>
                        <td style="color:#94a3b8;">{{ ($items->currentPage()-1)*$items->perPage()+$i+1 }}</td>
                        <td>
                            <div class="fw-600">{{ $item->productVariant?->product?->name ?? '—' }}</div>
                            <div style="font-size:.72rem;color:#94a3b8;">{{ $item->productVariant?->variant_name }}</div>
                        </td>
                        <td class="text-end">{{ number_format($item->total_qty) }}</td>
                        <td class="text-end fw-600">৳{{ number_format($item->revenue,0) }}</td>
                        <td class="text-end text-muted">৳{{ number_format($item->cogs,0) }}</td>
                        <td class="text-end fw-700 {{ $item->profit >= 0 ? 'text-success' : 'text-danger' }}">৳{{ number_format($item->profit,0) }}</td>
                        <td class="text-end">
                            @php $margin = $item->revenue > 0 ? ($item->profit/$item->revenue)*100 : 0; @endphp
                            <span class="badge {{ $margin >= 20 ? 'bg-success' : ($margin >= 10 ? 'bg-warning text-dark' : 'bg-danger') }}">
                                {{ number_format($margin,1) }}%
                            </span>
                        </td>
                        <td>
                            @php $barW = $maxProfit > 0 ? min(100, ($item->profit/$maxProfit)*100) : 0; @endphp
                            <div style="background:#e2e8f0;border-radius:3px;height:10px;overflow:hidden;">
                                <div style="background:{{ $item->profit >= 0 ? '#059669' : '#dc2626' }};height:100%;width:{{ number_format($barW,1) }}%;border-radius:3px;"></div>
                            </div>
                        </td>
                    </tr>
                    @endforeach
                </tbody>
                <tfoot style="background:#f8fafc;">
                    <tr>
                        <td colspan="3" class="fw-700 text-end">Totals:</td>
                        <td class="text-end fw-800">৳{{ number_format($summary->revenue,0) }}</td>
                        <td class="text-end fw-700 text-muted">৳{{ number_format($summary->cogs,0) }}</td>
                        <td class="text-end fw-800 text-success">৳{{ number_format($summary->profit,0) }}</td>
                        <td colspan="2"></td>
                    </tr>
                </tfoot>
            </table>
        </div>
    </div>
    @if($items->hasPages())<div class="card-footer">{{ $items->links() }}</div>@endif
</div>
@endsection