<table align="center" width="100%;" border="1" cellpadding="3" cellspacing="0" style="border:#808080 1px solid;">

<tr>
    <th width="4%">S. No.</th>
    <th width="10%">Bill No.</th>
    <th width="7%">Bill Date</th>
    <th>Client</th>
    <th width="22%">Employee</th>
    <th width="12%">Status </th>
    <th width="8%">Claim Amount</th>
    <th width="8%">Deduction</th>
    <th width="8%">Approved Amount </th>
</tr>
  <tbody id="dataTable" >
  <?php  $TADASQL="Select * from crm_ta_da_claim_form_main where approved_by='".$_SESSION['UserID']."'   ";
		$TADADATA=DB_query($TADASQL,$db);
		$count=0;
                if(DB_num_rows($TADADATA)>0){
		while($TADARow=DB_fetch_array($TADADATA))
		{ $count++; ?>
  	<tr bgcolor="#fff">
<td><?php echo $count; ?></td>
<td><?php echo $TADARow['bill_no'] ?> </td>
<td><?php echo ConvertSQLDate($TADARow['bill_date']) ?></td>
<td style="white-space:nowrap"><?php echo $s->getField('clientmaster','id',$TADARow['client_name'] ,'c_name');  ?></td>
<td><?php echo $s->getField('empmaster','id',$TADARow['employee'] ,'emp_name');  ?></td>

<td><?php if($_SESSION['UserID']==$TADARow['approved_by'] && $TADARow['status']==0) { 
?>
<a href="index.php?route=CRM/ta_da_claim_approve&action=approve&tada_id=<?php echo $TADARow['id'].$rurl;?>"><input type="button" name="Approve" value="Approve" class="search" /></a><?php } else if($TADARow['status']==1) { echo "Approved"; } ?> 
</td>
  <td><?php echo $TADARow['grand_total']; ?></td>
  <td><?php echo $TADARow['deduction']; ?></td>
  <td><?php echo $TADARow['approved_amount']; ?></td>
</tr>

                <?php }  } else {?>
<tr bgcolor="#fff">
    <td colspan="10">No Record Found.</td>
</tr>
                <?php } ?>
</tbody>
 </table>