@extends('layouts.app')

@section('content')
    <main class="main-content">
        <div class="page-header">
            <h1 class="page-title">Relatório de Contas a Pagar</h1>
            <p class="page-subtitle">Contas e parcelas por período</p>
        </div>

        <div class="users-card">
            <div class="users-header">
                <h3 class="users-title">Filtros</h3>
                <div class="users-actions">
                    <a href="{{ route('relatorios.contas.pdf', ['dt_inicial' => $dtInicial, 'dt_final' => $dtFinal, 'situacao' => $situacao, 'tipo' => $tipo]) }}" target="_blank" class="btn-primary">
                        <i class="fas fa-print"></i>
                        Imprimir
                    </a>
                </div>
            </div>
            <form action="{{ route('relatorios.contas') }}" method="GET">
            <div class="row">
                <div class="col-md-3">
                    <div class="form-group">
                        <label for="dt_inicial">Data Inicial</label>
                        <input type="text" class="form-control date-picker" id="dt_inicial" name="dt_inicial" value="{{ $dtInicial }}" placeholder="dd/mm/aaaa">
                    </div>
                </div>

                <div class="col-md-3">
                    <div class="form-group">
                        <label for="dt_final">Data Final</label>
                        <input type="text" class="form-control date-picker" id="dt_final" name="dt_final" value="{{ $dtFinal }}" placeholder="dd/mm/aaaa">
                    </div>
                </div>

                <div class="col-md-2">
                    <div class="form-group">
                        <label for="situacao">Situação</label>
                        <select class="form-control" id="situacao" name="situacao">
                            <option value="Todos" {{ $situacao === 'Todos' ? 'selected' : '' }}>Todos</option>
                            <option value="aPagar" {{ $situacao === 'aPagar' ? 'selected' : '' }}>A Pagar</option>
                            <option value="Pago" {{ $situacao === 'Pago' ? 'selected' : '' }}>Pago</option>
                            <option value="vencidas" {{ $situacao === 'vencidas' ? 'selected' : '' }}>Vencidas</option>
                        </select>
                    </div>
                </div>

                <div class="col-md-2">
                    <div class="form-group">
                        <label for="tipo">Tipo</label>
                        <select class="form-control" id="tipo" name="tipo">
                            <option value="Contas" {{ $tipo === 'Contas' ? 'selected' : '' }}>Contas</option>
                            <option value="Parcelas" {{ $tipo === 'Parcelas' ? 'selected' : '' }}>Parcelas</option>
                        </select>
                    </div>
                </div>
            </div>

            <div class="row" style="margin-top: 10px;">
                <div class="col-md-12 text-end">
                    <button type="submit" class="btn btn-primary">
                        <i class="fas fa-search"></i> Filtrar
                    </button>
                </div>
            </div>
            </form>
        </div>

        <div class="users-card">
            <div class="users-header">
                <h3 class="users-title">Resumo</h3>
            </div>
            <div class="row">
                <div class="col-md-4 mb-3">
                    <h6 class="text-muted mb-1">Valor Total</h6>
                    <h4 class="mb-0">R$ {{ number_format($totais['valor_total'], 2, ',', '.') }}</h4>
                </div>
                <div class="col-md-4 mb-3">
                    <h6 class="text-muted mb-1">Valor Pago</h6>
                    <h4 class="text-success mb-0">R$ {{ number_format($totais['valor_pago'], 2, ',', '.') }}</h4>
                </div>
                <div class="col-md-4 mb-3">
                    <h6 class="text-muted mb-1">Valor Restante</h6>
                    <h4 class="text-danger mb-0">R$ {{ number_format($totais['valor_restante'], 2, ',', '.') }}</h4>
                </div>
            </div>
        </div>

        <div class="users-card">
            <div class="users-header">
                <h3 class="users-title">{{ $tipo === 'Contas' ? 'Contas' : 'Parcelas' }}</h3>
            </div>
            <div class="table-responsive">
                @if($tipo === 'Contas')
                    <table class="table table-hover table-sm users-table">
                        <thead>
                            <tr>
                                <th>Nº DOC</th>
                                <th>Data</th>
                                <th>Fornecedor</th>
                                <th>Categoria - Tipo</th>
                                <th>Qtd Parc</th>
                                <th class="text-end">Valor</th>
                                <th class="text-end">Restante</th>
                                <th class="text-end">Pago</th>
                            </tr>
                        </thead>
                        <tbody>
                            @forelse($contas as $conta)
                                <tr>
                                    <td>{{ $conta->pedido }}</td>
                                    <td>{{ \Carbon\Carbon::parse($conta->data)->format('d/m/Y') }}</td>
                                    <td>{{ $conta->fornecedor ? $conta->fornecedor->nome : '' }}</td>
                                    <td>
                                        @if($conta->categoriaDespesa)
                                            {{ $conta->categoriaDespesa->nome }}
                                            @if($conta->tipoCategoria)
                                                - {{ $conta->tipoCategoria->nome }}
                                            @endif
                                        @else
                                            -
                                        @endif
                                    </td>
                                    <td>{{ $conta->n_parcelas }}</td>
                                    <td class="text-end">R$ {{ number_format($conta->valor_total, 2, ',', '.') }}</td>
                                    <td class="text-end">R$ {{ number_format($conta->valor_restante, 2, ',', '.') }}</td>
                                    <td class="text-end">R$ {{ number_format($conta->valor_pago, 2, ',', '.') }}</td>
                                </tr>
                            @empty
                                <tr>
                                    <td colspan="8" class="text-center py-4">
                                        <i class="fas fa-inbox fa-3x text-muted mb-3"></i>
                                        <p class="text-muted">Nenhum registro encontrado no período!</p>
                                    </td>
                                </tr>
                            @endforelse
                        </tbody>
                    </table>
                @else
                    <table class="table table-hover table-sm users-table">
                        <thead>
                            <tr>
                                <th>Nº DOC</th>
                                <th>Vencimento</th>
                                <th>Fornecedor</th>
                                <th>Categoria - Tipo</th>
                                <th>Descrição</th>
                                <th class="text-end">Valor</th>
                                <th class="text-end">Restante</th>
                                <th class="text-end">Pago</th>
                                <th>Status</th>
                            </tr>
                        </thead>
                        <tbody>
                            @forelse($contas as $parcela)
                                <tr>
                                    <td>{{ $parcela->pedido }}</td>
                                    <td>{{ \Carbon\Carbon::parse($parcela->vencimento)->format('d/m/Y') }}</td>
                                    <td>{{ $parcela->conta && $parcela->conta->fornecedor ? $parcela->conta->fornecedor->nome : '' }}</td>
                                    <td>
                                        @php
                                            $categoriaDespesa = $parcela->categoriaDespesa ?? ($parcela->conta->categoriaDespesa ?? null);
                                            $tipoCategoria = $parcela->tipoCategoria ?? ($parcela->conta->tipoCategoria ?? null);
                                        @endphp
                                        @if($categoriaDespesa)
                                            {{ $categoriaDespesa->nome }}
                                            @if($tipoCategoria)
                                                - {{ $tipoCategoria->nome }}
                                            @endif
                                        @else
                                            -
                                        @endif
                                    </td>
                                    <td>{{ $parcela->descricao }}</td>
                                    <td class="text-end">R$ {{ number_format($parcela->valor, 2, ',', '.') }}</td>
                                    <td class="text-end">R$ {{ number_format($parcela->valor_restante, 2, ',', '.') }}</td>
                                    <td class="text-end">R$ {{ number_format($parcela->valor_pago, 2, ',', '.') }}</td>
                                    <td>
                                        @if($parcela->status === 'pago' || $parcela->status === 'recebida')
                                            <span class="badge bg-success">Pago</span>
                                        @else
                                            <span class="badge bg-warning text-dark">A Pagar</span>
                                        @endif
                                    </td>
                                </tr>
                            @empty
                                <tr>
                                    <td colspan="9" class="text-center py-4">
                                        <i class="fas fa-inbox fa-3x text-muted mb-3"></i>
                                        <p class="text-muted">Nenhum registro encontrado no período!</p>
                                    </td>
                                </tr>
                            @endforelse
                        </tbody>
                    </table>
                @endif
            </div>
        </div>
    </main>

@push('scripts')
<script>
    $(document).ready(function() {
        $('.date-picker').datepicker({
            format: 'dd/mm/yyyy',
            language: 'pt-BR',
            autoclose: true,
            todayHighlight: true
        });
    });
</script>
@endpush
@endsection