@extends('layouts.main')

@section('content')
    @include('layouts.nav-top')
    <hr class="text-white">

    <div class="row mt-3">

        <div class="col-12 col-sm-6 col-xl-4 mb-4">
            <div class="card border-0 shadow">
                <div class="card-body p-3 p-sm-1">
                    <div class="row d-block d-xl-flex align-items-center">
                        <div
                            class="col-12 col-xl-5 text-xl-center mb-3 mb-xl-0 d-flex align-items-center justify-content-xl-center">
                            <div class="icon-shape icon-shape-primary rounded me-4 me-sm-0">
                                <svg class="icon" fill="currentColor" viewBox="0 0 20 20"
                                    xmlns="http://www.w3.org/2000/svg">
                                    <path
                                        d="M13 6a3 3 0 11-6 0 3 3 0 016 0zM18 8a2 2 0 11-4 0 2 2 0 014 0zM14 15a4 4 0 00-8 0v3h8v-3zM6 8a2 2 0 11-4 0 2 2 0 014 0zM16 18v-3a5.972 5.972 0 00-.75-2.906A3.005 3.005 0 0119 15v3h-3zM4.75 12.094A5.973 5.973 0 004 15v3H1v-3a3 3 0 013.75-2.906z">
                                    </path>
                                </svg>
                            </div>
                            <div class="d-sm-none">
                                <h2 class="h5">Total Companies</h2>
                                <h3 class="fw-extrabold mb-1">{{ $companies_count }}</h3>
                            </div>
                        </div>
                        <div class="col-12 col-xl-7 px-xl-0">
                            <div class="d-none d-sm-block">
                                <h2 class="h6 text-gray-400 mb-0">Total Companies</h2>
                                <h3 class="fw-extrabold mb-2">{{ $companies_count }}</h3>
                            </div>
                            <!-- <small class="d-flex align-items-center text-gray-500">
                                Feb 1 - Apr 1,
                                <svg class="icon icon-xxs text-gray-500 ms-2 me-1" fill="currentColor" viewBox="0 0 20 20" xmlns="http://www.w3.org/2000/svg"><path fill-rule="evenodd" d="M10 18a8 8 0 100-16 8 8 0 000 16zM4.332 8.027a6.012 6.012 0 011.912-2.706C6.512 5.73 6.974 6 7.5 6A1.5 1.5 0 019 7.5V8a2 2 0 004 0 2 2 0 011.523-1.943A5.977 5.977 0 0116 10c0 .34-.028.675-.083 1H15a2 2 0 00-2 2v2.197A5.973 5.973 0 0110 16v-2a2 2 0 00-2-2 2 2 0 01-2-2 2 2 0 00-1.668-1.973z" clip-rule="evenodd"></path></svg>
                                USA
                              </small>
                              <div class="small d-flex mt-1">
                                <div>
                                  Since last month <svg class="icon icon-xs text-success" fill="currentColor" viewBox="0 0 20 20" xmlns="http://www.w3.org/2000/svg"><path fill-rule="evenodd" d="M14.707 12.707a1 1 0 01-1.414 0L10 9.414l-3.293 3.293a1 1 0 01-1.414-1.414l4-4a1 1 0 011.414 0l4 4a1 1 0 010 1.414z" clip-rule="evenodd"></path></svg><span class="text-success fw-bolder">22%</span>
                                </div>
                              </div> -->
                        </div>
                    </div>
                </div>
            </div>
        </div>
        <div class="col-12 col-sm-6 col-xl-4 mb-4">
            <div class="card border-0 shadow">
                <div class="card-body p-3 p-sm-1">
                    <div class="row d-block d-xl-flex align-items-center">
                        <div
                            class="col-12 col-xl-5 text-xl-center mb-3 mb-xl-0 d-flex align-items-center justify-content-xl-center">
                            <div class="icon-shape icon-shape-secondary rounded me-4 me-sm-0">
                                <svg class="icon" fill="currentColor" viewBox="0 0 20 20"
                                    xmlns="http://www.w3.org/2000/svg">
                                    <path fill-rule="evenodd"
                                        d="M10 2a4 4 0 00-4 4v1H5a1 1 0 00-.994.89l-1 9A1 1 0 004 18h12a1 1 0 00.994-1.11l-1-9A1 1 0 0015 7h-1V6a4 4 0 00-4-4zm2 5V6a2 2 0 10-4 0v1h4zm-6 3a1 1 0 112 0 1 1 0 01-2 0zm7-1a1 1 0 100 2 1 1 0 000-2z"
                                        clip-rule="evenodd"></path>
                                </svg>
                            </div>
                            <div class="d-sm-none">
                                <h2 class="fw-extrabold h5">Zero Charges</h2>
                                <h3 class="mb-1">{{ $companies_zero_charges }}</h3>
                            </div>
                        </div>
                        <div class="col-12 col-xl-7 px-xl-0">
                            <div class="d-none d-sm-block">
                                <h2 class="h6 text-gray-400 mb-0">Zero Charges</h2>
                                <h3 class="fw-extrabold mb-2">{{ $companies_zero_charges }}</h3>
                            </div>
                            <!-- <small class="d-flex align-items-center text-gray-500">
                                Feb 1 - Apr 1,
                                <svg class="icon icon-xxs text-gray-500 ms-2 me-1" fill="currentColor" viewBox="0 0 20 20" xmlns="http://www.w3.org/2000/svg"><path fill-rule="evenodd" d="M10 18a8 8 0 100-16 8 8 0 000 16zM4.332 8.027a6.012 6.012 0 011.912-2.706C6.512 5.73 6.974 6 7.5 6A1.5 1.5 0 019 7.5V8a2 2 0 004 0 2 2 0 011.523-1.943A5.977 5.977 0 0116 10c0 .34-.028.675-.083 1H15a2 2 0 00-2 2v2.197A5.973 5.973 0 0110 16v-2a2 2 0 00-2-2 2 2 0 01-2-2 2 2 0 00-1.668-1.973z" clip-rule="evenodd"></path></svg>
                                GER
                              </small>
                              <div class="small d-flex mt-1">
                                <div>
                                  Since last month <svg class="icon icon-xs text-danger" fill="currentColor" viewBox="0 0 20 20" xmlns="http://www.w3.org/2000/svg"><path fill-rule="evenodd" d="M5.293 7.293a1 1 0 011.414 0L10 10.586l3.293-3.293a1 1 0 111.414 1.414l-4 4a1 1 0 01-1.414 0l-4-4a1 1 0 010-1.414z" clip-rule="evenodd"></path></svg><span class="text-danger fw-bolder">2%</span>
                                </div>
                              </div> -->
                        </div>
                    </div>
                </div>
            </div>
        </div>
        <div class="col-12 col-sm-6 col-xl-4 mb-4">
            <div class="card border-0 shadow">
                <div class="card-body p-3 p-sm-1">
                    <div class="row d-block d-xl-flex align-items-center">
                        <div
                            class="col-12 col-xl-5 text-xl-center mb-3 mb-xl-0 d-flex align-items-center justify-content-xl-center">
                            <div class="icon-shape icon-shape-tertiary rounded me-4 me-sm-0">
                                <svg class="icon" fill="currentColor" viewBox="0 0 20 20"
                                    xmlns="http://www.w3.org/2000/svg">
                                    <path fill-rule="evenodd"
                                        d="M3 3a1 1 0 000 2v8a2 2 0 002 2h2.586l-1.293 1.293a1 1 0 101.414 1.414L10 15.414l2.293 2.293a1 1 0 001.414-1.414L12.414 15H15a2 2 0 002-2V5a1 1 0 100-2H3zm11.707 4.707a1 1 0 00-1.414-1.414L10 9.586 8.707 8.293a1 1 0 00-1.414 0l-2 2a1 1 0 101.414 1.414L8 10.414l1.293 1.293a1 1 0 001.414 0l4-4z"
                                        clip-rule="evenodd"></path>
                                </svg>
                            </div>
                            <div class="d-sm-none">
                                <h2 class="fw-extrabold h5">Charges</h2>
                                <h3 class="mb-1">{{ $companies_charges }}</h3>
                            </div>
                        </div>
                        <div class="col-12 col-xl-7 px-xl-0">
                            <div class="d-none d-sm-block">
                                <h2 class="h6 text-gray-400 mb-0">Charges</h2>
                                <h3 class="fw-extrabold mb-2">{{ $companies_charges }}</h3>
                            </div>
                            <!-- <small class="text-gray-500"> Feb 1 - Apr 1 </small>
                              <div class="small d-flex mt-1">
                                <div>
                                  Since last month <svg class="icon icon-xs text-success" fill="currentColor" viewBox="0 0 20 20" xmlns="http://www.w3.org/2000/svg"><path fill-rule="evenodd" d="M14.707 12.707a1 1 0 01-1.414 0L10 9.414l-3.293 3.293a1 1 0 01-1.414-1.414l4-4a1 1 0 011.414 0l4 4a1 1 0 010 1.414z" clip-rule="evenodd"></path></svg><span class="text-success fw-bolder">4%</span>
                                </div>
                              </div> -->
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>
    <div class="row">

        <!-- Filters Start -->
        <hr class="text-white pl-3" />
        <div class="col-12">
            <form method="get" action="/resources/views/final.blade.php">
                <div class="row" id="filtersNow" runat="server">
                    <div class="col-md-4 mb-3">
                        <label for="cCompName" class="col-form-label text-white">Company Name</label>
                        <input type="text" name="cCompName" id="cCompName" value="{{ request()->cCompName }}"
                            class="form-control" />
                    </div>
                    <div class="col-md-4 mb-3">
                        <label for="cCompNum" class="col-form-label text-white">Company Number (Comma Seperated for
                            Multiple)</label>
                        <input type="text" name="cCompNum" ID="cCompNum" value="{{ request()->cCompNum }}"
                            class="form-control" />
                    </div>
                    <!-- <div class="col-md-4 mb-3">
                                <label for="cAddress" class="col-form-label text-white">Reg Address</label>
                                <input type="text" ID="cAddress" value="" class="form-control" />
                            </div> -->
                    <div class="col-md-4 mb-3">
                        <label for="cPostCode" class="col-form-label text-white">Post Code (Comma Seperated for
                            Multiple)</label>
                        <input type="text" name="cPostCode" ID="cPostCode" value="{{ request()->cPostCode }}"
                            class="form-control" />

                    </div>
                    <div class="col-md-4 mb-3">
                        <label for="cPersonEntitled" class="col-form-label text-white">Person Entitled</label>
                        <input type="text" id="personEntitledSearch" class="form-control" placeholder="Search..." />

                        <!-- <input type="text" name="cPersonEntitled" ID="cPersonEntitled" value="" class="form-control" /> -->
                        <select id="cPersonEntitled" aria-label="Default select example" name='cPersonEntitled[]'
                            class="form-select" multiple>
                            <option value=''>Choose a Person Entitled</option>
                            @foreach ($person_entitled as $person)
                                <option value="{{ $person['Persons_Entitled'] }}"
                                    {{ is_array(request()->cPersonEntitled) && in_array(trim($person['Persons_Entitled']), request()->cPersonEntitled) ? 'selected' : '' }}>
                                    {{ $person['Persons_Entitled'] }} ({{ $person['total'] }})</option>
                            @endforeach
                        </select>
                    </div>
                    <div class="col-md-4 mb-3">
                        <label for="cPostTown" class="col-form-label text-white">City / Town</label>
                        <input type="text" id="postTownSearch" class="form-control" placeholder="Search..." />
                        <!-- <input type="text" name="cPostTown" ID="cPostTown" value="" class="form-control" /> -->
                        <select id="cPostTown" aria-label="Default select example" name='cPostTown[]'
                            class="form-select select2" multiple>
                            <option value=''>Choose a Town </option>
                            @foreach ($postTown as $town)
                                <option value="{{ $town['RegAddress_PostTown'] }}"
                                    {{ is_array(request()->cPostTown) && in_array(trim($town['RegAddress_PostTown']), request()->cPostTown) ? 'selected' : '' }}>
                                    {{ $town['RegAddress_PostTown'] }} </option>
                            @endforeach
                        </select>
                    </div>

                    <div class="col-md-4 mb-3">
                        <label for="cCountry" class="col-form-label text-white">Company Country</label>
                        <input type="text" id="countrySearch" class="form-control" placeholder="Search..." />
                        <select id="cCountry" aria-label="Default select example" name='cCountry[]' class="form-select"
                            multiple>
                            <option value=''>Choose a Company Country</option>
                            @foreach ($company_country as $country)
                                <option value="{{ $country['RegAddress_Country'] }}"
                                    {{ is_array(request()->cCountry) && in_array(trim($country['RegAddress_Country']), request()->cCountry) ? 'selected' : '' }}>
                                    {{ $country['RegAddress_Country'] }} ({{ $country['total'] }})</option>
                            @endforeach
                        </select>
                    </div>
                    <div class="col-md-4 mb-3">
                        <label for="cStatus" class="col-form-label text-white">Company Status</label>
                        <input type="text" id="statusSearch" class="form-control" placeholder="Search..." />

                        <select id="cStatus" aria-label="Default select example" name='cStatus[]' class="form-select"
                            multiple>
                            <option value=''>Choose a Company Status</option>
                            @foreach ($company_status as $status)
                                <option value="{{ $status['Status'] }}"
                                    {{ is_array(request()->cStatus) && in_array(trim($status['Status']), request()->cStatus) ? 'selected' : '' }}>
                                    {{ $status['Status'] }} ({{ $status['total'] }})</option>
                            @endforeach
                        </select>
                    </div>
                    <div class="col-md-4 mb-3">
                        <label for="siccode" class="col-form-label text-white">SIC Code</label>
                        <input type="text" id="siccodeSearch" class="form-control" placeholder="Search..." />

                        <select id="siccode" aria-label="Default select example" name='siccode[]' class="form-select"
                            multiple>
                            <option value=''>Choose a SIC Code</option>
                            @foreach ($company_siccode as $siccode)
                                <option value="{{ $siccode['SICCode_SicText_1'] }}"
                                    {{ is_array(request()->siccode) && in_array(trim($siccode['SICCode_SicText_1']), request()->siccode) ? 'selected' : '' }}>
                                    {{ $siccode['SICCode_SicText_1'] }} ({{ $siccode['total'] }})</option>
                            @endforeach
                        </select>
                    </div>
                    <div class="col-md-4 mb-3">
                        <label for="cCategory" class="col-form-label text-white">Company Category</label>
                        <input type="text" id="cCategorySearch" class="form-control" placeholder="Search..." />

                        <select id="cCategory" aria-label="Default select example" name='cCategory[]'
                            class="form-select" multiple>
                            <option value=''>Choose a Company Category</option>
                            @foreach ($company_category as $category)
                                <option value="{{ $category['CompanyCategory'] }}"
                                    {{ is_array(request()->cCategory) && in_array(trim($category['CompanyCategory']), request()->cCategory) ? 'selected' : '' }}>
                                    {{ $category['CompanyCategory'] }} ({{ $category['total'] }})</option>
                            @endforeach
                        </select>
                    </div>
                    <div class="col-md-4 mb-3">
                        <label for="cNumMortCharges" class="col-form-label text-white">Company Mortgages NUMMORT
                            Charges</label>
                        <input type="text" id="cNumMortChargesSearch" class="form-control" placeholder="Search..." />

                        <select id="cNumMortCharges" aria-label="Default select example" name='cNumMortCharges[]'
                            class="form-select" multiple>
                            <option value=''>Choose a Company Mortgages NUMMORT Charges</option>
                            @foreach ($company_nummortcharges as $nummortcharges)
                                <option value="{{ $nummortcharges['Mortgages_NumMortCharges'] }}"
                                    {{ is_array(request()->cNumMortCharges) && in_array(trim($nummortcharges['Mortgages_NumMortCharges']), request()->cNumMortCharges) ? 'selected' : '' }}>
                                    {{ $nummortcharges['Mortgages_NumMortCharges'] }} ({{ $nummortcharges['total'] }})
                                </option>
                            @endforeach
                        </select>
                    </div>
                    <div class="col-md-4 mb-3">
                        <label for="cNumMortOutstanding" class="col-form-label text-white">Company Mortgages NUMMORT
                            Outstanding</label>
                        <input type="text" id="cNumMortOutstandingSearch" class="form-control"
                            placeholder="Search..." />
                        <select id="cNumMortOutstanding" aria-label="Default select example" name='cNumMortOutstanding[]'
                            class="form-select" multiple>
                            <option value=''>Choose a Company Mortgages NUMMORT Outstanding</option>
                            @foreach ($company_nummortoutstanding as $nummortoutstanding)
                                <option value="{{ $nummortoutstanding['Mortgages_NumMortOutstanding'] }}"
                                    {{ is_array(request()->cNumMortOutstanding) && in_array(trim($nummortoutstanding['Mortgages_NumMortOutstanding']), request()->cNumMortOutstanding) ? 'selected' : '' }}>
                                    {{ $nummortoutstanding['Mortgages_NumMortOutstanding'] }}
                                    ({{ $nummortoutstanding['total'] }})
                                </option>
                            @endforeach
                        </select>
                    </div>
                    <div class="col-md-4 mb-3">
                        <label for="cNumMortPartSatisfied" class="col-form-label text-white">Company Mortgages NUMMORT
                            Part
                            Satisfied</label>
                        <input type="text" id="cNumMortPartSatisfiedSearch" class="form-control"
                            placeholder="Search..." />

                        <select id="cNumMortPartSatisfied" aria-label="Default select example"
                            name='cNumMortPartSatisfied[]' class="form-select" multiple>
                            <option value=''>Choose a Company Mortgages NUMMORT Part Satisfied</option>
                            @foreach ($company_nummortpartsatisfied as $nummortpartsatisfied)
                                <option value="{{ $nummortpartsatisfied['Mortgages_NumMortPartSatisfied'] }}"
                                    {{ is_array(request()->cNumMortPartSatisfied) && in_array(trim($nummortpartsatisfied['Mortgages_NumMortPartSatisfied']), request()->cNumMortPartSatisfied) ? 'selected' : '' }}>
                                    {{ $nummortpartsatisfied['Mortgages_NumMortPartSatisfied'] }}
                                    ({{ $nummortpartsatisfied['total'] }})
                                </option>
                            @endforeach
                        </select>
                    </div>
                    <div class="col-md-4 mb-3">
                        <label for="cNumMortSatisfied" class="col-form-label text-white">Company Mortgages NUMMORT
                            Satisfied</label>
                        <input type="text" id="cNumMortSatisfiedSearch" class="form-control"
                            placeholder="Search..." />

                        <select id="cNumMortSatisfied" aria-label="Default select example" name='cNumMortSatisfied[]'
                            class="form-select" multiple>
                            <option value=''>Choose a Company Mortgages NUMMORT Satisfied</option>
                            @foreach ($company_nummortsatisfied as $nummortsatisfied)
                                <option value="{{ $nummortsatisfied['Mortgages_NumMortSatisfied'] }}"
                                    {{ is_array(request()->cNumMortSatisfied) && in_array(trim($nummortsatisfied['Mortgages_NumMortSatisfied']), request()->cNumMortSatisfied) ? 'selected' : '' }}>
                                    {{ $nummortsatisfied['Mortgages_NumMortSatisfied'] }}
                                    ({{ $nummortsatisfied['total'] }})
                                </option>
                            @endforeach
                        </select>
                    </div>

                    <div class="col-md-4 mb-3">
                        <label for="cNumMortSatisfied" class="col-form-label text-white">Incorporation Date Start</label>
                        <input type="date" name="cDateFrom" id="cDateFrom" placeholder="dd-mm-yyyy"
                            value="{{ request()->cDateFrom }}" class="form-control" max="{{ date('Y-m-d') }}" />
                        {{-- new row add  --}}
                        <div class="row">
                            <div class="col-mb-12">
                                <label for="cNumMortSatisfied" class="col-form-label text-white">Charge Date Start</label>
                                <input type="date" name="cDateFrom1" id="cDateFrom" placeholder="dd-mm-yyyy"
                                    value="{{ request()->cDateFrom1 }}" class="form-control"
                                    max="{{ date('Y-m-d') }}" />
                            </div>
                        </div>
                        {{-- add new row --}}
                    </div>
                    <div class="col-md-4 mb-3">
                        <label for="cNumMortSatisfied" class="col-form-label text-white">Incorporation Date End</label>
                        <input type="date" name="cDateTo" id="cDateTo" placeholder="dd-mm-yyyy"
                            value="{{ request()->cDateTo }}" class="form-control" max="{{ date('Y-m-d') }}" />
                        {{-- new row add  --}}
                        <div class="row">
                            <div class="col-mb-12">
                                <label for="cNumMortSatisfied" class="col-form-label text-white">Charge Date End</label>
                                <input type="date" name="cDateTo1" id="cDateTo" placeholder="dd-mm-yyyy"
                                    value="{{ request()->cDateTo1 }}" class="form-control" max="{{ date('Y-m-d') }}" />
                            </div>
                        </div>
                        {{-- add new row --}}
                    </div>
                </div>
                <div class="row" id="filtersNow2" runat="server">
                    <div class="col-md-4 mb-3">
                        <input type="submit" ID="filterBTN" class="btn btn-gray-800 px-4" value="Filter Data" />
                        <button type="reset" onclick="window.location.replace(location.pathname);"
                            class="btn btn-primary px-4">Reset</button>
                        <!-- <button ID="filterBTN" class="btn btn-gray-800 px-4"
                                    OnClick="btnFilter_Click">Filter Data</button> -->
                    </div>
                </div>
            </form>
        </div>
        <hr class="text-white">
        <!-- Filters End -->

        <div class="col-12">
            <nav>
                <div class="nav custom-tab nav-tabs" id="nav-tab" role="tablist"
                    style="justify-content: space-between; align-items: center;">
                    <div class="d-flex  align-items-center">

                        <a class="nav-item nav-link {{ Route::currentRouteName() == 'final-data-with-charges' ? 'active' : '' }}"
                            id="nav-final-data-with-charges-tab"
                            href="/final-data-with-charges?{{ http_build_query(array_merge($_GET, ['page' => '1'])) }}"
                            role="tab" aria-controls="nav-final-data-with-charges" aria-selected="false">CHARGES</a>
                        <a class="nav-item nav-link {{ Route::currentRouteName() == 'final-data' ? 'active' : '' }}"
                            id="nav-final-data-tab"
                            href="/final-data?{{ http_build_query(array_merge($_GET, ['page' => '1'])) }}" role="tab"
                            aria-controls="nav-final-data" aria-selected="true">ZERO CHARGES</a>
                        <div style="margin-left: 30px;"><span style="color: white;">Total Filtered Companies:
                                {{ $final_data_total_count }} | Zero Charges: {{ $final_data_no_charges_count }} |
                                Charges:
                                {{ $final_data_charges_count }}</span></div>
                    </div>
                    <button id="exportButton" class="btn btn-primary btn-lg">Export CSV</button>

                </div>

            </nav>
            {{-- <div class="pagination-container">
                <div class="pagination-length">
                    <label for="page-length-select">Show:</label>
                    <select id="page-length-select">
                        <option value="10">10</option>
                        <option value="25">25</option>
                        <option value="50">50</option>
                        <option value="100">100</option>
                    </select>
                </div>
            </div> --}}
            <div class="tab-content py-3 px-3 px-sm-0" id="nav-tabContent">
                <div class="tab-pane fade {{ Route::currentRouteName() == 'final-data' ? 'show active' : '' }}"
                    id="nav-final-data" role="tabpanel" aria-labelledby="nav-final-data-tab">
                    <div class="card border-0 shadow mb-4">
                        <div class="table-responsive w-100">
                            @if (!empty($final_data))
                                <div class="wrapper1">
                                    <div class="div1"></div>
                                </div>
                                <div class="wrapper2">
                                    <div class="div2">

                                        <table class="table table-centered w-100 table-nowrap mb-0 rounded"
                                            id="example">
                                            <thead>
                                                <tr>
                                                    <th class="border-0 rounded-start">Sr #</th>
                                                    <th class="border-0">Company Name</th>
                                                    <th class="border-0">Company Number</th>
                                                    <th class="border-0">Registered Address</th>
                                                    <th class="border-0">Company Category</th>
                                                    <th class="border-0">Incorporation Date</th>
                                                    <th class="border-0">Charges</th>
                                                    <!-- <th class="border-0">Date Creation</th> -->
                                                    <th class="border-0">Status</th>
                                                    <!-- <th class="border-0">Persons Entitled</th>
                                        <th class="border-0">Brief Description</th>
                                        <th class="border-0">Charge Code</th> -->
                                                    <th class="border-0">Mortgages NumMortCharges</th>
                                                    <th class="border-0">Mortgages NumMortOutstanding</th>
                                                    <th class="border-0">Mortgages NumMortPartSatisfied</th>
                                                    <th class="border-0">Mortgages NumMortSatisfied</th>
                                                    <th class="border-0">SICCode</th>
                                                    <th class="border-0 rounded-end">Company Link</th>
                                                </tr>
                                            </thead>
                                            <tbody>

                                                <!-- Item -->
                                                @foreach ($final_data as $key => $data)
                                                    <tr>
                                                        <td>{{ ($final_data->currentpage() - 1) * $final_data->perpage() + 1 + $key }}
                                                        </td>
                                                        <td><a href="{{ $data->Company_Name_Link }}"
                                                                class="text-primary fw-bold"
                                                                target="_blank">{{ $data->Company_Name }}</a></td>
                                                        <td><a href="{{ $data->Company_Number_Link }}" class="t fw-bold"
                                                                target="_blank">{{ $data->Company_Number }}</a></td>
                                                        <td>{{ $data->Registered_Address }}</td>
                                                        <td>{{ $data->CompanyCategory }}</td>
                                                        <td>{{ $data->IncorporationDate }}</td>
                                                        <td>{{ $data->Charges }}</td>
                                                        <!-- <td>{{ $data->Date_Creation }}</td> -->
                                                        <td>{{ $data->Status }}</td>
                                                        <!-- <td>{{ $data->Persons_Entitled }}</td>
                                        <td>{{ $data->Brief_Description }}</td>
                                        <td>{{ $data->Charge_Code }}</td> -->
                                                        <td>{{ $data->Mortgages_NumMortCharges }}</td>
                                                        <td>{{ $data->Mortgages_NumMortOutstanding }}</td>
                                                        <td>{{ $data->Mortgages_NumMortPartSatisfied }}</td>
                                                        <td>{{ $data->Mortgages_NumMortSatisfied }}</td>
                                                        <td>{{ $data->SICCode_SicText_1 }}</td>
                                                        <td><a href="{{ $data->Company_Link }}"
                                                                class="text-primary fw-bold"
                                                                target="_blank">{{ $data->Company_Link }}</a></td>
                                                    </tr>
                                                @endforeach
                                                <!-- End of Item -->
                                            </tbody>
                                        </table>
                                    </div>
                                </div>
                                {{-- Pagination --}}
                                {{-- <div class="d-flex justify-content-center">
                                    {!! $final_data->appends(request()->except('page'))->links() !!}
                                </div> --}}
                            @endif
                        </div>
                    </div>
                </div>
                {{-- @dd($final_data_charges) --}}
                <div class="tab-pane fade {{ Route::currentRouteName() == 'final-data-with-charges' ? 'show active' : '' }}"
                    id="nav-final-data-with-charges" role="tabpanel" aria-labelledby="nav-final-data-with-charges-tab">
                    <div class="card border-0 shadow mb-4">
                        <div class="table-responsive w-100">
                            @if (!empty($final_data_charges))
                                <div class="wrapper1">
                                    <div class="div1"></div>
                                </div>
                                <div class="wrapper2">
                                    <div class="div2">
                                        <table class="table table-centered w-100 table-nowrap mb-0 rounded"
                                            id="example">
                                            <thead>
                                                <tr>
                                                    <th class="border-0 rounded-start">Sr #</th>
                                                    <th class="border-0">Company Name</th>
                                                    <th class="border-0">Company Number</th>
                                                    <th class="border-0">Registered Address</th>
                                                    <th class="border-0">Company Category</th>
                                                    <th class="border-0">Incorporation Date</th>
                                                    <th class="border-0">Charges</th>
                                                    <th class="border-0">Date Creation</th>
                                                    <th class="border-0">Status</th>
                                                    <th class="border-0">Persons Entitled</th>
                                                    <th class="border-0">Brief Description</th>
                                                    <th class="border-0">Charge Code</th>
                                                    <th class="border-0">Mortgages NumMortCharges</th>
                                                    <th class="border-0">Mortgages NumMortOutstanding</th>
                                                    <th class="border-0">Mortgages NumMortPartSatisfied</th>
                                                    <th class="border-0">Mortgages NumMortSatisfied</th>
                                                    <th class="border-0">SICCode</th>
                                                    <th class="border-0 rounded-end">Company Link</th>
                                                </tr>
                                            </thead>
                                            <tbody>
                                                <!-- Item -->
                                                @foreach ($final_data_charges as $key => $data)
                                                    <tr>
                                                        <td>{{ ($final_data_charges->currentpage() - 1) * $final_data_charges->perpage() + 1 + $key }}
                                                        </td>
                                                        <td><a href="{{ $data->Company_Name_Link }}"
                                                                class="text-primary fw-bold"
                                                                target="_blank">{{ $data->Company_Name }}</a></td>
                                                        <td><a href="{{ $data->Company_Number_Link }}" class="t fw-bold"
                                                                target="_blank">{{ $data->Company_Number }}</a></td>
                                                        <td>{{ $data->Registered_Address }}</td>
                                                        <td>{{ $data->CompanyCategory }}</td>
                                                        <td>{{ $data->IncorporationDate }}</td>
                                                        <td>{{ $data->Charges }}</td>
                                                        <td>{{ $data->Date_Creation }}</td>
                                                        <td>{{ $data->Status }}</td>
                                                        <td>{{ $data->Persons_Entitled }}</td>
                                                        <td>
                                                            <div style="overflow-x:auto; max-width:400px">
                                                                {{ $data->Brief_Description }}</div>
                                                        </td>
                                                        <td>{{ $data->Charge_Code }}</td>
                                                        <td>{{ $data->Mortgages_NumMortCharges }}</td>
                                                        <td>{{ $data->Mortgages_NumMortOutstanding }}</td>
                                                        <td>{{ $data->Mortgages_NumMortPartSatisfied }}</td>
                                                        <td>{{ $data->Mortgages_NumMortSatisfied }}</td>
                                                        <td>{{ $data->SICCode_SicText_1 }}</td>
                                                        <td><a href="{{ $data->Company_Link }}"
                                                                class="text-primary fw-bold"
                                                                target="_blank">{{ $data->Company_Link }}</a></td>
                                                    </tr>
                                                @endforeach
                                                <!-- End of Item -->
                                            </tbody>
                                        </table>

                                    </div>
                                </div>
                                {{-- Pagination --}}
                                {{-- <div class="d-flex justify-content-center">
                      {!! $final_data_charges->appends(request()->except('page'))->links() !!} --}}
                                {{-- </div> --}}
                            @endif
                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>

    <footer class="rounded mt-5">
        <div class="row">
            <div class="col-12 col-md-4 col-xl-6 mb-4 mb-md-0">
                <p class="mb-0 text-center text-lg-start text-white">©{{ date('Y') }}-<span
                        class="current-year text-white"></span> <a class="text-white text-primary fw-normal"
                        href="#" target="_blank">{{ config('app.name', 'HANKZARIHS') }}</a></p>
            </div>
            <div class="col-12 col-md-8 col-xl-6 text-center text-lg-end text-white">Version 1.0</div>
        </div>
    </footer>

@endsection