<?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 final_status,remarks,scanner_name from sbidocs_tbl where sbiref_id='$id2' ";
		$result22=mysqli_query($conn,$sql22);
		$data22=mysqli_fetch_array($result22);
		
		?>
		<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">Account No.</font></td>
		<td style="width:275px; height:35px;"><?php echo $data['account_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">Bank Name</font></td>
		<td style="width:275px; height:35px;"><?php echo $data['bank_name'];?></td>			
		</tr>
		</table>
		<table style="width:1000px;" align="center"  class="table table-bordered"   >
		<tr >
		<td style="width:250px;"><font size="4">Branch</font></td>
		<td style="width:750px; height:35px;  "><?php echo $data['branch'].' '.$data['pincode'];?></td>
		</tr>
		</table>
		
		
		<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 $data22['remarks'];?></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($data22['final_status']);?></td>
		</tr>		
		</table>
	
		<table style="width:1000px;" align="center"  class="table table-bordered"   >
		<tr >
		<td style="width:250px;"><font size="4">Verified By</font></td>
		<td style="width:275px; height:35px;  "><?php echo $data22['scanner_name'];?></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: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>

