@extends('layouts.app')
@section('title', 'Profit & Loss Report')
@section('breadcrumb')
<li class="breadcrumb-item"><a href="#">Reports</a></li>
<li class="breadcrumb-item active">Profit & Loss</li>
@endsection

@push('styles')
<style>
@media print {
    #topbar, #sidebar, .card-footer, .btn, form { display: none !important; }
    #main-content { margin: 0 !important; padding: 0 !important; }
    .card { box-shadow: none !important; border: 1px solid #e2e8f0 !important; }
}
.pl-section { border-left: 4px solid; border-radius: 0 10px 10px 0; padding: .75rem 1rem; margin-bottom: .5rem; }
</style>
@endpush

@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-arrow me-2" style="color:#059669;"></i>Profit & Loss</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')

{{-- Summary Cards --}}
<div class="row g-3 mb-4">
    <div class="col-6 col-md-3">
        <x-reports.stat-card label="Total Revenue" value="{{ number_format($totalRevenue,0) }}" icon="bi-cash-coin" color="#059669" bg="#d1fae5" prefix="৳"/>
    </div>
    <div class="col-6 col-md-3">
        <x-reports.stat-card label="Cost of Goods" value="{{ number_format($cogs,0) }}" icon="bi-cart-check" color="#d97706" bg="#fef3c7" prefix="৳"/>
    </div>
    <div class="col-6 col-md-3">
        <x-reports.stat-card label="Gross Profit" value="{{ number_format($grossProfit,0) }}" icon="bi-graph-up" color="#7c3aed" bg="#ede9fe" prefix="৳"/>
    </div>
    <div class="col-6 col-md-3">
        <x-reports.stat-card label="Net Profit" value="{{ number_format($netProfit,0) }}" icon="bi-currency-exchange" color="{{ $netProfit >= 0 ? '#059669' : '#dc2626' }}" bg="{{ $netProfit >= 0 ? '#d1fae5' : '#fee2e2' }}" prefix="৳"/>
    </div>
</div>

<div class="row g-3">
    {{-- P&L Statement --}}
    <div class="col-12 col-lg-5">
        <div class="card">
            <div class="card-header fw-600"><i class="bi bi-file-earmark-bar-graph me-2"></i>Statement</div>
            <div class="card-body">

                {{-- Revenue --}}
                <div style="font-size:.72rem;font-weight:700;color:#94a3b8;text-transform:uppercase;letter-spacing:.08em;margin-bottom:.5rem;">Revenue</div>
                <div class="pl-section" style="border-color:#059669;background:#f0fdf4;">
                    <div class="d-flex justify-content-between"><span>Sales Revenue</span><span class="fw-700">৳{{ number_format($salesRevenue,2) }}</span></div>
                    @if($repairRevenue > 0)
                    <div class="d-flex justify-content-between mt-1" style="font-size:.875rem;color:#64748b;"><span>Repair Revenue</span><span>৳{{ number_format($repairRevenue,2) }}</span></div>
                    @endif
                    <hr class="my-1">
                    <div class="d-flex justify-content-between fw-700" style="color:#059669;"><span>Total Revenue</span><span>৳{{ number_format($totalRevenue,2) }}</span></div>
                </div>

                {{-- COGS --}}
                <div style="font-size:.72rem;font-weight:700;color:#94a3b8;text-transform:uppercase;letter-spacing:.08em;margin:.75rem 0 .5rem;">Cost of Goods Sold</div>
                <div class="pl-section" style="border-color:#d97706;background:#fffbeb;">
                    <div class="d-flex justify-content-between"><span>Cost of Products Sold</span><span class="fw-700">৳{{ number_format($cogs,2) }}</span></div>
                    @if($salesDiscount > 0)
                    <div class="d-flex justify-content-between mt-1" style="font-size:.875rem;color:#64748b;"><span>Sales Discounts Given</span><span>৳{{ number_format($salesDiscount,2) }}</span></div>
                    @endif
                </div>

                {{-- Gross Profit --}}
                <div class="pl-section" style="border-color:#7c3aed;background:#faf5ff;">
                    <div class="d-flex justify-content-between fw-700" style="color:#7c3aed;font-size:1rem;"><span>Gross Profit</span><span>৳{{ number_format($grossProfit,2) }}</span></div>
                    <div style="font-size:.75rem;color:#94a3b8;">{{ $salesRevenue > 0 ? number_format(($grossProfit/$salesRevenue)*100,1) : 0 }}% margin</div>
                </div>

                {{-- Expenses --}}
                @if($expenses > 0)
                <div style="font-size:.72rem;font-weight:700;color:#94a3b8;text-transform:uppercase;letter-spacing:.08em;margin:.75rem 0 .5rem;">Expenses</div>
                <div class="pl-section" style="border-color:#dc2626;background:#fef2f2;">
                    <div class="d-flex justify-content-between"><span>Operating Expenses</span><span class="fw-700 text-danger">৳{{ number_format($expenses,2) }}</span></div>
                </div>
                @endif

                {{-- Net Profit --}}
                <div class="pl-section mt-2" style="border-color:{{ $netProfit >= 0 ? '#059669' : '#dc2626' }};background:{{ $netProfit >= 0 ? '#d1fae5' : '#fee2e2' }};">
                    <div class="d-flex justify-content-between fw-700" style="color:{{ $netProfit >= 0 ? '#059669' : '#dc2626' }};font-size:1.1rem;">
                        <span>NET PROFIT</span>
                        <span>৳{{ number_format($netProfit,2) }}</span>
                    </div>
                </div>
            </div>
        </div>
    </div>

    {{-- Right Column --}}
    <div class="col-12 col-lg-7">

        {{-- Monthly Trend --}}
        @if($monthly->count())
        <div class="card mb-3">
            <div class="card-header fw-600"><i class="bi bi-bar-chart me-2"></i>Monthly Revenue</div>
            <div class="card-body p-0">
                <table class="table table-sm mb-0" style="font-size:.85rem;">
                    <thead><tr><th>Month</th><th class="text-end">Revenue</th><th class="text-end">Transactions</th><th style="width:120px;">Bar</th></tr></thead>
                    <tbody>
                        @php $maxRev = $monthly->max('revenue') ?: 1; @endphp
                        @foreach($monthly as $m)
                        <tr>
                            <td>{{ \Carbon\Carbon::createFromFormat('Y-m', $m->month)->format('M Y') }}</td>
                            <td class="text-end fw-600">৳{{ number_format($m->revenue,0) }}</td>
                            <td class="text-end">{{ $m->transactions }}</td>
                            <td>
                                <div style="background:#e2e8f0;border-radius:3px;height:12px;overflow:hidden;">
                                    <div style="background:#1d4ed8;height:100%;width:{{ number_format(($m->revenue/$maxRev)*100,1) }}%;border-radius:3px;"></div>
                                </div>
                            </td>
                        </tr>
                        @endforeach
                    </tbody>
                </table>
            </div>
        </div>
        @endif

        {{-- Top Products --}}
        @if($topProducts->count())
        <div class="card">
            <div class="card-header fw-600"><i class="bi bi-trophy me-2"></i>Top Products by Revenue</div>
            <div class="card-body p-0">
                <table class="table table-sm mb-0" style="font-size:.82rem;">
                    <thead><tr><th>#</th><th>Product</th><th class="text-end">Qty</th><th class="text-end">Revenue</th><th class="text-end">Profit</th><th class="text-end">Margin</th></tr></thead>
                    <tbody>
                        @foreach($topProducts as $i => $item)
                        <tr>
                            <td style="color:#94a3b8;">{{ $i+1 }}</td>
                            <td>
                                <div class="fw-600" style="font-size:.8rem;">{{ $item->productVariant?->product?->name }}</div>
                                <div style="font-size:.72rem;color:#94a3b8;">{{ $item->productVariant?->variant_name }}</div>
                            </td>
                            <td class="text-end">{{ $item->total_qty }}</td>
                            <td class="text-end fw-600">৳{{ number_format($item->revenue,0) }}</td>
                            <td class="text-end" style="color:#059669;">৳{{ number_format($item->profit,0) }}</td>
                            <td class="text-end">
                                <span class="badge {{ ($item->revenue > 0 && ($item->profit/$item->revenue)*100 >= 20) ? 'bg-success' : 'bg-warning text-dark' }}">
                                    {{ $item->revenue > 0 ? number_format(($item->profit/$item->revenue)*100,1) : 0 }}%
                                </span>
                            </td>
                        </tr>
                        @endforeach
                    </tbody>
                </table>
            </div>
        </div>
        @endif
    </div>
</div>

@endsection