|
|
|
สอบถาม การคำนวนเงิน อัตโนมัติ....ใช้ php javascript เก็บจำนวนกับราคาใน textbox รูปแบบ array |
|
|
|
|
|
|
|
มันยังไม่คำนวณไห้เลยค่ะ
<html>
<head>
<title>บันทึกใบสั่งซื้อรถจักรยานยนต์</title>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>
<script language="javascript">
function OpenPopup(intLine)
{
window.open('2.php?Line='+intLine,'myPopup');
}
function OpenPopup2(intLine)
{
window.open('3.php?Line='+intLine,'myPopup');
}
function textsum(){
function calA(i){
//alert("document.frmbegcomplete.price[i].length");
var d = function (){
var k = document.frmbegcomplete['price[]'][i];
var p = document.frmbegcomplete['amount[]'][i];
var a = document.frmbegcomplete['total[]'][i];
k.value = k.value.replace(/[^\d\.]/g,'');
p.value = p.value.replace(/[^\d\.]/g,'');
a.value = (k.value*1) * (p.value*1);
if (a.value <= 0){
a.style.color = 'red';
} else {
a.style.color = 'black';
}
}
return d;
}
for(var i=0;i<document.frmbegcomplete['price[]'].length;i++){
//alert("parseInt(eval("document.frmbegcomplete['price[]'].value"))");
document.frmbegcomplete['price[]'][i].onkeyup = calA(i);
document.frmbegcomplete['amount[]'][i].onkeyup = calA(i);
}
}
function CreateNewRow()
{
var intLine = parseInt(document.frmMain.hdnMaxLine.value);
intLine++;
var theTable = document.getElementById("tbExp");
var newRow = theTable.insertRow(theTable.rows.length)
newRow.id = newRow.uniqueID
var newCell
//*** Column No ***//
newCell = newRow.insertCell(0);
newCell.id = newCell.uniqueID;
newCell.setAttribute("className", "css-name");
newCell.innerHTML = "<center>"+intLine+"</center>";
//*** Column type_id ***//
newCell = newRow.insertCell(1);
newCell.id = newCell.uniqueID;
newCell.setAttribute("className", "css-name");
//newCell.setAttribute("OnClick", "OpenPopup('"+intLine+"')");
newCell.innerHTML = "<center><INPUT TYPE=\"TEXT\" NAME=\"type_id[]"+intLine+"\" ID=\"type_id[]"+intLine+"\" VALUE=\"...\" OnClick=\"OpenPopup('"+intLine+"')\"></center>";
//*** Column type_name ***//
newCell = newRow.insertCell(2);
newCell.id = newCell.uniqueID;
newCell.setAttribute("className", "css-name");
newCell.innerHTML = "<center><INPUT TYPE=\"TEXT\" SIZE=\"5\" NAME=\"type_name[]"+intLine+"\" ID=\"type_name[]"+intLine+"\" VALUE=\"\"></center>";
//*** Column color_name ***//
newCell = newRow.insertCell(3);
newCell.id = newCell.uniqueID;
newCell.setAttribute("className", "css-name");
//newCell.setAttribute("OnClick", "OpenPopup('"+intLine+"')");
newCell.innerHTML = "<center><INPUT TYPE=\"TEXT\" NAME=\"color_name[]"+intLine+"\" ID=\"color_name[]"+intLine+"\" VALUE=\"...\" OnClick=\"OpenPopup2('"+intLine+"')\"></center>";
//*** Column unit ***//
newCell = newRow.insertCell(4);
newCell.id = newCell.uniqueID;
newCell.setAttribute("className", "css-name");
newCell.innerHTML = "<center><INPUT TYPE=\"TEXT\" SIZE=\"5\" NAME=\"unit[]"+intLine+"\" ID=\"unit[]"+intLine+"\" VALUE=\"คัน\"></center>"
//*** Column amount ***//
newCell = newRow.insertCell(5);
newCell.id = newCell.uniqueID;
newCell.setAttribute("className", "css-name");
newCell.innerHTML = "<center><INPUT TYPE=\"TEXT\" SIZE=\"5\" NAME=\"amount[]"+intLine+"\" ID=\"amount[]"+intLine+"\" VALUE=\"\" OnChange=\"chkNum(this);textsum();\" onfocus=\"textsum();\" onblur=\"textsum();\" onkeyup=\"textsum();\"></center>";
//*** Column price ***//
newCell = newRow.insertCell(6);
newCell.id = newCell.uniqueID;
newCell.setAttribute("className", "css-name");
newCell.innerHTML = "<center><INPUT TYPE=\"TEXT\" SIZE=\"5\" NAME=\"price[]"+intLine+"\" ID=\"price[]"+intLine+"\" VALUE=\"\" OnChange=\"chkNum(this);textsum();\" onfocus=\"textsum();\" onblur=\"textsum();\" onkeyup=\"textsum();\" ></center>";
document.frmMain.hdnMaxLine.value = intLine;
//*** Column total ***//
newCell = newRow.insertCell(7);
newCell.id = newCell.uniqueID;
newCell.setAttribute("className", "css-name");
newCell.innerHTML = "<center><INPUT TYPE=\"TEXT\" SIZE=\"5\" NAME=\"total[]"+intLine+"\" ID=\"total[]"+intLine+"\" VALUE=\"\" OnChange=\"chkNum(this);textsum();\" onfocus=\"textsum();\" onblur=\"textsum();\" onkeyup=\"textsum();\"></center>";
document.frmMain.hdnMaxLine.value = intLine;
}
function RemoveRow()
{
intLine = parseInt(document.frmMain.hdnMaxLine.value);
if(parseInt(intLine) > 0)
{
theTable = document.getElementById("tbExp");
theTableBody = theTable.tBodies[0];
theTableBody.deleteRow(intLine);
intLine--;
document.frmMain.hdnMaxLine.value = intLine;
}
}
</script>
<body OnLoad="CreateNewRow();">
<form name="frmMain" method="post" action="readData.php">
<table width="859" height="78" border="1" id="tbExp" cellpadding="0" cellspacing="0">
<tr>
<td><div align="center">ลำดับ </div></td>
<td><div align="center">รหัส </div></td>
<td><div align="center">รายละเอียด </div></td>
<td><div align="center">สี </div></td>
<td><div align="center">หน่วย </div></td>
<td><div align="center">จำนวน</div></td>
<td><div align="center">ราคา:หน่วย (บาท)</div></td>
<td><div align="center">รวมเป็นเงิน (บาท)</div></td>
</tr>
</table>
<input type="hidden" name="hdnMaxLine" value="0" >
<input name="btnAdd" type="button" id="btnAdd" value="+" onClick="CreateNewRow();">
<input name="btnDel" type="button" id="btnDel" value="-" onClick="RemoveRow();">
<input type="submit" name="btnSubmit" value="Submit">
</form>
</body>
</html>
Tag : PHP, MySQL
|
|
|
|
|
|
Date :
2013-04-30 14:53:14 |
By :
lookpla26 |
View :
1594 |
Reply :
5 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
เงียบ.........
|
|
|
|
|
Date :
2013-04-30 15:13:02 |
By :
lookpla26 |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
แก้ไข แอตทริบิว id ไม่ต้องมี []
แก้ไข แอตทริบิว name ไม่มีต้องตัวเลข ก็ได้ หรือถ้าจะให้มีตัวเลข ต้องอยู่ในวงเล็บ name="price[1]"
แก้ไขฟังก์ชั่นคำนวน ให้เอาค่า price{x} * amout{x}
<html>
<head>
<title>บันทึกใบสั่งซื้อรถจักรยานยนต์</title>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>
<script language="javascript">
function OpenPopup(intLine)
{
window.open('2.php?Line='+intLine,'myPopup');
}
function OpenPopup2(intLine)
{
window.open('3.php?Line='+intLine,'myPopup');
}
function textsum(rowId){
var amount = document.getElementById('amount'+rowId).value;
var price = document.getElementById('price'+rowId).value;
var total = amount*price;
document.getElementById('total'+rowId).value = total;
}
function CreateNewRow()
{
var intLine = parseInt(document.frmMain.hdnMaxLine.value);
intLine++;
var theTable = document.getElementById("tbExp");
var newRow = theTable.insertRow(theTable.rows.length)
newRow.id = newRow.uniqueID
var newCell
//*** Column No ***//
newCell = newRow.insertCell(0);
newCell.id = newCell.uniqueID;
newCell.setAttribute("className", "css-name");
newCell.innerHTML = "<center>"+intLine+"</center>";
//*** Column type_id ***//
newCell = newRow.insertCell(1);
newCell.id = newCell.uniqueID;
newCell.setAttribute("className", "css-name");
//newCell.setAttribute("OnClick", "OpenPopup('"+intLine+"')");
newCell.innerHTML = "<center><INPUT TYPE=\"TEXT\" NAME=\"type_id[]\" ID=\"type_id"+intLine+"\" VALUE=\"...\" OnClick=\"OpenPopup('"+intLine+"')\"></center>";
//*** Column type_name ***//
newCell = newRow.insertCell(2);
newCell.id = newCell.uniqueID;
newCell.setAttribute("className", "css-name");
newCell.innerHTML = "<center><INPUT TYPE=\"TEXT\" SIZE=\"5\" NAME=\"type_name[]\" ID=\"type_name"+intLine+"\" VALUE=\"\"></center>";
//*** Column color_name ***//
newCell = newRow.insertCell(3);
newCell.id = newCell.uniqueID;
newCell.setAttribute("className", "css-name");
//newCell.setAttribute("OnClick", "OpenPopup('"+intLine+"')");
newCell.innerHTML = "<center><INPUT TYPE=\"TEXT\" NAME=\"color_name[]\" ID=\"color_name"+intLine+"\" VALUE=\"...\" OnClick=\"OpenPopup2('"+intLine+"')\"></center>";
//*** Column unit ***//
newCell = newRow.insertCell(4);
newCell.id = newCell.uniqueID;
newCell.setAttribute("className", "css-name");
newCell.innerHTML = "<center><INPUT TYPE=\"TEXT\" SIZE=\"5\" NAME=\"unit[]\" ID=\"unit"+intLine+"\" VALUE=\"คัน\"></center>"
//*** Column amount ***//
newCell = newRow.insertCell(5);
newCell.id = newCell.uniqueID;
newCell.setAttribute("className", "css-name");
newCell.innerHTML = "<center><INPUT TYPE=\"TEXT\" SIZE=\"5\" NAME=\"amount[]\" ID=\"amount"+intLine+"\" VALUE=\"\" OnChange=\"chkNum(this);textsum("+intLine+");\" onfocus=\"textsum("+intLine+");\" onblur=\"textsum("+intLine+");\" onkeyup=\"textsum("+intLine+");\"></center>";
//*** Column price ***//
newCell = newRow.insertCell(6);
newCell.id = newCell.uniqueID;
newCell.setAttribute("className", "css-name");
newCell.innerHTML = "<center><INPUT TYPE=\"TEXT\" SIZE=\"5\" NAME=\"price[]\" ID=\"price"+intLine+"\" VALUE=\"\" OnChange=\"chkNum(this);textsum("+intLine+");\" onfocus=\"textsum("+intLine+");\" onblur=\"textsum("+intLine+");\" onkeyup=\"textsum("+intLine+");\" ></center>";
document.frmMain.hdnMaxLine.value = intLine;
//*** Column total ***//
newCell = newRow.insertCell(7);
newCell.id = newCell.uniqueID;
newCell.setAttribute("className", "css-name");
newCell.innerHTML = "<center><INPUT TYPE=\"TEXT\" SIZE=\"5\" NAME=\"total[]\" ID=\"total"+intLine+"\" VALUE=\"\" OnChange=\"chkNum(this);textsum("+intLine+");\" onfocus=\"textsum("+intLine+");\" onblur=\"textsum("+intLine+");\" onkeyup=\"textsum("+intLine+");\"></center>";
document.frmMain.hdnMaxLine.value = intLine;
}
function RemoveRow()
{
intLine = parseInt(document.frmMain.hdnMaxLine.value);
if(parseInt(intLine) > 0)
{
theTable = document.getElementById("tbExp");
theTableBody = theTable.tBodies[0];
theTableBody.deleteRow(intLine);
intLine--;
document.frmMain.hdnMaxLine.value = intLine;
}
}
</script>
<body OnLoad="CreateNewRow();">
<form name="frmMain" method="post" action="readData.php">
<table width="859" height="78" border="1" id="tbExp" cellpadding="0" cellspacing="0">
<tr>
<td><div align="center">ลำดับ </div></td>
<td><div align="center">รหัส </div></td>
<td><div align="center">รายละเอียด </div></td>
<td><div align="center">สี </div></td>
<td><div align="center">หน่วย </div></td>
<td><div align="center">จำนวน</div></td>
<td><div align="center">ราคา:หน่วย (บาท)</div></td>
<td><div align="center">รวมเป็นเงิน (บาท)</div></td>
</tr>
</table>
<input type="hidden" name="hdnMaxLine" value="0" >
<input name="btnAdd" type="button" id="btnAdd" value="+" onClick="CreateNewRow();">
<input name="btnDel" type="button" id="btnDel" value="-" onClick="RemoveRow();">
<input type="submit" name="btnSubmit" value="Submit">
</form>
</body>
</html>
|
|
|
|
|
Date :
2013-04-30 15:36:04 |
By :
Naizan |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Date :
2013-04-30 16:25:09 |
By :
Naizan |
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Load balance : Server 05
|