<?php
session_start();
error_reporting(0);
$user_name=$_SESSION['user_name'];
/*if(empty($user_name))
 {
 header("location:index.php");
 }*/
$idd2=$_GET['id'];
$idd22=explode('//',$idd2);
$idd=$idd22[0];
$app_no=$idd22[1];
$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 bvsalaried 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>Employment(Salaried)/ Business(Self-Employed) Verification Report
(Strictly Private & Confidential)</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['Address Confirmed'].' '.$data['pincode'];?></td>
		</tr>
		<tr >
		<td style="width:250px;"><font size="4">Office/Business Address</font></td>
		<td style="width:750px; height:35px;  "><?php echo $data['address1'].' '.$data['pincode'];?></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['proof_type']);?></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['relation']);?></td>
		</tr>
		</table>
		<table style="width:1000px;" align="center"  class="table table-bordered"   >
		<tr >
		<td style="width:1000px;"  align="center"><b>The following information should be obtained if the applicant/colleagues are contacted in the office</b></td>
		</tr>
		</table>
		<table style="width:1000px;" align="center"  class="table table-bordered"   >
		<tr >
		<td style="width:250px;"><font size="4">Name of Employer/Co</font></td>
		<td style="width:275px; height:35px;  "><?php echo $datarv['comp_name'];?></td>
		<td style="width:200px; "><font size="4"></font>Person Met</td>
		<td style="width:275px; height:35px;"><?php echo $datarv['contact_person'];?></td>			
		</tr>
		</table>
		<table style="width:1000px;" align="center"  class="table table-bordered"   >
		<tr >
		<td style="width:250px;"><font size="4">Address of Employer/Co</font></td>
		<td style="width:750px; height:35px;  "><?php echo $datarv['office_address'];?></td>
		</tr>
		<tr >
		<td style="width:250px;"><font size="4">Website of Employer/Co (if available)</font></td>
		<td style="width:750px; height:35px;  "><?php echo $datarv['web_address'];?></td>
		</tr>
		<tr >
		<td style="width:250px;"><font size="4">e-mail address of Employer/Co(if available)</font></td>
		<td style="width:750px; height:35px;  "><?php echo $datarv['email'];?></td>
		</tr>
		</table>
		<table style="width:1000px;" align="center"  class="table table-bordered"   >
		<tr >
		<td style="width:250px;"><font size="4">Telephone Number Office</font></td>
		<td style="width:275px; height:35px;  "><?php echo $datarv['off_phone'];?></td>
		<td style="width:200px; "><font size="4">EXT</font></td>
		<td style="width:275px; height:35px;"><?php echo $datarv['off_ext'];?></td>			
		</tr>
		<tr >
		<td style="width:250px;"><font size="4">Telephone Number Residence </font></td>
		<td style="width:275px; height:35px;  "><?php echo $datarv['phone'];?></td>
		<td style="width:200px; "><font size="4">Mobile Number</font></td>
		<td style="width:275px; height:35px;"><?php echo $datarv['mobile'];?></td>			
		</tr>
		<tr >
		<td style="width:250px;"><font size="4">Co. Board Outside Bldg/Office</font></td>
		<td style="width:275px; height:35px;  "><?php echo $datarv['office_board'];?></td>
		<td style="width:200px; "><font size="4">Type of Employer/Co </font></td>
		<td style="width:275px; height:35px;"><?php echo $datarv['company_type'];?></td>			
		</tr>
		</table>
		<table style="width:1000px;" align="center"  class="table table-bordered"   >
		<tr >
		<td style="width:250px;"><font size="4">Nature of Business</font></td>
		<td style="width:750px; height:35px;  "><?php echo $datarv['nature_ofbusiness'];?></td>
		</tr>
		<table style="width:1000px;" align="center"  class="table table-bordered"   >
		<tr >
		<td style="width:250px;"><font size="4">Line of Business (for selfemplyed)</font></td>
		<td style="width:275px; height:35px;  "><?php echo $datarv['app_namebusiness'];?></td>
		<td style="width:200px; "><font size="4">Year of Establishment</font></td>
		<td style="width:275px; height:35px;"><?php echo $datarv['no_ofyears'];?></td>			
		</tr>
		<tr >
		<td style="width:250px;"><font size="4">Level of Business activity(for selfemployed)</font></td>
		<td style="width:275px; height:35px;  "><?php echo $datarv['business_activity'];?></td>
		<td style="width:200px; "><font size="4">No. of Employees</font></td>
		<td style="width:275px; height:35px;"><?php echo $datarv['no_ofemployee'];?></td>			
		</tr>
		<tr >
		<td style="width:250px;"><font size="4">No of Branches/Offices</font></td>
		<td style="width:275px; height:35px;  "><?php echo $datarv['no_ofbranches'];?></td>
		<td style="width:200px; "><font size="4">Office ambience/look</font></td>
		<td style="width:275px; height:35px;"><?php echo $datarv['exterior'];?></td>			
		</tr>
		<tr >
		<td style="width:250px;"><font size="4">Type of Locality</font></td>
		<td style="width:275px; height:35px;  "><?php echo $datarv['office_locality'];?></td>
		<td style="width:200px; "><font size="4">Area</font></td>
		<td style="width:275px; height:35px;"><?php echo $datarv['office_area'];?></td>			
		</tr>
		<tr >
		<td style="width:250px;"><font size="4">Nearest Landmark</font></td>
		<td style="width:275px; height:35px;  "><?php echo $datarv['landmark'];?></td>
		<td style="width:200px; "><font size="4">Ease of Locating</font></td>
		<td style="width:275px; height:35px;"><?php echo $datarv['ease_oflocating'];?></td>			
		</tr>
		<tr >
		<td style="width:250px;"><font size="4">Terms of employment(for employees)</font></td>
		<td style="width:275px; height:35px;  "><?php echo $datarv['job_type'];?></td>
		<td style="width:200px; "><font size="4">Grade</font></td>
		<td style="width:275px; height:35px;"><?php echo $datarv['company_profile'];?></td>			
		</tr>
		<tr >
		<td style="width:250px;"><font size="4">Years of current employment</font></td>
		<td style="width:275px; height:35px;  "><?php echo $datarv['total_years'];?></td>
		<td style="width:200px; "><font size="4"></font></td>
		<td style="width:275px; height:35px;"></td>			
		</tr>
		</table>
		<table style="width:1000px;" align="center"  class="table table-bordered"   >
		<tr >
		<td style="width:1000px;"  align="center"><b>If applicant is not giving information, the following information needs to be obtained from the
Colleague/Guard/Neighbour</b></td>
		</tr>
		</table>
		<table style="width:1000px;" align="center"  class="table table-bordered"   >
		<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">Name of Employer/Co</font></td>
		<td style="width:275px; height:35px;"><?php echo $datarv['employeement'];?></td>			
		</tr>
		<tr >
		<td style="width:250px;"><font size="4">Co/Established in(Year)</font></td>
		<td style="width:275px; height:35px;  "><?php echo $datarv['years_offaddress'];?></td>
		<td style="width:200px; "><font size="4">Designation</font></td>
		<td style="width:275px; height:35px;"><?php echo $datarv['designation_other'];?></td>			
		</tr>
		<tr >
		<td style="width:250px;"><font size="4">Telephono No. Office</font></td>
		<td style="width:275px; height:35px;  "><?php echo $datarv['ref_phone1'];?></td>
		<td style="width:200px; "><font size="4">Ext.</font></td>
		<td style="width:275px; height:35px;"><?php echo $datarv['ref_phone2'];?></td>			
		</tr>
		<tr >
		<td style="width:250px;"><font size="4">Type of Co/Employer</font></td>
		<td style="width:275px; height:35px;  "><?php echo $datarv['t'];?></td>
		<td style="width:200px; "><font size="4">Nature of Co/Employer</font></td>
		<td style="width:275px; height:35px;"><?php echo $datarv['app_namebusiness'];?></td>			
		</tr>
		<tr >
		<td style="width:250px;"><font size="4">No of Employees </font></td>
		<td style="width:275px; height:35px;  "><?php echo $datarv['app_namejob'];?></td>
		<td style="width:200px; "><font size="4">No. of Branches</font></td>
		<td style="width:275px; height:35px;"><?php echo $datarv['bprofile'];?></td>			
		</tr>
		<tr >
		<td style="width:250px;"><font size="4">Area</font></td>
		<td style="width:275px; height:35px;  "><?php echo $datarv['ref_address1'];?></td>
		<td style="width:200px; "><font size="4">Nearest Landmark</font></td>
		<td style="width:275px; height:35px;"><?php echo $datarv['ref_address2'];?></td>			
		</tr>
		</table>
		
		<table style="width:1000px;" align="center"  class="table table-bordered"   >
		<tr >
		<td style="width:1000px;"  align="center"><b>Office CPV COMMENTS</b></td>
		</tr>
		<tr >
		<td style="width:1000px;height:35px; "  ><?php echo $datarv['verifiers_remarks'];?></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>
		<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 strtoupper($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 strtoupper($datarv['neigh_check1']);?></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_comment1'].' '.$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 strtoupper($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 strtoupper($datarv['neigh_check2']);?></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_comment2'].' '.$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>

