Hi…
Good day!
I already had codes on setFilterGrid on my table, now I need to add the total qty at the row which is i don’t have any idea if it is possible using javascript and how. I want to happen is every time I filter the item code the Quantity will SUM and display on the last row.
here is my code:
<?php
include('connection.php');
?>
<html>
<title>Raw Materials Inventory</title>
<head>
<link rel="stylesheet" type="text/css" href="css/kanban.css" />
<script language="javascript" type="text/javascript" src="tablefilter.js"></script>
<style>
table {
font: 14px/28px Verdana, Arial, Helvetica, sans-serif;
border-collapse: collapse;
}
th {
padding: 0 0.6em;
text-align: left;
}
tr.yellow th {
border-top: 1px solid #FB7A31;
border-bottom: 1px solid #FB7A31;
background: #FFC;
}
td {
border-bottom: 1px solid #CCC;
padding: 0 0.6em;
}
td+td {
border-left: 1px solid #CCC;
text-align: center;
}
</style>
</head>
<body>
<form>
<?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 "<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"];
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>
Any help is highly appreciated.
Thank you so much.