@extends('backend.layouts.newpdf')
@section('content')					
<table class="table table-bordered table-sm">
	<thead>
		<tr>
			<th width="3%">SN</th>
			<th width="18%">Mem Name[Mem No]</th>
			<!-- <th>Status</th> -->
			<th>Month</th>
			<th>Sub Fee</th>
			<th>Dependent Fee</th>
			<th>Total</th>
			<th>Paid</th>
			<th>Due</th>
			<th>Previous Due</th>
			<th>Forwarding Due</th>			
		</tr>
	</thead>
	<tbody>
		@php
		$previousAdvanceSum = 0;
		$previousAdvanceForwordSum = 0;
		@endphp
		@foreach($subscriptions as $subscription)
		<tr>
			<td class="text-center">{{(($subscriptions->currentPage()-1)* $subscriptions->perPage())+$loop->index+1}}</td>
			<td>{{$subscription->member->full_name}} [{{$subscription->member->membership_no}}]</td>
			<!-- <td class="text-center">{{ $subscription->activity_status }}</td> -->
			<td class="text-center">{{$subscription->month.' '.$subscription->year}}</td>
			<td class="text-right">{{number_format($subscription->subscription_fee, 2)}}</td>
			<td class="text-right">{{number_format($subscription->dependent_fee, 2)}}</td>
			<td class="text-right">{{number_format($subscription->total_amount, 2)}}</td>
			<td class="text-right">{{number_format($subscription->paid_amount, 2)}}</td>
			<td class="text-right">{{number_format($subscription->due_amount, 2)}}</td>

			@if($subscriptions->last()!==null && $subscriptions->last()==$subscription)

				<td class="text-right">{{ number_format(
					$previousAdvanceSum += 
					get_previous_summary($subscription->member_id, $subscription->year, $subscription->month )  - get_subscriptions_advance_summary($subscription->member_id)
					, 2) }}
				</td>
				<td class="text-right">{{number_format( 
					$previousAdvanceForwordSum += (get_previous_summary($subscription->member_id, $subscription->year, $subscription->month)+$subscription->total_amount   - get_subscriptions_advance_summary($subscription->member_id)) - $subscription->paid_amount
					, 2)}}
				</td>
			@else
				<td class="text-right">{{ number_format( 
					$previousAdvanceSum +=  
					get_previous_summary($subscription->member_id, $subscription->year, $subscription->month )
					, 2) }}
				</td>
				<td class="text-right">{{number_format( 
					$previousAdvanceForwordSum += 
					(get_previous_summary($subscription->member_id, $subscription->year, $subscription->month)+$subscription->total_amount ) - $subscription->paid_amount
					, 2)}}
				</td>
			@endif

		</tr>
		@endforeach
	</tbody>
	<tfoot>
		<tr>
			<th class="text-right" colspan="3" style="text-align: right;">Total</th>			
			<th class="text-right">{{number_format($subscriptions->sum('subscription_fee'), 2)}}</th>
			<th class="text-right">{{number_format($subscriptions->sum('dependent_fee'), 2)}}</th>
			<th class="text-right">{{number_format($subscriptions->sum('total_amount'), 2)}}</th>
			<th class="text-right">{{number_format($subscriptions->sum('paid_amount'), 2)}}</th>
			<th class="text-right">{{number_format($subscriptions->sum('due_amount'), 2)}}</th>

			<th class="text-right">{{number_format($previousAdvanceSum, 2)}}</th>
			<th class="text-right">{{number_format($previousAdvanceForwordSum, 2)}}</th>

		</tr>
	</tfoot>
</table>					
@endsection

@section('styles')
<style type="text/css">
	table th {
		text-align: center;
	}
</style>
@endsection