@extends('layout.app')

@section('title', 'UAT-DB Error Log')

@section('style')
    <meta name="csrf-token" content="{{ csrf_token() }}">
    <style>
        #table-body tr {
            height: 10px;
        }
        .table > :not(caption) > * > * {
            padding: 0.2rem !important;
        }
        #user-datatable thead th {
            position: sticky;
            top: 0;
            background-color: #f8f9fa;
            z-index: 10;
        }
    </style>
@endsection

@section('main')

    <div class="">
        <nav aria-label="breadcrumb" class="d-none d-md-inline-block">
            <ol class="breadcrumb breadcrumb-dark breadcrumb-transparent">
                <li class="breadcrumb-item">
                    <a href="#">
                        <svg class="icon icon-xxs" fill="none" stroke="currentColor" viewBox="0 0 24 24">
                            <path stroke-linecap="round" stroke-linejoin="round" stroke-width="2"
                                  d="M3 12l2-2m0 0l7-7 7 7M5 10v10a1 1 0 001 1h3m10-11l2 2m-2-2v10a1 1 0 01-1 1h-3m-6 0a1 1 0 001-1v-4a1 1 0 011-1h2a1 1 0 011 1v4a1 1 0 001 1m-6 0h6"></path>
                        </svg>
                    </a>
                </li>
                <li class="breadcrumb-item"><a href="#">LIVE Tables</a></li>
                <li class="breadcrumb-item active" aria-current="page">DB Error Log</li>
            </ol>
        </nav>
    </div>

    <div class="mb">
        <div id="column-checkboxes" class="d-flex flex-wrap gap-2">
            @php
                $allColumns = ["ID", "ERROR_TIMESTAMP","ORG_CODE", "PROCEDURE_TABLE", "ERROR_CODE","ERROR_MESSAGE", "REQ_DATA", "USER_NAME", "HOST_NAME", "SESSION_ID","TRANSACTION_ID", "UPDATE_BY", "UPDATE_DATE", "STATUS"];
            @endphp
        </div>
    </div>

    <div class="card">
        <div class="card-body">
            <div class="row d-none" id="filter-section">
                <div class="col-md-4">
                    <label><strong>Choose Columns to Display</strong></label>
                    <div class="border rounded p-2" style="max-height: 150px; overflow-y: auto;">
                        @foreach ($allColumns as $col)
                            @if ($col === 'ID')
                                <input type="hidden" class="column-checkbox" value="ID" checked>
                            @else
                                <div class="form-check">
                                    <input class="form-check-input column-checkbox" type="checkbox"
                                           value="{{ $col }}" id="col-{{ $loop->index }}" checked>
                                    <label class="form-check-label" for="col-{{ $loop->index }}">
                                        {{ $col }}
                                    </label>
                                </div>
                            @endif
                        @endforeach
                    </div>
                </div>
                <div class="col-md-4">
                    <label><strong>Status</strong></label>
                    <select id="filter-status" class="form-select">
                        <option value="">All</option>
                        <option value="A">Active</option>
                        <option value="I">Inactive</option>
                    </select>
                </div>
                <div class="col-md-4">
                    <label><strong>Org Code</strong></label>
                    <input type="text" id="filter-org-code" class="form-control" placeholder="Enter Org Code">
                </div>
                <div class="col-md-2 d-flex align-items-end mt-2">
                    <button class="btn btn-primary" onclick="loadTableData()">Apply Filter</button>
                </div>
                <hr style="margin-top: 25px">
            </div>
            <div class="d-flex justify-content-between align-items-center mb-3">
                <h6>DB Error Log Data</h6>
                <div class="d-flex gap-2">
                    <button class="btn btn-outline-warning btn-sm" id="toggle-filter">
                        <span id="filter-icon">
                            <svg xmlns="http://www.w3.org/2000/svg" width="16" height="16" fill="currentColor"
                                 class="bi bi-funnel" viewBox="0 0 16 16">
                                <path d="M1.5 1.5A.5.5 0 0 1 2 1h12a.5.5 0 0 1 .39.812L10 8.118V13.5a.5.5 0 0 1-.777.416l-2-1.333A.5.5 0 0 1 7 12.167V8.118L1.61 1.812A.5.5 0 0 1 1.5 1.5z"/>
                            </svg>
                        </span>
                        <span id="close-icon" class="d-none">
                            <svg xmlns="http://www.w3.org/2000/svg" width="16" height="16" fill="currentColor"
                                 class="bi bi-x-lg" viewBox="0 0 16 16">
                                <path d="M2.146 2.146a.5.5 0 0 1 .708 0L8 7.293l5.146-5.147a.5.5 0 0 1 .708.708L8.707 8l5.147 5.146a.5.5 0 0 1-.708.708L8 8.707l-5.146 5.147a.5.5 0 0 1-.708-.708L7.293 8 2.146 2.854a.5.5 0 0 1 0-.708z"/>
                            </svg>
                        </span>
                        <span id="filter-btn-text"> Filter</span>
                    </button>

                    <a href="{{ url('orginfo/create') }}" class="btn btn-outline-primary btn-sm d-inline-flex align-items-center">
                        <svg class="icon icon-xs me-1" fill="none" stroke="currentColor" viewBox="0 0 24 24">
                            <path stroke-linecap="round" stroke-linejoin="round" stroke-width="2"
                                  d="M12 6v6m0 0v6m0-6h6m-6 0H6"></path>
                        </svg>
                        Add New
                    </a>
                </div>
            </div>
            <div class="table-responsive mt-2" style="max-height: 400px; overflow-y: auto;">
                <table class="table table-bordered" id="user-datatable" >
                    <thead class="thead-light">
                    <tr id="dynamic-header">
                        <th>SL</th>
                        <!-- Dynamic headers will be injected here -->
                        <th>Action</th>
                    </tr>
                    </thead>
                    <tbody id="table-body">
                    <!-- Data will be injected here -->
                    </tbody>
                </table>
            </div>
            <div class="d-flex justify-content-between align-items-center mt-3">
                <div id="total-records" style="font-size: small">Total Records: 0</div>
                <div class="btn-group" id="pagination-controls"></div>
                <div id="current-page" style="font-size: small">Page 1 of 1</div>
            </div>
        </div>
    </div>

@endsection

@section('script')
    <script src="{{ asset('assets/js/simple-datatables.js') }}"></script>
    <script>
        const toggleBtn = document.getElementById('toggle-filter');
        const filterSection = document.getElementById('filter-section');
        const filterIcon = document.getElementById('filter-icon');
        const closeIcon = document.getElementById('close-icon');
        const btnText = document.getElementById('filter-btn-text');

        toggleBtn.addEventListener('click', function () {
            const isHidden = filterSection.classList.contains('d-none');

            filterSection.classList.toggle('d-none');
            filterIcon.classList.toggle('d-none');
            closeIcon.classList.toggle('d-none');
            btnText.textContent = isHidden ? ' Close' : ' Filter';
        });

        let currentPage = 1;
        const pageSize = 10;

        function getFilters() {
            return {
                STATUS: $('#filter-status').val(),
                ORG_CODE: $('#filter-org-code').val(),
            };
        }

        function getSelectedColumns() {
            const selected = [];

            $('.column-checkbox:checked').each(function () {
                selected.push($(this).val());
            });
            return selected;
        }

        function loadTableData() {
            const selectedColumns = getSelectedColumns();
            const filters = getFilters();
            const offset = (currentPage - 1) * pageSize;

            $.ajax({
                url: '{{ route('lv-db-error-log-req') }}',
                type: 'POST',
                dataType: 'json',
                data: {
                    columns: selectedColumns,
                    filters: filters,
                    offset: offset,
                    limit: pageSize,
                    _token: '{{ csrf_token() }}'
                },
                success: function (data) {
                    $('#table-body').empty();

                    const rows = data.data || [];
                    const total = data.total || 0;
                    const totalPages = Math.ceil(total / pageSize);

                    // === Rebuild table header ===
                    let headerRow = '<th>SL</th>';
                    selectedColumns.forEach(col => {
                        headerRow += `<th>${col}</th>`;
                    });
                    headerRow += '<th>Action</th>';
                    $('#dynamic-header').html(headerRow);

                    // === Set total record count ===
                    $('#total-records').text(`Total Records: ${total}`);

                    // === Populate table body ===
                    if (rows.length === 0 && currentPage > 1) {
                        currentPage--;
                        loadTableData();
                        return;
                    }

                    $.each(rows, function (index, rowData) {
                        let row = `<tr><td>${offset + index + 1}</td>`;
                        selectedColumns.forEach(col => {
                            row += `<td>${rowData[col] ?? ''}</td>`;
                        });
                        row += `
                            <td>
                                <div class="btn-group">
                                    <button class="btn btn-secondary dropdown-toggle dropdown-toggle-split btn-sm" data-bs-toggle="dropdown">
                                        <svg class="icon icon-xs" fill="currentColor" viewBox="0 0 20 20">
                                            <path fill-rule="evenodd" d="M6 10a2 2 0 100 4 2 2 0 000-4zM10 10a2 2 0 100 4 2 2 0 000-4zM14 10a2 2 0 100 4 2 2 0 000-4z" clip-rule="evenodd"></path>
                                        </svg>
                                    </button>
                                    <ul class="dropdown-menu">
                                        <li><button class="dropdown-item" onclick="viewUser('${rowData.ID}')">View</button></li>
                                        <li><a class="dropdown-item" href="#" onclick="editUser('${rowData.ID}')">Edit</a></li>
                                        <li><a class="dropdown-item" href="#" onclick="deleteUser('${rowData.ID}')">Delete</a></li>
                                    </ul>
                                </div>
                            </td></tr>`;
                        $('#table-body').append(row);
                    });

                    // === Update page indicator ===
                    $('#current-page').text(`Page ${currentPage} of ${totalPages}`);

                    // === Build pagination ===
                    const $pagination = $('#pagination-controls');
                    $pagination.empty();

                    if (totalPages <= 1) return;

                    const createPageBtn = (page, text = page, disabled = false, active = false) => {
                        const btn = $(`<button class="btn ${active ? 'btn-primary' : 'btn-outline-secondary'}">${text}</button>`);
                        if (!disabled) {
                            btn.click(() => {
                                currentPage = page;
                                loadTableData();
                            });
                        } else {
                            btn.prop('disabled', true);
                        }
                        return btn;
                    };

                    // Prev
                    $pagination.append(createPageBtn(currentPage - 1, 'Prev', currentPage === 1));

                    // Numbered pages (max 5 visible)
                    const maxVisible = 5;
                    let start = Math.max(1, currentPage - Math.floor(maxVisible / 2));
                    let end = Math.min(totalPages, start + maxVisible - 1);
                    if (end - start < maxVisible - 1) {
                        start = Math.max(1, end - maxVisible + 1);
                    }

                    if (start > 1) {
                        $pagination.append(createPageBtn(1));
                        if (start > 2) $pagination.append($(''));
                    }

                    for (let i = start; i <= end; i++) {
                        $pagination.append(createPageBtn(i, i, false, i === currentPage));
                    }

                    if (end < totalPages) {
                        if (end < totalPages - 1) $pagination.append($(''));
                        $pagination.append(createPageBtn(totalPages));
                    }

                    // Next
                    $pagination.append(createPageBtn(currentPage + 1, 'Next', currentPage === totalPages));
                },
                error: function (xhr) {
                    console.error('Error:', xhr.responseText);
                }
            });
        }

        // Pagination buttons
        $('#prev-page').on('click', function () {
            if (currentPage > 1) {
                currentPage--;
                loadTableData();
            }
        });

        $('#next-page').on('click', function () {
            currentPage++;
            loadTableData();
        });

        // Trigger reloads
        $('.column-checkbox').on('change', loadTableData);
        $('#filter-status, #filter-org-code, #filter-date-from, #filter-date-to').on('change', function () {
            currentPage = 1;
            loadTableData();
        });

        // Initial load
        loadTableData();
    </script>
@endsection