@extends('layouts.admin')
@php
$joinedEvents = $member && $member->eventPayment ? $member->eventPayment->where('plan_type', 'member')->values() : null;
$hostPayments = $member && $member->singlePayments ? $member->singlePayments->where('plan_type', 'host') : null;
$joinedChallenges = $member->userScore
? $member?->userScore()?->whereHas('challenge', function ($q) {
$q->withoutGlobalScope(LatestDataScope::class); // remove global scope
})
?->searchChallenge()
?->whereNotNull('challenge_id')
?->whereNull('event_id')
?->whereNotNull('total_score')
?->with(['challenge' => function ($q) {
$q->withoutGlobalScope(LatestDataScope::class);
}])
?->get()
?->sortByDesc(function ($score) {
return optional($score->challenge)->start_date;
})->values()
: null;
@endphp
@section('content')
{{ totalNewRafMembersForHostOfCompletedEvents($member) }} 0
{{-- {{ getHostNewRAfMembers($member) }} --}}
N/A
{{-- {{ getPaidRevShareOfHost($member) }} --}}
${{ number_format(getTotalEventRevenueByHost($member), 2) }}
{{ $member ? $userType : 'Add Member' }}
Joined Challenges
Joined Events
@foreach ($joinedEvents as $index => $payment)
SNo.
Event Code
Event Name
Event Fee
Hosted By
Transaction ID
Date of Joined
@endforeach
{{ $index + 1 }}
{{ $payment->event->event_code ?? 'N/A' }}
{{ $payment->event->event_name ?? 'N/A' }}
{{ $payment->event->event_fee ? '$' . number_format($payment->event->event_fee , 2) : 'N/A' }}
{{ $payment->event->hosted_by ?? 'N/A' }}
{{ $payment->event ? (getPaymentForJoinedEvent($member, $payment->event->id)[0]['transcation_id'] ?? 'N/A') : 'N/A' }}
{{ $payment ? \Carbon\Carbon::parse($payment->created_at)->format('m/d/Y') : 'N/A' }}
Event's Payment Details
@foreach ($hostPayments as $index => $item)
SNo.
Event Code
Event Name
Event Fee
Transaction ID
@endforeach
{{ $index + 1 }}
{{-- {{ $item->event->event_code ?? 'N/A' }}
--}}
{{ @$item->event->event_code ?? 'N/A' }}
{{ @$item->event->event_name ?? 'N/A' }}
{{ $item->total_amount ? '$'.number_format($item->total_amount , 2) : 'N/A' }}
{{ @$item->transcation_id ?? 'N/A' }}
Rev-share | Revenue Details
Total No. of Active Members
Total Rev-share $ Generated Since Becoming a Host
{{-- {{ $item->event->event_code ?? 'N/A' }}
--}}
Total No. of Rev-share Members in Group
Total Rev-share $ generated
{{-- Total Rev-share $ paid --}}
Date Paid
{{-- Total Rev-share $ due --}}
Payment Receipt
Event Revenue Details
Total Event Revenue
@foreach ($member->events as $index => $event)
SNo.
Event code
Event start date
Event end date
No. of Participants
No. of New RAF Members
Total Event Revenue
Date Paid
Payment Receipt
@endforeach
{{ $index + 1 }}
{{ $event->event_code ?? 'N/A' }}
{{ \Carbon\Carbon::parse($event->start_date)->format('m/d/Y') ?? 'N/A' }}
{{ \Carbon\Carbon::parse($event->end_date)->format('m/d/Y') }}
{{ $event->totalEventRevenue->count() ?? 'N/A' }}
{{ $event->newRafMembers->count() ?? 'N/A' }}
{{ '$' . number_format($event->totalEventRevenue->sum('amount') , 2) ?? 'N/A' }}
{{ $event->hostPayoutByEventRevenue->first() ? $event->hostPayoutByEventRevenue->first()->payout_date->format('m/d/Y') : 'N/A' }}
@if ($event && isPayoutExistForEventRevenue($event->id))
Paid
@else
Pending
@endif
Subscriptions
@foreach ($member->payment as $key => $payment)
@php
$cancelledDate = getSubscriptionCanceledDate($payment);
@endphp
SNo.
Plan Name
Plan Type
Status
Amount
Date
Cancelled
@endforeach
{{ $key + 1 }}
{{ $payment->plan->name ?? 'N/A' }}
{{ ucfirst($payment->plan->time_type ?? 'N/A') }}
@if($cancelledDate == null)
Active
@else
Cancelled
@endif
${{ $payment->amount ?? '0' }}
{{-- {{ @$member->payment()->first()->transcation_id ?? 'N/A' }} --}}
@php
$date = $payment->renew_at != null ? $payment->renew_at : $payment->created_at;
@endphp
{{ \Carbon\Carbon::parse($date)->format('m/d/Y') ?? 'N/A' }}
{{ $cancelledDate ?? 'N/A' }}