@extends('layouts.default')

@section('title')
@parent
Статистика по менеджерам
@stop

@section('breadcrumbs')
	{{ Breadcrumbs::render('stat.finance') }}
@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">
		<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_SHOP)->get() as $currentProject)
					<a href="/stat/finance?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-0" 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="panel panel-default">
								 <div class="panel-heading">
									<h3 class="panel-title"><b>@if($input['startDate'] == $input['endDate']) за {{ $input['startDate'] }} @else с {{ $input['startDate'] }} по {{ $input['endDate'] }} @endif</b></h3>
								</div>
								<div class="table-responsive">
									<table class="table table-striped table-hover lead-stat">
										<thead>
											<tr>
												<th style="vertical-align:top">Менеджер</th>
												<th class="text-right" style="vertical-align:top">Заявок</th>
												<th class="text-right" style="vertical-align:top">Отказов</th>
												<th class="text-right" style="vertical-align:top">Оформлено</th>
												<th class="text-right" style="vertical-align:top">Менее 1 минуты</th>
												<th class="text-right" style="vertical-align:top">1-5 минут</th>
												<th class="text-right" style="vertical-align:top">5-10 минут</th>
												<th class="text-right" style="vertical-align:top">10-30 минут</th>
												<th class="text-right" style="vertical-align:top">30-60 минут</th>
												<th class="text-right" style="vertical-align:top">Более часа</th>
											</tr>
										</thead>
										<tbody>
											@foreach ($projects as $project)
												@if($projects->count() == 1)
													@foreach (User::withTrashed()->whereRaw('id in (SELECT user_id FROM users_projects WHERE project_id=?)', array($project->id))->get() as $manager)
														<?php
															$leadsQuant = $project->partners()->whereUserId($manager->id)->whereRaw($dateWhere)->count();
															$stat = $project->partners()->whereUserId($manager->id)->whereRaw($dateWhere)->checkStatus(array('statType' => 'agreed', 'type'=>'all'))->get(array(DB::raw('COUNT(*) as cnt, SUM(cartprice) as cartprice, SUM(purchaseprice) as purchaseprice, SUM(discount) as discount')))->first();
															$rejectsQuant = $project->partners()->whereUserId($manager->id)->whereRaw($dateWhere)->checkStatus(array('statusType'=>'reject'))->count();
															$agreePercent = 0;
															$rejectsPercent = 0;
															if ($leadsQuant) {
																$agreePercent = round(($stat->cnt * 100) / $leadsQuant, 0);
																$rejectsPercent = round(($rejectsQuant * 100) / $leadsQuant, 0);
															}
														?>
														@if($manager->hasRole(Role::ROLE_CRM) && !$manager->isAdmin() && ($leadsQuant || $stat->cnt))
															<tr>
																<td>
																	<p>{{ $manager->first_name }} {{ $manager->last_name }}</p>
																</td>
																<td class="text-right">
																	<p>
																		{{ $leadsQuant }}
																	</p>
																</td>
																<td>
																	<p class="text-right">
																		{{ $rejectsQuant }} ({{ $rejectsPercent }}%)
																	</p>
																</td>
																<td>
																	<p class="text-right">
																		{{ $stat->cnt }} ({{ $agreePercent }}%)<br/>
																		<span class="to-humanize" title="Сумма">{{ $stat->cartprice }}</span> <i class="fa fa-rub"></i><br/>
																		<span class="to-humanize" title="Средний чек">{{ ($stat->cnt) ? (round($stat->cartprice / $stat->cnt, 0)) : 0 }}</span> <i class="fa fa-rub"></i>
																		{{--<span class="to-humanize" title="Прибыль">{{ $stat->cartprice - $stat->purchaseprice }}</span> <i class="fa fa-rub"></i>--}}
																	</p>
																</td>
																<td>
																	<?php
																		$quantAll = $project->partners()->whereUserId($manager->id)->whereRaw($dateWhere)->whereRaw('TIME_TO_SEC(TIMEDIFF(partners.created_at,partners.lead_created_at))<=60')->count();
																		$quant = $project->partners()->whereUserId($manager->id)->whereRaw($dateWhere)->whereRaw('TIME_TO_SEC(TIMEDIFF(partners.created_at,partners.lead_created_at))<=60')->checkStatus(array('statType' => 'agreed', 'type'=>'all'))->count();
																		$sum = $project->partners()->whereUserId($manager->id)->whereRaw($dateWhere)->whereRaw('TIME_TO_SEC(TIMEDIFF(partners.created_at,partners.lead_created_at))<=60')->checkStatus(array('statType' => 'agreed', 'type'=>'all'))->sum('cartprice');
																		$quantPercent = 0;
																		if ($quantAll) {
																			$quantPercent = round(($quant * 100) / $quantAll, 0);
																		}
																	?>
																	<p class="text-right">
																		{{ $quantAll }}/{{ $quant }}<br/>{{ $quantPercent }}%<br/>
																		<span class="to-humanize" title="Средний чек">{{ ($quant) ? (round($sum / $quant, 0)) : 0 }}</span> <i class="fa fa-rub"></i>
																	</p>
																</td>
																<td>
																	<?php
																		$quantAll = $project->partners()->whereUserId($manager->id)->whereRaw($dateWhere)->whereRaw('TIME_TO_SEC(TIMEDIFF(partners.created_at,partners.lead_created_at))>60 AND TIME_TO_SEC(TIMEDIFF(partners.created_at,partners.lead_created_at))<=5*60')->count();
																		$quant = $project->partners()->whereUserId($manager->id)->whereRaw($dateWhere)->whereRaw('TIME_TO_SEC(TIMEDIFF(partners.created_at,partners.lead_created_at))>60 AND TIME_TO_SEC(TIMEDIFF(partners.created_at,partners.lead_created_at))<=5*60')->checkStatus(array('statType' => 'agreed', 'type'=>'all'))->count();
																		$sum = $project->partners()->whereUserId($manager->id)->whereRaw($dateWhere)->whereRaw('TIME_TO_SEC(TIMEDIFF(partners.created_at,partners.lead_created_at))>60 AND TIME_TO_SEC(TIMEDIFF(partners.created_at,partners.lead_created_at))<=5*60')->checkStatus(array('statType' => 'agreed', 'type'=>'all'))->sum('cartprice');
																		$quantPercent = 0;
																		if ($quantAll) {
																			$quantPercent = round(($quant * 100) / $quantAll, 0);
																		}
																	?>
																	<p class="text-right">
																		{{ $quantAll }}/{{ $quant }}<br/>{{ $quantPercent }}%<br/>
																		<span class="to-humanize" title="Средний чек">{{ ($quant) ? (round($sum / $quant, 0)) : 0 }}</span> <i class="fa fa-rub"></i>
																	</p>
																</td>
																<td>
																	<?php
																		$quantAll = $project->partners()->whereUserId($manager->id)->whereRaw($dateWhere)->whereRaw('TIME_TO_SEC(TIMEDIFF(partners.created_at,partners.lead_created_at))>5*60 AND TIME_TO_SEC(TIMEDIFF(partners.created_at,partners.lead_created_at))<=10*60')->count();
																		$quant = $project->partners()->whereUserId($manager->id)->whereRaw($dateWhere)->whereRaw('TIME_TO_SEC(TIMEDIFF(partners.created_at,partners.lead_created_at))>5*60 AND TIME_TO_SEC(TIMEDIFF(partners.created_at,partners.lead_created_at))<=10*60')->checkStatus(array('statType' => 'agreed', 'type'=>'all'))->count();
																		$sum = $project->partners()->whereUserId($manager->id)->whereRaw($dateWhere)->whereRaw('TIME_TO_SEC(TIMEDIFF(partners.created_at,partners.lead_created_at))>5*60 AND TIME_TO_SEC(TIMEDIFF(partners.created_at,partners.lead_created_at))<=10*60')->checkStatus(array('statType' => 'agreed', 'type'=>'all'))->sum('cartprice');
																		$quantPercent = 0;
																		if ($quantAll) {
																			$quantPercent = round(($quant * 100) / $quantAll, 0);
																		}
																	?>
																	<p class="text-right">
																		{{ $quantAll }}/{{ $quant }}<br/>{{ $quantPercent }}%<br/>
																		<span class="to-humanize" title="Средний чек">{{ ($quant) ? (round($sum / $quant, 0)) : 0 }}</span> <i class="fa fa-rub"></i>
																	</p>
																</td>
																<td>
																	<?php
																		$quantAll = $project->partners()->whereUserId($manager->id)->whereRaw($dateWhere)->whereRaw('TIME_TO_SEC(TIMEDIFF(partners.created_at,partners.lead_created_at))>10*60 AND TIME_TO_SEC(TIMEDIFF(partners.created_at,partners.lead_created_at))<=30*60')->count();
																		$quant = $project->partners()->whereUserId($manager->id)->whereRaw($dateWhere)->whereRaw('TIME_TO_SEC(TIMEDIFF(partners.created_at,partners.lead_created_at))>10*60 AND TIME_TO_SEC(TIMEDIFF(partners.created_at,partners.lead_created_at))<=30*60')->checkStatus(array('statType' => 'agreed', 'type'=>'all'))->count();
																		$sum = $project->partners()->whereUserId($manager->id)->whereRaw($dateWhere)->whereRaw('TIME_TO_SEC(TIMEDIFF(partners.created_at,partners.lead_created_at))>10*60 AND TIME_TO_SEC(TIMEDIFF(partners.created_at,partners.lead_created_at))<=30*60')->checkStatus(array('statType' => 'agreed', 'type'=>'all'))->sum('cartprice');
																		$quantPercent = 0;
																		if ($quantAll) {
																			$quantPercent = round(($quant * 100) / $quantAll, 0);
																		}
																	?>
																	<p class="text-right">
																		{{ $quantAll }}/{{ $quant }}<br/>{{ $quantPercent }}%<br/>
																		<span class="to-humanize" title="Средний чек">{{ ($quant) ? (round($sum / $quant, 0)) : 0 }}</span> <i class="fa fa-rub"></i>
																	</p>
																</td>
																<td>
																	<?php
																		$quantAll = $project->partners()->whereUserId($manager->id)->whereRaw($dateWhere)->whereRaw('TIME_TO_SEC(TIMEDIFF(partners.created_at,partners.lead_created_at))>30*60 AND TIME_TO_SEC(TIMEDIFF(partners.created_at,partners.lead_created_at))<=60*60')->count();
																		$quant = $project->partners()->whereUserId($manager->id)->whereRaw($dateWhere)->whereRaw('TIME_TO_SEC(TIMEDIFF(partners.created_at,partners.lead_created_at))>30*60 AND TIME_TO_SEC(TIMEDIFF(partners.created_at,partners.lead_created_at))<=60*60')->checkStatus(array('statType' => 'agreed', 'type'=>'all'))->count();
																		$sum = $project->partners()->whereUserId($manager->id)->whereRaw($dateWhere)->whereRaw('TIME_TO_SEC(TIMEDIFF(partners.created_at,partners.lead_created_at))>30*60 AND TIME_TO_SEC(TIMEDIFF(partners.created_at,partners.lead_created_at))<=60*60')->checkStatus(array('statType' => 'agreed', 'type'=>'all'))->sum('cartprice');
																		$quantPercent = 0;
																		if ($quantAll) {
																			$quantPercent = round(($quant * 100) / $quantAll, 0);
																		}
																	?>
																	<p class="text-right">
																		{{ $quantAll }}/{{ $quant }}<br/>{{ $quantPercent }}%<br/>
																		<span class="to-humanize" title="Средний чек">{{ ($quant) ? (round($sum / $quant, 0)) : 0 }}</span> <i class="fa fa-rub"></i>
																	</p>
																</td>
																<td>
																	<?php
																		$quantAll = $project->partners()->whereUserId($manager->id)->whereRaw($dateWhere)->whereRaw('TIME_TO_SEC(TIMEDIFF(partners.created_at,partners.lead_created_at))>60*60')->count();
																		$quant = $project->partners()->whereUserId($manager->id)->whereRaw($dateWhere)->whereRaw('TIME_TO_SEC(TIMEDIFF(partners.created_at,partners.lead_created_at))>60*60')->checkStatus(array('statType' => 'agreed', 'type'=>'all'))->count();
																		$sum = $project->partners()->whereUserId($manager->id)->whereRaw($dateWhere)->whereRaw('TIME_TO_SEC(TIMEDIFF(partners.created_at,partners.lead_created_at))>60*60')->checkStatus(array('statType' => 'agreed', 'type'=>'all'))->sum('cartprice');
																		$quantPercent = 0;
																		if ($quantAll) {
																			$quantPercent = round(($quant * 100) / $quantAll, 0);
																		}
																	?>
																	<p class="text-right">
																		{{ $quantAll }}/{{ $quant }}<br/>{{ $quantPercent }}%<br/>
																		<span class="to-humanize" title="Средний чек">{{ ($quant) ? (round($sum / $quant, 0)) : 0 }}</span> <i class="fa fa-rub"></i>
																	</p>
																</td>
															</tr>
													@endif
													@endforeach
												@endif
												<tr>
													<td>
														@if($projects->count() == 1)
															<p><b>Итого</b></p>
														@else
															<p>{{ $project->name }}</p>
														@endif
													</td>
													<?php
														$leadsQuant = $project->partners()->whereRaw($dateWhere)->count();
														$stat = $project->partners()->whereRaw($dateWhere)->checkStatus(array('statType' => 'agreed', 'type'=>'all'))->get(array(DB::raw('COUNT(*) as cnt, SUM(cartprice) as cartprice, SUM(purchaseprice) as purchaseprice, SUM(discount) as discount')))->first();
														$rejectsQuant = $project->partners()->whereRaw($dateWhere)->checkStatus(array('statusType'=>'reject'))->count();
														$agreePercent = 0;
														$rejectsPercent = 0;
														if ($leadsQuant) {
															$agreePercent = round(($stat->cnt * 100) / $leadsQuant, 0);
															$rejectsPercent = round(($rejectsQuant * 100) / $leadsQuant, 0);
														}
													?>
													<td class="text-right">
														<p>
															{{ $leadsQuant }}
														</p>
													</td>
													<td>
														<p class="text-right">
															{{ $rejectsQuant }} ({{ $rejectsPercent }}%)
														</p>
													</td>
													<td>
														<p class="text-right">
															{{ $stat->cnt }} ({{ $agreePercent }}%)<br/>
															<span class="to-humanize" title="Сумма">{{ $stat->cartprice }}</span> <i class="fa fa-rub"></i><br/>
															<span class="to-humanize" title="Средний чек">{{ ($stat->cnt) ? (round($stat->cartprice / $stat->cnt, 0)) : 0 }}</span> <i class="fa fa-rub"></i>
															{{--<span class="to-humanize" title="Прибыль">{{ $stat->cartprice - $stat->purchaseprice }}</span> <i class="fa fa-rub"></i>--}}
														</p>
													</td>
													<td>
														<?php
															$quantAll = $project->partners()->whereRaw($dateWhere)->whereRaw('TIME_TO_SEC(TIMEDIFF(partners.created_at,partners.lead_created_at))<=60')->count();
															$quant = $project->partners()->whereRaw($dateWhere)->whereRaw('TIME_TO_SEC(TIMEDIFF(partners.created_at,partners.lead_created_at))<=60')->checkStatus(array('statType' => 'agreed', 'type'=>'all'))->count();
															$sum = $project->partners()->whereRaw($dateWhere)->whereRaw('TIME_TO_SEC(TIMEDIFF(partners.created_at,partners.lead_created_at))<=60')->checkStatus(array('statType' => 'agreed', 'type'=>'all'))->sum('cartprice');
															$quantPercent = 0;
															if ($quantAll) {
																$quantPercent = round(($quant * 100) / $quantAll, 0);
															}
														?>
														<p class="text-right">
															{{ $quantAll }}/{{ $quant }}<br/>{{ $quantPercent }}%<br/>
															<span class="to-humanize" title="Средний чек">{{ ($quant) ? (round($sum / $quant, 0)) : 0 }}</span> <i class="fa fa-rub"></i>
														</p>
													</td>
													<td>
														<?php
															$quantAll = $project->partners()->whereRaw($dateWhere)->whereRaw('TIME_TO_SEC(TIMEDIFF(partners.created_at,partners.lead_created_at))>60 AND TIME_TO_SEC(TIMEDIFF(partners.created_at,partners.lead_created_at))<=5*60')->count();
															$quant = $project->partners()->whereRaw($dateWhere)->whereRaw('TIME_TO_SEC(TIMEDIFF(partners.created_at,partners.lead_created_at))>60 AND TIME_TO_SEC(TIMEDIFF(partners.created_at,partners.lead_created_at))<=5*60')->checkStatus(array('statType' => 'agreed', 'type'=>'all'))->count();
															$sum = $project->partners()->whereRaw($dateWhere)->whereRaw('TIME_TO_SEC(TIMEDIFF(partners.created_at,partners.lead_created_at))>60 AND TIME_TO_SEC(TIMEDIFF(partners.created_at,partners.lead_created_at))<=5*60')->checkStatus(array('statType' => 'agreed', 'type'=>'all'))->sum('cartprice');
															$quantPercent = 0;
															if ($quantAll) {
																$quantPercent = round(($quant * 100) / $quantAll, 0);
															}
														?>
														<p class="text-right">
															{{ $quantAll }}/{{ $quant }}<br/>{{ $quantPercent }}%<br/>
															<span class="to-humanize" title="Средний чек">{{ ($quant) ? (round($sum / $quant, 0)) : 0 }}</span> <i class="fa fa-rub"></i>
														</p>
													</td>
													<td>
														<?php
															$quantAll = $project->partners()->whereRaw($dateWhere)->whereRaw('TIME_TO_SEC(TIMEDIFF(partners.created_at,partners.lead_created_at))>5*60 AND TIME_TO_SEC(TIMEDIFF(partners.created_at,partners.lead_created_at))<=10*60')->count();
															$quant = $project->partners()->whereRaw($dateWhere)->whereRaw('TIME_TO_SEC(TIMEDIFF(partners.created_at,partners.lead_created_at))>5*60 AND TIME_TO_SEC(TIMEDIFF(partners.created_at,partners.lead_created_at))<=10*60')->checkStatus(array('statType' => 'agreed', 'type'=>'all'))->count();
															$sum = $project->partners()->whereRaw($dateWhere)->whereRaw('TIME_TO_SEC(TIMEDIFF(partners.created_at,partners.lead_created_at))>5*60 AND TIME_TO_SEC(TIMEDIFF(partners.created_at,partners.lead_created_at))<=10*60')->checkStatus(array('statType' => 'agreed', 'type'=>'all'))->sum('cartprice');
															$quantPercent = 0;
															if ($quantAll) {
																$quantPercent = round(($quant * 100) / $quantAll, 0);
															}
														?>
														<p class="text-right">
															{{ $quantAll }}/{{ $quant }}<br/>{{ $quantPercent }}%<br/>
															<span class="to-humanize" title="Средний чек">{{ ($quant) ? (round($sum / $quant, 0)) : 0 }}</span> <i class="fa fa-rub"></i>
														</p>
													</td>
													<td>
														<?php
															$quantAll = $project->partners()->whereRaw($dateWhere)->whereRaw('TIME_TO_SEC(TIMEDIFF(partners.created_at,partners.lead_created_at))>10*60 AND TIME_TO_SEC(TIMEDIFF(partners.created_at,partners.lead_created_at))<=30*60')->count();
															$quant = $project->partners()->whereRaw($dateWhere)->whereRaw('TIME_TO_SEC(TIMEDIFF(partners.created_at,partners.lead_created_at))>10*60 AND TIME_TO_SEC(TIMEDIFF(partners.created_at,partners.lead_created_at))<=30*60')->checkStatus(array('statType' => 'agreed', 'type'=>'all'))->count();
															$sum = $project->partners()->whereRaw($dateWhere)->whereRaw('TIME_TO_SEC(TIMEDIFF(partners.created_at,partners.lead_created_at))>10*60 AND TIME_TO_SEC(TIMEDIFF(partners.created_at,partners.lead_created_at))<=30*60')->checkStatus(array('statType' => 'agreed', 'type'=>'all'))->sum('cartprice');
															$quantPercent = 0;
															if ($quantAll) {
																$quantPercent = round(($quant * 100) / $quantAll, 0);
															}
														?>
														<p class="text-right">
															{{ $quantAll }}/{{ $quant }}<br/>{{ $quantPercent }}%<br/>
															<span class="to-humanize" title="Средний чек">{{ ($quant) ? (round($sum / $quant, 0)) : 0 }}</span> <i class="fa fa-rub"></i>
														</p>
													</td>
													<td>
														<?php
															$quantAll = $project->partners()->whereRaw($dateWhere)->whereRaw('TIME_TO_SEC(TIMEDIFF(partners.created_at,partners.lead_created_at))>30*60 AND TIME_TO_SEC(TIMEDIFF(partners.created_at,partners.lead_created_at))<=60*60')->count();
															$quant = $project->partners()->whereRaw($dateWhere)->whereRaw('TIME_TO_SEC(TIMEDIFF(partners.created_at,partners.lead_created_at))>30*60 AND TIME_TO_SEC(TIMEDIFF(partners.created_at,partners.lead_created_at))<=60*60')->checkStatus(array('statType' => 'agreed', 'type'=>'all'))->count();
															$sum = $project->partners()->whereRaw($dateWhere)->whereRaw('TIME_TO_SEC(TIMEDIFF(partners.created_at,partners.lead_created_at))>30*60 AND TIME_TO_SEC(TIMEDIFF(partners.created_at,partners.lead_created_at))<=60*60')->checkStatus(array('statType' => 'agreed', 'type'=>'all'))->sum('cartprice');
															$quantPercent = 0;
															if ($quantAll) {
																$quantPercent = round(($quant * 100) / $quantAll, 0);
															}
														?>
														<p class="text-right">
															{{ $quantAll }}/{{ $quant }}<br/>{{ $quantPercent }}%<br/>
															<span class="to-humanize" title="Средний чек">{{ ($quant) ? (round($sum / $quant, 0)) : 0 }}</span> <i class="fa fa-rub"></i>
														</p>
													</td>
													<td>
														<?php
															$quantAll = $project->partners()->whereRaw($dateWhere)->whereRaw('TIME_TO_SEC(TIMEDIFF(partners.created_at,partners.lead_created_at))>60*60')->count();
															$quant = $project->partners()->whereRaw($dateWhere)->whereRaw('TIME_TO_SEC(TIMEDIFF(partners.created_at,partners.lead_created_at))>60*60')->checkStatus(array('statType' => 'agreed', 'type'=>'all'))->count();
															$sum = $project->partners()->whereRaw($dateWhere)->whereRaw('TIME_TO_SEC(TIMEDIFF(partners.created_at,partners.lead_created_at))>60*60')->checkStatus(array('statType' => 'agreed', 'type'=>'all'))->sum('cartprice');
															$quantPercent = 0;
															if ($quantAll) {
																$quantPercent = round(($quant * 100) / $quantAll, 0);
															}
														?>
														<p class="text-right">
															{{ $quantAll }}/{{ $quant }}<br/>{{ $quantPercent }}%<br/>
															<span class="to-humanize" title="Средний чек">{{ ($quant) ? (round($sum / $quant, 0)) : 0 }}</span> <i class="fa fa-rub"></i>
														</p>
													</td>
												</tr>
											@endforeach
										</tbody>
									</table>
								</div>
							</div>
						</div>
						<!-- end widget content -->
					</div>
					<!-- end widget div -->
				</div>
				<!-- end widget -->
			</article>

		</div>
	</section>
@stop