@extends('admin.admin_dashboard')
@section('admin')
    @php
    /*
    //old logic

        use Carbon\Carbon;

        // my zone
        $my_zone = auth()->user()->ce_zone;

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

    */
    @endphp




   @php

        use Carbon\Carbon;

        // my zone
        $my_zone = auth()->user()->ce_zone;

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

    @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"> Registered User Purchases </li>

                    </ol>
                </nav>
            </div>
            <div class="ms-auto">
                <div class="btn-group">
                    @if (Auth::user()->can('zone.commission'))
                        <a href="{{ route('zone.commission') }}" class="btn btn-primary px-5"> Zone - Commissions
                        </a>
                    @endif
                </div>
            </div>
        </div>
        <!--end breadcrumb-->






        <div class="container-fluid">





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

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


                            <h4 class="card-title mb-4"> {{ $my_zone }} - User Purchases </h4>

                            <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> Zone </th>
                                            <th> Registered User Fullname </th>
                                            <th> Purchase_Amount </th>
                                            <th> Purchased_Item </th>
                                            <th> Product_Name </th>
                                            <th> Purchase_Date </th>




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


                                    <tbody>


                                        @foreach ($purchases as $key => $purchase)
                                            @if ($purchase->user)
                                                <tr>

                                                    <td> {{ $key + 1 }} </td>
                                                    <td> {{ $purchase->user->ce_zone }} </td>
                                                    <td> {{ $purchase->user->title }} {{ $purchase->user->firstname }}
                                                        {{ $purchase->user->surname }} </td>



                                                    @if ($purchase->purpose == 'ebook purchase')
                                                        <td>{{ number_format($purchase->total_amount, 2) }}
                                                            {{ $purchase->currency }}</td>
                                                    @elseif ($purchase->purpose == 'print book purchase')
                                                        <td>{{ number_format($purchase->total_amount * 0.75, 2) }}
                                                            {{ $purchase->currency }}</td>
                                                    @endif




                                                    <td> {{ $purchase->purpose }} </td>


                                                    <td>
                                                        @if ($purchase->purchase)
                                                            {{ $purchase->purchase->product_name }}
                                                        @elseif ($purchase->orders)
                                                            {{ $purchase->orders->pluck('product_name')->implode(', ') }}
                                                        @endif
                                                    </td>


                                                    <td> {{ \Carbon\Carbon::parse($purchase->created_at)->format('Y F jS - h:ia') }}
                                                    </td>




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








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

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

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



















        </div>






    </div>
@endsection