@php
use App\Models\CountryCurrency;
@endphp
@extends(Auth::user()->extender())
@section('title'){{__('Report')}} {{ __('Top Countries') }} @endsection
@section('content')
@include('includes.page_header',['title'=>__('Report')." ".
__('Top Countries'),'url'=>route(Auth::user()->user_dashboard()),'icon'
=> $icon??'','permission'=>'PriorityRoute-view'])

<!-- Include jQuery -->
<link rel="stylesheet" type="text/css" href="https://cdn.datatables.net/1.13.7/css/jquery.dataTables.min.css">

<div class="row">
    <div class="col-md-12">
        <div class="main-card mb-3 card">
            <div class="card-header">
                <button class="btn btn-link" type="button" onclick="toggleFilterSection()">
                    <i class="fas fa-filter"></i> Filter Wallet Transactions
                </button>
            </div>
            <div id="filterSection" style="display: none;">
                <div class="card-body">
                    <div class="container m-1">
                        <div class="row">
                            {{
                            Form::open(array(route('module.report.sale.top_product'),'method'=>'get','id'=>'module.report.sale.top_product'))
                            }}
                            <div class="row">
                                <div class="col-md-12">
                                    @include('modules.reports.recharge.filter_fields_admin')
                                </div>
                            </div>
                            <div class="row justify-content-end p-1">
                                <div class="col-auto">
                                    <a href="#" class="btn btn-sm btn-primary"
                                        onclick="document.getElementById('module.report.sale.top_product').submit(); return false;"
                                        data-bs-toggle="tooltip" title="{{__('Apply')}}"
                                        data-original-title="{{__('apply')}}">
                                        <span class="btn-inner--icon"><i class="ti ti-filter"></i>Filter</span>
                                    </a>
                                    <a href="{{route('module.report.sale.top_product')}}" class="btn btn-sm btn-danger "
                                        data-bs-toggle="tooltip" title="{{ __('Reset') }}"
                                        data-original-title="{{__('Reset')}}">
                                        <span class="btn-inner--icon"><i
                                                class="ti ti-arrows-horizontal"></i>Reset</span>
                                    </a>
                                </div>
                            </div>
                            {{ Form::close() }}
                        </div>
                    </div>
                </div>
            </div>
            <div class="card-footer d-flex justify-content-end">
                <p>Total Transactions Count: {{$purchase_trxs->count()}}</p>
            </div>



        </div>
    </div>
</div>
@include('admin.others.infyomincludes.filter_index_js')

<div class="row">
    <div class="col-md-12">
        <div class="main-card mb-3 card">
            <div class="card-body">
                <div class="row">
                    <div class="col-12">
                        <div class="table-responsive">
                            <table class="display" id="top_country-table" style="width:100%">
                                <thead>
                                    <tr>
                                        <th>#</th>
                                        <th>Code</th>
                                        <th>Country</th>
                                        <th>Currency</th>
                                        <th>Count</th>
                                        <th>Amount</th>
                                    </tr>
                                </thead>
                                <tbody>
                                    @forelse ($topCountries as $key=>$trx_country)
                                    @php
                                    $country = CountryCurrency::where('id',$key)->get()->first();
                                    @endphp
                                    @if ($country)
                                    <tr>
                                        <td>{{$key}}</td>
                                        <td>{{$country->code??''}}</td>
                                        <td>{{$country->country_name??''}}</td>
                                        <td>{{$country->name??''}}</td>
                                        <td>{{$trx_country['count']??''}}</td>
                                        <td>{{$trx_country['total_amount']??''}}</td>
                                    </tr>
                                    @endif

                                    @empty
                                    {{-- <tr>
                                        <td colspan="7">No users found</td>
                                    </tr> --}}
                                    @endforelse
                                </tbody>
                            </table>

                        </div>
                    </div>
                </div>
            </div>
        </div>
    </div>
</div>


<script type="text/javascript" language="javascript" src="https://code.jquery.com/jquery-3.7.0.js"></script>
<script type="text/javascript" language="javascript"
    src="https://cdn.datatables.net/1.13.7/js/jquery.dataTables.min.js"></script>
<script>
    new DataTable('#top_country-table', {
            pagingType: 'full_numbers'
        });
</script>

@endsection