@extends('layouts.app')

@section('title', 'Mayor General')

@section('content')
<div class="container-fluid">
    <div class="row">
        <div class="col-12">
            <div class="card">
                <div class="card-header bg-warning text-dark d-flex justify-content-between align-items-center">
                    <h4 class="mb-0">
                        <i class="fas fa-book"></i> Mayor General
                    </h4>
                    <div>
                        <button onclick="window.print()" class="btn btn-dark btn-sm">
                            <i class="fas fa-print"></i> Imprimir
                        </button>
                        <a href="{{ route('admin.accounting.dashboard') }}" class="btn btn-dark btn-sm">
                            <i class="fas fa-arrow-left"></i> Volver
                        </a>
                    </div>
                </div>
                <div class="card-body">
                    <!-- Filtros -->
                    <div class="card mb-4">
                        <div class="card-header bg-light d-flex justify-content-between align-items-center">
                            <h6 class="mb-0">
                                <i class="fas fa-filter me-2"></i>Filtros
                            </h6>
                            <div>
                                @if(auth()->check())
                                    <select id="savedFilters" class="form-select form-select-sm d-inline-block" style="width: auto;">
                                        <option value="">Filtros Guardados</option>
                                    </select>
                                    <button type="button" class="btn btn-sm btn-info" data-bs-toggle="modal" data-bs-target="#saveFilterModal">
                                        <i class="fas fa-save me-1"></i>Guardar Filtros
                                    </button>
                                @endif
                            </div>
                        </div>
                        <div class="card-body">
                            <form method="GET" action="{{ route('admin.accounting.reports.general-ledger') }}" id="filterForm">
                                <div class="row g-3">
                                    <div class="col-md-3">
                                        <label for="period_id" class="form-label">Período Contable</label>
                                        <select name="period_id" id="period_id" class="form-select">
                                            <option value="">Período Actual</option>
                                            @foreach($periods as $p)
                                                <option value="{{ $p->id }}" {{ $period && $period->id == $p->id ? 'selected' : '' }}>
                                                    {{ $p->name }}
                                                </option>
                                            @endforeach
                                        </select>
                                    </div>
                                    <div class="col-md-3">
                                        <label for="account_id" class="form-label">Cuenta</label>
                                        <select name="account_id" id="account_id" class="form-select">
                                            <option value="">Todas las cuentas</option>
                                            @foreach($accounts as $acc)
                                                <option value="{{ $acc->id }}" {{ $accountId == $acc->id ? 'selected' : '' }}>
                                                    {{ $acc->code }} - {{ $acc->name }}
                                                </option>
                                            @endforeach
                                        </select>
                                    </div>
                                    <div class="col-md-2">
                                        <label for="date_from" class="form-label">Fecha Desde</label>
                                        <input type="date" name="date_from" id="date_from" class="form-control" value="{{ $dateFrom }}">
                                    </div>
                                    <div class="col-md-2">
                                        <label for="date_to" class="form-label">Fecha Hasta</label>
                                        <input type="date" name="date_to" id="date_to" class="form-control" value="{{ $dateTo }}">
                                    </div>
                                    <div class="col-md-2">
                                        <label class="form-label">&nbsp;</label>
                                        <div>
                                            <button type="submit" class="btn btn-warning w-100">
                                                <i class="fas fa-search"></i> Generar
                                            </button>
                                        </div>
                                    </div>
                                    <div class="col-12">
                                        <label for="search" class="form-label">Búsqueda Avanzada</label>
                                        <input type="text" class="form-control" id="search" name="search" 
                                               value="{{ request('search') }}" 
                                               placeholder="Buscar por número de asiento, cuenta, descripción, referencia...">
                                        <small class="text-muted">Busca en número de asiento, código/nombre de cuenta, descripción o referencia</small>
                                    </div>
                                </div>
                            </form>
                        </div>
                    </div>

                    <!-- Mayor General -->
                    @if($entries->count() > 0)
                        @foreach($entries as $accountId => $accountEntries)
                            @php
                                $account = $accountEntries->first()->account;
                                $totalDebits = $accountEntries->sum('debit_amount');
                                $totalCredits = $accountEntries->sum('credit_amount');
                                $balance = $totalDebits - $totalCredits;
                            @endphp
                            <div class="card mb-4">
                                <div class="card-header bg-light">
                                    <h5 class="mb-0">
                                        {{ $account->code }} - {{ $account->name }}
                                    </h5>
                                </div>
                                <div class="card-body">
                                    <div class="table-responsive">
                                        <table class="table table-sm table-bordered">
                                            <thead class="table-dark">
                                                <tr>
                                                    <th>Fecha</th>
                                                    <th>Asiento</th>
                                                    <th>Descripción</th>
                                                    <th>Referencia</th>
                                                    <th class="text-end">Débito</th>
                                                    <th class="text-end">Crédito</th>
                                                    <th class="text-end">Saldo</th>
                                                </tr>
                                            </thead>
                                            <tbody>
                                                @php
                                                    $runningBalance = 0;
                                                @endphp
                                                @foreach($accountEntries as $entry)
                                                    @php
                                                        $runningBalance += $entry->debit_amount - $entry->credit_amount;
                                                    @endphp
                                                    <tr>
                                                        <td>{{ $entry->journalEntry->entry_date->format('d/m/Y') }}</td>
                                                        <td>{{ $entry->journalEntry->entry_number }}</td>
                                                        <td>{{ $entry->description }}</td>
                                                        <td>{{ $entry->reference ?? '-' }}</td>
                                                        <td class="text-end">
                                                            @if($entry->debit_amount > 0)
                                                                ${{ number_format($entry->debit_amount, 2) }}
                                                            @else
                                                                -
                                                            @endif
                                                        </td>
                                                        <td class="text-end">
                                                            @if($entry->credit_amount > 0)
                                                                ${{ number_format($entry->credit_amount, 2) }}
                                                            @else
                                                                -
                                                            @endif
                                                        </td>
                                                        <td class="text-end">
                                                            <strong>${{ number_format($runningBalance, 2) }}</strong>
                                                        </td>
                                                    </tr>
                                                @endforeach
                                            </tbody>
                                            <tfoot class="table-dark">
                                                <tr>
                                                    <th colspan="4" class="text-end">TOTALES</th>
                                                    <th class="text-end">${{ number_format($totalDebits, 2) }}</th>
                                                    <th class="text-end">${{ number_format($totalCredits, 2) }}</th>
                                                    <th class="text-end">${{ number_format($balance, 2) }}</th>
                                                </tr>
                                            </tfoot>
                                        </table>
                                    </div>
                                </div>
                            </div>
                        @endforeach
                    @else
                        <div class="alert alert-info">
                            <i class="fas fa-info-circle"></i> No hay movimientos para los filtros seleccionados.
                        </div>
                    @endif
                </div>
            </div>
        </div>
    </div>
</div>

<!-- Modal para guardar filtros -->
@if(auth()->check())
<div class="modal fade" id="saveFilterModal" tabindex="-1">
    <div class="modal-dialog">
        <div class="modal-content">
            <div class="modal-header">
                <h5 class="modal-title">Guardar Filtros</h5>
                <button type="button" class="btn-close" data-bs-dismiss="modal"></button>
            </div>
            <form id="saveFilterForm">
                @csrf
                <div class="modal-body">
                    <input type="hidden" name="report_type" value="general-ledger">
                    <div class="mb-3">
                        <label for="filter_name" class="form-label">Nombre del Filtro</label>
                        <input type="text" class="form-control" id="filter_name" name="name" required>
                    </div>
                    <div class="mb-3">
                        <label for="filter_description" class="form-label">Descripción (opcional)</label>
                        <textarea class="form-control" id="filter_description" name="description" rows="2"></textarea>
                    </div>
                    <div class="form-check">
                        <input class="form-check-input" type="checkbox" id="is_default" name="is_default" value="1">
                        <label class="form-check-label" for="is_default">
                            Establecer como predeterminado
                        </label>
                    </div>
                    <div class="form-check">
                        <input class="form-check-input" type="checkbox" id="is_shared" name="is_shared" value="1">
                        <label class="form-check-label" for="is_shared">
                            Compartir con otros usuarios
                        </label>
                    </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">Guardar</button>
                </div>
            </form>
        </div>
    </div>
</div>
@endif

@push('scripts')
<script>
    $(document).ready(function() {
        const reportType = 'general-ledger';
        const filterForm = $('#filterForm');
        const savedFiltersSelect = $('#savedFilters');
        const currentUserId = {{ auth()->id() ?? 0 }};

        // Cargar filtros guardados
        function loadSavedFilters() {
            fetch(`{{ url('admin/saved-report-filters') }}?report_type=${reportType}`, {
                headers: {
                    'X-Requested-With': 'XMLHttpRequest',
                    'Accept': 'application/json',
                }
            })
            .then(response => response.json())
            .then(data => {
                savedFiltersSelect.empty();
                savedFiltersSelect.append('<option value="">Filtros Guardados</option>');
                
                if (data.filters && data.filters.length > 0) {
                    data.filters.forEach(filter => {
                        const option = $('<option>')
                            .val(filter.id)
                            .text(filter.name + (filter.is_default ? ' (Predeterminado)' : '') + (filter.is_shared ? ' [Compartido]' : ''));
                        savedFiltersSelect.append(option);
                    });
                } else {
                    savedFiltersSelect.append('<option value="">No hay filtros guardados</option>');
                }
            })
            .catch(error => {
                console.error('Error al cargar filtros:', error);
            });
        }

        // Aplicar filtro guardado
        savedFiltersSelect.on('change', function() {
            const filterId = $(this).val();
            if (filterId) {
                applyFilter(filterId);
            }
        });

        function applyFilter(filterId) {
            fetch(`{{ url('admin/saved-report-filters') }}/${filterId}/apply`, {
                headers: {
                    'X-Requested-With': 'XMLHttpRequest',
                    'Accept': 'application/json',
                }
            })
            .then(response => response.json())
            .then(data => {
                if (data.success && data.filters) {
                    Object.keys(data.filters).forEach(key => {
                        const field = filterForm.find(`[name="${key}"]`);
                        if (field.length) {
                            if (field.attr('type') === 'checkbox') {
                                field.prop('checked', data.filters[key]);
                            } else {
                                field.val(data.filters[key] || '');
                            }
                        }
                    });
                    filterForm.submit();
                }
            })
            .catch(error => {
                console.error('Error al aplicar filtro:', error);
                alert('Error al aplicar el filtro');
            });
        }

        // Guardar filtro
        $('#saveFilterForm').on('submit', function(e) {
            e.preventDefault();
            
            const formData = new FormData(this);
            const filters = {};
            
            // Recopilar todos los valores del formulario de filtros
            filterForm.find('input, select, textarea').each(function() {
                const field = $(this);
                const name = field.attr('name');
                if (name && name !== '_token') {
                    if (field.attr('type') === 'checkbox') {
                        if (field.is(':checked')) filters[name] = true;
                    } else if (field.val()) {
                        filters[name] = field.val();
                    }
                }
            });
            
            formData.append('filters', JSON.stringify(filters));
            formData.append('report_type', reportType);
            
            fetch('{{ route("admin.saved-report-filters.store") }}', {
                method: 'POST',
                headers: {
                    'X-Requested-With': 'XMLHttpRequest',
                    'X-CSRF-TOKEN': $('meta[name="csrf-token"]').attr('content'),
                    'Accept': 'application/json',
                },
                body: formData
            })
            .then(response => response.json())
            .then(data => {
                if (data.success) {
                    alert('Filtro guardado exitosamente');
                    $('#saveFilterModal').modal('hide');
                    $('#saveFilterForm')[0].reset();
                    loadSavedFilters();
                } else {
                    alert(data.message || 'Error al guardar el filtro');
                }
            })
            .catch(error => {
                console.error('Error al guardar filtro:', error);
                alert('Error al guardar el filtro');
            });
        });

        // Cargar filtros al iniciar
        @if(auth()->check())
        loadSavedFilters();
        @endif
    });
</script>
@endpush
@endsection