@extends('layouts.app')

@section('center')
<style>
	.wb{
		border-left:1px solid white !important;
	}
	.bb{
		border-left:1px solid lightgray !important;
	}
	.rbg{
		border-right:1px solid lightgray !important;
	}
</style>
				<link rel="stylesheet" href="{{asset('assets')}}/vendor/datepicker/css/classic.css" />
				<link rel="stylesheet" href="{{asset('assets')}}/vendor/datepicker/css/classic.date.css" />
				<link rel="stylesheet" href="{{asset('assets')}}/vendor/bs-select/bs-select.css" />
<div class="row gutters">
			<div class="col-xl-12 col-lg-12 col-md-12 col-sm-12 col-12">
				<form action="{{route('kvaLog')}}">
				<div class="row gutters">
				<div class="col-xl-2 col-lg-2 col-md-2 col-sm-2">

							<div class="form-group">
								<label class="label">Device ID</label>
								<select class="form-control selectpicker" data-live-search="true" class="form-control " name="DeviceId">
									<option value=''>Select Device ID</option>
									@foreach($tr_data as $k => $row)
									<option value="{{$row->global_device_id}}" @isset($_GET["DeviceId"])
																	@if($_GET["DeviceId"]==$row->global_device_id) {{'selected'}} @endif
																	@endisset>{{$row->global_device_id}}</option>
									@endforeach

								</select>
							</div>

						</div>

						<div class="col-xl-3 col-lg-3 col-md-3 col-sm-3">

							<div class="form-group">
								<label class="label">From Date</label>
								<input type="text" class="form-control datepicker" name="from" placeholder="From"
																		@isset($_GET["from"])
																			 value="{{$_GET['from']}}"
																		@endisset >
							</div>

						</div>

						<div class="col-xl-3 col-lg-3 col-md-3 col-sm-3">

							<div class="form-group">
								<label class="label">To Date</label>
								<input type="text" class="form-control datepicker" name="to" placeholder="To"
								@isset($_GET["to"])
																			 value="{{$_GET['to']}}"
																		@endisset
								>
							</div>

						</div>

			<div class="col-xl-2 col-lg col-md-2 col-sm-2 col-12 ">
			<div class="form-group">
					<label class="label">&nbsp;</label>
					<button type="submit" class="form-control btn btn-primary generate">Generate</button>
				</div>

			</div>
				</div>
			</form>
			</div>

				<div class="col-xl-12 col-lg-12 col-md-12 col-sm-2 col-12">
						<div class="table-container">
								<div class="table-responsive" style="max-height: 800px; overflow-y: auto;">
								<table class="table table-bordered table-striped m-0" style="font-size:10px !important;">
									<thead style="position: sticky; top: 0;  z-index: 1;">
										<tr>
										<th  class=" wb">Time</th> 
											<th class="wb">Global ID</th>

											<!-- <th colspan="3" class="text-center wb">Voltages (V)</th> -->
											<!-- <th colspan="3" class="text-center wb">Currents (I)</th> -->
											<!-- <th colspan="3" class="text-center wb">Power Factor (PF)</th> -->
											<th colspan="3" class="text-center wb">kVA</th>
											<th colspan="3" class="text-center wb">kVAR</th>
											<th colspan="6" class="text-center wb">kVARh</th>
											<th colspan="6" class="text-center wb">rkVARh</th>

										</tr>
										<tr>
											<th></th>
											<!-- <th class="wb">V1</th> -->
											<!-- <th >V2</th> -->
											<!-- <th>V3</th> -->
											<!-- <th class="wb">I1</th> -->
											<!-- <th>I2</th> -->
											<!-- <th>I3</th> -->
											<!-- <th class="wb">PF1</th> -->
											<!-- <th>PF2</th> -->
											<!-- <th>PF3</th> -->
											<th></th>
											<th class="wb">kva1</th>
											<th>kva2</th>
											<th>kva3</th>

											<th class="wb">kvar1</th>
											<th>kvar2</th>
											<th>kvar3</th>


											<th class="wb">o1</th>
											<th>o2</th>
											<th>o3</th>
											<th >p1</th>
											<th>p2</th>
											<th>p3</th>

											<th class="wb">o1</th>
											<th>o2</th>
											<th>o3</th>
											<th >p1</th>
											<th>p2</th>
											<th>p3</th>


										</tr>
									</thead>
									<tbody>
										@foreach($data as $k => $row)
										@if($row->kva1 && $row->kva2 && $row->kva3 && $row->kvar1 && $row->kvar2 &&  $row->kvar3 &&  $row->kvar3 &&  $row->kvarho1 &&  $row->kvarho2 &&  
										$row->kvarho3 &&  $row->rkvarho1  &&  $row->rkvarho2  &&  $row->rkvarho3  ) 
										<tr >
												<td>{{appDate($row->dtime)}}</td>
												<td class="bb" style="color:blue;">{{ $row->global_device_id }}</td>
											

												<td class="bb">{{ $row->kva1 }}</td>
												<td>{{ $row->kva2 }}</td>
												<td>{{ $row->kva3 }}</td>

												<td class="bb">{{ $row->kvar1 }}</td>
												<td>{{ $row->kvar2 }}</td>
												<td>{{ $row->kvar3 }}</td>



												<td class="bb">{{ $row->kvarho1 }}</td>
												<td>{{ $row->kvarho2 }}</td>
												<td>{{ $row->kvarho3 }}</td>

												<td class="bb">{{ $row->kvarhp1 }}</td>
												<td>{{ $row->kvarhp2 }}</td>
												<td>{{ $row->kvarhp3 }}</td>

												<td class="bb">{{ $row->rkvarho1 }}</td>
												<td>{{ $row->rkvarho2 }}</td>
												<td>{{ $row->rkvarho3 }}</td>


												<td class="bb">{{ $row->rkvarhp1 }}</td>
												<td>{{ $row->rkvarhp2 }}</td>

												


												<td class="rbg ">{{ $row->rkvarhp3 }}</td>


											</tr>
										@endif
										@endforeach
									</tbody>
								</table>

								</div>
								<div class="d-flex  mt-3">
									{{ $data->appends(request()->query())->links('pagination::bootstrap-4') }} <!-- You can change the pagination view style -->
								</div>
						</div>

				</div>
			</div>

			@push('scripts')
			<script src="{{asset('assets')}}/vendor/datepicker/js/picker.js"></script>
			<script src="{{asset('assets')}}/vendor/datepicker/js/picker.date.js"></script>
			<script src="{{asset('assets')}}/vendor/datepicker/js/custom-picker.js"></script>
			<script src="{{asset('assets')}}/vendor/bs-select/bs-select.min.js"></script>
			<script src="{{asset('assets')}}/js/main.js"></script>
			@endpush
@endsection