@extends('backend.layouts.app')
@section('content')
@php
	$months = array();
	for($i = 1; $i <= 12; $i++){
		$month = date('F', strtotime('2000-'.$i.'-01'));
		$months[$month] = $month;
	}

	$yearOptions = array();
	for($year = 2000; $year <= (date('Y')+5); $year++){
		$yearOptions[$year] = $year;
	}
@endphp
<div class="container-fluid">
	<div class="row">
		<div class="col-xl-12">
			<div class="breadcrumb-holder">
				<h1 class="main-title float-left">Ledger of Subscriptions</h1>
				<ol class="breadcrumb float-right">
					<li class="breadcrumb-item"><a href="{{route('dashboard')}}">Dashboard</a></li>
					<li class="breadcrumb-item"><a href="{{route('golf-operation')}}">Golf Operation</a></li>
					<li class="breadcrumb-item"><a href="{{route('golf-operation.monthly-subscriptions')}}">Monthly Subscriptions</a></li>
					<li class="breadcrumb-item active">Ledger</li>
				</ol>
				<div class="clearfix"></div>
			</div>
		</div>
	</div>
	<div class="row">
		<div class="col-xl-12">
			<div class="card">
				<div class="card-body">
					<form id="filter-form">
						<div class="row">
							<div class="col-sm-2">
								<div class="form-group">
									<label class="control-label">Per Page</label>
									<select name="per_page" class="form-control per_page">
										<option value="50" @if(request()->per_page == 50) selected @endif>50</option>
										<option value="100" @if(request()->per_page == 100) selected @endif>100</option>
										<option value="200" @if(request()->per_page == 200) selected @endif>200</option>
										<option value="400" @if(request()->per_page == 400) selected @endif>400</option>
										<option value="500" @if(request()->per_page == 500) selected @endif>500</option>
									</select>
								</div>
							</div>
							<div class="col-sm-2">
								<div class="form-group">
									<label class="control-label">Mem. No</label>
									<input type="text" name="membership_no" class="form-control" value="{{request()->membership_no}}" />								
								</div>
							</div>
							<div class="col-sm-3">
								<div class="form-group">
									<label class="control-label">Mem. Name</label>
									<input type="text" name="member_name" class="form-control" value="{{request()->member_name}}" />
								</div>
							</div>
							<div class="col-sm-2">
								<div class="form-group">
									<label class="control-label">Year</label>
									<select class="form-control select2" name="year">
										<option value="">Select Year</option>
										{!!create_dropdown_option($yearOptions, request()->year)!!}
									</select>
								</div>
							</div>
							<div class="col-sm-2">
								<div class="form-group">
									<label class="control-label">Month</label>
									<select class="form-control select2" name="month">
										<option value="">Select Month</option>
										{!!create_dropdown_option($months, request()->month)!!}
									</select>
								</div>
							</div>
							<div class="col-sm-1">
								<div class="form-group" style="padding-top: 25px;">
									<button type="submit" class="btn btn-primary btn-sm"><i class="fa fa-play"></i></button>
									<button type="button" class="btn btn-danger btn-sm reset-btn"><i class="fa fa-remove"></i></button>
								</div>
							</div>					
						</div>
					</form>

					@if(isset($subscriptions) && $subscriptions->count())
						<div class="text-right" style="padding-bottom: 4px;">
							<a href="{{ route('golf-operation.monthly-subscriptions.manage-invoice-pdf', request()->all()) }}" target="_blank" class="btn btn-info btn-sm"><i class="fa fa-print"></i> Print</a>
						</div>

						<div class="table-responsive">
							<table class="table table-bordered table-sm">
								<thead>
									<tr>
										<th>SN</th>
										<th>Mem No</th>
										<th>Mem Name</th>
										<th>Status</th>									
										<th>Month</th>
										<th>Sub Fee</th>
										<th>Dependent Fee</th>
										<th>Bill Total</th>
										<th>Bill Paid</th>
										<th>Bill Due</th>
										<th>Previous Due</th>
										<th>Balance</th>
									</tr>
								</thead>
								<tbody>
									@foreach($subscriptions as $subscription)
										@php
										$advancePay = $subscription->member->subscriptionAdvance();
										@endphp
									<tr>
										<td class="text-center">{{(($subscriptions->currentPage()-1)* $subscriptions->perPage())+$loop->index+1}}</td>
										<td class="text-center">{{$subscription->member->membership_no}}</td>
										<td>{{$subscription->member->full_name}}</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->total_amount - $subscription->paid_amount, 2)}}</td>
										
										@if($subscriptions->last()!==null && $subscriptions->last()==$subscription)

											<td class="text-right">{{ number_format(get_previous_summary($subscription->member_id, $subscription->year, $subscription->month )  - (isset($advancePay->total_amount)?$advancePay->total_amount:0)
												, 2) }}
											</td>
											<td class="text-right">{{number_format((get_previous_summary($subscription->member_id, $subscription->year, $subscription->month)+$subscription->total_amount   - (isset($advancePay->total_amount)?$advancePay->total_amount:0)) - $subscription->paid_amount
												, 2)}}
											</td>
										@else
											<td class="text-right">{{ number_format(get_previous_summary($subscription->member_id, $subscription->year, $subscription->month )
												, 2) }}
											</td>
											<td class="text-right">{{number_format((get_previous_summary($subscription->member_id, $subscription->year, $subscription->month)+$subscription->total_amount ) - $subscription->paid_amount
												, 2)}}
											</td>
										@endif
										
									</tr>
									@endforeach
								</tbody>
							</table>
						</div>
					@endif

				</div>
				<div class="card-footer">
					@if(isset($subscriptions) && $subscriptions->count())
						{{$subscriptions->appends(request()->except(['page']))->links()}}
					@endif
				</div>
			</div>
		</div>
	</div>
</div>
@endsection

@section('before_body_end')
<style type="text/css">
	table th {
		text-align: center;
	}
</style>
<script type="text/javascript">
	$('.reset-btn').on('click', function(e){
		$('input, select:not(".per_page")').val('');
		$('#filter-form').submit();		
	});
</script>
@endsection