@extends('backend.layouts.app')
@section('content')
<div class="col-xl-12">
	<div class="breadcrumb-holder">
		<h5 style="text-align: center"> Collection Distribution of Driving Registration </h5>
		 <a href="{{route('drivingrange.add')}}" style="color: #000000; border: 1px solid #eee; width: 60%; margin: 15px auto; box-shadow: 0px 0px 5px 5px #9e9c9c;" >
					<i class="fa fa-home" aria-hidden="true" style="font-size: 20px; "></i>
					{{-- <img src="{{ url('public/backend/images/icons/admission.png') }}" style="width: 20px"> --}}
					 Driving Dashboard
				</a>
		<ol class="breadcrumb float-right">
			<li class="breadcrumb-item"><a href="{{route('dashboard')}}">Dashbaord</a> </li>
			<li class="breadcrumb-item"><a href="{{route('drivingrange.add')}}">Driving Range Manag</a> </li>			
			<li class="breadcrumb-item active">Summary of Collection Distribution </li>			
		</ol> 
		
		<br>
	
		<div class="clearfix"></div>
	</div>
</div>
<div class="container-fluid" >
	<div class="row">
		<div class="col-xl-12">
			<form method="get">
				<div class="card">
					<div class="card-body">	
						<div class="row justify-content-center daily-filter">

							<label class="col-sm-1 control-label text-right">Start Date</label>
							<div class="col-sm-3 text-center">
								@php
									$dateInput = request()->date_from ? request()->date_from : date('d-m-Y');
									$dateInput = date('d-m-Y',strtotime($dateInput));
								@endphp
								
								<input type="text" name="date_from" class="datepickerjui text-center form-control" value="{{$dateInput}}" autocomplete="off" required="" />
							</div>
							
							<label class="col-sm-1 control-label text-right">End Date</label>
							<div class="col-sm-3 text-center">
								@php
									$dateInput = request()->date_to ? request()->date_to : date('d-m-Y');
									$dateInput = date('d-m-Y',strtotime($dateInput));
								@endphp
								
								<input type="text" name="date_to" class="datepickerjui text-center form-control" value="{{$dateInput}}" autocomplete="off" required="" />
							</div>
							
							<div class="col-sm-1 ">							
								<button type="submit" class="btn btn-info"><i class="fa fa-search"></i> Get Result</button>
							</div>

						</div>
					</div>
					<div class="card-footer text-center">					
												
					</div>
				</div>
			</form>

			@if( request()->date_from && request()->date_to)
			<div class="card mt-2">
			<div class="card-header">
				<h3 class="card-title float-left"><b>Summary- {{$title}}</b></h3>
				<a href="{{ route('golf-operation.driving.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">

				@if (Session::has('error'))
					<div class="alert alert-danger">
					<a type="button" class="close" data-dismiss="alert">&times;</a>
					<p>{{ Session::get('error') }}</p>
					</div>
				@endif

				@php
					$i=0;
				@endphp

				@if(isset($information))
				@foreach($information as $key_main => $info)
					@php
						$i++
					@endphp
					@if (count($info)>0)

					<div class="card">
					<div class="card-header bg-">
						<strong>{{ucwords(str_replace('_', ' ', $key_main))}}</strong>
					</div>
					</div>

					<table class="table table-sm table-bordered">
						<thead>			
							<tr>
								<th>Sl</th>
								<th>M.No</th>
								<th style=" width: 180px;">Mem Name</th>
								
								<th>White Ball</th>
								<th>Yellow Ball</th>
								<th>Golf Set</th>
								<th>Daily Course Fee-09 Hole</th>
								<th>Coach  Fee 45 min</th>
								<th>Daily Course Fee -18 Hole</th>
								<th>Coach Fee 90 min</th>
								<th>R&A</th>
								<th>PRO</th>

								<th>Shift</th>
								<th>P.Mode</th>
								<th>Total</th>
								<th>Action</th>
							</tr>
						</thead>
						
						<tbody>
							@foreach($info as $key=>$entry)

							@php
								$wb_exist = false;
								$yb_exist = false;
								$golf_set_exist = false;
								$crs90_exist = false;
								$ch45_exist = false;
								$crs18_exist = false;
								$ch90_exist = false;
								$ra_exist = false;
								$pro_exist = false;
							@endphp
							
							<tr>
							<td style="width:3%">{{$loop->index +1 }}.</td>
							<td style="width:7%">{{$entry->membership_no}}</td>
							    <td style="width:25%">{{$entry->full_name}}</td>

								<td style="width:7%;text-align:right;">
									@php $wb_exist=false; @endphp
									@foreach ($drr as $choice)
										@if($entry->id==$choice->driving_info_id && $choice->service_name=='White Ball')
						                    {{ sprintf('%0.2f', $choice->total_price)}}
						                    @php $wb_exist=true; $wb_total=$wb_total+$choice->total_price; @endphp
										@endif
						            @endforeach
									{{(!!$wb_exist)?"":"0.00"}}
								</td>				
								<td style="width:7%;text-align:right;">
									@php $yb_exist=false; @endphp
									@foreach ($drr as $choice)
										@if($entry->id==$choice->driving_info_id && $choice->service_name=='Yellow Ball')
						                    {{ sprintf('%0.2f', $choice->total_price)}}
						                    @php $yb_exist=true; $yb_total=$yb_total+$choice->total_price; @endphp
										@endif
						            @endforeach
									{{(!!$yb_exist)?"":"0.00"}}
								</td>
								<td style="width:7%;text-align:right;">
									@php $golf_set_exist=false; @endphp
									@foreach ($drr as $choice)
										@if($entry->id==$choice->driving_info_id && $choice->service_name=='Golf Set')
						                    {{ sprintf('%0.2f', $choice->total_price)}}
						                    @php $golf_set_exist=true; $golf_set_total=$golf_set_total+$choice->total_price; @endphp
										@endif
						            @endforeach
									{{(!!$golf_set_exist)?"":"0.00"}}
								</td>
								<td style="width:7%;text-align:right;">
									@php $crs90_exist=false; @endphp
									@foreach ($drr as $choice)
										@if($entry->id==$choice->driving_info_id && $choice->service_name=='Daily Course Fee-09 Hole')
						                    {{ sprintf('%0.2f', $choice->total_price)}}
						                    @php $crs90_exist=true; $crs90_total=$crs90_total+$choice->total_price; @endphp
										@endif
						            @endforeach
									{{(!!$crs90_exist)?"":"0.00"}}
								</td>
								<td style="width:7%;text-align:right;">
									@php $ch45_exist=false; @endphp
									@foreach ($drr as $choice)
										@if($entry->id==$choice->driving_info_id && $choice->service_name=='Coach  Fee 45 min')
						                    {{ sprintf('%0.2f', $choice->total_price)}}
						                    @php $ch45_exist=true; $ch45_total=$ch45_total+$choice->total_price; @endphp
										@endif
						            @endforeach
									{{(!!$ch45_exist)?"":"0.00"}}
								</td>
								<td style="width:7%;text-align:right;">
									@php $crs18_exist=false; @endphp
									@foreach ($drr as $choice)
										@if($entry->id==$choice->driving_info_id && $choice->service_name=='Daily Course Fee -18 Hole')
						                    {{ sprintf('%0.2f', $choice->total_price)}}
						                    @php $crs18_exist=true; $crs18_total=$crs18_total+$choice->total_price; @endphp
										@endif
						            @endforeach
									{{(!!$crs18_exist)?"":"0.00"}}
								</td>
								<td style="width:7%;text-align:right;">
									@php $ch90_exist=false; @endphp
									@foreach ($drr as $choice)
										@if($entry->id==$choice->driving_info_id && $choice->service_name=='Coach Fee 90 min')
						                    {{ sprintf('%0.2f', $choice->total_price)}}
						                    @php $ch90_exist=true; $ch90_total=$ch90_total+$choice->total_price; @endphp
										@endif
						            @endforeach
									{{(!!$ch90_exist)?"":"0.00"}}
								</td>
								<td style="width:7%;text-align:right;">
									@php $ra_exist=false; @endphp
									@foreach ($drr as $choice)
										@if($entry->id==$choice->driving_info_id && $choice->service_name=='R&A')
						                    {{ sprintf('%0.2f', $choice->total_price)}}
						                    @php $ra_exist=true; $ra_total=$ra_total+$choice->total_price; @endphp
										@endif
						            @endforeach
									{{(!!$ra_exist)?"":"0.00"}}
								</td>
								<td style="width:7%;text-align:right;">
									@php $pro_exist=false; @endphp
									@foreach ($drr as $choice)
										@if($entry->id==$choice->driving_info_id && $choice->service_name=='PRO')
						                    {{ sprintf('%0.2f', $choice->total_price)}}
						                    @php $pro_exist=true; $pro_total=$pro_total+$choice->total_price; @endphp
										@endif
						            @endforeach
									{{(!!$pro_exist)?"":"0.00"}}
								</td>
								<td style="width:6%">{{$entry->shift}}</td>
								<td style="width:8%">{{$entry->name}}</td>
								<td style="width:5%">{{$entry->grand_total}}</td>
								<td style=""><a class="btn btn-info btn-sm" target="_blank" href="{{route('drivingrange.print', $entry->id)}}"><i class="fa fa-print"></i></a></td>
								
																
								
							</tr>
							@endforeach
							
							<tr>
								<th colspan="3" style="text-align: right;">G.Total</th>
								
								<th style="text-align: right;width: 8%">{{sprintf('%0.2f',$wb_total)}}</th>
								<th style="text-align: right;width: 8%">{{sprintf('%0.2f',$yb_total)}}</th>
								<th style="text-align: right;width: 8%">{{sprintf('%0.2f',$golf_set_total)}}</th>
								<th style="text-align: right;width: 8%">{{sprintf('%0.2f',$crs90_total)}}</th>
								<th style="text-align: right;width: 8%">{{sprintf('%0.2f',$ch45_total)}}</th>
								<th style="text-align: right;width: 8%">{{sprintf('%0.2f',$crs18_total)}}</th>
								<th style="text-align: right;width: 8%">{{sprintf('%0.2f',$ch90_total)}}</th>
								<th style="text-align: right;width: 8%">{{sprintf('%0.2f',$ra_total)}}</th>
								<th style="text-align: right;width: 8%">{{sprintf('%0.2f',$pro_total)}}</th>

								<th style="text-align: right;width: 8%">--</th>
								<th style="text-align: right;width: 8%">--</th>
								<th style="text-align: right;width: 8%">{{sprintf('%0.2f',$total_bill)}}</th>
							</tr>
							<style type="text/css">
								th small{font-size: 88%;}
							</style>
							{{-- AGC G.Total --}}							
							<tr style="border-top: 2px solid #999;">
								<th colspan="3" style="text-align: right;">AGC G.Total</th>
								
								<th style="text-align: right;width: 8%">{{sprintf('%0.2f',
									$agc_wb_total = getPercentage($wb_total, 50)
								)}} <br><small>(50%)</small></th>

								<th style="text-align: right;width: 8%">{{sprintf('%0.2f',
									$agc_yb_total = getPercentage($yb_total, 50)
								)}} <br><small>(50%)</small></th>

								<th style="text-align: right;width: 8%">{{sprintf('%0.2f',
									$agc_golf_set_total = getPercentage($golf_set_total, 100)
								)}} <br><small>(100%)</small></th>

								<th style="text-align: right;width: 8%">{{sprintf('%0.2f',
									$agc_crs90_total = getPercentage($crs90_total, 15)
								)}} <br><small>(15%)</small></th>

								<th style="text-align: right;width: 8%">{{sprintf('%0.2f',
									$agc_ch45_total = getPercentage($ch45_total, 100)
								)}} <br><small>(100%)</small></th>

								<th style="text-align: right;width: 8%">{{sprintf('%0.2f',
									$agc_crs18_total = getPercentage($crs18_total, 15)
								)}} <br><small>(15%)</small></th>

								<th style="text-align: right;width: 8%">{{sprintf('%0.2f',
									$agc_ch90_total = getPercentage($ch90_total, 100)
								)}} <br><small>(100%)</small></th>

								<th style="text-align: right;width: 8%">{{sprintf('%0.2f',
									$agc_ra_total = getPercentage($ra_total, 0)
								)}} <br><small>(0%)</small></th>

								<th style="text-align: right;width: 8%">{{sprintf('%0.2f',
									$agc_pro_total = getPercentage($pro_total, 0)
								)}} <br><small>(0%)</small></th>


								<th style="text-align: right;width: 8%">--</th>
								<th style="text-align: right;width: 8%">--</th>
								<th style="text-align: right;width: 8%">{{sprintf('%0.2f',
									($agc_wb_total + $agc_yb_total + $agc_golf_set_total + $agc_crs90_total + $agc_ch45_total + $agc_crs18_total + $agc_ch90_total + $agc_ra_total + $agc_pro_total)
								)}}</th>
							</tr>

							{{-- Coach G.Total --}}
							<tr >
								<th colspan="3" style="text-align: right;">Coach G.Total</th>
								
								<th style="text-align: right;width: 8%">{{sprintf('%0.2f',
									$coach_wb_total = getPercentage($wb_total, 0)
								)}} <br><small>(0%)</small></th>

								<th style="text-align: right;width: 8%">{{sprintf('%0.2f',
									$coach_yb_total = getPercentage($yb_total, 0)
								)}} <br><small>(0%)</small></th>

								<th style="text-align: right;width: 8%">{{sprintf('%0.2f',
									$coach_golf_set_total = getPercentage($golf_set_total, 0)
								)}} <br><small>(0%)</small></th>

								<th style="text-align: right;width: 8%">{{sprintf('%0.2f',
									$coach_crs90_total = getPercentage($crs90_total, 85)
								)}} <br><small>(85%)</small></th>

								<th style="text-align: right;width: 8%">{{sprintf('%0.2f',
									$coach_ch45_total = getPercentage($ch45_total, 0)
								)}} <br><small>(0%)</small></th>

								<th style="text-align: right;width: 8%">{{sprintf('%0.2f',
									$coach_crs18_total = getPercentage($crs18_total, 85)
								)}} <br><small>(85%)</small></th>

								<th style="text-align: right;width: 8%">{{sprintf('%0.2f',
									$coach_ch90_total = getPercentage($ch90_total, 0)
								)}} <br><small>(0%)</small></th>

								<th style="text-align: right;width: 8%">{{sprintf('%0.2f',
									$coach_ra_total = getPercentage($ra_total, 0)
								)}} <br><small>(0%)</small></th>

								<th style="text-align: right;width: 8%">{{sprintf('%0.2f',
									$coach_pro_total = getPercentage($pro_total, 0)
								)}} <br><small>(0%)</small></th>


								<th style="text-align: right;width: 8%">--</th>
								<th style="text-align: right;width: 8%">--</th>
								<th style="text-align: right;width: 8%">{{sprintf('%0.2f',
									($coach_wb_total + $coach_yb_total + $coach_golf_set_total + $coach_crs90_total + $coach_ch45_total + $coach_crs18_total + $coach_ch90_total + $coach_ra_total + $coach_pro_total)
								)}}</th>
							</tr>
							{{-- Contractor G.Total --}}
							<tr >
								<th colspan="3" style="text-align: right;">Contractor G.Total</th>
								
								<th style="text-align: right;width: 8%">{{sprintf('%0.2f',
									$contractor_wb_total = getPercentage($wb_total, 50)
								)}} <br><small>(50%)</small></th>

								<th style="text-align: right;width: 8%">{{sprintf('%0.2f',
									$contractor_yb_total = getPercentage($yb_total, 50)
								)}} <br><small>(50%)</small></th>

								<th style="text-align: right;width: 8%">{{sprintf('%0.2f',
									$contractor_golf_set_total = getPercentage($golf_set_total, 0)
								)}} <br><small>(0%)</small></th>

								<th style="text-align: right;width: 8%">{{sprintf('%0.2f',
									$contractor_crs90_total = getPercentage($crs90_total, 0)
								)}} <br><small>(0%)</small></th>

								<th style="text-align: right;width: 8%">{{sprintf('%0.2f',
									$contractor_ch45_total = getPercentage($ch45_total, 0)
								)}} <br><small>(0%)</small></th>

								<th style="text-align: right;width: 8%">{{sprintf('%0.2f',
									$contractor_crs18_total = getPercentage($crs18_total, 0)
								)}} <br><small>(0%)</small></th>

								<th style="text-align: right;width: 8%">{{sprintf('%0.2f',
									$contractor_ch90_total = getPercentage($ch90_total, 0)
								)}} <br><small>(0%)</small></th>

								<th style="text-align: right;width: 8%">{{sprintf('%0.2f',
									$contractor_ra_total = getPercentage($ra_total, 0)
								)}} <br><small>(0%)</small></th>

								<th style="text-align: right;width: 8%">{{sprintf('%0.2f',
									$contractor_pro_total = getPercentage($pro_total, 0)
								)}} <br><small>(0%)</small></th>


								<th style="text-align: right;width: 8%">--</th>
								<th style="text-align: right;width: 8%">--</th>
								<th style="text-align: right;width: 8%">{{sprintf('%0.2f',
									($contractor_wb_total + $contractor_yb_total + $contractor_golf_set_total + $contractor_crs90_total + $contractor_ch45_total + $contractor_crs18_total + $contractor_ch90_total + $contractor_ra_total + $contractor_pro_total)
								)}}</th>
							</tr>
							
														
						</tbody>
					</table>

					@endif

					@endforeach
					@endif

					<div class="last_page">

						{{-- <hr style="margin-top: 15px; border-top: 1px dotted #000;" /> --}}
						<div style="height: 130px;"></div>
						
						<div class="row">
							<div class="col-xl-4">
								<table class="table" style="font-weight: bold; font-size: 14px;">
									<tbody>
										<tr>
											<td class="text-center" style="">Admin</td>
										</tr>
									</tbody>
								</table>
							</div>
							<div class="col-xl-4">
								<table class="table" style="font-weight: bold; font-size: 14px;">
									<tbody>
										<tr>
											<td class="text-center" style="">Rep. Contractor</td>
										</tr>
									</tbody>
								</table>
							</div>
							<div class="col-xl-4">
								<table class="table" style="font-weight: bold; font-size: 14px;">
									<tbody>
										<tr>
											<td class="text-center" style="">AGC</td>
										</tr>
									</tbody>
								</table>
							</div>
							
						</div>
					</div>

				</div>
			@endif


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

<style type="text/css">
	table th, table td {
		font-size: 12px;
	}
</style>
@endsection