@extends('layouts.app')

@section('content')
<div class="container-fluid">
    <div class="d-flex justify-content-between align-items-center mb-3">
        <h3 class="mb-0">تقرير المصروفات</h3>
        <div>
            <a class="btn btn-outline-primary" href="{{ route('reports.expenses.export.pdf', request()->all()) }}" target="_blank">
                تصدير PDF
            </a>
        </div>
    </div>

    <div class="card mb-3">
        <div class="card-body">
            <form method="GET" class="row g-2">
                <div class="col-md-3">
                    <label class="form-label">التصنيف</label>
                    <select name="category_id" class="form-select">
                        <option value="">الكل</option>
                        @foreach($categories as $cat)
                            <option value="{{ $cat->id }}" {{ request('category_id') == $cat->id ? 'selected' : '' }}>{{ $cat->name }}</option>
                        @endforeach
                    </select>
                </div>
                <div class="col-md-2">
                    <label class="form-label">طريقة الدفع</label>
                    <select name="payment_method" class="form-select">
                        <option value="">الكل</option>
                        @foreach(['cash'=>'نقد','card'=>'بطاقة','online'=>'أونلاين','transfer'=>'حوالة'] as $k=>$v)
                            <option value="{{ $k }}" {{ request('payment_method') === $k ? 'selected' : '' }}>{{ $v }}</option>
                        @endforeach
                    </select>
                </div>
                <div class="col-md-2">
                    <label class="form-label">من تاريخ</label>
                    <input type="date" name="date_from" class="form-control" value="{{ request('date_from') }}">
                </div>
                <div class="col-md-2">
                    <label class="form-label">إلى تاريخ</label>
                    <input type="date" name="date_to" class="form-control" value="{{ request('date_to') }}">
                </div>
                <div class="col-md-3 d-flex align-items-end">
                    <button class="btn btn-primary me-2" type="submit">تصفية</button>
                    <a class="btn btn-light" href="{{ route('reports.expenses') }}">إعادة ضبط</a>
                </div>
            </form>
        </div>
    </div>

    <div class="row mb-3">
        <div class="col-md-3">
            <div class="card text-bg-light"><div class="card-body">
                <div class="small text-muted">إجمالي المصروفات</div>
                <div class="fs-4">{{ number_format($summary['total'], 2) }} OMR</div>
            </div></div>
        </div>
        <div class="col-md-3">
            <div class="card text-bg-light"><div class="card-body">
                <div class="small text-muted">عدد السجلات</div>
                <div class="fs-4">{{ $summary['count'] }}</div>
            </div></div>
        </div>
    </div>

    <div class="row">
        <div class="col-md-6">
            <div class="card">
                <div class="card-header">حسب التصنيف</div>
                <div class="table-responsive">
                    <table class="table table-sm mb-0">
                        <thead>
                            <tr>
                                <th>التصنيف</th>
                                <th class="text-end">المبلغ</th>
                                <th class="text-end">العدد</th>
                            </tr>
                        </thead>
                        <tbody>
                            @forelse($byCategory as $row)
                                <tr>
                                    <td>{{ optional($row->expense_category_id ? \App\Models\ExpenseCategory::find($row->expense_category_id) : null)->name ?? 'بدون' }}</td>
                                    <td class="text-end">{{ number_format($row->total, 2) }}</td>
                                    <td class="text-end">{{ $row->cnt }}</td>
                                </tr>
                            @empty
                                <tr><td colspan="3" class="text-center">لا توجد بيانات</td></tr>
                            @endforelse
                        </tbody>
                    </table>
                </div>
            </div>
        </div>
        <div class="col-md-6">
            <div class="card">
                <div class="card-header">حسب طريقة الدفع</div>
                <div class="table-responsive">
                    <table class="table table-sm mb-0">
                        <thead>
                            <tr>
                                <th>الطريقة</th>
                                <th class="text-end">المبلغ</th>
                                <th class="text-end">العدد</th>
                            </tr>
                        </thead>
                        <tbody>
                            @forelse($byPayment as $row)
                                <tr>
                                    <td>{{ ['cash'=>'نقد','card'=>'بطاقة','online'=>'أونلاين','transfer'=>'حوالة'][$row->payment_method] ?? $row->payment_method }}</td>
                                    <td class="text-end">{{ number_format($row->total, 2) }}</td>
                                    <td class="text-end">{{ $row->cnt }}</td>
                                </tr>
                            @empty
                                <tr><td colspan="3" class="text-center">لا توجد بيانات</td></tr>
                            @endforelse
                        </tbody>
                    </table>
                </div>
            </div>
        </div>
    </div>

    <div class="card mt-3">
        <div class="table-responsive">
            <table class="table table-striped mb-0">
                <thead>
                    <tr>
                        <th>#</th>
                        <th>التاريخ</th>
                        <th>التصنيف</th>
                        <th>المبلغ</th>
                        <th>طريقة الدفع</th>
                        <th>مرجع</th>
                        <th>المستخدم</th>
                    </tr>
                </thead>
                <tbody>
                    @forelse($expenses as $expense)
                        <tr>
                            <td>{{ $expense->id }}</td>
                            <td>{{ $expense->expense_date->format('Y-m-d H:i') }}</td>
                            <td>{{ optional($expense->category)->name }}</td>
                            <td>{{ number_format($expense->amount, 2) }} OMR</td>
                            <td>{{ ['cash'=>'نقد','card'=>'بطاقة','online'=>'أونلاين','transfer'=>'حوالة'][$expense->payment_method] ?? $expense->payment_method }}</td>
                            <td>{{ $expense->reference_no }}</td>
                            <td>{{ optional($expense->user)->name }}</td>
                        </tr>
                    @empty
                        <tr><td colspan="7" class="text-center">لا توجد بيانات</td></tr>
                    @endforelse
                </tbody>
            </table>
        </div>
        <div class="card-footer">{{ $expenses->links() }}</div>
    </div>
</div>
@endsection