".print_r($_POST, true)."";
if($save_btn!=""){
if($edit_id!=''){
$query="update `erp_bom` set `name`='$label' ,`prod_id`='$bom_prod_id' ,`create_date`='$create_date' where `id`='$edit_id'";
query($query);
}else{
$query="insert into `erp_bom` set `name`='$label' ,`prod_id`='$bom_prod_id' ,`create_date`='$create_date' ";
list(,$edit_id)=query($query);
}
}
if($save_item!=''){
if($edit_id!=''){
//echo "".print_r($_POST, true)."
";
if($item_id==''){
$query="select max(`item_no`) as max_item_no from `erp_bom_detail` where `bom_id`='$edit_id' ";
list($record,$data)=query($query);
$new_item_no=$data[0]['max_item_no']+1;
$query="insert into `erp_bom_detail` set `bom_id`='$edit_id' ,`qty`='$qty' ,`remark`='$item_remark', `item_id`='$bom_item_id', `item_no`='$new_item_no' , `unit`='$item_unit' ";
query($query);
}else{
$query="update `erp_bom_detail` set
`bom_id`='$edit_id' ,
`qty`='$qty' ,
`remark`='$item_remark',
`item_id`='$bom_item_id',
`unit`='$item_unit'
where id='$item_id'
";
query($query);
}
$edit_item="";
$item_id="";
$qty="";
$item_remark="";
$bom_item_id="";
$new_item_no="";
$item_unit="";
}else{
$return_java="no edit id";
}
}
if($del_item!=''){
$query="select `item_no` from `erp_bom_detail` where id='$item_id' ";
list($record,$data)=query($query);
if($record>0){
$query="update `erp_bom_detail` set `item_no`=`item_no`-1 where `bom_id`='$edit_id' and `item_no`>".$data[0]['item_no']."";
query($query);
$query="delete from `erp_bom_detail` where `id`='$item_id' ";
query($query);
$edit_item="";
$item_id="";
$qty="";
$item_remark="";
$bom_item_id="";
$new_item_no="";
$item_unit="";
}
}
if($edit_id!=$old_edit_id){
$query="select * from `erp_bom` where `id`='$edit_id' ";
list($record,$data)=query($query);
if($record>0){
$bom_prod_id=$data[0]['prod_id'];
$label=$data[0]['name'];
$create_date=$data[0]['create_date'];
}
}
?>