@extends('backend.layouts.app')

@section('content')
<div class="container-fluid">
	<div class="row">
		<div class="col-xl-12">
			<div class="breadcrumb-holder">
				<h1 class="main-title float-left">Monthly Bills 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">Monthly Bills</li>
				</ol>
				<div class="clearfix"></div>
			</div>
		</div>
	</div>
	<div class="row">
		<div class="col-sm-12">
			<div class="card">
				<form>
					<div class="card-body">
						<div class="row justify-content-center">
							<div class="col-sm-4">
								<div class="form-group">
									<label class="control-label">Year</label>
									<select class="form-control year-select select2" name="year">
										{!! yearDropdown(request()->year?request()->year:date('Y')) !!}
									</select>
								</div>
							</div>
							<div class="col-sm-4">
								<div class="form-group">
									<label class="control-label">Month</label>
									<select class="form-control month-select select2" name="month">
										{!! monthDropdown(request()->month?request()->month:date('F')) !!}
									</select>
								</div>
							</div>
						</div>
						<div class="row">
							<div class="col-sm-4">
								<div class="form-group">
									<label>Per Page</label>
									<select name="per_page" class="form-control">
										<option value="100" @if(request()->per_page == 100) selected @endif>100</option>
										<option value="250" @if(request()->per_page == 250) selected @endif>250</option>
										<option value="500" @if(request()->per_page == 500) selected @endif>500</option>
									</select>
								</div>
							</div>
							<div class="col-sm-4">
								<div class="form-group">
									<label>Search</label>
									<input type="text" name="term" class="form-control" value="{{ (request()->term)?request()->term:"" }}" />
								</div>
							</div>
							<div class="col-sm-2">
								<div class="form-group">
									<label>&nbsp;</label>
									<button type="submit" class="form-control btn btn-success"><i class="fa fa-search"></i> Search</button>
								</div>
							</div>							
						</div>
						<div class="table-responsive">
							<table class="table table-bordered">
								<thead>
									<tr>
										<th class="text-center">Serial</th>
										<th>Membership No & Name</th>
										<th class="text-right">Subscription Fee</th>
										<th class="text-right">Dependent Fee</th>
										<th class="text-right">Total</th>									
										<th class="text-right">Previous Dues</th>									
										<th class="text-right">Grand Total</th>									
										<th class="text-center">Action</th>									
									</tr>
								</thead>
								<tbody>
									@foreach($bills as $bill)

									@php
									$old_dues_present_due = 0;
									if ($bill->member->old_dues) {
										$old_dues_present_due = $bill->member->old_dues->present_due;
									}

									$getAllAdvanceBillPaid = $bill->member->getAllAdvanceBillPaid($bill->member->id, $bill->year, $bill->month);
									$advance_months_paid = 0;
									if (count($getAllAdvanceBillPaid)) {
										$advance_months_paid = $getAllAdvanceBillPaid->sum('paid_amount');
									}
									@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) }}</td>
										<td class="text-right">{{ number_format($bill->dependent_fee, 2) }}</td>
										<td class="text-right">
											{{ number_format($bill->total_amount, 2) }}
										</td>
										<td class="text-right">
											{{ number_format(get_previous_dues($bill->member_id, $bill->year, $bill->month)->sum('due_amount') + $old_dues_present_due - $advance_months_paid, 2) }}
										</td>
										<td class="text-right">
											{{ number_format($bill->due_amount + get_previous_dues($bill->member_id, $bill->year, $bill->month)->sum('due_amount') + $old_dues_present_due - $advance_months_paid, 2) }}
										</td>
										<td class="text-center">
											<a href="{{ route('golf-operation.monthly-subscriptions.bill-details', ['member_id' => $bill->member_id, 'year' => $bill->year, 'month' => $bill->month]) }}" target="_blank" class="btn btn-sm btn-info"><i class="fa fa-print"></i></a>
										</td>
									</tr>
									@endforeach
								</tbody>
							</table>
						</div>
					</div>
					<div class="card-footer">
						{{$bills->appends(request()->except(['page']))->links()}}
					</div>
				</form>					
			</div>			
		</div>
	</div>
</div>
@endsection

@section('before_body_end')
<script type="text/javascript">
	$(function(){
		$('.year-select, .month-select').on('change', function(){
			$(this).closest('form').submit();
		});
	});
</script>
@endsection