Jump to content

newphpcoder

Members
 View Profile  See their activity

  • Posts

    254

  • Joined

  • Last visited

 Content Type 

Posts posted by newphpcoder

    SUM values inside foreach and while loop

    in PHP Coding Help

    Posted

    Hi..

     

    I resolved it now using thid code:

     

    //-----Computation of Working Days---//
$sql = "SELECT FromMonth, ToMonth FROM so_month";
$res = mysql_query($sql,$con);

$row = mysql_fetch_assoc($res);
$FromMonth = $row['FromMonth'];
$ToMonth = $row['ToMonth'];

function monthNames($from, $to){
   $range=array();
   for($i=$from; $i<=$to; $i++){
           $range[$i]=date('M', mktime(0,0,0,$i));
   }
    return $range;
}
$month_ = implode("' ', ",monthNames($FromMonth,$ToMonth));

foreach( monthNames($FromMonth, $ToMonth) as $month){ 
$sql = "SELECT MonthName, SUM(WorkingDays) AS WorkingDays FROM working_days WHERE MonthName IN ('$month') GROUP BY MonthName";
$res = mysql_query($sql, $con);
$SumWorkingDays = 0; 
while($row = mysql_fetch_array($res)){

$WorkingDays+=(int)$row['WorkingDays'];
$SumWorkingDays += $WorkingDays;

}
}

     

    Thank you

    Auto Display results from computation while input Demanded Qty

    in Javascript Help

    Posted

    Hi..

     

    I have forms and I only need to input is the Demanded Qty, and from Demanded Qty that I input it will compute the demanded qty for each Item Code.

     

    Now my problem is I don't know on how can it possible that while i input the quantity it will also autodisplay the demanded qty for each materials.

     

    Noted: the Demanded Qty that will auto display is display only on the Demanded Qty you input per Items.

    For Example:

     

    On Item = P28 i input demanded qty, only on  the ItemCode will display the output.

     

    and when i input on P30 the computation will display on the ItemCode for P30.

     

    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);
?>
<html>
<title>Stock Requisition</title>
<head>
<link rel="stylesheet" type="text/css" href="kanban.css">

<script type="text/javascript">
function compute_quantity(){
    var DemandedQty = document.getElementById('DemandedQty').value;
    var Quantity = document.getElementById('Quantity').value;
    
    var SubQty = (DemandedQty * Quantity);
}
</script>
</head>
<body>
<form name="stock_requisition" action="<?php echo $_SERVER['PHP_SELF']; ?>" method="post">
<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

$DemandedQty = $_POST['DemandedQty'];

$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'];
    $Items_ = substr($Items, 12, 3);
    
echo "<tr>
        <td style='border: none;font-weight: bold;'> <input type='name' value='$Items_' name='Items_[]' id='Items' readonly = 'readonly' style = 'border:none;width:auto;font-family: Arial, Helvetica, sans-serif;font-size: 1em;'></td>
        <td style='border:none;'> </td>
        <td style='border:none;'> </td> 
        <td style='border: none;'><center><input type='text' name='DemandedQty[]' id='DemandedQty' value='' size='12' onkeypress = compute_quantity()></center></td>     
        </tr>"; 
             
$sql = "SELECT Items, SubItems, ItemCode, UoM, Class, Description, BINLocation, Quantity 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'];
     $Quantity = $row_sub['Quantity']; 
   
    echo "<input type='hidden' name='Quantity' id='Quantity' value='$Quantity'>";
    echo "<tr>
        <td style='border: none;'> <input type='hidden' value='$Items1' id='Items1' name='Items1[]'></td>
        <td style='border: none;'> <input type='text' name='SubItems[]' value='$SubItems' id='SubItems' readonly='readonly' style='border:none; width:auto;font-family: Arial, Helvetica, sans-serif;font-size: 1em;'></td>
        <td style='border: none;'> <input type='text' name='ItemCode[]' value='$ItemCode' id='ItemCode' readonly='readonly' style='border:none; width:auto;font-family: Arial, Helvetica, sans-serif;font-size: 1em;'></td>
        <td style='border: none;'><center><input type='text' name='SubQty[]' id='SubQty' value='' size='12' style></center></td>
        <td style='border: none;' size='3'> <input type='text' name='UoM[]' value='$UoM' id='UoM' readonly='readonly' style='border:none; width:auto;font-family: Arial, Helvetica, sans-serif;font-size: 1em;' size='3'></td>
        <td style='border: none;'> <input type='text' name='Class[]' value='$Class' id='Class' readonly='readonly' style='border:none; width:auto;font-family: Arial, Helvetica, sans-serif;font-size: 1em;'></td>
        <td style='border: none;'> <input type='text' name='Description[]' value='$Description' id='Description' readonly='readonly' style='border:none; width:auto;font-family: Arial, Helvetica, sans-serif;font-size: 1em;' size= '30'></td>
        <td style='border: none;'> <input type='text' name='BINLocation[]' value='$BINLocation' id='BINLocation' readonly='readonly' style='border:none; width:auto;font-family: Arial, Helvetica, sans-serif;font-size: 1em;'></td>     
        </tr>";    
        
}
}               
?>
</table>
</div>

</form>
</body>
</html>

     

    Thank you so much

    post-101569-13482403470824_thumb.jpg

    problem in overflow:auto in table

    in CSS Help

    Posted

    hi..

     

    i have table and I put style overflow:auto

    Now, I notice that also the <th> was up when I up the scroll.

     

    I just to happen is the <th> will be fix/ not move. only the <tr>

     

    here is my code:

     

    <div id="kanban_table" style="overflow:auto; height:215px;"> 
<table>
<th> JO No.</th>
<th> ETD </th>
<th> PO No. </th>
<th> SKU Code </th>
<th> Description </th>
<th> PO Req </th>
<th> Priority</th>
<?php
$sql = "SELECT FromMonth , ToMonth FROM so_month";
$res = mysql_query($sql, $con);

$row = mysql_fetch_assoc($res);

$FromMonth = $row['FromMonth'];
$ToMonth = $row['ToMonth'];

$sql = "SELECT ETD, PO_No, SKUCode, Description, POReq 
FROM sales_order  WHERE NOT EXISTS (SELECT PO_No FROM job_order WHERE job_order.PO_No = sales_order.PO_No) AND MONTH(ETD) BETWEEN '$FromMonth' AND '$ToMonth' ORDER BY ETD, PO_No ASC LIMIT 10 ";
$res_so = mysql_query($sql, $con);
while($row = mysql_fetch_assoc($res_so)){ 
echo "<form name='joborder_form' action='' method='post'>";   
$PO_No = $row['PO_No'];    
echo "<tr>
<td><input type='text' value='' style='border:none;' size='10'></td>
<td><input type='text' name='ETD' id='ETD' value='$row[ETD]' style='border:none;' size='10'></td> 
<td><input type='text' name='PO_No' id='PO_No' value='$row[PO_No]' style='border:none;' size='30'></td>
<td><input type='text' name='SKUCode' id='SKUCode' value='$row[sKUCode]' style='border:none;' size='15'></td>
<td><input type='text' name='Description' id='Description' value='$row[Description]' style='border:none;' size='35'></td>
<td><input type='text' name='POReq' id='POReq' value='$row[POReq]' style='border:none;' size='10'></td> 
<td><input type='submit' name='priority' value='Approved' id='priority'></td>
</tr>";
echo "</form>";
}
echo "</table>";
echo "</div>";

     

    Thank you

    SUM values inside foreach and while loop

    in PHP Coding Help

    Posted

    Hi..

     

    I have table which has a data so_month:

     

    FromMonth : 5

    ToMonth : 7

     

    and I have table working_days:

     

    MonthName

    May

    Jun

    Jul

    MonthNumber

    05

    06

    07

    WorkingDays

    23

    24

    23

     

    Now I have function to get the 3 consecutive months from FromMonth to ToMonth , which as you can see from May to Jul

     

    Now I have problem in getting the SUM of Working days.

     

    here is my code:

     

    <?php
  $sql = "SELECT FromMonth, ToMonth FROM so_month";
$res = mysql_query($sql,$con);

$row = mysql_fetch_assoc($res);
$FromMonth = $row['FromMonth'];
$ToMonth = $row['ToMonth'];

function monthNames($from, $to){
   $range=array();
   for($i=$from; $i<=$to; $i++){
           $range[$i]=date('M', mktime(0,0,0,$i));
   }
    return $range;
}
$month_ = implode("' ', ",monthNames($FromMonth,$ToMonth));

foreach( monthNames($FromMonth, $ToMonth) as $month){ 
$sql = "SELECT MonthName, SUM(WorkingDays) AS WorkingDays FROM working_days WHERE MonthName IN ('$month') GROUP BY MonthName";
$res = mysql_query($sql, $con);

while($row = mysql_fetch_array($res)){

$WorkingDays = $row['WorkingDays'];
}
echo $WorkingDays;
}
?>

     

    the output of this code is:

     

    232423

     

    and when I change this line:

     

    $WorkingDays = $row['WorkingDays'];

    to

    $WorkingDays += $row['WorkingDays'];

     

    the output is:

     

    234770

     

    I correct output should be: 70

     

    Any help is highly appreciated.

     

    Thank you very much..

     

     

    select the first three consecutive months

    in PHP Coding Help

    Posted

    Thank you...

     

    I tried this Update Query:

     

    \
UPDATE sales_order SET FromMonth = '05', ToMonth = '07' WHERE MONTH(ETD) BETWEEN '05' AND '07' ORDER BY SKUCode;

     

    //it did not update table but no error.

     

    when i try to select :

     

    SELECT ETD FROM sales_order WHERE MONTH(ETD) BETWEEN '05' AND '07';

    //it display ETD

     

    Why it did not update?

    Thank you

    Problem in using foreach and while loop in displaying data on table format

    in PHP Coding Help

    Posted

    Now I need to add 3 Months Name below working days.

     

     

     

    here is my code:

     

     

     

    
<html>
<head>
<title>Half Shell</title>
<link rel="stylesheet" type="text/css" href="kanban.css" />
<?php
  error_reporting(E_ALL ^ E_NOTICE);
  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);


?>

<body>
<form name="param" action="" method="post" onSubmit="return false">
<div id="fieldset_PS">
<?php
   echo "<table>";
  
   $sql = "SELECT DISTINCT s.Comp FROM sales_order s, param_settings p WHERE s.Comp = p.Compounds ORDER BY s.Comp";
   $res_comp = mysql_query($sql, $con);
   while($row_comp = mysql_fetch_assoc($res_comp)){
        $Comp[] = $row_comp['Comp'];
   }
   echo "<tr><th> </th>";

   foreach($Comp AS $Comp){
    echo "<th>$Comp</th>";
   }   
      echo "<tr><td>Total Kg/Compound</td>";
$Compound = array();
$sql = "SELECT DISTINCT s.Comp FROM sales_order s, param_settings p WHERE s.Comp = p.Compounds ORDER BY s.Comp";
   $res_comp = mysql_query($sql, $con);
   while($row_comp = mysql_fetch_assoc($res_comp)){
        $Compound[] = $row_comp['Comp'];
   }
foreach($Compound AS $Compound)
{
   $sql_sec = "SELECT SUM(TotalKg) AS TotalKg FROM sales_order  WHERE Comp = '$Compound' GROUP BY Comp ORDER BY Comp";

   # add error code compliant with the rest of error code management you are already using
   $result = mysql_query($sql_sec, $con) ;
   
   while( $row_sec = mysql_fetch_assoc( $result ) )
   {
         $TotalKg = $row_sec['TotalKg'];
         echo "<td>$TotalKg</td>";
   }
}
echo "</tr>";

echo "<tr>
    <td>Working Days</td></tr>";
   
function monthNames($from, $to){
   $range=array();
   for($i=$from; $i<=$to; $i++){
           $range[$i]=date('M', mktime(0,0,0,$i));
   }
    return $range;
}

$sql = "SELECT FromMonth, ToMonth FROM so_month";
$res = mysql_query($sql,$con);

$row = mysql_fetch_assoc($res);
$FromMonth = $row['FromMonth'];
$ToMonth = $row['ToMonth'];


foreach( monthNames($FromMonth, $ToMonth) as $month){  
   
echo "<tr>$month</tr>";// this part....
}

?>

     

     

     

    I attach my sample forms and the result of m code.

     

     

     

    Thank you again

    post-101569-13482403467905_thumb.jpg

    post-101569-13482403468016_thumb.jpg

    Problem in using foreach and while loop in displaying data on table format

    in PHP Coding Help

    Posted

    I tried this:

     

    <html>
<head>
<title>Half Shell</title>
<link rel="stylesheet" type="text/css" href="kanban.css" />
<?php
  error_reporting(E_ALL ^ E_NOTICE);
  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);

?>
<body>
<form name="param" action="" method="post" onSubmit="return false">
<div id="fieldset_PS">
<?php
   echo "<table>";
  
   $sql = "SELECT DISTINCT s.Comp FROM sales_order s, param_settings p WHERE s.Comp = p.Compounds ORDER BY s.Comp";
   $res_comp = mysql_query($sql, $con);
   while($row_comp = mysql_fetch_assoc($res_comp)){
        $Comp[] = $row_comp['Comp'];
   }
   echo "<tr><th> </th>";
   foreach($Comp AS $Comp){
    echo "<th>$Comp</th>";
   }  
      echo "<tr><td>Total Kg/Compound</td>";
$Compound = array();
$sql = "SELECT DISTINCT s.Comp FROM sales_order s, param_settings p WHERE s.Comp = p.Compounds ORDER BY s.Comp";
   $res_comp = mysql_query($sql, $con);
   while($row_comp = mysql_fetch_assoc($res_comp)){
        $Compound[] = $row_comp['Comp'];
   }
foreach($Compound AS $Compound)
{
   $sql_sec = "SELECT SUM(TotalKg) AS TotalKg FROM sales_order  WHERE Comp = '$Compound' GROUP BY Comp ORDER BY Comp";

   # add error code compliant with the rest of error code management you are already using
   $result = mysql_query($sql_sec, $con) ;
  
   while( $row_sec = mysql_fetch_assoc( $result ) )
   {
         $TotalKg = $row_sec['TotalKg'];
         echo "<td>$TotalKg</td>";
   }
}
echo "</tr>";
   ?>

     

    And it works.

     

    select the first three consecutive months

    in PHP Coding Help

    Posted

    Now this is my code:

     

    <?php
  error_reporting(E_ALL ^ E_NOTICE); 
  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);


?>
<html>
<head>
<title>Sales Order</title> 
<link rel="stylesheet" type="text/css" href="kanban.css" />

<script type="text/javascript">
function upload_so(){

    document.salesorder.action="import_salesorder.php";
    document.salesorder.submit();
    
    alert("Sales Order Successfully Uploaded.");
    window.location="SalesOrder.php";
}

function disp(){
    var FromMonth = document.getElementById('FromMonth').value;
    var ToMonth = document.getElementById('ToMonth').value;
    document.salesorder.action="salesorder.php?FromMonth="+FromMonth+"&ToMonth="+ToMonth;
    document.salesorder.submit();    
}
</script>      
</head>
<body>
<form enctype="multipart/form-data" action="import_salesorder.php" method="post" name="salesorder">

<div id="upload">
<fieldset>
<legend>Upload Sales Order</legend>
<input type="hidden" name="MAX_FILE_SIZE" value="10000000000" />
  <table width="500">
  <tr>
  <td>Sales Order:</td>
  <td><input type="file" name="file" /></td>
  <td><input type="button" value="Upload" onclick="upload_so()"/></td>
  <a href="import_salesorder.php">up</a>
  </tr>
  </table>
</fieldset>
</div>
<input type="hidden" value="<?php echo $date_upload; ?>" id="date_upload" name="date_upload">
</div>
<div id="From_Month">
<label>From Month:</label>
<select name="FromMonth">
<option value="Select">Select</option>
<option value="01" <?php if($_POST['FromMonth'] == '01') echo "selected='selected'"; ?>>January</option>
  <option value="02" <?php if($_POST['FromMonth'] == '02') echo "selected='selected'"; ?>>February</option>
<option value="03" <?php if($_POST['FromMonth'] == '03') echo "selected='selected'"; ?>>March</option>
  <option value="04" <?php if($_POST['FromMonth'] == '04') echo "selected='selected'"; ?>>April</option>
<option value="05" <?php if($_POST['FromMonth'] == '05') echo "selected='selected'"; ?>>May</option>
<option value="06" <?php if($_POST['FromMonth'] == '06') echo "selected='selected'"; ?>>June</option>
  <option value="07" <?php if($_POST['FromMonth'] == '07') echo "selected='selected'"; ?>>July</option>
<option value="08" <?php if($_POST['FromMonth'] == '08') echo "selected='selected'"; ?>>August</option>
  <option value="09" <?php if($_POST['FromMonth'] == '09') echo "selected='selected'"; ?>>September</option>
<option value="10" <?php if($_POST['FromMonth'] == '10') echo "selected='selected'"; ?>>October</option>
  <option value="11" <?php if($_POST['FromMonth'] == '11') echo "selected='selected'"; ?>>November</option>
<option value="12" <?php if($_POST['FromMonth'] == '12') echo "selected='selected'"; ?>>December</option>
</select>

<label>To Month:</label>
<select name="ToMonth">
<option value="Select">Select</option>
<option value="01" <?php if($_POST['ToMonth'] == '01') echo "selected='selected'"; ?>>January</option>
  <option value="02" <?php if($_POST['ToMonth'] == '02') echo "selected='selected'"; ?>>February</option>
<option value="03" <?php if($_POST['ToMonth'] == '03') echo "selected='selected'"; ?>>March</option>
  <option value="04" <?php if($_POST['ToMonth'] == '04') echo "selected='selected'"; ?>>April</option>
<option value="05" <?php if($_POST['ToMonth'] == '05') echo "selected='selected'"; ?>>May</option>
<option value="06" <?php if($_POST['ToMonth'] == '06') echo "selected='selected'"; ?>>June</option>
  <option value="07" <?php if($_POST['ToMonth'] == '07') echo "selected='selected'"; ?>>July</option>
<option value="08" <?php if($_POST['ToMonth'] == '08') echo "selected='selected'"; ?>>August</option>
  <option value="09" <?php if($_POST['ToMonth'] == '09') echo "selected='selected'"; ?>>September</option>
<option value="10" <?php if($_POST['ToMonth'] == '10') echo "selected='selected'"; ?>>October</option>
  <option value="11" <?php if($_POST['ToMonth'] == '11') echo "selected='selected'"; ?>>November</option>
<option value="12" <?php if($_POST['ToMonth'] == '12') echo "selected='selected'"; ?>>December</option>
</select>

<input type="button" name="display" value="display" onclick="disp()" id="display">
</div>

<div id="kanban_table">
<?php 
echo "<table border='.2'>";
echo "<th>ETD</th>
<th>PO No.</th>
<th>SKU Code</th>
<th>Description</th>
<th>PO Req</th>
<th>Compound</th>
<!--<th>Compound Kg</th>-->

";

    $FromMonth = $_POST['FromMonth'];
    $ToMonth = $_POST['ToMonth'];
    
$sql = "INSERT INTO so_month (FromMonth, ToMonth) VALUES ('$FromMonth', '$ToMonth')
ON DUPLICATE KEY UPDATE FromMonth = '$FromMonth', ToMonth = '$ToMonth'";
$res = mysql_query($sql,$con);   

$sql = "SELECT ETD, PO_No, SKUCode, Description, POReq, Comp FROM sales_order WHERE MONTH(ETD) BETWEEN '$FromMonth' AND '$ToMonth' ORDER BY ETD, PO_No";
$res = mysql_query($sql, $con);

while($row = mysql_fetch_assoc($res)){
    $ETD = $row['ETD'];
    $PO_No = $row['PO_No'];
    $SKUCode = $row['SKUCode'];
    $Description = $row['Description'];
    $POReq = $row['POReq'];
    $Comp = $row['Comp'];

echo "<tr>
<td>$ETD</td>
<td>$PO_No</td>
<td>$SKUCode</td>
<td>$Description</td>
<td>$POReq</td>
<td>$Comp</td>
<!--<td>$CompKg</td>-->
<!--<td>$Cloth</td>-->
</tr>";
}

?>
</div>                     
</form>
</body>
</html>

     

    Thank you

    Convert Month Number to Month Name in a Range

    in PHP Coding Help

    Posted

    I tried this:

     

    function monthNames($from, $to){
   $range=array();
   for($i=$from; $i<=$to; $i++){
           $range[$i]=date('M', mktime(0,0,0,$i));
   }
    return $range;
}

$sql = "SELECT FromMonth, ToMonth FROM so_month";
$res = mysql_query($sql,$con);

$row = mysql_fetch_assoc($res);
$FromMonth = $row['FromMonth'];
$ToMonth = $row['ToMonth'];


foreach( monthNames($FromMonth, $ToMonth) as $month){ echo $month,'<br>'; }

     

    and it works..

     

    now my problem how can I put this on my code:

     

    <html>
<head>
<title>Half Shell</title>
<link rel="stylesheet" type="text/css" href="kanban.css" />
<?php
  error_reporting(E_ALL ^ E_NOTICE);
  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);


?>

<body>
<form name="param" action="" method="post" onSubmit="return false">
<div id="fieldset_PS">
<?php
   echo "<table>";
   
   $sql = "SELECT DISTINCT s.Comp FROM sales_order s, param_settings p WHERE s.Comp = p.Compounds ORDER BY s.Comp";
   $res_comp = mysql_query($sql, $con); 
   while($row_comp = mysql_fetch_assoc($res_comp)){
        $Comp[] = $row_comp['Comp'];
   }
   echo "<tr><th> </th>";

   foreach($Comp AS $Comp){
    echo "<th>$Comp</th>";
   }    
      echo "<tr><td>Total Kg/Compound</td>";
$Compound = array();
$sql = "SELECT DISTINCT s.Comp FROM sales_order s, param_settings p WHERE s.Comp = p.Compounds ORDER BY s.Comp";
   $res_comp = mysql_query($sql, $con); 
   while($row_comp = mysql_fetch_assoc($res_comp)){
        $Compound[] = $row_comp['Comp'];
   }
foreach($Compound AS $Compound) 
{ 
   $sql_sec = "SELECT SUM(TotalKg) AS TotalKg FROM sales_order  WHERE Comp = '$Compound' GROUP BY Comp ORDER BY Comp"; 
  
   # add error code compliant with the rest of error code management you are already using 
   $result = mysql_query($sql_sec, $con) ; 
    
   while( $row_sec = mysql_fetch_assoc( $result ) ) 
   { 
         $TotalKg = $row_sec['TotalKg']; 
         echo "<td>$TotalKg</td>"; 
   } 
} 
echo "</tr>"; 

echo "<tr>
    <td>Working Days</td></tr>";
echo "<tr></tr>"// this part....
?>

     

    Thank you

    Insert only date where month is not previous month

    in MySQL Help

    Posted

    Now this is my code to delete the previous month.

     

    <?php
error_reporting(E_ALL ^ E_NOTICE); 
  date_default_timezone_set("Asia/Singapore"); //set the time zone    
$data = array();

$con = mysql_connect("localhost", "root","");
if (!$con) { 
  die(mysql_error());
}
$db = mysql_select_db("mes", $con);
if (!$db) { 
  die(mysql_error());
}
    $sql = "delete from sales_order";
    $result =  mysql_query($sql);
    if (!$result) {
        die(mysql_error());
    }

  
function add_employee($ETD,$PO_No,$SKUCode,$Description,$POReq ,$Comp)
  {
      global $data;
      
      
      $con = mysql_connect("localhost", "root","");
      if (!$con){ die(mysql_error());}
      $db = mysql_select_db("mes", $con);
      if (!$db) { 
          die(mysql_error());
      }

      $ETD= $ETD;
      $PO_No = $PO_No;
      $SKUCode = $SKUCode;
      $Description = $Description;
      $POReq = $POReq;
      $Comp = $Comp;
      
    
     $sql = "INSERT INTO sales_order (ETD,PO_No,SKUCode,Description,POReq,Comp) 
      VALUES 
      ('$ETD','$PO_No','$SKUCode','$Description','$POReq','$Comp')
     ";
     $res_so = mysql_query($sql, $con);
     

      $sql = "INSERT INTO sales_order_dump (ETD,PO_No,SKUCode,Description,POReq,Comp) 
      VALUES 
      ('$ETD','$PO_No','$SKUCode','$Description','$POReq','$Comp')
      ON DUPLICATE KEY UPDATE
      ETD = '$ETD', PO_No = '$PO_No', SKUCode = '$SKUCode', Description = '$Description', POReq = '$POReq', Comp = '$Comp'" or die(mysql_error());
      $res = mysql_query($sql, $con);
      
       $data []= array('ETD'=>$ETD,'PO_No'=>$PO_No,'SKUCode'=>$SKUCode,'Description'=>$Description,'POReq'=>$POReq,'Comp'=>$Comp); 
}

  

if(empty($_FILES['file']['tmp_name'])){

$doc = new DOMDocument();
$dom = $doc->load('Sales1.xml');
        
      $rows = $doc->getElementsByTagName('Row');
      global $last_row;
      $last_row = false;
      $first_row = true;
      foreach ($rows as $row)
      {
          if ( !$first_row )
          {
              $ETD = "";
              $PO_No = "";
              $SKUCode = "";
              $Description = "";
              $POReq = "";
              $Comp = "";
              
              $index = 1;
              $cells = $row->getElementsByTagName( 'Cell' );
          
              foreach( $cells as $cell )
              { 
                  $ind = $cell->getAttribute( 'Index' );
                  if ( $ind != null ) $index = $ind;
                  if ( $index == 1 ) $ETD = $cell->nodeValue;  
                  if ( $index == 2 ) $PO_No = $cell->nodeValue;
                  if ( $index == 3 ) $SKUCode = $cell->nodeValue;
                  if ( $index == 4 ) $Description = $cell->nodeValue;
                  if ( $index == 5 ) $POReq = $cell->nodeValue;
                  if ( $index == 6 ) $Comp = $cell->nodeValue;

                                    $index += 1;
              }

             if ($ETD=='' AND $PO_No=='' AND $SKUCode=='' AND $Description=='' AND $POReq=='' AND $Comp=='') {  
                    $last_row = true;
              }      
              else {
                    add_employee($ETD,$PO_No,$SKUCode,$Description, $POReq, $Comp);  
              }      
          }
          if ($last_row==true) {
              $first_row = true;
          }     
          else {
              $first_row = false;
          }
      }
  }  

  $sql = "SELECT * FROM sales_order";
  $res = mysql_query($sql, $con);
  
  $row = mysql_fetch_row($res);
  
  if($row >= 0){
  $sql_del = "DELETE FROM sales_order WHERE MONTH(ETD) = MONTH(NOW())-1";
  $res_del = mysql_query($sql_del,$con) or die(mysql_error());
  }
   
   
    $sql = "UPDATE sales_order s SET 
   CompKg = (SELECT Bch_Wt FROM param_settings p WHERE s.Comp = p.Compounds ORDER BY p.Compounds),
   PlugWt = (SELECT Plug_Wt FROM param_settings p WHERE s.Comp = p.Compounds ORDER BY p.Compounds)";
   $res = mysql_query($sql, $con);

  $sql = "UPDATE sales_order SET 
  Doz = ((CompKg * 1000) / PlugWt) / 12 / 2,
  KgDoz = (CompKg / Doz),
  TotalKg = (POReq * KgDoz),
  BatchNeeded = (POReq / Doz)
  ORDER BY SKUCode";
  $res = mysql_query($sql, $con);
   
  ?>

    Convert Month Number to Month Name in a Range

    in PHP Coding Help

    Posted

    I tried this:

     

    function monthNames($from, $to){
   $range=array();
   for($i=$from; $i<=$to; $i++){
           $range[$i]=date('M', mktime(0,0,0,$i));
   }
    return $range;
}
echo  implode(", ",monthNames(5,7));

$sql = "SELECT FromMonth, ToMonth FROM so_month";
$res = mysql_query($sql,$con);

$row = mysql_fetch_assoc($res);
$FromMonth = $row['FromMonth'];
$ToMonth = $row['ToMonth'];

echo $FromMonth;
echo $ToMonth;

echo monthNames($FromMonth, $ToMonth);

     

    the output is:

     

    May, Jun, Jul57Array

     

    it did not read the $FromMonth, $ToMonth

     

    why?

     

    Thank you

    select the first three consecutive months

    in PHP Coding Help

    Posted

    Hi..

     

    I need help in selecting first 3 Consecutive Months from my table ETD which type is Date.

     

    for example in my ETD:

     

    2012-04-01

    2012-04-01

    2012-04-05

    2012-04-08

    2012-04-08

    2012-05-01

    2012-05-01

    2012-05-05

    2012-05-08

    2012-05-08

    2012-06-01

    2012-06-01

    2012-06-05

    2012-06-08

    2012-06-08

    2012-07-01

    2012-07-01

    2012-07-05

    2012-07-08

    2012-07-08

    2012-08-01

    2012-08-01

    2012-08-05

    2012-08-08

    2012-08-08

     

     

    Now from this ETD data:

     

    I need to select only are:

    (from April - June)

    2012-04-01

    2012-04-01

    2012-04-05

    2012-04-08

    2012-04-08

    2012-05-01

    2012-05-01

    2012-05-05

    2012-05-08

    2012-05-08

    2012-06-01

    2012-06-01

    2012-06-05

    2012-06-08

    2012-06-08

     

    Thank you

    Convert Month Number to Month Name in a Range

    in PHP Coding Help

    Posted

    Hi..

     

    I need help in getting the 3 Months Name from my table field FromMonth and ToMonth.

    Here is the scenario.

     

    First, I select FromMonth and ToMonth.

    Ex.

    FromMonth = 5

    ToMonth = 7

    So it means

    FromMonth is May

    ToMonth is July.

     

    Now I save the MonthNumber to my database:

     

    table- so_month

    FromMonth = 5

    ToMonth = 7

     

    Now I need to get the between Months Name from FromMonth to ToMonth which are (May, June, July).

     

    How does it possible?

    Thank you so much.

     

    Problem in using foreach and while loop in displaying data on table format

    in PHP Coding Help

    Posted

    I revise again my code:

     

    <html>
<head>
<title>Half Shell</title>
<link rel="stylesheet" type="text/css" href="kanban.css" />
<?php
  error_reporting(E_ALL ^ E_NOTICE);
  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);
?>
<body>
<form name="param" action="" method="post" onSubmit="return false">
<div id="fieldset_PS">
<?php
   echo "<table>";
   
   $sql = "SELECT DISTINCT s.Comp FROM sales_order s, param_settings p WHERE s.Comp = p.Compounds ORDER BY s.Comp";
   $res_comp = mysql_query($sql, $con); 
   while($row_comp = mysql_fetch_assoc($res_comp)){
        $Comp[] = $row_comp['Comp'];
   }
   echo "<th> </th>";
   foreach($Comp AS $Comp){
    echo "<th>$Comp</th>";
     

   echo "<tr>
   <td>Total Kg/Compound</td>";
      $sql_sec = "SELECT SUM(TotalKg) AS TotalKg FROM sales_order  WHERE Comp = '$Comp' ORDER BY Comp";
   $res_sec = mysql_query($sql_sec, $con);
   
   while($row_sec = mysql_fetch_assoc($res_sec)){
       $TotalKg[] = $row_sec['TotalKg'];
   }
   foreach($TotalKg AS $Total){
    echo "<td>$Total</td>
    </tr>";
  }    
}

   ?>

     

    because I duplicate the tr so i remove it.

     

    I will attach agin the output still wrong :(

    post-101569-13482403466892_thumb.jpg

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.