@extends('layouts.app')
@section('title', 'লাভ-ক্ষতি রিপোর্ট')
@section('page-title', 'লাভ-ক্ষতি রিপোর্ট (P&L)')

@section('content')

{{-- Report Nav --}}
<div class="d-flex gap-2 mb-4 flex-wrap">
    <a href="{{ route('admin.reports.sales') }}" class="btn btn-outline-primary btn-sm rounded-pill">
        <i class="bi bi-graph-up me-1"></i>বিক্রয়
    </a>
    <a href="{{ route('admin.reports.stock') }}" class="btn btn-outline-warning btn-sm rounded-pill">
        <i class="bi bi-fire me-1"></i>স্টক
    </a>
    <a href="{{ route('admin.reports.due-customers') }}" class="btn btn-outline-danger btn-sm rounded-pill">
        <i class="bi bi-exclamation-circle me-1"></i>বকেয়া
    </a>
    <a href="{{ route('admin.reports.delivery') }}" class="btn btn-outline-info btn-sm rounded-pill">
        <i class="bi bi-bicycle me-1"></i>ডেলিভারি
    </a>
    <a href="{{ route('admin.reports.profit-loss') }}" class="btn btn-success btn-sm rounded-pill">
        <i class="bi bi-calculator me-1"></i>লাভ-ক্ষতি
    </a>
</div>

{{-- Filter --}}
<div class="card stat-card mb-4">
    <div class="card-body py-3">
        <form method="GET" class="row g-2 align-items-end">
            <div class="col-md-2">
                <label class="form-label small fw-semibold">বছর</label>
                <select name="year" class="form-select form-select-sm">
                    @foreach($years as $y)
                        <option value="{{ $y }}" {{ $year == $y ? 'selected' : '' }}>{{ $y }}</option>
                    @endforeach
                </select>
            </div>
            <div class="col-md-2">
                <label class="form-label small fw-semibold">মাস</label>
                <select name="month" class="form-select form-select-sm">
                    <option value="" {{ $month === '' ? 'selected' : '' }}>পুরো বছর</option>
                    @foreach(['01'=>'জানুয়ারি','02'=>'ফেব্রুয়ারি','03'=>'মার্চ','04'=>'এপ্রিল','05'=>'মে','06'=>'জুন','07'=>'জুলাই','08'=>'আগস্ট','09'=>'সেপ্টেম্বর','10'=>'অক্টোবর','11'=>'নভেম্বর','12'=>'ডিসেম্বর'] as $num => $name)
                        <option value="{{ $num }}" {{ $month == $num ? 'selected' : '' }}>{{ $name }}</option>
                    @endforeach
                </select>
            </div>
            <div class="col-md-2">
                <button type="submit" class="btn btn-success btn-sm w-100">
                    <i class="bi bi-calculator me-1"></i>হিসাব করুন
                </button>
            </div>
            <div class="col-md-auto ms-auto">
                <button type="button" onclick="window.print()" class="btn btn-outline-secondary btn-sm">
                    <i class="bi bi-printer me-1"></i>প্রিন্ট
                </button>
            </div>
        </form>
    </div>
</div>

{{-- Period Header --}}
<div class="alert alert-success d-flex align-items-center gap-3 mb-4">
    <i class="bi bi-calendar-check-fill fs-4"></i>
    <div>
        <strong>{{ $periodLabel }}</strong> —
        {{ $dateFrom->format('d M Y') }} থেকে {{ $dateTo->format('d M Y') }} পর্যন্ত
        <span class="ms-3 small">
            <i class="bi bi-cart3 me-1"></i>{{ $orderCount }}টি অর্ডার &nbsp;
            <i class="bi bi-wallet2 me-1"></i>{{ $expenseCount }}টি খরচ
        </span>
    </div>
</div>

{{-- P&L Statement --}}
<div class="row g-4 mb-4">
    <div class="col-lg-7">
        <div class="card stat-card h-100">
            <div class="card-header bg-white border-0 pt-3">
                <h6 class="fw-bold mb-0">
                    <i class="bi bi-file-earmark-bar-graph text-success me-2"></i>
                    আয়-ব্যয় বিবরণী
                </h6>
            </div>
            <div class="card-body p-0">
                <table class="table mb-0">

                    {{-- Revenue --}}
                    <tbody>
                        <tr class="table-light">
                            <td colspan="2" class="fw-bold text-muted small text-uppercase py-2 ps-3">
                                আয় (Revenue)
                            </td>
                        </tr>
                        <tr>
                            <td class="ps-4">মোট বিক্রয়</td>
                            <td class="text-end fw-semibold text-success">৳{{ number_format($revenue, 2) }}</td>
                        </tr>
                        <tr>
                            <td class="ps-4 text-muted small">আদায়কৃত</td>
                            <td class="text-end text-muted small">৳{{ number_format($collected, 2) }}</td>
                        </tr>
                        <tr>
                            <td class="ps-4 text-muted small">বকেয়া</td>
                            <td class="text-end text-danger small">৳{{ number_format($totalDue, 2) }}</td>
                        </tr>

                        {{-- COGS --}}
                        <tr class="table-light">
                            <td colspan="2" class="fw-bold text-muted small text-uppercase py-2 ps-3">
                                বিক্রয় খরচ (Cost of Goods Sold)
                            </td>
                        </tr>
                        <tr>
                            <td class="ps-4">পণ্য ক্রয়মূল্য (বিক্রিত)</td>
                            <td class="text-end fw-semibold text-danger">(৳{{ number_format($cogs, 2) }})</td>
                        </tr>

                        {{-- Gross Profit --}}
                        <tr class="border-top border-2">
                            <td class="fw-bold ps-3">মোট লাভ (Gross Profit)</td>
                            <td class="text-end fw-bold fs-5 {{ $grossProfit >= 0 ? 'text-success' : 'text-danger' }}">
                                ৳{{ number_format($grossProfit, 2) }}
                                <small class="text-muted fs-6">({{ $grossMargin }}%)</small>
                            </td>
                        </tr>

                        {{-- Operating Expenses --}}
                        <tr class="table-light">
                            <td colspan="2" class="fw-bold text-muted small text-uppercase py-2 ps-3">
                                পরিচালন খরচ (Operating Expenses)
                            </td>
                        </tr>
                        <tr>
                            <td class="ps-4">মোট খরচ</td>
                            <td class="text-end fw-semibold text-danger">(৳{{ number_format($expenses, 2) }})</td>
                        </tr>

                        {{-- Net Profit --}}
                        <tr class="border-top border-2 {{ $netProfit >= 0 ? 'table-success' : 'table-danger' }}">
                            <td class="fw-bold fs-5 ps-3 py-3">
                                নিট {{ $netProfit >= 0 ? 'লাভ' : 'ক্ষতি' }} (Net {{ $netProfit >= 0 ? 'Profit' : 'Loss' }})
                            </td>
                            <td class="text-end fw-bold fs-4 py-3 {{ $netProfit >= 0 ? 'text-success' : 'text-danger' }}">
                                ৳{{ number_format(abs($netProfit), 2) }}
                                <small class="fs-6 d-block text-muted">({{ $netMargin }}%)</small>
                            </td>
                        </tr>
                    </tbody>
                </table>
            </div>
        </div>
    </div>

    {{-- Right: Expense Breakdown + Chart --}}
    <div class="col-lg-5">

        {{-- Summary Cards --}}
        <div class="row g-3 mb-3">
            <div class="col-6">
                <div class="card border-success h-100">
                    <div class="card-body text-center py-3">
                        <i class="bi bi-arrow-up-circle-fill text-success fs-3"></i>
                        <div class="fw-bold fs-4 text-success mt-1">৳{{ number_format($revenue, 0) }}</div>
                        <div class="small text-muted">আয়</div>
                    </div>
                </div>
            </div>
            <div class="col-6">
                <div class="card border-danger h-100">
                    <div class="card-body text-center py-3">
                        <i class="bi bi-arrow-down-circle-fill text-danger fs-3"></i>
                        <div class="fw-bold fs-4 text-danger mt-1">৳{{ number_format($cogs + $expenses, 0) }}</div>
                        <div class="small text-muted">মোট ব্যয়</div>
                    </div>
                </div>
            </div>
        </div>

        {{-- Expense by Category --}}
        <div class="card stat-card">
            <div class="card-header bg-white border-0 pt-3">
                <h6 class="fw-semibold mb-0 small">ক্যাটাগরি অনুযায়ী খরচ</h6>
            </div>
            <div class="card-body p-0">
                <table class="table table-sm mb-0">
                    @forelse($expenseByCategory as $ec)
                    @php $info = \App\Models\Expense::categories()[$ec->category] ?? ['label'=>$ec->category,'color'=>'secondary','icon'=>'dash']; @endphp
                    <tr>
                        <td class="ps-3">
                            <i class="bi bi-{{ $info['icon'] }} text-{{ $info['color'] }} me-2"></i>
                            {{ $info['label'] }}
                        </td>
                        <td class="text-end pe-3 fw-semibold text-danger">৳{{ number_format($ec->total, 0) }}</td>
                    </tr>
                    @empty
                    <tr><td colspan="2" class="text-center text-muted py-3">কোনো খরচ নেই।</td></tr>
                    @endforelse
                    @if($expenseByCategory->count() > 0)
                    <tr class="table-light">
                        <td class="ps-3 fw-bold">মোট</td>
                        <td class="text-end pe-3 fw-bold text-danger">৳{{ number_format($expenses, 0) }}</td>
                    </tr>
                    @endif
                </table>
            </div>
        </div>
    </div>
</div>

{{-- Monthly Breakdown (বার্ষিক view-এ) --}}
@if($month === '' && $monthlyBreakdown->count() > 0)
<div class="card stat-card mb-4">
    <div class="card-header bg-white border-0 pt-3">
        <h6 class="fw-semibold mb-0">
            <i class="bi bi-bar-chart-steps text-primary me-2"></i>
            মাসিক বিশ্লেষণ — {{ $year }}
        </h6>
    </div>
    <div class="card-body">
        <canvas id="plChart" height="80"></canvas>
    </div>
</div>

<div class="card stat-card">
    <div class="card-header bg-white border-0 pt-3">
        <h6 class="fw-semibold mb-0">মাস অনুযায়ী লাভ-ক্ষতি</h6>
    </div>
    <div class="card-body p-0">
        <div class="table-responsive">
            <table class="table table-hover mb-0 align-middle text-center">
                <thead class="table-light">
                    <tr>
                        <th class="text-start ps-3">মাস</th>
                        <th class="text-success">আয়</th>
                        <th class="text-danger">পণ্য খরচ</th>
                        <th>মোট লাভ</th>
                        <th class="text-danger">পরিচালন খরচ</th>
                        <th>নিট লাভ/ক্ষতি</th>
                    </tr>
                </thead>
                <tbody>
                    @foreach($monthlyBreakdown as $mb)
                    <tr class="{{ $mb['net_profit'] < 0 ? 'table-danger' : '' }}">
                        <td class="text-start ps-3 fw-semibold">{{ $mb['month'] }}</td>
                        <td class="text-success">৳{{ number_format($mb['revenue'], 0) }}</td>
                        <td class="text-danger">(৳{{ number_format($mb['cogs'], 0) }})</td>
                        <td class="{{ $mb['gross_profit'] >= 0 ? 'text-success' : 'text-danger' }} fw-semibold">
                            ৳{{ number_format($mb['gross_profit'], 0) }}
                        </td>
                        <td class="text-danger">(৳{{ number_format($mb['expenses'], 0) }})</td>
                        <td class="{{ $mb['net_profit'] >= 0 ? 'text-success fw-bold' : 'text-danger fw-bold' }}">
                            {{ $mb['net_profit'] < 0 ? '▼' : '▲' }}
                            ৳{{ number_format(abs($mb['net_profit']), 0) }}
                        </td>
                    </tr>
                    @endforeach
                </tbody>
                <tfoot class="table-light">
                    <tr class="fw-bold">
                        <td class="text-start ps-3">বার্ষিক মোট</td>
                        <td class="text-success">৳{{ number_format($monthlyBreakdown->sum('revenue'), 0) }}</td>
                        <td class="text-danger">(৳{{ number_format($monthlyBreakdown->sum('cogs'), 0) }})</td>
                        <td class="{{ $grossProfit >= 0 ? 'text-success' : 'text-danger' }}">
                            ৳{{ number_format($grossProfit, 0) }}
                        </td>
                        <td class="text-danger">(৳{{ number_format($expenses, 0) }})</td>
                        <td class="{{ $netProfit >= 0 ? 'text-success fs-5' : 'text-danger fs-5' }}">
                            ৳{{ number_format(abs($netProfit), 0) }}
                        </td>
                    </tr>
                </tfoot>
            </table>
        </div>
    </div>
</div>
@endif

@push('styles')
<style>
@media print {
    .sidebar, .topbar, .report-nav, form, .btn, .no-print { display: none !important; }
    .main-content { margin-left: 0 !important; }
    .card { box-shadow: none !important; border: 1px solid #ddd !important; }
}
</style>
@endpush

@push('scripts')
@if($month === '' && $monthlyBreakdown->count() > 0)
<script src="https://cdn.jsdelivr.net/npm/chart.js@4.4.0/dist/chart.umd.min.js"></script>
<script>
const months   = @json($monthlyBreakdown->pluck('month')->toArray());
const revenues = @json($monthlyBreakdown->pluck('revenue')->toArray());
const grossProfits = @json($monthlyBreakdown->pluck('gross_profit')->toArray());
const netProfits   = @json($monthlyBreakdown->pluck('net_profit')->toArray());
const expensesArr  = @json($monthlyBreakdown->pluck('expenses')->toArray());

new Chart(document.getElementById('plChart'), {
    type: 'bar',
    data: {
        labels: months,
        datasets: [
            {
                label: 'আয়',
                data: revenues,
                backgroundColor: 'rgba(25,135,84,.25)',
                borderColor: '#198754',
                borderWidth: 2,
                type: 'bar',
            },
            {
                label: 'পরিচালন খরচ',
                data: expensesArr,
                backgroundColor: 'rgba(220,53,69,.2)',
                borderColor: '#dc3545',
                borderWidth: 2,
                type: 'bar',
            },
            {
                label: 'নিট লাভ',
                data: netProfits,
                borderColor: '#0d6efd',
                backgroundColor: 'transparent',
                borderWidth: 2.5,
                type: 'line',
                tension: .4,
                pointRadius: 5,
                pointBackgroundColor: netProfits.map(v => v >= 0 ? '#198754' : '#dc3545'),
            },
        ]
    },
    options: {
        responsive: true,
        plugins: { legend: { position: 'top' } },
        scales: { y: { beginAtZero: true } }
    }
});
</script>
@endif
@endpush
@endsection