@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('arap.ar_aging_title') }}</h1>
                </div>
            </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-7">
                    <div class="card-body py-5">
                        <form method="GET" action="{{ route('admin.dashboard.finance.reports.ar_aging.index') }}" class="row g-4 align-items-end">
                            <div class="col-md-4">
                                <label class="form-label">{{ trans('arap.customer') }}</label>
                                <select name="customer_id" data-control="select2" data-allow-clear="true" data-placeholder="{{ trans('arap.all_customers') }}" class="form-select">
                                    <option></option>
                                    @foreach($customers as $customer)
                                        <option value="{{ $customer->id }}" @selected(($filters['customer_id'] ?? '') == $customer->id)>{{ $customer->code }} - {{ $customer->name }}</option>
                                    @endforeach
                                </select>
                            </div>
                            <div class="col-md-4">
                                <label class="form-label">{{ trans('arap.branch') }}</label>
                                <select name="branch_id" data-control="select2" data-allow-clear="true" data-placeholder="{{ trans('arap.all_branches') }}" class="form-select">
                                    <option></option>
                                    @foreach($branches as $branch)
                                        <option value="{{ $branch->id }}" @selected(($filters['branch_id'] ?? '') == $branch->id)>{{ $branch->name }}</option>
                                    @endforeach
                                </select>
                            </div>
                            <div class="col-md-4">
                                <button type="submit" class="btn btn-primary">{{ trans('arap.apply') }}</button>
                            </div>
                        </form>
                    </div>
                </div>

                <div class="card mb-7">
                    <div class="card-body py-4">
                        <div class="table-responsive">
                            <table class="table align-middle table-row-dashed fs-6 gy-4">
                                <thead>
                                <tr class="text-start text-muted fw-bold fs-7 text-uppercase gs-0">
                                    <th>{{ trans('arap.code') }}</th>
                                    <th>{{ trans('arap.name') }}</th>
                                    <th class="text-end">{{ trans('arap.current') }}</th>
                                    <th class="text-end">{{ trans('arap.b1_30') }}</th>
                                    <th class="text-end">{{ trans('arap.b31_60') }}</th>
                                    <th class="text-end">{{ trans('arap.b61_90') }}</th>
                                    <th class="text-end">{{ trans('arap.over_90') }}</th>
                                    <th class="text-end">{{ trans('arap.total') }}</th>
                                </tr>
                                </thead>
                                <tbody class="text-gray-600 fw-semibold">
                                @forelse($report['rows'] as $row)
                                    <tr>
                                        <td>{{ $row->code }}</td>
                                        <td>{{ $row->name }}</td>
                                        <td class="text-end">{{ number_format($row->current, 2) }}</td>
                                        <td class="text-end">{{ number_format($row->b1_30, 2) }}</td>
                                        <td class="text-end">{{ number_format($row->b31_60, 2) }}</td>
                                        <td class="text-end">{{ number_format($row->b61_90, 2) }}</td>
                                        <td class="text-end">{{ number_format($row->over_90, 2) }}</td>
                                        <td class="text-end fw-bold">{{ number_format($row->total, 2) }}</td>
                                    </tr>
                                @empty
                                    <tr><td colspan="8" class="text-center py-10 text-muted">{{ trans('arap.no_data') }}</td></tr>
                                @endforelse
                                </tbody>
                                @if($report['rows']->isNotEmpty())
                                    <tfoot class="fw-bold fs-6">
                                    <tr>
                                        <td colspan="2" class="text-end">{{ trans('arap.totals') }}</td>
                                        <td class="text-end">{{ number_format($report['totals']['current'], 2) }}</td>
                                        <td class="text-end">{{ number_format($report['totals']['b1_30'], 2) }}</td>
                                        <td class="text-end">{{ number_format($report['totals']['b31_60'], 2) }}</td>
                                        <td class="text-end">{{ number_format($report['totals']['b61_90'], 2) }}</td>
                                        <td class="text-end">{{ number_format($report['totals']['over_90'], 2) }}</td>
                                        <td class="text-end">{{ number_format($report['totals']['total'], 2) }}</td>
                                    </tr>
                                    </tfoot>
                                @endif
                            </table>
                        </div>
                    </div>
                </div>

                <div class="card">
                    <div class="card-body py-4">
                        <h3 class="fs-5 fw-bold mb-4">{{ trans('arap.reconciliation') }}</h3>
                        <div class="row">
                            <div class="col-md-4">
                                <div class="text-muted fw-semibold">{{ trans('arap.ledger_balance') }}</div>
                                <div class="fs-4 fw-bold">{{ number_format($report['reconciliation']['ledger_balance'], 2) }}</div>
                            </div>
                            <div class="col-md-4">
                                <div class="text-muted fw-semibold">{{ trans('arap.erp_balance') }}</div>
                                <div class="fs-4 fw-bold">{{ number_format($report['reconciliation']['erp_balance'], 2) }}</div>
                            </div>
                            <div class="col-md-4">
                                <div class="text-muted fw-semibold">{{ trans('arap.difference') }}</div>
                                <div class="fs-4 fw-bold {{ abs($report['reconciliation']['difference']) > 0.01 ? 'text-danger' : 'text-success' }}">{{ number_format($report['reconciliation']['difference'], 2) }}</div>
                            </div>
                        </div>
                    </div>
                </div>

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