<?php ob_start(); ?>
<?php include "layouts/db_connect.php"; ?> <div class="right_col" role="main">
<?php
  // Use session variable on this page. This function must put on the top of page.

	if(isset($_GET['hpl']))
	{
?><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<?php include "layouts/db_con.php"; ?>  
<head><meta charset="UTF-8">
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Print Page</title>

<link rel="shortcut icon" href="images/favicon.ico">
<script type="text/javascript">
window.onload=function(){self.print();setTimeout("window.close()", 10);}

    window.onfocus = function() { window.close(); }
	 $(function(){ 
   setTimeout(function(){
      $('form').print();
    },100);
});

</script>
<style type="text/css"> 

#table1 
{ 
position:absolute; 
bottom:5%; 
} 
#table2 
{ 
position:absolute; 
bottom:15%; 
} 
#table3 
{ 
position:absolute; 
bottom:30%; 
} 

</style> 
<style type="text/css">
<!--
.style1 {font-size: 10px}
-->
</style>
<style>
p.ex1 {
    border: 1px solid white; 
    padding-top: 5px;
}
</style>
</head>
<div class="row">
                 <!-- page header -->
                <div class="col-lg-12">
<body onload="self.print()" onfocus="window.close()">
<?php
	$hpl=$_REQUEST['hpl'];
	$mfin=$_REQUEST['mfin'];
		$pamt1=$_REQUEST['pamt1'];
		$ldate1=$_REQUEST['ldate1'];
		$nod=$_REQUEST['nod'];

					$qry=mysqli_query($conn, "select * from customerdetails where hpl='$hpl' && mfin='$mfin'");
					$n=mysqli_num_rows($qry);
	
					
while($row=mysqli_fetch_array($qry))
  { 						
	$r=0;	
	$r++; 
?>
<form>
<div align="left"> <!-- this can be changed to "left" if preferred-->
<font size="2" align="right">
<?php 
$qry1=mysqli_query($conn, "select * from mfin where name='$mfin'");
					$row1=mysqli_fetch_array($qry1); 
					?>
&nbsp;&nbsp;&nbsp;&nbsp;<?php echo $row1['name']; ?><br>
&nbsp;&nbsp;&nbsp;&nbsp;<?php echo $row1['lic']; ?><br>
&nbsp;&nbsp;&nbsp;&nbsp;<?php echo $row1['addr']; ?><br>
&nbsp;&nbsp;&nbsp;&nbsp;<?php echo $row1['pno']; ?><br> </font>
</div>
<hr width="100%"><font size="5">
<p align="center"><u><b>LOAN DEFAULT NOTICE-CUSTOMER</u></b></p><br>
<?php
echo "Date:" .date("d/m/Y")."<br>"; ?> </font> <br>
<font size="2">
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;To,<br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Mr/Mrs.<?php echo $row['name']; ?>-<?php echo $row['hpl']; ?><br>
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<?php echo $row['address']; ?><br> </font> <br>
<font size="2">
<div>Loan a/c no -	<?php echo $row['hpl']; ?>	<br>
Total dues -<?php echo $row['duemnt']; ?><br>
Loan Date -	<?php echo $row['hpdate']; ?>	
Pending dues - <?php echo $nod; ?><br>
Vehicle Name		-	<?php echo $row['vname']; ?><br>
Vehicle Number	-	<?php echo $row['vno']; ?><br></div><br>
</font>
<font size="2">Dear Sir/Madam,<br><br>

We have been sending you periodic reminders regularly about your vehicle’s loan default and given you many opportunities and time to pay the pending amount. In spite of which, you have not paid the amount due nor give any proper explanation.
So we are giving you another opportunity to pay your pending amount. Kindly arrange to pay the pending amount mentioned below before <?php echo $ldate1; ?> without any delay. Or kindly surrender the hypothecated asset in full working condition. 
Kindly make use of this great opportunity for the mutual benefit of us. Or else we’ll be forced to take legal action against you in the court of law and you’ll have to face the consequences and bear the expenses.
</font>
<font size="2">
<br>
<b>Pending Amount: <?php echo $pamt1; ?>.00/-</b><br>

Kindly pay the pending amount by remitting cash in the finance office and get valid receipt for the same. Or kindly 
<br>deposit cash / demand draft / cheque only in the finance’s bank account mentioned below<br>
<br>
Account Name &nbsp;&nbsp;&nbsp;	&nbsp;&nbsp;&nbsp;: &nbsp;&nbsp;&nbsp;<?php echo $row1['acn1']; ?>		&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;	&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;			 <?php echo $row1['acn2']; ?><br>									
Account Number&nbsp;&nbsp;&nbsp;	: &nbsp;&nbsp;&nbsp;<?php echo $row1['acno1']; ?>		&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;	&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;			 <?php echo $row1['acno2']; ?><br>
Bank Name	&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;	: &nbsp;&nbsp;<?php echo $row1['bname1']; ?> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;		&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;			 <?php echo $row1['bname2']; ?><br>
Branch code	&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;	&nbsp;&nbsp;&nbsp;&nbsp;: &nbsp;&nbsp;&nbsp;<?php echo $row1['bco1']; ?> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;		&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;			 <?php echo $row1['bco2']; ?><br>
Ifsc Code	&nbsp;&nbsp;&nbsp;	&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;:&nbsp;&nbsp;&nbsp; <?php echo $row1['ifsc1']; ?>		&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;			 <?php echo $row1['ifsc2']; ?><br>Thanking you<br>
Wishing you progress and happiness<br><br>


<b>For<br>
<br>
<?php echo $row1['name']; ?></b><br>
Authorised Signatory<br>
<ul>
<li>writing an entry in the due card without valid receipt is illegal.</li>
<li>kindly know about the changes made in loan agreement rules within 7 days.</li> </ul>
For more information, kindly contact our office at the earliest.




         
</div>
</font>

</div> 
</form>
</body> <?php } ?>
</head>
</html>

<?php } ?>