<center> <h2>Applied Leave Details</h2></center>
 

<table border="0" width="100%" cellpadding="3" cellspacing="2">
	<tr bgcolor="#999999"><td><strong>To</strong></td>
		<td><strong>From</strong></td>
		<td><strong>Days Applied</strong></td>
		<td><strong>Approved Days</strong></td>
		<td><strong>Reason</strong></td>
		<td><strong>Comments</strong></td>
		<td><strong>Leave Type</strong></td>
</tr>
	
	 <?php 
     $leave_sql="Select * from emp_leave_apply where leave_type='".$_REQUEST['leave_type']."' and empid ='".$_REQUEST['empid']."' ";
   $leave_res=DB_query($leave_sql,$db);
   while($leave_row=DB_fetch_array($leave_res))
   { 
   ?>
	<tr><td><?php echo  ConvertSQLDate($leave_row['period_from'])?></td>
		<td><?php echo  ConvertSQLDate($leave_row['period_to'])?></td>
		<td><?php 
		//echo $s->FinedDays($leave_row['period_from'],$leave_row['period_to']);
		echo  $leave_row['total_days']?></td>
		<td><?php echo  $leave_row['approved_total_days']?></td>
		<td><?php echo  $leave_row['leave_reason']?></td>
		<td><?php echo  $leave_row['comments']?></td>
		<td><?php echo  $leave_row['leave_type']?></td>
	</tr>
<?php 
   } ?>
   
   
   
   
   
  
</table>	 
<h3> CS Updation Details</h3>
<table border="0" width="100%" cellpadding="3" cellspacing="2">


<tr bgcolor="#999999"><td>Date </td>

<td>Days</td></tr>

 <?php 
     $leave_sql="Select * from emp_csleave_updation where    empid ='".$_REQUEST['empid']."'";
   $leave_res=DB_query($leave_sql,$db);
   while($leave_row=DB_fetch_array($leave_res))
   { 
   ?>
	<tr><td><?php echo  ConvertSQLDate($leave_row['csdate'])?></td>
		<td><?php echo  $leave_row['csdays']?></td>
		 
	</tr>
<?php 
   } ?>
</table>	 
