@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">Всего клиентов<br>/ из заявок</th>
											<th class="text-center">Оформлено<br>/ из заявок </th>
										</tr>
									</thead>
									<tbody>
										<?php $infoSources = DB::table('partners')->whereIsFranchiseesOrder(0)->whereRaw('('.$dateCreatePartners.')')->join('info_source', 'partners.info_source_id', '=', 'info_source.id')->select(DB::raw('count(partners.id) as count,partners.info_source_id, info_source.source'))->groupBy('partners.info_source_id')->get(); ?>
                    @foreach($infoSources as $infoSource)
										<tr>
											<td>
												<p>{{ $infoSource->source }}</p>
											</td>
											<!--Всего-->
											<td class="text-center">
												<?php $infoSourcesCountLeads = Partner::whereIsFranchiseesOrder(0)->whereRaw($dateCreatePartners)->where('info_source_id', '=', $infoSource->info_source_id)->where('lead_id', '>', 0)->count(); ?>
												<p> {{ $infoSource->count }} / {{ $infoSourcesCountLeads }}</p>
											</td>
											<!--В работе-->
											<td class="text-center">
												<?php $infoSourcesCountAgree = Partner::whereIsFranchiseesOrder(0)->whereRaw($dateCreatePartners)->where('info_source_id', '=', $infoSource->info_source_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_CHECK_PATTERNS))->count(); ?>
												<?php $infoSourcesCountAgreeLeads = Partner::whereIsFranchiseesOrder(0)->whereRaw($dateCreatePartners)->where('info_source_id', '=', $infoSource->info_source_id)->where('lead_id', '>', 0)->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_CHECK_PATTERNS))->count(); ?>
												<p> {{ $infoSourcesCountAgree }} / {{ $infoSourcesCountAgreeLeads}}</p>
											</td>
										</tr>
										@endforeach
										
										<!-- из заявок -->
										<tr>
											<td>
												<p>Из заявок</p>
											</td>
											<!--Всего-->
											<td class="text-center">
												<?php $leadsCount = Partner::whereIsFranchiseesOrder(0)->whereRaw($dateCreatePartners)->where('lead_id', '>', 0)->count(); ?>
												<p> {{ $leadsCount }}</p>
											</td>
											<!--В работе-->
											<td class="text-center">
												<?php $leadsCountAgree = Partner::whereIsFranchiseesOrder(0)->whereRaw($dateCreatePartners)->where('lead_id', '>', 0)->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_CHECK_PATTERNS))->count(); ?>
												<p> {{ $leadsCountAgree }}</p>
											</td>
										</tr>
									</tbody>
								</table>
							</div>
						<!-- end widget content -->
					</div>
					<!-- end widget div -->
				</div>
				<!-- end widget -->
			</article>
		</div>
	</section>

@stop