@extends('layouts.default')

@section('title')
@parent
Статистика
@stop

@section('css')
@stop

@section('js')
	<script type="text/javascript" src="https://www.google.com/jsapi"></script>
	<script type="text/javascript">
		google.load("visualization", "1", {packages:["corechart"]});
		google.setOnLoadCallback(initChart);
		var current = 0;

		function initChart() {
			var options = {
				areaOpacity:	0.1,
				colors:				['#00aeef'],
				title:				'Заявки за сегодня',
				animation:		{ duration: 500, easing: 'out' },
				legend:				{ position: 'none' },
				hAxis:				{
												maxValue: 2,
												minValue: 2,
												textStyle:
												{
													color: '#898989'
												}
											},
				vAxis:				{
												maxValue: 2,
												minValue: 2,
												textStyle: {
													color: '#898989'
												},
												baselineColor: "#e1e1e1",
												minValue: 0,
												gridlines: { color: "#e1e1e1"}
											}
			};

			var data = [];

			data[0] = google.visualization.arrayToDataTable([
				['Час', 'Заявки']
				<?php
					$leads = Lead::withTrashed()
									->whereRaw(DB::raw("DATE(created_at)=DATE(NOW())"))
									->groupBy(DB::raw("DATE_FORMAT(created_at,'%H')"))
									->orderBy(DB::raw("DATE_FORMAT(created_at,'%H')"))
									->get(array(DB::raw("COUNT(id) as cnt, DATE_FORMAT(created_at,'%H') as hour")));
				?>
				@foreach ($leads as $item)
				,['{{ $item->hour }}',  {{ $item->cnt }}]
				@endforeach
			]);
			data[1] = google.visualization.arrayToDataTable([
				['Час', 'Заявки']
				<?php
					$leads = Lead::withTrashed()
									->groupBy(DB::raw("DATE_FORMAT(created_at,'%H')"))
									->orderBy(DB::raw("DATE_FORMAT(created_at,'%H')"))
									->get(array(DB::raw("COUNT(id) as cnt, DATE_FORMAT(created_at,'%H') as hour")));
				?>
				@foreach ($leads as $item)
				,['{{ $item->hour }}',  {{ $item->cnt }}]
				@endforeach
			]);

			var chart = new google.visualization.ColumnChart(document.getElementById('chart_div'));

			function drawChart() {
				chart.draw(data[current], options);
			}
			drawChart();

			$('#chartBtns button').click(function(){
				$('#chartBtns button').removeClass('active');
				$(this).addClass('active');
				current = $(this).data('id');
				drawChart();
				return false;
			});
		}

	</script>
@stop

@section('content')
{{--
	<div class="well well-sm">
		@foreach ($user->projects()->whereUsecrm(1)->get() as $project)
		<a href="/stat/crm?projectId={{ $project->id }}" class="btn btn-sm btn-default @if ($input['projectId'] == $project->id) active @endif" data-id="{{ $project->id }}">{{ $project->name }}</a>
		@endforeach
	</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-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">Оформлены</th>
				</tr>
			</thead>
			<tbody>
				@foreach ($projects as $project)
				<tr>
					<td>
						<p>{{ $project->name }}</p>
					</td>
					<td>
						<p class="text-center">{{ $project->leadsWithTrashed()->whereRaw('DATE(created_at)=DATE(NOW())')->count() }}</p>
					</td>
					<td>
						<p class="text-center">{{ $project->leads()->whereRaw('DATE(created_at)=DATE(NOW())')->count() }}</p>
					</td>
					<td>
						<p class="text-center">{{ $project->partners()->checkStatus(array('statusType'=>'reject'))->whereRaw('DATE(lead_created_at)=DATE(NOW()) AND DATE(updated_at)=DATE(NOW())')->count() }}</p>
					</td>
					<td>
						<p class="text-center">{{ $project->partners()->whereStatus(Partner::STATUS_REPEATED)->whereRaw('DATE(lead_created_at)=DATE(NOW()) AND DATE(updated_at)=DATE(NOW())')->count() }}</p>
					</td>
					<td>
						<p class="text-center">{{ $project->partners()->whereStatus(Partner::STATUS_TRASH_PHONE)->whereRaw('DATE(lead_created_at)=DATE(NOW()) AND DATE(updated_at)=DATE(NOW())')->count() }}</p>
					</td>
					<td>
						<p class="text-center">{{ $project->partners()->whereStatus(Partner::STATUS_SIZING)->whereRaw('DATE(lead_created_at)=DATE(NOW()) AND DATE(updated_at)=DATE(NOW())')->count() }}</p>
					</td>
					<td>
						<p class="text-center">{{ $project->partners()->checkStatus(array('statusType'=>'work'))->whereRaw('DATE(lead_created_at)=DATE(NOW()) AND DATE(updated_at)=DATE(NOW())')->count() }}</p>
					</td>
					<td>
						<p class="text-center">{{ $project->partners()->checkStatus(array('statusType'=>'paywaiting'))->whereRaw('DATE(lead_created_at)=DATE(NOW()) AND DATE(updated_at)=DATE(NOW())')->count() }}</p>
					</td>
					<td>
						<p class="text-center">{{ $project->partners()->where('paytype', '=', 1)->whereRaw('DATE(lead_created_at)=DATE(NOW()) AND DATE(datetime_of_agree)=DATE(NOW())')->count() }}</p>
					</td>
					<td>
						<p class="text-center">
							{{ $project->partners()->checkStatus(array('statusType'=>'agreed'))->whereRaw('DATE(lead_created_at)=DATE(NOW()) AND DATE(datetime_of_agree)=DATE(NOW())')->count() }}<br/>
							<span class="to-humanize" title="Сумма">{{ $project->partners()->checkStatus(array('statusType'=>'agreed'))->whereRaw('DATE(lead_created_at)=DATE(NOW()) AND DATE(datetime_of_agree)=DATE(NOW())')->sum('cartprice') }}</span> <i class="fa fa-rub"></i><br/>
							<span class="to-humanize" title="Прибыль">{{ $project->partners()->checkStatus(array('statusType'=>'agreed'))->whereRaw('DATE(lead_created_at)=DATE(NOW()) AND DATE(datetime_of_agree)=DATE(NOW())')->sum('cartprice') - $project->partners()->checkStatus(array('statusType'=>'agreed'))->whereRaw('DATE(lead_created_at)=DATE(NOW()) AND DATE(datetime_of_agree)=DATE(NOW())')->sum('prime_cost') }}</span> <i class="fa fa-rub"></i><br/>
						</p>
					</td>
				</tr>
				@endforeach
			</tbody>
		</table>
	</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-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">Оформлены</th>
				</tr>
			</thead>
			<tbody>
				@foreach ($projects as $project)
				<tr>
					<td>
						<p>{{ $project->name }}</p>
					</td>
					<td>
						<p class="text-center">{{ $project->leadsWithTrashed()->whereRaw('DATE(created_at)!=DATE(NOW())')->count() }}</p>
					</td>
					<td>
						<p class="text-center">{{ $project->leadsWithTrashed()->whereRaw('DATE(created_at)!=DATE(NOW())')->whereNull('deleted_at')->count() }}</p>
					</td>
					<td>
						<p class="text-center">{{ $project->partners()->checkStatus(array('statusType'=>'reject'))->whereRaw('(DATE(lead_created_at)!=DATE(NOW()) OR lead_created_at IS NULL) AND DATE(updated_at)=DATE(NOW())')->count() }}</p>
					</td>
					<td>
						<p class="text-center">{{ $project->partners()->whereStatus(Partner::STATUS_REPEATED)->whereRaw('(DATE(lead_created_at)!=DATE(NOW()) OR lead_created_at IS NULL) AND DATE(updated_at)=DATE(NOW())')->count() }}</p>
					</td>
					<td>
						<p class="text-center">{{ $project->partners()->whereStatus(Partner::STATUS_TRASH_PHONE)->whereRaw('(DATE(lead_created_at)!=DATE(NOW()) OR lead_created_at IS NULL) AND DATE(updated_at)=DATE(NOW())')->count() }}</p>
					</td>
					<td>
						<p class="text-center">{{ $project->partners()->whereStatus(Partner::STATUS_SIZING)->whereRaw('(DATE(lead_created_at)!=DATE(NOW()) OR lead_created_at IS NULL) AND DATE(updated_at)=DATE(NOW())')->count() }}</p>
					</td>
					<td>
						<p class="text-center">{{ $project->partners()->checkStatus(array('statusType'=>'work'))->whereRaw('(DATE(lead_created_at)!=DATE(NOW()) OR lead_created_at IS NULL) AND DATE(updated_at)=DATE(NOW())')->count() }}</p>
					</td>
					<td>
						<p class="text-center">{{ $project->partners()->checkStatus(array('statusType'=>'paywaiting'))->whereRaw('(DATE(lead_created_at)!=DATE(NOW()) OR lead_created_at IS NULL) AND DATE(updated_at)=DATE(NOW())')->count() }}</p>
					</td>
					<td>
						<p class="text-center">{{ $project->partners()->where('paytype', '=', 1)->whereRaw('(DATE(lead_created_at)!=DATE(NOW()) OR lead_created_at IS NULL) AND DATE(datetime_of_agree)=DATE(NOW())')->count() }}</p>
					</td>
					<td>
						<p class="text-center">
							{{ $project->partners()->checkStatus(array('statusType'=>'agreed'))->whereRaw('(DATE(lead_created_at)!=DATE(NOW()) OR lead_created_at IS NULL) AND DATE(datetime_of_agree)=DATE(NOW())')->count() }}<br/>
							<span class="to-humanize" title="Сумма">{{ $project->partners()->checkStatus(array('statusType'=>'agreed'))->whereRaw('(DATE(lead_created_at)!=DATE(NOW()) OR lead_created_at IS NULL) AND DATE(datetime_of_agree)=DATE(NOW())')->sum('cartprice') }}</span> <i class="fa fa-rub"></i><br/>
							<span class="to-humanize" title="Прибыль">{{ $project->partners()->checkStatus(array('statusType'=>'agreed'))->whereRaw('(DATE(lead_created_at)!=DATE(NOW()) OR lead_created_at IS NULL) AND DATE(datetime_of_agree)=DATE(NOW())')->sum('cartprice') - $project->partners()->checkStatus(array('statusType'=>'agreed'))->whereRaw('(DATE(lead_created_at)!=DATE(NOW()) OR lead_created_at IS NULL) AND DATE(datetime_of_agree)=DATE(NOW())')->sum('prime_cost') }}</span> <i class="fa fa-rub"></i><br/>
						</p>
					</td>
				</tr>
				@endforeach
			</tbody>
		</table>
	</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-center">Ожидают оплаты</th>
					<th class="text-center">Оплачены</th>
					<th class="text-center">Оформлены</th>
				</tr>
			</thead>
			<tbody>
				@foreach ($projects as $project)
				<tr>
					<td>
						<p>{{ $project->name }}</p>
					</td>
					<td>
						<p class="text-center">{{ $project->partners()->checkStatus(array('statusType'=>'paywaiting'))->whereRaw('DATE(updated_at)=DATE(NOW())')->count() }}</p>
					</td>
					<td>
						<p class="text-center">{{ $project->partners()->where('paytype', '=', 1)->whereRaw('DATE(datetime_of_agree)=DATE(NOW())')->count() }}</p>
					</td>
					<td>
						<p class="text-center">
							{{ $project->partners()->checkStatus(array('statusType'=>'agreed'))->whereRaw('DATE(datetime_of_agree)=DATE(NOW())')->count() }}<br/>
							<span class="to-humanize" title="Сумма">{{ $project->partners()->checkStatus(array('statusType'=>'agreed'))->whereRaw('DATE(datetime_of_agree)=DATE(NOW())')->sum('cartprice') }}</span> <i class="fa fa-rub"></i><br/>
							<span class="to-humanize" title="Прибыль">{{ $project->partners()->checkStatus(array('statusType'=>'agreed'))->whereRaw('DATE(datetime_of_agree)=DATE(NOW())')->sum('cartprice') - $project->partners()->checkStatus(array('statusType'=>'agreed'))->whereRaw('DATE(datetime_of_agree)=DATE(NOW())')->sum('prime_cost') }}</span> <i class="fa fa-rub"></i><br/>
						</p>
					</td>
				</tr>
				@endforeach
			</tbody>
		</table>
	</div>

	<div class="panel panel-default">
		 <div class="panel-heading">
			 Распределение заявок по часам
			 <div class="btn-group" id="chartBtns">
				<button class="btn btn-default active" data-id="0">За сегодня</button>
				<button class="btn btn-default" data-id="1">За все время</button>
			</div>
		</div>
	 <div id="chart_div" style="height: 500px;"></div>
	</div>
@stop