@extends('layouts.index')

@section('header')
<div class="row align-items-center py-4">
	<div class="col-lg-6 col-7">
		<h6 class="h2 text-white d-inline-block mb-0"> {{$title}} </h6>
		<nav aria-label="breadcrumb" class="d-none d-md-inline-block ml-md-4">
			<ol class="breadcrumb breadcrumb-links breadcrumb-dark">
				<li class="breadcrumb-item"><a href="{{url($url)}}"><i class="fas fa-home"></i></a></li>
				<li class="breadcrumb-item active" aria-current="page">{{$menu}}</li>
			</ol>
		</nav>
	</div>
</div>
@endsection

@push('styles')
<style>
	.select2-container .select2-selection--single{
		height : auto !important;
	}
</style>
@endpush

@section('content')
<div class="row">
	<div class="col">
		<div class="card">
			<!-- Card header -->
			<div class="card-header border-0">
				<div class="row">
					<div class="col-6">
						<h3 class="mb-0">{{$title}}</h3>
					</div>
					<div class="col-6 text-right">
						
					</div>
				</div>
            </div>
			<div class="col-12">
                <form action="{{route('laporan.show', 'Defect_Per_Bulan')}}" method="GET" class="row">
                    <div class="form-group col-2"  style="margin-bottom:0 !important;">
						@php
							$tahun_list = date('Y');
						@endphp
                        <select name="tahun" id="tahun" class="form-control">
                            <option value="">Tampilkan Semua</option>
							@for($i = 10;$i > 0; $i--)
							<option value="{{$tahun_list - $i}}">{{$tahun_list - $i}}</option>
							@endfor
							<option value="{{$tahun_list}}">{{$tahun_list}}</option>
                        </select>
                    </div>
                    <div class="form-group col-2"  style="margin-bottom:0 !important;">
                        <button type="submit" class="btn btn-success">Cari</button>
                    </div>
                </form>
            </div>
			<div class="table-responsive py-4">
				<table class="table table-flush" >
					<thead class="table-success">
						<tr>
							<th rowspan="2" class="text-center align-middle">Bulan</th>
							@foreach($datas as $data)
							<th colspan="3" class="text-center"> {{ $data->nama_perusahaan }} </th>
							@endforeach
						</tr>

						<tr>
							@foreach($datas as $data)
							<th class="text-center">Distribusi</th>
							<th class="text-center">Defect</th>
							<th class="text-center">Ratio</th>
							@endforeach
						</tr>
					</thead>

					<tbody>
						@foreach ($bulans as $key => $bulan)

						@php
						$distribusi = 0;
						$defect = 0;
						$ratio = 0;
						@endphp
						<tr>
							<td>{{ $bulan }}</td>
							@foreach ($datas as $data)
							@php
								$transaksi = \App\Models\Transaksi::whereHas('dealer', function($d) use($data) {
									$d->whereHas('perusahaan', function($p) use($data) {
										$p->where('id', $data->id);
									});
								})->whereMonth('start_picking', $key)->where('status', 'selesai')->get();

								foreach ($transaksi as $t) {
									$distribusi = $t->detailTransaksi->count();
									$defect = $t->detailTransaksi->whereNotNull('keluhan')->count();
									$ratio = round($defect / $distribusi * 100, 2);
								}

							@endphp
							<td class="text-center"> {{ $distribusi }}	</td>
							<td class="text-center"> {{ $defect }} </td>
							<td class="text-center"> {{ $ratio }}% </td>
							@endforeach
						</tr>
						@endforeach

						@php
							$ttlDistribusi = 0;
							$ttlDefect = 0;
							$ttlRatio = 0;
						@endphp

						<tr>
							<th>Total</th>
							@foreach ($datas as $data)
								@php
									$transaksi = \App\Models\Transaksi::whereHas('dealer', function($d) use($data) {
										$d->whereHas('perusahaan', function($p) use($data) {
											$p->where('id', $data->id);
										});
									})->where('status', 'selesai')->get();

									foreach ($transaksi as $t) {
										$ttlDistribusi += $t->detailTransaksi->count();
										$ttlDefect += $t->detailTransaksi->whereNotNull('keluhan')->count();

										if ($ttlDefect > 0) {
											$ttlRatio = round($ttlDefect / $ttlDistribusi * 100, 2);
										}
									}

								@endphp	
							@endforeach
							<th class="text-center">{{ $ttlDistribusi }}</th>
							<th class="text-center">{{ $ttlDefect }}</th>
							<th class="text-center">{{ $ttlRatio }} %</th>
						</tr>

					</tbody>
				</table>
			</div>
		</div>
	</div>
</div>

@push('scripts')
<script type="text/javascript">

	$(document).ready(function(){		
		$('.select2-single').select2();
	});
</script>
@endpush
@endsection