@extends('backend.layouts.app')
@section('content')
<div class="col-xl-12">
	<div class="breadcrumb-holder">
		<h5 style="text-align: center"> Memberwise Collection Report of Driving Reg </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 Manage</a> </li>			
			<li class="breadcrumb-item active">Memberwise Collection </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>

							@php
								$store=array();
							@endphp

							@foreach($info as $key=>$entry)

							@php
								$wb_exist = false;
								$yb_exist = false;
								$golf_set_exist = false;
								$crs09_exist = false;
								$ch45_exist = false;
								$crs18_exist = false;
								$ch90_exist = false;
								$ra_exist = false;
								$pro_exist = false;
								$totalRow = 0;
							@endphp
							
							<tr>

							@php
								$store[$key]['id'] = $entry->id;
								$store[$key]['membership_no'] = $entry->membership_no;
								$store[$key]['full_name'] = $entry->full_name;
							@endphp

							<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; 
						                    $store[$key]['wb_exist']=$choice->total_price;
						                    $wb_total=$wb_total+$choice->total_price; 
						                    $totalRow += $choice->total_price;
						                    @endphp
										@endif
						            @endforeach
									@php
						            	if (!$wb_exist){
						            		echo $store[$key]['wb_exist']="0.00";
						            	}
						            @endphp
								</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; 
						                    $store[$key]['yb_exist']=$choice->total_price;
						                    $yb_total=$yb_total+$choice->total_price; 
						                    $totalRow += $choice->total_price;
						                    @endphp
										@endif
						            @endforeach
									@php
						            	if (!$yb_exist){
						            		echo $store[$key]['yb_exist']="0.00";
						            	}
						            @endphp
								</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; 
						                    $store[$key]['golf_set_exist']=$choice->total_price;
						                    $golf_set_total=$golf_set_total+$choice->total_price; 
						                    $totalRow += $choice->total_price;
						                    @endphp
										@endif
						            @endforeach
									@php
						            	if (!$golf_set_exist){
						            		echo $store[$key]['golf_set_exist']="0.00";
						            	}
						            @endphp
								</td>
								<td style="width:7%;text-align:right;">
									@php $crs09_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 $crs09_exist=true; 
						                    $store[$key]['crs09_exist']=$choice->total_price;
						                    $crs09_total=$crs09_total+$choice->total_price; 
						                    $totalRow += $choice->total_price;
						                    @endphp
										@endif
						            @endforeach
									@php
						            	if (!$crs09_exist){
						            		echo $store[$key]['crs09_exist']="0.00";
						            	}
						            @endphp
								</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; 
						                    $store[$key]['ch45_exist']=$choice->total_price;$ch45_total=$ch45_total+$choice->total_price; 
						                    $totalRow += $choice->total_price;
						                    @endphp
										@endif
						            @endforeach
									@php
						            	if (!$ch45_exist){
						            		echo $store[$key]['ch45_exist']="0.00";
						            	}
						            @endphp
								</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; 
						                    $store[$key]['crs18_exist']=$choice->total_price;$crs18_total=$crs18_total+$choice->total_price; 
						                    $totalRow += $choice->total_price;
						                    @endphp
										@endif
						            @endforeach
									@php
						            	if (!$crs18_exist){
						            		echo $store[$key]['crs18_exist']="0.00";
						            	}
						            @endphp
								</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; 
						                    $store[$key]['ch90_exist']=$choice->total_price;$ch90_total=$ch90_total+$choice->total_price; 
						                    $totalRow += $choice->total_price;
						                    @endphp
										@endif
						            @endforeach
									@php
						            	if (!$ch90_exist){
						            		echo $store[$key]['ch90_exist']="0.00";
						            	}
						            @endphp
								</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; 
						                    $store[$key]['ra_exist']=$choice->total_price;$ra_total=$ra_total+$choice->total_price; 
						                    $totalRow += $choice->total_price;
						                    @endphp
										@endif
						            @endforeach
									@php
						            	if (!$ra_exist){
						            		echo $store[$key]['ra_exist']="0.00";
						            	}
						            @endphp
								</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; 
						                    $store[$key]['pro_exist']=$choice->total_price;$pro_total=$pro_total+$choice->total_price; 
						                    $totalRow += $choice->total_price;
						                    @endphp
										@endif
						            @endforeach
									@php
						            	if (!$pro_exist){
						            		echo $store[$key]['pro_exist']="0.00";
						            	}
						            @endphp
								</td>

								@php
									$store[$key]['totalRow']=$totalRow;
								@endphp

								<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',$crs09_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>
						</tbody>
					</table>

					<div id="mtable">
						<table id="coach_summary" 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>Total</th>
								</tr>
							</thead>
							<tbody>
								@php
									$listed=array();
								@endphp
								@foreach ($store as $ind=>$val)
									@php
										if(in_array($val['full_name'], $listed))
										{
											continue;
										}
										$listed[] = $val['full_name'];
										$rows = filterMemberDriving($val['full_name'], $store);
									@endphp
									
								<tr>
									<td>{{++$loop->index}}.</td>
									<td>{{$val['membership_no']}}</td>
									<td>{{$val['full_name']}}</td>
									
									<td>{{sprintf('%0.2f',$rows['wb_existSum'])}}</td>
									<td>{{sprintf('%0.2f',$rows['yb_existSum'])}}</td>
									<td>{{sprintf('%0.2f',$rows['golf_set_existSum'])}}</td>
									<td>{{sprintf('%0.2f',$rows['crs09_existSum'])}}</td>
									<td>{{sprintf('%0.2f',$rows['ch45_existSum'])}}</td>
									<td>{{sprintf('%0.2f',$rows['crs18_existSum'])}}</td>
									<td>{{sprintf('%0.2f',$rows['ch90_existSum'])}}</td>
									<td>{{sprintf('%0.2f',$rows['ra_existSum'])}}</td>
									<td>{{sprintf('%0.2f',$rows['pro_existSum'])}}</td>

									<td>{{sprintf('%0.2f',$rows['totalRowSum'])}}</td>
									<td></td>
								</tr>

								@endforeach

								{{-- cloned from top base html table --}}
								<tr class="total_foot">
									<th colspan="3" style="text-align: right;">G.Total</th>
									
									<th style="text-align: right;">{{sprintf('%0.2f',$wb_total)}}</th>
									<th style="text-align: right;">{{sprintf('%0.2f',$yb_total)}}</th>
									<th style="text-align: right;">{{sprintf('%0.2f',$golf_set_total)}}</th>
									<th style="text-align: right;">{{sprintf('%0.2f',$crs09_total)}}</th>
									<th style="text-align: right;">{{sprintf('%0.2f',$ch45_total)}}</th>
									<th style="text-align: right;">{{sprintf('%0.2f',$crs18_total)}}</th>
									<th style="text-align: right;">{{sprintf('%0.2f',$ch90_total)}}</th>
									<th style="text-align: right;">{{sprintf('%0.2f',$ra_total)}}</th>
									<th style="text-align: right;">{{sprintf('%0.2f',$pro_total)}}</th>

									<th style="text-align: right;">{{sprintf('%0.2f', ($wb_total + $yb_total + $golf_set_total + $crs09_total + $ch45_total + $crs18_total + $ch90_total + $ra_total + $pro_total ))}}</th>
								</tr>

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

					@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