@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'] = '9';
			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');

			var today = new Date();
			$("#todayDate").data('date', today.getDate()+'.'+(parseInt(today.getMonth())+1)+'.'+today.getFullYear());
			today.setDate(today.getDate()-1);
			$("#yeasterdayDate").data('date', today.getDate()+'.'+(parseInt(today.getMonth())+1)+'.'+today.getFullYear());

			$('.btn-set-date').unbind('click').on('click', function(){
				$('#startDate').val($(this).data('date'));
				$('#endDate').val($(this).data('date'));
				reload();
				return false;
			});
		});
	</script>
@stop

@section('content')
	<section id="widget-grid-1">
		<div class="row">
			<article class="col-xs-12 col-sm-12 col-md-12 col-lg-12">
				<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>
						<div class="form-group">
							<button id="yeasterdayDate" class="btn btn-default btn-set-date" data-date="">Вчера</button>
							<button id="todayDate" class="btn btn-default btn-set-date">Сегодня</button>
						</div>
					</form>
					<br/>

				</div>
			</article>

			<article class="col-xs-12 col-sm-12 col-md-12 col-lg-12">
				<div class="jarviswidget" id="wid-id-1" data-widget-colorbutton="false" data-widget-editbutton="false" data-widget-sortable="false" data-widget-deletebutton="false" data-widget-togglebutton="false">
					<!-- widget div-->
					<div>
						<!-- widget edit box -->
						<div class="jarviswidget-editbox">
							<!-- This area used as dropdown edit box -->
						</div>
						<!-- end widget edit box -->

						<!-- widget content -->
							<div class="panel panel-default">
								<div class="panel-heading">
			            <h3 class="panel-title"><b>Статистика производства по маркам и моделям авто</b></h3>
		            </div>
								<table class="table table-striped table-hover">
									<thead>
										<tr>
											<th>Марка</th>
											<th>Название</th>
											<th>Годы выпуска</th>
											<th>Кол-во</th>
										</tr>
									</thead>
									<tbody>
										<?php 
										  $markProductions = Production::select(DB::raw('m.name as mark,
																																		products.name as name,
																																		Count(products.id) AS count,
																																		products.year_start as yearStart,
																																		products.year_end as yearEnd'))
																										->leftJoin('products', 'products.id', '=', 'productions.product_id')
																										->leftJoin('marks as m', 'm.id', '=', 'products.mark_id')
															                      ->whereRaw('('.$dateCreatePartners.')')
																										->groupBy('products.name')
																										->orderBy('m.name', 'ASC')
																										->orderBy('count', 'DESC')
															                      ->get();
											?>
										@foreach($markProductions as $markProduction)
										<tr>
											<td>{{ $markProduction->mark }}</td>
											<td>{{ $markProduction->name }}</td>
											<td>{{ $markProduction->yearStart }} - {{ $markProduction->yearEnd }}</td>
											<td>{{ $markProduction->count }}</td>
										</tr>
										@endforeach
									</tbody>
								</table>
							</div>
						<!-- end widget content -->
					</div>
					<!-- end widget div -->
				</div>
				<!-- end widget -->
			</article>
		</div>
	</section>
@stop