@extends('layouts.app')

@section('title', 'Contas Bancárias')

@push('styles-custom')
    <link href="{{ asset('vendors/choices/choices.min.css') }}" rel="stylesheet" />
    <link href="{{ asset('vendors/flatpickr/flatpickr.min.css') }}" rel="stylesheet" />
    <link href="{{ asset('vendors/select2/css/select2.css') }}" rel="stylesheet" />
    <!-- DataTables CSS -->
    <link rel="stylesheet" href="https://cdn.datatables.net/1.13.6/css/dataTables.bootstrap5.min.css">
    <style>
        /* Mantém estilos do Select2 */
        .select2-container--default .select2-selection--single {
            height: 31px;
            padding: 0.1rem 0.5rem;
            font-size: 0.8125rem;
            border-radius: 0.25rem;
        }
        .select2-container--default .select2-selection--single .select2-selection__rendered {
            line-height: 24px;
        }
        .select2-container--default .select2-selection--single .select2-selection__arrow {
            height: 30px;
        }
        .modal-lg .select2-container {
            width: 100% !important;
        }

        /* Cores zebradas - linhas ímpares brancas, pares cinza */
        #contasBancariasTable tbody tr {
            background-color: #ffffff !important;
        }

        #contasBancariasTable tbody tr:nth-child(odd),
        table#contasBancariasTable tbody tr:nth-child(odd) {
            background-color: #ffffff !important;
        }

        #contasBancariasTable tbody tr:nth-child(even),
        table#contasBancariasTable tbody tr:nth-child(even) {
            background-color: #f1f3f4 !important;
        }

        /* Hover ainda funciona */
        #contasBancariasTable tbody tr:hover {
            background-color: rgba(13, 110, 253, 0.15) !important;
        }

        /* Altura das linhas - aumentada */
        #contasBancariasTable td,
        #contasBancariasTable th {
            padding: 1rem 0.75rem;
            vertical-align: middle;
        }

        #contasBancariasTable thead th {
            padding: 1.25rem 0.75rem;
            font-weight: 600;
        }

        /* DataTables customização */
        .dataTables_wrapper .dataTables_paginate .paginate_button.current {
            background: var(--phoenix-primary);
            color: white !important;
            border-color: var(--phoenix-primary);
        }

        /* Scrollbar duplo */
        .table-responsive {
            position: relative;
        }

        .table-scroll-top {
            overflow-x: auto;
            overflow-y: hidden;
            height: 20px;
            margin-bottom: 10px;
            border: 1px solid #dee2e6;
            border-radius: 0.375rem;
            background-color: #f8f9fa;
            transition: opacity 0.3s ease;
        }

        .table-scroll-top-inner {
            height: 18px;
            background: linear-gradient(90deg, #e9ecef 0%, #adb5bd 50%, #e9ecef 100%);
        }

        .dataTables_wrapper .dataTables_processing {
            background-color: rgba(255, 255, 255, 0.9);
            border: 1px solid #ddd;
            border-radius: 0.375rem;
            padding: 20px;
        }
    </style>
@endpush

@section('content')
<div class="content pt-3">
    <nav class="mb-3" aria-label="breadcrumb">
        <ol class="breadcrumb mb-0">
            <li class="breadcrumb-item"><a href="{{ route('dashboard') }}">Dashboard</a></li>
            <li class="breadcrumb-item active">Contas Bancárias</li>
        </ol>
    </nav>

    <div class="mb-9">
        <!-- Título e Botão Adicionar -->
        <div class="row align-items-center justify-content-between g-3 mb-4">
            <div class="col-auto">
                <h2 class="mb-0">Contas Bancárias</h2>
            </div>
            <div class="col-auto">
                <button type="button" class="btn btn-primary" onclick="window.location='{{ route('contas-bancarias.create') }}'">
                    <span class="fas fa-plus me-2"></span>Adicionar Conta Bancária
                </button>
            </div>
        </div>

        <!-- Card de Filtros -->
        <div class="card mb-4">
            <div class="card-header bg-body-tertiary">
                <h5 class="mb-0">Filtros</h5>
            </div>
            <div class="card-body">
                <form id="filterForm">
                    <!-- Primeira linha - Filtros principais -->
                    <div class="row g-3 mb-3">
                        <!-- Registros por página -->
                        <div class="col-md-2">
                            <label class="form-label small">Registros</label>
                            <select id="perPage" class="form-select form-select-sm">
                                <option value="10">10</option>
                                <option value="25">25</option>
                                <option value="50">50</option>
                                <option value="100" selected>100</option>
                            </select>
                        </div>
                    </div>

                    <!-- Segunda linha - Buscas -->
                    <div class="row g-3">
                        <!-- Busca primária -->
                        <div class="col-12 col-xl-6">
                            <label class="form-label small">Busca Principal</label>
                            <div class="row g-2">
                                <div class="col-12 col-md-8 mb-2 mb-md-0">
                                    <div class="position-relative">
                                        <input
                                            id="searchInput"
                                            class="form-control form-control-sm pe-5"
                                            type="search"
                                            name="q"
                                            placeholder="Buscar em todas as colunas"
                                        >
                                        <span class="fas fa-search position-absolute top-50 end-0 translate-middle-y me-3 text-muted"></span>
                                    </div>
                                </div>
                                <div class="col-12 col-md-4">
                                    <select name="search_field" id="searchField" class="form-select form-select-sm">
                                        <option value="">Todas as Colunas</option>
                                        <option value="empresa">Empresa</option>
                                        <option value="banco">Banco</option>
                                        <option value="agencia">Agência</option>
                                        <option value="conta_corrente">Conta Corrente</option>
                                        <option value="chave_pix">Chave PIX</option>
                                    </select>
                                </div>
                            </div>
                        </div>

                        <!-- Busca secundária -->
                        <div class="col-12 col-xl-6">
                            <label class="form-label small">Busca Secundária (opcional)</label>
                            <div class="row g-2">
                                <div class="col-12 col-md-8 mb-2 mb-md-0">
                                    <div class="position-relative">
                                        <input
                                            id="searchInput2"
                                            class="form-control form-control-sm pe-5"
                                            type="search"
                                            name="q2"
                                            placeholder="Segundo filtro (opcional)"
                                        >
                                        <span class="fas fa-search position-absolute top-50 end-0 translate-middle-y me-3 text-muted"></span>
                                    </div>
                                </div>
                                <div class="col-12 col-md-4">
                                    <select name="search_field2" id="searchField2" class="form-select form-select-sm">
                                        <option value="">Selecione</option>
                                        <option value="empresa">Empresa</option>
                                        <option value="banco">Banco</option>
                                        <option value="agencia">Agência</option>
                                        <option value="conta_corrente">Conta Corrente</option>
                                        <option value="chave_pix">Chave PIX</option>
                                    </select>
                                </div>
                            </div>
                        </div>
                    </div>

                    <!-- Botões de ação -->
                    <div class="row mt-3">
                        <div class="col-12 text-end">
                            <button type="button" id="btnLimparFiltros" class="btn btn-outline-secondary btn-sm">
                                <span class="fas fa-times me-1"></span>Limpar
                            </button>
                            <button type="button" id="btnAplicarFiltros" class="btn btn-primary btn-sm">
                                <span class="fas fa-search me-1"></span>Aplicar Filtros
                            </button>
                        </div>
                    </div>
                </form>
            </div>
        </div>

        <!-- Tabela -->
        <div class="card">
            <div class="card-body">
                <!-- Scrollbar superior -->
                <div class="table-scroll-top">
                    <div class="table-scroll-top-inner"></div>
                </div>

                <div class="table-responsive" id="tableContainer">
                    <table id="contasBancariasTable" class="table table-sm fs-9 mb-0">
                        <thead>
                            <tr>
                                <th>#</th>
                                <th>Empresa</th>
                                <th>Banco</th>
                                <th>Agência</th>
                                <th>Conta Corrente</th>
                                <th>Chave PIX</th>
                                <th>Ações</th>
                            </tr>
                        </thead>
                        <tbody>
                            <!-- Dados carregados via AJAX -->
                        </tbody>
                    </table>
                </div>
            </div>
        </div>
    </div>
</div>

<!-- Container para modais dinâmicos -->
<div id="modalContainer"></div>

<!-- Modal de Exclusão -->
<div class="modal fade" id="modalExclusao" tabindex="-1" aria-hidden="true">
    <div class="modal-dialog">
        <div class="modal-content">
            <div class="modal-header">
                <h5 class="modal-title">Confirmar Exclusão</h5>
                <button type="button" class="btn-close" data-bs-dismiss="modal"></button>
            </div>
            <div class="modal-body">
                Tem certeza que deseja excluir esta conta bancária?
            </div>
            <div class="modal-footer">
                <button type="button" class="btn btn-secondary" data-bs-dismiss="modal">Cancelar</button>
                <button type="button" class="btn btn-danger" id="btnConfirmarExclusao">Excluir</button>
            </div>
        </div>
    </div>
</div>

@endsection

@push('scripts-custom')
    <!-- DataTables JS -->
    <script src="https://cdn.datatables.net/1.13.6/js/jquery.dataTables.min.js"></script>
    <script src="https://cdn.datatables.net/1.13.6/js/dataTables.bootstrap5.min.js"></script>

    <!-- Choices e Select2 -->
    <script src="{{ asset('vendors/choices/choices.min.js') }}"></script>
    <script src="{{ asset('vendors/select2/js/select2.min.js') }}"></script>

    <script>
        // Função para capturar todos os parâmetros de filtro atuais
        function getFilterParams() {
            const params = new URLSearchParams(window.location.search);
            const filters = {};

            // Captura todos os parâmetros da URL
            for (const [key, value] of params) {
                filters[key] = value;
            }

            // Captura também os valores atuais dos filtros no formulário
            filters.search_field = $('#searchField').val() || '';
            filters.q = $('#searchInput').val() || '';
            filters.search_field2 = $('#searchField2').val() || '';
            filters.q2 = $('#searchInput2').val() || '';

            return filters;
        }

        // Função para adicionar campos hidden com os filtros em um formulário
        function addFilterFieldsToForm(form, filters) {
            for (const [key, value] of Object.entries(filters)) {
                if (value) {
                    const input = document.createElement('input');
                    input.type = 'hidden';
                    input.name = key;
                    input.value = value;
                    form.appendChild(input);
                }
            }
        }

        let contaIdParaExcluir = null;

        function abrirModalExclusao(contaId) {
            contaIdParaExcluir = contaId;
            const modal = new bootstrap.Modal(document.getElementById('modalExclusao'));
            modal.show();
        }

        document.getElementById('btnConfirmarExclusao').addEventListener('click', function() {
            if (contaIdParaExcluir) {
                const filters = getFilterParams();

                const form = document.createElement('form');
                form.method = 'POST';
                form.action = `/contas-bancarias/${contaIdParaExcluir}`;

                const csrfToken = document.createElement('input');
                csrfToken.type = 'hidden';
                csrfToken.name = '_token';
                csrfToken.value = '{{ csrf_token() }}';
                form.appendChild(csrfToken);

                const methodField = document.createElement('input');
                methodField.type = 'hidden';
                methodField.name = '_method';
                methodField.value = 'DELETE';
                form.appendChild(methodField);

                addFilterFieldsToForm(form, filters);

                document.body.appendChild(form);
                form.submit();
            }
        });

        // Função para restaurar filtros da URL ao carregar a página
        function restoreFiltersFromURL() {
            const params = new URLSearchParams(window.location.search);

            // Restaura cada filtro se existir na URL
            if (params.has('search_field')) $('#searchField').val(params.get('search_field'));
            if (params.has('q')) $('#searchInput').val(params.get('q'));
            if (params.has('search_field2')) $('#searchField2').val(params.get('search_field2'));
            if (params.has('q2')) $('#searchInput2').val(params.get('q2'));
        }

        let dataTable;

        $(document).ready(function() {
            // Inicializa DataTable
            initDataTable();

            // Configura event listeners
            setupEventListeners();

            // Atualiza placeholders
            updatePlaceholder();
            updatePlaceholder2();

            restoreFiltersFromURL();
        });

        function initDataTable() {
            dataTable = $('#contasBancariasTable').DataTable({
                processing: true,
                serverSide: true,
                ajax: {
                    url: '{{ route("contas-bancarias.index") }}',
                    type: 'GET',
                    data: function(d) {
                        // Adiciona todos os filtros
                        d.search_field = $('#searchField').val();
                        d.q = $('#searchInput').val();
                        d.search_field2 = $('#searchField2').val();
                        d.q2 = $('#searchInput2').val();
                    }
                },
                columns: [
                    { data: 'id', name: 'id' },
                    { data: 'empresa', name: 'empresa' },
                    { data: 'banco', name: 'banco' },
                    { data: 'agencia', name: 'agencia' },
                    { data: 'conta_corrente', name: 'conta_corrente' },
                    { data: 'chave_pix', name: 'chave_pix' },
                    { data: 'acoes', name: 'acoes', orderable: false, searchable: false }
                ],
                pageLength: 100,
                lengthMenu: [[10, 25, 50, 100], [10, 25, 50, 100]],
                order: [[0, 'asc']], // Ordena por ID 
                language: {
                    url: '//cdn.datatables.net/plug-ins/1.13.6/i18n/pt-BR.json'
                },
                dom: '<"d-none"lf>rt<"d-flex justify-content-between align-items-center mt-3"<"dataTables_info"i><"dataTables_paginate"p>>',
                drawCallback: function(settings) {
                    // Reinicializa tooltips
                    $('[data-bs-toggle="tooltip"]').tooltip();
                    
                    // As cores zebradas são aplicadas via CSS, não precisamos de JavaScript aqui
                }
            });

                // Debug melhorado
                dataTable.on('error.dt', function(e, settings, techNote, message) {
                    console.error('DataTable Error:', {
                        message: message,
                        techNote: techNote,
                        settings: settings
                    });
                    
                    // Fazer uma requisição manual para ver o erro real
                    $.ajax({
                        url: '{{ route("contas-bancarias.index") }}',
                        data: { 
                            _token: '{{ csrf_token() }}',
                            draw: 1,
                            start: 0,
                            length: 10
                        },
                        headers: {
                            'X-Requested-With': 'XMLHttpRequest'
                        }
                    }).fail(function(xhr, status, error) {
                        console.error('Erro AJAX manual:', {
                            status: xhr.status,
                            statusText: xhr.statusText,
                            responseText: xhr.responseText,
                            error: error
                        });
                    });
                });

                // Sincroniza select de registros por página
                $('#perPage').on('change', function() {
                    dataTable.page.len($(this).val()).draw();
                });
            }

        function setupEventListeners() {
            // Aplicar filtros
            $('#btnAplicarFiltros').on('click', function() {
                dataTable.ajax.reload();
            });

            // Limpar filtros
            $('#btnLimparFiltros').on('click', function() {
                $('#filterForm')[0].reset();
                updatePlaceholder();
                updatePlaceholder2();
                dataTable.ajax.reload();
            });

            // Mudança nos campos de busca
            $('#searchField, #searchField2').on('change', function() {
                updatePlaceholder();
                updatePlaceholder2();
                dataTable.ajax.reload();
            });

            // Aplicar filtro ao pressionar Enter nos campos de busca
            $('#searchInput, #searchInput2').on('keypress', function(e) {
                if (e.which === 13) {
                    e.preventDefault();
                    dataTable.ajax.reload();
                }
            });
        }

        // Sincronizar scrollbars horizontal
        function setupDualScrollbar() {
            const tableContainer = document.getElementById('tableContainer');
            const scrollTop = document.querySelector('.table-scroll-top');
            const scrollTopInner = document.querySelector('.table-scroll-top-inner');

            if (!tableContainer || !scrollTop || !scrollTopInner) return;

            // Função para atualizar largura
            function updateScrollWidth() {
                const table = tableContainer.querySelector('table');
                if (table) {
                    const tableWidth = table.offsetWidth;
                    scrollTopInner.style.width = tableWidth + 'px';
                }

                // Sempre mostrar a barra de rolagem superior
                scrollTop.style.display = 'block';
                
                // Se não há overflow, ocultar apenas visualmente mas manter a estrutura
                if (tableContainer.scrollWidth <= tableContainer.clientWidth) {
                    scrollTop.style.opacity = '0.3';
                } else {
                    scrollTop.style.opacity = '1';
                }
            }

            // Sincronizar scroll
            scrollTop.addEventListener('scroll', function() {
                tableContainer.scrollLeft = this.scrollLeft;
            });

            tableContainer.addEventListener('scroll', function() {
                scrollTop.scrollLeft = this.scrollLeft;
            });

            // Atualizar largura quando a tabela for redesenhada
            dataTable.on('draw.dt', updateScrollWidth);

            // Atualizar largura quando a janela for redimensionizada
            window.addEventListener('resize', updateScrollWidth);

            // Chamada inicial e periodicamente para garantir que funcione
            setTimeout(updateScrollWidth, 100);
            setTimeout(updateScrollWidth, 500);
            setTimeout(updateScrollWidth, 1000);
        }
        // Chamar após inicializar o DataTable
        setTimeout(setupDualScrollbar, 100);

        // Funções de placeholder
        function updatePlaceholder() {
            const field = $('#searchField').val();
            const input = $('#searchInput');
            if (!field) {
                input.attr('placeholder', 'Buscar em todas as colunas');
            } else {
                const label = field.replace('_', ' ').replace(/\b\w/g, l => l.toUpperCase());
                input.attr('placeholder', 'Buscar por ' + label);
            }
        }

        function updatePlaceholder2() {
            const field = $('#searchField2').val();
            const input = $('#searchInput2');
            if (!field) {
                input.attr('placeholder', 'Segundo filtro (opcional)');
            } else {
                const label = field.replace('_', ' ').replace(/\b\w/g, l => l.toUpperCase());
                input.attr('placeholder', 'Buscar por ' + label);
            }
        }
    </script>
@endpush