@extends('layouts.app')
@section('title', 'Payment Reconciliation')

@section('content')
@php
    $providerLabels = [
        'maya_checkout' => 'Maya Checkout / QRPh',
        'paymongo_checkout' => 'PayMongo Checkout',
        'xendit_payment_session' => 'Xendit Checkout',
        'card_terminal' => 'Card terminal',
    ];
@endphp
<section class="content-header">
    <h1>Payment Reconciliation</h1>
</section>

<section class="content">
    <div class="row">
        <div class="col-md-3 col-sm-6">
            <div class="small-box bg-green">
                <div class="inner"><h3>{{ number_format($summary['confirmed_count']) }}</h3><p>Confirmed payments</p></div>
                <div class="icon"><i class="fa fa-check-circle"></i></div>
            </div>
        </div>
        <div class="col-md-3 col-sm-6">
            <div class="small-box bg-aqua">
                <div class="inner"><h3><span class="display_currency" data-currency_symbol="true">{{ $summary['confirmed_amount'] }}</span></h3><p>Confirmed amount</p></div>
                <div class="icon"><i class="fa fa-money"></i></div>
            </div>
        </div>
        <div class="col-md-3 col-sm-6">
            <div class="small-box bg-yellow">
                <div class="inner"><h3><span class="display_currency" data-currency_symbol="true">{{ $summary['unsettled_amount'] }}</span></h3><p>Awaiting settlement</p></div>
                <div class="icon"><i class="fa fa-clock-o"></i></div>
            </div>
        </div>
        <div class="col-md-3 col-sm-6">
            <div class="small-box bg-red">
                <div class="inner"><h3>{{ number_format($summary['review_count']) }}</h3><p>Needs review</p></div>
                <div class="icon"><i class="fa fa-exclamation-triangle"></i></div>
            </div>
        </div>
    </div>

    <div class="callout callout-info">
        <h4><i class="fa fa-info-circle"></i> Settlement matching</h4>
        <p>Upload a provider CSV containing a merchant reference or provider reference plus the gross amount. Matching confirmed payments are marked settled; differences are kept for review.</p>
    </div>

    <div class="box box-primary">
        <div class="box-header with-border"><h3 class="box-title">Import provider settlement</h3></div>
        {!! Form::open(['route' => 'integrated-payments.import-settlement', 'method' => 'post', 'files' => true]) !!}
        <div class="box-body">
            <div class="row">
                <div class="col-md-4">
                    <div class="form-group">
                        {!! Form::label('provider', 'Provider:*') !!}
                        {!! Form::select('provider', $providerLabels, null, ['class' => 'form-control', 'required']) !!}
                    </div>
                </div>
                <div class="col-md-5">
                    <div class="form-group">
                        {!! Form::label('settlement_file', 'Settlement CSV:*') !!}
                        {!! Form::file('settlement_file', ['class' => 'form-control', 'accept' => '.csv,text/csv', 'required']) !!}
                    </div>
                </div>
                <div class="col-md-3">
                    <button type="submit" class="btn btn-primary" style="margin-top: 25px;"><i class="fa fa-upload"></i> Import and match</button>
                </div>
            </div>
            <small class="text-muted">Recognized headings include merchant_reference, request_reference_number, provider_reference, provider_payment_id, reference, amount, gross_amount, net_amount, fee, batch_number, and settled_at.</small>
        </div>
        {!! Form::close() !!}
    </div>

    <div class="box box-solid">
        <div class="box-header with-border">
            <h3 class="box-title">Provider payment attempts</h3>
        </div>
        <div class="box-body">
            {!! Form::open(['method' => 'get', 'class' => 'row']) !!}
                <div class="col-md-3">{!! Form::select('provider', ['' => 'All providers'] + $providerLabels, request('provider'), ['class' => 'form-control']) !!}</div>
                <div class="col-md-3">{!! Form::select('status', ['' => 'All payment statuses', 'paid' => 'Paid', 'pending' => 'Pending', 'processing' => 'Processing', 'failed' => 'Failed', 'cancelled' => 'Cancelled', 'needs_review' => 'Needs review', 'voided' => 'Voided', 'refunded' => 'Refunded'], request('status'), ['class' => 'form-control']) !!}</div>
                <div class="col-md-3">{!! Form::select('settlement_status', ['' => 'All settlement statuses', 'unsettled' => 'Unsettled', 'settled' => 'Settled', 'mismatch' => 'Mismatch'], request('settlement_status'), ['class' => 'form-control']) !!}</div>
                <div class="col-md-3"><button class="btn btn-default" type="submit"><i class="fa fa-filter"></i> Filter</button></div>
            {!! Form::close() !!}
            <br>
            <div class="table-responsive">
                <table class="table table-bordered table-striped">
                    <thead>
                    <tr>
                        <th>Date</th><th>Provider / channel</th><th>References</th><th>Location</th><th>Amount</th><th>Payment</th><th>Sale</th><th>Settlement</th><th></th>
                    </tr>
                    </thead>
                    <tbody>
                    @forelse($attempts as $attempt)
                        <tr>
                            <td>{{ optional($attempt->created_at)->format('Y-m-d H:i') }}</td>
                            <td>{{ $providerLabels[$attempt->provider] ?? str_replace('_', ' ', $attempt->provider) }}<br><small>{{ str_replace('_', ' ', $attempt->channel) }}</small></td>
                            <td><strong>{{ $attempt->merchant_reference }}</strong>
                                @if($attempt->provider_reference)<br><small>{{ $attempt->provider_reference }}</small>@endif
                            </td>
                            <td>{{ optional($attempt->location)->name ?: '—' }}</td>
                            <td><span class="display_currency" data-currency_symbol="true">{{ $attempt->amount }}</span></td>
                            <td><span class="label {{ $attempt->status === 'paid' ? 'label-success' : ($attempt->status === 'needs_review' ? 'label-danger' : 'label-default') }}">{{ str_replace('_', ' ', $attempt->status) }}</span></td>
                            <td>{{ optional($attempt->transaction)->invoice_no ?: 'Not linked' }}</td>
                            <td><span class="label {{ $attempt->settlement_status === 'settled' ? 'label-success' : ($attempt->settlement_status === 'mismatch' ? 'label-danger' : 'label-warning') }}">{{ str_replace('_', ' ', $attempt->settlement_status) }}</span></td>
                            <td>
                                @if(in_array($attempt->status, ['created', 'pending', 'processing']))
                                    {!! Form::open(['route' => ['integrated-payments.sync', $attempt->uuid], 'method' => 'post']) !!}
                                    <button class="btn btn-xs btn-default" type="submit"><i class="fa fa-refresh"></i> Refresh</button>
                                    {!! Form::close() !!}
                                @endif
                            </td>
                        </tr>
                    @empty
                        <tr><td colspan="9" class="text-center text-muted">No integrated payment attempts found.</td></tr>
                    @endforelse
                    </tbody>
                </table>
            </div>
            {{ $attempts->links() }}
        </div>
    </div>
</section>
@endsection