@php
$total_records=$TotalRecordsCnt;
$page_num=$Page_num;
$start_from = ($Page_num-1)*$limit;
$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'];
//$a=1;
$a=$start_from+1;
//echo $start_from;
$LeadModuleId="32f08263-96a5-11eb-948a-56b1773fd56f";
$StudentRegistrationModuleId="f8d9d46f-30c8-41dc-a816-727fd9e058d0";
$GetResultQuery=base64_encode($GetResultQuery);
@endphp
<br>
<div class="row">
	<div class="col-lg-12 col-md-12 layout-spacing">
		<div class="widget-content widget-content-area">
			<div class="row">
				<div class="col-sm-6 col-md-6 text-right">
					<input type="hidden" id="TotalRecords" value="11">
					<div class="text-primary" role="status" aria-live="polite" title="11"><span class=" total_records">Total  records</span></div>
				</div>
				<div class="col-sm-6 col-md-6" style="text-align: right">

					<div id="ExportExcelDiv">
						<button class="btn btn-primary" type="button" onclick="ExportExcel('StudentRegistrationDetailsReport','','')">Export Excel</button>
					</div>

					
				</div>
			</div>
			<br>
			<div class="table-responsive">
				<table class="table table-bordered mb-4">
					<!--<tdead>-->
						<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='';
								$EmailValues='';
								$MeetingDateandTimeNew='';
								$AppointmentDet=array();
								if(array_key_exists($LeadId,$AppointmentArray))
								{
									$AppointmentDet=$AppointmentArray[$LeadId];
									try
									{
										$AppointmentCreatedDatenew=$AppointmentDet->CreatedDate;
										$MeetingDateandTimeNew=$AppointmentDet->MeetingDateandTime;
									}
									catch(\Exception $e)
									{
										
									}
								}
								if(array_key_exists($EMailId,$EmailsArray))
								{
									$EmailValues=$EmailsArray[$EMailId][0];
								}
								@endphp
								<tr>
									<td>{{$a}}</td>
									<td title="Click here to view Student Registration in Detail"><a href="/ShowDetailView//"><font color="blue">{{$EachRecord->FirstName}}</font></a></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 title="Click here to view Lead in Detail"><a href="/ShowDetailView//"><font color="blue">{{$LeadFullName}}</font></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>
						</div>
						<!--Pagination-->
						<br>
						
						<div class="paginating-container pagination-solid">
							<ul class="pagination">
								@php
								$total_pages = ceil($total_records/$limit);
								$start_loop = $page_num;
								$difference = $total_pages - $page_num;

								$active_class='';

								@endphp

								@if($total_records > $limit)
								@if($difference <= 5)
								@php
								$start_loop = $total_pages - 5; 
								@endphp
								@endif
								@php
								$end_loop = $start_loop + 4;
								@endphp

								@if($page_num > 1)
								@php
								$first=$page_num-1;
								@endphp
								<li class="prev" onclick="DisplayStudentRegistration('{{$first}}')"><a>Prev</a></li>
								<li class="First" onclick="DisplayStudentRegistration('{{$first}}')"><a><<</a></li>
								@endif

								@for($i=$start_loop; $i<=$end_loop; $i++)
								@if($i>0)
								@php
								if($page_num==$i)
								$active_class='active';
								else
								$active_class='';
								@endphp
								<li class='{{$active_class}}'  onclick="DisplayStudentRegistration('{{$i}}')"> <a>{{$i}}</a></li>
								@endif
								@endfor
								@if($page_num <= $end_loop)
								@php
								$last=$page_num+1;
								@endphp
								<li class='Last'  onclick="DisplayStudentRegistration('{{$total_pages}}')"> <a>>></a></li>
								<li class="next"  onclick="DisplayStudentRegistration('{{$last}}')"><a>Next</a></li>
								@endif
								@endif
							</ul>
							
						</div>
						<!--End of Pagination-->

					</div>
				</div>
			</div>