@extends('_version_02.commons.layouts.admin')
@section('content')
{!! Form::model($model, ['class'=>'form-horizontal']) !!}
@include('_version_02.commons.layouts.partials._alert')

<section class="hk-sec-wrapper">
    <h5 class="hk-sec-title">{{App\Language::trans('Information')}}</h5>
   		@php
   			$message = $model->getSubsidyEffectiveDescription();
   		@endphp
		<div class="row mb-15">
		    <div class="col-sm">
		        <div class="media pa-20 border border-2 border-light rounded">
		            <img class="mr-15 circle d-74" src="{{asset('img/red_information.png')}}" alt="Generic placeholder image">
		            <div class="media-body">
		                <h6 class="mb-5">{{App\Language::trans('Information')}}</h6>
		                 {{App\Language::trans($message)}}
		            </div>
		        </div>
		    </div>
		</div>

		<div class="row">
			<div class="col-md-6">
				<div class="form-group{{ $errors->has('status') ? ' has-error' : '' }}">
					{!! Form::label('status', App\Language::trans('Status'), ['class'=>'control-label col-md-4', 'style' => 'margin-bottom:0px;' ]) !!}
					<label style="margin-bottom:0px;"  class="form-control-static">
							<small class="badge badge-{{$model->status != 0  ? 'success' : 'danger'}} mt-15 mr-10">{{$model->display_status_string('status')}}</small>
						


					</label>				
					</div>
				</div>
		</div>

		<div class="row">
			<div class="col-md-6">
				<div class="form-group{{ $errors->has('code') ? ' has-error' : '' }}">
					{!! Form::label('code', App\Language::trans('Code'), ['class'=>'control-label col-md-4', 'style' => 'margin-bottom:0px;' ]) !!}
					<label style="margin-bottom:0px;"  class="form-control-static">{{$model->code}}</label>
					
				</div>
			</div>

			<div class="col-md-6">
				<div class="form-group{{ $errors->has('name') ? ' has-error' : '' }}">
					{!! Form::label('text', App\Language::trans('Name'), ['class'=>'control-label col-md-4', 'style' => 'margin-bottom:0px;' ]) !!}
					<label style="margin-bottom:0px;"  class="form-control-static">{{$model->name}}</label>
				</div>
			</div>
		</div>


		<div class="row">
			<div class="col-md-6">
				<div class="form-group{{ $errors->has('amount') ? ' has-error' : '' }}">
					{!! Form::label('amount', App\Language::trans('Amount'), ['class'=>'control-label col-md-4', 'style' => 'margin-bottom:0px;' ]) !!}
					<label style="margin-bottom:0px;"  class="form-control-static">{{$model->amount}}</label>
				</div>
			</div>
		</div>

		<div class="row">
			<div class="col-md-6">
				<div class="form-group{{ $errors->has('room_type') ? ' has-error' : '' }}">
					{!! Form::label('room_type', App\Language::trans('Room Type'), ['class'=>'control-label col-md-4', 'style' => 'margin-bottom:0px;' ]) !!}
					<label style="margin-bottom:0px;"  class="form-control-static">{{$model->display_room_type_string('room_type')}}</label>
				</div>
			</div>	
		</div>


		<div class="row">
			<div class="col-md-6">
				<div class="form-group{{ $errors->has('implementation_date') ? ' has-error' : '' }}">
					{!! Form::label('implementation_date', App\Language::trans('Implementation Day'), ['class'=>'control-label col-md-4', 'style' => 'margin-bottom:0px;' ]) !!}
					<label style="margin-bottom:0px;"  class="form-control-static">{{$model->getDayInWord($model->implementation_date)}}</label>
				</div>
			</div>
		</div>

		<div class="row">
			<div class="col-md-6">
				<div class="form-group{{ $errors->has('starting_date') ? ' has-error' : '' }}">
					{!! Form::label('starting_date', App\Language::trans('From Month'), ['class'=>'control-label col-md-4', 'style' => 'margin-bottom:0px;' ]) !!}
					<label style="margin-bottom:0px;"  class="form-control-static">{{$model->setDate($model->starting_date)}}</label>
				</div>
			</div>
			<div class="col-md-6">
				<div class="form-group{{ $errors->has('month_ended') ? ' has-error' : '' }}">
					{!! Form::label('ending_date', App\Language::trans('To Month'), ['class'=>'control-label col-md-4', 'style' => 'margin-bottom:0px;' ]) !!}
					<label style="margin-bottom:0px;"  class="form-control-static">{{$model->setDate($model->ending_date)}}</label>
				</div>
			</div>
		</div>

		
		
		

		<div class="row">
			<div class="col-md-6">
				<div class="form-group{{ $errors->has('remark') ? ' has-error' : '' }}">
					{!! Form::label('remark', App\Language::trans('Remark'), ['class'=>'control-label col-md-4', 'style' => 'margin-bottom:0px;' ]) !!}
					<label class="form-control-static">{{$model->remark}}</label>
				</div>
			</div>
		</div>


	<!-- Plugin: Dual Select List -->
	@php 
		$grand_total = 0;
		$listing_index = 1;
		$ids = App\Support\SubsidyRecipientSelection::decode($model->subsidize_tenant_id ?: '[]');
		$selectedIds = array_fill_keys($ids, true);
		$member_detail = array();
		$room_name_list = array();
		$directoryUnavailable = false;
		try {
			$directory = (new App\LeafAPI())->get_houses();
			App\Support\SubsidyRecipientSelection::catalog($directory);
			foreach ($directory['house'] as $house) {
				foreach (isset($house['house_rooms']) && is_array($house['house_rooms']) ? $house['house_rooms'] : array() as $room) {
					$roomId = isset($room['id_house_room']) ? $room['id_house_room'] : 0;
					$roomName = isset($room['house_room_name']) ? $room['house_room_name'] : 'Room #' . $roomId;
					foreach (isset($room['house_room_members']) && is_array($room['house_room_members']) ? $room['house_room_members'] : array() as $member) {
						if (!isset($member['id_house_member']) || !isset($selectedIds[(string) $member['id_house_member']])) { continue; }
						$member += array('house_member_name' => 'Member #' . $member['id_house_member'], 'house_member_id_user' => 0, 'house_room_member_start_date' => '', 'house_room_member_end_date' => '0000-00-00 00:00:00');
						$member['id_house_room'] = $roomId;
						$member['room_name'] = $roomName;
						$member_detail[$member['id_house_member']] = $member;
						$room_name_list[$roomId] = $roomName;
					}
				}
			}
		} catch (\Throwable $e) {
			$directoryUnavailable = true;
		}
		// Every saved recipient stays visible even if directory data is missing.
		foreach ($ids as $id) {
			if (!isset($member_detail[$id])) {
				$member_detail[$id] = array('id_house_member' => $id, 'id_house_room' => 0, 'house_member_name' => 'Member #' . $id . ' (directory details unavailable)', 'house_member_id_user' => 0, 'house_room_member_start_date' => '', 'house_room_member_end_date' => '0000-00-00 00:00:00');
				$room_name_list[0] = 'Directory details unavailable';
			}
		}


		$cpus_listing = array();
		$cpus_listing_2 = array();
		$temp_cpus_listing = App\PowerMeterModel\CustomerPowerUsageSummary::whereIn('id_house_member', $ids)->get();
		$leaf_user_ids = array();
		foreach($temp_cpus_listing as $cpus)
		{//dd($cpus);
			$cpus_listing[$cpus['leaf_room_id']] =  isset($cpus_listing[$cpus['leaf_room_id']]) ? $cpus_listing[$cpus['leaf_room_id']] : array();
			array_push($cpus_listing[$cpus['leaf_room_id']] , $cpus);
			$leaf_user_ids[$cpus['leaf_id_user']] = $cpus['leaf_id_user'];

			$cpus_listing_2[$cpus['leaf_room_id']][$cpus['id_house_member']] =  isset($cpus_listing_2[$cpus['leaf_room_id']][$cpus['id_house_member']]) ? $cpus_listing_2[$cpus['leaf_room_id']][$cpus['id_house_member']] : array();
			array_push($cpus_listing_2[$cpus['leaf_room_id']][$cpus['id_house_member']] , $cpus);

		}
		//dd($cpus_listing_2);
		$user_emails = array();
		$temp_users = App\User::WhereIn('leaf_id_user',$leaf_user_ids)->get();
		foreach($temp_users as $user)
		{
			$user_emails[$user['leaf_id_user']] = $user['email'];
		}
	

		$user_subsidiary_listing = array();
		$user_subsidiary_listing_2 = array();
		$user_subsidiary_by_member = array();
		$temp_user_subsidiary_listing = App\PowerMeterModel\MeterPaymentReceived::getSubsidyBySudsidyId($model->id);
		foreach($temp_user_subsidiary_listing as $subsidy)
		{//dd($subsidy);
			$user_subsidiary_by_member[$subsidy['id_house_member']] = isset($user_subsidiary_by_member[$subsidy['id_house_member']]) ? $user_subsidiary_by_member[$subsidy['id_house_member']] : array();
			array_push($user_subsidiary_by_member[$subsidy['id_house_member']], $subsidy);
			$user_subsidiary_listing[$subsidy['leaf_room_id']] =  isset($user_subsidiary_listing[$subsidy['leaf_room_id']]) ? $user_subsidiary_listing[$subsidy['leaf_room_id']] : array();
			array_push($user_subsidiary_listing[$subsidy['leaf_room_id']] , $subsidy);

			$user_subsidiary_listing_2[$subsidy['leaf_room_id']][$subsidy['id_house_member']] =  isset($user_subsidiary_listing_2[$subsidy['leaf_room_id']][$subsidy['id_house_member']]) ? $user_subsidiary_listing_2[$subsidy['leaf_room_id']][$subsidy['id_house_member']] : array();
			array_push($user_subsidiary_listing_2[$subsidy['leaf_room_id']][$subsidy['id_house_member']] , $subsidy);
		}

		//dd($user_subsidiary_listing_2);
		//echo $model->id;
		//dd($user_subsidiary_listing);
	@endphp


@if(count($member_detail) > 0)
	@if($directoryUnavailable)<div class="alert alert-warning">The tenant directory could not be loaded. Saved recipient IDs remain listed below.</div>@endif

	@php
		$member_detail_2 = array();	
		foreach($member_detail as $member)
		{//dd($member);
				$member_detail_2[$member['id_house_room']] = isset($member_detail_2[$member['id_house_room']]) ? $member_detail_2[$member['id_house_room']] : array();
				array_push($member_detail_2[$member['id_house_room']] , $member);
		}

			//dd($member_detail_2);
	@endphp
	<section class="hk-sec-wrapper">
   		 <h5 class="hk-sec-title" style="margin-bottom:0px;">{{App\Language::trans('Recipient List')}}</h5>
			<div class="table-responsive">
				<table class="table table-bordered table-hover">
					<!-- <thead>
						<tr  style="background-color: #ddd;">
							<th class="text-center">#</th>
							<th class="text-center">{{App\Language::trans('Room Name')}}</th>
							<th class="text-center">{{App\Language::trans('Name')}}</th>		
							<th class="text-center">{{App\Language::trans('Check In Date')}}</th>	
							<th class="text-center" colspan="2">{{App\Language::trans('Check Out Date')}}</th>
						</tr>
					</thead> -->
					<tbody>

						@foreach($member_detail_2 as $id_house_room => $members)
								
@php //dd($member); @endphp
								<tr  style="background-color: #ddd;">
									<th class="text-left" colspan="5"> {{App\Language::trans('Room : ')}} {{ isset($room_name_list[$id_house_room]) ? $room_name_list[$id_house_room] : '-' }}</th>
								</tr>

								<tr  style="background-color: #ddd;">
									<th class="text-center">#</th>
									<!-- <th class="text-center">{{App\Language::trans('Room Name')}}</th> -->
									<th class="text-center">{{App\Language::trans('Name')}}</th>		
									<th class="text-center">{{App\Language::trans('Check In Date')}}</th>	
									<th class="text-center">{{App\Language::trans('Check Out Date')}}</th>
									<th class="text-center">

											{{App\Language::trans('App User')}}

											
												
											
									</th>
								</tr>

						@foreach($members as $member)			
					            <tr>
					            	<td class="text-center">{{ $listing_index }}</td>
									<!-- <td class="text-center">{{ $member['room_name'] }}</td> -->
									<td class="text-center">{{ $member['house_member_name'] }} 
											@if(isset($cpus_listing[$member['id_house_room']]))
												@if(isset($user_emails[$member['house_member_id_user']]))	
													<a target="_blank" href="http://13.251.20.181/leaf_webview/public/index.php/utility_charges/dashboard/testing_version?email={{$user_emails[$member['house_member_id_user']]}}"><i class="fa fa-mobile" aria-hidden="true"></i></a>
												@endif
											@endif
									</td>
									<td class="text-center">{{ $member['house_room_member_start_date'] }}</td>
									<td class="text-center">{{ $member['house_room_member_end_date'] == '0000-00-00 00:00:00' ? '-' : $member['house_room_member_end_date'] }}</td>
									<td class="text-center">
										@if(isset($cpus_listing[$member['id_house_room']]))
											<small class="badge badge-success mt-15 mr-10">Yes</small>
											
										@else
											<small class="badge badge-danger mt-15 mr-10">No</small>
										@endif

									</td>
								</tr>
								
								@php 
									$listing_index ++;
									$subsidy_index = 1;
									//  style="background-color: #ddd;"
								@endphp
								<tr>
									<th class="text-center">#</th>
									<th class="text-center">{{App\Language::trans('Document No')}}</th>
									<th class="text-center">{{App\Language::trans('Document Date')}}</th>
									<th class="text-center">{{App\Language::trans('Description')}}</th>
									<th class="text-center"  colspan="1">{{App\Language::trans('Amount')}}</th>
								</tr>

								@php 

									$user_subsidies = array();
									if(isset($user_subsidiary_by_member[$member['id_house_member']]))
									{
										$user_subsidies = $user_subsidiary_by_member[$member['id_house_member']];
									}else{

										echo '<tr><td colspan="5" class="text-center">  No record found. </td></tr> <tr> <td colspan="5"></td> </tr>';
										continue;
									}
									
								@endphp

								@if(count($user_subsidies) > 0)

										@foreach($user_subsidies as $user_subsidy)

											@php 
												if( date('Y-m' , strtotime( $user_subsidy['document_date'])) < date('Y-m' , strtotime($member['house_room_member_start_date'])))
												{
													continue;
												}
											@endphp

													<tr>
										            	<td class="text-center">{{ $subsidy_index }}</td>
														
														<td class="text-center">{{ $user_subsidy['document_no'] }}</td>
														<td class="text-center">{{ $user_subsidy['document_date'] }}</td>
														<td class="text-center">{{ $user_subsidy['remark'] }}</td>
														<td class="text-right" colspan="1">{{ number_format($user_subsidy['total_amount'], 2) }}</td>
													
													</tr>

													@php 
														$grand_total += $user_subsidy['total_amount'];
														$subsidy_index ++;
											@endphp

										@endforeach
								@else
									<tr>
										<td colspan="5" class="text-center">  No record found. </td>
									</tr>

								@endif
								<tr> <td colspan="5"></td> </tr>
						
				@endforeach 
				<!-- // end of members 	 -->				


			@endforeach 
			<!-- //end of master foreach -->


					            


					</tbody>
					<tfoot>
						<hr>
						<br>
						<tr>
							<td class="text-right" colspan="4">{{App\Language::trans('Total')}}:</td>
							<td class="text-right">{{number_format($grand_total, 2)}}</td>
						</tr>
					</tfoot>
				</table>
			</div>
	</section>

@endif

</section>

{!! Form::close() !!}
@stop
@section('script')

$(".input-daterange").datepicker({
	format: "dd-mm-yyyy",
});
@stop