<td colspan="3" valign="top" class="print_text" style="border-bottom:#000000 solid thin;">Buyer (if other than consignee)</td>
</tr>
<tr>
<td colspan="2" valign="top" class="print_text" style="border-right:#000000 solid thin;">Country of Origin of Goods<br/>
<b>INDIA</b>
</td>
<td class="print_text" valign="top">Country of final Destination :<br/><b><?php
echo $buyercountry;
?>
</b></td>
</tr>
<tr>
<td colspan="2" class="print_text" style="border-bottom:#000000 solid thin;border-right:#000000 solid thin;" valign="top">Pre. Carriage by :</td>
<td width="148" valign="top" class="print_text" style="border-bottom:#000000 solid thin;">Place of Receipt by</td>
<td colspan="3" rowspan="3" class="print_text" valign="top" style="border-top:#000000 solid thin;border-bottom:#000000 solid thin;border-left:#000000 solid thin;">Terms of Delivery of Payment<br/><?php
echo nl2br(getPINumber('TermsAndCondition', 'rec_id', getDispatchDetail('PiId', 'DispatchNumberId', $rec_id)));
?>
</td>
</tr>
<tr>
<td colspan="2" class="print_text" style="border-bottom:#000000 solid thin;border-right:#000000 solid thin;" valign="top">Vessel/Flight No.:</td>
<td class="print_text" style="border-bottom:#000000 solid thin;" valign="top">Port of Loading :</td>
</tr>
<tr>
<td colspan="2" class="print_text" style="border-bottom:#000000 solid thin;border-right:#000000 solid thin;" valign="top">Port of Discharge : <b><?php
echo $port;
?>
</b></td>
<td class="print_text" style="border-bottom:#000000 solid thin;" valign="top">Final Destination :</td>
</tr>
<tr>
if ($sno % 2 == 1) {
?>
bgcolor="#F5F2F1" <?php
}
?>
class="text_1">
<td align="center"><?php
echo $sno;
?>
</td>
<td align="center"><?php
echo getDispatchNumber('DispatchNumber', 'rec_id', $row['DispatchNumberId']);
?>
</td>
<td align="center"><?php
echo getPINumber('PiNumber', 'rec_id', $row['PiId']);
?>
</td>
<td align="center"><?php
echo getProduct('ProductName', 'rec_id', $row['ProductId']);
?>
</td>
<td align="center"><?php
echo getCount('Count', 'rec_id', $row['CountId']);
?>
</td>
<td align="center"><?php
echo $row['Quantity'];
?>
</td>
<td align="center"><?php
$sql_dn = "select * from mo_adm_dispatch_number";
$result_dn = mysql_query($sql_dn)or die("Error in Query: ".$sql_dn."<br/>".mysql_error()."<br/>".mysql_errno());
if(mysql_num_rows($result_dn)>0)
{
$sno = 1;
while($row_dn = mysql_fetch_array($result_dn))
{
$sql_1 = "select dm.rec_id , dm.PiId , dm.DispatchNumberId from mo_adm_dispatch_master as dm where dm.DispatchNumberId = '".$row_dn["rec_id"]."'";
$result_1 = mysql_query($sql_1)or die("Error in Query: ".$sql_1."<br/>".mysql_error()."<br/>".mysql_errno());
if(mysql_num_rows($result_1)>0)
{
$row_1 = mysql_fetch_array($result_1);
?>
<tr>
<td align="center"><?=getPINumber('PiNumber','rec_id',$row_1['PiId'])?></td>
<td align="center"><?=$row_dn['DispatchNumber']?></td>
<td align="center" class="text_1"><?=getBuyer('BuyerName','rec_id',getDispatchNumber('BuyerId','rec_id',$row_1['DispatchNumberId']))?></td>
</tr>
<?
}
?>
<tr>
<td align="center" colspan="4">
<table align="center" width="100%" border="0" cellpadding="0" cellspacing="0">
<tr>
<?
$sql = "select ddl.rec_id , ddl.DispatchMasterId , ddl.DocId , ddl.DocStatus , ddl.DocDate , dm.rec_id , dm.PiId , dm.DispatchNumberId from mo_adm_despatch_doclist as ddl , mo_adm_dispatch_master as dm where ddl.DocStatus = '0' and ddl.DispatchMasterId = dm.rec_id and dm.DispatchNumberId = '".$row_dn["rec_id"]."'";
$result = mysql_query($sql)or die("Error in Query: ".$sql."<br/>".mysql_error()."<br/>".mysql_errno());
if(mysql_num_rows($result)>0)
{
<b><?=$buyername?></b><br/>
<?=$buyeraddress?><br/>
<b><?=$buyercountry?></b>
</td>
<td colspan="3" valign="top" class="print_text" style="border-bottom:#000000 solid 1px;">Buyer (if other than consignee)</td>
</tr>
<tr>
<td colspan="2" valign="top" class="print_text" style="border-right:#000000 solid 1px;">Country of Origin of Goods<br/>
<b>INDIA</b>
</td>
<td class="print_text" valign="top">Country of final Destination :<br/><b><?=$buyercountry?></b></td>
</tr>
<tr>
<td colspan="2" class="print_text" style="border-bottom:#000000 solid 1px;border-right:#000000 solid 1px;" valign="top">Pre. Carriage by :</td>
<td width="148" valign="top" class="print_text" style="border-bottom:#000000 solid 1px;">Place of Receipt by</td>
<td colspan="3" rowspan="3" class="print_text" valign="top" style="border-top:#000000 solid 1px;border-bottom:#000000 solid 1px;border-left:#000000 solid 1px;">Terms of Delivery of Payment<br/><?=nl2br(getPINumber('TermsAndCondition','rec_id',getDispatchDetail('PiId','DispatchNumberId',$rec_id)))?></td>
</tr>
<tr>
<td colspan="2" class="print_text" style="border-bottom:#000000 solid 1px;border-right:#000000 solid 1px;" valign="top">Vessel/Flight No.:</td>
<td class="print_text" style="border-bottom:#000000 solid 1px;" valign="top">Port of Loading :</td>
</tr>
<tr>
<td colspan="2" class="print_text" style="border-bottom:#000000 solid 1px;border-right:#000000 solid 1px;" valign="top">Port of Discharge :</td>
<td class="print_text" style="border-bottom:#000000 solid 1px;" valign="top">Final Destination :</td>
</tr>
<tr>
<td width="96" valign="top" class="print_text" style="border-bottom:#000000 solid 1px;"><b>Marks & Nos./</b></td>
<td width="117" valign="top" class="print_text" style="border-bottom:#000000 solid 1px;"><b>No. & Kind of Pkgs.</b></td>
<td valign="top" class="print_text" style="border-bottom:#000000 solid 1px;border-right:#000000 solid 1px;"><b>Description of Goods</b></td>
<td width="94" align="center" valign="top" style="border-bottom:#000000 solid 1px;border-right:#000000 solid 1px;"><span class="print_text"><b>Quantity</b><br/>
<b>Kgs</b></span></td>
$row = mysql_fetch_array($result);
$rec_id = $row['rec_id'];
$buyername = getBuyer('BuyerName', 'rec_id', $row['BuyerId']);
$buyercountry = getCountry(getBuyer('CountryId', 'rec_id', $row['BuyerId']));
$buyeraddress = getBuyer('Address', 'rec_id', $row['BuyerId']);
$buyertinno = getBuyer('TinNumber', 'rec_id', $row['BuyerId']);
$invoiceno = $row['DispatchNumber'];
$invoicedate = getDateFormate($row['DespatchDate'], 1);
$transport = $row['TransportNo'];
$vechileno = $row['VechileNo'];
$lr_no = $row['LrNo'];
$lr_date = $row['LrDate'];
$Other_ref = $row['OtherRef'];
$FreightCharges = $row['FreightCharges'];
$pi_id = getDispatchDetail('PiId', 'DispatchNumberId', $rec_id);
$report_type = getPINumber('ReportType', 'rec_id', $pi_id);
$FinalNetAmount = $row['FinalNetAmount'];
}
header("Content-type: application/vnd.ms-excel");
header("Content-Disposition: attachment; filename=domestic_dispatch_excel.xls");
?>
<style type="text/css">
.headingSmallPrint
{
font-family:Verdana, Arial, Helvetica, sans-serif;
font-size:15px;
color:#000000;
text-align:center;
line-height:15px;
vertical-align:top;
padding-right:10px;
<tr>
<td class="tableText">
<b><?php
echo getPINumber('PiNumber', 'rec_id', $row_1['PiId']);
?>
</b>
</td>
<td class="tableText">
<b><?php
echo getDateFormate(getPINumber('PiDate', 'rec_id', $row_1['PiId']), 1);
?>
</b>
</td>
<td class="tableText">
<b><?php
echo getBuyer('BuyerName', 'rec_id', getPINumber('BuyerId', 'rec_id', $row_1['PiId']));
?>
</b>
</td>
</tr>
</table>
<table align="center" width="100%" cellpadding="0" cellspacing="0" class="table1" border="1">
<tr class="gredBg">
<td width="16%" align="center"><b>Product</b></td>
<td width="15%" align="center"><b>Count</b></td>
<td width="12%" align="center"><b>Quantity</b></td>
<td width="11%" align="center"><b>Price</b></td>
<td width="12%" align="center"><b>Total</b></td>
</tr>
<?php
$sql_detail = "select * from " . $mysql_adm_table_prefix . "pi_detail where PiId = '" . $row_1['PiId'] . "'";