
<?php $__env->startSection('title'); ?>
	@parent
	Статистика по отказам детализированная
<?php $__env->stopSection(); ?>

<?php $__env->startSection('css'); ?>
	<link rel="stylesheet" href="<?php echo asset('css/datepicker.css'); ?>">
<?php $__env->stopSection(); ?>

<?php $__env->startSection('js'); ?>
	<script src="<?php echo asset('js/kmk-support.js'); ?>"></script>
	<script src="<?php echo asset('js/bootstrap-datepicker.js'); ?>"></script>
	<script>
		function reload () {
			var params = kmkGiveGetParams(location.search);
			params['startDate'] = $('#startDate').val();
			params['endDate'] = $('#endDate').val();
			if ($('#useAgreed:checked').length) {
				params['useAgreed'] = 1;
			}
			else {
				params['useAgreed'] = 0;
			}
			kmkSetBrowserAddressParams(kmkObjectToGetString(params, false));
			location.reload();
		}

		$(document).ready(function(){
			$('#useAgreed').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>
<?php $__env->stopSection(); ?>

<?php $__env->startSection('content'); ?>
	<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="<?php echo $input['startDate']; ?>"/>
			</div>
			<div class="form-group">
				<label for="endDate">по</label> <input id="endDate" name="endDate" class="form-control" value="<?php echo $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>
	</div>
<div class="panel panel-default">
	<div class="panel-heading">
		<h3 class="panel-title"><b>Статистика по менеджерам</b></h3>
	</div>
	<table class="table table-striped table-hover lead-stat">
		<thead>
			<tr>
				<th style="vertical-align:top">Менеджер</th>
				<th class="text-center" style="vertical-align:top">Взято в работу</th>
				<th class="text-center" style="vertical-align:top">Оформлено</th>
				<th class="text-center" style="vertical-align:top">В работе</th>
				<th class="text-center" style="vertical-align:top">Отказ</th>
				<th title="оформлено заявок / всего" class="text-center" style="vertical-align:top">Из StreamWood</th>
				<th title="оформлено заявок / всего" class="text-center" style="vertical-align:top">Из Vk.com</th>
			</tr>
		</thead>
		<tbody>
			<?php foreach ($users as $user): ?>
				<tr>
					<!-- Менеджер-->
					<td><b><?php echo $user->last_name; ?> <?php echo $user->first_name; ?></b></td>
					
					<!--Взято в работу из заявок-->
					<?php 
					  $leadsCount = Partner::whereRaw($dateCreated)
																	->whereIsFranchiseesOrder(0)
																	->whereUserId($user->id)
										              ->whereNotIn('status', array(Partner::STATUS_REPEATED,	Partner::STATUS_TRASH_PHONE ))
																	->where('lead_id', '>', 0)
																	->count();
					?>
					  <td class="text-center"><?php echo $leadsCount; ?></td>
						
					<!--Оформлено-->
					<?php 
					  $agreeCount = Partner::whereRaw($dateAgree)
																	->whereIsFranchiseesOrder(0)
																	->whereUserId($user->id)
																	->whereIn('status', array(Partner::STATUS_REGISTRATION,	Partner::STATUS_WAIT_DELIVERING, Partner::STATUS_WAIT_SENDING, Partner::STATUS_DELIVERING, Partner::STATUS_WAIT_CLIENT_PAY,	Partner::STATUS_WAIT_CLIENT_PAY_CONFIRM, Partner::STATUS_WAIT_TRANSPORT_COMPANY_PAY,	Partner::STATUS_SUCCESS,	Partner::STATUS_PRODUCTION_WAIT,	Partner::STATUS_PRODUCTION_PROCESS,	Partner::STATUS_PRODUCTION_SUCCESS,	Partner::STATUS_PRODUCTION_PACKING,	Partner::STATUS_CHECK_PATTERNS))
																	->count();
					?>
					  <td class="text-center"><?php echo $agreeCount; ?></td>
					<!--В работе-->
					<?php 
					  $inworkCount = Partner::whereRaw($dateCreated)->whereIsFranchiseesOrder(0)->whereUserId($user->id)->whereStatus(Partner::STATUS_WORK)->count();
					?>
						<td class="text-center"><?php echo $inworkCount; ?></td>
						
					<!--Отказ-->
					<?php 
					  $rejectCount = Partner::whereRaw($dateUpdate)
																	->whereIsFranchiseesOrder(0)
																	->whereUserId($user->id)
																	->whereIn( 'status', array(Partner::STATUS_DELIVERING_FAIL, Partner::STATUS_REJECT, Partner::STATUS_WAIT_CLIENT_PAY_FAIL) )
																	->count();
					?>
						<td class="text-center"><?php echo $rejectCount; ?></td>
						
					<!--Из StreamWood-->
					<?php 
					  $streamWoodCount = Partner::whereRaw($dateCreated)
																			->whereIsFranchiseesOrder(0)
																			->whereUserId($user->id)
																			->whereInfoSourceId(5)
																			->where('lead_id', '=', 0)
																			->count();
						$streamWoodAgreeCount = Partner::whereRaw($dateCreated)
																						->whereIsFranchiseesOrder(0)
																						->whereUserId($user->id)
																						->whereInfoSourceId(5)
																						->whereIn('status', array(Partner::STATUS_REGISTRATION,	Partner::STATUS_WAIT_DELIVERING, Partner::STATUS_WAIT_SENDING, Partner::STATUS_DELIVERING, Partner::STATUS_WAIT_CLIENT_PAY,	Partner::STATUS_WAIT_CLIENT_PAY_CONFIRM, Partner::STATUS_WAIT_TRANSPORT_COMPANY_PAY,	Partner::STATUS_SUCCESS,	Partner::STATUS_PRODUCTION_WAIT,	Partner::STATUS_PRODUCTION_PROCESS,	Partner::STATUS_PRODUCTION_SUCCESS,	Partner::STATUS_PRODUCTION_PACKING,	Partner::STATUS_CHECK_PATTERNS))
																						->where('lead_id', '=', 0)
																						->count();
					?>
						<td title="оформлено заявок / всего" class="text-center"><?php echo $streamWoodAgreeCount; ?> / <?php echo $streamWoodCount; ?></td>
						
					<!--Из Vk.com-->
					<?php 
					  $vkCount = Partner::whereRaw($dateCreated)
																			->whereIsFranchiseesOrder(0)
																			->whereUserId($user->id)
																			->whereIn('info_source_id', array(1,2))
																			->where('lead_id', '=', 0)
																			->count();
					  $vkAgreeCount = Partner::whereRaw($dateCreated)
																			->whereIsFranchiseesOrder(0)
																			->whereUserId($user->id)
																			->whereIn('info_source_id', array(1,2))
																			->whereIn('status', array(Partner::STATUS_REGISTRATION,	Partner::STATUS_WAIT_DELIVERING, Partner::STATUS_WAIT_SENDING, Partner::STATUS_DELIVERING, Partner::STATUS_WAIT_CLIENT_PAY,	Partner::STATUS_WAIT_CLIENT_PAY_CONFIRM, Partner::STATUS_WAIT_TRANSPORT_COMPANY_PAY,	Partner::STATUS_SUCCESS,	Partner::STATUS_PRODUCTION_WAIT,	Partner::STATUS_PRODUCTION_PROCESS,	Partner::STATUS_PRODUCTION_SUCCESS,	Partner::STATUS_PRODUCTION_PACKING,	Partner::STATUS_CHECK_PATTERNS))
																			->where('lead_id', '=', 0)
																			->count();
					?>
						<td title="оформлено заявок / всего" class="text-center"><?php echo $vkAgreeCount; ?> / <?php echo $vkCount; ?></td>
				</tr>
			<?php endforeach; ?>
		</tbody>
	</table>
</div>
<?php $__env->stopSection(); ?>
<?php echo $__env->make('layouts.default', array_except(get_defined_vars(), array('__data', '__path')))->render(); ?>