<?php 
include('pdf_header.php');
//include('includes/config/config.php');
//include('includes/functions.php');
include('log_entry.php');
//include('pop_up_top.php');
?>
<link href="includes/css-js/admin.css" rel="stylesheet" type="text/css" />
<style>

</style>
<table width="100%">
    <tr>
        <div style="font-size:12px">
            <td width="25%" align="left"> Run Date :
                <?php  echo date("d-M-Y"); ?>
            </td>
            <td width="50%" align="center" style="font-size:40px"><strong>MEDICINE USAGE CATEGORY</strong></td>
            <td width="25%" align="left"> User :
                <?php  echo $username ?>
            </td>
    </tr>
</table>
<table width="100%" border="1px solid black">
    <?php  
 //$sql="select medicine_usage_cat_id,medicine_usage_cat_name,cat_desc,code from medicine_usage_cat";
 //echo $sql;
    $sql=base64_decode($filterkey);
 error_log("query: ".$sql);
 $result = @mysqli_query($conn,$sql);
  //echo $result;
  ?><tr bgcolor="#eeeeee">
        <th width="10%">Usage Id</th>
        <th width="10%">Usage Name</th>
        <th width="15%">Usage Description</th>
        <th width="6%">Usage Code</th>
    </tr><?php  
  $i=0;
while($row=@mysqli_fetch_array($result)){
      $i++;
// calculate age by dob
// $age   =   date_diff(date_create($row['dob']), date_create('now'))->y;
// $date_added=date_create($row['date_added']);
// $date_added=date_format($date_added,"d-m-Y");
// $resumed_duties_from=date_create($row['resumed_duties_from']);
// $resumed_duties_from=date_format($resumed_duties_from,"d-m-Y");
// $tested_positive_on=date('d-m-Y h:i A', strtotime($row['tested_positive_on']));
// $discharge_on=date('d-m-Y h:i A', strtotime($row['discharge_on']));

  ?><tr>
        <td><?php  echo $i?></td>
        <td><?php  echo $row['medicine_usage_cat_name']?></td>
        <td><?php  echo $row['cat_desc']?></td>
        <td><?php  echo $row['code']?></td>
    </tr><?php  
}
?>
</table>
<?php 
include('pdf_footer.php');
?>
<script>


</script>