header('Location: /FFXBD/NNew/Component_QC_Head_list.php?a=return');
?>
Untitled Document
//header('Content-Type: text/html; charset=utf-8');
include('dbcon.php');
$contno=$_POST['contno'];
$username=$_POST['username'];
$scno=$_POST['sc'];
$seq=$_POST['seq'];
$model=$_POST['model'];
$Adate=$_POST['Adate'];
$items1=$_POST['item1'];
$desc1=$_POST['desc1'];
$items2=$_POST['item2'];
$desc2=$_POST['desc2'];
$items3=$_POST['item3'];
$desc3=$_POST['desc3'];
$tdate=date('Y-m-d');
$desc="Contno:".$contno." Scno:".$scno." Seq:".$seq;
//set names utf8;
mysqli_query($conn,"set names utf8;");
////////audit
$sqlsave1=mysqli_query($conn,"Insert INTO Audit_Customapplications(Username,Tran_Date,Sc_No,Seq_No,App,Description)
Values('$username','$tdate','$scno','$seq','QCCOMP','".addslashes($desc)."')");
/////////////////////////////////
$sqlsave=mysqli_query($conn,"Insert INTO Component_QC_Head(Cont_No,Sc_No,Seq_No,Model,Arrival_Date,Tran_Date)
Values('$contno','$scno','$seq','".addslashes($model)."','$Adate','$tdate')");
$sqlsatr1=mysqli_query($conn,"select Max(Internal) as maxinternal FROM Component_QC_Head ");
$record2=mysqli_fetch_array($sqlsatr1);
$maxinternal=$record2['maxinternal'];
$sqlstr3=mysqli_query($conn,"select * FROM SC_Item WHERE Sc_No='".$scno."' AND Seq_No='".$seq."' ");
$record3=mysqli_fetch_array($sqlstr3);
$specno=$record3['Spec_No'];
$sqlstr=mysqli_query($conn,"select * FROM Ref_Componentqc WHERE Inv_No='".$contno."' AND Sc_No='".$scno."' AND Seq_No='".$seq."' order by Item");
while($record1=mysqli_fetch_array($sqlstr))
{
$subval1="";
$item1="";
$subval2="";
$item2="";
$subval3="";
$item3="";
$subval4="";
$item4="";
$subval5="";
$item5="";
$subval6="";
$item6="";
$orgdes="";
$s1="";
$s2="";
$s3="";
$s4="";
$s5="";
$s6="";
$sqlstr2=mysqli_query($conn,"select * FROM Sp_Kitem WHERE Internal='".$specno."' AND Group_Item='".$record1['Item']."' ");
$record2=mysqli_fetch_array($sqlstr2);
$description=$record2['Description'];
$subval1=$record2['Subval1'];
$item1=$record2['SubItem1'];
$subval2=$record2['Subval2'];
$item2=$record2['SubItem2'];
$subval3=$record2['Subval3'];
$item3=$record2['SubItem3'];
$subval4=$record2['SubItem4'];
$item4=$record2['Subval4'];
$subval5=$record2['Subitem5'];
$item5=$record2['Subval5'];
$subval6=$record2['SubItem6'];
$item6=$record2['Subval6'];
if($subval1 > '0')
{
$s1=$item1.":".$subval1;
}
if($subval2 > '0')
{
$s2=$item2.":".$subval2;
}
if($subval3 > '0')
{
$s3=$item3.":".$subval3;
}
if($subval4 > '0')
{
$s4=$item4.":".$subval4;
}
if($subval5 > '0')
{
$s5=$item5.":".$subval5;
}
if($subval6 > '0')
{
$s6=$item6.":".$subval6;
}
$orgdes=$description." ".$s1." ".$s2." ".$s3." ".$s4." ".$s5." ".$s6;
$sqlsave=mysqli_query($conn,"Insert INTO Component_QC_Item(Item_Name,Internal,Org_Description)
Values('".addslashes($record1['Item'])."','$maxinternal','".addslashes($orgdes)."')");
}
?>