Hi
Good day!
I have form created that I used setFilterGrid in my table, so that I can easily filter the data.
Now Every time I filter the item code I need to sum all the quantity , same with if I filter the item code and wh location it also sum the quantiy. Is it possible in javascript?
Here is my code:
HTML 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>
Thank you so much
Reply With Quote
Bookmarks