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



	@php
		$grand_total = 0;
		$listing_index = 1;
		
		$member_list = App\Customer::get_leaf_member_status_list();
		$member_detail = array();
		$cpus_listing_2 = array();
		$temp_cpus_listing =  App\PowerMeterModel\CustomerPowerUsageSummary::all();
		$leaf_user_ids = array();
		foreach($temp_cpus_listing as $cpus)
		{//dd($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'];
		}
	
		$room_name_list = array();
		foreach($member_list['non_exist_member_listing'] as $member)
		{
			
			$room_name_list[$member['id_house_room']] = App\LeafAPI::get_room_name_by_leaf_room_id($member['id_house_room']);
			$member['room_name'] = App\LeafAPI::get_room_name_by_leaf_room_id($member['id_house_room']);
			$member_detail[$member['id_house_member']] = $member;
		
		}

		
		$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
	<!-- MoiCW - Added Download button-->
	
	<a target="_blank" download href="{{action($page_variables['download_link'])}}" class="btn btn-primary">
				<i class="fa fa-file"></i> {{App\Language::trans('Download')}}
			</a>
	<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="6"> {{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('Last Update At')}}</th> -->
									<th class="text-center" colspan="2">

											{{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_2[$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>

									@php 
										 
									 // if(isset($cpus_listing_2[$member['id_house_room']][$member['id_house_member']]))
								       //   {
								         //    echo "<td  class='text-center'>".$cpus_listing_2[$member['id_house_room']][$member['id_house_member']]['updated_at']."</td>";
											// continue;
								        //  }else{
								         // 	  echo "<td  class='text-center'> - </td>";
								         // } 
								      
								    @endphp
									<td class="text-center" colspan="2">
										@if(isset($cpus_listing_2[$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>
								
							
								<tr>
									<th class="text-center">#</th>
									<th class="text-center">{{App\Language::trans('Total Paid (RM)')}}</th>
									<th class="text-center">{{App\Language::trans('Monthly Subsidy (RM)')}}</th>
									<th class="text-center">{{App\Language::trans('Usage (RM)')}}</th>
									<th class="text-center">{{App\Language::trans('Current Month Credit (RM)')}}</th>
									<th class="text-center">{{App\Language::trans('Balance (RM)')}}</th>
								</tr>

								@php 
										 $l_index =1;

										  if(!isset($cpus_listing_2[$member['id_house_room']][$member['id_house_member']]))
								          {
								             echo '<tr><td colspan="6" class="text-center">  Non app user. </td></tr> <tr> <td colspan="6"></td> </tr>';
											 continue;
								          } 


										  
										 $account_data = $cpus_listing_2[$member['id_house_room']][$member['id_house_member']][0];
//dd($account_data);
										 if($account_data['transaction_summary'] == null)
								          {
								             echo '<tr><td colspan="6" class="text-center">  No record found. </td></tr> <tr> <td colspan="6"></td> </tr>';
											 continue;
								          }

								          $data = json_decode($account_data['transaction_summary'], true);
								         
									//dd($data);

										
									
									
								@endphp

								@if(count($data) > 0)

										 @foreach ($data as $month_key => $m_data) 
										 	@php 
														//dd($data);
											@endphp

													<tr>
										            	<td class="text-center">{{ $month_key }}</td>
														
														<td class="text-right">{{ isset($m_data['total_paid_amount']) ? number_format($m_data['total_paid_amount'], 2) :  0  }}</td>
<td class="text-right">{{ isset($m_data['total_subsidy_amount']) ? number_format($m_data['total_subsidy_amount'], 2) :  0  }}</td>
<td class="text-right">{{ isset($m_data['total_payable_amount']) ? number_format($m_data['total_payable_amount'], 2) :  0  }}</td>
<td class="text-right" >{{ isset($m_data['current_credit_amount']) ? number_format($m_data['current_credit_amount'], 2) :  0  }}</td>
<td class="text-right" >{{ isset($m_data['user_balance']) ? number_format($m_data['user_balance'], 2) :  0  }}</td>
													</tr>

											@php 
														$grand_total += $m_data['total_paid_amount'];
														$l_index ++;
											@endphp

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

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


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


					            


					</tbody>
		
				</table>
			</div>
	</section>


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

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