@extends('layouts.adminapp') @section('title') {{ __('lng.AnnualMemberSubscriptionReport') }} - {{ __('lng.Print') }} @endsection @section('active_report', 'active') @section('open_report', 'open') @section('open_annual_subscription_report', 'open') @section('active_annual_subscription_report', 'active') @section('open_member_annual_subscription_report', 'open') @section('active_member_annual_subscription_report', 'active') @section('active_member_sd_annual_subscription_report', 'active') @section('content')

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

@include('PrintHeader.header')

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

{{__('lng.Status')}}: {{$Status}}
@php $si=0; @endphp @foreach ($ArMember as $key => $MemberSubscription) @php // Joining Date $DTs = ''; $TotYears = 0; $Amount = 0; $OpeningBalance = 0; $Payable = 0; $Payed = 0; $AdBal = 0; $DTs = date('Y-m-d', strtotime($MemberSubscription->date)); $TodayDate = date('Y-m-d'); if (strtotime($DTs) < strtotime($TodayDate)) { $NOW = Carbon\Carbon::now(); $year1 = Carbon\Carbon::parse($MemberSubscription->date); $year2 = Carbon\Carbon::parse($NOW); // Calculate the difference in years $TotYears = $year1->diffInYears($year2); } $Amount = $MemberSubscription->subscriptionpackage->amount; if ($MemberSubscription->DRorCR == 'Dr') { $OpeningBalance = $MemberSubscription->openingbalance; } elseif ($MemberSubscription->DRorCR == 'Cr') { $OpeningBalance = -1 * $MemberSubscription->openingbalance; } // Payable Caliculation if (is_numeric($TotYears)) { if ($OpeningBalance > 0) { $Payable = $TotYears * $Amount + $OpeningBalance; } else { $Payable = $TotYears * $Amount; } } // Payed Caliculation foreach ( $MemberSubscription->AnnualMemberSubscriptionPayment->where('isCancelled', 0) as $Subscription ) { if ($Subscription->isCancelled != 1) { $Payed += $Subscription->amount; } } // Advance Or Balance Caliculation if ($OpeningBalance < 0) { $AdBal = $Payable - $Payed + $OpeningBalance; } else { $AdBal = $Payable - $Payed; } @endphp @endforeach
{{__('lng.SiNo')}} {{__('lng.Member')}} {{__('lng.Contact')}} {{__('lng.HouseName')}} {{__('lng.Reg.No.')}} {{__('lng.SubscriptionDateOfJoin')}} {{__('lng.OpeningBalance')}}
{{__('lng.Pending')}}/{{__('lng.Advance')}}		 {{__('lng.Amount')}} {{__('lng.Year')}} {{__('lng.Payable')}} {{__('lng.Payed')}} {{__('lng.Balance')}} / {{__('lng.Advance')}}
{{++$si}} {{$MemberSubscription->member->name}} {{$MemberSubscription->member->contact}} {{$MemberSubscription->member->house->name}} {{$MemberSubscription->member->house->registernumber}} {{$DTs}} @if($OpeningBalance<0) @currency($OpeningBalance*-1) @elseif($OpeningBalance>0) @currency($OpeningBalance) @else @currency($OpeningBalance) @endif @currency($MemberSubscription->subscriptionpackage->amount ?? '0') {{$TotYears}} {{$Payable}} {{$Payed}} @if($AdBal<0) @currency($AdBal*-1) @elseif($AdBal>0) @currency($AdBal) @else @currency($AdBal) @endif
{{ __('lng.Back') }}
@endsection