@extends('layouts.master')
@section('title', 'Income Statement')

@section('content')
<div class="container-fluid py-3">
    <div class="d-flex justify-content-between align-items-center mb-3 no-print">
        <h4 class="mb-0">Income Statement</h4>
        <div class="d-flex gap-2">
            <button onclick="window.print()" class="btn btn-secondary btn-sm"><i class="fas fa-print me-1"></i> Print</button>
            <a href="?export=pdf&from_date={{ $from }}&to_date={{ $to }}" class="btn btn-danger btn-sm"><i class="fas fa-file-pdf me-1"></i> Download PDF</a>
            <a href="?export=excel&from_date={{ $from }}&to_date={{ $to }}" class="btn btn-success btn-sm"><i class="fas fa-file-excel me-1"></i> Download Excel</a>
        </div>
    </div>

    <form method="GET" class="row g-2 mb-3 no-print">
        <div class="col-md-3">
            <label class="form-label mb-1">From Date</label>
            <input type="date" class="form-control" name="from_date" value="{{ $from }}">
        </div>
        <div class="col-md-3">
            <label class="form-label mb-1">To Date</label>
            <input type="date" class="form-control" name="to_date" value="{{ $to }}">
        </div>
        <div class="col-md-3 d-flex align-items-end">
            <button class="btn btn-primary">Run</button>
        </div>
    </form>

    <div class="card shadow-sm">
        <div class="card-body p-0">
            <div style="background:#4e73df;color:#fff;padding:12px 16px;font-weight:700;">
                {{ $companyName ?? 'Company Name' }} <span style="float:right;">Income Statement</span>
            </div>
            <div class="p-3">
                <table class="table table-bordered table-sm mb-0">
                    <thead style="background-color: #4e73df; color: #fff;">
                        <tr>
                            <th>Income Statement</th>
                            <th class="text-end">Amount</th>
                        </tr>
                    </thead>
                    <tbody>
                        <tr class="table-primary"><td colspan="2"><strong>Revenue</strong></td></tr>
                        
                        @if(count($grouped['Sales']) > 0)
                            @foreach($grouped['Sales'] as $r)
                                <tr><td style="padding-left: 20px;">{{ $r['name'] }}</td><td class="text-end">{{ number_format($r['value'], 2) }}</td></tr>
                            @endforeach
                        @else
                            <tr><td style="padding-left: 20px;">Sales</td><td class="text-end">{{ number_format($sales, 2) }}</td></tr>
                        @endif
                        
                        @if(count($grouped['Sales Return']) > 0)
                            @foreach($grouped['Sales Return'] as $r)
                                <tr><td style="padding-left: 20px;"><em>Less:</em> {{ $r['name'] }}</td><td class="text-end">{{ number_format($r['value'], 2) }}</td></tr>
                            @endforeach
                        @else
                            <tr><td style="padding-left: 20px;"><em>Less:</em> Sales Return</td><td class="text-end">{{ number_format($salesReturn, 2) }}</td></tr>
                        @endif

                        @if(count($grouped['Discounts and Allowances']) > 0)
                            @foreach($grouped['Discounts and Allowances'] as $r)
                                <tr><td style="padding-left: 20px;"><em>Less:</em> {{ $r['name'] }}</td><td class="text-end">{{ number_format($r['value'], 2) }}</td></tr>
                            @endforeach
                        @else
                            <tr><td style="padding-left: 20px;"><em>Less:</em> Discounts and Allowances</td><td class="text-end">{{ number_format($discounts, 2) }}</td></tr>
                        @endif
                        
                        <tr class="table-light"><td style="padding-left: 20px;"><strong>Net Sales</strong></td><td class="text-end"><strong>{{ number_format($netSales, 2) }}</strong></td></tr>

                        <tr class="table-primary"><td colspan="2"><strong>Cost of Goods Sold</strong></td></tr>
                        @if(count($grouped['Materials']) > 0)
                            @foreach($grouped['Materials'] as $r)
                                <tr><td style="padding-left: 20px;">{{ $r['name'] }}</td><td class="text-end">{{ number_format($r['value'], 2) }}</td></tr>
                            @endforeach
                        @else
                            <tr><td style="padding-left: 20px;">Materials</td><td class="text-end">{{ number_format($materials, 2) }}</td></tr>
                        @endif

                        @if(count($grouped['Labor']) > 0)
                            @foreach($grouped['Labor'] as $r)
                                <tr><td style="padding-left: 20px;">{{ $r['name'] }}</td><td class="text-end">{{ number_format($r['value'], 2) }}</td></tr>
                            @endforeach
                        @else
                            <tr><td style="padding-left: 20px;">Labor</td><td class="text-end">{{ number_format($labor, 2) }}</td></tr>
                        @endif

                        @if(count($grouped['Overhead']) > 0)
                            @foreach($grouped['Overhead'] as $r)
                                <tr><td style="padding-left: 20px;">{{ $r['name'] }}</td><td class="text-end">{{ number_format($r['value'], 2) }}</td></tr>
                            @endforeach
                        @else
                            <tr><td style="padding-left: 20px;">Overhead</td><td class="text-end">{{ number_format($overhead, 2) }}</td></tr>
                        @endif

                        <tr class="table-light"><td style="padding-left: 20px;"><strong>Total Cost of Goods Sold</strong></td><td class="text-end"><strong>{{ number_format($cogs, 2) }}</strong></td></tr>
                        
                        <tr class="table-secondary"><td><strong>Gross Profit</strong></td><td class="text-end"><strong>{{ number_format($grossProfit, 2) }}</strong></td></tr>

                        <tr class="table-primary"><td colspan="2"><strong>Operating Expenses</strong></td></tr>
                        @foreach($grouped['Operating Expenses'] as $r)
                            <tr><td style="padding-left: 20px;">{{ $r['name'] }}</td><td class="text-end">{{ number_format($r['value'], 2) }}</td></tr>
                        @endforeach
                        <tr class="table-light"><td style="padding-left: 20px;"><strong>Total Operating Expenses</strong></td><td class="text-end"><strong>{{ number_format($opex, 2) }}</strong></td></tr>

                        <tr class="table-secondary"><td><strong>Operating Profit (Loss)</strong></td><td class="text-end"><strong>{{ number_format($operatingProfit, 2) }}</strong></td></tr>

                        <tr class="table-light"><td colspan="2"><em>Add: Other Income</em></td></tr>
                        @foreach($grouped['Other Income'] as $r)
                            <tr><td style="padding-left: 20px;">{{ $r['name'] }}</td><td class="text-end">{{ number_format($r['value'], 2) }}</td></tr>
                        @endforeach

                        <tr class="table-secondary"><td><strong>Profit (Loss) Before Taxes</strong></td><td class="text-end"><strong>{{ number_format($profitBeforeTax, 2) }}</strong></td></tr>

                        @if(count($grouped['Tax Expense']) > 0)
                            @foreach($grouped['Tax Expense'] as $r)
                                <tr><td style="padding-left: 20px;"><em>Less:</em> {{ $r['name'] }}</td><td class="text-end">{{ number_format($r['value'], 2) }}</td></tr>
                            @endforeach
                        @else
                            <tr><td style="padding-left: 20px;"><em>Less:</em> Tax Expense</td><td class="text-end">{{ number_format($taxExpense, 2) }}</td></tr>
                        @endif

                        <tr class="table-secondary">
                            <td><strong>Net Profit (Loss)</strong></td>
                            <td class="text-end"><strong style="color:{{ $netProfit >= 0 ? '#1cc88a' : '#e74a3b' }}">{{ number_format($netProfit, 2) }}</strong></td>
                        </tr>
                    </tbody>
                </table>
            </div>
        </div>
    </div>
</div>

<style>
@media print {
    .no-print { display:none !important; }
    body { background:#fff !important; }
    .card { border:none !important; box-shadow:none !important; }
}
</style>
@endsection