www.webdeveloper.com
Results 1 to 3 of 3

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

  1. #1
    Join Date
    Oct 2011
    Posts
    350

    Need help in using setFilterGrid with adding the total quantity

    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;'>&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>

    Thank you so much

  2. #2
    Join Date
    Jun 2004
    Location
    Portsmouth UK
    Posts
    2,669
    you will need to post a link to your page
    Vic

    God loves you and will never love you less.

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

  3. #3
    Join Date
    Oct 2011
    Posts
    350
    Hi

    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



Recent Articles