@extends('layouts.pdf')
@section('content')
<style type="text/css">
	table th{
		background: grey;
		text-align: center;
	}
	table tr{
		margin-top: 10px;
	}
	table td{
		text-align: center;
	}
</style>
<section class="container">
	<div>
		<h2>Excavation Statistics</h2>
		<h4>{{$thisYear}} vs. {{$lastYear}}</h4>
		<table style="width: 100%; font-size: 11px;">
			<thead>
				<tr>
					<th>Office</th>
					<th>Year</th>
					<th>Jan</th>
					<th>Feb</th>
					<th>Mar</th>
					<th>Apr</th>
					<th>May</th>
					<th>Jun</th>
					<th>Jul</th>
					<th>Aug</th>
					<th>Sep</th>
					<th>Oct</th>
					<th>Nov</th>
					<th>Dec</th>
					<th>Total</th>
				</tr>
			</thead>
			<tbody>
				<tr>
					<td>{{$office}}</td>
					<td>{{$thisYear}}</td>
					@for($i=1; $i<=12; $i++)
					<td>{{$result['This'][$i]}}</td>
					@endfor
					<td>{{$result['This']['Total']}}</td>
				</tr>
				<tr>
					<td>{{$office}}</td>
					<td>{{$lastYear}}</td>
					@for($i=1; $i<=12; $i++)
					<td>{{$result['Last'][$i]}}</td>
					@endfor
					<td>{{$result['Last']['Total']}}</td>
				</tr>
				<tr>
					<td>{{$office}}</td>
					<td></td>
					@for($i=1; $i<=12; $i++)
					<td>{{$result['This'][$i] - $result['Last'][$i]}}</td>
					@endfor
					<td>{{$result['This']['Total'] - $result['Last']['Total']}}</td>
				</tr>
				<tr>
					<td colspan="15" style="border-top: 1px solid grey;"></td>
				</tr>
				<tr>
					<td colspan="14" style="text-align: right;"><b>{{$thisYear}} YTD Total</b></td>
					<td><b>{{$result['This']['Total']}}</b></td>
				</tr>
				<tr>
					<td colspan="14" style="text-align: right;"><b>{{$lastYear}} Total</b></td>
					<td><b>{{$result['Last']['Total']}}</b></td>
				</tr>
				<tr>
					<td colspan="14" style="text-align: right;"><b>Difference</b></td>
					<td><b>{{$result['This']['Total'] - $result['Last']['Total']}}</b></td>
				</tr>
			</tbody>
		</table>
	</div>
</section>
@endsection