@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();
			if ($('#useLeadDate:checked').length) {
				params['useLeadDate'] = 1;
			}
			else {
				params['useLeadDate'] = 0;
			}
			kmkSetBrowserAddressParams(kmkObjectToGetString(params, false));
			location.reload();
		}

		$(document).ready(function(){
			$('#useLeadDate').change(function(){
				reload();
			});

			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 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">Средние: доставка<br> чек<br>маржа</th>
										</tr>
									</thead>
									<tbody>
											<tr>
												<td> <!-- Проект-->
													<p>{{ $project->name }}</p>
												</td>
												<td> <!-- Заявки  -->
													<?php
														$entrypointsQuant = Partner::whereIsFranchiseesOrder(0)->whereRaw('(('.$datePartnerLeadCreate.') OR ('.$dateCreatePartners.' AND partners.lead_id = 0))')->count('partners.id');
													?>
													<p class="text-center">{{ $entrypointsQuant + $project->leads()->whereRaw($dateLeadCreate)->count()}}</p>
												</td>
												<td><!--  Не обработано -->
													<p class="text-center">{{ $project->leads()->whereRaw($dateLeadCreate)->count() }}</p>
												</td>
												<td><!-- Отказ/ Повтор/ Недозвон/ Неверный номер  -->
													<p class="text-center">{{ Partner::whereIsFranchiseesOrder(0)->whereRaw('(('.$datePartnerLeadCreate.') OR ('.$dateCreatePartners.' AND partners.lead_id = 0))')->whereIn('status', array(Partner::STATUS_REJECT, Partner::STATUS_WAIT_CLIENT_PAY_FAIL, Partner::STATUS_DELIVERING_FAIL))->count() }}/
													{{ Partner::whereIsFranchiseesOrder(0)->whereRaw('(('.$datePartnerLeadCreate.') OR ('.$dateCreatePartners.' AND partners.lead_id = 0))')->whereStatus(Partner::STATUS_REPEATED)->count() }}/
													{{ Partner::whereIsFranchiseesOrder(0)->whereRaw('(('.$datePartnerLeadCreate.') OR ('.$dateCreatePartners.' AND partners.lead_id = 0))')->whereStatus(Partner::STATUS_NOANSWER)->count() }}/
													{{ Partner::whereIsFranchiseesOrder(0)->whereRaw('(('.$datePartnerLeadCreate.') OR ('.$dateCreatePartners.' AND partners.lead_id = 0))')->whereStatus(Partner::STATUS_TRASH_PHONE)->count() }}</p>
												</td>
												<td><!-- В работе  -->
													<p class="text-center">{{ Partner::whereIsFranchiseesOrder(0)->whereRaw('(('.$datePartnerLeadCreate.') OR ('.$dateCreatePartners.' AND partners.lead_id = 0))')->checkStatus(array('statusType'=>'work'))->count() }}</p>
												</td>
												<td><!--  Снятие размеров -->
													<p class="text-center">{{ Partner::whereIsFranchiseesOrder(0)->whereRaw('(('.$datePartnerLeadCreate.') OR ('.$dateCreatePartners.' AND partners.lead_id = 0))')->whereStatus(Partner::STATUS_SIZING)->count() }}</p>
												</td>
												<td><!-- Оформлены  -->
													<p class="text-center">
														<?php
															$countAllAgree = Partner::whereIsFranchiseesOrder(0)->whereRaw('(('.$datePartnerLeadCreate.') OR ('.$dateCreatePartners.' AND partners.lead_id = 0))')->checkStatus(array('statusType'=>'agreed'))->count();
															$count         = Partner::whereIsFranchiseesOrder(0)->whereRaw('(('.$datePartnerLeadCreate.') OR ('.$dateCreatePartners.' AND partners.lead_id = 0))')->checkStatus(array('statusType'=>'agreed'))->where('partners.cartprice', '>', '1')->count();
															$deliveryCount = Partner::whereIsFranchiseesOrder(0)->whereRaw('(('.$datePartnerLeadCreate.') OR ('.$dateCreatePartners.' AND partners.lead_id = 0))')->checkStatus(array('statusType'=>'agreed'))->whereTransportType(Partner::TRANSPORT_TYPE_CDEK)->where('cdek_receiverCityId', '!=', 44)->where('partners.deliveryprice','>',1)->count();
															$sum           = Partner::whereIsFranchiseesOrder(0)->whereRaw('(('.$datePartnerLeadCreate.') OR ('.$dateCreatePartners.' AND partners.lead_id = 0))')->checkStatus(array('statusType'=>'agreed'))->where('partners.cartprice', '>', '1')->sum('cartprice');
															$deliverySum   = Partner::whereIsFranchiseesOrder(0)->whereRaw('(('.$datePartnerLeadCreate.') OR ('.$dateCreatePartners.' AND partners.lead_id = 0))')->checkStatus(array('statusType'=>'agreed'))->whereTransportType(Partner::TRANSPORT_TYPE_CDEK)->where('cdek_receiverCityId', '!=', 44)->where('partners.deliveryprice','>',1)->sum('deliveryprice');
														  //Маржа
														  $productionCost = Partner::whereIsFranchiseesOrder(0)->whereRaw('(('.$datePartnerLeadCreate.') OR ('.$dateCreatePartners.' AND partners.lead_id = 0))')->checkStatus(array('statusType'=>'agreed'))->where('partners.cartprice', '>', '1')->sum('prime_cost');
															$margin = $sum - $productionCost - $deliverySum;
														?>
														{{ $countAllAgree }}<br/>
														<span class="to-humanize" title="Сумма. Стоимость доставки СДЭК: {{ $deliverySum }}">{{ $sum }}</span> <i class="fa fa-rub"></i>/<br/>
														<span class="to-humanize" title="Маржа">{{ $margin }}</span> <i class="fa fa-rub"></i><br/>
													</p>
												</td>
												<td><!-- Ожидают предоплаты  -->
													<p class="text-center">{{ Partner::whereIsFranchiseesOrder(0)->whereRaw('(('.$datePartnerLeadCreate.') OR ('.$dateCreatePartners.' AND partners.lead_id = 0))')->whereStatus(Partner::STATUS_WAIT_CLIENT_PAY)->count() }}</p>
												</td>
												<td><!-- Внесена предоплата  -->
													<p class="text-center">{{ Partner::whereIsFranchiseesOrder(0)->whereRaw('(('.$datePartnerLeadCreate.') OR ('.$dateCreatePartners.' AND partners.lead_id = 0))')->whereRaw('(paytype = 1 AND paidsum > 0)')->count() }}</p>
												</td>
												<td><!-- В производстве  -->
													<p class="text-center">{{ Partner::whereIsFranchiseesOrder(0)->whereRaw('(('.$datePartnerLeadCreate.') OR ('.$dateCreatePartners.' AND partners.lead_id = 0))')->whereIn('status', array(Partner::STATUS_PRODUCTION_WAIT, Partner::STATUS_PRODUCTION_PROCESS, Partner::STATUS_PRODUCTION_SUCCESS	))->count() }}</p>
												</td>
												<td><!-- Средняя доставка/сред. чек  -->
													<p class="text-center">
														<?php
															$deliveryAvg = 0;
															$sumAvg      = 0;
															$marginAvg   = 0;
															if ($deliveryCount) {
																$deliveryAvg = $deliverySum / $deliveryCount;
															}
															if ($count) {
																$sumAvg    = $sum / $count;
																$marginAvg = $margin / $count;
															}
														?>
														<span class="to-humanize" title="Средняя доставка СДЭК">{{ round($deliveryAvg, 0) }}</span> <i class="fa fa-rub"></i><br/>
														<span class="to-humanize" title="Средний чек">{{ round($sumAvg, 0) }}</span> <i class="fa fa-rub"></i><br/>
														<span class="to-humanize" title="Средняя маржа">{{ round($marginAvg, 0) }}</span> <i class="fa fa-rub"></i><br/>
													</p>
												</td>
											</tr>
											<?php
												$entrypoint = Partner::whereIsFranchiseesOrder(0)->whereRaw('('.$dateCreatePartners.' AND partners.lead_id = 0)')->count('*');
											?>
                        <tr><!-- с нулевыми lead_id-->
													<td>
														<p>&nbsp;&nbsp;&nbsp;<small> </small></p>
													</td>
													<td>
														<?php
														  // всего заявок по точке
															$pointQuant  = Partner::whereIsFranchiseesOrder(0)->whereRaw('('.$dateCreatePartners.' AND partners.lead_id = 0)')->count();
														?>
														<p class="text-center">{{ $pointQuant }} </p>
													</td>
													<td>
														<p class="text-center"> 0 </p>
													</td>
													<td>
														<?php // отказы
															  $pointReject = Partner::whereIsFranchiseesOrder(0)->whereRaw('('.$dateCreatePartners.' AND partners.lead_id = 0)')->checkStatus(array('statusType'=>'reject'))->count();
															   // повторы
																$pointRepeated = Partner::whereIsFranchiseesOrder(0)->whereRaw('('.$dateCreatePartners.' AND partners.lead_id = 0)')->whereStatus(Partner::STATUS_REPEATED)->count();
															   // недозвон
															  $pointNoanswer = Partner::whereIsFranchiseesOrder(0)->whereRaw('('.$dateCreatePartners.' AND partners.lead_id = 0)')->whereStatus(Partner::STATUS_NOANSWER)->count();
															   // неверный телефон
															  $pointTrashPhone = Partner::whereIsFranchiseesOrder(0)->whereRaw('('.$dateCreatePartners.' AND partners.lead_id = 0)')->whereStatus(Partner::STATUS_TRASH_PHONE)->count();
														?>
														<p class="text-center">{{ $pointReject }}/ {{ $pointRepeated }}/ {{ $pointNoanswer }}/ {{ $pointTrashPhone }}</p>
													</td>
													<td>
														<?php
														  // в работе
															  $pointInWork = Partner::whereIsFranchiseesOrder(0)->whereRaw('('.$dateCreatePartners.' AND partners.lead_id = 0)')->checkStatus(array('statusType'=>'work'))->count();
														?>
														<p class="text-center">{{ $pointInWork }}</p>
													</td>
													<td>
														<?php
														  // снятие размеров
															  $pointSizing = Partner::whereIsFranchiseesOrder(0)->whereRaw('('.$dateCreatePartners.' AND partners.lead_id = 0)')->whereStatus(Partner::STATUS_SIZING)->count();
														?>
														<p class="text-center">{{ $pointSizing }}</p>
													</td>
													<td>
														<p class="text-center">
															<?php
															  // оформлены
															  $pointAgreeAll = Partner::whereIsFranchiseesOrder(0)->whereRaw('('.$dateCreatePartners.' AND partners.lead_id = 0)')->checkStatus(array('statusType'=>'agreed'))->count();
																$pointAgree = Partner::whereIsFranchiseesOrder(0)->whereRaw('('.$dateCreatePartners.' AND partners.lead_id = 0)')->checkStatus(array('statusType'=>'agreed'))->where('partners.cartprice', '>', '1')->count();
															  //кол-во доставок
															  $pointdeliveryCount = Partner::whereIsFranchiseesOrder(0)->whereRaw('('.$dateCreatePartners.' AND partners.lead_id = 0)')->checkStatus(array('statusType'=>'agreed'))->whereTransportType(Partner::TRANSPORT_TYPE_CDEK)->where('cdek_receiverCityId', '!=', 44)->where('partners.deliveryprice','>',1)->count();
															  // сумма оформленных
															  $pointAgreeSum = Partner::whereIsFranchiseesOrder(0)->whereRaw('('.$dateCreatePartners.' AND partners.lead_id = 0)')->checkStatus(array('statusType'=>'agreed'))->where('partners.cartprice', '>', '1')->sum('cartprice');
															  //сумма доставок
															  $pointdeliverySum = Partner::whereIsFranchiseesOrder(0)->whereRaw('('.$dateCreatePartners.' AND partners.lead_id = 0)')->checkStatus(array('statusType'=>'agreed'))->whereTransportType(Partner::TRANSPORT_TYPE_CDEK)->where('cdek_receiverCityId', '!=', 44)->where('partners.deliveryprice','>',1)->sum('deliveryprice');
															  //маржа
																$productionCost = Partner::whereIsFranchiseesOrder(0)->whereRaw('('.$dateCreatePartners.' AND partners.lead_id = 0)')->checkStatus(array('statusType'=>'agreed'))->where('partners.cartprice', '>', '1')->sum('prime_cost');
																$margin = $pointAgreeSum - $productionCost - $pointdeliverySum;
														  ?>
															{{ $pointAgreeAll }}<br/>
															<span class="to-humanize" title="Сумма. Стоимость доставки СДЭК: {{ $pointdeliverySum }}.">{{ $pointAgreeSum }}</span> <i class="fa fa-rub"></i>/<br/>
															<span class="to-humanize" title="Маржа">{{ $margin }}</span> <i class="fa fa-rub"></i><br/>
														</p>
													</td>
													<td>
														<?php
														  // ожидают предоплаты
															  $pointPayWaiting = Partner::whereIsFranchiseesOrder(0)->whereRaw('('.$dateCreatePartners.' AND partners.lead_id = 0)')->whereStatus(Partner::STATUS_WAIT_CLIENT_PAY)->count();
														?>
														<p class="text-center">{{ $pointPayWaiting }}</p>
													</td>
													<td>
														<?php
														  // внесена предоплата
															  $pointPaid = Partner::whereIsFranchiseesOrder(0)->whereRaw('('.$dateCreatePartners.' AND partners.lead_id = 0)')->whereRaw('(paytype = 1 AND paidsum > 0)')->count();
														?>
														<p class="text-center">{{ $pointPaid }}</p>
													</td>
													<td>
														<?php
														  // производство
															  $pointProduction = Partner::whereIsFranchiseesOrder(0)->whereRaw('('.$dateCreatePartners.' AND partners.lead_id = 0)')->whereIn('status', array(Partner::STATUS_PRODUCTION_WAIT, Partner::STATUS_PRODUCTION_PROCESS, Partner::STATUS_PRODUCTION_SUCCESS))->count();
														?>
														<p class="text-center">{{ $pointProduction }}</p>
													</td>
													<td>
														<p class="text-center">
															<?php
																$deliveryAvg = 0;
																$sumAvg      = 0;
																$marginAvg   = 0;
																if ($pointdeliveryCount) {
																	$deliveryAvg = $pointdeliverySum / $pointdeliveryCount;
																}
																if ($pointAgree) {
																	$sumAvg    = $pointAgreeSum / $pointAgree;
																	$marginAvg = $margin / $pointAgree;
																}
															?>
															<span class="to-humanize" title="Средняя доставка">{{ round($deliveryAvg, 0) }}</span> <i class="fa fa-rub"></i><br/>
															<span class="to-humanize" title="Средний чек">{{ round($sumAvg, 0) }}</span> <i class="fa fa-rub"></i><br/>
															<span class="to-humanize" title="Средняя маржа">{{ round($marginAvg, 0) }}</span> <i class="fa fa-rub"></i><br/>
														</p>
													</td>
												</tr>
											<?php
												$entrypoints2 = $project->leads()->whereRaw($dateLeadCreate)->withTrashed()->groupBy('entrypoint')->get();
											?>
											@foreach ($entrypoints2 as $entrypoint)
												<tr>
													<td>
														<p>&nbsp;&nbsp;&nbsp;<small>{{ $entrypoint->entrypoint; }}</small></p>
													</td>
													<td>
														<?php
														  // всего заявок по точке
														  $pointQuant = Partner::leftjoin('leads', 'partners.lead_id', '=', 'leads.id')->whereIsFranchiseesOrder(0)->whereRaw('(('.$datePartnerLeadCreate.') OR ('.$dateCreatePartners.' AND partners.lead_id = 0))')->whereRaw("leads.entrypoint = '".$entrypoint->entrypoint."'")->count();
														?>
														<p class="text-center">{{ $pointQuant + $project->leads()->whereEntrypoint($entrypoint->entrypoint)->whereRaw($dateLeadCreate)->count()}} </p>
													</td>
													<td>
														<p class="text-center">{{ $project->leads()->whereEntrypoint($entrypoint->entrypoint)->whereRaw($dateLeadCreate)->count() }}</p>
													</td>
													<td>
														<?php // отказы
														  $pointReject = Partner::leftjoin('leads', 'partners.lead_id', '=', 'leads.id')->whereIsFranchiseesOrder(0)->whereRaw('(('.$datePartnerLeadCreate.') OR ('.$dateCreatePartners.' AND partners.lead_id = 0))')->checkStatus(array('statusType'=>'reject'))->whereRaw("leads.entrypoint = '".$entrypoint->entrypoint."'")->count();
															   // повторы
														  $pointRepeated = Partner::leftjoin('leads', 'partners.lead_id', '=', 'leads.id')->whereIsFranchiseesOrder(0)->whereRaw('(('.$datePartnerLeadCreate.') OR ('.$dateCreatePartners.' AND partners.lead_id = 0))')->whereStatus(Partner::STATUS_REPEATED)->whereRaw("leads.entrypoint = '".$entrypoint->entrypoint."'")->count();
															   // недозвон
														  $pointNoanswer = Partner::leftjoin('leads', 'partners.lead_id', '=', 'leads.id')->whereIsFranchiseesOrder(0)->whereRaw('(('.$datePartnerLeadCreate.') OR ('.$dateCreatePartners.' AND partners.lead_id = 0))')->whereStatus(Partner::STATUS_NOANSWER)->whereRaw("leads.entrypoint = '".$entrypoint->entrypoint."'")->count();
															   // неверный телефон
														  $pointTrashPhone = Partner::leftjoin('leads', 'partners.lead_id', '=', 'leads.id')->whereIsFranchiseesOrder(0)->whereRaw('(('.$datePartnerLeadCreate.') OR ('.$dateCreatePartners.' AND partners.lead_id = 0))')->whereStatus(Partner::STATUS_TRASH_PHONE)->whereRaw("leads.entrypoint = '".$entrypoint->entrypoint."'")->count();
														?>
														<p class="text-center">{{ $pointReject }}/ {{ $pointRepeated }}/ {{ $pointNoanswer }}/ {{ $pointTrashPhone }}</p>
													</td>
													<td>
														<?php
														  // в работе
													    $pointInWork = Partner::leftjoin('leads', 'partners.lead_id', '=', 'leads.id')->whereIsFranchiseesOrder(0)->whereRaw('(('.$datePartnerLeadCreate.') OR ('.$dateCreatePartners.' AND partners.lead_id = 0))')->checkStatus(array('statusType'=>'work'))->whereRaw("leads.entrypoint = '".$entrypoint->entrypoint."'")->count();
														?>
														<p class="text-center">{{ $pointInWork }}</p>
													</td>
													<td>
														<?php
														  // снятие размеров
														  $pointSizing = Partner::leftjoin('leads', 'partners.lead_id', '=', 'leads.id')->whereIsFranchiseesOrder(0)->whereRaw('(('.$datePartnerLeadCreate.') OR ('.$dateCreatePartners.' AND partners.lead_id = 0))')->whereStatus(Partner::STATUS_SIZING)->whereRaw("leads.entrypoint = '".$entrypoint->entrypoint."'")->count();
														?>
														<p class="text-center">{{ $pointSizing }}</p>
													</td>
													<td>
														<p class="text-center">
															<?php
															  // оформлены
														    $pointAgreeAll = Partner::leftjoin('leads', 'partners.lead_id', '=', 'leads.id')->whereIsFranchiseesOrder(0)->whereRaw('(('.$datePartnerLeadCreate.') OR ('.$dateCreatePartners.' AND partners.lead_id = 0))')->checkStatus(array('statusType'=>'agreed'))->whereRaw("leads.entrypoint = '".$entrypoint->entrypoint."'")->count();
																$pointAgree = Partner::leftjoin('leads', 'partners.lead_id', '=', 'leads.id')->whereIsFranchiseesOrder(0)->whereRaw('(('.$datePartnerLeadCreate.') OR ('.$dateCreatePartners.' AND partners.lead_id = 0))')->checkStatus(array('statusType'=>'agreed'))->whereRaw("leads.entrypoint = '".$entrypoint->entrypoint."'")->where('partners.cartprice', '>', '1')->count();
															  //кол-во доставок
														    $pointdeliveryCount = Partner::leftjoin('leads', 'partners.lead_id', '=', 'leads.id')->whereIsFranchiseesOrder(0)->whereRaw('(('.$datePartnerLeadCreate.') OR ('.$dateCreatePartners.' AND partners.lead_id = 0))')->checkStatus(array('statusType'=>'agreed'))->whereTransportType(Partner::TRANSPORT_TYPE_CDEK)->where('cdek_receiverCityId', '!=', 44)->whereRaw("leads.entrypoint = '".$entrypoint->entrypoint."'")->where('partners.deliveryprice', '>', '1')->count();
															  // сумма оформленных
														    $pointAgreeSum = Partner::leftjoin('leads', 'partners.lead_id', '=', 'leads.id')->whereIsFranchiseesOrder(0)->whereRaw('(('.$datePartnerLeadCreate.') OR ('.$dateCreatePartners.' AND partners.lead_id = 0))')->checkStatus(array('statusType'=>'agreed'))->whereRaw("leads.entrypoint = '".$entrypoint->entrypoint."'")->where('partners.cartprice', '>', '1')->sum('cartprice');
															  //стоимость доставок
														    $pointdeliverySum = Partner::leftjoin('leads', 'partners.lead_id', '=', 'leads.id')->whereIsFranchiseesOrder(0)->whereRaw('(('.$datePartnerLeadCreate.') OR ('.$dateCreatePartners.' AND partners.lead_id = 0))')->checkStatus(array('statusType'=>'agreed'))->whereTransportType(Partner::TRANSPORT_TYPE_CDEK)->where('cdek_receiverCityId', '!=', 44)->whereRaw("leads.entrypoint = '".$entrypoint->entrypoint."'")->where('partners.deliveryprice', '>', '1')->sum('deliveryprice');
															  //Маржа
																$productionCost = Partner::leftjoin('leads', 'partners.lead_id', '=', 'leads.id')->whereIsFranchiseesOrder(0)->whereRaw('(('.$datePartnerLeadCreate.') OR ('.$dateCreatePartners.' AND partners.lead_id = 0))')->checkStatus(array('statusType'=>'agreed'))->whereRaw("leads.entrypoint = '".$entrypoint->entrypoint."'")->where('partners.cartprice', '>', '1')->sum('prime_cost');
																$margin = $pointAgreeSum - $productionCost - $pointdeliverySum;
															?>
															{{ $pointAgreeAll }}<br/>
															<span class="to-humanize" title="Сумма. Стоимость доставки СДЭК: {{ $pointdeliverySum }}">{{ $pointAgreeSum }}</span> <i class="fa fa-rub"></i>/<br/>
															<span class="to-humanize" title="Маржа">{{ $margin }}</span> <i class="fa fa-rub"></i><br/>
														</p>
													</td>
													<td>
														<?php
														  // ожидают предоплаты
													    $pointPayWaiting = Partner::leftjoin('leads', 'partners.lead_id', '=', 'leads.id')->whereIsFranchiseesOrder(0)->whereRaw('(('.$datePartnerLeadCreate.') OR ('.$dateCreatePartners.' AND partners.lead_id = 0))')->whereStatus(Partner::STATUS_WAIT_CLIENT_PAY)->whereRaw("leads.entrypoint = '".$entrypoint->entrypoint."'")->count();
														?>
														<p class="text-center">{{ $pointPayWaiting }}</p>
													</td>
													<td>
														<?php
														  // внесена предоплата
														  $pointPaid = Partner::leftjoin('leads', 'partners.lead_id', '=', 'leads.id')->whereIsFranchiseesOrder(0)->whereRaw('(('.$datePartnerLeadCreate.') OR ('.$dateCreatePartners.' AND partners.lead_id = 0))')->whereRaw('(paytype = 1 AND paidsum > 0)')->whereRaw("leads.entrypoint = '".$entrypoint->entrypoint."'")->count();
														?>
														<p class="text-center">{{ $pointPaid }}</p>
													</td>
													<td>
														<?php
														  // производство
														  $pointProduction = Partner::leftjoin('leads', 'partners.lead_id', '=', 'leads.id')->whereIsFranchiseesOrder(0)->whereRaw('(('.$datePartnerLeadCreate.') OR ('.$dateCreatePartners.' AND partners.lead_id = 0))')->whereIn('status', array(Partner::STATUS_PRODUCTION_WAIT, Partner::STATUS_PRODUCTION_PROCESS, Partner::STATUS_PRODUCTION_SUCCESS))->whereRaw("leads.entrypoint = '".$entrypoint->entrypoint."'")->count();
														?>
														<p class="text-center">{{ $pointProduction }}</p>
													</td>
													<td>
														<p class="text-center">
															<?php
																$deliveryAvg = 0;
																$sumAvg      = 0;
																$marginAvg   = 0;
																if ($pointdeliveryCount) {
																	$deliveryAvg = $pointdeliverySum / $pointdeliveryCount;
																}
																if ($pointAgree) {
																	$sumAvg    = $pointAgreeSum / $pointAgree;
																	$marginAvg = $margin / $pointAgree;
																}
															?>
															<span class="to-humanize" title="Средняя доставка">{{ round($deliveryAvg, 0) }}</span> <i class="fa fa-rub"></i><br/>
															<span class="to-humanize" title="Средний чек">{{ round($sumAvg, 0) }}</span> <i class="fa fa-rub"></i><br/>
															<span class="to-humanize" title="Средняя маржа">{{ round($marginAvg, 0) }}</span> <i class="fa fa-rub"></i><br/>
														</p>
													</td>
												</tr>
											@endforeach
									</tbody>
								</table>
							</div>
						<!-- end widget content -->
					</div>
					<!-- end widget div -->
				</div>
				<!-- end widget -->
			</article>
		</div>
	</section>

@stop