@php $si=0; @endphp @foreach($AnnualMemberSubscriptions as $AnnualMemberSubscription) @php // Joining Date $DTs=""; $TotYears=0; $Amount=0; $OpeningBalance=0; $Payable=0; $Payed=0; $AdBal=0; $DTs = date("Y-m-d",strtotime($AnnualMemberSubscription->Date)); $TodayDate=date("Y-m-d"); $TodayDate = date('Y-m-d'); if (strtotime($DTs) < strtotime($TodayDate)) { $NOW = Carbon\Carbon::now(); $year1 = Carbon\Carbon::parse($AnnualMemberSubscription->Date); $year2 = Carbon\Carbon::parse($NOW); // Calculate the difference in years $TotYears = $year1->diffInYears($year2); } $Amount = App\Models\AnnualMemberSubscription::find($AnnualMemberSubscription->SubscriptionID)->subscriptionpackage->amount; if ($AnnualMemberSubscription->DRorCR == 'Dr') { $OpeningBalance = $AnnualMemberSubscription->OB; } elseif ($AnnualMemberSubscription->DRorCR == 'Cr') { $OpeningBalance = -1 * $AnnualMemberSubscription->OB; } // Payable Caliculation if (is_numeric($TotYears)) { if ($OpeningBalance > 0) { $Payable = $TotYears * $Amount + $OpeningBalance; } else { $Payable = $TotYears * $Amount; } } // Payed Caliculation foreach(App\Models\AnnualMemberSubscription::find($AnnualMemberSubscription->SubscriptionID)->AnnualMemberSubscriptionPayment->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 @if ($AnnualMemberSubscription->Photo) @else @endif @endforeach

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