<?php 
$PageSecurity = 4;
include('includes/session.inc');
include('includes/DefineSuppTransClass.php');

$locations = DB_query("SELECT * FROM locations where loccode='".$_REQUEST['q']."'",$db);
$data1= "";
$data2="";
$data1.="<select name='site_code' id='site_code' style='width:90%'>";
			while($loc_row=DB_fetch_array($locations)){
				$data1.="<option value='".$loc_row['loccode']."'>".$loc_row['loccode']."</option>";
			 }
		$data1.="</select>";
//echo "SELECT * FROM purchase WHERE site='".$_REQUEST['q']."'";
$requisitionno = DB_query("SELECT * FROM purchase",$db);
//$requisitionno = DB_query("SELECT * FROM materialrequisitions",$db);
$data2.="<select name='pr_no' id='pr_no' style='width:90%' value='' onChange= 'GetDate(this.value)'>";
$data2.="<option value=''>--Select--</option>";
		while($site_row=DB_fetch_array($requisitionno)){
			$data2.="<option value='".$site_row['id']."'>".$site_row['req_number']."</option>";
		}
$data2.="</select>";
echo $data=$data1."__".$data2;
?>

<table width="100%" border="1" cellpadding="3" cellspacing="0" style="border-collapse:collapse; border:#666666 solid 1px;">
  <tr>
    <td colspan="9" class="tabledata">Period Wise</td>
  </tr>
  <tr>
    <td class="tabledata">S. No.</td>
    <td class="tabledata">Date</td>
    <td class="tabledata">TT No.</td>
    <td class="tabledata">Party Name</td>
    <td class="tabledata">Product Name</td>
    <td class="tabledata">Invoice No.</td>
    <td class="tabledata">Fault Details</td>
    <td class="tabledata">Scope of service</td>
    <td class="tabledata">Technician</td>
    <td class="tabledata">Current Status</td>
  </tr>
  <tr>
    <td class="tabledata">&nbsp;</td>
    <td class="tabledata">&nbsp;</td>
    <td class="tabledata">&nbsp;</td>
    <td class="tabledata">&nbsp;</td>
    <td class="tabledata">&nbsp;</td>
    <td class="tabledata">&nbsp;</td>
    <td class="tabledata">&nbsp;</td>
    <td class="tabledata">&nbsp;</td>
    <td class="tabledata">&nbsp;</td>
  </tr>
</table>
