<?php
require_once('../config/config.php');
require_once(CLASS_DIR.'dbClass.php');
$obj = new DBClass();
$cupage = 'customer_enquiry';


$sql = "SELECT * FROM coal_listing WHERE id ='".$_GET['listingID']."'";
$rs = $obj->executeQry($sql,$link);
$row = $obj->fetchrow();

$dat = explode('-', $row['ondate']);
$dat = $dat[1].'-'.$dat[2].'-'.$dat[0];
require_once(INCLUDES_DIR.ADMHEADER); 
?>
<table border="0" cellspacing="0" cellpadding="0">

  <tr>

    <td height="29" align="center" class="submenu"><a href="customer_enquiry.php">Manage Customer Enquiry</a></td>

    <td align="center" class="submenu"><a href="search_by_company.php">Select By Comapny Name</a></td>

  </tr>

</table>

<table width="1000" border="0" cellspacing="0" cellpadding="0">

  <tr>

    <td height="17"></td>

  </tr>

  <tr>

    <td><table width="910" border="0" align="center" cellpadding="0" cellspacing="0">

      <tr>

        <td class="pagehead"><table width="900" border="0" cellspacing="0" cellpadding="0">

  

        </table></td>

      </tr>

      <tr>

        <td valign="top" bgcolor="#FFFFFF"><table width="800" border="0" align="center" cellpadding="0" cellspacing="0">


 <table width="100%" border="0" align="center" cellpadding="0" cellspacing="0">
                        <tr>
                            <td valign="top" class="bdr4">
                                <table width="100%" border="0" cellspacing="0" cellpadding="0">
                                    <tr>
                                        <td width="100%" height="35" class="pagehead">Manage Customer Enquiry</td>
                                    </tr>
                                    <tr>
                                        <td bgcolor="#990066" class="form_head">Supplier Details</td>
                                    </tr>
                                    <tr>
                                        <td valign="top" class="form_bg">
                                            <table width="100%" border="0" cellpadding="0" cellspacing="0" class="userdetails">
                                                <tr>
                                                    <td width="14%"><strong>Name :</strong> </td>
                                                    <td width="35%"><?php echo $row['person_name'].'('.$row['organisation_name'].')';?></td>
                                                    <td width="2%">&nbsp;</td>
                                                    <td width="14%"><strong>Address:</strong></td>
                                                    <td width="35%"><?php echo $row['address'] ?></td>
                                                </tr>
                                                <tr>
                                                    <td><strong>Email :</strong> </td>
                                                    <td><?php echo $row['email1'];?></td>
                                                    <td>&nbsp;</td>
                                                    <td><strong>City :</strong></td>
                                                    <td><?php echo $row['city'];?></td>
                                                </tr>
                                                <tr>
                                                    <td><strong>Phone :</strong> </td>
                                                    <td><?php echo $row['phone'];?></td>
                                                    <td>&nbsp;</td>
                                                    <td><strong>State :</strong></td>
                                                    <td><?php echo $row['state'];?></td>
                                                </tr>
                                                <tr>
                                                     <td><strong>Fax :</strong> </td>
                                                     <td><?php echo $row['fax'];?></td>
                                                     <td>&nbsp;</td>
                                                     <td><strong>Country:</strong></td>
                                                     <td><?php echo $row['country'];?></td>
                                                </tr>
                                                <tr>
                                                     <td><strong>Zip Code :</strong></td>
                                                     <td><?php echo $row['pincode'];?></td>
                                                     <td>&nbsp;</td>
                                                     <td><strong>CRN# :</strong></td>
                                                     <td><?php echo $row2['crn'];?></td>
                                                </tr>
    
                                            </table>
			                             </td>
                                    </tr>
                                     <tr>
                                        <td bgcolor="#990066" class="form_head">Product Details</td>
                                     </tr>
                                     <tr>
                                        <td valign="top" class="form_bg">
                                            <table width="100%" class="userdetails">
                                              <tr>
                                                <td width="20%"><b>Commodity : </b></td>
                                                <td width="30%"><?php echo $row['commodity'] ?></td>
                                                <td width="2%">&nbsp;</td>
                                                <td width="18%"><b>Origin : </b></td>
                                                <td width="30%"><?php echo $row['origin'] ?></td>
                                              </tr>
                                              <tr>
                                                <td><b>Area : </b></td>
                                                <td><?php echo $row['area'] ?></td>
                                                <td>&nbsp;</td>
                                                <td><b>Size : </b></td>
                                                <td><?php echo $row['size'] ?></td>
                                              </tr>
                                              <tr>
                                                <td><b>GCV :</b> </td>
                                                <td><?php echo $row['gcv'] ?></td>
                                                <td>&nbsp;</td>
                                                <td><b>TM : </b></td>
                                                <td><?php echo $row['tm'] ?></td>
                                              </tr>
                                              <tr>
                                                <td><b>ASH : </b></td>
                                                <td><?php echo $row['ash'] ?></td>
                                                <td>&nbsp;</td>
                                                <td><b>Sulpher : </b></td>
                                                <td><?php echo $row['sulpher'] ?></td>
                                              </tr>
                                              <tr>
                                                <td><b>Port : </b></td>
                                                <td><?php echo $row['port'] ?></td>
                                                <td>&nbsp;</td>
                                                <td><b>Base Rate :</b> </td>
                                                <td><?php echo $row['base_rate'] ?></td>
                                              </tr>
                                              <tr>
                                                <td><b>Order Date : </b></td>
                                                <td><?php echo date("d-m-Y",strtotime($row['added_on'])); ?></td>
                                                <td>&nbsp;</td>
                                                <td><b>Activated On : </b></td>
                                                <td><?php echo date("d-m-Y",strtotime($row['actdate'])); ?></td>
                                              </tr>
                                            </table>
                                        </td>
                                     </tr>
                                     <tr>
                                        <td bgcolor="#990066" class="form_head">&nbsp;</td>
                                     </tr>
                                </table>
                            </td>
                        </tr>
                    </table>
      </table></td>

  </tr>

  <tr>

    <td>&nbsp;</td>

  </tr>

</table>


<?php require_once(INCLUDES_DIR.ADMFOOTER); ?>
