@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";

if($_SERVER['REMOTE_ADDR']=="122.166.45.159")
{
	//echo "<pre>";
		//	print_r($results);
	//echo "</pre>";
	//die();
}

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 Created Date</th>
				<th nowrap>Call Date</th>
				<th nowrap>Lead Intrested Marked 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>Student Registration Date</th>
				<th nowrap>Appointment_Date</th>
				<th nowrap>Appointment Created Date</th>
				<th nowrap>Lead_Source</th>
				<th nowrap>Lead_Source_Detail</th>
				<th nowrap>Agent Name</th>
				<th nowrap>Lead Updated By</th>
				<th nowrap>Lead Disposition</th>
				<th nowrap>Lead Sub Disposition</th>
				<th nowrap>Vendor</th>
				<th nowrap>Lead Call Date</th>

				@if($_SERVER['REMOTE_ADDR']=="122.166.45.159")
				<!-- <th nowrap>StuRegId</th> -->
				@endif

			</tr>
		</thead>


		<tbody>
			@php
			$x=($PageNum-1)*10;
			@endphp

			@foreach($results as $result)

			@php
			$x++;	

			$FixedDateTime="2023-05-05 14:50:00";

			

			@endphp
			<tr>
				<td>{{$x}}</td>
				<td>
					@php
					try
					{
						echo $DropDowns[$result->BranchOffice];
					}
					catch(\Exception $e)
					{

					}
					@endphp
				</td>
				<td>{{$result->City}}</td>
				<td>{{$result->FirstName}}</td>
				<td>{{$result->LastName}}</td>
				<td>{{$result->PhoneMobile}}</td>
				<td>{{$result->EmailId}}</td>
				<td>

					@php
					try
					{
						echo $DropDowns[$result->StudyDestination];
					}
					catch(\Exception $e)
					{

					}
					@endphp

				</td>

				<td>

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

				</td>

				
				<td>

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

				</td>

				<td>
					{{$result->Intresetmodifiedtime}}
				</td>

				<td>
					@php
					try
					{
						echo $DropDowns[$result->StudyLevel];
					}
					catch(\Exception $e)
					{

					}
					@endphp
				</td>

				<td>
					@php
					try
					{
						echo $DropDowns[$result->LastLevelEducation];
					}
					catch(\Exception $e)
					{

					}
					@endphp
				</td>

				<td>
					@php
					try
					{
						echo $DropDowns[$result->Intake];
					}
					catch(\Exception $e)
					{

					}
					@endphp
				</td>

				<td>
					@php
					try
					{
						echo $DropDowns[$result->StudyYear];
					}
					catch(\Exception $e)
					{

					}
					@endphp
				</td>

				<td>

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


				<td>

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

				<td>
					@php
					try
					{	

						if(date('Y-m-d',strtotime($result->AppointmentCreatedDate)) == '2023-05-15')
						{
							if($result->CallRecordId==$result->AppointmentCallRecordId)
							{
								echo date('d-m-Y h:i:s a',strtotime($result->AppointmentCreatedDate));
							}
						}
						else
						{
							if($result->AppointmentCreatedDate)
							{
								if($result->CallTo==$result->AppointmentCreatedBy)
								{
									echo date('d-m-Y h:i:s a',strtotime($result->AppointmentCreatedDate));
								}

							}
						}

						
					}
					catch(\Exception $e){$AppointmentCreatedDate="";}
					@endphp

				</td>

				<td>
					@php
					try
					{
						echo $DropDowns[$result->LeadSource];
					}
					catch(\Exception $e)
					{

					}
					@endphp

				</td>
				<td>{{$result->LeadSourceDetail}}</td>


				<td>
					{{$result->AgentName}}
				</td>

				<td>
					@php
					try
					{
						echo $Agents[$result->LeadUpdatedBy];
					}
					catch(\Exception $e)
					{

					}
					@endphp

				</td>
				


				<td>
					@php
					try
					{
						echo $DropDowns[$result->LeadDisposition];
					}
					catch(\Exception $e)
					{

					}
					@endphp
				</td>
				<td>
					@php
					try
					{
						echo $DropDowns[$result->LeadSubDisposition];
					}
					catch(\Exception $e)
					{

					}
					@endphp
				</td>
				<td>
					@php
					try
					{
						echo $DropDowns[$result->Vendors];
					}
					catch(\Exception $e)
					{

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


				@if($_SERVER['REMOTE_ADDR']=="122.166.45.159")
				<!-- <td> {{$result->LeadId}} </td> -->
				@endif


			</tr>
			@endforeach

			@if($LeadRecordsCount==0)
			<tr>
				<td colspan="100">NO Records!</td>
			</tr>
			
			@endif
		</tbody>


	</table>
	@if($x!=0 && !$ExportToExcel)
	<div class="form-group row">

		@php
		$totalRecords=$LeadRecordsCount;
		@endphp


		<div class="col-md-12">
			<!-- <a href="javascript:void(0)" title="Click here to Export Excel" onclick="ExportExcel()" class="text-primary">Export Excel={{$LeadRecordsCount}}</a> -->

			<div>Total Records {{$LeadRecordsCount}}</div>

			<div id="ExcelBtnDiv">
				<button class="btn btn-primary" onclick="ExportExcelV2()">Export Excel</button>
			</div>


			@if($totalRecords > 10)
			<div class="paginating-container pagination-solid">
				<ul class="pagination">
					@php
					$limit=10;
					$total_pages = ceil($totalRecords/$limit);
					$start_loop = $PageNum;
					$difference = $total_pages - $PageNum;

					$active_class='';

					@endphp

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

					@if($PageNum > 1)
					@php
					$first=$PageNum-1;
					@endphp
					<li class="prev"><a href="javascript:void(0)" onclick="GetReport('{{$first}}')">Prev</a></li>
					<li class="First"><a href="javascript:void(0)" onclick="GetReport('1')"><<</a></li>
					@endif

					@for($i=$start_loop; $i<=$end_loop; $i++)
					@if($i>0)
					@php
					if($PageNum==$i)
					$active_class='active';
					else
					$active_class='';
					@endphp
					<li class='{{$active_class}}'><a href="javascript:void(0)" onclick="GetReport('{{$i}}')">{{$i}}</a></li>
					@endif
					@endfor
					@if($PageNum <= $end_loop)
					@php
					$last=$PageNum+1;
					@endphp
					<li class='Last'><a href="javascript:void(0)" onclick="GetReport('{{$total_pages}}')">>></a></li>
					<li class="next"><a href="javascript:void(0)" onclick="GetReport('{{$last}}')">Next</a></li>
					@endif
					@endif
				</ul>
			</div>
			@endif
			
		</div>
	</div>
	@endif
	@if(!$ExportToExcel)
</div>
@endif