@php
use App\Models\User\User;
use Carbon\Carbon;

$date1 = Carbon::parse($_GET['start_date']);
$date2 = Carbon::parse($_GET['end_date']);
$userType = $_GET['user_type'];
$files = User::where('is_admin', false)->whereBetween('created_at', [$date1, $date2]);
if($userType != 'all'){
    $files = $files->where('user_type', $userType);
}
$files = $files->orderBy('id', 'asc')->get();
$data = "
    <table>
        <thead>
            <tr>
                <th></th>
                <th colspan='7'>PERSONAL DETAILS</th>
                <th colspan='4'>FINANCIAL</th>
                <th colspan='7'>BIO DATA</th>
            </tr>
        </thead>
        <tbody>
            <tr>
                <th>SN</th>
                <th>UNIQUE ID</th>
                <th>FIRST NAME</th>
                <th>LAST NAME</th>
                <th>OTHER NAME</th>
                <th>PHONE NUMBER</th>
                <th>E-MAIL</th>
                <th>DATE JOINED</th>
                <th>BANK NAME</th>
                <th>BANK CODE</th>
                <th>ACCOUNT NAME</th>
                <th>ACCOUNT NUMBER</th>
                <th>DATE OF BIRTH</th>
                <th>GENDER</th>
                <th>ADDRESS</th>
                <th>MEANS OF ID</th>
                <th>IDENTITY NUMBER</th>
                <th>IDENTITY ISSUED AT</th>
                <th>IDENTITY EXPIRES AT</th>
            </tr>";
$i = 1;

$all_users = count($files);
$active_users = 0;
$restricted_users = 0;
$all_wallets = 0;

foreach($files as $file){

    if($file->is_active) $active_users += 1;
    else $restricted_users += 1;

    $data .= '<tr>';
    $data .= '<td>'.$i++.'</td>';
    $data .= '<td>'.$file->unique_id.'</td>';
    $data .= '<td>'.ucwords($file->first_name).'</td>';
    $data .= '<td>'.ucwords($file->last_name).'</td>';
    $data .= '<td>'.ucwords($file->other_name).'</td>';
    $data .= '<td>'.$file->mobile.'</td>';
    $data .= '<td>'.strtolower($file->email).'</td>';
    $data .= '<td>'.$file->created_at->format('F d, Y h:i A').'</td>';
    if($file->more != null){
        $data .= '<td>'.explode("||", $file->more->bank)[0].'</td>';
        $data .= '<td>'.explode("||", $file->more->bank)[1].'</td>';
        $data .= '<td>'.$file->more->account_name.'</td>';
        $data .= '<td>'.$file->more->account_number.'</td>';
        $data .= '<td>'.$file->more->dob.'</td>';
        $data .= '<td>'.$file->more->gender.'</td>';
        $data .= '<td>'.$file->more->address.'</td>';
        $data .= '<td>'.$file->more->means_of_id.'</td>';
        $data .= '<td>'.$file->more->id_number.'</td>';
        $data .= '<td>'.$file->more->id_date_issued.'</td>';
        $data .= '<td>'.$file->more->id_date_expired.'</td>';
    }else {
        $data .= '<td>-</td>';
        $data .= '<td>-</td>';
        $data .= '<td>-</td>';
        $data .= '<td>-</td>';
        $data .= '<td>-</td>';
        $data .= '<td>-</td>';
        $data .= '<td>-</td>';
        $data .= '<td>-</td>';
        $data .= '<td>-</td>';
        $data .= '<td>-</td>';
        $data .= '<td>-</td>';
    }

    $data .= '</tr>';
}

$data .= '<tr></tr>';
$data .= '<tr></tr>';
$data .= '<tr><td colspan="4"><strong>Totals</strong></td></tr>';
$data .= '<tr><td colspan="2"><strong>All Users</strong></td><td colspan="2"><strong>'.$all_users.'</strong></td></tr>';
$data .= '<tr><td colspan="2"><strong>Active Users</strong></td><td colspan="2"><strong>'.$active_users.'</strong></td></tr>';
$data .= '<tr><td colspan="2"><strong>Restricted Users</strong></td><td colspan="2"><strong>'.$restricted_users.'</strong></td></tr>';

$data .= "</tbody></table>";
@endphp
{!! $data !!}