<?php 
include ('config.php');
if(!isset($_SESSION['emp_name']))
	 {
	  echo("<script language='javascript'>window.location.href='index.php'</script>");
	  exit;
	 }
?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
	<head>
		<meta http-equiv="content-type" content="text/html; charset=utf-8" />
<link rel="stylesheet" type="text/css" href="css/grid.css" tppabs="" media="screen" />
        <!-- Main stylesheet -->
        <link rel="stylesheet" type="text/css" href="css/styles.css" tppabs="" media="screen" /> 
         <link rel="stylesheet" type="text/css" href="css/stylee.css" tppabs="" media="screen" />  
	</head>
	<style type="text/css">
	*{ margin:0px; padding:0px; box-sizing:border-box; }
	@page  
{ 
    size: auto;   /* auto is the initial value */ 

    /* this affects the margin in the printer settings */ 
    margin:5mm 15mm 5mm 15mm;  
} 

</style>
	<body>
    	<!-- Header -->
   <?php include('header1.php'); 
  // echo "select * from tbl_statement where  emp_acc='".$_SESSION['emp_accno']."' and emp_name='". $_SESSION['emp_name']."'"; 
//echo "select * from tbl_statement where emp_acc='".$_SESSION['emp_accno']."' and emp_name='".$_SESSION['emp_name']."'";
$select_query=mysqli_query($conn,"select * from tbl_statement where  emp_acc='".$_SESSION['emp_accno']."'");
$result=mysqli_fetch_array($select_query);
?> 
 <body style="margin:0px; padding:0px; font-family:Arial, Helvetica, sans-serif;">
	<div style=" margin:0 auto; width:800px; text-transform:uppercase;">
    	<div style="width:100%; text-align:center;">
        	  <h3 style="line-height:35px; font-weight:400; font-size:20px; margin-top:20px; padding-bottom:10px; border-bottom:1px solid #666;">INDIAN MOTOR PARTS AND ACCESSORIES EMPLOYEES' PROVIDENT FUND CHENNAI</h3>
        </div>
        <table style="border-collapse:collapse; width:800px; margin-top:20px;">
        	<tbody>
            	<tr>
                	<td style="width:500px; padding:10px; font-size:14px;">
                    	<p style="width:100px; float:left;">PAN A/C NO </p>:&nbsp; <?php echo $result['emp_acc']?>
                    </td>
                	<td style="width:300px; padding:10px; font-size:14px;">
                    	<p style="width:120px; float:left;">   UAN </p>:&nbsp;   <?php echo $result['emp_uan']?>
                    </td>
                </tr>
            	<tr>
                	<td rowspan="2"  style="width:500px; padding:10px; font-size:14px;">
                    	 <p style="width:100px; float:left;"> NAME SRI. </p> :&nbsp; <?php echo $result['emp_name']?>
                    </td>
                	<td  style="width:300px; padding:10px; font-size:14px;">
                    	 <p style="width:120px; float:left;"> BASIC NAME </p> :&nbsp;  5,456
                    </td>
                </tr>
                <tr>
                	<td style="width:300px; padding:10px; font-size:14px;">
                    	 <p style="width:120px; float:left;"> ACCOUNT NO </p> :&nbsp;  <?php echo $result['emp_acc']?>
                    </td>
                </tr>
            </tbody>	
        </table>
        <div style="width:800px;">
            <table style="border-collapse:collapse; width:350px; margin-top:20px; float:right;">
                <tbody>
                    <tr style="border-bottom:1px solid #333; text-align:center;">
                        <td style="">
                             <p style="line-height:25px; font-size:14px; padding-left:40px;">   EMPLOYEES'  <br> SUBSRIPTION </p> 
                        </td>
                        <td style="">
                               <p style="line-height:25px; font-size:14px; padding-left:40px;">   EMPLOYEES'  <br> CONTRIBUTION </p> 
                        </td>
                    </tr>
                    <tr style="text-align:right;">
                        <td style="">
                             <p style="line-height:25px; font-size:14px; padding:10px 20px 10px 0px;">  RS </p> 
                        </td>
                        <td style="">
                               <p style="line-height:25px; font-size:14px; padding:10px 20px 10px 0px;">  RS </p> 
                        </td>
                    </tr>
                    
                </tbody>	
            </table>	
        </div>
        
        <table style="border-collapse:collapse; width:800px; margin-top:20px;">
                <tbody>
                    <tr>
                     	<td style="width:450px; line-height:22px; font-size:14px; padding:10px 10px;">BALANCE AS ON 01-04-<?php echo date("Y");?>. </td> 
                        <td style="width:175px; text-align:right; padding:10px 20px 10px 10px;"><?php echo $result['empl_opg_bal']?></td> 
                        <td style="width:175px; text-align:right; padding:10px 20px 10px 10px;"><?php echo $result['emplyr_opg_bal']?></td> 
                    </tr>
                    <tr>
                     	<td style="width:450px; line-height:22px; font-size:14px; padding:10px 10px;">SUBSCRIBTION/CONTRIBUTION DURING THE PERIOD FROM <?php
echo date("d-m-Y",strtotime("-1 second",strtotime(date("Y-m-1"))));?>. </td> 
                        <td style="width:175px; text-align:right; padding:10px 20px 10px 10px; border-bottom:1px solid #333; vertical-align: bottom;"><?php echo $result['empl_subsc']?></td> 
                        <td style="width:175px; text-align:right; padding:10px 20px 10px 10px; border-bottom:1px solid #333; vertical-align: bottom;"><?php echo $result['emplyr_cntr']?></td> 
                    </tr>
                    <tr>
                     	<td style="width:450px; line-height:22px; font-size:14px; padding:10px 10px;"> </td> 
                        <td style="width:175px; text-align:right; padding:10px 20px 10px 10px; vertical-align: bottom;"><?php echo $result['empl_total']?></td> 
                        <td style="width:175px; text-align:right; padding:10px 20px 10px 10px; vertical-align: bottom;"><?php echo $result['emplyr_total']?></td> 
                    </tr>
                    <tr>
                     	<td style="width:450px; line-height:22px; font-size:14px; padding:10px 10px;">LESS:WITHDRAWAL DURING THE PERIOD. </td> 
                        <td style="width:175px; text-align:right; padding:10px 20px 10px 10px; border-bottom:1px solid #333; vertical-align: bottom;"><?php echo $result['empl_withdrawals']?></td> 
                        <td style="width:175px; text-align:right; padding:10px 20px 10px 10px; border-bottom:1px solid #333; vertical-align: bottom;"><?php echo $result['emplyr_withdrawls']?></td> 
                    </tr>
                    <tr>
                     	<td style="width:450px; line-height:22px; font-size:14px; padding:10px 10px;"> </td> 
                        <td style="width:175px; text-align:right; padding:10px 20px 10px 10px; vertical-align: bottom;"><?php echo $result['empl_total']?></td> 
                        <td style="width:175px; text-align:right; padding:10px 20px 10px 10px; vertical-align: bottom;"><?php echo $result['emplyr_total']?></td> 
                    </tr>
                    <tr>
                     	<td style="width:450px; line-height:22px; font-size:14px; padding:10px 10px;">ADD INTEREST CREDITED FOR THE YEAR ENDED <?php
echo date("d M Y",strtotime("-1 second",strtotime(date("Y-m-1"))));?>. </td> 
                        <td style="width:175px; text-align:right; padding:10px 20px 10px 10px; border-bottom:1px solid #333; vertical-align: bottom;"><?php echo $result['empl_int']?></td> 
                        <td style="width:175px; text-align:right; padding:10px 20px 10px 10px; border-bottom:1px solid #333; vertical-align: bottom;"><?php echo $result['emplyr_int']?></td> 
                    </tr>
					<tr>
                     	<td style="width:450px; line-height:22px; font-size:14px; padding:10px 10px;"> BALANCE AS ON <?php
echo date("d-m-Y",strtotime("-1 second",strtotime(date("Y-m-1"))));?>. </td> 
                        <td style="width:175px; text-align:right; padding:10px 20px 10px 10px; border-bottom:1px solid #333; vertical-align: bottom;"><?php echo $result['empl_tot']?></td> 
                        <td style="width:175px; text-align:right; padding:10px 20px 10px 10px; border-bottom:1px solid #333; vertical-align: bottom;"><?php echo $result['emplyr_tot']?></td> 
                    </tr>
                    <tr>
                     	<td style="width:450px; line-height:22px; font-size:14px; padding:10px 10px;">  PROVIDENT FUND LOAN</td> 
                        <td style="width:175px; text-align:right; padding:10px 20px 10px 10px; vertical-align: bottom;"></td> 
                        <td style="width:175px; text-align:right; padding:10px 20px 10px 10px; vertical-align: bottom;"></td> 
                    </tr>
                    <tr>
                     	<td style="width:450px; line-height:22px; font-size:14px; padding:10px 10px;">  ACCOUNT OF LOAN (PRINCIPAL) OUTSTANDING AS ON <?php
echo date("d-m-Y",strtotime("-1 second",strtotime(date("Y-m-1"))));?></td> 
                        <td style="width:175px; text-align:right; padding:10px 20px 10px 10px; vertical-align: bottom;">RS.</td> 
                        <td style="width:175px; text-align:right; padding:10px 20px 10px 10px; vertical-align: bottom;"><?php echo $result['loan_outstndng']?></td> 
                    </tr>
                </tbody>	
        </table>
        <table style="border-collapse:collapse; width:800px; margin-top:20px;">
                <tbody>
                    <tr>
                     	<td style="width:400px; padding-top:50px; padding-left:10px; vertical-align:top;">DATE : <?php echo date('d-M-Y');?> </td> 
                        <td style="width:400px; padding-top:50px; text-align:center;">TRUSTEE<br><img src="sign.jpg" width="300"></td> 
                    </tr>
                </tbody>	
        </table>
        
    </div>
</body>
</html>