@php

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

$ModuleId="806867ab-96a5-11eb-948a-56b1773fd56f";
$file_type = "vnd.ms-excel";
$file_name= $ReportName."-DrillDown.xls";
header("Content-Type: application/$file_type");
header("Content-Disposition: attachment; filename=$file_name");

$qry2=base64_decode($Query);

//echo $Query;

$Count=$totalcount;
$recordsPerPage=500;
$totalRecords=$Count;
$totalPages=ceil($totalRecords/$recordsPerPage);

$hideColumns=[$primarykeyName,$CstmkeyName];
$ColumnName['TicketNumber']='Ticket Number';
$ColumnName['TicketName']='Ticket Name';
$ColumnName['CreatedDate']='Created Date';
$ColumnName['FirstResponseTime']='First Response Time';
$ColumnName['FRTAT']='FRTAT';
$ColumnName['UpdatedDate']='Updated Date';
$ColumnName['Status']='Status';
$ColumnName['name']='Assigned to';
$ColumnName['IssueClassification']='Issue Classification';
$ColumnName['supportclassify']='Support Classification';
$ColumnName['SDR']='SDR';
$ColumnName['ClosedDateTime']='ClosedDateTime';
$ColumnName['TicketClosedBy']='TicketClosedBy';
$ColumnName['TotalTimeTaken']='TotalTimeTaken';

$TicketPriority=$GetDropdownLists['62'];
$TicketStatus=$GetDropdownLists['64'];
$issueclassificationdd=$GetDropdownLists['66'];
$SupportClassificationDD=$GetDropdownLists['18406c3e-0912-11ef-b910-00155d57ea61'];
@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");
		@endphp

		@foreach($results as $result)
		@php
		$xx++;
		@endphp
		@if($printHeader==1)
		<tr>
			<th>Slno</th>
			@foreach($ColumnName as $colname=>$value)
			<th>{{$value}}</th>
			@endforeach
		</tr>
		<tr>
			<td>{{$xx}}</td>
			@foreach($ColumnName as $colname=>$value)

			@php
			$a=$result->$colname;
			if($colname=='Status')
			{
				$a=$TicketStatus[$a];
			}
			elseif($colname=='IssueClassification')
			{
				if(array_key_exists($a,$issueclassificationdd))
				{
					$a=$issueclassificationdd[$a];
				}
			}
			elseif($colname=='supportclassify')
			{
				if(array_key_exists($a,$SupportClassificationDD))
				{
					$a=$SupportClassificationDD[$a];
				}
			}
			elseif($colname=='SDR')
			{
				if($a=='1725')
				{
				$a='YES';
				}
			}
			@endphp
			<td>{{$a}}</td>
			@endforeach
		</tr>

		@php
		$printHeader=0;
		@endphp

		@else
		<tr>
			<td>{{$xx}}</td>
			@foreach($ColumnName as $colname=>$value)
			@php
			$a=$result->$colname;
			if($colname=='Status')
			{
				$a=$TicketStatus[$a];
			}
			elseif($colname=='IssueClassification')
			{
				if(array_key_exists($a,$issueclassificationdd))
				{
					$a=$issueclassificationdd[$a];
				}
			}
			elseif($colname=='supportclassify')
			{
				if(array_key_exists($a,$SupportClassificationDD))
				{
					$a=$SupportClassificationDD[$a];
				}
			}
			elseif($colname=='SDR')
			{
			if($a=='1725')
			{
				$a='YES';
			}
			}
			@endphp
			<td>
				{{$a}} 
			</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