
<?php $__env->startSection('title'); ?>
@parent
Статистика по рабочим
<?php $__env->stopSection(); ?>

<?php $__env->startSection('css'); ?>
	<link rel="stylesheet" href="<?php echo asset('css/datepicker.css'); ?>">
<?php $__env->stopSection(); ?>

<?php $__env->startSection('js'); ?>
	<script src="<?php echo asset('js/kmk-support.js'); ?>"></script>
	<script src="<?php echo asset('js/bootstrap-datepicker.js'); ?>"></script>
	<script>
		function reload () {
			var params = kmkGiveGetParams(location.search);
			params['projectId'] = '<?php echo $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>
<?php $__env->stopSection(); ?>

<?php $__env->startSection('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="<?php echo $input['startDate']; ?>"/>
			</div>
			<div class="form-group">
				<label for="endDate">по</label> <input id="endDate" name="endDate" class="form-control" value="<?php echo $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>
				<?php foreach (ProductionMaster::orderBy('name', 'ASC')->get() as $master): ?>
					<tr>
						<td>
							<p><?php echo $master->name; ?></p>
						</td>
						<td>
							<p class="">
								<span class="to-humanize"><?php echo $master->production()->whereRaw(DB::raw('DATE(production_end_at)=DATE(NOW())'))->count(); ?></span>
								(<span class="to-humanize"><?php echo $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();
								?>
								<?php foreach($prodToday as $product): ?>
							    <p><?php echo $product->name; ?></p>
								<?php endforeach; ?>
							</p>
						</td>
						<td>
							<p class="">
								<span class="to-humanize"><?php echo $master->production()->whereRaw(DB::raw('DATE(production_end_at)=DATE(DATE_SUB(NOW(), INTERVAL 1 DAY))'))->count(); ?></span>
								(<span class="to-humanize"><?php echo $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();
								?>
								<?php foreach($prodYesterday as $product): ?>
							    <p><?php echo $product->name; ?></p>
								<?php endforeach; ?>
							</p>
						</td>
						<td>
							<p class="text-left">
								<span class="to-humanize"><?php echo $master->production()->whereRaw($dateWhere)->count(); ?></span>
								(<span class="to-humanize"><?php echo $master->production()->whereRaw($dateWhere)->whereProductTypeId(3)->count(); ?></span>)
								<?php 
								  $prodAll = $master->production()->whereRaw($dateWhere)->whereProductTypeId(3)->get();
								?>
								<?php foreach($prodAll as $product): ?>
							    <p class="text-left"><?php echo $product->name; ?></p>
								<?php endforeach; ?>
							</p>
						</td>
					</tr>
				<?php endforeach; ?>
			</tbody>
		</table>
	</div>
<?php $__env->stopSection(); ?>
<?php echo $__env->make('layouts.default', array_except(get_defined_vars(), array('__data', '__path')))->render(); ?>