Results 1 to 3 of 3

Thread: Need help in using setFilterGrid with adding the total quantity

Hybrid View

  1. #1
    Join Date
    Oct 2011

    Need help in using setFilterGrid with adding the total quantity


    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:
    <title>Raw Materials Inventory</title>
    <link rel="stylesheet" type="text/css" href="css/kanban.css" />
    <script language="javascript" type="text/javascript" src="tablefilter.js"></script>  
    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;
    $current = "in";
    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>Item Code</th>
    <th>WH Location</th>
    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>";
    <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"]

    Thank you so much

  2. #2
    Join Date
    Jun 2004
    Portsmouth UK
    you will need to post a link to your page

    God loves you and will never love you less.

    If my post has been useful please donate to http://www.operationsmile.org.uk/

  3. #3
    Join Date
    Oct 2011

    Sorry, but my page is not in online..it is intranet.

    Thank you

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
HTML5 Development Center