@extends('layouts.app', ['page' => __('Estado de Cuenta'), 'pageSlug' => 'account-statement', 'section' => 'menu'])

@section('content')

    <div class="row">
        <div class="col-md-12">
           <div class="card ">
                <div class="card-header">
                    <div class="row" style="border-bottom:2px solid #343434;margin-bottom: 20px;">
                        <div class="col-12 text-right">
                            <h4>{{ now()->translatedFormat('d F Y') }}</h4>
                        </div>
                    </div>

                    <div class="row">
                        <div class="col-12 col-md-6">
                            <h1 class="mb-3">{{ __('Estados de cuenta') }}</h1>
                            <h3 class="bw-card-text-bold">
                                Proyecto: {{ $unit->typology->houseDevelopment->name }} / {{ $unit->typology->name }} / {{ $unit->name }}
                            </h3>
                        </div>
                        <div class="col-12 col-md-6 text-md-right text-left mt-3 mt-md-0">
                            <h4 class="bw-card-text-bold">{{ __('Valor total:') }} ${{ number_format($listPrice) }}</h4>

                            @if (isset($lastDebtStatement->debt_to_date))
                                <h4 class="bw-card-text-bold">{{ __('Saldo al día:') }} ${{ number_format($lastDebtStatement->debt_to_date) }}</h4>
                            @else
                                <h4 class="bw-card-text-bold">{{ __('Saldo al día:') }} No disponible</h4>
                            @endif
                        </div>
                    </div>

                </div>

                <div class="card-body">
                    <div class="row">
                        <div class="col-5">
                            <h4>Cliente: <span class="bw-card-text">{{ $customer->name }}</span></h4>
                            <h4>Precio de lista: <span class="bw-card-text">${{ number_format($unit->price) }}</span></h4>
                            @if($unit->has_own_measurement)
                                <h4>Área interior: <span class="bw-card-text">{{ $unit->construction_meters }}</span></h4>
                                <h4>Área exterior: <span class="bw-card-text">{{ $unit->meters_of_free_area }}</span></h4>
                            @else
                                <h4>Área interior: <span class="bw-card-text">{{ $unit->typology->construction_meters }}</span></h4>
                                <h4>Área exterior: <span class="bw-card-text">{{ $unit->typology->meters_of_free_area }}</span></h4>
                            @endif
                        </div>
                        <div class="col-5">
                            <h4>Desarrollo: <span class="bw-card-text">{{ $unit->typology->houseDevelopment->name }}</span></h4>
                            <h4>Departamento: <span class="bw-card-text">{{ $unit->name }}</span></h4>
                            <h4>Nivel: <span class="bw-card-text">{{ $unit->levels }}</span></h4>
                        </div>
                    </div>
                    <br/>
                    <br/>
                    <div class="row">
                        <div class="col-12">
                            <div style="position: absolute;bottom: 10px;right: 0;">
                                <a target="_blank" href="{{ route('portal-customers.account-statement.pdf.generate',['customer' => $customer, 'unit' => $unit ]) }}" class="btn btn-gradient">Imprimir Estado de cuenta</a>
                            </div>
                        </div>
                    </div>

                    <!-- Contenedor con scroll horizontal -->
                    <div class="table-responsive">
                        <table class="table tablesorter text-center">
                            <thead class="th-gradient">
                                    <th class="th-text-color" scope="col"> {{ __('Pago') }}</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">{{ __('Tipo de Pago') }}</th>
                                    <th class="th-text-color" scope="col">{{ __('Administrar comprobantes de pago') }}</th>
                                    <th class="th-text-color" scope="col">{{ __('Ver Recibos') }}</th>
                            </thead>
                            <tbody>
                                @foreach ($accountStatements as $index => $accountStatement)

                                    @if ($accountStatement->amount > 0 )

                                        <tr class="table-row-hover td-gradient">
                                            <td>
                                                @if ($index === 0 || $index === $accountStatements->count() - 1)
                                                    1 / 1
                                                @else
                                                    {{ $index }} / {{ $accountStatements->count() -2 }}
                                                @endif
                                            </td>

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

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

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

                                            <!-- Saldo Firma de contrato -->
                                            @if ($index === 0)
                                                <td>
                                                    @php
                                                        $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
                                                                $remainingBalance -= $conciliation->amount;
                                                            @endphp
                                                            ${{ number_format($remainingBalance) }}<br/>
                                                        @endforeach
                                                    @endif
                                                </td>
                                            @elseif ($accountStatement->status != "En espera")
                                                <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
                                                            ${{ number_format($remainingBalance) }}<br/>
                                                        @endforeach
                                                    @endif
                                                </td>
                                            @else
                                                <td>-</td>
                                            @endif

                                            <td>
                                                @if ($accountStatement->accountStatementconciliation->isEmpty())
                                                    <p>-</p>
                                                @else
                                                    @foreach ($accountStatement->accountStatementconciliation as $conciliation)
                                                        {{ $conciliation->payment_type }}<br/>
                                                    @endforeach
                                                @endif
                                            </td>

                                            <td>
                                                <a class="btn btn-gradient" href="{{ route('portal-customers.accountstatement-blueprints.showByAccountStatement', ['customer' => $customer, 'unit' => $unit, 'accountStatement' => $accountStatement]) }}">{{ __('Subir o editar comprobantes') }}</a>
                                            </td>

                                            <td>
                                                @if ($accountStatement->accountStatementconciliation->isEmpty())
                                                    {{ __('No hay recibos') }}
                                                @else
                                                    <div class="row justify-content-center">
                                                        <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
                                                                        $hasConciliation = $accountStatement->accountStatementconciliation
                                                                            ->where('account_statement_blue_prints_id', $blueprint->id)
                                                                            ->isNotEmpty();
                                                                    @endphp

                                                                    @if ($hasConciliation)
                                                                        <li>
                                                                            <a class="dropdown-item" href="{{ route('portal-customers.accountStatement.showreceipt', ['customer' => $accountStatement->customer_id, 'unit' => $accountStatement->unit_id, 'accountStatement' => $accountStatement->id, 'blueprint' => $blueprint->id]) }}">
                                                                                Recibo: {{ $blueprint->name }}
                                                                            </a>
                                                                        </li>
                                                                    @endif
                                                                @empty
                                                                @endforelse
                                                            </div>
                                                        </div>
                                                    </div>
                                                @endif
                                            </td>
                                        </tr>

                                    @endif
                                @endforeach
                                <tr class="table-row-hover td-gradient">
                                    <td></td>
                                    <td>Totales</td>
                                    <td>${{ number_format($listPrice) }}</td>
                                    <td>${{ number_format($totalConciliationAmount) }}</td>
                                    <td></td>
                                    <td></td>
                                    <td></td>
                                    <td></td>
                                </tr>

                                @if(count($accountStatements) == 0)
                                    <tr class="table-row-hover td-gradient"><td colspan="8">No hay registros de pago para este estado de cuenta.</td></tr>
                                @endif
                            </tbody>
                        </table>
                    </div><!-- Fin table-responsive -->
                </div>
            </div>
        </div>
    </div>

@endsection