@extends('layouts.app')

@section('content')
<div class="d-flex justify-content-between align-items-center mb-3"><h3 class="mb-0">Data Structures (Dynamic Tables)</h3></div>

<div class="card mb-3">
    <div class="card-header">Create / Extend Dynamic Table</div>
    <div class="card-body">
        <form method="POST" action="{{ route('data-structures.store') }}" class="row g-2">
            @csrf
            <div class="col-md-3"><input class="form-control" name="label" placeholder="Display label" required></div>
            <div class="col-md-3"><input class="form-control" name="table_name" placeholder="dataset_expo_visitors" required></div>
            <div class="col-md-6"><input class="form-control" name="columns[]" placeholder="First column (optional)"></div>
            <div class="col-md-6"><input class="form-control" name="columns[]" placeholder="Second column (optional)"></div>
            <div class="col-md-6"><input class="form-control" name="columns[]" placeholder="Third column (optional)"></div>
            <div class="col-12"><button class="btn btn-primary">Save Structure</button></div>
        </form>
    </div>
</div>

<div class="card"><div class="table-responsive">
<table class="table align-middle mb-0">
    <thead class="table-light"><tr><th>Label</th><th>Table</th><th>Status</th><th>Columns</th><th>Profiles</th><th>Last Used</th><th>Row Count</th><th>Action</th></tr></thead>
    <tbody>
    @forelse($tables as $table)
        <tr>
            <td>{{ $table->label }}</td>
            <td><code>{{ $table->table_name }}</code></td>
            <td>{!! $table->is_active ? '<span class="badge text-bg-success">Active</span>' : '<span class="badge text-bg-secondary">Disabled</span>' !!}</td>
            <td><small>{{ $table->columns->pluck('column_name')->implode(', ') }}</small></td>
            <td><small>{{ $table->mappingProfiles->pluck('name')->implode(', ') }}</small></td>
            <td>{{ $table->last_used_at?->format('Y-m-d H:i') }}</td>
            <td>{{ $table->row_count }}</td>
            <td><form method="POST" action="{{ route('data-structures.toggle', $table) }}">@csrf @method('PATCH')<button class="btn btn-sm btn-outline-warning">{{ $table->is_active ? 'Disable' : 'Enable' }}</button></form></td>
        </tr>
    @empty
        <tr><td colspan="8" class="text-center py-4">No dynamic tables created yet</td></tr>
    @endforelse
    </tbody>
</table>
</div></div>
@endsection