@extends('admin.layout')

@section('title', __('Liste des fichiers Excel'))

@section('content')
<div class="row">
    <div class="col-12">
        <!-- En-tête -->
        <div class="d-flex justify-content-between align-items-center mb-4">
            <div>
                <h1 class="h3 mb-1" style="font-weight: 400;">
                    <i class="bi bi-file-earmark-spreadsheet text-primary me-2"></i>
                    {{ __('Liste des Fichiers Excel') }}
                </h1>
                <p class="text-muted mb-0" style="font-size: 0.9rem;">{{ __('Gérez vos fichiers Excel et leurs colonnes') }}</p>
            </div>
            <button type="button" class="btn btn-primary btn-sm" style="font-weight: 300; font-family: 'Ubuntu', sans-serif;" data-bs-toggle="modal" data-bs-target="#uploadModal">
                <i class="bi bi-plus-circle me-2"></i>
                {{ __('Nouveau Fichier') }}
            </button>
        </div>

        @if($excelFiles->isEmpty())
            <div class="card border-0 shadow text-center" style="border-radius: 8px;">
                <div class="card-body p-5">
                    <i class="bi bi-inbox text-muted" style="font-size: 3rem;"></i>
                    <p class="text-muted mt-3 mb-0" style="font-size: 1rem; font-weight: 300;">{{ __('Aucun fichier Excel disponible.') }}</p>
                    <button type="button" class="btn btn-primary btn-sm mt-3" style="font-weight: 300; font-family: 'Ubuntu', sans-serif;" data-bs-toggle="modal" data-bs-target="#uploadModal">
                        <i class="bi bi-upload me-2"></i>{{ __('Charger le premier fichier') }}
                    </button>
                </div>
            </div>
        @else
            <div class="card border-0 shadow" style="border-radius: 8px;">
                <div class="card-body p-0">
                    <div class="p-3 border-bottom">
                        <div class="input-group input-group-sm" style="max-width: 320px;">
                            <span class="input-group-text bg-white border-end-0" style="font-weight: 300;">
                                <i class="bi bi-search text-muted"></i>
                            </span>
                            <input type="search" id="excelSearch" class="form-control border-start-0" placeholder="{{ __('Rechercher un fichier...') }}" style="font-weight: 300;">
                        </div>
                    </div>
                    <div class="table-responsive">
                        <table id="excelTable" class="table table-hover mb-0" style="font-size: 0.95rem;">
                            <thead style="background: #f8f9fa; font-weight: 400;">
                                <tr>
                                    <th class="px-3" style="border-bottom: 1px solid #dee2e6; font-size: 0.95rem; padding-top: 0.25rem; padding-bottom: 0.25rem;">{{ __('Nom') }}</th>
                                    <th class="px-3" style="border-bottom: 1px solid #dee2e6; font-size: 0.95rem; padding-top: 0.25rem; padding-bottom: 0.25rem;">{{ __('Fichier original') }}</th>
                                    <th class="px-3" style="border-bottom: 1px solid #dee2e6; font-size: 0.95rem; padding-top: 0.25rem; padding-bottom: 0.25rem;">{{ __('Campagne') }}</th>
                                    <th class="px-3" style="border-bottom: 1px solid #dee2e6; font-size: 0.95rem; padding-top: 0.25rem; padding-bottom: 0.25rem;">{{ __('Colonnes') }}</th>
                                    <th class="px-3" style="border-bottom: 1px solid #dee2e6; font-size: 0.95rem; padding-top: 0.25rem; padding-bottom: 0.25rem;">{{ __('Lignes') }}</th>
                                    <th class="px-3" style="border-bottom: 1px solid #dee2e6; font-size: 0.95rem; padding-top: 0.25rem; padding-bottom: 0.25rem;">{{ __('Créé le') }}</th>
                                    <th class="px-3 text-end" style="border-bottom: 1px solid #dee2e6; font-size: 0.95rem; padding-top: 0.25rem; padding-bottom: 0.25rem;">{{ __('Actions') }}</th>
                                </tr>
                            </thead>
                            <tbody>
                                @foreach($excelFiles as $file)
                                <tr>
                                    <td class="px-3" style="border-bottom: 1px solid #f0f0f0; padding-top: 0.25rem; padding-bottom: 0.25rem;">
                                        <div class="d-flex align-items-center">
                                            <div class="bg-primary bg-opacity-10 rounded-circle p-1 me-2" style="width: 28px; height: 28px; display: flex; align-items: center; justify-content: center;">
                                                <i class="bi bi-file-earmark-spreadsheet text-primary" style="font-size: 0.85rem;"></i>
                                            </div>
                                            <span style="font-family: 'Ubuntu', sans-serif; font-weight: 300; font-size: 0.95rem;">{{ $file->name }}</span>
                                        </div>
                                    </td>
                                    <td class="px-3" style="border-bottom: 1px solid #f0f0f0; padding-top: 0.25rem; padding-bottom: 0.25rem;">
                                        <span style="font-size: 0.9rem;">{{ $file->original_name }}</span>
                                    </td>
                                    <td class="px-3" style="border-bottom: 1px solid #f0f0f0; padding-top: 0.25rem; padding-bottom: 0.25rem;">
                                        @if($file->campaign)
                                            <span class="badge bg-success" style="font-weight: 300; font-size: 0.85rem; padding: 0.25rem 0.5rem;">
                                                <i class="bi bi-megaphone me-1"></i>{{ $file->campaign->name }}
                                            </span>
                                        @else
                                            <span class="text-muted" style="font-size: 0.9rem;">
                                                <i class="bi bi-dash-circle me-1"></i>-
                                            </span>
                                        @endif
                                    </td>
                                    <td class="px-3" style="border-bottom: 1px solid #f0f0f0; padding-top: 0.25rem; padding-bottom: 0.25rem;">
                                        @if($file->columns && is_array($file->columns))
                                            <span class="badge bg-info" style="font-weight: 300; font-size: 0.85rem; padding: 0.25rem 0.5rem;">
                                                <i class="bi bi-list-ul me-1"></i>{{ trans_choice('messages.columns', count($file->columns), ['count' => number_format(count($file->columns), 0, ',', ' ')]) }}
                                            </span>
                                            @if(count($file->columns) > 0)
                                                <button type="button" class="btn btn-sm btn-link p-0 ms-1" 
                                                        data-bs-toggle="tooltip" 
                                                        data-bs-placement="top"
                                                        title="{{ implode(', ', array_slice($file->columns, 0, 10)) }}{{ count($file->columns) > 10 ? '...' : '' }}">
                                                    <i class="bi bi-info-circle text-info" style="font-size: 0.85rem;"></i>
                                                </button>
                                            @endif
                                        @else
                                            <span class="text-muted" style="font-size: 0.9rem;">
                                                <i class="bi bi-dash-circle me-1"></i>-
                                            </span>
                                        @endif
                                    </td>
                                    <td class="px-3" style="border-bottom: 1px solid #f0f0f0; padding-top: 0.25rem; padding-bottom: 0.25rem;">
                                        <span class="badge bg-primary" style="font-weight: 300; font-size: 0.85rem; padding: 0.25rem 0.5rem;">
                                            <i class="bi bi-table me-1"></i>{{ trans_choice('messages.rows', $file->row_count, ['count' => number_format($file->row_count, 0, ',', ' ')]) }}
                                        </span>
                                    </td>
                                    <td class="px-3" style="border-bottom: 1px solid #f0f0f0; padding-top: 0.25rem; padding-bottom: 0.25rem;">
                                        <span style="font-size: 0.9rem;">{{ optional($file->created_at)->locale(app()->getLocale())->diffForHumans() }}</span>
                                    </td>
                                    <td class="px-3 text-end" style="border-bottom: 1px solid #f0f0f0; padding-top: 0.25rem; padding-bottom: 0.25rem;">
                                        <div class="btn-group" role="group">
                                            <a href="{{ route('admin.excel-list.show', $file->id) }}" class="btn btn-sm btn-outline-info" style="font-weight: 300; font-size: 0.85rem; padding: 0.2rem 0.4rem; font-family: 'Ubuntu', sans-serif;" title="{{ __('Voir détails') }}">
                                                <i class="bi bi-eye"></i>
                                            </a>
                                            <button type="button" 
                                                    class="btn btn-sm btn-outline-danger" 
                                                    style="font-weight: 300; font-size: 0.85rem; padding: 0.2rem 0.4rem; font-family: 'Ubuntu', sans-serif;" 
                                                    title="{{ __('Supprimer') }}"
                                                    data-bs-toggle="modal" 
                                                    data-bs-target="#deleteModal{{ $file->id }}">
                                                <i class="bi bi-trash"></i>
                                            </button>
                                        </div>
                                    </td>
                                </tr>
                                @endforeach
                            </tbody>
                        </table>
                    </div>
                </div>
            </div>
        @endif
    </div>
</div>

<!-- Modal pour charger un fichier -->
<div class="modal fade" id="uploadModal" tabindex="-1" aria-labelledby="uploadModalLabel" aria-hidden="true">
    <div class="modal-dialog">
        <div class="modal-content" style="border-radius: 8px;">
            <div class="modal-header border-0 pb-3">
                <h5 class="modal-title" id="uploadModalLabel" style="font-weight: 400;">
                    <i class="bi bi-upload text-primary me-2"></i>{{ __('Charger un fichier Excel') }}
                </h5>
                <button type="button" class="btn-close" data-bs-dismiss="modal" aria-label="Close"></button>
            </div>
            <form action="{{ route('admin.excel-list.store') }}" method="POST" enctype="multipart/form-data">
                @csrf
                <div class="modal-body pt-0">
                    <div class="mb-4">
                        <label for="name" class="form-label mb-2" style="font-weight: 400;">{{ __('Nom (optionnel)') }}</label>
                        <input type="text" class="form-control @error('name') is-invalid @enderror" 
                               id="name" name="name" 
                               placeholder="{{ __('Laissez vide pour utiliser le nom du fichier') }}"
                               style="font-weight: 300; font-size: 0.95rem;">
                        <small class="text-muted" style="font-size: 0.85rem;">{{ __('Si non renseigné, le nom du fichier sera utilisé.') }}</small>
                        @error('name')
                            <div class="text-danger mt-2" style="font-size: 0.875rem;">{{ $message }}</div>
                        @enderror
                    </div>
                    <div class="mb-4">
                        <label for="campaign_id" class="form-label mb-2" style="font-weight: 400;">{{ __('Associer à une campagne (optionnel)') }}</label>
                        <select class="form-select @error('campaign_id') is-invalid @enderror" 
                                id="campaign_id" name="campaign_id"
                                style="font-weight: 300; font-size: 0.95rem;">
                            <option value="">-- {{ __('Aucune campagne') }} --</option>
                            @foreach($campaigns as $campaign)
                                <option value="{{ $campaign->id }}" {{ old('campaign_id') == $campaign->id ? 'selected' : '' }}>
                                    {{ $campaign->name }}
                                </option>
                            @endforeach
                        </select>
                        <small class="text-muted" style="font-size: 0.85rem;">{{ __('Vous pouvez associer ce fichier à une campagne existante.') }}</small>
                        @error('campaign_id')
                            <div class="text-danger mt-2" style="font-size: 0.875rem;">{{ $message }}</div>
                        @enderror
                    </div>
                    <div class="mb-3">
                        <label for="excel_file" class="form-label mb-2" style="font-weight: 400;">{{ __('Fichier Excel') }} <span class="text-danger">*</span></label>
                        <input type="file" class="form-control @error('excel_file') is-invalid @enderror" 
                               id="excel_file" name="excel_file" accept=".xlsx,.xls" required
                               style="font-weight: 300; font-size: 0.95rem;">
                        <small class="text-muted" style="font-size: 0.85rem;">{{ __('Formats acceptés: .xlsx, .xls (max 10MB)') }}</small>
                        @error('excel_file')
                            <div class="text-danger mt-2" style="font-size: 0.875rem;">{{ $message }}</div>
                        @enderror
                    </div>
                </div>
                <div class="modal-footer border-0 pt-0">
                    <button type="button" class="btn btn-outline-secondary btn-sm" data-bs-dismiss="modal" style="font-weight: 300; font-family: 'Ubuntu', sans-serif;">{{ __('Annuler') }}</button>
                    <button type="submit" class="btn btn-primary btn-sm" style="font-weight: 300; font-family: 'Ubuntu', sans-serif;">
                        <i class="bi bi-upload me-2"></i>{{ __('Charger') }}
                    </button>
                </div>
            </form>
        </div>
    </div>
</div>
@endsection

@section('scripts')
<script>
    // Initialiser les tooltips Bootstrap
    var tooltipTriggerList = [].slice.call(document.querySelectorAll('[data-bs-toggle="tooltip"]'));
    var tooltipList = tooltipTriggerList.map(function (tooltipTriggerEl) {
        return new bootstrap.Tooltip(tooltipTriggerEl);
    });

    const excelSearchInput = document.getElementById('excelSearch');
    if (excelSearchInput) {
        const rows = document.querySelectorAll('#excelTable tbody tr');
        excelSearchInput.addEventListener('input', function () {
            const term = this.value.trim().toLowerCase();
            rows.forEach(row => {
                row.style.display = row.textContent.toLowerCase().includes(term) ? '' : 'none';
            });
        });
    }
</script>

<!-- Modals de confirmation -->
@foreach($excelFiles as $file)
    <div class="modal fade" id="deleteModal{{ $file->id }}" tabindex="-1" aria-labelledby="deleteModalLabel{{ $file->id }}" aria-hidden="true">
        <div class="modal-dialog modal-dialog-centered">
            <div class="modal-content" style="border-radius: 12px;">
                <div class="modal-header border-0 pb-2">
                    <h5 class="modal-title" id="deleteModalLabel{{ $file->id }}" style="font-weight: 300;">
                        <i class="bi bi-exclamation-triangle text-danger me-2"></i>Supprimer le fichier
                    </h5>
                    <button type="button" class="btn-close" data-bs-dismiss="modal" aria-label="Close"></button>
                </div>
                <div class="modal-body" style="font-weight: 300;">
                    <p class="mb-0">{{ __('Êtes-vous sûr de vouloir supprimer le fichier ":name" ?', ['name' => $file->name]) }}</p>
                    <p class="text-danger mt-2 mb-0" style="font-size: 0.9rem;">Cette action est irréversible.</p>
                </div>
                <div class="modal-footer border-0 pt-2">
                    <form action="{{ route('admin.excel-list.destroy', $file->id) }}" method="POST" class="d-inline">
                        @csrf
                        @method('DELETE')
                        <button type="button" class="btn btn-outline-secondary btn-sm" data-bs-dismiss="modal" style="font-weight: 300; font-family: 'Ubuntu', sans-serif;">Annuler</button>
                        <button type="submit" class="btn btn-danger btn-sm" style="font-weight: 300; font-family: 'Ubuntu', sans-serif;">
                            <i class="bi bi-trash me-2"></i>Supprimer
                        </button>
                    </form>
                </div>
            </div>
        </div>
    </div>
@endforeach
@endsection