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

@section('page-header')
@include('admin.reports._header', [
    'title' => 'تقرير المخزون الشامل',
    'subtitle' => 'تحليل قيمة المخزون والأصناف منخفضة الرصيد',
    'icon' => 'ti-building-warehouse',
    'color' => 'success',
])
@endsection

@php
    $totalItems = $stocks->groupBy('item_id')->count();
    $lowStockCount = $lowStock->count();
    $byCategory = $byCategory->sortByDesc('value');
    $insights = [];
    if ($lowStockCount > 0) $insights[] = ['type'=>'warning', 'text'=>"<strong>{$lowStockCount}</strong> صنف وصل للحد الأدنى - يحتاج إعادة طلب"];
    if ($totalValue > 0 && $byCategory->isNotEmpty()) {
        $top = $byCategory->first();
        $pct = round($top['value'] / $totalValue * 100, 1);
        if ($pct > 50) $insights[] = ['type'=>'warning', 'text'=>"<strong>".$top['category']."</strong> يمثل {$pct}% من قيمة المخزون - تركز عالي"];
    }
@endphp

@section('content')
<div class="no-print mb-3">
    <div class="card"><div class="card-body py-2">
        <button onclick="window.print()" class="btn btn-outline-secondary btn-sm"><i class="ti ti-printer ms-1"></i> طباعة</button>
        <button onclick="exportTablesToCSV()" class="btn btn-outline-success btn-sm"><i class="ti ti-file-spreadsheet ms-1"></i> تصدير Excel</button>
    </div></div>
</div>

@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-alert-circle ms-1"></i>
        <div>{!! $insight['text'] !!}</div>
    </div>
    @endforeach
</div>
@endif

<div class="row row-cards mb-3">
    <div class="col-md-3">
        <div class="kpi-pro featured" style="border-color:#198754">
            <i class="ti ti-coins kpi-icon-bg text-success"></i>
            <div class="kpi-label">قيمة المخزون</div>
            <div class="kpi-value text-success">{{ number_format($totalValue, 0) }} <span class="kpi-unit">ج</span></div>
            <div class="kpi-trend flat"><i class="ti ti-box"></i> {{ $totalItems }} صنف</div>
        </div>
    </div>
    <div class="col-md-3">
        <div class="kpi-pro featured" style="border-color:#dc3545">
            <i class="ti ti-alert-triangle kpi-icon-bg text-danger"></i>
            <div class="kpi-label">أصناف منخفضة</div>
            <div class="kpi-value text-danger">{{ $lowStockCount }}</div>
            <div class="kpi-trend down"><i class="ti ti-arrow-left"></i> <a href="{{ route('admin.purchase-orders.create') }}" class="text-danger">إنشاء أمر شراء</a></div>
        </div>
    </div>
    <div class="col-md-3">
        <div class="kpi-pro featured" style="border-color:#0dcaf0">
            <i class="ti ti-category kpi-icon-bg text-info"></i>
            <div class="kpi-label">عدد الفئات</div>
            <div class="kpi-value text-info">{{ $byCategory->count() }}</div>
            <div class="kpi-trend flat"><i class="ti ti-info-circle"></i> تصنيف</div>
        </div>
    </div>
    <div class="col-md-3">
        <div class="kpi-pro featured" style="border-color:#ffc107">
            <i class="ti ti-arrows-shuffle kpi-icon-bg text-warning"></i>
            <div class="kpi-label">حركة الأصناف</div>
            <div class="kpi-value text-warning">{{ \App\Models\StockMovement::whereDate('movement_date', '>=', now()->startOfMonth())->count() }}</div>
            <div class="kpi-trend flat"><i class="ti ti-calendar"></i> الشهر الحالي</div>
        </div>
    </div>
</div>

<div class="row row-cards mb-3">
    <div class="col-md-5">
        <div class="card h-100">
            <div class="card-header"><h3 class="card-title">توزيع المخزون حسب الفئة</h3></div>
            <div class="card-body"><div id="catChart"></div></div>
        </div>
    </div>
    <div class="col-md-7">
        <div class="card h-100">
            <div class="card-header"><h3 class="card-title">القيمة بالفئة</h3></div>
            <div class="table-responsive">
                <table class="table card-table table-vcenter">
                    <thead><tr><th>الفئة</th><th class="text-center">عدد الأصناف</th><th class="text-end">القيمة (ج)</th><th>النسبة</th></tr></thead>
                    <tbody>
                        @foreach($byCategory as $row)
                        @php $pct = $totalValue > 0 ? round($row['value']/$totalValue*100, 1) : 0; @endphp
                        <tr>
                            <td><strong>{{ $row['category'] }}</strong></td>
                            <td class="text-center">{{ $row['items'] }}</td>
                            <td class="text-end fw-bold">{{ number_format($row['value'], 0) }}</td>
                            <td>
                                <div class="d-flex align-items-center">
                                    <div class="progress flex-grow-1 ms-2" style="height:8px"><div class="progress-bar bg-success" style="width:{{ $pct }}%"></div></div>
                                    <strong>{{ $pct }}%</strong>
                                </div>
                            </td>
                        </tr>
                        @endforeach
                    </tbody>
                </table>
            </div>
        </div>
    </div>
</div>

<div class="card mb-3">
    <div class="card-header">
        <h3 class="card-title text-danger"><i class="ti ti-alert-triangle ms-1"></i> أصناف تحتاج إعادة طلب ({{ $lowStockCount }})</h3>
        <div class="card-actions"><a href="{{ route('admin.purchase-orders.create') }}" class="btn btn-warning btn-sm"><i class="ti ti-shopping-bag ms-1"></i> أمر شراء</a></div>
    </div>
    <div class="table-responsive">
        <table class="table card-table table-vcenter">
            <thead><tr><th>الكود</th><th>الصنف</th><th>الفئة</th><th class="text-center">الرصيد الحالي</th><th class="text-center">الحد الأدنى</th><th class="text-center">نقطة الطلب</th><th>الحالة</th></tr></thead>
            <tbody>
                @forelse($lowStock as $item)
                @php $stock = $item->totalStock(); @endphp
                <tr>
                    <td><code>{{ $item->code }}</code></td>
                    <td><strong>{{ $item->name }}</strong></td>
                    <td>{{ $item->category?->name ?? '-' }}</td>
                    <td class="text-center {{ $stock <= 0 ? 'text-danger fw-bold' : 'text-warning fw-bold' }}">{{ number_format($stock, 2) }} {{ $item->unit?->short_name }}</td>
                    <td class="text-center">{{ number_format($item->min_stock, 2) }}</td>
                    <td class="text-center">{{ number_format($item->reorder_point, 2) }}</td>
                    <td>
                        @if($stock <= 0)
                            <span class="badge bg-danger">نفذ</span>
                        @elseif($stock <= $item->min_stock)
                            <span class="badge bg-warning">حرج</span>
                        @else
                            <span class="badge bg-info">منخفض</span>
                        @endif
                    </td>
                </tr>
                @empty
                <tr><td colspan="7" class="text-center text-success py-4"><i class="ti ti-check-circle fs-2"></i><br>كل الأصناف بمستوى آمن</td></tr>
                @endforelse
            </tbody>
        </table>
    </div>
</div>

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

@push('scripts')
<script>
const cats = @json($byCategory->values());
new ApexCharts(document.querySelector('#catChart'), {
    chart: { type: 'donut', height: 320, fontFamily: 'Cairo' },
    series: cats.map(c => parseFloat(c.value)),
    labels: cats.map(c => c.category),
    legend: { position: 'bottom', fontFamily: 'Cairo' },
    colors: ['#0d6efd','#198754','#fd7e14','#dc3545','#0dcaf0','#6f42c1','#ffc107','#20c997'],
    plotOptions: { pie: { donut: { labels: { show: true, total: { show: true, label: 'الإجمالي', formatter: w => new Intl.NumberFormat('ar-EG').format(w.globals.seriesTotals.reduce((a,b)=>a+b,0)) } } } } },
}).render();

function exportTablesToCSV() {
    const tables = document.querySelectorAll('table');
    let csv = '';
    tables.forEach((t, i) => {
        if (i > 0) csv += '\n\n';
        t.querySelectorAll('tr').forEach(r => {
            csv += Array.from(r.querySelectorAll('th, td'))
                .map(c => '"' + c.innerText.replace(/"/g,'""').replace(/\n/g,' ').trim() + '"').join(',') + '\n';
        });
    });
    const blob = new Blob([csv], { type:'text/csv;charset=utf-8;' });
    const a = document.createElement('a');
    a.href = URL.createObjectURL(blob);
    a.download = 'inventory-report.csv'; a.click();
}
</script>
@endpush