@php $si=0; @endphp @foreach ($ArHouse as $key => $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
@csrf @php $no=0; @endphp @foreach ($ArHouse as $key => $HouseSubscription) @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 @endforeach
@csrf