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


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



require_once(INCLUDES_DIR.ADMHEADER); 
?>
<table border="0" cellspacing="0" cellpadding="0">
  <tr>
    <td height="29" align="center" class="submenu"><a href="enquiries.php">Enquiries</a></td>
    <td align="center" class="submenu"><a href="contactus.php">Contact Us</a></td>
	<td align="center" class="submenu">Expert Help</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">
          <tr>
            <td width="315" height="35">View Expert Help</td>
            </tr>
        </table></td>
      </tr>
      <tr>
        <td valign="top" bgcolor="#FFFFFF" class="innermain"><table width="800" border="0" align="center" cellpadding="0" cellspacing="0">
          <tr>
            <td height="25">&nbsp;</td>
          </tr>
          <tr>
            <td valign="top" class="bdr4"><table width="800" border="0" cellspacing="0" cellpadding="0">
              <tr>
                <td bgcolor="#990066" class="form_head">Requirement Details</td>
                </tr>
              <tr>
                <td valign="top" class="form_bg"><table  width="500" class="form_txt1" border="0" cellspacing="0" cellpadding="0">
   <tr>
     <td>
       <table width="100%" border="0" cellspacing="0" cellpadding="0">
       		<tr>
	          <td width="25%" class="contain"><b>Commodity</b></td> 
	          <td width="65%" class="contain"><?php echo $row['commodity'] ?></td>
	       </tr>
	       <tr>
	          <td class="contain"><b>Origin</b></td> 
	          <td class="contain"><?php echo $row['origin'] ?></td>
	       </tr>
	       <tr>
	          <td class="contain"><b>Location</b></td> 
	          <td class="contain"><?php if($row['commodity'] == 'Coal') { echo ($row['origin']=='Indian')?$row['area']:$row['port']; } else { echo ($row['origin']=='Indian')?$row['noncoal_state']:$row['noncoal_state'].' ('.$row['noncoal_port'].')'; }?></td>
	       </tr>
		   <tr>
	          <td class="contain"><b>Sub Location</b></td> 
	          <td class="contain"><?php if($row['commodity'] == 'Coal') {  if($row['origin']=='Indian') { echo $row['mines_name']; } } else { echo ($row['origin']=='Indian')?$row['noncoal_district']:$row['noncoal_district']; }?></td>
	       </tr>
	       <tr>
	          <td class="contain"><b>Size</b></td> 
	          <td class="contain"><?php echo $row['size'] ?></td>
	       </tr>
	       <tr>
	          <td class="contain"><b>Gross Calorific Value(A.D.Basis)</b></td> 
	          <td class="contain"><?php echo $row['gcv'] ?></td>
	       </tr>
	       <tr>
	          <td class="contain"><b>Total Moisture(A.R.Basis)</b></td> 
	          <td class="contain"><?php echo $row['tm'] ?></td>
	       </tr>
	       <tr>
	          <td class="contain"><b>ASH(A.D.Basis)</b></td> 
	          <td class="contain"><?php echo $row['ash'] ?></td>
	       </tr>
	       <tr>
	          <td class="contain"><b>Sulphur</b></td> 
	          <td class="contain"><?php echo $row['sulpher'] ?></td>
	       </tr>
	       <tr>
	          <td class="contain"><b>Supply Destination</b></td> 
	          <td class="contain"><?php echo $row['supply_destination'] ?></td>
	       </tr>
	      
	</table>
  </td>
</tr>
	       <p>&nbsp;</p>
</table>
</td>
              </tr>
              <tr>
                <td bgcolor="#990066" class="form_head">Contact Details</td>
              </tr>
              <tr>
                <td valign="top" class="form_bg"><table width="500" border="0" cellpadding="0" cellspacing="0" class="form_txt1">
                  <tr>
                    <td align="left" width="30">Name</td>
                    <td align="center" width="5">:</td>
                    <td align="left"><? echo $row['name'];?></td>
                    </tr>
                  <tr>
                    <td align="left">Mobile / Phone</td>
                    <td align="center" width="5">:</td>
			<td align="left"><? echo $row['contact'];?></td>
                  </tr>
                  <tr>
                    <td align="left">Address</td>
                    <td align="center" width="5">:</td>
			<td align="left"><? echo $row['address'];?></td>
                  </tr>
				  <tr>
                    <td align="left">email</td>
                    <td align="center" width="5">:</td>
			<td align="left"><? echo $row['email'];?></td>
                  </tr>
				  <tr>
                    <td align="left">comment</td>
                    <td align="center" width="5">:</td>
			<td align="left"><? echo $row['comment'];?></td>
                  </tr>
				   <tr>
                    <td align="left">Date</td>
                    <td align="center" width="5">:</td>
			<td align="left"><? echo $row['date'];?></td>
                  </tr>
                </table></td>
              </tr>
              <tr>
                <td bgcolor="#990066" class="form_head">&nbsp;</td>
              </tr>
              </table></td>
          </tr>
          </table></td>
      </tr>
      </table></td>
  </tr>
  <tr>
    <td height="40">&nbsp;</td>
  </tr>
</table>

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