{{ __('lng.Subscription') }}

@php $si=0; @endphp @foreach ($HouseSubscriptions as $HouseSubscription) @php // Joining Date $DTs = ''; $TotMonth = 0; $Amount = 0; $OpeningBalance = 0; $Payable = 0; $Payed = 0; $AdBal = 0; $DTs = date('Y-m-d', strtotime($HouseSubscription->date)); $TodayDate = date('Y-m-d'); if (strtotime($DTs) < strtotime($TodayDate)) { $NOW = Carbon\Carbon::now(); $NOWDate = date('m', strtotime($NOW)); $month1 = Carbon\Carbon::parse($HouseSubscription->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) @if ($Member->photo) @else @endif @endif @endforeach @endforeach

{{ __('lng.SiNo') }}	{{ __('lng.Action') }}	{{ __('lng.Authority') }}	{{ __('lng.Contact') }}	{{ __('lng.Reg.No.') }}	{{ __('lng.OpeningBalance') }} {{ __('lng.Pending') }}/{{ __('lng.Advance') }}	{{ __('lng.Amount') }}	{{ __('lng.Month') }}	{{ __('lng.Payable') }}	{{ __('lng.Payed') }}	{{ __('lng.Balance') }}/{{ __('lng.Advance') }}
{{ ++$si }}		{{$HouseSubscription->house->name}} - {{$Member->name}}	{{$Member->contact}}	{{$HouseSubscription->house->registernumber}}	@if($OpeningBalance<0) @currency($OpeningBalance*-1) @elseif($OpeningBalance>0) @currency($OpeningBalance) @else @currency($OpeningBalance) @endif	@currency($HouseSubscription->subscriptionpackage->amount ?? '0')	{{$TotMonth}}	{{$Payable}}	{{$Payed}}	@if($AdBal<0) @currency($AdBal*-1) @elseif($AdBal>0) @currency($AdBal) @else @currency($AdBal) @endif

{{ __('lng.Showing') }} {{ $HouseSubscriptions->count() }} {{ __('lng.Items') }}