@php
// echo "<pre>";
// print_r($GetResult);
 // echo "</pre>";
 $file_type = "vnd.ms-excel";
$file_name= "ExportData.xls";
header("Content-Type: application/$file_type");
header("Content-Disposition: attachment; filename=$file_name");
@endphp

@foreach($XAxisArray as $EachXAxis=>$XAxisValue)
<table border='1'>
	<tr>
		<th>{{$LabelNames[$EachXAxis]}}</th>
		<th>Count</th>
	</tr>
	@php
	$XAxisData=$GetResult[$EachXAxis];
	$FieldDetail=$FieldsDisplayType[$EachXAxis];
	$DisplayType=$FieldDetail['DisplayType'];
	$DisplayValue='';
	$total=0;
	@endphp
	
	@foreach($XAxisData as $Values=>$ColumnCnt)
		<tr>
			@if($DisplayType==2 || $DisplayType==5)
				@php
					$DropDownNameId=$FieldDetail['DropDownNameId'];
					if($GetDropdownLists[$DropDownNameId])
					{
						$ChildDropDown=$GetDropdownLists[$DropDownNameId];
						if(array_key_exists($Values,$ChildDropDown))
						{
							$DisplayValue=$ChildDropDown[$Values];
						}
					}
				@endphp
			@elseif($DisplayType==15)
				@php
					$DisplayFinalValue="";
					$AssignedUserNameTEmp="";
					if(array_key_exists($Values,$AssignedToList))
					{
						$AssignedUserNameTEmp=$AssignedToList[$Values];
						$DisplayValue=$AssignedUserNameTEmp['name'];
					}
				@endphp
			@elseif($DisplayType==1 || $DisplayType==11 || $DisplayType==17 || $DisplayType==13) 
				@php
					$DisplayValue=$Values;
				@endphp
			@else
				@php
					$DisplayValue=$Values;
				@endphp
			@endif
			<td>
				@if($DisplayValue=='')
					(EMPTY)
				@else
					{{$DisplayValue}}
				@endif
			</td>
			<td>
				@php
				$total=$total+$ColumnCnt;
				@endphp
				
				{{$ColumnCnt}}
			</td>
		</tr>
	@endforeach
	<tr>
		<td>Total</td>
		<td>
			{{$total}}
		</td>
	</tr>
</table>
@endforeach