@foreach ($plans as $key=>$plan) @if($plan->created_at >= '2023-10-26 00:00:00') @php $gst_amount = $plan->total_amount - ($plan->total_amount * 100) /118; @endphp @else @if ($plan->payment_detail != null && $plan->payment_detail != 'Updated by Admin') @else @endif @endif @if($plan->created_at >= '2023-10-26 00:00:00') @php $gst_amount = $plan->total_amount - ($plan->total_amount * 100) /118; @endphp @if($plan->user?->state == 'Uttar Pradesh') @else @endif @else @endif @endforeach

Invoice ID	Date	Transaction ID	Total Amount	Amount	CGST (9%)	SGST (9%)	IGST (18%)	Purchase Type	Package Name	Name	Email	Phone	State	Pan Number	Referral	Sponsor Name	Sponsor Referral Code
{{$plan->invoice_id}}	{{$plan->created_at->format('d-m-Y h:i A')}}	@if ($plan->payment_detail != null && $plan->payment_detail != 'Updated by Admin') {{json_decode($plan->payment_detail)->id}} @endif	{{$plan->total_amount}} {{-- @if ($plan->payment_detail != null && $plan->payment_detail != 'Updated by Admin') {{json_decode($plan->payment_detail)->amount}} @else 0 @endif --}}	{{ round($plan->total_amount-$gst_amount,2) }}	{{json_decode($plan->payment_detail)->amount}}	0	{{ round($gst_amount/2,2) }}	{{ round($gst_amount/2,2) }}				{{ round($gst_amount,2) }}				@if($plan->amount == $plan->plan->amount) New Plan @else Upgrade Plan @endif	{{$plan->plan->title}}	{{$plan->user?->name}}	{{$plan->user?->email}}	{{$plan->user?->phone}}	{{$plan->user?->state}}	{{optional($plan->user?->bankDetail)->pan_number}}	{{$plan->user?->referrer_code}}	{{optional($plan->user?->sponsorDetail)->name}}	{{optional($plan->user?->sponsorDetail)->referrer_code}}