@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', 'Leadtime_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">Overtime</th>
							<th class="text-center">Ratio</th>
							@endforeach
						</tr>
					</thead>

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

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

								foreach ($detailTransaksi as $dt) {
									$distribusi = $detailTransaksi->count();
									
									$leadTimeHari = date_diff( date_create(date('Y-m-d', strtotime($dt->transaksi->start_picking))), date_create(date('Y-m-d', strtotime($dt->transaksi->tgl_datang)))  )->format('%d');

									$leadTimeJam = date_diff( date_create(date('H:i:s', strtotime($dt->transaksi->tgl_berangkat))), date_create(date('H:i:s', strtotime($dt->transaksi->tgl_datang)))  )->format('%H');

									// Jika Over Hari / Over Jam
									if ( 
									$leadTimeHari > str_replace('H+','',$dt->transaksi->dealer->jadwal->hari) 
									|| 
									date('H:i:s', strtotime($dt->transaksi->tgl_datang)) > $dt->transaksi->dealer->jadwal->jam ){
										$overtime += 1;
									}

									if ($overtime > 0) {
										$ratio = round($overtime / $distribusi * 100, 2);
									}
								}

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

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

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

									foreach ($detailTransaksi as $dt) {
										$ttlDistribusi = $detailTransaksi->count();
										
										$leadTimeHari = date_diff( date_create(date('Y-m-d', strtotime($dt->transaksi->start_picking))), date_create(date('Y-m-d', strtotime($dt->transaksi->tgl_datang)))  )->format('%d');

										$leadTimeJam = date_diff( date_create(date('H:i:s', strtotime($dt->transaksi->tgl_berangkat))), date_create(date('H:i:s', strtotime($dt->transaksi->tgl_datang)))  )->format('%H');

										// Jika Over Hari / Over Jam
										if ( 
										$leadTimeHari > str_replace('H+','',$dt->transaksi->dealer->jadwal->hari) 
										|| 
										date('H:i:s', strtotime($dt->transaksi->tgl_datang)) > $dt->transaksi->dealer->jadwal->jam ){
											$ttlOvertime += 1;
										}

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

								@endphp	
							@endforeach
							<th class="text-center">{{ $ttlDistribusi }}</th>
							<th class="text-center">{{ $ttlOvertime }}</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