@extends('layouts.app')

@section('content')
<div class="container-fluid">
    <div class="row">
        <div class="col-12">
            <div class="card">
                <div class="card-header">
                    <h3 class="card-title">Profit & Loss Statement</h3>
                    <div class="card-tools">
                        <div class="btn-group">
                            <button type="button" class="btn btn-tool dropdown-toggle" data-toggle="dropdown">
                                <i class="fas fa-download"></i>
                            </button>
                            <div class="dropdown-menu dropdown-menu-right">
                                <a href="#" class="dropdown-item" onclick="exportToExcel()">Export to Excel</a>
                                <a href="#" class="dropdown-item" onclick="exportToPDF()">Export to PDF</a>
                            </div>
                        </div>
                    </div>
                </div>
                <div class="card-body">
                    <form id="filterForm" class="mb-3">
                        <div class="row">
                            <div class="col-md-3">
                                <div class="form-group">
                                    <label>Start Date</label>
                                    <input type="date" class="form-control" name="start_date" value="{{ request('start_date', now()->startOfMonth()->format('Y-m-d')) }}">
                                </div>
                            </div>
                            <div class="col-md-3">
                                <div class="form-group">
                                    <label>End Date</label>
                                    <input type="date" class="form-control" name="end_date" value="{{ request('end_date', now()->format('Y-m-d')) }}">
                                </div>
                            </div>
                            <div class="col-md-3">
                                <div class="form-group">
                                    <label>Compare With</label>
                                    <select class="form-control" name="compare_with">
                                        <option value="">None</option>
                                        <option value="previous_period">Previous Period</option>
                                        <option value="previous_year">Previous Year</option>
                                    </select>
                                </div>
                            </div>
                            <div class="col-md-3">
                                <div class="form-group">
                                    <label>&nbsp;</label>
                                    <button type="submit" class="btn btn-primary btn-block">Generate Report</button>
                                </div>
                            </div>
                        </div>
                    </form>

                    <div class="table-responsive">
                        <table class="table table-bordered">
                            <thead>
                                <tr>
                                    <th>Description</th>
                                    <th class="text-right">Current Period</th>
                                    @if(request('compare_with'))
                                    <th class="text-right">Comparison Period</th>
                                    <th class="text-right">Variance</th>
                                    <th class="text-right">% Change</th>
                                    @endif
                                </tr>
                            </thead>
                            <tbody>
                                <!-- Revenue Section -->
                                <tr class="font-weight-bold">
                                    <td colspan="{{ request('compare_with') ? 5 : 2 }}">Revenue</td>
                                </tr>
                                @foreach($revenues as $revenue)
                                <tr>
                                    <td>{{ $revenue->name }}</td>
                                    <td class="text-right">{{ number_format($revenue->amount, 2) }}</td>
                                    @if(request('compare_with'))
                                    <td class="text-right">{{ number_format($revenue->comparison_amount, 2) }}</td>
                                    <td class="text-right">{{ number_format($revenue->variance, 2) }}</td>
                                    <td class="text-right">{{ number_format($revenue->percentage_change, 2) }}%</td>
                                    @endif
                                </tr>
                                @endforeach
                                <tr class="font-weight-bold">
                                    <td>Total Revenue</td>
                                    <td class="text-right">{{ number_format($totalRevenue, 2) }}</td>
                                    @if(request('compare_with'))
                                    <td class="text-right">{{ number_format($totalRevenueComparison, 2) }}</td>
                                    <td class="text-right">{{ number_format($totalRevenueVariance, 2) }}</td>
                                    <td class="text-right">{{ number_format($totalRevenuePercentageChange, 2) }}%</td>
                                    @endif
                                </tr>

                                <!-- Cost of Goods Sold Section -->
                                <tr class="font-weight-bold">
                                    <td colspan="{{ request('compare_with') ? 5 : 2 }}">Cost of Goods Sold</td>
                                </tr>
                                @foreach($costOfGoodsSold as $cogs)
                                <tr>
                                    <td>{{ $cogs->name }}</td>
                                    <td class="text-right">{{ number_format($cogs->amount, 2) }}</td>
                                    @if(request('compare_with'))
                                    <td class="text-right">{{ number_format($cogs->comparison_amount, 2) }}</td>
                                    <td class="text-right">{{ number_format($cogs->variance, 2) }}</td>
                                    <td class="text-right">{{ number_format($cogs->percentage_change, 2) }}%</td>
                                    @endif
                                </tr>
                                @endforeach
                                <tr class="font-weight-bold">
                                    <td>Total Cost of Goods Sold</td>
                                    <td class="text-right">{{ number_format($totalCOGS, 2) }}</td>
                                    @if(request('compare_with'))
                                    <td class="text-right">{{ number_format($totalCOGSComparison, 2) }}</td>
                                    <td class="text-right">{{ number_format($totalCOGSVariance, 2) }}</td>
                                    <td class="text-right">{{ number_format($totalCOGSPercentageChange, 2) }}%</td>
                                    @endif
                                </tr>

                                <!-- Gross Profit -->
                                <tr class="font-weight-bold">
                                    <td>Gross Profit</td>
                                    <td class="text-right">{{ number_format($grossProfit, 2) }}</td>
                                    @if(request('compare_with'))
                                    <td class="text-right">{{ number_format($grossProfitComparison, 2) }}</td>
                                    <td class="text-right">{{ number_format($grossProfitVariance, 2) }}</td>
                                    <td class="text-right">{{ number_format($grossProfitPercentageChange, 2) }}%</td>
                                    @endif
                                </tr>

                                <!-- Operating Expenses Section -->
                                <tr class="font-weight-bold">
                                    <td colspan="{{ request('compare_with') ? 5 : 2 }}">Operating Expenses</td>
                                </tr>
                                @foreach($operatingExpenses as $expense)
                                <tr>
                                    <td>{{ $expense->name }}</td>
                                    <td class="text-right">{{ number_format($expense->amount, 2) }}</td>
                                    @if(request('compare_with'))
                                    <td class="text-right">{{ number_format($expense->comparison_amount, 2) }}</td>
                                    <td class="text-right">{{ number_format($expense->variance, 2) }}</td>
                                    <td class="text-right">{{ number_format($expense->percentage_change, 2) }}%</td>
                                    @endif
                                </tr>
                                @endforeach
                                <tr class="font-weight-bold">
                                    <td>Total Operating Expenses</td>
                                    <td class="text-right">{{ number_format($totalOperatingExpenses, 2) }}</td>
                                    @if(request('compare_with'))
                                    <td class="text-right">{{ number_format($totalOperatingExpensesComparison, 2) }}</td>
                                    <td class="text-right">{{ number_format($totalOperatingExpensesVariance, 2) }}</td>
                                    <td class="text-right">{{ number_format($totalOperatingExpensesPercentageChange, 2) }}%</td>
                                    @endif
                                </tr>

                                <!-- Operating Profit -->
                                <tr class="font-weight-bold">
                                    <td>Operating Profit</td>
                                    <td class="text-right">{{ number_format($operatingProfit, 2) }}</td>
                                    @if(request('compare_with'))
                                    <td class="text-right">{{ number_format($operatingProfitComparison, 2) }}</td>
                                    <td class="text-right">{{ number_format($operatingProfitVariance, 2) }}</td>
                                    <td class="text-right">{{ number_format($operatingProfitPercentageChange, 2) }}%</td>
                                    @endif
                                </tr>

                                <!-- Other Income/Expenses Section -->
                                <tr class="font-weight-bold">
                                    <td colspan="{{ request('compare_with') ? 5 : 2 }}">Other Income/Expenses</td>
                                </tr>
                                @foreach($otherIncomeExpenses as $item)
                                <tr>
                                    <td>{{ $item->name }}</td>
                                    <td class="text-right">{{ number_format($item->amount, 2) }}</td>
                                    @if(request('compare_with'))
                                    <td class="text-right">{{ number_format($item->comparison_amount, 2) }}</td>
                                    <td class="text-right">{{ number_format($item->variance, 2) }}</td>
                                    <td class="text-right">{{ number_format($item->percentage_change, 2) }}%</td>
                                    @endif
                                </tr>
                                @endforeach

                                <!-- Net Profit Before Tax -->
                                <tr class="font-weight-bold">
                                    <td>Net Profit Before Tax</td>
                                    <td class="text-right">{{ number_format($netProfitBeforeTax, 2) }}</td>
                                    @if(request('compare_with'))
                                    <td class="text-right">{{ number_format($netProfitBeforeTaxComparison, 2) }}</td>
                                    <td class="text-right">{{ number_format($netProfitBeforeTaxVariance, 2) }}</td>
                                    <td class="text-right">{{ number_format($netProfitBeforeTaxPercentageChange, 2) }}%</td>
                                    @endif
                                </tr>

                                <!-- Tax -->
                                <tr class="font-weight-bold">
                                    <td>Income Tax</td>
                                    <td class="text-right">{{ number_format($incomeTax, 2) }}</td>
                                    @if(request('compare_with'))
                                    <td class="text-right">{{ number_format($incomeTaxComparison, 2) }}</td>
                                    <td class="text-right">{{ number_format($incomeTaxVariance, 2) }}</td>
                                    <td class="text-right">{{ number_format($incomeTaxPercentageChange, 2) }}%</td>
                                    @endif
                                </tr>

                                <!-- Net Profit After Tax -->
                                <tr class="font-weight-bold bg-primary text-white">
                                    <td>Net Profit After Tax</td>
                                    <td class="text-right">{{ number_format($netProfitAfterTax, 2) }}</td>
                                    @if(request('compare_with'))
                                    <td class="text-right">{{ number_format($netProfitAfterTaxComparison, 2) }}</td>
                                    <td class="text-right">{{ number_format($netProfitAfterTaxVariance, 2) }}</td>
                                    <td class="text-right">{{ number_format($netProfitAfterTaxPercentageChange, 2) }}%</td>
                                    @endif
                                </tr>
                            </tbody>
                        </table>
                    </div>
                </div>
            </div>
        </div>
    </div>
</div>
@endsection

@push('scripts')
<script>
function exportToExcel() {
    // Implement Excel export functionality
}

function exportToPDF() {
    // Implement PDF export functionality
}
</script>
@endpush