@extends('layout.app')

@section('title', 'UAT-Pay Bill Retry')

@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="#">UAT Tables</a></li>
                <li class="breadcrumb-item active" aria-current="page">Pay Bill Retry</li>
            </ol>
        </nav>
    </div>

    <div class="mb">
        <div id="column-checkboxes" class="d-flex flex-wrap gap-2">
            @php
                $allColumns = ["ID", "ORG_CODE", "TIMESTAMP", "CONVERSATIONID", "INITIATORID", "PARENTID", "INITIATORMSISDN",
                "REQUESTERMSISDN", "CHANNELCODE", "DEBITMSISDN", "BKASHTRXREF", "BILLREFNUMBER", "PAYMODE", "PAYTYPE",
                "PRODUCTID", "SUBID", "BILLAMOUNT", "PAYMENTCONTRACTNO", "CONTACTNO", "ACTUALAMOUNT", "PARTIALAMOUNTFLAG",
                "BILLMONTH", "STARTMONTH", "ENDMONTH", "EXTENDEDPARAMETER1", "EXTENDEDPARAMETER2", "EXTENDEDPARAMETER3",
                "EXTENDEDPARAMETER4", "EXTENDEDPARAMETER5", "RESPONSE_TIMESTAMP", "CDSL_TRAN_ID", "ACCOUNTREMARKS", "PRODUCTNAME1",
                "MANDATORYPAYMENT1", "PENALTYDATE1", "PENALTYAMOUNT1", "PAYMENTMONTH1", "PAYMENTSTATE1", "PAYMENTDETAILS1",
                "ACTUALAMOUNT1", "RCVBLAMOUNT1", "MINAMOUNT1", "AMOUNT1", "AMOUNTDETAIL1", "PARTIALALLOWED1", "TOTALAMOUNT",
                "TOTALPAYMENTACTUAL", "TOTALPAYMENTPENALTY", "EXT_PARAM1", "EXT_PARAM2", "EXT_PARAM3", "EXT_PARAM4",
                "EXT_PARAM5", "EXT_PARAM6", "TOKENINFO", "PARTNERNOTIFICATION", "CALL_BACK_CODE", "CALL_BACK_STATUS",
                "CALL_BACK_MSG", "CUST_NAME", "DUE_DATE", "BILL_DATE", "BILL_NUM", "METER_NUM", "BILLER_TRAN_ID", "BILLER_ERR_CODE",
                "BILLER_MSG", "PRIN_AMT", "VAT_AMT", "BILLER_TOT_AMT", "LOC_CODE", "LOC_AMT", "SUB_LCO", "SUB_LCO_AMT", "DIST_CODE",
                "DIST_AMT", "SUB_DIST_CODE", "SUB_DIST_AMT", "AMOUNTDETAIL", "RESULTCODE", "RESULTDESC", "STATUS", "RETRY_STATUS",
                "CREATE_DATE", "CREATE_BY", "UPDATE_BY", "UPDATE_DATE"];
            @endphp
        </div>
    </div>

    <div class="card">
        <div class="card-body">
            <div class="row d-none" id="filter-section">
                <div class="row">
                    <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-8">
                        <div class="row">
                            <div class="col-md-3">
                                <label><strong>ChannelType</strong></label>
                                <select id="filter-ChannelType" class="form-select">
                                    <option value="">All</option>
                                </select>
                            </div>
                            <div class="col-md-3">
                                <label><strong>PayMode</strong></label>
                                <select id="filter-PayMode" class="form-select">
                                    <option value="">All</option>
                                </select>
                            </div>
                            <div class="col-md-3">
                                <label><strong>PayType</strong></label>
                                <select id="filter-PayType" class="form-select">
                                    <option value="">All</option>
                                </select>
                            </div>
                            <div class="col-md-3">
                                <label><strong>Status</strong></label>
                                <select id="filter-status" class="form-select">
                                    <option value="">All</option>
                                    <option value="A">Pending</option>
                                    <option value="P">Processing</option>
                                </select>
                            </div>
                            <div class="col-md-3">
                                <label><strong>CreateDate</strong></label>
                                <div class="input-group">
                                    <span class="input-group-text">
                                        <svg class="icon icon-xs text-gray-600" fill="currentColor" viewBox="0 0 20 20" xmlns="http://www.w3.org/2000/svg">
                                            <path fill-rule="evenodd" d="M6 2a1 1 0 00-1 1v1H4a2 2 0 00-2 2v10a2 2 0 002 2h12a2 2 0 002-2V6a2 2 0 00-2-2h-1V3a1 1 0 10-2 0v1H7V3a1 1 0 00-1-1zm0 5a1 1 0 000 2h8a1 1 0 100-2H6z" clip-rule="evenodd"></path>
                                        </svg>
                                    </span>
                                    <input class="form-control" name="filter-CreateDate" id="filter-CreateDate" type="text" placeholder="dd/mm/yyyy" required>
                                </div>
                            </div>
                            <div class="col-md-3">
                                <label><strong>CONVERSATIONID</strong></label>
                                <input type="text" id="filter-CONVERSATIONID" class="form-control" placeholder="Enter CONVERSATIONID">
                            </div>
                            <div class="col-md-3">
                                <label><strong>BILLREFNUMBER</strong></label>
                                <input type="text" id="filter-BILLREFNUMBER" class="form-control" placeholder="Enter BILLREFNUMBER">
                            </div>
                            <div class="col-md-3">
                                <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>
                        </div>
                    </div>
                </div>
                <hr style="margin-top: 25px">
            </div>
            <div class="d-flex justify-content-between align-items-center mb-3">
                <h6>Pay Bill Retry 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>
        $('#filter-CreateDate').datepicker({
            format: 'dd-MM-yyyy',
            autoclose: true,
            todayHighlight: true
        });

        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 {
                TYPE: $('#filter-TYPE').val(),
                CHANNELCODE: $('#filter-ChannelType').val(),
                PAYMODE: $('#filter-PayMode').val(),
                PAYTYPE: $('#filter-PayType').val(),
                STATUS: $('#filter-status').val(),
                CREATE_DATE: $('#filter-CreateDate').val(),
                CONVERSATIONID: $('#filter-CONVERSATIONID').val(),
                BILLREFNUMBER: $('#filter-BILLREFNUMBER').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-pay-bill-retry-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);
                }
            });
        }

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

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

        $('.column-checkbox').on('change', loadTableData);
        $('#filter-TYPE, #filter-ChannelType, #filter-PayMode,#filter-PayType, #filter-status, #filter-CreateDate, #filter-BILLREFNUMBER, #filter-org-code, #filter-CONVERSATIONID').on('change', function () {
            currentPage = 1;
            loadTableData();
        });

        function ChannelType() {
            url = "{{ url('uat-channel-type-reg') }}";
            $.ajax({
                url: url,
                type: "GET",
                success: function (data) {
                    if (data) {
                        var channeltypes = data;
                        var selectElement = $('#filter-ChannelType');
                        selectElement.empty();
                        selectElement.append('<option value="" selected>All</option>');
                        channeltypes.forEach(function(channeltype) {
                            selectElement.append('<option value="' + channeltype.CHANNEL_CODE + '">' + channeltype.CHANNEL_NAME + '</option>');
                        });
                        // selectElement.select2();
                    } else {
                        console.error('Failed to load roles');
                    }
                },
                error: function (err) {
                    console.error('Error loading roles', err);
                }
            });
        }
        function inquiryMode() {
            url = "{{ url('uat-inquiry-paymode-reg') }}";
            $.ajax({
                url: url,
                type: "GET",
                success: function (data) {
                    if (data) {
                        var channeltypes = data;
                        var selectElement = $('#filter-PayMode');
                        selectElement.empty();
                        selectElement.append('<option value="" selected>All</option>');
                        channeltypes.forEach(function(channeltype) {
                            selectElement.append('<option value="' + channeltype.PAY_CODE + '">' + channeltype.PAY_NAME + '</option>');
                        });
                        // selectElement.select2();
                    } else {
                        console.error('Failed to load roles');
                    }
                },
                error: function (err) {
                    console.error('Error loading roles', err);
                }
            });
        }
        function inquiryType() {
            url = "{{ url('uat-inquiry-paytype-reg') }}";
            $.ajax({
                url: url,
                type: "GET",
                success: function (data) {
                    if (data) {
                        var channeltypes = data;
                        var selectElement = $('#filter-PayType');
                        selectElement.empty();
                        selectElement.append('<option value="" selected>All</option>');
                        channeltypes.forEach(function(channeltype) {
                            selectElement.append('<option value="' + channeltype.PAY_TYPE_CODE + '">' + channeltype.PAY_TYPE_NAME + '</option>');
                        });
                        //selectElement.select2();
                    } else {
                        console.error('Failed to load roles');
                    }
                },
                error: function (err) {
                    console.error('Error loading roles', err);
                }
            });
        }
        ChannelType();
        inquiryType();
        inquiryMode();
        loadTableData();
    </script>
@endsection