@extends('admin.layouts.master')
@section('title', 'تقرير الأرصدة الشامل')

@section('css')
    <link href="{{ URL::asset('assets/admin/plugins/datatable/css/dataTables.bootstrap4.min.css') }}" rel="stylesheet" />
    <link href="{{ URL::asset('assets/admin/plugins/datatable/css/buttons.bootstrap4.min.css') }}" rel="stylesheet">
    <link href="{{ URL::asset('assets/admin/plugins/datatable/css/responsive.bootstrap4.min.css') }}" rel="stylesheet" />
    <link href="{{ URL::asset('assets/admin/plugins/datatable/css/jquery.dataTables.min.css') }}" rel="stylesheet">
    <link href="{{ URL::asset('assets/admin/plugins/datatable/css/responsive.dataTables.min.css') }}" rel="stylesheet">
    <link href="{{ URL::asset('assets/admin/plugins/select2/css/select2.min.css') }}" rel="stylesheet">
@endsection

@section('page-header')
    <!-- breadcrumb -->
    <div class="breadcrumb-header justify-content-between">
        <div class="my-auto">
            <div class="d-flex">
                <h4 class="content-title mb-0 my-auto">التقارير</h4>
                <span class="text-muted mt-1 tx-13 mr-2 mb-0">/ تقرير الأرصدة الشامل</span>
            </div>
        </div>
    </div>
    <!-- breadcrumb -->
@endsection

@section('content')
    <!-- row -->
    <div class="row">
        <div class="col-xl-12">
            <!-- إحصائيات سريعة -->
            <div class="row mb-4">
                <div class="col-lg-3 col-md-6">
                    <div class="card">
                        <div class="card-body">
                            <div class="counter-status d-flex align-items-center">
                                <div class="counter-icon bg-primary-gradient">
                                    <x-lucide-users width="24" height="24" />
                                </div>
                                <div class="mr-auto">
                                    <h5 class="tx-13">إجمالي المستخدمين</h5>
                                    <h2 class="mb-0 tx-22 mb-1 text-primary">{{ number_format($stats['total_users']) }}</h2>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>
                <div class="col-lg-3 col-md-6">
                    <div class="card">
                        <div class="card-body">
                            <div class="counter-status d-flex align-items-center">
                                <div class="counter-icon bg-success-gradient">
                                    <x-lucide-wallet width="24" height="24" />
                                </div>
                                <div class="mr-auto">
                                    <h5 class="tx-13">إجمالي الأرصدة</h5>
                                    <h2 class="mb-0 tx-22 mb-1 text-success">{{ number_format($stats['total_balance'], 2) }}
                                    </h2>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>
                <div class="col-lg-3 col-md-6">
                    <div class="card">
                        <div class="card-body">
                            <div class="counter-status d-flex align-items-center">
                                <div class="counter-icon bg-success-gradient">
                                    <x-lucide-arrow-up-circle width="24" height="24" />
                                </div>
                                <div class="mr-auto">
                                    <h5 class="tx-13">الأرصدة الموجبة</h5>
                                    <h2 class="mb-0 tx-22 mb-1 text-success">
                                        {{ number_format($stats['positive_balance'], 2) }}</h2>
                                    <p class="text-muted tx-11 mb-0">({{ $stats['positive_balance_count'] }} مستخدم)</p>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>
                <div class="col-lg-3 col-md-6">
                    <div class="card">
                        <div class="card-body">
                            <div class="counter-status d-flex align-items-center">
                                <div class="counter-icon bg-danger-gradient">
                                    <x-lucide-arrow-down-circle width="24" height="24" />
                                </div>
                                <div class="mr-auto">
                                    <h5 class="tx-13">الأرصدة السالبة</h5>
                                    <h2 class="mb-0 tx-22 mb-1 text-danger">
                                        {{ number_format($stats['negative_balance'], 2) }}</h2>
                                    <p class="text-muted tx-11 mb-0">({{ $stats['negative_balance_count'] }} مستخدم)</p>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>
            </div>

            <!-- إحصائيات إضافية -->
            <div class="row mb-4">
                <div class="col-lg-4">
                    <div class="card">
                        <div class="card-header">
                            <h6 class="card-title mb-0">إحصائيات الرصيد</h6>
                        </div>
                        <div class="card-body">
                            <div class="row">
                                <div class="col-6">
                                    <h6 class="tx-12 text-muted">أعلى رصيد</h6>
                                    <h4 class="text-success">{{ number_format($stats['max_balance'], 2) }}</h4>
                                </div>
                                <div class="col-6">
                                    <h6 class="tx-12 text-muted">أقل رصيد</h6>
                                    <h4 class="text-danger">{{ number_format($stats['min_balance'], 2) }}</h4>
                                </div>
                                <div class="col-12 mt-3">
                                    <h6 class="tx-12 text-muted">متوسط الرصيد</h6>
                                    <h4 class="text-primary">{{ number_format($stats['avg_balance'], 2) }}</h4>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>
                <div class="col-lg-4">
                    <div class="card">
                        <div class="card-header">
                            <h6 class="card-title mb-0">حسب نوع المستخدم</h6>
                        </div>
                        <div class="card-body">
                            <div class="row">
                                <div class="col-6">
                                    <h6 class="tx-12 text-muted">التجار</h6>
                                    <h5>{{ number_format($stats['balances_by_user_type']['vendors']->count ?? 0) }}</h5>
                                    <p class="tx-11 text-muted">
                                        {{ number_format($stats['balances_by_user_type']['vendors']->total ?? 0, 2) }}</p>
                                </div>
                                <div class="col-6">
                                    <h6 class="tx-12 text-muted">المستخدمين العاديين</h6>
                                    <h5>{{ number_format($stats['balances_by_user_type']['regular']->count ?? 0) }}</h5>
                                    <p class="tx-11 text-muted">
                                        {{ number_format($stats['balances_by_user_type']['regular']->total ?? 0, 2) }}</p>
                                </div>
                            </div>
                        </div>
                    </div>
                </div>
                <div class="col-lg-4">
                    <div class="card">
                        <div class="card-header">
                            <h6 class="card-title mb-0">حسب العملة</h6>
                        </div>
                        <div class="card-body">
                            @foreach ($stats['balances_by_currency'] as $currency_stat)
                                <div class="d-flex justify-content-between mb-2">
                                    <span class="tx-12">{{ $currency_stat->currency->symbol ?? 'غير محدد' }}</span>
                                    <span
                                        class="tx-12 font-weight-bold">{{ number_format($currency_stat->total_balance, 2) }}</span>
                                </div>
                            @endforeach
                        </div>
                    </div>
                </div>
            </div>

            <!-- فلاتر البحث -->
            <div class="card mb-4">
                <div class="card-header">
                    <h6 class="card-title mb-0">فلاتر البحث</h6>
                </div>
                <div class="card-body">
                    <form method="GET" action="{{ route('admin.reports.users.balances-summary') }}" class="row">
                        <div class="col-lg-3 col-md-6 mb-3">
                            <label class="form-label">العملة</label>
                            <select name="currency_id" class="form-control select2">
                                <option value="">جميع العملات</option>
                                @foreach ($currencies as $currency)
                                    <option value="{{ $currency->id }}"
                                        {{ request('currency_id') == $currency->id ? 'selected' : '' }}>
                                        {{ $currency->name }} ({{ $currency->symbol }})
                                    </option>
                                @endforeach
                            </select>
                        </div>
                        <div class="col-lg-3 col-md-6 mb-3">
                            <label class="form-label">نوع المستخدم</label>
                            <select name="user_type" class="form-control">
                                <option value="">جميع الأنواع</option>
                                <option value="vendor" {{ request('user_type') == 'vendor' ? 'selected' : '' }}>التجار
                                </option>
                                <option value="regular" {{ request('user_type') == 'regular' ? 'selected' : '' }}>
                                    المستخدمين العاديين</option>
                            </select>
                        </div>
                        <div class="col-lg-3 col-md-6 mb-3">
                            <label class="form-label">حالة الرصيد</label>
                            <select name="balance_status" class="form-control">
                                <option value="">جميع الأرصدة</option>
                                <option value="positive" {{ request('balance_status') == 'positive' ? 'selected' : '' }}>
                                    الأرصدة الموجبة</option>
                                <option value="negative" {{ request('balance_status') == 'negative' ? 'selected' : '' }}>
                                    الأرصدة السالبة</option>
                                <option value="zero" {{ request('balance_status') == 'zero' ? 'selected' : '' }}>الأرصدة
                                    صفر</option>
                            </select>
                        </div>
                        <div class="col-lg-3 col-md-6 mb-3">
                            <label class="form-label">حالة النشاط</label>
                            <select name="is_active" class="form-control">
                                <option value="">جميع الحالات</option>
                                <option value="1" {{ request('is_active') == '1' ? 'selected' : '' }}>نشط</option>
                                <option value="0" {{ request('is_active') == '0' ? 'selected' : '' }}>غير نشط
                                </option>
                            </select>
                        </div>
                        <div class="col-lg-3 col-md-6 mb-3">
                            <label class="form-label">ترتيب الرصيد</label>
                            <select name="sort_order" class="form-control">
                                <option value="desc" {{ request('sort_order') == 'desc' ? 'selected' : '' }}>من الأعلى
                                    للأقل</option>
                                <option value="asc" {{ request('sort_order') == 'asc' ? 'selected' : '' }}>من الأقل
                                    للأعلى</option>
                            </select>
                        </div>
                        <div class="col-lg-9 col-md-6 mb-3 d-flex align-items-end">
                            <button type="submit" class="btn btn-primary me-2">
                                <x-lucide-search width="20" height="20" /> بحث
                            </button>
                            <a href="{{ route('admin.reports.users.balances-summary') }}" class="btn btn-secondary me-2">
                                <x-lucide-refresh-cw width="20" height="20" /> مسح الفلاتر
                            </a>
                            <button type="button" class="btn btn-success" onclick="exportData()">
                                <x-lucide-download width="20" height="20" /> تصدير Excel
                            </button>
                        </div>
                    </form>
                </div>
            </div>

            <!-- جدول البيانات -->
            <div class="card">
                <div class="card-header">
                    <h6 class="card-title mb-0">قائمة المستخدمين والأرصدة</h6>
                </div>
                <div class="card-body">
                    <div class="table-responsive">
                        <table class="table table-striped table-bordered nowrap" style="width:100%">
                            <thead>
                                <tr>
                                    <th>#</th>
                                    <th>الاسم</th>
                                    <th>البريد الإلكتروني</th>
                                    <th>رقم الهاتف</th>
                                    <th>العملة</th>
                                    <th>الرصيد</th>
                                    <th>الحد الأدنى</th>
                                    <th>نوع المستخدم</th>
                                    <th>حالة النشاط</th>
                                    <th>تاريخ التسجيل</th>
                                </tr>
                            </thead>
                            <tbody>
                                @forelse($users as $user)
                                    <tr>
                                        <td>{{ $loop->iteration + ($users->currentPage() - 1) * $users->perPage() }}</td>
                                        <td>
                                            <div class="d-flex align-items-center">
                                                <img src="{{ route('admin.media.users.avatar', ['user' => $user->id]) }}"
                                                    alt="صورة المستخدم" class="avatar-sm rounded-circle me-2"
                                                    style="width: 32px; height: 32px;">
                                                <div>
                                                    <strong>{{ $user->name }}</strong>
                                                    @if ($user->store)
                                                        <br><small class="text-muted">{{ $user->store }}</small>
                                                    @endif
                                                </div>
                                            </div>
                                        </td>
                                        <td>{{ $user->email }}</td>
                                        <td>{{ $user->mobile }}</td>
                                        <td>
                                            <span class="badge badge-info">
                                                {{ $user->currency->symbol ?? 'غير محدد' }}
                                            </span>
                                        </td>
                                        <td>
                                            <span
                                                class="badge badge-{{ $user->balance > 0 ? 'success' : ($user->balance < 0 ? 'danger' : 'secondary') }}">
                                                {{ number_format($user->balance, 2) }}
                                            </span>
                                        </td>
                                        <td>{{ number_format($user->min_balance, 2) }}</td>
                                        <td>
                                            @if ($user->is_vendor)
                                                <span class="badge badge-warning">تاجر</span>
                                            @else
                                                <span class="badge badge-primary">مستخدم عادي</span>
                                            @endif
                                        </td>
                                        <td>
                                            <span class="badge badge-{{ $user->isActive ? 'success' : 'danger' }}">
                                                {{ $user->isActive ? 'نشط' : 'غير نشط' }}
                                            </span>
                                        </td>
                                        <td>{{ $user->created_at->format('Y-m-d') }}</td>
                                    </tr>
                                @empty
                                    <tr>
                                        <td colspan="10" class="text-center">لا توجد بيانات</td>
                                    </tr>
                                @endforelse
                            </tbody>
                        </table>
                    </div>

                    <!-- Pagination -->
                    <div class="d-flex justify-content-center mt-3">
                        {{ $users->appends(request()->query())->links() }}
                    </div>
                </div>
            </div>
        </div>
    </div>
    <!-- row closed -->
@endsection

@section('js')
    <script src="{{ URL::asset('assets/admin/plugins/datatable/js/jquery.dataTables.min.js') }}"></script>
    <script src="{{ URL::asset('assets/admin/plugins/datatable/js/dataTables.dataTables.min.js') }}"></script>
    <script src="{{ URL::asset('assets/admin/plugins/datatable/js/dataTables.responsive.min.js') }}"></script>
    <script src="{{ URL::asset('assets/admin/plugins/datatable/js/responsive.dataTables.min.js') }}"></script>
    <script src="{{ URL::asset('assets/admin/plugins/datatable/js/jquery.dataTables.js') }}"></script>
    <script src="{{ URL::asset('assets/admin/plugins/datatable/js/dataTables.bootstrap4.js') }}"></script>
    <script src="{{ URL::asset('assets/admin/plugins/datatable/js/dataTables.buttons.min.js') }}"></script>
    <script src="{{ URL::asset('assets/admin/plugins/datatable/js/buttons.bootstrap4.min.js') }}"></script>
    <script src="{{ URL::asset('assets/admin/plugins/datatable/js/jszip.min.js') }}"></script>
    <script src="{{ URL::asset('assets/admin/plugins/datatable/js/pdfmake.min.js') }}"></script>
    <script src="{{ URL::asset('assets/admin/plugins/datatable/js/vfs_fonts.js') }}"></script>
    <script src="{{ URL::asset('assets/admin/plugins/datatable/js/buttons.html5.min.js') }}"></script>
    <script src="{{ URL::asset('assets/admin/plugins/datatable/js/buttons.print.min.js') }}"></script>
    <script src="{{ URL::asset('assets/admin/plugins/datatable/js/buttons.colVis.min.js') }}"></script>
    <script src="{{ URL::asset('assets/admin/plugins/datatable/js/dataTables.responsive.min.js') }}"></script>
    <script src="{{ URL::asset('assets/admin/plugins/datatable/js/responsive.bootstrap4.min.js') }}"></script>
    <script src="{{ URL::asset('assets/admin/plugins/select2/js/select2.min.js') }}"></script>

    <script>
        $(document).ready(function() {
            $('.select2').select2();
        });

        function exportData() {
            // جمع معاملات الفلتر الحالية
            const params = new URLSearchParams(window.location.search);

            // إضافة معامل التصدير
            params.set('export', 'excel');

            // إنشاء رابط التصدير
            const exportUrl = '{{ route('admin.reports.users.export-balances-summary') }}?' + params.toString();

            // فتح رابط التصدير
            window.open(exportUrl, '_blank');
        }
    </script>
@endsection