newphpcoder 9 Posted March 18, 2013 Report Share Posted March 18, 2013 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. Quote Link to post Share on other sites
justsomeguy 1,135 Posted March 18, 2013 Report Share Posted March 18, 2013 You'll need to edit the code inside tablefilter.js if it doesn't already have a feature to do that. Quote Link to post Share on other sites
newphpcoder 9 Posted March 20, 2013 Author Report Share Posted March 20, 2013 Hi..I found code that has a sum below from this link :http://tablefilter.free.fr/ex.php#tbl9Sample Table 7: <script language="javascript" type="text/javascript">//<![CDATA[var totRowIndex = tf_Tag(tf_Id('table7'),"tr").length; var table7_Props = { rows_counter: true, loader: true, loader_text: "Filtering data...", col_operation: { id: ["table8Tot1","table8Tot2"], col: [2,4], operation: ["sum","sum"], write_method: ["innerHTML","setValue"], exclude_row: [totRowIndex], decimal_precision: [1,0] }, rows_always_visible: [totRowIndex] };var tf7 = setFilterGrid( "table7",table7_Props );//*** Note ***//You can also write operation results in elements outside the table. //]]></script> Honestly, I cannot understand the whole code because it has no html code or sample code of table.So it's to hard for me to adopt that code in my present code: <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><!--<div id="ddcolortabs"><ul><li> <a href="SalesOrder.php" title="Sales Order"><span>Order Management</span></a></li> <li> <a href="ParameterSettings.php" title="Parameter Settings"><span>Parameter Settings</span></a></li><li style="margin-left: 1px"><a href="kanban_report.php" title="WIP Report"><span>Wip Report</span></a></li><li><a href="fsn.php" title="Finished Stock Note"><span>WMS FG</span></a></li><li id="current"><a href="ReceivingMaterials.php" title="WMS RM"><span>WMS RM</span></a></li><li><a href="StockRequisition1.php" title="Stock Requisition"><span>Stock Requisition</span></a></li> <li><a href="calendar_days.php" title="Calendar Days"><span>Calendar Days</span></a></li></ul></div>--><div id="ddcolortabs1"><ul><li><a href="ReceivingMaterials.php" title="Raw Materials"><span>Raw Materials</span></a></li><li><a href="Shelving.php" title="Shelving"><span>Shelving</span></a></li><li><a href="Picking.php" title="Picking"><span>Picking</span></a></li><li><a href="Issuance.php" title="Issuance"><span>Issuance</span></a></li><li id="current"><a href="wmsinventory.php" title="Inventory"><span>Inventory</span></a></li</ul></div><div style='clear: both;'> </div><div style='clear: both;'> </div><table id='inventory'><tr class='yellow'><th>Component</th><th>Item Code</th><th>Description</th><th>WH Location</th><th>UoM</th><th>Quantity</th></tr><tr><td>Chemicals</td><td>MAT-CHE-0010</td><td>Barium Sulfate, 25kg./bag</td><td>WAREHOUSE 1</td><td>kg</td><td>200</td></tr><tr><td>Chemicals</td><td>MAT-CHE-0075 </td><td>Kaolin Clay</td><td>WAREHOUSE 1</td><td>kg</td><td>200</td></tr><tr><td>Chemicals</td><td>MAT-CHE-0080</td><td>Light Magnesium Carbonate</td><td>WAREHOUSE 2</td><td>kg</td><td>325</td></tr><tr><td>Chemicals</td><td>MAT-CHE-0080</td><td>Light Magnesium Carbonate</td><td>WAREHOUSE 2</td><td>kg</td><td>250</td></tr><tr><td>Ringpull</td><td>PAC-EZO-0050</td><td>Ringpull, SONOCO 300dia; EOE part # 115-0356-56</td><td>WAREHOUSE 2</td><td>pc</td><td>151800</td></tr><tr><td>Sticker</td><td>PAC-STK-0080A</td><td>Blank Label Sticker, 3"X4",sheet form (additional carton label for SHIREBROOK order)</td><td>WAREHOUSE 3</td><td>pc</td><td>464</td></tr><tr><td>Tin Can/PET/P-bag</td><td>PAC-PET-0000</td><td>PET 3B-DSPI</td><td>WAREHOUSE 1</td><td>pc</td><td>94500</td></tr></table><table id=''></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> I hope somebody can help me. To merge the two javascript. So that after I filter the Item Code below the Quantiy will display the SUM.Thank you so much Quote Link to post Share on other sites
justsomeguy 1,135 Posted March 20, 2013 Report Share Posted March 20, 2013 All of the examples on that page use the same table shown at the top. It looks like the col_operation property is used to set up calculation rows. It's listed in the documentation under filter grid bar behaviors. http://tablefilter.free.fr/doc.php Quote Link to post Share on other sites
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.