@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">Collection Report of Subscription</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">Collection Report of Subscription</li>
				</ol>
				<div class="clearfix"></div>
			</div>
		</div>
	</div> --}}
	<form class="" id="search_form" style="padding-top: 15px;">
		<div class="row">
			<div class="col-sm-1 text-right">From Date</div>
			<div class="col-sm-2">
				<div class="form-group">
					<input type="text" name="from_date" class="form-control report-datepicker" value="{{ (request()->from_date)?request()->from_date:date('Y-m-d') }}" />
				</div>
			</div>
			<div class="col-sm-1 text-right">To Date</div>
			<div class="col-sm-2">
				<div class="form-group">
					<input type="text" name="to_date" class="form-control report-datepicker" value="{{ (request()->to_date)?request()->to_date:date('Y-m-d') }}" />
				</div>
			</div>							
			<div class="col-sm-1 text-right">Membership No</div>
			<div class="col-sm-2">
				<div class="form-group">
					<input type="text" name="membership_no" class="form-control" value="{{ (request()->membership_no)?request()->membership_no:"" }}" />
				</div>
			</div>							
			<div class="col-sm-2">
				<div class="form-group">
					<button type="submit" class="form-control btn btn-success"><i class="fa fa-search"></i> Search</button>
				</div>
			</div>
			<div class="col-sm-1">
				<div class="form-group">
					<button id="all" class="form-control btn btn-success"> All </button>
				</div>
			</div>
			<script type="text/javascript">

				$(document).ready(function() {

					$('#all').click(function(event) {

						event.preventDefault();
						
						$('input[name="membership_no"]').val("");

						$('#search_form').append('<input hidden name="all" value="1" />');

						$('#search_form').submit();
					});

				});

			</script>							
		</div>
	</form>
		
	<div class="row">
		<div class="col-md-12">						
			<div class="card">
				<div class="card-body">
					<div class="row" style="">
						<div class="col-md-11">
							<h6 class="main-title" style="margin-bottom:15px;"><strong>Collection Report of Subscription</strong> {{!empty($member->full_name)? 'for '.$member->full_name.'(M No: '.$member->membership_no.')':""}} From {{ request()->from_date?request()->from_date:date('Y-m-d') }} To {{ request()->to_date?request()->to_date:date('Y-m-d') }}</h6>
						</div>
						<div class="col-md-1 text-right">
							<a href="{{ route('golf-operation.monthly-subscriptions.collection-report-pdf', request()->all()) }}" target="_blank" class="btn btn-info btn-sm"><i class="fa fa-print"></i> Print</a>
						</div>
					</div>

					<div class="table-responsive">
						<table class="table table-bordered table-sm" style="border: 0px;">
							<tr>
								<th class="text-center">Sr. No.</th>
								<th class="text-center">Receipt No.</th>
								<th class="text-center">Mem No</th>
								<th class="text-center">Mem Name</th>
								<th class="text-center">Payment Date</th>
								<th class="text-center">Months</th>								
								<th class="text-right">Total </th>
								<th class="text-center">Payment Reference</th>	
								<th class="text-center">Action</th>						
							</tr>

							@php
								$all_mode_total_collection = 0;
								$all_mode_names = "";
							@endphp

							@foreach($collections as $collection)
							<tr>
								<td colspan="100%" style="height: 25px; border-left: 0px!important; border-right: 0px!important;"></td>
							</tr>
							<tr>
								<th colspan="100%">{{ $collection['mode'] }}</th>
								@php $all_mode_names .= $all_mode_names? "+ ".$collection['mode']." ":$collection['mode']." "; @endphp
							</tr>
								@php
									$total_monthly_sub = 0;
									$total_dependent = 0;
									$total_locker_fee = 0;
									$total_collection = 0;
									$total_grand = 0;
									$serial = 1;
								@endphp

								@if(count($collection['data']) > 0)

									@foreach($collection['data'] as  $payment)
									<tr>
										<td class="text-center">{{ $serial }}</td>
										<td class="text-center">{{ sprintf('%06d', $payment->id) }}</td>
										<td class="text-center">{{ $payment->member->membership_no }}</td>
										<td class="text-left">{{ $payment->member->full_name }}</td>
										<td class="text-left">{{ date('d-M-Y h:i:s a',strtotime($payment->created_at)) }}</td>
										<td>										
											{{getRanges($payment->time_range)}}
										</td>							
																		
										<td class="text-right">{{ number_format($payment->total_paid, 2) }}</td>							
										<td class="text-center">{{ $payment->payment_reference }}</td>
										<td class="text-center"><a href="{{ route('golf-operation.monthly-subscriptions.bill-payment-details', $payment->id) }}" target="_blank" class="btn btn-info btn-sm"><i class="fa fa-print"></i></a></td>
										@php
											$total_collection += $payment->total_paid;
											$serial++;
										@endphp
									</tr>
									@endforeach
								@endif
								
								<tr>
									<th colspan="6" class="text-right">Total = </th>
									
									<th class="text-right">{{ number_format($total_collection, 2) }}</th>
									<th class="text-right"></th>								
									<td colspan="2"></td>
								</tr>

								@php $all_mode_total_collection += $total_collection; @endphp

							@endforeach

								<tr>
									<td colspan="100%" style="height: 25px; border-left: 0px!important; border-right: 0px!important;"></td>
								</tr>

								<tr>
									<th colspan="6" class="text-right"> [ {{$all_mode_names}} ] Total = </th>
									
									<th class="text-right">{{ number_format($all_mode_total_collection, 2) }}</th>
									<th class="text-right"></th>
									<td colspan="2"></td>
								</tr>

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

@endsection

@section('before_body_end')
<script type="text/javascript">
	$(function() {
        $('.report-datepicker').daterangepicker({
            singleDatePicker: true,
            showDropdowns: true,
            autoUpdateInput: false,
            // drops: "up",
            autoApply:true,
            locale: {
                format: 'YYYY-MM-DD',
                daysOfWeek: ['Su', 'Mo', 'Tu', 'We', 'Th', 'Fr','Sa'],
                firstDay: 0
            }
        },
        function(start) {
            this.element.val(start.format('YYYY-MM-DD'));
            this.element.parent().parent().removeClass('has-error');
        },
        function(chosen_date) {
            this.element.val(chosen_date.format('YYYY-MM-DD'));
        });
        
        $('.report-datepicker').on('apply.daterangepicker', function(ev, picker) {
            $(this).val(picker.startDate.format('YYYY-MM-DD'));
        });
    });
</script>
@endsection