@extends('layouts.app')
@section('content')
<div class="max-w-5xl mx-auto p-6">
    <h1 class="text-xl font-semibold mb-4">Profit &amp; Loss Statement</h1>
    <form method="GET" class="bg-white rounded shadow p-4 grid grid-cols-3 gap-4 mb-4">
        <div>
            <label class="block text-sm font-medium mb-1">From</label>
            <input type="date" name="from" value="{{ $from }}" class="w-full border rounded p-2">
        </div>
        <div>
            <label class="block text-sm font-medium mb-1">To</label>
            <input type="date" name="to" value="{{ $to }}" class="w-full border rounded p-2">
        </div>
        <div class="flex items-end gap-2">
            <button class="px-4 py-2 bg-gray-800 text-white rounded">Filter</button>
            <form method="POST" action="{{ route('reports.export.pdf', 'profit-loss') }}">
                @csrf
                <input type="hidden" name="from" value="{{ $from }}">
                <input type="hidden" name="to" value="{{ $to }}">
                <button class="px-3 py-2 bg-red-600 text-white rounded">PDF</button>
            </form>
            <form method="POST" action="{{ route('reports.export.excel', 'profit-loss') }}">
                @csrf
                <input type="hidden" name="from" value="{{ $from }}">
                <input type="hidden" name="to" value="{{ $to }}">
                <button class="px-3 py-2 bg-green-600 text-white rounded">Excel</button>
            </form>
        </div>
    </form>
    <div class="bg-white rounded shadow overflow-hidden">
        <div class="px-4 py-2 bg-gray-50 font-semibold">Revenue</div>
        <table class="min-w-full">
            <tbody class="divide-y divide-gray-100">
                @foreach($rev['rows'] as $r)
                <tr>
                    <td class="px-4 py-2">{{ $r['code'] }} - {{ $r['name'] }}</td>
                    <td class="px-4 py-2 text-right">{{ number_format($r['amount'], 2) }}</td>
                </tr>
                @endforeach
                <tr class="bg-gray-50 font-semibold">
                    <td class="px-4 py-2">Total Revenue</td>
                    <td class="px-4 py-2 text-right">{{ number_format($rev['total'], 2) }}</td>
                </tr>
            </tbody>
        </table>
        <div class="px-4 py-2 bg-gray-50 font-semibold">COGS</div>
        <table class="min-w-full">
            <tbody class="divide-y divide-gray-100">
                @foreach($cg['rows'] as $r)
                <tr>
                    <td class="px-4 py-2">{{ $r['code'] }} - {{ $r['name'] }}</td>
                    <td class="px-4 py-2 text-right">{{ number_format($r['amount'], 2) }}</td>
                </tr>
                @endforeach
                <tr class="bg-gray-50 font-semibold">
                    <td class="px-4 py-2">Total COGS</td>
                    <td class="px-4 py-2 text-right">{{ number_format($cg['total'], 2) }}</td>
                </tr>
            </tbody>
        </table>
        <div class="px-4 py-2 bg-gray-50 font-semibold">Gross Profit</div>
        <div class="px-4 py-2 text-right">{{ number_format($gross, 2) }}</div>
        <div class="px-4 py-2 bg-gray-50 font-semibold">Expenses</div>
        <table class="min-w-full">
            <tbody class="divide-y divide-gray-100">
                @foreach($exp['rows'] as $r)
                <tr>
                    <td class="px-4 py-2">{{ $r['code'] }} - {{ $r['name'] }}</td>
                    <td class="px-4 py-2 text-right">{{ number_format($r['amount'], 2) }}</td>
                </tr>
                @endforeach
                <tr class="bg-gray-50 font-semibold">
                    <td class="px-4 py-2">Total Expenses</td>
                    <td class="px-4 py-2 text-right">{{ number_format($exp['total'], 2) }}</td>
                </tr>
            </tbody>
        </table>
        <div class="px-4 py-2 bg-gray-50 font-semibold">Net Profit</div>
        <div class="px-4 py-2 text-right font-semibold">{{ number_format($net, 2) }}</div>
    </div>
</div>
@endsection