@extends('user.user_dashboard')
@section('home')
    @php

        use Carbon\Carbon;

        // Authenticated user
        $my_username = auth()->user()->username;

        // All users referred by this user
        $referredUsers = App\Models\User::where('referred_by', $my_username)->get();

        // All users subscriptions referred by this user
        $subscriptions = App\Models\Payment::with(['subscription', 'user'])
            ->where('purpose', 'subscription')
            ->whereNull('coupon')
            ->whereHas('user', function ($query) use ($my_username) {
                $query->where('referred_by', $my_username);
            })
            ->latest()
            ->get();

        /*
        //Monthly sum
        $monthlySums = $subscriptions
            ->groupBy(function ($subscription) {
                // Group by month and year: "July 2025", "August 2025", etc.

                return Carbon::parse($subscription->created_at)->format('F Y');
            })
            ->map(function ($groupedSubscriptions, $month) {
                return [
                    'month' => $month,
                    'total' => $groupedSubscriptions->sum('total_amount'),
                ];
            })
            ->values(); // Optional: to reset keys to 0, 1, 2...

       */


        // Monthly sum (converted to Espees)
        $monthlySums = $subscriptions
            ->groupBy(function ($subscription) {
                // Group by month and year
                return Carbon::parse($subscription->created_at)->format('F Y');
            })
            ->map(function ($groupedSubscriptions, $month) {
                // Conversion rates to Espees (per 1 unit of currency)
                $conversionRates = [
                    'ESPEES' => 1,
                    'ESPEES-VOUCHER' => 1,
                    'USD' => 1 / 1.25, // 0.8 Espees
                    'GBP' => 1 / 1, // 1.0 Espee
                    'CAD' => 1 / 1.7, // 0.588 Espees
                    'EUR' => 1 / 1.15, // 0.869 Espees
                    'ZAR' => 1 / 23, // 0.043 Espees
                    'NGN' => 1 / 2050, // 0.000488 Espees
                ];

                // Convert each payment to Espees before summing
                $totalInEspees = $groupedSubscriptions->sum(function ($sub) use ($conversionRates) {
                    $currency = strtoupper($sub->currency ?? 'ESPEES');
                    $rate = $conversionRates[$currency] ?? 1;
                    return $sub->total_amount * $rate;
                });

                return [
                    'month' => $month,
                    'total' => $totalInEspees,
                ];
            })
            ->values();


    @endphp













    <!-- ================================
                START BREADCRUMB AREA
            ================================= -->
    <section class="breadcrumb-area section-padding img-bg-2 ">
        <div class="overlay"></div>

        <div class="container">

            <div class="breadcrumb-content d-flex flex-wrap align-items-center justify-content-between">




                <div class="section-heading">
                    <h2 class="section__title text-white"> <a href="{{ route('dashboard.referral') }}"> <i
                                class="la la-chevron-left icon text-white"> </i> </a> Influencer Dashboard &nbsp; &nbsp;
                        &nbsp; </h2>
                </div>

                <ul
                    class="generic-list-item generic-list-item-white generic-list-item-arrow d-flex flex-wrap align-items-center">
                    <li> <a href="{{ route('dashboard') }}"> Dashboard </a> </li>
                    <li> <a href="{{ route('dashboard.referral') }}"> Referrals </a> </li>
                    <li> <a href="{{ route('referral.influencer.dashboard') }}"> Influencer Dashboard </a> </li>
                </ul>


            </div><!-- end breadcrumb-content -->



        </div><!-- end container -->
    </section><!-- end breadcrumb-area -->
    <!-- ================================
               END BREADCRUMB AREA
            ================================= -->


    <div class="container-fluid py-5">


        <div class="card mt-3 mb-5">
            <div class="card-body">

                <h4 class="my-2"> My Registered Users </h4>

                <div class="table-responsive">
                    {{--  <table id="example" class="table table-striped table-bordered" style="width:100%"> --}}
                    <table id="datatable" class="table table-bordered table-hover table-striped dt-responsive nowrap"
                        style="border-collapse: collapse; border-spacing: 0; width: 100%;">

                        <thead>
                            <tr>
                                <th>s/n </th>
                                <th> Name </th>
                                <th> Dated Signed up </th>
                                <th> Subscription Status </th>

                            </tr>
                        </thead>

                        <tbody>


                            @foreach ($referredUsers as $key => $user)
                                @php
                                    $UserSubscription = $user
                                        ->subscriptions()
                                        ->where('status', 'active')
                                        ->where('end_date', '>', now())
                                        ->latest()
                                        ->first();
                                @endphp



                                <tr>
                                    <td> {{ $key + 1 }} </td>
                                    <td>{{ $user->title }} {{ $user->firstname }} {{ $user->surname }}</td>
                                    <td>{{ $user->created_at->format('F j, Y, g:i A') }}</td>
                                    <td>
                                        @if ($UserSubscription)
                                            <span class="badge bg-success"> Subscribed </span>
                                        @else
                                            <span class="badge bg-danger"> Unsubscribed </span>
                                        @endif
                                    </td>


                                </tr>
                            @endforeach



                        </tbody>



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




        <div class="card mt-3 mb-5">
            <div class="card-body">

                <h4 class="my-2"> Users Subscriptions </h4>



                <div class="table-responsive">
                    {{--  <table id="example" class="table table-striped table-bordered" style="width:100%"> --}}
                    <table id="datatable" class="table table-bordered table-hover table-striped dt-responsive nowrap"
                        style="border-collapse: collapse; border-spacing: 0; width: 100%;">

                        <thead>
                            <tr>
                                <th> s/n </th>
                                <th> Fullname </th>
                                <th> Subscription_Amount </th>
                                <th> Subscription_Name </th>
                                <th> Subscription_Duration </th>
                                <th> Subscription_Date </th>

                            </tr>
                        </thead>

                        <tbody>

                            @foreach ($subscriptions as $key => $subscription)
                                <tr>

                                    <td> {{ $key + 1 }} </td>
                                    <td> {{ $subscription->user->title }} {{ $subscription->user->firstname }}
                                        {{ $subscription->user->surname }} </td>
                                    <td> {{ $subscription->total_amount }} {{ $subscription->currency }} </td>
                                    <td> {{ $subscription->subscription->subscription_name }} </td>
                                    <td> {{ $subscription->subscription->subscription_duration }} </td>
                                    <td> {{ \Carbon\Carbon::parse($subscription->subscription->start_date)->format('Y F jS - h:ia') }}
                                    </td>



                                </tr>
                                <!-- end -->
                            @endforeach

                        </tbody>



                    </table>
                </div>



            </div>
        </div>





        <div class="card mt-3 mb-5">
            <div class="card-body">

                <h4 class="my-2"> Monthly Commissions </h4>

                <p class="mb-2"> Commission is 30% of Total Users Subscription Amount </p>


                <div class="table-responsive">

                    {{--  <table id="example" class="table table-striped table-bordered" style="width:100%"> --}}
                    <table id="datatable" class="table table-bordered table-hover table-striped dt-responsive nowrap"
                        style="border-collapse: collapse; border-spacing: 0; width: 100%;">

                        {{-- <table class="table table-centered mb-0 align-middle table-hover table-nowrap" > --}}

                        <thead class="table-light">
                            <tr>

                                <th> s/n </th>
                                <th> Month </th>
                                <th> Total Subscription Amount </th>
                                <th> Commission Amount ( 30% ) </th>

                            </tr>
                        </thead><!-- end thead -->


                        <tbody>


                            @php $i = 1; @endphp

                            @foreach ($monthlySums as $summary)
                                <tr>

                                    <td>{{ $i++ }}</td>

                                    <td> {{ $summary['month'] }}</td>


                                    <td> {{ number_format($summary['total'], 2) }} Espees </td>

                                    <td> {{ number_format($summary['total'] * 0.3, 2) }} Espees </td>

                                    <td> </td>

                                </tr>
                            @endforeach

                            <!-- end -->




                        </tbody><!-- end tbody -->
                    </table> <!-- end table -->
                </div>
            </div>
        </div>
















    </div>
@endsection