@php

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

$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");
$demography = new Demography();
 $LeadSourceDetDropDown=$GetDropdownLists['68'];
 $BranchOfficeDropDown=$GetDropdownLists['69'];
 $StudyDestinationDropDown=$GetDropdownLists['71'];
 $StudyLevelDropdown=$GetDropdownLists['76'];
 $LastLevelEducationDropdown=$GetDropdownLists['79'];
 $IntakeDropdown=$GetDropdownLists['74'];
 $StudyYearDropdown=$GetDropdownLists['72'];
 
 $VendorDropDown=$LeadGetDropdownLists[82];
 $LeadDispositionDropDown=$LeadGetDropdownLists[65];
 $LeadSubDispositionDropDown=$LeadGetDropdownLists[66];
 $LeadSourceDropDown=$LeadGetDropdownLists['ddfb84a7-5564-4335-9a18-f1a782c018cf'];
$qry2=base64_decode($Query);
$Count=$totalcount;
$recordsPerPage=500;
$totalRecords=$Count;
$totalPages=ceil($totalRecords/$recordsPerPage);
$GetREsult=DB::select($qry2);

$AppointmentArray=array();
foreach($GetREsult as $EachData)
{
	$LeadId=$EachData->LeadId;
	$EMailId=$EachData->EMailId;
	$GetAppointMentDetail=Unixperts::GetAppointMentDetail($LeadId);
	$AppointmentArray[$LeadId]=$GetAppointMentDetail;
	if($EMailId)
	{
		$EmailsArray[$EMailId]=$demography->GetEmailValues($EMailId);
	}
}

$a=1;
@endphp
<table border=1>
	<tr >
		<td rowspan="2"><b>Sl.No</b></td>
		<td colspan="13" align="center"><b>Student Registration</b></td>
		<td colspan="7"  align="center"><b>Leads</b></td>
		<td colspan="2"  align="center"><b>Appointments</b></td>
	</tr>
	<tr>
		<td class="text-center"><b>First Name</b></td>
		<td class="text-center"><b>Last Name</b></td>
		<td class="text-center"><b>Phone Mobile</b></td>
		<td class="text-center"><b>Email Id</b></td>
		<td class="text-center"><b>Branch Office</b></td>
		<td class="text-center"><b>Lead Source Det</b></td>
		<td class="text-center"><b>Study Destination</b></td>
		<td class="text-center"><b>Created By</b></td>
		<td class="text-center"><b>Student Registration Created Date</b></td>
		<td class="text-center"><b>Study Level</b></td>
		<td class="text-center"><b>Last Level of Education</b></td>
		<td class="text-center"><b>Intake</b></td>
		<td class="text-center"><b>Study Year</b></td>
		<td class="text-center"><b>Lead Full Name</b></td>
		<!--<td class="text-center"><b>Lead Last Name</td>-->
		<td class="text-center"><b>Lead Mobile Number</b></td>
		<td class="text-center"><b>Vendors</b></td>
		<td class="text-center"><b> Lead Disposition</b></td>
		<td class="text-center"><b> Lead Sub Disposition </b></td>
		<td class="text-center"><b> Lead Source</b></td>
		<td class="text-center"><b> Lead Created Date</b></td>
		<td class="text-center"><b> Appointment Created Date</b></td>
		<td class="text-center"><b> Meeting Date and Time</b></td>
	</tr>
	<!--</tdead>-->
	<tbody>
	@foreach($GetREsult as $EachRecord)
	@php
	$EMailId=$EachRecord->EMailId;
	$BranchOffice=$EachRecord->BranchOffice;
	$LeadSourceDet=$EachRecord->LeadSourceDet;
	$StudyDestination=$EachRecord->StudyDestination;
	$CreatedDate=$EachRecord->CreatedDate;
	$CreatedBy=$EachRecord->CreatedBy;
	$LeadId=$EachRecord->LeadId;
	$LeadFirstName=$EachRecord->LeadFirstName;
	$LeadLastName=$EachRecord->LeadLastName;
	$LeadFullName=$LeadFirstName." ".$LeadLastName;
	$LeadPhoneMobile=$EachRecord->LeadPhoneMobile;
	$Vendors=$EachRecord->Vendors;
	$LeadDisposition=$EachRecord->LeadDisposition;
	$LeadSubDisposition=$EachRecord->LeadSubDisposition;
	$LeadSource=$EachRecord->LeadSource;
	$LeadCreatedDate=$EachRecord->LeadCreatedDate;
	$StudyLevel=$EachRecord->StudyLevel;
	$LastLevelEducation=$EachRecord->LastLevelEducation;
	$Intake=$EachRecord->Intake;
	$StudyYear=$EachRecord->StudyYear;
	//$AppointmentCreatedDate=$EachRecord->AppointmentCreatedDate;
	//$MeetingDateandTime=$EachRecord->MeetingDateandTime;
	$AppointmentCreatedDatenew='';
	$MeetingDateandTimeNew='';
	$EmailValues='';
	if(array_key_exists($LeadId,$AppointmentArray))
	{
		try
		{
			$AppointmentCreatedDatenew=$AppointmentArray[$LeadId]->CreatedDate;
			$MeetingDateandTimeNew=$AppointmentArray[$LeadId]->MeetingDateandTime;
		}
		catch(\Exception $e)
		{
			$AppointmentCreatedDatenew='';
			$MeetingDateandTimeNew='';
		}
	}
	if(array_key_exists($EMailId,$EmailsArray))
	{
		$EmailValues=$EmailsArray[$EMailId][0];
	}
	@endphp
	<tr>
		<td>{{$a}}</td>
		<td>{{$EachRecord->FirstName}}</td>
		<td>{{$EachRecord->LastName}}</td>
		<td>{{$EachRecord->MobileNumber}}</td>
		<td>{{$EmailValues}}</td>
		<td>
			@if(array_key_exists($BranchOffice,$BranchOfficeDropDown))
				{{$BranchOfficeDropDown[$BranchOffice]}}
			@else
				{{$BranchOffice}}
			@endif
		</td>
		<td>
			@if(array_key_exists($LeadSourceDet,$LeadSourceDetDropDown))
					{{$LeadSourceDetDropDown[$LeadSourceDet]}}
			@else
				{{$LeadSourceDet}}
			@endif
			{{$LeadSourceDet}}
		</td>
		<td>
			@if(array_key_exists($StudyDestination,$StudyDestinationDropDown))
					{{$StudyDestinationDropDown[$StudyDestination]}}
			@else
				{{$StudyDestination}}
			@endif
		</td>
		<td>
			@if(array_key_exists($CreatedBy,$getActiveUsersList))
				{{$getActiveUsersList[$CreatedBy]['name']}}
			@else
				{{$CreatedBy}}
			@endif
		</td>
		<td>{{$CreatedDate}}</td>
		<td>
			@if(array_key_exists($StudyLevel,$StudyLevelDropdown))
				{{$StudyLevelDropdown[$StudyLevel]}}
			@else
				{{$StudyLevel}}
			@endif
		</td>
		<td>
			@if(array_key_exists($LastLevelEducation,$LastLevelEducationDropdown))
				{{$LastLevelEducationDropdown[$LastLevelEducation]}}
			@else
				{{$LastLevelEducation}}
			@endif
		</td>
		<td>
			@if(array_key_exists($Intake,$IntakeDropdown))
				{{$IntakeDropdown[$Intake]}}
			@else
				{{$Intake}}
			@endif
		</td>
		<td>
			@if(array_key_exists($StudyYear,$StudyYearDropdown))
				{{$StudyYearDropdown[$StudyYear]}}
			@else
				{{$StudyYear}}
			@endif
		</td>
		<td>{{$LeadFullName}}</td>
		<!--<td>{{$LeadLastName}}</td>-->
		<td>{{$LeadPhoneMobile}}</td>
		<td>
			@if(array_key_exists($Vendors,$VendorDropDown))
				{{$VendorDropDown[$Vendors]}}
			@else
				{{$Vendors}}
			@endif
		</td>
		<td>
			@if(array_key_exists($LeadDisposition,$LeadDispositionDropDown))
				{{$LeadDispositionDropDown[$LeadDisposition]}}
			@else
				{{$LeadDisposition}}
			@endif
		</td>
		<td>
			@if(array_key_exists($LeadSubDisposition,$LeadSubDispositionDropDown))
				{{$LeadSubDispositionDropDown[$LeadSubDisposition]}}
			@else
				{{$LeadSubDisposition}}
			@endif
		</td>
		<td>
			@if(array_key_exists($LeadSource,$LeadSourceDropDown))
				{{$LeadSourceDropDown[$LeadSource]}}
			@else
				{{$LeadSource}}
			@endif
		</td>
		<td>{{$LeadCreatedDate}}</td>
		<td>{{$AppointmentCreatedDatenew}}</td>
		<td>{{$MeetingDateandTimeNew}}</td>
	</tr>
	@php
	$a++;
	@endphp
	@endforeach
	</tbody>
</table>