@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 = App\Models\SubscriptionPackage::find($AnnualHouseSubscription->SubscriptionPackageID) ->amount; if ($AnnualHouseSubscription->DRorCR == 'Dr') { $OpeningBalance = $AnnualHouseSubscription->OB; } elseif ($AnnualHouseSubscription->DRorCR == 'Cr') { $OpeningBalance = -1 * $AnnualHouseSubscription->OB; } // Payable Calculation if (is_numeric($TotYears)) { if ($OpeningBalance > 0) { $Payable = ($TotYears*$Amount)+$OpeningBalance; } else { $Payable = $TotYears * $Amount; } } // Payed Calculation foreach ( App\Models\AnnualHouseSubscription::find($AnnualHouseSubscription->SubscriptionID) ->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 (App\Models\House::find($AnnualHouseSubscription->HouseID)->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->HouseName }} - {{ $Member->name }}{{ $AnnualHouseSubscription->HouseNo }} {{ $AnnualHouseSubscription->Place }} {{ $DTs }} @if ($OpeningBalance < 0) @currency($OpeningBalance * -1) @elseif($OpeningBalance > 0) @currency($OpeningBalance) @else @currency($OpeningBalance) @endif @currency(App\Models\SubscriptionPackage::find($AnnualHouseSubscription->SubscriptionPackageID)->amount ?? '0') {{ $TotYears }} {{ $Payable }} {{ $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 => $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 = App\Models\SubscriptionPackage::find($AnnualHouseSubscription->SubscriptionPackageID) ->amount; if ($AnnualHouseSubscription->DRorCR == 'Dr') { $OpeningBalance = $AnnualHouseSubscription->OB; } elseif ($AnnualHouseSubscription->DRorCR == 'Cr') { $OpeningBalance = -1 * $AnnualHouseSubscription->OB; } // Payable Calculation if (is_numeric($TotYears)) { if ($OpeningBalance > 0) { $Payable = ($TotYears*$Amount)+$OpeningBalance; } else { $Payable = $TotYears * $Amount; } } // Payed Calculation foreach ( App\Models\AnnualHouseSubscription::find($AnnualHouseSubscription->SubscriptionID) ->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