'0')
{
$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)."')");
}
}
if($bulkinv > '0')
{
$username=$_POST['username'];
$bulkinv=$_POST['contno2'];
//$bulkactualarrival=$_POST['bulkactualdt'];
$sqlsatr5=mysqli_query($conn,"select * FROM CusDec where InvoiceNo='$bulkinv'");
$record5=mysqli_fetch_array($sqlsatr5);
$bulkactualarrival=$record5['ActualArival'];
$descbulk="Bulk-Inv-".$bulkinv."ActualArrival:".$bulkactualarrival;
$sqlsave1=mysqli_query($conn,"Insert INTO Audit_Customapplications(Username,Tran_Date,Sc_No,Seq_No,App,Description)
Values('$username','$tdate','$bulkinv','$seq','QCCOMP-Bulk','".addslashes($descbulk)."')");
////////////////////////////////////////////////////////////////////////////////
$sqlsave=mysqli_query($conn,"Insert INTO Component_QC_Head(Cont_No,Arrival_Date,Tran_Date)
Values('$bulkinv','$bulkactualarrival','$tdate')");
$sqlsatr1=mysqli_query($conn,"select Max(Internal) as maxinternal FROM Component_QC_Head ");
$record2=mysqli_fetch_array($sqlsatr1);
$maxinternal=$record2['maxinternal'];
$sqlsatr34=mysqli_query($conn,"Select * FROM PI_Imp_B_Head where Invoice_No='$bulkinv' ");
//echo "Select * FROM PO_Imp_B_Head where PO_No='$bulkinv' ";
$record34=mysqli_fetch_array($sqlsatr34);
$bulkinternal=$record34['Internal'];
//echo $bulkinternal;
$sqlbulk=mysqli_query($conn,"Select * FROM PI_Imp_B_Item WHERE Internal='".$bulkinternal."' ");
//echo "select * FROM PO_Imp_B_Item WHERE Internal='".$bulkinternal."' ";
while($recordsbulk=mysqli_fetch_array($sqlbulk))
{
$itemcode=$recordsbulk['Item_Code'];
$description=$recordsbulk['Description'];
$sqlsave=mysqli_query($conn,"Insert INTO Component_QC_Item(Item_Name,Internal,Org_Description)
Values('".addslashes($itemcode)."','$maxinternal','".addslashes($description)."')");
}
/////////////////////////////////////////////////////////////////////////////////
}
if($fixedinv > '0')
{
$username=$_POST['username'];
$bulkinv=$_POST['contno3'];
//echo $bulkinv;
//$bulkactualarrival=$_POST['fixedactual'];
$sqlsatr5=mysqli_query($conn,"select * FROM CusDec where InvoiceNo='$bulkinv'");
$record5=mysqli_fetch_array($sqlsatr5);
$bulkactualarrival=$record5['ActualArival'];
$descbulk="Bulk-Inv-".$bulkinv."ActualArrival:".$bulkactualarrival;
$sqlsave1=mysqli_query($conn,"Insert INTO Audit_Customapplications(Username,Tran_Date,Sc_No,Seq_No,App,Description)
Values('$username','$tdate','$bulkinv','$seq','QCCOMP-Fixed','".addslashes($descbulk)."')");
////////////////////////////////////////////////////////////////////////////////
$sqlsave=mysqli_query($conn,"Insert INTO Component_QC_Head(Cont_No,Arrival_Date,Tran_Date)
Values('$bulkinv','$bulkactualarrival','$tdate')");
$sqlsatr1=mysqli_query($conn,"select Max(Internal) as maxinternal FROM Component_QC_Head ");
$record2=mysqli_fetch_array($sqlsatr1);
$maxinternal=$record2['maxinternal'];
//echo $maxinternal;
$sqlsatr33=mysqli_query($conn,"select * FROM PI_Imp_F_Head where Invoice_No='$bulkinv' ");
//echo "select * FROM PI_Imp_F_Head where Invoice_No='$bulkinv' ";
$record33=mysqli_fetch_array($sqlsatr33);
$bulkinternal=$record33['Internal'];
//echo $bulkinternal;
/*
$sqlbulk5=mysqli_query($conn,"select * FROM PI_Imp_F_Item WHERE Internal='".$bulkinternal."' ");
echo "select * FROM PI_Imp_F_Item WHERE Internal='".$bulkinternal."' ";
while($recordsbulk5=mysqli_fetch_array($sqlbulk5))
{
$itemcode=$recordsbulk5['Item_Code'];
$description=$recordsbulk5['Description'];
$sqlsave=mysqli_query($conn,"Insert INTO Component_QC_Item(Item_Code,Internal,Org_Description)
Values('".addslashes($itemcode)."','$maxinternal','".addslashes($description)."')");
echo "Insert INTO Component_QC_Item(Item_Code,Internal,Org_Description)
Values('".addslashes($itemcode)."','$maxinternal','".addslashes($description)."')";
}
*/
//////////////////////
$sqlbulk60=mysqli_query($conn,"Select * FROM PI_Imp_F_Item WHERE Internal='".$bulkinternal."' ");
//echo "select * FROM PO_Imp_B_Item WHERE Internal='".$bulkinternal."' ";
while($recordsbulk60=mysqli_fetch_array($sqlbulk60))
{
$itemcode=$recordsbulk60['Item_Code'];
$description=$recordsbulk60['Description'];
$sqlsave5=mysqli_query($conn,"Insert INTO Component_QC_Item(Item_Name,Internal,Org_Description)
Values('".addslashes($itemcode)."','$maxinternal','".addslashes($description)."')");
}
////////////////////////////////////
}
?>