<?php include 'connection.php';?><!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" />
<title>Invoice</title>
<?php 
$query2 = "select * from  challan_master where challan_id='".$_REQUEST['challan_id']."'";
			//echo $query2;
$result2 = mysql_query($query2,$conn);	
while($row=mysql_fetch_array($result2))
	                                              	{
$consignor= $row['consignor'];
$consignee= $row['consignee'];
$main_job_no=$row['main_job_no'];
$consignee_gst_no= $row['consignee_gst_no'];
$from_consignor= $row['from_consignor'];
$to_consignor= $row['to_consignor'];
$vehicle_no = $row['vehicle_no'];
$articles_no= $row['articles_no'];
$challan_to= $row['challan_to'];
$weight= $row['weight'];
$freight= $row['freight'];
$transportations_service= $row['transportations_service'];
$description= $row['description'];
$loaded_export_import= $row['loaded_export_import'];
$container_no= $row['container_no'];
$paid= $row['paid'];
$transportation= $row['transportation'];
$loaded= $row['loaded'];
$container_no= $row['container_no'];
$seal_no= $row['seal_no'];
$destinations= $row['destinations'];
$shipping_agent= $row['shipping_agent'];
$booking_no= $row['booking_no'];
$in_time= $row['in_time'];
$out_time= $row['out_time'];
$receiver_signature_with_seal= $row['receiver_signature_with_seal'];
$delivery_at= $row['delivery_at'];
$description= $row['description'];	
	$date= $row['date'];
  $consignor_address= $row['consignor_address'];
  $consignee_addess= $row['consignee_addess'];
  $actual_weight=$row['actual_weight'];
$charged_weight=$row['charged_weight'];
$topay_freight=$row['topay_freight'];
$no_of_pkgs=$row['no_of_pkgs'];
$paid_freight=$row['paid_freight'];		
$challan_no=$row['challan_no'];	

  		$b_e_no=$row['b_e_no'];
$b_e_date=$row['b_e_date'];
$sb_no=$row['sb_no'];
$sb_date=$row['sb_date'];
$seal_no=$row['seal_no'];
$container_type=$row['container_type'];
$type_pkgs=$row['type_pkgs'];
$consignee_gst_no=$row['consignee_gst_no'];
$customer_id=$row['customer_id'];
							}
		

    											?>
													
<?php												
$query2 = "select * from customer_master where customer_id = '$customer_id'";
$result2 = mysql_query($query2,$conn);	
while($row = mysql_fetch_array($result2))
{
$billing_address = $row['billing_address'];
$bgst_no = $row['bgst_no'];
$customer_name = $row['customer_name'];
$bstate_code = $row['bstate_code'];

}
?>
<?php												
$queryci = "select * from company_info where name = '".$_REQUEST['cha_name']."'";
$resultci = mysql_query($queryci,$conn);	
while($row = mysql_fetch_array($resultci))
{
$full_name_com = $row['full_name_com'];
}
?>
<style type="text/css">
#printable { display: ; }
    @media print
    {
    	#non-printable { display: none; }
    	#printable { display: block; }
    }
	 #footer {
    position:relative;
    bottom : 0;
	}
     #header {
    position:fixed;
    top : 0;
	}
</style>
<style type="text/css">
<!--
body {
	margin-left: 0px;
	margin-top: 0px;
	margin-right: 0px;
	margin-bottom: 0px;
}
.style14 {font-family: Arial, Helvetica, sans-serif;  font-size: 11px;}
.style15 {font-family: Arial, Helvetica, sans-serif; font-size: 14px; }
.style16 {font-size: 12px}
.style17 {font-family: Arial, Helvetica, sans-serif; font-size: 14px; font-weight: bold; }
-->
</style>
</head>
<body>
<table width="100%" border="1" bordercolor="#000000" style="border-collapse:collapse">
  <tr>
    <td colspan="3"><div align="center"><img src="header_bar_shigmoda.jpg"/></div></td>
  </tr>
  <tr>
    <td width="37%"><div align="left" class="style15" style="padding:3px;"><strong>From</strong> : <?php echo $from_consignor;?> <strong>To</strong> : <? echo $to_consignor;?> </div></td>
    <td width="35%"><div align="left" class="style17" style="padding:3px;">Job No. :<?php echo $main_job_no; ?></div></td>
    <td width="28%"><div align="left" class="style17" style="padding:3px;">G.C. NOTE NO. <?php echo $challan_no; ?></div></td>
  </tr>
  <tr>
    <td rowspan="2" valign="top" class="style15"><div align="left" style="padding:3px;"><strong>Consignor: <?php echo $consignor;?> </strong></div> <?php echo $consignor_address;?>  <br />
	GST No. <?php echo $bgst_no;?>  </td>
    <td rowspan="2" valign="top" class="style15"><div align="left" style="padding:3px;"><strong>Consignee:  <?php echo $consignee;?></strong></div><?php echo $consignee_addess;?> <br />
	GST No : <?php echo $consignee_gst_no;?></td>
    <td class="style15"><div align="left" style="padding:3px;"><strong>Date:<?php echo $date;?> </strong></div></td>
  </tr>
  <tr>
    <td class="style15"><div align="left" style="padding:3px;"><strong>Vehicle No. : <?php echo $vehicle_no;?></strong></div></td>
  </tr>
  <tr>
    <td colspan="3"><table width="100%" border="1" bordercolor="#CCCCCC" style="border-collapse:collapse">
      <tr>
        <td rowspan="3" valign="top" class="style15"><div align="center" style="padding:3px;"><strong>Articles No.</strong></div></td>
        <td rowspan="3" valign="top" class="style15"><div align="center" style="padding:3px;"><strong>DESCRIPTION</strong></div></td>
        <td colspan="2" class="style15"><div align="center" style="padding:3px;"><strong>Weight</strong></div>          </td>
        <td colspan="4" class="style15"><div align="center" style="padding:3px;"><strong>FREIGHT</strong></div></td>
        </tr>
      <tr>
        <td class="style15"><div align="center" style="padding:3px;"><strong>ACTUAL</strong></div></td>
        <td class="style15"><div align="center" style="padding:3px;"><strong>CHARGED</strong></div></td>
        <td colspan="2" class="style15"><div align="center" style="padding:3px;"><strong>TO PAY</strong></div></td>
        <td colspan="2" class="style15"><div align="center" style="padding:3px;"><strong>PAID</strong></div></td>
      </tr>
      <tr>
        <td class="style14"><div align="center" style="padding:3px;"><strong>Kg</strong></div></td>
        <td class="style14"><div align="center" style="padding:3px;"><strong>Kg</strong></div></td>
        <td class="style14"><div align="center" style="padding:3px;"><strong>Rs.</strong></div></td>
        <td class="style14"><div align="center" style="padding:3px;"><strong>P</strong></div></td>
        <td class="style14"><div align="center" style="padding:3px;"><strong>Rs.</strong></div></td>
        <td class="style14"><div align="center" style="padding:3px;"><strong>P</strong></div></td>
      </tr>
      <tr>
        <td height="28"><div align="center" style="padding:3px;"><b><?php echo $no_of_pkgs;?> <?php echo $type_pkgs;?></b></div></td>
        <td><table width="100%" border="0" bordercolor="#999999" style="border-collapse:collapse">
          <tr>
            <td width="80%" class="style15"><div align="left" style="padding:3px;">TRANSPORTATION SERVICE : &nbsp;&nbsp; <b><?php echo $transportations_service;?></b></div> </td>
            </tr>
          <tr>
            <td class="style15"><div align="left" style="padding:3px;">LOADED EXPORT / IMPORT / LOCAL : &nbsp;&nbsp;<b><?php echo $loaded_export_import;?></b></div></td>
            </tr>
          <tr>
            <td class="style15"><div align="left" style="padding:3px;">CONTAINER NO. : &nbsp;&nbsp;<b><?php echo $container_no;?> (<?PHP echo $container_type;?>)</b></div></td>
            </tr>
			
			<tr>
            <td class="style15"><div align="left" style="padding:3px;">DESTINATION : &nbsp;&nbsp;<b><?php echo $destinations;?></b></div></td>
            </tr>
			<tr>
            <td class="style15"><div align="left" style="padding:3px;">BE/SB No : &nbsp;&nbsp;<b><?php echo $b_e_no;?> <?php echo $sb_no;?></b></div></td>
            </tr>
			<tr>
            <td class="style15"><div align="left" style="padding:3px;">Date: &nbsp;&nbsp;<b><?php echo $b_e_date;?><?php echo $sb_date;?></b></div></td>
            </tr>
          <tr>
            <td class="style15"><div align="left" style="padding:3px;">DESCRIPTION : &nbsp;&nbsp; <b><?php echo $description;?></b></div></td>
            </tr>
          <tr>
            <td class="style15">&nbsp;<div align="left" style="padding:3px;">SEAL NO : &nbsp;&nbsp;&nbsp;<b><?php echo $seal_no;?></b></div></td>
            </tr>
          <tr>
            <td class="style15">&nbsp;</td>
            </tr>
        </table></td>
        <td valign="top"><div align="center" style="padding:3px;"> 
		
		<b><?php echo $actual_weight;?></b></div></td>
        <td valign="top"><div align="center" style="padding:3px;"> <b><?php echo $charged_weight;?></b></div></td>
        <td colspan="2" valign="top"><div align="center" style="padding:3px;"> <b><?php echo $topay_freight;?></b></div></td>
        <td colspan="2" valign="top"><div align="center" style="padding:3px;"><b><?php echo $paid_freight;?></b></div></td>
      </tr>
    </table></td>
  </tr>
  <tr>
    <td colspan="3" class="style15"><div align="left" style="padding:3px;"><span class="style14"><span class="style16"></span></span>In Time &amp; Date : <br /><br />
      Out Time &amp; Date : <br /><br />
    Receiver Signature with Seal :<br /><br /> </div></td>
  </tr>
  <tr>
    <td colspan="2" class="style15"><div align="left" style="padding:3px;"><span class="style14"><span class="style16"></span></span>Delivery at :<br /><br /> </div>      </td>
    <td rowspan="2" valign="top" class="style15"><div align="left" style="padding:3px;"><span class="style14"><span class="style16"></span></span> For Shigmoda Carriers and lifters Pvt. Ltd<br /><br /></div></td>
  </tr>
  <tr>
    <td colspan="2" class="style15"><div align="left" style="padding:3px;"><span class="style14"><span class="style16"></span></span>GST NO.: <br /><br /></div></td>
  </tr>
</table>
</body>
</html>
