<?
                                                        while($row=mysql_fetch_array($result_prj))
                                                        {	
														
                                                    ?>
                                                                <tr <? if ($sno%2==1) { ?> bgcolor="#F5F2F1" <? } ?> class="text_1">
                                                                    <td align="center"><?php 
echo getDispatchNumber("DispatchNumber", "rec_id", $row['DispatchNumberId']);
?>
</td>
                                                                    <td align="center"><?php 
echo getDateFormate(getDispatchNumber("DespatchDate", "rec_id", $row['DispatchNumberId']), 1);
?>
</td>
                                                                    <td align="center"><?php 
echo getBuyer('BuyerName', 'rec_id', getDispatchNumber("BuyerId", "rec_id", $row['DispatchNumberId']));
?>
</td>
                                                                    <td align="center"><?php 
echo $row['Port'];
?>
</td>
                                                                    <td align="center"><?php 
echo getCountry(getBuyer('CountryId', 'rec_id', $row['BuyerId']));
?>
</td>
                                                                    <td align="center"><?php 
echo getProduct("ProductName", "rec_id", $row['ProductId']);
?>
</td>
                                                                    <td align="center"><?php 
 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)
             {
                 while($row = mysql_fetch_array($result))
                 //$row = mysql_fetch_array($result);
Beispiel #3
0
                                                     <?php 
    while ($row = mysql_fetch_array($result_prj)) {
        ?>
                                                    			<tr <?php 
        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 
Beispiel #4
0
                ?>
</td>
                                                                                            </tr>
                                                                                            <?php 
                $s++;
            }
            ?>
		                                         	         
                                                                                        </table>
                                                                                    </td>
                                                                                </tr>
                                                                            </table>
                                                                        </div>
                                                                    </td>
                                                                    <td align="center"><span class="text_1"><?php 
            echo getBuyer('BuyerName', 'rec_id', getDispatchNumber('BuyerId', 'rec_id', $row_1['DispatchNumberId']));
            ?>
</span></td>
                                                                </tr>
																<?php 
        }
        ?>
                                                                <tr>
                                                                    <td align="center" colspan="4">
                                                                        <table align="center" width="100%" border="0" cellpadding="0" cellspacing="0">
                                                                            <tr>
                                                                            <?php 
        $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) {
            while ($row = mysql_fetch_array($result)) {