@extends('layouts.default')

@section('title')
	@parent
	Статистика отдела кадров
@stop

@section('breadcrumbs')
	{{ Breadcrumbs::render('stat.hr.leads') }}
@stop

@section('js')
	<script src="{{ asset('js/kmk-support.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(){
			$('#useLeadDate').change(function(){
				reload();
			});

			var startDate = $('#startDate')
				.datepicker({
					onClose: function( selectedDate ) {
						$("#endDate").datepicker( "option", "minDate", selectedDate );
						reload();
					}
				});
			var endDate = $('#endDate')
				.datepicker({
					onClose: function( selectedDate ) {
						$( "#startDate" ).datepicker( "option", "maxDate", selectedDate );
						reload();
					}
				});

			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')
	<div class="row">
		<div class="col-xs-12 col-sm-8 col-md-8 col-lg-8">
			<h1 class="page-title txt-color-blueDark">
				<i class="fa fa-bar-chart-o fa-fw"></i>
				Статистика отдела кадров
			</h1>
		</div>
	</div>

	<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/>
					@foreach ($user->projects()->whereUsecrm(1)->whereType(Project::TYPE_HR)->get() as $currentProject)
					<a href="/stat/hr/leads?projectId={{ $currentProject->id }}" class="btn btn-sm btn-default @if ($input['projectId'] == $currentProject->id) active @endif" data-id="{{ $currentProject->id }}">{{ $currentProject->name }}</a>
					@endforeach
				</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">
					<header>
						<span class="widget-icon"> <i class="fa fa-bar-chart-o"></i> </span>
						<h2>Статистика по заявкам</h2>
					</header>

					<!-- 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="widget-body">
							<div class="table-responsive">
								<table class="table table-striped table-hover">
									<thead>
										<tr>
											<th>Проект</th>
											<th class="text-center">Заявки</th>
											<th class="text-center">Не обработано</th>
											<th class="text-center">Отказ</th>
											<th class="text-center">Повтор</th>
											<th class="text-center">Неверный номер</th>
											<th class="text-center">В работе</th>
											<th class="text-center">Резерв</th>
											<th class="text-center">Назначено собеседование</th>
											<th class="text-center">На рассмотрении</th>
											<th class="text-center">Стажировка</th>
											<th class="text-center">Работа</th>
										</tr>
									</thead>
									<tbody>
										@foreach ($projects as $project)
											<tr>
												<td>
													<p>{{ $project->name }}</p>
												</td>
												<td>
													<?php
														$leadsCnt = $project->leadsWithTrashed()->whereRaw($dateWhere2)->count(DB::raw('distinct visitor_id'));
														$leadsCnt2 = $project->leadsWithTrashed()->whereRaw($dateWhere2)->count();
														$leadsCntDiff = 0;
														//$leadsCntDiff = $leadsCnt - $project->leadsWithTrashed()->whereRaw('TIME(created_at)<TIME(NOW()) AND DATE(created_at)=DATE(DATE_SUB(NOW(), INTERVAL 1 DAY))')->count(DB::raw('distinct visitor_id'));
													?>
													<p class="text-center">{{ $leadsCnt }} ({{ $leadsCnt2 }}) @if($leadsCntDiff)<span class="@if ($leadsCntDiff<0) diff-minus @elseif ($leadsCntDiff>0) diff-plus @endif">@if($leadsCntDiff>0)+@endif{{ $leadsCntDiff }}</span>@endif</p>
												</td>
												<td>
													<p class="text-center">{{ $project->leads()->whereRaw($dateWhere2)->count() }}</p>
												</td>
												<td>
													<p class="text-center">{{ $project->partners()->checkStatus(array('statusType'=>'reject'))->whereRaw($dateWhere)->count() }}</p>
												</td>
												<td>
													<p class="text-center">{{ $project->partners()->whereStatus(Partner::STATUS_REPEATED)->whereRaw($dateWhere)->count() }}</p>
												</td>
												<td>
													<p class="text-center">{{ $project->partners()->whereStatus(Partner::STATUS_TRASH_PHONE)->whereRaw($dateWhere)->count() }}</p>
												</td>
												<td>
													<p class="text-center">{{ $project->partners()->checkStatus(array('statusType'=>'work'))->whereRaw($dateWhere)->count() }}</p>
												</td>
												<td>
													<p class="text-center">{{ $project->partners()->checkStatus(array('statusType'=>'hr_reserve'))->whereRaw($dateWhere)->count() }}</p>
												</td>
												<td>
													<p class="text-center">{{ $project->partners()->checkStatus(array('statusType'=>'hr_interviewwait'))->whereRaw($dateWhere)->count() }}</p>
												</td>
												<td>
													<p class="text-center">{{ $project->partners()->checkStatus(array('statusType'=>'hr_test'))->whereRaw($dateWhere)->count() }}</p>
												</td>
												<td>
													<p class="text-center">{{ $project->partners()->checkStatus(array('statusType'=>'hr_traineeship'))->whereRaw($dateWhere)->count() }}</p>
												</td>
												<td>
													<p class="text-center">{{ $project->partners()->checkStatus(array('statusType'=>'hr_employed'))->whereRaw($dateWhere)->count() }}</p>
												</td>
											</tr>
											<?php
												$entrypoints = $project->leads()->withTrashed()->whereRaw($dateWhere2)->groupBy('entrypoint')->orderBy('entrypoint', 'ASC')->get(array(DB::raw('COUNT(*) as cnt, entrypoint')));
											?>
											@foreach ($entrypoints as $entrypoint)
												<tr>
													<td>
														<p>&nbsp;&nbsp;&nbsp;<small>{{ $entrypoint->entrypoint }}</small></p>
													</td>
													<td>
														<?php
															$leadsCnt = $project->leadsWithTrashed()->whereEntrypoint($entrypoint->entrypoint)->whereRaw($dateWhere2)->count(DB::raw('distinct visitor_id'));
															$leadsCnt2 = $project->leadsWithTrashed()->whereEntrypoint($entrypoint->entrypoint)->whereRaw($dateWhere2)->count();
															$leadsCntDiff = 0;
															//$leadsCntDiff = $leadsCnt - $project->leadsWithTrashed()->whereEntrypoint($entrypoint->entrypoint)->whereRaw('TIME(created_at)<TIME(NOW()) AND DATE(created_at)=DATE(DATE_SUB(NOW(), INTERVAL 1 DAY))')->count(DB::raw('distinct visitor_id'));
														?>
														<p class="text-center">{{ $leadsCnt }} ({{ $leadsCnt2 }}) @if($leadsCntDiff)<span class="@if ($leadsCntDiff<0) diff-minus @elseif ($leadsCntDiff>0) diff-plus @endif">@if($leadsCntDiff>0)+@endif{{ $leadsCntDiff }}</span>@endif</p>
													</td>
													<td>
														<p class="text-center">{{ $project->leads()->whereEntrypoint($entrypoint->entrypoint)->whereRaw($dateWhere2)->count() }}</p>
													</td>
													<td>
														<p class="text-center">{{ $project->partners()->checkStatus(array('statusType'=>'reject'))->whereRaw($dateWhere)->whereRaw(DB::raw('lead_id IN (SELECT id FROM leads WHERE '.$dateWhere2.' AND entrypoint="'.$entrypoint->entrypoint.'")'))->count() }}</p>
													</td>
													<td>
														<p class="text-center">{{ $project->partners()->whereStatus(Partner::STATUS_REPEATED)->whereRaw($dateWhere)->whereRaw(DB::raw('lead_id IN (SELECT id FROM leads WHERE '.$dateWhere2.' AND entrypoint="'.$entrypoint->entrypoint.'")'))->count() }}</p>
													</td>
													<td>
														<p class="text-center">{{ $project->partners()->whereStatus(Partner::STATUS_TRASH_PHONE)->whereRaw($dateWhere)->whereRaw(DB::raw('lead_id IN (SELECT id FROM leads WHERE '.$dateWhere2.' AND entrypoint="'.$entrypoint->entrypoint.'")'))->count() }}</p>
													</td>
													<td>
														<p class="text-center">{{ $project->partners()->checkStatus(array('statusType'=>'work'))->whereRaw($dateWhere)->whereRaw(DB::raw('lead_id IN (SELECT id FROM leads WHERE '.$dateWhere2.' AND entrypoint="'.$entrypoint->entrypoint.'")'))->count() }}</p>
													</td>
													<td>
														<p class="text-center">{{ $project->partners()->checkStatus(array('statusType'=>'hr_reserve'))->whereRaw($dateWhere)->whereRaw(DB::raw('lead_id IN (SELECT id FROM leads WHERE '.$dateWhere2.' AND entrypoint="'.$entrypoint->entrypoint.'")'))->count() }}</p>
													</td>
													<td>
														<p class="text-center">{{ $project->partners()->checkStatus(array('statusType'=>'hr_interviewwait'))->whereRaw($dateWhere)->whereRaw(DB::raw('lead_id IN (SELECT id FROM leads WHERE '.$dateWhere2.' AND entrypoint="'.$entrypoint->entrypoint.'")'))->count() }}</p>
													</td>
													<td>
														<p class="text-center">{{ $project->partners()->checkStatus(array('statusType'=>'hr_test'))->whereRaw($dateWhere)->whereRaw(DB::raw('lead_id IN (SELECT id FROM leads WHERE '.$dateWhere2.' AND entrypoint="'.$entrypoint->entrypoint.'")'))->count() }}</p>
													</td>
													<td>
														<p class="text-center">{{ $project->partners()->checkStatus(array('statusType'=>'hr_traineeship'))->whereRaw($dateWhere)->whereRaw(DB::raw('lead_id IN (SELECT id FROM leads WHERE '.$dateWhere2.' AND entrypoint="'.$entrypoint->entrypoint.'")'))->count() }}</p>
													</td>
													<td>
														<p class="text-center">{{ $project->partners()->checkStatus(array('statusType'=>'hr_employed'))->whereRaw($dateWhere)->whereRaw(DB::raw('lead_id IN (SELECT id FROM leads WHERE '.$dateWhere2.' AND entrypoint="'.$entrypoint->entrypoint.'")'))->count() }}</p>
													</td>
												</tr>
											@endforeach
										@endforeach
									</tbody>
								</table>
							</div>
						</div>
						<!-- end widget content -->
					</div>
					<!-- end widget div -->
				</div>
				<!-- end widget -->
			</article>
		</div>
	</section>

@stop