@php $si=0; @endphp @foreach ($ArMember as $key => $Member) @php // Joining Date $DTs=""; $TotMonth=0; $Amount=0; $OpeningBalance=0; $Payable=0; $Payed=0; $AdBal=0; $DTs = date("Y-m-d",strtotime($Member->Date)); $TodayDate=date("Y-m-d"); if(strtotime($DTs)Date); $month2 = Carbon\Carbon::parse($NOW); $TotMonth = $month1->diffInMonths($month2); } $Amount = App\Models\MemberSubscription::find($Member->SubscriptionID)->subscriptionpackage->amount; if ($Member->DRorCR == 'Dr') { $OpeningBalance = $Member->OB; } elseif ($Member->DRorCR == 'Cr') { $OpeningBalance = -1 * $Member->OB; } // Payable Caliculation if (is_numeric($TotMonth)) { if ($OpeningBalance > 0) { $Payable = $TotMonth * $Amount + $OpeningBalance; } else { $Payable = $TotMonth * $Amount; } } // Payed Caliculation foreach(App\Models\MemberSubscription::find($Member->SubscriptionID)->MemberSubscriptionPayment->where('isCancelled',0) as $Subscription) { if($Subscription->isCancelled!=1) { $Payed+=$Subscription->amount; } } // Advance Or Balance Caliculation if ($OpeningBalance < 0) { $AdBal = $Payable - $Payed + $OpeningBalance; } else { $AdBal = $Payable - $Payed; } @endphp @endforeach

{{__('lng.SiNo')}}	{{__('lng.Member')}}	{{__('lng.Contact')}}	{{__('lng.HouseName')}}	{{__('lng.Reg.No.')}}	{{__('lng.SubscriptionDateOfJoin')}}	{{__('lng.OpeningBalance')}} {{__('lng.Pending')}}/{{__('lng.Advance')}}	{{__('lng.MonthlyAmount')}}	{{__('lng.Month')}}	{{__('lng.Payable')}}	{{__('lng.Payed')}}	{{__('lng.Balance')}}/{{__('lng.Advance')}}
{{++$si}}	{{$Member->Name}}	{{$Member->Contact}}	{{$Member->HouseName}}	{{$Member->HouseNo}}	{{$DTs}}	@if($OpeningBalance<0) @currency($OpeningBalance*-1) @elseif($OpeningBalance>0) @currency($OpeningBalance) @else @currency($OpeningBalance) @endif	@currency($Amount)	{{$TotMonth}}	{{$Payable}}	{{$Payed}}	@if($AdBal<0) @currency($AdBal*-1) @elseif($AdBal>0) @currency($AdBal) @else @currency($AdBal) @endif