@extends('layouts.app')

@section('title', 'Conciliación Bancaria Interactiva')

@section('content')
<div class="container-fluid py-4">
    <!-- Header -->
    <div class="d-flex justify-content-between align-items-center mb-4">
        <div>
            <h1 class="h3 mb-0 text-gradient-primary">
                <i class="fas fa-exchange-alt me-2"></i>Conciliación Bancaria Interactiva
            </h1>
            <p class="text-muted mb-0">{{ $bankAccount->bank->name ?? 'Banco' }} - {{ $bankAccount->account_number }}</p>
        </div>
        <div>
            <a href="{{ route('admin.bank.reconciliations.index') }}" class="btn btn-secondary">
                <i class="fas fa-arrow-left me-1"></i>Volver
            </a>
        </div>
    </div>

    <!-- Mensajes -->
    @if(session('success'))
        <div class="alert alert-success alert-dismissible fade show" role="alert">
            <i class="fas fa-check-circle me-2"></i>{{ session('success') }}
            <button type="button" class="btn-close" data-bs-dismiss="alert"></button>
        </div>
    @endif

    @if(session('error'))
        <div class="alert alert-danger alert-dismissible fade show" role="alert">
            <i class="fas fa-exclamation-circle me-2"></i>{{ session('error') }}
            <button type="button" class="btn-close" data-bs-dismiss="alert"></button>
        </div>
    @endif

    <!-- Panel de Filtros y Acciones -->
    <div class="card mb-4">
        <div class="card-body">
            <div class="row g-3">
                <div class="col-md-3">
                    <label class="form-label">Fecha Desde</label>
                    <input type="date" id="date_from" class="form-control" value="{{ now()->subDays(30)->format('Y-m-d') }}">
                </div>
                <div class="col-md-3">
                    <label class="form-label">Fecha Hasta</label>
                    <input type="date" id="date_to" class="form-control" value="{{ now()->format('Y-m-d') }}">
                </div>
                <div class="col-md-3 d-flex align-items-end">
                    <button type="button" id="btn-filter" class="btn btn-primary w-100">
                        <i class="fas fa-filter me-1"></i>Filtrar
                    </button>
                </div>
                <div class="col-md-3 d-flex align-items-end gap-2">
                    <button type="button" id="btn-auto-match" class="btn btn-success flex-fill">
                        <i class="fas fa-magic me-1"></i>Conciliar Automático
                    </button>
                    <button type="button" id="btn-manual-match" class="btn btn-info flex-fill" disabled>
                        <i class="fas fa-hand-pointer me-1"></i>Conciliar Manual
                    </button>
                </div>
            </div>
            <hr>
            <div class="row">
                <div class="col-md-6">
                    <form action="{{ route('admin.bank.reconciliations.import') }}" method="POST" enctype="multipart/form-data" id="import-form">
                        @csrf
                        <input type="hidden" name="bank_account_id" value="{{ $bankAccount->id }}">
                        <div class="input-group">
                            <input type="file" name="statement_file" class="form-control" accept=".csv,.xls,.xlsx" required>
                            <button type="submit" class="btn btn-outline-primary">
                                <i class="fas fa-upload me-1"></i>Importar Estado de Cuenta
                            </button>
                        </div>
                        <small class="text-muted">Formatos soportados: CSV, XLS, XLSX</small>
                    </form>
                </div>
                <div class="col-md-6 text-end d-flex align-items-center justify-content-end">
                    <a href="{{ route('admin.bank.reconciliations.download-template') }}" class="btn btn-outline-secondary">
                        <i class="fas fa-download me-1"></i>Descargar Plantilla CSV
                    </a>
                </div>
            </div>
        </div>
    </div>

    <!-- Split Screen: Banco vs Sistema -->
    <div class="row g-4">
        <!-- Columna Izquierda: Transacciones del Banco -->
        <div class="col-md-6">
            <div class="card h-100">
                <div class="card-header bg-primary text-white">
                    <h5 class="mb-0">
                        <i class="fas fa-university me-2"></i>Transacciones del Banco
                        <span class="badge bg-light text-dark ms-2" id="bank-count">0</span>
                    </h5>
                </div>
                <div class="card-body p-0">
                    <div class="table-responsive" style="max-height: 600px; overflow-y: auto;">
                        <table class="table table-hover table-striped mb-0" id="bank-transactions-table">
                            <thead class="table-light sticky-top">
                                <tr>
                                    <th width="40">
                                        <input type="checkbox" id="select-all-bank">
                                    </th>
                                    <th>Fecha</th>
                                    <th>Referencia</th>
                                    <th>Descripción</th>
                                    <th class="text-end">Monto</th>
                                    <th>Tipo</th>
                                </tr>
                            </thead>
                            <tbody id="bank-transactions-body">
                                <tr>
                                    <td colspan="6" class="text-center text-muted py-4">
                                        <i class="fas fa-spinner fa-spin me-2"></i>Cargando transacciones...
                                    </td>
                                </tr>
                            </tbody>
                        </table>
                    </div>
                </div>
            </div>
        </div>

        <!-- Columna Derecha: Transacciones del Sistema -->
        <div class="col-md-6">
            <div class="card h-100">
                <div class="card-header bg-success text-white">
                    <h5 class="mb-0">
                        <i class="fas fa-calculator me-2"></i>Transacciones del Sistema
                        <span class="badge bg-light text-dark ms-2" id="system-count">0</span>
                    </h5>
                </div>
                <div class="card-body p-0">
                    <div class="table-responsive" style="max-height: 600px; overflow-y: auto;">
                        <table class="table table-hover table-striped mb-0" id="system-transactions-table">
                            <thead class="table-light sticky-top">
                                <tr>
                                    <th width="40">
                                        <input type="checkbox" id="select-all-system">
                                    </th>
                                    <th>Fecha</th>
                                    <th>Referencia</th>
                                    <th>Descripción</th>
                                    <th class="text-end">Monto</th>
                                    <th>Tipo</th>
                                </tr>
                            </thead>
                            <tbody id="system-transactions-body">
                                <tr>
                                    <td colspan="6" class="text-center text-muted py-4">
                                        <i class="fas fa-spinner fa-spin me-2"></i>Cargando transacciones...
                                    </td>
                                </tr>
                            </tbody>
                        </table>
                    </div>
                </div>
            </div>
        </div>
    </div>
</div>

<!-- Modal para Crear Ajuste -->
<div class="modal fade" id="adjustmentModal" tabindex="-1">
    <div class="modal-dialog">
        <div class="modal-content">
            <div class="modal-header">
                <h5 class="modal-title">Crear Ajuste Contable</h5>
                <button type="button" class="btn-close" data-bs-dismiss="modal"></button>
            </div>
            <form id="adjustment-form">
                @csrf
                <div class="modal-body">
                    <input type="hidden" id="adjustment-bank-transaction-id">
                    <div class="mb-3">
                        <label class="form-label">Cuenta Contable</label>
                        <select class="form-select" id="adjustment-chart-of-account-id" required>
                            <option value="">Seleccione una cuenta...</option>
                            @foreach(\App\Models\ChartOfAccount::where('type', 'expense')->where('is_active', true)->get() as $account)
                                <option value="{{ $account->id }}">{{ $account->code }} - {{ $account->name }}</option>
                            @endforeach
                        </select>
                    </div>
                    <div class="mb-3">
                        <label class="form-label">Notas</label>
                        <textarea class="form-control" id="adjustment-notes" rows="3"></textarea>
                    </div>
                </div>
                <div class="modal-footer">
                    <button type="button" class="btn btn-secondary" data-bs-dismiss="modal">Cancelar</button>
                    <button type="submit" class="btn btn-primary">Crear Ajuste</button>
                </div>
            </form>
        </div>
    </div>
</div>
@endsection

@push('styles')
<style>
    .transaction-selected {
        background-color: #e7f3ff !important;
        border-left: 4px solid #0d6efd;
    }
    .table tbody tr {
        cursor: pointer;
    }
    .table tbody tr:hover {
        background-color: #f8f9fa;
    }
    .sticky-top {
        position: sticky;
        top: 0;
        z-index: 10;
    }
    .badge-receivable {
        background-color: #198754;
    }
    .badge-payable {
        background-color: #dc3545;
    }
</style>
@endpush

@push('scripts')
<script>
const BANK_ACCOUNT_ID = {{ $bankAccount->id }};
let selectedBankTransaction = null;
let selectedSystemTransaction = null;

$(document).ready(function() {
    // Cargar transacciones iniciales
    loadBankTransactions();
    loadSystemTransactions();

    // Filtro
    $('#btn-filter').on('click', function() {
        loadBankTransactions();
        loadSystemTransactions();
    });

    // Selección de transacciones del banco
    $(document).on('change', '.bank-transaction-checkbox', function() {
        const row = $(this).closest('tr');
        const id = $(this).data('id');
        
        $('.bank-transaction-checkbox').not(this).prop('checked', false);
        $('#bank-transactions-table tbody tr').removeClass('transaction-selected');
        
        if ($(this).is(':checked')) {
            selectedBankTransaction = id;
            row.addClass('transaction-selected');
            checkManualMatchButton();
        } else {
            selectedBankTransaction = null;
            checkManualMatchButton();
        }
    });

    // Selección de transacciones del sistema
    $(document).on('change', '.system-transaction-checkbox', function() {
        const row = $(this).closest('tr');
        const id = $(this).data('id');
        const type = $(this).data('type');
        
        $('.system-transaction-checkbox').not(this).prop('checked', false);
        $('#system-transactions-table tbody tr').removeClass('transaction-selected');
        
        if ($(this).is(':checked')) {
            selectedSystemTransaction = { id: id, type: type };
            row.addClass('transaction-selected');
            checkManualMatchButton();
        } else {
            selectedSystemTransaction = null;
            checkManualMatchButton();
        }
    });

    // Select all checkboxes
    $('#select-all-bank').on('change', function() {
        $('.bank-transaction-checkbox').prop('checked', $(this).is(':checked'));
    });

    $('#select-all-system').on('change', function() {
        $('.system-transaction-checkbox').prop('checked', $(this).is(':checked'));
    });

    // Conciliación automática
    $('#btn-auto-match').on('click', function() {
        if (!confirm('¿Desea conciliar automáticamente todas las transacciones posibles?')) {
            return;
        }

        const btn = $(this);
        btn.prop('disabled', true).html('<i class="fas fa-spinner fa-spin me-1"></i>Procesando...');

        $.ajax({
            url: `/admin/bank/reconciliations/api/auto-match/${BANK_ACCOUNT_ID}`,
            method: 'POST',
            data: {
                _token: '{{ csrf_token() }}',
                date_from: $('#date_from').val(),
                date_to: $('#date_to').val()
            },
            success: function(response) {
                if (response.success) {
                    alert(response.message);
                    loadBankTransactions();
                    loadSystemTransactions();
                } else {
                    alert('Error: ' + response.message);
                }
            },
            error: function(xhr) {
                alert('Error al procesar la conciliación automática.');
            },
            complete: function() {
                btn.prop('disabled', false).html('<i class="fas fa-magic me-1"></i>Conciliar Automático');
            }
        });
    });

    // Conciliación manual
    $('#btn-manual-match').on('click', function() {
        if (!selectedBankTransaction || !selectedSystemTransaction) {
            alert('Por favor seleccione una transacción de cada columna.');
            return;
        }

        if (!confirm('¿Confirma la conciliación manual de estas transacciones?')) {
            return;
        }

        const btn = $(this);
        btn.prop('disabled', true).html('<i class="fas fa-spinner fa-spin me-1"></i>Procesando...');

        $.ajax({
            url: '/admin/bank/reconciliations/api/manual-match',
            method: 'POST',
            data: {
                _token: '{{ csrf_token() }}',
                bank_transaction_id: selectedBankTransaction,
                payment_id: selectedSystemTransaction.id,
                payment_type: selectedSystemTransaction.type
            },
            success: function(response) {
                if (response.success) {
                    alert(response.message);
                    selectedBankTransaction = null;
                    selectedSystemTransaction = null;
                    $('.bank-transaction-checkbox, .system-transaction-checkbox').prop('checked', false);
                    $('#bank-transactions-table tbody tr, #system-transactions-table tbody tr').removeClass('transaction-selected');
                    checkManualMatchButton();
                    loadBankTransactions();
                    loadSystemTransactions();
                } else {
                    alert('Error: ' + response.message);
                }
            },
            error: function(xhr) {
                const response = xhr.responseJSON;
                alert('Error: ' + (response?.message || 'Error al procesar la conciliación manual.'));
            },
            complete: function() {
                btn.prop('disabled', false).html('<i class="fas fa-hand-pointer me-1"></i>Conciliar Manual');
            }
        });
    });

    // Crear ajuste (doble clic en transacción del banco)
    $(document).on('dblclick', '#bank-transactions-table tbody tr', function() {
        const id = $(this).find('.bank-transaction-checkbox').data('id');
        if (id) {
            $('#adjustment-bank-transaction-id').val(id);
            $('#adjustmentModal').modal('show');
        }
    });

    // Formulario de ajuste
    $('#adjustment-form').on('submit', function(e) {
        e.preventDefault();
        
        $.ajax({
            url: '/admin/bank/reconciliations/api/create-adjustment',
            method: 'POST',
            data: {
                _token: '{{ csrf_token() }}',
                bank_transaction_id: $('#adjustment-bank-transaction-id').val(),
                chart_of_account_id: $('#adjustment-chart-of-account-id').val(),
                notes: $('#adjustment-notes').val()
            },
            success: function(response) {
                if (response.success) {
                    alert(response.message);
                    $('#adjustmentModal').modal('hide');
                    $('#adjustment-form')[0].reset();
                    loadBankTransactions();
                } else {
                    alert('Error: ' + response.message);
                }
            },
            error: function(xhr) {
                const response = xhr.responseJSON;
                alert('Error: ' + (response?.message || 'Error al crear el ajuste.'));
            }
        });
    });

    // Formulario de importación
    $('#import-form').on('submit', function(e) {
        const btn = $(this).find('button[type="submit"]');
        btn.prop('disabled', true).html('<i class="fas fa-spinner fa-spin me-1"></i>Subiendo...');
    });
});

function checkManualMatchButton() {
    const btn = $('#btn-manual-match');
    if (selectedBankTransaction && selectedSystemTransaction) {
        btn.prop('disabled', false);
    } else {
        btn.prop('disabled', true);
    }
}

function loadBankTransactions() {
    const tbody = $('#bank-transactions-body');
    tbody.html('<tr><td colspan="6" class="text-center text-muted py-4"><i class="fas fa-spinner fa-spin me-2"></i>Cargando...</td></tr>');

    $.ajax({
        url: `/admin/bank/reconciliations/api/bank-transactions/${BANK_ACCOUNT_ID}`,
        method: 'GET',
        data: {
            date_from: $('#date_from').val(),
            date_to: $('#date_to').val()
        },
        success: function(response) {
            if (response.success) {
                const transactions = response.data;
                $('#bank-count').text(transactions.length);

                if (transactions.length === 0) {
                    tbody.html('<tr><td colspan="6" class="text-center text-muted py-4">No hay transacciones del banco pendientes de conciliar.</td></tr>');
                    return;
                }

                let html = '';
                transactions.forEach(function(txn) {
                    const amountClass = txn.type === 'deposit' ? 'text-success' : 'text-danger';
                    const amountSign = txn.type === 'deposit' ? '+' : '-';
                    html += `
                        <tr>
                            <td>
                                <input type="checkbox" class="bank-transaction-checkbox" data-id="${txn.id}">
                            </td>
                            <td>${txn.date}</td>
                            <td>${txn.reference || '-'}</td>
                            <td>${txn.description}</td>
                            <td class="text-end ${amountClass}">${amountSign} ${formatCurrency(txn.amount)}</td>
                            <td><span class="badge bg-secondary">${txn.type_text}</span></td>
                        </tr>
                    `;
                });
                tbody.html(html);
            }
        },
        error: function() {
            tbody.html('<tr><td colspan="6" class="text-center text-danger py-4">Error al cargar las transacciones del banco.</td></tr>');
        }
    });
}

function loadSystemTransactions() {
    const tbody = $('#system-transactions-body');
    tbody.html('<tr><td colspan="6" class="text-center text-muted py-4"><i class="fas fa-spinner fa-spin me-2"></i>Cargando...</td></tr>');

    $.ajax({
        url: `/admin/bank/reconciliations/api/system-transactions/${BANK_ACCOUNT_ID}`,
        method: 'GET',
        data: {
            date_from: $('#date_from').val(),
            date_to: $('#date_to').val()
        },
        success: function(response) {
            if (response.success) {
                const transactions = response.data;
                $('#system-count').text(transactions.length);

                if (transactions.length === 0) {
                    tbody.html('<tr><td colspan="6" class="text-center text-muted py-4">No hay transacciones del sistema pendientes de conciliar.</td></tr>');
                    return;
                }

                let html = '';
                transactions.forEach(function(txn) {
                    const badgeClass = txn.type === 'receivable' ? 'badge-receivable' : 'badge-payable';
                    const typeText = txn.type === 'receivable' ? 'Cobro' : 'Pago';
                    html += `
                        <tr>
                            <td>
                                <input type="checkbox" class="system-transaction-checkbox" data-id="${txn.id}" data-type="${txn.type}">
                            </td>
                            <td>${txn.date}</td>
                            <td>${txn.reference || '-'}</td>
                            <td>${txn.description}</td>
                            <td class="text-end">${formatCurrency(txn.amount_local)} ${txn.currency}</td>
                            <td><span class="badge ${badgeClass}">${typeText}</span></td>
                        </tr>
                    `;
                });
                tbody.html(html);
            }
        },
        error: function() {
            tbody.html('<tr><td colspan="6" class="text-center text-danger py-4">Error al cargar las transacciones del sistema.</td></tr>');
        }
    });
}

function formatCurrency(amount) {
    return new Intl.NumberFormat('es-VE', {
        minimumFractionDigits: 2,
        maximumFractionDigits: 2
    }).format(amount);
}
</script>
@endpush