
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">

<html>
<head><meta http-equiv="Content-Type" content="text/html; charset=utf-8">


    <title>EXPENSES Print</title>


    <style>
        /*.center {*/
        /*    text-align: center;*/
        /*}*/

        .right {
            text-align: right;
        }
        
        .tb  {
           width: 750px;
           border: 1px solid black;


           border-collapse: collapse;
       }
       .tb td  {

           border-top: 1px solid black;
           border-left: 1px solid black;


           border-collapse: collapse;
       }
       .tb th  {

           border-top: 1px solid black;
           border-left: 1px solid black;


           border-collapse: collapse;
       }

       .tb1 {

           border: 1px solid #000000;
       }

   </style>

</head>
<?php
require_once ("connection_sql.php");
session_start();
$sql = "Select * from s_expenses where REFNO='" . $_GET["refno"] . "' and CANCELL='0'";
$result = $conn->query($sql);
$row = $result->fetch();
 
$sql1 = "Select * from s_expense_type where REFNO='" . $row["TYPE"] . "'";
$result1 = $conn->query($sql1);
$row1 = $result1->fetch();

// $sql2 = "Select * from s_employee where REFNO='" . $row["EMPLOYEE"] . "'";
// $result2 = $conn->query($sql2);
// $row2 = $result2->fetch();

$sql_invpara = "SELECT * from invpara WHERE flag='".$_SESSION['company']."'"; 
$result_invpara = $conn->query($sql_invpara);
$row_invpara = $result_invpara->fetch(); 



?>
<body>
        <table width="750px;" cellspacing="0" border="0" align="center"

        <tr>
            <th style="text-align: center;font-size:25px;"   colspan=1 ><?php echo $row_invpara['COMPANY'] ?></th>
        </tr>
        
         <tr>
            <th style="text-align: center;font-size:23px;"   colspan=1 ><?php echo $row_invpara['ADD1'] ?></th>
        </tr>
       
         <tr> 
            <td>&nbsp;</td>
            <td></td>
            <td></td>
            <td></td>
            <td></td>
        </tr>
        <tr>

           
            <td style="text-align: center;font-size:24px;"><b>EXPENSES </b></td>
            <td></td>
            
            <td></td>
            <td></td>
        </tr>
       
         <tr> 
            <td>&nbsp;</td>
            <td></td>
            <td></td>
            <td></td>
            <td></td>
        </tr>
         <tr> 
            <td>&nbsp;</td>
            <td></td>
            <td></td>
            <td></td>
            <td></td>
        </tr>
     </table>  
    <table width="750px;"   cellspacing="0" align="center" border="0">

  
        
        <tr> 
            <td style="font-size:23px;">Type : <?php echo $row1['NAME'] ?></td>
            <td></td>
            <td class="right" style="font-size:23px;">Ref No :<?php echo $row['REFNO']; ?> </td>  
        </tr> 
      
        <tr> 
            <td  style="font-size:23px;"> Employee : <?php echo $row['EMPLOYEE'] ?></td>
            <td></td>
            <td class="right"  style="font-size:23px;">Date : <?php echo $row['SDATE'] ?></td>
        </tr>
        <tr> 
             <td  style="font-size:23px;">Amount : <?php echo $row['AMOUNT'] ?></td>
            <td></td>
            <td></td>
        </tr>
         <tr> 
             <td  style="font-size:23px;"> Remark : <?php echo $row['REMARK'] ?></td>
            <td></td>
            <td></td>
        </tr>
          <tr> 
            <td>&nbsp;</td>
            <td></td>
            <td></td>
            <td></td>
            <td></td>
        </tr>
           <tr> 
            <td>&nbsp;</td>
            <td></td>
            <td></td>
            <td></td>
            <td></td>
        </tr>
          <tr> 
            <td>&nbsp;</td>
            <td></td>
            <td></td>
            <td></td>
            <td></td>
        </tr>
    </table>

   
    <table width="750px;"   cellspacing="0" align="center" border="0">
    <tr> 
        <td>
            <table border="0" bordercolor="#000000" cellpadding="0" cellspacing="0">
                <tr>
                    <td>
                        <table border="0" >
                            <tr > 
                                <td height="25" width="480" valign="top" align="center"><span style="font-size:16px;"><b></b></span></td> 
                                  
                            </tr> 
                            <tr>
                               
                                <td align="left"><span><b>.................................................................</b></span></td> 
                                <td><span><b>&nbsp;</b></span></td> 
                                <td align="center"><span><b>.................................................................</b></span></td> 
                                <td><span><b>&nbsp;</b></span></td> 
                            </tr>
                            <tr>
                               
                                <td align="left"><span style="font-size:16px;"><b>PREPARED BY</b></span></td> 
                                <td><span><b>&nbsp;</b></span></td> 
                                <td align="center"><span style="font-size:16px;"><b>AUTHORIZED BY</b></span></td> 
                                <td><span><b>&nbsp;</b></span></td> 
                                
                            </tr>
                        </table>
                    </td>
                </tr>
             </table>
        </td>
        </tr>
    </table>
 
<!-- ************************************************************************** -->
</body>

</html>
