@extends('_version_02.commons.layouts.admin')
@section('content')
{!! Form::model($model, ['class'=>'form-horizontal','method'=>'get']) !!}
<section class="hk-sec-wrapper">
    <h5 class="hk-sec-title">{{App\Language::trans('Filter By')}}</h5><hr>
   		

   		<div class="row">
			<div class="col-md-6">
				<div class="form-group{{ $errors->has('month_started') ? ' has-error' : '' }}">
					{!! Form::label('month_started', App\Language::trans('From Month'), ['class'=>'control-label col-md-4']) !!}
					<div class="col-md-8">
						{!! Form::select('month_started', App\PowerMeterModel\MeterInvoice::previous_one_year_combobox(), (old('month_started') ? old('month_started'):$model->three_month_pass()), ['class'=>'form-control','autofocus']) !!}
                        {!!$errors->first('month_started', '<label for="month_started" class="help-block error">:message</label>')!!}
					</div>
				</div>
			</div>
			<div class="col-md-6">
				<div class="form-group{{ $errors->has('month_ended') ? ' has-error' : '' }}">
					{!! Form::label('month_ended', App\Language::trans('To Month'), ['class'=>'control-label col-md-4']) !!}
					<div class="col-md-8">
						{!! Form::select('month_ended', App\PowerMeterModel\MeterInvoice::previous_one_year_combobox(), (old('month_ended') ? old('month_ended'):$model->last_month()), ['class'=>'form-control']) !!}
                        {!!$errors->first('month_ended', '<label for="month_ended" class="help-block error">:message</label>')!!}
					</div>
				</div>
			</div>
		</div>

		<div class="row">
			<div class="col-md-12">
				<div class="form-group{{ $errors->has('leaf_house_id') ? ' has-error' : '' }}">
					{!! Form::label('leaf_house_id', App\Language::trans('Unit No.'), ['class'=>'control-label col-md-4']) !!}
					<div class="col-md-12">
						{!! Form::select('leaf_house_id', App\PowerMeterModel\MeterRegister::houses_combobox(), null, ['class'=>'form-control','required','onchange'=>'init_room_combobox(this)']) !!}
                        {!!$errors->first('leaf_house_id', '<label for="leaf_house_id" class="help-block error">:message</label>')!!}
					</div>
				</div>
			</div>
		</div>

		<div class="row">
			<div class="col-md-12">
				<div class="form-group{{ $errors->has('leaf_room_id') ? ' has-error' : '' }}">
					{!! Form::label('leaf_room_id', App\Language::trans('Room No.'), ['class'=>'control-label col-md-4']) !!}
					<div class="col-md-12">
						{!! Form::select('leaf_room_id', App\PowerMeterModel\MeterRegister::rooms_combobox((old('leaf_house_id') ? old('leaf_house_id'):$model->leaf_house_id)), null, ['class'=>'form-control','onchange'=>'init_room_status(this)']) !!}
                        {!!$errors->first('leaf_room_id', '<label for="leaf_room_id" class="help-block error">:message</label>')!!}
                        <!-- ,'required' -->
					</div>
				</div>
			</div>
		</div>
		
		<div class="row">
			<div class="col-md-6">
				<div class="form-group{{ $errors->has('export_by') ? ' has-error' : '' }}">
					{!! Form::label('export_by', App\Language::trans('Exported By'), ['class'=>'control-label col-md-4']) !!}
					<div class="col-md-12">
						 <div class="row">	
						 	
							<div class="col-md-3">
							    <div class="custom-control custom-radio">
							        <input type="radio" id="export_by_html" name="export_by" value="html"  class="custom-control-input">
							        <label class="custom-control-label" for="export_by_html">{{App\Language::trans('HTML')}}</label>
							    </div>
							</div>

							<div class="col-md-3">
							    <div class="custom-control custom-radio">
							        <input type="radio" id="export_by_pdf" name="export_by" value="pdf" checked class="custom-control-input">
							        <label class="custom-control-label" for="export_by_pdf">{{App\Language::trans('PDF')}}</label>
							    </div>
							</div>
							
							<div class="col-md-3">
							    <div class="custom-control custom-radio">
							        <input type="radio" id="export_by_excel" name="export_by" value="excel"  class="custom-control-input">
							        <label class="custom-control-label" for="export_by_excel">{{App\Language::trans('Excel')}}</label>
							    </div>
							</div>

						 </div>
						 {!!$errors->first('export_by', '<label for="export_by" class="help-block error">:message</label>')!!}
					</div>
				</div>
			</div>
		</div>

</section>
@include('_version_02.commons.layouts.partials._form_floating_footer_report')
{!! Form::close() !!}
@if(count($listing))

	@php 
		$no_reading_arr = array();
		$tenant_header = ['#','Name','Move In Date' , 'Move Out Date'];
		$tenant_variables = ['house_member_name','house_room_member_start_date','house_room_member_end_date'];

	@endphp
	<section class="hk-sec-wrapper">
    <h5 class="hk-sec-title">{{App\Language::trans('Result')}}</h5><hr>

			<div class="table-responsive">
				<table class="table table-bordered table-hover">
					<thead>
						<tr>
							<th class="text-center">{{App\Language::trans('Month')}}</th>
							<th class="text-center">{{App\Language::trans('Total Hours')}}</th>
							<th class="text-center">{{App\Language::trans('Avg. kW')}}</th>
							<th class="text-center">{{App\Language::trans('Max. kW')}}</th>
							<th class="text-center">{{App\Language::trans('Min. kW')}}</th>
							<th class="text-center">{{App\Language::trans('Total kWh')}}</th>
							<th class="text-center">{{App\Language::trans('Total Charges (RM)')}}</th>
						</tr>
					</thead>
					<tbody>
					@php  
						$x=0;
						$total_payable_amount = 0;
					@endphp
	
					@foreach($houses_detail as $house)
						<tr style="background-color: #ddd;">
							<td class="text-left" colspan="7">{{App\Language::trans('Unit')}} : {{$house['house_unit']}}</td>
						</tr>
						@foreach($house['house_rooms'] as $room)

							@php  
								$isMeterRegister = false;
								$isFirstRoomHeader = true;
								$rowNo =0;
								$room_subtotal =0;
								$total_payable_amount = 0;
								$room_subtotal_total_usage  =0;
							@endphp
						
						

						

							@foreach($listing as $row)
								@if(!isset($room['meter']['id']))

										<tr>
											<td class="text-left" colspan="1">{{App\Language::trans('Room')}} : {{$room['house_room_name']}}  </td>
											<td class="text-left" colspan="6"><span class='label label-danger'> {{App\Language::trans(App\Setting::SUNWAY_NO_METER_FOUND_LABEL)}} </span></td>
										</tr>
										@php   break;	@endphp

								@elseif($row->meter_register_id == $room['meter']['id'])
									@if($isFirstRoomHeader == true)
										<tr style="background-color: #FFFEFE;">
											<td class="text-left" colspan="1">{{App\Language::trans('Room')}} : {{$room['house_room_name']}}  </td>
											<td  class="text-left"  colspan="6" >{{App\Language::trans('Meter ID')}} : <span class='label label-success'> {{$listing[$rowNo]->meter_register_id}} </span></td>
										</tr>

										@if($is_show_tenant)
											
																					
													
											@if(count($room['house_room_members']) > 0)
													<tr>
														<th colspan="7" class="text-left">{{App\Language::trans('Tenant Detail')}}</th>								
													
													</tr>
													<tr>
														@foreach($tenant_header as $h_key) 
															@php $extra_html = ""; @endphp
															@if($h_key == 'Move Out Date')
																@php $extra_html = " colspan=4 "; @endphp
																
															@endif
															<th class="text-left" {{ $extra_html }}> {{ App\Language::trans($h_key) }}</th>
														
														@endforeach
													</tr>

													@php $t_counter =1 ; $extra_html = ""; @endphp
													@foreach($room['house_room_members'] as $member) 
													<tr>
														<td class="text-left" colspan="1">{{ $t_counter }}  </td>
														@foreach($tenant_variables as $t_variable) 
															@php $extra_html = ""; @endphp
															@if($t_variable == 'house_room_member_end_date')
																@php
																	$extra_html = " colspan=4 ";
																	$member[$t_variable] = $member[$t_variable] == '0000-00-00 00:00:00' ? '-' : $member[$t_variable];
																@endphp							
															@endif
															
															<td class="text-left" {{ $extra_html }}> {{App\Language::trans($member[$t_variable]) }}  </td>
															

														@endforeach
														@php $t_counter ++ ; @endphp
													</tr>	
													@endforeach

											@else
													<tr>
														<th colspan="7" class="text-center">{{App\Language::trans('No tenanted')}}</th>								
													
													</tr>
													
											@endif
									@endif

										<tr>
											<th class="text-center">{{App\Language::trans('Month')}}</th>
											<th class="text-center">{{App\Language::trans('Total Hours')}}</th>
											<th class="text-center">{{App\Language::trans('Avg. kW')}}</th>
											<th class="text-center">{{App\Language::trans('Max. kW')}}</th>
											<th class="text-center">{{App\Language::trans('Min. kW')}}</th>
											<th class="text-center">{{App\Language::trans('Total kWh')}}</th>
											<th class="text-center">{{App\Language::trans('Total Charges (RM)')}}</th>
										</tr>
									@endif
									
									


									@php  				
										$payable_amount = App\Setting::calculate_utility_fee($row->total_usage);
										$isFirstRoomHeader = false;			
										$isMeterRegister = true;
										$total += $row->total_usage; 
										$room_subtotal += $payable_amount;
										$room_subtotal_total_usage += $row->total_usage;
// && $row->total_hours == 0
										if($row->total_usage == 0)
										{
											$temp_meter = App\PowerMeterModel\MeterRegister::find($row->meter_register_id);
											$no_reading_arr[$row->meter_register_id] = $temp_meter;
										}

									@endphp		
										<tr>
											<td class="text-center">{{date('m-Y', strtotime($row->current_date))}}</td>
											<td class="text-center">{{$row->total_hours}}</td>
											<td class="text-center">{{number_format($row->average_usage,9)}}</td>
											<td class="text-center">{{number_format($row->max_usage,9)}}</td>
											<td class="text-center">{{number_format($row->min_usage,9)}}</td>
											<td class="text-center">{{number_format($row->total_usage,9)}}</td>
											<td class="text-right">{{number_format($payable_amount,2)}}</td>
										</tr>
										
								@endif
				
								@php  
								$rowNo++;
								@endphp
								
								
							@endforeach
							
							@if(isset($room['meter']['id']))
								<tr>
									<td class="text-right" colspan="5">{{App\Language::trans('Room Subtotal')}}</td>
									<td class="text-center">{{number_format($room_subtotal_total_usage, 9)}}</td>
									<td class="text-right">{{number_format($room_subtotal, 2)}}</td>
								</tr>
							@endif
									
							@php  
								$x = $x + $room_subtotal;
								$isMeterRegister = false;
							@endphp
							
						@endforeach
					@endforeach

	
						
					</tbody>
					<tfoot>
						<tr style="background-color: #ddd;">
							<td class="text-right" colspan="5">{{App\Language::trans('Total')}}:</td>
							<td class="text-center">{{number_format($total, 9)}}</td>
							<td class="text-right">{{number_format($x,2)}}</td>
						</tr>
					</tfoot>
				</table>


				<table class="table table-bordered table-hover">
					<thead>
						<tr>
							<th class="text-center">{{App\Language::trans('ID')}}</th>
							<th class="text-center">{{App\Language::trans('Room')}}</th>
							<th class="text-center">{{App\Language::trans('IP Address')}}</th>
						</tr>
					</thead>
					<tbody>
	
					@foreach($no_reading_arr as $no_reading_meter)

								@php  
						//dd($no_reading_meter);
					@endphp

						<tr>

							<td class="text-center">{{ $no_reading_meter->meter_id }}</td>
							<td class="text-center">{{ $no_reading_meter->ip_address }}</td>
							<td class="text-center">{{ App\LeafAPI::get_room_name_by_leaf_room_id($no_reading_meter->leaf_room_id) }}</td>
						</tr>
						
	
					@endforeach
					</tbody>
				</table>
			</div>
			
	</section>

@elseif(count($listing) == 0 && $is_search_result == true)
	@include('_version_02.commons.report_modules.no_data_found')
@endif
@stop
@section('script')
$(".input-daterange").datepicker({
	format: "dd-mm-yyyy",
});
@stop