@extends('layouts.app')
@section('title','Profit Report')@section('page-title','Profit & Margin Report')
@section('content')
<div class="page-header d-flex align-items-start justify-content-between">
    <div><h1>Profit &amp; Margin Report</h1><p>{{ \Carbon\Carbon::parse($from)->format('M j, Y') }} — {{ \Carbon\Carbon::parse($to)->format('M j, Y') }}{{ $selectedBranch ? ' · '.$selectedBranch->name : (auth()->user()->isAdmin()?' · All Branches':'') }}</p></div>
    <button onclick="window.print()" class="btn btn-outline-secondary"><i class="bi bi-printer me-1"></i>Print</button>
</div>
<div class="card mb-4"><div class="card-body p-3">
    <form method="GET" class="row g-2 align-items-end">
        <div class="col-6 col-md-2"><label class="form-label" style="font-size:12px;">From</label><input type="date" name="from" class="form-control" value="{{ $from }}"></div>
        <div class="col-6 col-md-2"><label class="form-label" style="font-size:12px;">To</label><input type="date" name="to" class="form-control" value="{{ $to }}"></div>
        @if(auth()->user()->isAdmin())<div class="col-6 col-md-2"><label class="form-label" style="font-size:12px;">Branch</label><select name="branch_id" class="form-select"><option value="">All Branches</option>@foreach($branches as $b)<option value="{{ $b->id }}" {{ request('branch_id')==$b->id?'selected':'' }}>{{ $b->code }}</option>@endforeach</select></div>@endif
        <div class="col-auto" style="padding-top:24px"><button type="submit" class="btn btn-brand">Generate</button></div>
    </form>
</div></div>

<div class="row g-3 mb-4">
    @foreach([['$'.number_format($summary['total_revenue'],2),'Total Revenue (USD)','stat-card-1','bi-graph-up-arrow'],['$'.number_format($summary['total_cost'],2),'Total COGS','stat-card-2','bi-cart-dash'],['$'.number_format($summary['gross_profit'],2),'Gross Profit','stat-card-3','bi-piggy-bank'],[number_format($summary['avg_margin'],1).'%','Avg Gross Margin','stat-card-4','bi-percent']] as [$val,$label,$cls,$icon])
    <div class="col-6 col-xl-3"><div class="stat-card {{ $cls }} h-100"><div class="stat-icon"><i class="bi {{ $icon }}"></i></div><div class="stat-value">{{ $val }}</div><div class="stat-label">{{ $label }}</div></div></div>
    @endforeach
</div>

@if($profitData->count())
<div class="card mb-4"><div class="card-body p-4">
    <h6 class="fw-700 mb-3" style="font-family:'Space Grotesk',sans-serif;">Top 10 by Profit</h6>
    @php $top10 = $profitData->sortByDesc('profit')->take(10); $maxP = $top10->max('profit') ?: 1; @endphp
    @foreach($top10 as $row)
    <div class="mb-2">
        <div class="d-flex justify-content-between mb-1" style="font-size:12px;"><span class="fw-600">{{ Str::limit($row['product'],40) }}</span><span style="color:#06D6A0;font-weight:700;">${{ number_format($row['profit'],2) }} ({{ number_format($row['margin'],1) }}%)</span></div>
        <div class="progress" style="height:5px;"><div class="progress-bar" style="width:{{ max(2,($row['profit']/$maxP)*100) }}%;background:#06D6A0;"></div></div>
    </div>
    @endforeach
</div></div>
@endif

<div class="card"><div class="card-body p-0">
    <div class="p-4 pb-2 d-flex justify-content-between align-items-center"><h6 class="fw-700 mb-0" style="font-family:'Space Grotesk',sans-serif;">Full Profit Detail</h6><span class="text-muted" style="font-size:13px;">{{ $profitData->count() }} products sold</span></div>
    <div class="table-responsive"><table class="table table-hover mb-0">
        <thead><tr><th class="ps-4">Product</th><th>Category</th><th class="text-end">Qty</th><th class="text-end">Revenue (USD)</th><th class="text-end">COGS</th><th class="text-end">Gross Profit</th><th class="text-end pe-4">Margin</th></tr></thead>
        <tbody>
        @forelse($profitData->sortByDesc('profit') as $row)
        <tr>
            <td class="ps-4 fw-600" style="font-size:13px;">{{ $row['product'] }}</td>
            <td style="font-size:13px;color:var(--text-muted-c)">{{ $row['category'] }}</td>
            <td class="text-end" style="font-size:13px;">{{ number_format($row['qty']) }}</td>
            <td class="text-end fw-600">${{ number_format($row['revenue'],2) }}</td>
            <td class="text-end text-muted" style="font-size:13px;">${{ number_format($row['cost'],2) }}</td>
            <td class="text-end fw-700" style="color:{{ $row['profit']>=0?'#06D6A0':'var(--danger-c)' }}">{{ $row['profit']>=0?'+':'' }}${{ number_format($row['profit'],2) }}</td>
            <td class="text-end pe-4 fw-700" style="color:{{ $row['margin']>=25?'#06D6A0':($row['margin']>=10?'var(--brand)':'var(--danger-c)') }}">{{ number_format($row['margin'],1) }}%</td>
        </tr>
        @empty<tr><td colspan="7" class="text-center py-5 text-muted"><i class="bi bi-bar-chart" style="font-size:36px"></i><p class="mt-2 mb-0">No sales in this period.</p></td></tr>
        @endforelse
        </tbody>
        @if($profitData->count())
        <tfoot style="border-top:2px solid var(--border-c);background:var(--page-bg)">
            <tr><td class="ps-4 fw-700" colspan="2">TOTALS</td><td class="text-end fw-700">{{ number_format($profitData->sum('qty')) }}</td><td class="text-end fw-700">${{ number_format($summary['total_revenue'],2) }}</td><td class="text-end fw-700">${{ number_format($summary['total_cost'],2) }}</td><td class="text-end fw-800" style="color:#06D6A0;font-size:15px;">${{ number_format($summary['gross_profit'],2) }}</td><td class="text-end pe-4 fw-700" style="font-size:15px;color:var(--accent)">{{ number_format($summary['avg_margin'],1) }}%</td></tr>
        </tfoot>
        @endif
    </table></div>
</div></div>
@endsection