@extends('layouts.app')

@section('content')
<div class="min-h-screen bg-gradient-to-br from-slate-50 to-slate-100 py-8 px-4 md:px-8">
    <div class="max-w-7xl mx-auto">

        <!-- رأس الصفحة -->
        <div class="mb-8">
            <h1 class="text-3xl font-bold text-black mb-2">تقرير أرصدة المخزون</h1>
            <p class="text-black">عرض رصيد كل صنف في كل مخزن</p>
        </div>

        <!-- رسائل الحالة -->
        @if(session('success'))
        <div class="bg-green-50 border-l-4 border-green-500 p-4 mb-6 rounded-r-lg">
            <div class="flex">
                <div class="flex-shrink-0">
                    <i class="fas fa-check-circle text-green-500 text-xl"></i>
                </div>
                <div class="mr-3">
                    <p class="text-green-700 font-medium">{{ session('success') }}</p>
                </div>
            </div>
        </div>
        @endif

        <!-- نموذج التصفية -->
        <div class="bg-white rounded-xl shadow-lg p-6 mb-6 border border-gray-200">
            <h3 class="text-lg font-semibold text-black mb-4">
                <i class="fas fa-filter ml-2 text-blue-600"></i>تصفية البيانات
            </h3>

            <form method="GET" action="{{ route('inventory.reports.stock-balances') }}" class="space-y-4">
                <div class="grid grid-cols-1 md:grid-cols-2 lg:grid-cols-4 gap-4">
                    
                    <!-- المخزن -->
                    <div>
                        <label for="warehouse_id" class="block text-sm font-medium text-black mb-1">المخزن</label>
                        <select id="warehouse_id" name="warehouse_id" class="w-full px-4 py-2 border border-gray-300 rounded-lg focus:ring-2 focus:ring-blue-500 focus:border-transparent">
                            <option value="">جميع المخازن</option>
                            @foreach($warehouses as $warehouse)
                                <option value="{{ $warehouse->id }}" {{ $filters['warehouse_id'] == $warehouse->id ? 'selected' : '' }}>
                                    {{ $warehouse->name }}
                                </option>
                            @endforeach
                        </select>
                    </div>

                    <!-- الصنف -->
                    <div>
                        <label for="item_id" class="block text-sm font-medium text-black mb-1">الصنف</label>
                        <select id="item_id" name="item_id" class="w-full px-4 py-2 border border-gray-300 rounded-lg focus:ring-2 focus:ring-blue-500 focus:border-transparent">
                            <option value="">جميع الأصناف</option>
                            @foreach($items as $item)
                                <option value="{{ $item->id }}" {{ $filters['item_id'] == $item->id ? 'selected' : '' }}>
                                    {{ $item->name }}
                                </option>
                            @endforeach
                        </select>
                    </div>

                    <!-- الفئة -->
                    <div>
                        <label for="category_id" class="block text-sm font-medium text-black mb-1">الفئة</label>
                        <select id="category_id" name="category_id" class="w-full px-4 py-2 border border-gray-300 rounded-lg focus:ring-2 focus:ring-blue-500 focus:border-transparent">
                            <option value="">جميع الفئات</option>
                            @foreach($categories as $category)
                                <option value="{{ $category->id }}" {{ $filters['category_id'] == $category->id ? 'selected' : '' }}>
                                    {{ $category->name }}
                                </option>
                            @endforeach
                        </select>
                    </div>
                </div>

                <div class="flex gap-3">
                    <button type="submit" class="inline-flex items-center px-6 py-2 bg-blue-600 hover:bg-blue-700 text-white font-semibold rounded-lg transition-all duration-200">
                        <i class="fas fa-search mr-2"></i> بحث
                    </button>
                    <a href="{{ route('inventory.reports.stock-balances') }}" class="inline-flex items-center px-6 py-2 bg-gray-400 hover:bg-gray-500 text-white font-semibold rounded-lg transition-all duration-200">
                        <i class="fas fa-redo mr-2"></i> إعادة تعيين
                    </a>
                </div>
            </form>
        </div>

        <!-- الإحصائيات السريعة -->
        @if (count($stockBalances) > 0)
            @php
                $itemBalances = [];
                $balances = [];
                foreach ($stockBalances as $item) {
                    $key = $item->name . '_' . $item->warehouse_name;
                    $itemBalances[$item->name] = $item->current_quantity;
                }
                $finalBalance = array_sum($itemBalances);
            @endphp
            <div class="grid grid-cols-1 md:grid-cols-4 gap-4 mb-6">
                <!-- عدد الأصناف -->
                <div class="bg-white rounded-lg shadow-md border-l-4 border-blue-500 p-4">
                    <p class="text-black text-sm font-medium">عدد الأصناف</p>
                    <p class="text-2xl font-bold text-blue-600 mt-1">{{ $statistics['count'] }}</p>
                </div>

                <!-- إجمالي الكمية -->
                <div class="bg-white rounded-lg shadow-md border-l-4 border-green-500 p-4">
                    <p class="text-black text-sm font-medium">إجمالي الكمية</p>
                    <p class="text-2xl font-bold text-green-600 mt-1">{{ number_format($statistics['total_quantity'], 2) }}</p>
                </div>

                <!-- متوسط الكمية -->
                <div class="bg-white rounded-lg shadow-md border-l-4 border-orange-500 p-4">
                    <p class="text-black text-sm font-medium">متوسط الكمية</p>
                    <p class="text-2xl font-bold text-orange-600 mt-1">{{ number_format($statistics['average_quantity'], 2) }}</p>
                </div>

                <!-- الرصيد النهائي -->
                <div class="bg-white rounded-lg shadow-md border-l-4 border-purple-500 p-4">
                    <p class="text-black text-sm font-medium">الرصيد النهائي</p>
                    <p class="text-2xl font-bold text-purple-600 mt-1">{{ number_format($finalBalance, 2) }}</p>
                </div>
            </div>
        @endif

        <!-- جدول الأرصدة -->
        <div class="bg-white rounded-xl shadow-lg overflow-hidden border border-gray-200">
            <div class="overflow-x-auto">
                <table class="w-full">
                    <thead class="bg-gradient-to-r from-gray-800 to-gray-900 text-white">
                        <tr>
                            <th class="px-6 py-4 text-right font-semibold text-sm">#</th>
                            <th class="px-6 py-4 text-right font-semibold text-sm">التاريخ</th>
                            <th class="px-6 py-4 text-right font-semibold text-sm">نوع الحركة</th>
                            <th class="px-6 py-4 text-right font-semibold text-sm">الصنف</th>
                            <th class="px-6 py-4 text-center font-semibold text-sm">وارد</th>
                            <th class="px-6 py-4 text-center font-semibold text-sm">منصرف</th>
                            <th class="px-6 py-4 text-center font-semibold text-sm">محول</th>
                            <th class="px-6 py-4 text-center font-semibold text-sm">الرصيد</th>
                            <th class="px-6 py-4 text-right font-semibold text-sm">الوحدة</th>
                            <th class="px-6 py-4 text-right font-semibold text-sm">من / إلى</th>
                            <th class="px-6 py-4 text-right font-semibold text-sm">المستند</th>
                        </tr>
                    </thead>
                    <tbody class="divide-y divide-gray-200">
                        @php
                            $balances = [];
                            foreach ($stockBalances as $mov) {
                                $key = $mov->name . '_' . ($mov->warehouse_name ?? 'unknown');
                                $currentBalance = $balances[$key] ?? 0;
                                
                                if (isset($mov->inbound_qty) && $mov->inbound_qty > 0) {
                                    $currentBalance += floatval($mov->inbound_qty);
                                } elseif (isset($mov->outbound_qty) && $mov->outbound_qty > 0) {
                                    $currentBalance -= floatval($mov->outbound_qty);
                                } else {
                                    $currentBalance = $mov->current_quantity;
                                }
                                
                                $balances[$key] = $currentBalance;
                                $mov->running_balance = $currentBalance;
                            }
                        @endphp
                        @forelse($stockBalances as $item)
                            <tr class="hover:bg-blue-50 transition-colors duration-150">
                                <td class="px-6 py-4 text-black font-medium">{{ $loop->iteration }}</td>
                                <td class="px-6 py-4 text-sm text-black">-</td>

                                <!-- نوع الحركة -->
                                <td class="px-6 py-4">
                                    <span class="inline-flex items-center px-3 py-1 rounded-full text-sm font-medium bg-gray-100 text-black">
                                        <i class="fas fa-list ml-1"></i>أرصدة
                                    </span>
                                </td>

                                <td class="px-6 py-4 font-semibold text-black">
                                    {{ $item->name ?? '-' }}
                                    <span class="block text-xs text-black mt-1">الرصيد: {{ number_format($item->current_quantity, 2) }}</span>
                                </td>

                                <!-- الكميات -->
                                <td class="px-6 py-4 text-center">-</td>
                                <td class="px-6 py-4 text-center">-</td>
                                <td class="px-6 py-4 text-center">-</td>

                                <!-- الرصيد الجاري -->
                                <td class="px-6 py-4 text-center font-bold">
                                    <span class="px-3 py-1 rounded-lg {{ $item->current_quantity >= 0 ? 'bg-blue-100 text-blue-700' : 'bg-red-100 text-red-700' }}">
                                        {{ number_format($item->current_quantity, 2) }}
                                    </span>
                                </td>

                                <td class="px-6 py-4 text-sm text-black">{{ $item->primary_unit_name ?? '-' }}</td>

                                <!-- من/إلى -->
                                <td class="px-6 py-4 text-xs text-black">{{ $item->warehouse_name ?? '-' }}</td>

                                <td class="px-6 py-4 text-sm font-medium">{{ $item->code ?? '-' }}</td>
                            </tr>
                        @empty
                            <tr>
                                <td colspan="11" class="px-6 py-12 text-center">
                                    <div class="flex flex-col items-center justify-center">
                                        <i class="fas fa-inbox text-black text-4xl mb-3"></i>
                                        <p class="text-black font-medium">لا توجد بيانات</p>
                                        <p class="text-black text-sm mt-1">ابدأ بإضافة حركة للمخزن</p>
                                    </div>
                                </td>
                            </tr>
                        @endforelse
                    </tbody>
                </table>
            </div>
        </div>

    </div>
</div>
@endsection