@extends('layouts.app', ['page' => __('Pagos por conciliar'), 'pageSlug' => 'pendingconciliation', 'section' => 'menu'])

@section('content')

    @component('components.searchBar', ['fields' => $fields , 'action' => route('customers.pendingconciliation'), 'search' => $search]) @endcomponent

    <div class="row">
        <div class="col-md-12">
           <div class="card ">
                <div class="card-header">
                    <div class="row">
                        <div class="col-12">
                            <h2 class="card-title">{{ __('Estados de Cuenta')  }}</h2>
                        </div>
                    </div>
                </div>

                <div class="card-body">
                    <table class="table tablesorter text-center">
                        <thead class="th-gradient">
                                <th class="th-text-color" scope="col"> {{ __('Cliente') }}</th>
                                <th class="th-text-color" scope="col"> {{ __('Desarrollo') }}</th>
                                <th class="th-text-color" scope="col">{{ __('Status') }}</th>
                                                                <th class="th-text-color" scope="col">{{ __('Período') }}</th>
                                <th class="th-text-color" scope="col">{{ __('Monto (MXN)') }}</th>
                                <th class="th-text-color" scope="col">{{ __('Dépositos') }}</th>
                                <th class="th-text-color" scope="col">{{ __('Saldo') }}</th>
                                <th class="th-text-color" scope="col">{{ __('Comprobantes de pago / Recibos') }}</th>
                                <th class="th-text-color" scope="col">{{ __('Eliminar pagos') }}</th>
                                <th class="th-text-color" scope="col"></th>
                        </thead>
                        <tbody>
                            @foreach ($accountStatements as $index => $accountStatement)

                                @if ($accountStatement->amount > 0 && $accountStatement->customer)

                                    <tr class="table-row-hover td-gradient">

                                        <td>{{ $accountStatement->customer->name }}</td>
                                        <td>{{ $accountStatement->unit->typology->houseDevelopment->name }} <br/> {{ $accountStatement->unit->typology->name }} <br/> {{ $accountStatement->unit->name }}</td>
                                        <td>{{ $accountStatement->status }}</td> <!-- Status -->

                                        
                                        <td style="text-transform: capitalize;">{{ $accountStatement->issue_date->translatedFormat('F Y') }}</td> <!-- Periodo -->

                                        <td>${{ number_format($accountStatement->amount) }}</td>  <!-- Importe -->

                                        <!-- Depositos -->
                                        <td>
                                            @if ($accountStatement->accountStatementconciliation->isEmpty())
                                                <p>-</p>
                                            @else
                                                @foreach ($accountStatement->accountStatementconciliation as $conciliation)
                                                    ${{ number_format($conciliation->amount) }} / {{ $conciliation->conciliation_date }}<br/>
                                                @endforeach
                                            @endif
                                        </td>

                                        <!-- Saldo Firma de contrato -->
                                        @if ($index === 0)
                                            <td>
                                                @php
                                                    // Inicializar el saldo restante con el monto total del AccountStatement
                                                    $remainingBalance = $accountStatement->amount;
                                                @endphp

                                                @if ($accountStatement->accountStatementconciliation->isEmpty())
                                                    @if ($remainingBalance == 0 || empty($remainingBalance))
                                                        -
                                                    @else
                                                        ${{ number_format($remainingBalance) }}
                                                    @endif
                                                @else
                                                    @foreach ($accountStatement->accountStatementconciliation as $conciliation)
                                                        @php
                                                            // Restar el monto del depósito actual
                                                            $remainingBalance -= $conciliation->amount;
                                                        @endphp
                                                        <!-- Mostrar el saldo restante después de este depósito -->
                                                        ${{ number_format($remainingBalance) }}<br/>
                                                    @endforeach
                                                @endif
                                            </td>
                                        @elseif ($accountStatement->status != "En espera")
                                            <!-- Saldo Pagos parciales y Saldo en Escrituracion -->
                                            <td>
                                                @php
                                                    $previousBalance = $index > 0 ? $accountStatements[$index - 1]->debt_to_date : 0;

                                                    $remainingBalance = $accountStatement->amount + $previousBalance;
                                                @endphp

                                                @if ($accountStatement->accountStatementconciliation->isEmpty())
                                                    ${{ number_format($accountStatement->debt_to_date) }}
                                                @else
                                                    @foreach ($accountStatement->accountStatementconciliation as $conciliation)
                                                        @php
                                                            $remainingBalance -= $conciliation->amount;
                                                        @endphp

                                                        <!-- Mostrar el saldo restante después de este depósito -->
                                                        ${{ number_format($remainingBalance) }}<br/>

                                                    @endforeach
                                                @endif
                                            </td>
                                            @else
                                                <td>-</td>
                                        @endif

                                        <td>
                                            <div class="row justify-content-center">
                                                @if ($accountStatement->blueprints->isEmpty())
                                                -
                                                @else
                                                    @can('conciliar_pagos')
                                                        <div class="dropdown">
                                                            <a class="btn btn-sm btn-icon-only text-light bw-btn-anchor" href="#" role="button" data-toggle="dropdown" aria-haspopup="true" aria-expanded="false">
                                                                <i class="tim-icons icon-settings-gear-63"></i>
                                                            </a>
                                                            <div class="dropdown-menu dropdown-menu-right dropdown-menu-arrow">
                                                                @forelse ($accountStatement->blueprints as $blueprint)
                                                                    @php
                                                                        // Verificar si existe alguna conciliación relacionada con el blueprint actual
                                                                        $hasConciliation = $accountStatement->accountStatementconciliation
                                                                            ->where('account_statement_blue_prints_id', $blueprint->id)
                                                                            ->isNotEmpty();
                                                                    @endphp

                                                                    @if ($hasConciliation)
                                                                        <li>
                                                                            <a class="dropdown-item" href="{{ route('customers.validatepayment', ['customer' => $accountStatement->customer_id, 'unit' => $accountStatement->unit_id, 'accountStatement' => $accountStatement, 'blueprint' => $blueprint]) }}">Pago conciliado: {{ $blueprint->name }}</a>
                                                                        </li>
                                                                    @else
                                                                        <li>
                                                                            <a class="dropdown-item" href="{{ route('customers.validatepayment', ['customer' => $accountStatement->customer_id, 'unit' => $accountStatement->unit_id, 'accountStatement' => $accountStatement, 'blueprint' => $blueprint]) }}">Comprobante de Pago: {{ $blueprint->name }}</a>
                                                                        </li>
                                                                    @endif
                                                                @empty
                                                                @endforelse
                                                            </div>
                                                        </div>
                                                    @endcan
                                                @endif
                                            </div>
                                        </td>

                                        <td>
                                            <div class="row justify-content-center">
                                                @if ($accountStatement->blueprints->isEmpty() or $accountStatement->accountStatementconciliation->isEmpty())
                                                -
                                                @else
                                                    @can('conciliar_pagos')
                                                        <div class="dropdown">
                                                            <a class="btn btn-sm btn-icon-only text-light bw-btn-anchor" href="#" role="button" data-toggle="dropdown" aria-haspopup="true" aria-expanded="false">
                                                                <i class="tim-icons icon-settings-gear-63"></i>
                                                            </a>
                                                            <div class="dropdown-menu dropdown-menu-right dropdown-menu-arrow">
                                                                @forelse ($accountStatement->blueprints as $blueprint)
                                                                    @php
                                                                        // Verificar si existe alguna conciliación relacionada con el blueprint actual
                                                                        $hasConciliation = $accountStatement->accountStatementconciliation
                                                                            ->where('account_statement_blue_prints_id', $blueprint->id)
                                                                            ->isNotEmpty();

                                                                        $conciliation = $accountStatement->accountStatementconciliation
                                                                            ->where('account_statement_blue_prints_id', $blueprint->id)
                                                                            ->first();
                                                                    @endphp

                                                                    @if ($hasConciliation)
                                                                        <li>
                                                                            <a class="dropdown-item" href="javascript:void(0);" 
                                                                            onclick="confirmDeleteSwal('{{ route('customers.deletepayment', ['accountStatement' => $accountStatement, 'blueprint' => $blueprint, 'accountStatementConciliation' => $conciliation]) }}', '{{ $blueprint->name }}')">
                                                                            Eliminar Pago: {{ $blueprint->name }}
                                                                            </a>
                                                                        </li>
                                                                    @endif
                                                                @empty
                                                                @endforelse
                                                            </div>
                                                        </div>
                                                    @endcan
                                                @endif
                                            </div>
                                        </td>

                                        <td>
                                            @can('conciliar_pagos')
                                                <a class="btn btn-sm btn-gradient" href="{{ route('customers.accountStatementConciliationIndex', ['customer' => $accountStatement->customer_id, 'unit' => $accountStatement->unit_id, 'accountStatement' => $accountStatement, 'blueprint' => null]) }}">{{ __('Agregar pago') }}</a>
                                            @endcan
                                        </td>
                                    </tr>

                                @endif
                            @endforeach

                            @if(count($accountStatements) == 0)
                                <tr class="table-row-hover td-gradient"><td colspan="9">No hay pagos pendientes por conciliar.</td></tr>
                            @endif
                        </tbody>
                    </table>
                </div>
                <div class="card-footer py-4">
                    <nav class="d-flex justify-content-end" aria-label="...">
                        {{ $accountStatements->appends($_GET)->links() }}
                    </nav>
                </div>
            </div>
        </div>
    </div>

@endsection

@push('js')
<script>
    function confirmDeleteSwal(url, blueprintName) {
        Swal.fire({
            title: '¿Estás seguro que deseas eliminar el pago?',
            text: 'Esta acción no se puede deshacer.',
            icon: 'warning',
            showCancelButton: true,
            confirmButtonText: 'Sí, eliminar',
            cancelButtonText: 'Cancelar'
        }).then((result) => {
            if (result.isConfirmed) {
                window.location.href = url;
            }
        });
    }
</script>
@endpush