@extends('layouts.default')

@section('title')
@parent
Статистика за день
@stop

@section('content')

@if (Sentry::check() )
	<div class="col-md-8 col-md-offset-2">
		<div class="panel panel-default">
			 <div class="panel-heading">
				<h3 class="panel-title">Статистика
					<div class="btn-group btn-group-sm">
						@if (isset($stat[0]))
						<a class="btn @if ($date == $stat[0]->date) btn-success active @else btn-default @endif" href="/">Сегодня ({{ $stat[0]->cntAll }})</a>
						@endif
						@if (isset($stat[1]))
						<a class="btn @if ($date == $stat[1]->date) btn-success active @else btn-default @endif" href="/?date={{ $stat[1]->date }}">Вчера ({{ $stat[1]->cntAll }})</a>
						@endif
						@if (isset($stat[2]))
						<a class="btn @if ($date == $stat[2]->date) btn-success active @else btn-default @endif" href="/?date={{ $stat[2]->date }}">Позавчера ({{ $stat[2]->cntAll }})</a>
						@endif
					</div>
				</h3>
			</div>
			<table class="table table-striped table-hover lead-stat">
				<thead>
					<tr>
						<th>Проект</th>
						<th class="text-center">Новые</th>
						<th class="text-center">В&nbsp;работе</th>
						<th class="text-center">Всего</th>
					</tr>
				</thead>
				<tbody>
					@foreach ($projects as $project)
					<?php
						$entrypoints = $project->leadsWithTrashed()->whereRaw($dateWhere)->groupBy('entrypoint')->get(array(DB::raw('COUNT(id) as cntAll, SUM((CASE WHEN (deleted_at IS NULL) THEN 1 ELSE 0 END)) as cntIsNew, SUM((CASE WHEN (isbad != 1 AND deleted_at IS NOT NULL) THEN 1 ELSE 0 END)) as cntIsOk, entrypoint as name')));
					?>
					<tr>
						<td>
							<p><b>{{ $project->name }}</b></p>
							<p>
								@foreach ($entrypoints as $entrypoint)
									@if ($entrypoint->name)
										&nbsp;&nbsp;&nbsp;{{ $entrypoint->name }}<br/>
									@else
										&nbsp;&nbsp;&nbsp;&mdash;<br/>
									@endif
								@endforeach
							</p>
						</td>
						<td>
							<?php
								$projectLeadCnt = $project->leads()->whereRaw($dateWhere)->count();
							?>
							<p class="text-center"><span class="leadCntAll">{{ $projectLeadCnt }}</span></p>
							<p class="text-center">
								@foreach ($entrypoints as $entrypoint)
								<span class="leadCnt">{{ $entrypoint->cntIsNew }}</span><br/>
								@endforeach
							</p>
						</td>
						<td>
							<?php
								$projectLeadCnt = $project->leadsWithTrashed()->whereIsbad(0)->whereNotNull('deleted_at')->whereRaw($dateWhere)->count();
							?>
							<p class="text-center"><span class="leadCntAll">{{ $projectLeadCnt }}</span></p>
							<p class="text-center">
								@foreach ($entrypoints as $entrypoint)
								<span class="leadCnt">{{ $entrypoint->cntIsOk }}</span><br/>
								@endforeach
							</p>
						</td>
						<td>
							<?php
								$projectLeadCnt = $project->leadsWithTrashed()->whereRaw($dateWhere)->count();
								$projectdiff = $projectLeadCnt - $project->leads()->whereRaw('TIME(created_at)<TIME(NOW()) AND DATE(created_at)=DATE(DATE_SUB(?, INTERVAL 1 DAY))', array($date))->count();
							?>
							<p class="text-center"><span class="leadCntAll">{{ $projectLeadCnt }}</span>@if ($today && $projectdiff)<span class="@if ($projectdiff<0) diff-minus @elseif ($projectdiff>0) diff-plus @endif">@if($projectdiff>0)+@endif{{ $projectdiff }}</span>@endif</p>
							<p class="text-center">
								@foreach ($entrypoints as $entrypoint)
								<?php
									$diff = $entrypoint->cntAll - $entrypoint->getBeforeCnt($project->id, $entrypoint->name, $date);
								?>
								<span class="leadCnt">{{ $entrypoint->cntAll }}</span>@if ($today && $diff)<span class="@if ($diff<0) diff-minus @elseif ($diff>0) diff-plus @endif">@if($diff>0)+@endif{{ $diff }}</span>@endif<br/>
								@endforeach
							</p>
						</td>
					</tr>
					@endforeach
				</tbody>
			</table>
		</div>
	</div>
@endif


@stop