@extends(backpack_view('blank'))

@section('header')
    <section class="container-fluid">
        <h2>Bilan &agrave; Payer</h2>
    </section>
@endsection

@section('content')
<div class="row mb-3">
    <div class="col-12">
        <form method="GET" action="{{ route('paid.search') }}" id="filterForm">
            <div class="row g-2 align-items-end">

                <div class="col-md-2">
                    <label class="form-label">Vendeur</label>
                    <select name="agent" class="form-select" onchange="this.form.submit()">
                        <option value="*" @selected($agent === '*')>Tout</option>
                        @foreach ($sellers as $seller)
                            <option value="{{ $seller->id }}" @selected($agent == $seller->id)>{{ $seller->name }}</option>
                        @endforeach
                    </select>
                </div>

                <div class="col-md-2">
                    <label class="form-label">Center</label>
                    <select name="center" class="form-select" onchange="this.form.submit()">
                        <option value="*" @selected($cent === '*')>Tout</option>
                        @foreach ($centers as $center)
                            <option value="{{ $center->id }}" @selected($cent == $center->id)>{{ $center->name }}</option>
                        @endforeach
                    </select>
                </div>

                <div class="col-md-2">
                    <label class="form-label">Tirage</label>
                    <select name="draw" class="form-select" onchange="this.form.submit()">
                        <option value="*" @selected($dra === '*')>Tout</option>
                        @foreach ($draws as $draw)
                            <option value="{{ $draw->id }}" @selected($dra == $draw->id)>{{ $draw->name }}</option>
                        @endforeach
                    </select>
                </div>

                <div class="col-md-2">
                    <label class="form-label">Du</label>
                    <input type="date" name="from" class="form-control" value="{{ $from_show }}"
                           onchange="this.form.submit()">
                </div>

                <div class="col-md-2">
                    <label class="form-label">Au</label>
                    <input type="date" name="to" class="form-control" value="{{ $to_show }}"
                           onchange="this.form.submit()">
                </div>

            </div>
        </form>
    </div>
</div>

<div class="row">
    <div class="col-12">
        <div class="card">
            <div class="card-body p-0">
                <div class="table-responsive">
                    <table id="bilanTable" class="table table-striped table-hover mb-0">
                        <thead class="table-dark">
                            <tr>
                                <th>Vendeur</th>
                                <th>Date</th>
                                <th>Lotterie / Tirage</th>
                                <th class="text-end">Vente</th>
                                <th class="text-end">Commission</th>
                                <th class="text-end">Cash</th>
                                <th class="text-end">&Agrave; payer</th>
                                <th class="text-end">Diff</th>
                            </tr>
                        </thead>
                        <tbody>
                            @php
                                $totalVente      = 0;
                                $totalCommission = 0;
                                $totalCash       = 0;
                                $totalTopay      = 0;
                                $totalDiff       = 0;
                            @endphp
                            @forelse ($pointofsales as $row)
                                @php
                                    $totalVente      += $row->vente;
                                    $totalCommission += $row->commission;
                                    $totalCash       += $row->cash;
                                    $totalTopay      += $row->topay;
                                    $totalDiff       += $row->diff;
                                @endphp
                                <tr>
                                    <td><strong>{{ $row->name }}</strong></td>
                                    <td>{{ \Carbon\Carbon::parse($row->date1)->format('d-m-Y') }}</td>
                                    <td>{{ $row->lotterie }} &mdash; {{ $row->draw }}</td>
                                    <td class="text-end">{{ number_format($row->vente, 2) }}</td>
                                    <td class="text-end">{{ number_format($row->commission, 2) }}</td>
                                    <td class="text-end">{{ number_format($row->cash, 2) }}</td>
                                    <td class="text-end">
                                        {{ number_format($row->topay, 2) }}
                                        <small class="text-muted">HTG</small>
                                    </td>
                                    <td class="text-end @if($row->diff < 0) text-danger @endif">
                                        {{ number_format($row->diff, 2) }}
                                    </td>
                                </tr>
                            @empty
                                <tr>
                                    <td colspan="8" class="text-center text-muted py-4">{{ __('crud.no_data') }}</td>
                                </tr>
                            @endforelse
                        </tbody>
                        <tfoot class="table-light fw-bold">
                            <tr>
                                <td colspan="3" class="text-end">{{ __('crud.totals') }}</td>
                                <td class="text-end">{{ number_format($totalVente, 2) }}</td>
                                <td class="text-end">{{ number_format($totalCommission, 2) }}</td>
                                <td class="text-end">{{ number_format($totalCash, 2) }}</td>
                                <td class="text-end">{{ number_format($totalTopay, 2) }}</td>
                                <td class="text-end @if($totalDiff < 0) text-danger @endif">
                                    {{ number_format($totalDiff, 2) }}
                                </td>
                            </tr>
                        </tfoot>
                    </table>
                </div>
            </div>
        </div>
    </div>
</div>
@endsection

@section('after_scripts')
<script>
    document.addEventListener('DOMContentLoaded', function () {
        if (typeof $.fn.DataTable !== 'undefined') {
            $('#bilanTable').DataTable({
                pageLength: 25,
                lengthMenu: [10, 25, 50, 100],
                order: [],
                columnDefs: [{ orderable: false, targets: -1 }],
            });
        }
    });
</script>
@endsection