@php $si=0; @endphp @foreach ($ArHouse as $key => $HouseSubscription) @php // Joining Date $DTs=""; $TotMonth=0; $Amount=0; $OpeningBalance=0; $Payable=0; $Payed=0; $AdBal=0; // if($HouseSubscription) { $DTs = date("Y-m-d",strtotime($HouseSubscription->date)); $TodayDate=date("Y-m-d"); if(strtotime($DTs)date); $month2 = Carbon\Carbon::parse($NOW); $TotMonth = $month1->diffInMonths($month2); } // $TotMonth = $diff-$NOWDate; $Amount = $HouseSubscription->subscriptionpackage->amount; if($HouseSubscription->DRorCR == 'Dr'){ $OpeningBalance = $HouseSubscription->openingbalance; } elseif($HouseSubscription->DRorCR == 'Cr') { $OpeningBalance = -1 * $HouseSubscription->openingbalance; } // } // Payable Caliculation if (is_numeric($TotMonth)) { if($OpeningBalance > 0){ $Payable = ($TotMonth*$Amount)+$OpeningBalance; } else{ $Payable = $TotMonth*$Amount; } } // Payed Caliculation foreach($HouseSubscription->house->subscriptions 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($HouseSubscription->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.Month') }} {{ __('lng.Payable') }} {{ __('lng.Payed') }} {{ __('lng.Balance') }}/{{ __('lng.Advance') }}
{{ ++$si }}{{$HouseSubscription->house->name}} - {{$Member->name}}{{$HouseSubscription->house->registernumber}} {{$HouseSubscription->house->place}} {{$DTs}} @if ($OpeningBalance < 0) @currency($OpeningBalance * -1) @elseif($OpeningBalance > 0) @currency($OpeningBalance) @else @currency($OpeningBalance) @endif @currency($HouseSubscription->subscriptionpackage->amount ?? '0') {{$TotMonth}} @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=""; $TotMonth=0; $Amount=0; $OpeningBalance=0; $Payable=0; $Payed=0; $AdBal=0; // if($HouseSubscription) { $DTs = date("Y-m-d",strtotime($HouseSubscription->date)); $TodayDate=date("Y-m-d"); if(strtotime($DTs)date); $month2 = Carbon\Carbon::parse($NOW); $TotMonth = $month1->diffInMonths($month2); } // $TotMonth = $diff-$NOWDate; $Amount = $HouseSubscription->subscriptionpackage->amount; if($HouseSubscription->DRorCR == 'Dr'){ $OpeningBalance = $HouseSubscription->openingbalance; } elseif($HouseSubscription->DRorCR == 'Cr') { $OpeningBalance = -1 * $HouseSubscription->openingbalance; } // } // Payable Caliculation if (is_numeric($TotMonth)) { if($OpeningBalance > 0){ $Payable = ($TotMonth*$Amount)+$OpeningBalance; } else{ $Payable = $TotMonth*$Amount; } } // Payed Caliculation foreach($HouseSubscription->house->subscriptions 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