@extends('admin.admin_dashboard')
@section('admin')
    @php

        /*

        //old logic

use Carbon\Carbon;

$subscriptions = App\Models\Payment::with(['subscription', 'user'])
    ->where('purpose', 'subscription')
    ->where(function ($query) {
        $query->where(function ($q) {
            $q->where('coupon', 'LWFS')
            ->where('created_at', '>', Carbon::parse('2025-06-30')->endOfDay());
        })->orWhere(function ($q) {
            $q->whereNull('coupon')
            ->where('created_at', '>', Carbon::parse('2025-06-30')->endOfDay())
              ->whereHas('user', function ($u) {
                  $u->where('zone', 'LWFS');
              });
        });
    })
    ->latest()
    ->get();



    $monthlySums = $subscriptions->groupBy(function ($item) {
    return Carbon::parse($item->created_at)->format('F Y');
    })->map(function ($items, $month) {
    return [
        'month' => $month,
        'total' => $items->sum('total_amount'), 
    ];
   });

   */
    @endphp







    @php

        use Carbon\Carbon;

        $subscriptions = App\Models\Payment::with(['subscription', 'user'])
            ->where('purpose', 'subscription')
            ->where(function ($query) {
                $query
                    ->where(function ($q) {
                        $q->where('coupon', 'LWFS')->where('created_at', '>', Carbon::parse('2025-06-30')->endOfDay());
                    })
                    ->orWhere(function ($q) {
                        $q->whereNull('coupon')
                            ->where('created_at', '>', Carbon::parse('2025-06-30')->endOfDay())
                            ->whereHas('user', function ($u) {
                                $u->where('zone', 'LWFS');
                            });
                    });
            })
            ->latest()
            ->get();

        // Conversion rates to Espees (per 1 unit of currency)  <-- added this block
        $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
        ];

        $monthlySums = $subscriptions
            ->groupBy(function ($item) {
                return Carbon::parse($item->created_at)->format('F Y');
            })
            ->map(function ($items, $month) use ($conversionRates) {
                // <-- passed $conversionRates into closure
                return [
                    'month' => $month,

                    // Convert each payment’s total_amount to Espees before summing  <-- updated this line
                    'total' => $items->sum(function ($payment) use ($conversionRates) {
                        $currency = strtoupper($payment->currency ?? 'ESPEES'); // handle missing currency safely
                        $rate = $conversionRates[$currency] ?? 1; // default to 1 if unknown
                        return $payment->total_amount * $rate; // convert to Espees
                    }),
                ];
            });

    @endphp









    @php

        /*
//old purchase logic

   $purchases = App\Models\Payment::with(['user', 'purchase', 'orders'])
    ->whereIn('purpose', ['ebook purchase', 'print book purchase'])
    ->where(function ($query) {
        $query->where(function ($q) {
            $q->where('coupon', 'LWFS')
            ->where('created_at', '>', Carbon::parse('2025-06-30')->endOfDay());
        })->orWhere(function ($q) {
            $q->whereNull('coupon')
            ->where('created_at', '>', Carbon::parse('2025-06-30')->endOfDay())
              ->whereHas('user', function ($u) {
                  $u->where('zone', 'LWFS');
              });
        });
    })
    ->latest()
    ->get();


   


    $purchaseMonthlySums = $purchases->groupBy(function ($item) {
       return Carbon::parse($item->created_at)->format('F Y');
    })->map(function ($items, $month) {
       return [
           'month' => $month,
           'total' => $items->sum(function ($purchase) {
               return $purchase->purpose === 'print book purchase'
                   ? $purchase->total_amount * 0.75
                   : $purchase->total_amount;
           }),
       ];
   });


   */
    @endphp














    <div class="page-content">

        <!--breadcrumb-->
        <div class="page-breadcrumb d-none d-sm-flex align-items-center mb-3">
            <div class="ps-3">
                <nav aria-label="breadcrumb">
                    <ol class="breadcrumb mb-0 p-0">

                        <li class="breadcrumb-item">
                            <a href="{{ route('admin.dashboard') }}"> <i class="bx bx-home-alt"> </i> </a>
                        </li>

                        <li class="breadcrumb-item active" aria-current="page"> Commissions </li>

                    </ol>
                </nav>
            </div>
            <div class="ms-auto">

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






        <div class="container-fluid">





            <!--Subscription Starts -->
            <div class="row">

                <div class="col-xl-12">
                    <div class="card">
                        <div class="card-body">


                            <h4 class="card-title mb-4"> Subscription Commissions </h4>

                            <p class=""> Total Commission [30%] = Net Commission [25%] + Coupon Code Discount [5%]
                            </p>

                            <div class="table-responsive">




                                <table id="datatable" class="table table-bordered 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> Net Commission Amount ( 25% ) </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.25, 2) }} Espees </td>

                                                <td> </td>

                                            </tr>
                                        @endforeach

                                        <!-- end -->




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

                        </div><!-- end card -->
                    </div><!-- end card -->
                </div>
                <!-- end col -->

            </div>
            <!--Subscriptions ends --> <!-- end row -->




            {{--
         @if (Auth::user()->can('lwfs.purchase'))
           <!--Purchases Starts -->
           <div class="row">

            <div class="col-xl-12">
                <div class="card">
                    <div class="card-body">
                       

                        <h4 class="card-title mb-4"> Purchase Commissions </h4>

                         <p class=""> Commission [5%] </p>

                        <div class="table-responsive">

                            
         
                        <table id="datatable" class="table table-bordered 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 Purchase Amount </th>
                                        <th> Net Commission Amount ( 5 % )  </th>
                                      
                                       
                                        
                                    </tr>
                                </thead><!-- end thead -->


                                <tbody>

                                  
                                   @php $i = 1; @endphp

                                   @foreach ($purchaseMonthlySums as $summary)

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

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

                                     <td>  </td>

                                   </tr>

                                  @endforeach

                                     <!-- end -->

                                    

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

                    </div><!-- end card -->
                </div><!-- end card -->
            </div>
            <!-- end col -->

           </div>
          <!--Purchases ends --> <!-- end row -->
          @endif
          --}}



















        </div>






    </div>
@endsection