I created picking module and now I need help in subtract/minus Demanded Qty to the Qty from the wms table based on the lot number selected and it will happen only when the checkbox was check.
Here is the flow:
- Select SR #
- After Select SR # data will display below
- Choose Lot Number
- Check the beside textbox to subtract/minus the demanded qty to the lot number qty from wms table
- When the check box was check and after subtract the select option will be only display the lot number you selected.
I am new in using checkbox.
Here is my code:
<?php error_reporting(0); date_default_timezone_set("Asia/Singapore"); //set the time zone $con = mysql_connect('localhost', 'root',''); if (!$con) { echo 'failed'; die(); } mysql_select_db("mes", $con); $Date_Shelve =date('Y-m-d H:i:s'); ?> <html> <title>Picking</title> <head> <link href="kanban.css" rel="stylesheet" type="text/css"> <script type="text/javascript"> function get_option(elm){ var elm = document.getElementById('sr_number'); sr_number = elm.options[elm.selectedIndex].value; document.picking_form.action="Picking.php?sr_number="+sr_number; document.picking_form.submit(); } </script> </head> <body> <div id="SR_date"> <label>Date :</label> <input type="text" name="date_pick" value="<?php echo $Date_Shelve; ?>" size="16" readonly="readonly" style="border: none;"> </div> <div id="Picking"> <label class="LLabellot">Select SR # :</label> <?php $query = "SELECT DISTINCT m.sr_number FROM sr_main m JOIN sr_submain s ON (m.sr_number = s.sr_number) ORDER BY sr_number"; $rows = mysql_query($query, $con); echo "<select name = 'sr_number' onchange='get_option();'>"; echo "<option> Select </option>"; while ($record = mysql_fetch_array($rows)) { echo "<option value = '{$record['sr_number']}'"; if ($lot_number == $record['sr_number']) echo "selected = 'selected'"; echo ">{$record['sr_number']}</option>"; } echo "</select>"; echo "<br/><br/>"; $sr_number = $_POST['sr_number']; $sql = "SELECT sr_number, Items, DemandedQty, uom FROM sr_main WHERE sr_number = '$sr_number'"; $res_sr_main = mysql_query($sql, $con); $row_num = mysql_num_rows($res_sr_main); if($row_num > 0){ while($row_sr_main = mysql_fetch_assoc($res_sr_main)){ $sr_number = $row_sr_main['sr_number']; $items = $row_sr_main['Items']; $demandedqty = $row_sr_main['DemandedQty']; $uom = $row_sr_main['uom']; echo "<form name='picking_form' action='' method='post'> "; echo "<label> SR # :</label>"; echo $sr_number; echo "<table>"; echo "<th>Items</th> <th> Item Code </th> <th> Demanded Qty </th> <th> UoM </th> <th> Description </th> <th> Lot Number </th> <th> Approve</th>"; echo "<tr> <td>$items</td> <td></td> <td style='text-align:right;'>$demandedqty</td> <td>$uom</td> </tr>"; $sql_sub = "SELECT sr_number, Items, ItemCode, SubQty, UoM, Description FROM sr_submain WHERE sr_number = '$sr_number' and Items = '$items'"; $res_sub = mysql_query($sql_sub, $con); while($row_sub = mysql_fetch_assoc($res_sub)){ $sr_num = $row_sub['sr_number']; $Items = $row_sub['Items']; $ItemCode = $row_sub['ItemCode']; $SubQty = $row_sub['SubQty']; $UoM = $row_sub['UoM']; $Description = $row_sub['Description']; $query = "SELECT lot_number from wms WHERE (date_shelve IS NOT NULL) ORDER BY lot_number"; $rows = mysql_query($query, $con); echo "<tr> <td></td> <td>$ItemCode</td> <td style='text-align:right;'>$SubQty</td> <td>$UoM</td> <td>$Description</td>"; echo "<td><select name = 'lot_number'>"; echo "<option> Select </option>"; while ($record = mysql_fetch_array($rows)) { echo "<option value = '{$record['lot_number']}'"; if ($lot_number == $record['lot_number']) echo "selected = 'selected'"; echo ">{$record['lot_number']}</option>"; } echo "</select>"; echo "<td><input type='checkbox' name='chk' value=''></td> </tr>"; } } } ?> </div> </form> </body> </html>
Thank you so much