SitePoint Sponsor

User Tag List

Results 1 to 2 of 2

Threaded View

  1. #1
    SitePoint Guru
    Join Date
    Oct 2011
    Posts
    658
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    insert only items with demanded qty.

    Hi...

    I have form for saving items into database, but I want only insert item with demanded qty.
    here is my code:

    StockRequisition.php
    PHP Code:
    <?php                                                                          
    $con 
    mysql_connect('localhost''root','');

    if (!
    $con) {
        echo 
    'failed';
        die();
    }

    mysql_select_db("mes"$con);
    $sr_date =date('Y-m-d H:i:s');

            
    $sql "SELECT sr_number FROM stock_requisition ORDER BY sr_date DESC LIMIT 1";
            
    $result mysql_query($sql$con);
            
            if (!
    $result) {
                echo 
    'failed'
                die();
            }
            
    $total mysql_num_rows($result);
            if (
    $total <= 0) {
                
    $currentSRNum 1;
                
    $currentYear  = (int)(date('y'));
                
    $currentMonth = (int)(date('m'));
                
    $currentDay = (int)(date('d'));

                
    $currentSRYMD substr($row['sr_number'], 06);
                
    $currentYMD date("ymd");
                if (
    $currentYMD $currentSRYMD
                {  
                    
    $currentSRNum 1;
                } 
                else 
                {  
                    
    $currentSRNum += 1;
                }        
                
            } 
            else {
                
    $row mysql_fetch_assoc($result);
                
                
    $currentSRNum = (int)(substr($row['sr_number'],0,3));
                
                
    $currentSRYear  = (int)(substr($row['sr_number'],2,2));
                
    $currentSRMonth = (int)(substr($row['sr_number'],0,2));
                
    $currentSRNum = (int)(substr($row['sr_number'],6,4));
                
    $currentYear  = (int)(date('y'));
                
    $currentMonth = (int)(date('m'));
                
    $currentDay = (int)(date('d'));

                
    $currentSRYMD substr($row['sr_number'], 06);
                
    $currentYMD date("ymd");
                if (
    $currentYMD $currentSRYMD
                {  
                    
    $currentSRNum 1;
                } 
                else 
                {  
                    
    $currentSRNum += 1;
                }                                           
            }       
            
    $yearMonth date('ymd');    
            
    $currentSR $currentYMD sprintf("%04d"$currentSRNum);   
    ?>
    <html>
    <title>Stock Requisition</title>
    <head>
    <link rel="stylesheet" type="text/css" href="kanban.css">

    <script type="text/javascript">
    function save_sr(){
        var sr_date = document.getElementById("sr_date").value;
        var sr_number = document.getElementById("sr_number").value;
        var Items1 = document.getElementById("Items1").value;
        var SubItems = document.getElementById("SubItems").value;
        var ItemCode = document.getElementById("ItemCode").value;
        var DemandedQty = document.getElementById("DemandedQty").value;
        var UoM = document.getElementById("UoM").value;
        var Class = document.getElementById("Class").value;
        var Description = document.getElementById("Description").value;
        var BINLocation = document.getElementById("BINLocation").value;
        var RequestedBy = document.getElementById("RequestedBy").value;
        var ApprovedBy = document.getElementById("ApprovedBy").value;
        var ReceivedBy = document.getElementById("ReceivedBy").value;
        var IssuedBy = document.getElementById("IssuedBy").value;
        
        document.stock_requisition.action="StockRequisitionSave.php?sr_date="+sr_date+"&sr_number="+sr_number+"&Items1="+Items1+
        "&SubItems="+SubItems+"&ItemCode="+ItemCode+"&DemandedQty="+DemandedQty+"&UoM="+UoM+"&Class="+Class+"&Description="+
        Description+"&BINLocation="+BINLocation+"&RequestedBy="+RequestedBy+"&ApprovedBy="+ApprovedBy+"&ReceivedBy="+ReceivedBy+
        "&IssuedBy="+IssuedBy;
        document.stock_requisition.submit();
        alert("Stock Requisition data save.");
        window.location = "StockRequisition.php";
    }

    </script>
    </head>
    <body>
    <form name="stock_requisition" action="<?php echo $_SERVER['PHP_SELF']; ?>" method="post">
    <div id="SR_date">
    <label>Date :</label>
    <input type="text" name="sr_date" value="<?php echo $sr_date?>">    
    </div>
    <div id="SR_number">
    <label>SR# :</label>
    <input type="text" name="sr_number" value="<?php echo $currentSR?>">
    <br/> 
    </div> 
       <div>
    <table>
    <thead>
    <th>Items</th>
    <th>Sub Items</th>
    <th>Item Code</th>
    <th>Demanded Qty</th>
    <th>UoM</th>
    <th>Class</th>
    <th>Description</th>
    <th>BIN Location</th>
    </thead>
    <?php
    $sql 
    "SELECT DISTINCT Items FROM bom_subitems ORDER BY Items";
    $res_bom mysql_query($sql$con);

    while(
    $row mysql_fetch_assoc($res_bom)){
        
        
    $Items $row['Items'];
    echo 
    "<tr>
            <td style='border: none;font-weight: bold;'>&nbsp;<input type='name' value='
    $Items' name='Items' id='Items'></td>
            </tr>"
    ;       
         
    $sql "SELECT Items, SubItems, ItemCode, UoM, Class, Description, BINLocation FROM bom_subitems WHERE Items = '$Items' ORDER BY Items"or die(mysql_error());

    $res_sub mysql_query($sql$con);  
     
     while(
    $row_sub mysql_fetch_assoc($res_sub)){

         
    $Items1 $row_sub['Items'];
         
    $SubItems $row_sub['SubItems'];
         
    $ItemCode $row_sub['ItemCode'];
         
    $UoM $row_sub['UoM'];
         
    $Class $row_sub['Class'];
         
    $Description $row_sub['Description'];
         
    $BINLocation $row_sub['BINLocation'];         
         
        echo 
    "<tr>
            <td><input type='hidden' value='
    $Items1' id='Items1' name='Items1[]'></td>
            <td><input type='text' name='SubItems[]' value='
    $SubItems' id='SubItems' readonly='readonly' style='border:none;></td>
            <td><input type='text' name='ItemCode[]' value='
    $ItemCode' id='ItemCode' readonly='readonly' style='border:none;></td>
            <td><center><input type='text' name='DemandedQty[]' id='DemandedQty' value='' size='7'></center></td>
            <td><input type='text' name='UoM[]' value='
    $UoM' id='UoM' readonly='readonly' style='border:none;></td>
            <td><input type='text' name='Class[]' value='
    $Class' id='Class' readonly='readonly' style='border:none;></td>
            <td><input type='text' name='Description[]' value='
    $Description' id='Description' readonly='readonly' style='border:none;></td>
            <td><input type='text' name='BINLocation[]' value='
    $BINLocation' id='BINLocation' readonly='readonly' style='border:none;></td>     
            </tr>"
    ;    
            
    }
    }   

    ?>
    </table>
    </div>
    <?php
       $RequestedBy 
    = array('AAA''BBB');
       
       
    $ApprovedBy = array('EEE''FFF');
       
       
    $ReceivedBy = array('III''JJJ');
       
       
    $IssuedBy = array('MMM''NNN'); 

    ?>

     <div id='Requested_By'>
    <label>Requested By:</label>
     <select name="RequestedBy">
     <option value="Select">Select</option>
     <option value="AAA" <?php if($_POST['RequestedBy'] == 'AAA') echo "selected='selected'"?>>AAA</option>
      <option value="BBB" <?php if($_POST['RequestedBy'] == 'BBB') echo "selected='selected'"?>>BBB</option>
     </select>
    </div>

    <div id='Approved_By'>
    <label>Approved By:</label>
    <select name="ApprovedBy">
    <option name='Select'>Select</option>
    <option value="EEE" <?php if($_POST['ApprovedBy'] == 'EEE') echo "selected='selected'"?>>EEE</option>
      <option value="FFF" <?php if($_POST['ApprovedBy'] == 'FFF') echo "selected='selected'"?>>FFF</option>
    </select>
    </div>

    <div id='Received_By'>
    <label>Issued By:</label>
    <select name="IssuedBy">
    <option name='Select'>Select</option>
    <option value="III" <?php if($_POST['ReceivedBy'] == 'III') echo "selected='selected'"?>>III</option>
      <option value="JJJ" <?php if($_POST['ReceivedBy'] == 'JJJ') echo "selected='selected'"?>>JJJ</option>
    </select>
    </div>

    <div id='Issued_By'>
    <label>Received By:</label>
    <select name="ReceivedBy">
    <option name='Select'>Select</option>
    <option value="MMM" <?php if($_POST['IssuedBy'] == 'MMM') echo "selected='selected'"?>>MMM</option>
      <option value="NNN" <?php if($_POST['IssuedBy'] == 'NNN') echo "selected='selected'"?>>NNN</option>
    </select>
    </div>

    <div id="save_btn">
    <input type="button" name="button" value="save" onClick="save_sr()" style="width: 5em;">
    </div>
    </form>
    </body>
    </html>
    and here is my database:

    PHP Code:
    <?php                                                                          
     
    $con 
    mysql_connect('localhost''root','');

    if (!
    $con) {
        echo 
    'failed';
        die();
    }

    mysql_select_db("mes"$con);
    $sr_date $_POST['sr_date'];
    $sr_number $_POST['sr_number'];
    $Items1 $_POST['Items1'];
    $SubItems $_POST['SubItems'];
    $ItemCode $_POST['ItemCode'];
    $DemandedQty $_POST['DemandedQty'];
    $UoM $_POST['UoM'];
    $Class $_POST['Class'];
    $Description $_POST['Description'];
    $BINLocation $_POST['BINLocation'];
    $RequestedBy $_POST['RequestedBy'];
    $ApprovedBy $_POST['ApprovedBy'];
    $ReceivedBy $_POST['ReceivedBy'];
    $IssuedBy $_POST['IssuedBy'];

    for(
    $i 0$i count($Items1); $i++) 

        
    $sql "INSERT INTO stock_requisition 
        (sr_date, sr_number, Items, SubItems, ItemCode, DemandedQty, UoM, Class, Description, BINLocation, RequestedBy, 
        ApprovedBy, ReceivedBy, IssuedBy) 
        VALUES 
        ('
    $sr_date', '$sr_number', '$Items1[$i]', '$SubItems[$i]', '$ItemCode[$i]', '$DemandedQty[$i]', '$UoM[$i]', '$Class[$i]', '$Description[$i]', 
        '
    $BINLocation[$i]', '$RequestedBy', '$ApprovedBy', '$ReceivedBy', '$IssuedBy') 
        "
    ;   

        
    $result mysql_query($sql$con);          
    }                
    ?>
    I attach my sample form.
    I need to save only the P28.. I just want to save only item with data in demanded quantity

    Thank you
    Attached Images Attached Images


Bookmarks

Posting Permissions

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