@extends('admin.default')
@section('title', 'Admin | Private Customers Report')
@section('content')
@php
$permissions= getPermissions();
@endphp	
<script type="text/javascript" src="https://www.gstatic.com/charts/loader.js"></script>
   <nav class="page-breadcrumb">
      <ol class="breadcrumb">
         <li class="breadcrumb-item"><a href="/">Dashboard</a></li>
         <li class="breadcrumb-item active" aria-current="page">Private Customer Report</li>
      </ol>
   </nav>
   <div class="row">
      <div class="col-md-12 grid-margin stretch-card">
         <div class="card">
            <div class="card-body">
            <div class="form-group row">
               <div class="col-md-2">
                  @if(isset($permissions) && isset($permissions["report_clear_filter_button"]) && $permissions["report_clear_filter_button"]==1)
                     <a class="btn btn-outline-primary" href="{{route('customerReporting', ['date_range' => '3m'])}}" id="clear">Clear Filter</a>
                  @endif
               </div>
               <div class="col-md-4">
                  <select class="form-control" id="date_range">
                     <option value="7d">Last 7 days</option>
                     <option value="1m">This Month</option>
                     <option value="3m">Last 3 Months</option>
                     <option value="6m">Last 6 Months</option>
                     <option value="custom">Custom Range</option>
                  </select>
                  <div class="input-group input-daterange datepicker mt-2 bg-info" id="datePickerExample">
                     <input type="text" class="form-control" value="{{(Request::get('start') !== null) ? Request::get('start') : ''}}" id="start"><span class="input-group-addon"><i data-feather="calendar"></i></span>
                     <div class="input-group-addon">to</div>
                     <input type="text" class="form-control" value="{{(Request::get('end') !== null) ? Request::get('end') : ''}}" id="end"><span class="input-group-addon"><i data-feather="calendar"></i></span>
                  </div>
               </div>
               <div class="col-md-2">
                  @if(isset($permissions) && isset($permissions["report_filter_option_button"]) && $permissions["report_filter_option_button"]==1)
                     <button class="btn btn-primary" id="filter">Filter</button>
                  @endif
               </div>
               <div class="col-md-4">
               <form class="form-inline" method="get" action="{{route('customerReportExportExcel')}}">
                  <input type="hidden" name="date_range" value="{{(Request::get('date_range') !== null) ? Request::get('date_range') : ''}}">
                  <input type="hidden" name="start" value="{{(Request::get('start') !== null) ? Request::get('start') : ''}}">
                  <input type="hidden" name="end" value="{{(Request::get('end') !== null) ? Request::get('end') : ''}}">
                  <div class="d-flex align-items-baseline">
                     @if(isset($permissions) && isset($permissions["report_excel_button"]) && $permissions["report_excel_button"]==1)
                        <h6>Export Report as </h6>
                        <button type="submit" class="btn btn-sm btn-secondary ml-3" id="export_excel">Excel</button>
                     @endif
                  </div>
               </form>
               </div>
            </div>
               <div class="row">
               <div class="col-4 col-md-4 col-xl-4">
                  
               </div>
               </div>
            </div>
         </div>
      </div>
   </div>
   <div class="row">
      <div class="col-md-7">
         <div class="card">
            <div class="card-body">
               <div id="regions_div" style="width: 100%; height: 350px;"></div>
            </div>
         </div>
      </div>
      <div class="col-md-5">
         <div class="card">
            <div class="card-body">
               <div id="donutchart" style="width: 100%; height:350px;"></div>
            </div>
         </div>
      </div>
   </div>
      <div class="row mt-3">
      <div class="col-md-12">
         <div class="card">
            <div class="card-body">
               <div class="row">
                  <div class="col-md-3">
                     <div class="d-flex justify-content-center align-items-baseline">
                        <h6 class="card-title mb-0">Total Customers</h6>
                        <h3 class="ml-3">{{number_format($data['total'])}}</h3>
                     </div>
                  </div>
                  <div class="col-md-3">
                     <div class="d-flex justify-content-center align-items-baseline">
                        <h6 class="card-title mb-0">Out of Scope</h6>
                        <h3 class="ml-3">{{number_format($data['out_of_scope'])}}</h3>
                     </div>
                  </div>
               </div>
            </div>
         </div>
      </div>
      </div>
   <div class="row mt-3">
      <div class="col-md-3">
         <div class="card">
            <div class="card-body">
               <div class="d-flex justify-content-between align-items-baseline">
                  <h6 class="card-title mb-0"><i class="mdi mdi-account-plus"></i> New</h6>
                  <h3 class="ml-3">{{number_format($data['signup']['total'])}}</h3>
               </div>
               <div class="d-flex justify-content-between align-items-baseline">
                  <p><i class="mdi mdi-nature"></i> Pending Profile</p>
                  <p class="float-right"><span class="h5"> {{number_format($data['signup']['pending_profile'])}}</span></p>
               </div>
               <div class="d-flex justify-content-between align-items-baseline">
                  <p><i class="mdi mdi-email-open"></i> Pending Email Verif.</p>
                  <p><span class="h5 ml-3"> {{number_format($data['signup']['pending_email_verification'])}}</span></p>
               </div>
               <div class="d-flex justify-content-between align-items-baseline">
                  <p><i class="mdi mdi-key-remove"></i> Pending Password </p>
                  <p><span class="h5 ml-3"> {{number_format($data['signup']['pending_password'])}}</span></p>
               </div>
            </div>
         </div>
      </div>
      <div class="col-md-3">
         <div class="card">
            <div class="card-body">
               <div class="d-flex justify-content-between align-items-baseline">
                  <h6 class="card-title mb-0"><i class="mdi mdi-account-minus"></i> Pending</h6>
                  <h3 class="ml-3">{{ (isset($data['pending']['total'])) ? number_format($data['pending']['total']) : 0 }}</h3>
               </div>
               <div class="d-flex justify-content-between align-items-baseline">
                  <p><i class="mdi mdi-account-star"></i> Active</p>
                  <p><span class="h5 ml-2"> {{number_format($data['pending']['active'])}}</span></p>
               </div>
               <div class="d-flex justify-content-between align-items-baseline">
                  <p><i class="mdi mdi-account-settings"></i> Pending</p>
                  <p><span class="h5 ml-2"> {{number_format($data['pending']['pending'])}}</span></p>
               </div>
               <div class="d-flex justify-content-between align-items-baseline">
                  <p><i class="mdi mdi-account-convert"></i> Processing</p>
                  <p><span class="h5 ml-2"> {{number_format($data['pending']['processing'])}}</span></p>
               </div>
            </div>
         </div>
      </div>
      <div class="col-md-3">
         <div class="card">
            <div class="card-body">
               <div class="d-flex justify-content-between align-items-baseline">
                  <h6 class="card-title mb-0"><i class="mdi mdi-account-check"></i> Approved</h6>
                  <h3 class="ml-3">{{number_format($data['approved']['total'])}}</h3>
               </div>
               <div class="d-flex justify-content-between align-items-baseline">
                  <p><i class="mdi mdi-account-star"></i> Active</p>
                  <p><span class="h5 ml-2"> {{number_format($data['approved']['active'])}}</span></p>
               </div>
               <div class="d-flex justify-content-between align-items-baseline">
                  <p><i class="mdi mdi-account-convert"></i> Processing</p>
                  <p><span class="h5 ml-2"> {{number_format($data['approved']['processing'])}}</span></p>
               </div>
            </div>
         </div>
      </div>
      <div class="col-md-3">
         <div class="card">
               <div class="card-body">
                  <div class="d-flex justify-content-between align-items-baseline">
                     <h6 class="card-title mb-0"><i class="mdi mdi-account-remove"></i> Failed KYC</h6>
                     <h3 class="ml-3">{{number_format($data['fail_kyc']['total'])}}</h3>
                  </div>
                  <div class="d-flex justify-content-between align-items-baseline mt-2">
                     <h6 class="card-title mb-0"><i class="link-icon" data-feather="file-text" height="14" width="14"></i> Transaction Comp.</h6>
                     <h3 class="ml-3">{{number_format($data['tx_completed']['total'])}}</h3>
                  </div>
                  <div class="row">
                  <div class="col-12 col-md-12 col-xl-12">
                  </div>
                  </div>
            </div>
         </div>
      </div>
   </div>


   <div class="row mt-3">
      <div class="col-md-12 grid-margin stretch-card">
      
         <div class="card">
         <div class="card-header">
            <div class="d-flex align-items-baseline">
               <h6 class="card-title mb-0"><i class="mdi mdi-account-plus"></i> New</h6>
               <h3 class="ml-3">{{number_format($data['signup']['total'])}}</h3>
            </div>
            <ul class="nav nav-tabs" id="myTab" role="tablist">
               <li class="nav-item">
                  <a class="nav-link active" id="pending_profile-tab" data-toggle="tab" href="#pending_profile" role="pending_profile" aria-controls="pending_profile" aria-selected="true">
                     <p><i class="mdi mdi-nature"></i> Pending Profile ({{number_format($data['signup']['pending_profile'])}})</p>
                  </a>
               </li>
               <li class="nav-item">
                  <a class="nav-link" id="pending_email_verification-tab" data-toggle="tab" href="#pending_email_verification" role="pending_email_verification" aria-controls="pending_email_verification" aria-selected="true">
                     <p><i class="mdi mdi-email-open"></i> Pending Email Verif. ({{number_format($data['signup']['pending_email_verification'])}})</p>
                  </a>
               </li>
               <li class="nav-item">
                  <a  class="nav-link" id="pending_password-tab" data-toggle="tab" href="#pending_password" role="pending_password" aria-controls="pending_password" aria-selected="false">
                  <p><i class="mdi mdi-key-remove"></i> Pending Password ({{number_format($data['signup']['pending_password'])}})</p>
                  </a>
               </li>
            </ul>
         </div>
            <div class="card-body" style="max-height:400px; overflow:auto;">
               <div class="tab-content" id="myTabContent">
                  <div class="tab-pane fade show active" id="pending_profile" role="pending_profile" aria-labelledby="pending_profile-tab">
                     <div class="table-responsive"> 
                        <table id="dataTableExample" class="table">
                           <thead>
                              <tr>
                                 <th>Name</th>
                                 <th>Email</th>
                                 <th>Phone No.</th>
                                 <th>Country</th>
                                 @if(isset($permissions) && isset($permissions["report_new_pending_profile_detail_button"]) && $permissions["report_new_pending_profile_detail_button"]==1)
                                    s<th>Action</th>
                                 @endif
                              </tr>
                           </thead>
                           <tbody>
                           @foreach($data['data']['signup']['pending_profile'] as $key)
                              <tr>
                                 <td>{{$key['first_name']." ".$key['last_name']}}</td>
                                 <td>{{$key['email']}}</td>
                                 <td>{{!empty($key['mobile_number']) ? formatPhoneNumber($key['mobile_number']) : '-'}}</td>
                                 <td>{{isset($key['country']['name']) ? $key['country']['name']: ''}}</td>
                                 <td>
                                    @if(isset($permissions) && isset($permissions["report_new_pending_profile_detail_button"]) && $permissions["report_new_pending_profile_detail_button"]==1)
                                       <a class="btn btn-sm btn-primary text-white detail" data-toggle="modal" data-id="{{$key['id']}}" data-target=".detail_modal">Detail</a>
                                    @endif
                                 </td>
                              </tr>
                           @endforeach
                           </tbody>
                        </table>
                     </div>
                  </div>
                  <div class="tab-pane fade" id="pending_email_verification" role="pending_email_verification" aria-labelledby="pending_email_verification-tab">
                     <div class="table-responsive"> 
                        <table id="dataTableExample" class="table">
                           <thead>
                              <tr>
                                 <th>Name</th>
                                 <th>Email</th>
                                 <th>Phone No.</th>
                                 <th>Country</th>
                                 @if(isset($permissions) && isset($permissions["report_new_pending_email_detail_button"]) && $permissions["report_new_pending_email_detail_button"]==1)
                                    <th>Action</th>
                                 @endif
                              </tr>
                           </thead>
                           <tbody>
                           @foreach($data['data']['signup']['pending_email_verification'] as $key)
                              <tr>
                                 <td>{{$key['first_name']." ".$key['last_name']}}</td>
                                 <td>{{$key['email']}}</td>
                                 <td>{{!empty($key['mobile_number']) ? formatPhoneNumber($key['mobile_number']) : '-'}}</td>
                                 <td>{{isset($key['country']['name']) ? $key['country']['name']: ''}}</td>
                                 <td>
                                    @if(isset($permissions) && isset($permissions["report_new_pending_email_detail_button"]) && $permissions["report_new_pending_email_detail_button"]==1)
                                       <a class="btn btn-sm btn-primary text-white detail" data-toggle="modal" data-id="{{$key['id']}}" data-target=".detail_modal">Detail</a>
                                    @endif
                                 </td>
                              </tr>
                           @endforeach
                           </tbody>
                        </table>
                     </div>
                  </div>
                  <div class="tab-pane fade" id="pending_password" role="pending_password" aria-labelledby="pending_password-tab">
                     <div class="table-responsive"> 
                        <table id="dataTableExample" class="table">
                           <thead>
                              <tr>
                                 <th>Name</th>
                                 <th>Email</th>
                                 <th>Phone No.</th>
                                 <th>Country</th>
                                 @if(isset($permissions) && isset($permissions["report_new_pending_password_detail_button"]) && $permissions["report_new_pending_password_detail_button"]==1)
                                    <th>Action</th>
                                 @endif
                              </tr>
                           </thead>
                           <tbody>
                           @foreach($data['data']['signup']['pending_password'] as $key)
                              <tr>
                                 <td>{{$key['first_name']." ".$key['last_name']}}</td>
                                 <td>{{$key['email']}}</td>
                                 <td>{{!empty($key['mobile_number']) ? formatPhoneNumber($key['mobile_number']) : '-'}}</td>
                                 <td>{{isset($key['country']['name']) ? $key['country']['name']: ''}}</td>
                                 <td>
                                    @if(isset($permissions) && isset($permissions["report_new_pending_password_detail_button"]) && $permissions["report_new_pending_password_detail_button"]==1)
                                       <a class="btn btn-sm btn-primary text-white detail" data-toggle="modal" data-id="{{$key['id']}}" data-target=".detail_modal">Detail</a>
                                    @endif
                                 </td>
                              </tr>
                           @endforeach
                           </tbody>
                        </table>
                     </div>
                  </div>
               </div>
            </div>
         </div>
      </div>
   </div>


   <div class="row mt-3">
      <div class="col-md-12 grid-margin stretch-card">
      
         <div class="card">
         <div class="card-header">
            <div class="d-flex align-items-baseline">
               <h6 class="card-title mb-0"><i class="mdi mdi-account-minus"></i> Pending</h6>
               <h3 class="ml-3">{{ (isset($data['pending']['total'])) ? number_format($data['pending']['total']) : 0 }}</h3>
            </div>
            <ul class="nav nav-tabs" id="myTab" role="tablist">
               <li class="nav-item">
                  <a class="nav-link active" id="active-tab" data-toggle="tab" href="#active" role="active" aria-controls="active" aria-selected="true">
                     <p><i class="mdi mdi-account-star"></i> Active ({{number_format($data['pending']['active'])}})</p>
                  </a>
               </li>
               <li class="nav-item">
                  <a class="nav-link" id="pending-tab" data-toggle="tab" href="#pending" role="pending" aria-controls="pending" aria-selected="true">
                     <p><i class="mdi mdi-account-settings"></i> Pending ({{number_format($data['pending']['pending'])}})</p>
                  </a>
               </li>
               <li class="nav-item">
                  <a  class="nav-link" id="processing-tab" data-toggle="tab" href="#processing" role="processing" aria-controls="processing" aria-selected="false">
                  <p><i class="mdi mdi-account-convert"></i> Processing ({{number_format($data['pending']['processing'])}})</p>
                  </a>
               </li>
            </ul>
         </div>
            <div class="card-body" style="max-height:400px; overflow:auto;">
               <div class="tab-content" id="myTabContent">
                  <div class="tab-pane fade show active" id="pending_profile" role="pending_profile" aria-labelledby="pending_profile-tab">
                     <div class="table-responsive"> 
                        <table id="dataTableExample" class="table">
                           <thead>
                              <tr>
                                 <th>Name</th>
                                 <th>Email</th>
                                 <th>Phone No.</th>
                                 <th>Country</th>
                                 @if(isset($permissions) && isset($permissions["report_pending_active_detail_button"]) && $permissions["report_pending_active_detail_button"]==1)
                                    <th>Action</th>
                                 @endif
                              </tr>
                           </thead>
                           <tbody>
                           @foreach($data['data']['pending']['active'] as $key)
                              <tr>
                                 <td>{{$key['first_name']." ".$key['last_name']}}</td>
                                 <td>{{$key['email']}}</td>
                                 <td>{{!empty($key['mobile_number']) ? formatPhoneNumber($key['mobile_number']) : '-'}}</td>
                                 <td>{{isset($key['country']['name']) ? $key['country']['name']: ''}}</td>
                                 <td>
                                    @if(isset($permissions) && isset($permissions["report_pending_active_detail_button"]) && $permissions["report_pending_active_detail_button"]==1)
                                       <a class="btn btn-sm btn-primary text-white detail" data-toggle="modal" data-id="{{$key['id']}}" data-target=".detail_modal">Detail</a>
                                    @endif
                                 </td>
                              </tr>
                           @endforeach
                           </tbody>
                        </table>
                     </div>
                  </div>
                  <div class="tab-pane fade" id="pending" role="pending" aria-labelledby="pending-tab">
                     <div class="table-responsive"> 
                        <table id="dataTableExample" class="table">
                           <thead>
                              <tr>
                                 <th>Name</th>
                                 <th>Email</th>
                                 <th>Phone No.</th>
                                 <th>Country</th>
                                 @if(isset($permissions) && isset($permissions["report_pending_pending_detail_button"]) && $permissions["report_pending_pending_detail_button"]==1)
                                    <th>Action</th>
                                 @endif
                              </tr>
                           </thead>
                           <tbody>
                           @foreach($data['data']['pending']['pending'] as $key)
                              <tr>
                                 <td>{{$key['first_name']." ".$key['last_name']}}</td>
                                 <td>{{$key['email']}}</td>
                                 <td>{{!empty($key['mobile_number']) ? formatPhoneNumber($key['mobile_number']) : '-'}}</td>
                                 <td>{{isset($key['country']['name']) ? $key['country']['name']: ''}}</td>
                                 <td>
                                    @if(isset($permissions) && isset($permissions["report_pending_pending_detail_button"]) && $permissions["report_pending_pending_detail_button"]==1)
                                       <a class="btn btn-sm btn-primary text-white detail" data-toggle="modal" data-id="{{$key['id']}}" data-target=".detail_modal">Detail</a>
                                    @endif
                                 </td>
                              </tr>
                           @endforeach
                           </tbody>
                        </table>
                     </div>
                  </div>
                  <div class="tab-pane fade" id="processing" role="processing" aria-labelledby="processing-tab">
                     <div class="table-responsive"> 
                        <table id="dataTableExample" class="table">
                           <thead>
                              <tr>
                                 <th>Name</th>
                                 <th>Email</th>
                                 <th>Phone No.</th>
                                 <th>Country</th>
                                 @if(isset($permissions) && isset($permissions["report_pending_processing_detail_button"]) && $permissions["report_pending_processing_detail_button"]==1)
                                    <th>Action</th>
                                 @endif
                              </tr>
                           </thead>
                           <tbody>
                           @foreach($data['data']['pending']['processing'] as $key)
                              <tr>
                                 <td>{{$key['first_name']." ".$key['last_name']}}</td>
                                 <td>{{$key['email']}}</td>
                                 <td>{{!empty($key['mobile_number']) ? formatPhoneNumber($key['mobile_number']) : '-'}}</td>
                                 <td>{{isset($key['country']['name']) ? $key['country']['name']: ''}}</td>
                                 <td>
                                    @if(isset($permissions) && isset($permissions["report_pending_processing_detail_button"]) && $permissions["report_pending_processing_detail_button"]==1)
                                       <a class="btn btn-sm btn-primary text-white detail" data-toggle="modal" data-id="{{$key['id']}}" data-target=".detail_modal">Detail</a>      
                                    @endif
                                 </td>
                              </tr>
                           @endforeach
                           </tbody>
                        </table>
                     </div>
                  </div>
               </div>
            </div>
         </div>
      </div>
   </div>

   <div class="row mt-3">
      <div class="col-md-12 grid-margin stretch-card">
      
         <div class="card">
         <div class="card-header">
            <div class="d-flex align-items-baseline">
               <h6 class="card-title mb-0"><i class="mdi mdi-account-check"></i> Approved</h6>
               <h3 class="ml-3">{{number_format($data['approved']['total'])}}</h3>
            </div>
            <ul class="nav nav-tabs" id="myTab" role="tablist">
               <li class="nav-item">
                  <a class="nav-link active" id="approved-active-tab" data-toggle="tab" href="#approved-active" role="approved-active" aria-controls="approved-active" aria-selected="true">
                     <p><i class="mdi mdi-account-star"></i> Active ({{number_format($data['approved']['active'])}})</p>
                  </a>
               </li>
               <li class="nav-item">
                  <a class="nav-link" id="approved-processing-tab" data-toggle="tab" href="#approved-processing" role="approved-processing" aria-controls="approved-processing" aria-selected="true">
                     <p><i class="mdi mdi-account-settings"></i> Pending ({{number_format($data['approved']['processing'])}})</p>
                  </a>
               </li>
            </ul>
         </div>
            <div class="card-body" style="max-height:400px; overflow:auto;">
               <div class="tab-content" id="myTabContent">
                  <div class="tab-pane fade show active" id="approved-active" role="approved-active" aria-labelledby="approved-active-tab">
                     <div class="table-responsive"> 
                        <table id="dataTableExample" class="table">
                           <thead>
                              <tr>
                                 <th>Name</th>
                                 <th>Email</th>
                                 <th>Phone No.</th>
                                 <th>Country</th>
                                 @if(isset($permissions) && isset($permissions["report_approved_active_detail_button"]) && $permissions["report_approved_active_detail_button"]==1)
                                    <th>Action</th>
                                 @endif
                              </tr>
                           </thead>
                           <tbody>
                           @foreach($data['data']['approved']['active'] as $key)
                              <tr>
                                 <td>{{$key['first_name']." ".$key['last_name']}}</td>
                                 <td>{{$key['email']}}</td>
                                 <td>{{!empty($key['mobile_number']) ? formatPhoneNumber($key['mobile_number']) : '-'}}</td>
                                 <td>{{isset($key['country']['name']) ? $key['country']['name']: ''}}</td>
                                 <td>
                                    @if(isset($permissions) && isset($permissions["report_approved_active_detail_button"]) && $permissions["report_approved_active_detail_button"]==1)
                                       <a class="btn btn-sm btn-primary text-white detail" data-toggle="modal" data-id="{{$key['id']}}" data-target=".detail_modal">Detail</a>
                                    @endif
                                 </td>
                              </tr>
                           @endforeach
                           </tbody>
                        </table>
                     </div>
                  </div>
                  <div class="tab-pane fade" id="approved-processing" role="approved-processing" aria-labelledby="approved-processing-tab">
                     <div class="table-responsive"> 
                        <table id="dataTableExample" class="table">
                           <thead>
                              <tr>
                                 <th>Name</th>
                                 <th>Email</th>
                                 <th>Phone No.</th>
                                 <th>Country</th>
                                 @if(isset($permissions) && isset($permissions["report_approved_pending_detail_button"]) && $permissions["report_approved_pending_detail_button"]==1)
                                    <th>Action</th>
                                 @endif
                              </tr>
                           </thead>
                           <tbody>
                           @foreach($data['data']['approved']['processing'] as $key)
                              <tr>
                                 <td>{{$key['first_name']." ".$key['last_name']}}</td>
                                 <td>{{$key['email']}}</td>
                                 <td>{{!empty($key['mobile_number']) ? formatPhoneNumber($key['mobile_number']) : '-'}}</td>
                                 <td>{{isset($key['country']['name']) ? $key['country']['name']: ''}}</td>
                                 <td>
                                    @if(isset($permissions) && isset($permissions["report_approved_pending_detail_button"]) && $permissions["report_approved_pending_detail_button"]==1)
                                       <a class="btn btn-sm btn-primary text-white detail" data-toggle="modal" data-id="{{$key['id']}}" data-target=".detail_modal">Detail</a>
                                    @endif
                                 </td>
                              </tr>
                           @endforeach
                           </tbody>
                        </table>
                     </div>
                  </div>
               </div>
            </div>
         </div>
      </div>
   </div>

   <div class="row mt-3" >
      <div class="col-md-12 grid-margin stretch-card">
      
         <div class="card">
            <div class="card-header">
               <div class="d-flex align-items-baseline">
                  <h6 class="card-title mb-0"><i class="mdi mdi-account-remove"></i> Failed KYC</h6>
                  <h3 class="ml-3">{{number_format($data['fail_kyc']['total'])}}</h3>
               </div>
            </div>
            <div class="card-body" style="max-height:400px; overflow:auto;">
               <div class="table-responsive"> 
                  <table id="dataTableExample" class="table">
                     <thead>
                        <tr>
                           <th>Name</th>
                           <th>Email</th>
                           <th>Phone No.</th>
                           <th>Country</th>
                           @if(isset($permissions) && isset($permissions["report_failed_kyc_detail_button"]) && $permissions["report_failed_kyc_detail_button"]==1)
                              <th>Action</th>
                           @endif
                        </tr>
                     </thead>
                     <tbody>
                     @foreach($data['data']['fail_kyc']['total'] as $key)
                        <tr>
                           <td>{{$key['first_name']." ".$key['last_name']}}</td>
                           <td>{{$key['email']}}</td>
                           <td>{{!empty($key['mobile_number']) ? formatPhoneNumber($key['mobile_number']) : '-'}}</td>
                           <td>{{isset($key['country']['name']) ? $key['country']['name']: ''}}</td>
                           <td>
                              @if(isset($permissions) && isset($permissions["report_failed_kyc_detail_button"]) && $permissions["report_failed_kyc_detail_button"]==1)
                                 <a class="btn btn-sm btn-primary text-white detail" data-toggle="modal" data-id="{{$key['id']}}" data-target=".detail_modal">Detail</a>
                              @endif
                           </td>
                        </tr>
                     @endforeach
                     </tbody>
                  </table>
               </div>
            </div>
         </div>
      </div>
   </div>

   <div class="row mt-3">
      <div class="col-md-12 grid-margin stretch-card">
      
         <div class="card">
            <div class="card-header">
               <div class="d-flex align-items-baseline mt-2">
                  <h6 class="card-title mb-0"><i class="link-icon" data-feather="file-text" height="14" width="14"></i> Transaction Completed</h6>
                  <h3 class="ml-3">{{number_format($data['tx_completed']['total'])}}</h3>
               </div>
            </div>
            <div class="card-body" style="max-height:400px; overflow:auto;">
               <div class="table-responsive"> 
                  <table id="dataTableExample" class="table">
                     <thead>
                        <tr>
                           <th>Name</th>
                           <th>Email</th>
                           <th>Phone No.</th>
                           <th>Country</th>
                           @if(isset($permissions) && isset($permissions["report_transaction_detail_button"]) && $permissions["report_transaction_detail_button"]==1)
                              <th>Action</th>
                           @endif
                        </tr>
                     </thead>
                     <tbody>
                     @foreach($data['data']['tx_completed']['total'] as $key)
                        <tr>
                           <td>{{$key['first_name']." ".$key['last_name']}}</td>
                           <td>{{$key['email']}}</td>
                           <td>{{!empty($key['mobile_number']) ? formatPhoneNumber($key['mobile_number']) : '-'}}</td>
                           <td>{{isset($key['country']['name']) ? $key['country']['name']: ''}}</td>
                           <td>
                              @if(isset($permissions) && isset($permissions["report_transaction_detail_button"]) && $permissions["report_transaction_detail_button"]==1)
                                <a class="btn btn-sm btn-primary text-white detail" data-toggle="modal" data-id="{{$key['id']}}" data-target=".detail_modal">Detail</a>
                              @endif
                           </td>
                        </tr>
                     @endforeach
                     </tbody>
                  </table>
               </div>
            </div>
         </div>
      </div>
   </div>

                                      <!-- Detail Modal Start -->
<div class="modal fade bd-example-modal-lg detail_modal" tabindex="-1" role="dialog" aria-labelledby="detail_modal" aria-hidden="true">
  <div class="modal-dialog modal-lg" role="detail_modal">
    <div class="modal-content">
    
      <div class="modal-header">
        <h5 class="modal-title" id="exampleModalLabel">Customer Details</h5>
        <button type="button" class="close" data-dismiss="modal" aria-label="Close">
          <span aria-hidden="true">&times;</span>
        </button>
      </div>
      <div id="add-msg"></div>
        <div class="modal-body">
            <div class="form-group row">
                <div class="col-md-2"><h6>Full Name</h6></div>
                <div class="col-md-4"><p id="name"></p></div>
                <div class="col-md-2"><h6>Email</h6></div>
                <div class="col-md-4"><p id="email"></p></div>
            </div>
            <div class="form-group row">
               <div class="col-md-2"><h6>City</h6></div>
                <div class="col-md-4"><p id="city"></p></div>
                <div class="col-md-2"><h6>Country</h6></div>
                <div class="col-md-4"><p id="country"></p></div>
            </div>
            <div class="form-group row">
               <div class="col-md-2"><h6>KYC Status</h6></div>
                <div class="col-md-4"><p id="kyc_status"></p></div>
                <!-- <div class="col-md-2"><h6>Risk Score</h6></div>
                <div class="col-md-4"><p id="risk_score"></p></div> -->
            </div>
            <div class="form-group row" id="assessment">
               
            </div>
        </div>
      <div class="modal-footer">
        <!-- <input type="submit" class="btn btn-primary" value="Save"> -->
      </div>
    </div>
  </div>
</div>
                                <!-- Detail Modal End -->
<script type="text/javascript">
   $(document).ready(function() {

      @if(Request::get('start') == null)
      $('#datePickerExample').hide();
      @endif

      $("#date_range").val("{{(Request::get('date_range') !== null) ? Request::get('date_range') : ''}}");
      
      $('#date_range').change(function(){
         let dateRange;
         dateRange = $('#date_range').val();
         if(dateRange == 'custom') {
            $('#datePickerExample').show();
         }else{
            $('#datePickerExample').hide();
            $('#start').val("");
            $('#end').val("");
         }
      });

      $(document).on("click", "#filter" , function() {
         var date_range = $('#date_range').val();
         var start = $('#start').val();
         var end = $('#end').val();
         window.location = '/administrator/customers-reporting?date_range='+date_range+'&start='+start+'&end='+end;
      });

      $(document).on("click", ".detail" , function() {
         var id = $(this).data('id');
         event.preventDefault();
		$.ajax({
			dataType: "json",
			url: "/administrator/private-customer-detail-ajax/"+id,
			type: "GET",
			success: function(response){
				if(response){
				  console.log(response);   
               $( "#assessment" ).empty();
					if(response['error'] == false){
						$('#name').html(response['results']['first_name'] + " " + response['results']['last_name']);
						$('#email').html(response['results']['email']);
						$('#city').html(response['results']['city']['name']);
						$('#country').html(response['results']['country']['name']);
                  if(response['results']['verification']['aml_status']){
                     $('#kyc_status').html(response['results']['verification']['aml_status']);
                  }else{
                     $('#kyc_status').html('-');
                  }
                  if(response['results']['response']['assessment']){
                     $("#assessment").html('<div class="col-md-12 h5 my-3">Required Documents</div>');
                     $.each(response['results']['response']['assessment'], function(key,val) {
                        $("#assessment").append('<div class="col-md-3 font-weight-bold">'+key+'</div> <div class="col-md-9 text-danger">'+val+'</div>');
                  });
                  }
                  
					}
					else if(response['error'] == true){
						$('#add-msg').html('<div class="alert alert-danger">' + response['message'] + '</div>');
					}else{
						$('#add-msg').html('<div class="alert alert-danger">JSON formate error!!</div>');
					}  
				}
			},
			error: function(){
				$('#add-msg').html('<div class="alert alert-danger">Something went wrong. Please try again later!</div>');
			}
         //    complete: function(){
         //       //  $('.save').val("Save");
         //    }
		});
         console.log(id);

      });

   });

   var units = @json($data['countByCountry']);
   google.charts.load('current', {
      'packages':['geochart'],
   });
   google.charts.setOnLoadCallback(drawRegionsMap);

   function drawRegionsMap() {
      var data = google.visualization.arrayToDataTable(units);
      var options = {
         sizeAxis: { minValue: 0, maxValue: 100 },
   //   region: '155', // Western Europe
      displayMode: 'auto',
      colorAxis: {colors: ['#66d1d1', '#031a61']}
      };

      var chart = new google.visualization.GeoChart(document.getElementById('regions_div'));

      chart.draw(data, options);
   }

   google.charts.load("current", {packages:["corechart"]});
   google.charts.setOnLoadCallback(drawChart);
   function drawChart() {

      var data = google.visualization.arrayToDataTable(units);

      var options = {
         title: 'Customers Percentage By Country',
         // pieHole: 0.3,
         is3D: true,
         // pieSliceText: 'label',
         // sliceVisibilityThreshold: .2,
         // width: 500,
         // height:350,
      };

      var chart = new google.visualization.PieChart(document.getElementById('donutchart'));
      chart.draw(data, options);
   }
</script>
@stop