@extends('layouts.site')

@section('title', 'MySQL Editor - Podsumowanie')

@php
    $runs = $runs ?? collect();
    $actions = $actions ?? collect();
    $selectedRunId = (int) ($selectedRunId ?? 0);
    $selectedRunDate = trim((string) ($selectedRunDate ?? ''));
    $displayTimezone = 'Europe/Warsaw';
    $formatLocalDateTime = static function ($value) use ($displayTimezone) {
        if (empty($value)) {
            return '-';
        }

        try {
            return \Illuminate\Support\Carbon::parse((string) $value, 'UTC')
                ->setTimezone($displayTimezone)
                ->format('Y-m-d H:i:s');
        } catch (\Throwable $exception) {
            return (string) $value;
        }
    };
@endphp

@section('content')
<div class="tab-content_2">
    <div class="row justify-content-center">
        <div class="col-md-12">
            <div class="form-group row" style="margin: 0 0.5rem">
                <div class="col-md-7">
                    <h5><i>MySQL Editor - Podsumowanie wykonan</i></h5>
                </div>
                <div class="col-md-5 btn-position">
                    <a class="btn btn-outline-secondary" href="{{ route('m_mysql_editor_form_add') }}" title="Powrot do edytora">
                        <i class="fas fa-edit"></i> Edytor
                    </a>
                    <a class="btn btn-dark" href="{{ url('/m_admin') }}" title="Zamknij">
                        <i class="fa fa-times fa-lg" aria-hidden="true"></i>
                    </a>
                </div>
            </div>
            <hr class="form_info"/>

            @if(!$logTablesReady)
                <div class="alert alert-warning" role="alert">
                    Brak tabel logowania/archiwizacji dla MySQL Editor. Uruchom update SQL:
                    <code>_DB_Update/DB_Update_2026.04.01_mysql_editor_multidb.sql</code>
                </div>
            @endif

            @if (session('mysql_editor_success'))
                <div class="alert alert-success" role="alert">{{ session('mysql_editor_success') }}</div>
            @endif

            @if (session('mysql_editor_error'))
                <div class="alert alert-danger" role="alert">{{ session('mysql_editor_error') }}</div>
            @endif

            @if ($logTablesReady)
                <div class="card mb-3">
                    <div class="card-body">
                        <small class="text-muted d-block mb-2">Wszystkie daty i godziny sa wyswietlane w czasie lokalnym: {{ $displayTimezone }}</small>
                        <form method="get" action="{{ route('m_mysql_editor_summary') }}" class="form-inline">
                            <label for="run_id" class="mr-2 mb-2"><b>Wybierz uruchomienie:</b></label>
                            <select id="run_id" name="run_id" class="form-control form-control-sm mr-2 mb-2" style="min-width: 22rem;">
                                <option value="" {{ $selectedRunId === 0 ? 'selected' : '' }}>Wszystkie akcje</option>
                                @foreach($runs as $run)
                                    @php
                                        $runStatus = strtoupper((string) ($run->status ?? '-'));
                                        $runLabel = '#' . $run->id . ' | ' . $formatLocalDateTime($run->started_at ?? null) . ' | ' . $runStatus;
                                    @endphp
                                    <option value="{{ $run->id }}" {{ (int) $run->id === $selectedRunId ? 'selected' : '' }}>
                                        {{ $runLabel }}
                                    </option>
                                @endforeach
                            </select>
                            <label for="run_date" class="mr-2 mb-2"><b>Data:</b></label>
                            <input
                                id="run_date"
                                name="run_date"
                                type="date"
                                class="form-control form-control-sm mr-2 mb-2"
                                value="{{ $selectedRunDate }}"
                            >
                            <button type="submit" class="btn btn-primary btn-sm mr-2 mb-2">Pokaz</button>
                            <a href="{{ route('m_mysql_editor_summary') }}" class="btn btn-outline-secondary btn-sm mb-2">Wszystkie</a>
                        </form>
                    </div>
                </div>

                @if($selectedRun)
                    <div class="card mb-3">
                        <div class="card-header"><b>Podsumowanie uruchomienia #{{ $selectedRun->id }}</b></div>
                        <div class="card-body">
                            <div class="row">
                                <div class="col-md-3"><b>Status:</b> {{ strtoupper($selectedRun->status ?? '-') }}</div>
                                <div class="col-md-3"><b>OK:</b> {{ (int) ($selectedRun->success_count ?? 0) }}</div>
                                <div class="col-md-3"><b>Bledy:</b> {{ (int) ($selectedRun->error_count ?? 0) }}</div>
                                <div class="col-md-3"><b>Start:</b> {{ $formatLocalDateTime($selectedRun->started_at ?? null) }}</div>
                            </div>
                        </div>
                    </div>
                @endif

                <div class="card mb-3">
                    <div class="card-header">
                        <b>Akcje DB {{ $selectedRunId > 0 ? '(Run #' . $selectedRunId . ')' : '(Wszystkie)' }}</b>
                    </div>
                    <div class="card-body">
                        <div class="table-responsive" style="height: 49vh;">
                            <table class="table table-sm table-bordered table-striped">
                                <thead>
                                    <tr>
                                        <th style="width:4rem;" class="text-center">Lp</th>
                                        <th style="width:12rem;" class="text-center">Data i godzina skryptu</th>
                                        <th>db_name</th>
                                        <th style="width:8rem;" class="text-center">status</th>
                                        <th>Szczegoly</th>
                                    </tr>
                                </thead>
                                <tbody>
                                    @forelse($actions as $index => $action)
                                        @php
                                            $rawStatus = strtolower((string) ($action->status ?? ''));
                                            $isOk = $rawStatus === 'success';
                                            $statusLabel = $isOk ? 'OK' : 'Error';
                                            $statusClass = $isOk ? 'text-success' : 'text-danger';

                                            $details = trim((string) ($action->error_message ?? ''));
                                            if ($isOk && $details === '') {
                                                $details = 'Wykonano poprawnie.';
                                            }
                                            if (!$isOk && $details === '') {
                                                $details = 'Brak szczegolow bledu.';
                                            }
                                            if (!empty($action->failed_statement_index)) {
                                                $details .= ' | Instrukcja #' . $action->failed_statement_index;
                                            }
                                            if (!empty($action->failed_statement_preview)) {
                                                $details .= ' | SQL: ' . $action->failed_statement_preview;
                                            }
                                            if ((int) $action->run_id > 0) {
                                                $details .= ' | Run #' . $action->run_id;
                                            }
                                            $scriptDateTime = $formatLocalDateTime($action->run_started_at ?? $action->started_at ?? null);
                                            $details .= ' | Start run: ' . $formatLocalDateTime($action->run_started_at ?? null);
                                            $details .= ' | Koniec akcji: ' . $formatLocalDateTime($action->finished_at ?? null);
                                        @endphp
                                        <tr>
                                            <td class="text-center">{{ $index + 1 }}</td>
                                            <td class="text-center">{{ $scriptDateTime }}</td>
                                            <td><code>{{ $action->database_name ?? '-' }}</code></td>
                                            <td class="text-center {{ $statusClass }}"><b>{{ $statusLabel }}</b></td>
                                            <td>{{ $details }}</td>
                                        </tr>
                                    @empty
                                        <tr>
                                            <td colspan="5" class="text-center">Brak wykonanych akcji.</td>
                                        </tr>
                                    @endforelse
                                </tbody>
                            </table>
                        </div>
                    </div>
                </div>
            @endif
        </div>
    </div>
</div>
@endsection

@section('navbar')
    @include('sites.admin._navbar_m_admin_site')
    <i class="fas fa-chevron-right separator"></i>
    <span class="navbar_navigate" title="Aktywna Strona">MySQL Editor</span>
    <i class="fas fa-chevron-right separator"></i>
    <span class="navbar_navigate" title="Podsumowanie">Podsumowanie wykonan</span>
@endsection

@section('menu')
    @include('sites.admin.menu_admin')
@endsection

@section('modal_windows')
@endsection