Calculation Logic... [Archive]

prince

04-05-2005, 09:52 PM

Hi all !

I am in need of a calculation Logic which can do following functions. Just Calculation of rows to be filled with data under CHANGE Column of table T3
would suffice my need.

THERE IS A TABLE T1 WHICH NEED TO BE FILLED BY USER AFTER PICKING VALUES FROM TABLE T2 (MARKED WITH AVAILABLE ONLY).
ON SELECTION OF THESE VALUES WHEN USER SUBMITTS THE PAGE IT SHOULD PERFORM SOME CALCULATIONS TO ADJUST THE VALUES AND DISPLAY A TABLE LIKE T3.

CAN IT BE MADE LIKE THIS USING JAVA ???
a ZILLION THANKS IN ADVANCE IF THERE IS SOLUTION WITH YOU..

The Exaple code... just cut and paste in your machine to see the page..

<html><head>
<SCRIPT LANGUAGE="JavaScript">

function check(){
tbl = document.getElementById("myTable");
if (tbl.rows[2].cells[3].childNodes[0].nodeValue == "Available") {
alert(tbl.rows[2].cells[1].childNodes[0].nodeValue);
}
}

</SCRIPT>
</head><Body><form name="test" action="">

Enter the values in table T1 below.
<Table id="myTab" border=1>
<tr><td>Name:size</td><td>Qty</td></tr>
<tr><td>Round:1-10</td><td> <input value=> </td></tr>
<tr><td>Plane:11-35</td><td><input value=></td></tr>
<tr><td>Sheet:26-40</td><td><input value=></td></tr>

</Table> <br>

Chose the values from table T2 below to fill in T1 above.
<Table id="myTable" border=1>
<tr><td>Name:size</td><td>Min</td> <td>Max</td> <td>Remark</td> </tr>
<tr><td>A:1-10</td><td> 1 </td><td>10</td> <td>--</td> </tr>
<tr><td>XX:11-20</td><td>11</td><td>20</td> <td>Available</td> </tr>
<tr><td>XX:21-30</td><td>21</td><td>30</td> <td>Available</td> </tr>
<tr><td>A:31-40</td><td>31</td><td>40</td> <td>--</td> </tr>
<tr><td>XX:41-50</td><td>41</td><td>50</td> <td>Available</td> </tr>
</Table>

<BR>
<input type="submit" value = "submit" onClick="check(this)">
</form>
</body>
</html>
<br>
The changes made are :

<Table id="myTable1" border=1>
<tr><td>Name:size</td><td>Min</td> <td>Max</td> <td>Changes/td> </tr>
<tr><td>A:1-10</td><td> 1 </td><td>10</td> <td>--</td> </tr>
<tr><td>XX:11-20</td><td>11</td><td>20</td> <td>Round:1-10</td> </tr>
<tr><td>XX:21-30</td><td>21</td><td>30</td> <td>Plane:11-30</td> </tr>
<tr><td>A:31-40</td><td>31</td><td>40</td> <td>--</td> </tr>
<tr><td>XX:41-50</td><td>41</td><td>50</td> <td>Plane:31-25</td> </tr>
<tr><td>XX:41-50</td><td>41</td><td>50</td> <td>Sheet:26-30</td> </tr>
</Table>
<Table border=1>
<tr><td><value="">-------------</td><td><value="">---</td><td><value="">---</td> <td>Sheet:31-40</td> </tr>
</Table>