@extends('backend.layouts.snappy-pdf')

@section('content')

<div class="container">
<div class="row">		
	<div class="text-center">
		<img style="width:50px; height: 50px" src="{{url('public/backend/images/logo.png')}}">
		<h3 style="margin: 0px;">Bhatiary Golf &Country Club</h3>
		<h5 style="margin: 0px;"><strong>Dhaka Cantonment, Dhaka</strong></h5>
	</div>			
</div>
<div class="row">
	<div class="text-center">
		<h6 style="font-weight: bold; text-decoration: underline; margin: 0px; margin-bottom: 15px;">Monthly {{(request()->per_page && request()->all)?'['.request()->per_page.']':''}} Bills of <b>Subscriptions</b> for {{$month}} {{$year}} {{ (!request()->all && isset($member))?' of '.$member->full_name.' (M No. '.$member->membership_no.')' :''}}</h6>
	</div>
</div>
</div>
		
	<div class="row">
		<div class="col-md-12">						
			<div class="card">
				
				<div class="card-body">
					
					<table class="table table-bordered">
						<thead>
							<tr>
								<th class="text-center">Serial</th>
								<th width="25%">Membership No & Name</th>
								<th class="text-right">Subscription Fee</th>
								<th class="text-right">Dependent Fee</th>
								<th class="text-right">Fee Increased</th>
								<th class="text-right">Total</th>									
								<th class="text-right">Due</th>									
								<th class="text-right">Previous Dues</th>
								<th class="text-right">Grand Total</th>								
							</tr>
						</thead>
						<tbody>
							@php
							$subscription_fee_sum = 0;
							$dependent_fee_sum = 0;
							$fee_increased_sum = 0;
							$total_fee_sum = 0;
							$due_sum = 0;

							$previousAdvanceSum = 0;
							$previousAdvanceForwordSum = 0;
							@endphp

							@foreach($bills as $bill)

							@php
							if (!$bill->member) {
								continue;
							}

							$old_dues_present_due = 0;
							$old_dues = $bill->member->old_dues;
							$due_exists_from = "";

							if ($old_dues) {
								$old_dues_present_due = $old_dues->present_due;
								if ($old_dues_present_due) {
									$due_exists_from = date('M Y', strtotime($old_dues->from_month));
								}
							}

							$previous_dues = get_previous_dues($bill->member_id, $bill->year, $bill->month);
							if (count($previous_dues)) {
								$due_exists_from = $due_exists_from = date('M', strtotime($previous_dues->first()->month)).' '.$previous_dues->first()->year;
							}

							if ($due_exists_from) {
								$due_exists_from = 'From '.$due_exists_from.' ';
							}

							$advance_next_date = strtotime('+1 Month', strtotime($bill->year.'-'.$bill->month));
							$advance_next_year = date('Y', $advance_next_date);
							$advance_next_month = date('F', $advance_next_date);

							// here in bill advance starts from next month-year
							$getAllAdvanceBillPaid = $bill->member->getAllAdvanceBillPaid($bill->member->id, $advance_next_year, $advance_next_month);
							$advance_months_paid = 0;
							$adv_exists_till="";

							if (count($getAllAdvanceBillPaid)) {
								$advance_months_paid = $getAllAdvanceBillPaid->sum('paid_amount');
								$adv_exists_till = '(till '.date('M',strtotime($getAllAdvanceBillPaid->last()->month)).' '.$getAllAdvanceBillPaid->last()->year.')';
							}

							@endphp

							<tr>
									<td class="text-center">{{ $loop->index + 1 }}</td>
									<td>{{ $bill->member->membership_no }} - {{ $bill->member->full_name }}</td>
									<td class="text-right">{{ number_format( $bill->subscription_fee, 2) }}
										@php $subscription_fee_sum += $bill->subscription_fee @endphp
									</td>
									<td class="text-right">{{ number_format( $bill->dependent_fee, 2) }}

										@php $dependent_fee_sum += $bill->dependent_fee @endphp

									</td>
									<td class="text-right">{{ number_format( $bill->fee_increased, 2) }}

										@php $fee_increased_sum += $bill->fee_increased @endphp
									</td>
									<td class="text-right">
										{{ number_format( $bill->total_amount, 2) }}

										@php $total_fee_sum += $bill->total_amount @endphp
									</td>
									<td class="text-right">
										{{ number_format( $bill->due_amount, 2) }}

										@php $due_sum += $bill->due_amount @endphp
									</td>
									<td class="text-right">

										<div style="font-size:11px">{{$due_exists_from}}</div>

										{{ number_format(

											$previous_dues->sum('due_amount') + $old_dues_present_due - $advance_months_paid 

											, 2) }}

											@php $previousAdvanceSum +=  

											$previous_dues->sum('due_amount') + $old_dues_present_due - $advance_months_paid  @endphp

											<div style="font-size:11px">{{$adv_exists_till}}</div>
									</td>
									<td class="text-right">
										{{ number_format(

											$bill->due_amount + $previous_dues->sum('due_amount') + $old_dues_present_due - $advance_months_paid 

											, 2) }}

											@php $previousAdvanceForwordSum += 

											$bill->due_amount + $previous_dues->sum('due_amount') + $old_dues_present_due - $advance_months_paid  @endphp
										
									</td>
									
								</tr>
							@endforeach
						</tbody>
						<tfoot>
							<tr>
								<th colspan="2" class="text-right">Total</th>
								<th class="text-right">{{ number_format($subscription_fee_sum, 2) }}</th>
								<th class="text-right">{{ number_format($dependent_fee_sum, 2) }}</th>
								<th class="text-right">{{ number_format($fee_increased_sum, 2) }}</th>
								<th class="text-right">{{ number_format($total_fee_sum, 2) }}</th>
								<th class="text-right">{{ number_format($due_sum, 2) }}</th>

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

				</div>
			</div>
		</div>
	</div>
</div>

@endsection