@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;
	}
	.rb{
		background-color: lightgrey;
		/* color:white; */
	}
</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('kwh-reading-list')}}">
				<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-responsive">
							<div class="table-container">
									<div class="table-responsive" style="max-height: 800px; overflow-y: auto;">
									<table class="table m-0 table-hover" style="font-size: 10px !important;">
										<thead style="position: sticky; top: 0;  z-index: 1;">
											<tr>
												<th rowspan="2" >Reading Date</th> 
												<th rowspan="2" class="wb ">GlobalID</th>
												<!-- <th rowspan="2">isRv</th> -->
												<th colspan="3" class="wb text-center"  > Total KWH Offpeak </th>
												<th colspan="3" class="wb text-center">Total KWH Peak</th>
											</tr>
											<tr>
												<!-- Voltages -->
												<th class="wb"> PESCO </th>
												<th >CISNR </th>
												<th > Difference </th>
												<th class="wb"> PESCO </th>
												<th >CISNR</th>
												<th >Difference</th>

											</tr>
										</thead>
										<tbody class="recent-record-row">
											@if($data && (!$data->isEmpty()))
											@php
															$previous = null;
														@endphp

														@foreach($data as $row)
															<tr>
																<td>{{ appDate($row->created_at) }}</td>
																<td class="bb">{{ $row->global_device_id }}</td>

																{{-- Offpeak --}}
																<td class="bb">{{ $row->pesco_total_kwho }}</td>
																<td>{{ $row->total_kwho }}</td>
																<td class="rb">
																	
																</td>

																{{-- Peak --}}
																<td class="bb">{{ $row->pesco_total_kwhp }}</td>
																<td>{{ $row->total_kwhp }}</td>
																<td class="rbg rb">
																	
																</td>
															</tr>

															{{-- Row-to-Row Difference Row --}}
															@if($previous)
															<tr style="background-color:rgb(230, 228, 228); font-weight: bold;">
																<td>Difference</td>
																<td class="bb"></td>

																{{-- Offpeak --}}
																<td class="bb">{{ abs($row->pesco_total_kwho - $previous->pesco_total_kwho) }}</td>
																<td>{{ abs($row->total_kwho - $previous->total_kwho) }}</td>
																<td class="rb">{{ abs(($row->pesco_total_kwho - $row->total_kwho) - ($previous->pesco_total_kwho - $previous->total_kwho)) }}</td>

																{{-- Peak --}}
																<td class="bb">{{ abs($row->pesco_total_kwhp - $previous->pesco_total_kwhp) }}</td>
																<td>{{ abs($row->total_kwhp - $previous->total_kwhp) }}</td>
																<td class="rbg rb">{{ abs(($row->pesco_total_kwhp - $row->total_kwhp) - ($previous->pesco_total_kwhp - $previous->total_kwhp)) }}</td>
															</tr>
															@endif

															@php
																$previous = $row;
															@endphp
														@endforeach
											@else
												<tr>
													<td colspan="25" class="text-danger">Record Not Found</td>
												</tr>
											@endif
										</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>
			</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