Jump to content

Auto calculate conversion and display to beside textbox

newphpcoder

By newphpcoder
in Javascript Help

 Share

Recommended Posts

newphpcoder Advanced Member

newphpcoder

Posted
Posted

Hi..

 

I have syntax for autocalculate the max lot and the output display in Total_max same with min lot and the output display in Totam_min, now I need to have convert automatically the number I was inputted in max lot textbox and it will display in max doz textbox same also with min lot convert to min doz textbox.

 

the conversion  is:

 

max doz = max lot * 10

min doz = min lot * 10

 

here is my code:

 

<html>
<head>
<style type="text/css">
#fieldset_PS{
    position: relative;
    width: 20%;
    height: auto;
    margin-left: .5em;
    top : 0px;
    
}
#main_button{
    margin-left: .7em;
    position: absolute;
    top : 0px;
}

#footer_button{
    margin-left: .5em;
    position: absolute;
    top : 535px;
}
</style>
<link rel="stylesheet" type="text/css" href="kanban.css" /> 
<script type="text/javascript">
  
function display_PS(){
    document.loading_kanban.action="ParameterSettings.php";
    document.loading_kanban.submit();
}
function display_Kanban(){
    document.loading_kanban.action="kanban_report.php";
    document.loading_kanban.submit();
}
</script>

<script type="text/javascript">
//Code for auto calculate Total Max//
function autocalearn(oText)
{
if (isNaN(oText.value)) //filter input
{
alert('Numbers only!');
oText.value = '';
}
var field, val, oForm = oText.form, Total_max = a = 0;
for (a; a < arguments.length; ++a) //loop through text elements
{
field = arguments[a];
val = parseFloat(field.value); //get value
if (!isNaN(val)) //number?
{
Total_max += val; //accumulate
}
}
oForm.Total_max.value = Total_max.toFixed(2); //out
}

</script>


<script type="text/javascript">
//Code for auto calculate Total Min//  
function autocalmin(oText)
{
if (isNaN(oText.value)) //filter input
{
alert('Numbers only!');
oText.value = '';
}
var field, val, oForm = oText.form, Total_min = a = 0;
for (a; a < arguments.length; ++a) //loop through text elements
{
field = arguments[a];
val = parseFloat(field.value); //get value
if (!isNaN(val)) //number?
{
Total_min += val; //accumulate
}
}

oForm.Total_min.value = Total_min.toFixed(2); //out
}

</script>
</head>
<?php
  error_reporting(0);
$con = mysql_connect('localhost', 'root','');

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

mysql_select_db("mes", $con);
?>
<form name="loading_kanban">
<div id="main_button">
<center>
<!--<label style="margin-left: .9em; font-family: Arial, Helvetica, sans-serif; font-size: .7em;">Display Details:</label><input  onclick='showDetails(this);' id='chkDetail'   type='checkbox' checked='checked' value='wip'/>     -->
<input type="button" name="parameter_settings" value="Parameter Settings" onclick="display_PS()">
<input type="button" name="parameter_settings" value="Stock Requisition"> 
<input type="button" name="parameter_settings" value="Kanban Report" onclick="display_Kanban()">
</center>
</div>
<div id="fieldset_PS">
<center>
<table border="1">
<th>Compounds</th>
<th>Max</th>
<th>UOM</th>
<th>Max</th>
<th>UOM</th>
<th>Min</th>
<th>UOM</th>
<th>Min</th>
<th>UOM</th>

<tr>
<td><label id="P27" name="P27" size="6" style="text-align: center;">P27</label></td>
<td><input type="text" name="P27_max" id="P27_max" size="6" onkeyup="return autocalearn(this, P28_max, P30_max, P32W_max, P33_max, P35_max, P35M_max, P35W_max, P38_max, P41_max, P42_max, P43_max, P45_max, P46_max, P47_max)"></td>
<td><label id="P27LOT_max" name="P27LOT_max" size="3" style="text-align: left;">Lot</label></td> 
<td><input type="text" name="P27_maxdoz" id="P27_maxdoz" size="6"></td>
<td><label id="P27Doz_max" name="P27Doz_max" size="3" style="text-align: left;">Doz</label></td> 
<td><input type="text" name="P27_min" id="P27_min" size="6" onkeyup="return autocalmin(this, P28_min, P30_min, P32W_min, P33_min, P35_min, P35M_min, P35W_min, P38_min, P41_min, P42_min, P43_min, P45_min, P46_min, P47_min)"></td>
<td><label id="P27LOT_min" name="P27LOT_min" size="3" style="text-align: left;">Lot</label></td>
<td><input type="text" name="P27_mindoz" id="P27_mindoz" size="6"></td>
<td><label id="P27Doz_min" name="P27Doz_min" size="3" style="text-align: left;">Doz</label></td>
</tr> 
<tr>
<td><label id="P28" name="P28" size="6">P28</label></td> 
<td><input type="text" name="P28_max" id="P28_max" size="6" onkeyup="return autocalearn(this, P27_max, P30_max, P32W_max, P33_max, P35_max, P35M_max, P35W_max, P38_max, P41_max, P42_max, P43_max, P45_max, P46_max, P47_max)"></td>
<td><label id="P28LOT_max" name="P28LOT_max" size="3" style="text-align: left;">Lot</label></td>
<td><input type="text" name="P28_maxdoz" id="P28_maxdoz" size="6"></td>
<td><label id="P28Doz_max" name="P28Doz_max" size="3" style="text-align: left;">Doz</label></td> 
<td><input type="text" name="P28_min" id="P28_min" size="6" onkeyup="return autocalmin(this, P27_min, P30_min, P32W_min, P33_min, P35_min, P35M_min, P35W_min, P38_min, P41_min, P42_min, P43_min, P45_min, P46_min, P47_min)"></td>
<td><label id="P28LOT_min" name="P28LOT_min" size="3" style="text-align: left;">Lot</label></td>
<td><input type="text" name="P28_mindoz" id="P28_mindoz" size="6"></td>
<td><label id="P28Doz_min" name="P28Doz_min" size="3" style="text-align: left;">Doz</label></td>
</tr>
<tr>
<td><label id="P30" name="P30" size="6">P30</label></td> 
<td><input type="text" name="P30_max" id="P30_max" size="6" onkeyup="return autocalearn(this, P27_max, P28_max, P32W_max, P33_max, P35_max, P35M_max, P35W_max, P38_max, P41_max, P42_max, P43_max, P45_max, P46_max, P47_max)"></td>
<td><label id="P30LOT_max" name="P30LOT_max" size="3" style="text-align: left;">Lot</label></td>
<td><input type="text" name="P30_maxdoz" id="P30_maxdoz" size="6"></td>
<td><label id="P30Doz_max" name="P30Doz_max" size="3" style="text-align: left;">Doz</label></td>
<td><input type="text" name="P30_min" id="P30_min" size="6" onkeyup="return autocalmin(this, P27_min, P28_min, P32W_min, P33_min, P35_min, P35M_min, P35W_min, P38_min, P41_min, P42_min, P43_min, P45_min, P46_min, P47_min)"></td>
<td><label id="P30LOT_min" name="P30LOT_min" size="3" style="text-align: left;">Lot</label></td>
<td><input type="text" name="P30_mindoz" id="P30_mindoz" size="6"></td>
<td><label id="P30Doz_min" name="P30Doz_min" size="3" style="text-align: left;">Doz</label></td>
</tr>    
<tr>
<td><label id="P32W" name="P32W" size="6">P32W</label></td> 
<td><input type="text" name="P32W_max" id="P32W_max" size="6" onkeyup="return autocalearn(this, P27_max, P28_max, P30_max, P33_max, P35_max, P35M_max, P35W_max, P38_max, P41_max, P42_max, P43_max, P45_max, P46_max, P47_max)"></td>
<td><label id="P32WLOT_max" name="P32WLOT_max" size="3" style="text-align: left;">Lot</label></td>
<td><input type="text" name="P32W_maxdoz" id="P32W_maxdoz" size="6"></td>
<td><label id="P32WDoz_max" name="P32WDoz_max" size="3" style="text-align: left;">Doz</label></td>
<td><input type="text" name="P32W_min" id="P32W_min" size="6" onkeyup="return autocalmin(this, P27_min, P28_min, P30_min, P33_min, P35_min, P35M_min, P35W_min, P38_min, P41_min, P42_min, P43_min, P45_min, P46_min, P47_min)"></td>
<td><label id="P32WLot_min" name="P32WLot_min" size="3" style="text-align: left;">Lot</label></td>
<td><input type="text" name="P32W_mindoz" id="P32W_mindoz" size="6"></td>
<td><label id="P32WDoz_min" name="P32WDoz_min" size="3" style="text-align: left;">Doz</label></td>
</tr>  
<tr>
<td><label id="P33" name="P33" size="6">P33</label></td> 
<td><input type="text" name="P33_max" id="P33_max" size="6" onkeyup="return autocalearn(this, P27_max, P28_max, P30_max, P32W_max, P35_max, P35M_max, P35W_max, P38_max, P41_max, P42_max, P43_max, P45_max, P46_max, P47_max)"></td>
<td><label id="P33LOT_max" name="P33LOT_max" size="3" style="text-align: left;">Lot</label></td>
<td><input type="text" name="P33_maxdoz" id="P33_maxdoz" size="6"></td>
<td><label id="P33Doz_max" name="P33Doz_max" size="3" style="text-align: left;">Doz</label></td>
<td><input type="text" name="P33_min" id="P33_min" size="6" onkeyup="return autocalmin(this, P27_min, P28_min, P30_min, P32W_min, P35_min, P35M_min, P35W_min, P38_min, P41_min, P42_min, P43_min, P45_min, P46_min, P47_min)"></td>
<td><label id="P33LOT_min" name="P33LOT_min" size="3" style="text-align: left;">Lot</label></td>
<td><input type="text" name="P33_mindoz" id="P33_mindoz" size="6"></td>
<td><label id="P33Doz_min" name="P33Doz_min" size="3" style="text-align: left;">Doz</label></td>
</tr>  
<tr>
<td><label id="P35" name="P35" size="6">P35</label></td> 
<td><input type="text" name="P35_max" id="P35_max" size="6" onkeyup="return autocalearn(this, P27_max, P28_max, P30_max, P32W_max, P33_max, P35M_max, P35W_max, P38_max, P41_max, P42_max, P43_max, P45_max, P46_max, P47_max)"></td>
<td><label id="P35LOT_max" name="P35LOT_max" size="3" style="text-align: left;">Lot</label></td>
<td><input type="text" name="P35_maxdoz" id="P35_maxdoz" size="6"></td>
<td><label id="P35Doz_max" name="P35Doz_max" size="3" style="text-align: left;">Doz</label></td>
<td><input type="text" name="P35_min" id="P35_min" size="6" onkeyup="return autocalmin(this, P27_min, P28_min, P30_min, P32W_min, P33_min, P35M_min, P35W_min, P38_min, P41_min, P42_min, P43_min, P45_min, P46_min, P47_min)"></td>
<td><label id="P35LOT_min" name="P35LOT_min" size="3" style="text-align: left;">Lot</label></td>
<td><input type="text" name="P35_mindoz" id="P35_mindoz" size="6"></td>
<td><label id="P35Doz_min" name="P35Doz_min" size="3" style="text-align: left;">Doz</label></td>

</tr>  
<tr>
<td><label id="P35M" name="P35M" size="6">P35M</label></td> 
<td><input type="text" name="P35M_max" id="P35M_max" size="6" onkeyup="return autocalearn(this, P27_max, P28_max, P30_max, P32W_max, P33_max, P35_max, P35W_max, P38_max, P41_max, P42_max, P43_max, P45_max, P46_max, P47_max)"></td>
<td><label id="P35MLOT_max" name="P35MLOT_max" size="3" style="text-align: left;">Lot</label></td>
<td><input type="text" name="P35M_maxdoz" id="P35M_maxdoz" size="6"></td>
<td><label id="P35MDoz_max" name="P35MDoz_max" size="3" style="text-align: left;">Doz</label></td>
<td><input type="text" name="P35M_min" id="P35M_min" size="6" onkeyup="return autocalmin(this, P27_min, P28_min, P30_min, P32W_min, P33_min, P35_min, P35W_min, P38_min, P41_min, P42_min, P43_min, P45_min, P46_min, P47_min)"></td>
<td><label id="P35MLOT_min" name="P35MLOT_min" size="3" style="text-align: left;">Lot</label></td>
<td><input type="text" name="P35M_mindoz" id="P35M_mindoz" size="6"></td>
<td><label id="P35MDoz_min" name="P35MDoz_min" size="3" style="text-align: left;">Doz</label></td>
</tr>  
<tr>
<td><label id="P35W" name="P35W" size="6">P35W</label></td> 
<td><input type="text" name="P35W_max" id="P35W_max" size="6" onkeyup="return autocalearn(this, P27_max, P28_max, P30_max, P32W_max, P33_max, P35_max, P38_max, P41_max, P42_max, P43_max, P45_max, P46_max, P47_max)"></td>
<td><label id="P35WLOT_max" name="P35WLOT_max" size="3" style="text-align: left;">Lot</label></td>
<td><input type="text" name="P35W_maxdoz" id="P35W_maxdoz" size="6"></td>
<td><label id="P35WDoz_max" name="P35WDoz_max" size="3" style="text-align: left;">Doz</label></td>
<td><input type="text" name="P35W_min" id="P35W_min" size="6" onkeyup="return autocalmin(this, P27_min, P28_min, P30_min, P32W_min, P33_min, P35_min, P38_min, P41_min, P42_min, P43_min, P45_min, P46_min, P47_min)"></td>
<td><label id="P35WLOT_min" name="P35WLOT_min" size="3" style="text-align: left;">Lot</label></td>
<td><input type="text" name="P35W_mindoz" id="P35W_mindoz" size="6"></td>
<td><label id="P35WDoz_min" name="P35WDoz_min" size="3" style="text-align: left;">Doz</label></td>
</tr>  
<tr>
<td><label id="P38" name="P38" size="6">P38</label></td> 
<td><input type="text" name="P38_max" id="P38_max" size="6" onkeyup="return autocalearn(this, P27_max, P28_max, P30_max, P32W_max, P33_max, P35_max, P35M_max, P35W_max, P42_max, P43_max, P45_max, P46_max, P47_max)"></td>
<td><label id="P38LOT_max" name="P38LOT_max" size="3" style="text-align: left;">Lot</label></td>
<td><input type="text" name="P38_maxdoz" id="P38_maxdoz" size="6"></td>
<td><label id="P38Doz_max" name="P38Doz_max" size="3" style="text-align: left;">Doz</label></td>
<td><input type="text" name="P38_min" id="P38_min" size="6" onkeyup="return autocalmin(this, P27_min, P28_min, P30_min, P32W_min, P33_min, P35_min, P35M_min, P35W_min, P42_min, P43_min, P45_min, P46_min, P47_min)"></td>
<td><label id="P38LOT_min" name="P38LOT_min" size="3" style="text-align: left;">Lot</label></td>
<td><input type="text" name="P38_mindoz" id="P38_mindoz" size="6"></td>
<td><label id="P38Doz_min" name="P38Doz_min" size="3" style="text-align: left;">Doz</label></td>
</tr>  
<tr>
<td><label id="P41" name="P41" size="6">P41</label></td> 
<td><input type="text" name="P41_max" id="P41_max" size="6" onkeyup="return autocalearn(this, P27_max, P28_max, P30_max, P32W_max, P33_max, P35_max, P35M_max, P35W_max, P38_max, P42_max, P43_max, P45_max, P46_max, P47_max)"></td>
<td><label id="P41LOT_max" name="P41LOT_max" size="3" style="text-align: left;">Lot</label></td>
<td><input type="text" name="P41_maxdoz" id="P41_maxdoz" size="6"></td>
<td><label id="P41Doz_max" name="P41Doz_max" size="3" style="text-align: left;">Doz</label></td>
<td><input type="text" name="P41_min" id="P41_min" size="6" onkeyup="return autocalmin(this, P27_min, P28_min, P30_min, P32W_min, P33_min, P35_min, P35M_min, P35W_min, P38_min, P42_min, P43_min, P45_min, P46_min, P47_min)"></td>
<td><label id="P41LOT_min" name="P41LOT_min" size="3" style="text-align: left;">Lot</label></td>
<td><input type="text" name="P41_mindoz" id="P41_mindoz" size="6"></td>
<td><label id="P41Doz_min" name="P41Doz_min" size="3" style="text-align: left;">Doz</label></td>
</tr>  

<tr>
<td><label id="P42" name="P42" size="6">P42</label></td> 
<td><input type="text" name="P42_max" id="P42_max" size="6" onkeyup="return autocalearn(this, P27_max, P28_max, P30_max, P32W_max, P33_max, P35_max, P35M_max, P35W_max, P38_max, P41_max, P43_max, P45_max, P46_max, P47_max)"></td>
<td><label id="P42LOT_max" name="P42LOT_max" size="3" style="text-align: left;">Lot</label></td>
<td><input type="text" name="P42_maxdoz" id="P42_maxdoz" size="6"></td>
<td><label id="P42Doz_max" name="P42Doz_max" size="3" style="text-align: left;">Doz</label></td>
<td><input type="text" name="P42_min" id="P42_min" size="6" onkeyup="return autocalmin(this, P27_min, P28_min, P30_min, P32W_min, P33_min, P35_min, P35M_min, P35W_min, P38_min, P41_min, P43_min, P45_min, P46_min, P47_min)"></td>
<td><label id="P42LOT_min" name="P42LOT_min" size="3" style="text-align: left;">Lot</label></td>
<td><input type="text" name="P42_mindoz" id="P42_mindoz" size="6"></td>
<td><label id="P42Doz_min" name="P42Doz_min" size="3" style="text-align: left;">Doz</label></td>
</tr>  

<tr>
<td><label id="P43" name="P43" size="6">P43</label></td> 
<td><input type="text" name="P43_max" id="P43_max" size="6" onkeyup="return autocalearn(this, P27_max, P28_max, P30_max, P32W_max, P33_max, P35_max, P35M_max, P35W_max, P38_max, P41_max, P42_max, P45_max, P46_max, P47_max)"></td>
<td><label id="P43LOT_max" name="P43LOT_max" size="3" style="text-align: left;">Lot</label></td>
<td><input type="text" name="P43_maxdoz" id="P43_maxdoz" size="6"></td>
<td><label id="P43Doz_max" name="P43Doz_max" size="3" style="text-align: left;">Doz</label></td>
<td><input type="text" name="P43_min" id="P43_min" size="6" onkeyup="return autocalmin(this, P27_min, P28_min, P30_min, P32W_min, P33_min, P35_min, P35M_min, P35W_min, P38_min, P41_min, P42_min, P45_min, P46_min, P47_min)"></td>
<td><label id="P43LOT_min" name="P43LOT_min" size="3" style="text-align: left;">Lot</label></td>
<td><input type="text" name="P43_mindoz" id="P43_mindoz" size="6"></td>
<td><label id="P43Doz_min" name="P43Doz_min" size="3" style="text-align: left;">Doz</label></td>
</tr>  

<tr>
<td><label id="P45" name="P45" size="6">P45</label></td> 
<td><input type="text" name="P45_max" id="P45_max" size="6" onkeyup="return autocalearn(this, P27_max, P28_max, P30_max, P32W_max, P33_max, P35_max, P35M_max, P35W_max, P38_max, P41_max, P42_max, P43_max, P46_max, P47_max)"></td>
<td><label id="P45LOT_max" name="P45LOT_max" size="3" style="text-align: left;">Lot</label></td>
<td><input type="text" name="P45_maxdoz" id="P45_maxdoz" size="6"></td>
<td><label id="P45Doz_max" name="P45Doz_max" size="3" style="text-align: left;">Doz</label></td>
<td><input type="text" name="P45_min" id="P45_min" size="6" onkeyup="return autocalmin(this, P27_min, P28_min, P30_min, P32W_min, P33_min, P35_min, P35M_min, P35W_min, P38_min, P41_min, P42_min, P43_min, P46_min, P47_min)"></td>
<td><label id="P45LOT_min" name="P45LOT_min" size="3" style="text-align: left;">Lot</label></td>
<td><input type="text" name="P45_mindoz" id="P45_mindoz" size="6"></td>
<td><label id="P45Doz_min" name="P45Doz_min" size="3" style="text-align: left;">Doz</label></td>
</tr>  

<tr>
<td><label id="P46" name="P46" size="6">P46</label></td> 
<td><input type="text" name="P46_max" id="P46_max" size="6" onkeyup="return autocalearn(this, P27_max, P28_max, P30_max, P32W_max, P33_max, P35_max, P35M_max, P35W_max, P38_max, P41_max, P42_max, P43_max, P45_max, P47_max)"></td>
<td><label id="P46LOT_max" name="P46LOT_max" size="3" style="text-align: left;">Lot</label></td>
<td><input type="text" name="P46_maxdoz" id="P46_maxdoz" size="6"></td>
<td><label id="P46Doz_max" name="P46Doz_max" size="3" style="text-align: left;">Doz</label></td>
<td><input type="text" name="P46_min" id="P46_min" size="6" onkeyup="return autocalmin(this, P27_min, P28_min, P30_min, P32W_min, P33_min, P35_min, P35M_min, P35W_min, P38_min, P41_min, P42_min, P43_min, P45_min, P47_min)"></td>
<td><label id="P46LOT_min" name="P46LOT_min" size="3" style="text-align: left;">Lot</label></td>
<td><input type="text" name="P46_mindoz" id="P46_mindoz" size="6"></td>
<td><label id="P46Doz_min" name="P46Doz_min" size="3" style="text-align: left;">Doz</label></td>
</tr>  

<tr>
<td><label id="P47" name="P47" size="6">P47</label></td> 
<td><input type="text" name="P47_max" id="P47_max" size="6" onkeyup="return autocalearn(this, P27_max, P28_max, P30_max, P32W_max, P33_max, P35_max, P35M_max, P35W_max, P38_max, P41_max, P42_max, P43_max, P45_max, P46_max)"></td>
<td><label id="P47LOT_max" name="P47LOT_max" size="3" style="text-align: left;">Lot</label></td>
<td><input type="text" name="P47_maxdoz" id="P47_maxdoz" size="6"></td>
<td><label id="P47Doz_max" name="P47Doz_max" size="3" style="text-align: left;">Doz</label></td>
<td><input type="text" name="P47_min" id="P47_min" size="6" onkeyup="return autocalmin(this, P27_min, P28_min, P30_min, P32W_min, P33_min, P35_min, P35M_min, P35W_min, P38_min, P41_min, P42_min, P43_min, P45_min, P46_min)"></td>
<td><label id="P47LOT_min" name="P47LOT_min" size="3" style="text-align: left;">Lot</label></td>
<td><input type="text" name="P47_mindoz" id="P47_mindoz" size="6"></td>
<td><label id="P47Doz_min" name="P47Doz_min" size="3" style="text-align: left;">Doz</label></td>
</tr>  
<tr>
<td><label id="Total" name="Total" size="6"><b>Total</b><label></td> 
<td><input type="text" name="Total_max" id="Total_max" size="6"></td>
<td><label id="TotalLOT_max" name="TotalLOT_max" size="3" style="text-align: left;">Lot</label></td>
<td><input type="text" name="Total_maxdoz" id="Total_maxdoz" size="6"></td>
<td><label id="TotalDoz_max" name="TotalDoz_max" size="3" style="text-align: left;">Doz</label></td>
<td><input type="text" name="Total_min" id="Total_min" size="6"></td>
<td><label id="TotalLOT_min" name="TotalLOT_min" size="3" style="text-align: left;">Lot</label></td>
<td><input type="text" name="Total_mindoz" id="Total_mindoz" size="6"></td>
<td><label id="TotalDoz_min" name="TotalDoz_min" size="3" style="text-align: left;">Doz</label></td>
</tr>  
</table>
</center>
</div>
<div id="footer_button">
<input type="button" name="SAVE" value="SAVE" style="width: 25%;">
<input type="button" name="CANCEL" value="CANCEL">
</div>
</form>
</html>

 

I attach the sample imge of my webpage.

post-101569-13482403306555_thumb.jpg

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
 Share
Go to topic listing
×
×
  • 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.