@extends('layouts.app')

@section('content')
<div class="pagetitle">
    <h1>{{ __('reports.reports.expenses_title') }}</h1>
    <nav>
        <ol class="breadcrumb">
            <li class="breadcrumb-item"><a href="/admin">{{ __('Home') }}</a></li>
            <li class="breadcrumb-item active">{{ __('reports.reports.expenses_title') }}</li>
        </ol>
    </nav>
</div>

<div class="card">
    <div class="card-body pt-3">
        @include('admin.reports._filters')

        <div class="d-flex gap-2 mb-3">
            <a class="btn btn-outline-success" href="{{ route('export.reports.expenses.excel', request()->query()) }}">
                <i class="bi bi-file-earmark-excel"></i> {{ __('reports.actions.export_excel') }}
            </a>
            <a class="btn btn-outline-danger" href="{{ route('export.reports.expenses.pdf', request()->query()) }}">
                <i class="bi bi-file-earmark-pdf"></i> {{ __('reports.actions.export_pdf') }}
            </a>
        </div>

        <div class="row mb-3">
            <div class="col-md-4">
                <div class="alert alert-warning mb-0"><b>{{ __('reports.totals.total_expenses') }}:</b> {{ number_format($total_expenses, 2) }}</div>
            </div>
        </div>

        <h6 class="mt-3">{{ __('reports.reports.expenses_by_category') }}</h6>
        <table class="table table-bordered">
            <thead>
                <tr>
                    <th>{{ __('reports.fields.expense_category') }}</th>
                    <th>{{ __('reports.fields.total') }}</th>
                </tr>
            </thead>
            <tbody>
                @forelse($by_category as $r)
                    <tr>
                        <td>{{ app()->getLocale() == 'ar' ? $r->label_ar : $r->label_en }}</td>
                        <td>{{ number_format($r->total, 2) }}</td>
                    </tr>
                @empty
                    <tr><td colspan="2" class="text-center text-muted">{{ __('reports.messages.no_data') }}</td></tr>
                @endforelse
            </tbody>
        </table>

        <h6 class="mt-4">{{ __('reports.reports.expenses_list') }}</h6>
        <table class="table table-bordered">
            <thead>
                <tr>
                    <th>#</th>
                    <th>{{ __('reports.fields.date') }}</th>
                    <th>{{ __('reports.fields.expense_category') }}</th>
                    <th>{{ __('reports.fields.expense') }}</th>
                    <th>{{ __('reports.fields.total') }}</th>
                </tr>
            </thead>
            <tbody>
                @forelse($rows as $r)
                    <tr>
                        <td>{{ $r->id }}</td>
                        <td>{{ $r->real_date }}</td>
                        <td>{{ app()->getLocale() == 'ar' ? ($r->cat_ar ?? $r->cat_en) : ($r->cat_en ?? $r->cat_ar) }}</td>
                        <td>{{ app()->getLocale() == 'ar' ? $r->label_ar : $r->label_en }}</td>
                        <td>{{ number_format($r->price, 2) }}</td>
                    </tr>
                @empty
                    <tr><td colspan="5" class="text-center text-muted">{{ __('reports.messages.no_data') }}</td></tr>
                @endforelse
            </tbody>
        </table>

        <div class="mt-3">{{ $rows->links() }}</div>


    </div>
</div>
@endsection