@php

use App\Http\Controllers\TestController;
use App\Models\Demography;

$file_type = "vnd.ms-excel";
$file_name= "PriorityWiseSLAReport.xls";

$qry2=$MainSearchQry;
$Count=$TotalRecords;
$recordsPerPage=500;
$totalRecords=$Count;
$totalPages=ceil($totalRecords/$recordsPerPage);

$hideColumns=[$primarykeyName,$CstmkeyName];

$recordIds=json_decode($recordIds,true);

$recordIdCondition="";

//echo $qry2;

if(count($recordIds))
{
	$recordIds="'".implode("','",$recordIds)."'";

	$recordIdCondition=" WHERE $primarykeyName in ($recordIds) and";

	$qry2= str_replace_first('WHERE',$recordIdCondition, $qry2); 

}	

//echo "<br> -----------------------------<br>";


$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>

	@php

	$printHeader=1;
	$xx=0;

	//$totalPages=1;

	for($x=0;$x<$totalPages;$x++)
	{
		$startFrom=$x*$recordsPerPage;
		$results=DB::select($qry2." limit $startFrom,$recordsPerPage");
		//$results=DB::select($qry2." limit 10");
		//die();
		@endphp

		@foreach($results as $result)
		@php
		$xx++;
		@endphp
		@if($printHeader==1)
		<tr>
			<th>Slno</th>
			@foreach($result as $colname=>$value)
			@php
			if(in_array($colname,$hideColumns))
			{
				continue;
			}
			$colname=Demography::GetLabelValue($ModuleId,$colname);
			@endphp
			<th>{{$colname}}</th>

			@endforeach
		</tr>
		<tr>
			<td>{{$xx}}</td>
			@foreach($result as $colname=>$value)

			@php
			if(in_array($colname,$hideColumns))
			{
				continue;
			}
			@endphp

			@php
			$ConfigId=$LabelDecodedvalue->$colname;
			$ModuleId=$AliasDetail[$ConfigId]['ModuleId'];
			$ColumnName=$AliasDetail[$ConfigId]['ColumnName'];
			$value=TestController::GetDisplayValue($ModuleId,$ColumnName,$value);
			@endphp
			<td>{{$value}}</td>
			@endforeach
		</tr>

		@php
		$printHeader=0;
		@endphp

		@else
		<tr>
			<td>{{$xx}}</td>
			@foreach($result as $colname=>$value)

			@php
			if(in_array($colname,$hideColumns))
			{
				continue;
			}
			@endphp

			@php
			$ConfigId=$LabelDecodedvalue->$colname;
			$ModuleId=$AliasDetail[$ConfigId]['ModuleId'];
			$ColumnName=$AliasDetail[$ConfigId]['ColumnName'];
			$value=TestController::GetDisplayValue($ModuleId,$ColumnName,$value);
			@endphp

			<td>{{$value}}</td>
			@endforeach
		</tr>
		@endif	
		@endforeach
		@php

	}
	@endphp
</table>

@php
@endphp

@php

function str_replace_first($search, $replace, $subject)
{
	$search = '/'.preg_quote($search, '/').'/';
	return preg_replace($search, $replace, $subject, 1);
}


@endphp