";
$result1114 = mysqli_query($conn,$sqlstr1114);
}
else
{
//$i++;
$sql5=mysqli_query($conn,"Select * from Container_Head where ContainerNo='$invno1' ");
$resultt=mysqli_fetch_array($sql5);
$importterms=$resultt['Import_terms'];
$sqlstr1 = "INSERT INTO IBWS_Payment_Main(Inv_No,Inv_Date,Internal,Factory,Paymnt_Due,Inv_plusminus,Parts_Value,Spares_Value,TTL_Amt,Cash_Duedate,Import_Terms) VALUES('$invno1','$idate','$internal','$fnickname','$newdate','$plusminus','$pval','$sparesval','$ttlamt','$newdate','$importterms')" ;
$result11 = mysqli_query($conn,$sqlstr1);
}
//////
//////////////////////////////////////////////////////////////////////////////////////////////////
$sqlstr133="Select * from Payment_IBWS_P_SCseq where Inv_No='$invno1' ";
//echo $sqlstr121;
$result133=mysqli_query($conn,$sqlstr133);
while($record3=mysqli_fetch_array($result133))
{
$Inv_No=$record3['Inv_No'];
$Total_value=$record3['sumvalsc'];
$Sc_No=$record3['Sc_No'];
$Seq_No=$record3['Seq_No'];
$Ship_No=$record3['Ship_No'];
//$lineno=$record3['LineNo'];
$sqlstr1334="Select * from IBWS_Payment_Main where Inv_No='$invno1' ";
//echo $sqlstr121;
$result1334=mysqli_query($conn,$sqlstr1334);
$record34=mysqli_fetch_array($result1334);
$lineno=$record34['Line'];
if(mysqli_num_rows(mysqli_query($conn,"SELECT * FROM IBWS_Inv_SCwise WHERE Inv_No= '$Inv_No' AND Sc_No='$Sc_No' AND Seq_No='$Seq_No' AND Ship_No='$Ship_No' ")))
{
//$i++;
/*
$sqlstr1114 = "UPDATE IBWS_Inv_SCwise SET
Total_value='$Total_value'
where Inv_No= '$Inv_No' AND Sc_No='$Sc_No' AND Seq_No='$Seq_No' AND Ship_No='$Ship_No' ";
//echo $sqlstr114;
//echo "
";
$result1114 = mysqli_query($conn,$sqlstr1114);
*/
}
else
{
//$i++;
$sqlstr1 = "INSERT INTO IBWS_Inv_SCwise(Inv_No,Total_value,Sc_No,Seq_No,Ship_No,lineibws) VALUES('$Inv_No','$Total_value','$Sc_No','$Seq_No','$Ship_No','$lineno')" ;
$result11 = mysqli_query($conn,$sqlstr1);
}
}
//////////////////////////////////////////////////////////////////////////////////////////////////
$sqlstr133="Select * from Payment_IBWS_SP_SCseq where Inv_No='$invno1' ";
//echo $sqlstr121;
$result133=mysqli_query($conn,$sqlstr133);
while($record3=mysqli_fetch_array($result133))
{
$Inv_No=$record3['Inv_No'];
$Total_value=$record3['spval'];
$Sc_No=$record3['Sc_No'];
$Seq_No=$record3['Seq_No'];
$Ship_No=$record3['Ship_No'];
//$lineno=$record3['LineNo'];
$sqlstr1334="Select * from IBWS_Payment_Main where Inv_No='$invno1' ";
//echo $sqlstr121;
$result1334=mysqli_query($conn,$sqlstr1334);
$record34=mysqli_fetch_array($result1334);
$lineno=$record34['Line'];
if(mysqli_num_rows(mysqli_query($conn,"SELECT * FROM IBWS_Inv_SCwisespttl WHERE Inv_No= '$Inv_No' AND Sc_No='$Sc_No' AND Seq_No='$Seq_No' AND Ship_No='$Ship_No' ")))
{
//$i++;
/*
$sqlstr1114 = "UPDATE IBWS_Inv_SCwisespttl SET
Total_value='$Total_value'
where Inv_No= '$invno1' AND Sc_No='$Sc_No' AND Seq_No='$Seq_No' AND Ship_No='$Ship_No'";
//echo $sqlstr114;
//echo "
";
$result1114 = mysqli_query($conn,$sqlstr1114);
*/
}
else
{
//$i++;
$sqlstr1 = "INSERT INTO IBWS_Inv_SCwisespttl(Inv_No,Total_value,Sc_No,Seq_No,Ship_No,lineibws) VALUES('$Inv_No','$Total_value','$Sc_No','$Seq_No','$Ship_No','$lineno')" ;
$result11 = mysqli_query($conn,$sqlstr1);
}
}
}
}
}
}
/////////////////////////////////Input Duedate Information
$sql2=mysqli_query($conn,"SELECT * FROM Ibws_Head_Inv WHERE Inv_No='$invno'");
$recs=mysqli_fetch_array($sql2);
$sql20=mysqli_query($conn,"SELECT * FROM IBWS_Payment_Main WHERE Inv_No='$invno'");
$recs20=mysqli_fetch_array($sql20);
$ttlamount=$recs20['TTL_Amt'];
$plusminusa=$recs20['Inv_plusminus'];
$ttlinv=$ttlamount+$plusminusa;
$sqlinsert=mysqli_query($conn,"INSERT INTO Ibws_payment_Duedates_Input(Cont_No,Fty,ETD,ETA,Amt,Title) Values('$invno','".$recs['Tittle']."','".$recs['Etd']."','".$recs['Eta']."','$ttlinv','".$recs['InvoiceTo']."')");
}////////
/////////////////////////////////
?>