@extends('dashboard.admin.layouts.master')

@section('content')
<div class="d-flex flex-column flex-column-fluid">
    <div id="kt_app_toolbar" class="app-toolbar py-3 py-lg-6">
        <div id="kt_app_toolbar_container" class="app-container container-xxl d-flex flex-stack">
            <div class="page-title d-flex flex-column justify-content-center flex-wrap me-3">
                <h1 class="page-heading d-flex text-dark fw-bold fs-3 flex-column justify-content-center my-0">
                    {{ trans('finance.reports.expense_analytics.title') }}
                </h1>
            </div>
            <button onclick="window.print()" class="btn btn-light btn-sm">{{ trans('finance.reports.print') }}</button>
        </div>
    </div>

    <div id="kt_app_content" class="app-content flex-column-fluid">
        <div id="kt_app_content_container" class="app-container container-xxl">

            <div class="card mb-5 d-print-none">
                <div class="card-body py-4">
                    <form method="GET" class="row g-3 align-items-end">
                        <div class="col-md-3">
                            <label class="form-label fs-7">{{ trans('finance.reports.branch') }}</label>
                            <select name="branch_id" class="form-select form-select-sm">
                                <option value="">{{ trans('finance.reports.all') }}</option>
                                @foreach($filterOptions['branches'] as $b)
                                    <option value="{{ $b->id }}" @selected(($filters['branch_id'] ?? '') == $b->id)>{{ $b->name }}</option>
                                @endforeach
                            </select>
                        </div>
                        <div class="col-md-3">
                            <label class="form-label fs-7">{{ trans('finance.reports.expense_item') }}</label>
                            <select name="expense_item_id" class="form-select form-select-sm">
                                <option value="">{{ trans('finance.reports.all') }}</option>
                                @foreach($filterOptions['expenseItems'] as $i)
                                    <option value="{{ $i->id }}" @selected(($filters['expense_item_id'] ?? '') == $i->id)>{{ $i->name }}</option>
                                @endforeach
                            </select>
                        </div>
                        <div class="col-md-2">
                            <label class="form-label fs-7">{{ trans('finance.reports.date_from') }}</label>
                            <input type="date" name="date_from" class="form-control form-control-sm" value="{{ $filters['date_from'] ?? '' }}">
                        </div>
                        <div class="col-md-2">
                            <label class="form-label fs-7">{{ trans('finance.reports.date_to') }}</label>
                            <input type="date" name="date_to" class="form-control form-control-sm" value="{{ $filters['date_to'] ?? '' }}">
                        </div>
                        <div class="col-md-2">
                            <button type="submit" class="btn btn-primary btn-sm w-100">{{ trans('finance.reports.filter') }}</button>
                        </div>
                    </form>
                </div>
            </div>

            <div class="row g-4 mb-5">
                <div class="col-md-3">
                    <div class="card"><div class="card-body">
                        <div class="text-muted fs-7">{{ trans('finance.reports.total_count') }}</div>
                        <div class="fw-bolder fs-2 text-primary">{{ number_format($totals['expense_count']) }}</div>
                    </div></div>
                </div>
                <div class="col-md-3">
                    <div class="card"><div class="card-body">
                        <div class="text-muted fs-7">{{ trans('finance.reports.total_amount') }}</div>
                        <div class="fw-bolder fs-2 text-dark">{{ number_format($totals['total_amount'], 2) }}</div>
                    </div></div>
                </div>
                <div class="col-md-3">
                    <div class="card"><div class="card-body">
                        <div class="text-muted fs-7">{{ trans('finance.reports.total_paid') }}</div>
                        <div class="fw-bolder fs-2 text-success">{{ number_format($totals['total_paid'], 2) }}</div>
                    </div></div>
                </div>
                <div class="col-md-3">
                    <div class="card"><div class="card-body">
                        <div class="text-muted fs-7">{{ trans('finance.reports.total_unpaid') }}</div>
                        <div class="fw-bolder fs-2 text-danger">{{ number_format($totals['total_unpaid'], 2) }}</div>
                    </div></div>
                </div>
            </div>

            <div class="row g-5">
                <div class="col-lg-6">
                    <div class="card">
                        <div class="card-header"><h3 class="card-title fw-bold fs-5">{{ trans('finance.reports.by_item') }}</h3></div>
                        <div class="card-body pt-0">
                            <table class="table table-row-dashed gy-2">
                                <thead><tr class="fw-bold text-muted">
                                    <th>{{ trans('finance.reports.code') }}</th>
                                    <th>{{ trans('finance.reports.name') }}</th>
                                    <th class="text-end">{{ trans('finance.reports.count') }}</th>
                                    <th class="text-end">{{ trans('finance.reports.amount') }}</th>
                                </tr></thead>
                                <tbody>
                                    @forelse($byItem as $row)
                                    <tr>
                                        <td>{{ $row->code }}</td>
                                        <td>{{ $row->name }}</td>
                                        <td class="text-end">{{ number_format($row->expense_count) }}</td>
                                        <td class="text-end fw-bold">{{ number_format($row->total_amount, 2) }}</td>
                                    </tr>
                                    @empty
                                    <tr><td colspan="4" class="text-center text-muted py-4">{{ trans('finance.reports.no_data') }}</td></tr>
                                    @endforelse
                                </tbody>
                            </table>
                        </div>
                    </div>
                </div>

                <div class="col-lg-6">
                    <div class="card">
                        <div class="card-header"><h3 class="card-title fw-bold fs-5">{{ trans('finance.reports.by_branch') }}</h3></div>
                        <div class="card-body pt-0">
                            <table class="table table-row-dashed gy-2">
                                <thead><tr class="fw-bold text-muted">
                                    <th>{{ trans('finance.reports.code') }}</th>
                                    <th>{{ trans('finance.reports.name') }}</th>
                                    <th class="text-end">{{ trans('finance.reports.count') }}</th>
                                    <th class="text-end">{{ trans('finance.reports.amount') }}</th>
                                </tr></thead>
                                <tbody>
                                    @forelse($byBranch as $row)
                                    <tr>
                                        <td>{{ $row->code }}</td>
                                        <td>{{ $row->name }}</td>
                                        <td class="text-end">{{ number_format($row->expense_count) }}</td>
                                        <td class="text-end fw-bold">{{ number_format($row->total_amount, 2) }}</td>
                                    </tr>
                                    @empty
                                    <tr><td colspan="4" class="text-center text-muted py-4">{{ trans('finance.reports.no_data') }}</td></tr>
                                    @endforelse
                                </tbody>
                            </table>
                        </div>
                    </div>
                </div>

                <div class="col-12">
                    <div class="card">
                        <div class="card-header"><h3 class="card-title fw-bold fs-5">{{ trans('finance.reports.by_cost_center') }}</h3></div>
                        <div class="card-body pt-0">
                            <table class="table table-row-dashed gy-2">
                                <thead><tr class="fw-bold text-muted">
                                    <th>{{ trans('finance.reports.code') }}</th>
                                    <th>{{ trans('finance.reports.name') }}</th>
                                    <th class="text-end">{{ trans('finance.reports.count') }}</th>
                                    <th class="text-end">{{ trans('finance.reports.amount') }}</th>
                                    <th class="text-end">{{ trans('finance.reports.paid') }}</th>
                                </tr></thead>
                                <tbody>
                                    @forelse($byCostCenter as $row)
                                    <tr>
                                        <td>{{ $row->code ?? '—' }}</td>
                                        <td>{{ $row->name ?? trans('finance.reports.unassigned') }}</td>
                                        <td class="text-end">{{ number_format($row->expense_count) }}</td>
                                        <td class="text-end fw-bold">{{ number_format($row->total_amount, 2) }}</td>
                                        <td class="text-end">{{ number_format($row->total_paid, 2) }}</td>
                                    </tr>
                                    @empty
                                    <tr><td colspan="5" class="text-center text-muted py-4">{{ trans('finance.reports.no_data') }}</td></tr>
                                    @endforelse
                                </tbody>
                            </table>
                        </div>
                    </div>
                </div>
            </div>

        </div>
    </div>
</div>
@endsection