<?php
session_start();
error_reporting(0);
$user_name=$_SESSION['user_name'];
/*if(empty($user_name))
 {
 header("location:index.php");
 }*/
$idd=$_GET['id'];
$id=base64_decode($idd);
include_once("database_connection.php"); 
$sqlu="select *  from sbialloc_tbl where id='$id' " ;
$resultu=mysqli_query($conn,$sqlu);
$data=mysqli_fetch_array($resultu);
$idu=$datau['id'];
$promo_code=$data['promo_code'];
$sqlu="select user_name from user_tblsbifi where id='$promo_code' " ;
$resultu=mysqli_query($conn,$sqlu);
$datau=mysqli_fetch_array($resultu);
$loginid=$datau['user_name'];
	
?>
<html>
<head>
<link rel="stylesheet" href="https://stackpath.bootstrapcdn.com/bootstrap/4.3.1/css/bootstrap.min.css">
<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/font-awesome/4.7.0/css/font-awesome.min.css">
<script src="https://ajax.googleapis.com/ajax/libs/jquery/3.3.1/jquery.min.js"></script>
<script src="https://cdnjs.cloudflare.com/ajax/libs/popper.js/1.14.7/umd/popper.min.js"></script>
<script src="https://stackpath.bootstrapcdn.com/bootstrap/4.3.1/js/bootstrap.min.js"></script>
<style type="text/css">
    .bs-example{
    	margin: 20px;
    }
</style>
<style type="text/css">
.thumbnail{
position: relative;
z-index: 0;
}
.thumbnail:hover{
background-color: transparent;
z-index: 50;
}
.thumbnail span{ /*CSS for enlarged image*/
position: absolute;
background-color: lightyellow;
padding: 5px;
left: -1000px;
border: 1px dashed gray;
visibility: hidden;
color: black;
text-decoration: none;
}
.thumbnail span img{ /*CSS for enlarged image*/
border-width: 0;
padding: 2px;
}
.thumbnail:hover span{ /*CSS for enlarged image on hover*/
visibility: visible;
top: 0;
left: 5px; /*position where enlarged image should offset horizontally */
}
</style>
</head>
<table style="width:1000px;" border="1"  align="center" class="table table-bordered"  >
<tr>
<td style="width:1000px;">
<fieldset style="width:1000px;" height="auto">
<table style="width:1000px;"   class="table table-bordered"  >
<tr >
<td style="width:250px; border: 1px dashed #cccccc;" ><img src="images/logosbi.png" width="150" height="100" /></td>
<td style="width:750px; border: 1px dashed #cccccc;" align="center"><font size="4"><b>KANDARP MANAGEMENT SERVICES PVT. LTD</b></font></td>
</tr>
</table>
		<table style="width:1000px;" align="center"  class="table table-bordered"   >
		<?php
		$appco_applicant=$data['appco_applicant'];
		$id2= $data['id'];
		$sql22="select id,status,app_no,dump_date,month from allocation_tbl where sbiref_id='$id2' ";
		$result22=mysqli_query($conn,$sql22);
		$data22=mysqli_fetch_array($result22);
		$refid=$data22['id'];
		$sqlrv="select * from res_verification where ref_id='$refid' ";
		$resultrv=mysqli_query($conn,$sqlrv);
		$datarv=mysqli_fetch_array($resultrv);
		?>
		<tr >
		<td style="width:250px;;"><font size="4">Reference No.</font></td>
		<td style="width:275px; height:35px;  "><?php echo $data['case_id'];?></td>
		<td style="width:200px; "><font size="4">Customer Name</font></td>
		<td style="width:275px; height:35px;"><?php echo $data['name'];?></td>			
		</tr>		
		<tr>
		<td style="width:250px;"><font size="4">Case Creation Login Details.</font></td>
		<td style="width:275px; height:35px;"><?php echo $loginid;?></td>
		<td style="width:200px; "><font size="4">Contact No.</font></td>
		<td style="width:275px; height:35px;"><?php echo $data['mobile_no'];?></td>			
		</tr>		
		<tr >
		<td style="width:250px;"><font size="4">Product Name</font></td>
		<td style="width:275px; height:35px;  "><?php echo $data['loan_type'];?></td>
		<td style="width:200px; "><font size="4">Loan Amount</font></td>
		<td style="width:275px; height:35px;"><?php echo $data['loan_amount'];?></td>			
		</tr>
		</table>
		<table style="width:1000px;" align="center"  class="table table-bordered"   >
		<tr >
		<td style="width:250px;"><font size="4">Address</font></td>
		<td style="width:750px; height:35px;  "><?php echo $data['address1'].' '.$data['pincode'];?></td>
		</tr>
		</table>
		<table style="width:1000px;" align="center"  class="table table-bordered"   >
		<tr >
		<td style="width:1000px;"  align="center"><b>Residence Verification Format</b></td>
		</tr>
		</table>
		<table style="width:1000px;" align="center"  class="table table-bordered"   >
		<tr >
		<td style="width:250px;"><font size="4">Address Confirmed </font></td>
		<td style="width:750px; height:35px;  "><?php echo $datarv['confirm_by'];?></td>
		</tr>
		<tr >
		<td style="width:250px;"><font size="4">Address Confirmed by</font></td>
		<td style="width:750px; height:35px;  "><?php echo strtoupper($datarv['address_type']);?></td>
		</tr>
		</table>
		<table style="width:1000px;" align="center"  class="table table-bordered"   >
		<tr >
		<td style="width:1000px;"  align="center"><b>The following information needs to be obtained if the applicant or his family members are contacted</b></td>
		</tr>
		</table>
		<table style="width:1000px;" align="center"  class="table table-bordered"   >
		<tr >
		<td style="width:250px;"><font size="4">Applicant Name</font></td>
		<td style="width:275px; height:35px;  "><?php echo $datarv['applicant_name'];?></td>
		<td style="width:200px; ">Date of Birth</td>
		<td style="width:275px; height:35px;"><?php echo $datarv['dob'];?></td>			
		</tr>
		<tr >
		<td style="width:250px;"><font size="4">Person Met</font></td>
		<td style="width:275px; height:35px;  "><?php echo $datarv['contact_person'];?></td>
		<td style="width:200px; "><font size="4">Relationship</font></td>
		<td style="width:275px; height:35px;"><?php echo $datarv['relation'];?></td>			
		</tr>
		<tr >
		<td style="width:250px;"><font size="4">No of residents in house</font></td>
		<td style="width:275px; height:35px;  "><?php echo $datarv[''];?></td>
		<td style="width:200px; "><font size="4">Years at current Residence</font></td>
		<td style="width:275px; height:35px;"><?php echo $datarv['no_offamily'];?></td>			
		</tr>
		<tr >
		<td style="width:250px;"><font size="4">No of Earning Family Members</font></td>
		<td style="width:275px; height:35px;  "><?php echo $datarv['working'];?></td>
		<td style="width:200px; "><font size="4">Residence Status</font></td>
		<td style="width:275px; height:35px;"><?php echo $datarv['res_status'];?></td>			
		</tr>
		<tr >
		<td style="width:250px;"><font size="4">Name of employer</font></td>
		<td style="width:275px; height:35px;  "><?php echo $datarv['cust_name'];?></td>
		<td style="width:200px; "><font size="4">Employer Address</font></td>
		<td style="width:275px; height:35px;"><?php echo $datarv['previous_address'];?></td>			
		</tr>
		<tr >
		<td style="width:250px;"><font size="4">Telephone No Residence</font></td>
		<td style="width:275px; height:35px;  "><?php echo $datarv['mobile'];?></td>
		<td style="width:200px; "><font size="4">Office</font></td>
		<td style="width:275px; height:35px;"><?php echo $datarv['office_phone'];?></td>			
		</tr>
		<tr >
		<td style="width:250px;"><font size="4">Approx Rent </font></td>
		<td style="width:275px; height:35px;  "><?php echo $datarv['loan_no'];?></td>
		<td style="width:200px; "><font size="4">Approx Value if owned</font></td>
		<td style="width:275px; height:35px;"><?php echo $datarv['loan_amount'];?></td>			
		</tr>
		<tr >
		<td style="width:250px;"><font size="4">Bank Name</font></td>
		<td style="width:275px; height:35px;  "><?php echo $datarv['bank_relation'];?></td>
		<td style="width:200px; "><font size="4">Branch</font></td>
		<td style="width:275px; height:35px;"><?php echo $datarv['issuing_bank'];?></td>			
		</tr>
		</table>
		<table style="width:1000px;" align="center"  class="table table-bordered"   >
		<tr >
		<td style="width:250px;"><font size="4">Designation</font></td>
		<td style="width:750px; height:35px;  "><?php echo $datarv['designation'];?></td>
		</tr>
		<tr>
		<td style="width:250px; "><font size="4">Permanent Address/phone</font></td>
		<td style="width:750px; height:35px;"><?php echo $datarv['permanent_address'];?></td>			
		</tr>
		</table>
		<table style="width:1000px;" align="center"  class="table table-bordered"   >
		<tr >
		<td style="width:250px;"><font size="4">Vehicles</font></td>
		<td style="width:275px; height:35px;  "><?php echo $datarv['present_vehicle'];?></td>
		<td style="width:200px; "><font size="4">Make and Type</font></td>
		<td style="width:275px; height:35px;"><?php echo $datarv['vehicle_make'];?></td>			
		</tr>
		</table>
		<table style="width:1000px;" align="center"  class="table table-bordered"   >
		<tr >
		<td style="width:1000px;"  align="center"><b>Verifier's Observations</b></td>
		</tr>
		</table>
		<table style="width:1000px;" align="center"  class="table table-bordered"   >
		<tr >
		<td style="width:250px;"><font size="4">Location</font></td>
		<td style="width:275px; height:35px;  "><?php echo $datarv['ease_locality'];?></td>
		<td style="width:200px; "><font size="4">Locality</font></td>
		<td style="width:275px; height:35px;"><?php echo $datarv['res_locality'];?></td>			
		</tr>
		<tr >
		<td style="width:250px;"><font size="4">Accomodation Type</font></td>
		<td style="width:275px; height:35px;  "><?php echo $datarv['res_type'];?></td>
		<?php
		if($datarv['interior1']=="pa")
		{
		$interior="PAINTED";
		}
		elseif($datarv['interior2']=="cl")
		{
		$interior="Furnished";
		}
		elseif($datarv['interior3']=="ca")
		{
		$interior="";
		}
		elseif($datarv['interior4']=="cu")
		{
		$interior="Carpated";
		}
		else
		{
		$interior="Cutains";
		}
		if($datarv['assets_seen']=="TV")
		{
		$tv="TELEVISION";
		}
		else
		{
		$tv="";
		}
		if($datarv['assets_seen2']=="rf")
		{
		$ref="REFRIGERATOR";
		}
		else
		{
		$ref="";
		}
		if($datarv['assets_seen3']=="ms")
		{
		$music="MUSIC SYSTEM";
		}
		else
		{
		$music="";
		}
		if($datarv['assets_seen4']=="ac")
		{
		$ac="AIR CONDITION";
		}
		else
		{
		$ac="";
		}
		$assets=$tv.''.$ref.''.$music.''.$ac;
		/*if($tv>0 and $ref>0 and  $music>0 and $ac>0)
		{
		$assets="TELEVISION|REFRIGERATOR|MUSIC SYSTEM|AIR CONDITION";
		}
		elseif($tv>0  and  $music>0 and $ac>0)
		{
		$assets="TELEVISION|MUSIC SYSTEM|AIR CONDITION";
		}
		elseif($ref>0 and  $music>0 and $ac>0)
		{
		$assets="REFRIGERATOR|MUSIC SYSTEM|AIR CONDITION";
		}
		elseif($music>0 and $ac>0)
		{
		$assets="MUSIC SYSTEM|AIR CONDITION";
		}	*/
		?>
		<td style="width:200px; "><font size="4">Interior Conditions</font></td>
		<td style="width:275px; height:35px;"><?php echo strtoupper($interior);?></td>			
		</tr>
		<tr >
		<td style="width:250px;"><font size="4">Area</font></td>
		<td style="width:275px; height:35px;  "><?php echo $datarv['carpet_area'];?></td>
		<td style="width:200px; "><font size="4">Standard of Living</font></td>
		<td style="width:275px; height:35px;"><?php echo $datarv['living_standard'];?></td>			
		</tr>
		</table>
		<table style="width:1000px;" align="center"  class="table table-bordered"   >
		<tr >
		<td style="width:250px;"><font size="4">Assets Seen</font></td>
		<td style="width:750px; height:35px;  "><?php echo $assets;?></td>
		</tr>
		<tr>
		<td style="width:250px; "><font size="4">Nearest Landmark</font></td>
		<td style="width:750px; height:35px;"><?php echo $datarv['landmark'];?></td>			
		</tr>
		</table>
		<table style="width:1000px;" align="center"  class="table table-bordered"   >
		<tr >
		<td style="width:1000px;"  align="center"><b>If the house is locked,the following information needs to be obtained from the Neighbour/Third Party.</b></td>
		</tr>
		</table>
		<table style="width:1000px;" align="center"  class="table table-bordered"   >
		<tr >
		<td style="width:250px;"><font size="4">Applicant Name</font></td>
		<td style="width:750px; height:35px;  "><?php echo $datarv['name_address'];?></td>
		</tr>
		</table>
		<table style="width:1000px;" align="center"  class="table table-bordered"   >
		<tr >
		<td style="width:250px;"><font size="4">Person Met</font></td>
		<td style="width:275px; height:35px;  "><?php echo $datarv['ref_name1'];?></td>
		<td style="width:200px; "><font size="4">Relationship</font></td>
		<td style="width:275px; height:35px;"><?php echo $datarv['ref_address1'];?></td>			
		</tr>
		<tr >
		<td style="width:250px;"><font size="4">Applicant Age (Approx)</font></td>
		<td style="width:275px; height:35px;  "><?php echo $datarv['age'];?></td>
		<td style="width:200px; "><font size="4">No of residents in house</font></td>
		<td style="width:275px; height:35px;"><?php echo $datarv['family_seen'];?></td>			
		</tr>
		</table>
		<table style="width:1000px;" align="center"  class="table table-bordered"   >
		<tr>
		<td style="width:250px;"><font size="4">Years lived at residence occupation</font></td>
		<td style="width:750px; height:35px;  "><?php echo $datarv['add_stay'];?></td>
		</tr>
		<tr>
		<td style="width:250px;"><font size="4">Occupation</font></td>
		<td style="width:750px; height:35px;  "><?php echo $datarv['spouse_work'];?></td>
		</tr>
		</table>
		<table style="width:1000px;" align="center"  class="table table-bordered"   >
		<tr >
		<td style="width:1000px;"  align="center"><b>If the address is not confirmed then the following information needs to be filled.</b></td>
		</tr>
		</table>
		<table style="width:1000px;" align="center"  class="table table-bordered"   >
		<tr >
		<td style="width:250px;"><font size="4">Untraceable</font></td>
		<td style="width:275px; height:35px;  "><font size="4">Reason</font></td>
		<td style="width:475px; "><?php echo $datarv['ref_address2'];?></td>
		</tr>
		<tr >
		<td style="width:250px;"><font size="4"></font></td>
		<td style="width:275px; height:35px;  "><font size="4">Result of Calling</font></td>
		<td style="width:475px; "><?php echo $datarv['res_locality2'];?></td>
		</tr>
		<tr >
		<td style="width:250px;"><font size="4">Mismatched  in Residence Address </font></td>
		<td style="width:275px; height:35px;  "><font size="4">Is the applicant know to the person</font></td>
		<td style="width:475px; "><?php echo $datarv['name_verified'];?></td>
		</tr>
		<tr >
		<td style="width:250px;"><font size="4"></font></td>
		<td style="width:275px; height:35px;  "><font size="4">To Whom Does Address Belong ?</font></td>
		<td style="width:475px; "><?php echo $datarv['company_address'];?></td>
		</tr>
		</table>
		<table style="width:1000px;" align="center"  class="table table-bordered"   >
		<tr >
		<td style="width:1000px;"  align="center"><b>The following is based on Verifier Observations</b></td>
		</tr>
		</table>
		<table style="width:1000px;" align="center"  class="table table-bordered"   >
		<tr>
		<td style="width:250px;"><font size="4">Verifier Name</font></td>
		<td style="width:750px; height:35px;  "><?php echo $datarv['v_name'];?></td>
		</tr>
		<tr>
		<td style="width:250px;"><font size="4">Verification Conducted At</font></td>
		<td style="width:750px; height:35px;  "><?php echo $datarv['res_entry'];?></td>
		</tr>
		<tr>
		<td style="width:250px;"><font size="4">Proof Attached</font></td>
		<td style="width:750px; height:35px;  "><?php echo $datarv['res_proof1'];?></td>
		</tr>
		<tr>
		<td style="width:250px;"><font size="4">Type of Proof</font></td>
		<td style="width:750px; height:35px;  "><?php echo strtoupper($datarv['add_proofdetails']);?></td>
		</tr>
		</table>
		<table style="width:1000px;" align="center"  class="table table-bordered"   >
		<tr >
		<td style="width:250px;"><font size="4">Date of Visit</font></td>
		<td style="width:275px; height:35px;  "><?php echo $datarv['visit_date'];?></td>
		<td style="width:200px; "><font size="4">Time of Visit</font></td>
		<td style="width:275px; height:35px;"><?php echo $datarv['visit_time'];?></td>			
		</tr>
		</table>
		<table style="width:1000px;" align="center"  class="table table-bordered"   >
		<tr >
		<td style="width:1000px;"  align="center"><b>Updations</b></td>
		</tr>
		</table>
		<table style="width:1000px;" align="center"  class="table table-bordered"   >
		<tr>
		<td style="width:250px;"><font size="4">Address</font></td>
		<td style="width:750px; height:35px;  "><?php echo $datarv['correct_address'];?></td>
		</tr>
		<tr>
		<td style="width:250px;"><font size="4">Phone Number</font></td>
		<td style="width:750px; height:35px;  "><?php echo $datarv['ref_phone1'];?></td>
		</tr>
		<tr>
		<td style="width:250px;"><font size="4">Employement Details</font></td>
		<td style="width:750px; height:35px;  "><?php echo $datarv['exterior_commentsother'];?></td>
		</tr>
		</table>
		<table style="width:1000px;" align="center"  class="table table-bordered"   >
		<tr >
		<td style="width:1000px;"  align="center"><b>RESI CPV COMMENTS</b></td>
		</tr>
		<tr >
		<td style="width:1000px;height:35px; "  ><?php echo $datarv['C'];?></td>
		</tr>
		<tr >
		<td style="width:1000px;"  align="center"><b>Supervisor Remarks</b></td>
		</tr>
		<tr >
		<td style="width:1000px;height:35px; "  ><?php echo $datarv['supervisor_remarks'];?></td>
		</tr>
		<tr >
		<td style="width:1000px;"  align="center"><b>AS CLAIMED / CONFIRMED</b></td>
		</tr>
		<tr >
		<td style="width:1000px;height:35px; "  ><?php echo $datarv['C'];?></td>
		</tr>
		</table>
		<table style="width:1000px;" align="center"  class="table table-bordered"   >
		<tr>
		<td style="width:250px;"><font size="4">Visit Conducted</font></td>
		<td style="width:750px; height:35px;  "><?php echo strtoupper($datarv['final_status']);?></td>
		</tr>		
		</table>
		<?php
		if(strlen($datarv['remarks1'])>2)
		{
		?>
		<table style="width:1000px;" align="center"  class="table table-bordered"   >
		<tr >
		<td style="width:1000px;"  align="center"><b>Bank Statement Remarks</b></td>
		</tr>
		<tr >
		<td style="width:1000px;height:35px; "  ><?php echo $datarv['remarks1'];?></td>
		</tr>
		</table>
		<table style="width:1000px;" align="center"  class="table table-bordered"   >
		<tr>
		<td style="width:250px;"><font size="4">Bank Statement Status</font></td>
		<td style="width:750px; height:35px;  "><?php echo strtoupper($datarv['reg_no']);?></td>
		</tr>		
		</table>
		<?php
		}
		else
		{
		}
		?>
		<table style="width:1000px;" align="center"  class="table table-bordered"   >
		<tr >
		<td style="width:1000px;"  align="center"><b>Applicant Photos</b></td>
		</tr>
		</table>
		<?php 
	
	$id=$data22['id'];
	$dump_date=$data22['dump_date'];
	$month=$data22['month'];
	$image1 = 'http://kandarp.in/combinebanking/uploads/'.$month.'/'.$dump_date.'/'.$id.'/1.jpg';
	$image2 = 'http://kandarp.in/combinebanking/uploads/'.$month.'/'.$dump_date.'/'.$id.'/2.jpg';
	$image3 = 'http://kandarp.in/combinebanking/uploads/'.$month.'/'.$dump_date.'/'.$id.'/3.jpg';
	$image4 = 'http://kandarp.in/combinebanking/uploads/'.$month.'/'.$dump_date.'/'.$id.'/4.jpg';
	$image5 = 'http://kandarp.in/combinebanking/uploads/'.$month.'/'.$dump_date.'/'.$id.'/5.jpg';
	$image6 = 'http://kandarp.in/combinebanking/uploads/'.$month.'/'.$dump_date.'/'.$id.'/6.jpg';

?>
<table style="width:1000px;" align="center"  class="table table-bordered"   >
<tr>		
	<td><a class='thumbnail' ><img src="<?php echo $image1 ;?>" width='310px' height='250px' border='1' /><span><img src="<?php echo $image1 ;?>" /></span></a></div></td>
	<td><a class='thumbnail' ><img src="<?php echo $image2 ;?>" width='310px' height='250px' border='1' /><span><img src="<?php echo $image2 ;?>" /></span></a></div></td>
	<td><a class='thumbnail' ><img src="<?php echo $image3 ;?>" width='310px' height='250px' border='1' /><span><img src="<?php echo $image3 ;?>" /></span></a></div></td>
	</tr>
	<tr>		
	<td><a class='thumbnail' ><img src="<?php echo $image4 ;?>" width='310px' height='250px' border='1' /><span><img src="<?php echo $image4 ;?>" /></span></a></div></td>
	<td><a class='thumbnail' ><img src="<?php echo $image5 ;?>" width='310px' height='250px' border='1' /><span><img src="<?php echo $image5 ;?>" /></span></a></div></td>
	<td><a class='thumbnail' ><img src="<?php echo $image6 ;?>" width='310px' height='250px' border='1' /><span><img src="<?php echo $image6 ;?>" /></span></a></div></td>
	</tr>
 </table>
 <table style="width:1000px;" align="center"  class="table table-bordered"   >
		<tr >
		<td style="width:250px;"><font size="4">Date of Visit</font></td>
		<td style="width:275px; height:35px;  "><?php echo $datarv['visit_date'];?></td>
		<td style="width:200px; "><font size="4">Time of Visit</font></td>
		<td style="width:275px; height:35px;"><?php echo $datarv['visit_time'];?></td>			
		</tr>
		</table>
		<table style="width:1000px;" align="center"  class="table table-bordered"   >
		<tr >
		<td style="width:1000px;"  align="center"><b>Location</b></td>
		</tr>
		</table>
		<table style="width:1000px;" align="center"  class="table table-bordered"   >
		<tr >
		<td style="width:250px;"><font size="4">Latitude</font></td>
		<td style="width:275px; height:35px;  "><?php echo $datarv['x_coordinate'];?></td>
		<td style="width:200px; "><font size="4">Longitude</font></td>
		<td style="width:275px; height:35px;"><?php echo $datarv['y_coordinate'];?></td>			
		</tr>
		</table>
		<table style="width:1000px;" align="center"  class="table table-bordered"   >
		<div id="googlemap">
		<iframe src="https://maps.google.com/maps?q=<?php echo $datarv['x_coordinate']; ?>,<?php echo $datarv['y_coordinate']; ?>&hl=en&z=14&amp;output=embed" width="100%" height="600" frameborder="0" style="border:0" allowfullscreen></iframe>   
     		</div>
		</table>
		<table style="width:1000px;" align="center"  class="table table-bordered"   >
		<tr >
		<td style="width:1000px;"  align="center"><b>Cross Verification Info</b></td>
		</tr>
		</table>
		<table style="width:1000px;" align="center"  class="table table-bordered"   >
		<tr >
		<td style="width:250px;"><font size="4">Neighbour Check 1</font></td>
		<td style="width:275px; height:35px;  "><?php echo $datarv['neigh_name1'];?></td>
		<td style="width:200px; "><font size="4">Neighbour Check 1 With</font></td>
		<td style="width:275px; height:35px;"><?php echo $datarv['neigh_comments1'];?></td>			
		</tr>
		</table>
		<table style="width:1000px;" align="center"  class="table table-bordered"   >
		<tr>
		<td style="width:250px;"><font size="4">TCP 1 Negative Comments</font></td>
		<td style="width:750px; height:35px;  "><?php echo strtoupper($datarv['neigh_commentsother1']);?></td>
		</tr>		
		</table>
		<table style="width:1000px;" align="center"  class="table table-bordered"   >
		<tr >
		<td style="width:250px;"><font size="4">Neighbour Check 2</font></td>
		<td style="width:275px; height:35px;  "><?php echo $datarv['neigh_name2'];?></td>
		<td style="width:200px; "><font size="4">Neighbour Check 2 With</font></td>
		<td style="width:275px; height:35px;"><?php echo $datarv['neigh_comments2'];?></td>			
		</tr>
		</table>
		<table style="width:1000px;" align="center"  class="table table-bordered"   >
		<tr>
		<td style="width:250px;"><font size="4">TCP 2 Negative Comments</font></td>
		<td style="width:750px; height:35px;  "><?php echo strtoupper($datarv['neigh_commentsother2']);?></td>
		</tr>
		<tr>
		<td style="width:250px;"><font size="4">Customer Signature</font></td>
		<td style="width:750px; height:35px;  "></td>
		</tr>	
		</table>
		<table style="width:1000px;" align="center"  class="table table-bordered"   >
		<tr >
		<td style="width:250px;"><font size="4">Visited By</font></td>
		<td style="width:275px; height:35px;  "><?php echo $fename;?></td>
		<td style="width:200px; "><font size="4">Verified By</font></td>
		<td style="width:275px; height:35px;"><?php echo $datarv['scanner_name'];?></td>			
		</tr>
		</table>
		<table style="width:1000px;" align="center"  class="table table-bordered"   >
		<tr >
		<td style="width:475px;">
		<table style="width:475px;">
		<tr>
		<td style="width:475px;" align="center"></td>
		</tr>
		<tr>
		<td style="width:475px;"><font size="4">Signature of Agency Supervisor (with Agency Seal)</font></td>
		</tr>
		</table>
		</td>
		<td style="width:475px;">
		<table style="width:475px;">
		<tr>
		<td style="width:475px;" align="center"></td>
		</tr>
		<tr>
		<td style="width:475px;"><font size="4">Audit Check Remarks With Stamp & Sign</font></td>
		</tr>
		</table>
		</td>
		</tr>
		</table>	
		</td>
		
		</tr>
		</table>
		
			</form>
			</body>
			</html>

