SitePoint Sponsor

User Tag List

Results 1 to 2 of 2
  1. #1
    SitePoint Guru
    Join Date
    Oct 2011
    Posts
    657
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Problem in If condition

    Hi..

    I tried this code:

    Code:
    <?php
         error_reporting(0);
       date_default_timezone_set("Asia/Singapore"); //set the time zone  
    $con = mysql_connect('localhost', 'root','');
      mysql_select_db("mes", $con); 
    if (!$con) {
        echo 'failed';
        die();
    }
    
    $sql = "SELECT PCODE, total FROM kanban_checker ORDER BY PCODE";
    $res = mysql_query($sql, $con) or die(mysql_error());
    
    while($row = mysql_fetch_assoc($res)){
        $PCODE = $row['PCODE'];
        $total = $row['total'];
    }
      $sql = "SELECT 
                    P28, P28_max, P28_min,
                    P30, P30_max, P30_min,
                    P32, P32_max, P32_min,
                    P33, P33_max, P33_min,
                    P35, P35_max, P35_min,
                    P35M, P35M_max, P35M_min,
                    P35W, P35W_max, P35W_min,
                    P38, P38_max, P38_min,
                    P41, P41_max, P41_min,
                    P42, P42_max, P42_min,
                    P43, P43_max, P43_min,
                    P46, P46_max, P46_min
                    FROM parameter_settings";
            $res_pcode = mysql_query($sql, $con);
            
      $row = mysql_fetch_assoc($res_pcode);
                $P28 = $row['P28'];
                $P28_max = $row['P28_max'];
                $P28_min = $row['P28_min'];
            
                $P30 = $row['P30'];
                $P30_max = $row['P30_max'];
                $P30_min = $row['P30_min'];
                
                $P32 = $row['P32'];
                $P32_max = $row['P32_max'];
                $P32_min = $row['P32_min'];
                
                $P33 = $row['P33'];
                $P33_max = $row['P33_max'];
                $P33_min = $row['P33_min'];
                
                $P35 = $row['P35'];
                $P35_max = $row['P35_max'];
                $P35_min = $row['P35_min'];
               
                $P35M = $row['P35M'];
                $P35M_max = $row['P35M_max'];
                $P35M_min = $row['P35M_min'];
                
                $P35W = $row['P35W'];
                $P35W_max = $row['P35W_max'];
                $P35W_min = $row['P35W_min'];
                
                $P38 = $row['P38'];
                $P38_max = $row['P38_max'];
                $P38_min = $row['P38_min'];
                
                $P41 = $row['P41'];
                $P41_max = $row['P41_max'];
                $P41_min = $row['P41_min'];
                
                $P42 = $row['P42'];
                $P42_max = $row['P42_max'];
                $P42_min = $row['P42_min'];
                
                $P43 = $row['P43'];
                $P43_max = $row['P43_max'];
                $P43_min = $row['P43_min'];
                
                $P46 = $row['P46'];
                $P46_max = $row['P46_max'];
                $P46_min = $row['P46_min'];
                
                $P47 = $row['P47'];
                $P47_max = $row['P47_max'];
                $P47_min = $row['P47_min'];             
           if($PCODE = $P28 || $total = $P28_min){
                echo $P28_min;
            }
            elseif($PCODE = $P30 || $total = $P30_min){
                echo $P30_min;
            }
            elseif($PCODE = $P32 || $total = $P32_min){
                echo $P32_min;
            }
            elseif($PCODE = $P33 || $total = $P33_min){
                echo $P33_min;
            }
            elseif($PCODE = $P35 || $total = $P35_min){
                echo $P35_min;
            }
            elseif($PCODE = $P35M || $total = $P35M_min){
                echo $P35M_min;
            }
            elseif($PCODE = $P35W || $total = $P35W_min){
                echo $P35W_min;
            }
            elseif($PCODE = $P38 || $total = $P38_min){
                echo $P38_min;
            }
            elseif($PCODE = $P41 || $total = $P41_min){
                echo $P41_min;
            }
            elseif($PCODE = $P42 || $total = $P42_min){
                echo $P42_min;
            }
            elseif($PCODE = $P43 || $total = $P43_min){
                echo $P43_min;
            }
            elseif($PCODE = $P46 || $total = $P46_min){
                echo $P46_min;
            }
            elseif($PCODE = $P47 || $total = $P47_min){
                echo $P47_min;
            }
            else{
                echo '';
            }
    ?>
    for display data if total = min.

    The problem is, in this condition he satisfied if condition even though $total is not equal to $P28_min.

    Thank you

  2. #2
    SitePoint Guru
    Join Date
    Oct 2011
    Posts
    657
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Hi..

    I resolved my issue when i revise my code:

    Code:
    $sql = "SELECT PCODE, total FROM kanban_checker ORDER BY PCODE";
    $res = mysql_query($sql, $con) or die(mysql_error());
    
    while($row = mysql_fetch_assoc($res)){
        $PCODE = $row['PCODE'];
        $total = $row['total'];
      $sql = "SELECT 
                    P28, P28_max, P28_min,
                    P30, P30_max, P30_min,
                    P32, P32_max, P32_min,
                    P33, P33_max, P33_min,
                    P35, P35_max, P35_min,
                    P35M, P35M_max, P35M_min,
                    P35W, P35W_max, P35W_min,
                    P38, P38_max, P38_min,
                    P41, P41_max, P41_min,
                    P42, P42_max, P42_min,
                    P43, P43_max, P43_min,
                    P46, P46_max, P46_min,
                    P47, P47_max, P47_min
                    FROM parameter_settings";
            $res_pcode = mysql_query($sql, $con);
            
      $row = mysql_fetch_assoc($res_pcode);
                $P28 = $row['P28'];
                $P28_max = $row['P28_max'];
                $P28_min = $row['P28_min'];
            
                $P30 = $row['P30'];
                $P30_max = $row['P30_max'];
                $P30_min = $row['P30_min'];
                
                $P32 = $row['P32'];
                $P32_max = $row['P32_max'];
                $P32_min = $row['P32_min'];
                
                $P33 = $row['P33'];
                $P33_max = $row['P33_max'];
                $P33_min = $row['P33_min'];
                
                $P35 = $row['P35'];
                $P35_max = $row['P35_max'];
                $P35_min = $row['P35_min'];
               
                $P35M = $row['P35M'];
                $P35M_max = $row['P35M_max'];
                $P35M_min = $row['P35M_min'];
                
                $P35W = $row['P35W'];
                $P35W_max = $row['P35W_max'];
                $P35W_min = $row['P35W_min'];
                
                $P38 = $row['P38'];
                $P38_max = $row['P38_max'];
                $P38_min = $row['P38_min'];
                
                $P41 = $row['P41'];
                $P41_max = $row['P41_max'];
                $P41_min = $row['P41_min'];
                
                $P42 = $row['P42'];
                $P42_max = $row['P42_max'];
                $P42_min = $row['P42_min'];
                
                $P43 = $row['P43'];
                $P43_max = $row['P43_max'];
                $P43_min = $row['P43_min'];
                
                $P46 = $row['P46'];
                $P46_max = $row['P46_max'];
                $P46_min = $row['P46_min'];
                
                $P47 = $row['P47'];
                $P47_max = $row['P47_max'];
                $P47_min = $row['P47_min'];             
           if($PCODE == $P28 && $total == $P28_min){
                echo $P28_min;
            }
            
           else{
               echo '';
           }
            
           if($PCODE == $P30 && $total == $P30_min){
                echo $P30_min;
            }
           else{
               echo '';
           }
           
           if($PCODE == $P32 && $total == $P32_min){
                echo $P32_min;
           }
           else{
               echo '';
           }
           
           if($PCODE == $P33 && $total == $P33_min){
                echo $P33_min;
           }
           else{
               echo '';
           }
           
           if($PCODE == $P35 && $total == $P35_min){
                echo $P35_min;
           }
           else{
               echo '';
           }
           
           if($PCODE == $P35M && $total == $P35M_min){
                echo $P35M_min;
           }
           else{
               echo '';
           }
           
           if($PCODE == $P35W && $total == $P35W_min){
                echo $P35W_min;
           }
           else{
               echo '';
           }
           
           if($PCODE == $P38 && $total == $P38_min){
                echo $P38_min;
           }
           else{
               echo '';
           }
           
           if($PCODE == $P41 && $total == $P41_min){
                echo $P41_min;
           }
           else{
               echo '';
           }
           
           if($PCODE == $P42 && $total == $P42_min){
                echo $P42_min;
           }
           else{
               echo '';
           }
           if($PCODE == $P43 && $total == $P43_min){
                echo $P43_min;
           }
           else{
               echo '';
           }
           if($PCODE == $P46 && $total == $P46_min){
                echo $P46_min;
           }
           else{
               echo '';
           }
           
           if($PCODE == $P47 && $total == $P47_min){
                echo $P47_min;
           }
            else{
                echo '';
            }
    }
    Now my problem is..

    How and where i can add this code in my form to display minimum value per Items which Items = PCODE.

    here is my code where I need to add the above code:

    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);
    $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;
            } 
            else {
    //------------------------------------------------------------------------------------------------------------------
                // Stock Number iteration.... 
                $row = mysql_fetch_assoc($result);
                
                $currentSRNum = (int)(substr($row['sr_num'],0,3));
                
                $currentSRYear  = (int)(substr($row['sr_num'],2,2));
                $currentSRMonth = (int)(substr($row['sr_num'],0,2));
                
                $currentYear  = (int)(date('y'));
                $currentMonth = (int)(date('m'));
                $currentDay = (int)(date('d'));
                
                
                if ($currentYear == $currentSRYear) {
                    if ($currentMonth == $currentSRMonth) {
                        $currentSRNum = $currentSRNum + 1;
                    }
                    if ($currentMonth > $currentSRMonth) {
                        $currentSRNum = 1;
                    }
                    if ($currentDay > $currentSRDay) {
                        $currentSRNum = 1;
                    }
                }  
                if ($currentYear > $currentRefYear) {      
                    $currentSRNum = 1;                    
                }                                          
            }
    //------------------------------------------------------------------------------------------------------------------         
            $yearMonth = date('ymd');    
            $currentSR = $yearMonth . sprintf("%03d", $currentSRNum); 
    ?>
    <html>
    <title>Stock Requisition</title>
    <head>
    </head>
    <body>
    <div id="ddcolortabs">
    <ul>
    <li> <a href="ParameterSettings.php" title="Parameter Settings"><span>Parameter Settings</span></a></li>
    <li id="current"><a href="StockRequisition.php" title="Stock Requisition"><span>Stock Requisition</span></a></li>
    <li style="margin-left: 1px"><a href="kanban_report.php" title="WIP Report"><span>Wip Report</span></a></li>
    </ul>
    </div>
    <div id="SR_date">
    <label>Date :</label>
    <input type="text" name="sr_date" value="<?php echo $sr_date; ?>" size="16" readonly="readonly">    
    </div>
    <div id="SR_number">
    <label>SR# :</label>
    <input type="text" name="sr_number" value="<?php echo $currentSR; ?>" size="8" readonly="readonly" style="font-weight: bold;">
    <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;$row[Items]</td>
            </tr>";       
    
    $sql = "SELECT SubItems, ItemCode, UoM, Class, Description, BINLocation FROM bom_subitems WHERE Items = '$row[Items]' ORDER BY Items"or die(mysql_error());
    $res_sub = mysql_query($sql, $con);
    
     while($row_sub = mysql_fetch_assoc($res_sub)){
    
        echo "<tr>
            <td style='border: none;'>&nbsp;</td>
            <td style='border: none;'>$row_sub[SubItems]</td>
            <td style='border: none;'>&nbsp;$row_sub[ItemCode]</td>
            <td style='border: none;'><center><input type='text' name='DemandedQty' id='DemandedQty' value='' size='7'></center></td>
            <td style='border: none;' size='3'>&nbsp;$row_sub[UoM]</td>
            <td style='border: none;'>&nbsp;$row_sub[Class]</td>
            <td style='border: none;'>&nbsp;$row_sub[Description]</td>
            <td style='border: none;'>&nbsp;$row_sub[BINLocation]</td>     
            </tr>";
    
    }
    }   
                   
    ?>
    </table>
    </div>
    
    </body>
    </html>
    In Demanded Qty i need to display the Minimum if the total = minimum per PCODE/Item per Item.

    for example in P28 the total = P28_min then It will display on the 3 textboxes which belong to P28
    I attach my sample image.

    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
  •