@php $si=0; @endphp @foreach($AnnualHouseSubscriptions as $AnnualHouseSubscription) @php // Joining Date $DTs=""; $TotYears=0; $Amount=0; $OpeningBalance=0; $Payable=0; $Payed=0; $AdBal=0; $DTs = date("Y-m-d",strtotime($AnnualHouseSubscription->date)); $TodayDate = date("Y-m-d"); if (strtotime($DTs) < strtotime($TodayDate)) { $NOW = Carbon\Carbon::now(); $year1 = Carbon\Carbon::parse($AnnualHouseSubscription->date); $year2 = Carbon\Carbon::parse($NOW); // Calculate the difference in years $TotYears = $year1->diffInYears($year2); } $Amount = $AnnualHouseSubscription->subscriptionpackage->amount; if($AnnualHouseSubscription->DRorCR == 'Dr'){ $OpeningBalance = $AnnualHouseSubscription->openingbalance; } elseif($AnnualHouseSubscription->DRorCR == 'Cr') { $OpeningBalance = -1 * $AnnualHouseSubscription->openingbalance; } // Payable Caliculation if (is_numeric($TotYears)) { if($OpeningBalance > 0){ $Payable = ($TotYears*$Amount)+$OpeningBalance; } else{ $Payable = $TotYears*$Amount; } } // Payed Caliculation foreach($AnnualHouseSubscription->AnnualHouseSubscriptionPayment as $Subscriptionpay) { if($Subscriptionpay->isCancelled!=1) { $Payed+=$Subscriptionpay->amount; } } // Advance Or Balance Caliculation if($OpeningBalance < 0){ $AdBal=($Payable-$Payed)+$OpeningBalance; } else { $AdBal=$Payable-$Payed; } @endphp @foreach($AnnualHouseSubscription->house->members as $Member) @if($Member->member_relation_id == App\Extra\General\DBFixedValues::AUTHORITY) @endif @endforeach @endforeach

{{__('lng.SiNo')}}	{{__('lng.Authority')}}	{{__('lng.Reg.No.')}}	{{__('lng.Place')}}	{{__('lng.SubscriptionDateOfJoin')}}	{{__('lng.OpeningBalance')}} {{__('lng.Pending')}}/{{__('lng.Advance')}}	{{__('lng.Amount')}}	{{__('lng.Year')}}	{{__('lng.Payable')}}	{{__('lng.Payed')}}	{{__('lng.Balance')}}/{{__('lng.Advance')}}
{{++$si}}	{{$AnnualHouseSubscription->house->name}} - {{$Member->name}}	{{$AnnualHouseSubscription->house->registernumber}}	{{$AnnualHouseSubscription->house->place}}	{{$DTs}}	@if($OpeningBalance<0) @currency($OpeningBalance*-1) @elseif($OpeningBalance>0) @currency($OpeningBalance) @else @currency($OpeningBalance) @endif	@currency($AnnualHouseSubscription->subscriptionpackage->amount ?? '0')	{{$TotYears}}	@currency($Payable)	@currency($Payed)	@if($AdBal<0) @currency($AdBal*-1) @elseif($AdBal>0) @currency($AdBal) @else @currency($AdBal) @endif