@extends('layouts.default')

@section('title')
@parent
Статистика по рабочим
@stop

@section('css')
	<link rel="stylesheet" href="{{ asset('css/datepicker.css') }}">
@stop

@section('js')
	<script src="{{ asset('js/kmk-support.js') }}"></script>
	<script src="{{ asset('js/bootstrap-datepicker.js') }}"></script>
	<script>
		function reload () {
			var params = kmkGiveGetParams(location.search);
			params['projectId'] = '{{ $input['projectId'] }}';
			params['startDate'] = $('#startDate').val();
			params['endDate'] = $('#endDate').val();
			kmkSetBrowserAddressParams(kmkObjectToGetString(params, false));
			location.reload();
		}

		$(document).ready(function(){
			var startDate = $('#startDate')
				.datepicker({
					format: 'dd.mm.yyyy',
					weekStart: 1
				})
				.on('changeDate', function(ev) {
					$('#startDate').datepicker('hide');
					if (ev.date.valueOf() > endDate.date.valueOf()){
						startDate.setValue(endDate.date);
			    }
					reload();
				}).data('datepicker');
			var endDate = $('#endDate')
				.datepicker({
					format: 'dd.mm.yyyy',
					weekStart: 1
				})
				.on('changeDate', function(ev) {
					$('#endDate').datepicker('hide');
					if (ev.date.valueOf() < startDate.date.valueOf()){
						endDate.setValue(startDate.date);
			    }
					reload();
				}).data('datepicker');
			});
	</script>
@stop

@section('content')
	<div class="well well-sm">
		<form class="form-inline" role="form">
			<div class="form-group">
				<label for="startDate">Дата производства с</label> <input id="startDate" name="startDate" class="form-control" value="{{ $input['startDate'] }}"/>
			</div>
			<div class="form-group">
				<label for="endDate">по</label> <input id="endDate" name="endDate" class="form-control" value="{{ $input['endDate'] }}"/>
			</div>
		</form>
	</div>
	<div class="panel panel-default">
		 <div class="panel-heading">
			<h3 class="panel-title"><b>Статистика по рабочим</b></h3>
		</div>
		<table class="table table-striped table-hover lead-stat">
			<thead>
				<tr>
					<th>ФИО</th>
					<th class="">Сегодня, <br>всего (полных)</th>
					<th class="">Вчера, <br>всего (полных)</th>
					<th class="">За выбранный период, <br>всего (полных)</th>
				</tr>
			</thead>
			<tbody>
				@foreach (ProductionMaster::orderBy('name', 'ASC')->get() as $master)
					<tr>
						<td>
							<p>{{ $master->name }}</p>
						</td>
						<td>
							<p class="">
								<span class="to-humanize">{{ $master->production()->whereRaw(DB::raw('DATE(production_end_at)=DATE(NOW())'))->count() }}</span>
								(<span class="to-humanize">{{ $master->production()->whereRaw(DB::raw('DATE(production_end_at)=DATE(NOW())'))->whereProductTypeId(3)->count() }}</span>)
								<?php 
								  $prodToday = $master->production()->whereRaw(DB::raw('DATE(production_end_at)=DATE(NOW())'))->whereProductTypeId(3)->get();
								?>
								@foreach($prodToday as $product)
							    <p>{{ $product->name }}</p>
								@endforeach
							</p>
						</td>
						<td>
							<p class="">
								<span class="to-humanize">{{ $master->production()->whereRaw(DB::raw('DATE(production_end_at)=DATE(DATE_SUB(NOW(), INTERVAL 1 DAY))'))->count() }}</span>
								(<span class="to-humanize">{{ $master->production()->whereRaw(DB::raw('DATE(production_end_at)=DATE(DATE_SUB(NOW(), INTERVAL 1 DAY))'))->whereProductTypeId(3)->count() }}</span>)
								<?php 
								  $prodYesterday = $master->production()->whereRaw(DB::raw('DATE(production_end_at)=DATE(DATE_SUB(NOW(), INTERVAL 1 DAY))'))->whereProductTypeId(3)->get();
								?>
								@foreach($prodYesterday as $product)
							    <p>{{ $product->name }}</p>
								@endforeach
							</p>
						</td>
						<td>
							<p class="text-left">
								<span class="to-humanize">{{ $master->production()->whereRaw($dateWhere)->count() }}</span>
								(<span class="to-humanize">{{ $master->production()->whereRaw($dateWhere)->whereProductTypeId(3)->count() }}</span>)
								<?php 
								  $prodAll = $master->production()->whereRaw($dateWhere)->whereProductTypeId(3)->get();
								?>
								@foreach($prodAll as $product)
							    <p class="text-left">{{ $product->name }}</p>
								@endforeach
							</p>
						</td>
					</tr>
				@endforeach
			</tbody>
		</table>
	</div>
@stop