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:

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;'>&nbsp;</div><div style='clear: both;'>&nbsp;</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.