
<?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['projectId'] = '<?php echo $input['projectId']; ?>';
			params['startDate'] = $('#startDate').val();
			params['endDate'] = $('#endDate').val();
			kmkSetBrowserAddressParams(kmkObjectToGetString(params, false));
			location.reload();
		}

		$(document).ready(function(){
			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');
			});
	</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>
		</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>ФИО</th>
					<th class="text-right" title="По дате оформления заявки. Не включает заявки на замеры.">Оформлено заявок</th>
					<th class="text-right">Сумма заказов</th>
					<th class="text-right">Маржа</th>
					<th class="text-right" title="Входит в общее кол-во оформленных заказов">Доставляется</th>		
					<th class="text-right" title="Входит в общее кол-во оформленных заказов">Доставлено</th>	
					<th class="text-right" title="Входит в общее кол-во оформленных заказов">Отказы по оформленным</th>
					<th class="text-right" title="По дате создания заявки. Не входит в общее кол-во оформленных заказов">Заявок на замеры</th>
				</tr>
			</thead>
			<tbody>
				<?php foreach (Partner::whereRaw($dateWhereAll)->whereIsFranchiseesOrder(1)->with('user')->groupBy('user_id')->get() as $franchise): ?>
					<tr>
						<td> <!-- ФИО -->
							<?php echo $franchise->user->first_name.' '.$franchise->user->last_name; ?>
							<small class="cite"><?php echo $franchise->user->city; ?></small>
						</td>
						<td> <!-- Оформлено заявок (по дате оформления)-->
							<p class="text-right">
								<span class="to-humanize"><?php echo Partner::whereRaw($dateWhereAgree)->where('user_id', '=', $franchise->user_id)->whereIsFranchiseesOrder(1)->where('status', '<>', Partner::STATUS_SIZING)->count(); ?></span>
							</p>
						</td>
						<td> <!-- Сумма заказов -->
							<p class="text-right">
								<span class="to-humanize"><?php echo $franchiseesCost = Partner::whereRaw($dateWhereAgree)->where('user_id', '=', $franchise->user_id)->whereIsFranchiseesOrder(1)->where('status', '<>', Partner::STATUS_SIZING)->sum('franchisees_cost'); ?></span>
							</p>
						</td>
						<td> <!-- Маржа -->
							<p class="text-right"> 
								<span class="to-humanize"><?php echo $franchiseesCost - Partner::whereRaw($dateWhereAgree)->where('user_id', '=', $franchise->user_id)->whereIsFranchiseesOrder(1)->where('status', '<>', Partner::STATUS_SIZING)->sum('prime_cost'); ?></span>
							</p>
						</td>	
						<td> <!-- Доставляется -->
							<p class="text-right">
								<span class="to-humanize"><?php echo Partner::whereRaw($dateWhereAgree)->where('user_id', '=', $franchise->user_id)->whereIsFranchiseesOrder(1)->where('status', '=', Partner::STATUS_DELIVERING)->count(); ?></span>
							</p>
						</td>
						<td> <!-- Доставлено -->
							<p class="text-right">
								<span class="to-humanize"><?php echo Partner::whereRaw($dateWhereAgree)->where('user_id', '=', $franchise->user_id)->whereIsFranchiseesOrder(1)->whereIn('status', array(Partner::STATUS_SUCCESS, Partner::STATUS_WAIT_TRANSPORT_COMPANY_PAY))->count(); ?></span>
							</p>
						</td>
						<td> <!-- Отказы по оформленным -->
							<p class="text-right">
								<span class="to-humanize"><?php echo Partner::whereRaw($dateWhereAgree)->where('user_id', '=', $franchise->user_id)->whereIsFranchiseesOrder(1)->where('status', '=', Partner::STATUS_REJECT)->count(); ?></span>
							</p>
						</td>
						<td> <!-- Заявок на замеры (по дате создания заявки)-->
							<p class="text-right">
								<span class="to-humanize"><?php echo Partner::whereRaw($dateWhereSize)->where('user_id', '=', $franchise->user_id)->whereIsFranchiseesOrder(1)->where('status', '=', Partner::STATUS_SIZING)->count(); ?></span>
							</p>
						</td>	
					</tr>
				<?php endforeach; ?>
				<tr class="panel-footer">
						<?php $franchiseAgree = Partner::whereRaw($dateWhereAgree)->whereIsFranchiseesOrder(1);?>
					       <!-- Итого -->
						<td class="text-right"><b> Итого:</b></td>
						<td> <!-- Оформлено заявок -->
							<p class="text-right">
								<span class="to-humanize"><?php echo $franchiseAgree->where('status', '<>', Partner::STATUS_SIZING)->count(); ?></span>
							</p>
						</td>
						<td> <!-- Сумма заказов -->
							<p class="text-right">
								<span class="to-humanize"><?php echo $franchiseesCostTotal = $franchiseAgree->where('status', '<>', Partner::STATUS_SIZING)->sum('franchisees_cost'); ?></span>
							</p>
						</td>
						<td> <!-- Маржа -->
							<p class="text-right">
								<span class="to-humanize"><?php echo $franchiseesCostTotal - $franchiseAgree->where('status', '<>', Partner::STATUS_SIZING)->sum('prime_cost'); ?></span>
							</p>
						</td>
						<td> <!-- Доставляется -->
							<p class="text-right">
								<span class="to-humanize"><?php echo Partner::whereRaw($dateWhereAgree)->whereIsFranchiseesOrder(1)->where('status', '=', Partner::STATUS_DELIVERING)->count(); ?></span>
							</p>
						</td>
						<td> <!-- Доставлено -->
							<p class="text-right">
								<span class="to-humanize"><?php echo Partner::whereRaw($dateWhereAgree)->whereIsFranchiseesOrder(1)->whereIn('status', array(Partner::STATUS_SUCCESS, Partner::STATUS_WAIT_TRANSPORT_COMPANY_PAY))->count(); ?></span>
							</p>
						</td>
						<td> <!-- Отказы по оформленным-->
							<p class="text-right">
								<span class="to-humanize"><?php echo Partner::whereRaw($dateWhereAgree)->whereIsFranchiseesOrder(1)->where('status', '=', Partner::STATUS_REJECT)->count(); ?></span>
							</p>
						</td>
						<td> <!-- Заявок на замеры -->
							<p class="text-right">
								<span class="to-humanize"><?php echo Partner::whereRaw($dateWhereSize)->whereIsFranchiseesOrder(1)->where('status', '=', Partner::STATUS_SIZING)->count(); ?></span>
							</p>
						</td>	
				  </tr>
			</tbody>
		</table>
	</div>
<?php $__env->stopSection(); ?>
<?php echo $__env->make('layouts.default', array_except(get_defined_vars(), array('__data', '__path')))->render(); ?>