@extends('admin.layouts.master')
@section('title', 'التقرير المالي')

@section('page-header')
@include('admin.reports._header', [
    'title' => 'التقرير المالي - قائمة الدخل',
    'subtitle' => 'تحليل الإيرادات والتكاليف والأرباح من '.$from.' إلى '.$to,
    'icon' => 'ti-report-money',
    'color' => 'success',
])
@endsection

@section('content')
@include('admin.reports._filters', ['from'=>$from, 'to'=>$to, 'showCompare'=>true])

{{-- Insights --}}
@if(!empty($insights))
<div class="insights-box">
    <h4 class="mb-2"><i class="ti ti-bulb ms-1 text-warning"></i> الرؤى المالية</h4>
    @foreach($insights as $insight)
    <div class="insight-item {{ $insight['type'] }}">
        <i class="ti ti-{{ $insight['type'] === 'positive' ? 'circle-check' : ($insight['type'] === 'negative' ? 'alert-triangle' : 'info-circle') }} ms-1"></i>
        <div>{!! $insight['text'] !!}</div>
    </div>
    @endforeach
</div>
@endif

{{-- KPI Cards --}}
<div class="row row-cards mb-3">
    <div class="col-md-6 col-lg-3">
        <div class="kpi-pro featured" style="border-color:#198754">
            <i class="ti ti-arrow-up-right kpi-icon-bg text-success"></i>
            <div class="kpi-label">إجمالي الإيرادات</div>
            <div class="kpi-value text-success">{{ number_format($totalRevenue, 0) }} <span class="kpi-unit">ج</span></div>
            @if($prev)
                @php $g = $prev['revenue'] > 0 ? round(($totalRevenue-$prev['revenue'])/$prev['revenue']*100, 1) : 0; @endphp
                <div class="kpi-trend {{ $g > 0 ? 'up' : ($g < 0 ? 'down' : 'flat') }}">
                    <i class="ti ti-trending-{{ $g >= 0 ? 'up' : 'down' }}"></i> {{ $g > 0 ? '+' : '' }}{{ $g }}%
                </div>
            @endif
        </div>
    </div>
    <div class="col-md-6 col-lg-3">
        <div class="kpi-pro featured" style="border-color:#dc3545">
            <i class="ti ti-arrow-down-right kpi-icon-bg text-danger"></i>
            <div class="kpi-label">إجمالي التكاليف</div>
            <div class="kpi-value text-danger">{{ number_format($totalCosts, 0) }} <span class="kpi-unit">ج</span></div>
            @if($prev)
                @php $g = $prev['costs'] > 0 ? round(($totalCosts-$prev['costs'])/$prev['costs']*100, 1) : 0; @endphp
                <div class="kpi-trend {{ $g < 0 ? 'up' : ($g > 5 ? 'down' : 'flat') }}">
                    <i class="ti ti-trending-{{ $g >= 0 ? 'up' : 'down' }}"></i> {{ $g > 0 ? '+' : '' }}{{ $g }}%
                </div>
            @endif
        </div>
    </div>
    <div class="col-md-6 col-lg-3">
        <div class="kpi-pro featured" style="border-color:{{ $netProfit >= 0 ? '#0d6efd' : '#dc3545' }}">
            <i class="ti ti-coin kpi-icon-bg text-primary"></i>
            <div class="kpi-label">صافي الربح</div>
            <div class="kpi-value {{ $netProfit >= 0 ? 'text-primary' : 'text-danger' }}">{{ number_format($netProfit, 0) }} <span class="kpi-unit">ج</span></div>
            <div class="kpi-trend flat"><i class="ti ti-percentage"></i> الهامش الصافي {{ $netMargin }}%</div>
        </div>
    </div>
    <div class="col-md-6 col-lg-3">
        <div class="kpi-pro featured" style="border-color:#ffc107">
            <i class="ti ti-percentage kpi-icon-bg text-warning"></i>
            <div class="kpi-label">هامش الربح الإجمالي</div>
            <div class="kpi-value text-warning">{{ $grossMargin }}<span class="kpi-unit">%</span></div>
            <div class="kpi-trend flat"><i class="ti ti-info-circle"></i> الصحي 25-40%</div>
        </div>
    </div>
</div>

{{-- P&L Statement --}}
<div class="row row-cards mb-3">
    <div class="col-lg-7">
        <div class="card">
            <div class="card-header"><h3 class="card-title"><i class="ti ti-file-text ms-1"></i> قائمة الدخل (P&L Statement)</h3></div>
            <div class="card-body p-0">
                <table class="table mb-0">
                    <tbody>
                        <tr class="bg-success-lt"><td colspan="3" class="fw-bold"><i class="ti ti-plus ms-1"></i> الإيرادات</td></tr>
                        <tr><td class="ps-4">المبيعات (فواتير)</td><td></td><td class="text-end">{{ number_format($sales, 2) }}</td></tr>
                        <tr><td class="ps-4">مبيعات نقطة البيع (POS)</td><td></td><td class="text-end">{{ number_format($pos, 2) }}</td></tr>
                        <tr class="bg-light"><td class="fw-bold">إجمالي الإيرادات</td><td></td><td class="text-end fw-bold text-success">{{ number_format($totalRevenue, 2) }}</td></tr>

                        <tr class="bg-danger-lt"><td colspan="3" class="fw-bold"><i class="ti ti-minus ms-1"></i> التكاليف</td></tr>
                        <tr><td class="ps-4">المشتريات</td><td></td><td class="text-end">({{ number_format($purchases, 2) }})</td></tr>
                        <tr><td class="ps-4">المصروفات التشغيلية</td><td></td><td class="text-end">({{ number_format($expenses, 2) }})</td></tr>
                        <tr class="bg-light"><td class="fw-bold">إجمالي التكاليف</td><td></td><td class="text-end fw-bold text-danger">({{ number_format($totalCosts, 2) }})</td></tr>

                        <tr class="bg-primary text-white" style="font-size:1.1rem">
                            <td class="fw-bold">صافي الربح</td><td></td>
                            <td class="text-end fw-bold">{{ number_format($netProfit, 2) }} ج.م</td>
                        </tr>
                        <tr><td class="text-muted">هامش الربح الإجمالي</td><td></td><td class="text-end">{{ $grossMargin }}%</td></tr>
                        <tr><td class="text-muted">هامش الربح الصافي</td><td></td><td class="text-end">{{ $netMargin }}%</td></tr>
                    </tbody>
                </table>
            </div>
        </div>
    </div>

    <div class="col-lg-5">
        <div class="card mb-3">
            <div class="card-header"><h3 class="card-title">المراكز المالية</h3></div>
            <div class="card-body">
                <div class="d-flex justify-content-between align-items-center mb-3 pb-2 border-bottom">
                    <div><strong>مديونيات العملاء</strong><div class="text-muted small">إجمالي الأرصدة المدينة</div></div>
                    <h3 class="m-0 text-danger">{{ number_format($customersBalance, 0) }}</h3>
                </div>
                <div class="d-flex justify-content-between align-items-center">
                    <div><strong>مستحقات الموردين</strong><div class="text-muted small">إجمالي ما علينا لموردين</div></div>
                    <h3 class="m-0 text-info">{{ number_format(abs($suppliersBalance), 0) }}</h3>
                </div>
            </div>
        </div>

        <div class="card">
            <div class="card-header"><h3 class="card-title">توزيع الإيرادات vs التكاليف</h3></div>
            <div class="card-body"><div id="distChart"></div></div>
        </div>
    </div>
</div>

{{-- Comparison Table --}}
@if($prev)
<div class="card mb-3">
    <div class="card-header"><h3 class="card-title"><i class="ti ti-versions ms-1"></i> مقارنة بالفترة السابقة ({{ $prev['from'] }} - {{ $prev['to'] }})</h3></div>
    <div class="table-responsive">
        <table class="table card-table table-vcenter">
            <thead><tr>
                <th>المؤشر</th>
                <th class="text-center"><span class="period-tag current">حالي</span></th>
                <th class="text-center"><span class="period-tag previous">سابق</span></th>
                <th class="text-center">الفرق</th>
                <th class="text-center">% التغير</th>
            </tr></thead>
            <tbody>
                @php
                    $rows = [
                        ['l'=>'إجمالي الإيرادات', 'c'=>$totalRevenue, 'p'=>$prev['revenue']],
                        ['l'=>'المشتريات', 'c'=>$purchases, 'p'=>$prev['purchases'], 'reverse'=>true],
                        ['l'=>'المصروفات', 'c'=>$expenses, 'p'=>$prev['expenses'], 'reverse'=>true],
                        ['l'=>'صافي الربح', 'c'=>$netProfit, 'p'=>$prev['profit']],
                    ];
                @endphp
                @foreach($rows as $r)
                @php
                    $diff = $r['c'] - $r['p'];
                    $pct = $r['p'] != 0 ? round($diff / abs($r['p']) * 100, 1) : 0;
                    $reverse = $r['reverse'] ?? false;
                    $good = $reverse ? $diff < 0 : $diff > 0;
                    $cls = $diff == 0 ? 'cmp-flat' : ($good ? 'cmp-up' : 'cmp-down');
                @endphp
                <tr>
                    <td><strong>{{ $r['l'] }}</strong></td>
                    <td class="text-center fw-bold">{{ number_format($r['c'], 2) }}</td>
                    <td class="text-center text-muted">{{ number_format($r['p'], 2) }}</td>
                    <td class="text-center {{ $cls }}">{{ $diff >= 0 ? '+' : '' }}{{ number_format($diff, 2) }}</td>
                    <td class="text-center {{ $cls }}">
                        <i class="ti ti-{{ $diff > 0 ? 'arrow-up' : ($diff < 0 ? 'arrow-down' : 'minus') }}"></i>
                        {{ $diff >= 0 ? '+' : '' }}{{ $pct }}%
                    </td>
                </tr>
                @endforeach
            </tbody>
        </table>
    </div>
</div>
@endif

{{-- Expenses by Category --}}
@if($expensesByCategory->isNotEmpty())
<div class="card mb-3">
    <div class="card-header"><h3 class="card-title"><i class="ti ti-tags ms-1"></i> توزيع المصروفات حسب الفئة</h3></div>
    <div class="row">
        <div class="col-md-6">
            <div class="card-body"><div id="expenseChart"></div></div>
        </div>
        <div class="col-md-6">
            <div class="table-responsive">
                <table class="table card-table mb-0">
                    <thead><tr><th>الفئة</th><th class="text-center">عدد</th><th class="text-end">المبلغ</th><th class="text-center">%</th></tr></thead>
                    <tbody>
                        @foreach($expensesByCategory as $row)
                        <tr>
                            <td><strong>{{ $row['category'] }}</strong></td>
                            <td class="text-center">{{ $row['count'] }}</td>
                            <td class="text-end fw-bold">{{ number_format($row['amount'], 2) }}</td>
                            <td class="text-center">{{ $expenses > 0 ? round($row['amount']/$expenses*100, 1) : 0 }}%</td>
                        </tr>
                        @endforeach
                    </tbody>
                </table>
            </div>
        </div>
    </div>
</div>
@endif

<div class="print-footer print-only">
    التقرير المالي | {{ \App\Models\Setting::get('company_name') }} | {{ now()->format('Y-m-d H:i') }} | الفترة: {{ $from }} - {{ $to }}
</div>
@endsection

@push('scripts')
<script>
// Revenue vs Costs donut
new ApexCharts(document.querySelector('#distChart'), {
    chart: { type: 'donut', height: 280, fontFamily: 'Cairo' },
    series: [{{ $sales }}, {{ $pos }}, {{ $purchases }}, {{ $expenses }}],
    labels: ['مبيعات', 'نقطة بيع', 'مشتريات', 'مصروفات'],
    colors: ['#0d6efd', '#0dcaf0', '#fd7e14', '#dc3545'],
    legend: { position: 'bottom', fontFamily: 'Cairo' },
    plotOptions: { pie: { donut: { labels: { show: true, total: { show: true, label: 'الإجمالي' } } } } },
}).render();

@if($expensesByCategory->isNotEmpty())
const expData = @json($expensesByCategory->values());
new ApexCharts(document.querySelector('#expenseChart'), {
    chart: { type: 'bar', height: 320, fontFamily: 'Cairo' },
    series: [{ name: 'المصروفات', data: expData.map(d => d.amount) }],
    xaxis: { categories: expData.map(d => d.category) },
    plotOptions: { bar: { horizontal: true, distributed: true, borderRadius: 4 } },
    colors: ['#dc3545','#fd7e14','#ffc107','#0dcaf0','#0d6efd','#6f42c1','#6c757d'],
    legend: { show: false },
    dataLabels: { enabled: true, formatter: v => new Intl.NumberFormat('ar-EG').format(v) },
}).render();
@endif
</script>
@endpush