@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.cash_bank_movement.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.account') }}</label>
                            <select name="account_id" class="form-select form-select-sm">
                                <option value="">{{ trans('finance.reports.all') }}</option>
                                @foreach($filterOptions['accounts'] as $a)
                                    <option value="{{ $a->id }}" @selected(($filters['account_id'] ?? '') == $a->id)>{{ $a->code }} — {{ $a->name }}</option>
                                @endforeach
                            </select>
                        </div>
                        <div class="col-md-2">
                            <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-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-3">
                            <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-4">
                    <div class="card"><div class="card-body">
                        <div class="text-muted fs-7">{{ trans('finance.reports.total_debit') }}</div>
                        <div class="fw-bolder fs-2 text-success">{{ number_format($totals['total_debit'], 2) }}</div>
                    </div></div>
                </div>
                <div class="col-md-4">
                    <div class="card"><div class="card-body">
                        <div class="text-muted fs-7">{{ trans('finance.reports.total_credit') }}</div>
                        <div class="fw-bolder fs-2 text-danger">{{ number_format($totals['total_credit'], 2) }}</div>
                    </div></div>
                </div>
                <div class="col-md-4">
                    <div class="card"><div class="card-body">
                        <div class="text-muted fs-7">{{ trans('finance.reports.net_movement') }}</div>
                        <div class="fw-bolder fs-2 {{ $totals['net_movement'] >= 0 ? 'text-primary' : 'text-warning' }}">{{ number_format($totals['net_movement'], 2) }}</div>
                    </div></div>
                </div>
            </div>

            <div class="card">
                <div class="card-body pt-0">
                    <div class="table-responsive">
                        <table class="table table-row-dashed align-middle gy-3">
                            <thead>
                                <tr class="fw-bold text-muted">
                                    <th>{{ trans('finance.reports.entry_date') }}</th>
                                    <th>{{ trans('finance.reports.entry_number') }}</th>
                                    <th>{{ trans('finance.reports.journal') }}</th>
                                    <th>{{ trans('finance.reports.account') }}</th>
                                    <th>{{ trans('finance.reports.branch') }}</th>
                                    <th>{{ trans('finance.reports.description') }}</th>
                                    <th class="text-end">{{ trans('finance.reports.debit') }}</th>
                                    <th class="text-end">{{ trans('finance.reports.credit') }}</th>
                                </tr>
                            </thead>
                            <tbody>
                                @forelse($movements as $m)
                                <tr>
                                    <td>{{ \Illuminate\Support\Carbon::parse($m->entry_date)->format('Y-m-d') }}</td>
                                    <td class="fw-bold">{{ $m->entry_number }}</td>
                                    <td>{{ $m->journal_code ?? '—' }}</td>
                                    <td class="fs-7">{{ $m->account_code }} — {{ $m->account_name }}</td>
                                    <td>{{ $m->branch_name ?? '—' }}</td>
                                    <td class="fs-7">{{ $m->line_description ?? $m->entry_description ?? '—' }}</td>
                                    <td class="text-end {{ $m->debit > 0 ? 'fw-bold text-success' : 'text-muted' }}">{{ number_format($m->debit, 2) }}</td>
                                    <td class="text-end {{ $m->credit > 0 ? 'fw-bold text-danger' : 'text-muted' }}">{{ number_format($m->credit, 2) }}</td>
                                </tr>
                                @empty
                                <tr><td colspan="8" class="text-center text-muted py-6">{{ trans('finance.reports.no_data') }}</td></tr>
                                @endforelse
                            </tbody>
                            @if($movements->count())
                            <tfoot>
                                <tr class="fw-bold border-top">
                                    <td colspan="6" class="text-end">{{ trans('finance.reports.page_total') }}:</td>
                                    <td class="text-end">{{ number_format(collect($movements->items())->sum('debit'), 2) }}</td>
                                    <td class="text-end">{{ number_format(collect($movements->items())->sum('credit'), 2) }}</td>
                                </tr>
                            </tfoot>
                            @endif
                        </table>
                    </div>
                    <div class="d-flex justify-content-end mt-4 d-print-none">{{ $movements->links() }}</div>
                </div>
            </div>
        </div>
    </div>
</div>
@endsection