Code:
<?php
$current = "in";
include("menu.php");
echo "<div style='clear: both;'> </div><div style='clear: both;'> </div>";
$result = mysql_query("SELECT s.bin_location, s.shelved_qty, s.issued_qty, r.wh_code, m.component, m.mat_code, m.description, m.uom FROM wms_shelving AS s LEFT JOIN wms_receiving AS r ON s.rm_id = r.rm_id LEFT JOIN bom_material AS m ON r.uid_mat = m.uid_mat WHERE s.shelved_qty > s.issued_qty OR ISNULL(s.issued_qty) ORDER BY m.component, m.mat_code");
/*
echo "\n<table id= 'inventory'>";
echo "\n\t<tr class=\"yellow\">\n\t\t<th>Component</th>\n\t\t<th>Item Code</th>\n\t\t<th>Description</th>\n\t\t<th>Bin Location</th>\n\t\t<th>UoM</th>\n\t\t<th>Quantity</th>\n\t</tr>";
while($row = mysql_fetch_array($result))
{
echo "\n\t<tr>";
echo "\n\t\t<td>" . $row["component"] . "</td>";
echo "\n\t\t<td>" . $row["mat_code"] . "</td>";
echo "\n\t\t<td>" . $row["description"] . "</td>";
echo "\n\t\t<td>" . $row["bin_location"] . "</td>";
echo "\n\t\t<td>" . $row["uom"] . "</td>";
$remaining_qty = $row["shelved_qty"] - $row["issued_qty"];
echo "\n\t\t<td>" . $remaining_qty . "</td>";
echo "\n\t</tr>";
}
echo "\n</table>";
*/
echo "<table id='inventory'>";
echo "<tr class='yellow'>
<th>Component</th>
<th>Item Code</th>
<th>Description</th>
<th>WH Location</th>
<th>UoM</th>
<th>Quantity</th>
</tr>";
while($row = mysql_fetch_array($result))
{
$component = $row['component'];
$itemcode = $row['mat_code'];
$description = $row['description'];
$wh_location = $row['bin_location'];
$uom = $row['uom'];
$remaining_qty = $row["shelved_qty"] - $row["issued_qty"];
// $quantity = $row['remaining_qty'];
echo "<tr>";
echo "<td>$component</td>";
echo "<td>$itemcode</td>";
echo "<td>$description</td>";
echo "<td>$wh_location</td>";
echo "<td>$uom</td>";
echo "<td>$remaining_qty</td>";
echo "</tr>" ;
}
echo "</table>";
?>
</form>
<script language="javascript" type="text/javascript">
var fnsFilters = {
sort_select: true,
loader: true,
col_5: "none",
col_4: "none",
col_3: "select",
col_2: "none",
col_1: "select",
col_0: "select",
on_change: true,
display_all_text: "Filter",
rows_counter: false,
btn_reset: false,
alternate_rows: false,
btn_reset_text: "Display Existing Item Code",
col_width: ["auto","auto","auto", "auto", "auto", "auto"]
}
setFilterGrid("inventory",fnsFilters);
</script>
</body>
</html>
Comment