Hi…
I just want to know how can I compute the Total Maximum Dozen while I’m input number in the textboxes from Maximum Lot.
Now, in my code:
When I input in textbox from Maximum lot it computes the Maximum Dozen and Total Maximum Lot, and the Total Maximum Dozen was only compute or change when I press the key on the textbox from Maximum Dozen.
I want to happen is:when I input in Maximum Lot textboxes the total Maximum Lot, Maximum Dozen, and Total Maximum Dozen will compute.
Here is my code:
<html>
<head>
<title>Half Shell</title>
<link rel="stylesheet" type="text/css" href="kanban.css" />
<script type="text/javascript">
//auto compute Total Max
function autocalearn(oText)
{
var P28_max_lot = document.getElementById("P28_max_lot").value;
var P28_bch_wt = document.getElementById("P28_bch_wt").value;
var P28_plug_wt = document.getElementById("P28_plug_wt").value;
var P28_max_convert = (parseFloat(P28_max_lot) * ((parseFloat(P28_bch_wt))* parseFloat(1000)) / parseFloat(P28_plug_wt) / parseFloat(12));
if( !isNaN(P28_max_convert) ){
var P28_max_doz = document.getElementById("P28_max_doz").value = P28_max_convert.toFixed(2);
}
var P30_max_lot = document.getElementById("P30_max_lot").value;
var P30_bch_wt = document.getElementById("P30_bch_wt").value;
var P30_plug_wt = document.getElementById("P30_plug_wt").value;
var P30_max_convert = (parseFloat(P30_max_lot) * ((parseFloat(P30_bch_wt))* parseFloat(1000)) / parseFloat(P30_plug_wt) / parseFloat(12));
if( !isNaN(P30_max_convert) ){
var P30_max_doz = document.getElementById("P30_max_doz").value = P30_max_convert.toFixed(2);
}
var P32_max_lot = document.getElementById("P32_max_lot").value;
var P32_bch_wt = document.getElementById("P32_bch_wt").value;
var P32_plug_wt = document.getElementById("P32_plug_wt").value;
var P32_max_convert = (parseFloat(P32_max_lot) * ((parseFloat(P32_bch_wt))* parseFloat(1000)) / parseFloat(P32_plug_wt) / parseFloat(12));
if( !isNaN(P32_max_convert) ){
var P32_max_doz = document.getElementById("P32_max_doz").value = P32_max_convert.toFixed(2);
}
var P33_max_lot = document.getElementById("P33_max_lot").value;
var P33_bch_wt = document.getElementById("P33_bch_wt").value;
var P33_plug_wt = document.getElementById("P33_plug_wt").value;
var P33_max_convert = (parseFloat(P33_max_lot) * ((parseFloat(P33_bch_wt))* parseFloat(1000)) / parseFloat(P33_plug_wt) / parseFloat(12));
if( !isNaN(P33_max_convert) ){
var P33_max_doz = document.getElementById("P33_max_doz").value = P33_max_convert.toFixed(2);
}
var P35_max_lot = document.getElementById("P35_max_lot").value;
var P35_bch_wt = document.getElementById("P35_bch_wt").value;
var P35_plug_wt = document.getElementById("P35_plug_wt").value;
var P35_max_convert = (parseFloat(P35_max_lot) * ((parseFloat(P35_bch_wt))* parseFloat(1000)) / parseFloat(P35_plug_wt) / parseFloat(12));
if( !isNaN(P35_max_convert) ){
var P35_max_doz = document.getElementById("P35_max_doz").value = P35_max_convert.toFixed(2);
}
var P35M_max_lot = document.getElementById("P35M_max_lot").value;
var P35M_bch_wt = document.getElementById("P35M_bch_wt").value;
var P35M_plug_wt = document.getElementById("P35M_plug_wt").value;
var P35M_max_convert = (parseFloat(P35M_max_lot) * ((parseFloat(P35M_bch_wt))* parseFloat(1000)) / parseFloat(P35M_plug_wt) / parseFloat(12));
if( !isNaN(P35M_max_convert) ){
var P35M_max_doz = document.getElementById("P35M_max_doz").value = P35M_max_convert.toFixed(2);
}
var P35W_max_lot = document.getElementById("P35W_max_lot").value;
var P35W_bch_wt = document.getElementById("P35W_bch_wt").value;
var P35W_plug_wt = document.getElementById("P35W_plug_wt").value;
var P35W_max_convert = (parseFloat(P35W_max_lot) * ((parseFloat(P35W_bch_wt))* parseFloat(1000)) / parseFloat(P35W_plug_wt) / parseFloat(12));
if( !isNaN(P35W_max_convert) ){
var P35W_max_doz = document.getElementById("P35W_max_doz").value = P35W_max_convert.toFixed(2);
}
var P38_max_lot = document.getElementById("P38_max_lot").value;
var P38_bch_wt = document.getElementById("P38_bch_wt").value;
var P38_plug_wt = document.getElementById("P38_plug_wt").value;
var P38_max_convert = (parseFloat(P38_max_lot) * ((parseFloat(P38_bch_wt))* parseFloat(1000)) / parseFloat(P38_plug_wt) / parseFloat(12));
if( !isNaN(P38_max_convert) ){
var P38_max_doz = document.getElementById("P38_max_doz").value = P38_max_convert.toFixed(2);
}
if (isNaN(oText.value))
{
alert('Numbers only!');
oText.value = '';
}
var field, val, oForm = oText.form, Total_max_lot = a = 0;
for (a; a < arguments.length; ++a) //loop through text elements
{
field = arguments[a];
val = parseFloat(field.value);
if (!isNaN(val)) //number?
{
Total_max_lot += val;
}
}
oForm.Total_max_lot.value = Total_max_lot.toFixed(2);
}
</script>
<script type="text/javascript">
//Auto convert to Doz and auto compute total max doz
function doz(oText){
if (isNaN(oText.value))
{
oText.value = '';
}
var field, val, oForm = oText.form, Total_max_doz = a = 0;
for (a; a < arguments.length; ++a) //loop through text elements
{
field = arguments[a];
val = parseFloat(field.value);
if (!isNaN(val)) //number?
{
Total_max_doz += val;
}
}
oForm.Total_max_doz.value = Total_max_doz.toFixed(2);
}
</script>
</head>
<?php
date_default_timezone_set("Asia/Singapore");
$con = mysql_connect('localhost', 'root','');
if (!$con) {
echo 'failed';
die();
}
mysql_select_db("mes", $con);
?>
<body>
<form name="loading_kanban" action="" method="post" onSubmit="return false">
<div id="fieldset_PS">
<table>
<th>Compounds</th>
<th>Max</th>
<th>UoM</th>
<th>Max</th>
<th>UoM</th>
<tr>
<td><input type="text" name="P28" id="P28" value="P28" ></td>
<td><input type="text" name="P28_max_lot" id="P28_max_lot" value="<?php echo $P28_max_lot; ?>" onkeyup="return autocalearn(this, P30_max_lot, P32_max_lot, P33_max_lot, P35_max_lot, P35M_max_lot, P35W_max_lot, P38_max_lot, P40_max_lot, P41_max_lot, P42_max_lot, P43_max_lot, P46_max_lot, P47_max_lot)" ></td>
<td><input type="text" name="P28_max_lot_uom" id="P28_max_lot_uom" value="Lot" ></td>
<td><b><input type="text" name="P28_max_doz" id="P28_max_doz" value="<?php echo $P28_max_doz;?>" onkeyup="return doz(P28_max_doz, P30_max_doz, P32_max_doz, P33_max_doz, P35_max_doz, P35M_max_doz, P35W_max_doz, P38_max_doz, P40_max_doz, P41_max_doz, P42_max_doz, P43_max_doz, P46_max_doz, P47_max_doz)" ></b></td>
<td><input type="text" name="P28_max_doz_uom" id="P28_max_doz_uom" value="Doz" ></td>
</tr>
<tr>
<td><input type="text" name="P30" id="P30" value="P30" ></td>
<td><input type="text" name="P30_max_lot" id="P30_max_lot" value="<?php echo $P30_max_lot;?>" onkeyup="return autocalearn(this, P28_max_lot, P32_max_lot, P33_max_lot, P35_max_lot, P35M_max_lot, P35W_max_lot, P38_max_lot, P40_max_lot, P41_max_lot, P42_max_lot, P43_max_lot, P46_max_lot, P47_max_lot)" ></td>
<td><input type="text" name="P30_max_lot_uom" id="P30_max_lot_uom" value="Lot" ></td>
<td><b><input type="text" name="P30_max_doz" id="P30_max_doz" value="<?php echo $P30_max_doz; ?>" onkeyup="return doz(this, P28_max_doz, P32_max_doz, P33_max_doz, P35_max_doz, P35M_max_doz, P35W_max_doz, P38_max_doz, P40_max_doz, P41_max_doz, P42_max_doz, P43_max_doz, P46_max_doz, P47_max_doz)"></b></td>
<td><input type="text" name="P30_max_doz_uom" id="P30_max_doz_uom" value="Doz" ></td>
</tr>
<tr>
<td><input type="text" name="P32" id="P32" value="P32" ></td>
<td><input type="text" name="P32_max_lot" id="P32_max_lot" value="<?php echo $P32_max_lot ;?>" onkeyup="return autocalearn(this, P28_max_lot, P30_max_lot, P33_max_lot, P35_max_lot, P35M_max_lot, P35W_max_lot, P38_max_lot, P40_max_lot, P41_max_lot, P42_max_lot, P43_max_lot, P46_max_lot, P47_max_lot)" ></td>
<td><input type="text" name="P32_max_lot_uom" id="P32_max_lot_uom" value="Lot" ></td>
<td><b><input type="text" name="P32_max_doz" id="P32_max_doz" value="<?php echo $P32_max_doz; ?>" onkeyup="return doz(this, P28_max_doz, P30_max_doz, P33_max_doz, P35_max_doz, P35M_max_doz, P35W_max_doz, P38_max_doz, P40_max_doz, P41_max_doz, P42_max_doz, P43_max_doz, P46_max_doz, P47_max_doz)"></b></td>
<td><input type="text" name="P32_max_doz_uom" id="P32_max_doz_uom" value="Doz" ></td>
</tr>
<tr>
<td><input type="text" name="P33" id="P33" value="P33" ></td>
<td><input type="text" name="P33_max_lot" id="P33_max_lot" value="<?php echo $P33_max_lot; ?>" onkeyup="return autocalearn(this, P28_max_lot, P30_max_lot, P32_max_lot, P35_max_lot, P35M_max_lot, P35W_max_lot, P38_max_lot, P40_max_lot, P41_max_lot, P42_max_lot, P43_max_lot, P46_max_lot, P47_max_lot)" ></td>
<td><input type="text" name="P33_max_lot_uom" id="P33_max_lot_uom" value="Lot" ></td>
<td><b><input type="text" name="P33_max_doz" id="P33_max_doz" value="<?php echo $P33_max_doz; ?>" onkeyup="return doz(this, P28_max_doz, P30_max_doz, P32_max_doz, P35_max_doz, P35M_max_doz, P35W_max_doz, P38_max_doz, P40_max_doz, P41_max_doz, P42_max_doz, P43_max_doz, P46_max_doz, P47_max_doz)"></b></td>
<td><input type="text" name="P33_max_doz_uom" id="P33_max_doz_uom" value="Doz" ></td>
</tr>
<tr>
<td><input type="text" name="P35" id="P35" value="P35"></td>
<td><input type="text" name="P35_max_lot" id="P35_max_lot" value="<?php echo $P35_max_lot; ?>" onkeyup="return autocalearn(this, P28_max_lot, P30_max_lot, P32_max_lot, P33_max_lot, P35M_max_lot, P35W_max_lot, P38_max_lot, P40_max_lot, P41_max_lot, P42_max_lot, P43_max_lot, P46_max_lot, P47_max_lot)" ></td>
<td><input type="text" name="P35_max_lot_uom" id="P35_max_lot_uom" value="Lot" ></td>
<td><b><input type="text" name="P35_max_doz" id="P35_max_doz" value="<?php echo $P35_max_doz; ?>" onkeyup="return doz(this, P28_max_doz, P30_max_doz, P32_max_doz, P33_max_doz,P35M_max_doz, P35W_max_doz, P38_max_doz, P40_max_doz, P41_max_doz, P42_max_doz, P43_max_doz, P46_max_doz, P47_max_doz)"></b></td>
<td><input type="text" name="P35_max_doz_uom" id="P35_max_doz_uom" value="Doz" ></td>
</tr>
<tr>
<td><input type="text" name="P35M" id="P35M" value="P35M"></td>
<td><input type="text" name="P35M_max_lot" id="P35M_max_lot" value="<?php echo $P35M_max_lot; ?>" onkeyup="return autocalearn(this, P28_max_lot, P30_max_lot, P32_max_lot, P33_max_lot, P35_max_lot, P35W_max_lot, P38_max_lot, P40_max_lot, P41_max_lot, P42_max_lot, P43_max_lot, P46_max_lot, P47_max_lot)" ></td>
<td><input type="text" name="P35M_max_lot_uom" id="P35M_max_lot_uom" value="Lot" ></td>
<td><b><input type="text" name="P35M_max_doz" id="P35M_max_doz" value="<?php echo $P35M_max_doz; ?>" onkeyup="return doz(this, P28_max_doz, P30_max_doz, P32_max_doz, P33_max_doz,P35_max_doz, P35W_max_doz, P38_max_doz, P40_max_doz, P41_max_doz, P42_max_doz, P43_max_doz, P46_max_doz, P47_max_doz)"></b></td>
<td><input type="text" name="P35M_max_doz_uom" id="P35M_max_doz_uom" value="Doz" ></td>
</tr>
<tr>
<td><input type="text" name="P35W" id="P35W" value="P35W"></td>
<td><input type="text" name="P35W_max_lot" id="P35W_max_lot" value="<?php echo $P35W_max_lot; ?>" onkeyup="return autocalearn(this, P28_max_lot, P30_max_lot, P32_max_lot, P33_max_lot, P35_max_lot, P35M_max_lot, P38_max_lot, P40_max_lot, P41_max_lot, P42_max_lot, P43_max_lot, P46_max_lot, P47_max_lot)" ></td>
<td><input type="text" name="P35W_max_lot_uom" id="P35W_max_lot_uom" value="Lot" ></td>
<td><b><input type="text" name="P35W_max_doz" id="P35W_max_doz" value="<?php echo $P35W_max_doz; ?>" onkeyup="return doz(this, P28_max_doz, P30_max_doz, P32_max_doz, P33_max_doz,P35_max_doz, P35M_max_doz, P38_max_doz, P40_max_doz, P41_max_doz, P42_max_doz, P43_max_doz, P46_max_doz, P47_max_doz)"></b></td>
<td><input type="text" name="P35W_max_doz_uom" id="P35W_max_doz_uom" value="Doz" ></td>
</tr>
<tr>
<td><input type="text" name="P38" id="P38" value="P38" ></td>
<td><input type="text" name="P38_max_lot" id="P38_max_lot" value="<?php echo $P38_max_lot; ?>" size="8" onkeyup="return autocalearn(this, P28_max_lot, P30_max_lot, P32_max_lot, P33_max_lot, P35_max_lot, P35M_max_lot, P35W_max_lot, P40_max_lot, P41_max_lot, P42_max_lot, P43_max_lot, P46_max_lot, P47_max_lot)" ></td>
<td><input type="text" name="P38_max_lot_uom" id="P38_max_lot_uom" value="Lot" ></td>
<td><b><input type="text" name="P38_max_doz" id="P38_max_doz" value="<?php echo $P38_max_doz; ?>" onkeyup="return doz(this, P28_max_doz, P30_max_doz, P32_max_doz, P33_max_doz,P35_max_doz, P35M_max_doz, P35W_max_doz, P40_max_doz, P41_max_doz, P42_max_doz, P43_max_doz, P46_max_doz, P47_max_doz)"></b></td>
<td><input type="text" name="P38_max_doz_uom" id="P38_max_doz_uom" value="Doz" ></td>
</tr>
<tr>
<td><input type="text" name="Total" id="Total" value="Total" ></td>
<td><input type="text" name="Total_max_lot" id="Total_max_lot" value="<?php echo $Total_max_lot; ?>" ></td>
<td><input type="text" name="Total_max_lot_uom" id="Total_max_lot_uom" value="Lot" ></td>
<td><b><input type="text" name="Total_max_doz" id="Total_max_doz" value="<?php echo $Total_max_doz; ?>"></b></td>
<td><input type="text" name="Total_max_doz_uom" id="Total_max_doz_uom" value="Doz" ></td>
</tr>
</table>
</div>
</form>
</body>
</html>
Can you do me additional favor?If you have time kindly visit this site:<snip />
Thank you so much