@php
echo "<pre>";
	// print_r($XAxisArray);
	// print_r($YAxisArray);
//	print_r($GetResult);
	//print_r($FieldsDisplayType);
	//print_r($AssignedToList);
echo "</pre>";

$XAxisData=$GetResult['XAxisData'];
$YAxisData=$GetResult['YAxisData'];
$REsultData=$GetResult['REsultData'];
$XDemographyConfigId=$XAxisArray[0]['DemographyConfigId'];
$XAxisColumnName=$XAxisArray[0]['ColumnName'];
$XAxisAliasname=$XAxisArray[0]['Aliasname'];
$YDemographyConfigId=$YAxisArray[0]['DemographyConfigId'];
$YAxisColumnName=$YAxisArray[0]['ColumnName'];
$YAxisAliasname=$YAxisArray[0]['Aliasname'];

$file_type = "vnd.ms-excel";
$file_name= "ExportData.xls";
header("Content-Type: application/$file_type");
header("Content-Disposition: attachment; filename=$file_name");
@endphp
<table border='1'>
<tr>
	<td>{{$XAxisAliasname}} / {{$YAxisAliasname}}</td>
	@foreach($YAxisData as $EachYAxisData)
		@php
			$YColumnName=$EachYAxisData;
			$YDisplayName=$EachYAxisData;
			$YdisplayType=$FieldsDisplayType[$YDemographyConfigId]['DisplayType'];
			if(($YdisplayType==5 || $YdisplayType==2 || $YdisplayType==3 || $YdisplayType==6 ) && $YColumnName!='')
			{
				$YDropDownNameId=$FieldsDisplayType[$YDemographyConfigId]['DropDownNameId'];
				if($GetDropdownLists[$YDropDownNameId])
				{
					$ChildDropDown=$GetDropdownLists[$YDropDownNameId];
					if(array_key_exists($YColumnName,$ChildDropDown))
					{
						$YDisplayName=$ChildDropDown[$YColumnName];
					}
				}
			}
			if($YdisplayType==15 || $YdisplayType==31 || $YdisplayType==32 || $YdisplayType==33)
			{
				$AssignedUserNameTEmp="";
				if(array_key_exists($YColumnName,$AssignedToList))
				{
					$AssignedUserNameTEmp=$AssignedToList[$YColumnName];
					$YDisplayName=$AssignedUserNameTEmp['name'];
				}
			}
		@endphp
		<td>
			@if($YDisplayName=='')
				(EMPTY)
			@else
				{{$YDisplayName}}
			@endif
		</td>
	@endforeach
</tr>
	@foreach($XAxisData as $EachXAxisData)
	<tr>
		@php
			$XColumnName=$EachXAxisData;
			$XDisplayName=$EachXAxisData;
			$XdisplayType=$FieldsDisplayType[$XDemographyConfigId]['DisplayType'];
			if(($XdisplayType==5 || $XdisplayType==2 || $XdisplayType==3 || $XdisplayType==6 ) && $XColumnName!='')
			{
				$XDropDownNameId=$FieldsDisplayType[$XDemographyConfigId]['DropDownNameId'];
				if($GetDropdownLists[$XDropDownNameId])
				{
					$ChildDropDown=$GetDropdownLists[$XDropDownNameId];
					if(array_key_exists($XColumnName,$ChildDropDown))
					{
						$XDisplayName=$ChildDropDown[$XColumnName];
					}
				}
			}
			if($XdisplayType==15 || $XdisplayType==31 || $XdisplayType==32 || $XdisplayType==33)
			{
				$AssignedUserNameTEmp="";
				if(array_key_exists($XColumnName,$AssignedToList))
				{
					$AssignedUserNameTEmp=$AssignedToList[$XColumnName];
					$XDisplayName=$AssignedUserNameTEmp['name'];
				}
			}
		@endphp
		<td>
			@if($XDisplayName=='')
				(EMPTY)
			@else
				{{$XDisplayName}}
			@endif
		</td>
		@foreach($YAxisData as $EachYAxisData)
		<td>
			@php
				$YColumnName=$EachYAxisData;
				$XAxisREsult=$REsultData[$XColumnName][$YColumnName];
			@endphp
			<a onclick="AdhocDrillDown('{{$XDemographyConfigId}}','{{$XColumnName}}','{{$YDemographyConfigId}}','{{$YColumnName}}','{{$AdHocReportId}}','{{$ReportType}}','{{$PrimaryModuleId}}',1,'{{$mode}}')" data-toggle="modal" data-target="#XAxisModal">
			{{$XAxisREsult}}
			</a>
		</td>
		@endforeach
	</tr>
	@endforeach
</table>