@php
use App\Models\Demography;
use App\Models\ProgressiveDialler;

$studentRegistrationModuleId="f8d9d46f-30c8-41dc-a816-727fd9e058d0";
$AppointmentsModuleId="e62506fb-5247-471b-b575-518a3099b64b";
$CallRecordsModuleId="c7d8d1a7-73c1-8527-2f2d-603ccbe1e9ae";

//echo "<pre>";
	//print_r($results);
//echo "</pre>";

if($ExportToExcel)
{
	$file_type = "vnd.ms-excel";
	$file_name= "LeadReport.xls";
	header("Content-Type: application/$file_type");
	header("Content-Disposition: attachment; filename=$file_name");

	$tableClass="";
	$border="border=1";
}
else
{
	$tableClass="table table-hover table-striped table-bordered table-no-space";
	$border="border=1";
}


@endphp

@if(!$ExportToExcel)
<div class="table-responsive">
	@endif
	<table class="{{$tableClass}}" {{$border}}>
		<thead>
			<tr>
				<th nowrap>Slno</th>
				<th nowrap>Branch</th>
				<th nowrap>City</th>
				<th nowrap>First_Name</th>
				<th nowrap>Last_Name</th>
				<th nowrap>Primary_Mobile</th>
				<th nowrap>Email_ID</th>
				<th nowrap>Study_Destination</th>
				<th nowrap>Lead Call Date</th>
				<th nowrap>Study_Level</th>
				<th nowrap>Last_Level_of_Educat</th>
				<th nowrap>Intake</th>
				<th nowrap>Study_Year</th>
				<th nowrap>Appointment_Date</th>
				<th nowrap>Lead_Source</th>
				<th nowrap>Lead_Source_Detail</th>
				<th nowrap>Agent Name</th>
				<th nowrap>Lead Disposition</th>
				<th nowrap>Lead Sub Disposition</th>
			</tr>
		</thead>


		<tbody>
			@php
			$x=0;
			@endphp
			@foreach($results as $result)

			@php
			$x++;
			$StudyModuleValues=ProgressiveDialler::GetChildRecord($studentRegistrationModuleId,$ModuleId,$result->LeadId);	

			$AppointmentValues=ProgressiveDialler::GetChildRecord($AppointmentsModuleId,$ModuleId,$result->LeadId);	

			$CallRecordsValues=ProgressiveDialler::GetChildRecord($CallRecordsModuleId,$ModuleId,$result->LeadId);	


			@endphp
			<tr>
				<td>{{$x}}</td>
				<td>{{Demography::GetDisplayValue($ModuleId,"BranchOffice",$result->BranchOffice)}}</td>
				<td>{{Demography::GetDisplayValue($ModuleId,"PrimaryAddressCity",$result->PrimaryAddressCity)}}</td>
				<td>{{Demography::GetDisplayValue($ModuleId,"FirstName",$result->FirstName)}}</td>
				<td>{{Demography::GetDisplayValue($ModuleId,"LastName",$result->LastName)}}</td>
				<td>{{Demography::GetDisplayValue($ModuleId,"PhoneMobile",$result->PhoneMobile)}}</td>
				<td>{{Demography::GetDisplayValue($ModuleId,"EmailId",$result->EmailId)}}</td>
				<td>{{Demography::GetDisplayValue($ModuleId,"StudyDestination",$result->StudyDestination)}}</td>
				<td>

					@php
					try
					{
						echo $StartDate=date('Y-m-d',strtotime($result->StartDate));
					}
					catch(\Exception $e){$StartDate="";}
					@endphp

				</td>

				<td>
					@php
					try
					{
						$StudyLevel=$StudyModuleValues->StudyLevel;
					}
					catch(\Exception $e){$StudyLevel="";}
					@endphp
					{{Demography::GetDisplayValue($studentRegistrationModuleId,"StudyLevel",$StudyLevel)}}
				</td>

				<td>
					@php
					try
					{
						$LastLevelEducation=$StudyModuleValues->LastLevelEducation;
					}
					catch(\Exception $e){$LastLevelEducation="";}
					@endphp
					{{Demography::GetDisplayValue($studentRegistrationModuleId,"LastLevelEducation",$LastLevelEducation)}}
				</td>

				<td>
					@php
					try
					{
						$Intake=$StudyModuleValues->Intake;
					}
					catch(\Exception $e){$Intake="";}
					@endphp
					{{Demography::GetDisplayValue($studentRegistrationModuleId,"Intake",$Intake)}}
				</td>

				<td>
					@php
					try
					{
						$StudyYear=$StudyModuleValues->StudyYear;
					}
					catch(\Exception $e){$StudyYear="";}
					@endphp
					{{Demography::GetDisplayValue($studentRegistrationModuleId,"StudyYear",$StudyYear)}}
				</td>


				<td>

					@php
					try
					{
						echo date('d-m-Y h:i:s a',strtotime($AppointmentValues->MeetingDateandTime));
					}
					catch(\Exception $e){$MeetingDateandTime="";}
					@endphp
				</td>

				<td>{{Demography::GetDisplayValue($ModuleId,"LeadSource",$result->LeadSource)}}</td>
				<td>{{Demography::GetDisplayValue($ModuleId,"LeadSourceDetail",$result->LeadSourceDetail)}}</td>


				<td>
					@php
					try
					{
						$CreatedBy=$StudyModuleValues->CreatedBy;
					}
					catch(\Exception $e){$CreatedBy="";}
					@endphp
					{{Demography::GetDisplayValue($studentRegistrationModuleId,"CreatedBy",$CreatedBy)}}
				</td>


				<td>{{Demography::GetDisplayValue($ModuleId,"LeadDisposition",$result->LeadDisposition)}}</td>
				<td>{{Demography::GetDisplayValue($ModuleId,"LeadSubDisposition",$result->LeadSubDisposition)}}</td>


			</tr>
			@endforeach

		</tbody>


	</table>
	@if($x!=0 && !$ExportToExcel)
	<div class="form-group row">
		<div class="col-md-12">
			<button class="btn btn-primary" onclick="ExportExcel()">Export Excel</button>
		</div>
	</div>
	@endif
	@if(!$ExportToExcel)
</div>
@endif