@extends('backend.layouts.snappy-pdf')
@section('content')
<style type="text/css">
.last_page{
    /*page-break-after: always;*/
    page-break-inside: avoid;
}
</style>
<div class="container">
	<div name="page-header">
		<img style="width:50px; height: 50px; left: 70px; top: 0px; margin-left: 10px;" src="{{url('public/backend/images/logo.png')}}">
		<div class="text-center" style="margin-top: -35px;">			
			<h4 style="margin: 0px;">Daily Entry Summary <br />
				{{$title}}
			</h4>
			<h3 style="margin: 0px; font-size: 18px;">Bhatiary Golf &Country Club</h3>
			<h5 style="margin: 0px;padding-bottom: 5px;"><strong>Dhaka Cantonment, Dhaka</strong></h5>
		</div>
	</div>
	<table class="table table-sm table-bordered">
		<thead>			
			<tr>
				<th rowspan="2" class="text-enter">Sr. No</th>
				<th rowspan="2" class="text-center">Reg. No.</th>
				<th rowspan="2" class="text-center" style="width: 55px;">Date</th>
				<th rowspan="2">Member ID & Name</th>				
				<th rowspan="2">Member ID</th>				
				<th rowspan="2" class="text-center">Caddy ID</th>
				<th rowspan="2" class="text-center">Ballboy ID</th>
				<th rowspan="2" class="text-center">Pay. Method</th>
				<th rowspan="2" class="text-center">Green Fee</th>
				<th rowspan="2" class="text-center">Caddy Fee</th>
				<th rowspan="2" class="text-center">Ballboy Fee</th>
				<th rowspan="2" class="text-center">Rent Cart</th>
				<th rowspan="2" class="text-center">Rent Set</th>
				<th rowspan="2" class="text-center">Rent Trolley</th>
				<th rowspan="2" class="text-center">Other Fee</th>
				<th rowspan="2" class="text-center">Total</th>
				<td colspan="2" class="text-center">Subsidy</td>
			</tr>
			<tr>
				<td class="text-center">Caddie</td>
				<td class="text-center">Ballboy</td>
			</tr>
		</thead>
				<tbody>
			@foreach($dailyentries as $entry)
			<tr>
				<td class="text-center">{{$loop->index+1}}</td>
				<td class="text-center">
					@php
						$reg_no = sprintf('%06', $entry->id);
					@endphp
					{{ $entry->id }}
				</td>
				<td>{{ date('d-M-y', strtotime($entry->created_at)) }}</td>
				<td>{{$entry->name}}</td>								
				<td class="text-center">{{$entry->membership_no}}</td>
				<td>{{isset($entry->caddy)?$entry->caddy->caddy_id:''}}</td>
				<td>{{isset($entry->ballboy)?$entry->ballboy->ballboy_id:''}}</td>
				<td>{{isset($entry->payment_method)?$entry->payment_method->name:''}} <br /> {{ $entry->payment_reference }}</td>
				<td style="text-align: right;">{{$entry->green_fee}}</td>
				<td style="text-align: right;">{{$entry->caddy_fee}}</td>
				<td style="text-align: right;">{{$entry->ballboy_fee}}</td>
				<td style="text-align: right;">{{$entry->cart_fee}}</td>
				<td style="text-align: right;">{{$entry->set_fee}}</td>
				<td style="text-align: right;">{{$entry->trolley_fee}}</td>
				<td style="text-align: right;">{{$entry->other_fee}}</td>
				<td style="text-align: right;">{{$entry->total_bill}}</td>
				<td style="text-align: right;">{{$entry->caddy_subsidy}}</td>
				<td style="text-align: right;">{{$entry->ballboy_subsidy}}</td>
							</tr>
			@endforeach
		</tbody>
		<tfoot>
			<tr>
				<th colspan="7" style="text-align: right;">
					Total
				</th>
				<th style="text-align: right;">{{$total_green_fee}}</th>
				<th style="text-align: right;">{{$total_caddy_fee}}</th>
				<th style="text-align: right;">{{$total_ballboy_fee}}</th>
				<th style="text-align: right;">{{$total_cart_fee}}</th>
				<th style="text-align: right;">{{$total_set_fee}}</th>
				<th style="text-align: right;">{{$total_trolley_fee}}</th>
				<th style="text-align: right;">{{$total_other_fee}}</th>
				<th style="text-align: right;">{{$total_bill}}</th>
				<th style="text-align: right;">{{$caddy_subsidy}}</th>
				<th style="text-align: right;">{{$ballboy_subsidy}}</th>
			</tr>
		</tfoot>		
	</table>

	<div class="last_page">
		<div class="row last_page">
			<div class="col-xs-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-xs-2">
				
			</div>
			<div class="col-xs-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-xs-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-xs-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-xs-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-xs-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>
<style type="text/css">
	.table th, .table td, .table thead th, .table thead td, .table tbody th, .table tbody td {
		font-size: 10px;
		vertical-align: middle;
		padding: 3px;
	}
</style>
@endsection