@extends('backend.layouts.app')
@section('content')
<div class="col-xl-12">
	<div class="breadcrumb-holder">
		<h1 class="main-title float-left">Dailyentry Summary</h1>
		<ol class="breadcrumb float-right">
			<li class="breadcrumb-item">Home </li>
			<li class="breadcrumb-item active">Dailyentry Summary</li>
		</ol>
		<div class="clearfix"></div>
	</div>
</div>
<div class="container-fluid">
	<div class="col-xl-12">
		<form method="get">
			<div class="card">
				<div class="card-body">					
					<div class="row">
						<div class="col-sm-12 text-center">
							<label style="margin-right: 20px;"><input type="radio" name="report_type" value="daily" @if(!in_array(request()->report_type, ['monthly','financial_year'])) checked @endif>Datewise </label>	
							<label style="margin-right: 20px;"><input type="radio" name="report_type" value="monthly" @if(request()->report_type == 'monthly') checked @endif>Monthly </label>						
							<label><input type="radio" name="report_type" value="financial_year" @if(request()->report_type == 'financial_year') checked @endif>Financial Yearly</label>						
						</div>
					</div>	
					<div class="row justify-content-center daily-filter" style="@if(in_array(request()->report_type, ['monthly','financial_year'])) display: none; @endif">						
						<div class="col-sm-2 text-center">
							<div class="form-group">
								<label class="control-label">Date From</label>
								<input type="text" name="date" class="single-date-picker text-center form-control" value="{{request()->date?request()->date:date('Y-m-d')}}" autocomplete="off" required="" />								
							</div>
						</div>
						<div class="col-sm-2">
							<label>Date To</label>
							<input type="text" name="to_date" class="single-date-picker text-center form-control" value="{{request()->date?request()->to_date:date('Y-m-d')}}" autocomplete="off" />
						</div>											
					</div>
					<div class="row justify-content-center monthly-filter" style="@if(in_array(request()->report_type, ['daily','financial_year']) || request()->report_type == '') display: none; @endif">						
						<div class="col-sm-2 text-center">
							<div class="form-group">
								<label class="control-label">Month</label>
								<select name="month" class="form-control select2">
									{!! monthDropdownNumberValue(request()->month) !!}
								</select>
							</div>
						</div>
						<div class="col-sm-2 text-center">
							<div class="form-group">
								<label class="control-label">Year</label>
								<select name="year" class="form-control select2">
									{!! yearDropdown(request()->year, false) !!}
								</select>
							</div>
						</div>											
					</div>
					<div class="row justify-content-center financial-year-filter" style="@if(in_array(request()->report_type, ['daily','monthly']) || request()->report_type == '') display: none; @endif">						
						<div class="col-sm-2 text-center">
							<div class="form-group">
								<label class="control-label">Financial Year</label>
								<select name="financial_year" class="form-control select2">
									{!! financialYearOptions(request()->financial_year) !!}
								</select>
							</div>
						</div>											
					</div>										
				</div>
				<div class="card-footer text-center">					
					<button type="submit" class="btn btn-info"><i class="fa fa-search"></i> Get Result</button>							
				</div>
			</div>
		</form>	

		@if(request()->report_type)
		<div class="card mt-2">
			<div class="card-header">
				<h3 class="card-title float-left">Summary</h3>
				<a href="{{ route('golf-operation.dailyentry.report.details', request()->all())}}" class="btn btn-info float-right btn-sm" target="_blank"><i class="fa fa-print"></i> Print</a>
			</div>
			<div class="card-body">
				<div class="table-responsive">
					<table class="table table-bordered">
						<thead>
							<tr>
								<th class="text-center" rowspan="2">Sr. No</th>
								<th class="text-center" rowspan="2">Reg No.</th>
								<th class="text-center" rowspan="2">Date</th>
								<th class="text-center" rowspan="2">Name</th>
								<th class="text-center" rowspan="2">Mem. No</th>
								<th class="text-center" rowspan="2">Caddy ID</th>
								<th class="text-center" rowspan="2">Ballboy ID</th>
								<th class="text-center" rowspan="2">Payment Method</th>
								<th class="text-center" rowspan="2">Green Fee</th>
								<th class="text-center" rowspan="2">Caddy Fee</th>
								<th class="text-center" rowspan="2">Ballboy Fee</th>
								<th class="text-center" rowspan="2">Rent Cart</th>
								<th class="text-center" rowspan="2">Rent Set</th>
								<th class="text-center" rowspan="2">Rent Trolley</th>
								<th class="text-center" rowspan="2">Other</th>
								<th class="text-center" rowspan="2">Total</th>
								<th class="text-center" colspan="2">Subsidy</th>
							</tr>
							<tr>
								<th class="text-center">Caddy</th>
								<th class="text-center">Ballboy</th>
							</tr>
						</thead>
						<tbody>
														@foreach($dailyentries as $entry)
							<tr>
								<td>{{$loop->index+1}}</td>
								<td>
																		{{ $reg_no }}
								</td>
								<td>{{ date('d-M-y', strtotime($entry->created_at)) }}</td>
								<td>{{$entry->name}}</td>				
								<td class="text-center">{{$entry->membership_no}}</td>								
								<td class="text-center">{{isset($entry->caddy)?$entry->caddy->caddy_id:''}}</td>
								<td class="text-center">{{isset($entry->ballboy)?$entry->ballboy->ballboy_id:''}}</td>
								<td class="text-center">{{isset($entry->payment_method)?$entry->payment_method->name:''}} <br /> {{ $entry->payment_reference }}</td>
								<td style="text-align: right;">{{ number_format($entry->green_fee, 2) }}</td>
								<td style="text-align: right;">{{ number_format($entry->caddy_fee, 2) }}</td>
								<td style="text-align: right;">{{ number_format($entry->ballboy_fee, 2) }}</td>
								<td style="text-align: right;">{{ number_format($entry->cart_fee, 2) }}</td>
								<td style="text-align: right;">{{ number_format($entry->set_fee, 2) }}</td>
								<td style="text-align: right;">{{ number_format($entry->trolley_fee, 2) }}</td>
								<td style="text-align: right;">{{ number_format($entry->other_fee, 2) }}</td>
								<td style="text-align: right;">{{ number_format($entry->total_bill, 2) }}</td>
								<td style="text-align: right;">{{ number_format($entry->caddy_subsidy, 2) }}</td>
								<td style="text-align: right;">{{ number_format($entry->ballboy_subsidy, 2)}}</td>
															</tr>
							@endforeach
						</tbody>
						<tfoot>
							<tr>
								<th colspan="7" style="text-align: right;">
									Total
								</th>
								<th style="text-align: right;">{{ number_format($total_green_fee, 2) }}</th>
								<th style="text-align: right;">{{ number_format($total_caddy_fee, 2) }}</th>
								<th style="text-align: right;">{{ number_format($total_ballboy_fee, 2) }}</th>
								<th style="text-align: right;">{{ number_format($total_cart_fee, 2) }}</th>
								<th style="text-align: right;">{{ number_format($total_set_fee, 2) }}</th>
								<th style="text-align: right;">{{ number_format($total_trolley_fee, 2) }}</th>
								<th style="text-align: right;">{{ number_format($total_other_fee, 2) }}</th>
								<th style="text-align: right;">{{ number_format($total_bill, 2) }}</th>
								<th style="text-align: right;">{{ number_format($caddy_subsidy, 2) }}</th>
								<th style="text-align: right;">{{ number_format($ballboy_subsidy, 2) }}</th>
							</tr>							
						</tfoot>	
					</table>
					<div class="row">
						<div class="col-sm-5">
							<p style="margin: 0px; border-bottom: 1px solid #000; font-size: 14px; font-weight: bold;">Income Collection</p>
							<table class="table" style="font-weight: bold; font-size: 14px;">
								<tbody>
									<tr>
										<td class="text-left" style="width: 70%;">Grand Total of Green Fee:</td>
										<td class="text-right">{{ number_format($total_green_fee, 2) }}</td>
									</tr>									
									<tr>
										<td class="text-left">Grand Total of Golf Cart Fee:</td>
										<td class="text-right">{{ number_format($total_cart_fee, 2) }}</td>
									</tr>
									<tr>
										<td class="text-left">Grand Total of Golf Set Fee:</td>
										<td class="text-right">{{ number_format($total_set_fee, 2) }}</td>
									</tr>
									<tr>
										<td class="text-left">Grand Total of Golf Trolley Fee:</td>
										<td class="text-right">{{ number_format($total_trolley_fee, 2) }}</td>
									</tr>
									<tr>
										<td class="text-left">Grand Total of Other Fee:</td>
										<td class="text-right">{{ number_format($total_other_fee, 2) }}</td>
									</tr>
								</tbody>													
							</table>
							<table class="table" style="font-weight: bold; font-size: 14px; border-top: 1px double #000;">
								<tbody>
									<tr>
										<td class="text-left" style="width: 70%;">Grand Total of Receive:</td>
										<td class="text-right">{{ number_format(($total_green_fee+$total_cart_fee+$total_set_fee+$total_trolley_fee+$total_other_fee), 2) }}</td>
									</tr>
								</tbody>
							</table>
							{{-- <div style="height: 25px;"></div> --}}

							<p style="margin: 0px; border-bottom: 1px solid #000; font-size: 14px; font-weight: bold;">Subsidy</p>
							<table class="table" style="font-weight: bold; font-size: 14px; margin-bottom: 0px;">
								<tbody>
									<tr>
										<td class="text-left" style="width: 70%;">Grand Total of Caddy Fee (Subsidy):</td>
										<td class="text-right">{{ number_format($caddy_subsidy, 2) }}</td>
									</tr>
									<tr>
										<td class="text-left">Grand Total of Ball Boy Fee (Subsidy):</td>
										<td class="text-right">{{ number_format($ballboy_subsidy, 2) }}</td>
									</tr>
								</tbody>
							</table>
							<table class="table" style="font-weight: bold; font-size: 14px; border-top: 1px double #000;">
								<tbody>
									<tr>
										<td class="text-left" style="width: 70%;">Grand Total of Subsidy:</td>
										<td class="text-right">{{ number_format(($caddy_subsidy+$ballboy_subsidy), 2) }}</td>
									</tr>
								</tbody>
							</table>
							
							{{-- <hr style="margin-top: 15px; border-top: 1px dotted #000;" /> --}}
							<table class="table" style="font-weight: bold; font-size: 14px;">
								<tbody>
									<tr>
										<td class="text-left" style="width: 70%;">Net Payable to Accounts:</td>
										<td class="text-right">{{ number_format(($total_green_fee+$total_cart_fee+$total_set_fee+$total_trolley_fee+$total_other_fee) - ($caddy_subsidy+$ballboy_subsidy), 2) }}</td>
									</tr>
								</tbody>
							</table>
							
						</div>
						<div class="col-sm-2">
							
						</div>
						<div class="col-sm-5">
							<p style="margin: 0px; border-bottom: 1px solid #000; font-size: 14px; font-weight: bold;">Caddy & Ballboy Fee Collection</p>
							<table class="table" style="font-weight: bold; font-size: 14px;">
								<tbody>
									
									<tr>
										<td class="text-left">Grand Total of Caddy Fee:</td>
										<td class="text-right">{{ number_format($total_caddy_fee, 2) }}</td>
									</tr>
									<tr>
										<td class="text-left">Grand Total of Ball Boy Fee:</td>
										<td class="text-right">{{ number_format($total_ballboy_fee, 2) }}</td>
									</tr>									
								</tbody>													
							</table>
							<table class="table" style="font-weight: bold; font-size: 14px; border-top: 1px double #000;">
								<tbody>
									<tr>
										<td class="text-left" style="width: 70%;">Grand Total of Receiving:</td>
										<td class="text-right">{{ number_format(($total_caddy_fee + $total_ballboy_fee), 2) }}</td>
									</tr>
								</tbody>
							</table>

							<p style="margin: 0px; border-bottom: 1px solid #000; font-size: 14px; font-weight: bold;">Subsidy</p>
							<table class="table" style="font-weight: bold; font-size: 14px; margin-bottom: 0px;">
								<tbody>
									<tr>
										<td class="text-left" style="width: 70%;">Grand Total of Caddy Fee (Subsidy):</td>
										<td class="text-right">{{ number_format($caddy_subsidy, 2) }}</td>
									</tr>
									<tr>
										<td class="text-left">Grand Total of Ball Boy Fee (Subsidy):</td>
										<td class="text-right">{{ number_format($ballboy_subsidy, 2) }}</td>
									</tr>
								</tbody>
							</table>
							<table class="table" style="font-weight: bold; font-size: 14px; border-top: 1px double #000;">
								<tbody>
									<tr>
										<td class="text-left" style="width: 70%;">Grand Total of Subsidy:</td>
										<td class="text-right">{{ number_format(($caddy_subsidy+$ballboy_subsidy), 2) }}</td>
									</tr>
								</tbody>
							</table>
							<hr style="margin-top: 15px; border-top: 1px dotted #000;" />
							<table class="table" style="font-weight: bold; font-size: 14px;">
								<tbody>
									<tr>
										<td class="text-left" style="width: 70%;">Total Amount of Caddy & Ballboy Payment:</td>
										<td class="text-right">{{ number_format(($total_caddy_fee + $total_ballboy_fee+$caddy_subsidy+$ballboy_subsidy), 2) }}</td>
									</tr>
								</tbody>
							</table>
						</div>
					</div>

					<hr style="margin-top: 15px; border-top: 1px dotted #000;" />
					<div style="height: 130px;"></div>
					
					<div class="row">
						<div class="col-md-3">
							<table class="table" style="font-weight: bold; font-size: 14px;">
								<tbody>
									<tr>
										<td class="text-center" style="">Operator</td>
									</tr>
								</tbody>
							</table>
						</div>
						<div class="col-md-3">
							<table class="table" style="font-weight: bold; font-size: 14px;">
								<tbody>
									<tr>
										<td class="text-center" style="">GM(Op.)</td>
									</tr>
								</tbody>
							</table>
						</div>
						<div class="col-md-3">
							<table class="table" style="font-weight: bold; font-size: 14px;">
								<tbody>
									<tr>
										<td class="text-center" style="">CEO</td>
									</tr>
								</tbody>
							</table>
						</div>
						<div class="col-md-3">
							<table class="table" style="font-weight: bold; font-size: 14px;">
								<tbody>
									<tr>
										<td class="text-center" style="">Mem. Sec.</td>
									</tr>
								</tbody>
							</table>
						</div>
						
					</div>

				</div>
			</div>
		</div>
		@endif
	</div>
</div>
@endsection
@section('before_body_end')
<style type="text/css">
	.table th, .table td {
		font-size: 12px;
		vertical-align: middle;
		padding: 2px;
	}
</style>
<script type="text/javascript">
	$(function(){								
		$('.single-date-picker').daterangepicker({
			singleDatePicker: true,
			showDropdowns: true,
			autoUpdateInput: false,
			locale: {
		      format: 'YYYY-MM-DD'
		    }
		});

		$('input[name="report_type"]').on('change', function(e){
			var value = $(this).val();
			if(value == 'daily'){
				$('.daily-filter').show();
				$('.monthly-filter').hide();
				$('.financial-year-filter').hide();
			}else if(value == 'monthly'){
				$('.daily-filter').hide();
				$('.monthly-filter').show();
				$('.financial-year-filter').hide();
			}else if(value == 'financial_year'){
				$('.daily-filter').hide();
				$('.monthly-filter').hide();
				$('.financial-year-filter').show();
			}
		});

		$('.single-date-picker').on('apply.daterangepicker', function(ev, picker){
			$(this).val(picker.startDate.format('YYYY-MM-DD'));			
		});

		$('.caddy-dropdown').select2({
            placeholder: 'Select Caddy',	            
            multiple: false,
            allowClear: true,
            ajax: {
                url: '{{route("caddy-suggestion")}}',
                dataType: 'json',
                data: function (params) {
                  return {
                    term: params.term, // search term
                    page: params.page
                  };
                },
                processResults: function (data, params) {
                    params.page = params.page || 1;
                    return {
                        results: data.items,
                        pagination: {
                          more: (params.page * 30) < data.total_count
                        }
                    };
                }
            }
        });	

        $('.ballboy-dropdown').select2({
            placeholder: 'Select Ballboy',	            
            multiple: false,
            allowClear: true,
            ajax: {
                url: '{{route("ballboy-suggestion")}}',
                dataType: 'json',
                data: function (params) {
                  return {
                    term: params.term, // search term
                    page: params.page
                  };
                },
                processResults: function (data, params) {
                    params.page = params.page || 1;
                    return {
                        results: data.items,
                        pagination: {
                          more: (params.page * 30) < data.total_count
                        }
                    };
                }
            }
        });			
	});
</script>
@endsection