<?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>
	<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>
    <div  id="wrapper">
    	<!--  header start  -->
		<header>
        	<div class="top-header">
            	<div class="container">
                	<p class="theader-content"><strong>INDIA MOTOR PARTS AND ACCESSORIES EMPLOYEES PROVIDENT FUND</strong> <br> <strong>CHENNAI</strong></p>	
                </div>
            </div>
       </header>
       <div class="ac-no">
            <div class="container">
                <p class="ac-no-content"><strong>Account Number</strong> &nbsp; &nbsp; : &nbsp; &nbsp;<span><strong><?php echo $result['emp_acc']?></strong></span></p>	
                <p class="ac-no-content"><strong>Employee Name</strong> &nbsp; &nbsp; :  &nbsp; &nbsp;<span><strong><?php echo $result['emp_name']?></strong></span></p>	
            </div>
       </div>
        
    	<!--  header end  -->
        <div  class="package-table">
            <div  class="container">
                <table>
                  <tr>
                    <td style=" width:40%;"></td>
                    <td style=" width:30%; border-bottom: 1px solid #b6b6b6; text-align:right;"><strong>Employee's Subscribtion</strong></td>
                    <td style=" width:30%; border-bottom: 1px solid #b6b6b6; text-align:right;"><strong>Employer's Contribution</strong></td>
                  </tr>
                  <tr>
                    <td style=" width:40%;" > &nbsp; <strong>Balance As on 01.04.2016</strong> &nbsp;   &nbsp;  </td>
                    <td style=" width:30%; text-align:right;"><?php echo $result['empl_opg_bal']?> </td>
                    <td style=" width:30%; text-align:right;"><?php echo $result['emplyr_opg_bal']?> </td>
                  </tr>
                  <tr>
                    <td style=" width:40%;" ><strong>Subscribtion/Contribution Till &nbsp;&nbsp;<?php
echo date("d-m-Y",strtotime("-1 second",strtotime(date("Y-m-1"))));?> </strong></td>
                    <td style=" width:30%; border-bottom: 1px solid #b6b6b6; text-align:right;"> <?php echo $result['empl_subsc']?> </td>
                    <td style=" width:30%; border-bottom: 1px solid #b6b6b6; text-align:right;"><?php echo $result['emplyr_cntr']?>  </td>
                  </tr>
                  <tr>
                    <td style=" width:40%;" > <strong>Less Withdrawal During The Period</strong> </td>
                    
                     <td style=" width:30%;text-align:right;"><?php echo $result['empl_withdrawals']?>  </td>
                    <td style=" width:30%; text-align:right;"><?php echo $result['emplyr_withdrawls']?>  </td>
                    
                  </tr>
                  <tr>
                    <td style=" width:40%;" > </td>
                   <td style=" width:30%; border-bottom: 1px solid #b6b6b6;text-align:right;"><?php echo $result['empl_total']?>  </td>
                    <td style=" width:30%; border-bottom: 1px solid #b6b6b6;text-align:right;"><?php echo $result['emplyr_total']?>  </td>
                  </tr>
                
                    <tr>
                    <td style=" width:40%;"> </td>
                    <td style=" width:30%; text-align:right;"> <?php echo $result['empl_total']?>  </td>
                    <td style=" width:30%; text-align:right;"><?php echo $result['emplyr_total']?>  </td>
                  </tr>
                    <tr>
                    <td style=" width:40%;"><strong>Add Interest Credited Till &nbsp;&nbsp;<?php
echo date("d-m-Y",strtotime("-1 second",strtotime(date("Y-m-1"))));?></strong></td>
                    <td style=" width:30%;   border-bottom: 1px solid #b6b6b6; text-align:right;"><?php echo $result['empl_int']?></td>
                    <td style=" width:30%;   border-bottom: 1px solid #b6b6b6; text-align:right;"><?php echo $result['emplyr_int']?></td>
                  </tr>
                  <tr>
                    <td style=" width:40%;"><strong>Balance As on Current &nbsp;&nbsp;<?php
echo date("d-m-Y",strtotime("-1 second",strtotime(date("Y-m-1"))));?></strong></td>
                    <td style=" width:30%;  border-bottom: 1px solid #b6b6b6; text-align:right;"><?php echo $result['empl_tot']?></td>
                    <td style=" width:30%;  border-bottom: 1px solid #b6b6b6; text-align:right;"><?php echo $result['emplyr_tot']?></td>
                  </tr>
                   <tr>
                    <td style=" width:40%;" > </td>
                    <td style=" width:30%;"> </td>
                    <td style=" width:30%; "> </td>
                  </tr>
                  <tr>
                    <td style=" width:40%;"><strong>Provident Fund Loan</strong></td>
                    <td style=" width:30%; text-align:right;"></td>
                    <td style=" width:30%; text-align:left;"></td>
                  </tr>
                  
                   <tr>
                    <td style=" width:40%;" > </td>
                    <td style=" width:30%;"> </td>
                    <td style=" width:30%; "> </td>
                  </tr>
                  
                   <tr>
                    <td style=" width:40%;"><strong>Account of Loan (Principal) Outstanding as on &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;(<?php
echo date("d-m-Y",strtotime("-1 second",strtotime(date("Y-m-1"))));?>)</strong></td>
                    <td style=" width:30%; text-align:right;">Rs</td>
                    <td style=" width:30%; text-align:left;"><?php echo $result['loan_outstndng']?></td>
                  </tr>
                  <tr style=" margin-top:50px;">
                    <td style=" width:40%;"><strong>Date:</strong>&nbsp;&nbsp;<?php echo date('d-M-Y');?></td>
                    <td style=" width:30%; text-align:right;"> </td>
<!--                    <td style=" width:30%; text-align:right;">typesetting</td>
-->                  </tr>
                </table>
               
	</body>
</html>