@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 lockers</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($lockers) && $lockers->count())
						<div class="text-right" style="padding-bottom: 4px;">
							<a href="{{ route('golf-operation.monthly-locker.manage-locker-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>Bill Total</th>
										<th>Bill Paid</th>
										<th>Bill Due</th>
										<th>Previous Due</th>
										<th>Balance</th>
									</tr>
								</thead>
								<tbody>
									@foreach($lockers as $locker)

									<tr>
										<td class="text-center">{{(($lockers->currentPage()-1)* $lockers->perPage())+$loop->index+1}}</td>
										<td class="text-center">{{$locker->member->membership_no}}</td>
										<td>{{$locker->member->full_name}}</td>
										<td class="text-center">{{ $locker->activity_status }}</td>									
										<td class="text-center">{{$locker->month . ', ' . $locker->year}}</td>
										<td class="text-right">{{number_format($locker->locker_fee, 2)}}</td>
										<td class="text-right">{{number_format($locker->total_amount, 2)}}</td>
										<td class="text-right">{{number_format($locker->paid_amount, 2)}}</td>
										<td class="text-right">{{number_format($locker->total_amount - $locker->paid_amount, 2)}}</td>
										
										@if($lockers->last()!==null && $lockers->last()==$locker)

											<td class="text-right">{{ number_format(get_locker_previous_summary($locker->member_id, $locker->year, $locker->month ) , 2) }}
											</td>
											<td class="text-right">{{number_format((get_locker_previous_summary($locker->member_id, $locker->year, $locker->month)+$locker->total_amount) - $locker->paid_amount
												, 2)}}
											</td>
										@else
											<td class="text-right">{{ number_format(get_locker_previous_summary($locker->member_id, $locker->year, $locker->month )
												, 2) }}
											</td>
											<td class="text-right">{{number_format((get_locker_previous_summary($locker->member_id, $locker->year, $locker->month)+$locker->total_amount ) - $locker->paid_amount
												, 2)}}
											</td>
										@endif
										
									</tr>
									@endforeach
								</tbody>
							</table>
						</div>
					@endif

				</div>
				<div class="card-footer">
					@if(isset($lockers) && $lockers->count())
						{{$lockers->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