<?php
$sod_part = $_POST['sod_part'];
$sod_cu_part = $_POST['sod_cu_part'];
$sod_list_price = $_POST['sod_list_price'];
$sod_net_price = $_POST['sod_net_price'];
$sod_discount = $_POST['sod_discount'];
$sod_ord_um = $_POST['sod_ord_um'];
$sod_req_date = $_POST['sod_req_date'];
$sod_req_qty = $_POST['sod_req_qty'];
$sod_notes = $_POST['sod_notes'];
$add_num = $_POST['add_num'];
?>
<html>
<head>
<style rel="stylesheet" type="text/css" media="screen">
table.list {
border-collapse: collapse;
background: #fff;
border: 1px solid #999;
font-size: 12px;
margin: 2px 0;
}
tr.odd {
background: #EEE;
}
tr.odd:hover {
background: yellow;
}
tr.even {
background: #FFF;
}
tr.even:hover {
background: yellow;
}
td.prog_caption {
padding: 0px;
color: #355173;
font: bold 16pt Verdana;
border: 0px solid gold;
}
th.header {
color: #000;
padding: 0 5px;
font-weight: normal;
background: gold;
border: 1px solid #999;
}
th.header_v {
color: #fff;
font-weight: normal;
background: navy;
border: 1px solid blue;
padding: 0 5px;
width: 120px;
}
th.criteria {
padding: 0 5px;
color: #000;
font-weight: normal;
text-align: right;
background: #D8E4EB;
width: 120px;
}
td.data {
padding: 0 5px;
font-weight: normal;
background: #FFFF66;
width: 120px;
}
td.list {
padding: 0 1px;
border-bottom: 1px solid #DDD;
white-space: nowrap;
text-align:center;
}
fieldset.tab {
margin: 0;
padding: 5px;
border: 3px solid #6BA4D7;
}
fieldset.criteria {
padding: 0px 5px 2px;
}
legend.criteria {
padding: 0px 2px;
color: blue;
font-weight: bold;
font-family: Arial;
}
</style>
</head>
<script type="text/javascript"><!--
var sum;
sum=5;
function addDetailProcess(num){
var num;
var temp;
if(num==0){
num=1;
}
for (i=0;i<num;i++){
sum=sum+1;
if (sum % 2 == 0){
var newRow=tbDetailHide1.rows[0].cloneNode(true);
}
else if (sum % 2 != 0){
var newRow=tbDetailHide2.rows[0].cloneNode(true);
}
temp=sum*1;
newRow.all.a.value=temp;
tbDetailUsed.insertBefore(newRow);
}
}
function show_cu_info(){
document.myform.action="add.php";
document.myform.submit();
}
function autoInput(){
var e;
with(document.myform){
var tmp = so_discount.value;
var tmp1 = so_req_date.value;
for (var i=0;i<elements.length;i++){
e = elements[i];
if (e.tagName == "INPUT" && e.type.toLowerCase() == "text" && e.name.substr(0,12) == "sod_discount"){
e.value = tmp;
}
if (e.tagName == "INPUT" && e.type.toLowerCase() == "text" && e.name.substr(0,12) == "sod_req_date"){
e.value = tmp1;
}
}
}
}
//--></script>
<!--增加出来的表格样式(隐藏)-->
<table class="list" id="tbDetailHide1" style="display:none">
<tr class="even">
<td class="list center"><input type="text" name="a" size="2" readonly="readonly" style="color:#000;background-color:#FFF;border:none;text-align:center;"></td>
<td><input name="sod_part[]" type="text" size="15" maxlength="15" /></td>
<td><input name="sod_cu_part[]" type="text" size="15" maxlength="15" /></td>
<td><input name="sod_list_price[]" type="text" size="10" maxlength="15" /></td>
<td><input name="sod_net_price[]" type="text" size="10" maxlength="15" /></td>
<td><input name="sod_discount[]" type="text" size="10" maxlength="5" /></td>
<td><input name="sod_req_date[]" type="text" size="10" maxlength="20" /></td>
<td><input name="sod_req_qty[]" type="text" size="10" maxlength="15" /></td>
<td><input name="sod_ord_um[]" type="text" size="2" maxlength="2" /></td>
<td><input name="sod_notes[]" type="text" size="10" maxlength="20" /></td>
</tr>
</table>
<table class="list" id="tbDetailHide2" style="display:none">
<tr class="odd">
<td class="list center"><input type="text" name="a" size="2" readonly="readonly" style="color:#000;background-color:#EEE;border:none;text-align:center;"></td>
<td><input name="sod_part[]" type="text" size="15" maxlength="15" /></td>
<td><input name="sod_cu_part[]" type="text" size="15" maxlength="15" /></td>
<td><input name="sod_list_price[]" type="text" size="10" maxlength="15" /></td>
<td><input name="sod_net_price[]" type="text" size="10" maxlength="15" /></td>
<td><input name="sod_discount[]" type="text" size="10" maxlength="5" /></td>
<td><input name="sod_req_date[]" type="text" size="10" maxlength="20" /></td>
<td><input name="sod_req_qty[]" type="text" size="10" maxlength="15" /></td>
<td><input name="sod_ord_um[]" type="text" size="2" maxlength="2" /></td>
<td><input name="sod_notes[]" type="text" size="10" maxlength="20" /></td>
</tr>
</table>
<form name="myform" method="post" action="add.php">
<fieldset class="tab">
<legend class="criteria">DETAIL</legend>
<table class="list">
<tbody id="tbDetailUsed">
<tr>
<th class="header">Line</th>
<th class="header">Part-Num</th>
<th class="header">Cust-Part</th>
<th class="header">List-Price</th>
<th class="header">Net-Price</th>
<th class="header">Discount</th>
<th class="header">Date</th>
<th class="header">Qty</th>
<th class="header">UM</th>
<th class="header">Notes</th>
</tr>
<?php
for ($i=1;$i<=5;$i++){
if ($i % 2 == 0){
echo '<tr class="even">';
}
else{
echo '<tr class="odd">';
}
echo '
<td class="list center">'.$i.'<input name="sod_line[]" type="hidden" value="'.$i.'" /></td>
<td><input name="sod_part[]" type="text" size="15" maxlength="15" /></td>
<td><input name="sod_cu_part[]" type="text" size="15" maxlength="15" /></td>
<td><input name="sod_list_price[]" type="text" size="10" maxlength="15" /></td>
<td><input name="sod_net_price[]" type="text" size="10" maxlength="15" /></td>
<td><input name="sod_discount[]" type="text" size="10" maxlength="5" /></td>
<td><input name="sod_req_date[]" type="text" size="10" maxlength="20" /></td>
<td><input name="sod_req_qty[]" type="text" size="10" maxlength="15" /></td>
<td><input name="sod_ord_um[]" type="text" size="2" maxlength="2" /></td>
<td><input name="sod_notes[]" type="text" size="10" maxlength="20" /></td>
</tr>';
}
?>
</tbody></table>
Add <input name="add_num" type="text" size="2" maxlength="2" />records
<input name="add_btn" type="button" value="Add" οnclick="addDetailProcess(document.myform.add_num.value)" />
<input name="save" type="submit" value="Save" />
</fieldset>
</form>
<?php
if ( $_POST['save'] != ''){
foreach ($sod_part as $value){
static $m=0;
if ($value != null){
$sod_sql = "INSERT INTO sod VALUES('".$sod_part[$m]."','".$sod_cu_part[$m];
$sod_sql.= "','".$sod_list_price[$m]."','".$sod_net_price[$m]."','".$sod_discount[$m]."','".$sod_ord_um[$m];
$sod_sql.= "','".$sod_req_date[$m]."','".$sod_req_qty[$m]."',now(),'".$sod_notes[$m]."') ";
$sod_res = mysql_query($sod_sql);
$m++;
}
else{
$m++;
continue;
}
}
}
?>